[08/05/2020 09:02:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618131','60.254.42.39');
[08/05/2020 09:02:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618132','60.254.42.39');
[08/05/2020 09:02:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618133','60.254.42.39');
[08/05/2020 09:02:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618134','60.254.42.39');
[08/05/2020 09:02:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618135','60.254.42.39');
[08/05/2020 09:02:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618135','60.254.42.39');
[08/05/2020 09:02:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618136','60.254.42.39');
[08/05/2020 09:02:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618137','60.254.42.39');
[08/05/2020 09:02:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618138','60.254.42.39');
[08/05/2020 09:02:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618138','60.254.42.39');
[08/05/2020 09:02:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618139','60.254.42.39');
[08/05/2020 09:02:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618139','60.254.42.39');
[08/05/2020 09:02:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618156','60.254.42.39');
[08/05/2020 09:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618162','60.254.42.39');
[08/05/2020 09:03:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596618197','60.254.42.39');
[08/05/2020 09:09: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 = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',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= '',allow_book_under_cancellation='1',modify_date='2020-08-05 09:09:36',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/05/2020 09:09:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-05 09:09: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;0\&#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;1000\&#039;,credit_limit= \&#039;1000\&#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= ,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-05 09:09:36\&#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  - modify_date=2020-08-05+05%3A31%3A57 changed to - modify_date=2020-08-05+09%3A09%3A36',`ip`= '60.254.42.39';
[08/05/2020 09:09:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3528', `entity`='Agents', `value`='25' ;
[08/05/2020 09:09: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/05/2020 09:09:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '0.000',credit_usage= '1000.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.42.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-05 09:08:36';
[08/05/2020 09:09:36], [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 = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/05/2020 09:09:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 25 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20424 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_registration_email&agent_id=25',create_date= '2020-08-05 09:09:43';
[08/05/2020 09:09:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15784 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_confirmation_email&agent_id=25',create_date= '2020-08-05 09:09:48';
[08/05/2020 09:19:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596619196','45.120.147.56');
[08/05/2020 09:25:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596619537','45.120.147.56');
[08/05/2020 09:27:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-05 09:27:27', '', '', '');
[08/05/2020 09:30:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596619824','45.120.147.56');
