[03/04/2024 06:00:37], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-04 06:00:37',login_attempt=0 where id = '7868';
[03/04/2024 06:00:37], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '32', login_datetime = '2024-03-04 06:00:37', ip = '43.239.53.130', action = 'Login' ;
[03/04/2024 06:00:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74',create_date='2024-03-04 06:00:37', update_date='2024-03-04 06:00:37',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[03/04/2024 06:00:43], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:43' WHERE id= '619';
[03/04/2024 06:00:46], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:46' WHERE id= '619';
[03/04/2024 06:00:49], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:49' WHERE id= '619';
[03/04/2024 06:00:49], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:00:49], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:49' WHERE id= '619';
[03/04/2024 06:00:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:49' WHERE id= '619';
[03/04/2024 06:00:55], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:55' WHERE id= '619';
[03/04/2024 06:00:57], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:57' WHERE id= '619';
[03/04/2024 06:00:57], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:00:58], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:58' WHERE id= '619';
[03/04/2024 06:00:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:00:58' WHERE id= '619';
[03/04/2024 06:01:00], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:00' WHERE id= '619';
[03/04/2024 06:01:02], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:02' WHERE id= '619';
[03/04/2024 06:01:02], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:01:02], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:02' WHERE id= '619';
[03/04/2024 06:01:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:02' WHERE id= '619';
[03/04/2024 06:01:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:05' WHERE id= '619';
[03/04/2024 06:01:07], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:01:07' WHERE id= '619';
[03/04/2024 06:01:07], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:04:07], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:04:07' WHERE id= '619';
[03/04/2024 06:04:07], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:04:11], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:04:11' WHERE id= '619';
[03/04/2024 06:04:11], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:04:57], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:04:57' WHERE id= '619';
[03/04/2024 06:04:57], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:05:40], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:05:40' WHERE id= '619';
[03/04/2024 06:05:40], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:05:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:05:50' WHERE id= '619';
[03/04/2024 06:05:53], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:05:53' WHERE id= '619';
[03/04/2024 06:05:53], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:05:54], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:05:54' WHERE id= '619';
[03/04/2024 06:05:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:05:54' WHERE id= '619';
[03/04/2024 06:07:48], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:07:48' WHERE id= '619';
[03/04/2024 06:07:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:07:49' WHERE id= '619';
[03/04/2024 06:07:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:07:53' WHERE id= '619';
[03/04/2024 06:08:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:08' WHERE id= '619';
[03/04/2024 06:08:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:09' WHERE id= '619';
[03/04/2024 06:08:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/11/27' , departure_date = '2024/11/29' , nights = '2' , nationality = '106' , room_types = '2, 1.1' , room_type='[{"numberOfAdults":2},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"1"}]' , available='0' , create_date = '2024-03-04 06:08:09' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/04/2024 06:08:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:09' WHERE id= '619';
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_7_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_7_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_7_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_9_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_9_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_9_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_4_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_4_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_4_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_2_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_2_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_2_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_10_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_10_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_10_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_3_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_3_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_3_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_6_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_6_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_6_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_1_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_1_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_1_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_11_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_11_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_11_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_8_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_8_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_8_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_5_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_5_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_5_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_18_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_18_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_18_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_15_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_15_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_15_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_13_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_13_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_13_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_14_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_14_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_14_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_17_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_17_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_17_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_12_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_12_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_12_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 't7/04_03_2024/request_Availability__hotel_yards_16_06_08_10_1709532490.xml', 't7/04_03_2024/response_Availability__hotel_yards_16_06_08_10_1709532490.xml', 't7/04_03_2024/response_header_Availability__hotel_yards_16_06_08_10_1709532490.xml', 'tboholidays', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=0&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.281'
        , error_description = ''
        , memory_used = '1394264'
        WHERE id = '46796';
[03/04/2024 06:08:10], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_22.json', 'e1p/04_03_2024/response_availability_hotel_yards_46_1709532490_22.json', 'e1p/04_03_2024/response_header_availability_hotel_yards_46_1709532490_22.json', 'expediapackage', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.298'
        , error_description = ''
        , memory_used = '2343224'
        WHERE id = '46815';
[03/04/2024 06:08:10], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_98.json', 'e1/04_03_2024/response_availability_hotel_yards_46_1709532490_98.json', 'e1/04_03_2024/response_header_availability_hotel_yards_46_1709532490_98.json', 'expedia', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.311'
        , error_description = ''
        , memory_used = '2343152'
        WHERE id = '46816';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=2&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.314'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46800';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__5_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__5_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__5_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=3&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.329'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46802';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.332'
        , error_description = ''
        , memory_used = '2759920'
        WHERE id = '46817';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=6&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.335'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46803';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=7&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.341'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46797';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__0_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__0_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__0_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.347'
        , error_description = ''
        , memory_used = '2760384'
        WHERE id = '46818';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__2_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__2_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__2_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=11&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.408'
        , 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.364'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46805';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.365'
        , error_description = ''
        , memory_used = '2760240'
        WHERE id = '46819';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=5&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.368'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46807';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=9&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.373'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46798';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__8_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__8_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__8_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.379'
        , error_description = ''
        , memory_used = '2732512'
        WHERE id = '46820';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__6_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__6_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__6_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__3_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__3_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__3_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=4&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.390'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46799';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.390'
        , error_description = ''
        , memory_used = '2760384'
        WHERE id = '46821';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__4_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__4_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__4_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.394'
        , error_description = ''
        , memory_used = '2760256'
        WHERE id = '46822';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__1_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__1_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__1_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.398'
        , error_description = ''
        , memory_used = '2760256'
        WHERE id = '46823';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.401'
        , error_description = ''
        , memory_used = '2760256'
        WHERE id = '46824';
[03/04/2024 06:08:10], [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', 'd1/04_03_2024/request_availability_hotel_yards__7_06_08_10_1709532490.xml', 'd1/04_03_2024/response_availability_hotel_yards__7_06_08_10_1709532490.xml', 'd1/04_03_2024/response_header_availability_hotel_yards__7_06_08_10_1709532490.xml', 'dotw', '2024-03-04 06:08:10', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=14&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.408'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46811';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.410'
        , error_description = ''
        , memory_used = '2760384'
        WHERE id = '46825';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=13&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.421'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46810';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=16&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.424'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46814';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=15&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.429'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46809';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=10&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.435'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46801';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=1&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.441'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46804';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=8&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.447'
        , error_description = ''
        , memory_used = '1394568'
        WHERE id = '46806';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=18&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.452'
        , error_description = ''
        , memory_used = '1392256'
        WHERE id = '46808';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=17&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.457'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46812';
[03/04/2024 06:08:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=12&total_request=19&hotel_ids=&web_service=no'
        , http_hit_time = '2024-03-04 06:08:10.406'
        , 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.463'
        , error_description = ''
        , memory_used = '1394808'
        WHERE id = '46813';
[03/04/2024 06:08:11], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_85.json', 'e1/04_03_2024/response_availability_hotel_yards_46_1709532490_85.json', 'e1/04_03_2024/response_header_availability_hotel_yards_46_1709532490_85.json', 'expedia', '2024-03-04 06:08:11', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:12], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_54.json', 'e1/04_03_2024/response_availability_hotel_yards_46_1709532490_54.json', 'e1/04_03_2024/response_header_availability_hotel_yards_46_1709532490_54.json', 'expedia', '2024-03-04 06:08:12', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:12], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_70.json', 'e1p/04_03_2024/response_availability_hotel_yards_46_1709532490_70.json', 'e1p/04_03_2024/response_header_availability_hotel_yards_46_1709532490_70.json', 'expediapackage', '2024-03-04 06:08:12', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:12], [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/04_03_2024/request_availability_hotel_yards_46_1709532490_70.json', 'e1p/04_03_2024/response_availability_hotel_yards_46_1709532490_70.json', 'e1p/04_03_2024/response_header_availability_hotel_yards_46_1709532490_70.json', 'expediapackage', '2024-03-04 06:08:12', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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.464'
        , error_description = ''
        , memory_used = '216992448'
        WHERE id = '46826';
[03/04/2024 06:08:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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 = '4.147'
        , error_description = ''
        , memory_used = '283343536'
        WHERE id = '46827';
[03/04/2024 06:08:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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 = '4.181'
        , error_description = ''
        , memory_used = '230208168'
        WHERE id = '46829';
[03/04/2024 06:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F122.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-04 06:08:10.407'
        , 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 = '4.652'
        , error_description = ''
        , memory_used = '299650000'
        WHERE id = '46828';
[03/04/2024 06:08:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '309',
        request_path = '/xml_all.php?userid=7867&sessionid=48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74',
        duration = '6.343',
        merge_duration = '1.202',
        assigned_supplier_count = '6',
        searched_supplier_count = '4',
        system_load_1_min = '0.10',
        system_load_5_min = '0.15',
        system_load_15_min = '0.15',
        system_memory_usage = '42.99',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '46') + '53671544',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '46';
[03/04/2024 06:08:16], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:16' WHERE id= '619';
[03/04/2024 06:08:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:16' WHERE id= '619';
[03/04/2024 06:08:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:16' WHERE id= '619';
[03/04/2024 06:08:25], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:25' WHERE id= '619';
[03/04/2024 06:08:26], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:26' WHERE id= '619';
[03/04/2024 06:08:26], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1709532506','43.239.53.130');
[03/04/2024 06:08:26], [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/04_03_2024/request_valuation_hotel_yards_46_1709532506_95.json', 'e1p/04_03_2024/response_valuation_hotel_yards_46_1709532506_95.json', 'e1p/04_03_2024/response_header_valuation_hotel_yards_46_1709532506_95.json', 'expediapackage', '2024-03-04 06:08:26', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:08:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:45' WHERE id= '619';
[03/04/2024 06:08:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:50' WHERE id= '619';
[03/04/2024 06:08:51], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:08:51' WHERE id= '619';
[03/04/2024 06:09:09], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:09:09' WHERE id= '619';
[03/04/2024 06:09:09], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1709532549','43.239.53.130');
[03/04/2024 06:09:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:09:10' WHERE id= '619';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '3247', create_date = '2024-03-04 06:09:11', agent_id = '7867', parent_agent_id = '7867', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '308.8', display_currency_code = 'USD', native_room_rate = '308.8', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/11/27', check_out_date = '2024/11/29', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'PRiyanka', leader_last_name = 'test', status_date = '2024-03-04 06:09:11';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('500','LOTUS GRAND HOTEL','Lotus Grand Hotel','8836227','OT000039076','dubai','expediapackage',NOW());
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '32'
		WHERE
		id='500'
		;
[03/04/2024 06:09:11], [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('500','3247','','2','3','1','-','','','8836227','Lotus Grand Hotel','Al Riqqa road, Deira Opposite Al Ghurair Shopping Mall','971-4-7035801','4.0','2','2024/11/27','2024/11/29','','https://hotelyards.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzkwMDAwMDAvODg0MDAwMC84ODM2MzAwLzg4MzYyMjcvMGRkNTM4MDhfYi5qcGc=');
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '500', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'KingBed Deluxe Double or Twin Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 King Bed)', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:"displayNightlyRate";d:81.829999999999998;s:25:"displayNightlyRateDisplay";s:154:"Rate - 81.83,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.94 USD, Marketing Fee - 5.94  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:82.239999999999995;}i:1;a:3:{s:18:"displayNightlyRate";d:72.569999999999993;s:25:"displayNightlyRateDisplay";s:154:"Rate - 72.57,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.94 USD, Marketing Fee - 5.94  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:72.930000000000007;}}', native_nightly_rates = 'a:2:{i:0;a:1:{s:17:"nativeNightlyRate";d:81.829999999999998;}i:1;a:1:{s:17:"nativeNightlyRate";d:72.569999999999993;}}', native_room_rate_total = '154.4', wh_room_rate_total = '155.17', display_room_rate_total = '154.4', number_of_rooms = '1';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '500', booking_detail_id = '1', rid = '215', room = '0', salutations = 'Mr', first_name = 'PRiyanka', last_name = 'test', passenger_type = 'adult', age = '';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '500', booking_detail_id = '1', rid = '215', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '500', booking_detail_id = '1', room_type_code = '', room_name = 'singlepluschild', room_type_description = 'KingBed Deluxe Double or Twin Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 King Bed)', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:"displayNightlyRate";d:81.829999999999998;s:25:"displayNightlyRateDisplay";s:154:"Rate - 81.83,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.94 USD, Marketing Fee - 5.94  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:82.239999999999995;}i:1;a:3:{s:18:"displayNightlyRate";d:72.569999999999993;s:25:"displayNightlyRateDisplay";s:154:"Rate - 72.57,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.94 USD, Marketing Fee - 5.94  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:72.930000000000007;}}', native_nightly_rates = 'a:2:{i:0;a:1:{s:17:"nativeNightlyRate";d:81.829999999999998;}i:1;a:1:{s:17:"nativeNightlyRate";d:72.569999999999993;}}', native_room_rate_total = '154.4', wh_room_rate_total = '155.17', display_room_rate_total = '154.4', number_of_rooms = '1';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '500', booking_detail_id = '1', rid = '216', room = '0', salutations = 'Mr', first_name = 'Test', last_name = 'test', passenger_type = 'adult', age = '';
[03/04/2024 06:09:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '500', booking_detail_id = '1', rid = '216', room = '0', salutations = 'Child', first_name = 'TBAB', last_name = 'TBAB', passenger_type = 'child', age = '1';
[03/04/2024 06:09:12], [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/04_03_2024/request_reservation_hotel_yards_46_1709532551_28.json', 'e1p/04_03_2024/response_reservation_hotel_yards_46_1709532551_28.json', 'e1p/04_03_2024/response_header_reservation_hotel_yards_46_1709532551_28.json', 'expediapackage', '2024-03-04 06:09:12', '', '48a6f32a2027a7359b8f80f18839be068f5c840ca0311160bb3a89e03f5eec74', '46');
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7405370388422', confirmation_number = '7405370388422', display_discount = '0', cancellation_policy = 'Free cancellation up to  18:08:10 on  2024-03-01<br>If you cancel between 2024-03-01 18:08:11 and 2024-11-27 00:00:00 , you will be charged 310.34 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 18:08 on 1st of March 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-03-02 06:09: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 self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 60.02 AED (16.34 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 = 'hotelyards', sales_manager_id = '0', admin_booked = '1', 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 self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 60.02 AED (16.34 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 = 'hotelyards', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='310.34',  wh_sub_agent_rate='0',  wh_parent_agent_id='7868',  wh_agent_id='7868',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='21',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7867',  sub_agent_rate='0',  agent_rate='308.8',  applicable_service_tax='0',  supplier_rate='308.8',  uid='f1359f4a0a8601f3592c9cc3840b4cb6'  where id='500';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='500';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '500' , sr_id = '1' ;
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('500','25.264651','55.318562');
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= '2024/00051', voucher_id='123',status_date='2024-03-04 06:09:12',current_status='vouchered',voucher_hashcode='7c46ae34727b03f30408771bb0a1ab3156100500',vouchered_by ='' where id='500';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2024/00051' where id='500' and is_invoiced!='yes';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7867';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7867',credit_value= '99999581.800',credit_usage= '417.200',credit_limit= '99999999.000',receipt_id= '',amount= '',booking_id='500',booking_cost= '308.8',receipt_allocation= '',balance= '308.8',ip='43.239.53.130',user_type='User',admin_id='Agent - Rajendra  chaursiya(CD7867)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-03-04 06:03:12';
[03/04/2024 06:09:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '500', booking_log = 'Booking Vouchered', create_date = '2024-03-04 06:09:12', supplier_currency ='USD', type = 'Sale', agent_price = '', sub_agent_price ='', supplier_price = '0.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/04/2024 06:09:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Proforma Invoice Record for Booking HTL00500',mailbody='
&lt;link href=\&#039;https://fonts.googleapis.com/css?family=PT+Sans:400,700,400italic,700italic\&#039; rel=\&#039;stylesheet\&#039; type=\&#039;text/css\&#039;&gt;
&lt;!doctype html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;script type=\&quot;text/javascript\&quot; src=\&quot;https://hotelyards.astrabookings.com/project_folder/astra/js/jquery.min.js\&quot;&gt;&lt;/script&gt;
&lt;script type=\&quot;text/javascript\&quot; src=\&quot;https://hotelyards.astrabookings.com/project_folder/astra/js/jQuery.print.js\&quot;&gt;&lt;/script&gt;

&lt;style&gt;
@import url(\&#039;https://fonts.googleapis.com/css2?family=Nunito+Sans:opsz,wght@6..12,200;6..12,300;6..12,400;6..12,500;6..12,600;6..12,700;6..12,800;6..12,900&display=swap\&#039;);
.inv_width{width:89%;}
 .print_Btn {
   font-size: 16px;
    border-radius: 3px;
    color: #00B5EF;
    top: 0!important;
    text-shadow: none;
    margin-bottom: 5px;
}
button {
    background: transparent none repeat scroll 0 0;
    border: 0 none;
    cursor: pointer;
    padding-bottom: 10px;
    padding-right: 20px;
}
a.q_btn {
    text-decoration: none;
    color: #424142;
    border: 1px solid #424142;
    padding: 7px 10px;
    text-transform: uppercase;
    font-size: 12px;
    border-radius: 4px;
    margin: 0 7px;
    display:inline-block;
    color: #9e9e9e!important;
    border: 1px solid #9e9e9e!important;
    display: inline-flex;
    align-items: center;
}
a.q_btn img{
	margin: 0 5px 0 0;
	filter: opacity(.5);
}
.modal-body &gt; .printDialog{display: block;}
@media print {
	@import url(\&#039;https://fonts.googleapis.com/css2?family=Nunito+Sans:opsz,wght@6..12,200;6..12,300;6..12,400;6..12,500;6..12,600;6..12,700;6..12,800;6..12,900&display=swap\&#039;);
  	a.q_btn {display:none;}
}
&lt;/style&gt;


&lt;script type=\&quot;text/javascript\&quot;&gt;
function printContent(el){
	//$.print(\&quot;#\&quot;+el);
     $(\&quot;#\&quot;+el).print({
        //Use Global styles
        globalStyles : false,
        //Add link with attrbute media=print
        mediaPrint : true,
        //Custom stylesheet
       	stylesheet : null,
        //Print in a hidden iframe
        iframe : true,
        //Don\&#039;t print this
        noPrintSelector : \&quot;.print_hide\&quot;
    }); 
}
&lt;/script&gt;

&lt;/head&gt;
&lt;body style=\&quot;background:#eeeeee;font-family: \&#039;Nunito Sans\&#039;, sans-serif;margin-top:0px;\&quot;&gt;
	&lt;div id=\&quot;invoiceDialog\&quot; class=\&quot;printDialog\&quot; style=\&quot;background:#EEEEEE;padding:10px 0px;\&quot;&gt;
		&lt;table align=\&quot;center\&quot;  cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:1280px; background:#ffffff; font-size:13px; margin:0px auto;\&quot;&gt;
						&lt;tr&gt;
				&lt;td&gt;
					&lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;\&quot;&gt;
						&lt;tr&gt;
							&lt;td style=\&quot;padding:20px 0px 10px 90px;\&quot;&gt; 
								 
								&lt;img src=\&quot;https://hotelyards.astrabookings.com/project_folder/astra/images/hotelyards/logo.svg\&quot; class=\&quot;small_logo img-responsive\&quot;  /&gt;
								&nbsp; 	
							&lt;/td&gt;
	
							&lt;td style=\&quot;padding:20px 80px 10px 0px;text-align:right;\&quot;&gt; 
								&lt;span style=\&quot;color:#000000;font-size:17px;font-weight:600;text-align:right;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;  &lt;/span&gt;
								&lt;br&gt;
								&lt;span style=\&quot;color:#333333;font-size:13px;text-align:right;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
									 , &lt;br/&gt;
									Tel:  &lt;br/&gt;
									Email: &lt;a href=\&quot;mailto:\&quot; style=\&quot;color: #333333; text-decoration: none;\&quot;&gt;&lt;/a&gt; &lt;br/&gt;
																 	&lt;/span&gt;
							&lt;/td&gt;
							&lt;td style=\&quot;width:10px;padding:20px 0px;text-align:right;right:-1px;\&quot;&gt;
								 &lt;img src=\&quot;https://hotelyards.astrabookings.com/project_folder/astra/images/hotelyards/emails/email_header.jpg\&quot; /&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
					&lt;/table&gt;
				&lt;/td&gt;
			&lt;/tr&gt;
		&lt;/table&gt;
		&lt;table  align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:1280px; background:#ffffff; font-size:13px; margin:0px auto;\&quot;&gt;
			&lt;tr&gt;
				&lt;td&gt;
					&lt;table  align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:1100px; background:#ffffff; font-size:13px; margin:0px auto;\&quot;&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;margin:0px auto;font-size:13px;border-top: 1px solid #b8b8b8;\&quot;&gt;
									&lt;tr&gt;
										&lt;td valign=\&quot;top\&quot; style=\&quot;text-align: left; font-size: 13px; color: #333333; padding: 15px 0px 5px 0px; width: 280px;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
											&lt;span style=\&quot;text-transform:uppercase;font-weight:bold;\&quot;&gt;Invoice No.: &lt;/span&gt; 
											&lt;span style=\&quot;text-transform:uppercase;font-weight:bold;color:#333333;\&quot;&gt;2024/00051&lt;/span&gt;&lt;br&gt;											&lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#333333;padding-top:5px;text-transform:normal\&quot;&gt; 
												March, 04, 2024
											&lt;/span&gt;
										&lt;/td&gt;
										&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:18px;color:#333333;font-weight:bold;text-transform:uppercase;width:200px;font-family: \&#039;Nunito Sans\&#039;, sans-serif;padding:20px 0px 5px 0px;\&quot;&gt;
										 Invoice										&lt;/td&gt;
										&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:right;font-size:13px;color:#333333;padding:15px 0px 5px 0px;text-transform:uppercase;font-weight:bold;width:280px;\&quot;&gt; 
																						&lt;span style=\&quot;text-transform:uppercase;font-weight:bold;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Astra Booking ID.: &lt;/span&gt; 
											&lt;span style=\&quot;text-transform:uppercase;font-weight:bold;color:#333333;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;HTL00500&lt;/span&gt; &lt;br&gt;&lt;br&gt;
											&lt;span style=\&quot;text-transform:uppercase;font-weight:bold;color:#333333;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
												Hotel Yards
											&lt;/span&gt; &lt;br&gt;
											&lt;span style=\&quot;font-style:italic;text-align:left;font-size:12px;color:#333333;padding-top:5px;text-transform:normal;font-weight:normal;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
												Hazmieh, Jiser Albasha, Mar Roukoz st - Lebanon &lt;br&gt;
												Phone:96170500659
											&lt;/span&gt;
																					&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;margin:0px auto; padding:0px 0px 0px 0px; width:100%;\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;border-top:1px solid #b8b8b8;border-left:1px solid #b8b8b8;border-bottom:1px solid #b8b8b8; border-right:1px solid #b8b8b8;background:#f3f3f3;\&quot;&gt;
											&lt;table cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;margin-top:3px;font-size:13px; width:100%;\&quot;&gt;
												&lt;tr&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:20%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Hotel Name 
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:12%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														City
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:15%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Guest Name
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:10%\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:10%\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
			
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;border-bottom:1px solid #b8b8b8;border-left:1px solid #b8b8b8;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Rates
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;border-bottom:1px solid #b8b8b8;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Tax
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;border-bottom:1px solid #b8b8b8;border-right:1px solid #b8b8b8;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														O/C
													&lt;/td&gt;
												&lt;/tr&gt;
			
												&lt;tr&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:20%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Lotus Grand Hotel  &lt;br&gt;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:0px 5px 5px 5px;width:12%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Dubai, UNITED ARAB EMIRATES
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:0px;width:15%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														Mr PRiyanka Test
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:600;width:10%\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:600;width:10%\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;border-left:1px solid #b8b8b8;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														0.00
														&lt;span style=\&quot;font-style:italic;text-align:center;font-size:13px;color:#333333;padding:0px 5px 5px 5px;text-transform:uppercase\&quot;&gt; &nbsp; &lt;/span&gt;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														0.000
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;border-right:1px solid #b8b8b8;\&quot;&gt; 
														--	
													&lt;/td&gt;
												&lt;/tr&gt;
			
												&lt;tr&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:20%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Room Name&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:12%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Check In&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:15%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Check Out&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Rooms&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;Nights&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 0px 5px;font-weight:normal;width:10%;border-left:1px solid #b8b8b8;\&quot;&gt;&nbsp;&lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#333333;padding-top:5px;text-transform:uppercase\&quot;&gt; &nbsp; &lt;/span&gt;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;\&quot;&gt; &nbsp;&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px;font-weight:normal;width:10%;border-right:1px solid #b8b8b8;\&quot;&gt;&nbsp;&lt;/td&gt;
												&lt;/tr&gt;
																								&lt;tr&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:normal;width:20%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														KingBed Deluxe Double or Twin Room(Room Only)- &lt;font color=\&#039;red\&#039;&gt;Package Deal&lt;/font&gt; &lt;b&gt;&lt;font color=\&#039;#265db7\&#039;&gt;(Members exclusive price)&lt;/font&gt;&lt;/b&gt;&lt;br&gt;(1 King Bed)
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;width:12%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														27/11/2024
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;width:15%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														29/11/2024
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														1
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														2
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:normal;width:10%;border-left:1px solid #b8b8b8;\&quot;&gt; 
														&nbsp;
														&lt;span style=\&quot;font-style:italic;text-align:center;font-size:13px;color:#333333;padding:0px 5px 5px 5px;text-transform:uppercase\&quot;&gt; &nbsp; &lt;/span&gt;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px;font-weight:normal;width:10%;border-right:1px solid #b8b8b8;\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
			
												&lt;/tr&gt;
																								&lt;tr&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:normal;width:20%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														KingBed Deluxe Double or Twin Room(Room Only)- &lt;font color=\&#039;red\&#039;&gt;Package Deal&lt;/font&gt; &lt;b&gt;&lt;font color=\&#039;#265db7\&#039;&gt;(Members exclusive price)&lt;/font&gt;&lt;/b&gt;&lt;br&gt;(1 King Bed)
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;width:12%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														27/11/2024
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;width:15%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														29/11/2024
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														1
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:600;width:10%;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 
														2
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px 5px 5px 5px;font-weight:normal;width:10%;border-left:1px solid #b8b8b8;\&quot;&gt; 
														&nbsp;
														&lt;span style=\&quot;font-style:italic;text-align:center;font-size:13px;color:#333333;padding:0px 5px 5px 5px;text-transform:uppercase\&quot;&gt; &nbsp; &lt;/span&gt;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:0px 5px 5px 5px;font-weight:normal;width:10%;\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
													&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:center;font-size:13px;color:#000000;padding:5px;font-weight:normal;width:10%;border-right:1px solid #b8b8b8;\&quot;&gt; 
														&nbsp;
													&lt;/td&gt;
			
												&lt;/tr&gt;
																								&lt;tr&gt;
													&lt;td colspan=\&quot;5\&quot; style=\&quot;padding:5px;text-transform:uppercase;font-weight:bold;color:#333333;text-align:right;border-top:1px solid #b8b8b8;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; Net Amount ($) &lt;/td&gt;
													&lt;td colspan=\&quot;3\&quot; style=\&quot;text-align:right;color:#000000;font-weight:600;border-top:1px solid #b8b8b8;border-left:1px solid #b8b8b8;border-right:1px solid #b8b8b8;padding:5px 15px 5px 5px;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; 0 USD&lt;/td&gt;
												&lt;/tr&gt;
											&lt;/table&gt;
										&lt;/td&gt;
									&lt;/tr&gt;
			
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
			
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;margin:8px auto;width:100%; padding:20px 0px 20px 0px\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;color:#000000;font-size:12px;font-weight:bold;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt;  Remarks &lt;/td&gt;
									&lt;/tr&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;font-weight:bold;color:#333333;font-size:12px;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; Invoice Original Amount = 0 USD &lt;/td&gt;
									&lt;/tr&gt;
									&lt;tr&gt;
										&lt;td&gt; 
											&lt;span style=\&quot;font-weight:bold;color:#333333;font-size:12px;font-family: \&#039;Nunito Sans\&#039;, sans-serif;\&quot;&gt; Issued By: &lt;/span&gt; &lt;span style=\&quot;font-weight:normal;color:#333333;font-size:12px;\&quot;&gt;  &lt;/span&gt; &lt;br&gt;
											
										&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
												&lt;tr&gt;&lt;td&gt;&nbsp;&lt;/td&gt;&lt;/tr&gt;
					&lt;/table&gt;
				&lt;/td&gt;
			&lt;/tr&gt;
		&lt;/table&gt;
	&lt;/div&gt;
	&lt;/body&gt;
&lt;/html&gt;',mailto='',mailcc='',mailbcc='',mailattachment='/home/otrams/public_html/beta///project_folder/astra_protected/temp/Invoice.pdf',reason='You must provide at least one recipient email address.',date_time='2024-03-04 06:09:15';
[03/04/2024 06:09:15], [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
		('','','500','inprocess-booking-invoiced','2024-03-04 06:09:15','Booking invoiced by Back Office hotelyards on behalf of Agent - Rajendra  chaursiya(CD7867)','7867','43.239.53.130','','1','');
[03/04/2024 06:09:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='500',booking_detail_id ='500',agent_id ='7867',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is  %',create_date ='2024-03-04 06:09:15';
[03/04/2024 06:09:15], [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
		('','','500','vouchered','2024-03-04 06:09:15','Voucherd by Back Office hotelyards on behalf of Agent - Rajendra  chaursiya(CD7867)','7867','43.239.53.130','','1','');
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('500','gajendra.rajpurohit@qtechsoftware.com');
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('500','gajendra.rajpurohit@qtechsoftware.com');
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('500','gajendra.rajpurohit@qtechsoftware.com');
[03/04/2024 06:09:16], [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 ('3247','500','confirmed','2024-03-04 06:09:12','Booking confirmed. Booked by Back Office hotelyards on behalf of Agent - Rajendra  chaursiya(CD7867)','7867','43.239.53.130','1','7867');
[03/04/2024 06:09:16], [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('500','2024-03-01 18:08:11','2024-03-01 18:08:11','2024-11-27 00:00:00','2024-11-27 00:00:00','308.8','310.34','0','2024-03-04 06:09:16','310.34');
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='500',status='1' where reservation_id='3247' and booking_id ='0';
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='500' where agent_logs_id='46' and source_type='expediapackage';
[03/04/2024 06:09:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='23.76',  commission_tax='',  booking_id ='500',  supplier_tax='56.74',  supplier_base_fare='252.06',  supplier_commissionable_fare='23.76'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-03-04 06:09:16';
[03/04/2024 06:10:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:05' WHERE id= '619';
[03/04/2024 06:10:07], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:07' WHERE id= '619';
[03/04/2024 06:10:12], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:12' WHERE id= '619';
[03/04/2024 06:10:26], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:26' WHERE id= '619';
[03/04/2024 06:10:31], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:31' WHERE id= '619';
[03/04/2024 06:10:38], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:38' WHERE id= '619';
[03/04/2024 06:10:40], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:10:40' WHERE id= '619';
[03/04/2024 06:10:40], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/04/2024 06:13:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:13:01' WHERE id= '619';
[03/04/2024 06:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:13:09' WHERE id= '619';
[03/04/2024 06:13:43], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:13:43' WHERE id= '619';
[03/04/2024 06:13:47], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:13:47' WHERE id= '619';
[03/04/2024 06:13:57], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-04 06:13:57' WHERE id= '619';
