[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='10.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='						Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-29 10:58:04', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='10.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='10.340', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='20.918984280532', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='20.918984280532', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:35:02', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:35:02', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='81', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '535', old_reff_id = '81', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '281', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '536', old_reff_id = '81', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '281', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '281', old_reff_id = '81', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"10";s:13:"whNightlyRate";s:5:"10.34";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '10' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:4:"12.5";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '284', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '284', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='												Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='1109.1898428053',agent_markup='1109.1898428053',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:35:02',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '100',display_discount='0',modified_datetime='2024-04-02 09:35:02',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='100', agent_markup='1109.1898428053', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='12.5' where id='386';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:35:02', supplier_currency ='USD', type = 'Ammended', agent_price = '90', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:35:02', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:35:02', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:35:02', agent_price = '12.500', sub_agent_price = '0.000', supplier_price = '100.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('90'),   credit_value= credit_value-('90') ,  cd_credit_usage=cd_credit_usage+('90') , cd_credit_value=cd_credit_value-('90')  WHERE id = '7863';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998372.570',credit_usage= '627.430',credit_limit= '999999000.000',receipt_id= '',amount= '90',booking_id='386',booking_cost= '100',receipt_allocation= '',balance= '100',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:02';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('2.16'),   credit_value= credit_value-('2.16') ,  cd_credit_usage=cd_credit_usage+('2.16') , cd_credit_value=cd_credit_value-('2.16')  WHERE id = '7866';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-195.100',credit_usage= '195.100',credit_limit= '0.000',receipt_id= '',amount= '2.16',booking_id='386',booking_cost= '100',receipt_allocation= '',balance= '100',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:02';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='91.729999999998',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 1109.1898428053 %',create_date ='2024-04-02 09:35:02';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:35:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:35:02','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='100.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='												Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:35:02', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='100.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='12.500', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='1109.1898428053', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='1109.1898428053', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:37:52', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:37:52', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='82', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '540', old_reff_id = '82', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '284', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '541', old_reff_id = '82', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '284', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '284', old_reff_id = '82', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:4:"12.5";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '100' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"200";s:13:"whNightlyRate";s:3:"125";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '200' ,number_of_rooms = '1';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '285', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '285', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																		Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='2318.3796856106',agent_markup='2318.3796856106',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:37:52',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '200',display_discount='0',modified_datetime='2024-04-02 09:37:52',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='200', agent_markup='2318.3796856106', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='125' where id='386';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:37:52', supplier_currency ='USD', type = 'Ammended', agent_price = '100', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:37:52', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:37:52', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:37:52', agent_price = '125.000', sub_agent_price = '0.000', supplier_price = '200.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('100'),   credit_value= credit_value-('100') ,  cd_credit_usage=cd_credit_usage+('100') , cd_credit_value=cd_credit_value-('100')  WHERE id = '7863';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998272.570',credit_usage= '727.430',credit_limit= '999999000.000',receipt_id= '',amount= '100',booking_id='386',booking_cost= '200',receipt_allocation= '',balance= '200',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:52';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('112.5'),   credit_value= credit_value-('112.5') ,  cd_credit_usage=cd_credit_usage+('112.5') , cd_credit_value=cd_credit_value-('112.5')  WHERE id = '7866';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-307.600',credit_usage= '307.600',credit_limit= '0.000',receipt_id= '',amount= '112.5',booking_id='386',booking_cost= '200',receipt_allocation= '',balance= '200',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:52';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='191.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 2318.3796856106 %',create_date ='2024-04-02 09:37:52';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:37:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:37:52','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='200.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																		Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:37:52', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='200.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='125.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='2318.3796856106', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='2318.3796856106', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:38:24', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:38:24', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='83', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '542', old_reff_id = '83', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '285', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '543', old_reff_id = '83', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '285', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '285', old_reff_id = '83', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"200";s:13:"whNightlyRate";s:3:"125";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '200' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"200";s:13:"whNightlyRate";s:3:"250";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '200' ,number_of_rooms = '1';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '286', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '286', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																								Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='2318.3796856106',agent_markup='2318.3796856106',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:38:24',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '200',display_discount='0',modified_datetime='2024-04-02 09:38:24',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='200', agent_markup='2318.3796856106', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='250' where id='386';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:38:24', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:38:24', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:38:24', agent_price = '250.000', sub_agent_price = '0.000', supplier_price = '200.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:38:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:38:24','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='200.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																								Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:38:24', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='200.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='250.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='2318.3796856106', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='2318.3796856106', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:39:52', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:39:52', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='84', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '544', old_reff_id = '84', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '286', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '545', old_reff_id = '84', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '286', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '286', old_reff_id = '84', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"200";s:13:"whNightlyRate";s:3:"250";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '200' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"75";s:13:"whNightlyRate";s:3:"250";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '75' ,number_of_rooms = '1';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '287', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '287', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																														Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='806.89238210399',agent_markup='806.89238210399',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:39:52',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '75',display_discount='0',modified_datetime='2024-04-02 09:39:52',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='75', agent_markup='806.89238210399', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='250' where id='386';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:39:52', supplier_currency ='USD', type = 'Ammended', agent_price = '-125', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:39:52', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:39:52', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:39:52', agent_price = '250.000', sub_agent_price = '0.000', supplier_price = '75.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('-125'),   credit_value= credit_value-('-125') ,  cd_credit_usage=cd_credit_usage+('-125') , cd_credit_value=cd_credit_value-('-125')  WHERE id = '7863';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998397.570',credit_usage= '602.430',credit_limit= '999999000.000',receipt_id= '',amount= '-125',booking_id='386',booking_cost= '75',receipt_allocation= '',balance= '75',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:52';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7866';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-307.600',credit_usage= '307.600',credit_limit= '0.000',receipt_id= '',amount= '',booking_id='386',booking_cost= '75',receipt_allocation= '',balance= '75',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:52';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='66.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 806.89238210399 %',create_date ='2024-04-02 09:39:52';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:39:52], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:39:52','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='75.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																														Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:39:52', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='75.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='250.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='806.89238210399', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='806.89238210399', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:40:53', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:40:53', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='85', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '546', old_reff_id = '85', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '287', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '547', old_reff_id = '85', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '287', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '287', old_reff_id = '85', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"75";s:13:"whNightlyRate";s:3:"250";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '75' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"75";s:13:"whNightlyRate";s:5:"93.75";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '75' ,number_of_rooms = '1';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '288', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '288', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																				Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='806.89238210399',agent_markup='806.89238210399',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:40:53',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '75',display_discount='0',modified_datetime='2024-04-02 09:40:53',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='75', agent_markup='806.89238210399', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='93.75' where id='386';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:40:53', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:40:53', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:40:53', agent_price = '93.750', sub_agent_price = '0.000', supplier_price = '75.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:40:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:40:53','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='75.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																				Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:40:53', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='75.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='93.750', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='806.89238210399', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='806.89238210399', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:44:26', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:44:26', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='86', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '548', old_reff_id = '86', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '288', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '549', old_reff_id = '86', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '288', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '288', old_reff_id = '86', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"75";s:13:"whNightlyRate";s:5:"93.75";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '75' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"500";s:13:"whNightlyRate";s:5:"93.75";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '500' ,number_of_rooms = '1';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '289', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '289', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																										Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='5945.9492140266',agent_markup='5945.9492140266',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:44:26',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '500',display_discount='0',modified_datetime='2024-04-02 09:44:26',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='500', agent_markup='5945.9492140266', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='93.75' where id='386';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:44:26', supplier_currency ='USD', type = 'Ammended', agent_price = '425', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:44:26', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:44:26', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:44:26', agent_price = '93.750', sub_agent_price = '0.000', supplier_price = '500.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('425'),   credit_value= credit_value-('425') ,  cd_credit_usage=cd_credit_usage+('425') , cd_credit_value=cd_credit_value-('425')  WHERE id = '7863';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999997972.570',credit_usage= '1027.430',credit_limit= '999999000.000',receipt_id= '',amount= '425',booking_id='386',booking_cost= '500',receipt_allocation= '',balance= '500',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:26';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7866';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-307.600',credit_usage= '307.600',credit_limit= '0.000',receipt_id= '',amount= '',booking_id='386',booking_cost= '500',receipt_allocation= '',balance= '500',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:26';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='491.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 5945.9492140266 %',create_date ='2024-04-02 09:44:26';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:44:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:44:26','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='500.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																										Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:44:26', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='500.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='93.750', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='5945.9492140266', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='5945.9492140266', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:45:03', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:45:03', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='87', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '550', old_reff_id = '87', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '289', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '551', old_reff_id = '87', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '289', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '289', old_reff_id = '87', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"500";s:13:"whNightlyRate";s:5:"93.75";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '500' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"500";s:13:"whNightlyRate";s:3:"625";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '500' ,number_of_rooms = '1';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '290', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '290', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																																Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='5945.9492140266',agent_markup='5945.9492140266',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:45:03',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '500',display_discount='0',modified_datetime='2024-04-02 09:45:03',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='500', agent_markup='5945.9492140266', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='625' where id='386';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:45:03', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:45:03', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:45:03', agent_price = '625.000', sub_agent_price = '0.000', supplier_price = '500.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:45:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:45:03','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='500.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																																Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:45:03', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='500.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='625.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='5945.9492140266', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='5945.9492140266', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:46:22', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:46:22', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='88', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '552', old_reff_id = '88', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '290', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '553', old_reff_id = '88', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '290', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '290', old_reff_id = '88', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"500";s:13:"whNightlyRate";s:3:"625";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '500' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"700";s:13:"whNightlyRate";s:3:"625";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '700' ,number_of_rooms = '1';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '291', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '291', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																																						Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='8364.3288996372',agent_markup='8364.3288996372',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:46:22',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '700',display_discount='0',modified_datetime='2024-04-02 09:46:22',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='700', agent_markup='8364.3288996372', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='625' where id='386';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:46:22', supplier_currency ='USD', type = 'Ammended', agent_price = '200', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:46:22', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:46:22', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:46:22', agent_price = '625.000', sub_agent_price = '0.000', supplier_price = '700.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('200'),   credit_value= credit_value-('200') ,  cd_credit_usage=cd_credit_usage+('200') , cd_credit_value=cd_credit_value-('200')  WHERE id = '7863';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999997772.570',credit_usage= '1227.430',credit_limit= '999999000.000',receipt_id= '',amount= '200',booking_id='386',booking_cost= '700',receipt_allocation= '',balance= '700',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:22';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7866';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-307.600',credit_usage= '307.600',credit_limit= '0.000',receipt_id= '',amount= '',booking_id='386',booking_cost= '700',receipt_allocation= '',balance= '700',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:22';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='691.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 8364.3288996372 %',create_date ='2024-04-02 09:46:22';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:46:22], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:46:22','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='700.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																																						Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:46:22', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='700.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='625.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='8364.3288996372', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='8364.3288996372', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:47:41', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:47:41', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='89', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '554', old_reff_id = '89', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '291', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '555', old_reff_id = '89', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '291', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '291', old_reff_id = '89', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"700";s:13:"whNightlyRate";s:3:"625";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '700' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"700";s:13:"whNightlyRate";s:3:"875";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '700' ,number_of_rooms = '1';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '292', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '292', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																																												Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='8364.3288996372',agent_markup='8364.3288996372',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:47:41',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '700',display_discount='0',modified_datetime='2024-04-02 09:47:41',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='700', agent_markup='8364.3288996372', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='875' where id='386';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:47:41', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:47:41', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:47:41', agent_price = '875.000', sub_agent_price = '0.000', supplier_price = '700.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:47:41], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:47:41','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='700.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																																												Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:47:41', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='700.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='875.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='8364.3288996372', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='8364.3288996372', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:49:43', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:49:43', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='90', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '556', old_reff_id = '90', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '292', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '557', old_reff_id = '90', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '292', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '292', old_reff_id = '90', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"700";s:13:"whNightlyRate";s:3:"875";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '700' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:3:"875";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '293', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '293', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																																																		Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='1109.1898428053',agent_markup='1109.1898428053',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:49:43',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '100',display_discount='0',modified_datetime='2024-04-02 09:49:43',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='100', agent_markup='1109.1898428053', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='875' where id='386';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:49:43', supplier_currency ='USD', type = 'Ammended', agent_price = '-600', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:49:43', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:49:43', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:49:43', agent_price = '875.000', sub_agent_price = '0.000', supplier_price = '100.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('-600'),   credit_value= credit_value-('-600') ,  cd_credit_usage=cd_credit_usage+('-600') , cd_credit_value=cd_credit_value-('-600')  WHERE id = '7863';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998372.570',credit_usage= '627.430',credit_limit= '999999000.000',receipt_id= '',amount= '-600',booking_id='386',booking_cost= '100',receipt_allocation= '',balance= '100',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:43';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7866';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-307.600',credit_usage= '307.600',credit_limit= '0.000',receipt_id= '',amount= '',booking_id='386',booking_cost= '100',receipt_allocation= '',balance= '100',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-04-02 09:04:43';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='386',booking_detail_id ='386',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='91.729999999998',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 1109.1898428053 %',create_date ='2024-04-02 09:49:43';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:49:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:49:43','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='386', agent_id ='7863', itenirary_id ='7155156385697', confirmation_number ='7155156385697', payment_confirmation_no ='', voucher_id ='1321', voucher_hashcode ='3b0900fe5ff680ae41ebc0119109462189279386', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='bali', country_id ='107', display_room_rate ='100.000', native_room_rate ='8.270', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																																																																		Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-04-02 09:49:43', create_date ='2024-02-09 07:57:36', source_type ='expediapackage', expiration_date ='2024-06-11 10:00:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='100.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='875.000', supplier_rate ='8.270', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='1109.1898428053', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='1109.1898428053', wh_agent_markup ='25.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-04-02 09:51:43', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 09:51:43', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='185', old_reff_id ='91', booking_id ='386', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/06/19', departure_date ='2024/06/20', hotel_id ='8313143', hotel_name ='Teba House - CHSE Certified', hotel_address1 ='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_phone ='62-361-971179', hotel_rating ='2.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '558', old_reff_id = '91', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '293', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '559', old_reff_id = '91', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '293', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '293', old_reff_id = '91', booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:3:"875";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '100' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '386', booking_detail_id = '185', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Room(Room Only)- Package Deal (Members exclusive price)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:3:"125";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"8.27";}}' ,native_room_rate_total = '8.27' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '', rid = '294', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '294', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7155156385697',cancellation_policy='																																																																								Free cancellation up to  12:59:59 on  2024-06-11&lt;br&gt;If you cancel between 2024-06-11 13:00:00 and 2024-06-19 00:00:00 , you will be charged 10.34 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		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 13:00 on 11th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='1109.1898428053',agent_markup='1109.1898428053',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-04-02 09:51:43',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '100',display_discount='0',modified_datetime='2024-04-02 09:51:43',modified_by ='Ayman',native_room_rate='8.27',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-06-11 10:00:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free self parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Members exclusive price,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='386';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='100', agent_markup='1109.1898428053', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='125' where id='386';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:51:43', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:51:43', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '386', booking_log = 'Booking Modified', create_date = '2024-04-02 09:51:43', agent_price = '125.000', sub_agent_price = '0.000', supplier_price = '100.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '1', arrival_date='2024/06/19', departure_date='2024/06/20', rate_code='~', hotel_address1='Jalan Sugriwa No.59 Br. Padangtegal Klod', hotel_name='Teba House - CHSE Certified', hotel_phone='62-361-971179' where booking_id ='386';
[04/02/2024 09:51:43], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','386','vouchered','2024-04-02 09:51:43','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
