INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(42, 1, 'Forget Email Mobile', 'forget_email_mobile', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"520\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Forget Email / Mobile</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to </strong><strong><strong><%= com_name %>,</strong> </strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td>\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">Your Email:-</span></td>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 13px; font-weight:bold; color: #0a0a0a; text-align:left; line-height: 24px;\"><%= user_email %></span></td>\n                                                                        </tr>\n                                                                        \n                                                                        <tr>\n                                                                            <td>\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">Your Mobile:-</span></td>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 13px; font-weight:bold; color: #0a0a0a; text-align:left; line-height: 24px;\"><%= user_mobile %></span></td>\n                                                                        </tr>\n                                                                        \n                                                                        <!-- end of content --><!-- Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\n                                                                                You can log on our live chat for More Assistance .</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<?php echo $comp_info[\'global_email\']; ?>;\" style=\"color:#6f021a;\"><!--?php echo $comp_info[\'global_email\']; ?--></a> or Call <!--?php echo $comp_info[\'phone\']; ?-->, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td align=\"right\" height=\"12\" style=\"font-size:11\n                                                px; line-height:23px; mso-line-height-rule:exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <tr>\n                                            <td height=\"2\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2020-05-20 10:37:48', '2020-06-11 01:08:35', 1, 1, '', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(43, 1, 'Forget User Id', 'forget_userid', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"520\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Forget User Id</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to </strong><strong><strong><%= com_name %>,</strong> </strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td>\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">Your User Id:-</span></td>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                <span class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 13px; font-weight:bold; color: #0a0a0a; text-align:left; line-height: 24px;\"><%= user_name %></span></td>\n                                                                        </tr>\n                                                                        \n                                                                       \n                                                                        <!-- end of content --><!-- Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\n                                                                                You can log on our live chat for More Assistance .</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<?php echo $comp_info[\'global_email\']; ?>;\" style=\"color:#6f021a;\"><!--?php echo $comp_info[\'global_email\']; ?--></a> or Call <!--?php echo $comp_info[\'phone\']; ?-->, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td align=\"right\" height=\"12\" style=\"font-size:11\n                                                px; line-height:23px; mso-line-height-rule:exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <tr>\n                                            <td height=\"2\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2020-05-20 10:37:48', '2020-06-11 01:09:37', 1, 1, '', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(44, 1, 'Birthday Reminder', 'birthday_wishes', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Birthday Wishes</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to </strong><strong><%= com_name %>, </strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family:Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Dear <!--?php echo $user_info[\'user_name\']; ?--></td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                <span class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">Wish You A Very Happy Birthday.</span></td>\n                                                                        </tr>\n                                                                        <!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td>\n                                                                                <!-- start of social icons -->\n                                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"100%\">\n                                                                                    <tbody>\n                                                                                        <tr>\n                                                                                            <td width=\"50%\">\n                                                                                                &nbsp;</td>\n                                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\" width=\"50%\">\n                                                                                                &nbsp;</td>\n                                                                                        </tr>\n                                                                                    </tbody>\n                                                                                </table>\n                                                                                <!-- end of social icons --><!-- logo --><!-- end of logo --></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"3\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<%= global_email %>\" style=\"color:#6f021a;\"><%= global_email %></a> or Call <%= com_phone %>, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>                                        \n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2017-10-12 11:45:13', '2020-06-11 09:07:24', 1, 1, '127.0.0.1', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(45, 1, 'License Expiry', 'license_expiry', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>License / Permit Expiry Message</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to <strong><strong><%= com_name %>,</strong></strong></strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family:Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Thanks for Registration and Showing interest in <%= com_name %> , India`s First online Transport Portal for All Travel Needs</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Your License is Going to Expired.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Details:</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <table border=\"1\" cellpadding=\"3\" cellspacing=\"4\" class=\"table\" style=\"border:1px solid #DDD;\" width=\"100%\">\n                                                                                    <tbody>\n                                                                                        <tr>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                License No.</td>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                <%= license_no %></td>\n                                                                                        </tr>\n                                                                                       <tr>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                Expiry Date.</td>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                <%= license_expiry_date %></td>\n                                                                                        </tr>\n                                                                                        <tr>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                Permit Expiry Date.</td>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                <%= permit_expiry_date %></td>\n                                                                                        </tr>\n                                                                                    </tbody>\n                                                                                </table>\n                                                                            </td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Hope to server you soon.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #000000; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                For More details Please Download our Mobile App</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color:#000000; text-align:left; line-height: 24px;\">\n                                                                                Please click on the link (<a href=\" <%= driver_app_url %>\" style=\"color:#6f021a;\" target=\"_blank\">Link of android app</a>) to download and Start using our App or also log in to our Transport Portal <a href=\" <%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"> </a><a href=\"<%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"><%= site_name %></a></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\n                                                                                You can log on our live chat for More Assistance .</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<%= global_email %>\" style=\"color:#6f021a;\"><%= global_email %></a> or Call <%= com_phone %>, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td align=\"right\" height=\"12\" style=\"font-size:11\n                                                px; line-height:23px; mso-line-height-rule:exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                     \n                                        <tr>\n                                            <td height=\"12\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2019-05-13 12:36:28', '2020-06-12 02:04:14', 1, 1, '127.0.0.1', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(46, 1, 'Minimum Wallet Amount 500', 'wallet_amount_500', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Booking enquiry message</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to <strong><strong><%= com_name %>,</strong></strong></strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family:Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Thanks for Registration and Showing interest in <%= com_name %> , India`s First online Transport Portal for All Travel Needs</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Your Wallet Amount to too Low to Receive the Booking Notification and other Services</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Please Recharge Your Wallet to enjoy our services.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Details:</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <table border=\"1\" cellpadding=\"3\" cellspacing=\"4\" class=\"table\" style=\"border:1px solid #DDD;\" width=\"100%\">\n                                                                                    <tbody>\n                                                                                        <tr>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                Wallet Amount.</td>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                <%= wallet_amount %></td>\n                                                                                        </tr>\n                                                                                       \n                                                                                    </tbody>\n                                                                                </table>\n                                                                            </td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Hope to server you soon.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #000000; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                For More details Please Download our Mobile App</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color:#000000; text-align:left; line-height: 24px;\">\n                                                                                Please click on the link (<a href=\" <%= driver_app_url %>\" style=\"color:#6f021a;\" target=\"_blank\">Link of android app</a>) to download and Start using our App or also log in to our Transport Portal <a href=\" <%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"> </a><a href=\"<%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"><%= site_name %></a></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\n                                                                                You can log on our live chat for More Assistance .</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<%= global_email %>\" style=\"color:#6f021a;\"><%= global_email %></a> or Call <%= com_phone %>, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td align=\"right\" height=\"12\" style=\"font-size:11\n                                                px; line-height:23px; mso-line-height-rule:exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                     \n                                        <tr>\n                                            <td height=\"12\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2019-05-13 12:36:28', '2020-06-11 09:03:49', 1, 1, '127.0.0.1', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(47, 1, 'Minimum Wallet Amount 1000', 'wallet_amount_1000', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <!-- start of social icons -->\n                                                <table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td width=\"20\">\n                                                                &nbsp;</td>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Dear <%= username %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of social icons --><!-- logo -->\n                                                <table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                Date: <%= date %></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                                <!-- end of logo --></td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image --><!-- leftimage -->\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\n    <tbody>\n        <tr>\n            <td>\n                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                    <tbody>\n                        <tr>\n                            <td width=\"100%\">\n                                <table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                    <tbody>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td>\n                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"100%\">\n                                                    <tbody>\n                                                        <tr>\n                                                            <td>\n                                                                <!-- spacing for mobile devices-->\n                                                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\n                                                                    <tbody>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Booking enquiry message</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Welcome to <strong><strong><%= com_name %>,</strong></strong></strong></td>\n                                                                        </tr>\n                                                                        <!-- end of title --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- /Spacing --><!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family:Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Thanks for Registration and Showing interest in <%= com_name %> , India`s First online Transport Portal for All Travel Needs</td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <!-- content -->\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Your Wallet Amount to too Low to Receive the Booking Notification and other Services</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Please Recharge Your Wallet to enjoy our services.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Details:</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                <table border=\"1\" cellpadding=\"3\" cellspacing=\"4\" class=\"table\" style=\"border:1px solid #DDD;\" width=\"100%\">\n                                                                                    <tbody>\n                                                                                        <tr>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                Wallet Amount.</td>\n                                                                                            <td bgcolor=\"#fbfbfb\" style=\"padding-left: 3%; color: #000; font-size: 11px;\">\n                                                                                                <%= wallet_amount %></td>\n                                                                                        </tr>\n                                                                                       \n                                                                                    </tbody>\n                                                                                </table>\n                                                                            </td>\n                                                                        </tr>\n                                                                        <!-- end of content --><!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\n                                                                                <strong>Hope to server you soon.</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #000000; font-weight:bold; text-align:left; line-height: 24px;\">\n                                                                                For More details Please Download our Mobile App</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color:#000000; text-align:left; line-height: 24px;\">\n                                                                                Please click on the link (<a href=\" <%= driver_app_url %>\" style=\"color:#6f021a;\" target=\"_blank\">Link of android app</a>) to download and Start using our App or also log in to our Transport Portal <a href=\" <%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"> </a><a href=\"<%= site_url %>\" style=\"color:#6f021a;\" target=\"_blank\"><%= site_name %></a></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\n                                                                                You can log on our live chat for More Assistance .</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                For any Assistance or query write to</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                write to <a href=\"mailto:<%= global_email %>\" style=\"color:#6f021a;\"><%= global_email %></a> or Call <%= com_phone %>, We will be Glad to Assist You</td>\n                                                                        </tr>\n                                                                        <!-- Spacing -->\n                                                                        <tr>\n                                                                            <td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\n                                                                                &nbsp;</td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\n                                                                                <strong>For <%= com_name %> Team</strong></td>\n                                                                        </tr>\n                                                                        <tr>\n                                                                            <td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\n                                                                                Ph <%= com_phone %> ,<%= com_mobile %></td>\n                                                                        </tr>\n                                                                    </tbody>\n                                                                </table>\n                                                                <!-- end of for mobile devices--></td>\n                                                        </tr>\n                                                    </tbody>\n                                                </table>\n                                            </td>\n                                        </tr>\n                                        <!-- Spacing -->\n                                        <tr>\n                                            <td align=\"right\" height=\"12\" style=\"font-size:11\n                                                px; line-height:23px; mso-line-height-rule:exactly;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                     \n                                        <tr>\n                                            <td height=\"12\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\n                                                &nbsp;</td>\n                                        </tr>\n                                        <!-- Spacing --><!-- Spacing --><!-- Spacing -->\n                                    </tbody>\n                                </table>\n                            </td>\n                        </tr>\n                    </tbody>\n                </table>\n            </td>\n        </tr>\n    </tbody>\n</table>\n<!-- end of left image -->', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2019-05-13 12:36:28', '2020-06-11 09:03:44', 1, 1, '127.0.0.1', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(48, 1, 'Booking Auto Release', 'booking_auto_release', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<p>\r\n	<!-- leftimage --></p>\r\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"560\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"210\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\r\n																Dear &lt;%= username %&gt;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"194\">\r\n													<tbody>\r\n														<tr>\r\n															<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\r\n																Date: &lt;%= date %&gt;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<!-- end of left image --><!-- leftimage -->\r\n<table bgcolor=\"#f3f3f3 \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"left-image\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"20\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"520\">\r\n													<tbody>\r\n														<tr>\r\n															<td>\r\n																<!-- spacing for mobile devices-->\r\n																<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" width=\"100%\">\r\n																	<tbody>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				<span style=\"color:#c52d2f;\"><strong>Subject:- </strong></span>Booking Cancellation message</td>\r\n																		</tr>\r\n																		<!-- Spacing -->\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<!-- /Spacing -->\r\n																		<tr>\r\n																			<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 15px; color: #0a0a0a; text-align:left; line-height: 24px;\">\r\n																				<strong>Welcome to </strong><strong>&lt;%= com_name %&gt;,</strong></td>\r\n																		</tr>\r\n																		<!-- end of title --><!-- Spacing -->\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<!-- /Spacing --><!-- content -->\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family:Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				Thanks for Showing interest in &lt;%= com_name %&gt;, India`s First online Transport Portal for All Travel Needs.</td>\r\n																		</tr>\r\n																		<!-- end of content --><!-- Spacing -->\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<!-- content -->\r\n																		<tr>\r\n																			<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\r\n																				<strong>Your booking has been Cancelled</strong></td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<!-- end of content --><!-- Spacing -->\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td>\r\n																				<!-- start of social icons -->\r\n																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidthmob\" vaalign=\"middle\" width=\"100%\">\r\n																					<tbody>\r\n																						<tr>\r\n																							<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\" width=\"41%\">\r\n																								Booking Ref</td>\r\n																							<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; font-weight:bold; text-align:left; line-height: 24px;\" width=\"49%\">\r\n																								&lt;%= booking_ref_no %&gt;,</td>\r\n																						</tr>\r\n																					</tbody>\r\n																				</table>\r\n																				<!-- end of social icons --><!-- logo --><!-- end of logo --></td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-top-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #0a0a0a; text-align:left; line-height: 24px;\">\r\n																				<strong>Hope to server you soon.</strong></td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:13px; color: #000000; font-weight:bold; text-align:left; line-height: 24px;\">\r\n																				For More details Please Download our Mobile App</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color:#000000; text-align:left; line-height: 24px;\">\r\n																				Please click on the link (<a href=\"&lt;%= driver_app_link%&gt;\" style=\"color:#6f021a;\" target=\"_blank\">Link of android app</a>) to download and Start using our App or also log in to our Transport Portal <a href=\"https://www.bookingcabs.com\" target=\"_blank\">&lt;%= site_name%&gt;</a></td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size:12px; color: #000000; font-weight:normal; text-align:left; line-height: 24px;\">\r\n																				You can log on our live chat for More Assistance .</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				For any Assistance or query write to</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				<a href=\"mailto:&lt;%= global_email %&gt;\" style=\"color:#c52d2f;\">&lt;%= global_email %&gt;</a> or Call &lt;%= com_phone %&gt;, We will be Glad to Assist You</td>\r\n																		</tr>\r\n																		<!-- Spacing -->\r\n																		<tr>\r\n																			<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">\r\n																				&nbsp;</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #c52d2f; text-align:left; line-height: 24px;\">\r\n																				For &lt;%= com_name %&gt; Team</td>\r\n																		</tr>\r\n																		<tr>\r\n																			<td class=\"padding-right15\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 12px; color: #000000; text-align:left; line-height: 24px;\">\r\n																				Ph &lt;%= com_phone %&gt; ,&lt;%= com_mobile %&gt;</td>\r\n																		</tr>\r\n																	</tbody>\r\n																</table>\r\n																<!-- end of for mobile devices--></td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"12\" style=\"font-size:11\r\n                                px; line-height:23px; mso-line-height-rule:exactly;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<tr>\r\n											<td height=\"12\" style=\"font-size:11px;  mso-line-height-rule:exactly; background:url(http://&lt;?php echo $_SERVER[\'SERVER_NAME\']; ?&gt;/images/refer&amp;earnBG.jpg) no-repeat; width:100%; height:191px; color:#000;\">\r\n												<table height=\"198\" style=\"color:#000; font-size:12px;\" width=\"100%\">\r\n													<tbody>\r\n														<tr>\r\n															<td height=\"98\" width=\"48%\">\r\n																&nbsp;</td>\r\n															<td width=\"35%\">\r\n																&nbsp;</td>\r\n															<td width=\"17%\">\r\n																&nbsp;</td>\r\n														</tr>\r\n														<tr>\r\n															<td height=\"28\">\r\n																&nbsp;</td>\r\n															<td style=\"color:#fff; font-size:18px; font-weight:bold;\">\r\n																500</td>\r\n															<td>\r\n																&nbsp;</td>\r\n														</tr>\r\n														<tr>\r\n															<td align=\"center\" colspan=\"3\" height=\"62\">\r\n																<div style=\"border:1px dotted #333; width:50%; margin-top:10px; height:auto; font-size:13px;\">\r\n																	Up to 500 HelloMoney on Sign up<br />\r\n																	&amp; Inviting Friends to Join<br />\r\n																	&lt;%= com_name %&gt;</div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n											</td>\r\n										</tr>\r\n										<tr>\r\n											<td height=\"12\" style=\"font-size: 11px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif; text-align: right;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing --><!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<!-- end of left image -->\r\n<p>\r\n	&nbsp;</p>\r\n', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n					<tbody>\r\n						<tr>\r\n							<td width=\"100%\">\r\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\r\n									<tbody>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\r\n											</td>\r\n										</tr>\r\n										<!-- Spacing --><!-- Spacing -->\r\n										<tr>\r\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\r\n												&nbsp;</td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td>\r\n												<!-- start of social icons -->\r\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\r\n													<tbody>\r\n														<tr>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"24\" width=\"24\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"right\" height=\"25\" width=\"25\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\r\n															</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of social icons --><!-- logo -->\r\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\r\n													<tbody>\r\n														<tr>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"87\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\r\n															</td>\r\n															<td width=\"10\">\r\n																&nbsp;</td>\r\n															<td align=\"left\" height=\"27\" width=\"154\">\r\n																<div class=\"imgpop\">\r\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\r\n															</td>\r\n															<td width=\"20\">\r\n																&nbsp;</td>\r\n														</tr>\r\n													</tbody>\r\n												</table>\r\n												<!-- end of logo --></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\r\n										</tr>\r\n										<tr>\r\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\r\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\r\n										</tr>\r\n										<!-- Spacing -->\r\n									</tbody>\r\n								</table>\r\n							</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', '2017-05-15 12:52:48', '2020-06-05 10:11:52', 1, 1, '127.0.0.1', 1),
(49, 1, 'Booking Hold', 'booking_hold', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"banner\" width=\"100%\"> 	<tbody> 		<tr> 			<td> 				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 					<tbody> 						<tr> 							<td width=\"100%\"> 								<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\"> 									<tbody> 										<tr> 											<td align=\"right\" bgcolor=\"#c52d2f\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"33%\"> 																&nbsp;</td> 															<td width=\"10%\"> 																<img src=\"<%= site_url %>/images/home1.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Home</a></td> 															<td width=\"11%\"> 																<img src=\"<%= site_url %>/images/services-icon.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Services</a></td> 															<td width=\"14%\"> 																<img src=\"<%= site_url %>/images/contant.jpg\" /> <a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Contact Us</a></td> 															<td width=\"32%\"> 																<img src=\"<%= site_url %>/images/fare-col.jpg\" /> <a href=\"<%= site_url %>/signup\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:11px; text-decoration:none;\" target=\"_blank\">Affiliate / Suppliers Registration</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"center\" bgcolor=\"#FFFFFF\" height=\"74\" st-image=\"banner-image\"> 												<table border=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td height=\"70\" width=\"44%\"> 																<img src=\"<%= site_url %>/images/logo-emailer-bookingcabs.png\" style=\"width: 150px;\" /></td> 															<td width=\"36%\"> 																<a href=\"#\"><img src=\"<%= site_url %>/images/download-mobileApp.jpg\" /></a></td> 															<td width=\"20%\"> 																<a href=\"<%= site_url %>/signup\" target=\"_blank\"><img src=\"<%= site_url %>/images/signUp.jpg\" /></a> &nbsp;<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/login.jpg\" /></a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 										<tr> 											<td align=\"right\" bgcolor=\"#3e3c3c\" height=\"29\" st-image=\"banner-image\"> 												<table border=\"0\" cellspacing=\"0\" width=\"100%\"> 													<tbody> 														<tr> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" target=\"_blank\"><img src=\"<%= site_url %>/images/hom-icon.jpg\" /></a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Local Hire</a></td> 															<td width=\"14%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Point to Point</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Airport Transfer</a></td> 															<td width=\"11%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Outstation</a></td> 															<td width=\"15%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Guide Booking</a></td> 															<td width=\"13%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Refer &amp; Earn</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Offer</a></td> 															<td width=\"7%\"> 																<a href=\"<%= site_url %>\" style=\"color:#fff; font-family:Arial, Helvetica, sans-seri; font-size:10px; text-decoration:none;\" target=\"_blank\">Blog</a></td> 														</tr> 													</tbody> 												</table> 											</td> 										</tr> 											<tr>                                             <td style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\" height=\"15\">&nbsp;</td>                                         </tr>								</tbody> 								</table> 								<!-- end of image --></td> 						</tr> 					</tbody> 				</table> 			</td> 		</tr> 	</tbody> </table>', '<p><!-- leftimage --></p>\n<table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"font-size:9px\">\n    <tr>\n        <td colspan=\"0\">\n            <table border=\"1px\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px\">\n                    <tr>\n\n                        <td align=\"left\" class=\"paddint5r0l5b5\" colspan=\"2\">\n                            <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-size:10px\">\n                                 <tr>\n                            		<td width=\'25%\'>\n                            		    <img src=\"<%= company_logo %>\" height=\"75px\" width=\"75px\" />\n                            		</td>	\n                            			<td width=\'45%\' style=\'text-align:center\'>\n                            			    <h5><strong>last voucher date :</strong> <%= booking_release_date %></h5>\n                            		   </td>\n                                    <td style=\'width=\"30%\";text-align:right\'>\n                                     <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-size:9px;\">\n                                            <tr>\n                                                <td><strong>Booking No :</strong></td>\n                                                <td><%= booking_ref_no %></td>\n                                            </tr>\n                                             <tr>\n                                                <td><strong>Booking Date :</strong></td>\n                                                <td><%= booking_date %></td>\n                                            </tr>\n                                             <tr>\n                                                <td><strong>Booking Time :</strong></td>\n                                                <td><%= booking_time %></td>\n                                            </tr>\n                                             <tr>\n                                                <td><strong>GST No. :</strong></td>\n                                                <td><%= company_gst_no %></td>\n                                            </tr>\n                                        </table>                                        	\n                                    </td>\n                            		\n                        		</tr>\n                           </table>\n                        \n                         </td>\n                    </tr>\n				<br/>\n\n				<tr>\n					<td>\n							<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"  width=\"100%\" style=\"font-size:9px\">\n								<thead>\n										<tr>\n										<th width=\"5%\" style=\"text-align:left\">S.no</th>\n										<th nowrap width=\"10%\" style=\"text-align:left\">Date</th>\n										<th width=\"45%\" style=\"text-align:left\">Particular</th>\n										<th width=\"15%\" style=\"text-align:left\">Details</th>\n										<th width=\"5%\" style=\"text-align:left\">Adt.</th>\n										<th width=\"5%\" style=\"text-align:left\">Chd.</th>\n										<th width=\"5%\" style=\"text-align:left\">Inf.</th>\n										<th width=\"5%\" style=\"text-align:left\">Lug.</th>\n\n									</tr>\n								</thead>\n\n								<tbody>\n									<tr>\n										<td>01</td>\n										<td><%= pickup_date %></td>\n										<td><%= pickup_address %></td>\n										<td><%= vehicle_type %></td>\n										<td center><%= adults %></td>\n										<td center><%= childs %></td>\n										<td center><%= childs %></td>\n										<td center><%= luggage %></td>\n									</tr>\n								</tbody>\n\n							</table>\n					\n					</td>\n				</tr>\n								<tr>\n									<td>\n										<table  width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-size:9px\">\n\n											<tr>\n												<td width=\"15%\"><strong>Pickup address :</strong></td>\n											     <td width=\"35%\"><%= pickup_address %></td>\n											     <td width=\"15%\"><strong>Drop address :</strong></td>\n    											     <td width=\"35%\"><%= drop_address %></td>\n											  </tr> \n											  \n											 <tr> \n    											<td><strong>Pickup Date :</strong></td>\n    											 <td><%= pickup_date %></td>\n											 </tr>\n											 <tr>\n											     <td><strong>Pickup Time :</strong></td>\n    											  <td><%= pickup_time %></td>\n    											  <td><strong>Expected Time :</strong></td>\n											     <td><%= distance %></td>\n											     \n											 </tr>\n											 <tr>\n											    <td><strong>Package :</strong></td>\n											     <td><%= local_pkg_name %></td>\n											     <td><strong>Expected Distance :</strong></td>\n											     <td><%= distance %></td>\n											 </tr>\n											 <tr>\n											     <td><strong>No of days : </strong></td>\n											     <td></td>\n											     <td><strong>Extra Km :</strong></td>\n											     <td><%= per_km_price %></td>\n											 </tr>\n										</table>\n									</td>\n								</tr>\n                                                          \n                            </table>\n                        </td>\n                </tr>\n\n\n            </td>\n        </tr>\n      </table>\n \n    \n   <table  border=\"1px\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px;margin-top: 4px\">\n    <tr>\n        <td> \n        <span style=\'font-size:9px\'><strong>Traveller Details</strong></span>\n      <table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px\">\n          <tr>\n              <td><strong>First Name :</strong></td>\n              <td><%= first_name %></td>\n              <td><strong>Last Name :</strong></td>\n              <td><%= last_name %></td>\n          </tr>\n          <tr>\n              <td><strong>Mobile :</strong></td>\n              <td><%= mobile_no %></td>\n              <td><strong>Alt Mobile :</strong></td>\n               <td><%= alt_mobile_no %></td>\n          </tr>\n          <tr>\n              <td><strong>Email :</strong></td>\n               <td><%= email %></td>\n              <td><strong>Nationality :</strong></td>\n               <td><%= nationality %></td>\n          </tr>\n          <tr>\n              <td><strong>Agent Reference :</strong></td>\n               <td><%= agent_reference %></td>\n              <td><strong>Gst No :</strong></td>\n               <td><%= gst_no %></td>\n          </tr>\n      </table>\n      </td>\n      </table>      \n\n      \n    <table  border=\"1px\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px;margin-top: 4px\">\n        <tr>\n           <td> \n<span style=\'font-size:9px\'><strong>Fare Rule</strong></span>\n           \n            <table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px\">\n                  <tr>\n                      <td>\n                        <ul style=\"list-style:circle; margin-left:10px;margin-top:1px\">\n                        <li>Approx Distance  <strong><%= local_pkg_name %></strong> ( As Per Quote)</li>\n                        <li>Minimum Charged Distance <strong><%= base_fare %></strong> ( As per Min Distance )</li>\n                        <li>Per Km Rates  <strong><%= per_km_price %></strong> ( As Per Per Km Rates )</li>\n                        <% if (per_hr_charge) { %>\n                        <li>Per Hour Rates <strong><%= per_hr_charge %></strong> ( As Per Per Hrs Rates )</li>\n                        <% } %>\n                        <li>Driver Allowance <strong><%= night_charge %></strong> ( Per Day)</li>\n                        </ul>\n\n                         <strong>Extra Charges  :- </strong>\n                    Distance :- If you use Vehicle more than the Estimated Km (<strong><%= local_pkg_name %></strong>)  (<i class=\"fa fa-inr\"></i> <%= per_km_price %>) Per Extra Km\n      Rates <% if(per_hr_charge) { %> & RS <%= per_hr_charge %> Per Extra Hrs <% } %> will be Charged.<br/>\n                    Time :- If you drop the Vehicle after 2000 Hrs extra Driver Allowance will be Applicable<br/>   \n<strong>Note :- </strong>\n                    <ul style=\"list-style:circle; margin-left:10px;margin-top:1px\">\n                        <li>One Day Means One Calendar day from Midnight ( <%= night_rate_begins %> Midnight to <%= night_rate_ends %> Mid Night).</li>\n                        <li>Kilometers ( Km) and Hours will be Calculated from Garage to Garage or Specified</li>\n                        <li>Air Con will be switch off in Hill Areas</li>\n                        <li>If Driver Drive Vehicle between <%= night_rate_begins %> to <%= night_rate_ends %> , Driver Allowance / Night Charges <strong><%= night_charge %></strong> will be Applicable</li>\n                    </ul>\n                    <strong>Inclusions & Exclusions</strong><br/>\n                    <strong>Inclusions</strong>\n                    <ul style=\"list-style:circle; margin-left:10px;margin-top:1px\">\n                        <li>Distance <strong>Package <%= local_pkg_name %></strong> Km for the exact Itinerary listed above </li>\n                        <li>No Route Deviation allowed Unless Listed in Itinerary </li>\n                        <li>GST</li>\n                        <li>If Driver Drive Vehicle between <%= night_rate_begins %> to <%= night_rate_ends %> , Driver Allowance / Night Charges <strong><%= night_charge %></strong> will be Applicable</li>\n                    </ul>\n                    <strong>Exclusion</strong>\n                    <ul style=\"list-style:circle; margin-left:10px;margin-top:1px\">\n                        <li>Toll Taxes and Parking ( As Per Actual)</li>                        \n                        <li>Night Pickup Allowance excluded</li>\n                        <li>Night Drop off Allowance excluded</li>\n                        <li>Peak Charges & Waiting Charges as per Tariff</li>\n                        <li>Driver Allowance (Night Charges) Applicable is the Vehicle</li>\n                    </ul>\n           \n                      </td>\n                  </tr>\n                  \n            </table>\n      </td>\n      </tr>\n    </table>\n\n    <table  border=\"1x\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px;margin-top: 4px\">\n        <tr>\n           <td> \n            <span style=\'font-size:9px\'><strong>Cancellation Rule</strong></span>\n            <table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px;margin-top: 4px\">\n                \n<% if (cancellation_rule.length) { %>\n    <% cancellation_rule.forEach((rule) => { %>        \n            <tr>\n               <td><%= rule.name %></td>\n               <td><i class=\"<%= rule.currency_icon %>\"><%= rule.cancellation_charge %></td>\n            </tr>\n      <% }) %>\n  <% } %>\n               \n                    \n           </table>\n    </table>\n\n    \n    <% if(remark){ %>\n     <table  border=\"1px\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px\">\n        <tr>\n           <td> \n            <span style=\'font-size:9px\'><strong>Remark</strong></span>\n            <table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"font-size:9px\">\n               <tr><td><%= remark %></td></tr>\n           </table>\n    </table>\n    <% } %>\n\n\n</table>\n      \n          \n<!-- end of left image -->\n<p>&nbsp;</p>', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\" st-sortable=\"footer\" width=\"100%\">\n	<tbody>\n		<tr>\n			<td>\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\n					<tbody>\n						<tr>\n							<td width=\"100%\">\n								<table align=\"center\" bgcolor=\"#ffffff\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"devicewidth\" width=\"600\">\n									<tbody>\n										<!-- Spacing -->\n										<tr>\n											<td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\n												<hr style=\"height:1px; color:#BBB; background-color:#BBB;\" />\n											</td>\n										</tr>\n										<!-- Spacing --><!-- Spacing -->\n										<tr>\n											<td height=\"15\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly; color:#BBB;\">\n												&nbsp;</td>\n										</tr>\n										<!-- Spacing -->\n										<tr>\n											<td>\n												<!-- start of social icons -->\n												<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"40\" vaalign=\"middle\" width=\"175\">\n													<tbody>\n														<tr>\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"20\">\n																&nbsp;</td>\n															<td align=\"left\" height=\"24\" width=\"24\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= facebook_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"24\" src=\"<%= site_url %>/images/fb-icon.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"24\" /> </a></div>\n															</td>\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\n																&nbsp;</td>\n															<td align=\"right\" height=\"25\" width=\"25\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= twitter_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/twitter.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\n															</td>\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\n																&nbsp;</td>\n															<td align=\"right\" height=\"25\" width=\"25\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= instagram_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/instagram.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\n															</td>\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\n																&nbsp;</td>\n															<td align=\"right\" height=\"25\" width=\"25\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= linkedin_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/linkedin.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\n															</td>\n															<td align=\"left\" style=\"font-size:1px; line-height:1px;\" width=\"10\">\n																&nbsp;</td>\n															<td align=\"right\" height=\"25\" width=\"25\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= youtube_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"25\" src=\"<%= site_url %>/images/youtube.png\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"25\" /> </a></div>\n															</td>\n														</tr>\n													</tbody>\n												</table>\n												<!-- end of social icons --><!-- logo -->\n												<table align=\"right\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"291\">\n													<tbody>\n														<tr>\n															<td width=\"20\">\n																&nbsp;</td>\n															<td align=\"left\" height=\"27\" width=\"87\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= site_url %>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/booknow-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"87\" /> </a></div>\n															</td>\n															<td width=\"10\">\n																&nbsp;</td>\n															<td align=\"left\" height=\"27\" width=\"154\">\n																<div class=\"imgpop\">\n																	<a href=\"<%= client_app_url%>\" target=\"_blank\"> <img alt=\"\" border=\"0\" height=\"27\" src=\"<%= site_url %>/images/download-mobile-app-bt.jpg\" style=\"display:block; border:none; outline:none; text-decoration:none;\" width=\"154\" /> </a></div>\n															</td>\n															<td width=\"20\">\n																&nbsp;</td>\n														</tr>\n													</tbody>\n												</table>\n												<!-- end of logo --></td>\n										</tr>\n										<!-- Spacing -->\n										<tr>\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\n												Designed by <a href=\"<%= developed_by%>\" style=\"color:#900;\" target=\"_blank\">TracoWeb</a></td>\n										</tr>\n										<tr>\n											<td align=\"right\" height=\"10\" style=\"font-size: 11px; line-height: 18px; mso-line-height-rule: exactly; font-family: Arial, Helvetica, sans-serif;\">\n												You are receiving this email because you subscribed to our newsletter <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Subscribe</a> | <a href=\"#\" style=\"color:#900;\" target=\"_blank\">Unsubscribe</a></td>\n										</tr>\n										<!-- Spacing -->\n									</tbody>\n								</table>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n', '2017-05-15 12:52:48', '2020-09-14 07:02:35', 1, 1, '127.0.0.1', 1);
INSERT INTO `email_templates` (`id`, `company_id`, `name`, `type`, `img`, `header_text`, `description`, `footer_text`, `created_date`, `modified_date`, `created_by`, `modified_by`, `ip`, `is_active`) VALUES
(50, 1, 'Invoice', 'invoice', '', '', '<table  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"border-collapse: collapse;font-size:9px\">\r\n                <tr>\r\n                    <td colspan=\"0\">\r\n                        <table border=\"1\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n                            <tr>\r\n\r\n                                <td align=\"left\" class=\"paddinT5R0L5B5\" colspan=\"2\">\r\n                                    <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-size:9px\">\r\n\r\n<tr>\r\n                            		<td width=\'35%\'>\r\n                            		    <img src=\"<%= company_logo %>\" height=\"25px\" width=\"120px\" />\r\n                            		</td>	\r\n                            			<td width=\'25%\' style=\'text-align:center\'>\r\n                            			    \r\n                            		   </td>\r\n                                    	<td style=\'width=\"30%\";text-align:right\'>\r\n                                    	 <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-size:9px;\">\r\n                                            <tr>\r\n                                                <td><strong>Booking No :</strong></td>\r\n                                                <td><%= booking_ref_no %></td>\r\n                                            </tr>\r\n                                             <tr>\r\n                                                <td><strong>Booking Date :</strong></td>\r\n                                                <td><%= booking_date %> <%= booking_time %></td>\r\n                                            </tr>\r\n                                             \r\n                                        </table>                                        	\r\n                                          </td>\r\n                            		\r\n                        		</tr>\r\n\r\n                                        \r\n                                    </table>\r\n\r\n                                </td>\r\n\r\n                            </tr>\r\n                            <tr>\r\n                                <td colspan=\"2\">\r\n                                    <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n\r\n                                        <tr>\r\n                                            <td>\r\n\r\n						<table  width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;font-size:9px\">\r\n\r\n							<tr>\r\n							     <td width=\"15%\"><strong><%= com_name %> :</strong></td>\r\n							     <td width=\"35%\"><strong><%= comp_address %></strong></td>\r\n							     <td width=\"15%\"><strong><%= first_name %><%= last_name %></strong></td>\r\n							     <td width=\"35%\"></td>\r\n							  </tr> \r\n							  \r\n							 <tr> \r\n							 <td><strong>Phone :</strong></td>\r\n							 <td><%= com_phone %></td>\r\n							<td><strong>Mobile :</strong></td>						 \r\n							<td><%= mobile_no %></td>\r\n							 </tr>\r\n\r\n 							 <tr> \r\n							 <td><strong>Mobile :</strong></td>\r\n							 <td><%= com_mobile %></td>\r\n							 </tr>\r\n\r\n\r\n							 <tr>\r\n							     <td><strong>Email :</strong></td>\r\n							     <td><%= global_email %></td>\r\n							    <td><strong>Email :</strong></td>\r\n							     <td><%= email %></td>\r\n							     \r\n							 </tr>\r\n							 <tr>\r\n							    <td><strong>Pan :</strong></td>\r\n							     <td><%= com_pan %></td>							     \r\n							 </tr>\r\n							 <tr>\r\n							     <td><strong>GST : </strong></td>\r\n							      <td><%= com_gst_no %></td>\r\n							 </tr>\r\n							  <tr> <td colspan=\"2\">&nbsp;</td></tr>      \r\n						</table>\r\n\r\n\r\n                                            </td>\r\n\r\n\r\n                                        </tr>\r\n                                    </table>\r\n                                </td>\r\n                            </tr>\r\n\r\n                          \r\n                            <tr>\r\n                                <td colspan=\"2\">                                   \r\n                                        <table  width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;font-size:9px\">\r\n                                            <thead>\r\n                                                <tr>\r\n                                                    <th width=\"5%\" style=\"text-align:left\">S.No</th>\r\n                                                    <th width=\"10%\" style=\"text-align:left\">Date</th>\r\n                                                    <th width=\"10%\" style=\"text-align:left\">Ref.No.</th>\r\n                                                    <th width=\"15%\" style=\"text-align:left\">Client Name</th>                                                    \r\n                                                    <th width=\"20%\" style=\"text-align:center\">Particulars</th>\r\n                                                    <th width=\"10%\" style=\"text-align:left\">Vehicle</th>                                                  \r\n                                                   \r\n                                                    <th width=\"5%\" style=\"text-align:left\">Unit</th>\r\n                                                    <th width=\"5%\" style=\"text-align:left\">Rate</th>\r\n                                                    <th width=\"15%\" style=\"text-align:left\">Amount</th>\r\n                                                </tr>\r\n                                            </thead>\r\n\r\n\r\n                                            <tbody> \r\n						                        <tr>\r\n                                                    <td>01</td>\r\n                                                    <td><%= pickup_date %></td>\r\n                                                     <td><%= booking_ref_no %></td>\r\n                                                    <td><%= first_name %> <%= last_name %></td>	\r\n                                                    <td><%= pickup_address %></td>\r\n                                                    <td><%= vehicle_type %></td>\r\n                                                    <td><%= distance %></td>\r\n                                                    <td><i class=\"fa fa-inr\"></i><%= per_km_price %></td>\r\n                                                    <td align=\"center\">&#x20B9; <%= base_fare %></td>\r\n                                                </tr>\r\n                                                </tr>\r\n                                                <tr> <td colspan=\"10\">&nbsp;</td></tr>\r\n                                                 <tr> <td colspan=\"10\">&nbsp;</td></tr>\r\n                                                  <tr> <td colspan=\"10\">&nbsp;</td></tr>      \r\n                                                  <tr> <td colspan=\"10\">&nbsp;</td></tr>\r\n                                                  <tr> <td colspan=\"10\">&nbsp;</td></tr>  \r\n\r\n                                            </tbody>\r\n\r\n                                        </table>\r\n                                   \r\n                                </td>\r\n                            </tr>\r\n\r\n                            <tr>\r\n                                <td>\r\n\r\n                                    <table width=\"100%\"  cellpadding=\"0\" cellspacing=\"1\"  style=\"font-size:9px\">\r\n                                        <tr>\r\n                                          <td>\r\n                                            <table width=\"40%\"  cellpadding=\"0\" cellspacing=\"1\" border=\"1px\"  style=\"border-collapse: collapse;font-size:9px\" align=\"right\">\r\n                                                <tr align=\"right\">\r\n                                                <td width=\"25%\">Bill Amount</td>\r\n                                                <td width=\"15%\"><%= base_fare %></td>\r\n                                            </tr>\r\n                                            <tr align=\"right\">\r\n                                                <td>Other</td>\r\n                                                <td><%= other_charges %></td>\r\n                                            </tr>\r\n                                            <tr align=\"right\">\r\n                                                <td>Deduction</td>\r\n                                                <td><%= discount %></td>\r\n                                            </tr>\r\n                                            <tr align=\"right\">\r\n                                                <td>Total Amt.</td>\r\n                                                <td><%= running_amount %></td>\r\n                                            </tr>\r\n                                            \r\n                                            <tr align=\"right\">\r\n                                                <td>CGST of (<%= cgst_tax %>):</td>\r\n                                                <td><%= cgst_value %></td>\r\n                                            </tr>\r\n                                            <tr align=\"right\">\r\n                                                <td>SGST of (<%= sgst_tax %>): </td>\r\n                                                <td><%= sgst_value %></td>\r\n                                            </tr>\r\n                                            <tr align=\"right\">\r\n                                                <td>IGST of (<%= igst_tax %>): </td>\r\n                                                <td><%= igst_value %></td>\r\n                                            </tr>\r\n                                            \r\n                                            <tr align=\"right\">\r\n                                                <td>Total Amount</td>\r\n                                                <td>&#x20B9; <%= estimated_price %></td>\r\n                                            </tr>                                            \r\n                                            </table>  \r\n                                              </td>\r\n                                        </tr>\r\n                                        \r\n                                    <tr align=\"left\">\r\n                                          <td><strong><%= amount_in_world %></strong></td>\r\n                                    </tr> \r\n                                        \r\n                                        <tr>\r\n                                            <td colspan=2>\r\n                                                <table width=\"100%\"  border=\"1px\" cellpadding=\"0\" cellspacing=\"1\" style=\"border-collapse: collapse;font-size:9px;margin-bottom: 4px\">\r\n                                                   <tr>\r\n                                                        <td width=\"30%\" align=\"center\">HSN/SAC</td>\r\n                                                        <td width=\"15%\" align=\"center\">Taxable Value</td>\r\n                                                        <td width=\"15%\" align=\"center\">CGST\r\n                                                            <table  width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td>Rate</td>\r\n                                                                <td>Amount</td>\r\n                                                            </tr>\r\n                                                            </table>\r\n                                                        </td>\r\n                                                          \r\n                                                           <td width=\"15%\" align=\"center\">SGST\r\n                                                            <table width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td>Rate</td>\r\n                                                                <td>Amount</td>\r\n                                                            </tr>\r\n                                                            </table>\r\n                                                        </td>\r\n\r\n 							<td width=\"15%\" align=\"center\">IGST\r\n                                                         <table  width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td>Rate</td>\r\n                                                                <td>Amount</td>\r\n                                                            </tr>\r\n                                                            </table>\r\n                                                        </td>\r\n\r\n                                                        <td width=\"15%\">Total Tax Amount</td>\r\n                                                    </tr>\r\n\r\n                                                    <tr>\r\n                                                        <td></td>\r\n							<td><%= running_amount %></td>\r\n							<td>\r\n							<table  width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td width=\"50%\"><%= cgst_tax %></td>\r\n                                                                <td width=\"50%\"><%= cgst_value %></td>\r\n                                                            </tr>\r\n                                                            </table>	\r\n							</td> \r\n							<td>\r\n							<table  width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td width=\"50%\"><%= sgst_tax %></td>\r\n                                                                <td width=\"50%\"><%= sgst_value %></td>\r\n                                                            </tr>\r\n                                                            </table>	\r\n							</td>\r\n							<td>\r\n						<table  width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px;margin-top: 4px\">\r\n                                                            <tr>\r\n                                                                <td width=\"50%\"><%= igst_tax %></td>\r\n                                                                <td width=\"50%\"><%= igst_value %></td>\r\n                                                            </tr>\r\n                                                            </table>\r\n							</td>\r\n							<td align=\"right\">&#x20B9; <%= estimated_price %></td>\r\n                                                    </tr>\r\n                                                </table>\r\n                                                \r\n                                            </td>\r\n                                        </tr>\r\n                                        \r\n                                        \r\n                                    </table>\r\n\r\n                                </td>\r\n\r\n                            </tr>\r\n\r\n                        </table>\r\n                    </td>\r\n                </tr>\r\n\r\n\r\n                </td>\r\n          </tr>\r\n</table>\r\n\r\n<table  border=\"1\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"font-size:9px;margin-top:10px\">\r\n\r\n                <tr>\r\n                    <td>\r\n                       <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px\">\r\n\r\n                            <tr>\r\n                                <td>\r\n                                    <strong>Terms & Condition:</strong>\r\n                                   \r\n                                    <ol>\r\n                                        <li>Payment should be made by cheque/Draft/NEFT/Electonic transfer in fever of \r\n					<% if (user_com_name) { %>\r\n					<%= user_com_name %>\r\n					<%} else { %>\r\n					<%= com_name %>\r\n					<%}  %> </li>\r\n                                        <li>Final Fair will depend upon actual distance (in KM) Travelled+Service Tax</li>\r\n                                        <li>In case of any discrepancy kindly inform for necessary correction with-in 7 days</li>\r\n                                        <li>Insureance of passenger if not insured and not included in the quoted price</li>\r\n                                        <li>E&O.E. subject to daily jurisdiction</li>\r\n                                    </ol>\r\n\r\n                                </td>\r\n                            </tr>\r\n                        </table>\r\n                    </td>\r\n                </tr>\r\n            </table>\r\n\r\n\r\n<table  border=\"1\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundtable\" st-sortable=\"footer\" width=\"100%\" style=\"font-size:9px;margin-top:10px\">\r\n                <tr>\r\n                    <td>\r\n                       <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" style=\"font-size:9px\">\r\n                           <tr>\r\n                               <td><strong>Bank Details</strong></td>\r\n                               <td align=\"right\" style=\"font-size:12px\"><strong>for  <% if (user_com_name) { %>\r\n					<%= user_com_name %>\r\n				<%} else { %>\r\n					<%= com_name %>	\r\n				<%}  %></strong></td>\r\n                           </tr>\r\n                            <tr>\r\n                                <td>Beneficiary Name :\r\n 				    <% if (user_ac_holder) { %>\r\n					<%= user_ac_holder %>\r\n				<%} else { %>\r\n					<%= ac_holder_name %>	\r\n				<%}  %>\r\n				 </td>\r\n                            </tr>\r\n                            <tr>\r\n                                <td>Bank Name:  <% if (user_bank_name) { %>\r\n					<%= user_bank_name %>\r\n				<%} else { %>\r\n					<%= bank_name %>	\r\n				<%}  %></td>\r\n                            </tr>\r\n                            <tr>\r\n                                <td>A/c No: <% if (user_ac_no) { %>\r\n					<%= user_ac_no %>\r\n				<%} else { %>\r\n					<%= account_no %>	\r\n				<%}  %> </td>\r\n                            </tr>\r\n                            <tr>\r\n                                <td>IFSC Code : <% if (user_ifsc_code) { %>\r\n					<%= user_ifsc_code %>\r\n				<%} else { %>\r\n					<%= ifsc_code %>	\r\n				<%}  %> </td>\r\n                            </tr>\r\n                            <tr>\r\n                                <td>Branch Name : <% if (user_bank_branch) { %>\r\n					<%= user_bank_branch %>\r\n				<%} else { %>\r\n					<%= branch %>	\r\n				<%}  %>  </td>\r\n                            </tr>\r\n                            \r\n                             <tr>\r\n                               <td align=\"right\" colspan=2>Authorised Signature</td>\r\n                            </tr>\r\n                        </table>\r\n                    </td>\r\n                </tr>\r\n            </table>', '', '2017-05-15 12:52:48', '2020-09-16 06:55:28', 1, 1, '127.0.0.1', 1);

-- --------------------------------------------------------

--
-- Table structure for table `email_templatess`
--

CREATE TABLE `email_templatess` (
  `id` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `code` varchar(1000) NOT NULL,
  `subject` varchar(1000) NOT NULL,
  `body` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_templatess`
--

INSERT INTO `email_templatess` (`id`, `name`, `code`, `subject`, `body`) VALUES
(1, 'Base Combination', 'base_combination', 'Base Combination {{name}} | {{mobile}}', 'Dear Sir/Madam\r\n<br>\r\n<br>\r\nBase Combination {{name}} {{date}}\r\n<br>\r\n<br>\r\nKind regards<br>\r\nTeam Bookingcabs\r\n\r\n');

-- --------------------------------------------------------

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `id` int(11) NOT NULL,
  `enquiry_ref_no` varchar(255) DEFAULT NULL,
  `user_type` int(11) NOT NULL DEFAULT '0',
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `mobile_prefix` varchar(10) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text,
  `city` int(11) NOT NULL DEFAULT '0',
  `booking_type` int(11) NOT NULL DEFAULT '0',
  `module_type` int(11) NOT NULL DEFAULT '0',
  `enquiry_type` int(11) NOT NULL DEFAULT '0',
  `travel_date` datetime DEFAULT NULL,
  `remarks` text,
  `enquiry_closed_date` datetime DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `ip` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `enquiry_followup_status`
--

CREATE TABLE `enquiry_followup_status` (
  `id` int(11) NOT NULL,
  `enquiry_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `enquiry_assigned_date` datetime DEFAULT NULL,
  `remarks` text,
  `created_date` datetime DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `ip` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `enquiry_type`
--

CREATE TABLE `enquiry_type` (
  `id` int(11) NOT NULL,
  `enquiry_type` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `modified_by` int(11) DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `ip` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `enquiry_type`
--

INSERT INTO `enquiry_type` (`id`, `enquiry_type`, `created_date`, `modified_date`, `created_by`, `modified_by`, `status`, `ip`) VALUES
(1, 'Driver Complaints', '2015-01-08 19:03:58', '2015-01-24 03:58:11', 0, 0, 0, ''),
(2, 'Vehicle Complaints', '2015-01-08 18:08:12', '2015-01-24 03:58:22', 0, 0, 0, ''),
(3, 'Fare Complaints', '2015-01-08 18:08:37', '2015-01-19 01:16:42', 0, 0, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `experience`
--

CREATE TABLE `experience` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `exp_name` varchar(255) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  `status` enum('0','1') NOT NULL,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `extras`
--

CREATE TABLE `extras` (
  `id` int(11) NOT NULL,
  `base_vehicle_id` int(11) NOT NULL,
  `extras_master_id` varchar(100) NOT NULL,
  `extra_value_type` varchar(10) DEFAULT NULL COMMENT '%, Rs',
  `extra_value` int(11) DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fare_log`
--

CREATE TABLE `fare_log` (
  `fare_log_id` int(11) NOT NULL,
  `table_name` varchar(100) NOT NULL,
  `field_name` varchar(100) NOT NULL,
  `old_value` varchar(100) NOT NULL,
  `new_value` varchar(100) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_date` datetime NOT NULL,
  `ip` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fare_rate_type`
--

CREATE TABLE `fare_rate_type` (
  `rate_type_id` int(11) NOT NULL,
  `base_vehicle_id` int(11) NOT NULL,
  `rate` int(11) NOT NULL DEFAULT '1' COMMENT '1-Net,2-commission',
  `rate_type` varchar(10) NOT NULL,
  `rate_value` float NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Fare rate type (Net Rate or Comimssion Rate)';

-- --------------------------------------------------------

--
-- Table structure for table `favorite_addresses`
--

CREATE TABLE `favorite_addresses` (
  `id` int(11) NOT NULL,
  `Ref_Name` varchar(255) NOT NULL,
  `Bookign_ID` int(11) NOT NULL,
  `ClientId` int(11) NOT NULL,
  `Address_ID` int(11) NOT NULL,
  `Status` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `favorite_addresses`
--

INSERT INTO `favorite_addresses` (`id`, `Ref_Name`, `Bookign_ID`, `ClientId`, `Address_ID`, `Status`) VALUES
(42, 'test1', 0, 1874, 196, 0),
(43, 'test2', 0, 1874, 210, 0),
(45, 'test3', 0, 1874, 211, 0),
(46, 'test3', 0, 1874, 211, 0),
(58, 'laxmo', 0, 1470, 230, 0),
(67, 'ffgg', 0, 1470, 228, 0),
(68, 'faiz', 0, 1470, 195, 0),
(69, 'home', 0, 1784, 196, 0),
(70, 'office', 0, 1784, 326, 0),
(71, 'airport', 0, 1784, 327, 0),
(72, 'yyy', 0, 1470, 212, 0),
(73, 'rohot', 0, 1470, 340, 0),
(74, 'wee', 0, 1470, 340, 0),
(75, 'ramxxx', 0, 1470, 196, 0),
(76, '8888888888', 0, 1470, 194, 0),
(77, '1111111111', 0, 1470, 194, 0),
(78, 'rrr', 0, 1784, 366, 0);

-- --------------------------------------------------------

--
-- Table structure for table `fcm_template`
--

CREATE TABLE `fcm_template` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `message` text,
  `msg_type` text,
  `msg_sku` text,
  `variables` text,
  `text_limit` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `status_done` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Contains SMS template';

--
-- Dumping data for table `fcm_template`
--

INSERT INTO `fcm_template` (`id`, `company_id`, `message`, `msg_type`, `msg_sku`, `variables`, `text_limit`, `is_active`, `status_done`, `created_by`, `modified_by`, `created_date`, `modified_date`, `ip`) VALUES
(1, 1, 'Hi <%= username %>, Your bkg ref.<%= booking_ref %> for <%= pickup_time %>. Total apx cost Rs.<%= estimated_price %>. contact <%= com_phone %> or mobile app <%= client_app_link %>,<%= site_url %>', 'Booking (Thanks)', 'booking', '1. User Name  2. Ref. no. 3. Date & Time 4. apprx amount 5. Company Phone No 6. App Download link 7. Site Url', 271, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:39:09', '127.0.0.1'),
(2, 1, 'Hi <%= username %>, Your Driver <%= driver_name %> <%= driver_contact_no %> Veh No <%= vehicle_no %> for ref. no. <%= booking_ref_no %> will pick you at <%= pickup_time %>. Or cnt <%= com_phone %>', 'Booking(Driver Details)', 'accept', '1. User Name 2. Driver Name 3. Driver Contact 4. Vehicle No. 5. Ref. no. 6. Pickup Date & Time 7. Company phone No', 143, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:39:33', '127.0.0.1'),
(3, 1, 'Hi <%= username %>, Your bkg ref. <%= booking_ref_no %> for <%= pickup_time %> is delayed. You can contact the <%= driver_name %> <%= driver_contact_no %>.or cnt <%= com_phone %>', 'Booking(Delayed)', 'delay', '1. User Name  2. Ref. no. 3. Date & Time 4. Driver 5. Driver Contact 6. Company Phone No', 136, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:36:19', '127.0.0.1'),
(4, 1, 'Hi <%= username %>,Your cab <%= vehicle_no %> has reached pickup location. Pls board to avoid waiting charges. Mobile app <%= app_link %> or cnt <%= com_phone %>', 'Booking(Reported)', 'reporting', '1. User Name  2. cab no. 3. App download link 4. Company Phone No', 142, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:35:56', '127.0.0.1'),
(5, 1, 'Hi <%= username %>, Your Bkg ref.<%= booking_ref_no %> has been cancelled. Hope to serve you soon.visit <%= site_url %> or mobile apps <%= app_link %> <%= com_phone %>', 'Booking(Cancellation)', 'cancel', '1. User Name  2. Ref. no.3. Site Url 4 app download link 5. Company Phone No', 144, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:41:46', '127.0.0.1'),
(6, 1, 'Hi <%= username %>, Your trip Bkg ref <%= booking_ref_no %> has been started please rate Driver & Earn Hello Money Download Mobile App <%= app_link %> or call <%= com_phone %>', 'Booking(Trip Start)', 'trip_start', '1 User Name 2 Bkg Ref No 3 App Download Link 4. Company Phone No', 151, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:43:20', '127.0.0.1'),
(7, 1, 'Hi <%= username %>,Total trip amt bkg ref <%= booking_ref_no %> is Rs.<%= total_price %>. Collect fare receipt from cabbie or log in <%= site_url %>.Thanks choosing <%= site_name %>', 'Booking(Invoice)', 'invoice', '1. User Name 2. Ref. no. 3. Total bill 4. Site Url 5. Site Name', 154, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:45:02', '127.0.0.1'),
(8, 1, 'Hi <%= username %>, Your bkg ref. <%= booking_ref_no %> of <%= pickup_time %> has been rescheduled <%= reschedule_pickup_time %> or cnt <%= com_phone %> or download <%= app_link %>,<%= site_url %>', 'Booking(Reschedule)', 'resechdule', '1. Name  2. Ref. no. 3. Pickup Date & Time 4. Reschedule Pickup Date & Time 5. Company Phone No 6. App download link 7. Site Url', 151, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:47:17', '127.0.0.1'),
(9, 1, 'Hi <%= username %>, Your bkg ref. <%= booking_ref_no %> has been reassigneded from <%= old_driver_name %> & <%= old_driver_no %> to <%= new_driver_no %> & <%= new_driver_no %>. Cnt <%= com_phone %> or download app <%= app_link %>.', 'Booking(Reassignment)', 'reassign', '1. Name  2. Ref. no. 3. Old Driver Name 4. Old Driver Contact 5. New Driver Name 6. New Driver Contact 7. Company Phone No 8. App Download Link', 146, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:50:29', '127.0.0.1'),
(10, 1, 'Hi <%= username %>,Thanks for Enquiry <%= site_name %>. Enquiry Ref No is <%= enquiry_ref_no %>, More details cnt <%= com_phone %> or mobile apps <%= app_link %>,<%= site_url %>', 'Enquiry', 'enquiry', '1. Name 2.Site Name 3. Enquiry Ref. no. 3. Company Phone No 4. App download link 5. Site Url', 154, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:52:53', '127.0.0.1'),
(11, 1, 'Thank for choosing <%= site_name %> . Your Bkg Ref <%= booking_ref_no %> for <%= pickup_time %>. Cab details will be sent 45 Min prior of pickup time.Download mobile apps <%= app_link %>', 'Advance Booking', 'advance_booking', '1. SIte Name 2. Ref No 3.Date & Time 4. App download link', 160, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 11:43:40', '127.0.0.1'),
(12, 1, 'Apologies for inconvenience caused to you. Your complaint No is <%= complaint_ref_no %>. Your complaint will be resolved shortly.cnt <%= com_phone %>, <%= site_url %>', 'Complaint', 'complaint', '1. Complaint Ref. no. 2. Company Phone No 3. Site Url', 153, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:55:56', '127.0.0.1'),
(13, 1, 'Hi <%= username %>, Your Total account balance as of <%= date_time %> is Rs. <%= total_amt %>. Please recharge in order to avoid the blocking.cnt <%= com_phone %>', 'Driver - Account Balance 1(On each booking when Balance is INR 1000)', 'driver_acc_bal1', '1. Driver Name  2. Date & Time 3. Account Balance 4. Company Phone No', 142, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 09:57:52', '127.0.0.1'),
(14, 1, 'Hi <%= username %>, You have recharged of Rs.<%= recharge_amt %> on your <%= driver_cnt %>. Your current balance as of <%= date_time %> is Rs. <%= account_balance %>. Cnt <%= com_phone %>', 'Driver - Account Balance 2(On Recharge)', 'driver_acc_bal2', '1. Driver Name 2. Reacharge amount 3. Driver Contact 4. Date & Time 5. Account Balance', 149, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:01:12', '127.0.0.1'),
(15, 1, 'Hi <%= username %>, Duties for your <%= driver_cnt %> have been blocked due to nil or minus balance. Recharge immediately to get the booking. Cnt <%= com_phone %>', 'Driver - Account Balance 3(On Nil Balance)', 'driver_acc_bal3', '1. Driver Name 2. Driver Contact', 147, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:02:42', '127.0.0.1'),
(16, 1, 'Hi <%= username %>, Your bkg ref.<%= booking_ref_no %> for <%= pickup_time %>. Total apx cost Rs.<%= total_price %>.  Cnt  <%= com_phone %> mobile app <%= app_link %>,<%= site_url %>', 'Booking (Thanks)', 'intercity_booking', '1. User Name  2. Ref. no. 3. Date & Time 4. apprx amount 5. Company phone No 6.App Download link 7. Site url', 148, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:06:42', '127.0.0.1'),
(17, 1, 'Hi, Welcome to <%= site_name %>! Your One Time Password for change password is <%= otp %>. Please Enter this password to access your profile.', 'OTP', 'otp', '1. Site Name 2. OTP', 25, 1, 0, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:08:12', '127.0.0.1'),
(18, 1, 'Hi <%= username %> sorry we don\'t have any other cabs, if you want we can try another cab after 15 min. Log on <%= site_url %>  or Contact <%= com_phone %> ', 'cab delay for 15 mins after pickup time of user', 'cab_delay_15', '1. Name 2. Site Url 3. Company Phone No', 146, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:09:39', '127.0.0.1'),
(19, 1, 'Hi <%= username %>, Your account has been uploaded with Rs <%= amount %> ,You can Start your booking Now ,Log on <%= site_url %> or Call <%= com_phone %> ', 'Amount Upload', 'amt_upload', '1. Driver Name 2. Amount 3. Site Url 4. Company hone No\r\n', 141, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:11:19', '127.0.0.1'),
(20, 1, 'Hi <%= username %>,You have requested to reset the Password ,Enter the <%= otp %> to confirm log on <%= site_url %>', 'Forgot Password', 'forgot_password', '1. User Name 2. OTP 3. Site Url', 113, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:12:32', '127.0.0.1'),
(21, 1, 'Hi <%= username %>, Your Bkg Ref <%= booking_ref_no %> for <%= client_name %> has been Cancel .Hope to Serve you soon or Contact <%= site_name %> <%= com_phone %>', 'Booking Reassign/Cancel', 'reassign_cancel', '1. Driver Name 2. Booking ref no 3. Client Name 4. Site Name 5. Company Phone No', 130, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:14:19', '127.0.0.1'),
(22, 1, 'Hi <%= username %>, Welcome to <%= com_name %>,Thanks for Registration, Please complete the Registration Formalities log on to <%= site_url%>. Or Call <%= com_phone %>', 'Welcome Msg ', 'welcome_msg', '1 User Name 2 Company Name 3. SIte Url 4. Company Phone No', 145, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:26:42', '127.0.0.1'),
(23, 1, 'Hi <%= username %>, Welcome to <%= com_name %>! To activate enter the verification code <%= code %> on <%= com_name %>  or Log on <%= site_url %>.', 'Account Verification code', 'acc_verify_code', '1. User Name  2. Company Name 3. Verification code 4. Site Name 5. SIte Url', 128, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-03 13:01:40', '127.0.0.1'),
(24, 1, 'Hi <%= username %>,  Rs <%= amount %> is Credited in Hello Money Account ,Hello Money Balance is Rs <%= total_balance %> , Log on <%= site_url %> to use Hello Money', 'Sign up Credit ', 'signup_credit', '1. User Name 2. Amount 3.  Total Amount 4. SIte Url', 149, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:29:05', '127.0.0.1'),
(25, 1, 'Hi <%= username %>, Use my Code <%= user_referral_code %> to Signup and get <%= referral_amount %> Hello Money to ride for free ,Have a great ride Download <%= app_link %>', 'Refer & Earn', 'refer_earn', '1. Refered Name, 2. Referal Code 3. Referral Amount 4. app download link', 138, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:29:37', '127.0.0.1'),
(26, 1, 'Hi <%= username %>, Welcome to <%= com_name %>, Thanks for Registration Your Referral Code is <%= user_referral_code %> log on to <%= site_url%> Or Download <%= app_link %>', 'Registration of driver', 'driver_regis', '1. Driver Name 2. Company Name 3. Referral Code 4. Site Url 5. App Download Link', 113, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:31:29', '127.0.0.1'),
(27, 1, 'Hi <%= username %>, Welcome to <%= com_name %>! Thanks for Registration, Please complete the Registration Formalities log on to <%= site_url %>. Or Call <%= com_phone %>', 'Welcome Message', 'message', '1 User Name 2 Company Name 3. Site Url 4. Company Phone No', 113, 1, 0, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:36:05', '127.0.0.1'),
(28, 1, 'Hi <%= username %>, Your booking with ref. no. <%= booking_ref_no %> for <%= pickup_time %>. Total apprx cost Rs.<%= estimated_price %>. Our tarrif is <%= tarrif_amount %> Rs. for first <%= hrs %> Hrs.  After that Rs.<%= per_hour_price %> per Hour. waiting charges Rs.<%= waiting_charge %> /minute. For more details, contact <%= com_phone %> or download mobile app <%= app_link %>. Other conditions apply.', 'Booking(Thanks)', 'booking_hrs', '1. User Name  2. Ref. no. 3. Date & Time 4. apprx amount 5. tariff amount 6. Hours 7. Per Hour Charge 8. Waiting amount 9. Company Phone No 10. App Download link', 315, 1, 0, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:41:52', '127.0.0.1'),
(29, 1, 'Hi <%= username %>,We regret to inform cancellation of Bkg ref.<%= booking_ref_no %> currently there is no free cab.Serve you soon. <%= site_url %> or Download app <%= app_link %>', 'Booking(Cancellation from Admin)', 'cancel_admin', '1. User Name  2. Ref. no. 3. Site Url 4 app download link', 161, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 11:42:20', '127.0.0.1'),
(30, 1, 'Hi <%= username %> Sorry we don\'t have any other cabs, if you want we can try another cab after 30 min. Log on <%= site_url %> or Contact <%= com_phone %>  ', 'cab delay for 30 mins after pickup time of user', 'cab_delay_30', '1. Name 2. Site Url 3. Company Phone No', 146, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:34:24', '127.0.0.1'),
(31, 1, 'Hi <%= username %>, Welcome to <%= com_name %>, Thanks for Registration Your Referral Code is <%= user_referral_code %> log on to <%= site_url%> Or Download <%= app_link %>', 'Registration of User', 'user_regis', '1. User Name 2.Company Name 3. Referal Code 4. Site url 5.App Download Link', 143, 1, 1, 1, 1, '0000-00-00 00:00:00', '2020-06-02 10:32:38', '127.0.0.1');

-- --------------------------------------------------------

--
