initial commit
[namibia] / data / old_b4c stuff / templates_sale_seller.sql
1 UPDATE `mig_db`.`lib_template` SET `tags` = 'first_name,family_name,vehicle,price,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email,seller,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email,stock_number', `email_template` = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
4  <head>
5         <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
6         <title></title>
7  </head>
8  <body style="padding:0;margin:0;">
9         <!-- Begin 100% Wrapping Table -->
10         <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
11                 <tr>
12                         <td style="padding:20px 0;">
13                                 <!-- Begin Main Template Table -->                                      
14                                 <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;">
15                                         <tr>
16                                                 <td>
17                                                 <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
18                                                 </td>
19                                         </tr>                           
20                                         <tr>
21                                                 <td style="background:#f6f6f6;padding:20px 0">
22                                                         <!-- Main Content table -->
23                                                         <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;">
24                                                                 <tr>
25                                                                         <!-- Spacing Column -->
26                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
27                                                                         <!-- Main Column -->
28                                                                         <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
29                                                                                 <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>
30                                                                                 <p style="margin:0 0 1em;padding:0;">
31                                                                                         &nbsp;
32                                                                                 </p>
33                                                                                 <p style="margin:0 0 1em;padding:0;">
34                                                                                         Hello [first_name] [family_name],
35                                                                                 </p>
36                      <p style="margin:0 0 1em;padding:0;">
37                        Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].
38                      </p>
39                      <p style="margin:0 0 1em;padding:0;">
40                        <b>Your responsibilities:</b>
41                        <ul>
42                          <li>Invoice vehicle.</li>
43                          <li>Send Natis, invoice and bank details.</li>
44                          <li>Have vehicle ready for collection.</li>
45                          <li>Print attachments.</li>
46                        </ul>
47                      </p>
48                      <p style="margin:0 0 1em;padding:0;">
49                        <b>Buyer:</b>
50                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
51                          <tr>
52                            <td width="80px"><b>Trading Name:</b></td>
53                            <td><b>[buyer]</b></td>
54                          </tr>
55                          <tr>
56                            <td width="80px"><b>Full Name:</b></td>
57                            <td><b>[buyer_name]</b></td>
58                          </tr>
59                          <tr>
60                            <td width="80px"><b>Physical Address:</b></td>
61                            <td><b>[buyer_address]</b></td>
62                          </tr>
63                          <tr>
64                            <td width="80px"><b>VAT Number:</b></td>
65                            <td><b>[buyer_vat_number]</b></td>
66                          </tr>
67                          <tr>
68                            <td width="80px"><b>Cellphone:</b></td>
69                            <td><b>[buyer_mobile]</b></td>
70                          </tr>
71                          <tr>
72                            <td width="80px"><b>E-mail:</b></td>
73                            <td><b>[buyer_email]</b></td>
74                          </tr>
75                        </table>
76                                            
77                                            
78                      </p>
79                                          
80                                          <br><br>
81                                          <p style="margin:0 0 1em;padding:0;">
82                        <b>Seller:</b>
83                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
84                          <tr>
85                            <td width="80px"><b>Trading Name:</b></td>
86                            <td><b>[seller]</b></td>
87                          </tr>
88                          <tr>
89                            <td width="80px"><b>Full Name:</b></td>
90                            <td><b>[seller_name]</b></td>
91                          </tr>
92                          <tr>
93                            <td width="80px"><b>Auction Address:</b></td>
94                            <td><b>[vehicle_address]</b></td>
95                          </tr>
96                          <tr>
97                            <td width="80px"><b>Billing Address:</b></td>
98                            <td><b>[seller_billing_address]</b></td>
99                          </tr>
100                          <tr>
101                            <td width="80px"><b>VAT Number:</b></td>
102                            <td><b>[seller_vat_number]</b></td>
103                          </tr>
104                          <tr>
105                            <td width="80px"><b>E-mail:</b></td>
106                            <td><b>[seller_email]</b></td>
107                          </tr>
108                                                   <tr>
109                            <td width="80px"><b>Stock Number:</b></td>
110                            <td><b>[stock_number]</b></td>
111                          </tr>
112                        </table>
113                      </p>
114                      <p style="margin:0 0 1em;padding:0;"><br/>
115                        Regards,<br/>
116                        The Bid4Cars Team
117                      </p>
118                                                                         </td>
119                                                                         <!-- Spacing Column -->
120                                                                         <td width="40" valign="top" style="width:40px;">&nbsp;</td>
121                                                                         <!-- Side Column -->
122                                                                         <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
123                                                                                 <img src="{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />
124                                                                                 <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>
125                                                                                 <p style="margin:0 0 1em;padding:5px;">
126                                                                                         Online technology bringing buyers and sellers
127                                                                                         together through the Dealer Network.
128                                                                                 </p>                    
129                                                                         </td>
130                                                                         <!-- Spacing Column -->
131                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
132                                                                 </tr>
133                                                         </table>
134                                                         <!-- /Main Content Table -->                    
135                                                 </td>           
136                                         </tr>
137                                         <tr>
138                                                 <td style="background:#ececec;padding:10px 0 0;">
139                                                         <!-- Begin Footer table -->
140                                                         <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">
141                                                                 <tr>
142                                                                         <!-- Spacing Column -->
143                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
144                                                                         <!-- Main Column -->
145                                                                         <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">
146                                                                                 <p style="margin:0 0 1em;padding:0;"><b>demo.bid4cars.co.za</b></p>
147                                                                         </td>
148                                                                         <!-- Spacing Column -->                                                         
149                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>
150                                                                 </tr>
151                                                         </table>
152                                                         <!-- /End Footer Table -->      
153                                                 </td>
154                                         </tr>                           
155                                 </table>
156                                 <!-- /End Main Template Table -->
157                         </td>
158                 </tr>
159         </table>
160  <!-- /End 100% Wrapping Table  -->     
161  </body>
162  </html>
163  ' WHERE `lib_template`.`id` = 6;