[05/21/2024 12:01:21], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 12:01:21' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 12:01:23], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 12:01:23', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1838');
[05/21/2024 12:01:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 12:01:22.944'
        , request_start_time = '0.034'
        , parsing_start_time = '0.021'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.200'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5499496'
        WHERE id = '554793';
[05/21/2024 12:01:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.361',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.79',
        system_load_5_min = '12.91',
        system_load_15_min = '16.41',
        system_memory_usage = '92.94',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1838') + '6448488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1838';
[05/21/2024 12:02:54], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotels SET name = 'qtech_test',rating = '3.0',first_name = '',middle_name = '' ,last_name = '' ,city = '64440',country = '106',location_id = '',area = '',address = '' ,phone ='',fax = '',email = '',website = '',latitude = '',longitude = '',driving_direction = '',near_by = '',weekend = '6,7',main_image = '',optional_images = '#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#',main_image_desc = '',optional_images_desc = '',hotelbeds_code ='',status ='A',short_desc = '',long_desc = '';
[05/21/2024 12:02:54], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-21 12:02:54',`log_type`= 'Hotel Added',`sql_query`= 'INSERT INTO hotels SET name = \&#039;qtech_test\&#039;,rating = \&#039;3.0\&#039;,first_name = \&#039;\&#039;,middle_name = \&#039;\&#039; ,last_name = \&#039;\&#039; ,city = \&#039;64440\&#039;,country = \&#039;106\&#039;,location_id = \&#039;\&#039;,area = \&#039;\&#039;,address = \&#039;\&#039; ,phone =\&#039;\&#039;,fax = \&#039;\&#039;,email = \&#039;\&#039;,website = \&#039;\&#039;,latitude = \&#039;\&#039;,longitude = \&#039;\&#039;,driving_direction = \&#039;\&#039;,near_by = \&#039;\&#039;,weekend = \&#039;6,7\&#039;,main_image = \&#039;\&#039;,optional_images = \&#039;#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#\&#039;,main_image_desc = \&#039;\&#039;,optional_images_desc = \&#039;\&#039;,hotelbeds_code =\&#039;\&#039;,status =\&#039;A\&#039;,short_desc = \&#039;\&#039;,long_desc = \&#039;\&#039;',`log_description`= 'Hotel qtech_test Added by User v3alpha',`ip`= '43.239.53.130';
[05/21/2024 12:37:17], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000001' AND city_code= '64440' AND country_code= '106';
[05/21/2024 12:37:17], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000001',hotel_id = '4',city_code = '64440',country_code = '106';
[05/21/2024 12:37:17], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000001',hotel_id = '7',city_code = '64440',country_code = '106';
[05/21/2024 12:37:17], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-21 12:37:17',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000001\&#039;,hotel_id = \&#039;4\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000001\&#039;,hotel_id = \&#039;7\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000001, City : 64440, Country : 106, Hotels are : 4,7',`ip`= '43.239.53.130';
[05/21/2024 12:37:17], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3390', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 12:41:12], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='7' AND supplier_id='S000000001';
[05/21/2024 12:41:12], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='7', supplier_id='S000000001', class_id='1', is_channel_manager_mapped = '0';
[05/21/2024 12:49:58], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],UPDATE hotels SET weekend='6,7', infant_lower_limit='0', infant_upper_limit='1', tiny_child_lower_limit='2', tiny_child_upper_limit='3', child_lower_limit='4', child_upper_limit='6', teen_child_lower_limit='7', teen_child_upper_limit='8' WHERE id='7';
[05/21/2024 12:49:58], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 12:49:58',`log_type`= 'Hotel',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;, infant_lower_limit=\&#039;0\&#039;, infant_upper_limit=\&#039;1\&#039;, tiny_child_lower_limit=\&#039;2\&#039;, tiny_child_upper_limit=\&#039;3\&#039;, child_lower_limit=\&#039;4\&#039;, child_upper_limit=\&#039;6\&#039;, teen_child_lower_limit=\&#039;7\&#039;, teen_child_upper_limit=\&#039;8\&#039; WHERE id=\&#039;7\&#039;',`log_description`= 'Hotel Setting of qtech_test Updated By travelclick',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 12:49:58], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3391', `entity`='Hotels', `value`='7' ;
[05/21/2024 12:49:58], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3391', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 12:52:43], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='7' AND supplier_id='S000000001';
[05/21/2024 12:52:43], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='7', supplier_id='S000000001', class_id='6', is_channel_manager_mapped = '0';
[05/21/2024 12:52:44], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='7' AND supplier_id='S000000001';
[05/21/2024 12:52:44], [file name :-/efsdata/otrams/public_html/beta/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='7', supplier_id='S000000001', class_id='6', is_channel_manager_mapped = '0';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-21',to_date='2024-05-21',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-22',to_date='2024-05-22',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-23',to_date='2024-05-23',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-24',to_date='2024-05-24',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-25',to_date='2024-05-25',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-26',to_date='2024-05-26',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-27',to_date='2024-05-27',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-28',to_date='2024-05-28',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-29',to_date='2024-05-29',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-30',to_date='2024-05-30',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-31',to_date='2024-05-31',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-01',to_date='2024-06-01',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-02',to_date='2024-06-02',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-03',to_date='2024-06-03',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-04',to_date='2024-06-04',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-05',to_date='2024-06-05',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-06',to_date='2024-06-06',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-07',to_date='2024-06-07',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-08',to_date='2024-06-08',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-09',to_date='2024-06-09',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-10',to_date='2024-06-10',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-11',to_date='2024-06-11',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-12',to_date='2024-06-12',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-13',to_date='2024-06-13',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-14',to_date='2024-06-14',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-15',to_date='2024-06-15',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-16',to_date='2024-06-16',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-17',to_date='2024-06-17',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-18',to_date='2024-06-18',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-19',to_date='2024-06-19',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-20',to_date='2024-06-20',supplier_id='S000000001',hotel_id='7',room_basis_id='3',room_class_id='6',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '16',teen_child_wtb_weekend_rate= '16',teen_display= 'yes',adult_wb_rate= '17',adult_wb_weekend_rate= '17',adult_display= 'yes';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 12:54:12',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For qtech_test added successfully. Room Category :- Standard - Double, Max Pax - 3, Extrabed - 1(Buffet Breakfast) From :- 21-05-2024 To :- 20-06-2024',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3392', `entity`='Hotels', `value`='7' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3392', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3392', `entity`='Inventory', `value`='2' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3392', `entity`='Room', `value`='6' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO hotel_supplier_currency_mapping SET SupplierId ='S000000001',hotel_id ='7',currency_code ='USD',city_code ='64440',country_code ='106',created_datetime ='2024-05-21 12:54:12',created_by ='#supplier#',ip_addr ='43.239.53.130';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('7@S000000001@2024-05-21@2024-05-21@@6@3@19@@@0','21-05-2024~21-05-2024','7','S000000001','2024-05-21','2024-05-21','6','3','43.239.53.130','0','0','38a7c39f574b3afd4497062c6cafc325','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','38a7c39f574b3afd4497062c6cafc325','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0','');
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 12:54:12',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For qtech_test Rate:- 20 Room Category :- Standard - Double, Max Pax - 3, Extrabed - 1 (Buffet Breakfast) Market :- localsystem From:- 21-05-2024 To:- 20-06-2024',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Hotels', `value`='7' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Inventory', `value`='2' ;
[05/21/2024 12:54:12], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Room', `value`='6' ;
[05/21/2024 12:54:13], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Market', `value`='19' ;
[05/21/2024 12:54:13], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('7@S000000001@2024-05-22@2024-05-22@@6@3@19@@@0','22-05-2024~22-05-2024','7','S000000001','2024-05-22','2024-05-22','6','3','43.239.53.130','0','0','ba755b4efb0c0c7024f839b24bc6c49b','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','ba755b4efb0c0c7024f839b24bc6c49b','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-23@2024-05-23@@6@3@19@@@0','23-05-2024~23-05-2024','7','S000000001','2024-05-23','2024-05-23','6','3','43.239.53.130','0','0','37161b0a6a4a1ae3066e952239c7d8a5','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','37161b0a6a4a1ae3066e952239c7d8a5','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-24@2024-05-24@@6@3@19@@@0','24-05-2024~24-05-2024','7','S000000001','2024-05-24','2024-05-24','6','3','43.239.53.130','0','0','8c06b7728b13ee375d1a12960136bb71','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','8c06b7728b13ee375d1a12960136bb71','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-25@2024-05-25@@6@3@19@@@0','25-05-2024~25-05-2024','7','S000000001','2024-05-25','2024-05-25','6','3','43.239.53.130','0','0','c35b45a440d0f385c88dae4c48d4ddb5','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','c35b45a440d0f385c88dae4c48d4ddb5','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-26@2024-05-26@@6@3@19@@@0','26-05-2024~26-05-2024','7','S000000001','2024-05-26','2024-05-26','6','3','43.239.53.130','0','0','c1dfbb67c8b2c8c5fb71f04294baf0b1','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','c1dfbb67c8b2c8c5fb71f04294baf0b1','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-27@2024-05-27@@6@3@19@@@0','27-05-2024~27-05-2024','7','S000000001','2024-05-27','2024-05-27','6','3','43.239.53.130','0','0','a34678ca634f342a03c9c7f30fc2ab75','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','a34678ca634f342a03c9c7f30fc2ab75','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-28@2024-05-28@@6@3@19@@@0','28-05-2024~28-05-2024','7','S000000001','2024-05-28','2024-05-28','6','3','43.239.53.130','0','0','ebb23952d724d3319a3dc685569343e2','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','ebb23952d724d3319a3dc685569343e2','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-29@2024-05-29@@6@3@19@@@0','29-05-2024~29-05-2024','7','S000000001','2024-05-29','2024-05-29','6','3','43.239.53.130','0','0','eb9df1a6fe01bdcf4265f4ab8e5a1799','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','eb9df1a6fe01bdcf4265f4ab8e5a1799','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-30@2024-05-30@@6@3@19@@@0','30-05-2024~30-05-2024','7','S000000001','2024-05-30','2024-05-30','6','3','43.239.53.130','0','0','0d1a309239d3c1332c002c062e4c5f42','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','0d1a309239d3c1332c002c062e4c5f42','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-05-31@2024-05-31@@6@3@19@@@0','31-05-2024~31-05-2024','7','S000000001','2024-05-31','2024-05-31','6','3','43.239.53.130','0','0','7e66f9b5afa0c5abf3332a8aff259417','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','7e66f9b5afa0c5abf3332a8aff259417','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-01@2024-06-01@@6@3@19@@@0','01-06-2024~01-06-2024','7','S000000001','2024-06-01','2024-06-01','6','3','43.239.53.130','0','0','a31f904a8ef9cd2c6b083cdbe64f5913','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','a31f904a8ef9cd2c6b083cdbe64f5913','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-02@2024-06-02@@6@3@19@@@0','02-06-2024~02-06-2024','7','S000000001','2024-06-02','2024-06-02','6','3','43.239.53.130','0','0','22b2c81792cef90e790ffcba3091acc3','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','22b2c81792cef90e790ffcba3091acc3','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-03@2024-06-03@@6@3@19@@@0','03-06-2024~03-06-2024','7','S000000001','2024-06-03','2024-06-03','6','3','43.239.53.130','0','0','ddbab43a10f8d20ca06d487028db145f','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','ddbab43a10f8d20ca06d487028db145f','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-04@2024-06-04@@6@3@19@@@0','04-06-2024~04-06-2024','7','S000000001','2024-06-04','2024-06-04','6','3','43.239.53.130','0','0','fbb33068c4d0608b8e17b0b9ffeecff0','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','fbb33068c4d0608b8e17b0b9ffeecff0','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-05@2024-06-05@@6@3@19@@@0','05-06-2024~05-06-2024','7','S000000001','2024-06-05','2024-06-05','6','3','43.239.53.130','0','0','f417e7f14c38c991ff0dac44d0650de5','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','f417e7f14c38c991ff0dac44d0650de5','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-06@2024-06-06@@6@3@19@@@0','06-06-2024~06-06-2024','7','S000000001','2024-06-06','2024-06-06','6','3','43.239.53.130','0','0','933892bdbfd8995eb5bc669e41600518','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','933892bdbfd8995eb5bc669e41600518','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-07@2024-06-07@@6@3@19@@@0','07-06-2024~07-06-2024','7','S000000001','2024-06-07','2024-06-07','6','3','43.239.53.130','0','0','d4519a58100a094fa1aafd50a3c93b9c','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','d4519a58100a094fa1aafd50a3c93b9c','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-08@2024-06-08@@6@3@19@@@0','08-06-2024~08-06-2024','7','S000000001','2024-06-08','2024-06-08','6','3','43.239.53.130','0','0','9449c51e65d65e4ca66e64b719c6f9da','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','9449c51e65d65e4ca66e64b719c6f9da','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-09@2024-06-09@@6@3@19@@@0','09-06-2024~09-06-2024','7','S000000001','2024-06-09','2024-06-09','6','3','43.239.53.130','0','0','54e72a2e83e6b3c47ca024b37b1947ca','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','54e72a2e83e6b3c47ca024b37b1947ca','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-10@2024-06-10@@6@3@19@@@0','10-06-2024~10-06-2024','7','S000000001','2024-06-10','2024-06-10','6','3','43.239.53.130','0','0','0644e6654451a5815369976b757779e0','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','0644e6654451a5815369976b757779e0','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-11@2024-06-11@@6@3@19@@@0','11-06-2024~11-06-2024','7','S000000001','2024-06-11','2024-06-11','6','3','43.239.53.130','0','0','31bec69c6795f08bb91c6c63aa43bcff','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','31bec69c6795f08bb91c6c63aa43bcff','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-12@2024-06-12@@6@3@19@@@0','12-06-2024~12-06-2024','7','S000000001','2024-06-12','2024-06-12','6','3','43.239.53.130','0','0','89fafbb16220a3a67911aae9ba2fd887','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','89fafbb16220a3a67911aae9ba2fd887','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-13@2024-06-13@@6@3@19@@@0','13-06-2024~13-06-2024','7','S000000001','2024-06-13','2024-06-13','6','3','43.239.53.130','0','0','0d37ba45f4cb63a3c927d89e7d066ce7','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','0d37ba45f4cb63a3c927d89e7d066ce7','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-14@2024-06-14@@6@3@19@@@0','14-06-2024~14-06-2024','7','S000000001','2024-06-14','2024-06-14','6','3','43.239.53.130','0','0','31392a17b814c7a0f811ea7ae8dfd3b6','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','31392a17b814c7a0f811ea7ae8dfd3b6','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-15@2024-06-15@@6@3@19@@@0','15-06-2024~15-06-2024','7','S000000001','2024-06-15','2024-06-15','6','3','43.239.53.130','0','0','92f80171368a396090d115947469fea5','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','92f80171368a396090d115947469fea5','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-16@2024-06-16@@6@3@19@@@0','16-06-2024~16-06-2024','7','S000000001','2024-06-16','2024-06-16','6','3','43.239.53.130','0','0','84828675c139ceabb1cca8baba9860e3','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','84828675c139ceabb1cca8baba9860e3','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-17@2024-06-17@@6@3@19@@@0','17-06-2024~17-06-2024','7','S000000001','2024-06-17','2024-06-17','6','3','43.239.53.130','0','0','dbe77151a3f1395218cfaaf998e0eae1','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','dbe77151a3f1395218cfaaf998e0eae1','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-18@2024-06-18@@6@3@19@@@0','18-06-2024~18-06-2024','7','S000000001','2024-06-18','2024-06-18','6','3','43.239.53.130','0','0','71d9433e83faa0c6216810c2dab78889','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','71d9433e83faa0c6216810c2dab78889','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-19@2024-06-19@@6@3@19@@@0','19-06-2024~19-06-2024','7','S000000001','2024-06-19','2024-06-19','6','3','43.239.53.130','0','0','8f535525fddd3926d4189c1568d840b9','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','8f535525fddd3926d4189c1568d840b9','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0',''),('7@S000000001@2024-06-20@2024-06-20@@6@3@19@@@0','20-06-2024~20-06-2024','7','S000000001','2024-06-20','2024-06-20','6','3','43.239.53.130','0','0','19f635d3dbe4e446613f6a4b3be4c6a4','Sa,Su','19','Supplier','2','A','20','20','USD','0','0','24','0','','','0','19f635d3dbe4e446613f6a4b3be4c6a4','2024-05-21 12:54:12','2024-05-21','Supplier','','','','','0','');
[05/21/2024 12:54:13], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[05/21/2024 12:54:13], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rate_profile (rate_profile,time_stamp) values(19,'38a7c39f574b3afd4497062c6cafc325'),(19,'ba755b4efb0c0c7024f839b24bc6c49b'),(19,'37161b0a6a4a1ae3066e952239c7d8a5'),(19,'8c06b7728b13ee375d1a12960136bb71'),(19,'c35b45a440d0f385c88dae4c48d4ddb5'),(19,'c1dfbb67c8b2c8c5fb71f04294baf0b1'),(19,'a34678ca634f342a03c9c7f30fc2ab75'),(19,'ebb23952d724d3319a3dc685569343e2'),(19,'eb9df1a6fe01bdcf4265f4ab8e5a1799'),(19,'0d1a309239d3c1332c002c062e4c5f42'),(19,'7e66f9b5afa0c5abf3332a8aff259417'),(19,'a31f904a8ef9cd2c6b083cdbe64f5913'),(19,'22b2c81792cef90e790ffcba3091acc3'),(19,'ddbab43a10f8d20ca06d487028db145f'),(19,'fbb33068c4d0608b8e17b0b9ffeecff0'),(19,'f417e7f14c38c991ff0dac44d0650de5'),(19,'933892bdbfd8995eb5bc669e41600518'),(19,'d4519a58100a094fa1aafd50a3c93b9c'),(19,'9449c51e65d65e4ca66e64b719c6f9da'),(19,'54e72a2e83e6b3c47ca024b37b1947ca'),(19,'0644e6654451a5815369976b757779e0'),(19,'31bec69c6795f08bb91c6c63aa43bcff'),(19,'89fafbb16220a3a67911aae9ba2fd887'),(19,'0d37ba45f4cb63a3c927d89e7d066ce7'),(19,'31392a17b814c7a0f811ea7ae8dfd3b6'),(19,'92f80171368a396090d115947469fea5'),(19,'84828675c139ceabb1cca8baba9860e3'),(19,'dbe77151a3f1395218cfaaf998e0eae1'),(19,'71d9433e83faa0c6216810c2dab78889'),(19,'8f535525fddd3926d4189c1568d840b9'),(19,'19f635d3dbe4e446613f6a4b3be4c6a4');
[05/21/2024 12:54:33], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-21 12:54:33',login_attempt=0 where id = '7857';
[05/21/2024 12:54:33], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-05-21 12:54:33', ip = '43.239.53.130', action = 'Login' ;
[05/21/2024 12:54:58], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1}]' , available='0' , create_date = '2024-05-21 12:54:58' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 12:55:01], [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)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 12:55:01', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1839');
[05/21/2024 12:55:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 12:55:00.706'
        , request_start_time = '0.052'
        , parsing_start_time = '0.024'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.482'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498072'
        WHERE id = '554794';
[05/21/2024 12:55:01], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.941',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '12.54',
        system_load_5_min = '17.58',
        system_load_15_min = '14.15',
        system_memory_usage = '97.44',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1839') + '6448368',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1839';
[05/21/2024 12:55:12], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 12:55:12' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 12:55:13], [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)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 12:55:13', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1840');
[05/21/2024 12:55:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 12:55:13.559'
        , request_start_time = '0.040'
        , parsing_start_time = '0.016'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.216'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5484976'
        WHERE id = '554795';
[05/21/2024 12:55:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.410',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.61',
        system_load_5_min = '16.91',
        system_load_15_min = '13.99',
        system_memory_usage = '95.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1840') + '6449352',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1840';
[05/21/2024 12:56:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 12:56:10' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 12:56:12], [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)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 12:56:12', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1841');
[05/21/2024 12:56:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 12:56:11.866'
        , request_start_time = '0.031'
        , parsing_start_time = '0.013'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.204'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497728'
        WHERE id = '554796';
[05/21/2024 12:56:12], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.367',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.86',
        system_load_5_min = '14.26',
        system_load_15_min = '13.25',
        system_memory_usage = '94.46',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1841') + '6449264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1841';
[05/21/2024 12:57:21], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO localsystem_cancellation_policy SET hotel_id='7',duration_type='days',from_duration='0',to_duration='1',amount_type='percentage',amount_value='10',from_date='2024-05-31',to_date='2024-05-31',supplier_id='S000000001',added_by='supplier';
[05/21/2024 12:57:21], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 12:57:21',`log_type`= 'Cancellation Policy',`sql_query`= 'INSERT INTO localsystem_cancellation_policy SET hotel_id=\&#039;7\&#039;,duration_type=\&#039;days\&#039;,from_duration=\&#039;0\&#039;,to_duration=\&#039;1\&#039;,amount_type=\&#039;percentage\&#039;,amount_value=\&#039;10\&#039;,from_date=\&#039;2024-05-31\&#039;,to_date=\&#039;2024-05-31\&#039;,supplier_id=\&#039;S000000001\&#039;,added_by=\&#039;supplier\&#039;',`log_description`= 'New cancellation policy added for qtech_test by- travelclick',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 12:57:21], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3394', `entity`='Hotels', `value`='7' ;
[05/21/2024 12:57:21], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3394', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 12:57:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 12:57:28' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 12:57:29], [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)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 12:57:29', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1842');
[05/21/2024 12:57:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 12:57:29.48'
        , request_start_time = '0.033'
        , parsing_start_time = '0.016'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.124'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497728'
        WHERE id = '554797';
[05/21/2024 12:57:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.285',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.11',
        system_load_5_min = '12.86',
        system_load_15_min = '12.87',
        system_memory_usage = '95.75',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1842') + '6449264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1842';
