[04/02/2024 01:10:38], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-04-02 13:10:38', ip = '198.235.24.21', action = 'Login' ;
[04/02/2024 01:23:54], [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 ='1000.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 12:43:31', 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 ='1000.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 ='11991.898428053', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='11991.898428053', 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 13:23:54', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 13:23:54', 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 01:23:54], [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 ='99', 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 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '574', old_reff_id = '99', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '301', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '575', old_reff_id = '99', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '301', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '301', old_reff_id = '99', 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:4:"1000";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 = '1000' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:23:54], [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:"150";s:13:"whNightlyRate";s:4:"1250";}}' ,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 = '150' ,number_of_rooms = '1';
[04/02/2024 01:23:54], [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 = '302', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 01:23:54], [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 = '302', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 01:23:54], [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='1713.784764208',agent_markup='1713.784764208',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 13:23:54',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '150',display_discount='0',modified_datetime='2024-04-02 13:23:54',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 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='150', agent_markup='1713.784764208', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='1250' where id='386';
[04/02/2024 01:23:54], [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 13:23:54', supplier_currency ='USD', type = 'Ammended', agent_price = '-850', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:23:54], [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 13:23:54', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 01:23:54], [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 13:23:54', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:23:54], [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 13:23:54', agent_price = '1250.000', sub_agent_price = '0.000', supplier_price = '150.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('-850'),   credit_value= credit_value-('-850') ,  cd_credit_usage=cd_credit_usage+('-850') , cd_credit_value=cd_credit_value-('-850')  WHERE id = '7863';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998322.570',credit_usage= '677.430',credit_limit= '999999000.000',receipt_id= '',amount= '-850',booking_id='386',booking_cost= '150',receipt_allocation= '',balance= '150',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 13:04:54';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('1125'),   credit_value= credit_value-('1125') ,  cd_credit_usage=cd_credit_usage+('1125') , cd_credit_value=cd_credit_value-('1125')  WHERE id = '7866';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-1432.600',credit_usage= '1432.600',credit_limit= '0.000',receipt_id= '',amount= '1125',booking_id='386',booking_cost= '150',receipt_allocation= '',balance= '150',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 13:04:54';
[04/02/2024 01:23:54], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 01:23:54], [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 ='141.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 1713.784764208 %',create_date ='2024-04-02 13:23:54';
[04/02/2024 01:23:54], [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 01:23:54], [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 13:23:54','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 01:24:44], [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 ='150.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 13:23:54', 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 ='150.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='1250.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 ='1713.784764208', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='1713.784764208', 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 13:24:44', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 13:24:44', 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 01:24:44], [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 ='100', 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 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '576', old_reff_id = '100', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '302', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '577', old_reff_id = '100', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '302', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '302', old_reff_id = '100', 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:"150";s:13:"whNightlyRate";s:4:"1250";}}' ,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 = '150' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:24:44], [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:"150";s:13:"whNightlyRate";s:5:"187.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 = '150' ,number_of_rooms = '1';
[04/02/2024 01:24:44], [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 = '303', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 01:24:44], [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 = '303', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 01:24:44], [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='1713.784764208',agent_markup='1713.784764208',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 13:24:44',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '150',display_discount='0',modified_datetime='2024-04-02 13:24:44',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 01:24:44], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='150', agent_markup='1713.784764208', supplier_rate='8.27', wh_sub_agent_rate='', wh_agent_rate='187.5' where id='386';
[04/02/2024 01:24:44], [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 13:24:44', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 01:24:44], [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 13:24:44', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:24:44], [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 13:24:44', agent_price = '187.500', sub_agent_price = '0.000', supplier_price = '150.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 01:24:44], [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 01:24:44], [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 13:24:44','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 01:47: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 ='150.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 13:24:44', 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 ='150.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='187.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 ='1713.784764208', wh_applied_markup ='25.000', original_voucher ='', subagent_markup ='', agent_markup ='1713.784764208', 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 13:47:02', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 13:47: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 01:47: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 ='101', 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 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '578', old_reff_id = '101', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '303', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '579', old_reff_id = '101', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '303', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '303', old_reff_id = '101', 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:"150";s:13:"whNightlyRate";s:5:"187.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 = '150' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:47: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:"200";s:13:"whNightlyRate";s:5:"187.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 = '200' ,number_of_rooms = '1';
[04/02/2024 01:47: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 = '304', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 01:47: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 = '304', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 01:47: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='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 13:47:02',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '200',display_discount='0',modified_datetime='2024-04-02 13:47: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 01:47:02], [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='187.5' where id='386';
[04/02/2024 01:47: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 13:47:02', supplier_currency ='USD', type = 'Ammended', agent_price = '50', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:47: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 13:47:02', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 01:47: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 13:47:02', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:47: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 13:47:02', agent_price = '187.500', sub_agent_price = '0.000', supplier_price = '200.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('50'),   credit_value= credit_value-('50') ,  cd_credit_usage=cd_credit_usage+('50') , cd_credit_value=cd_credit_value-('50')  WHERE id = '7863';
[04/02/2024 01:47:02], [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= '50',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 13:04:02';
[04/02/2024 01:47:02], [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 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-1432.600',credit_usage= '1432.600',credit_limit= '0.000',receipt_id= '',amount= '',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 13:04:02';
[04/02/2024 01:47:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 01:47: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 ='191.73',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 2318.3796856106 %',create_date ='2024-04-02 13:47:02';
[04/02/2024 01:47: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 01:47: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 13:47:02','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[04/02/2024 01:49: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 ='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 13:47: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 ='200.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='187.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 ='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 13:49:53', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-04-02 13:49: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 01:49: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 ='102', 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 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '580', old_reff_id = '102', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '0', rid = '304', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '581', old_reff_id = '102', booking_id = '386', booking_detail_id = '185', salutations = 'Mr', room = '1', rid = '304', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '304', old_reff_id = '102', 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:5:"187.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 = '200' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[04/02/2024 01:49: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: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 01:49: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 = '305', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[04/02/2024 01:49: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 = '305', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[04/02/2024 01:49: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='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 13:49:53',service_date='2024-06-19',check_out_date='2024-06-20',display_room_rate= '100',display_discount='0',modified_datetime='2024-04-02 13:49: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 01:49:53], [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 01:49: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 13:49:53', supplier_currency ='USD', type = 'Ammended', agent_price = '-100', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:49: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 13:49:53', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[04/02/2024 01:49: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 13:49:53', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '8.270', supplier_id = 'expediapackage', supplier_type = 'online';
[04/02/2024 01:49: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 13:49:53', agent_price = '125.000', sub_agent_price = '0.000', supplier_price = '100.000' where booking_id = '386'  and type = "Sale";
[04/02/2024 01:49:53], [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 01:49:53], [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= '-100',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 13:04:53';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('-62.5'),   credit_value= credit_value-('-62.5') ,  cd_credit_usage=cd_credit_usage+('-62.5') , cd_credit_value=cd_credit_value-('-62.5')  WHERE id = '7866';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-1370.100',credit_usage= '1370.100',credit_limit= '0.000',receipt_id= '',amount= '-62.5',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 13:04:53';
[04/02/2024 01:49:53], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='386';
[04/02/2024 01:49:53], [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 13:49:53';
[04/02/2024 01:49: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 01:49: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 13:49:53','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
