[11/30/2023 07:01:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 07:01:04',login_attempt=0 where id = '7857';
[11/30/2023 07:01:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-30 07:01:04', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 07:01:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7857', session_id='1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9',create_date='2023-11-30 07:01:04', update_date='2023-11-30 07:01:04',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/30/2023 07:01:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:18' WHERE id= '181';
[11/30/2023 07:01:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:22' WHERE id= '181';
[11/30/2023 07:01:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/05' , departure_date = '2023/12/06' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-30 07:01:22' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/30/2023 07:01:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:23' WHERE id= '181';
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_64.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_64.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_64.json', 'expediapackage', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_41.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_41.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_41.json', 'expedia', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.536'
            , error_description = ''
            , memory_used = '3329632'
            WHERE id = '16131';
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.537'
            , error_description = ''
            , memory_used = '3328360'
            WHERE id = '16132';
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_50.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_50.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_50.json', 'expedia', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_33.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_33.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_33.json', 'expedia', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_76.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_76.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_76.json', 'expedia', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_64.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_64.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_64.json', 'expedia', '2023-11-30 07:01:24', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.007'
            , error_description = ''
            , memory_used = '15924712'
            WHERE id = '16134';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_29.json', 'e1/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_29.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_29.json', 'expedia', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.154'
            , error_description = ''
            , memory_used = '40318848'
            WHERE id = '16133';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_98.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_98.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_98.json', 'expediapackage', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.286'
            , error_description = ''
            , memory_used = '42719736'
            WHERE id = '16135';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.375'
            , error_description = ''
            , memory_used = '18243696'
            WHERE id = '16138';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.390'
            , error_description = ''
            , memory_used = '49013904'
            WHERE id = '16136';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_17.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_17.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_17.json', 'expediapackage', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.464'
            , error_description = ''
            , memory_used = '48820352'
            WHERE id = '16137';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_3.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_3.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_3.json', 'expediapackage', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_32.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_32.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_32.json', 'expediapackage', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_01_24_1701327684_22.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_01_24_1701327684_22.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_01_24_1701327684_22.json', 'expediapackage', '2023-11-30 07:01:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.802'
            , error_description = ''
            , memory_used = '44414136'
            WHERE id = '16139';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.934'
            , error_description = ''
            , memory_used = '53622936'
            WHERE id = '16140';
[11/30/2023 07:01:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.978'
            , error_description = ''
            , memory_used = '48707824'
            WHERE id = '16141';
[11/30/2023 07:01:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:01:23.981'
            , 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.202'
            , error_description = ''
            , memory_used = '54315024'
            WHERE id = '16142';
[11/30/2023 07:01:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:26' WHERE id= '181';
[11/30/2023 07:01:28], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:28' WHERE id= '181';
[11/30/2023 07:01:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:01:51' WHERE id= '181';
[11/30/2023 07:21:42], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'SUJAY_QTECH' , user_type = 'SUJAY_QTECH'_type , branch_id = '' , login_datetime = '2023-11-30 07:21:42' , ip = '43.239.53.130' , action = 'Logout'  ;
[11/30/2023 07:29:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],delete from agent_gateway where agent_id=7857;
[11/30/2023 07:29:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values
				('7857','1', '2023-11-30 07:29:44', 'admin#v3alpha#v3alpha', '43.239.53.130');
[11/30/2023 07:29:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values
				('7857','5', '2023-11-30 07:29:44', 'admin#v3alpha#v3alpha', '43.239.53.130');
[11/30/2023 07:29:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values
				('7857','6', '2023-11-30 07:29:44', 'admin#v3alpha#v3alpha', '43.239.53.130');
[11/30/2023 07:29:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values
				('7857','7', '2023-11-30 07:29:44', 'admin#v3alpha#v3alpha', '43.239.53.130');
[11/30/2023 07:29:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 07:29:49',login_attempt=0 where id = '7857';
[11/30/2023 07:29:49], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-30 07:29:49', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 07:29:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:29:49' WHERE id= '181';
[11/30/2023 07:31:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:31:53' WHERE id= '181';
[11/30/2023 07:32:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:06' WHERE id= '181';
[11/30/2023 07:32:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/14' , departure_date = '2024/02/15' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-30 07:32:06' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/30/2023 07:32:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:06' WHERE id= '181';
[11/30/2023 07:32:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_67.json', 'e1/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_67.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_67.json', 'expedia', '2023-11-30 07:32:07', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.223'
            , error_description = ''
            , memory_used = '3328128'
            WHERE id = '16143';
[11/30/2023 07:32:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_63.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_63.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_63.json', 'expediapackage', '2023-11-30 07:32:07', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.362'
            , error_description = ''
            , memory_used = '3329088'
            WHERE id = '16144';
[11/30/2023 07:32:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_70.json', 'e1/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_70.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_70.json', 'expedia', '2023-11-30 07:32:08', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_46.json', 'e1/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_46.json', 'e1/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_46.json', 'expedia', '2023-11-30 07:32:08', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:09], [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/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_73.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_73.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_73.json', 'expediapackage', '2023-11-30 07:32:09', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:09], [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/30_11_2023/request_availability_Deepak_T_07_32_06_1701329526_45.json', 'e1p/30_11_2023/response_availability_Deepak_T_07_32_06_1701329526_45.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_07_32_06_1701329526_45.json', 'expediapackage', '2023-11-30 07:32:09', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , 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.895'
            , error_description = ''
            , memory_used = '172335808'
            WHERE id = '16145';
[11/30/2023 07:32:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , 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.945'
            , error_description = ''
            , memory_used = '177094040'
            WHERE id = '16146';
[11/30/2023 07:32:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , 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.613'
            , error_description = ''
            , memory_used = '180481016'
            WHERE id = '16147';
[11/30/2023 07:32:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 07:32:06.828'
            , 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.795'
            , error_description = ''
            , memory_used = '188682360'
            WHERE id = '16148';
[11/30/2023 07:32:10], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:10' WHERE id= '181';
[11/30/2023 07:32:13], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:13' WHERE id= '181';
[11/30/2023 07:32:18], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:18' WHERE id= '181';
[11/30/2023 07:32:18], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:18' WHERE id= '181';
[11/30/2023 07:32:18], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701329538','43.239.53.130');
[11/30/2023 07:32:18], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/30_11_2023/request_valuation_Deepak_T_07_32_18_1701329538_6.json', 'e1p/30_11_2023/response_valuation_Deepak_T_07_32_18_1701329538_6.json', 'e1p/30_11_2023/response_header_valuation_Deepak_T_07_32_18_1701329538_6.json', 'expediapackage', '2023-11-30 07:32:18', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:18], [file name :-/home/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 ('Oyo 367 Eureka Hotel', 'dubai', '138', '7857', '', '28', '', 'hotelcancellationpolicy', '2023-11-30 :07:32:18','');
[11/30/2023 07:32:24], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:24' WHERE id= '181';
[11/30/2023 07:32:24], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:24' WHERE id= '181';
[11/30/2023 07:32:24], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701329544','43.239.53.130');
[11/30/2023 07:32:25], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/30_11_2023/request_valuation_Deepak_T_07_32_24_1701329544_80.json', 'e1p/30_11_2023/response_valuation_Deepak_T_07_32_24_1701329544_80.json', 'e1p/30_11_2023/response_header_valuation_Deepak_T_07_32_24_1701329544_80.json', 'expediapackage', '2023-11-30 07:32:25', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:32:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:31' WHERE id= '181';
[11/30/2023 07:32:36], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:36' WHERE id= '181';
[11/30/2023 07:32:36], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701329556','43.239.53.130');
[11/30/2023 07:32:38], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:38' WHERE id= '181';
[11/30/2023 07:32:38], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:32:38' WHERE id= '181';
[11/30/2023 07:32:38], [file name :-/home/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','61.39','2023-11-30 07:32:38','43.239.53.130','17013295583785','20231130073238','1144','uid_7857##fname_sujay##bid_129##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com','1144_1701329558_hotel','HP','on_selection','EUR');
[11/30/2023 07:33:21], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:33:21' WHERE id= '181';
[11/30/2023 07:33:21], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:192:\"entityId=8a829418537b334501537ebdbd6f03a9&paymentType=DB&amount=61&currency=EUR&merchantTransactionId=20231130073238&customer.email=&testMode=EXTERNAL&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='1144' and gateway_code='HP';
[11/30/2023 07:35:19], [file name :-/home/otrams/public_html/beta/payment_gateway_response.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:35:19' WHERE id= '181';
[11/30/2023 07:35:19], [file name :-/home/otrams/public_html/beta/payment_gateway_response.php],INSERT INTO hyperpay (agent_Id,payment_Id,registration_Id,currency,reg_date)
				VALUES ('7857','8ac7a49f8c1e3392018c1f274d553384','8ac7a4a08c1e3bb4018c1f274cc500b0','',NOW());
[11/30/2023 07:35:19], [file name :-/home/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:12:{s:2:\"id\";s:32:\"8ac7a49f8c1e3392018c1f274d553384\";s:14:\"registrationId\";s:32:\"8ac7a4a08c1e3bb4018c1f274cc500b0\";s:11:\"paymentType\";s:2:\"DB\";s:12:\"paymentBrand\";s:6:\"MASTER\";s:21:\"merchantTransactionId\";s:14:\"20231130073238\";s:6:\"result\";a:2:{s:4:\"code\";s:11:\"100.150.203\";s:11:\"description\";s:54:\"registration is not valid, probably initially rejected\";}s:4:\"card\";a:2:{s:3:\"bin\";s:6:\"545301\";s:11:\"last4Digits\";s:4:\"null\";}s:8:\"customer\";a:2:{s:2:\"ip\";s:13:\"43.239.53.130\";s:9:\"ipCountry\";s:2:\"IN\";}s:16:\"customParameters\";a:2:{s:24:\"SHOPPER_EndToEndIdentity\";s:64:\"21900305b952dd5e92bd7329f2db3052923d835ba831a5d57260905f36444625\";s:18:\"SHOPPER_customerId\";s:4:\"7857\";}s:11:\"buildNumber\";s:66:\"61f4269e734e3f28b436a8c288eb43715e898cc6@2023-11-28 00:42:34 +0000\";s:9:\"timestamp\";s:24:\"2023-11-30 07:35:18+0000\";s:3:\"ndc\";s:46:\"9B3FF8E85BEC978A8B5EE60F6D6F99A6.uat01-vm-tx02\";}',return_date='1701329719',payment_status='Transaction Successful',gateway_point='on_readresponse',orderID= '20231130073238' where unique_ref_id='' and gateway_code='HP';
[11/30/2023 07:35:19], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:35:19' WHERE id= '181';
[11/30/2023 07:35:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1144', create_date = '2023-11-30 07:35:20', agent_id = '7857', parent_agent_id = '7857', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '81.97', display_currency_code = 'USD', native_room_rate = '53.18', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/14', check_out_date = '2024/02/15', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'sujay', leader_last_name = 'Raut', status_date = '2023-11-30 07:35:20';
[11/30/2023 07:35:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='129'
		;
[11/30/2023 07:35:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('129','1144','','1','1','0','-','','','1722824','OYO 367 Eureka Hotel','Al Rigga Road, Deira','971-42954466','2.0','1','2024/02/14','2024/02/15','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzIwMDAwMDAvMTczMDAwMC8xNzIyOTAwLzE3MjI4MjQvMzhiYTVjOTRfYi5qcGc=');
[11/30/2023 07:35:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '129', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'KingBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 King Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:81.969999999999999;s:25:"displayNightlyRateDisplay";s:197:"Rate - 53.18, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 4 USD, Marketing Fee - 4  USD #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:53.18;}}', native_room_rate_total = '53.18', display_room_rate_total = '81.97', number_of_rooms = '1', room_category = 'KingBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 King Bed)', meal_basis = 'Room Only';
[11/30/2023 07:35:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '129', booking_detail_id = '1', rid = '135', room = '0', salutations = 'Mr', first_name = 'sujay', last_name = 'Raut', passenger_type = 'adult', age = '';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/30_11_2023/request_reservation_Deepak_T_07_35_20_1701329720_78.json', 'e1p/30_11_2023/response_reservation_Deepak_T_07_35_20_1701329720_78.json', 'e1p/30_11_2023/response_header_reservation_Deepak_T_07_35_20_1701329720_78.json', 'expediapackage', '2023-11-30 07:35:22', '', '1362c246c5cc4e6d4ab25f23a38bd4d49fcf8ef06bcb5a491c08dac54bf2d8a9', '0');
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7894384403104', confirmation_number = '7894384403104', display_discount = '0', cancellation_policy = 'Free cancellation up to  00:59:59 on  2024-02-10<br>If you cancel between 2024-02-10 01:00:00 and 2024-02-14 00:00:00 , you will be charged 81.97 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 01:00 on 10th of February 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-02-09 22:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 9.99 AED (2.72 USD)</b><br/><span style=\'color: red;\'><strong>Note:</strong> *This conversion is an approximate price based on the current exchange rate and may change before your stay.</span><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'b2btravel', sales_manager_id = '0', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 9.99 AED (2.72 USD)</b><br/><span style=\'color: red;\'><strong>Note:</strong> *This conversion is an approximate price based on the current exchange rate and may change before your stay.</span><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='54.14',  agent_markup='54.14',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='81.97',  applicable_service_tax='0',  supplier_rate='53.18',  uid='788b6a588c12f087475b72c03c4d7980'  where id='129';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='129';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('129','25.261046','55.325413');
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-30 07:35:22',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;129\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -129 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='371', `entity`='BookingId', `value`='129' ;
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_payment_gateway='1',payment_confirmation_no='',additional_charge='1.64' where  id ='129';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO cash_booking(booking_id,first_name,last_name,address,email,phone,mobile,payment_gateway,amount,pg_charges,currency,voucher_id,return_gateway_info,create_date,custom_commision,custom_markup,is_partial_payment,partial_amount)VALUES('129','Deepak','trivedi','mumbai 64440  106','sujay.raut@qtechsoftware.com','91-123456790','91-1234567890','HP','81.97','1.64','USD','20231130073238','a:12:{s:2:\"id\";s:32:\"8ac7a49f8c1e3392018c1f274d553384\";s:14:\"registrationId\";s:32:\"8ac7a4a08c1e3bb4018c1f274cc500b0\";s:11:\"paymentType\";s:2:\"DB\";s:12:\"paymentBrand\";s:6:\"MASTER\";s:21:\"merchantTransactionId\";s:14:\"20231130073238\";s:6:\"result\";a:2:{s:4:\"code\";s:11:\"100.150.203\";s:11:\"description\";s:54:\"registration is not valid, probably initially rejected\";}s:4:\"card\";a:2:{s:3:\"bin\";s:6:\"545301\";s:11:\"last4Digits\";s:4:\"null\";}s:8:\"customer\";a:2:{s:2:\"ip\";s:13:\"43.239.53.130\";s:9:\"ipCountry\";s:2:\"IN\";}s:16:\"customParameters\";a:2:{s:24:\"SHOPPER_EndToEndIdentity\";s:64:\"21900305b952dd5e92bd7329f2db3052923d835ba831a5d57260905f36444625\";s:18:\"SHOPPER_customerId\";s:4:\"7857\";}s:11:\"buildNumber\";s:66:\"61f4269e734e3f28b436a8c288eb43715e898cc6@2023-11-28 00:42:34 +0000\";s:9:\"timestamp\";s:24:\"2023-11-30 07:35:18+0000\";s:3:\"ndc\";s:46:\"9B3FF8E85BEC978A8B5EE60F6D6F99A6.uat01-vm-tx02\";}',now(),'0','0','no','');
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= 'INV30112300075', voucher_id='129',status_date='2023-11-30 07:35:22',current_status='vouchered',voucher_hashcode='babba3b59f07f6511f0dfec720c11dd954883129',vouchered_by ='' where id='129';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= 'INV30112300075' where id='129' and is_invoiced!='yes';
[11/30/2023 07:35:22], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '129', booking_log = 'Booking Vouchered', create_date = '2023-11-30 07:35:22', supplier_currency ='USD', type = 'Sale', agent_price = '81.97', sub_agent_price ='', supplier_price = '53.180', supplier_id = 'expediapackage', supplier_type = 'online';
[11/30/2023 07:35:23], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','129','vouchered-invoiced','2023-11-30 07:35:23','Booking invoiced by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','','','');
[11/30/2023 07:35:23], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='129',booking_detail_id ='129',agent_id ='7857',is_sub_agent ='N',parent_id ='',display_commission ='28.791652',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 54.14 %',create_date ='2023-11-30 07:35:23';
[11/30/2023 07:35:23], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO receipts(id,agent_id,payment_date,particulars,balance_before,amount_received,unadjusted_amount,payment_mode,bank_name,instrument_no,instrument_date,create_date,status,received_by,currency_code,site_id,log_link) VALUES ('','7857',now(),'Booking done from HP payment gateway.','-100.000','81.970','81.970','EFT','HP','','','','A','','USD','0','7');
[11/30/2023 07:35:23], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update receipts set docNo= 'RCT30112300000005' where id = '5';
[11/30/2023 07:35:23], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO receipts_bookings set booking_id='129',agent_id='7857',booking_rate_id='110',receipt_id='5',source_type='expediapackage',amount_received='81.970',payment_status='',service_type='hotel',site_id='0',create_date='2023-11-30 07:35:23';
[11/30/2023 07:35:24], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE receipts set unadjusted_amount=unadjusted_amount-'81.970' Where id='5';
[11/30/2023 07:35:24], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+81.970 Where booking_id= '129';
[11/30/2023 07:35:24], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','129','vouchered','2023-11-30 07:35:24','Voucherd by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','','','');
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update b2c_transctionlimit SET currentlimit='193649.785' where site_id='0';
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1144','129','confirmed','2023-11-30 07:35:22','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('129','2024-02-10 01:00:00','2024-02-10 01:00:00','2024-02-14 00:00:00','2024-02-14 00:00:00','53.18','81.97','0','2023-11-30 07:35:26','81.97');
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='129',status='1' where reservation_id='1144' and booking_id ='0';
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='129' where agent_logs_id='0' and source_type='expediapackage';
[11/30/2023 07:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='4',  commission_tax='',  booking_id ='129',  supplier_tax='5.91',  supplier_base_fare='47.27',  supplier_commissionable_fare='4'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-30 07:35:26';
[11/30/2023 07:36:41], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:36:41' WHERE id= '181';
[11/30/2023 07:36:47], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:36:47' WHERE id= '181';
[11/30/2023 07:38:05], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:38:05' WHERE id= '181';
[11/30/2023 07:38:05], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[11/30/2023 07:38:10], [file name :-/home/otrams/public_html/beta/get_cancellation_fee.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:38:10' WHERE id= '181';
[11/30/2023 07:38:12], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:38:12' WHERE id= '181';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('129', 'cancel', 'e1p/30_11_2023/request_cancel_Deepak_T_129_1701329892_63.json', 'e1p/30_11_2023/response_cancel_Deepak_T_129_1701329892_63.json', 'e1p/30_11_2023/response_header_cancel_Deepak_T_129_1701329892_63.json', 'expediapackage', '2023-11-30 07:38:13', '');
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='129', agent_id ='7857', itenirary_id ='7894384403104', confirmation_number ='7894384403104', payment_confirmation_no ='', voucher_id ='129', voucher_hashcode ='babba3b59f07f6511f0dfec720c11dd954883129', email_id ='', leader_title ='Mr', leader_first_name ='sujay', leader_last_name ='Raut', city_id ='dubai', country_id ='138', display_room_rate ='81.970', native_room_rate ='53.180', native_currency_code ='USD', additional_charge ='1.640', cancellation_policy ='Free cancellation up to  00:59:59 on  2024-02-10<br>If you cancel between 2024-02-10 01:00:00 and 2024-02-14 00:00:00 , you will be charged 81.97 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 01:00 on 10th of February 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2023-11-30 07:35:22', create_date ='2023-11-30 07:35:20', source_type ='expediapackage', expiration_date ='2024-02-09 22:00:00', comment_contract =' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 9.99 AED (2.72 USD)</b><br/><span style=\'color: red;\'><strong>Note:</strong> *This conversion is an approximate price based on the current exchange rate and may change before your stay.</span><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='1', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='81.970', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='53.180', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='b2btravel', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='54.14', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='54.14', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-11-30 07:38:13', modified_by ='', display_currency_code ='USD', created_datetime ='2023-11-30 07:38:13', sub_agent_rate ='0.000', created_by ='Deepak_T', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='43.239.53.130', is_cancel_history ='1';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','129','cancelled','2023-11-30 07:38:13','','7857','43.239.53.130','','','');
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2023-11-30 07:38:13' , pending_cancellation = 'no' WHERE reservation_id = '1144' AND id = '129' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='129';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='' , applicable_service_tax='0' WHERE id = '129' AND (current_status = 'cancelled' ) ;
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','USD','USD','1144','129','2023-11-30 07:38:13','',' ');
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE agents SET credit_usage=credit_usage+('-81.97'),   credit_value= credit_value-('-81.97') ,  cd_credit_usage=cd_credit_usage+('-81.97') , cd_credit_value=cd_credit_value-('-81.97')  WHERE id = '7857';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],insert into  agent_credit_log SET agent_id= '7857',credit_value= '181.970',credit_usage= '-181.970',credit_limit= '0.000',receipt_id= '',amount= '-81.97',booking_id='129',booking_cost= '',receipt_allocation= '81.97',balance= '-81.97',ip='43.239.53.130',user_type='User',admin_id='Agent - Deepak  trivedi(CA7857)',temp_credit_limit='',log_type='Booking Cancelled',note='Booking Cancelled',create_date='2023-11-30 07:11:13';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php], insert into booking_rate_info set  booking_id = '129', booking_log = 'Booking Cancelled', create_date = '2023-11-30 07:38:13', supplier_currency ='USD', type = 'Cancelled', agent_price = '-81.97', sub_agent_price ='', supplier_price = '-53.18', supplier_id = 'expediapackage', supplier_type = 'online';
[11/30/2023 07:38:13], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[11/30/2023 07:38:16], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:38:16' WHERE id= '181';
[11/30/2023 07:38:16], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[11/30/2023 07:38:17], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 07:38:17' WHERE id= '181';
[11/30/2023 07:38:17], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
