[08/02/2024 05:04:55], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575095','43.239.53.130');
[08/02/2024 05:04:55], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'ebookingcenter/02_08_2024/request_valuation_Test_DoNotUse_05_04_55_1722575095_14.json', 'ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_04_55_1722575095_14.json', 'ebookingcenter/02_08_2024/response_header_valuation_Test_DoNotUse_05_04_55_1722575095_14.json', 'ebookingcenter', '2024-08-02 05:04:55', '', '10890220240804575537396896217', '14644708', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_04_55_1722575095_14.json');
[08/02/2024 05:05:02], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575102','43.239.53.130');
[08/02/2024 05:05:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'ebookingcenter/02_08_2024/request_valuation_Test_DoNotUse_05_05_03_1722575103_42.json', 'ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_05_03_1722575103_42.json', 'ebookingcenter/02_08_2024/response_header_valuation_Test_DoNotUse_05_05_03_1722575103_42.json', 'ebookingcenter', '2024-08-02 05:05:03', '', '10890220240804575537396896217', '14644708', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_05_03_1722575103_42.json');
[08/02/2024 05:05:22], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575122','43.239.53.130');
[08/02/2024 05:05:22], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'ebookingcenter/02_08_2024/request_valuation_Test_DoNotUse_05_05_22_1722575122_97.json', 'ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_05_22_1722575122_97.json', 'ebookingcenter/02_08_2024/response_header_valuation_Test_DoNotUse_05_05_22_1722575122_97.json', 'ebookingcenter', '2024-08-02 05:05:22', '', '10890220240804575537396896217', '14644708', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/02_08_2024/response_valuation_Test_DoNotUse_05_05_22_1722575122_97.json');
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '103' ,status = '1' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:06:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-08-02 05:06:51',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 103 ,status = \&#039;1\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-618 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[08/02/2024 05:06:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-02 05:06:56',login_attempt=0 where id = '618';
[08/02/2024 05:06:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'bhargavi_ws', user_type = 'A', branch_id = '1', login_datetime = '2024-08-02 05:06:56', ip = '43.239.53.130', action = 'Login' ;
[08/02/2024 05:07:42], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2025/01/09' , departure_date = '2025/01/10' , nights = '1' , nationality = '138' , room_types = '2.2, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"2,6"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"4,7"}]' , available='0' , create_date = '2024-08-02 05:07:42' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/02/2024 05:07:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_618_6180220240805074259020994188', session_id='6180220240805074259020994188', Collection_create_time='2024-08-02 05:07:42';
[08/02/2024 05:07:56], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'r2/02_08_2024/request_availability__05_07_42_bhargavi_ws_1722575262_.xml', 'r2/02_08_2024/response_availability__05_07_42_bhargavi_ws_1722575262_.xml', 'r2/02_08_2024/response_header_availability__05_07_42_bhargavi_ws_1722575262_.xml', 'roomsxml', '2024-08-02 05:07:56', '', '6180220240805074259020994188', '14644715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_availability__05_07_42_bhargavi_ws_1722575262_.xml');
[08/02/2024 05:07:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '360'
        , request_url = '/call.php?s=roomsxml&sessionid=6180220240805074259020994188&xml_user_id=618&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2024-08-02 05:07:42.876'
        , request_start_time = '0.023'
        , parsing_start_time = '13.184'
        , mapping_complete_time = '0.756'
        , mongo_start_time = '1.224'
        , search_end_time = '1.219'
        , total_duration = '15.762'
        , error_description = ''
        , memory_used = '115140304'
        WHERE id = '168503020';
[08/02/2024 05:07:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '354',
        request_path = '/xml_all.php?userid=618&sessionid=6180220240805074259020994188',
        duration = '17.091',
        merge_duration = '0.005',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.06',
        system_load_5_min = '1.25',
        system_load_15_min = '1.32',
        system_memory_usage = '15.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '14644715') + '2398000',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '14644715';
[08/02/2024 05:08:09], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575289','43.239.53.130');
[08/02/2024 05:08:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_08_09_bhargavi_ws_1722575289_.xml', 'r2/02_08_2024/response_valuation__05_08_09_bhargavi_ws_1722575289_.xml', 'r2/02_08_2024/response_header_valuation__05_08_09_bhargavi_ws_1722575289_.xml', 'roomsxml', '2024-08-02 05:08:12', '', '6180220240805074259020994188', '14644715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_08_09_bhargavi_ws_1722575289_.xml');
[08/02/2024 05:09:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575353','43.239.53.130');
[08/02/2024 05:09:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_09_13_bhargavi_ws_1722575353_.xml', 'r2/02_08_2024/response_valuation__05_09_13_bhargavi_ws_1722575353_.xml', 'r2/02_08_2024/response_header_valuation__05_09_13_bhargavi_ws_1722575353_.xml', 'roomsxml', '2024-08-02 05:09:13', '', '6180220240805074259020994188', '14644715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_09_13_bhargavi_ws_1722575353_.xml');
[08/02/2024 05:10:28], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575428','43.239.53.130');
[08/02/2024 05:10:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into email_trigger set  subject ='roomsxml Rate Change on confirmation page redirection done to book now  Astra Bookings',  message='On Book Now page, Rate Change has been found for Supplier roomsxml:<br><br>Old Supplier  Rate:145.04 USD<br><font color=\'red\'><b>New Supplier rate:170.74 USD</b></font><br>Old Agent  Rate:150.84 USD<br><font color=\'red\'><b>Agent New rate:177.56 </b></font><br>Agency Name:Astra Qtech WS<br>Agent Name:Bhargavi&nbsp;Pise<br>City:dubai<br>Arrival Date:2025/01/09<br>Departure Date:2025/01/10<br>Supplier - roomsxml<br>Hotel:PREMIER INN DUBAI INVESTMENTS PARK<br>Total Nights:1<br>Date :02-08-2024<br><b>Room Info</b><br><hr><b> Room Type </b>:Family Room - Non Smoking (Double) Room only <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:doubleplus2children<br><br> <b> Room Type </b>:Family Room - Non Smoking (Double) Room only <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:doubleplus2children<br><br> ',  email_sent ='yes', create_date ='2024-08-02 05:10:32', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:10:32], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575432','43.239.53.130');
[08/02/2024 05:10:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Astra Qtech WS (Username: bhargavi_ws)<br><br>City:<br><br>Arrival Date:<br><br>Departure Date:<br><br>Supplier:<br><br>Hotel:<br><br>',  email_sent ='yes', create_date ='2024-08-02 05:10:33', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:11:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575486','43.239.53.130');
[08/02/2024 05:11:30], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_11_26_bhargavi_ws_1722575486_.xml', 'r2/02_08_2024/response_valuation__05_11_26_bhargavi_ws_1722575486_.xml', 'r2/02_08_2024/response_header_valuation__05_11_26_bhargavi_ws_1722575486_.xml', 'roomsxml', '2024-08-02 05:11:30', '', '6180220240805074259020994188', '14644715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_11_26_bhargavi_ws_1722575486_.xml');
[08/02/2024 05:11:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Astra Qtech WS (Username: bhargavi_ws)<br><br>City:dubai<br><br>Arrival Date:09/01/2025<br><br>Departure Date:10/01/2025<br><br>Supplier:roomsxml<br><br>Hotel:PREMIER INN DUBAI INTERNATIONAL AIRPORT<br><br>Room:Family Room + Free Wifi Room only
',  email_sent ='yes', create_date ='2024-08-02 05:11:31', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:12:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575527','43.239.53.130');
[08/02/2024 05:12:09], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_12_07_bhargavi_ws_1722575527_.xml', 'r2/02_08_2024/response_valuation__05_12_07_bhargavi_ws_1722575527_.xml', 'r2/02_08_2024/response_header_valuation__05_12_07_bhargavi_ws_1722575527_.xml', 'roomsxml', '2024-08-02 05:12:09', '', '6180220240805074259020994188', '14644715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_12_07_bhargavi_ws_1722575527_.xml');
[08/02/2024 05:12:10], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Astra Qtech WS (Username: bhargavi_ws)<br><br>City:dubai<br><br>Arrival Date:09/01/2025<br><br>Departure Date:10/01/2025<br><br>Supplier:roomsxml<br><br>Hotel:PREMIER INN DUBAI INTERNATIONAL AIRPORT<br><br>Room:Family Room + Free Wifi Room only
',  email_sent ='yes', create_date ='2024-08-02 05:12:10', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '103' ,status = '1' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '618',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/02/2024 05:12:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-08-02 05:12:25',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 103 ,status = \&#039;1\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;618\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-618 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[08/02/2024 05:12:31], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-02 05:12:31',login_attempt=0 where id = '618';
[08/02/2024 05:12:31], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'bhargavi_ws', user_type = 'A', branch_id = '1', login_datetime = '2024-08-02 05:12:31', ip = '43.239.53.130', action = 'Login' ;
[08/02/2024 05:13:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2025/01/08' , departure_date = '2025/01/09' , nights = '1' , nationality = '138' , room_types = '2.2, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"3,5"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"4,7"}]' , available='0' , create_date = '2024-08-02 05:13:25' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/02/2024 05:13:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_618_6180220240805132525019745862', session_id='6180220240805132525019745862', Collection_create_time='2024-08-02 05:13:25';
[08/02/2024 05:13:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'r2/02_08_2024/request_availability__05_13_26_bhargavi_ws_1722575606_.xml', 'r2/02_08_2024/response_availability__05_13_26_bhargavi_ws_1722575606_.xml', 'r2/02_08_2024/response_header_availability__05_13_26_bhargavi_ws_1722575606_.xml', 'roomsxml', '2024-08-02 05:13:39', '', '6180220240805132525019745862', '14644718', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_availability__05_13_26_bhargavi_ws_1722575606_.xml');
[08/02/2024 05:13:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '359'
        , request_url = '/call.php?s=roomsxml&sessionid=6180220240805132525019745862&xml_user_id=618&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2024-08-02 05:13:25.925'
        , request_start_time = '0.021'
        , parsing_start_time = '13.097'
        , mapping_complete_time = '0.758'
        , mongo_start_time = '1.226'
        , search_end_time = '1.207'
        , total_duration = '15.658'
        , error_description = ''
        , memory_used = '113676616'
        WHERE id = '168503123';
[08/02/2024 05:13:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '352',
        request_path = '/xml_all.php?userid=618&sessionid=6180220240805132525019745862',
        duration = '17.087',
        merge_duration = '0.005',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.11',
        system_load_5_min = '1.23',
        system_load_15_min = '1.30',
        system_memory_usage = '17.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '14644718') + '2398080',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '14644718';
[08/02/2024 05:14:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575640','43.239.53.130');
[08/02/2024 05:14:02], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_14_00_bhargavi_ws_1722575640_.xml', 'r2/02_08_2024/response_valuation__05_14_00_bhargavi_ws_1722575640_.xml', 'r2/02_08_2024/response_header_valuation__05_14_00_bhargavi_ws_1722575640_.xml', 'roomsxml', '2024-08-02 05:14:02', '', '6180220240805132525019745862', '14644718', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_14_00_bhargavi_ws_1722575640_.xml');
[08/02/2024 05:14:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575671','43.239.53.130');
[08/02/2024 05:14:35], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_14_31_bhargavi_ws_1722575671_.xml', 'r2/02_08_2024/response_valuation__05_14_31_bhargavi_ws_1722575671_.xml', 'r2/02_08_2024/response_header_valuation__05_14_31_bhargavi_ws_1722575671_.xml', 'roomsxml', '2024-08-02 05:14:35', '', '6180220240805132525019745862', '14644718', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_14_31_bhargavi_ws_1722575671_.xml');
[08/02/2024 05:14:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575681','43.239.53.130');
[08/02/2024 05:14:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'r2/02_08_2024/request_valuation__05_14_41_bhargavi_ws_1722575681_.xml', 'r2/02_08_2024/response_valuation__05_14_41_bhargavi_ws_1722575681_.xml', 'r2/02_08_2024/response_header_valuation__05_14_41_bhargavi_ws_1722575681_.xml', 'roomsxml', '2024-08-02 05:14:41', '', '6180220240805132525019745862', '14644718', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/02_08_2024/response_valuation__05_14_41_bhargavi_ws_1722575681_.xml');
[08/02/2024 05:16:22], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575782','43.239.53.130');
[08/02/2024 05:16:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into email_trigger set  subject ='roomsxml Rate Change on confirmation page redirection done to book now  Astra Bookings',  message='On Book Now page, Rate Change has been found for Supplier roomsxml:<br><br>Old Supplier  Rate:145.24 USD<br><font color=\'red\'><b>New Supplier rate:170.74 USD</b></font><br>Old Agent  Rate:151.04 USD<br><font color=\'red\'><b>Agent New rate:177.56 </b></font><br>Agency Name:Astra Qtech WS<br>Agent Name:Bhargavi&nbsp;Pise<br>City:dubai<br>Arrival Date:2025/01/08<br>Departure Date:2025/01/09<br>Supplier - roomsxml<br>Hotel:PREMIER INN DUBAI INVESTMENTS PARK<br>Total Nights:1<br>Date :02-08-2024<br><b>Room Info</b><br><hr><b> Room Type </b>:Family Room - Non Smoking (Double) Room only <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:doubleplus2children<br><br> <b> Room Type </b>:Family Room - Non Smoking (Double) Room only <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:doubleplus2children<br><br> ',  email_sent ='yes', create_date ='2024-08-02 05:16:25', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:16:25], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1722575785','43.239.53.130');
[08/02/2024 05:16:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Astra Qtech WS (Username: bhargavi_ws)<br><br>City:<br><br>Arrival Date:<br><br>Departure Date:<br><br>Supplier:<br><br>Hotel:<br><br>',  email_sent ='yes', create_date ='2024-08-02 05:16:26', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/02/2024 05:16:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-02 05:16:47',login_attempt=0 where id = '618';
[08/02/2024 05:16:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'bhargavi_ws', user_type = 'A', branch_id = '1', login_datetime = '2024-08-02 05:16:47', ip = '43.239.53.130', action = 'Login' ;
[08/02/2024 05:17:57], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/18' , departure_date = '2024/12/19' , nights = '1' , nationality = '138' , room_types = '2.2, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"2,4"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"}]' , available='0' , create_date = '2024-08-02 05:17:57' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/02/2024 05:19:19], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/18' , departure_date = '2024/12/19' , nights = '1' , nationality = '138' , room_types = '2.2, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"2,4"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"}]' , available='0' , create_date = '2024-08-02 05:19:19' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/02/2024 05:20:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-02 05:20:04',login_attempt=0 where id = '618';
[08/02/2024 05:20:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'bhargavi_ws', user_type = 'A', branch_id = '1', login_datetime = '2024-08-02 05:20:04', ip = '43.239.53.130', action = 'Login' ;
[08/02/2024 05:26:17], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'bali' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/30' , departure_date = '2024/12/31' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-02 05:26:17' , site_id = '' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/02/2024 05:31:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-02 05:31:22',login_attempt=0 where id = '618';
[08/02/2024 05:31:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'bhargavi_ws', user_type = 'A', branch_id = '1', login_datetime = '2024-08-02 05:31:22', ip = '43.239.53.130', action = 'Login' ;
[08/02/2024 05:41:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '618' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2025/01/23' , departure_date = '2025/01/24' , nights = '1' , nationality = '138' , room_types = '2.2, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"7,3"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"3,5"}]' , available='0' , create_date = '2024-08-02 05:41:09' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
