[08/07/2020 06:07:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '45.120.147.56' , city = 'Mumbai' , arrival_date='2020/08/20',  departure_date='2020/08/20',  nights='1',  create_date='2020-08-07 :06:07:22',  nationality='106',  additional_markup='',  selected_currency='',  service_type='transfer',  total_adult='2',  total_children='',  site_id = '' ;
[08/07/2020 06:07:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],insert into email_logs SET `subject`= 'Local Transfer Currency Not Present USD-',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'TG9jYWwgVHJhbnNmZXIgQ3VycmVuY3kgTm90IFByZXNlbnQgVVNELQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/transfer_search_list.php',create_date= '2020-08-07 06:07:22';
[08/07/2020 06:09:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , city = 'Mumbai' , arrival_date='2020/08/20',  departure_date='2020/08/20',  nights='1',  create_date='2020-08-07 :06:09:34',  nationality='106',  additional_markup='',  selected_currency='',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/07/2020 06:09:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],insert into email_logs SET `subject`= 'Local Transfer Currency Not Present USD-',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'TG9jYWwgVHJhbnNmZXIgQ3VycmVuY3kgTm90IFByZXNlbnQgVVNELQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/transfer_search_list.php',create_date= '2020-08-07 06:09:34';
[08/07/2020 06:09:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '45.120.147.56' , city = 'Mumbai' , arrival_date='2020/08/20',  departure_date='2020/08/20',  nights='1',  create_date='2020-08-07 :06:09:55',  nationality='106',  additional_markup='',  selected_currency='',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/07/2020 06:09:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],insert into email_logs SET `subject`= 'Local Transfer Currency Not Present USD-',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'TG9jYWwgVHJhbnNmZXIgQ3VycmVuY3kgTm90IFByZXNlbnQgVVNELQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/transfer_search_list.php?ez_queries=1',create_date= '2020-08-07 06:09:55';
[08/07/2020 06:11:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , city = 'Mumbai' , arrival_date='2020/08/21',  departure_date='2020/08/21',  nights='1',  create_date='2020-08-07 :06:11:04',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/07/2020 06:11:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596780695','45.120.147.56');
[08/07/2020 06:12:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596780732','45.120.147.56');
[08/07/2020 06:12:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Mumbai Darshan transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5NdW1iYWkgRGFyc2hhbjwvYj4gdHJhbnNmZXIuIDxicj48YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2020-08-07 06:12:12';
[08/07/2020 06:12:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Mumbai Darshan transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Mumbai Darshan&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-07 06:12:12';
[08/07/2020 06:13:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596780806','103.104.226.130');
[08/07/2020 06:13:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596780834','45.120.147.56');
[08/07/2020 06:13:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Mumbai Darshan transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5NdW1iYWkgRGFyc2hhbjwvYj4gdHJhbnNmZXIuIDxicj48YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2020-08-07 06:13:54';
[08/07/2020 06:13:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Mumbai Darshan transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Mumbai Darshan&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-07 06:13:54';
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET credit_value=credit_value+'3'25''25''25'' WHERE id= ?;
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Credit Limit Changed',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'aGksIAogCkNyZWRpdCBMaW1pdCBDaGFuZ2VkIGZvcjogUXRlY2hQdnQgKDI1KSAKT2xkIExpbWl0OiAxMDAwCk5ldyBMaW1pdDogNDAwMApDaGFuZ2VkIEJ5OiB0ZmcKIApSZWdhcmRzIAogVGhlIEZhYnVsb3VzIEdldGF3YXkK',to_email_id= 'SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=&status_search=&person_name_search=&search=agent&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=025',create_date= '2020-08-07 06:16:22';
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '4000',credit_limit= '4000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-08-07 06:16:22',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '',can_show_hotels= '' WHERE id= '25';
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:16:22',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;4000\&#039;,credit_limit= \&#039;4000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-07 06:16:22\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - credit_limit=1000&credit_limit_assigned=1000&credit_value=-2108.070&modify_date=2020-08-05+09%3A09%3A36&can_voucher=&auto_voucher_bookings=0 changed to - credit_limit=4000&credit_limit_assigned=4000&credit_value=891.930&modify_date=2020-08-07+06%3A16%3A22&can_voucher=1&auto_voucher_bookings=1',`ip`= '45.120.147.56';
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3547', `entity`='Agents', `value`='25' ;
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '891.930',credit_usage= '3108.070',credit_limit= '4000',receipt_id= '',amount= '',ip='45.120.147.56',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-07 06:08:22';
[08/07/2020 06:16:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET credit_value=credit_value+'1'25''25''25''25'' WHERE id= ?;
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Credit Limit Changed',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'aGksIAogCkNyZWRpdCBMaW1pdCBDaGFuZ2VkIGZvcjogUXRlY2hQdnQgKDI1KSAKT2xkIExpbWl0OiA0MDAwCk5ldyBMaW1pdDogMTQwMDAKQ2hhbmdlZCBCeTogdGZnCiAKUmVnYXJkcyAKIFRoZSBGYWJ1bG91cyBHZXRhd2F5Cg==',to_email_id= 'nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=PhpTest&status_search=&person_name_search=&search=agent&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=025',create_date= '2020-08-07 06:16:54';
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '14000',credit_limit= '14000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= 'otrams',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-08-07 06:16:54',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '',can_show_hotels= '' WHERE id= '25';
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:16:54',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;14000\&#039;,credit_limit= \&#039;14000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;otrams\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-07 06:16:54\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - credit_limit=4000&credit_limit_assigned=4000&credit_value=891.930&modify_date=2020-08-07+06%3A16%3A22&consultant_id=SalesConsultant&sales_manager_id= changed to - credit_limit=14000&credit_limit_assigned=14000&credit_value=10891.930&modify_date=2020-08-07+06%3A16%3A54&consultant_id=nitinalpha&sales_manager_id=otrams',`ip`= '103.104.226.130';
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3548', `entity`='Agents', `value`='25' ;
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10891.930',credit_usage= '3108.070',credit_limit= '14000',receipt_id= '',amount= '',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-07 06:08:54';
[08/07/2020 06:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= 'otrams',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '14000',credit_limit= '14000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Tour Operator',can_book= '1',sales_manager_id= 'otrams',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-08-07 06:17:34',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '' WHERE id= '25';
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:17:34',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;14000\&#039;,credit_limit= \&#039;14000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Tour Operator\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;otrams\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-07 06:17:34\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;2\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - nature_of_business=0&modify_date=2020-08-07+06%3A16%3A54&agent_category=0 changed to - nature_of_business=Tour+Operator&modify_date=2020-08-07+06%3A17%3A34&agent_category=2',`ip`= '45.120.147.56';
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3549', `entity`='Agents', `value`='25' ;
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10891.930',credit_usage= '3108.070',credit_limit= '14000',receipt_id= '',amount= '',ip='45.120.147.56',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-07 06:08:34';
[08/07/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= 'otrams',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/07/2020 06:18:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , city = 'Mumbai' , arrival_date='2020/08/20',  departure_date='2020/08/20',  nights='1',  create_date='2020-08-07 :06:18:41',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/07/2020 06:18:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781129','45.120.147.56');
[08/07/2020 06:18:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781138','103.104.226.130');
[08/07/2020 06:18:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Mumbai Darshan transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5NdW1iYWkgRGFyc2hhbjwvYj4gdHJhbnNmZXIuIDxicj48YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2020-08-07 06:18:58';
[08/07/2020 06:18:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Mumbai Darshan transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Mumbai Darshan&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-07 06:18:58';
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '14000',credit_limit= '14000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Tour Operator',can_book= '1',sales_manager_id= 'otrams',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='0',modify_date='2020-08-07 06:19:36',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '' WHERE id= '25';
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:19:36',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;14000\&#039;,credit_limit= \&#039;14000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Tour Operator\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;otrams\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2020-08-07 06:19:36\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;2\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-08-07+06%3A17%3A34&allow_book_under_cancellation=1 changed to - modify_date=2020-08-07+06%3A19%3A36&allow_book_under_cancellation=0',`ip`= '45.120.147.56';
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3550', `entity`='Agents', `value`='25' ;
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10891.930',credit_usage= '3108.070',credit_limit= '14000',receipt_id= '',amount= '',ip='45.120.147.56',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-07 06:08:36';
[08/07/2020 06:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= 'otrams',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/07/2020 06:19:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781184','45.120.147.56');
[08/07/2020 06:19:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Mumbai Darshan transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5NdW1iYWkgRGFyc2hhbjwvYj4gdHJhbnNmZXIuIDxicj48YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2020-08-07 06:19:44';
[08/07/2020 06:19:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Mumbai Darshan transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Mumbai Darshan&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-07 06:19:44';
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '14000',credit_limit= '14000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Tour Operator',can_book= '1',sales_manager_id= 'otrams',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-08-07 06:19:58',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '' WHERE id= '25';
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:19:58',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;14000\&#039;,credit_limit= \&#039;14000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Tour Operator\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;otrams\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-07 06:19:58\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;2\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-08-07+06%3A19%3A36&allow_book_under_cancellation=0 changed to - modify_date=2020-08-07+06%3A19%3A58&allow_book_under_cancellation=1',`ip`= '45.120.147.56';
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3551', `entity`='Agents', `value`='25' ;
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10891.930',credit_usage= '3108.070',credit_limit= '14000',receipt_id= '',amount= '',ip='45.120.147.56',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-07 06:08:58';
[08/07/2020 06:19:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= 'otrams',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/07/2020 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781217','45.120.147.56');
[08/07/2020 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Mumbai Darshan transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5NdW1iYWkgRGFyc2hhbjwvYj4gdHJhbnNmZXIuIDxicj48YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2020-08-07 06:20:17';
[08/07/2020 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Mumbai Darshan transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Mumbai Darshan&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-07 06:20:17';
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values ('203','days',
				'0','2','percentage',
				'80','2020-08-07','2020-10-31','S000000068','transfer', 'admin');
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:22:32',`log_type`= 'Transfer Cancellation Policy Inserted',`sql_query`= 'insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values (\&#039;203\&#039;,\&#039;days\&#039;,
				\&#039;0\&#039;,\&#039;2\&#039;,\&#039;percentage\&#039;,
				\&#039;80\&#039;,\&#039;2020-08-07\&#039;,\&#039;2020-10-31\&#039;,\&#039;S000000068\&#039;,\&#039;transfer\&#039;, \&#039;admin\&#039;)',`log_description`= 'Transfer Cancellation Policy Inserted By User tfg',`ip`= '45.120.147.56';
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values ('203','days',
				'2','5','percentage',
				'50','2020-08-07','2020-10-31','S000000068','transfer', 'admin');
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:22:32',`log_type`= 'Transfer Cancellation Policy Inserted',`sql_query`= 'insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values (\&#039;203\&#039;,\&#039;days\&#039;,
				\&#039;2\&#039;,\&#039;5\&#039;,\&#039;percentage\&#039;,
				\&#039;50\&#039;,\&#039;2020-08-07\&#039;,\&#039;2020-10-31\&#039;,\&#039;S000000068\&#039;,\&#039;transfer\&#039;, \&#039;admin\&#039;)',`log_description`= 'Transfer Cancellation Policy Inserted By User tfg',`ip`= '45.120.147.56';
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values ('203','days',
				'5','10','percentage',
				'40','2020-08-07','2020-10-31','S000000068','transfer', 'admin');
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:22:32',`log_type`= 'Transfer Cancellation Policy Inserted',`sql_query`= 'insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values (\&#039;203\&#039;,\&#039;days\&#039;,
				\&#039;5\&#039;,\&#039;10\&#039;,\&#039;percentage\&#039;,
				\&#039;40\&#039;,\&#039;2020-08-07\&#039;,\&#039;2020-10-31\&#039;,\&#039;S000000068\&#039;,\&#039;transfer\&#039;, \&#039;admin\&#039;)',`log_description`= 'Transfer Cancellation Policy Inserted By User tfg',`ip`= '45.120.147.56';
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values ('203','days',
				'10','30','percentage',
				'25','2020-08-07','2020-10-31','S000000068','transfer', 'admin');
[08/07/2020 06:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/localsystem_cancelation_policy.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-07 06:22:32',`log_type`= 'Transfer Cancellation Policy Inserted',`sql_query`= 'insert into localsystem_cancellation_policy_services (service_id,duration_type,from_duration,to_duration,
				amount_type,amount_value,from_date,to_date,supplier_id,service_type, added_by) values (\&#039;203\&#039;,\&#039;days\&#039;,
				\&#039;10\&#039;,\&#039;30\&#039;,\&#039;percentage\&#039;,
				\&#039;25\&#039;,\&#039;2020-08-07\&#039;,\&#039;2020-10-31\&#039;,\&#039;S000000068\&#039;,\&#039;transfer\&#039;, \&#039;admin\&#039;)',`log_description`= 'Transfer Cancellation Policy Inserted By User tfg',`ip`= '45.120.147.56';
[08/07/2020 06:22:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781371','45.120.147.56');
[08/07/2020 06:24:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '45.120.147.56' , city = 'Mumbai' , arrival_date='2020/10/15',  departure_date='2020/10/15',  nights='1',  create_date='2020-08-07 :06:24:02',  nationality='106',  additional_markup='',  selected_currency='INR',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/07/2020 06:24:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781463','45.120.147.56');
[08/07/2020 06:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596781483','45.120.147.56');
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],INSERT INTO bookings set reservation_id='1738',agent_id='25',backoffice_user='',itenirary_id='',confirmation_number='',comment_contract='Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.',special_remark='',city_id='Mumbai',country_id='',display_room_rate='6000',display_currency_code='INR',native_room_rate='100',consultant_id='nitinalpha',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 14-Sep-2020 14:00 hrs.<BR>Late Amendment Charges may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B>  Cancellation Charges of 1500 INR applicable if cancelled after 14-Sep-2020 14:00 hrs.<br> Cancellation Charges of 2400 INR applicable if cancelled after 04-Oct-2020 14:00 hrs.<br> Cancellation Charges of 3000 INR applicable if cancelled after 09-Oct-2020 14:00 hrs.<br> Cancellation Charges of 4800 INR applicable if cancelled after 12-Oct-2020 14:00 hrs.<br>',current_status='on_request',booking_status='1',nationality='',create_date='2020-08-07 06:54:57',status_date='2020-08-07 06:54:57',source_type='localtransfer',supplier_profile_id='',expiration_date='2020-09-14 14:00:00',native_rate='0',display_rate='0',wh_display_rate='0',applied_multiplier='60',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2020-10-15',check_out_date='2020-10-15',agent_currency_multiplier='0.01533',ip_addr='45.120.147.56',site_id='0',leader_phone='',email_id='',sub_user_id='',sales_manager_id='otrams',booking_branch_id='1',site_url = 'http://uat.tfg.otrams.net/', service_type='transfer';
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update bookings set  parent_agent_id='25', sub_agent_rate='0', agent_rate='6000', applicable_service_tax='0', supplier_rate='100', original_source='', uid='96dc251cae67505650729caf00e78333' where id='2805';
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into transfer_bookings  set booking_id='2805',gtaToken='',city_code='64440',transfer_date='2020-10-15',language_code='E',pickup='H',pickup_code='',dropoff='A',dropoff_code='',no_of_pass='1',pick_up_time='.',dropoff_time='',item_code='203',item_content='Mumbai Darshan',sel_arr_from='',flight_number='',terminal_details='',dest_terminal_details='',dropoff_to_hotel='H',dropoff_station='',dropoff_station_train='',dropoff_station_destination='',dest_flight_no='',flight_destination='',dropoff_port_shipname='',dropoff_port_shipcompany='',dropoff_port_shipdestination='',pickup_acc_address1='',pickup_acc_address2='',pickup_acc_city='',pickup_acc_country='',pickup_acc_postcode='',pickup_acc_phone='',dropoff_acc_address1='',dropoff_acc_address2='',dropoff_acc_city='',dropoff_acc_country='',dropoff_acc_postcode='',dropoff_acc_phone='',dropoff_other_address1='',dropoff_other_address2='',dropoff_other_country='',dropoff_other_postcode='',dropoff_other_phone='',Error='',Item_Confirm_Ref='',airport_arriving_from='',arriving_flight_number='',pickup_station_arriving_from='',pickup_station_train_name='',pickup_station_arriving_station='',pickup_port_arriving_from='',pickup_port_ship_name='',pickup_port_shipping_company='',pickup_other_address1='',pickup_other_address2='',pickup_other_country='',pickup_other_postcode='',pickup_other_phone='',country_code='106',adult_charge='100',child_charge='0',tariff_code='c8393260969584aaaba1e9bcb71191bf',supplier_id='S000000068',pickup_from_hotel='',dropoff_airport_name='',transfer_condition='Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.',vehicle_type='4', charge_applied_type='SIC Basis' ,travel_duration='4 hr 0 mins ';
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2805','on_request','2020-08-07 06:54:57','Transfer Booking on_request','25','45.120.147.56','','','');
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into transfer_vehicles (booking_id,vehicle_code,vehicle_name,max_luggage,max_passenger,sel_passenger,lead_name,vehicle_native_price,native_price,display_price,native_surcharge,display_surcharge,wh_display_price,wh_surcharge,no_of_adult,adult_rate,no_of_child,lead_phone) values ('2805','4','VAN 6 SEATER ','5','4','1','Mr Sanket Desai','100','100','6000','','','','','1','100','0','');
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update bookings set leader_first_name = 'Mr Sanket Desai' where id = '2805';
[08/07/2020 06:54:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update xmllogs set reservation_id='2805' where agent_logs_id='372' and source_type='localtransfer';
[08/07/2020 06:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302805/  Booking On Request ',from_email_id= '',body= '[encoded data, 40012 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-07 06:54:58';
[08/07/2020 06:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302805/  Booking On Request ',from_email_id= '',body= '[encoded data, 40012 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-07 06:54:58';
[08/07/2020 06:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302805/  Booking On Request ',from_email_id= '',body= '[encoded data, 27760 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-07 06:54:58';
[08/07/2020 06:56:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , city = 'mumbai' , arrival_date='2020/08/13',  departure_date='2020/08/13',  nights='1',  create_date='2020-08-07 :06:56:25',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='1',  total_children='0',  site_id = '' ;
[08/07/2020 06:56:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596783417','103.104.226.130');
