Blame view

account/func/func.eMailing.php 30.1 KB
42868d70   andryeyev   Создал GIT
1
  <?
c9ea832e   andryeyev   + что-то связано ...
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
   
  function sendMail ($to, $nameto, $from, $namefrom, $subject, $mailMessage, $files='') 
  {  
      // Âàø êëþ÷ äîñòóïà ê API (èç Ëè÷íîãî Êàáèíåòà)
      $api_key = "5xaiqb1pnuu8jsun4rwxhow4shj11e55zdhjf5do";
      
      // Ïàðàìåòðû ñîîáùåíèÿ
      // Åñëè ñêðèïò â êîäèðîâêå UTF-8, íå èñïîëüçóéòå iconv
      $email_from_name = "ExtremStyle";
      $email_from_email = "extremstyle.ua@eltrade.com.ua";
      $email_to = $to;
      $email_body = urlencode (iconv ('cp1251', 'utf-8', $mailMessage));
      
      $subject = iconv ('cp1251', 'utf-8', $subject);
      
      $email_body = iconv ('cp1251', 'utf-8', $mailMessage);
      
      $email_subject = $subject;
      $list_id = "1774752";
      
      // Ñîçäà¸ì POST-çàïðîñ
      $POST = array (
          'api_key' => $api_key,
          'email' => $email_to,
          'sender_name' => $email_from_name,
          'sender_email' => $email_from_email,
          'subject' => $email_subject,
          'body' => $email_body,
          'list_id' => $list_id 
      );
      
      // Óñòàíàâëèâàåì ñîåäèíåíèå
      $ch = curl_init ();
      curl_setopt ($ch, CURLOPT_RETURNTRANSFER, true);
      curl_setopt ($ch, CURLOPT_POST, 1);
      curl_setopt ($ch, CURLOPT_POSTFIELDS, $POST);
      curl_setopt ($ch, CURLOPT_TIMEOUT, 10);
      curl_setopt ($ch, CURLOPT_URL, 'http://api.unisender.com/ru/api/sendEmail?format=json');
      $result = curl_exec ($ch);
      
      if ($result)
      {
          // Ðàñêîäèðóåì îòâåò API-ñåðâåðà
          $jsonObj = json_decode ($result);
          
          if (null === $jsonObj)
          {
              // Îøèáêà â ïîëó÷åííîì îòâåòå
              echo "Invalid JSON";
          }
          elseif (! empty ($jsonObj->error))
          {
              // Îøèáêà îòïðàâêè ñîîáùåíèÿ
              echo "An error occured: " . $jsonObj->error . "(code: " . $jsonObj->code . ")";
          }
          else
          {
              // Ñîîáùåíèå óñïåøíî îòïðàâëåíî
              echo "Email message is sent. Message id " . $jsonObj->result->email_id;
          }
      }
      else
      {
          // Îøèáêà ñîåäèíåíèÿ ñ API-ñåðâåðîì
          echo "API access error";
      } 
42868d70   andryeyev   Создал GIT
68
  }
c9ea832e   andryeyev   + что-то связано ...
69
70
71
72
73
74
75
76
77
78
79
   
  function sendMailPhp ($to, $nameto, $from, $namefrom, $subject, $mailMessage, $files='') { // $files = array('archive.zip' => file_get_contents('archive.zip')
      
      if (is_array ($files) && (! empty ($files)))
      {
          $ContentType = "Content-Type: multipart/mixed;";
      }
      else
      {
          $ContentType = "Content-Type: multipart/alternative;";
      }
42868d70   andryeyev   Создал GIT
80
81
82
83
84
85
86
87
88
      
      $boundary = strtoupper(md5(uniqid(rand())))."";
  
      $headers  = "Date: ".date('Y-m-d H:i:s')." +0200 \r\n";
      $headers .= "From: ".MimeEncode($namefrom)." <$from> \r\n";
      $headers .= "Return-Path: ".MimeEncode($namefrom)." <$from>\r\n";
      $headers .= "MIME-Version: 1.0" . "\r\n";
  	$ContentType = "Content-type: text/html;";
      $headers .= "$ContentType boundary=\"{$boundary}\"; \r\n";
c9ea832e   andryeyev   + что-то связано ...
89
90
91
      $headers.=  "Content-type: text/html; charset=\"windows-1251\";\r\n\r\n"; 
      $body =  "--{$boundary}\r\n";
      $body.=  "Content-type: text/html; charset=\"windows-1251\";\r\n\r\n";
42868d70   andryeyev   Создал GIT
92
      $body.=  $mailMessage."\r\n";
c9ea832e   andryeyev   + что-то связано ...
93
94
95
96
97
98
99
      $headers = "From: ".MimeEncode($namefrom)." <$from>\r\n X-Mailer: PHP/" . phpversion();
          
      // Äëÿ âëîæåíèõ ôàéëîâ
      if ((is_array ($files)) && (! empty ($files)))
      {
          foreach ($files as $filename => $filecontent)
          {
42868d70   andryeyev   Создал GIT
100
101
102
103
104
105
106
107
108
109
             $body .= "--{$boundary}\r\n";
             $body .= "Content-Type: application/octet-stream;name=\"".$filename."\" \r\n";
             $body .= "Content-Transfer-Encoding:base64 \r\n";
             $body .= "Content-Disposition:attachment;filename=\"".$filename."\" \r\n";
             $body .= chunk_split(base64_encode($filecontent));
          }
      }
      
      $body .= "\r\n--{$boundary}--\r\n";
      
c9ea832e   andryeyev   + что-то связано ...
110
  	mail(" ".MimeEncode($nameto)." <$to>", MimeEncode($subject), $body, $headers); 
42868d70   andryeyev   Создал GIT
111
112
  }
  
