[05/03/2023 07:30:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG203193/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 19400 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-05-03 07:30:07';
[05/03/2023 07:30:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG203193/   Booking Cancelled ',from_email_id= '',body= '[encoded data, 19120 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-05-03 07:30:10';
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3194', 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-05-03 07:07:01', create_date ='2023-05-03 07:07:01', source_type ='misc', expiration_date ='2023-05-03 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-05-03 07:30:11', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2023-05-03 07:30:11', 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 ='117.247.157.57', is_cancel_history ='1';
[05/03/2023 07:30:11], [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
        ('','','3194','cancelled','2023-05-03 07:30:11',' by tfg','tfg','117.247.157.57','tfg','','');
[05/03/2023 07:30:11], [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-05-03 07:30:11' , pending_cancellation = 'no'WHERE reservation_id = 'RDT2023052012' AND id = '3194' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3194',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3194';
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-05-03 07:30:11',`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;3194\&#039;',`ip`= '117.247.157.57';
[05/03/2023 07:30:11], [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 = '3194' AND (current_status = 'cancelled' ) ;
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[05/03/2023 07:30:11], [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','RDT2023052012','3194','2023-05-03 07:30:11','',' ','');
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403194 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 22316 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-05-03 07:30:11';
[05/03/2023 07:30:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403194 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 21196 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-05-03 07:30:11';
[05/03/2023 07:30: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=' TFG403194 / Booking Cancelled ',mailbody=' &lt;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/hotel.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/sight_seeing.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/transfer.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&gt;

&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;&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;Wednesday, May  3, 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;&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;
										 &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;
							&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;
									 :&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  &nbsp; 03-May-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;
									 :&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;
									TFG403194&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;
									 :&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;
									 :&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;
									 :&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;
									 :&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;
									 :&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;
									 :&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;
									 :&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-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;
									 :&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-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;
									 :&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; :&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; :&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; :&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;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/hotel.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&gt;
 &lt;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/sight_seeing.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&gt;
 &lt;br /&gt;
&lt;b&gt;Warning&lt;/b&gt;:  Smarty error: unable to read resource: \&quot;english/transfer.conf\&quot; in &lt;b&gt;/home/otrams/public_html/otramsphp7/uat/v3otrams/common/classes/smarty/Smarty.class.php&lt;/b&gt; on line &lt;b&gt;1118&lt;/b&gt;&lt;br /&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; &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; 
				&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;&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;&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-05-03 07:30:11';
[05/03/2023 07:30:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG403194 / Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 19556 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2023-05-03 07:30:12';
