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';



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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `reservation` varchar(30) NOT NULL,
  `web_booking_rate` varchar(15) NOT NULL,
  `web_confirm_rate` varchar(15) NOT NULL,
  `web_service_rate` varchar(15) NOT NULL,
  `android_app_rate` varchar(15) NOT NULL,
  `android_booking_rate` varchar(15) NOT NULL,
  `android_confirm_rate` varchar(15) NOT NULL,
  `android_service_rate` varchar(15) NOT NULL,
  `call_book_rate` varchar(15) NOT NULL,
  `call_agent_rate` varchar(15) NOT NULL,
  `call_instruction_rate` varchar(15) NOT NULL,
  `call_confirmation_rate` varchar(15) NOT NULL,
  `call_services_rate` varchar(15) NOT NULL,
  `vehicle_rate` varchar(15) NOT NULL,
  `requested_rate` varchar(15) NOT NULL,
  `instruction_follow_rate` varchar(15) NOT NULL,
  `vehicle_condition` varchar(15) NOT NULL,
  `aircondition_effective_rate` varchar(15) NOT NULL,
  `cleanness_rate` varchar(15) NOT NULL,
  `grooming_rate` varchar(15) NOT NULL,
  `accuracy_rate` varchar(15) NOT NULL,
  `invoice_time_rate` varchar(15) NOT NULL,
  `receivingInv_rate` varchar(15) NOT NULL,
  `created_date` date NOT NULL,
  `ip` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `feedback_for_user_app`
--

