[06/15/2023 04:43:40], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '72.9.144.10' , city = 'Atlanta(ga)' , service_name = '' , country_of_residence = 'IN' , service_type = 'hotel' , arrival_date = '2023/06/17' , departure_date = '2023/06/20' , nights = '3' , nationality = 'IN' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-15 04:43:40' , site_id = '' , country_code = '1' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/15/2023 04:43:44], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_06_2023/request_availability_24X7rooms_04_43_40_1686804220_92.json', 'e1p/15_06_2023/response_availability_24X7rooms_04_43_40_1686804220_92.json', 'e1p/15_06_2023/response_header_availability_24X7rooms_04_43_40_1686804220_92.json', 'expediapackage', '2023-06-15 04:43:44', '', '77371520230604434031701493456', '0');
[06/15/2023 04:43:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371520230604434031701493456&xml_user_id=7737&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=16&ip=72.9.144.10&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-15 04:43:40.971'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.462'
            , error_description = ''
            , memory_used = '50763016'
            WHERE id = '343';
[06/15/2023 04:43:44], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_search_24X7rooms_04_43_44_1686804224_6278883.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_search_24X7rooms_04_43_44_1686804224_6278883.txt','7737','77371520230604434031701493456','0','2023-06-15 04:43:40','2023-06-15 04:43:44','hotel_search','','','4','0');
[06/15/2023 04:43:54], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '72.9.144.10' , city = 'Atlanta(ga)' , service_name = '' , country_of_residence = 'IN' , service_type = 'hotel' , arrival_date = '2023/06/17' , departure_date = '2023/06/20' , nights = '3' , nationality = 'IN' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-15 04:43:54' , site_id = '' , country_code = '1' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/15/2023 04:43:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_06_2023/request_availability_24X7rooms_04_43_55_1686804235_83.json', 'e1p/15_06_2023/response_availability_24X7rooms_04_43_55_1686804235_83.json', 'e1p/15_06_2023/response_header_availability_24X7rooms_04_43_55_1686804235_83.json', 'expediapackage', '2023-06-15 04:43:57', '', '77371520230604435445325589651', '0');
[06/15/2023 04:43:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371520230604435445325589651&xml_user_id=7737&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=16&ip=72.9.144.10&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-15 04:43:55.28'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.676'
            , error_description = ''
            , memory_used = '50761944'
            WHERE id = '344';
[06/15/2023 04:43:57], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_search_24X7rooms_04_43_57_1686804237_5688037.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_search_24X7rooms_04_43_57_1686804237_5688037.txt','7737','77371520230604435445325589651','0','2023-06-15 04:43:54','2023-06-15 04:43:57','hotel_search','','','3','0');
[06/15/2023 04:44:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Indigo Atlanta Downtown, An Ihg Hotel', 'Atlanta(ga)', '1', '7737', '', '1', '', 'hoteldetails', '2023-06-15 :04:44:26','');
[06/15/2023 04:44:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_detail_24X7rooms_04_44_26_1686804266_8859580.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_detail_24X7rooms_04_44_26_1686804266_8859580.txt','7737','77371520230604435445325589651','0','2023-06-15 04:44:26','2023-06-15 04:44:26','hotel_detail','','','0','');
[06/15/2023 04:45:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Indigo Atlanta Downtown, An Ihg Hotel', 'Atlanta(ga)', '1', '7737', '', '1', '', 'hoteldetails', '2023-06-15 :04:45:26','');
[06/15/2023 04:45:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_detail_24X7rooms_04_45_26_1686804326_2647006.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_detail_24X7rooms_04_45_26_1686804326_2647006.txt','7737','77371520230604435445325589651','0','2023-06-15 04:45:26','2023-06-15 04:45:26','hotel_detail','','','0','');
[06/15/2023 04:45:42], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/15_06_2023/request_valuation_24X7rooms_04_45_40_1686804340_1.json', 'e1p/15_06_2023/response_valuation_24X7rooms_04_45_40_1686804340_1.json', 'e1p/15_06_2023/response_header_valuation_24X7rooms_04_45_40_1686804340_1.json', 'expediapackage', '2023-06-15 04:45:42', '', '77371520230604435445325589651', '0');
[06/15/2023 04:45:42], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_cancellation_policy_24X7rooms_04_45_42_1686804342_1_11062233-63_58193_5561797.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_cancellation_policy_24X7rooms_04_45_42_1686804342_1_11062233-63_58193_5561797.txt','7737','77371520230604435445325589651','0','2023-06-15 04:45:40','2023-06-15 04:45:42','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','2','');
[06/15/2023 04:45:52], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/15_06_2023/request_valuation_24X7rooms_04_45_51_1686804351_63.json', 'e1p/15_06_2023/response_valuation_24X7rooms_04_45_51_1686804351_63.json', 'e1p/15_06_2023/response_header_valuation_24X7rooms_04_45_51_1686804351_63.json', 'expediapackage', '2023-06-15 04:45:52', '', '77371520230604435445325589651', '0');
[06/15/2023 04:45:52], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_cancellation_policy_24X7rooms_04_45_52_1686804352_1_11062233-63_33378_9747235.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_cancellation_policy_24X7rooms_04_45_52_1686804352_1_11062233-63_33378_9747235.txt','7737','77371520230604435445325589651','0','2023-06-15 04:45:51','2023-06-15 04:45:52','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','1','');
[06/15/2023 04:46:21], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/15_06_2023/request_valuation_24X7rooms_04_46_21_1686804381_70.json', 'e1p/15_06_2023/response_valuation_24X7rooms_04_46_21_1686804381_70.json', 'e1p/15_06_2023/response_header_valuation_24X7rooms_04_46_21_1686804381_70.json', 'expediapackage', '2023-06-15 04:46:21', '', '77371520230604435445325589651', '0');
[06/15/2023 04:46:21], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/request_hotel_cancellation_policy_24X7rooms_04_46_21_1686804381_1_11062233-63_80055_4352004.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/15_06_2023/response_hotel_cancellation_policy_24X7rooms_04_46_21_1686804381_1_11062233-63_80055_4352004.txt','7737','77371520230604435445325589651','0','2023-06-15 04:46:21','2023-06-15 04:46:21','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','0','');
