[03/15/2024 10:00:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:00:44' WHERE id= '664';
[03/15/2024 10:00:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:00:48' WHERE id= '664';
[03/15/2024 10:02:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:02:45' WHERE id= '664';
[03/15/2024 10:03:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:03:12' WHERE id= '664';
[03/15/2024 10:03:16], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:03:16' WHERE id= '664';
[03/15/2024 10:04:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:04:41' WHERE id= '664';
[03/15/2024 10:05:41], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:41' WHERE id= '664';
[03/15/2024 10:05:41], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-15 10:05:41',login_attempt=0 where id = '7866';
[03/15/2024 10:05:41], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-03-15 10:05:41', ip = '43.239.53.130', action = 'Login' ;
[03/15/2024 10:05:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:42' WHERE id= '664';
[03/15/2024 10:05:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:52' WHERE id= '664';
[03/15/2024 10:05:55], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:55' WHERE id= '664';
[03/15/2024 10:05:55], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/03/30' , departure_date = '2024/03/31' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-15 10:05:55' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/15/2024 10:05:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:56' WHERE id= '664';
[03/15/2024 10:05:56], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-03-15 10:05:56', '', '364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f', '229');
[03/15/2024 10:05:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f&xml_user_id=7863&db_caching=1&web_service=no'
        , http_hit_time = '2024-03-15 10:05:56.93'
        , 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.107'
        , error_description = ''
        , memory_used = '10675696'
        WHERE id = '61446';
[03/15/2024 10:05:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7863&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f',
        duration = '0.168',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.24',
        system_load_5_min = '3.95',
        system_load_15_min = '5.24',
        system_memory_usage = '76.27',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '229') + '3813024',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '229';
[03/15/2024 10:05:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:05:56' WHERE id= '664';
[03/15/2024 10:06:00], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:00' WHERE id= '664';
[03/15/2024 10:06:01], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:01' WHERE id= '664';
[03/15/2024 10:06:01], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1710497161','43.239.53.130');
[03/15/2024 10:06:01], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Payment Gateway credit limit is over for the days transaction (15-03-2024 10:06:01).(NOTIFICATION_PER_DAY_LIMIT)',mailbody='Dear Administrator,&lt;br/&gt;The Payment Gateway credit limit assigned is over for a day &lt;br/&gt; Payment Gateway Credit Limit IS  0 USD&lt;br/&gt; The customer wants to book for 0 USD&lt;br/&gt;&lt;br/&gt;Agent Information &lt;br/&gt;&lt;br/&gt;Agency Name : Qtech &lt;br&gt;Agency Code : CD7863 &lt;br&gt;City : dubai &lt;br&gt;Service Date : 2024/03/30 &lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-03-15 10:06:01';
[03/15/2024 10:06:27], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:27' WHERE id= '664';
[03/15/2024 10:06:27], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-15 10:06:27',login_attempt=0 where id = '7865';
[03/15/2024 10:06:27], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-03-15 10:06:27', ip = '43.239.53.130', action = 'Login' ;
[03/15/2024 10:06:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:27' WHERE id= '664';
[03/15/2024 10:06:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:31' WHERE id= '664';
[03/15/2024 10:06:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:37' WHERE id= '664';
[03/15/2024 10:06:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/30' , departure_date = '2024/05/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-15 10:06:37' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/15/2024 10:06:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:37' WHERE id= '664';
[03/15/2024 10:06:37], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-03-15 10:06:37', '', '364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f', '230');
[03/15/2024 10:06:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f&xml_user_id=7863&db_caching=1&web_service=no'
        , http_hit_time = '2024-03-15 10:06:37.771'
        , 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.103'
        , error_description = ''
        , memory_used = '10568656'
        WHERE id = '61447';
[03/15/2024 10:06:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7863&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f',
        duration = '0.147',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.65',
        system_load_5_min = '3.73',
        system_load_15_min = '5.11',
        system_memory_usage = '76.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '230') + '3812688',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '230';
[03/15/2024 10:06:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:38' WHERE id= '664';
[03/15/2024 10:06:42], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:42' WHERE id= '664';
[03/15/2024 10:06:43], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:06:43' WHERE id= '664';
[03/15/2024 10:06:43], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1710497203','43.239.53.130');
[03/15/2024 10:06:43], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Payment Gateway credit limit is over for the days transaction (15-03-2024 10:06:43).(NOTIFICATION_PER_DAY_LIMIT)',mailbody='Dear Administrator,&lt;br/&gt;The Payment Gateway credit limit assigned is over for a day &lt;br/&gt; Payment Gateway Credit Limit IS  0 USD&lt;br/&gt; The customer wants to book for 0 USD&lt;br/&gt;&lt;br/&gt;Agent Information &lt;br/&gt;&lt;br/&gt;Agency Name : Qtech &lt;br&gt;Agency Code : CD7863 &lt;br&gt;City : dubai &lt;br&gt;Service Date : 2024/04/30 &lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-03-15 10:06:43';
[03/15/2024 10:07:03], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:03' WHERE id= '664';
[03/15/2024 10:07:06], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:06' WHERE id= '664';
[03/15/2024 10:07:21], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:21' WHERE id= '664';
[03/15/2024 10:07:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:23' WHERE id= '664';
[03/15/2024 10:07:26], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:26' WHERE id= '664';
[03/15/2024 10:07:26], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/30' , departure_date = '2024/05/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-15 10:07:26' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/15/2024 10:07:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:27' WHERE id= '664';
[03/15/2024 10:07:27], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-03-15 10:07:27', '', '364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f', '231');
[03/15/2024 10:07:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f&xml_user_id=7863&db_caching=1&web_service=no'
        , http_hit_time = '2024-03-15 10:07:27.125'
        , 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.171'
        , error_description = ''
        , memory_used = '10568624'
        WHERE id = '61448';
[03/15/2024 10:07:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7863&sessionid=364dfadbbcf7a1fa1d198d0da2817bb692831e493fa4d5ad23826bd4eedc178f',
        duration = '0.236',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '9.58',
        system_load_5_min = '5.11',
        system_load_15_min = '5.48',
        system_memory_usage = '77.06',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '231') + '3812752',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '231';
[03/15/2024 10:07:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:07:27' WHERE id= '664';
[03/15/2024 10:08:16], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:08:16' WHERE id= '664';
[03/15/2024 10:08:16], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:08:16' WHERE id= '664';
[03/15/2024 10:08:16], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1710497296','43.239.53.130');
[03/15/2024 10:08:16], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Payment Gateway credit limit is over for the days transaction (15-03-2024 10:08:16).(NOTIFICATION_PER_DAY_LIMIT)',mailbody='Dear Administrator,&lt;br/&gt;The Payment Gateway credit limit assigned is over for a day &lt;br/&gt; Payment Gateway Credit Limit IS  0 USD&lt;br/&gt; The customer wants to book for 0 USD&lt;br/&gt;&lt;br/&gt;Agent Information &lt;br/&gt;&lt;br/&gt;Agency Name : Qtech &lt;br&gt;Agency Code : CD7863 &lt;br&gt;City : dubai &lt;br&gt;Service Date : 2024/04/30 &lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-03-15 10:08:16';
[03/15/2024 10:08:16], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:08:16' WHERE id= '664';
[03/15/2024 10:08:45], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:08:45' WHERE id= '664';
[03/15/2024 10:08:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1710497325','43.239.53.130');
[03/15/2024 10:08:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-03-15 10:08:46' WHERE id= '664';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'localsystem', reservation_id = '3706', create_date = '2024-03-15 10:08:47', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '31', is_xml = '0', display_room_rate = '110', display_currency_code = 'USD', native_room_rate = '100', native_currency_code = 'USD', supplier_profile_id = '19', service_type = 'hotel', service_date = '2024/04/30', check_out_date = '2024/05/01', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'bhaves', leader_last_name = 'gurav', status_date = '2024-03-15 10:08:47';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='536'
		;
[03/15/2024 10:08:47], [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('536','3706','S000000001','1','2','0','-','','','5','NEW DUBAI SHIV RAJ','Dubai','987654323','4.0','1','2024/04/30','2024/05/01','','https://baysantravel.astrabookings.com/project_folder/astra//images/imagenotavailable.jpg');
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '536', booking_detail_id = '1', room_type_code = '2~~~1~~~1~~~9~~~~~~~~~71649~~~0~~~S000000001', room_name = 'double', room_type_description = 'Delux  -English Breakfast : 2 Pax ', display_nightly_rates = 'a:1:{i:0;a:5:{s:18:"displayNightlyRate";i:110;s:15:"pricing_profile";a:9:{s:8:"range_id";s:2:"82";s:4:"from";s:1:"0";s:2:"to";s:7:"1000000";s:6:"amount";i:110;s:7:"percent";s:5:"10.00";s:8:"currency";N;s:10:"profile_id";s:2:"12";s:18:"without_mul_amount";s:4:"0.00";s:16:"check_mul_amount";i:0;}s:16:"promotionDisplay";s:0:"";s:25:"displayNightlyRateDisplay";s:218:"Supplier Name - localsupplier(travelclick - S000000001), Rate - 100 USD, Currency Multiplier (USD-USD) - 1.00000 Markup in % - 10.00%, Markup Amount - 0, , Markup Amount in SAR - 0.00,Supplier Commission-0 #localsystem";s:13:"whNightlyRate";d:110.55;}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:"O_nativeNightlyRate";i:100;s:17:"nativeNightlyRate";i:100;s:9:"free_sale";s:2:"no";s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}', native_room_rate_total = '100', wh_room_rate_total = '110.55', display_room_rate_total = '110', number_of_rooms = '1';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '536', booking_detail_id = '1', rid = '253', room = '0', salutations = 'Mr', first_name = 'bhaves', last_name = 'gurav', passenger_type = 'adult', age = '';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '536', booking_detail_id = '1', rid = '253', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<br><Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 110 USD applicable if cancelled after 14 Mar 2024 22:08 hrs.', supplier_cancellation_policy = '', current_status = 'on_request', expiration_date = '2024-03-15 10:09:00', comment_contract = '', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bhavesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = '', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000', free_sale='',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='110.55',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='10',  agent_markup='10',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='110',  applicable_service_tax='0',  supplier_rate='100',  uid='953a5d3e30c2ff57116100258eb9f6ff'  where id='536';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='536';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('536','','');
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set admin_booked='1' where id='536';
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Special Condition Booking - Baysan Tourism Services',mailbody='
&lt;!DOCTYPE html PUBLIC \&quot;-//W3C//DTD XHTML 1.0 Transitional//EN\&quot; \&quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\&quot;&gt;
&lt;html xmlns=\&quot;http://www.w3.org/1999/xhtml\&quot;&gt;
&lt;head&gt;
&lt;meta http-equiv=\&quot;Content-Type\&quot; content=\&quot;text/html; charset=utf-8\&quot; /&gt;
&lt;title&gt;:: Baysan Tourism Services :: &lt;/title&gt;
&lt;/head&gt;
&lt;body style=\&quot;background:#EEEEEE;font-family: \&#039;PT Sans\&#039;, sans-serif;margin-top:0px;\&quot;&gt;
    &lt;div style=\&quot;background:#EEEEEE;padding:10px 0px;\&quot;&gt;
    &lt;table width=\&quot;670px\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;padding:0px 0px;border-collapse: collapse;\&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;width:320px;padding:20px 0px 10px 35px;\&quot;&gt; 
            &lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravellogo.png\&quot; alt=\&quot;Baysan Tourism Services\&quot;  style=\&quot;height:100px\&quot;&gt;          
          &lt;/td&gt;
  
          &lt;td valign=\&quot;top\&quot; style=\&quot;width:320px;padding:20px 25px 10px 0px;text-align:right;\&quot;&gt; 
            &lt;span style=\&quot;color:#1a222f;font-size:17px;font-weight:600;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Baysan Tourism Services &lt;/span&gt;
            &lt;br&gt;
            &lt;span style=\&quot;color:#1a222f;font-size:13px;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
            Casalanges Dahra Area, Tripoli, Libya&lt;br/&gt;              
                      Tel: &lt;br/&gt;
            Email : &lt;a href=\&quot;mailto:gajendra.rajpurohit@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;gajendra.rajpurohit@qtechsoftware.com&lt;/a&gt; &lt;br/&gt;
            https://baysantravel.astrabookings.com/
            &lt;/span&gt;
          &lt;/td&gt;
          &lt;td style=\&quot;width:10px;padding:20px 0px;text-align:right;\&quot;&gt;
             &lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/email_header.jpg\&quot; /&gt;
          &lt;/td&gt;
    &lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;
  &lt;/tr&gt; 
&lt;/table&gt;
 
    &lt;table width=\&quot;700\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;padding:0px 0px;border-collapse: collapse;\&quot;&gt;
      &lt;tr&gt;
        &lt;td&gt;
          &lt;table width=\&quot;630\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;padding:0px 0px;border-collapse: collapse;\&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%;margin:0px auto;font-size:13px;padding:0px;\&quot;&gt;
                  &lt;tr&gt;
                    &lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:14px;color:#1a222f;padding:10px 0px 5px 0px;\&quot;&gt; 
                      &lt;span style=\&quot;text-transform:capitalize;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Dear Operations Team, &lt;/span&gt; &lt;br&gt;
                      &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#1a222f;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Friday, March 15, 2024
                      &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 cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%; padding:0px 0px 10px 0px;\&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%;margin:3px auto;background:#F5F6F8;border:1px solid #D8E1E6;\&quot;&gt;  
                        &lt;tr&gt;
                          &lt;td&gt;
                            &lt;table style=\&quot;width:100%;margin:0px auto; border-bottom:0; font-size:13px; color:#15394b;padding:8px;\&quot;&gt;
                              &lt;tr&gt;
                                &lt;td style=\&quot;font-style:italic;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                  Following booking is done either through payment gateway system or within cancellation deadline.&lt;br&gt;&lt;br&gt;
                                  Kindly recheck this booking as it might be either:&lt;br&gt; 
                                  1. Failed or on-request.&lt;br&gt;
                                  2. This booking may be came on special condition&lt;br&gt;&lt;br&gt;
                                  The details of booking is provided below. Please handle the booking manually.
                                &lt;/td&gt;                                 
                              &lt;/tr&gt;
                            &lt;/table&gt;
                          &lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr&gt;
                          &lt;td&gt;
                            &lt;table style=\&quot;width:100%;margin:0px auto; border-bottom:0; font-size:13px; color:#15394b;padding:0 8px;\&quot;&gt;
                              &lt;tr&gt;
                                &lt;td valign=\&quot;top\&quot; width=\&quot;200px\&quot; style=\&quot;text-align:left;font-size:14px;color:#1a222f;padding:5px 0px 5px 5px;\&quot;&gt; 
                                  &lt;span style=\&quot;text-transform:capitalize;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Booking ID&lt;/span&gt; &lt;br&gt;
                                &lt;/td&gt;
                                &lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:14px;color:#1a222f;padding:5px 0px 5px 5px;\&quot;&gt; 
                                  &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#1a222f;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                    HTL00536
                                  &lt;/span&gt;
                                &lt;/td&gt;                                
                              &lt;/tr&gt;
                              &lt;tr&gt;
                                &lt;td valign=\&quot;top\&quot; width=\&quot;200px\&quot; style=\&quot;text-align:left;font-size:14px;color:#1a222f;padding:5px 0px 5px 5px;\&quot;&gt; 
                                  &lt;span style=\&quot;text-transform:capitalize;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Supplier&lt;/span&gt; &lt;br&gt;
                                &lt;/td&gt;
                                &lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:14px;color:#1a222f;padding:5px 0px 5px 5px;\&quot;&gt; 
                                  &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#1a222f;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                    localsystem
                                  &lt;/span&gt;
                                &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;/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;width: 100%; font-size: 10px; margin: 0px auto; padding: 8px 0px;color:#023246;border-top:1px solid #CFD4D7;\&quot;&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding:10px 0px 5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
					Our Support team is always ready to assist you. Please contact us on &lt;a href=\&quot;mailto:gajendra.rajpurohit@qtechsoftware.com\&quot; style=\&quot;color: #00a6da; text-decoration: none;\&quot;&gt;gajendra.rajpurohit@qtechsoftware.com&lt;/a&gt; for any assistance or feedback
				&lt;/td&gt;
			&lt;/tr&gt;
		&lt;/table&gt;
	&lt;/td&gt;
&lt;/tr&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%; padding:30px 0px 30px 0px;\&quot;&gt;
                  &lt;tr&gt;
                    &lt;td style=\&quot;text-align:right;\&quot;&gt;
                      &lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;margin:0px auto;font-size:13px;\&quot;&gt;
                        &lt;tr&gt;
                          &lt;td style=\&quot;color:#000000;padding:5px 5px 0px 5px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;text-align:right;\&quot;&gt; 
                            Thanking You                    
                          &lt;/td&gt;                                 
                        &lt;/tr&gt;
                        &lt;tr&gt;
                          &lt;td style=\&quot;color:#000000;width:25%;font-size:12px;font-family: \&#039;PT Sans\&#039;, sans-serif;text-align:right;\&quot;&gt; 
                            Registration and Sales Team.                    
                          &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;/table&gt;
        &lt;/td&gt;
      &lt;/tr&gt;
    &lt;/table&gt;
  &lt;/div&gt;
  &lt;/body&gt;
&lt;/html&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-03-15 10:08:47';
[03/15/2024 10:08:47], [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 ('3706','536','on_request','2024-03-15 10:08:47','Booking on_request . Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[03/15/2024 10:08:47], [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('536','2024-03-15 10:08:00','2024-03-15 10:08:00','1970-01-01 00:00:00','1970-01-01 00:00:00','100','110','0','2024-03-15 10:08:47','110');
[03/15/2024 10:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '536',  room_id= '2~~~1~~~1~~~9~~~~~~~~~71649~~~0~~~S000000001',  room_name= 'double',  supplier_id= 'S000000001',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '100',  native_rate= '100',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2024-03-15 10:08:47' ;
