[09/02/2020 10:01:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00109',assignment_type='internal',entity_value='4',entity_type='driver',vehicle_no='1',vehicle='2',type='private_per_km',allowance='100',substitute_price='',petty_cash='',pickupSlot='2019-04-30 00:00:00',dropOffSlot='2019-04-30 01:00:00',remark='',duration='1 hours 0 mintues',create_date='2020-09-02 10:01:05',created_by='tfg';
[09/02/2020 10:01:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='108',booking_id='692',pax='3',start_assignment_time='2019-04-30 00:00:00',end_assignment_time='2019-04-30 01:00:00',pickup='Lake Drive, Sri Lanka Sri Lanka',dropoff=' lakeside  Sri Lanka',service_name='Road Transfer',created_date='2020-09-02 10:01:05';
[09/02/2020 10:01:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (692);
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info SET supplier_price='0',original_supplier_price='100.000',acc_export='0' WHERE acc_type='purchase' AND booking_id IN (692) and type != 'Assignment';
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='USD',supplier_price='100.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='1.00000',substitute_price='0.000',booking_id='692',booking_log='',type='Assignment',create_date='2020-09-02 10:01:05',account_invoice='L00109',particulars='Logistics Assignment';
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET old_supplier = supplier_id, supplier_id = 'S000000072' where booking_id = '692' ;
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-02 10:01:06',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00109\&#039;,assignment_type=\&#039;internal\&#039;,entity_value=\&#039;4\&#039;,entity_type=\&#039;driver\&#039;,vehicle_no=1,vehicle=\&#039;2\&#039;,type=\&#039;private_per_km\&#039;,allowance=100,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2019-04-30 00:00:00\&#039;,dropOffSlot=\&#039;2019-04-30 01:00:00\&#039;,remark=\&#039;\&#039;,duration=\&#039;1 hours 0 mintues\&#039;,create_date=\&#039;2020-09-02 10:01:05\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;108\&#039;,booking_id=\&#039;692\&#039;,pax=\&#039;3\&#039;,start_assignment_time=\&#039;2019-04-30 00:00:00\&#039;,end_assignment_time=\&#039;2019-04-30 01:00:00\&#039;,pickup=\&#039;Lake Drive, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039; lakeside  Sri Lanka\&#039;,service_name=\&#039;Road Transfer\&#039;,created_date=\&#039;2020-09-02 10:01:05\&#039;',`log_description`= ' driver Allowance:-  USD petty Cash:-  USD',`ip`= '43.250.210.87';
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3642', `entity`='BookingId', `value`='692' ;
[09/02/2020 10:01:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3642', `entity`='Assignment', `value`='L00109' ;
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00110',assignment_type='external',entity_value='S000000072',entity_type='supplier',vehicle_no='1',vehicle='0',type='private_per_km',allowance='50',substitute_price='',petty_cash='',pickupSlot='2019-04-30 00:00:00',dropOffSlot='2019-04-30 01:00:00',remark='',duration='1 hours 0 mintues',create_date='2020-09-02 10:04:13',created_by='tfg';
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='109',booking_id='692',pax='3',start_assignment_time='2019-04-30 00:00:00',end_assignment_time='2019-04-30 01:00:00',pickup='Lake Drive, Sri Lanka Sri Lanka',dropoff=' lakeside  Sri Lanka',service_name='Road Transfer',created_date='2020-09-02 10:04:13';
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (692);
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '692' ;
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='USD',supplier_price='50.0000000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='1.00000',substitute_price='0.000',booking_id='692',booking_log='',type='Assignment',create_date='2020-09-02 10:04:13',account_invoice='L00110',particulars='Logistics Assignment';
[09/02/2020 10:04:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '692' ;
[09/02/2020 10:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-02 10:04:14',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00110\&#039;,assignment_type=\&#039;external\&#039;,entity_value=\&#039;S000000072\&#039;,entity_type=\&#039;supplier\&#039;,vehicle_no=1,vehicle=\&#039;0\&#039;,type=\&#039;private_per_km\&#039;,allowance=50,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2019-04-30 00:00:00\&#039;,dropOffSlot=\&#039;2019-04-30 01:00:00\&#039;,remark=,duration=\&#039;1 hours 0 mintues\&#039;,create_date=\&#039;2020-09-02 10:04:13\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;109\&#039;,booking_id=\&#039;692\&#039;,pax=\&#039;3\&#039;,start_assignment_time=\&#039;2019-04-30 00:00:00\&#039;,end_assignment_time=\&#039;2019-04-30 01:00:00\&#039;,pickup=\&#039;Lake Drive, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039; lakeside  Sri Lanka\&#039;,service_name=\&#039;Road Transfer\&#039;,created_date=\&#039;2020-09-02 10:04:13\&#039;',`log_description`= ' supplier Allowance:- 50 USD petty Cash:-  USD',`ip`= '43.250.210.87';
[09/02/2020 10:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3643', `entity`='BookingId', `value`='692' ;
[09/02/2020 10:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3643', `entity`='Assignment', `value`='L00110' ;
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00111',assignment_type='external',entity_value='S000000202',entity_type='supplier',vehicle_no='2',vehicle='1',type='private_per_km',allowance='40',substitute_price='',petty_cash='',pickupSlot='2019-04-30 00:00:00',dropOffSlot='2019-04-30 01:00:00',remark='',duration='1 hours 0 mintues',create_date='2020-09-02 10:04:16',created_by='tfg';
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='110',booking_id='692',pax='3',start_assignment_time='2019-04-30 00:00:00',end_assignment_time='2019-04-30 01:00:00',pickup='Lake Drive, Sri Lanka Sri Lanka',dropoff=' lakeside  Sri Lanka',service_name='Road Transfer',created_date='2020-09-02 10:04:16';
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (692);
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '692' ;
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '692' ;
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='USD',supplier_price='40.0000000',supplier_type='offlline',supplier_id='S000000202',acc_type='purchase',accounting_multiplier='1.00000',substitute_price='0.000',booking_id='692',booking_log='',type='Assignment',create_date='2020-09-02 10:04:16',account_invoice='L00111',particulars='Logistics Assignment';
[09/02/2020 10:04:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000202' where booking_id = '692' ;
[09/02/2020 10:04:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-02 10:04:17',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00111\&#039;,assignment_type=\&#039;external\&#039;,entity_value=\&#039;S000000202\&#039;,entity_type=\&#039;supplier\&#039;,vehicle_no=2,vehicle=\&#039;1\&#039;,type=\&#039;private_per_km\&#039;,allowance=40,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2019-04-30 00:00:00\&#039;,dropOffSlot=\&#039;2019-04-30 01:00:00\&#039;,remark=,duration=\&#039;1 hours 0 mintues\&#039;,create_date=\&#039;2020-09-02 10:04:16\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;110\&#039;,booking_id=\&#039;692\&#039;,pax=\&#039;3\&#039;,start_assignment_time=\&#039;2019-04-30 00:00:00\&#039;,end_assignment_time=\&#039;2019-04-30 01:00:00\&#039;,pickup=\&#039;Lake Drive, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039; lakeside  Sri Lanka\&#039;,service_name=\&#039;Road Transfer\&#039;,created_date=\&#039;2020-09-02 10:04:16\&#039;',`log_description`= ' supplier Allowance:- 40 USD petty Cash:-  USD',`ip`= '43.250.210.87';
[09/02/2020 10:04:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3644', `entity`='BookingId', `value`='692' ;
[09/02/2020 10:04:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3644', `entity`='Assignment', `value`='L00111' ;
