[03/06/2021 12:07:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3098', agent_id ='25', itenirary_id ='3', sequence = '3', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='Test', city_id ='Kotugoda', country_id ='132', display_room_rate ='52.230', native_room_rate ='200.000', native_currency_code ='MYR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2021-02-01 06:10:52', create_date ='2021-02-01 06:10:52', source_type ='localsystem', expiration_date ='2021-02-01 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='THE WALLAWWA', native_rate ='', display_rate ='', agent_rate ='52.230', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='200.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.23694', applied_markup ='10.217776652317', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='10.217776652317', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.23694', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2021-03-06 12:07:17', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2021-03-06 12:07:17', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[03/06/2021 12:07:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1236', old_reff_id ='553', booking_id ='3098', supplier_id ='S000000092', total_nights ='1', arrival_date ='2021/02/17', departure_date ='2021/02/18', hotel_id ='53719', hotel_name ='THE WALLAWWA', hotel_address1 ='', hotel_phone ='', hotel_rating ='3.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/06/2021 12:07:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6469', old_reff_id = '553', booking_id = '3098', booking_detail_id = '1236', salutations = 'Mrs', room = '0', rid = '1841', first_name = 'Snehal', last_name = 'Test' ,passenger_type = 'adult' ,age = '';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6470', old_reff_id = '553', booking_id = '3098', booking_detail_id = '1236', salutations = 'Mr', room = '0', rid = '1841', first_name = 'ToBeAdvisedB', last_name = 'ToBeAdvisedB' ,passenger_type = 'adult' ,age = '';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1841', old_reff_id = '553', booking_id = '3098', booking_detail_id = '1236', room_type_code = '2~~~140~~~671~~~1~~~~~~~~~105489~~~0~~~S000000092', room_name = 'double', room_type_description = 'ROH (Standard/Superior) - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:52.23;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";i:200;}}' ,native_room_rate_total = '200' ,display_room_rate_total = '52.23' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3098', booking_detail_id = '1236', room_type_code = '2~~~140~~~671~~~1~~~~~~~~~105489~~~0~~~S000000092', room_name = 'double', meal_basis = 'Bed & Breakfast', room_type_description = 'ROH (Standard/Superior) - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:5:"52.23";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"200";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '52.23' ,number_of_rooms = '1';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3098', booking_detail_id = '1236', salutations = 'Mrs', room = '', rid = '1842', first_name = 'Snehal', last_name = 'Test' ,age = '';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3098', booking_detail_id = '1236', salutations = 'Mr', room = '', rid = '1842', first_name = 'ToBeAdvisedB', last_name = 'ToBeAdvisedB' ,age = '';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='ag',native_currency_code='MYR',display_currency_code='USD',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='0.23694',applied_markup='10.217776652317',agent_markup='10.217776652317',consultant_id='tfg',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1.00000',service_type_detail='THE WALLAWWA',current_status='confirmed',status_date='2021-03-06 12:07:18',service_date='2021-02-17',check_out_date='2021-02-18',display_room_rate= '52.23',display_discount='0.000',modified_datetime='2021-03-06 12:07:18',modified_by ='tfg',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mrs',leader_first_name='Snehal',leader_last_name='Test',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2021-02-01 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3098';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-03-06 12:07:18',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.250.210.76\&#039; for booking \&#039;3098\&#039;',`ip`= '43.250.210.76';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='25', sub_agent_rate='', agent_rate='52.23', agent_markup='10.217776652317', supplier_rate='200', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3098';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1', supplier_id= 'S000000092', total_rooms= '1', arrival_date='2021/02/17', departure_date='2021/02/18', rate_code='~', hotel_address1='', hotel_name='THE WALLAWWA', hotel_phone='', reservation_pushed='2' where booking_id ='3098';
[03/06/2021 12:07:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set reservation_pushed = '2', channel_manager = 'rategain',room_type_description='' where booking_id = '3098';
[03/06/2021 12:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3098';
[03/06/2021 12:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/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
        ('','','3098','confirmed','2021-03-06 12:07:20','Booking Modified by tfg','tfg','43.250.210.76','tfg','','');
[03/06/2021 12:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='0.23694' where booking_id='3098' and from_currency='USD' and to_currency='MYR';
