[08/23/2024 12:09:54], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='138201', agent_id ='949', itenirary_id ='138201', confirmation_number ='', payment_confirmation_no ='', voucher_id ='23213232', voucher_hashcode ='7db2fdb9d7b9624686516d2b921ffac085983138201', email_id ='shiv.chauhan@qtechsoftware.com', leader_title ='Mr', leader_first_name ='shiv', leader_last_name ='chauhan', city_id ='delhi(new delhi)', country_id ='106', display_room_rate ='1.400', native_room_rate ='5.000', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='						Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
		Any Changes in initial booking may be denied by the supplier or may result in extra charges.
		Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;br&gt;&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 0.03 USD applicable if cancelled after 26-Sep-2024 05:30 hrs.
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-08-23 09:47:54', create_date ='2024-08-23 09:42:45', source_type ='localsystem', expiration_date ='2024-09-26 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='1.400', wh_sub_agent_rate ='0.000', wh_agent_rate ='1.400', supplier_rate ='5.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='shiv_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.27229', applied_markup ='2.94', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='2.94', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27229', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-08-23 12:09:54', modified_by ='shiv_qtech', display_currency_code ='USD', created_datetime ='2024-08-23 12:09:54', sub_agent_rate ='0.000', created_by ='shiv_qtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='43.239.53.130';
[08/23/2024 12:09:54], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='131457', old_reff_id ='56281', booking_id ='138201', supplier_id ='S000000042', total_nights ='1', arrival_date ='2024/09/27', departure_date ='2024/09/28', hotel_id ='48619', hotel_name ='DELHI_QTECHTEST HOTEL', hotel_address1 ='delhi', hotel_phone ='', hotel_rating ='3.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[08/23/2024 12:09:54], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '259887', old_reff_id = '56281', booking_id = '138201', booking_detail_id = '131457', salutations = 'Mr', room = '0', rid = '151659', first_name = 'shiv', last_name = 'chauhan' ,passenger_type = 'adult' ,age = '';
[08/23/2024 12:09:54], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '259888', old_reff_id = '56281', booking_id = '138201', booking_detail_id = '131457', salutations = 'Mr', room = '1', rid = '151659', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[08/23/2024 12:09:54], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '151659', old_reff_id = '56281', booking_id = '138201', booking_detail_id = '131457', room_type_code = '2~~~63~~~1078~~~2', room_name = 'double', room_type_description = 'Double Room  -Room Only : 2 Pax', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"1.4";s:13:"whNightlyRate";s:3:"1.4";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:1:"5";}}' ,native_room_rate_total = '5' ,display_room_rate_total = '1.4' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '138201', booking_detail_id = '131457', room_type_code = '2~~~63~~~1078~~~2', room_name = 'double', room_type_description = 'Double Room  -Room Only : 2 Pax', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"2.8";s:13:"whNightlyRate";s:3:"2.8";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"10";}}' ,native_room_rate_total = '10' ,display_room_rate_total = '2.8' ,number_of_rooms = '1';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '138201', booking_detail_id = '131457', salutations = 'Mr', room = '', rid = '151676', first_name = 'shiv', last_name = 'chauhan' ,age = '';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '138201', booking_detail_id = '131457', salutations = 'Mr', room = '1', rid = '151676', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='',cancellation_policy='												Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
		Any Changes in initial booking may be denied by the supplier or may result in extra charges.
		Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;br&gt;&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 0.03 USD applicable if cancelled after 26-Sep-2024 05:30 hrs.
											
											',supplier_cancellation_policy='',applied_multiplier='0.27229',applied_markup='2.94',agent_markup='2.94',consultant_id='shiv_qtech',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='0.27229',agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-08-23 12:09:55',service_date='2024-09-27',check_out_date='2024-09-28',display_room_rate= '2.8',display_discount='0',modified_datetime='2024-08-23 12:09:55',modified_by ='shiv_qtech',native_room_rate='10',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',nationality ='Indian',booking_type ='online',supplier_profile_id ='12',expiration_date= '2024-09-26 00:00:00',source_type='localsystem',special_comment='',admin_note='',comment_contract='',booking_repushti='4' WHERE id='138201';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='949', sub_agent_rate='', agent_rate='2.8', agent_markup='2.94', supplier_rate='10', wh_sub_agent_rate='', wh_agent_rate='2.8' where id='138201';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '138201', booking_log = 'Booking Modified', create_date = '2024-08-23 12:09:55', supplier_currency ='AED', type = 'Ammended', agent_price = '1.4', sub_agent_price ='', supplier_price = '5', supplier_id = 'S000000042', supplier_type = 'offline';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '138201', booking_log = 'Booking Modified', create_date = '2024-08-23 12:09:55', agent_price = '2.800', sub_agent_price = '0.000', supplier_price = '2.800' where booking_id = '138201'  and type = "Sale";
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('1.4'),   credit_value= credit_value-('1.4') ,  cd_credit_usage=cd_credit_usage+('1.4') , cd_credit_value=cd_credit_value-('1.4')  WHERE id = '949';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '949',credit_value= '1006.650',credit_usage= '-6.650',credit_limit= '1000.000',receipt_id= '',amount= '1.4',booking_id='138201',booking_cost= '2.8',receipt_allocation= '',balance= '2.8',ip='43.239.53.130',user_type='admin',admin_id='shiv_qtech',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-08-23 12:08:55';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='138201';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='138201',booking_detail_id ='138201',agent_id ='949',is_sub_agent ='N',parent_id ='',display_commission ='0.08005326',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 2.94 %',create_date ='2024-08-23 12:09:55';
[08/23/2024 12:09:55], [file name :-/efsdata/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000042' , total_rooms= '1', arrival_date='2024/09/27', departure_date='2024/09/28', rate_code='~', hotel_address1='delhi', hotel_name='DELHI_QTECHTEST HOTEL', hotel_phone='' where booking_id ='138201';
[08/23/2024 12:09:55], [file name :-/efsdata/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
		('','','138201','vouchered','2024-08-23 12:09:55','Booking Modified by shiv_qtech','shiv_qtech','43.239.53.130','shiv_qtech','','');
