[07/29/2020 12:05:06], [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= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICd2ZWhpY2xlX2lkJyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMjktMDctMjAyMCAxMjowNTowNgogUXVlcnk6U0VMRUNUIHZlaGljbGVfaWQsdmVoaWNsZV9kZXNjIEZST00gYm9va2luZ3NfcGFja2FnZXMgYiBMRUZUIEpPSU4gdmVoaWNsZV90eXBlIHYgT04gYi52ZWhpY2xlX2lkPXYuaWQgV0hFUkUgYm9va2luZ19pZD0nMCcgQU5EIHNlcnZpY2VfaWQ9JzIwNCcgQU5EIHN1cHBsaWVyX2lkPSdTMDAwMDAwMDAzJwoKL3Rtcy9sb2dpc3RpY3MucGhwP21vZHVsZT1hc3NpZ25tZW50U2hlZXQmYWN0aW9uPXZpZXdBc3NpZ25WZWhpY2xlR3VpZGUmdHlwZT11bmRlZmluZWQmYm9va2luZ19pZD00Mzgmc2VydmljZU5hbWU9TGVpc3VyZSUyMERheSZhc3NpZ25tZW50X251bWJlcj1MMDAwNzQKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDYzLAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvbG9naXN0aWNzL0xvZ2lzdGljcy5waHAnLAogICAgJ2xpbmUnID0+IDE1MTUsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRSb3cnLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL2xvZ2lzdGljcy9Mb2dpc3RpY3MucGhwJywKICAgICdsaW5lJyA9PiAyNCwKICAgICdmdW5jdGlvbicgPT4gJ3ZpZXdBc3NpZ25WZWhpY2xlR3VpZGUnLAogICAgJ2NsYXNzJyA9PiAnTG9naXN0aWNzJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvbG9naXN0aWNzLnBocCcsCiAgICAnbGluZScgPT4gOSwKICAgICdmdW5jdGlvbicgPT4gJ3NldEFjdGlvbicsCiAgICAnY2xhc3MnID0+ICdMb2dpc3RpY3MnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL3Rtcy9sb2dpc3RpY3MucGhwP21vZHVsZT1hc3NpZ25tZW50U2hlZXQmYWN0aW9uPXZpZXdBc3NpZ25WZWhpY2xlR3VpZGUmdHlwZT11bmRlZmluZWQmYm9va2luZ19pZD00Mzgmc2VydmljZU5hbWU9TGVpc3VyZSUyMERheSZhc3NpZ25tZW50X251bWJlcj1MMDAwNzQKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40NC4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiA2MywKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL2xvZ2lzdGljcy9Mb2dpc3RpY3MucGhwJywKICAgICdsaW5lJyA9PiAxNTE1LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Um93JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9sb2dpc3RpY3MvTG9naXN0aWNzLnBocCcsCiAgICAnbGluZScgPT4gMjQsCiAgICAnZnVuY3Rpb24nID0+ICd2aWV3QXNzaWduVmVoaWNsZUd1aWRlJywKICAgICdjbGFzcycgPT4gJ0xvZ2lzdGljcycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2xvZ2lzdGljcy5waHAnLAogICAgJ2xpbmUnID0+IDksCiAgICAnZnVuY3Rpb24nID0+ICdzZXRBY3Rpb24nLAogICAgJ2NsYXNzJyA9PiAnTG9naXN0aWNzJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/logistics.php?module=assignmentSheet&action=viewAssignVehicleGuide&type=undefined&booking_id=438&serviceName=Leisure%20Day&assignment_number=L00074',create_date= '2020-07-29 12:05:06';
[07/29/2020 12:18:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET driver_id='5',vehicle_id='4',from_date='2018-12-25 05:30:00',to_date='2018-12-26 05:30:00',status='leave';
[07/29/2020 12:19:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-29 12:19:32',login_attempt=0 where id = '21';
[07/29/2020 12:19:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2020-07-29 12:19:32', ip = '45.120.147.56', action = 'Login' ;
[07/29/2020 12:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Insert into logistic_vehicle_maintenance Set
			vehicle='4',
			po_no='123',
			po_date='2020-07-31',
			mileage='100',
			description='Test',
			unit='',
			gen_service_total='100',
			repair_parts_total='',
			supplier='Ankita',
			invoice_no='123',
			invoice_date='',
			mnt_value='100',
			remark='';
[07/29/2020 12:31:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Insert into logistics_daily_vehicle_movement Set
		movemnt_date='2020-07-31',
		assign_no='L00108',
		driver='5',
		assign_detail='',
		est_km='100',
		gps_km='',
		km='150',
		expected_out_time='18:01:12',
		out_time='20:01:14',
		expected_in_time='20:01:28',
		vehicle='4',
		in_time='17:01:18';
