[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3048', agent_id ='25', itenirary_id ='3048', sequence = '', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='', leader_first_name ='', leader_last_name ='', city_id ='mumbai', country_id ='106', display_room_rate ='54.440', native_room_rate ='200.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.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 2.72 USD applicable if cancelled after 27-Oct-2020 14:00 hrs.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2020-10-26 09:35:37', create_date ='2020-10-26 09:35:37', source_type ='localsystem', expiration_date ='2020-10-28 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='54.440', 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 ='nitinalpha', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.27222', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27222', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-26 11:35:15', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2020-10-26 11:35:15', 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 ='60.254.11.53';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1186', old_reff_id ='533', booking_id ='3048', supplier_id ='S000000241', total_nights ='1', arrival_date ='2020/10/30', departure_date ='2020/10/31', hotel_id ='53775', hotel_name ='SASSYSPOON', hotel_address1 ='Test', hotel_phone ='123456789', hotel_rating ='5.0', rate_code ='', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='rategain', reservation_pushed ='0', gtaToken ='';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1777', old_reff_id = '533', booking_id = '3048', booking_detail_id = '1186', room_type_code = '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'double', room_type_description = 'Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:54.44;s:16:"promotionDisplay";s:0:"";s:25:"displayNightlyRateDisplay";s:152:"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem";}}' ,native_nightly_rates = 'a:1:{i:0;a:4:{s:19:"O_nativeNightlyRate";i:200;s:17:"nativeNightlyRate";i:200;s:9:"free_sale";s:2:"no";s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '200' ,display_room_rate_total = '54.44' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3048', booking_detail_id = '1186', room_type_code = '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'double', meal_basis = '', room_type_description = 'Standard -Bed & Breakfast : 2 Pax -D', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"200";s:13:"whNightlyRate";s:3:"200";}}' ,native_nightly_rates = 'a:1:{i:0;a:3:{s:17:"nativeNightlyRate";s:3:"200";s:19:"O_nativeNightlyRate";i:200;s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '200' ,display_room_rate_total = '200' ,number_of_rooms = '1';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3048', booking_detail_id = '1186', salutations = 'Mr', room = '', rid = '1778', first_name = 'TBA', last_name = 'TBA' ,age = '';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3048', booking_detail_id = '1186', salutations = 'Mr', room = '', rid = '1778', first_name = 'TBA', last_name = 'TBA' ,age = '';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_currency_multiplier where booking_id =?;
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='Test123',native_currency_code='AED',display_currency_code='AED',is_currency_update='no',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;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 2.72 USD applicable if cancelled after 27-Oct-2020 14:00 hrs.                                ',supplier_cancellation_policy='',applied_multiplier='1',applied_markup='0',agent_markup='0',consultant_id='tfg',basecurrency_multiplier='0.27222',basecurrency_multiplier_native='0.27222'_native,agent_currency_multiplier='0.27222',service_type_detail='SASSYSPOON',current_status='confirmed',status_date='2020-10-26 11:35:15',service_date='2020-10-31',check_out_date='2020-11-01',display_room_rate= '200',display_discount='0',modified_datetime='2020-10-26 11:35:15',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='CaseTwo',nationality ='Indian',accounts_processed ='0',booking_type ='online',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-10-28 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3048';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-26 11:35:15',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;60.254.11.53\&#039; for booking \&#039;3048\&#039;',`ip`= '60.254.11.53';
[10/26/2020 11:35:15], [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='200', agent_markup='0', supplier_rate='200', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='200' where id='3048';
[10/26/2020 11:35:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000241' , total_rooms= '1', arrival_date='2020/10/31', departure_date='2020/11/01', rate_code='~', hotel_address1='Test', hotel_name='SASSYSPOON', hotel_phone='123456789', reservation_pushed='2' where booking_id ='3048';
[10/26/2020 11:35:15], [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
        ('','','3048','confirmed','2020-10-26 11:35:15','Booking Modified by tfg','tfg','60.254.11.53','tfg','','');
[10/26/2020 11:35:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1' where booking_id='3048' and from_currency='AED' and to_currency='AED';
[10/26/2020 11:35:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3048';
[10/26/2020 11:39:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3048', agent_id ='25', itenirary_id ='3048', confirmation_number ='Test123', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='CaseTwo', city_id ='mumbai', country_id ='106', display_room_rate ='200.000', native_room_rate ='200.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;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 2.72 USD applicable if cancelled after 27-Oct-2020 14:00 hrs.                                ', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2020-10-26 11:35:15', create_date ='2020-10-26 09:35:37', source_type ='localsystem', expiration_date ='2020-10-28 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='SASSYSPOON', native_rate ='', display_rate ='', agent_rate ='200.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='200.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 ='1', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.27222', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27222', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='0.27222', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-26 11:39:21', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2020-10-26 11:39:21', sub_agent_rate ='0.000', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='60.254.11.53', is_cancel_history ='1';
[10/26/2020 11:39:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3048','cancelled','2020-10-26 11:39:21','Cancellation Confirmation Number: Cancellation done on 2020-10-26 11:39:21  by tfg','tfg','60.254.11.53','tfg','','');
[10/26/2020 11:39:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2020-10-26 11:39:21' , pending_cancellation = 'no'WHERE reservation_id = 'QTECH2020101854' AND id = '3048' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[10/26/2020 11:39:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3048',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3048';
[10/26/2020 11:39:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-26 11:39:21',`log_type`= 'Agent Loyalty Point Detail',`sql_query`= 'INSERT INTO loyalty_detail SET booking_id= :booking_id,type= :type,log= :log',`log_description`= 'Loyalty earn Points is &nbsp;&nbsp; of agent &nbsp;due to cancellation of booking id \&#039;3048\&#039;',`ip`= '60.254.11.53';
[10/26/2020 11:39:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '3048' AND (current_status = 'cancelled' ) ;
[10/26/2020 11:39:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[10/26/2020 11:39:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note,cancellation_reason) values ('0','0','AED','AED','QTECH2020101854','3048','2020-10-26 11:39:22','Cancellation done on 2020-10-26 11:39:21 ','Confirmed charges. ','');
[10/26/2020 11:39:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],update bookings_details set reservation_pushed = '3', channel_manager = 'rategain',room_type_description='' where booking_id = '3048';
[10/26/2020 11:39:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103048 /  Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 19824 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2020-10-26 11:39:23';
[10/26/2020 11:39:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3048','snehal.valanju@qtechsoftware.com');
[10/26/2020 11:39:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3048','ankita.rao@qtechsoftware.com');
[10/26/2020 11:39:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103048 /  Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27924 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2020-10-26 11:39:24';
[10/26/2020 11:39:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3048','snehal.valanju@qtechsoftware.com');
[10/26/2020 11:39:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3048','snehal.valanju@qtechsoftware.com');
[10/26/2020 11:39:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3048';
[10/26/2020 11:48:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-26 11:48:57',login_attempt=0 where id = '25';
[10/26/2020 11:48:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-10-26 11:48:57', ip = '60.254.11.53', action = 'Login' ;
