[07/18/2024 11:02:32], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_02_32_1721300552.xml','amadeus','2024-07-18 11:02:32','13562083');
[07/18/2024 11:02:32], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_02_32_1721300552.xml','Amadeus','2024-07-18 11:02:32','13562083');
[07/18/2024 11:08:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 11:08:22',login_attempt=0 where id = '949';
[07/18/2024 11:08:22], [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-18 11:08:22', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 11:08:49], [file name :-/efsdata/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , service_type = 'Airline' , arrival_date = '2024/07/30' , departure_date = '2024/07/31' , create_date = '2024-07-18 :11:08:49' , origin = 'DXB' , destination = 'BOM' , site_id = '' ;
[07/18/2024 11:08:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_08_54_1721300934.xml','amadeus','2024-07-18 11:08:54','13569653');
[07/18/2024 11:08:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_08_54_1721300934.xml','Amadeus','2024-07-18 11:08:54','13569653');
[07/18/2024 11:08:57], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_08_57_1721300937.xml','amadeus','2024-07-18 11:08:57','13569653');
[07/18/2024 11:08:57], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_08_57_1721300937.xml','Amadeus','2024-07-18 11:08:57','13569653');
[07/18/2024 11:09:18], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_09_18_1721300958.xml','amadeus','2024-07-18 11:09:18','13569653');
[07/18/2024 11:09:18], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_09_18_1721300958.xml','Amadeus','2024-07-18 11:09:18','13569653');
[07/18/2024 11:09:22], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_09_22_1721300962.xml','amadeus','2024-07-18 11:09:22','13569653');
[07/18/2024 11:09:22], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_09_22_1721300962.xml','Amadeus','2024-07-18 11:09:22','13569653');
[07/18/2024 11:09:22], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_09_22_1721300962.xml','amadeus','2024-07-18 11:09:22','13569653');
[07/18/2024 11:09:22], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_09_22_1721300962.xml','Amadeus','2024-07-18 11:09:22','13569653');
[07/18/2024 11:09:25], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_09_25_1721300965.xml','amadeus','2024-07-18 11:09:25','13569653');
[07/18/2024 11:09:25], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_09_25_1721300965.xml','Amadeus','2024-07-18 11:09:25','13569653');
[07/18/2024 11:11:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_11_54_1721301114.xml','amadeus','2024-07-18 11:11:54','13569653');
[07/18/2024 11:11:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_11_54_1721301114.xml','Amadeus','2024-07-18 11:11:54','13569653');
[07/18/2024 11:16:03], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_16_03_1721301363.xml','amadeus','2024-07-18 11:16:03','13569653');
[07/18/2024 11:16:03], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_16_03_1721301363.xml','Amadeus','2024-07-18 11:16:03','13569653');
[07/18/2024 11:17:01], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_17_01_1721301421.xml','amadeus','2024-07-18 11:17:01','13569653');
[07/18/2024 11:17:01], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_17_01_1721301421.xml','Amadeus','2024-07-18 11:17:01','13569653');
[07/18/2024 11:19:03], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_19_03_1721301543.xml','amadeus','2024-07-18 11:19:03','13569653');
[07/18/2024 11:19:04], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_19_03_1721301543.xml','Amadeus','2024-07-18 11:19:04','13569653');
[07/18/2024 11:19:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 11:19:29',login_attempt=0 where id = '7857';
[07/18/2024 11:19:29], [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-07-18 11:19:29', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 11:19:44], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/19' , departure_date = '2024/07/20' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 11:19:44' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/18/2024 11:19:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '367',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240711194433775405126',
        duration = '2.448',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.17',
        system_load_5_min = '7.96',
        system_load_15_min = '9.54',
        system_memory_usage = '62.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2616') + '2419824',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2616';
[07/18/2024 11:19:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721301597','43.239.53.130');
[07/18/2024 11:19:57], [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 ('', 'AVAILABILITY', 'e1/18_07_2024/request_availability_Deepak_T_2616_1721301597_85.json', 'e1/18_07_2024/response_availability_Deepak_T_2616_1721301597_85.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2616_1721301597_85.json', 'expedia', '2024-07-18 11:19:57', '', '78571820240711194433775405126', '2616', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2616_1721301597_85.json');
[07/18/2024 11:19:57], [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', 'e1/18_07_2024/request_valuation_Deepak_T_2616_1721301597_4.json', 'e1/18_07_2024/response_valuation_Deepak_T_2616_1721301597_4.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2616_1721301597_4.json', 'expedia', '2024-07-18 11:19:57', '', '78571820240711194433775405126', '2616', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2616_1721301597_4.json');
[07/18/2024 11:19:57], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('Nihal Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelratechange', '2024-07-18 :11:19:57','');
[07/18/2024 11:20:30], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721301630','43.239.53.130');
[07/18/2024 11:20:30], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','45.97','2024-07-18 11:20:30','43.239.53.130','17213016307398','20240718112030','4915','uid_7857##fname_supr##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4915_1721301630_hotel','HP','on_selection','EUR');
[07/18/2024 11:20:32], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:191:\"entityId=8a829418537b334501537ebdbd6f03a9&paymentType=DB&amount=46&currency=EUR&merchantTransactionId=20240718112030&customer.email=supriya@gmail.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4915_1721301630_hotel' and gateway_code='HP';
[07/18/2024 11:21:31], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_21_31_1721301691.xml','amadeus','2024-07-18 11:21:31','13569653');
[07/18/2024 11:21:31], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_21_31_1721301691.xml','Amadeus','2024-07-18 11:21:31','13569653');
[07/18/2024 11:32:36], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 11:32:36',login_attempt=0 where id = '7857';
[07/18/2024 11:32:37], [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-07-18 11:32:37', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 11:32:52], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/25' , departure_date = '2024/07/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 11:32:52' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/18/2024 11:32:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '373',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240711325233910897194',
        duration = '3.023',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '15.35',
        system_load_5_min = '8.80',
        system_load_15_min = '9.65',
        system_memory_usage = '70.42',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2617') + '2532176',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2617';
[07/18/2024 11:43:32], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721303012','43.239.53.130');
[07/18/2024 11:43:33], [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 ('', 'AVAILABILITY', 'e1/18_07_2024/request_availability_Deepak_T_2617_1721303012_23.json', 'e1/18_07_2024/response_availability_Deepak_T_2617_1721303012_23.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2617_1721303012_23.json', 'expedia', '2024-07-18 11:43:33', '', '78571820240711325233910897194', '2617', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2617_1721303012_23.json');
[07/18/2024 11:43:33], [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', 'e1/18_07_2024/request_valuation_Deepak_T_2617_1721303013_62.json', 'e1/18_07_2024/response_valuation_Deepak_T_2617_1721303013_62.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2617_1721303013_62.json', 'expedia', '2024-07-18 11:43:33', '', '78571820240711325233910897194', '2617', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2617_1721303013_62.json');
[07/18/2024 11:43:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='expedia Rate Change on Book Now Astra',  message='On Book Now page, Rate Change has been found for Supplier expedia:<br><br>Old Supplier  Rate:29.78 USD<br><font color=\'red\'><b>New Supplier rate:30.07 USD</b></font><br>Old Agent  Rate:57.63 USD<br><font color=\'red\'><b>Agent New rate:58.19 </b></font><br>Agency Name:Qtech<br>Agent Name:Deepak&nbsp;trivedi<br>City:dubai<br>Arrival Date:2024/07/25<br>Departure Date:2024/07/26<br>Supplier - expedia<br>Hotel:NIHAL HOTEL<br>Total Nights:1<br>Date :18-07-2024<br><b>Room Info</b><br><hr><b> Room Type </b>:Deluxe Room , 1 Double Bed or 2 Twin Beds , Room Only (Private sale: save 5%) <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:double<br><br> ',  email_sent ='yes', create_date ='2024-07-18 11:43:34', email_sent_to ='rohan.vartak@qtechsoftware.com,rohan.vartak@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[07/18/2024 11:43:34], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('Nihal Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelratechange', '2024-07-18 :11:43:34','');
[07/18/2024 11:43:55], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 11:43:55',login_attempt=0 where id = '7851';
[07/18/2024 11:43:55], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-07-18 11:43:55', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 11:44:10], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721303050','43.239.53.130');
[07/18/2024 11:44:11], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','44.46','2024-07-18 11:44:11','43.239.53.130','17213030519435','20240718114411','4917','uid_7857##fname_supr##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4917_1721303051_hotel','HP','on_selection','EUR');
[07/18/2024 11:44:54], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:191:\"entityId=8a829418537b334501537ebdbd6f03a9&paymentType=DB&amount=44&currency=EUR&merchantTransactionId=20240718114411&customer.email=supriya@gmail.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4917_1721303051_hotel' and gateway_code='HP';
[07/18/2024 11:45:52], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:4:{s:6:\"result\";a:3:{s:4:\"code\";s:11:\"200.300.404\";s:11:\"description\";s:28:\"invalid or missing parameter\";s:15:\"parameterErrors\";a:1:{i:0;a:3:{s:4:\"name\";s:8:\"entityId\";s:5:\"value\";N;s:7:\"message\";s:28:\"invalid or missing parameter\";}}}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 11:45:51+0000\";s:3:\"ndc\";s:46:\"C5C7A3B3855656562101F1492A99158A.uat01-vm-tx02\";}',return_date='1721303151',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 11:45:52], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','0','2024-07-18 11:45:52','43.239.53.130','17213031522015','','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 11:45:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_11_45_54_1721303154.xml','amadeus','2024-07-18 11:45:54','13569653');
[07/18/2024 11:45:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_11_45_54_1721303154.xml','Amadeus','2024-07-18 11:45:54','13569653');
[07/18/2024 11:50:21], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:4:{s:6:\"result\";a:3:{s:4:\"code\";s:11:\"200.300.404\";s:11:\"description\";s:28:\"invalid or missing parameter\";s:15:\"parameterErrors\";a:1:{i:0;a:3:{s:4:\"name\";s:8:\"entityId\";s:5:\"value\";N;s:7:\"message\";s:28:\"invalid or missing parameter\";}}}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 11:50:21+0000\";s:3:\"ndc\";s:46:\"232461B2EFE27E4A8764E79C6C10BA83.uat01-vm-tx04\";}',return_date='1721303420',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 11:50:21], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('','0','2024-07-18 11:50:21','185.147.172.66','17213034219510','','','uid_##fname_##bid_652##route_bookflow##type_B2B##pg_##mob_##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 11:53:11], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:16:{s:2:\"id\";s:32:\"8ac7a4a290c3cdd20190c5a99c3e1ba8\";s:11:\"paymentType\";s:2:\"DB\";s:12:\"paymentBrand\";s:4:\"VISA\";s:6:\"amount\";s:5:\"44.00\";s:8:\"currency\";s:3:\"EUR\";s:10:\"descriptor\";s:34:\"9838.6367.8671 Bawadi Tours - Euro\";s:21:\"merchantTransactionId\";s:14:\"20240718114411\";s:6:\"result\";a:2:{s:4:\"code\";s:11:\"000.100.110\";s:11:\"description\";s:68:\"Request successfully processed in \'Merchant in Integrator Test Mode\'\";}s:13:\"resultDetails\";a:10:{s:13:\"CscResultCode\";s:11:\"Unsupported\";s:21:\"clearingInstituteName\";s:4:\"SAIB\";s:20:\"TransactionIdentfier\";s:19:\"1234567890123456789\";s:14:\"ConnectorTxID1\";s:32:\"8ac7a4a290c3cdd20190c5a99c3e1ba8\";s:11:\"connectorId\";s:3:\"540\";s:9:\"VerStatus\";s:1:\"E\";s:7:\"BatchNo\";s:8:\"20111101\";s:10:\"endToEndId\";s:14:\"26233508514971\";s:11:\"AuthorizeId\";s:6:\"061452\";s:13:\"AvsResultCode\";s:11:\"Unsupported\";}s:4:\"card\";a:13:{s:3:\"bin\";s:6:\"444000\";s:10:\"binCountry\";s:2:\"GB\";s:11:\"last4Digits\";s:4:\"0010\";s:6:\"holder\";s:7:\"supriya\";s:11:\"expiryMonth\";s:2:\"01\";s:10:\"expiryYear\";s:4:\"2039\";s:6:\"issuer\";a:3:{s:4:\"bank\";s:19:\"CLYDESDALE BANK PLC\";s:7:\"website\";s:26:\"HTTP://WWW.CBONLINE.CO.UK/\";s:5:\"phone\";s:10:\"8006783320\";}s:4:\"type\";s:5:\"DEBIT\";s:5:\"level\";s:16:\"PREPAID ELECTRON\";s:7:\"country\";s:2:\"GB\";s:12:\"maxPanLength\";s:2:\"16\";s:7:\"binType\";s:8:\"PERSONAL\";s:13:\"regulatedFlag\";s:1:\"N\";}s:8:\"customer\";a:3:{s:5:\"email\";s:17:\"supriya@gmail.com\";s:2:\"ip\";s:15:\"103.104.226.130\";s:9:\"ipCountry\";s:2:\"IN\";}s:16:\"customParameters\";a:3:{s:24:\"SHOPPER_EndToEndIdentity\";s:64:\"0578dc79d94d33a6fca44235b86442437f353818087e189689de46edef289343\";s:24:\"CTPE_DESCRIPTOR_TEMPLATE\";s:0:\"\";s:18:\"SHOPPER_customerId\";s:4:\"7857\";}s:4:\"risk\";a:1:{s:5:\"score\";s:1:\"0\";}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 11:45:50+0000\";s:3:\"ndc\";s:46:\"C5C7A3B3855656562101F1492A99158A.uat01-vm-tx02\";}',return_date='1721303590',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '20240718114411' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 11:53:11], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','0','2024-07-18 11:53:11','43.239.53.130','17213035918215','','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 11:54:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-18 11:54:28',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7857 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 24 ',`ip`= '43.239.53.130';
[07/18/2024 11:55:04], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_name= '',first_name= 'Deepak',middle_name= '',last_name= 'trivedi',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '2000.000',credit_limit= '2000.000',credit_distribution= '0',temp_credit_limit= '',address= 'mumbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '3',enable_dst= '',branch_id='23',phone= '91-123456790',mobile= '91-1234567890',fax= '',currency= '6',email= 'deepak.trivedi@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2024-07-18 11:55:04',consultant_id= 'b2btravel',agency_email= '',acc_name= 'DEEPAK',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',allow_credit_use= '1' WHERE id= '7857';
[07/18/2024 11:55:04], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-18 11:55:04',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Deepak\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;trivedi\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;2000.000\&#039;,credit_limit= \&#039;2000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;mumbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;3\&#039;,enable_dst= 0,branch_id=\&#039;23\&#039;,phone= \&#039;91-123456790\&#039;,mobile= \&#039;91-1234567890\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= ,can_voucher= 1,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2024-07-18 11:55:04\&#039;,consultant_id= \&#039;b2btravel\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;DEEPAK\&#039;,acc_email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,allow_credit_use= 1 WHERE id= \&#039;7857\&#039;',`log_description`= 'Agent 7857 updated For  - email=sujay.raut%40qtechsoftware.com&modify_date=2024-06-03+12%3A59%3A29 changed to - email=deepak.trivedi%40qtechsoftware.com&modify_date=2024-07-18+11%3A55%3A04',`ip`= '43.239.53.130';
[07/18/2024 11:55:04], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7857' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[07/18/2024 11:55:04], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7857',credit_value= '2000.000',credit_usage= '0.000',credit_limit= '2000.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by v3alpha',create_date='2024-07-18 11:07:04';
[07/18/2024 11:55:04], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '23',consultant_id= 'b2btravel',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7857';
[07/18/2024 11:55:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],delete from agent_gateway where agent_id=7857;
[07/18/2024 11:55:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values ('7857','1', '2024-07-18 11:55:20', 'admin#v3alpha#v3alpha', '43.239.53.130');
[07/18/2024 11:55:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 11:55:22',login_attempt=0 where id = '7857';
[07/18/2024 11:55:22], [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-07-18 11:55:22', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 11:55:38], [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 = 'bali' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/08/31' , departure_date = '2024/09/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-18 11:55:38' , 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/18/2024 11:55:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '970',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240711553877308016738',
        duration = '3.483',
        merge_duration = '0.010',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '17.12',
        system_load_5_min = '18.29',
        system_load_15_min = '15.15',
        system_memory_usage = '78.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2618') + '3559672',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2618';
[07/18/2024 11:55:51], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721303751','43.239.53.130');
[07/18/2024 11:55:51], [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 ('', 'AVAILABILITY', 'e1/18_07_2024/request_availability_Deepak_T_2618_1721303751_49.json', 'e1/18_07_2024/response_availability_Deepak_T_2618_1721303751_49.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2618_1721303751_49.json', 'expedia', '2024-07-18 11:55:51', '', '78571820240711553877308016738', '2618', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2618_1721303751_49.json');
[07/18/2024 11:55:51], [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', 'e1/18_07_2024/request_valuation_Deepak_T_2618_1721303751_43.json', 'e1/18_07_2024/response_valuation_Deepak_T_2618_1721303751_43.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2618_1721303751_43.json', 'expedia', '2024-07-18 11:55:51', '', '78571820240711553877308016738', '2618', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2618_1721303751_43.json');
[07/18/2024 11:55:51], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('Restu Bali', 'bali', '107', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-07-18 :11:55:51','');
[07/18/2024 11:56:17], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721303777','43.239.53.130');
[07/18/2024 11:56:18], [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 ('', 'AVAILABILITY', 'e1/18_07_2024/request_availability_Deepak_T_2618_1721303777_6.json', 'e1/18_07_2024/response_availability_Deepak_T_2618_1721303777_6.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2618_1721303777_6.json', 'expedia', '2024-07-18 11:56:18', '', '78571820240711553877308016738', '2618', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2618_1721303777_6.json');
[07/18/2024 11:56:18], [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', 'e1/18_07_2024/request_valuation_Deepak_T_2618_1721303778_44.json', 'e1/18_07_2024/response_valuation_Deepak_T_2618_1721303778_44.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2618_1721303778_44.json', 'expedia', '2024-07-18 11:56:18', '', '78571820240711553877308016738', '2618', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2618_1721303778_44.json');
[07/18/2024 11:56:46], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721303806','43.239.53.130');
[07/18/2024 11:56:47], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','33.92','2024-07-18 11:56:47','43.239.53.130','17213038071601','20240718115647','4920','uid_7857##fname_deepak##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_deepak.trivedi@qtechsoftware.com##phone_1234567890##siteurl_beta.astrabookings.com','4920_1721303807_hotel','HP','on_selection','EUR');
[07/18/2024 11:56:50], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:206:\"entityId=8a829418537b334501537ebdbd6f03a9&paymentType=DB&amount=34&currency=EUR&merchantTransactionId=20240718115647&customer.email=deepak.trivedi@qtechsoftware.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4920_1721303807_hotel' and gateway_code='HP';
