[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '7' ,lead_time = '876',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '66' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[11/27/2023 12:15:48], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-11-27 12:15:48',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;876\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#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-7857 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7857 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7857 ## supplier_id- 69 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[11/27/2023 12:16:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:31' WHERE id= '154';
[11/27/2023 12:16:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:16:32',login_attempt=0 where id = '7857';
[11/27/2023 12:16:32], [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-27 12:16:32', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:16:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:32' WHERE id= '154';
[11/27/2023 12:16:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:41' WHERE id= '154';
[11/27/2023 12:16:46], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:46' WHERE id= '154';
[11/27/2023 12:16:52], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:52' WHERE id= '154';
[11/27/2023 12:16:55], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:16:55' WHERE id= '154';
[11/27/2023 12:17:06], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:06' WHERE id= '154';
[11/27/2023 12:17:06], [file name :-/home/otrams/public_html/beta/m1_flight_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' , service_type = 'Airline' , arrival_date = '2023/12/10' , departure_date = '2023/12/11' , create_date = '2023-11-27 :12:17:06' , origin = 'DXB' , destination = 'SIN' , site_id = '' ;
[11/27/2023 12:17:07], [file name :-/home/otrams/public_html/beta/flight_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:07' WHERE id= '154';
[11/27/2023 12:17:12], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:12' WHERE id= '154';
[11/27/2023 12:17:17], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:17' WHERE id= '154';
[11/27/2023 12:17:22], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:22' WHERE id= '154';
[11/27/2023 12:17:23], [file name :-/home/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/home/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/27_11_2023/request_Availability_Deepak_T_12_17_23_1701087443.xml','amadeus','2023-11-27 12:17:23','129');
[11/27/2023 12:17:23], [file name :-/home/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/27_11_2023/response_Availability_Deepak_T_12_17_23_1701087443.xml','Amadeus','2023-11-27 12:17:23','129');
[11/27/2023 12:17:24], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:17:24' WHERE id= '154';
[11/27/2023 12:32:11], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:32:11',login_attempt=0 where id = '7865';
[11/27/2023 12:32:11], [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-27 12:32:11', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:32:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58',create_date='2023-11-27 12:32:12', update_date='2023-11-27 12:32:12',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/27/2023 12:32:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:38' WHERE id= '155';
[11/27/2023 12:32:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:39' WHERE id= '155';
[11/27/2023 12:32:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:41' WHERE id= '155';
[11/27/2023 12:32:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:49' WHERE id= '155';
[11/27/2023 12:32:49], [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/12' , departure_date = '2024/01/16' , nights = '4' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-27 12:32:49' , 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/27/2023 12:32:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:49' WHERE id= '155';
[11/27/2023 12:32:51], [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/27_11_2023/request_availability_Baysan_Tourism_wh_12_32_50_1701088370_9.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_12_32_50_1701088370_9.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_32_50_1701088370_9.json', 'expedia', '2023-11-27 12:32:51', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:32:51], [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/27_11_2023/request_availability_Baysan_Tourism_wh_12_32_50_1701088370_74.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_12_32_50_1701088370_74.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_32_50_1701088370_74.json', 'expedia', '2023-11-27 12:32:51', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:32:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:32:50.608'
            , 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 = '15966552'
            WHERE id = '14563';
[11/27/2023 12:32:51], [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/27_11_2023/request_availability_Baysan_Tourism_wh_12_32_50_1701088370_7.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_12_32_50_1701088370_7.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_32_50_1701088370_7.json', 'expediapackage', '2023-11-27 12:32:51', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:32:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:32:50.609'
            , 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.178'
            , error_description = ''
            , memory_used = '15882976'
            WHERE id = '14565';
[11/27/2023 12:32:51], [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/27_11_2023/request_availability_Baysan_Tourism_wh_12_32_50_1701088370_10.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_12_32_50_1701088370_10.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_32_50_1701088370_10.json', 'expediapackage', '2023-11-27 12:32:51', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:32:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:32:50.608'
            , 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.242'
            , error_description = ''
            , memory_used = '35374064'
            WHERE id = '14564';
[11/27/2023 12:32:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:32:50.608'
            , 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.512'
            , error_description = ''
            , memory_used = '37740144'
            WHERE id = '14566';
[11/27/2023 12:32:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:32:52' WHERE id= '155';
[11/27/2023 12:33:38], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:38' WHERE id= '155';
[11/27/2023 12:33:39], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:39' WHERE id= '155';
[11/27/2023 12:33:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088419','43.239.53.130');
[11/27/2023 12:33:39], [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', 'e1/27_11_2023/request_valuation_Baysan_Tourism_wh_12_33_39_1701088419_88.json', 'e1/27_11_2023/response_valuation_Baysan_Tourism_wh_12_33_39_1701088419_88.json', 'e1/27_11_2023/response_header_valuation_Baysan_Tourism_wh_12_33_39_1701088419_88.json', 'expedia', '2023-11-27 12:33:39', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:33:48], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:48' WHERE id= '155';
[11/27/2023 12:33:48], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:48' WHERE id= '155';
[11/27/2023 12:33:48], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088428','43.239.53.130');
[11/27/2023 12:33:49], [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/27_11_2023/request_valuation_Baysan_Tourism_wh_12_33_48_1701088428_29.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_12_33_48_1701088428_29.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_12_33_48_1701088428_29.json', 'expediapackage', '2023-11-27 12:33:49', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:33:51], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:51' WHERE id= '155';
[11/27/2023 12:33:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:33:52' WHERE id= '155';
[11/27/2023 12:33:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088432','43.239.53.130');
[11/27/2023 12:33:52], [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/27_11_2023/request_valuation_Baysan_Tourism_wh_12_33_52_1701088432_80.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_12_33_52_1701088432_80.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_12_33_52_1701088432_80.json', 'expediapackage', '2023-11-27 12:33:52', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:34:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:34:01' WHERE id= '155';
[11/27/2023 12:34:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:34:01' WHERE id= '155';
[11/27/2023 12:34:33], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:34:33' WHERE id= '155';
[11/27/2023 12:34:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088473','43.239.53.130');
[11/27/2023 12:34:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:34:36' WHERE id= '155';
[11/27/2023 12:34:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '979', create_date = '2023-11-27 12:34:37', 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 = '91.19', display_currency_code = 'USD', native_room_rate = '91.19', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/12', check_out_date = '2024/01/16', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestA', leader_last_name = 'demo', status_date = '2023-11-27 12:34:37';
[11/27/2023 12:34:37], [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 ('83','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/27/2023 12:34:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='83'
		;
[11/27/2023 12:34:37], [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('83','979','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','4','2024/01/12','2024/01/16','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/27/2023 12:34:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '83', 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:4:{i:0;a:3:{s:18:"displayNightlyRate";d:22.789999999999999;s:25:"displayNightlyRateDisplay";s:158:"Rate - 22.79,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.3725 USD, Marketing Fee - 2.3725  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.899999999999999;}i:1;a:3:{s:18:"displayNightlyRate";d:22.789999999999999;s:25:"displayNightlyRateDisplay";s:158:"Rate - 22.79,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.3725 USD, Marketing Fee - 2.3725  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.899999999999999;}i:2;a:3:{s:18:"displayNightlyRate";d:22.789999999999999;s:25:"displayNightlyRateDisplay";s:158:"Rate - 22.79,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.3725 USD, Marketing Fee - 2.3725  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.899999999999999;}i:3;a:3:{s:18:"displayNightlyRate";d:22.82;s:25:"displayNightlyRateDisplay";s:158:"Rate - 22.82,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.3725 USD, Marketing Fee - 2.3725  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.93;}}', native_nightly_rates = 'a:4:{i:0;a:1:{s:17:"nativeNightlyRate";d:22.789999999999999;}i:1;a:1:{s:17:"nativeNightlyRate";d:22.789999999999999;}i:2;a:1:{s:17:"nativeNightlyRate";d:22.789999999999999;}i:3;a:1:{s:17:"nativeNightlyRate";d:22.82;}}', native_room_rate_total = '91.19', wh_room_rate_total = '91.63', display_room_rate_total = '91.19', number_of_rooms = '1';
[11/27/2023 12:34:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '83', booking_detail_id = '1', rid = '92', room = '0', salutations = 'Mr', first_name = 'TestA', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 12:34:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '83', booking_detail_id = '1', rid = '92', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/27/2023 12:34:38], [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/27_11_2023/request_reservation_Baysan_Tourism_wh_12_34_37_1701088477_31.json', 'e1p/27_11_2023/response_reservation_Baysan_Tourism_wh_12_34_37_1701088477_31.json', 'e1p/27_11_2023/response_header_reservation_Baysan_Tourism_wh_12_34_37_1701088477_31.json', 'expediapackage', '2023-11-27 12:34:38', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7142912075802', confirmation_number = '7142912075802', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-10<br>If you cancel between 2024-01-10 12:30:00 and 2024-01-12 00:00:00 , you will be charged 22.9 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 10th 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-10 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='91.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='91.19',  applicable_service_tax='0',  supplier_rate='91.19',  uid='1a5aae54788a05c5c7a5b88cb743b0cf'  where id='83';
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='83';
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('83','19.0727','72.8561');
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-27 12:34:38',`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;83\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -83 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='316', `entity`='BookingId', `value`='83' ;
[11/27/2023 12:34:38], [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 ('979','83','confirmed','2023-11-27 12:34:38','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/27/2023 12:34:38], [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('83','2024-01-10 12:30:00','2024-01-10 12:30:00','2024-01-12 00:00:00','2024-01-12 00:00:00','22.79','22.9','0','2023-11-27 12:34:38','22.9');
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='83',status='1' where reservation_id='979' and booking_id ='0';
[11/27/2023 12:34:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='83' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 12:34:39], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='9.49',  commission_tax='',  booking_id ='83',  supplier_tax='9.52',  supplier_base_fare='81.67',  supplier_commissionable_fare='9.49'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 12:34:39';
[11/27/2023 12:35:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:35:45' WHERE id= '155';
[11/27/2023 12:35:54], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:35:54',login_attempt=0 where id = '7865';
[11/27/2023 12:35:54], [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-27 12:35:54', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:35:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7852', session_id='deb8bb09c4cca0fd0521d474c1c4f37ad18fff689fc9161d273c55b93e87f2ed',create_date='2023-11-27 12:35:55', update_date='2023-11-27 12:35:55',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/27/2023 12:36:35], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:36:35' WHERE id= '156';
[11/27/2023 12:36:35], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:36:35',login_attempt=0 where id = '7865';
[11/27/2023 12:36:35], [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-27 12:36:35', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:36:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:36:35' WHERE id= '156';
[11/27/2023 12:36:59], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2023-11-27 12:36:59' , ip = '43.239.53.130' , action = 'Logout'  ;
[11/27/2023 12:38:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:38:58',login_attempt=0 where id = '7857';
[11/27/2023 12:38:58], [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-27 12:38:58', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:38:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7857', session_id='9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc',create_date='2023-11-27 12:38:58', update_date='2023-11-27 12:38:58',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/27/2023 12:39:19], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:39:19' WHERE id= '157';
[11/27/2023 12:39:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:39:50' WHERE id= '157';
[11/27/2023 12:39:50], [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/12' , departure_date = '2024/01/16' , nights = '4' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-27 12:39:50' , 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/27/2023 12:39:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:39:51' WHERE id= '157';
[11/27/2023 12:39:52], [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/27_11_2023/request_availability_Deepak_T_12_39_51_1701088791_52.json', 'e1/27_11_2023/response_availability_Deepak_T_12_39_51_1701088791_52.json', 'e1/27_11_2023/response_header_availability_Deepak_T_12_39_51_1701088791_52.json', 'expedia', '2023-11-27 12:39:52', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:39:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:39:51.981'
            , 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.719'
            , error_description = ''
            , memory_used = '15650680'
            WHERE id = '14572';
[11/27/2023 12:39:52], [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/27_11_2023/request_availability_Deepak_T_12_39_51_1701088791_87.json', 'e1/27_11_2023/response_availability_Deepak_T_12_39_51_1701088791_87.json', 'e1/27_11_2023/response_header_availability_Deepak_T_12_39_51_1701088791_87.json', 'expedia', '2023-11-27 12:39:52', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:39:52], [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/27_11_2023/request_availability_Deepak_T_12_39_51_1701088791_13.json', 'e1p/27_11_2023/response_availability_Deepak_T_12_39_51_1701088791_13.json', 'e1p/27_11_2023/response_header_availability_Deepak_T_12_39_51_1701088791_13.json', 'expediapackage', '2023-11-27 12:39:52', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:39:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:39:51.981'
            , 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.070'
            , error_description = ''
            , memory_used = '15660336'
            WHERE id = '14574';
[11/27/2023 12:39:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:39:51.981'
            , 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.084'
            , error_description = ''
            , memory_used = '36339392'
            WHERE id = '14573';
[11/27/2023 12:39:53], [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/27_11_2023/request_availability_Deepak_T_12_39_51_1701088791_93.json', 'e1p/27_11_2023/response_availability_Deepak_T_12_39_51_1701088791_93.json', 'e1p/27_11_2023/response_header_availability_Deepak_T_12_39_51_1701088791_93.json', 'expediapackage', '2023-11-27 12:39:53', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:39:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:39:51.981'
            , 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.976'
            , error_description = ''
            , memory_used = '38719368'
            WHERE id = '14575';
[11/27/2023 12:39:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:39:54' WHERE id= '157';
[11/27/2023 12:39:58], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:39:58' WHERE id= '157';
[11/27/2023 12:40:30], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:40:30' WHERE id= '157';
[11/27/2023 12:40:30], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:40:30' WHERE id= '157';
[11/27/2023 12:40:30], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088830','43.239.53.130');
[11/27/2023 12:40:31], [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/27_11_2023/request_valuation_Deepak_T_12_40_30_1701088830_44.json', 'e1p/27_11_2023/response_valuation_Deepak_T_12_40_30_1701088830_44.json', 'e1p/27_11_2023/response_header_valuation_Deepak_T_12_40_30_1701088830_44.json', 'expediapackage', '2023-11-27 12:40:31', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:40:31], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Nirmal Lodging', 'mumbai', '106', '7857', '', '28', '', 'hotelcancellationpolicy', '2023-11-27 :12:40:31','');
[11/27/2023 12:40:33], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:40:33' WHERE id= '157';
[11/27/2023 12:40:33], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:40:33' WHERE id= '157';
[11/27/2023 12:40:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088833','43.239.53.130');
[11/27/2023 12:40:34], [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/27_11_2023/request_valuation_Deepak_T_12_40_33_1701088833_21.json', 'e1p/27_11_2023/response_valuation_Deepak_T_12_40_33_1701088833_21.json', 'e1p/27_11_2023/response_header_valuation_Deepak_T_12_40_33_1701088833_21.json', 'expediapackage', '2023-11-27 12:40:34', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:41:13], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:41:13' WHERE id= '155';
[11/27/2023 12:41:13], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:41:13' WHERE id= '155';
[11/27/2023 12:41:13], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088873','43.239.53.130');
[11/27/2023 12:41:14], [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/27_11_2023/request_valuation_Baysan_Tourism_wh_12_41_13_1701088873_45.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_12_41_13_1701088873_45.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_12_41_13_1701088873_45.json', 'expediapackage', '2023-11-27 12:41:14', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:42:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:42:52' WHERE id= '157';
[11/27/2023 12:42:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701088972','43.239.53.130');
[11/27/2023 12:42:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:42:53' WHERE id= '157';
[11/27/2023 12:42:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '982', create_date = '2023-11-27 12:42:54', 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 = '196.78', display_currency_code = 'USD', native_room_rate = '86.66', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/12', check_out_date = '2024/01/16', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestA', leader_last_name = 'demo', status_date = '2023-11-27 12:42:54';
[11/27/2023 12:42:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='84'
		;
[11/27/2023 12:42:54], [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('84','982','','1','1','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','4','2024/01/12','2024/01/16','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/27/2023 12:42:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '84', booking_detail_id = '1', room_type_code = '', room_name = 'single', 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:4:{i:0;a:2:{s:18:"displayNightlyRate";d:49.189999999999998;s:25:"displayNightlyRateDisplay";s:207:"Rate - 21.66, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 2.2575 USD, Marketing Fee - 2.2575  USD #expediapackage";}i:1;a:2:{s:18:"displayNightlyRate";d:49.189999999999998;s:25:"displayNightlyRateDisplay";s:207:"Rate - 21.66, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 2.2575 USD, Marketing Fee - 2.2575  USD #expediapackage";}i:2;a:2:{s:18:"displayNightlyRate";d:49.189999999999998;s:25:"displayNightlyRateDisplay";s:207:"Rate - 21.66, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 2.2575 USD, Marketing Fee - 2.2575  USD #expediapackage";}i:3;a:2:{s:18:"displayNightlyRate";d:49.210000000000001;s:25:"displayNightlyRateDisplay";s:207:"Rate - 21.68, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 2.2575 USD, Marketing Fee - 2.2575  USD #expediapackage";}}', native_nightly_rates = 'a:4:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.66;}i:1;a:1:{s:17:"nativeNightlyRate";d:21.66;}i:2;a:1:{s:17:"nativeNightlyRate";d:21.66;}i:3;a:1:{s:17:"nativeNightlyRate";d:21.68;}}', native_room_rate_total = '86.66', display_room_rate_total = '196.78', 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/27/2023 12:42:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '84', booking_detail_id = '1', rid = '93', room = '0', salutations = 'Mr', first_name = 'TestA', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 12:42:55], [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/27_11_2023/request_reservation_Deepak_T_12_42_54_1701088974_51.json', 'e1p/27_11_2023/response_reservation_Deepak_T_12_42_54_1701088974_51.json', 'e1p/27_11_2023/response_header_reservation_Deepak_T_12_42_54_1701088974_51.json', 'expediapackage', '2023-11-27 12:42:55', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7283847044304', confirmation_number = '7283847044304', display_discount = '0', cancellation_policy = 'Free cancellation up to  15:29:59 on  2024-01-10<br>If you cancel between 2024-01-10 15:30:00 and 2024-01-12 00:00:00 , you will be charged 49.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 15:30 on 10th 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-10 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.07',  agent_markup='127.07',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='196.78',  applicable_service_tax='0',  supplier_rate='86.66',  uid='cd14ab7bc968a37fccdd0d418d76a290'  where id='84';
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='84';
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('84','19.08418','72.8796');
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-27 12:42:55',`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;84\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -84 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='317', `entity`='BookingId', `value`='84' ;
[11/27/2023 12:42:55], [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 ('982','84','confirmed','2023-11-27 12:42:55','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/27/2023 12:42:55], [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('84','2024-01-10 15:30:00','2024-01-10 15:30:00','2024-01-12 00:00:00','2024-01-12 00:00:00','21.66','49.18','0','2023-11-27 12:42:55','49.18');
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='84',status='1' where reservation_id='982' and booking_id ='0';
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='84' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 12:42:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='9.03',  commission_tax='',  booking_id ='84',  supplier_tax='9.08',  supplier_base_fare='77.58',  supplier_commissionable_fare='9.03'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 12:42:55';
[11/27/2023 12:43:29], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:43:29' WHERE id= '155';
[11/27/2023 12:43:43], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:43:43' WHERE id= '155';
[11/27/2023 12:43:43], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701089023','43.239.53.130');
[11/27/2023 12:43:43], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:43:43' WHERE id= '155';
[11/27/2023 12:43:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:43:54' WHERE id= '155';
[11/27/2023 12:48:11], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:11' WHERE id= '155';
[11/27/2023 12:48:11], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:48:11',login_attempt=0 where id = '7865';
[11/27/2023 12:48:11], [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-27 12:48:11', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:48:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:12' WHERE id= '155';
[11/27/2023 12:48:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:18' WHERE id= '155';
[11/27/2023 12:48:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:24' WHERE id= '155';
[11/27/2023 12:48:24], [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/05' , departure_date = '2024/01/06' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-27 12:48:24' , 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/27/2023 12:48:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:24' WHERE id= '155';
[11/27/2023 12:48: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/27_11_2023/request_availability_Baysan_Tourism_wh_12_48_24_1701089304_32.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_12_48_24_1701089304_32.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_48_24_1701089304_32.json', 'expedia', '2023-11-27 12:48:25', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:48: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/27_11_2023/request_availability_Baysan_Tourism_wh_12_48_24_1701089304_65.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_12_48_24_1701089304_65.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_48_24_1701089304_65.json', 'expedia', '2023-11-27 12:48:25', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:48:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:48: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.879'
            , error_description = ''
            , memory_used = '14309864'
            WHERE id = '14581';
[11/27/2023 12:48: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/27_11_2023/request_availability_Baysan_Tourism_wh_12_48_24_1701089304_29.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_12_48_24_1701089304_29.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_48_24_1701089304_29.json', 'expediapackage', '2023-11-27 12:48:26', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:48:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:48: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.123'
            , error_description = ''
            , memory_used = '29979392'
            WHERE id = '14582';
[11/27/2023 12:48:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:48: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.199'
            , error_description = ''
            , memory_used = '14151920'
            WHERE id = '14583';
[11/27/2023 12:48: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/27_11_2023/request_availability_Baysan_Tourism_wh_12_48_24_1701089304_28.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_12_48_24_1701089304_28.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_12_48_24_1701089304_28.json', 'expediapackage', '2023-11-27 12:48:26', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:48:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&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-27 12:48: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.656'
            , error_description = ''
            , memory_used = '31347808'
            WHERE id = '14584';
[11/27/2023 12:48:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:27' WHERE id= '155';
[11/27/2023 12:48:43], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:43' WHERE id= '157';
[11/27/2023 12:48:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:48:43',login_attempt=0 where id = '7857';
[11/27/2023 12:48:43], [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-27 12:48:43', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:48:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:43' WHERE id= '157';
[11/27/2023 12:48:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:48:49' WHERE id= '157';
[11/27/2023 12:49:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:00' WHERE id= '157';
[11/27/2023 12:49:00], [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/05' , departure_date = '2024/01/06' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-27 12:49:00' , 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/27/2023 12:49:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:01' WHERE id= '157';
[11/27/2023 12:49:02], [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/27_11_2023/request_availability_Deepak_T_12_49_01_1701089341_32.json', 'e1/27_11_2023/response_availability_Deepak_T_12_49_01_1701089341_32.json', 'e1/27_11_2023/response_header_availability_Deepak_T_12_49_01_1701089341_32.json', 'expedia', '2023-11-27 12:49:02', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:49:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:49:01.397'
            , 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.832'
            , error_description = ''
            , memory_used = '14398544'
            WHERE id = '14585';
[11/27/2023 12:49:02], [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/27_11_2023/request_availability_Deepak_T_12_49_01_1701089341_67.json', 'e1/27_11_2023/response_availability_Deepak_T_12_49_01_1701089341_67.json', 'e1/27_11_2023/response_header_availability_Deepak_T_12_49_01_1701089341_67.json', 'expedia', '2023-11-27 12:49:02', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:49:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:49:01.397'
            , 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.143'
            , error_description = ''
            , memory_used = '31062120'
            WHERE id = '14586';
[11/27/2023 12:49:02], [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/27_11_2023/request_availability_Deepak_T_12_49_01_1701089341_47.json', 'e1p/27_11_2023/response_availability_Deepak_T_12_49_01_1701089341_47.json', 'e1p/27_11_2023/response_header_availability_Deepak_T_12_49_01_1701089341_47.json', 'expediapackage', '2023-11-27 12:49:02', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:49:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:49:01.397'
            , 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.368'
            , error_description = ''
            , memory_used = '14573648'
            WHERE id = '14587';
[11/27/2023 12:49:03], [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/27_11_2023/request_availability_Deepak_T_12_49_01_1701089341_97.json', 'e1p/27_11_2023/response_availability_Deepak_T_12_49_01_1701089341_97.json', 'e1p/27_11_2023/response_header_availability_Deepak_T_12_49_01_1701089341_97.json', 'expediapackage', '2023-11-27 12:49:03', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:49:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc&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-27 12:49:01.397'
            , 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.972'
            , error_description = ''
            , memory_used = '32502840'
            WHERE id = '14588';
[11/27/2023 12:49:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:03' WHERE id= '157';
[11/27/2023 12:49:05], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:05' WHERE id= '157';
[11/27/2023 12:49:07], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:07' WHERE id= '155';
[11/27/2023 12:49:08], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:49:08' WHERE id= '155';
[11/27/2023 12:49:08], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701089348','43.239.53.130');
[11/27/2023 12:49:08], [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/27_11_2023/request_valuation_Baysan_Tourism_wh_12_49_08_1701089348_39.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_12_49_08_1701089348_39.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_12_49_08_1701089348_39.json', 'expediapackage', '2023-11-27 12:49:08', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 12:50:47], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:50:47' WHERE id= '155';
[11/27/2023 12:50:48], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:50:48' WHERE id= '155';
[11/27/2023 12:51:15], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:51:15' WHERE id= '157';
[11/27/2023 12:51:16], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:51:16' WHERE id= '157';
[11/27/2023 12:51:16], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701089476','43.239.53.130');
[11/27/2023 12:51:16], [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/27_11_2023/request_valuation_Deepak_T_12_51_16_1701089476_9.json', 'e1p/27_11_2023/response_valuation_Deepak_T_12_51_16_1701089476_9.json', 'e1p/27_11_2023/response_header_valuation_Deepak_T_12_51_16_1701089476_9.json', 'expediapackage', '2023-11-27 12:51:16', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:51:23], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:51:23' WHERE id= '157';
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:52:02' WHERE id= '157';
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701089522','43.239.53.130');
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:52:02' WHERE id= '157';
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '987', create_date = '2023-11-27 12:52:02', 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 = '48.09', display_currency_code = 'USD', native_room_rate = '20.6', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/05', check_out_date = '2024/01/06', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestAS', leader_last_name = 'Demo', status_date = '2023-11-27 12:52:02';
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='85'
		;
[11/27/2023 12:52:02], [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('85','987','','1','1','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/05','2024/01/06','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '85', booking_detail_id = '1', room_type_code = '', room_name = 'single', 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:48.090000000000003;s:25:"displayNightlyRateDisplay";s:202:"Rate - 20.6, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.73 USD, Marketing Fee - 1.73  USD #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:20.600000000000001;}}', native_room_rate_total = '20.6', display_room_rate_total = '48.09', 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/27/2023 12:52:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '85', booking_detail_id = '1', rid = '94', room = '0', salutations = 'Mr', first_name = 'TestAS', last_name = 'Demo', passenger_type = 'adult', age = '';
[11/27/2023 12:52:03], [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/27_11_2023/request_reservation_Deepak_T_12_52_02_1701089522_76.json', 'e1p/27_11_2023/response_reservation_Deepak_T_12_52_02_1701089522_76.json', 'e1p/27_11_2023/response_header_reservation_Deepak_T_12_52_02_1701089522_76.json', 'expediapackage', '2023-11-27 12:52:03', '', '9ae622dd4b88f4f3cb12cca2e6008958cc38b4ad30c9dc800ad47e41bdce90dc', '0');
[11/27/2023 12:52:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7732899477688', confirmation_number = '7732899477688', display_discount = '0', cancellation_policy = 'Free cancellation up to  15:29:59 on  2024-01-03<br>If you cancel between 2024-01-03 15:30:00 and 2024-01-05 00:00:00 , you will be charged 48.09 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 3rd 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-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> 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='133.45',  agent_markup='133.45',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='48.09',  applicable_service_tax='0',  supplier_rate='20.6',  uid='c8cd9e462f87a1ccae00ea77f2ec8a5a'  where id='85';
[11/27/2023 12:52:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='85';
[11/27/2023 12:52:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('85','19.08418','72.8796');
[11/27/2023 12:52:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-27 12:52:04',`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;85\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -85 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 12:52:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='318', `entity`='BookingId', `value`='85' ;
[11/27/2023 12:52:04], [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 ('987','85','confirmed','2023-11-27 12:52:03','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/27/2023 12:52:04], [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('85','2024-01-03 15:30:00','2024-01-03 15:30:00','2024-01-05 00:00:00','2024-01-05 00:00:00','20.6','48.09','0','2023-11-27 12:52:04','48.09');
[11/27/2023 12:52:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='85',status='1' where reservation_id='987' and booking_id ='0';
[11/27/2023 12:52:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='85' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 12:52:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.73',  commission_tax='',  booking_id ='85',  supplier_tax='2.24',  supplier_base_fare='18.36',  supplier_commissionable_fare='1.73'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 12:52:04';
[11/27/2023 12:52:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:52:31' WHERE id= '157';
[11/27/2023 12:52:41], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:52:41' WHERE id= '155';
[11/27/2023 12:52:41], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701089561','43.239.53.130');
[11/27/2023 12:52:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:52:42' WHERE id= '155';
[11/27/2023 12:54:43], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:54:43' WHERE id= '155';
[11/27/2023 12:55:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:55:11' WHERE id= '155';
[11/27/2023 12:55:28], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:55:28' WHERE id= '157';
[11/27/2023 12:58:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:58:09' WHERE id= '155';
[11/27/2023 12:58:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:58:31' WHERE id= '155';
[11/27/2023 12:58:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 12:58:31',login_attempt=0 where id = '7865';
[11/27/2023 12:58:31], [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-27 12:58:31', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 12:58:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 12:58:31' WHERE id= '155';
