[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO history_bookings set history_booking_id ='3111', agent_id ='21', itenirary_id ='4', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Ms', leader_first_name ='Ankita', leader_last_name ='RaoTest', city_id ='Kandy', country_id ='132', display_room_rate ='20200.000', native_room_rate ='231.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2021-04-20 07:00:39', create_date ='2021-04-20 07:00:39', source_type ='localsightseeing', expiration_date ='2021-04-19 18:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='sightseeing', service_type_detail ='Kandy Test Tour', native_rate ='', display_rate ='', agent_rate ='20200.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='231.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='60', applied_markup ='45.743145743145', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='45.743145743145', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2021-04-28 13:02:03', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2021-04-28 13:02:03', 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 ='43.239.53.130', is_cancel_history ='1';
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3111','cancelled','2021-04-28 13:02:03',' by tfg','tfg','43.239.53.130','tfg','','');
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2021-04-28 13:02:03' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2020101825' AND id = '3111' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO loyalty_detail SET booking_id= '3111',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3111';
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-04-28 13:02:03',`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;3111\&#039;',`ip`= '43.239.53.130';
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '3111' AND (current_status = 'cancelled' ) ;
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],delete from cancellations where booking_id =? ;
[04/28/2021 01:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.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','','','RDT2020101825','3111','2021-04-28 13:02:03','',' ','');
[04/28/2021 01:02:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 21588 characters]',to_email_id= 'jignesh@qtechsoftware.com',cc= 'nitin@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:02:04';
[04/28/2021 01:02:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 18436 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:02:05';
[04/28/2021 01:02:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 18436 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:02:08';
[04/28/2021 01:03:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 21588 characters]',to_email_id= 'jignesh@qtechsoftware.com',cc= 'nitin@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:03:34';
[04/28/2021 01:03:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 18436 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:03:36';
[04/28/2021 01:03:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= ' TFG203111/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 18436 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php',create_date= '2021-04-28 13:03:39';
