[11/28/2023 06:12:40], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:12:40',login_attempt=0 where id = '7865';
[11/28/2023 06:12:40], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:12:40', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:12:41], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:12:41' WHERE id= '158';
[11/28/2023 06:13:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:13:54' WHERE id= '158';
[11/28/2023 06:14:32], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:14:32' WHERE id= '158';
[11/28/2023 06:14:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:14:32',login_attempt=0 where id = '7865';
[11/28/2023 06:14:32], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:14:32', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:14:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:14:32' WHERE id= '158';
[11/28/2023 06:17:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:17:18',login_attempt=0 where id = '7865';
[11/28/2023 06:17:18], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:17:18', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:17:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:17:18' WHERE id= '159';
[11/28/2023 06:19:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:19:46' WHERE id= '158';
[11/28/2023 06:21:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:21:05',login_attempt=0 where id = '7857';
[11/28/2023 06:21:05], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-28 06:21:05', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:21:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:21:05' WHERE id= '160';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:21:10' WHERE id= '160';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:21:10',login_attempt=0 where id = '7851';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2023-11-28 06:21:10', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:21:10' WHERE id= '160';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:21:10',login_attempt=0 where id = '7851';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2023-11-28 06:21:10', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:21:10' WHERE id= '160';
[11/28/2023 06:21:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:21:10' WHERE id= '160';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '59' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/28/2023 06:22:18], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-11-28 06:22:18',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 67 ,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;7851\&#039;,supplier_id = 52 ,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;7851\&#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;7851\&#039;,supplier_id = 24 ,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;7851\&#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;7851\&#039;,supplier_id = 64 ,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;7851\&#039;,supplier_id = 65 ,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;7851\&#039;,supplier_id = 34 ,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;7851\&#039;,supplier_id = 20 ,status = \&#039;1\&#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;7851\&#039;,supplier_id = 55 ,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;7851\&#039;,supplier_id = 62 ,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;7851\&#039;,supplier_id = 53 ,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;7851\&#039;,supplier_id = 16 ,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;7851\&#039;,supplier_id = 75 ,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;7851\&#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;7851\&#039;,supplier_id = 18 ,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;7851\&#039;,supplier_id = 19 ,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;7851\&#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;7851\&#039;,supplier_id = 71 ,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;7851\&#039;,supplier_id = 69 ,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;7851\&#039;,supplier_id = 68 ,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;7851\&#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;7851\&#039;,supplier_id = 35 ,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;7851\&#039;,supplier_id = 70 ,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;7851\&#039;,supplier_id = 59 ,status = \&#039;1\&#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;7851\&#039;,supplier_id = 32 ,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;7851\&#039;,supplier_id = 58 ,status = \&#039;1\&#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;7851\&#039;,supplier_id = 56 ,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;7851\&#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;7851\&#039;,supplier_id = 61 ,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;7851\&#039;,supplier_id = 63 ,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;7851\&#039;,supplier_id = 54 ,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;7851\&#039;,supplier_id = 66 ,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;7851\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7851 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7851 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[11/28/2023 06:22:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:22:23' WHERE id= '160';
[11/28/2023 06:22:26], [file name :-/home/otrams/public_html/beta/transfer_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:22:26' WHERE id= '160';
[11/28/2023 06:23:01], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:23:01' WHERE id= '158';
[11/28/2023 06:23:01], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:23:01',login_attempt=0 where id = '7865';
[11/28/2023 06:23:01], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:23:01', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:23:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:23:01' WHERE id= '158';
[11/28/2023 06:23:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:23:11' WHERE id= '158';
[11/28/2023 06:23:16], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:23:16' WHERE id= '158';
[11/28/2023 06:23:16], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:23:16',login_attempt=0 where id = '7865';
[11/28/2023 06:23:16], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:23:16', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:23:16], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:23:16' WHERE id= '158';
[11/28/2023 06:24:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:24:18' WHERE id= '158';
[11/28/2023 06:25:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:05' WHERE id= '158';
[11/28/2023 06:25:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:13' WHERE id= '158';
[11/28/2023 06:25:20], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:20' WHERE id= '158';
[11/28/2023 06:25:20], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/02' , departure_date = '2024/01/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 06:25:20' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 06:25:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:20' WHERE id= '158';
[11/28/2023 06:25:21], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_25_21_1701152721_56.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_25_21_1701152721_56.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_25_21_1701152721_56.json', 'expedia', '2023-11-28 06:25:21', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:25:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:25:21.82'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.667'
            , error_description = ''
            , memory_used = '12197320'
            WHERE id = '14765';
[11/28/2023 06:25:22], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_25_21_1701152721_99.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_25_21_1701152721_99.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_25_21_1701152721_99.json', 'expediapackage', '2023-11-28 06:25:22', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:25:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:25:21.82'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.104'
            , error_description = ''
            , memory_used = '12366648'
            WHERE id = '14766';
[11/28/2023 06:25:22], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_25_21_1701152721_98.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_25_21_1701152721_98.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_25_21_1701152721_98.json', 'expediapackage', '2023-11-28 06:25:22', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:25:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:25:21.82'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.538'
            , error_description = ''
            , memory_used = '31086920'
            WHERE id = '14767';
[11/28/2023 06:25:24], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_25_21_1701152721_53.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_25_21_1701152721_53.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_25_21_1701152721_53.json', 'expedia', '2023-11-28 06:25:24', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:25:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:25:21.82'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.423'
            , error_description = ''
            , memory_used = '28141520'
            WHERE id = '14768';
[11/28/2023 06:25:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:24' WHERE id= '158';
[11/28/2023 06:25:37], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:37' WHERE id= '158';
[11/28/2023 06:25:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:37' WHERE id= '158';
[11/28/2023 06:25:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701152737','43.239.53.130');
[11/28/2023 06:25:38], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_06_25_37_1701152737_15.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_06_25_37_1701152737_15.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_06_25_37_1701152737_15.json', 'expediapackage', '2023-11-28 06:25:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:25:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:45' WHERE id= '158';
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:59' WHERE id= '158';
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701152759','43.239.53.130');
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:25:59' WHERE id= '158';
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1018', create_date = '2023-11-28 06:25:59', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '21.52', display_currency_code = 'USD', native_room_rate = '21.52', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/02', check_out_date = '2024/01/03', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testN', leader_last_name = 'demo', status_date = '2023-11-28 06:25:59';
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('96','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 06:25:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='96'
		;
[11/28/2023 06:26:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('96','1018','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/02','2024/01/03','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 06:26:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '96', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:21.52;s:25:"displayNightlyRateDisplay";s:154:"Rate - 21.52,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.74 USD, Marketing Fee - 1.74  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:21.629999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.52;}}', native_room_rate_total = '21.52', wh_room_rate_total = '21.63', display_room_rate_total = '21.52', number_of_rooms = '1';
[11/28/2023 06:26:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '96', booking_detail_id = '1', rid = '105', room = '0', salutations = 'Mr', first_name = 'testN', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 06:26:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '96', booking_detail_id = '1', rid = '105', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Baysan_Tourism_wh_06_26_00_1701152760_56.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_06_26_00_1701152760_56.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_06_26_00_1701152760_56.json', 'expediapackage', '2023-11-28 06:26:01', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7583195713352', confirmation_number = '7583195713352', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2023-12-31<br>If you cancel between 2023-12-31 12:30:00 and 2024-01-02 00:00:00 , you will be charged 21.63 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 31st of December 2023.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2023-12-31 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='21.63',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='21.52',  applicable_service_tax='0',  supplier_rate='21.52',  uid='8a08edfa5be897ef89505be4ace84c3e'  where id='96';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='96';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('96','19.0727','72.8561');
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 06:26:01',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;96\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -96 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='330', `entity`='BookingId', `value`='96' ;
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1018','96','confirmed','2023-11-28 06:26:01','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('96','2023-12-31 12:30:00','2023-12-31 12:30:00','2024-01-02 00:00:00','2024-01-02 00:00:00','21.52','21.63','0','2023-11-28 06:26:01','21.63');
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='96',status='1' where reservation_id='1018' and booking_id ='0';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='96' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 06:26:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.74',  commission_tax='',  booking_id ='96',  supplier_tax='2.35',  supplier_base_fare='19.17',  supplier_commissionable_fare='1.74'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 06:26:01';
[11/28/2023 06:31:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:04' WHERE id= '158';
[11/28/2023 06:31:14], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:14' WHERE id= '158';
[11/28/2023 06:31:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:31:14',login_attempt=0 where id = '7865';
[11/28/2023 06:31:14], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:31:14', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:31:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:15' WHERE id= '158';
[11/28/2023 06:31:19], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:19' WHERE id= '158';
[11/28/2023 06:31:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:27' WHERE id= '158';
[11/28/2023 06:31:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/14' , departure_date = '2023/12/15' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 06:31:27' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 06:31:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:27' WHERE id= '158';
[11/28/2023 06:31:28], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_31_28_1701153088_69.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_31_28_1701153088_69.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_31_28_1701153088_69.json', 'expedia', '2023-11-28 06:31:28', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:31:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:31:28.81'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.815'
            , error_description = ''
            , memory_used = '12731984'
            WHERE id = '14771';
[11/28/2023 06:31:28], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_31_28_1701153088_35.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_31_28_1701153088_35.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_31_28_1701153088_35.json', 'expedia', '2023-11-28 06:31:28', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:31:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:31:28.81'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.078'
            , error_description = ''
            , memory_used = '26521472'
            WHERE id = '14772';
[11/28/2023 06:31:29], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_31_28_1701153088_40.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_31_28_1701153088_40.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_31_28_1701153088_40.json', 'expediapackage', '2023-11-28 06:31:29', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:31:29], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_31_28_1701153088_9.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_31_28_1701153088_9.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_31_28_1701153088_9.json', 'expediapackage', '2023-11-28 06:31:29', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:31:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:31:28.81'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.264'
            , error_description = ''
            , memory_used = '12802944'
            WHERE id = '14773';
[11/28/2023 06:31:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:31:28.81'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.435'
            , error_description = ''
            , memory_used = '27051344'
            WHERE id = '14774';
[11/28/2023 06:31:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:29' WHERE id= '158';
[11/28/2023 06:31:37], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:37' WHERE id= '158';
[11/28/2023 06:31:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:37' WHERE id= '158';
[11/28/2023 06:31:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701153097','43.239.53.130');
[11/28/2023 06:31:38], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_06_31_37_1701153097_61.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_06_31_37_1701153097_61.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_06_31_37_1701153097_61.json', 'expediapackage', '2023-11-28 06:31:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:31:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:45' WHERE id= '158';
[11/28/2023 06:31:59], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:31:59' WHERE id= '158';
[11/28/2023 06:31:59], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701153119','43.239.53.130');
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:32:00' WHERE id= '158';
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1020', create_date = '2023-11-28 06:32:00', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '22.07', display_currency_code = 'USD', native_room_rate = '22.07', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2023/12/14', check_out_date = '2023/12/15', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testO', leader_last_name = 'demo', status_date = '2023-11-28 06:32:00';
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('97','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='97'
		;
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('97','1020','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2023/12/14','2023/12/15','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '97', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:22.07;s:25:"displayNightlyRateDisplay";s:154:"Rate - 22.07,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.01 USD, Marketing Fee - 2.01  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.18;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:22.07;}}', native_room_rate_total = '22.07', wh_room_rate_total = '22.18', display_room_rate_total = '22.07', number_of_rooms = '1';
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '97', booking_detail_id = '1', rid = '106', room = '0', salutations = 'Mr', first_name = 'testO', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 06:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '97', booking_detail_id = '1', rid = '106', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Baysan_Tourism_wh_06_32_00_1701153120_18.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_06_32_00_1701153120_18.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_06_32_00_1701153120_18.json', 'expediapackage', '2023-11-28 06:32:01', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7745684826587', confirmation_number = '7745684826587', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2023-12-12<br>If you cancel between 2023-12-12 12:30:00 and 2023-12-14 00:00:00 , you will be charged 22.18 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 12th of December 2023.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2023-12-12 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543213', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='22.18',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='22.07',  applicable_service_tax='0',  supplier_rate='22.07',  uid='153f6705b55676ab2fb423602ab11893'  where id='97';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='97';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('97','19.0727','72.8561');
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 06:32:01',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;97\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -97 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='331', `entity`='BookingId', `value`='97' ;
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1020','97','confirmed','2023-11-28 06:32:01','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('97','2023-12-12 12:30:00','2023-12-12 12:30:00','2023-12-14 00:00:00','2023-12-14 00:00:00','22.07','22.18','0','2023-11-28 06:32:01','22.18');
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='97',status='1' where reservation_id='1020' and booking_id ='0';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='97' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 06:32:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='2.01',  commission_tax='',  booking_id ='97',  supplier_tax='2.36',  supplier_base_fare='19.71',  supplier_commissionable_fare='2.01'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 06:32:01';
[11/28/2023 06:43:03], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:03' WHERE id= '158';
[11/28/2023 06:43:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:43:03',login_attempt=0 where id = '7865';
[11/28/2023 06:43:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:43:03', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:43:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:03' WHERE id= '158';
[11/28/2023 06:43:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:21' WHERE id= '158';
[11/28/2023 06:43:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:21' WHERE id= '158';
[11/28/2023 06:43:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:33' WHERE id= '158';
[11/28/2023 06:43:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/03/05' , departure_date = '2024/03/06' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-28 06:43:33' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 06:43:34], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:34' WHERE id= '158';
[11/28/2023 06:43:35], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_43_34_1701153814_53.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_43_34_1701153814_53.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_43_34_1701153814_53.json', 'expedia', '2023-11-28 06:43:35', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:43:35], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_43_34_1701153814_58.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_43_34_1701153814_58.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_43_34_1701153814_58.json', 'expedia', '2023-11-28 06:43:35', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:43:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:43:34.564'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.783'
            , error_description = ''
            , memory_used = '14580008'
            WHERE id = '14777';
[11/28/2023 06:43:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:43:34.563'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.032'
            , error_description = ''
            , memory_used = '32646960'
            WHERE id = '14778';
[11/28/2023 06:43:35], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_43_34_1701153814_41.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_43_34_1701153814_41.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_43_34_1701153814_41.json', 'expediapackage', '2023-11-28 06:43:35', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:43:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:43:34.564'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.206'
            , error_description = ''
            , memory_used = '14819320'
            WHERE id = '14779';
[11/28/2023 06:43:35], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_43_34_1701153814_36.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_43_34_1701153814_36.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_43_34_1701153814_36.json', 'expediapackage', '2023-11-28 06:43:35', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:43:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:43:34.564'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.559'
            , error_description = ''
            , memory_used = '33425104'
            WHERE id = '14780';
[11/28/2023 06:43:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:36' WHERE id= '158';
[11/28/2023 06:43:45], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:45' WHERE id= '158';
[11/28/2023 06:43:45], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:45' WHERE id= '158';
[11/28/2023 06:43:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701153825','43.239.53.130');
[11/28/2023 06:43:45], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_06_43_45_1701153825_50.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_06_43_45_1701153825_50.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_06_43_45_1701153825_50.json', 'expediapackage', '2023-11-28 06:43:45', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:43:52], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:43:52' WHERE id= '158';
[11/28/2023 06:44:06], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:44:06' WHERE id= '158';
[11/28/2023 06:44:06], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701153846','43.239.53.130');
[11/28/2023 06:44:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:44:06' WHERE id= '158';
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1022', create_date = '2023-11-28 06:44:07', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '19.71', display_currency_code = 'USD', native_room_rate = '19.71', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/03/05', check_out_date = '2024/03/06', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestS', leader_last_name = 'Demo', status_date = '2023-11-28 06:44:07';
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('98','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='98'
		;
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('98','1022','','1','1','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/03/05','2024/03/06','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '98', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.710000000000001;s:25:"displayNightlyRateDisplay";s:154:"Rate - 19.71,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.58 USD, Marketing Fee - 1.58  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:19.809999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.710000000000001;}}', native_room_rate_total = '19.71', wh_room_rate_total = '19.81', display_room_rate_total = '19.71', number_of_rooms = '1';
[11/28/2023 06:44:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '98', booking_detail_id = '1', rid = '107', room = '0', salutations = 'Mr', first_name = 'TestS', last_name = 'Demo', passenger_type = 'adult', age = '';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Baysan_Tourism_wh_06_44_07_1701153847_57.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_06_44_07_1701153847_57.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_06_44_07_1701153847_57.json', 'expediapackage', '2023-11-28 06:44:08', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7979899191156', confirmation_number = '7979899191156', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-03-03<br>If you cancel between 2024-03-03 12:30:00 and 2024-03-05 00:00:00 , you will be charged 19.81 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 3rd of March 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-03-03 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='19.81',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='19.71',  applicable_service_tax='0',  supplier_rate='19.71',  uid='e4a9a426f0446ccd612f0d270e71184d'  where id='98';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='98';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('98','18.95112099','72.83793084');
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 06:44:08',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;98\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -98 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='332', `entity`='BookingId', `value`='98' ;
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1022','98','confirmed','2023-11-28 06:44:08','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('98','2024-03-03 12:30:00','2024-03-03 12:30:00','2024-03-05 00:00:00','2024-03-05 00:00:00','19.71','19.81','0','2023-11-28 06:44:08','19.81');
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='98',status='1' where reservation_id='1022' and booking_id ='0';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='98' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 06:44:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.58',  commission_tax='',  booking_id ='98',  supplier_tax='2.15',  supplier_base_fare='17.56',  supplier_commissionable_fare='1.58'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 06:44:08';
[11/28/2023 06:47:43], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:43' WHERE id= '158';
[11/28/2023 06:47:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:47:43',login_attempt=0 where id = '7865';
[11/28/2023 06:47:43], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 06:47:43', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:47:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:43' WHERE id= '158';
[11/28/2023 06:47:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:48' WHERE id= '158';
[11/28/2023 06:47:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:48' WHERE id= '158';
[11/28/2023 06:47:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:49' WHERE id= '158';
[11/28/2023 06:47:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:50' WHERE id= '158';
[11/28/2023 06:47:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:56' WHERE id= '158';
[11/28/2023 06:47:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/11' , departure_date = '2024/01/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 06:47:56' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 06:47:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:56' WHERE id= '158';
[11/28/2023 06:47:57], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_47_56_1701154076_63.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_47_56_1701154076_63.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_47_56_1701154076_63.json', 'expedia', '2023-11-28 06:47:57', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:47:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:47:56.973'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.870'
            , error_description = ''
            , memory_used = '14572680'
            WHERE id = '14783';
[11/28/2023 06:47:57], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_06_47_56_1701154076_50.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_06_47_56_1701154076_50.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_47_56_1701154076_50.json', 'expedia', '2023-11-28 06:47:57', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:47:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:47:56.973'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.137'
            , error_description = ''
            , memory_used = '31175688'
            WHERE id = '14784';
[11/28/2023 06:47:58], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_47_56_1701154076_7.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_47_56_1701154076_7.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_47_56_1701154076_7.json', 'expediapackage', '2023-11-28 06:47:58', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:47:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:47:56.973'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.342'
            , error_description = ''
            , memory_used = '14578536'
            WHERE id = '14785';
[11/28/2023 06:47:58], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_06_47_56_1701154076_9.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_06_47_56_1701154076_9.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_06_47_56_1701154076_9.json', 'expediapackage', '2023-11-28 06:47:58', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:47:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:47:56.973'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.711'
            , error_description = ''
            , memory_used = '32596664'
            WHERE id = '14786';
[11/28/2023 06:47:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:47:59' WHERE id= '158';
[11/28/2023 06:48:05], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:48:05' WHERE id= '158';
[11/28/2023 06:48:06], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:48:06' WHERE id= '158';
[11/28/2023 06:48:06], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701154086','43.239.53.130');
[11/28/2023 06:48:07], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_06_48_06_1701154086_42.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_06_48_06_1701154086_42.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_06_48_06_1701154086_42.json', 'expediapackage', '2023-11-28 06:48:07', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:48:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:48:13' WHERE id= '158';
[11/28/2023 06:48:29], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:48:29' WHERE id= '158';
[11/28/2023 06:48:29], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701154109','43.239.53.130');
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:48:30' WHERE id= '158';
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1024', create_date = '2023-11-28 06:48:30', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '21.52', display_currency_code = 'USD', native_room_rate = '21.52', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/11', check_out_date = '2024/01/12', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestQ', leader_last_name = 'demo', status_date = '2023-11-28 06:48:30';
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('99','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='99'
		;
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('99','1024','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/11','2024/01/12','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '99', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:21.52;s:25:"displayNightlyRateDisplay";s:154:"Rate - 21.52,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.74 USD, Marketing Fee - 1.74  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:21.629999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.52;}}', native_room_rate_total = '21.52', wh_room_rate_total = '21.63', display_room_rate_total = '21.52', number_of_rooms = '1';
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '99', booking_detail_id = '1', rid = '108', room = '0', salutations = 'Mr', first_name = 'TestQ', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 06:48:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '99', booking_detail_id = '1', rid = '108', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Baysan_Tourism_wh_06_48_30_1701154110_62.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_06_48_30_1701154110_62.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_06_48_30_1701154110_62.json', 'expediapackage', '2023-11-28 06:48:31', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7410807406641', confirmation_number = '7410807406641', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-09<br>If you cancel between 2024-01-09 12:30:00 and 2024-01-11 00:00:00 , you will be charged 21.63 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 9th of January 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-01-09 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='21.63',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='21.52',  applicable_service_tax='0',  supplier_rate='21.52',  uid='5e635e2a2513105998e997899075c0f4'  where id='99';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='99';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('99','19.0727','72.8561');
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 06:48:31',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;99\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -99 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='333', `entity`='BookingId', `value`='99' ;
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1024','99','confirmed','2023-11-28 06:48:31','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('99','2024-01-09 12:30:00','2024-01-09 12:30:00','2024-01-11 00:00:00','2024-01-11 00:00:00','21.52','21.63','0','2023-11-28 06:48:31','21.63');
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='99',status='1' where reservation_id='1024' and booking_id ='0';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='99' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 06:48:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.74',  commission_tax='',  booking_id ='99',  supplier_tax='2.35',  supplier_base_fare='19.17',  supplier_commissionable_fare='1.74'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 06:48:31';
[11/28/2023 06:49:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 06:49:10',login_attempt=0 where id = '7857';
[11/28/2023 06:49:10], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-28 06:49:10', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 06:49:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:10' WHERE id= '160';
[11/28/2023 06:49:15], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:15' WHERE id= '160';
[11/28/2023 06:49:15], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:15' WHERE id= '160';
[11/28/2023 06:49:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:24' WHERE id= '160';
[11/28/2023 06:49:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/11' , departure_date = '2024/01/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 06:49:24' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 06:49:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:24' WHERE id= '160';
[11/28/2023 06:49:25], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Deepak_T_06_49_24_1701154164_31.json', 'e1/28_11_2023/response_availability_Deepak_T_06_49_24_1701154164_31.json', 'e1/28_11_2023/response_header_availability_Deepak_T_06_49_24_1701154164_31.json', 'expedia', '2023-11-28 06:49:25', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:49:24.937'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.767'
            , error_description = ''
            , memory_used = '14266664'
            WHERE id = '14789';
[11/28/2023 06:49:25], [file name :-/home/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)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Deepak_T_06_49_24_1701154164_40.json', 'e1/28_11_2023/response_availability_Deepak_T_06_49_24_1701154164_40.json', 'e1/28_11_2023/response_header_availability_Deepak_T_06_49_24_1701154164_40.json', 'expedia', '2023-11-28 06:49:25', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:25], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Deepak_T_06_49_24_1701154164_68.json', 'e1p/28_11_2023/response_availability_Deepak_T_06_49_24_1701154164_68.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_06_49_24_1701154164_68.json', 'expediapackage', '2023-11-28 06:49:25', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:49:24.937'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.104'
            , error_description = ''
            , memory_used = '14423336'
            WHERE id = '14791';
[11/28/2023 06:49:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:49:24.937'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.195'
            , error_description = ''
            , memory_used = '31155368'
            WHERE id = '14790';
[11/28/2023 06:49:26], [file name :-/home/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)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Deepak_T_06_49_24_1701154164_41.json', 'e1p/28_11_2023/response_availability_Deepak_T_06_49_24_1701154164_41.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_06_49_24_1701154164_41.json', 'expediapackage', '2023-11-28 06:49:26', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 06:49:24.937'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.777'
            , error_description = ''
            , memory_used = '32575032'
            WHERE id = '14792';
[11/28/2023 06:49:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:27' WHERE id= '160';
[11/28/2023 06:49:28], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:28' WHERE id= '160';
[11/28/2023 06:49:34], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:34' WHERE id= '160';
[11/28/2023 06:49:34], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:34' WHERE id= '160';
[11/28/2023 06:49:34], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701154174','43.239.53.130');
[11/28/2023 06:49:35], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Deepak_T_06_49_34_1701154174_4.json', 'e1p/28_11_2023/response_valuation_Deepak_T_06_49_34_1701154174_4.json', 'e1p/28_11_2023/response_header_valuation_Deepak_T_06_49_34_1701154174_4.json', 'expediapackage', '2023-11-28 06:49:35', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:42' WHERE id= '160';
[11/28/2023 06:49:51], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:51' WHERE id= '160';
[11/28/2023 06:49:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701154191','43.239.53.130');
[11/28/2023 06:49:51], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 06:49:51' WHERE id= '160';
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1026', create_date = '2023-11-28 06:49:52', agent_id = '7857', parent_agent_id = '7857', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '49.04', display_currency_code = 'USD', native_room_rate = '21.52', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/11', check_out_date = '2024/01/12', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2023-11-28 06:49:52';
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='100'
		;
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('100','1026','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/11','2024/01/12','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '100', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:49.039999999999999;s:25:"displayNightlyRateDisplay";s:203:"Rate - 21.52, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.74 USD, Marketing Fee - 1.74  USD #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.52;}}', native_room_rate_total = '21.52', display_room_rate_total = '49.04', number_of_rooms = '1', room_category = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', meal_basis = 'Room Only';
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '100', booking_detail_id = '1', rid = '109', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[11/28/2023 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '100', booking_detail_id = '1', rid = '109', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Deepak_T_06_49_52_1701154192_33.json', 'e1p/28_11_2023/response_reservation_Deepak_T_06_49_52_1701154192_33.json', 'e1p/28_11_2023/response_header_reservation_Deepak_T_06_49_52_1701154192_33.json', 'expediapackage', '2023-11-28 06:49:53', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7705111963849', confirmation_number = '7705111963849', display_discount = '0', cancellation_policy = 'Free cancellation up to  15:29:59 on  2024-01-09<br>If you cancel between 2024-01-09 15:30:00 and 2024-01-11 00:00:00 , you will be charged 49.04 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 15:30 on 9th of January 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-01-09 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'b2btravel', sales_manager_id = '0', admin_booked = '0', email_id = 'bhavesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='127.88',  agent_markup='127.88',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='49.04',  applicable_service_tax='0',  supplier_rate='21.52',  uid='5dbd82ada24f0fffeb635a17f5e066d1'  where id='100';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='100';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('100','19.08418','72.8796');
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-28 06:49:53',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;100\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -100 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='334', `entity`='BookingId', `value`='100' ;
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1026','100','confirmed','2023-11-28 06:49:53','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('100','2024-01-09 15:30:00','2024-01-09 15:30:00','2024-01-11 00:00:00','2024-01-11 00:00:00','21.52','49.04','0','2023-11-28 06:49:53','49.04');
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='100',status='1' where reservation_id='1026' and booking_id ='0';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='100' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.74',  commission_tax='',  booking_id ='100',  supplier_tax='2.35',  supplier_base_fare='19.17',  supplier_commissionable_fare='1.74'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 06:49:53';
