[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3055', agent_id ='25', itenirary_id ='2', sequence = '2', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='Test', city_id ='Colombo', country_id ='132', display_room_rate ='1.530', native_room_rate ='100.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2020-11-02 05:36:34', create_date ='2020-11-02 05:36:34', source_type ='localsystem', expiration_date ='2020-11-02 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='QuotationTest', native_rate ='', display_rate ='', agent_rate ='1.530', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='100.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.01533', applied_markup ='-0.195694716242', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='-0.195694716242', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2021-09-17 05:22:23', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2021-09-17 05:22:23', 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 ='';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1193', old_reff_id ='559', booking_id ='3055', supplier_id ='S000000070', total_nights ='1', arrival_date ='2020/11/19', departure_date ='2020/11/20', hotel_id ='53701', hotel_name ='QuotationTest', hotel_address1 ='', hotel_phone ='', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6377', old_reff_id = '559', booking_id = '3055', booking_detail_id = '1193', salutations = 'Mrs', room = '0', rid = '1787', first_name = 'Snehal', last_name = 'Test' ,passenger_type = 'adult' ,age = '';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6378', old_reff_id = '559', booking_id = '3055', booking_detail_id = '1193', salutations = 'Mr', room = '0', rid = '1787', first_name = 'ToBeAdvisedB', last_name = 'ToBeAdvisedB' ,passenger_type = 'adult' ,age = '';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1787', old_reff_id = '559', booking_id = '3055', booking_detail_id = '1193', room_type_code = '2~~~111~~~617~~~1~~~~~~~~~71100~~~0~~~S000000070', room_name = 'double', room_type_description = 'Luxury Tent (A/C) - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:1.53;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";i:100;}}' ,native_room_rate_total = '100' ,display_room_rate_total = '1.53' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3055', booking_detail_id = '1193', room_type_code = '2~~~111~~~617~~~1~~~~~~~~~71100~~~0~~~S000000070', room_name = 'double', meal_basis = 'Bed & Breakfast', room_type_description = 'Luxury Tent (A/C) - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:4:"1.53";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '1.53' ,number_of_rooms = '1';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3055', booking_detail_id = '1193', salutations = 'Mrs', room = '', rid = '1859', first_name = 'Snehal', last_name = 'Test' ,age = '';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3055', booking_detail_id = '1193', salutations = 'Mr', room = '', rid = '1859', first_name = 'ToBeAdvisedB', last_name = 'ToBeAdvisedB' ,age = '';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='2293092089',native_currency_code='INR',display_currency_code='USD',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='0.01533',applied_markup='-0.195694716242',agent_markup='-0.195694716242',consultant_id='tfg',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1.00000',service_type_detail='QuotationTest',current_status='confirmed',status_date='2021-09-17 05:22:23',service_date='2021-04-23',check_out_date='2021-04-24',display_room_rate= '1.53',display_discount='0.000',modified_datetime='2021-09-17 05:22:23',modified_by ='tfg',native_room_rate='100',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= '2020-11-02 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3055';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-09-17 05:22:23',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.239.53.130\&#039; for booking \&#039;3055\&#039;',`ip`= '43.239.53.130';
[09/17/2021 05:22:23], [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='1.53', agent_markup='-0.195694716242', supplier_rate='100', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3055';
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1', supplier_id= 'S000000070', total_rooms= '1', arrival_date='2021/04/23', departure_date='2021/04/24', rate_code='~', hotel_address1='', hotel_name='QuotationTest', hotel_phone='', reservation_pushed='2' where booking_id ='3055';
[09/17/2021 05:22:23], [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
        ('','','3055','confirmed','2021-09-17 05:22:23','Booking Modified by tfg','tfg','43.239.53.130','tfg','','');
[09/17/2021 05:22:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='0.01533' where booking_id='3055' and from_currency='USD' and to_currency='INR';
