[06/05/2023 08:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3195', agent_id ='21', itenirary_id ='3', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='ashwini.shetty@qtechsoftware.com', leader_title ='Ms', leader_first_name ='TestA', leader_last_name ='TestL', city_id ='Dubai', country_id ='138', display_room_rate ='105.000', native_room_rate ='100.000', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2023-06-05 07:46:58', create_date ='2023-06-05 07:46:58', source_type ='localsystem', expiration_date ='2023-06-05 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='THE WESTIN DUBAI MINA SEYAHI BEACH RESORT MARINA', native_rate ='', display_rate ='', agent_rate ='105.000', 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 ='1.00000', applied_markup ='5', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='5', 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 ='10', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-06-05 08:02:59', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2023-06-05 08:02:59', 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 ='106.207.220.49', is_cancel_history ='1';
[06/05/2023 08:02:59], [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
        ('','','3195','cancelled','2023-06-05 08:02:59','Cancellation Confirmation Number: Cancellation done on 2023-06-05 08:02:59  by tfg','tfg','106.207.220.49','tfg','','');
[06/05/2023 08:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2023-06-05 08:02:59' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2023062013' AND id = '3195' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[06/05/2023 08:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3195',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3195';
[06/05/2023 08:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-06-05 08:02:59',`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;3195\&#039;',`ip`= '106.207.220.49';
[06/05/2023 08:02:59], [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 = '3195' AND (current_status = 'cancelled' ) ;
[06/05/2023 08:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[06/05/2023 08:02:59], [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','RDT2023062013','3195','2023-06-05 08:02:59','Cancellation done on 2023-06-05 08:02:59 ','Confirmed charges. ','');
[06/05/2023 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103195 /  Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 19532 characters]',to_email_id= 'sneha.jain@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:00';
[06/05/2023 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3195','sneha.jain@qtechsoftware.com');
[06/05/2023 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3195','ankita.rao@qtechsoftware.com');
[06/05/2023 08:03:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103195 /  Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 25544 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:01';
[06/05/2023 08:03:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3195','snehal.valanju@qtechsoftware.com');
[06/05/2023 08:03:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3195','snehal.valanju@qtechsoftware.com');
[06/05/2023 08:03:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3195','example@test.com');
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3196', agent_id ='21', itenirary_id ='4', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='ashwini.shetty@qtechsoftware.com', leader_title ='Ms', leader_first_name ='TestA', leader_last_name ='TestL', city_id ='Dubai', country_id ='138', display_room_rate ='10708.830', native_room_rate ='1000.000', native_currency_code ='BHD', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2023-06-05 07:46:58', create_date ='2023-06-05 07:46:58', source_type ='localtransfer', expiration_date ='2023-06-04 18:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='transfer', service_type_detail ='Air to Acc', native_rate ='', display_rate ='', agent_rate ='10708.830', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='1000.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='9.7353', applied_markup ='10', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='10', wh_agent_markup ='0.000', basecurrency_multiplier ='0.27222', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='2.65017', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='10', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-06-05 08:03:03', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2023-06-05 08:03: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 ='106.207.220.49', is_cancel_history ='1';
[06/05/2023 08:03:03], [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
        ('','','3196','cancelled','2023-06-05 08:03:03','Cancellation Confirmation Number: RDT2023062013 by tfg','tfg','106.207.220.49','tfg','','');
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2023-06-05 08:03:03' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2023062013' AND id = '3196' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3196',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3196';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-06-05 08:03: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;3196\&#039;',`ip`= '106.207.220.49';
[06/05/2023 08:03:03], [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 = '3196' AND (current_status = 'cancelled' ) ;
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[06/05/2023 08:03:03], [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','BHD','AED','RDT2023062013','3196','2023-06-05 08:03:03','RDT2023062013',' ','');
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG303196/  Booking Cancelled ',from_email_id= '',body= '[encoded data, 37296 characters]',to_email_id= 'sneha.jain@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:03';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG303196/  Booking Cancelled ',from_email_id= '',body= '[encoded data, 36620 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:03';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG303196/  Booking Cancelled ',from_email_id= '',body= '[encoded data, 30108 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:03';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-06-05 08:03:03',`log_type`= 'Tranfer Booking Cancelled',`sql_query`= '',`log_description`= 'Tranfer Booking Get Cancelled Booking_id = TFG303196',`ip`= '106.207.220.49';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3197', agent_id ='21', itenirary_id ='5', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='ashwini.shetty@qtechsoftware.com', leader_title ='Ms', leader_first_name ='TestA', leader_last_name ='TestL', city_id ='Dubai', country_id ='138', display_room_rate ='216.000', native_room_rate ='200.000', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2023-06-05 07:46:58', create_date ='2023-06-05 07:46:58', source_type ='localsightseeing', expiration_date ='2023-06-04 18:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='sightseeing', service_type_detail ='Dubai Theme park', native_rate ='', display_rate ='', agent_rate ='216.000', 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 ='1.00000', applied_markup ='8', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='8', 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 ='10', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-06-05 08:03:03', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2023-06-05 08:03: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 ='106.207.220.49', is_cancel_history ='1';
[06/05/2023 08:03:03], [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
        ('','','3197','cancelled','2023-06-05 08:03:03',' by tfg','tfg','106.207.220.49','tfg','','');
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2023-06-05 08:03:03' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2023062013' AND id = '3197' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3197',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3197';
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-06-05 08:03: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;3197\&#039;',`ip`= '106.207.220.49';
[06/05/2023 08:03:03], [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 = '3197' AND (current_status = 'cancelled' ) ;
[06/05/2023 08:03:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[06/05/2023 08:03:03], [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','','','RDT2023062013','3197','2023-06-05 08:03:03','',' ','');
[06/05/2023 08:03:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG203197/   Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 23948 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,example@test.com',cc= 'nitin@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:04';
[06/05/2023 08:03:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG203197/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 21680 characters]',to_email_id= 'sneha.jain@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:06';
[06/05/2023 08:03:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG203197/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 21680 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:09';
[06/05/2023 08:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3198', agent_id ='21', itenirary_id ='6', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='ashwini.shetty@qtechsoftware.com', leader_title ='Ms', leader_first_name ='TestA', leader_last_name ='TestL', city_id ='Dubai', country_id ='138', display_room_rate ='87.040', native_room_rate ='100.000', native_currency_code ='MYR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2023-06-05 07:46:58', create_date ='2023-06-05 07:46:58', source_type ='misc', expiration_date ='2023-06-05 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='misc', service_type_detail ='Ferry Ticket(MISC)', native_rate ='', display_rate ='', agent_rate ='87.040', 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.87037', 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.23694', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='10', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-06-05 08:03:10', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2023-06-05 08:03:10', 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 ='106.207.220.49', is_cancel_history ='1';
[06/05/2023 08:03:10], [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
        ('','','3198','cancelled','2023-06-05 08:03:10',' by tfg','tfg','106.207.220.49','tfg','','');
[06/05/2023 08:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2023-06-05 08:03:10' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2023062013' AND id = '3198' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[06/05/2023 08:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3198',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3198';
[06/05/2023 08:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-06-05 08:03:10',`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;3198\&#039;',`ip`= '106.207.220.49';
[06/05/2023 08:03:10], [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 = '3198' AND (current_status = 'cancelled' ) ;
[06/05/2023 08:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[06/05/2023 08:03:10], [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','MYR','AED','RDT2023062013','3198','2023-06-05 08:03:10','',' ','');
[06/05/2023 08:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403198 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 20048 characters]',to_email_id= 'sneha.jain@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:11';
[06/05/2023 08:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403198 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 20048 characters]',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:11';
[06/05/2023 08:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO mails_error_log set mailfrom='roma.banwani@qtechsoftware.com',mailsubject=' TFG403198 / Booking Cancelled ',mailbody=' 
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;Booking Email&lt;/TITLE&gt;

&lt;style type=\&quot;text/css\&quot;&gt;
@import url(http://fonts.googleapis.com/css?family=Source+Sans+Pro:400,600,700);
&lt;/style&gt;

&lt;/HEAD&gt;
&lt;BODY&gt;
&lt;!-- Code change by Dilip --&gt;
	&lt;table width=\&quot;700\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; align=\&quot;center\&quot; style=\&quot;margin: 0 auto; border: 1px solid #e8eef1;\&quot;&gt;
		&lt;!-- createing new header page by Dilip 27-02-2014 --&gt;
&lt;tr&gt;
    &lt;td valign=\&quot;top\&quot; style=\&quot;border-bottom:1px solid #dce4e7;  padding:0 0 5px 0; height:90px; line-height:0px; background:#fff;\&quot;&gt;
        &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
         &lt;tr&gt;
            &lt;td colspan=\&quot;2\&quot; style=\&quot; height:21px;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
        
            &lt;td rowspan=\&quot;2\&quot; valign=\&quot;top\&quot; style=\&quot;width:500px; padding:0px 0 0 0;\&quot;&gt;
            	
              &lt;a href=\&quot;#\&quot;&gt;
					       &lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com//project_folder/tfg_project/images/elogo.png\&quot; height=\&quot;70px\&quot;&gt;
						&lt;/a&gt;
            &lt;/td&gt;
            &lt;td valign=\&quot;top\&quot; style=\&quot; width:146px;color:#636464; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:center; padding:0px 0 19px 0;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
            &lt;td valign=\&quot;top\&quot;&gt;
            	
            &lt;/td&gt;
         &lt;/tr&gt;
        &lt;/table&gt;
    &lt;/td&gt;
&lt;/tr&gt; 
&lt;tr style=\&quot;background:#fff;\&quot;&gt;
   &lt;td style=\&quot;border-bottom:1px solid #dce4e7;\&quot;&gt;
    &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
      &lt;tr&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:220px; height:31px;\&quot;&gt;Monday, June  5, 2023&lt;/td&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:180px; height:31px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/emails/phone.png\&quot; align=\&quot;\&quot; width=\&quot;12\&quot; height=\&quot;18\&quot; style=\&quot;margin-right: 5px;\&quot;/&gt;+94 (0)11 789 5820&lt;br/&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:auto; height:31px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/emails/mail.png\&quot; align=\&quot;\&quot; width=\&quot;20\&quot; height=\&quot;14\&quot; style=\&quot;margin-right: 5px;\&quot; /&gt;&lt;a href=\&quot;mailto:reservations@thefabulousgetaway.com\&quot; style=\&quot;color:#686f74; text-decoration:none;\&quot;&gt;reservations@thefabulousgetaway.com&lt;/a&gt;&lt;/td&gt;
      &lt;/tr&gt;
    &lt;/table&gt;    
    &lt;/td&gt;
&lt;/tr&gt;

	&lt;tr&gt;
			&lt;td valign=\&quot;top\&quot;
				style=\&quot;height: 94px; background: #ecf1f2; border-top: 1px solid #dce4e7; border-bottom: 1px solid #d9dfe0;\&quot;&gt;

				&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
					&lt;tr&gt;
						&lt;td valign=\&quot;top\&quot; style=\&quot;height: 9px; line-height: 9px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/Hotelbooking_bg.png\&quot;	width=\&quot;700\&quot; height=\&quot;9\&quot; border=\&quot;0\&quot; /&gt;&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td style=\&quot;line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot;
								cellspacing=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td colspan=\&quot;2\&quot; style=\&quot;height: 16px; line-height: 16px;\&quot;&gt;&nbsp;&lt;/td&gt;
								&lt;/tr&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;color: #4a4a4a; font-family: Arial, Helvetica, sans-serif; font-size: 14px; width: 489px; padding: 0 0 3px 0; line-height: 20px;\&quot;&gt;MISC Booking Details&lt;/td&gt;
									&lt;td rowspan=\&quot;3\&quot; valign=\&quot;top\&quot; style=\&quot;width: 156px; line-height: 0px;\&quot;&gt;
										&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
											&lt;tr&gt;
												&lt;td style=\&quot;color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;\&quot;&gt;&lt;/td&gt;
											&lt;/tr&gt;
											&lt;tr&gt;
												&lt;td	style=\&quot;color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;\&quot;&gt;&lt;/td&gt;
											&lt;/tr&gt;
										&lt;/table&gt;
									&lt;/td&gt;
								&lt;/tr&gt;
								&lt;tr&gt;
									&lt;td
										style=\&quot;height:30px; color: #4a4a4a; font-family: Arial, Helvetica, sans-serif; font-size: 20px; font-weight: bold; line-height: 20px;\&quot;&gt;
										Your Booking status is &lt;span style=\&quot;color: #e08c18; font-size:30px;\&quot; &gt;cancelled&lt;/span&gt;
										
									&lt;/td&gt;
								&lt;/tr&gt;
															&lt;/table&gt;

						&lt;/td&gt;
					&lt;/tr&gt;
				&lt;/table&gt;
			&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;td valign=\&quot;top\&quot;
				style=\&quot;background: #f3f6f7; border-top: 1px solid #fff; line-height: 0px;\&quot;&gt;
				&lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot;
					cellspacing=\&quot;0\&quot;
					style=\&quot;border: 1px solid #e4e8e9; margin: 26px auto 0 auto; background: #fff;\&quot;&gt;
					&lt;tr&gt;
						&lt;td
							style=\&quot;height: 41px; line-height: 41px; padding: 0 0 0 24px; background: #77787a; color: #fff; font-family: Arial, Helvetica, sans-serif; font-size: 16px; font-weight: bold;\&quot;&gt;
							MISC Details&lt;/td&gt;
					&lt;/tr&gt;

					
					
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Booked By :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									Qtech_Ankita 1 &nbsp; 05-Jun-2023&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Booking Ref No. :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									TFG403198&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Destination :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									Dubai&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Service Name :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									Ferry Ticket(MISC)&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									No of Children :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									-&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									No of Adults :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									2&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Country :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									United Arab Emirates&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Book for :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									Ferry Ticket(MISC)&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Service required from :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									17-Nov-2023&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Service required to :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									17-Nov-2023&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
					&lt;tr&gt;
						&lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;
									Special Instruction :&lt;/td&gt;
									&lt;td	style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;
									-&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
					&lt;/tr&gt;
						                		                   	&lt;tr&gt;
	                    &lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;Sub Total Charge :&lt;/td&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;0.000 AED&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
	                    &lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;Payment Gateway Charges :&lt;/td&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt;0.000 AED&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
						&lt;/tr&gt;		
						&lt;tr&gt;
	                    &lt;td	style=\&quot;height: 45px; border-bottom: 1px solid #dfe5e6; line-height: 0px;\&quot;&gt;
							&lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
								&lt;tr&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; font-weight: bold; padding: 0 0 0 24px; width: 180px;\&quot;&gt;Total Charge :&lt;/td&gt;
								&lt;td style=\&quot;height: 45px; color: #4d4d4d; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 0 0 0 24px; width: 491px;\&quot;&gt; 0 AED&lt;/td&gt;
								&lt;/tr&gt;
							&lt;/table&gt;
						&lt;/td&gt;
						&lt;/tr&gt;		
							               		
	                                           
                        
											&lt;/tr&gt;	
					&lt;/table&gt;
					
			  
&lt;tr&gt;
	&lt;td bgcolor=\&quot;#f3f6f7\&quot;&gt;
		&lt;table width=\&quot;95%\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; style=\&quot;margin: 0 auto; background: #f3f6f7; /* border-top: 2px solid #e8eef1; */ padding: 0px\&quot; class=\&quot;table_footer\&quot;&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;height: 19px;\&quot;&gt;&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0px; line-height: 18px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal;\&quot;&gt;Our Support Team is always ready to assist you. Please contact us on &lt;span style=\&quot;color: #435770;\&quot;&gt; &lt;a href=\&quot;mailto:reservations@thefabulousgetaway.com\&quot; style=\&quot;color: #435770; text-decoration: none;\&quot;&gt;reservations@thefabulousgetaway.com&lt;/a&gt;&lt;/span&gt; for any assistance or feedback.
				&lt;/td&gt;
			&lt;/tr&gt;
				&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0px; line-height: 18px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 16px; font-weight: bold; text-align: right;\&quot;&gt;Thanking You&nbsp;&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0 20px 0px; line-height: 15px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal; text-align: right;\&quot;&gt;Registration & Sales Team&nbsp;&lt;br /&gt;The Fabulous Getaway&nbsp;
				&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0 17px 0px;  color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal; text-align: right;\&quot;&gt;&lt;a href=\&quot;https://www.thefabulousgetaway.com\&quot; style=\&quot;color: #435770; text-decoration: none; line-height: 18px; padding-left: 20px;\&quot;&gt;https://www.thefabulousgetaway.com&lt;/a&gt;&nbsp;&lt;/td&gt;
			&lt;/tr&gt;
			
		&lt;/table&gt;
	&lt;/td&gt;
&lt;/tr&gt;

				&lt;/table&gt;
			&lt;/td&gt;
		&lt;/tr&gt;
	&lt;/table&gt;
&lt;/BODY&gt;
&lt;/HTML&gt;
',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2023-06-05 08:03:11';
[06/05/2023 08:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403198 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 19964 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-06-05 08:03:11';
