[07/12/2024 06:00:22], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/15' , departure_date = '2024/09/16' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-12 06:00:22' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '0' ;
[07/12/2024 06:00:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7851&sessionid=78511220240706002292367618531',
        duration = '0.140',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.33',
        system_load_5_min = '1.22',
        system_load_15_min = '1.13',
        system_memory_usage = '54.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2566') + '2873920',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2566';
[07/12/2024 06:00:42], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/08/15' , departure_date = '2024/08/17' , nights = '2' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-12 06:00:42' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '0' ;
[07/12/2024 06:00:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7851&sessionid=78511220240706004238531889260',
        duration = '0.043',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.42',
        system_load_5_min = '1.26',
        system_load_15_min = '1.14',
        system_memory_usage = '54.70',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2567') + '2224128',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2567';
[07/12/2024 06:03:38], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/30' , departure_date = '2024/08/02' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-12 06:03:38' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '0' ;
[07/12/2024 06:03:39], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7851&sessionid=7851122024070603381227665050',
        duration = '0.045',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.06',
        system_load_5_min = '1.18',
        system_load_15_min = '1.13',
        system_memory_usage = '54.49',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2568') + '2224176',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2568';
[07/12/2024 06:07:36], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:07:36', ip = '138.199.43.81', action = 'Login' ;
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '102' ,status = '' ,priority = '3' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '3';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '98' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '84' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '103' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:22:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-12 06:22:28',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;3\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;3\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#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;1089\&#039;,supplier_id = 98 ,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;1089\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#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;1089\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#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;1089\&#039;,supplier_id = 84 ,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;1089\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#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;1089\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 103 ,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;1089\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#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;1089\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1089 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 89 ## company_name - Aos Connect ## supplier_code-aosc  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 102 ## company_name - Bedzinn ## supplier_code-bedzinn  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 74 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 96 ## company_name - GRNConnect - TGX ## supplier_code-grnconnecttgx  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 67 ## company_name - Local System ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 1 ## company_name - Miki ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 73 ## company_name - Restel ## supplier_code-restel  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 57 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-1089 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/12/2024 06:22:33], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-12 06:22:33',login_attempt=0 where id = '1089';
[07/12/2024 06:22:33], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-07-12 06:22:33', ip = '43.239.53.130', action = 'Login' ;
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/12/2024 06:24:11], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Deepak_Qtech',`create_date`= '2024-07-12 06:24:11',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/12/2024 06:24:14], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-12 06:24:14',login_attempt=0 where id = '949';
[07/12/2024 06:24:14], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-12 06:24:14', ip = '43.239.53.130', action = 'Login' ;
[07/12/2024 06:24:41], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'bali' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-12 06:24:41' , site_id = '' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/12/2024 06:24:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'j2/12_07_2024/request_availability_yogeshqtech_06_24_43_17207654830.xml', 'j2/12_07_2024/response_availability_yogeshqtech_06_24_43_17207654830.xml', 'j2/12_07_2024/response_header_availability_yogeshqtech_06_24_43_17207654830.xml', 'jumbotours', '2024-07-12 06:24:44', '', '9491220240706244183923525877', '13080886', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/12_07_2024/response_availability_yogeshqtech_06_24_43_17207654830.xml');
[07/12/2024 06:24:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9491220240706244183923525877&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-12 06:24:43.348'
        , request_start_time = '0.038'
        , parsing_start_time = '1.032'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.225'
        , search_end_time = '0.000'
        , total_duration = '1.332'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '10217320'
        WHERE id = '159357223';
[07/12/2024 06:24:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '8',
        request_path = '/xml_all.php?userid=949&sessionid=9491220240706244183923525877',
        duration = '2.052',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.21',
        system_load_5_min = '1.76',
        system_load_15_min = '1.61',
        system_memory_usage = '58.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13080886') + '2395968',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '13080886';
[07/12/2024 06:25:06], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720765506','43.239.53.130');
[07/12/2024 06:25:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'j2/12_07_2024/request_valuation_yogeshqtech_06_25_06_1720765506.xml', 'j2/12_07_2024/response_valuation_yogeshqtech_06_25_06_1720765506.xml', 'j2/12_07_2024/response_header_valuation_yogeshqtech_06_25_06_1720765506.xml', 'jumbotours', '2024-07-12 06:25:07', '', '9491220240706244183923525877', '13080886', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/12_07_2024/response_valuation_yogeshqtech_06_25_06_1720765506.xml');
[07/12/2024 06:25:47], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:25:47', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:25:47], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:25:47', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:26:11], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720765571','43.239.53.130');
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1887875', create_date = '2024-07-12 06:26:13', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'bali', country_id = '107', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '67.07', display_currency_code = 'USD', native_room_rate = '59.06', native_currency_code = 'EUR', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/10/31', check_out_date = '2024/11/01', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'deepak', leader_last_name = 'trivedi', status_date = '2024-07-12 06:26:13';
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('133580','ALOFT BALI KUTA AT BEACHWALK','NA','2817772','OT001282245','bali','jumbotours',NOW());
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='133580'
		;
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('133580','1887875','','1','1','0','-','','','2817772','ALOFT BALI KUTA AT BEACHWALK','Jl. Pantai Kuta Gg. Wina, Badung, Bali','','4.0','1','2024/10/31','2024/11/01','','https://i.travelapi.com/lodging/65000000/64570000/64569400/64569347/e2a6b6ea_b.jpg');
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '133580', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'ALOFT KING, GUEST ROOM, 1 KING, BALCONY - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:67.069999999999993;s:25:"displayNightlyRateDisplay";s:158:"Rate - 59.06, Currency Multiplier (EUR-USD) - 1.0815, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:59.060000000000002;}}', native_room_rate_total = '59.06', display_room_rate_total = '67.07', number_of_rooms = '1', room_category = 'Single ALOFT KING, GUEST ROOM, 1 KING, BALCONY - <font color=\'red\'>PACKAGE RATE</font>', meal_basis = 'ROOM ONLY';
[07/12/2024 06:26:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '133580', booking_detail_id = '1', rid = '146421', room = '0', salutations = 'Mr', first_name = 'deepak', last_name = 'trivedi', passenger_type = 'adult', age = '';
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'RESERVATION', 'j2/12_07_2024/request_reservation_yogeshqtech_06_26_13_1720765573.xml', 'j2/12_07_2024/response_reservation_yogeshqtech_06_26_13_1720765573.xml', 'j2/12_07_2024/response_header_reservation_yogeshqtech_06_26_13_1720765573.xml', 'jumbotours', '2024-07-12 06:26:21', '', '9491220240706244183923525877', '13080886', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/12_07_2024/response_reservation_yogeshqtech_06_26_13_1720765573.xml');
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '8735983618', display_discount = '0', native_discount = '0', cancellation_policy = '<b>ALOFT KING, GUEST ROOM, 1 KING, BALCONY - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-10-26 05:29:59<br>If you cancel between 2024-10-26 05:30:00 and 2024-10-31 00:00:00 , you will be charged 67.07 USD<br>No show is subject to a 100.0% cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 05:30 on 26th of October 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-10-26 00:00:00', comment_contract = ' ADDITIONAL INFO: Tour Op Dyn Bkfst For2 Rate, Tour Operator Dynamic Program, see Rate detailsADDITIONAL INFO: Dyn Net Breakfst For 2 Rate, Dynamic Leisure 20% Bundled Net Breakfast 2 AD Program, includes resort fee, see Rate detailsADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed This property accepts credit cards; cash is not accepted Cashless transactions are available Safety features at this property include a fire extinguisher, a security system, and a first aid kit This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: New Year\'s Eve (31 December) Gala Dinner per adult: IDR 454545 New Year\'s Eve (31 December) Gala Dinner per child: IDR 454545 (from 1 to 11 years old) We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately IDR 217800 per person Rollaway bed fee: IDR 484000.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Pool access available from 8:00 AM to 7:00 PM. Up to 2 children 5 years old and younger stay free when occupying the parent or guardian\'s room, using existing bedding. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'deepak.trivedi@qtechsoftware.com', leader_phone = '1234567890', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' ADDITIONAL INFO: Tour Op Dyn Bkfst For2 Rate, Tour Operator Dynamic Program, see Rate detailsADDITIONAL INFO: Dyn Net Breakfst For 2 Rate, Dynamic Leisure 20% Bundled Net Breakfast 2 AD Program, includes resort fee, see Rate detailsADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed This property accepts credit cards; cash is not accepted Cashless transactions are available Safety features at this property include a fire extinguisher, a security system, and a first aid kit This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: New Year\'s Eve (31 December) Gala Dinner per adult: IDR 454545 New Year\'s Eve (31 December) Gala Dinner per child: IDR 454545 (from 1 to 11 years old) We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately IDR 217800 per person Rollaway bed fee: IDR 484000.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Pool access available from 8:00 AM to 7:00 PM. Up to 2 children 5 years old and younger stay free when occupying the parent or guardian\'s room, using existing bedding. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions.', backoffice_user = 'Deepak_Qtech', customer_id = '', applied_multiplier='1.0815',  applied_markup='5.01',  agent_markup='5.01',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.0815',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='67.07',  applicable_service_tax='0',  supplier_rate='59.06',  uid='d31355807edd21416dde36b6c0c672fe'  where id='133580';
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='133580';
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('133580','-8.71699','115.171');
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-07-12 06:26:21',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;133580\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -133580 And Booking Status - confirmed',`ip`= '43.239.53.130';
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='133580' ;
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1887875','133580','confirmed','2024-07-12 06:26:21','Booking confirmed. Booked by Back Office Deepak_Qtech on behalf of Agent - Deepak  Trivedi(CD0949)','949','43.239.53.130','0','949');
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('133580','2024-10-26 05:30:00','2024-10-27 05:30:00','2024-10-31 00:00:00','2024-11-01 00:00:00','59.06','67.07','24','2024-07-12 06:26:21','67.07');
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='133580',status='1' where reservation_id='1887875' and booking_id ='0';
[07/12/2024 06:26:21], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='133580' where agent_logs_id='13080886' and source_type='jumbotours';
[07/12/2024 06:26:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('133580','deepak.trivedi@qtechsoftware.com');
[07/12/2024 06:26:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('133580','demo@demo.demo');
[07/12/2024 06:26:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('133580','ops@astrabookings.com');
[07/12/2024 06:26:26], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('133580','info@astrabookings.com');
[07/12/2024 06:26:26], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('133580','ops@astrabookings.com');
[07/12/2024 06:28:17], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:28:17', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:28:17], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:28:17', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:28:54], [file name :-/efsdata/otrams/public_html/beta/terms.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:28:54', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:30:03], [file name :-/efsdata/otrams/public_html/beta/terms.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-12 06:30:03', ip = '162.19.137.220', action = 'Login' ;
[07/12/2024 06:33:06], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-12 06:33:06', ip = '149.28.209.136', action = 'Login' ;
[07/12/2024 06:33:08], [file name :-/efsdata/otrams/public_html/beta/home/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-12 06:33:08', ip = '149.28.209.136', action = 'Login' ;
[07/12/2024 06:44:58], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/12/2024 06:45:03], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('133580', 'CANCELLATION_FEE', 'j2/12_07_2024/request_CANCELLATION_FEE_yogeshqtech_133580_06_45_03_1720766703.xml', 'j2/12_07_2024/response_CANCELLATION_FEE_yogeshqtech_133580_06_45_03_1720766703.xml', 'j2/12_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_133580_06_45_03_1720766703.xml', 'jumbotours', '2024-07-12 06:45:03', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/12_07_2024/response_CANCELLATION_FEE_yogeshqtech_133580_06_45_03_1720766703.xml');
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('133580', 'CANCEL', 'j2/12_07_2024/request_cancel_yogeshqtech_133580_06_45_04_1720766704.xml', 'j2/12_07_2024/response_cancel_yogeshqtech_133580_06_45_04_1720766704.xml', 'j2/12_07_2024/response_header_cancel_yogeshqtech_133580_06_45_04_1720766704.xml', 'jumbotours', '2024-07-12 06:45:12', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/12_07_2024/response_cancel_yogeshqtech_133580_06_45_04_1720766704.xml');
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='133580', agent_id ='949', itenirary_id ='', confirmation_number ='8735983618', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='deepak.trivedi@qtechsoftware.com', leader_title ='Mr', leader_first_name ='deepak', leader_last_name ='trivedi', city_id ='bali', country_id ='107', display_room_rate ='67.070', native_room_rate ='59.060', native_currency_code ='EUR', additional_charge ='0.000', cancellation_policy ='<b>ALOFT KING, GUEST ROOM, 1 KING, BALCONY - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-10-26 05:29:59<br>If you cancel between 2024-10-26 05:30:00 and 2024-10-31 00:00:00 , you will be charged 67.07 USD<br>No show is subject to a 100.0% cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 05:30 on 26th of October 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2024-07-12 06:26:13', create_date ='2024-07-12 06:26:13', source_type ='jumbotours', expiration_date ='2024-10-26 00:00:00', comment_contract =' ADDITIONAL INFO: Tour Op Dyn Bkfst For2 Rate, Tour Operator Dynamic Program, see Rate detailsADDITIONAL INFO: Dyn Net Breakfst For 2 Rate, Dynamic Leisure 20% Bundled Net Breakfast 2 AD Program, includes resort fee, see Rate detailsADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed This property accepts credit cards; cash is not accepted Cashless transactions are available Safety features at this property include a fire extinguisher, a security system, and a first aid kit This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: New Year\'s Eve (31 December) Gala Dinner per adult: IDR 454545 New Year\'s Eve (31 December) Gala Dinner per child: IDR 454545 (from 1 to 11 years old) We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately IDR 217800 per person Rollaway bed fee: IDR 484000.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Pool access available from 8:00 AM to 7:00 PM. Up to 2 children 5 years old and younger stay free when occupying the parent or guardian\'s room, using existing bedding. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='67.070', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='59.060', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Bhavesh_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.0815', applied_markup ='5.01', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='5.01', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.0815', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-07-12 06:45:12', modified_by ='', display_currency_code ='USD', created_datetime ='2024-07-12 06:45:12', sub_agent_rate ='0.000', created_by ='yogeshqtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='43.239.53.130', is_cancel_history ='1';
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','133580','cancelled','2024-07-12 06:45:12','','949','43.239.53.130','','','');
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2024-07-12 06:45:12' , pending_cancellation = 'no' WHERE reservation_id = '1887875' AND id = '133580' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='133580';
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='' , applicable_service_tax='0' WHERE id = '133580' AND (current_status = 'cancelled' ) ;
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[07/12/2024 06:45:12], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','EUR','USD','1887875','133580','2024-07-12 06:45:12','',' ');
[07/12/2024 06:45:14], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/12/2024 06:45:16], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('133580','deepak.trivedi@qtechsoftware.com');
[07/12/2024 06:45:16], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('133580','demo@demo.demo');
[07/12/2024 06:45:18], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('133580','ops@astrabookings.com');
[07/12/2024 06:45:18], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('133580','info@astrabookings.com');
[07/12/2024 06:45:18], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('133580','ops@astrabookings.com');
[07/12/2024 06:45:22], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/12/2024 06:45:24], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/12/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