CREATE TABLE `feedback_for_user_app` (
  `id` int(11) NOT NULL,
  `UserId` int(11) NOT NULL,
  `Helpful` float NOT NULL,
  `EasyToUse` float NOT NULL,
  `Design` float NOT NULL,
  `Feedback` text NOT NULL,
  `AppType` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fix_route`
--

CREATE TABLE `fix_route` (
  `id` int(11) NOT NULL,
  `base_vehicle_id` int(11) NOT NULL,
  `frequent_location` varchar(30) 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 DEFAULT '0',
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fix_route`
--

INSERT INTO `fix_route` (`id`, `base_vehicle_id`, `frequent_location`, `created_date`, `modified_date`, `created_by`, `modified_by`, `status`, `ip`) VALUES
(1, 1, '110032', '2023-03-21 04:53:13', '2023-03-21 22:23:13', 1, 0, '0', '43.248.153.0'),
(2, 4, '110032', '2023-03-30 14:36:09', '2023-03-30 09:06:09', 14, 0, '1', '122.180.251.101'),
(3, 7, '110032', '2023-03-31 22:59:59', '2023-03-31 17:29:59', 17, 0, '1', '47.31.219.126');

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

--
-- Table structure for table `guide_details`
--

CREATE TABLE `guide_details` (
  `id` int(11) NOT NULL,
  `guide_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `email_id` varchar(100) NOT NULL,
  `email_id_verified` enum('0','1') NOT NULL DEFAULT '0',
  `phone_no` varchar(15) NOT NULL,
  `phone_no_verified` enum('0','1') NOT NULL DEFAULT '0',
  `external_ref_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `gender` enum('Male','Female') CHARACTER SET latin2 COLLATE latin2_bin NOT NULL DEFAULT 'Male',
  `address` text NOT NULL,
  `country` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `pin_code` varchar(10) NOT NULL,
  `kyc` varchar(100) NOT NULL,
  `kyc_proof` text NOT NULL,
  `photo` text NOT NULL,
  `photo_verify` int(11) NOT NULL,
  `duty_type_pref` varchar(100) NOT NULL,
  `payment_type_id` int(11) NOT NULL,
  `license_state` varchar(50) NOT NULL,
  `license_no` varchar(50) NOT NULL,
  `license_proof` text NOT NULL,
  `license_validity` varchar(20) NOT NULL,
  `pan_card_no` varchar(20) NOT NULL,
  `pancard_proof` text NOT NULL,
  `police_proof` text NOT NULL,
  `audit_proof` text NOT NULL,
  `pref_city` varchar(100) NOT NULL,
  `route_knowledge` varchar(10) NOT NULL,
  `pref_zone` varchar(10) NOT NULL,
  `week_off` varchar(50) NOT NULL,
  `education_qualification` text NOT NULL,
  `guide_qualification` text NOT NULL,
  `theme` int(11) NOT NULL,
  `experience` text NOT NULL,
  `pref_timing` varchar(50) NOT NULL,
  `membership_id` int(11) NOT NULL,
  `about_guide` text NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '5',
  `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,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `guide_fare`
--

CREATE TABLE `guide_fare` (
  `id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `booking_type` varchar(5) NOT NULL,
  `s_id` int(11) NOT NULL,
  `nationality` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guide_fare`
--

INSERT INTO `guide_fare` (`id`, `country_id`, `state_id`, `city_id`, `booking_type`, `s_id`, `nationality`, `lang_id`) VALUES
(1, 1, 1, 1, '101', 1, 1, 0),
(2, 1, 1, 1, '102', 2, 1, 0),
(3, 1, 1, 2, '105', 5, 1, 0);

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

--
-- Table structure for table `guide_hourly_fare`
--

CREATE TABLE `guide_hourly_fare` (
  `giude_hourly_fare_id` int(11) NOT NULL,
  `base_comb_id` int(11) NOT NULL,
  `minimum_charge` int(11) NOT NULL,
  `minimum_hrs` int(11) NOT NULL,
  `per_hr_charge` int(11) 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;

--
-- Dumping data for table `guide_hourly_fare`
--

INSERT INTO `guide_hourly_fare` (`giude_hourly_fare_id`, `base_comb_id`, `minimum_charge`, `minimum_hrs`, `per_hr_charge`, `created_date`, `modified_date`, `created_by`, `modified_by`, `status`, `ip`) VALUES
(1, 1, 800, 4, 200, '2017-08-22 00:00:00', '2017-08-22 11:12:45', 1, 1, '1', '127.0.0.1');

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

--
-- Table structure for table `guide_language`
--

CREATE TABLE `guide_language` (
  `guide_lang_id` int(11) NOT NULL,
  `guide_id` int(11) NOT NULL,
  `lang_id` int(11) 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 DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `guide_local_package`
--

CREATE TABLE `guide_local_package` (
  `id` int(11) NOT NULL,
  `package` varchar(255) DEFAULT NULL,
  `master_pkg_id` int(11) DEFAULT '101',
  `sub_pkg_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `hrs` int(11) NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `status` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guide_local_package`
--

INSERT INTO `guide_local_package` (`id`, `package`, `master_pkg_id`, `sub_pkg_id`, `city_id`, `lang_id`, `hrs`, `price`, `status`) VALUES
(1, '4 Hrs', 101, 2, 2, 1, 4, 400, 1),
(2, '8 Hrs', 101, 2, 2, 1, 8, 800, 1),
(3, '12 Hrs', 101, 2, 2, 1, 12, 1200, 1),
(4, '4 Hrs', 102, 2, 2, 1, 4, 400, 1),
(5, '8 Hrs', 102, 2, 2, 1, 8, 800, 1),
(6, '12 Hrs', 102, 2, 2, 1, 12, 1200, 1);

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

--
-- Table structure for table `hotel_board_room`
--

CREATE TABLE `hotel_board_room` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `capacity` varchar(5) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_board_room_images`
--

CREATE TABLE `hotel_board_room_images` (
  `id` int(11) NOT NULL,
  `board_room_id` int(11) NOT NULL,
  `path` varchar(255) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_conference_hall`
--

CREATE TABLE `hotel_conference_hall` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `capacity` varchar(25) NOT NULL,
  `u_shaped` varchar(25) NOT NULL,
  `theater_shaped` varchar(25) NOT NULL,
  `round_table` varchar(25) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_conference_hall_images`
--

CREATE TABLE `hotel_conference_hall_images` (
  `id` int(11) NOT NULL,
  `conference_hall_id` int(11) NOT NULL,
  `path` varchar(255) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_detail`
--

CREATE TABLE `hotel_detail` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `property_type` int(11) NOT NULL,
  `hotel_category` int(11) DEFAULT NULL,
  `logo` text COLLATE utf8_unicode_ci,
  `url` text COLLATE utf8_unicode_ci NOT NULL,
  `city_id` int(11) DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `featured` int(11) NOT NULL DEFAULT '0',
  `preferred` int(11) DEFAULT '0',
  `total_floor` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_rooms_single` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_rooms_double` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_rooms_twin` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_rooms_disabled` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `check_in_time` time NOT NULL,
  `check_out_time` time NOT NULL,
  `total_conference_halls` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_board_rooms` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `total_party_lawns` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `interconnected_total_rooms` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `currency` int(11) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `payment_description` text COLLATE utf8_unicode_ci,
  `telephone` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `building_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `building_number` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `postal_code` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sales_person_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sales_person_landline_no` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `sales_person_mobile_no` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sales_person_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `reservation_person_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reservation_person_landline_no` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `reservation_person_mobile_no` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `reservation_person_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `weekend` int(11) DEFAULT NULL,
  `realted_tours` text COLLATE utf8_unicode_ci,
  `brochure_title` text COLLATE utf8_unicode_ci,
  `brochure_description` text COLLATE utf8_unicode_ci,
  `meta_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allocation_from_date` date DEFAULT NULL,
  `allocation_to_date` date DEFAULT NULL,
  `allocation_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allocation_cut_off_days` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allocation_room_category` int(11) DEFAULT NULL,
  `available_start_date` date DEFAULT NULL,
  `available_end_date` date DEFAULT NULL,
  `feature_google_map` text COLLATE utf8_unicode_ci,
  `hotel_highlights` text COLLATE utf8_unicode_ci,
  `payment_structure_id` int(11) DEFAULT NULL,
  `document_id` int(11) DEFAULT NULL,
  `cancellation_policy` int(11) DEFAULT NULL,
  `refund_policy` int(11) DEFAULT NULL,
  `term_policy` int(11) DEFAULT NULL,
  `payment_structure_content` text COLLATE utf8_unicode_ci,
  `documentation_content` text COLLATE utf8_unicode_ci,
  `cancellation_policy_content` text COLLATE utf8_unicode_ci,
  `refund_policy_content` text COLLATE utf8_unicode_ci,
  `term_policy_content` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `hotel_extra_info`
--

CREATE TABLE `hotel_extra_info` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `extra_info_id` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotel_extra_info`
--

INSERT INTO `hotel_extra_info` (`id`, `hotel_id`, `extra_info_id`, `created_date`, `created_by`, `modified_by`, `modified_date`, `status`, `ip`) VALUES
(1, 4, 23, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(2, 4, 24, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(3, 4, 25, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(4, 4, 26, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(5, 4, 27, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(6, 4, 28, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(7, 4, 29, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(8, 4, 30, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(9, 4, 31, '2020-10-08', 1, 1, '2020-10-09 01:51:15', 2, '127.0.0.1'),
(10, 4, 23, '2020-10-08', 1, 1, '2020-10-09 01:53:11', 2, '127.0.0.1'),
(11, 4, 23, '2020-10-08', 1, 1, '2020-10-09 01:54:53', 2, '127.0.0.1'),
(12, 4, 24, '2020-10-08', 1, 1, '2020-10-09 01:54:53', 2, '127.0.0.1'),
(13, 3, 23, '2020-10-08', 1, 1, '2020-10-09 02:00:40', 2, '127.0.0.1'),
(14, 3, 24, '2020-10-08', 1, 1, '2020-10-09 02:00:40', 2, '127.0.0.1'),
(15, 3, 23, '2020-10-08', 1, 1, '2020-10-09 02:01:58', 2, '127.0.0.1'),
(16, 3, 24, '2020-10-08', 1, 1, '2020-10-09 02:01:58', 2, '127.0.0.1'),
(17, 3, 25, '2020-10-08', 1, 1, '2020-10-09 02:01:58', 2, '127.0.0.1'),
(18, 2, 23, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(19, 2, 24, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(20, 2, 25, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(21, 2, 26, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(22, 2, 27, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(23, 2, 28, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(24, 2, 29, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(25, 2, 30, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(26, 2, 31, '2020-10-08', 1, 1, '2020-10-09 02:03:31', 2, '127.0.0.1'),
(27, 2, 23, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(28, 2, 24, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(29, 2, 25, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(30, 2, 26, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(31, 2, 27, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(32, 2, 28, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(33, 2, 29, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(34, 2, 30, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(35, 2, 31, '2020-10-13', 1, 1, '2020-10-13 15:58:41', 2, '127.0.0.1'),
(36, 3, 23, '2020-10-13', 1, 1, '2020-10-13 16:01:26', 2, '127.0.0.1'),
(37, 3, 24, '2020-10-13', 1, 1, '2020-10-13 16:01:26', 2, '127.0.0.1'),
(38, 3, 25, '2020-10-13', 1, 1, '2020-10-13 16:01:26', 2, '127.0.0.1'),
(39, 2, 23, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(40, 2, 24, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(41, 2, 25, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(42, 2, 26, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(43, 2, 27, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(44, 2, 28, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(45, 2, 29, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(46, 2, 30, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(47, 2, 31, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(48, 3, 23, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(49, 3, 24, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(50, 3, 25, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(51, 4, 23, '2020-12-05', 1, 1, '2020-12-05 06:54:05', 2, '127.0.0.1'),
(52, 4, 24, '2020-12-05', 1, 1, '2020-12-05 06:54:05', 2, '127.0.0.1'),
(53, 4, 23, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(54, 4, 24, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(55, 4, 23, '2021-02-01', 1, NULL, '2021-02-01 08:16:36', 1, '127.0.0.1'),
(56, 4, 24, '2021-02-01', 1, NULL, '2021-02-01 08:16:36', 1, '127.0.0.1'),
(57, 7, 24, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(58, 7, 25, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(59, 7, 26, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(60, 7, 27, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(61, 7, 28, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(62, 7, 29, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(63, 7, 30, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(64, 7, 31, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(65, 7, 23, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(66, 1, 23, '2021-02-01', 1, NULL, '2021-02-01 10:16:22', 1, '127.0.0.1'),
(67, 1, 24, '2021-02-01', 1, NULL, '2021-02-01 10:16:22', 1, '127.0.0.1'),
(68, 3, 23, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(69, 3, 24, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(70, 3, 25, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(71, 3, 23, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(72, 3, 24, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(73, 3, 25, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(74, 3, 23, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(75, 3, 24, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(76, 3, 25, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(77, 5, 23, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(78, 5, 24, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(79, 5, 25, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(80, 3, 23, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(81, 3, 24, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(82, 3, 25, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(83, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(84, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(85, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(86, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(87, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(88, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(89, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(90, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(91, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:18:21', 2, '127.0.0.1'),
(92, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(93, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(94, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(95, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(96, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(97, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(98, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(99, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(100, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(101, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(102, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(103, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(104, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(105, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(106, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(107, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(108, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(109, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(110, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(111, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(112, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(113, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(114, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(115, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(116, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(117, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(118, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(119, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(120, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(121, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(122, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(123, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(124, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(125, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(126, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(127, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(128, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(129, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(130, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(131, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(132, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(133, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(134, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(135, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(136, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(137, 7, 23, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(138, 7, 24, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(139, 7, 25, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(140, 7, 26, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(141, 7, 27, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(142, 7, 28, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(143, 7, 29, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(144, 7, 30, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(145, 7, 31, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(146, 2, 23, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(147, 2, 24, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(148, 2, 25, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(149, 2, 26, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(150, 2, 27, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(151, 2, 28, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(152, 2, 29, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(153, 2, 30, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(154, 2, 31, '2021-03-06', 1, NULL, '2021-03-06 10:56:58', 1, '127.0.0.1'),
(155, 7, 23, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(156, 7, 24, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(157, 7, 25, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(158, 7, 26, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(159, 7, 27, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(160, 7, 28, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(161, 7, 29, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(162, 7, 30, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(163, 7, 31, '2021-03-06', 1, 1, '2021-03-06 11:29:11', 2, '127.0.0.1'),
(164, 7, 23, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(165, 7, 24, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(166, 7, 25, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(167, 7, 26, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(168, 7, 27, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(169, 7, 28, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(170, 7, 29, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(171, 7, 30, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(172, 7, 31, '2021-03-06', 1, 1, '2021-03-06 11:29:21', 2, '127.0.0.1'),
(173, 7, 23, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(174, 7, 24, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(175, 7, 25, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(176, 7, 26, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(177, 7, 27, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(178, 7, 28, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(179, 7, 29, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(180, 7, 30, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1'),
(181, 7, 31, '2021-08-01', 1, NULL, '2021-07-31 18:43:16', 1, '127.0.0.1');

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

--
-- Table structure for table `hotel_facility`
--

CREATE TABLE `hotel_facility` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `facility_name_id` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotel_facility`
--

INSERT INTO `hotel_facility` (`id`, `hotel_id`, `facility_name_id`, `created_date`, `created_by`, `modified_by`, `modified_date`, `status`, `ip`) VALUES
(1, 2, 1, '2020-12-05', 1, 1, '2020-12-05 06:27:37', 2, '127.0.0.1'),
(2, 2, 2, '2020-12-05', 1, 1, '2020-12-05 06:27:37', 2, '127.0.0.1'),
(3, 2, 1, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(4, 2, 2, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(5, 2, 3, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(6, 2, 4, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(7, 2, 5, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(8, 2, 6, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(9, 2, 7, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(10, 2, 8, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(11, 2, 9, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(12, 2, 10, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(13, 2, 11, '2020-12-05', 1, 1, '2020-12-05 06:30:14', 2, '127.0.0.1'),
(14, 3, 1, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(15, 3, 2, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(16, 3, 3, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(17, 3, 4, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(18, 3, 5, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(19, 3, 6, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(20, 3, 7, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(21, 3, 8, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(22, 3, 9, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(23, 3, 10, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(24, 3, 11, '2020-12-05', 1, 1, '2020-12-05 06:31:11', 2, '127.0.0.1'),
(25, 4, 1, '2020-12-05', 1, 1, '2020-12-05 06:54:04', 2, '127.0.0.1'),
(26, 4, 2, '2020-12-05', 1, 1, '2020-12-05 06:54:04', 2, '127.0.0.1'),
(27, 4, 3, '2020-12-05', 1, 1, '2020-12-05 06:54:04', 2, '127.0.0.1'),
(28, 4, 4, '2020-12-05', 1, 1, '2020-12-05 06:54:04', 2, '127.0.0.1'),
(29, 4, 1, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(30, 4, 2, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(31, 4, 3, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(32, 4, 4, '2021-02-01', 1, 1, '2021-02-01 08:16:03', 2, '127.0.0.1'),
(33, 4, 1, '2021-02-01', 1, NULL, '2021-02-01 08:16:35', 1, '127.0.0.1'),
(34, 4, 2, '2021-02-01', 1, NULL, '2021-02-01 08:16:35', 1, '127.0.0.1'),
(35, 4, 3, '2021-02-01', 1, NULL, '2021-02-01 08:16:35', 1, '127.0.0.1'),
(36, 4, 4, '2021-02-01', 1, NULL, '2021-02-01 08:16:35', 1, '127.0.0.1'),
(37, 7, 1, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(38, 7, 2, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(39, 7, 3, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(40, 7, 4, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(41, 7, 5, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(42, 7, 6, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(43, 7, 8, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(44, 7, 9, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(45, 7, 10, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(46, 7, 11, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(47, 7, 7, '2021-02-01', 1, 1, '2021-02-01 10:12:19', 2, '127.0.0.1'),
(48, 1, 1, '2021-02-01', 1, NULL, '2021-02-01 10:16:22', 1, '127.0.0.1'),
(49, 1, 2, '2021-02-01', 1, NULL, '2021-02-01 10:16:22', 1, '127.0.0.1'),
(50, 3, 1, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(51, 3, 2, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(52, 3, 3, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(53, 3, 4, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(54, 3, 5, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(55, 3, 6, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(56, 3, 7, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(57, 3, 8, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(58, 3, 9, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(59, 3, 10, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(60, 3, 11, '2021-02-01', 1, 1, '2021-02-01 10:20:34', 2, '127.0.0.1'),
(61, 3, 1, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(62, 3, 2, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(63, 3, 3, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(64, 3, 4, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(65, 3, 5, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(66, 3, 6, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(67, 3, 7, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(68, 3, 8, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(69, 3, 9, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(70, 3, 10, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(71, 3, 11, '2021-02-01', 1, 1, '2021-02-01 10:20:51', 2, '127.0.0.1'),
(72, 3, 1, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(73, 3, 2, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(74, 3, 3, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(75, 3, 4, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(76, 3, 5, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(77, 3, 6, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(78, 3, 7, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(79, 3, 8, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(80, 3, 9, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(81, 3, 10, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(82, 3, 11, '2021-02-01', 1, 1, '2021-02-01 10:23:30', 2, '127.0.0.1'),
(83, 5, 1, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(84, 5, 2, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(85, 5, 3, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(86, 5, 4, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(87, 5, 5, '2021-02-01', 1, NULL, '2021-02-01 10:39:38', 1, '127.0.0.1'),
(88, 3, 1, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(89, 3, 2, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(90, 3, 3, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(91, 3, 4, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(92, 3, 5, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(93, 3, 6, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(94, 3, 7, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(95, 3, 8, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(96, 3, 9, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(97, 3, 10, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(98, 3, 11, '2021-02-01', 1, NULL, '2021-02-01 10:58:53', 1, '127.0.0.1'),
(99, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(100, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(101, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(102, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(103, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(104, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(105, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(106, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(107, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(108, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(109, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:18:20', 2, '127.0.0.1'),
(110, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(111, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(112, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(113, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(114, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(115, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(116, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(117, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(118, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(119, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(120, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:27:06', 2, '127.0.0.1'),
(121, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(122, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(123, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(124, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(125, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(126, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(127, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(128, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(129, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(130, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(131, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:31:04', 2, '127.0.0.1'),
(132, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(133, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(134, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(135, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(136, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(137, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(138, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(139, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(140, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(141, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(142, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:34:24', 2, '127.0.0.1'),
(143, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(144, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(145, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(146, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(147, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(148, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(149, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(150, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(151, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(152, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(153, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:35:26', 2, '127.0.0.1'),
(154, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(155, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(156, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(157, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(158, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(159, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(160, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(161, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(162, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(163, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(164, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:35:53', 2, '127.0.0.1'),
(165, 7, 1, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(166, 7, 2, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(167, 7, 3, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(168, 7, 4, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(169, 7, 5, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(170, 7, 6, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(171, 7, 7, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(172, 7, 8, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(173, 7, 9, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(174, 7, 10, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(175, 7, 11, '2021-03-06', 1, 1, '2021-03-06 10:46:44', 2, '127.0.0.1'),
(176, 2, 1, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(177, 2, 2, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(178, 2, 3, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(179, 2, 4, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(180, 2, 5, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(181, 2, 6, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(182, 2, 7, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(183, 2, 8, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(184, 2, 9, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(185, 2, 10, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(186, 2, 11, '2021-03-06', 1, NULL, '2021-03-06 10:56:57', 1, '127.0.0.1'),
(187, 7, 1, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(188, 7, 2, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(189, 7, 3, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(190, 7, 4, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(191, 7, 5, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(192, 7, 6, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(193, 7, 7, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(194, 7, 8, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(195, 7, 9, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(196, 7, 10, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(197, 7, 11, '2021-03-06', 1, 1, '2021-03-06 11:29:10', 2, '127.0.0.1'),
(198, 7, 1, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(199, 7, 2, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(200, 7, 3, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(201, 7, 4, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(202, 7, 5, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(203, 7, 6, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(204, 7, 7, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(205, 7, 8, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(206, 7, 9, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(207, 7, 10, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(208, 7, 11, '2021-03-06', 1, 1, '2021-03-06 11:29:20', 2, '127.0.0.1'),
(209, 7, 1, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(210, 7, 2, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(211, 7, 3, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(212, 7, 4, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(213, 7, 5, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(214, 7, 6, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(215, 7, 7, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(216, 7, 8, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(217, 7, 9, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(218, 7, 10, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1'),
(219, 7, 11, '2021-08-01', 1, NULL, '2021-07-31 18:43:15', 1, '127.0.0.1');

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

--
-- Table structure for table `hotel_free_offers`
--

CREATE TABLE `hotel_free_offers` (
  `id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `mapping_id` int(11) NOT NULL,
  `bkg_type_id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `rooms` tinyint(4) NOT NULL DEFAULT '0',
  `nights` tinyint(4) NOT NULL DEFAULT '0',
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_free_offers_log`
--

CREATE TABLE `hotel_free_offers_log` (
  `id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `mapping_id` int(11) NOT NULL,
  `bkg_type_id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `rooms` tinyint(4) NOT NULL DEFAULT '0',
  `nights` tinyint(4) NOT NULL DEFAULT '0',
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_invoice`
--

CREATE TABLE `hotel_invoice` (
  `invoice_id` int(11) NOT NULL,
  `hotel_code` varchar(100) NOT NULL,
  `hotel_name` varchar(100) NOT NULL,
  `currency` varchar(30) NOT NULL,
  `tbo_invoice` varchar(30) NOT NULL,
  `no_of_rooms` varchar(10) NOT NULL,
  `total_room_price` varchar(20) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `hotel_booking_status` varchar(20) NOT NULL,
  `ChildCharge` varchar(10) NOT NULL,
  `OtherCharges` varchar(20) NOT NULL,
  `Discount` varchar(20) NOT NULL,
  `PublishedPrice` varchar(15) NOT NULL,
  `PublishedPriceRoundedOff` varchar(15) NOT NULL,
  `confirmation_number` varchar(50) NOT NULL,
  `booking_ref_no` varchar(100) NOT NULL,
  `booking_id` varchar(50) NOT NULL,
  `check_in_date` date NOT NULL,
  `check_out_date` date NOT NULL,
  `nights_stay` varchar(20) NOT NULL,
  `is_paid` varchar(20) NOT NULL,
  `is_paid_at` date NOT NULL,
  `payment_type` varchar(20) NOT NULL,
  `total_tax_price` varchar(15) NOT NULL,
  `fees` varchar(15) NOT NULL,
  `is_voucher_booking` varchar(15) NOT NULL,
  `cancelation_date` date NOT NULL,
  `cgst_tax` varchar(10) NOT NULL,
  `igst_tax` varchar(10) NOT NULL,
  `sgst_tax` varchar(10) NOT NULL,
  `estimated_price_before_markup` varchar(20) NOT NULL,
  `markup_type` varchar(50) NOT NULL,
  `markup_value` varchar(15) NOT NULL,
  `markup_price` varchar(15) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `modified_by` varchar(50) NOT NULL,
  `modified_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `hotel_location_map_distance`
--

CREATE TABLE `hotel_location_map_distance` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `location_type_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `distance` varchar(5) NOT NULL,
  `walk` varchar(5) NOT NULL,
  `public_transport` varchar(5) NOT NULL,
  `by_car` varchar(5) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_party_lawn`
--

CREATE TABLE `hotel_party_lawn` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `capacity` varchar(5) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_party_lawn_images`
--

CREATE TABLE `hotel_party_lawn_images` (
  `id` int(11) NOT NULL,
  `party_lawn_id` int(11) NOT NULL,
  `path` varchar(255) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_related`
--

CREATE TABLE `hotel_related` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `hotel_id2` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hotel_rooms`
--

CREATE TABLE `hotel_rooms` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `room_type_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `thumb` text,
  `minimum_staying` varchar(5) NOT NULL,
  `maximum_adult` varchar(5) NOT NULL,
  `maximum_children` varchar(5) NOT NULL,
  `extra_bed` varchar(5) DEFAULT NULL,
  `deal` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `vendor_type` int(11) DEFAULT NULL,
  `vendor_name` varchar(255) DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotel_rooms`
--

INSERT INTO `hotel_rooms` (`id`, `hotel_id`, `category_id`, `room_type_id`, `name`, `thumb`, `minimum_staying`, `maximum_adult`, `maximum_children`, `extra_bed`, `deal`, `description`, `vendor_type`, `vendor_name`, `valid_from`, `valid_to`, `created_date`, `created_by`, `modified_by`, `modified_date`, `status`, `ip`) VALUES
(1, 3, 1, 2, 'Test', '', '1', '2', '3', '4', '', '<p>Test</p>', 0, '', '0000-00-00', '0000-00-00', '2020-10-16 19:26:19', 1, 1, '2020-10-16 13:56:19', 0, '127.0.0.1'),
(2, 2, 1, 1, 'Test', '', '2', '2', '2', '2', '', '<p>Testxzc</p>', 0, '', '0000-00-00', '0000-00-00', '2020-11-11 04:21:34', 1, 1, '2020-11-10 22:51:34', 1, '127.0.0.1'),
(3, 2, 1, 3, 'Test', '', '2', '2', '2', '2', '', '<p>Test</p>', 0, '', '0000-00-00', '0000-00-00', '2020-11-11 04:27:59', 1, 1, '2020-11-10 22:57:59', 1, '127.0.0.1'),
(4, 2, 1, 2, 'Test', '', '12', '12', '12', '12', '', '<p>Test Description.</p>', 0, '', '0000-00-00', '0000-00-00', '2021-02-01 15:33:28', 1, 1, '2021-02-01 10:03:28', 1, '127.0.0.1'),
(5, 7, 1, 1, 'Test Room', NULL, '33', '33', '33', '33', NULL, '<p>Test Room</p>', NULL, NULL, NULL, NULL, '2021-03-06 17:15:47', 1, 1, '2021-03-06 11:45:47', 0, '127.0.0.1');

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

--
-- Table structure for table `hotel_room_cancellation_fees`
--

CREATE TABLE `hotel_room_cancellation_fees` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `vendor_type` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `rate_type` varchar(50) NOT NULL,
  `rate_type_id` int(11) NOT NULL DEFAULT '0',
  `rate_name_id` int(11) NOT NULL,
  `cancel_date_from` date NOT NULL,
  `cancel_date_to` date NOT NULL,
  `cancellation_master_id` int(11) NOT NULL,
  `cancellation_type` varchar(10) NOT NULL,
  `cancellation_value` float NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotel_room_cancellation_fees`
--

INSERT INTO `hotel_room_cancellation_fees` (`id`, `hotel_id`, `room_id`, `currency_id`, `vendor_type`, `vendor_id`, `rate_type`, `rate_type_id`, `rate_name_id`, `cancel_date_from`, `cancel_date_to`, `cancellation_master_id`, `cancellation_type`, `cancellation_value`, `created_date`, `created_by`, `modified_by`, `modified_date`, `status`, `ip`) VALUES
(11, 3, 1, 2, 14, 1584, 'Normal Rate', 0, 2, '2021-12-21', '2021-12-30', 13, 'Value', 100, '2021-12-20', 1, 1, '2021-12-20 11:14:49', 1, '127.0.0.1'),
(12, 3, 1, 2, 14, 1584, 'Normal Rate', 0, 2, '2021-12-21', '2021-12-30', 12, 'Value', 200, '2021-12-20', 1, 1, '2021-12-20 11:14:49', 1, '127.0.0.1'),
(13, 3, 1, 1, 8, 1673, 'Normal Rate', 0, 1, '2021-12-20', '2021-12-31', 13, 'Value', 100, '2021-12-20', 1, 1, '2021-12-20 11:15:42', 1, '127.0.0.1'),
(14, 3, 1, 1, 8, 1673, 'Normal Rate', 0, 1, '2021-12-20', '2021-12-31', 12, 'Value', 200, '2021-12-20', 1, NULL, '2021-12-20 11:15:42', 1, '127.0.0.1'),
(15, 3, 1, 2, 14, 1861, 'Package Rate', 1, 1, '2021-12-20', '2021-12-31', 13, 'Value', 10, '2021-12-20', 1, 1, '2021-12-20 11:28:26', 2, '127.0.0.1'),
(16, 3, 1, 2, 14, 1861, 'Package Rate', 1, 1, '2021-12-20', '2021-12-31', 12, 'Value', 20, '2021-12-20', 1, 1, '2021-12-20 11:28:26', 0, '127.0.0.1'),
(17, 3, 1, 2, 14, 1861, 'Package Rate', 1, 1, '2021-12-20', '2021-12-31', 11, 'Value', 30, '2021-12-20', 1, 1, '2021-12-20 11:28:26', 0, '127.0.0.1'),
(23, 3, 1, 3, 8, 1673, 'Package Rate', 2, 4, '2021-12-20', '2021-12-31', 12, 'Value', 50, '2021-12-20', 1, 1, '2021-12-20 11:41:58', 0, '127.0.0.1'),
(24, 3, 1, 3, 8, 1673, 'Package Rate', 2, 4, '2021-12-20', '2021-12-31', 13, 'Value', 100, '2021-12-20', 1, 1, '2021-12-20 11:41:58', 2, '127.0.0.1'),
(25, 3, 1, 3, 8, 1673, 'Package Rate', 2, 4, '2021-12-20', '2021-12-31', 11, 'Value', 200, '2021-12-20', 1, 1, '2021-12-20 11:41:58', 0, '127.0.0.1'),
(26, 3, 1, 2, 8, 1673, 'Package Rate', 3, 3, '2021-12-20', '2021-12-21', 13, 'Value', 10, '2021-12-20', 1, 1, '2021-12-20 11:57:15', 1, '127.0.0.1');

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

--
-- Table structure for table `hotel_room_cancellation_fees_logs`
--

CREATE TABLE `hotel_room_cancellation_fees_logs` (
  `id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `vendor_type` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `rate_type` varchar(50) NOT NULL,
  `rate_type_id` int(11) NOT NULL DEFAULT '0',
  `rate_name_id` int(11) NOT NULL,
  `cancel_date_from` date NOT NULL,
  `cancel_date_to` date NOT NULL,
  `cancellation_master_id` int(11) NOT NULL,
  `cancellation_type` varchar(10) NOT NULL,
  `cancellation_value` float NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
