[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 04:08:30], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-08 04:08:30',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-949 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/08/2024 04:09:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:09:47',login_attempt=0 where id = '949';
[07/08/2024 04:09:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:09:47', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:10:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/09' , departure_date = '2024/07/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:10:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:10:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_10_34_17204118343.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118343.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_10_34_17204118343.xml', 'jumbotours', '2024-07-08 04:10:35', '', '949082024070410338245678441', '12727120', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118343.xml');
[07/08/2024 04:10:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070410338245678441&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:10:34.598'
        , request_start_time = '0.050'
        , parsing_start_time = '0.979'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.128'
        , search_end_time = '0.000'
        , total_duration = '1.248'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '3528488'
        WHERE id = '157026090';
[07/08/2024 04:10:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_10_34_17204118341.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118341.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_10_34_17204118341.xml', 'jumbotours', '2024-07-08 04:10:36', '', '949082024070410338245678441', '12727120', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118341.xml');
[07/08/2024 04:10:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_10_34_17204118342.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118342.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_10_34_17204118342.xml', 'jumbotours', '2024-07-08 04:10:36', '', '949082024070410338245678441', '12727120', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118342.xml');
[07/08/2024 04:10:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070410338245678441&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:10:34.598'
        , request_start_time = '0.036'
        , parsing_start_time = '2.116'
        , mapping_complete_time = '0.130'
        , mongo_start_time = '0.263'
        , search_end_time = '0.000'
        , total_duration = '2.521'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '12700224'
        WHERE id = '157026091';
[07/08/2024 04:10:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070410338245678441&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:10:34.598'
        , request_start_time = '0.041'
        , parsing_start_time = '2.123'
        , mapping_complete_time = '0.173'
        , mongo_start_time = '0.324'
        , search_end_time = '0.000'
        , total_duration = '2.589'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '16335464'
        WHERE id = '157026092';
[07/08/2024 04:10:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_10_34_17204118340.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118340.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_10_34_17204118340.xml', 'jumbotours', '2024-07-08 04:10:37', '', '949082024070410338245678441', '12727120', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_10_34_17204118340.xml');
[07/08/2024 04:10:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070410338245678441&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:10:34.598'
        , request_start_time = '0.053'
        , parsing_start_time = '3.143'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.229'
        , search_end_time = '0.000'
        , total_duration = '3.513'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '10549456'
        WHERE id = '157026093';
[07/08/2024 04:10:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '139',
        request_path = '/xml_all.php?userid=949&sessionid=949082024070410338245678441',
        duration = '3.755',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.16',
        system_load_5_min = '1.22',
        system_load_15_min = '1.23',
        system_memory_usage = '20.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727120') + '2448008',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727120';
[07/08/2024 04:11:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:11:04',login_attempt=0 where id = '949';
[07/08/2024 04:11:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:11:04', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:11:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/25' , departure_date = '2024/07/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:11:35' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:11:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_11_36_17204118963.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118963.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_11_36_17204118963.xml', 'jumbotours', '2024-07-08 04:11:37', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118963.xml');
[07/08/2024 04:11:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704113536712169932&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:11:36.419'
        , request_start_time = '0.013'
        , parsing_start_time = '0.758'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.093'
        , search_end_time = '0.000'
        , total_duration = '0.968'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979848'
        WHERE id = '157026094';
[07/08/2024 04:11:38], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_11_36_17204118962.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118962.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_11_36_17204118962.xml', 'jumbotours', '2024-07-08 04:11:38', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118962.xml');
[07/08/2024 04:11:38], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_11_36_17204118960.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118960.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_11_36_17204118960.xml', 'jumbotours', '2024-07-08 04:11:38', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118960.xml');
[07/08/2024 04:11:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704113536712169932&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:11:36.419'
        , request_start_time = '0.024'
        , parsing_start_time = '1.897'
        , mapping_complete_time = '0.310'
        , mongo_start_time = '0.564'
        , search_end_time = '0.000'
        , total_duration = '2.577'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28264704'
        WHERE id = '157026095';
[07/08/2024 04:11:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704113536712169932&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:11:36.419'
        , request_start_time = '0.008'
        , parsing_start_time = '2.097'
        , mapping_complete_time = '0.330'
        , mongo_start_time = '0.603'
        , search_end_time = '0.000'
        , total_duration = '2.822'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '30222648'
        WHERE id = '157026096';
[07/08/2024 04:11:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_11_36_17204118961.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118961.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_11_36_17204118961.xml', 'jumbotours', '2024-07-08 04:11:40', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_11_36_17204118961.xml');
[07/08/2024 04:11:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704113536712169932&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:11:36.418'
        , request_start_time = '0.009'
        , parsing_start_time = '3.494'
        , mapping_complete_time = '0.361'
        , mongo_start_time = '0.655'
        , search_end_time = '0.000'
        , total_duration = '4.267'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33297280'
        WHERE id = '157026097';
[07/08/2024 04:11:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '202',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240704113536712169932',
        duration = '4.377',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.29',
        system_load_5_min = '1.25',
        system_load_15_min = '1.24',
        system_memory_usage = '19.92',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727121') + '2450552',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727121';
[07/08/2024 04:12:15], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720411935','43.239.53.130');
[07/08/2024 04:12:23], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_04_12_15_1720411935.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_04_12_15_1720411935.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_04_12_15_1720411935.xml', 'jumbotours', '2024-07-08 04:12:23', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_04_12_15_1720411935.xml');
[07/08/2024 04:13:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720412011','43.239.53.130');
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877179', create_date = '2024-07-08 04:13:32', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/25', check_out_date = '2024/07/26', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'supriya', leader_last_name = 'gangawane', status_date = '2024-07-08 04:13:32';
[07/08/2024 04:13:32], [file name :-/efsdata/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 ('132970','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132970'
		;
[07/08/2024 04:13:32], [file name :-/efsdata/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('132970','1877179','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/25','2024/07/26','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132970', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132970', booking_detail_id = '1', rid = '145733', room = '0', salutations = 'Mr', first_name = 'supriya', last_name = 'gangawane', passenger_type = 'adult', age = '';
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132970', booking_detail_id = '1', rid = '145733', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[07/08/2024 04:13:32], [file name :-/efsdata/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,file_path) VALUE ('', 'RESERVATION', 'j2/08_07_2024/request_reservation_yogeshqtech_04_13_32_1720412012.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_04_13_32_1720412012.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_04_13_32_1720412012.xml', 'jumbotours', '2024-07-08 04:13:32', '', '9490820240704113536712169932', '12727121', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_04_13_32_1720412012.xml');
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', native_discount = '0', cancellation_policy = '<b>DELUXE ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-20 05:29:59<br>If you cancel between 2024-07-20 05:30:00 and 2024-07-25 00:00:00 , you will be charged 28.4 USD<br>No show is subject to a 100.0% 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 05:30 on 20th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'failed', expiration_date = '2024-07-20 00:00:00', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'supriya@gmail.com', leader_phone = '9987204292', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', backoffice_user = 'Qtech_pranali', customer_id = '', applied_multiplier='1.00000',  applied_markup='4.99',  agent_markup='4.99',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='28.4',  applicable_service_tax='0',  supplier_rate='27.05',  uid='89ccc25441e7a4c3616377be041c4983'  where id='132970';
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132970';
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132970' , sr_id = '6' ;
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132970','25.24997','55.2819');
[07/08/2024 04:13:32], [file name :-/efsdata/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 ('1877179','132970','failed','2024-07-08 04:13:32','Booking failed Error: Failed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','43.239.53.130','0','949');
[07/08/2024 04:13:32], [file name :-/efsdata/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('132970','2024-07-20 05:30:00','2024-07-21 05:30:00','2024-07-25 00:00:00','2024-07-26 00:00:00','27.05','28.4','24','2024-07-08 04:13:32','28.4');
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132970',status='1' where reservation_id='1877179' and booking_id ='0';
[07/08/2024 04:13:32], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132970' where agent_logs_id='12727121' and source_type='jumbotours';
[07/08/2024 04:13:34], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132970','deepak.trivedi@qtechsoftware.com');
[07/08/2024 04:13:34], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132970','demo@demo.demo');
[07/08/2024 04:13:35], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132970','ops@astrabookings.com');
[07/08/2024 04:21:21], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:21:21',login_attempt=0 where id = '949';
[07/08/2024 04:21:21], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:21:21', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:23:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/31' , departure_date = '2024/08/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:23:29' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:23:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_23_30_17204126103.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126103.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_23_30_17204126103.xml', 'jumbotours', '2024-07-08 04:23:31', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126103.xml');
[07/08/2024 04:23:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704232929416806118&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:23:30.399'
        , request_start_time = '0.008'
        , parsing_start_time = '0.985'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.094'
        , search_end_time = '0.000'
        , total_duration = '1.224'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979496'
        WHERE id = '157026268';
[07/08/2024 04:23:32], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_23_30_17204126101.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126101.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_23_30_17204126101.xml', 'jumbotours', '2024-07-08 04:23:32', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126101.xml');
[07/08/2024 04:23:32], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_23_30_17204126102.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126102.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_23_30_17204126102.xml', 'jumbotours', '2024-07-08 04:23:32', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126102.xml');
[07/08/2024 04:23:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704232929416806118&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:23:30.400'
        , request_start_time = '0.026'
        , parsing_start_time = '2.167'
        , mapping_complete_time = '0.364'
        , mongo_start_time = '0.671'
        , search_end_time = '0.000'
        , total_duration = '2.911'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33430592'
        WHERE id = '157026269';
[07/08/2024 04:23:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704232929416806118&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:23:30.399'
        , request_start_time = '0.014'
        , parsing_start_time = '2.339'
        , mapping_complete_time = '0.317'
        , mongo_start_time = '0.576'
        , search_end_time = '0.000'
        , total_duration = '2.988'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28858072'
        WHERE id = '157026270';
[07/08/2024 04:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_23_30_17204126100.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126100.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_23_30_17204126100.xml', 'jumbotours', '2024-07-08 04:23:37', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_23_30_17204126100.xml');
[07/08/2024 04:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704232929416806118&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:23:30.399'
        , request_start_time = '0.009'
        , parsing_start_time = '7.312'
        , mapping_complete_time = '0.333'
        , mongo_start_time = '0.607'
        , search_end_time = '0.000'
        , total_duration = '7.993'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '30534224'
        WHERE id = '157026271';
[07/08/2024 04:23:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '200',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240704232929416806118',
        duration = '8.110',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.28',
        system_load_5_min = '1.67',
        system_load_15_min = '1.38',
        system_memory_usage = '22.45',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727125') + '2398072',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727125';
[07/08/2024 04:23:49], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720412629','43.239.53.130');
[07/08/2024 04:23:50], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_04_23_49_1720412629.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_04_23_49_1720412629.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_04_23_49_1720412629.xml', 'jumbotours', '2024-07-08 04:23:50', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_04_23_49_1720412629.xml');
[07/08/2024 04:24:50], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720412690','43.239.53.130');
[07/08/2024 04:24:52], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877181', create_date = '2024-07-08 04:24:52', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/31', check_out_date = '2024/08/01', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'supriya', leader_last_name = 'gangawane', status_date = '2024-07-08 04:24:52';
[07/08/2024 04:24:52], [file name :-/efsdata/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 ('132971','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 04:24:52], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132971'
		;
[07/08/2024 04:24:52], [file name :-/efsdata/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('132971','1877181','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/31','2024/08/01','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 04:24:52], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132971', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 04:24:52], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132971', booking_detail_id = '1', rid = '145734', room = '0', salutations = 'Mr', first_name = 'supriya', last_name = 'gangawane', passenger_type = 'adult', age = '';
[07/08/2024 04:24:52], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132971', booking_detail_id = '1', rid = '145734', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[07/08/2024 04:24:53], [file name :-/efsdata/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,file_path) VALUE ('', 'RESERVATION', 'j2/08_07_2024/request_reservation_yogeshqtech_04_24_52_1720412692.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_04_24_52_1720412692.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_04_24_52_1720412692.xml', 'jumbotours', '2024-07-08 04:24:53', '', '9490820240704232929416806118', '12727125', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_04_24_52_1720412692.xml');
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', native_discount = '0', cancellation_policy = '<b>DELUXE ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-26 05:29:59<br>If you cancel between 2024-07-26 05:30:00 and 2024-07-31 00:00:00 , you will be charged 28.4 USD<br>No show is subject to a 100.0% 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 05:30 on 26th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'failed', expiration_date = '2024-07-26 00:00:00', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'supriya@gmail.com', leader_phone = '9987204292', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', backoffice_user = 'Qtech_pranali', customer_id = '', applied_multiplier='1.00000',  applied_markup='4.99',  agent_markup='4.99',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='28.4',  applicable_service_tax='0',  supplier_rate='27.05',  uid='02d5f382021474bd15ebce8b696d7dc9'  where id='132971';
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132971';
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132971' , sr_id = '6' ;
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132971','25.24997','55.2819');
[07/08/2024 04:24:53], [file name :-/efsdata/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 ('1877181','132971','failed','2024-07-08 04:24:53','Booking failed Error: Failed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','43.239.53.130','0','949');
[07/08/2024 04:24:53], [file name :-/efsdata/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('132971','2024-07-26 05:30:00','2024-07-27 05:30:00','2024-07-31 00:00:00','2024-08-01 00:00:00','27.05','28.4','24','2024-07-08 04:24:53','28.4');
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132971',status='1' where reservation_id='1877181' and booking_id ='0';
[07/08/2024 04:24:53], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132971' where agent_logs_id='12727125' and source_type='jumbotours';
[07/08/2024 04:24:54], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132971','deepak.trivedi@qtechsoftware.com');
[07/08/2024 04:24:54], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132971','demo@demo.demo');
[07/08/2024 04:24:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132971','ops@astrabookings.com');
[07/08/2024 04:29:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:29:40',login_attempt=0 where id = '949';
[07/08/2024 04:29:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:29:40', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:30:05], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/23' , departure_date = '2024/07/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:30:05' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:30:07], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_30_05_17204130053.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130053.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_30_05_17204130053.xml', 'jumbotours', '2024-07-08 04:30:07', '', '9490820240704300529336427764', '12727163', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130053.xml');
[07/08/2024 04:30:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704300529336427764&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:30:05.850'
        , request_start_time = '0.020'
        , parsing_start_time = '1.075'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.096'
        , search_end_time = '0.000'
        , total_duration = '1.241'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2945688'
        WHERE id = '157026494';
[07/08/2024 04:30:07], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_30_05_17204130052.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130052.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_30_05_17204130052.xml', 'jumbotours', '2024-07-08 04:30:07', '', '9490820240704300529336427764', '12727163', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130052.xml');
[07/08/2024 04:30:07], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_30_05_17204130050.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130050.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_30_05_17204130050.xml', 'jumbotours', '2024-07-08 04:30:07', '', '9490820240704300529336427764', '12727163', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130050.xml');
[07/08/2024 04:30:08], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_30_05_17204130051.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130051.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_30_05_17204130051.xml', 'jumbotours', '2024-07-08 04:30:08', '', '9490820240704300529336427764', '12727163', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_30_05_17204130051.xml');
[07/08/2024 04:30:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704300529336427764&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:30:05.850'
        , request_start_time = '0.020'
        , parsing_start_time = '1.646'
        , mapping_complete_time = '0.316'
        , mongo_start_time = '0.571'
        , search_end_time = '0.000'
        , total_duration = '2.287'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '27928208'
        WHERE id = '157026495';
[07/08/2024 04:30:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704300529336427764&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:30:05.851'
        , request_start_time = '0.020'
        , parsing_start_time = '1.741'
        , mapping_complete_time = '0.338'
        , mongo_start_time = '0.619'
        , search_end_time = '0.000'
        , total_duration = '2.430'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '29931400'
        WHERE id = '157026496';
[07/08/2024 04:30:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704300529336427764&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:30:05.851'
        , request_start_time = '0.020'
        , parsing_start_time = '2.084'
        , mapping_complete_time = '0.375'
        , mongo_start_time = '0.652'
        , search_end_time = '0.000'
        , total_duration = '2.806'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33364208'
        WHERE id = '157026497';
[07/08/2024 04:30:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '198',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240704300529336427764',
        duration = '2.933',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.42',
        system_load_5_min = '1.35',
        system_load_15_min = '1.32',
        system_memory_usage = '23.63',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727163') + '2398768',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727163';
[07/08/2024 04:30:23], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720413023','43.239.53.130');
[07/08/2024 04:30:25], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_04_30_24_1720413024.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_04_30_24_1720413024.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_04_30_24_1720413024.xml', 'jumbotours', '2024-07-08 04:30:25', '', '9490820240704300529336427764', '12727163', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_04_30_24_1720413024.xml');
[07/08/2024 04:31:16], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720413076','43.239.53.130');
[07/08/2024 04:31:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877183', create_date = '2024-07-08 04:31:18', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/23', check_out_date = '2024/07/24', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'supriya', leader_last_name = 'gangawane', status_date = '2024-07-08 04:31:18';
[07/08/2024 04:31:18], [file name :-/efsdata/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 ('132972','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 04:31:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132972'
		;
[07/08/2024 04:31:18], [file name :-/efsdata/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('132972','1877183','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/23','2024/07/24','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 04:31:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132972', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 04:31:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132972', booking_detail_id = '1', rid = '145735', room = '0', salutations = 'Mr', first_name = 'supriya', last_name = 'gangawane', passenger_type = 'adult', age = '';
[07/08/2024 04:31:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132972', booking_detail_id = '1', rid = '145735', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[07/08/2024 04:33:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:33:04',login_attempt=0 where id = '949';
[07/08/2024 04:33:04], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:33:04', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:33:21], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/25' , departure_date = '2024/07/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:33:21' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:33:22], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_33_21_17204132013.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132013.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_33_21_17204132013.xml', 'jumbotours', '2024-07-08 04:33:22', '', '9490820240704332179391678704', '12727165', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132013.xml');
[07/08/2024 04:33:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704332179391678704&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:33:21.930'
        , request_start_time = '0.021'
        , parsing_start_time = '0.397'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.094'
        , search_end_time = '0.000'
        , total_duration = '0.560'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979632'
        WHERE id = '157026557';
[07/08/2024 04:33:23], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_33_21_17204132010.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132010.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_33_21_17204132010.xml', 'jumbotours', '2024-07-08 04:33:23', '', '9490820240704332179391678704', '12727165', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132010.xml');
[07/08/2024 04:33:23], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_33_22_17204132022.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_33_22_17204132022.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_33_22_17204132022.xml', 'jumbotours', '2024-07-08 04:33:23', '', '9490820240704332179391678704', '12727165', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_33_22_17204132022.xml');
[07/08/2024 04:33:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704332179391678704&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:33:21.930'
        , request_start_time = '0.008'
        , parsing_start_time = '1.462'
        , mapping_complete_time = '0.331'
        , mongo_start_time = '0.608'
        , search_end_time = '0.000'
        , total_duration = '2.138'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '30292560'
        WHERE id = '157026558';
[07/08/2024 04:33:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704332179391678704&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:33:21.931'
        , request_start_time = '0.008'
        , parsing_start_time = '1.832'
        , mapping_complete_time = '0.324'
        , mongo_start_time = '0.578'
        , search_end_time = '0.000'
        , total_duration = '2.490'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28162048'
        WHERE id = '157026559';
[07/08/2024 04:33:24], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_33_21_17204132011.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132011.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_33_21_17204132011.xml', 'jumbotours', '2024-07-08 04:33:24', '', '9490820240704332179391678704', '12727165', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_33_21_17204132011.xml');
[07/08/2024 04:33:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240704332179391678704&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:33:21.930'
        , request_start_time = '0.012'
        , parsing_start_time = '2.910'
        , mapping_complete_time = '0.364'
        , mongo_start_time = '0.655'
        , search_end_time = '0.000'
        , total_duration = '3.634'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33297280'
        WHERE id = '157026560';
[07/08/2024 04:33:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '202',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240704332179391678704',
        duration = '3.757',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.25',
        system_load_5_min = '1.28',
        system_load_15_min = '1.30',
        system_memory_usage = '23.40',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727165') + '2542632',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727165';
[07/08/2024 04:33:35], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720413215','43.239.53.130');
[07/08/2024 04:33:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_04_33_35_1720413215.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_04_33_35_1720413215.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_04_33_35_1720413215.xml', 'jumbotours', '2024-07-08 04:33:41', '', '9490820240704332179391678704', '12727165', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_04_33_35_1720413215.xml');
[07/08/2024 04:34:09], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720413249','43.239.53.130');
[07/08/2024 04:34:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877185', create_date = '2024-07-08 04:34:10', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/25', check_out_date = '2024/07/26', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'supriya', leader_last_name = 'gangawane', status_date = '2024-07-08 04:34:10';
[07/08/2024 04:34:10], [file name :-/efsdata/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 ('132973','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 04:34:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132973'
		;
[07/08/2024 04:34:10], [file name :-/efsdata/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('132973','1877185','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/25','2024/07/26','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 04:34:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132973', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 04:34:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132973', booking_detail_id = '1', rid = '145736', room = '0', salutations = 'Mr', first_name = 'supriya', last_name = 'gangawane', passenger_type = 'adult', age = '';
[07/08/2024 04:34:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132973', booking_detail_id = '1', rid = '145736', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[07/08/2024 04:50:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 04:50:07',login_attempt=0 where id = '949';
[07/08/2024 04:50:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 04:50:07', ip = '43.239.53.130', action = 'Login' ;
[07/08/2024 04:50:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/24' , departure_date = '2024/07/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 04:50:23' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 04:50:25], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_50_24_17204142243.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142243.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_50_24_17204142243.xml', 'jumbotours', '2024-07-08 04:50:25', '', '949082024070450237812980897', '12727179', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142243.xml');
[07/08/2024 04:50:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070450237812980897&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:50:24.241'
        , request_start_time = '0.019'
        , parsing_start_time = '0.818'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.091'
        , search_end_time = '0.000'
        , total_duration = '0.977'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979280'
        WHERE id = '157027600';
[07/08/2024 04:50:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_50_24_17204142240.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142240.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_50_24_17204142240.xml', 'jumbotours', '2024-07-08 04:50:26', '', '949082024070450237812980897', '12727179', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142240.xml');
[07/08/2024 04:50:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_50_24_17204142242.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142242.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_50_24_17204142242.xml', 'jumbotours', '2024-07-08 04:50:26', '', '949082024070450237812980897', '12727179', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142242.xml');
[07/08/2024 04:50:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070450237812980897&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:50:24.240'
        , request_start_time = '0.022'
        , parsing_start_time = '2.090'
        , mapping_complete_time = '0.327'
        , mongo_start_time = '0.599'
        , search_end_time = '0.000'
        , total_duration = '2.759'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '29901504'
        WHERE id = '157027601';
[07/08/2024 04:50:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070450237812980897&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:50:24.241'
        , request_start_time = '0.008'
        , parsing_start_time = '2.263'
        , mapping_complete_time = '0.314'
        , mongo_start_time = '0.560'
        , search_end_time = '0.000'
        , total_duration = '2.892'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28086376'
        WHERE id = '157027602';
[07/08/2024 04:50:27], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_04_50_24_17204142241.xml', 'j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142241.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_04_50_24_17204142241.xml', 'jumbotours', '2024-07-08 04:50:27', '', '949082024070450237812980897', '12727179', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_04_50_24_17204142241.xml');
[07/08/2024 04:50:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070450237812980897&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 04:50:24.241'
        , request_start_time = '0.019'
        , parsing_start_time = '3.222'
        , mapping_complete_time = '0.370'
        , mongo_start_time = '0.668'
        , search_end_time = '0.000'
        , total_duration = '3.958'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33600832'
        WHERE id = '157027603';
[07/08/2024 04:50:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '198',
        request_path = '/xml_all.php?userid=949&sessionid=949082024070450237812980897',
        duration = '4.069',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.45',
        system_load_5_min = '2.46',
        system_load_15_min = '2.04',
        system_memory_usage = '29.12',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727179') + '2259288',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727179';
[07/08/2024 04:50:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720414238','43.239.53.130');
[07/08/2024 04:50:39], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_04_50_38_1720414238.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_04_50_38_1720414238.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_04_50_38_1720414238.xml', 'jumbotours', '2024-07-08 04:50:39', '', '949082024070450237812980897', '12727179', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_04_50_38_1720414238.xml');
[07/08/2024 04:51:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720414297','43.239.53.130');
[07/08/2024 04:51:38], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877189', create_date = '2024-07-08 04:51:38', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/24', check_out_date = '2024/07/25', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Supriya', leader_last_name = 'gangawane', status_date = '2024-07-08 04:51:38';
[07/08/2024 04:51:38], [file name :-/efsdata/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 ('132974','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 04:51:38], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132974'
		;
[07/08/2024 04:51:38], [file name :-/efsdata/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('132974','1877189','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/24','2024/07/25','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 04:51:38], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132974', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 04:51:38], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132974', booking_detail_id = '1', rid = '145737', room = '0', salutations = 'Mr', first_name = 'Supriya', last_name = 'gangawane', passenger_type = 'adult', age = '';
[07/08/2024 04:51:38], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132974', booking_detail_id = '1', rid = '145737', room = '0', salutations = 'Mr', first_name = 'Aji', last_name = 'Gangawane', passenger_type = 'adult', age = '';
