Git Repository Public Repository

namibia

URLs

Copy to Clipboard
 
c449ac80b48405f72fd700d5cd406397b3a17d8a
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
INSERT INTO `mig_db`.`lib_template` (`name`, `subject`, `tags`, `email_template`) 
VALUES 
('new-public-to-priceguide', 
'Vehicle submitted to Dealer network', 
'firstName,familyName,year,make,model,type,regNo', 
'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 <head>
 	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
 	<title></title>
 </head>
 <body style="padding:0;margin:0;">
 	<!-- Begin 100% Wrapping Table -->
 	<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
 		<tr>
 			<td style="padding:20px 0;">
 				<!-- Begin Main Template Table -->
 				<table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">
 					<tr>
 						<td>
 						<img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
 						</td>
 					</tr>
 					<tr>
 						<td style="background:#f6f6f6;padding:20px 0">
 							<!-- Main Content table -->
 							<table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
 								<tr>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 									<!-- Main Column -->
 									<td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
 										<h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Vehicle submitted to Dealer network</h1>
 										<p style="margin:0 0 1em;padding:0;">
 											&nbsp;
 										</p>
 										<p style="margin:0 0 1em;padding:0;">
 											Dear <strong>[firstName] [familyName] </strong>,
 										</p>
 										<p stayle="margin:0 0 1em;padding:0;">
 											We would like to confirm you that your vehicle details was verified and sent to our dealer network.
 											We will revert back to you after 24 hours with an Offer on Valuation.
 										</p>
 
 										<div style="float:left; width:100%">
 											<strong style="width:60px; display:block; float:left">Year:</strong> [year]
 										</div>
 										<div style="float:left; width:100%">
 											<strong style="width:60px; display:block; float:left">Make:</strong> [make]
 										</div>
 										<div style="float:left; width:100%">
 											<strong style="width:60px; display:block; float:left">Model:</strong> [model]
 										</div>
 										<div style="float:left; width:100%">
 											<strong style="width:60px; display:block; float:left">Type:</strong> [type]
 										</div>
 										<div style="float:left; width:100%">
 											<strong style="width:60px; display:block; float:left">Reg No:</strong> [regNo]
 										</div>
 									
 										<div style="float:left; width:100%">
 										<br>
 										</div>
 										<div style="float:left; width:100%">
 										<strong>Offer will only be confirmed after the vehicle has been physically inspected by Bid4Cars</strong>
 										<br/><br/>
 										Kind Regards,<br/>
 										The Bid4Cars Team
 										</div>
 
 									</td>
 									<!-- Spacing Column -->
 									<td width="40" valign="top" style="width:40px;">&nbsp;</td>
 									<!-- Side Column -->
 									<td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
 										<img src="{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;display:block;float:none;" />
 										<br></br>
 										<h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>
 										<p style="margin:0 0 1em;padding:5px;">
 											Online technology bringing buyers and sellers
 											together through the Dealer Network.
 										</p>
 									</td>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 								</tr>
 							</table>
 							<!-- /Main Content Table -->
 						</td>
 					</tr>
 					<tr>
 						<td style="background:#ececec;padding:10px 0 0;">
 							<!-- Begin Footer table -->
 							<table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
 								<tr>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 									<!-- Main Column -->
 									<td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">
 										<p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>
 									</td>
 									<!-- Spacing Column -->
 									<td width="380" valign="top" align="right" style="width:380px;">
 										&nbsp;
 									</td>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 								</tr>
 							</table>
 							<!-- /End Footer Table -->
 						</td>
 					</tr>
 				</table>
 				<!-- /End Main Template Table -->
 			</td>
 		</tr>
 	</table>
 <!-- /End 100% Wrapping Table  -->
 </body>
 </html>
 ');

Commits for namibia/data/old_b4c stuff/new-public-to-priceguide.sql

Diff revisions: vs.
Revision Author Commited Message
df0489 ... Mark Fri 14 Oct, 2016 10:01:00 +0000

initial commit