-- https://www.phpmyadmin.net/
--

START TRANSACTION;




INSERT INTO `core_mail_templates` (`id`, `name`, `code`, `from_email`, `to_email`, `cc`, `bcc`, `subject`, `content`, `created_at`) VALUES
(15, 'Booking Confirmation', 'BOOKING_CONFIRMATION', 'do-not-reply@travelportal.com', NULL, '', '', 'Booking Ref : {{BookingRef}} is Confirmed | {{AgencyName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<title>Booking Confirmation</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=iso-8859-1\">\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=utf-8\" />\n</head>\n\n\n<body style=\"margin:20px 0;padding:0;border:0;background:#f3f3f3;font-weight:normal;text-align:center;font-family:arial,verdana,sans-serif;color:#555555;font-size:15px;box-sizing:border-box;\">\n  <center>\n     <table style=\"margin:0;padding:0;border:1px solid #ccc;width:870px;\" cellspacing=\"0\">\n       <tr style=\"width:100%;background:#fff;\">\n          <td style=\"width:75%;\">\n              <table style=\"margin:0;padding:0;border:0;width:100%;padding:15px;\" cellspacing=\"0\">\n                 <tr>\n                    <th align=\"left\" style=\"color:#555;font-size:18px;padding-bottom:10px;font-weight:normal;line-height: 5px\">Your Reservation is Confirmed</th>\n                 </tr>\n                 <tr style=\"display:inline-block;\">\n                    <td style=\"color:#fff;font-size:15px;\">\n                       <label style=\"margin:0px;width:auto; color: #555\">Booking Ref :</label>\n                       <p  style=\"margin:0px;width:auto;display:inline-block; color: #555\">{{BookingRef}}</p>\n                         \n                    </td>\n                     \n                 </tr>\n                  \n                  <tr>\n                    <td style=\"color:#fff;font-size:15px;\">\n                      <label style=\"margin:0px;width:auto; color: #555\">Itineary ID :</label>\n                       <p  style=\"margin:0px;width:auto;display:inline-block; color: #555\">{{ItinearyId}}</p>\n                         \n                    </td>\n                  </tr>\n                  \n                  \n                  \n                  <tr>\n                    <td><p style=\"color:#555;font-size:13px;margin:10px 0 10px 0;width:auto;\">We have charged your credit card for the full payment of this transaction.</p></td>\n                 </tr>\n              \n              </table>\n           </td>\n           <td style=\"width:25%;\">\n              <table style=\"margin:0;padding:0;border:0;width:100%;\"cellspacing=\"0\">\n                 <tr>\n                    <td align=\"center\">\n                        <a href=\"#\" style=\"float: left;padding-right: 15px;\"><img style=\"height:auto; width:235px;\"  src=\"{{AgencyLogo}}\"/></a>\n                    </td>\n                  </tr>\n              </table>\n           </td>\n      </tr>\n     </table>\n    \n   \n     \n      \n      <table style=\"margin:10px 0 0 0;padding:10px 10px 0px 10px;border:1px solid #ccc; border-bottom: 0px; width:870px;background:#fff;\" cellspacing=\"0\">\n              <tr align=\"left\">\n                  <th style=\"border-bottom:1px solid #ededed;text-transform:uppercase;font-size:18px;font-weight:normal;\">Tour Information</th>\n              </tr>\n            \n\n      <table style=\"padding:10px;border-bottom: 1px solid #ccc;border-left: 1px solid #ccc;border-right: 1px solid #ccc;width:870px;background:#fff;\" cellspacing=\"0\">\n          <tbody>\n              <tr>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px;\"> <label style=\"font-weight: 600\">Tour Name </label></td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;border-top: 1px solid #ccc;padding: 5px;\">\n                      <p style=\"margin: 5px 0px;\">{{TourName}}</p>\n                  </td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px;\"> <label style=\"font-weight: 600\">Booking Date </label></td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;border-top: 1px solid #ccc;padding: 5px;\">\n                      <p style=\"margin: 5px 0px;\">{{BookingDate}}</p>\n                  </td>\n              </tr>\n              <tr>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc;padding: 5px;\"> <label style=\"font-weight: 600\">Tour Code </label></td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\">\n                      <p style=\"margin: 5px 0px;\">{{TourCode}}</p>\n                  </td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\"> <label style=\"font-weight: 600\">Departure Date</label></td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\">\n                      <p style=\"margin: 5px 0px;\">{{TravelDate}}</p>\n                  </td>\n              </tr>\n              <tr>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc;padding: 5px;\"><label style=\"font-weight: 600\">Start Location </label></td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\">\n                      <p style=\"margin: 5px 0px;\">{{StartLocation}}</p>\n                  </td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\"> </td>\n                  <td style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc;padding: 5px;\"> </td>\n              </tr>\n          </tbody>\n      </table>\n                           \n      </table> \n     <table style=\"margin:10px 0 0 0;padding:10px;border:1px solid #ccc;width:870px;background:#fff;\" cellspacing=\"0\">\n              <tr align=\"left\">\n                  <th style=\"border-bottom:1px solid #ededed;text-transform:uppercase;font-size:18px;font-weight:normal;\">PRICE Details</th>\n              </tr>\n            \n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:160px;float:left;\">Grand Total :</label>\n                    <p style=\"width:auto; margin:0px;display:inline-block;font-weight:normal;\"> {{CurrencySymbol}} {{GrandTotal}}\n                    </p>\n                 </td>\n              </tr>\n      </table>   \n      \n      <table style=\"margin:10px 0 0 0;padding:10px 10px 0px 10px;border:1px solid #ccc; border-bottom: 0px; width:870px;background:#fff;\" cellspacing=\"0\">\n              <tr align=\"left\">\n                  <th style=\"border-bottom:1px solid #ededed;text-transform:uppercase;font-size:18px;font-weight:normal;\">Guest Information</th>\n              </tr>\n            \n\n      <table style=\"padding:10px;border-bottom: 1px solid #ccc;border-left: 1px solid #ccc;border-right: 1px solid #ccc;width:870px;background:#fff;\" cellspacing=\"0\">\n         <thead>\n            <th style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px; text-align: left\">Guest Name</th>\n             <th style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px; text-align: left\">Date of birth</th>\n             <th style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px; text-align: left\">Type</th>\n             <th style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px; text-align: left\">Passport Number</th>\n             <th style=\"border-bottom: 1px solid #ccc;border-right: 1px solid #ccc; border-left: 1px solid #ccc; border-top: 1px solid #ccc;padding: 5px; text-align: left\">Nationality</th>\n          </thead>\n          <tbody>\n		{{GuestDetail}}\n          </tbody>\n      </table>\n                           \n      </table> \n      \n      <table style=\"margin:10px 0 0 0;padding:10px;border:1px solid #ccc;width:870px;background:#fff;\" cellspacing=\"0\">\n              <tr align=\"left\">\n                  <th style=\"border-bottom:1px solid #ededed;text-transform:uppercase;font-size:18px;font-weight:normal;\">Supplier Contact Details</th>\n              </tr>\n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:250px;float:left;\">Local Supplier Contact Number :</label>\n                    <p style=\"width:auto; margin:0px;display:inline-block;\">{{LocalContactNumber}}</p>\n                 </td>   \n              </tr>\n              \n      </table> \n      \n      <table style=\"margin:10px 0 0 0;padding:10px;border:1px solid #ccc;width:870px;background:#fff;\" cellspacing=\"0\">\n              <tr align=\"left\">\n                  <th style=\"border-bottom:1px solid #ededed;text-transform:uppercase;font-size:18px;font-weight:normal;\">CONTACT Details</th>\n              </tr>\n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:160px;float:left;\">Name :</label>\n                    <p style=\"width:auto; margin:0px;display:inline-block;\">{{LeadPassengerName}}</p>\n                 </td>   \n              </tr>\n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:160px;float:left;\">Email :</label>\n                    <p style=\"width:auto; margin:0px;display:inline-block;font-weight:normal;\">{{LeadPassengerNameEmail}}</p>\n                 </td>\n              </tr>\n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:160px;float:left;\">Mobile No :</label>\n                    <p style=\"width:auto; margin:0px;display:inline-block;\">{{LeadPassengerPhone}}</p>\n                 </td>   \n              </tr>\n              <tr>\n                 <td style=\"padding-top:7px;\">\n                    <label style=\"font-weight:bold;width:160px;float:left;\">Address :</label>\n                    <p style=\"width:555px; margin:0px;display:inline-block;\">{{LeadPassengerAddress}}</p>\n                 </td>   \n              </tr>\n              <tr>\n                   \n              </tr>\n      </table>    \n  </center>\n</body>\n</html>', '2018-07-25 02:03:14'),
(16, 'Payment Received', 'PAYMENT_RECEIVED', 'do-not-reply@travelportal.com', NULL, '', '', 'Booking Ref : {{BookingRef}} E-Ticket Generated | {{AgencyName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta name=\"viewport\" content=\"width=device-width\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n<title>Payment Received</title>\r\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;width: 100%;padding-top: 40px;\">\r\n	<tr>\r\n		<td></td>\r\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n                   \r\n					<tr>\r\n						<td class=\"content-wrap\" style=\"padding: 25px;\">\r\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \r\n                                <tr>\r\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                       \r\n                                             <img src=\"{{AgencyLogo}}\" width=\"250\">\r\n                                        \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                        Dear {{CustomerName}},\r\n                                    </td>\r\n								</tr>\r\n								<tr>\r\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										<p style=\"font-weight: normal;font-size: 14px; margin: 0;\">Txn: {{TransactionID}} is successfull. Details are as follows:</p>\r\n									</td>\r\n								</tr>\r\n                                <tr>\r\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                        Payment Method: {{PaymentMethod}}<br>\r\n                                        Amount Paid: {{Currency}} {{Amount}}\r\n                                    </td>\r\n                                </tr>\r\n                               \r\n                                <tr>\r\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\r\n                                    	Thanks,<br>\r\n                                        {{AgencyName}} Team!!\r\n                                    </td>\r\n                                </tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n		</td>\r\n		<td></td>\r\n	</tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2018-07-25 02:03:55'),
(18, 'Invoice Generation', 'INVOICE_GENERATION', 'do-not-reply@travelportal.com', NULL, '', '', 'Invoice : {{InvoiceNumber}} | {{AgencyName}}', '\"Invoice Number:{{InvoiceNumber}}\n\nINVOICE\n\n{{NameReference}} {{GivenName}} {{SurName}}\n{{CustomerEmail}}\n\nBooking Ref: {{BookingRef}}\nBooking Date: {{BookingDate}}\n\n{{FromAirport}} {{ToAirport}} \n{{FlightDate}} / {{People}}\n\nDescription\nDeparture\n{{DepartureAirportCode}} {{DepartureTime}}\n{{DepartureDate}} {{DepartureAirportName}}\n\n{{ArrivalAirportCode}} {{ArrivalTime}}\n{{ArrivalDate}}{{ArrivalAirportName}}\n\nReturn\n{{DepartureAirportCode}} {{DepartureTime}}\n{{DepartureDate}} {{DepartureAirportName}}\n\n{{ArrivalAirportCode}} {{ArrivalTime}}\n{{ArrivalDate}}{{ArrivalAirportName}}\n\nAmount\n{{Currency}}{{BookingAmount}}\n\n{{AmountInWords}}\n\nTotal: {{Currency}}{{BookingAmount}}\n\nCustomer Support\nCorporate & Head Office : {{AgencyAddress}}\nEmail:{{AgencyEmail}}\nURL:{{AgencyUrl}}\nNumber: {{AgencySupportNumber}}\n\nNOTE :This is computer Gentrating invoice and doesnot require signature stamp please do not reply this mail it has been sent from email accountant that is not montiroid\n\n\"', '2018-07-25 02:07:08'),
(19, 'Booking Cancellation Request', 'BOOKING_CANCELLATION_REQUEST', 'do-not-reply@travelportal.com', NULL, '', '', 'Cancellation Ref: {{CancellationId}} is Pending |  {{AgencyName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<title>Booking Cancellation Request</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=iso-8859-1\">\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=utf-8\" />\n</head>\n\n\n<body style=\"margin:20px 0;padding:0;border:0;background:#f3f3f3;font-weight:normal;text-align:center;font-family:arial,verdana,sans-serif;color:#555555;font-size:15px;box-sizing:border-box;\">\n  <center>\n    <table style=\"margin:0;padding:0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;\">\n            <label style=\"margin:0px;width:100%;font-weight: bold;float: left;padding-bottom: 10px;\">Cancellation Request Generated Successfully</label>\n            <label style=\"margin:0px;width:auto;padding: 5px 0px;\">Cancellation ID :</label>\n            <p  style=\"margin:0px;width:58%;display:inline-block;padding: 5px 0px;\">{{CancellationId}}</p>\n            <label style=\"margin:0px;width:auto;\">Cancellation Date :</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">{{CancellationDate}}</p>\n          </td>\n          <td style=\"width:40%;\">\n            <img src=\"{{AgencyLogo}}\" width=\"160\" height=\"\" style=\"float: right;\">\n          </td>\n       </tr>\n     </table>\n     <table style=\"margin:20px 0 0 0;padding:0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <label style=\"margin:0px;width:100%;font-weight: 600;float: left;padding-bottom: 10px;\">Dear {{CustomerName}},,</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">Cancellation Request of your Booking Ref {{BookingRef}} has been generated. You will be notified once cancellation request processed.</p>\n          </td>\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <table style=\"margin:20px 0 0 0;padding:0;border:0;width:;border-collapse: collapse;width:100%\" cellspacing=\"0\">\n             <thead>\n               <tr>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation ID</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation Status</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Refund Status</th>\n               </tr>\n             </thead>\n             <tbody>\n               <tr>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{CancellationId}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\"> {{CancelationStatus}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">Pending</td>\n               </tr>\n             </tbody>\n           </table>\n          </td>\n        \n       </tr>\n     </table>\n     <table style=\"margin:0px 0 0 0;padding:0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#fff;padding:15px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float:left; width: 100%; border-bottom:2px solid #ededed;\">\n             <p style=\"margin:0px;width:auto;display:inline-block;font-size:18px;font-weight:normal;color:#666; text-transform: capitalize;\">Customer Support</p>\n              </td>\n             <td style=\"float: left; width: 65%\">\n               <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Corporate & Head Office\n               </p>\n               <label style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; float: left;\";>{{AgencyAddress}}</label>\n             </td>\n\n               <td style=\"float: right; width: 30%; margin-top: 10px\">\n                 <img src=\"assets/img/mail.png\" style=\"float: left; padding-right: 10px; margin-top: 3px \">\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyEmail}}</span>\n               </td>\n               <td style=\"float: right; width: 30%; margin-top: 5px\">\n                 <img src=\"assets/img/web.png\" style=\"float: left; padding-right: 10px\" >\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyUrl}}</span>\n               </td>\n               <td style=\"margin: 10px 0px 0px 0px; float: left;width: 30%\">\n               <img src=\"assets/img/support.png\" style=\"float: left; padding-right: 5px\">\n               <span style=\"float: left; color: #04486b; font-size: 18px; margin: 5px 0px 0px 0px\">{{AgencySupportNumber}}</span>\n\n               <p style=\"float: left; margin: 0; color: #666;\">24*7 Available</p>\n              </td> \n           </td> \n         </tr>\n       </table>\n      <table style=\"margin:20px 0 0 0;padding:0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#555555;padding:10px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float: left;width: 100%\">\n             <label style=\"color: #fff; font-size: 16px; float: left;\">NOTE :</label>\n             <p style=\"color: #fff; font-size: 15px; float: right; width: 90%; margin: 0\">Please do not reply to this mail.It has been sent from an email account that is not monitored.</p>\n           </td>\n         </tr>\n       </table>\n  </center>\n</body>\n</html>\n\n', '2018-07-25 02:07:55'),
(20, 'Booking Cancellation Request Processed', 'BOOKING_CANCELLATION_REQUEST_PROCESSED', 'do-not-reply@travelportal.com', NULL, '', '', 'Cancellation Ref: {{CancellationId}} is Processed |  {{AgencyName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<title>Booking Refund Request Processed</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=iso-8859-1\">\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=utf-8\" />\n</head>\n\n\n<body style=\"margin:20px 0;padding:0;border:0;background:#f3f3f3;font-weight:normal;text-align:center;font-family:arial,verdana,sans-serif;color:#555555;font-size:15px;box-sizing:border-box;\">\n  <center>\n    <table style=\"margin:0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;\">\n            <label style=\"margin:0px;width:100%;font-weight: bold;float: left;padding-bottom: 10px;\">Refund Request Processed Successfully!!</label>\n            <label style=\"margin:0px;width:auto;padding: 5px 0px;\">Cancellation ID :</label>\n            <p  style=\"margin:0px;width:58%;display:inline-block;padding: 5px 0px;\">{{CancellationId}}</p>\n            <label style=\"margin:0px;width:auto;\">Cancellation Date :</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">{{CancellationDate}}</p>\n          </td>\n          <td style=\"width:40%;\">\n            <img src=\"{{AgencyLogo}}\" width=\"160\" height=\"\" style=\"float: right;\">\n          </td>\n       </tr>\n     </table>\n     <table style=\"margin:20px 0 0 0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <label style=\"margin:0px;width:100%;font-weight: 600;float: left;padding-bottom: 10px;\">Dear {{CustomerName}},,</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">Refund of your Booking Ref {{BookingRef}}  is {{RefundStatus}}.</p>\n          </td>\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <table style=\"margin:20px 0 0 0;padding:0;border:0;width:;border-collapse: collapse;width:100%\" cellspacing=\"0\">\n             <thead>\n               <tr>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation ID</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation Status</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Refund Status</th>\n               </tr>\n             </thead>\n             <tbody>\n               <tr>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{CancellationId}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{CancelationStatus}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{RefundStatus}}</td>\n               </tr>\n             </tbody>\n           </table>\n          </td>\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <table style=\"margin:20px 0 0 0;padding:0;border:0;width:;border-collapse: collapse;width:100%\" cellspacing=\"0\">\n             <tbody>\n               <tr>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Cancellation Process Date:</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{CancelationDateTime}} </p>\n                 </td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Refund Process Date:</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{RefundDateTime}}</p>\n                 </td>\n               </tr>\n               <tr>\n                  <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666;\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Reason For Cancellation :</label>\n                  <p style=\"margin:0px;width:auto;display:inline-block;\">{{Reason}}</p>\n                 </td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Refund Amount :</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{RefundAmount}}</p>\n                 </td>\n               </tr>\n             </tbody>\n           </table>\n          </td>\n         \n       </tr>\n     </table>\n     <table style=\"margin:0px 0 0 0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#fff;padding:15px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float:left; width: 100%; border-bottom:2px solid #ededed;\">\n             <p style=\"margin:0px;width:auto;display:inline-block;font-size:18px;font-weight:normal;color:#666; text-transform: capitalize;\">Customer Support</p>\n              </td>\n             <td style=\"float: left; width: 65%\">\n               <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Corporate & Head Office:\n               </p>\n               <label style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; float: left;\";>{{AgencyAddress}}</label>\n             </td>\n\n               <td style=\"float: right; width: 30%; margin-top: 10px\">\n                 <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Email:\n               </p>\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyEmail}}</span>\n               </td>\n               <td style=\"float: right; width: 30%; margin-top: 5px\">\n                  <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Website:\n               </p>\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyUrl}}</span>\n               </td>\n               <td style=\"margin: 10px 0px 0px 0px; float: left;width: 30%\">\n               <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                ContactNumber:\n               </p>\n               <span style=\"float: left; color: #04486b; font-size: 18px; margin: 5px 0px 0px 0px\">{{AgencySupportNumber}}</span>\n\n               <p style=\"float: left; margin: 0; color: #666;\">24*7 Available</p>\n              </td> \n           </td> \n         </tr>\n       </table>\n      <table style=\"margin:20px 0 0 0;padding:0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#555555;padding:10px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float: left;width: 100%\">\n             <label style=\"color: #fff; font-size: 16px; float: left;\">NOTE :</label>\n             <p style=\"color: #fff; font-size: 15px; float: right; width: 90%; margin: 0\">Please do not reply to this mail.It has been sent from an email account that is not monitored.</p>\n           </td>\n         </tr>\n       </table>\n  </center>\n</body>\n</html>\n\n\n', '2018-07-25 02:08:41'),
(21, 'Booking Refund Request Processed', 'BOOKING_REFUND_REQUEST_PROCESSED', 'do-not-reply@travelportal.com', NULL, '', '', 'Cancellation Ref: {{CancellationId}} is Refunded | {{AgencyName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<title>Booking Refund Request Processed</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=iso-8859-1\">\n<meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=utf-8\" />\n</head>\n\n\n<body style=\"margin:20px 0;padding:0;border:0;background:#f3f3f3;font-weight:normal;text-align:center;font-family:arial,verdana,sans-serif;color:#555555;font-size:15px;box-sizing:border-box;\">\n  <center>\n    <table style=\"margin:0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;\">\n            <label style=\"margin:0px;width:100%;font-weight: bold;float: left;padding-bottom: 10px;\">Refund Request Processed Successfully!!</label>\n            <label style=\"margin:0px;width:auto;padding: 5px 0px;\">Cancellation ID :</label>\n            <p  style=\"margin:0px;width:58%;display:inline-block;padding: 5px 0px;\">{{CancellationId}}</p>\n            <label style=\"margin:0px;width:auto;\">Cancellation Date :</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">{{CancellationDate}}</p>\n          </td>\n          <td style=\"width:40%;\">\n            <img src=\"{{AgencyLogo}}\" width=\"160\" height=\"\" style=\"float: right;\">\n          </td>\n       </tr>\n     </table>\n     <table style=\"margin:20px 0 0 0;border:0;width:870px;background: #fff;padding: 15px\" cellspacing=\"0\">\n       <tr style=\"width:100%;\">\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <label style=\"margin:0px;width:100%;font-weight: 600;float: left;padding-bottom: 10px;\">Dear {{CustomerName}},,</label>\n            <p  style=\"margin:0px;width:auto;display:inline-block;\">Refund of your Booking Ref {{BookingRef}} has been Processed successfully. Total Refund Amount:\n              {{RefundAmount}} (Refund Charges have been waived off for you).</p>\n          </td>\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <table style=\"margin:20px 0 0 0;padding:0;border:0;width:;border-collapse: collapse;width:100%\" cellspacing=\"0\">\n             <thead>\n               <tr>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation ID</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Cancellation Status</th>\n                 <th style=\"font-size: 14px;padding-right: 15px !important;font-weight: 600;vertical-align: middle;font-weight: 600;padding: 10px 8px;color: #666;text-align: left;border: 1px solid #666\">Refund Status</th>\n               </tr>\n             </thead>\n             <tbody>\n               <tr>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{CancellationId}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{CancelationStatus}}</td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 20px 0px 20px 10px;background: #fff;border: 1px solid #666\">{{RefundStatus}}</td>\n               </tr>\n             </tbody>\n           </table>\n          </td>\n          <td style=\"color:#666;font-size:16px;width: 100%;float: left;\">\n            <table style=\"margin:20px 0 0 0;padding:0;border:0;width:;border-collapse: collapse;width:100%\" cellspacing=\"0\">\n             <tbody>\n              <tr>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Cancellation Process Date:</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{CancelationDateTime}} </p>\n                 </td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Refund Process Date:</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{RefundDateTime}}</p>\n                 </td>\n               </tr>\n               <tr>\n                  <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666;\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Reason For Cancellation :</label>\n                  <p style=\"margin:0px;width:auto;display:inline-block;\">{{Reason}}</p>\n                 </td>\n                 <td style=\"border-bottom: 1px solid rgba(230, 230, 230, 0.7);padding: 10px 0px 10px 10px;background: #fff;border: 1px solid #666\">\n                   <label style=\"margin:0px;width:auto;padding-bottom: 10px;\">Refund Amount :</label>\n                  <p  style=\"margin:0px;width:auto;display:inline-block;\">{{RefundAmount}}</p>\n                 </td>\n               </tr>\n             </tbody>\n           </table>\n          </td>\n         \n       </tr>\n     </table>\n     <table style=\"margin:0px 0 0 0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#fff;padding:15px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float:left; width: 100%; border-bottom:2px solid #ededed;\">\n             <p style=\"margin:0px;width:auto;display:inline-block;font-size:18px;font-weight:normal;color:#666; text-transform: capitalize;\">Customer Support</p>\n              </td>\n             <td style=\"float: left; width: 65%\">\n               <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Corporate & Head Office:\n               </p>\n               <label style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; float: left;\";>{{AgencyAddress}}</label>\n             </td>\n\n               <td style=\"float: right; width: 30%; margin-top: 10px\">\n                 <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Email:\n               </p>\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyEmail}}</span>\n               </td>\n               <td style=\"float: right; width: 30%; margin-top: 5px\">\n                  <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                Website:\n               </p>\n                 <span style=\"color: #666; font-size: 16px\">{{AgencyUrl}}</span>\n               </td>\n               <td style=\"margin: 10px 0px 0px 0px; float: left;width: 30%\">\n               <p style=\"color: #666; font-size: 16px; margin: 10px 0px 0px 0px; text-transform: capitalize;\">\n                ContactNumber:\n               </p>\n               <span style=\"float: left; color: #04486b; font-size: 18px; margin: 5px 0px 0px 0px\">{{AgencySupportNumber}}</span>\n\n               <p style=\"float: left; margin: 0; color: #666;\">24*7 Available</p>\n              </td> \n           </td> \n         </tr>\n       </table>\n      <table style=\"margin:20px 0 0 0;padding:0;border:0;width:870px;\" cellspacing=\"0\">\n         <tr style=\"background:#555555;padding:10px;box-sizing:border-box;float:left; width:100%;\">\n           <td style=\"float: left;width: 100%\">\n             <label style=\"color: #fff; font-size: 16px; float: left;\">NOTE :</label>\n             <p style=\"color: #fff; font-size: 15px; float: right; width: 90%; margin: 0\">Please do not reply to this mail.It has been sent from an email account that is not monitored.</p>\n           </td>\n         </tr>\n       </table>\n  </center>\n</body>\n</html>\n\n\n', '2018-07-25 02:09:31'),
(22, 'Quotation Generation', 'QUOTATION_GENERATION', 'do-not-reply@travelportal.com', NULL, '', '', 'Quotation: {{QuotationId}} | {{AgencyName}}', '\"Dear {{CustomerName}}\r\n\r\nYour Quotation is Generated,\r\nQuotation ID: {{QuotationId}}\r\nQuotation Date: {{QuotationDate}}\r\n\r\nQuotation Details\r\nCustomer Name: {{CustomerName}}\r\nBilling Address : {{CustomerAddress}}\r\nInquiry Id: {{InquiryId}}\r\nInquiry Date:{{InquiryDate}}\r\nFrom City: {{FromAirport}}\r\nTo City:  {{ToAirport}} \r\nDepart Date:{{DepartDate}}\r\nArrival Date:{{ArrivalDate}}\r\nNo.of Adults:{{AdultCount}}\r\nNo.of Childs:{{ChildCount}}\r\nNo.of Infants:{{InfantsCount}}\r\nTotal No. of Pax:{{TotalPassangerCount}}\r\nContact Person Name:{{ContactPersonName}}\r\nContact Person Number:{{ContactPersonNumber}}\r\n\r\nPrimary Quotation\r\nPrice:{{Currency}} {{QuotationPrice}}\r\nDiscount:{{Currency}} {{DiscountPrice}}\r\nService Fee:{{Currency}} {{ServiceFeePrice}}\r\nTax:{{Currency}} {TaxPrice}}\r\nGrand Total:{{Currency}} {{TotalPrice}}\r\n\r\nInclusion\r\n{{Inclusion}}\r\n\r\nCancellation Policy\r\n{{CancellationPolicy}}\r\n\r\nTerms & Conditions\r\n{{TermsAndConditions}}\"', '2018-07-25 18:17:15'),
(23, 'Deposit Request Generation', 'DEPOSIT_REQUEST_GENERATION', 'do-not-reply@travelportal.com', NULL, '', '', 'New Deposit Request From {{AgencyName}}', '\"New Deposite Request has generated, following are details,\r\n\r\nDeposite Request Information\r\nAgency Name : {{AgencyName}}\r\nAgency Code : {{AgencyCode}}\r\nDeposite Amount Request : {{DepositeAmount}}\r\nDate and Time of Deposite : {{Date}} {{Time}}\r\nType of Deposite : {{TypeOfDeposite}}\r\nBeneficiary Bank : {{BamificiaryBank}}\r\nCheque/DD No. : {{ChequeNumber}}\r\nRemark : {{Remark}}\"', '2018-07-25 18:27:56'),
(24, 'Inquiry Generation', 'INQUIRY_GENERATION', 'do-not-reply@travelportal.com', NULL, '', '', 'Inquiry: {{InquiryId}} has been Generated | {{AgencyName}}', '\"New Inquiry has Generated, following are details,\r\n\r\nInquiry Information\r\nInquiry Id: {{InquiryId}}\r\nFlight Type : {{FlightType}}\r\nFrom City: {{DepartureAirportCode}}\r\nTo City : {{ArrivalAirportCode}}\r\nClass: {{Class}}\r\nDepart Date: {{DepartDate}}\r\nReturn Date: {{ReturnDate}}\r\nPassenger Info: {{PsnrInfo}}\r\nDetails:{{Text}}\r\nPreferred Communication : {{PrfrdCom}}\r\n\r\nCustomer Information\r\nCustomer Name: {{CustomerName}}\r\nEmail : {{CustomerEmail}}\r\nMobile Number : {{CustomerMobile}}\r\nAddress : {{CustomerAddress}}\"', '2018-07-25 18:40:36'),
(25, 'Agency Deposit Account Credited', 'AGENCY_DEPOSIT_ACCOUNT_CREDITED', 'do-not-reply@travelportal.com', NULL, '', '', 'Txn:  {{TransacrionId}} | Account Credited | {{AgencyName}}', '\"Account Credited Successfully, following are details,\r\n\r\nDeposite Request Information\r\nAgency Name : {{AgencyName}}\r\nAgency Code : {{AgencyCode}}\r\nTransaction Id : {{TransactionId}}\r\nCredited  Amount  : {{CreditedAmount}}\r\nDate and Time : {{DateTime}}\r\n\"', '2018-07-25 18:44:01'),
(26, 'Top up Done Successfully', 'TOP_UP_DONE_SUCCESSFULLY', 'do-not-reply@travelportal.com', NULL, '', '', 'Txn:  {{TransacrionId}} | Top up Done Successfully | {{AgencyName}}', '\"Account Top Up Done Successfully, following are details,\r\n\r\nTop Up Information\r\nTransaction Id : {{TransactionId}}\r\nTop Up  Amount  :{{TopUpAmount}}\r\nDate and Time : {{DateTime}}\r\n\"', '2018-07-25 18:46:22'),
(27, 'Supplier Booking Confirmation', 'SUPPLIER_BOOKING_CONFIRMATION', 'do-not-reply@travelportal.com', NULL, '', '', 'Booking Ref : {{BookingRef}} is Confirmed | {{SupplierName}}', '\"Your Reservation is Confirmed Booking Ref : {{BookingRef}} \n\nSupplier Confirmation No: {{SupplierConfirmation}}\n\n{{TourName}} {{TourType}} \n{{Status}}\nTravel Date : {{TravelDate}} \nBooking Date : {{BookingDate}} \nTour Code :  {{TourCode}} \n\nPassenger Information: {{NumberOfPeople}} / {{PassengerType}}\nPassanger Information Sr No. : {{SrNo}} Passenger Name : {{NameReference}} {{GivenName}} {{SurName}} Type : {{PsgrType}} \n\nTravel Information\nNet price: {{NetPrice}} \nArrival Time: {{ArrivalTime}}\nDeparture Date: {{DepartureDate}} \nPassport Number: {{PassportNumber}}\nPassport Expiry Date: {{PassportExpiryDate}}\nPick up Location: {{PickUpLocation}} \nDeparture Flight No: {{DepartureFlightNumber}} \nDeparture Airline: {{DepartureAirline}}\nPassport Nationality: {{PassportNationality}} \nDate of Birth: {{DateOfBirth}} \nArrival Airline: {{ArrivalAirline}}\nDrop Off Location: {{DropOffLocation}}\nArrival Flight No: {{ArrivalFlightNumber}} \nDeparture Time: {{DepartureTime}} \nSpecial requirements: {{SpecialRequirements}}\n\nPRICE Details Grand Total : {{CurrencySymbol}} {{NetPrice}} \n\nCONTACT Details Name : {{LeadPassengerName}} Email : {{LeadPassengerNameEmail}} Phone Number : {{LeadPassengerPhone}} Address : {{LeadPassengerAddress}} \n\"', '2018-07-25 18:46:22'),
(28, 'Supplier Product Published', 'SUPPLIER_PRODUCT_PUBLISHED', 'do-not-reply@travelportal.com', NULL, '', '', 'Product Name : {{ProductName}} is Published Successfully ', 'Your {{ProductName}} with {{TourCode}} has been published successfully. Once any booking will be done on this product you will receive a mail.', '2018-07-25 18:46:22'),
(29, 'Booking Cancellation Request to Supplier', 'SUPPLIER_CANCELLATION_REQUEST_TO_SUPPLIER', 'do-not-reply@travelportal.com', NULL, '', '', 'Cancellation Ref: {{CancellationId}} is Pending |  {{BookingRef}}', '\"Cancellation Request Generated Successfully!!\n\nCancellation ID :{{CancellationId}}\nCancellation Date :{{CancellationDate}}\n\n\nDear {{CustomerName}},\n\nCancellation Request of your Tour Booking Ref {{BookingRef}} with Supplier Confirmation Number {{SupplierConfirmation}} has been generated. You will be notified once cancellation request processed.\n\nCancellation ID        : {{CancellationId}}\nCancellation Status  : {{CancelationStatus}}\n\nPassenger Name : {{PassengerName}}\n\nCustomer Support\nCorporate & Head Office : {{AgencyAddress}}\nEmail:{{AgencyEmail}}\nURL:{{AgencyUrl}}\nNumber: {{AgencySupportNumber}}\n\nNOTE :Please do not reply to this mail.It has been sent from an email account that is not monitored.\"', '2018-07-25 18:46:22'),
(30, 'Booking Cancellation Request Processed', 'SUPPLIER_CANCELLATION_REQUEST_PROCESSED', 'do-not-reply@travelportal.com', NULL, '', '', 'Cancellation Ref: {{CancellationId}} is Processed |  {{BookingRef}} ', '<p>\"Cancellation Request Processed Successfully!! Cancellation ID :{{CancellationId}} Cancellation Date :{{CancellationDate}} Dear {{CustomerName}}, Cancellation of your Tour Booking Ref {{Booking Ref}} with Supplier Confirmation Number {{SupplierConfirmation}} has been Processed successfully. Total Cancellation Charge: {{Currency}} {{CancellationAmount}} (Cancellation Charges have been waived off for you). Cancellation ID : {{CancellationId}} Cancellation Status : {{CancelationStatus}} Refund Amount : {{Refund Amount}} Refund Status : {{RefundStatus}} Cancellation Process Date Time :{{CancelationDateTime}} Refund Process Date Time :Pending Cancellation Charges :{{CancelationCharge}} Refund Amount :Pending Reason For Cancellation :{{Reason}} Passenger Name : {{PassangerName}} Customer Support Corporate &amp; Head Office : {{AgencyAddress}} Email:{{AgencyEmail}} URL:{{AgencyUrl}} Number: {{AgencySupportNumber}} NOTE :Please do not reply to this mail.It has been sent from an email account that is not monitored.\"&nbsp;</p>', '2018-07-25 18:46:22');
INSERT INTO `core_mail_templates` (`id`, `name`, `code`, `from_email`, `to_email`, `cc`, `bcc`, `subject`, `content`, `created_at`) VALUES
(31, 'Customer Review', 'CUSTOMER_REVIEW', 'do-not-reply@travelportal.com', NULL, '', '', 'Hi {{CustomerName}}!! Review {{TourName}} and share your experience with us', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n\n<head>\n    <title>Mail</title>\n    <meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=iso-8859-1\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; cha₹et=utf-8\" />\n</head>\n\n\n<body style=\"margin:20px 0;padding:0;border:0;background:#f3f3f3;font-weight:normal;text-align:center;font-family:arial,verdana,sans-serif;color:#555555;font-size:15px;box-sizing:border-box;\">\n    <center>\n       \n        <table style=\"margin:0;padding:0;border:1px solid #ccc;width:870px;\" cellspacing=\"0\">\n            <tr style=\"width:100%;background:#fff;\">\n                <td style=\"padding-left: 10px; padding-top: 15px; padding-bottom: 15px;text-align: center;\">\n                    <img src=\"{{GeneralLogo}}\" width=\"250\" height=\"\">\n                </td>\n            </tr>\n            <tr>\n                <td style=\"background-color: #000; text-align: center; padding: 13px 0px;\">\n                    <h4 style=\"color: #fffc00; margin: 0;font-size: 17px;\">Thank you!</h4>\n                    <p style=\"color: #fff; margin: 0;padding-top: 10px;\">A big thanks for giving us an opportunity to serve you. <br> You are our valued customer and your option matters a lot to us.</p>\n                </td>\n            </tr>\n            <tr style=\"background: #fff;\">\n                <td style=\"padding: 10px 0px 10px 10px;\">\n                    <p style=\"margin: 0px; padding-top: 10px\">Hey {{CustomerName}},</p>\n                    <p style=\"margin: 0px; color: #0073AA; font-size: 18px; padding: 10px 0px\">How Was your Tour {{TourName}}?</p>\n                    <p style=\"margin: 0px; \">Go ahead, Write a review on your tour experience for the travel community 20 Milion users would read your review</p>\n                </td>\n            </tr>\n           <tr style=\"background: #fff;\">\n                <td style=\"float: left; width: 100%; text-align: center;border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;padding: 10px 0px;\">\n                    <h5 style=\"margin: 0;font-size: 18px;font-weight: normal;padding: 10px 0px;padding-top: 0;\">Rate your Tour</h5>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"border: 2px solid #cf2a28; float: none; display: inline-block; width:20px; height:20px; padding: 5px;text-decoration: none;margin: 0px 5px;border-radius: 5px; color: #cf2a28\">1</a>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"border: 2px solid #e27474; float: none; display: inline-block; width:20px; height:20px; padding: 5px;text-decoration: none;margin: 0px 5px;border-radius: 5px; color: #e27474\">2</a>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"border: 2px solid #ff9f15; float: none; display: inline-block; width:20px; height:20px; padding: 5px;text-decoration: none;margin: 0px 5px;border-radius: 5px; color: #ff9f15\">3</a>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"border: 2px solid #6ca951; float: none; display: inline-block; width:20px; height:20px; padding: 5px;text-decoration: none;margin: 0px 5px;border-radius: 5px; color: #6ca951\">4</a>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"border: 2px solid #23aa31; float: none; display: inline-block; width:20px; height:20px; padding: 5px;text-decoration: none;margin: 0px 5px;border-radius: 5px; color: #23aa31\">5</a>\n                    <a href=\"{{B2CUrl}}/product/customer-review/{{ProductCode}}/{{BookingRef}}\" style=\"color: #0078ff; float: none; display: inline-block; width: 100%; font-size: 12px; padding-top: 10px\">Click here to submit you Review. It will take only a minute</a>\n                </td>\n            </tr>\n            <tr style=\"background: #fff;\">\n                <td style=\"float: left; width: 100%; text-align: center\">\n                    <h5 style=\"margin: 0;font-size: 18px;font-weight: normal;padding: 10px 0px 20px 0px;\">Why Should you write a review?</h5>\n                    <div style=\"float: none;display: inline-block;margin: 0px 20px;\">\n                        <img src=\"{{B2CUrl}}/assets/img/bag.jpg\" width=\"80\">\n                        <p style=\"line-height: 23px;\">Help 20 million travellers plan <br> better holidays. </p>\n                    </div>\n                    <div style=\"float: none;display: inline-block;margin: 0px 20px;\">\n                        <img src=\"{{B2CUrl}}/assets/img/tag.png\" width=\"80\">\n                        <p style=\"line-height: 23px;\">Help 20 million travellers plan <br> better holidays. </p>\n                    </div>\n                    <div style=\"float: none;display: inline-block;margin: 0px 20px;\">\n                        <img src=\"{{B2CUrl}}/assets/img/user.png\" width=\"80\">\n                        <p style=\"line-height: 23px;\">Help 20 million travellers plan <br> better holidays. </p>\n                    </div>\n                </td>\n            </tr>\n            <tr style=\"background: #fff;\">\n                <td style=\"float: left; width: 100%; text-align: center\">\n                    <p style=\"margin-bottom: 5px;font-size: 13px;\">\n                        &#9400;2019 {{AgencyName}} All Right Reserved \n                    </p>\n                </td>\n            </tr>\n        </table>\n\n\n    </center>\n</body>\n\n</html>', '2019-02-19 04:28:47'),
(32, 'Travel Requied Information Mail', 'REQUIRED_INFO_MAIL', 'do-not-reply@travelportal.com', NULL, '', '', 'Additional required information for upcoming booking', '<!DOCTYPE html\r\n    PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n\r\n<head>\r\n    <meta name=\"viewport\" content=\"width=device-width\" />\r\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n    <title>User Sign up</title>\r\n    <link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\"\r\n    style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n    <table class=\"body-wrap\" style=\"background-color: #f6f6f6;width: 100%;padding-top: 40px;\">\r\n        <tr>\r\n            <td></td>\r\n            <td class=\"container\" width=\"600\"\r\n                style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n                <div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n                    <table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"\r\n                        style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n\r\n                        <tr>\r\n                            <td class=\"content-wrap\" style=\"padding: 25px;\">\r\n                                <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                           \r\n                                                <img src=\"{{AgencyLogo}}\" width=\"250\">\r\n                                            \r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                            Dear {{CustomerName}},\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                            Please update your addtional information for the upcomming booking, your\r\n                                            booking reference no {{BookingRef}} with the\r\n                                            booking date {{BookingDate}} and travel date {{TravelDate}}.\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                            Update your Travel Information or Click the link to add the details.\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                            {{Click Here}}\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td style=\"vertical-align: top; padding:5px 0px 0px 0px\">\r\n                                            It\'s our pleasure to help you see the world your way!!<br>\r\n                                            Sincerely, <br>\r\n                                            {{AgencyName}} Team!!\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n            <td></td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n\r\n</html>', '2019-08-30 09:59:04'),
(33, 'Welcome Agency', 'WELCOME_AGENCY', 'do-not-reply@travelportal.com', NULL, '', '', 'Welcome to {{AgencyName}}!!', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<meta name=\"viewport\" content=\"width=device-width\" />\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n<title>User Sign up</title>\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\n</head>\n\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\n\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;width: 100%;padding-top: 40px;\">\n	<tr>\n		<td></td>\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\n                   \n					<tr>\n						<td class=\"content-wrap\" style=\"padding: 25px;\">\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \n                                 <tr>\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\n                                       \n                                             <img src=\"{{AgencyLogo}}\" width=\"250\">\n                                        \n                                    </td>\n                                </tr>\n                                <tr>\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\n										Dear {{UserName}},  \n									</td>\n								</tr>\n								<tr>\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\n										<p style=\"font-weight: normal;font-size: 14px; margin: 0;\">Welcome to the world of {{AgencyName}}.</p>\n									</td>\n								</tr>\n                                <tr>\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\n                                        We are excited that you have registered with {{AgencyName}} and look forward to meeting all your travel needs!\n                                    </td>\n                                </tr>\n                                <tr>\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\n										Please note that the email address we have on file for you is {{UserName}}.		\n                                    </td>\n                                </tr>\n                                <tr>\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\n										It\'s our pleasure to help you see the world your way!!<br>\n										Sincerely, <br>\n                                        {{AgencyName}} Team!!\n                                    </td>\n                                </tr>\n							</table>\n						</td>\n					</tr>\n				</table>\n			</div>\n		</td>\n		<td></td>\n	</tr>\n</table>\n\n</body>\n</html>\n', '2018-07-25 01:56:32'),
(34, 'B2b Product PDF', 'B2B_PRODUCT_PDF', 'do-not-reply@travelportal.com', NULL, '', '', 'Quotation Of Products ', 'this is the Quotation Of Products ', '2018-07-25 01:56:32'),
(35, 'b2b Quotation mail', 'B2B_QUOTATION_MAIL', 'do-not-reply@travelportal.com', NULL, 'vivek@amarinfotech.com', '', 'Itinerary Quotation from {{AgencyName}}!!', '<p>User Sign up       <img src=\"{{AgencyLogo}}\" width=\"250\">   Here\'s That tour you liked     {{AgencyName}} sent yourself a reminder to check out this tour. And it makes us happy that you\'re thinking about your next travel experience! You can get one step closer to booking by reviewing the tour\'s highlights and checking the availability to find travel dates that fit your schedule.   It\'s our pleasure to help you see the world your way!!</p><p> Sincerely, </p><p> {{AgencyName}} Team!!     </p><p>  </p>', '2018-07-25 01:56:32');
COMMIT;

