[07/29/2020 11:01:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],delete from `psa_users`  where id = 'SnehalUAT';
[07/29/2020 11:01:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:01:33',`log_type`= 'User',`sql_query`= 'delete from `psa_users`  where id = :user_id',`log_description`= 'User SnehalUAT has been deleted.',`ip`= '60.254.44.39';

[07/29/2020 11:03:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/manage_documents.php],INSERT INTO business_documents SET document_type = 'Ncvbn',entity_type = 'logistic_driver',display_filename = 'IMG_1214.png',disk_filename  = '213a44bd7b7f46b9a996e13eb819bdf2413e059482eda68541697e61a2cb530f.png',create_date_time  = '2020/07/29',mime_type  = 'image/png',backoffice_user  = 'tfg';
[07/29/2020 11:07:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'Snehal' ,  last_name = 'Valanju' ,  curr_add = 'Mumbai' ,  gender = 'female' ,  contact_number = '12345678' ,  email = '' ,  status = 'A' ,  licence_valid_from = '2020-07-28' ,  licence_valid_to = '2025-12-31' ,  license_no = '123456789' , supplier = 'S000000072' , experience = '1' , type = 'driver' WHERE ID='5';
[07/29/2020 11:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'Snehal' ,  last_name = 'Valanju' ,  curr_add = 'Mumbai' ,  gender = 'female' ,  contact_number = '12345678' ,  email = '' , language_spoken = '61,62,63,64,65' ,  status = 'A' ,  licence_valid_from = '2020-07-01' ,  licence_valid_to = '2025-12-31' ,  license_no = '123456789' , supplier = 'S000000072' , experience = '1' , type = 'driver' WHERE ID='5';

[07/29/2020 11:08:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'Snehal' ,  last_name = 'Valanju' ,  curr_add = 'Mumbai' ,  gender = 'female' ,  contact_number = '12345678' ,  email = '' , language_spoken = '61,62,63,64,65' ,  status = 'I' ,  licence_valid_from = '2020-07-01' ,  licence_valid_to = '2025-12-31' ,  license_no = '123456789' , supplier = 'S000000072' , experience = '1' , type = 'driver' WHERE ID='5';
[07/29/2020 11:09:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-31 05:30:00',to_date='2020-07-31 05:30:00',status='leave';
[07/29/2020 11:09:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'Snehal' ,  last_name = 'Valanju' ,  curr_add = 'Mumbai' ,  gender = 'female' ,  contact_number = '12345678' ,  email = '' , language_spoken = '61,62,63,64,65' ,  status = 'A' ,  licence_valid_from = '2020-07-01' ,  licence_valid_to = '2025-12-31' ,  license_no = '123456789' , supplier = 'S000000072' , experience = '1' , type = 'driver' WHERE ID='5';
[07/29/2020 11:10:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-29 05:30:00',to_date='2020-07-29 05:30:00',status='leave';
[07/29/2020 11:10:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php], DELETE FROM logistics_driver_vehicle_status WHERE id='5';
[07/29/2020 11:10:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:10:20',`log_type`= 'Logistics Driver/Vehicle Status',`sql_query`= ' DELETE FROM logistics_driver_vehicle_status WHERE id=\&#039;5\&#039;',`log_description`= 'Deleted leave Status From 2020-07-29 05:30:00 - 2020-07-29 05:30:00 For Driver Snehal Valanju',`ip`= '60.254.44.39';
[07/29/2020 11:10:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-31 05:30:00',to_date='2020-07-31 05:30:00',status='leave';
[07/29/2020 11:13:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php], DELETE FROM logistics_driver_vehicle_status WHERE id='4';
[07/29/2020 11:13:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:13:28',`log_type`= 'Logistics Driver/Vehicle Status',`sql_query`= ' DELETE FROM logistics_driver_vehicle_status WHERE id=\&#039;4\&#039;',`log_description`= 'Deleted leave Status From 2020-07-31 05:30:00 - 2020-07-31 05:30:00 For Driver Snehal Valanju',`ip`= '60.254.44.39';
[07/29/2020 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php], DELETE FROM logistics_driver_vehicle_status WHERE id='6';
[07/29/2020 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:13:50',`log_type`= 'Logistics Driver/Vehicle Status',`sql_query`= ' DELETE FROM logistics_driver_vehicle_status WHERE id=\&#039;6\&#039;',`log_description`= 'Deleted leave Status From 2020-07-31 05:30:00 - 2020-07-31 05:30:00 For Driver Snehal Valanju',`ip`= '60.254.44.39';
[07/29/2020 11:14:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-29 05:30:00',to_date='2020-07-29 05:30:00',status='leave';
[07/29/2020 11:16:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-31 16:46:00',to_date='2020-07-31 16:46:00',status='leave';
[07/29/2020 11:17:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET status = 'D' WHERE id='2';
[07/29/2020 11:28:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-29 05:30:00',to_date='2020-07-30 05:30:00',status='leave';
[07/29/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO vehicle SET  company_name = 'Tata Motors' , status = 'A' , vehicle_model = '2018' , vehicle_type = '2' , vehicle_registration_number = 'MH0292' , body_type = 'Metal' , colour = 'Black' , fuel_type = 'diesel' , door = '1' , driver_id = '5' , insurance_validity_from = '2020-07-01' , insurance_validity_to = '2023-12-31' , road_transfer_inspection_from = '2020-07-29' , road_transfer_inspection_to = '2023-12-31';
[07/29/2020 11:32:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-07-31 05:30:00',to_date='2020-07-31 05:30:00',status='block';
[07/29/2020 11:33:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',from_date='2020-08-01 05:30:00',to_date='2020-08-01 05:30:00',status='leave';
[07/29/2020 11:34:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE vehicle SET  company_name = 'Tata Motors',status = 'A',vehicle_model = '2018',vehicle_type = '2',vehicle_registration_number = 'MH0292',year_of_mfg = '2015-06-30',body_type = 'Metal',colour = 'Black',fuel_type = 'diesel',door = '1',insurance_validity_from = '2020-07-01',insurance_validity_to = '2023-12-31',road_transfer_inspection_from = '2020-07-29',road_transfer_inspection_to = '2023-12-31' WHERE id='4';
[07/29/2020 11:36:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE vehicle SET  company_name = 'Tata Motors',status = 'A',vehicle_model = '2018',vehicle_type = '2',vehicle_registration_number = 'MH0292',year_of_mfg = '2015-06-30',body_type = 'Metal',colour = 'Black',fuel_type = 'diesel',door = '1',driver_id = '5',insurance_validity_from = '2020-07-01',insurance_validity_to = '2023-12-31',road_transfer_inspection_from = '2020-07-29',road_transfer_inspection_to = '2023-12-31' WHERE id='4';
[07/29/2020 11:40:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE vehicle SET  company_name = 'Tata Motors',status = 'A',vehicle_model = '2018',vehicle_type = '2',vehicle_registration_number = 'MH0292',year_of_mfg = '2015-06-30',body_type = 'Metal',colour = 'Black',fuel_type = 'diesel',door = '1',insurance_validity_from = '2020-07-01',insurance_validity_to = '2023-12-31',road_transfer_inspection_from = '2020-07-29',road_transfer_inspection_to = '2023-12-31' WHERE id='4';
[07/29/2020 11:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET vehicle_id='4',from_date='2020-07-31 05:30:00',to_date='2020-07-31 05:30:00',status='under_maintenance';
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00107',assignment_type='internal',entity_value='5',entity_type='driver',vehicle_no='1',vehicle='4',type='private',allowance='100',substitute_price='',petty_cash='',pickupSlot='2018-12-26 00:00:00',dropOffSlot='2018-12-26 04:00:00',remark='',duration='4 hours 0 mintues',create_date='2020-07-29 11:44:53',created_by='tfg';
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='106',booking_id='407',pax='1',start_assignment_time='2018-12-26 00:00:00',end_assignment_time='2018-12-26 04:00:00',pickup='H&ocirc;tel Restaurant Mercure Abbeville H&ocirc;tel de Franc',dropoff='Mumbai',service_name='Mumbai Darshan',created_date='2020-07-29 11:44:53';
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (407);
[07/29/2020 11:44:53], [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 (407) and type != 'Assignment';
[07/29/2020 11:44:53], [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='EUR',supplier_price='100.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='1.18029',substitute_price='0.000',booking_id='407',booking_log='',type='Assignment',create_date='2020-07-29 11:44:53',account_invoice='L00107',particulars='Logistics Assignment';
[07/29/2020 11:44:53], [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 = '407' ;
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:44:53',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00107\&#039;,assignment_type=\&#039;internal\&#039;,entity_value=\&#039;5\&#039;,entity_type=\&#039;driver\&#039;,vehicle_no=1,vehicle=\&#039;4\&#039;,type=\&#039;private\&#039;,allowance=100,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2018-12-26 00:00:00\&#039;,dropOffSlot=\&#039;2018-12-26 04:00:00\&#039;,remark=\&#039;\&#039;,duration=\&#039;4 hours 0 mintues\&#039;,create_date=\&#039;2020-07-29 11:44:53\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;106\&#039;,booking_id=\&#039;407\&#039;,pax=\&#039;1\&#039;,start_assignment_time=\&#039;2018-12-26 00:00:00\&#039;,end_assignment_time=\&#039;2018-12-26 04:00:00\&#039;,pickup=\&#039;H&ocirc;tel Restaurant Mercure Abbeville H&ocirc;tel de Franc\&#039;,dropoff=\&#039;Mumbai\&#039;,service_name=\&#039;Mumbai Darshan\&#039;,created_date=\&#039;2020-07-29 11:44:53\&#039;',`log_description`= ' driver Allowance:-  EUR petty Cash:-  EUR',`ip`= '60.254.44.39';
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='BookingId', `value`='407' ;
[07/29/2020 11:44:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Assignment', `value`='L00107' ;
[07/29/2020 11:45:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'RON' ,  last_name = 'V' ,  curr_add = 'Mumbai Vasai' ,  gender = 'male' ,  contact_number = '9898989898' ,  email = 'rohan.vartak@qtechsoftware.com' ,  nationality = '106' , language_spoken = '62,63,64' ,  status = 'A' ,  licence_valid_from = '2018-01-08' ,  licence_valid_to = '2048-12-30' ,  license_no = 'INDL007' , remarks = 'Best Driver' , supplier = 'S000000072' , experience = '2' , type = 'guide' WHERE ID='4';
[07/29/2020 11:46:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICd2ZWhpY2xlX2lkJyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMjktMDctMjAyMCAxMTo0NjozMQogUXVlcnk6U0VMRUNUIHZlaGljbGVfaWQsdmVoaWNsZV9kZXNjIEZST00gYm9va2luZ3NfcGFja2FnZXMgYiBMRUZUIEpPSU4gdmVoaWNsZV90eXBlIHYgT04gYi52ZWhpY2xlX2lkPXYuaWQgV0hFUkUgYm9va2luZ19pZD0nMCcgQU5EIHNlcnZpY2VfaWQ9JzQnIEFORCBzdXBwbGllcl9pZD0nUzAwMDAwMDA2NicKCi90bXMvbG9naXN0aWNzLnBocD9tb2R1bGU9YXNzaWdubWVudFNoZWV0JmFjdGlvbj12aWV3QXNzaWduVmVoaWNsZUd1aWRlJnR5cGU9dW5kZWZpbmVkJmJvb2tpbmdfaWQ9NDM3JnNlcnZpY2VOYW1lPVJvYWQlMjBUcmFuc2ZlciZhc3NpZ25tZW50X251bWJlcj0KCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDYzLAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvbG9naXN0aWNzL0xvZ2lzdGljcy5waHAnLAogICAgJ2xpbmUnID0+IDE1MTUsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRSb3cnLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL2xvZ2lzdGljcy9Mb2dpc3RpY3MucGhwJywKICAgICdsaW5lJyA9PiAyNCwKICAgICdmdW5jdGlvbicgPT4gJ3ZpZXdBc3NpZ25WZWhpY2xlR3VpZGUnLAogICAgJ2NsYXNzJyA9PiAnTG9naXN0aWNzJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvbG9naXN0aWNzLnBocCcsCiAgICAnbGluZScgPT4gOSwKICAgICdmdW5jdGlvbicgPT4gJ3NldEFjdGlvbicsCiAgICAnY2xhc3MnID0+ICdMb2dpc3RpY3MnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL3Rtcy9sb2dpc3RpY3MucGhwP21vZHVsZT1hc3NpZ25tZW50U2hlZXQmYWN0aW9uPXZpZXdBc3NpZ25WZWhpY2xlR3VpZGUmdHlwZT11bmRlZmluZWQmYm9va2luZ19pZD00Mzcmc2VydmljZU5hbWU9Um9hZCUyMFRyYW5zZmVyJmFzc2lnbm1lbnRfbnVtYmVyPQp1YXQudGZnLm90cmFtcy5uZXQsIENsaWVudCBJUDogNjAuMjU0LjQ0LjM5PC9wcmU+PGJyPgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDYzLAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvbG9naXN0aWNzL0xvZ2lzdGljcy5waHAnLAogICAgJ2xpbmUnID0+IDE1MTUsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRSb3cnLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL2xvZ2lzdGljcy9Mb2dpc3RpY3MucGhwJywKICAgICdsaW5lJyA9PiAyNCwKICAgICdmdW5jdGlvbicgPT4gJ3ZpZXdBc3NpZ25WZWhpY2xlR3VpZGUnLAogICAgJ2NsYXNzJyA9PiAnTG9naXN0aWNzJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvbG9naXN0aWNzLnBocCcsCiAgICAnbGluZScgPT4gOSwKICAgICdmdW5jdGlvbicgPT4gJ3NldEFjdGlvbicsCiAgICAnY2xhc3MnID0+ICdMb2dpc3RpY3MnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/logistics.php?module=assignmentSheet&action=viewAssignVehicleGuide&type=undefined&booking_id=437&serviceName=Road%20Transfer&assignment_number=',create_date= '2020-07-29 11:46:32';
[07/29/2020 11:47:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'RON' ,  last_name = 'V' ,  curr_add = 'Mumbai Vasai' ,  gender = 'male' ,  contact_number = '9898989898' ,  email = 'rohan.vartak@qtechsoftware.com' ,  nationality = '106' , language_spoken = '62,63,64' ,  status = 'A' ,  licence_valid_from = '2018-01-08' ,  licence_valid_to = '2048-12-30' ,  license_no = 'INDL007' , remarks = 'Best Driver' , supplier = 'S000000072' , experience = '2' , type = 'guide' WHERE ID='4';
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update logistics_assignment set assignment_type='external', entity_value='S000000202', entity_type='supplier', vehicle_no='1', vehicle='0', type='private', allowance='200', substitute_price='', petty_cash='', pickupSlot='2018-12-26 00:00:00', dropOffSlot='2018-12-26 04:00:00', remark='', duration='4 hours 0 mintues', modified_date='2020-07-29 11:48:38', modified_by='tfg' where assignment_no='L00107';
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (407);
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info set  supplier_price = '200' ,substitute_price = '' ,supplier_type  ='offline' ,supplier_id  ='S000000202' ,supplier_currency  ='EUR' ,account_invoice  ='L00107', acc_export='0', accounting_multiplier='1.18029' where bid='1293' AND account_invoice='L00107';
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000202' where booking_id = '407' ;
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:48:38',`log_type`= 'Assignment',`sql_query`= '----',`log_description`= ' supplier Allowance:- 200 EUR petty Cash:-  EUR',`ip`= '60.254.44.39';
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3385', `entity`='BookingId', `value`='407' ;
[07/29/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3385', `entity`='Assignment', `value`='L00107' ;
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00108',assignment_type='external',entity_value='S000000072',entity_type='supplier',vehicle_no='1',vehicle='0',type='private',allowance='100',substitute_price='',petty_cash='',pickupSlot='2018-12-26 00:00:00',dropOffSlot='2018-12-26 04:00:00',remark='',duration='4 hours 0 mintues',create_date='2020-07-29 11:49:18',created_by='tfg';
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='107',booking_id='407',pax='1',start_assignment_time='2018-12-26 00:00:00',end_assignment_time='2018-12-26 04:00:00',pickup='H&ocirc;tel Restaurant Mercure Abbeville H&ocirc;tel de Franc',dropoff='Mumbai',service_name='Mumbai Darshan',created_date='2020-07-29 11:49:18';
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (407);
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000202' where booking_id = '407' ;
[07/29/2020 11:49:18], [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='EUR',supplier_price='100.0000000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='1.18029',substitute_price='0.000',booking_id='407',booking_log='',type='Assignment',create_date='2020-07-29 11:49:18',account_invoice='L00108',particulars='Logistics Assignment';
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '407' ;
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:49:18',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00108\&#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\&#039;,allowance=100,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2018-12-26 00:00:00\&#039;,dropOffSlot=\&#039;2018-12-26 04:00:00\&#039;,remark=,duration=\&#039;4 hours 0 mintues\&#039;,create_date=\&#039;2020-07-29 11:49:18\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;107\&#039;,booking_id=\&#039;407\&#039;,pax=\&#039;1\&#039;,start_assignment_time=\&#039;2018-12-26 00:00:00\&#039;,end_assignment_time=\&#039;2018-12-26 04:00:00\&#039;,pickup=\&#039;H&ocirc;tel Restaurant Mercure Abbeville H&ocirc;tel de Franc\&#039;,dropoff=\&#039;Mumbai\&#039;,service_name=\&#039;Mumbai Darshan\&#039;,created_date=\&#039;2020-07-29 11:49:18\&#039;',`log_description`= ' supplier Allowance:- 100 EUR petty Cash:-  EUR',`ip`= '60.254.44.39';
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3386', `entity`='BookingId', `value`='407' ;
[07/29/2020 11:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3386', `entity`='Assignment', `value`='L00108' ;
[07/29/2020 11:56:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO history_logistics_bookings SELECT * FROM logistics_bookings WHERE 1  AND la_id IN (106) and booking_id in (407);
[07/29/2020 11:56:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],DELETE From logistics_bookings WHERE 1  AND la_id IN (106) and booking_id in (407);
[07/29/2020 11:56:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 11:56:42',`log_type`= 'Assignment',`sql_query`= 'DELETE From logistics_bookings WHERE 1  AND la_id IN (106) and booking_id in (407)',`log_description`= 'Assignment of Booking Id -407 is Released (guide)',`ip`= '60.254.44.39';
[07/29/2020 11:56:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3387', `entity`='BookingId', `value`='407' ;
[07/29/2020 11:56:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3387', `entity`='Assignment', `value`='L00107' ;
[07/29/2020 11:56:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (1705,1706,1707,1708,1709,407);
[07/29/2020 11:56:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET  supplier_id = 'S000000072' where booking_id = '407' ;
[07/29/2020 11:56:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],DELETE FROM logistics_assignment WHERE id NOT IN (SELECT la_id FROM logistics_bookings);
