[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '1' ,priority = '8' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:21], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:01:22], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-09-24 14:01:22',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 24 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 19 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 59 ,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;7839\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7839 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 8760 ',`ip`= '103.139.247.180';
[09/24/2023 02:03:22], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:03:22' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:03:39], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:03:39' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:04:06], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:04:06' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:04:46], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:04:46' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:04:54], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:04:54' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:05:37], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/SQTECH/24_09_2023/request_hotel_search_SQTECH_14_05_37_1695564337_9518839.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/SQTECH/24_09_2023/response_hotel_search_SQTECH_14_05_37_1695564337_9518839.txt','','','0','2023-09-24 14:05:37','2023-09-24 14:05:37','hotel_search','','','0','');
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '1' ,priority = '8' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:06:25], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-09-24 14:06:25',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 24 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 19 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 59 ,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;7839\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7839 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 24 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 1',`ip`= '103.139.247.180';
[09/24/2023 02:07:12], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:07:12' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:07:19], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:07:19' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:09:55], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-09-24 02:09:55',login_attempt=0 where id = '7839';
[09/24/2023 02:09:55], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '28', login_datetime = '2023-09-24 14:09:55', ip = '103.139.247.180', action = 'Login' ;
[09/24/2023 02:09:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='103.139.247.180', agent_id='7839', session_id='914a4ed8b1eda700d02741d55221bf8d6043fe66e5c76173c6a71980f5ab17d9',create_date='2023-09-24 02:09:56', update_date='2023-09-24 02:09:56',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[09/24/2023 02:11:45], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:11:45' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:11:57], [file name :-/home/otrams/public_html/beta/tms/authenticate_web_service.php],update agents set web_service='1' , ws_customer_type= 'external' , allow_iprange= '1', allow_encoding= '1', web_service_ip= '192.168.0.238,3.128.191.50,43.239.53.130' , web_service_only_mapped_hotels='0' where id= '7839';
[09/24/2023 02:12:04], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:12:04' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:12:36], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-09-24 02:12:36' WHERE id= '87';
[09/24/2023 02:12:36], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-09-24 02:12:36',login_attempt=0 where id = '7839';
[09/24/2023 02:12:36], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '28', login_datetime = '2023-09-24 14:12:36', ip = '103.139.247.180', action = 'Login' ;
[09/24/2023 02:12:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-09-24 02:12:37' WHERE id= '87';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '1' ,priority = '8' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/24/2023 02:12:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-09-24 14:12:55',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 24 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#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;7839\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 59 ,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;7839\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7839 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 24 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 1',`ip`= '103.139.247.180';
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:13:04' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:13:04.690'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:13:04'
                , session_id = '78392420230914130496563466079'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743648';
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:13:04.690'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:13:04'
                , session_id = '78392420230914130496563466079'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743576';
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_13_04_1695564784.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_13_04_1695564784.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_13_04_1695564784.xml', 'dotw', '2023-09-24 02:13:04', '', '78392420230914130496563466079', '0');
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914130496563466079&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:04.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.265'
            , error_description = ''
            , memory_used = '3624072'
            WHERE id = '6794';
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_13_04_1695564784.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_13_04_1695564784.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_13_04_1695564784.xml', 'dotw', '2023-09-24 02:13:04', '', '78392420230914130496563466079', '0');
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_13_04_1695564784.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_13_04_1695564784.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_13_04_1695564784.xml', 'dotw', '2023-09-24 02:13:04', '', '78392420230914130496563466079', '0');
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914130496563466079&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:04.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.270'
            , error_description = ''
            , memory_used = '3639344'
            WHERE id = '6796';
[09/24/2023 02:13:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914130496563466079&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:04.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.270'
            , error_description = ''
            , memory_used = '3639344'
            WHERE id = '6795';
[09/24/2023 02:13:06], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_13_04_1695564784_55.json', 'e1/24_09_2023/response_availability_sqtech_14_13_04_1695564784_55.json', 'e1/24_09_2023/response_header_availability_sqtech_14_13_04_1695564784_55.json', 'expedia', '2023-09-24 02:13:06', '', '78392420230914130496563466079', '0');
[09/24/2023 02:13:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230914130496563466079&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:13:04.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.639'
            , error_description = ''
            , memory_used = '121091336'
            WHERE id = '6797';
[09/24/2023 02:13:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_13_04_1695564784_10.json', 'e1p/24_09_2023/response_availability_sqtech_14_13_04_1695564784_10.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_13_04_1695564784_10.json', 'expediapackage', '2023-09-24 02:13:07', '', '78392420230914130496563466079', '0');
[09/24/2023 02:13:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230914130496563466079&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:13:04.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.978'
            , error_description = ''
            , memory_used = '134195192'
            WHERE id = '6798';
[09/24/2023 02:13:08], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_13_08_1695564788_8212453.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_13_08_1695564788_8212453.txt','7839','78392420230914130496563466079','0','2023-09-24 14:13:04','2023-09-24 14:13:08','hotel_search','','','4','0');
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:13:24' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:13:24.690'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:13:24'
                , session_id = '78392420230914132495567695005'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743408';
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:13:24.690'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:13:24'
                , session_id = '78392420230914132495567695005'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743408';
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_13_24_1695564804.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_13_24_1695564804.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_13_24_1695564804.xml', 'dotw', '2023-09-24 02:13:24', '', '78392420230914132495567695005', '0');
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914132495567695005&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:24.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.192'
            , error_description = ''
            , memory_used = '3025472'
            WHERE id = '6801';
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_13_24_1695564804.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_13_24_1695564804.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_13_24_1695564804.xml', 'dotw', '2023-09-24 02:13:24', '', '78392420230914132495567695005', '0');
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914132495567695005&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:24.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.204'
            , error_description = ''
            , memory_used = '3025512'
            WHERE id = '6802';
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_13_24_1695564804.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_13_24_1695564804.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_13_24_1695564804.xml', 'dotw', '2023-09-24 02:13:24', '', '78392420230914132495567695005', '0');
[09/24/2023 02:13:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914132495567695005&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:13:24.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.236'
            , error_description = ''
            , memory_used = '3003240'
            WHERE id = '6803';
[09/24/2023 02:13:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_13_24_1695564804_56.json', 'e1/24_09_2023/response_availability_sqtech_14_13_24_1695564804_56.json', 'e1/24_09_2023/response_header_availability_sqtech_14_13_24_1695564804_56.json', 'expedia', '2023-09-24 02:13:26', '', '78392420230914132495567695005', '0');
[09/24/2023 02:13:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230914132495567695005&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:13:24.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.508'
            , error_description = ''
            , memory_used = '120313992'
            WHERE id = '6804';
[09/24/2023 02:13:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_13_24_1695564804_20.json', 'e1p/24_09_2023/response_availability_sqtech_14_13_24_1695564804_20.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_13_24_1695564804_20.json', 'expediapackage', '2023-09-24 02:13:27', '', '78392420230914132495567695005', '0');
[09/24/2023 02:13:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230914132495567695005&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:13:24.690'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.147'
            , error_description = ''
            , memory_used = '134453704'
            WHERE id = '6805';
[09/24/2023 02:13:29], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_13_29_1695564809_7267237.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_13_29_1695564809_7267237.txt','7839','78392420230914132495567695005','0','2023-09-24 14:13:24','2023-09-24 14:13:29','hotel_search','','','5','0');
[09/24/2023 02:15:36], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:15:36' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:15:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:15:36.897'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:15:36'
                , session_id = '78392420230914153610920561020'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743248';
[09/24/2023 02:15:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:15:36.897'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:15:36'
                , session_id = '78392420230914153610920561020'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743248';
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_15_36_1695564936.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_15_36_1695564936.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_15_36_1695564936.xml', 'dotw', '2023-09-24 02:15:37', '', '78392420230914153610920561020', '0');
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_15_36_1695564936.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_15_36_1695564936.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_15_36_1695564936.xml', 'dotw', '2023-09-24 02:15:37', '', '78392420230914153610920561020', '0');
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_15_36_1695564936.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_15_36_1695564936.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_15_36_1695564936.xml', 'dotw', '2023-09-24 02:15:37', '', '78392420230914153610920561020', '0');
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914153610920561020&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:36.897'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.196'
            , error_description = ''
            , memory_used = '3003232'
            WHERE id = '6808';
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914153610920561020&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:36.897'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.197'
            , error_description = ''
            , memory_used = '3025560'
            WHERE id = '6809';
[09/24/2023 02:15:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914153610920561020&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:36.897'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.199'
            , error_description = ''
            , memory_used = '3025504'
            WHERE id = '6810';
[09/24/2023 02:15:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_15_36_1695564936_26.json', 'e1/24_09_2023/response_availability_sqtech_14_15_36_1695564936_26.json', 'e1/24_09_2023/response_header_availability_sqtech_14_15_36_1695564936_26.json', 'expedia', '2023-09-24 02:15:38', '', '78392420230914153610920561020', '0');
[09/24/2023 02:15:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230914153610920561020&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:15:36.897'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.177'
            , error_description = ''
            , memory_used = '120141784'
            WHERE id = '6811';
[09/24/2023 02:15:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_15_36_1695564936_49.json', 'e1p/24_09_2023/response_availability_sqtech_14_15_36_1695564936_49.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_15_36_1695564936_49.json', 'expediapackage', '2023-09-24 02:15:40', '', '78392420230914153610920561020', '0');
[09/24/2023 02:15:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230914153610920561020&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:15:36.897'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.196'
            , error_description = ''
            , memory_used = '134737504'
            WHERE id = '6812';
[09/24/2023 02:15:41], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_15_41_1695564941_3502556.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_15_41_1695564941_3502556.txt','7839','78392420230914153610920561020','0','2023-09-24 14:15:36','2023-09-24 14:15:41','hotel_search','','','5','0');
[09/24/2023 02:15:52], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:15:52' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:15:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:15:52.885'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:15:52'
                , session_id = '78392420230914155268934051695'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743408';
[09/24/2023 02:15:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:15:52.885'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:15:52'
                , session_id = '78392420230914155268934051695'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743408';
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_15_52_1695564952.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_15_52_1695564952.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_15_52_1695564952.xml', 'dotw', '2023-09-24 02:15:53', '', '78392420230914155268934051695', '0');
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_15_52_1695564952.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_15_52_1695564952.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_15_52_1695564952.xml', 'dotw', '2023-09-24 02:15:53', '', '78392420230914155268934051695', '0');
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_15_52_1695564952.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_15_52_1695564952.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_15_52_1695564952.xml', 'dotw', '2023-09-24 02:15:53', '', '78392420230914155268934051695', '0');
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914155268934051695&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:52.885'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.193'
            , error_description = ''
            , memory_used = '3025472'
            WHERE id = '6815';
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914155268934051695&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:52.885'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.194'
            , error_description = ''
            , memory_used = '3031448'
            WHERE id = '6816';
[09/24/2023 02:15:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914155268934051695&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:15:52.885'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.197'
            , error_description = ''
            , memory_used = '3003240'
            WHERE id = '6817';
[09/24/2023 02:15:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_15_52_1695564952_14.json', 'e1/24_09_2023/response_availability_sqtech_14_15_52_1695564952_14.json', 'e1/24_09_2023/response_header_availability_sqtech_14_15_52_1695564952_14.json', 'expedia', '2023-09-24 02:15:54', '', '78392420230914155268934051695', '0');
[09/24/2023 02:15:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230914155268934051695&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:15:52.885'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.918'
            , error_description = ''
            , memory_used = '119981128'
            WHERE id = '6818';
[09/24/2023 02:15:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_15_52_1695564952_61.json', 'e1p/24_09_2023/response_availability_sqtech_14_15_52_1695564952_61.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_15_52_1695564952_61.json', 'expediapackage', '2023-09-24 02:15:56', '', '78392420230914155268934051695', '0');
[09/24/2023 02:15:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230914155268934051695&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:15:52.885'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.038'
            , error_description = ''
            , memory_used = '134609184'
            WHERE id = '6819';
[09/24/2023 02:15:57], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_15_57_1695564957_6778427.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_15_57_1695564957_6778427.txt','7839','78392420230914155268934051695','0','2023-09-24 14:15:52','2023-09-24 14:15:57','hotel_search','','','5','0');
[09/24/2023 02:16:31], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:16:31' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:16:32.69'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:16:32'
                , session_id = '7839242023091416319300657231'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743824';
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:16:32.69'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:16:32'
                , session_id = '7839242023091416319300657231'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743648';
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_16_32_1695564992.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_16_32_1695564992.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_16_32_1695564992.xml', 'dotw', '2023-09-24 02:16:32', '', '7839242023091416319300657231', '0');
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_16_32_1695564992.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_16_32_1695564992.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_16_32_1695564992.xml', 'dotw', '2023-09-24 02:16:32', '', '7839242023091416319300657231', '0');
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=7839242023091416319300657231&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:16:32.68'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.192'
            , error_description = ''
            , memory_used = '3031032'
            WHERE id = '6822';
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=7839242023091416319300657231&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:16:32.69'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.194'
            , error_description = ''
            , memory_used = '3031040'
            WHERE id = '6823';
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_16_32_1695564992.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_16_32_1695564992.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_16_32_1695564992.xml', 'dotw', '2023-09-24 02:16:32', '', '7839242023091416319300657231', '0');
[09/24/2023 02:16:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=7839242023091416319300657231&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:16:32.69'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.199'
            , error_description = ''
            , memory_used = '3002768'
            WHERE id = '6824';
[09/24/2023 02:16:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_16_32_1695564992_14.json', 'e1/24_09_2023/response_availability_sqtech_14_16_32_1695564992_14.json', 'e1/24_09_2023/response_header_availability_sqtech_14_16_32_1695564992_14.json', 'expedia', '2023-09-24 02:16:33', '', '7839242023091416319300657231', '0');
[09/24/2023 02:16:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7839242023091416319300657231&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:16:32.69'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.641'
            , error_description = ''
            , memory_used = '120752992'
            WHERE id = '6825';
[09/24/2023 02:16:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_16_32_1695564992_64.json', 'e1p/24_09_2023/response_availability_sqtech_14_16_32_1695564992_64.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_16_32_1695564992_64.json', 'expediapackage', '2023-09-24 02:16:34', '', '7839242023091416319300657231', '0');
[09/24/2023 02:16:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7839242023091416319300657231&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:16:32.69'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.752'
            , error_description = ''
            , memory_used = '133817480'
            WHERE id = '6826';
[09/24/2023 02:16:36], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_16_36_1695564996_4560901.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_16_36_1695564996_4560901.txt','7839','7839242023091416319300657231','0','2023-09-24 14:16:31','2023-09-24 14:16:36','hotel_search','','','5','0');
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 14:17:21' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:17:21.257'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:17:21'
                , session_id = '78392420230914172164335238238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743248';
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-24 14:17:21.257'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-24 02:17:21'
                , session_id = '78392420230914172164335238238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743408';
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__1_14_17_21_1695565041.xml', 'd1/24_09_2023/response_availability_sqtech__1_14_17_21_1695565041.xml', 'd1/24_09_2023/response_header_availability_sqtech__1_14_17_21_1695565041.xml', 'dotw', '2023-09-24 02:17:21', '', '78392420230914172164335238238', '0');
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914172164335238238&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=1&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:17:21.257'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.193'
            , error_description = ''
            , memory_used = '3025464'
            WHERE id = '6829';
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__2_14_17_21_1695565041.xml', 'd1/24_09_2023/response_availability_sqtech__2_14_17_21_1695565041.xml', 'd1/24_09_2023/response_header_availability_sqtech__2_14_17_21_1695565041.xml', 'dotw', '2023-09-24 02:17:21', '', '78392420230914172164335238238', '0');
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914172164335238238&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=2&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:17:21.258'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.199'
            , error_description = ''
            , memory_used = '3003232'
            WHERE id = '6830';
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd1/24_09_2023/request_availability_sqtech__0_14_17_21_1695565041.xml', 'd1/24_09_2023/response_availability_sqtech__0_14_17_21_1695565041.xml', 'd1/24_09_2023/response_header_availability_sqtech__0_14_17_21_1695565041.xml', 'dotw', '2023-09-24 02:17:21', '', '78392420230914172164335238238', '0');
[09/24/2023 02:17:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=78392420230914172164335238238&xml_user_id=7839&db_caching=1&destination_code=364&country_code=6&language=&web_service=yes&time_out=24&hotels_ids=&erequest=0&total_request=3&web_service=yes&time_out=24'
            , http_hit_time = '2023-09-24 14:17:21.257'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.204'
            , error_description = ''
            , memory_used = '3025504'
            WHERE id = '6831';
[09/24/2023 02:17:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_14_17_21_1695565041_42.json', 'e1p/24_09_2023/response_availability_sqtech_14_17_21_1695565041_42.json', 'e1p/24_09_2023/response_header_availability_sqtech_14_17_21_1695565041_42.json', 'expediapackage', '2023-09-24 02:17:24', '', '78392420230914172164335238238', '0');
[09/24/2023 02:17:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_09_2023/request_availability_sqtech_14_17_21_1695565041_83.json', 'e1/24_09_2023/response_availability_sqtech_14_17_21_1695565041_83.json', 'e1/24_09_2023/response_header_availability_sqtech_14_17_21_1695565041_83.json', 'expedia', '2023-09-24 02:17:25', '', '78392420230914172164335238238', '0');
[09/24/2023 02:17:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230914172164335238238&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:17:21.258'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.512'
            , error_description = ''
            , memory_used = '132589976'
            WHERE id = '6832';
[09/24/2023 02:17:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230914172164335238238&xml_user_id=7839&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-24 14:17:21.258'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.865'
            , error_description = ''
            , memory_used = '119502832'
            WHERE id = '6833';
[09/24/2023 02:17:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/request_hotel_search_sqtech_14_17_26_1695565046_8583458.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_14_17_26_1695565046_8583458.txt','7839','78392420230914172164335238238','0','2023-09-24 14:17:21','2023-09-24 14:17:26','hotel_search','','','5','0');
[09/24/2023 02:17:47], [file name :-/home/otrams/public_html/beta/supplier_registration.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2023-09-24 14:17:47', ip = '176.31.103.46', action = 'Login' ;