c9ea832e   andryeyev   + что-то связано ...
113
114
115
116
117
118
119
  function MimeEncode ($str, $data_charset = 'windows-1251', $send_charset = 'windows-1251')
  {
      if (! empty ($str))
      { 
          if ($data_charset != $send_charset)
          {
              $str = iconv ($data_charset, $send_charset, $str);
42868d70   andryeyev   Создал GIT
120
121
          }
          
c9ea832e   andryeyev   + что-то связано ...
122
123
124
125
126
127
          return '=?' . $send_charset . '?B?' . base64_encode ($str) . '?=';
      }
      else
      {
          return '';
      }
42868d70   andryeyev   Создал GIT
128
  }
c9ea832e   andryeyev   + что-то связано ...
129
   
35532d37   andryeyev   - купон больше пр...
130
131
132
133
134
135
136
  function eMailing ($action, $user_id='',$order_id='',$discont_id='') 
  {
      switch ($action) 
      {
          // =====================
          // ==== ðåãèñòðàöèÿ ====
          // =====================
42868d70   andryeyev   Создал GIT
137
  
35532d37   andryeyev   - купон больше пр...
138
          case 'reg':
42868d70   andryeyev   Создал GIT
139
140
141
  
              global $_POST;
              
c9ea832e   andryeyev   + что-то связано ...
142
143
144
145
146
147
148
149
150
151
              $sql = "
                  SELECT * 
                  FROM zlo_users 
                  WHERE email = '".$_POST['form']['email']."'
              ";
  
              $result = mysql_query ($sql) or die (mysql_error ());
              if (mysql_affected_rows () != 0)
              {
                  $user = mysql_fetch_assoc ($result);
42868d70   andryeyev   Создал GIT
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
              }
  
              $subject = "Ðåãèñòðàöèÿ íà ñàéòå ïîëüçîâàòåëÿ : ".$user['username'];
  
              $mail = "
  
              Çäðàâñòâóéòå, ".$user['username']." ! <br/><br/>
  
              Âû óñïåøíî çàðåãèñòðèðîâàëèñü â íàøåì ìàãàçèíå <br/>
  			äëÿ ïîäòâåðæäåíèÿ ðåãèñòðàöèè ïåðåéäèòå ïî ññûëêå: <a href='http://extremstyle.ua/account/active/?hash=".$user['hash']."'>http://extremstyle.ua/?hash=".$user['hash']."</a>
              <br/>Äëÿ âõîäà â <a href='http://extremstyle.ua/'>ëè÷íûé êàáèíåò</a> èñïîëüçóéòå ñëåäóþùèå äàííûå:
              <br/>
              <br/>
              <blockquote>
                <blockquote>
                              ËÎÃÈÍ: ".$user['email']." <br/>
                              ÏÀÐÎËÜ: ".$user['pass']."
                </blockquote>
              </blockquote>				
  			<br/>
c9ea832e   andryeyev   + что-то связано ...
172
173
              <br/>";
  
42868d70   andryeyev   Создал GIT
174
175
176
              ///////////<b>Àêòèâàöèÿ äèñêîíòíîé êàðòû:</b> http://extremstyle.ua/account/activation/?uid=".$user['id']."&id=".$discont_id."
              $mail .= "
              Æåëàåì ïðèÿòíûõ ïîêóïîê!	<br/><br/>";
c9ea832e   andryeyev   + что-то связано ...
177
178
179
180
  
              if ($user['group'] != 1)
              {
                  // ïèñüìî ðåãèñòðàöèè
42868d70   andryeyev   Создал GIT
181
                  sendMail ($user['email'], $user['username'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
c9ea832e   andryeyev   + что-то связано ...
182
183
184
  
                  // ïèñüìî êóïîí
                  eMailing ('kupon', $user['id']);
42868d70   andryeyev   Создал GIT
185
              }
c9ea832e   andryeyev   + что-то связано ...
186
   
42868d70   andryeyev   Создал GIT
187
188
              // Ðàññûëêà óâåäîìëåíèé àäìèíàì
              $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
c9ea832e   andryeyev   + что-то связано ...
189
190
191
              $result = mysql_query ($sql) or die (mysql_error ());
              while ($admin = mysql_fetch_assoc ($result))
              {
42868d70   andryeyev   Создал GIT
192
193
                  sendMail ($admin['email'], $admin['username'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
42868d70   andryeyev   Создал GIT
194
  
35532d37   andryeyev   - купон больше пр...
195
              break;
42868d70   andryeyev   Создал GIT
196
  
c9ea832e   andryeyev   + что-то связано ...
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
          // ===============
          // ==== Êóïîí ====
          // ===============
              
          case 'kupon': 
    
              // ïîëüçîâàòåëü
              $sql = '
                  SELECT * 
                  FROM zlo_users 
                  WHERE `id` = '.(int)$user_id.' 
                  LIMIT 1
              '; 
  
              $result = mysql_query ($sql) or die (mysql_error ());
              if (mysql_affected_rows () != 0)
              {
                  $user = mysql_fetch_assoc ($result); 
                  
                  // êóïîí
                  $sql = '
                      SELECT `card`, `active`, `id` 
                      FROM `card` 
                      WHERE `user_id` = '.$user['id'].' 
                      LIMIT 1
                  ';
                  
                  $result = mysql_query ($sql) or die (mysql_error ());
                  if (mysql_affected_rows () != 0)
                  { 
                      $card = mysql_fetch_assoc ($result);
      
                      $to      = $user['email'];
                      $subject = 'Êëóáíàÿ êàðòà "Ýêñòðåì Ñòàéë"';
   
                      // ïèñüìî
                      ob_start();
                      include_once $_SERVER['DOCUMENT_ROOT'].'/email/discont.php';
                      $message = ob_get_clean();
42868d70   andryeyev   Создал GIT
236
  
c9ea832e   andryeyev   + что-то связано ...
237
238
239
                      // îòñûëàåì
                      sendMail ($to, $to, "extremstyle.ua@eltrade.com.ua", "ExtremStyle", $subject, $message); 
                  }
42868d70   andryeyev   Создал GIT
240
241
              }
              
c9ea832e   andryeyev   + что-то связано ...
242
243
              break;
  
35532d37   andryeyev   - купон больше пр...
244
245
246
247
248
          // =====================
          // ==== Íîâûé çàêàç ====
          // =====================
              
          case 'order-new': 
42868d70   andryeyev   Создал GIT
249
250
251
252
253
254
255
256
257
258
259
260
261
262
          
              global $lang;
  
              // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT * FROM zlo_users WHERE id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              // óçíàåì âñå äàííûå î çàêàçå
              $sql = "SELECT * FROM catalogs_orders WHERE `id`=$order_id";
              $result = mysql_query($sql) or die(mysql_error());
              $order=mysql_fetch_assoc($result);
  
  
35532d37   andryeyev   - купон больше пр...
263
264
265
266
267
268
269
270
271
272
              
              $tel = str_replace("+","",$order['phone']);
              
              if(trim($tel)=='') $tel = $user['tel'];
              
              //echo $tel;
              //exit;
              //$tel = "380969670748";
              sendSMS($tel,"Vash zakaz Prinyat. # zakaza:".$order_id.". V blijayshee vremya menedjer svyajetsya s Vami. (044) 428-65-38; (050) 382-03-00");
              
42868d70   andryeyev   Создал GIT
273
274
275
276
277
  
  
              $subject = "Íîâûé çàêàç íà ñàéòå extremstyle.ua - ïîëüçîâàòåëü : ". $user['username']; 
  
              // Ïîäêëþ÷àåì ñòèëè
c9ea832e   andryeyev   + что-то связано ...
278
279
280
               
              $sql = "
              SELECT distinct s3.id, s5.name as fio, s4.translit as rub_name, s3 . *
35532d37   andryeyev   - купон больше пр...
281
              FROM catalogs_orders_products s1
c9ea832e   andryeyev   + что-то связано ...
282
283
284
285
                  LEFT JOIN catalogs_modifications s2 ON s2.id = s1.product_id
                  LEFT JOIN catalogs_products s3 ON s3.id = s2.product_id
                  LEFT JOIN catalogs_rubrics s4 ON s4.id = s3.rubric_id 
                  LEFT JOIN catalogs_orders s5 ON s5.id = s1.order_id 
35532d37   andryeyev   - купон больше пр...
286
              WHERE s1.order_id = '".$order_id."';";
42868d70   andryeyev   Создал GIT
287
288
289
290
              $result = mysql_query($sql) or die(mysql_error());
  			$datas = "";
              while ($product2 = mysql_fetch_assoc($result)){
  				$datas .= "<table width=\"300px\">
35532d37   andryeyev   - купон больше пр...
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
                  <tr>
                  <td>
                  <a href=\"https://plus.google.com/share?url=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                    '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\"><img
                    src=\"http://extremstyle.ua/img/32/googleplus_32.png\" alt=\"Share on Google+\" width=\"32px\" height=\"32px\"/></a>
                  </td>
                  <td>
                  <a href=\"http://vkontakte.ru/share.php?url=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                    '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\">
                  <img
                    src=\"http://extremstyle.ua/img/32/vkontakte_32.png\" alt=\"Share on VK\" width=\"32px\" height=\"32px\"/>
                  </a>
                  
                  </td>
                  <td><a href=\"http://www.facebook.com/sharer.php?u=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                    '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\">
                  <img
                    src=\"http://extremstyle.ua/img/32/facebook_32.png\" alt=\"Share on FB\" width=\"32px\" height=\"32px\"/>
                  </a></td>
                  </tr>
                  </table>";
42868d70   andryeyev   Создал GIT
312
313
314
315
316
  			}
  
              
              $mail= '
  
35532d37   andryeyev   - купон больше пр...
317
318
319
320
321
              <html>
              <meta content="text/html; charset=windows-1251" http-equiv="content-type" />
              <img src="http://extremstyle.ua/p301.png">
              <br/>
              <br/>            
42868d70   andryeyev   Создал GIT
322
323
324
325
  			Çäðàâñòâóéòå,'. $user['username'].'!<br/><br/>
  			<b>Âàøà çàÿâêà ïðèíÿòà.<br/>
              Äëÿ ïîäòâåðæäåíèÿ çàêàçà íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.</b><br/><br/>';
  
35532d37   andryeyev   - купон больше пр...
326
327
              if(!@ShowOrder($user_id, $order_id, $mail)) return false;
              
3eaa9da4   andryeyev   + Правки текста в...
328
329
330
331
              $mail= ShowOrder($user_id, $order_id, $mail);
  
  			$mail.=" 
  			Ñòîèìîñòü äîñòàâêè:<br />
35532d37   andryeyev   - купон больше пр...
332
333
334
              - åñëè ñóììà çàêàçà ìåíüøå 1000 ãðí. - äîñòàâêà ñòîèò 30 èëè 50 ãðí. â çàâèñèìîñòè îò ãàáàðèòîâ.<br />
              - åñëè ñóììà çàêàçà ðàâíà èëè áîëüøå 1000 ãðí. - äîñòàâêà ïî Êèåâó áåñïëàòíàÿ.<br />
              <br />
3eaa9da4   andryeyev   + Правки текста в...
335
336
              Ïðè çàêàçå íà ñóììó áîëåå 1000 ãðí - äîñòàâêà ïî Óêðàèíå íà ñêëàä Íîâîé Ïî÷òû áåñïëàòíàÿ (êðîìå íàëîæåííîãî ïëàòåæà, àêöèîííûõ òîâàðîâ è òîâàðîâ ñî ñêèäêîé).
  			<br /><br />
42868d70   andryeyev   Создал GIT
337
338
339
340
341
342
  			Ïðèñîåäèíÿéòåñü ê íàì:
  			".$datas."
  
  			<br />
  			Ñ óâàæåíèåì, êîìàíäà <font color='green'>Extremstyle.ua</font><br /><br />
  			Äàííîå ïèñüìî ñîçäàíî àâòîìàòè÷åñêè, ïîæàëóéñòà íå îòâå÷àéòå íà íåãî.";
c9ea832e   andryeyev   + что-то связано ...
343
   
42868d70   andryeyev   Создал GIT
344
345
346
347
348
349
350
351
352
353
354
355
356
              if ($user['group']!=1) {
                  sendMail ($user['email'], $user['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
              // Ðàññûëêà óâåäîìëåíèé àäìèíàì
              $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
              $result = mysql_query($sql) or die(mysql_error());
              while ($admin=mysql_fetch_assoc($result)) {
                  sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
              
              eMailing('xml', $user_id, $order_id); 
              
          break;
35532d37   andryeyev   - купон больше пр...
357
358
359
360
          
          // =======================
          // ==== Çàêàç èçìåíåí ====
          // =======================
42868d70   andryeyev   Создал GIT
361
  
35532d37   andryeyev   - купон больше пр...
362
          case 'order-changed': 
42868d70   andryeyev   Создал GIT
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
          
              global $lang;
  
              // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT * FROM zlo_users WHERE id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              // óçíàåì âñå äàííûå î çàêàçå
              $sql = "SELECT * FROM catalogs_orders WHERE `id`=$order_id";
              $result = mysql_query($sql) or die(mysql_error());
              $order=mysql_fetch_assoc($result);
  
              $subject = "Îáíîâëåííûé çàêàç íà ñàéòå extremstyle.ua - ïîëüçîâàòåëü : ". $user['username']; 
  
              $mail = "
  
              Çäðàâñòâóéòå,". $user['username']."!<br/><br/>
  
              Âàø Îáíîâëåííûé çàêàç";
              
              $mail=ShowOrder($user_id, $order_id, $mail);
                          
              $mail.="Íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.<br/>
              Äåòàëüíóþ èíôîðìàöèþ è ñîñòîÿíèå çàêàçà Âû ìîæåòå ïðîâåðèòü â http://extremstyle.ua/account/ <br/><br/>
  
              Ñïàñèáî, ÷òî âûáðàëè íàñ! <br/><br/>
  
              ";
  
              if ($user['group']!=1) {
                  sendMail ($user['email'], $user['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
              // Ðàññûëêà óâåäîìëåíèé àäìèíàì
              $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
              $result = mysql_query($sql) or die(mysql_error());
              while ($admin=mysql_fetch_assoc($result)) {
                  sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
              
35532d37   andryeyev   - купон больше пр...
403
404
405
406
407
408
              break;
             
          // =============
          // ==== xml ====
          // =============
          
42868d70   andryeyev   Создал GIT
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
          case 'xml':
  
              // Äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u 
                      WHERE u.id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              // Äàííûå î çàêàçå
              $sql = "SELECT o.*,o.id as order_id, o.adress as address, d.title as delivery_title FROM catalogs_orders as o
                      LEFT JOIN zlo_users as u on u.id=o.user_id
                      LEFT JOIN zlo_book_delivery as d ON o.delivery=d.id
                      WHERE o.id='$order_id'";
              $result = mysql_query($sql) or die(mysql_error());
              $order=mysql_fetch_assoc($result); 
              
              // Äàííûå î òîâàðå
              $sql = "SELECT m.*, m.id as mod_id, p.* from catalogs_modifications as m
                      LEFT JOIN catalogs_products as p ON p.id=m.product_id 
                      LEFT JOIN catalogs_orders_products as op ON op.order_id=$order_id 
                      WHERE m.id= op.product_id ";
              $result = mysql_query($sql) or die(mysql_error());
              
                  $xml  = "<?xml version='1.0' encoding='windows-1251' ?>\n";
                  $xml .= "<Order orderNum='".$order['mktime']."'>\n";
                  
                  while ($item=mysql_fetch_assoc($result)) {
                  
                  $xml .= "   <OrderItem ID='".$item['code']."'>\n";
                  $xml .= "       <ProductName>".$item['name']."</ProductName>\n";
                  $xml .= "       <Size>".$item['size']."</Size>\n";
                  $xml .= "       <Color>".$item['color']."</Color>\n";
                  $xml .= "       <Price>".$item['cine']."</Price>\n";
                  $xml .= "       <Count>".$item['count']."</Count>\n";
                  $xml .= "   </OrderItem>\n";
                  
                  }
                  $xml .= "   <CustomerInfo>\n";
                  $xml .= "       <Name>".$user['username']."</Name>\n";
                  $xml .= "       <Mobile>".$user['tel']."</Mobile>\n";
                  $xml .= "       <Email>".$user['email']."</Email>\n";
                  $xml .= "   </CustomerInfo>\n";
                  $xml .= "   <DeliveryInfo>\n";
                  $xml .= "       <City>Óêðàèíà</City>\n";
                  $xml .= "       <Address>".$order['address']."</Address>\n";
                  $xml .= "       <DeliveryType>".$order['delivery_title']."</DeliveryType>\n";
                  $xml .= "   </DeliveryInfo>\n";
                  $xml .= "   <Comment>".$order['comment']."</Comment>\n";
                  $xml .= "</Order>\n";
                  
                  // ======== ñîçäàíèå xml-àðõèâà =======
                  
                  // Ðàçáèâàåì íà ãîä è ìåñÿö çàêàçà
                  $dateFromDate=ExtractDate((date('Y-m-d H:i:s',$order['mktime'])));
                  
                  // Ñîáèðàåì ïóòü è ôàéë
                  $filePath = "./xml/".$dateFromDate[0]."/".$dateFromDate[1]."/";
                  $fileName = "order_".$order['order_id'].".xml";
                  
                  // Ñîçäàåì ïàïêó
                      $root=$_SERVER['DOCUMENT_ROOT'];
                      
                  if (!is_dir($root."/xml/".$dateFromDate[0])) {
                      mkdir($root."/xml/".$dateFromDate[0], 0777, true);
                      chmod($root."/xml/".$dateFromDate[0], 0777);
                  }
                  
                  if (!is_dir($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1])) {
                      mkdir($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1], 0777, true);  
                      chmod($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1], 0777);
                  }
  
                  // Îòêðûòü ôàéë
                  $fh = fopen($filePath.$fileName, "w+");
  
                  // Çàïèñàòü ñîäåðæèìîå â ôàéë
                  fwrite($fh, $xml);
  
                  // Çàêðûòü ôàéë
                  fclose($fh); 
                  
                  $mail="<p>Çàêàç <b>¹ $order_id</b></p>
                         Ïîëüçîâàòåëÿ: {$user['username']}";
                  
                  $files = array($fileName => file_get_contents($filePath.$fileName));
  
              // Ðàññûëêà óâåäîìëåíèé àäìèíàì
              $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
              $result = mysql_query($sql) or die(mysql_error());
              while ($admin=mysql_fetch_assoc($result)) {
                  sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', "XML Çàêàç ¹ {$order_id} Ïîëüçîâàòåëÿ: {$user['username']}", $mail, $files);
              }
              
          break;
          
35532d37   andryeyev   - купон больше пр...
504
505
506
507
508
          // ============================
          // ==== Íàïîìèíàíèå ïàðîëÿ ====
          // ============================
          
          case 'remind': 
42868d70   andryeyev   Создал GIT
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
  
              // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT * FROM zlo_users as u WHERE u.id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              $subject = "Íàïîìèíàíèå ïàðîëÿ ïîëüçîâàòåëÿ : ".$user['username'];
  
              $mail = "
  
              Çäðàâñòâóéòå, ".$user['username']." !
              <br/>
              <br/>
              Äëÿ âõîäà â ëè÷íûé êàáèíåò èñïîëüçóéòå ñëåäóþùèå äàííûå:
              <br/>
              <br/>
              <blockquote>
                <blockquote>
  
                              ËÎÃÈÍ: ".$user['email']."<br/>
                              ÏÀÐÎËÜ: ".$user['pass']."
                </blockquote>
              </blockquote>				
              <br/>					
              <br/>
              <br/>
              Æåëàåì ïðèÿòíûõ ïîêóïîê!<br/>
              <br/>
              <br/>
              email:info@extremstyle.ua";	
              
              sendMail ($user['email'], $user['username'], 'remind@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              
              break;
c9ea832e   andryeyev   + что-то связано ...
543
544
545
546
547
548
  
          // =======================
          // ==== MessageToUser ====
          // =======================
  
          case 'MessageToUser':
42868d70   andryeyev   Создал GIT
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
  
              // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u 
                      WHERE u.id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              $subject = "Óâåäîìëåíèå î ïîëó÷åíèè ïèñüìà îò àäìèíèñòðàöèè extremstyle.ua";
  
              $mail = "
  
              Çäðàâñòâóéòå, ".$user['username']." !
              <br/>
              <br/>
                 <blockquote>
                    <blockquote>
                      Âû ïîëó÷èëè ïèñüìî îò àäìèíèñòðàöèè ñàéòà extremstyle.ua
                    </blockquote>
                  </blockquote>
              <br/>
              <br/>
              
              Äëÿ ïðî÷åíèÿ ïåðåéäèòå â Âàø ëè÷íûé êàáèíåò ïî <a href='http://extremstyle.ua/'>ññûëêå</a>";	
              
              sendMail ($user['email'], $user['username'], 'mail-notify@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              
              break;
c9ea832e   andryeyev   + что-то связано ...
576
577
578
579
580
581
  
          // ========================
          // ==== MessageToAdmin ====
          // ========================
  
          case 'MessageToAdmin':
42868d70   andryeyev   Создал GIT
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
  
              // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
              $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u 
                      WHERE u.id=$user_id";
              $result = mysql_query($sql) or die(mysql_error());
              $user=mysql_fetch_assoc($result);
              
              // Âûâîä message
              $sql = "SELECT text FROM zlo_users_message WHERE `from` = '$user_id' ORDER BY `date` DESC LIMIT 1";
              $result = mysql_query($sql) or die(mysql_error());
              $message=mysql_fetch_assoc($result);	
              
              $subject = "Óâåäîìëåíèå î ïîëó÷åíèè ïèñüìà îò ïîëüçîâàòåëÿ ".$user['username']." ";
  
              $mail = "
  
              Çäðàâñòâóéòå !
              <br/>
              <br/>
                 <blockquote>
                    <blockquote>
                      Âû ïîëó÷èëè ïèñüìî îò ".$user['username']."
                    </blockquote>
                  </blockquote>
              <br/>
              ".$user['username']." íàïèñàë(à):
              <pre>
              ".$message['text']."
              </pre>";	
              
              // Ðàññûëêà óâåäîìëåíèé àäìèíàì
              $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
              $result = mysql_query($sql) or die(mysql_error());
              while ($admin=mysql_fetch_assoc($result)) {
                  sendMail ($admin['email'], $admin['username'], 'mail-notify@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
              }
              
              break;
              
      }
  }
  
  /////////////////////////////////////////////////////////////////////////////////
  
  function ShowOrder($user_id, $order_id, $mail) {
  
              $sql = "SELECT o.*,u.*, o.id as order_id, o.`mktime` as order_date".((@$_SESSION['id'])?", o.address as address_o":"")." FROM catalogs_orders as o
                      RIGHT JOIN zlo_users as u on u.id=o.user_id
                      WHERE o.id='$order_id'";
              $result = mysql_query($sql) or die(mysql_error());	
  
  //if(trim($order['total'])<=0) return false;
  
              if (mysql_affected_rows()!=0) {
                  $order=mysql_fetch_assoc($result);
  
  if(trim($order['address_o'])!='') $order['address'] = $order['address_o'];
  
  
              if(trim($order['total'])<=0) return false;
  			
  				$mail.="Çàÿâêå ïðèñâîåí íîìåð: ".$order['order_id']."<br />
  						Áóäåì ðàäû îòâåòèòü íà âàøè âîïðîñû ïî òåëåôîíàì:<br /> (044) 428-65-38; (050) 382-03-00<br /><br />";
                  /*
  				$mail.="<div class='orders'>";
                  
                  $mail.="
                  <fieldset id='order-info' style='width:500px;'>
                  <legend>Çàêàç #".$order['order_id']." Cóììà: ".$order['total']." ãðí.</legend> 	
                  <table class='order-info'>
                      <tr>
                          <td>Äàòà:</td>
                          <td class=info>".date('Y-m-d H:i:s',$order['order_date'])."</td>
                      </tr>
                      
                      <tr>
                          <td>Êëèåíò:</td>
                          <td class=info>".$order['username']."&nbsp;</td>
                      </tr>
                      
                      <tr>
                          <td>Òåë:</td>
                          <td class=info>".$order['tel']."&nbsp;</td>
                      </tr>
  
                      <tr>
                          <td>Ãîðîä:</td>
                          <td class=info>".$order['city']."&nbsp;</td>
                      </tr>
  					
                      <tr>
                          <td>Àäðåñ:</td>
                          <td class=info>".$order['address']."&nbsp;</td>
                      </tr>
                      
                      <tr>
                          <td>Äîñòàâêà:</td>
                          <td class=info>".viewBook('zlo_book_delivery', $order['delivery'], 'id', 'title')."&nbsp;</td>
                      </tr>
  
                      <tr>
                          <td>Èíôî:</td>
                          <td class=info> ".$order['comment']."&nbsp;</td>
                      </tr>
                      "; 
                      
                  $mail.="
                  </fieldset>
                  </table>
                  
                  <p></p><p></p>
                  ";*/
                  
                  
                  // Òàáëèöà òîâàðîâ
  
                  $sql3 = "SELECT * FROM catalogs_orders_products
                           WHERE `order_id`='".$order['order_id']."' ";
                  $result3 = mysql_query($sql3) or die(mysql_error());
                  if (mysql_affected_rows()!=0) { $i=0;
                  
                  $mail.="<img src='http://extremstyle.ua/img/hr_m.jpg' border='0' />
                      <div class='order-details'>
                      <b>Âàø çàêàç:</b>";
                  $mail.="<table>";
                        /*$mail.="<tr>
                          <td>¹</td>
                          <td>ôîòî</td>
  						<td>Êîä</td>
                          <td>Áðåíä</td>
                          <td>Íàçâàíèå</td>
                          <td>Êîë.</td>
                          <td>Öåíà</td>
                          <td>Ñóììà</td>
                          <td></td>
                        </tr>";*/
                  while ($item_id=mysql_fetch_assoc($result3)) { $i++;
                  
                      $sql4 = "select *,catalogs_modifications.pic as m_pic from catalogs_modifications 
                              left join catalogs_products 
                              on catalogs_products.id=catalogs_modifications.product_id 
                              where catalogs_modifications.id='".$item_id['product_id']."' ";
                      $result4 = mysql_query($sql4) or die(mysql_error());
                      if (mysql_affected_rows()!=0) {	
                      while ($item=mysql_fetch_assoc($result4)) { 
  
                      /* $mail.="<tr>
                              <td>$i .</td> 
  							<td><img src='http://extremstyle.ua/uploaded/pic/catalogs/modifications/".$item['m_pic']."' border='0' /></td>
                              <td>".$item['code']."</td>          
                              <td>".viewBook('catalogs_brends', $item['brend_id'], 'id', 'name')."</td>
                              <td><a href='http://extremstyle.ua/catalogs/".$item['rubric_id'].'/t'.$item['id']."/' target='_new'>".$item['name']."</a></td>
                              <td>".$item_id['count']."</td>
                              <td>".$item['cine']."</td>  
                              <td>".($item['cine']*$item_id['count'])."</td>
                              <td>";
  
                         $mail.="</td>
                            </tr>";*/
  						  $mail.="<tr>
  						  <td><img src='http://extremstyle.ua/uploaded/pic/catalogs/modifications/".$item['m_pic']."' border='0' /></td>
  						  <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
  						  <td width='200'>
  							<a href='http://extremstyle.ua/catalogs/".$item['rubric_id'].'/t'.$item['id']."/' target='_new' style='font-size:18px;color:#589a42;'>".$item['name']."</a><br />
  						  <b>".($item_id['product_cine_id']*$item_id['count'])."</b> ãðí.<br />
  						  Êîë-âî: ".$item_id['count']."
  						  </td>
  						  <td width='200'><b>
  						  Êîä: ".$item['code']."<br />
  						  Ðàçìåð: ".$item['size']."<br />
  						  Öâåò: ".$item['color']."<br />
  						  </b></td>
  						  </tr>";
  
                          }          
                      
                      }
                  }
                  
                  $mail.="</table>
                     </div><img src='http://extremstyle.ua/img/hr_mb.jpg' border='0' />";
                     
                  $mail.="<br />
  				Ìîáèëüíûé òåëåôîí: ".$order['phone']."<br />
  				Àäðåñ äîñòàâêè: ".$order['adress']."<br />
  				Ñïîñîá îïëàòû: ".$order['payment']."<br />
  				Ñïîñîá äîñòàâêè: ".viewBook('zlo_book_delivery', $order['delivery'], 'id', 'title')."<br />
  				Ñòîèìîñòü çàêàçà: ".$order['total']."<br /><br />
  				";
  				
  				
                  }
              
              }
              
              $dostavka=viewBook('zlo_book_delivery', $order['delivery'], 'id', 'value');//Ñòîèìîñòü äîñòàâêè: UAH ".$dostavka."<br/>
              $dostavka=0;
              
            /*  $mail.= "
              <br/><br/>
                      Îáùàÿ ñóììà çàêàçà: UAH ".($order['total']+$dostavka)."
              <br/><br/>";*/
              
      return $mail;
  }
  ?>