[01/29/2024 06:11:08], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:11:08' WHERE id= '459';
[01/29/2024 06:11:19], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:11:19' WHERE id= '459';
[01/29/2024 06:11:22], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:11:22' WHERE id= '459';
[01/29/2024 06:11:22], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:11:30], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:11:30' WHERE id= '459';
[01/29/2024 06:13:26], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:13:26' WHERE id= '459';
[01/29/2024 06:13:32], [file name :-/home/otrams/public_html/beta/booking_request.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:13:32' WHERE id= '459';
[01/29/2024 06:13:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:13:58' WHERE id= '459';
[01/29/2024 06:15:47], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:15:47' WHERE id= '459';
[01/29/2024 06:17:15], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:15' WHERE id= '459';
[01/29/2024 06:17:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:18' WHERE id= '459';
[01/29/2024 06:17:24], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:24' WHERE id= '459';
[01/29/2024 06:17:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:32' WHERE id= '459';
[01/29/2024 06:17:32], [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 = '1' , ip = '123.253.233.242' , city = 'tangerang' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/01/29' , departure_date = '2024/01/30' , nights = '1' , nationality = '107' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-29 06:17:32' , site_id = '21' , country_code = '107' , city_code = '67332' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/29/2024 06:17:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:33' WHERE id= '459';
[01/29/2024 06:17:33], [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/29_01_2024/request_availability_straightline_wh_06_17_33_1706509053_94.json', 'e1/29_01_2024/response_availability_straightline_wh_06_17_33_1706509053_94.json', 'e1/29_01_2024/response_header_availability_straightline_wh_06_17_33_1706509053_94.json', 'expedia', '2024-01-29 06:17:33', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:17:33], [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/29_01_2024/request_availability_straightline_wh_06_17_33_1706509053_49.json', 'e1p/29_01_2024/response_availability_straightline_wh_06_17_33_1706509053_49.json', 'e1p/29_01_2024/response_header_availability_straightline_wh_06_17_33_1706509053_49.json', 'expediapackage', '2024-01-29 06:17:33', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:17:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:17:33.225'
            , 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.786'
            , error_description = ''
            , memory_used = '7696096'
            WHERE id = '30045';
[01/29/2024 06:17:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:17:33.225'
            , 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.822'
            , error_description = ''
            , memory_used = '7673448'
            WHERE id = '30046';
[01/29/2024 06:17:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:34' WHERE id= '459';
[01/29/2024 06:17:56], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:56' WHERE id= '459';
[01/29/2024 06:17:57], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:17:57' WHERE id= '459';
[01/29/2024 06:17:57], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706509077','123.253.233.242');
[01/29/2024 06:17:57], [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/29_01_2024/request_valuation_straightline_wh_06_17_57_1706509077_43.json', 'e1p/29_01_2024/response_valuation_straightline_wh_06_17_57_1706509077_43.json', 'e1p/29_01_2024/response_header_valuation_straightline_wh_06_17_57_1706509077_43.json', 'expediapackage', '2024-01-29 06:17:57', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:18:15], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:18:15' WHERE id= '459';
[01/29/2024 06:18:54], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:18:54' WHERE id= '459';
[01/29/2024 06:18:54], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706509134','123.253.233.242');
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:18:55' WHERE id= '459';
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '2328', create_date = '2024-01-29 06:18:55', agent_id = '7842', parent_agent_id = '7842', agent_ref_no = '', nationality = 'Indonesian', city_id = 'tangerang', country_id = '107', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '116.13', display_currency_code = 'USD', native_room_rate = '116.13', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/29', check_out_date = '2024/01/30', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'endang', leader_last_name = 'sutrisna', status_date = '2024-01-29 06:18:55';
[01/29/2024 06:18:55], [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 ('369','ATRIA HOTEL GADING SERPONG','Atria Hotel Gading Serpong - CHSE Certified','4249005','OT000240430','tangerang','expediapackage',NOW());
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='369'
		;
[01/29/2024 06:18:55], [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('369','2328','','1','2','0','-','','','4249005','Atria Hotel Gading Serpong - CHSE Certified','CBD Gading Serpong, Lot #2 Jln. Blvd Gading Serpong, Paramount Serpong','62-21-29215999','4.0','1','2024/01/29','2024/01/30','','https://straightline.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzUwMDAwMDAvNDI1MDAwMC80MjQ5MTAwLzQyNDkwMDUvYjE2MjhkNGFfYi5qcGc=');
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '369', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Family Suite(Breakfast for 2)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:116.13;s:25:"displayNightlyRateDisplay";s:155:"Rate - 116.13,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 9.32 USD, Marketing Fee - 9.32  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:116.70999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:116.13;}}', native_room_rate_total = '116.13', wh_room_rate_total = '116.71', display_room_rate_total = '116.13', number_of_rooms = '1';
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '369', booking_detail_id = '1', rid = '173', room = '0', salutations = 'Mr', first_name = 'endang', last_name = 'sutrisna', passenger_type = 'adult', age = '';
[01/29/2024 06:18:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '369', booking_detail_id = '1', rid = '173', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[01/29/2024 06:18:56], [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/29_01_2024/request_reservation_straightline_wh_06_18_55_1706509135_94.json', 'e1p/29_01_2024/response_reservation_straightline_wh_06_18_55_1706509135_94.json', 'e1p/29_01_2024/response_header_reservation_straightline_wh_06_18_55_1706509135_94.json', 'expediapackage', '2024-01-29 06:18:56', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7730805556645', confirmation_number = '7730805556645', display_discount = '0', cancellation_policy = 'Free cancellation up to  18:17:32 on  2024-01-26<br>If you cancel between 2024-01-26 18:17:33 and 2024-01-29 00:00:00 , you will be charged 116.71 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:17 on 26th of January 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-01-27 06:18: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>Breakfast for 2, Free self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><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 = 'shejoh2022@gmail.com', leader_phone = '9883435232', agent_currency_multiplier = '1.00000', ip_addr = '123.253.233.242', 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>Breakfast for 2, Free self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><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 = '', 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='116.71',  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='7842',  sub_agent_rate='0',  agent_rate='116.13',  applicable_service_tax='0',  supplier_rate='116.13',  uid='8c21823feea575b8158135515ea5d92f'  where id='369';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='369';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('369','-6.2443203356515','106.62789595585');
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'straightline_wh',`create_date`= '2024-01-29 06:18:56',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;369\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -369 And Booking Status - confirmed',`ip`= '123.253.233.242';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='659', `entity`='BookingId', `value`='369' ;
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= '2024/00015', voucher_id='2901061855',status_date='2024-01-29 06:18:56',current_status='vouchered',voucher_hashcode='553d3c5a35be2f92e0ad90e9cf9e98c092489369',vouchered_by ='' where id='369';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2024/00016' where id='369' and is_invoiced!='yes';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('116.13'),   credit_value= credit_value-('116.13') ,  cd_credit_usage=cd_credit_usage+('116.13') , cd_credit_value=cd_credit_value-('116.13')  WHERE id = '7842';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7842',credit_value= '996407.680',credit_usage= '3591.320',credit_limit= '999999.000',receipt_id= '',amount= '116.13',booking_id='369',booking_cost= '116.13',receipt_allocation= '',balance= '116.13',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:56';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents  SET credit_usage=credit_usage+('116.71'),   credit_value= credit_value-('116.71') ,  cd_credit_usage=cd_credit_usage+('116.71') , cd_credit_value=cd_credit_value-('116.71')  WHERE id = '7868';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6666052.880',credit_usage= '613.120',credit_limit= '6666666.000',receipt_id= '',amount= '116.71',booking_id='369',booking_cost= '116.13',receipt_allocation= '',balance= '116.13',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:56';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into wh_booking_rate_info set  booking_id = '369', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:18:56', type = 'Sale', agent_price = '116.710', sub_agent_price = '0.000', supplier_price = '116.130';
[01/29/2024 06:18:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '369', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:18:56', supplier_currency ='USD', type = 'Sale', agent_price = '116.13', sub_agent_price ='', supplier_price = '116.130', supplier_id = 'expediapackage', supplier_type = 'online';
[01/29/2024 06:19:01], [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
		('','','369','vouchered-invoiced','2024-01-29 06:19:01','Booking invoice by user id -7842','7842','123.253.233.242','','','');
[01/29/2024 06:19:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='369',booking_detail_id ='369',agent_id ='7842',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-29 06:19:01';
[01/29/2024 06:19:01], [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
		('','','369','vouchered','2024-01-29 06:19:01','Vouchered By Agent..7842','7842','123.253.233.242','','','');
[01/29/2024 06:19:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','gajendra.rajpurohit@qtechsoftware.com');
[01/29/2024 06:19:02], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','email@hotelyards.com');
[01/29/2024 06:19:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:19:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','rohan.vartak@qtechsoftware.com');
[01/29/2024 06:19:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:19:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:19:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('369','nisha@qtechsoftware.com');
[01/29/2024 06:19:04], [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 ('2328','369','confirmed','2024-01-29 06:18:56','Booking confirmed','7842','123.253.233.242','0','7842');
[01/29/2024 06:19:04], [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('369','2024-01-26 18:17:33','2024-01-26 18:17:33','2024-01-29 00:00:00','2024-01-29 00:00:00','116.13','116.71','','2024-01-29 06:19:04','116.71');
[01/29/2024 06:19:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='369',status='1' where reservation_id='2328' and booking_id ='0';
[01/29/2024 06:19:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='369' where agent_logs_id='0' and source_type='expediapackage';
[01/29/2024 06:19:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='9.32',  commission_tax='',  booking_id ='369',  supplier_tax='20.16',  supplier_base_fare='95.97',  supplier_commissionable_fare='9.32'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-01-29 06:19:05';
[01/29/2024 06:19:17], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:19:17' WHERE id= '459';
[01/29/2024 06:20:10], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:20:10' WHERE id= '459';
[01/29/2024 06:20:14], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:20:14' WHERE id= '459';
[01/29/2024 06:20:18], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:20:18' WHERE id= '459';
[01/29/2024 06:20:18], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:20:38], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:20:38' WHERE id= '459';
[01/29/2024 06:23:52], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:23:52' WHERE id= '459';
[01/29/2024 06:24:01], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:24:01' WHERE id= '459';
[01/29/2024 06:27:02], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:27:02' WHERE id= '459';
[01/29/2024 06:28:07], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:07' WHERE id= '459';
[01/29/2024 06:28:50], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:50' WHERE id= '459';
[01/29/2024 06:28:53], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:53' WHERE id= '459';
[01/29/2024 06:28:59], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:59' WHERE id= '459';
[01/29/2024 06:28:59], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:28:59], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:59' WHERE id= '459';
[01/29/2024 06:28:59], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:28:59' WHERE id= '459';
[01/29/2024 06:29:01], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:29:01' WHERE id= '459';
[01/29/2024 06:29:04], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:29:04' WHERE id= '459';
[01/29/2024 06:29:04], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:29:21], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:29:21' WHERE id= '459';
[01/29/2024 06:29:21], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:29:57], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:29:57' WHERE id= '459';
[01/29/2024 06:35:06], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-29 06:35:06',login_attempt=0 where id = '7851';
[01/29/2024 06:35:06], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-29 06:35:06', ip = '43.239.53.130', action = 'Login' ;
[01/29/2024 06:35:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:07' WHERE id= '461';
[01/29/2024 06:35:10], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:10' WHERE id= '461';
[01/29/2024 06:35:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:13' WHERE id= '461';
[01/29/2024 06:35:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:20' WHERE id= '461';
[01/29/2024 06:35:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:35:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:35:22], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_35_20_1706510120.json', 'v1/29_01_2024/response_availability_Viator_test_06_35_20_1706510120.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_35_20_1706510120.json', 'viator', '2024-01-29 06:35:22', '', '', '1152');
[01/29/2024 06:35:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:23' WHERE id= '461';
[01/29/2024 06:35:24], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:24' WHERE id= '461';
[01/29/2024 06:35:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:27' WHERE id= '461';
[01/29/2024 06:35:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_35_27_1706510127.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_35_27_1706510127.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_35_27_1706510127.json', 'viator', '2024-01-29 06:35:27', '', '', '1152');
[01/29/2024 06:35:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:53' WHERE id= '461';
[01/29/2024 06:35:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:35:53',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:35:53], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_35_53_1706510153.json', 'v1/29_01_2024/response_availability_Viator_test_06_35_53_1706510153.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_35_53_1706510153.json', 'viator', '2024-01-29 06:35:53', '', '', '1153');
[01/29/2024 06:35:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:54' WHERE id= '461';
[01/29/2024 06:35:54], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:54' WHERE id= '461';
[01/29/2024 06:35:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:35:56' WHERE id= '461';
[01/29/2024 06:35:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_35_56_1706510156.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_35_56_1706510156.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_35_56_1706510156.json', 'viator', '2024-01-29 06:35:56', '', '', '1153');
[01/29/2024 06:36:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:36:07' WHERE id= '461';
[01/29/2024 06:36:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_36_07_1706510167.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_36_07_1706510167.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_36_07_1706510167.json', 'viator', '2024-01-29 06:36:07', '', '', '1153');
[01/29/2024 06:36:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:36:10' WHERE id= '461';
[01/29/2024 06:36:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_36_10_1706510170.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_36_10_1706510170.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_36_10_1706510170.json', 'viator', '2024-01-29 06:36:10', '', '', '1153');
[01/29/2024 06:36:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:36:13' WHERE id= '461';
[01/29/2024 06:36:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_36_13_1706510173.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_36_13_1706510173.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_36_13_1706510173.json', 'viator', '2024-01-29 06:36:13', '', '', '1153');
[01/29/2024 06:37:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:12' WHERE id= '461';
[01/29/2024 06:37:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:17' WHERE id= '461';
[01/29/2024 06:37:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:37:17',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:37:18], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_37_17_1706510237.json', 'v1/29_01_2024/response_availability_Viator_test_06_37_17_1706510237.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_37_17_1706510237.json', 'viator', '2024-01-29 06:37:18', '', '', '1154');
[01/29/2024 06:37:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:19' WHERE id= '461';
[01/29/2024 06:37:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:19' WHERE id= '461';
[01/29/2024 06:37:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:21' WHERE id= '461';
[01/29/2024 06:37:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_37_21_1706510241.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_37_21_1706510241.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_37_21_1706510241.json', 'viator', '2024-01-29 06:37:22', '', '', '1154');
[01/29/2024 06:37:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:37:57' WHERE id= '461';
[01/29/2024 06:37:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:37:57',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:38:00], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_37_57_1706510277.json', 'v1/29_01_2024/response_availability_Viator_test_06_37_57_1706510277.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_37_57_1706510277.json', 'viator', '2024-01-29 06:38:00', '', '', '1155');
[01/29/2024 06:38:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:38:01' WHERE id= '461';
[01/29/2024 06:38:01], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:38:01' WHERE id= '461';
[01/29/2024 06:38:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:38:03' WHERE id= '461';
[01/29/2024 06:38:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_38_03_1706510283.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_38_03_1706510283.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_38_03_1706510283.json', 'viator', '2024-01-29 06:38:04', '', '', '1155');
[01/29/2024 06:39:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:39:51' WHERE id= '461';
[01/29/2024 06:39:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:39:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:39:51], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_39_51_1706510391.json', 'v1/29_01_2024/response_availability_Viator_test_06_39_51_1706510391.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_39_51_1706510391.json', 'viator', '2024-01-29 06:39:51', '', '', '1156');
[01/29/2024 06:39:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:39:52' WHERE id= '461';
[01/29/2024 06:39:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:39:52' WHERE id= '461';
[01/29/2024 06:39:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:39:55' WHERE id= '461';
[01/29/2024 06:39:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_39_55_1706510395.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_39_55_1706510395.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_39_55_1706510395.json', 'viator', '2024-01-29 06:39:55', '', '', '1156');
[01/29/2024 06:39:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:39:58' WHERE id= '461';
[01/29/2024 06:40:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:40:03' WHERE id= '461';
[01/29/2024 06:40:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:40:10' WHERE id= '461';
[01/29/2024 06:40:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_40_10_1706510410.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_40_10_1706510410.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_40_10_1706510410.json', 'viator', '2024-01-29 06:40:10', '', '', '1156');
[01/29/2024 06:41:00], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:41:00' WHERE id= '459';
[01/29/2024 06:41:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:41:07' WHERE id= '459';
[01/29/2024 06:41:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:41:13' WHERE id= '459';
[01/29/2024 06:41:13], [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 = '1' , ip = '123.253.233.242' , city = 'pekanbaru' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/01/29' , departure_date = '2024/01/30' , nights = '1' , nationality = '107' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-29 06:41:13' , site_id = '21' , country_code = '107' , city_code = '67341' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/29/2024 06:41:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:41:14' WHERE id= '459';
[01/29/2024 06:41:14], [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/29_01_2024/request_availability_straightline_wh_06_41_14_1706510474_78.json', 'e1/29_01_2024/response_availability_straightline_wh_06_41_14_1706510474_78.json', 'e1/29_01_2024/response_header_availability_straightline_wh_06_41_14_1706510474_78.json', 'expedia', '2024-01-29 06:41:14', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:41:14], [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/29_01_2024/request_availability_straightline_wh_06_41_14_1706510474_43.json', 'e1p/29_01_2024/response_availability_straightline_wh_06_41_14_1706510474_43.json', 'e1p/29_01_2024/response_header_availability_straightline_wh_06_41_14_1706510474_43.json', 'expediapackage', '2024-01-29 06:41:14', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:41:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:41:14.194'
            , 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.732'
            , error_description = ''
            , memory_used = '5150840'
            WHERE id = '30063';
[01/29/2024 06:41:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:41:14.195'
            , 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.764'
            , error_description = ''
            , memory_used = '5186624'
            WHERE id = '30064';
[01/29/2024 06:41:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:41:15' WHERE id= '459';
[01/29/2024 06:42:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:42:49' WHERE id= '461';
[01/29/2024 06:42:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:42:49',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:42:50], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_42_49_1706510569.json', 'v1/29_01_2024/response_availability_Viator_test_06_42_49_1706510569.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_42_49_1706510569.json', 'viator', '2024-01-29 06:42:50', '', '', '1157');
[01/29/2024 06:42:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:42:51' WHERE id= '461';
[01/29/2024 06:42:51], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:42:51' WHERE id= '461';
[01/29/2024 06:42:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:42:54' WHERE id= '461';
[01/29/2024 06:42:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_42_54_1706510574.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_42_54_1706510574.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_42_54_1706510574.json', 'viator', '2024-01-29 06:42:54', '', '', '1157');
[01/29/2024 06:43:25], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:25' WHERE id= '459';
[01/29/2024 06:43:26], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:26' WHERE id= '459';
[01/29/2024 06:43:26], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706510606','123.253.233.242');
[01/29/2024 06:43:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:26' WHERE id= '461';
[01/29/2024 06:43:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:43:26',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:43: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/29_01_2024/request_valuation_straightline_wh_06_43_26_1706510606_26.json', 'e1p/29_01_2024/response_valuation_straightline_wh_06_43_26_1706510606_26.json', 'e1p/29_01_2024/response_header_valuation_straightline_wh_06_43_26_1706510606_26.json', 'expediapackage', '2024-01-29 06:43:26', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:43:26], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_43_26_1706510606.json', 'v1/29_01_2024/response_availability_Viator_test_06_43_26_1706510606.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_43_26_1706510606.json', 'viator', '2024-01-29 06:43:26', '', '', '1158');
[01/29/2024 06:43:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:28' WHERE id= '461';
[01/29/2024 06:43:28], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:28' WHERE id= '461';
[01/29/2024 06:43:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:31' WHERE id= '461';
[01/29/2024 06:43:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_43_31_1706510611.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_43_31_1706510611.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_43_31_1706510611.json', 'viator', '2024-01-29 06:43:31', '', '', '1158');
[01/29/2024 06:43:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:50' WHERE id= '459';
[01/29/2024 06:43:51], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:51' WHERE id= '459';
[01/29/2024 06:43:59], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:43:59' WHERE id= '459';
[01/29/2024 06:44:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:01' WHERE id= '459';
[01/29/2024 06:44:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:02' WHERE id= '459';
[01/29/2024 06:44:36], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:36' WHERE id= '459';
[01/29/2024 06:44:36], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706510676','123.253.233.242');
[01/29/2024 06:44:37], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:37' WHERE id= '459';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '2330', create_date = '2024-01-29 06:44:38', agent_id = '7842', parent_agent_id = '7842', agent_ref_no = '', nationality = 'Indonesian', city_id = 'pekanbaru', country_id = '107', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '74.03', display_currency_code = 'USD', native_room_rate = '74.03', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/29', check_out_date = '2024/01/30', sub_user_id = '', booking_status = '1', leader_title = 'Mrs', leader_first_name = 'Ayu', leader_last_name = 'Retno', status_date = '2024-01-29 06:44:38';
[01/29/2024 06:44:38], [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 ('370','GRAND JATRA HOTEL PEKANBARU','Grand Jatra Hotel Pekanbaru','5803062','OT000329739','pekanbaru','expediapackage',NOW());
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='370'
		;
[01/29/2024 06:44:38], [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('370','2330','','1','2','0','-','','','5803062','Grand Jatra Hotel Pekanbaru','Jl. Tengku Zainal Abidin Komplek Mal Pekanbaru No. 1','+62761850888','4.0','1','2024/01/29','2024/01/30','','https://straightline.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzYwMDAwMDAvNTgxMDAwMC81ODAzMTAwLzU4MDMwNjIvNzcxMjJjMmNfYi5qcGc=');
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '370', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'KingBed Grand Superior Room(Breakfast buffet)- <font color=\'red\'>Package Deal</font> <br>(1 King Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:74.030000000000001;s:25:"displayNightlyRateDisplay";s:152:"Rate - 74.03,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.2 USD, Marketing Fee - 5.2  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:74.400000000000006;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:74.030000000000001;}}', native_room_rate_total = '74.03', wh_room_rate_total = '74.4', display_room_rate_total = '74.03', number_of_rooms = '1';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '370', booking_detail_id = '1', rid = '174', room = '0', salutations = 'Mrs', first_name = 'Ayu', last_name = 'Retno', passenger_type = 'adult', age = '';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '370', booking_detail_id = '1', rid = '174', room = '0', salutations = 'Mrs', first_name = 'Retno', last_name = 'Ayu', passenger_type = 'adult', age = '';
[01/29/2024 06:44:38], [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/29_01_2024/request_reservation_straightline_wh_06_44_38_1706510678_40.json', 'e1p/29_01_2024/response_reservation_straightline_wh_06_44_38_1706510678_40.json', 'e1p/29_01_2024/response_header_reservation_straightline_wh_06_44_38_1706510678_40.json', 'expediapackage', '2024-01-29 06:44:38', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7072349268271', confirmation_number = '7072349268271', display_discount = '0', cancellation_policy = 'Free cancellation up to  22:59:59 on  2024-01-24<br>If you cancel between 2024-01-24 23:00:00 and 2024-01-29 00:00:00 , you will be charged 74.4 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 23:00 on 24th of January 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-01-25 11:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Breakfast buffet, Free parking, Free WiFi<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 = 'shejoh2022@gmail.com', leader_phone = '9883435232', agent_currency_multiplier = '1.00000', ip_addr = '123.253.233.242', 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>Breakfast buffet, Free parking, Free WiFi<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 = '', 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='74.4',  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='7842',  sub_agent_rate='0',  agent_rate='74.03',  applicable_service_tax='0',  supplier_rate='74.03',  uid='69ea82caa034c92cf767c22ecb1a9688'  where id='370';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='370';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('370','0.53075628949073','101.44833830166');
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'straightline_wh',`create_date`= '2024-01-29 06:44:38',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;370\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -370 And Booking Status - confirmed',`ip`= '123.253.233.242';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='660', `entity`='BookingId', `value`='370' ;
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= '2024/00017', voucher_id='2901064438',status_date='2024-01-29 06:44:38',current_status='vouchered',voucher_hashcode='9caf4eb07b325bc87c5b9dbfdcb8a3cb48004370',vouchered_by ='' where id='370';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2024/00018' where id='370' and is_invoiced!='yes';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('74.03'),   credit_value= credit_value-('74.03') ,  cd_credit_usage=cd_credit_usage+('74.03') , cd_credit_value=cd_credit_value-('74.03')  WHERE id = '7842';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7842',credit_value= '996333.650',credit_usage= '3665.350',credit_limit= '999999.000',receipt_id= '',amount= '74.03',booking_id='370',booking_cost= '74.03',receipt_allocation= '',balance= '74.03',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:38';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents  SET credit_usage=credit_usage+('74.4'),   credit_value= credit_value-('74.4') ,  cd_credit_usage=cd_credit_usage+('74.4') , cd_credit_value=cd_credit_value-('74.4')  WHERE id = '7868';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665978.480',credit_usage= '687.520',credit_limit= '6666666.000',receipt_id= '',amount= '74.4',booking_id='370',booking_cost= '74.03',receipt_allocation= '',balance= '74.03',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:38';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into wh_booking_rate_info set  booking_id = '370', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:44:38', type = 'Sale', agent_price = '74.400', sub_agent_price = '0.000', supplier_price = '74.030';
[01/29/2024 06:44:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '370', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:44:38', supplier_currency ='USD', type = 'Sale', agent_price = '74.03', sub_agent_price ='', supplier_price = '74.030', supplier_id = 'expediapackage', supplier_type = 'online';
[01/29/2024 06:44:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:41' WHERE id= '461';
[01/29/2024 06:44:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:44:41',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:44:41], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_44_41_1706510681.json', 'v1/29_01_2024/response_availability_Viator_test_06_44_41_1706510681.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_44_41_1706510681.json', 'viator', '2024-01-29 06:44:41', '', '', '1159');
[01/29/2024 06:44:43], [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
		('','','370','vouchered-invoiced','2024-01-29 06:44:43','Booking invoice by user id -7842','7842','123.253.233.242','','','');
[01/29/2024 06:44:43], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='370',booking_detail_id ='370',agent_id ='7842',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-29 06:44:43';
[01/29/2024 06:44:43], [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
		('','','370','vouchered','2024-01-29 06:44:43','Vouchered By Agent..7842','7842','123.253.233.242','','','');
[01/29/2024 06:44:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:43' WHERE id= '461';
[01/29/2024 06:44:43], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:43' WHERE id= '461';
[01/29/2024 06:44:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','gajendra.rajpurohit@qtechsoftware.com');
[01/29/2024 06:44:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','email@hotelyards.com');
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:45' WHERE id= '461';
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','rohan.vartak@qtechsoftware.com');
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:44:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_44_45_1706510685.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_44_45_1706510685.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_44_45_1706510685.json', 'viator', '2024-01-29 06:44:45', '', '', '1159');
[01/29/2024 06:44:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('370','nisha@qtechsoftware.com');
[01/29/2024 06:44:46], [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 ('2330','370','confirmed','2024-01-29 06:44:38','Booking confirmed','7842','123.253.233.242','0','7842');
[01/29/2024 06:44:46], [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('370','2024-01-24 23:00:00','2024-01-24 23:00:00','2024-01-29 00:00:00','2024-01-29 00:00:00','74.03','74.4','','2024-01-29 06:44:46','74.4');
[01/29/2024 06:44:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='370',status='1' where reservation_id='2330' and booking_id ='0';
[01/29/2024 06:44:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='370' where agent_logs_id='0' and source_type='expediapackage';
[01/29/2024 06:44:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='5.2',  commission_tax='',  booking_id ='370',  supplier_tax='12.85',  supplier_base_fare='61.18',  supplier_commissionable_fare='5.2'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-01-29 06:44:47';
[01/29/2024 06:44:56], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:44:56' WHERE id= '459';
[01/29/2024 06:45:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:45:15' WHERE id= '461';
[01/29/2024 06:45:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:45:15',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:45:16], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_45_15_1706510715.json', 'v1/29_01_2024/response_availability_Viator_test_06_45_15_1706510715.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_45_15_1706510715.json', 'viator', '2024-01-29 06:45:16', '', '', '1160');
[01/29/2024 06:45:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:45:17' WHERE id= '461';
[01/29/2024 06:45:17], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:45:17' WHERE id= '461';
[01/29/2024 06:45:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:45:19' WHERE id= '461';
[01/29/2024 06:45:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_45_19_1706510719.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_45_19_1706510719.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_45_19_1706510719.json', 'viator', '2024-01-29 06:45:19', '', '', '1160');
[01/29/2024 06:47:32], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:47:32' WHERE id= '459';
[01/29/2024 06:47:38], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:47:38' WHERE id= '459';
[01/29/2024 06:47:45], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:47:45' WHERE id= '459';
[01/29/2024 06:47:52], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:47:52' WHERE id= '459';
[01/29/2024 06:47:52], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:47:59], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:47:59' WHERE id= '459';
[01/29/2024 06:48:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:48:13' WHERE id= '459';
[01/29/2024 06:48:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:48:18' WHERE id= '459';
[01/29/2024 06:48:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:48:21' WHERE id= '459';
[01/29/2024 06:48:21], [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 = '1' , ip = '123.253.233.242' , city = 'jakarta' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/01/29' , departure_date = '2024/01/30' , nights = '1' , nationality = '107' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-29 06:48:21' , site_id = '21' , country_code = '107' , city_code = '67326' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/29/2024 06:48:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:48:21' WHERE id= '459';
[01/29/2024 06:48:22], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_84.json', 'e1/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_84.json', 'e1/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_84.json', 'expedia', '2024-01-29 06:48:22', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=2&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , 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.675'
            , error_description = ''
            , memory_used = '7368472'
            WHERE id = '30075';
[01/29/2024 06:48:22], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_88.json', 'e1p/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_88.json', 'e1p/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_88.json', 'expediapackage', '2024-01-29 06:48:22', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=2&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , 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.789'
            , error_description = ''
            , memory_used = '7496536'
            WHERE id = '30076';
[01/29/2024 06:48:23], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_77.json', 'e1/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_77.json', 'e1/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_77.json', 'expedia', '2024-01-29 06:48:23', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:23], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_7.json', 'e1/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_7.json', 'e1/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_7.json', 'expedia', '2024-01-29 06:48:23', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:23], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_72.json', 'e1p/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_72.json', 'e1p/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_72.json', 'expediapackage', '2024-01-29 06:48:23', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.427'
            , error_description = ''
            , memory_used = '35759592'
            WHERE id = '30077';
[01/29/2024 06:48:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=1&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.460'
            , error_description = ''
            , memory_used = '33861448'
            WHERE id = '30078';
[01/29/2024 06:48:23], [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/29_01_2024/request_availability_straightline_wh_06_48_22_1706510902_60.json', 'e1p/29_01_2024/response_availability_straightline_wh_06_48_22_1706510902_60.json', 'e1p/29_01_2024/response_header_availability_straightline_wh_06_48_22_1706510902_60.json', 'expediapackage', '2024-01-29 06:48:23', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:48:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=1&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.884'
            , error_description = ''
            , memory_used = '35175768'
            WHERE id = '30079';
[01/29/2024 06:48:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=3&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-29 06:48:22.154'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.920'
            , error_description = ''
            , memory_used = '37612888'
            WHERE id = '30080';
[01/29/2024 06:48:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:48:24' WHERE id= '459';
[01/29/2024 06:49:16], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:16' WHERE id= '459';
[01/29/2024 06:49:16], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:16' WHERE id= '459';
[01/29/2024 06:49:16], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706510956','123.253.233.242');
[01/29/2024 06:49:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:16' WHERE id= '461';
[01/29/2024 06:49:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:49:16',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:49:17], [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/29_01_2024/request_valuation_straightline_wh_06_49_16_1706510956_65.json', 'e1p/29_01_2024/response_valuation_straightline_wh_06_49_16_1706510956_65.json', 'e1p/29_01_2024/response_header_valuation_straightline_wh_06_49_16_1706510956_65.json', 'expediapackage', '2024-01-29 06:49:17', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:49:17], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_49_16_1706510956.json', 'v1/29_01_2024/response_availability_Viator_test_06_49_16_1706510956.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_49_16_1706510956.json', 'viator', '2024-01-29 06:49:17', '', '', '1161');
[01/29/2024 06:49:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:18' WHERE id= '461';
[01/29/2024 06:49:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:18' WHERE id= '461';
[01/29/2024 06:49:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:25' WHERE id= '459';
[01/29/2024 06:49:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:25' WHERE id= '461';
[01/29/2024 06:49:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_49_25_1706510965.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_49_25_1706510965.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_49_25_1706510965.json', 'viator', '2024-01-29 06:49:25', '', '', '1161');
[01/29/2024 06:49:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:26' WHERE id= '459';
[01/29/2024 06:49:30], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:30' WHERE id= '459';
[01/29/2024 06:49:34], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:34' WHERE id= '459';
[01/29/2024 06:49:42], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:42' WHERE id= '459';
[01/29/2024 06:49:42], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706510982','123.253.233.242');
[01/29/2024 06:49:43], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:49:43' WHERE id= '459';
[01/29/2024 06:49:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '2332', create_date = '2024-01-29 06:49:44', agent_id = '7842', parent_agent_id = '7842', agent_ref_no = '', nationality = 'Indonesian', city_id = 'jakarta', country_id = '107', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '79.46', display_currency_code = 'USD', native_room_rate = '79.46', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/29', check_out_date = '2024/01/30', sub_user_id = '', booking_status = '1', leader_title = 'Mrs', leader_first_name = 'megi', leader_last_name = 'setiawan', status_date = '2024-01-29 06:49:44';
[01/29/2024 06:49:44], [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 ('371','NOVOTEL JAKARTA MANGGA DUA SQUARE','Novotel Jakarta Mangga Dua Square Hotel','1328749','OT000094410','jakarta','expediapackage',NOW());
[01/29/2024 06:49:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='371'
		;
[01/29/2024 06:49:44], [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('371','2332','','1','2','0','-','','','1328749','Novotel Jakarta Mangga Dua Square Hotel','Jalan Gunung Sahari Raya 1','+622162312800','4.0','1','2024/01/29','2024/01/30','','https://straightline.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzIwMDAwMDAvMTMzMDAwMC8xMzI4ODAwLzEzMjg3NDkvOGY1ZWFkZDBfYi5qcGc=');
[01/29/2024 06:49:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '371', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'TwinBed Deluxe Room, 2 Twin Beds(Free breakfast)- <font color=\'red\'>Package Deal</font> <br>(2 Twin Beds)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:79.459999999999994;s:25:"displayNightlyRateDisplay";s:154:"Rate - 79.46,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 5.31 USD, Marketing Fee - 5.31  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:79.859999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:79.459999999999994;}}', native_room_rate_total = '79.46', wh_room_rate_total = '79.86', display_room_rate_total = '79.46', number_of_rooms = '1';
[01/29/2024 06:49:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '371', booking_detail_id = '1', rid = '175', room = '0', salutations = 'Mrs', first_name = 'megi', last_name = 'setiawan', passenger_type = 'adult', age = '';
[01/29/2024 06:49:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '371', booking_detail_id = '1', rid = '175', room = '0', salutations = 'Mrs', first_name = 'setiawan', last_name = 'megi', passenger_type = 'adult', age = '';
[01/29/2024 06:49:45], [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/29_01_2024/request_reservation_straightline_wh_06_49_44_1706510984_31.json', 'e1p/29_01_2024/response_reservation_straightline_wh_06_49_44_1706510984_31.json', 'e1p/29_01_2024/response_header_reservation_straightline_wh_06_49_44_1706510984_31.json', 'expediapackage', '2024-01-29 06:49:45', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7917036567634', confirmation_number = '7917036567634', display_discount = '0', cancellation_policy = 'Free cancellation up to  19:59:59 on  2024-01-27<br>If you cancel between 2024-01-27 20:00:00 and 2024-01-29 00:00:00 , you will be charged 79.86 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 20:00 on 27th of January 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-01-28 08:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free breakfast, Free self parking, Free WiFi<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 = 'shejoh2022@gmail.com', leader_phone = '9883435232', agent_currency_multiplier = '1.00000', ip_addr = '123.253.233.242', 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 breakfast, Free self parking, Free WiFi<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 = '', 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='79.86',  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='7842',  sub_agent_rate='0',  agent_rate='79.46',  applicable_service_tax='0',  supplier_rate='79.46',  uid='be762320f1fa91742c459f6cf5fc6024'  where id='371';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='371';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('371','-6.13786','106.83175');
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'straightline_wh',`create_date`= '2024-01-29 06:49:45',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;371\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -371 And Booking Status - confirmed',`ip`= '123.253.233.242';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='661', `entity`='BookingId', `value`='371' ;
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= '2024/00019', voucher_id='2901064944',status_date='2024-01-29 06:49:45',current_status='vouchered',voucher_hashcode='03dad008f0ce46708c20334fe68b1bf056080371',vouchered_by ='' where id='371';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2024/00020' where id='371' and is_invoiced!='yes';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('79.46'),   credit_value= credit_value-('79.46') ,  cd_credit_usage=cd_credit_usage+('79.46') , cd_credit_value=cd_credit_value-('79.46')  WHERE id = '7842';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7842',credit_value= '996254.190',credit_usage= '3744.810',credit_limit= '999999.000',receipt_id= '',amount= '79.46',booking_id='371',booking_cost= '79.46',receipt_allocation= '',balance= '79.46',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:45';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents  SET credit_usage=credit_usage+('79.86'),   credit_value= credit_value-('79.86') ,  cd_credit_usage=cd_credit_usage+('79.86') , cd_credit_value=cd_credit_value-('79.86')  WHERE id = '7868';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '79.86',booking_id='371',booking_cost= '79.46',receipt_allocation= '',balance= '79.46',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-29 06:01:45';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into wh_booking_rate_info set  booking_id = '371', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:49:45', type = 'Sale', agent_price = '79.860', sub_agent_price = '0.000', supplier_price = '79.460';
[01/29/2024 06:49:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '371', booking_log = 'Booking Vouchered', create_date = '2024-01-29 06:49:45', supplier_currency ='USD', type = 'Sale', agent_price = '79.46', sub_agent_price ='', supplier_price = '79.460', supplier_id = 'expediapackage', supplier_type = 'online';
[01/29/2024 06:49:49], [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
		('','','371','vouchered-invoiced','2024-01-29 06:49:49','Booking invoice by user id -7842','7842','123.253.233.242','','','');
[01/29/2024 06:49:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='371',booking_detail_id ='371',agent_id ='7842',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-29 06:49:49';
[01/29/2024 06:49:49], [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
		('','','371','vouchered','2024-01-29 06:49:49','Vouchered By Agent..7842','7842','123.253.233.242','','','');
[01/29/2024 06:49:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','gajendra.rajpurohit@qtechsoftware.com');
[01/29/2024 06:49:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','email@hotelyards.com');
[01/29/2024 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','rohan.vartak@qtechsoftware.com');
[01/29/2024 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:49:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','deepak.trivedi@qtechsoftware.com');
[01/29/2024 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('371','nisha@qtechsoftware.com');
[01/29/2024 06:49:53], [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 ('2332','371','confirmed','2024-01-29 06:49:45','Booking confirmed','7842','123.253.233.242','0','7842');
[01/29/2024 06:49:53], [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('371','2024-01-27 20:00:00','2024-01-27 20:00:00','2024-01-29 00:00:00','2024-01-29 00:00:00','79.46','79.86','','2024-01-29 06:49:53','79.86');
[01/29/2024 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='371',status='1' where reservation_id='2332' and booking_id ='0';
[01/29/2024 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='371' where agent_logs_id='0' and source_type='expediapackage';
[01/29/2024 06:49:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='5.31',  commission_tax='',  booking_id ='371',  supplier_tax='14.15',  supplier_base_fare='65.31',  supplier_commissionable_fare='5.31'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-01-29 06:49:53';
[01/29/2024 06:50:02], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:02' WHERE id= '459';
[01/29/2024 06:50:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:21' WHERE id= '461';
[01/29/2024 06:50:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:50:21',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:50:21], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_50_21_1706511021.json', 'v1/29_01_2024/response_availability_Viator_test_06_50_21_1706511021.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_50_21_1706511021.json', 'viator', '2024-01-29 06:50:21', '', '', '1162');
[01/29/2024 06:50:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:22' WHERE id= '461';
[01/29/2024 06:50:22], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:22' WHERE id= '461';
[01/29/2024 06:50:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:24' WHERE id= '461';
[01/29/2024 06:50:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_50_24_1706511024.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_50_24_1706511024.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_50_24_1706511024.json', 'viator', '2024-01-29 06:50:24', '', '', '1162');
[01/29/2024 06:50:35], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:35' WHERE id= '459';
[01/29/2024 06:50:44], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:44' WHERE id= '459';
[01/29/2024 06:50:47], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:47' WHERE id= '459';
[01/29/2024 06:50:51], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:51' WHERE id= '459';
[01/29/2024 06:50:51], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:50:58], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:50:58' WHERE id= '459';
[01/29/2024 06:52:20], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:52:20' WHERE id= '459';
[01/29/2024 06:52:20], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 06:52:24], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:52:24' WHERE id= '459';
[01/29/2024 06:52:27], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:52:27' WHERE id= '459';
[01/29/2024 06:53:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:53:11' WHERE id= '461';
[01/29/2024 06:53:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:53:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:53:11], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_53_11_1706511191.json', 'v1/29_01_2024/response_availability_Viator_test_06_53_11_1706511191.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_53_11_1706511191.json', 'viator', '2024-01-29 06:53:11', '', '', '1163');
[01/29/2024 06:53:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:53:13' WHERE id= '461';
[01/29/2024 06:53:13], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:53:13' WHERE id= '461';
[01/29/2024 06:53:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:53:15' WHERE id= '461';
[01/29/2024 06:53:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_53_15_1706511195.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_53_15_1706511195.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_53_15_1706511195.json', 'viator', '2024-01-29 06:53:15', '', '', '1163');
[01/29/2024 06:54:13], [file name :-/home/otrams/public_html/beta/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706511253','43.239.53.130');
[01/29/2024 06:55:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:55:06' WHERE id= '461';
[01/29/2024 06:55:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:55:06',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:55:07], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_55_06_1706511306.json', 'v1/29_01_2024/response_availability_Viator_test_06_55_06_1706511306.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_55_06_1706511306.json', 'viator', '2024-01-29 06:55:07', '', '', '1164');
[01/29/2024 06:55:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:55:12' WHERE id= '461';
[01/29/2024 06:55:12], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:55:12' WHERE id= '461';
[01/29/2024 06:55:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:55:17' WHERE id= '461';
[01/29/2024 06:55:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_55_17_1706511317.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_55_17_1706511317.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_55_17_1706511317.json', 'viator', '2024-01-29 06:55:17', '', '', '1164');
[01/29/2024 06:56:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:56:41' WHERE id= '461';
[01/29/2024 06:56:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :06:56:41',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 06:56:41], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/29_01_2024/request_availability_Viator_test_06_56_41_1706511401.json', 'v1/29_01_2024/response_availability_Viator_test_06_56_41_1706511401.json', 'v1/29_01_2024/response_header_availability_Viator_test_06_56_41_1706511401.json', 'viator', '2024-01-29 06:56:41', '', '', '1165');
[01/29/2024 06:56:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:56:43' WHERE id= '461';
[01/29/2024 06:56:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:56:44' WHERE id= '461';
[01/29/2024 06:56:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 06:56:47' WHERE id= '461';
[01/29/2024 06:56:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_06_56_47_1706511407.json', 'v1/29_01_2024/response_sight_details_Viator_test_06_56_47_1706511407.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_06_56_47_1706511407.json', 'viator', '2024-01-29 06:56:49', '', '', '1165');
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotels SET name = 'Travel Buggy',rating = '5.0',first_name = 'Sachin',middle_name = 'Ramesh' ,last_name = 'Tendulkar' ,city = '64440',country = '106',location_id = '81924',area = '',address = 'Dadar east MUmbai' ,phone ='9876598765',fax = '',email = 'email@qtechsoft.com',website = 'travel_buggy.in',latitude = '',longitude = '',driving_direction = 'details about Driving Direction',near_by = 'Exhibition Center,Shopping Center,Malls,Transport Station',weekend = '6,7',main_image = '',optional_images = '#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#',main_image_desc = '',optional_images_desc = '',hotelbeds_code ='',status ='A',short_desc = '',long_desc = 'DEscription about hotel (This description will display on hotel list page at front side';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-29 06:57:08',`log_type`= 'Hotel Added',`sql_query`= 'INSERT INTO hotels SET name = \&#039;Travel Buggy\&#039;,rating = \&#039;5.0\&#039;,first_name = \&#039;Sachin\&#039;,middle_name = \&#039;Ramesh\&#039; ,last_name = \&#039;Tendulkar\&#039; ,city = \&#039;64440\&#039;,country = \&#039;106\&#039;,location_id = \&#039;81924\&#039;,area = \&#039;\&#039;,address = \&#039;Dadar east MUmbai\&#039; ,phone =\&#039;9876598765\&#039;,fax = \&#039;\&#039;,email = \&#039;email@qtechsoft.com\&#039;,website = \&#039;travel_buggy.in\&#039;,latitude = \&#039;\&#039;,longitude = \&#039;\&#039;,driving_direction = \&#039;details about Driving Direction\&#039;,near_by = \&#039;Exhibition Center,Shopping Center,Malls,Transport Station\&#039;,weekend = \&#039;6,7\&#039;,main_image = \&#039;\&#039;,optional_images = \&#039;#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#\&#039;,main_image_desc = \&#039;\&#039;,optional_images_desc = \&#039;\&#039;,hotelbeds_code =\&#039;\&#039;,status =\&#039;A\&#039;,short_desc = \&#039;\&#039;,long_desc = \&#039;DEscription about hotel (This description will display on hotel list page at front side\&#039;',`log_description`= 'Hotel Travel Buggy Added by User v3alpha',`ip`= '43.239.53.130';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotel_amenity SET hotel_id = '3',amenity_id = '1';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotel_amenity SET hotel_id = '3',amenity_id = '2';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotel_amenity SET hotel_id = '3',amenity_id = '3';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotel_amenity SET hotel_id = '3',amenity_id = '4';
[01/29/2024 06:57:08], [file name :-/home/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotel_amenity SET hotel_id = '3',amenity_id = '5';
