Administrator / extrem

<?

function sendMail ($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;"; }
    
    $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";
    $headers .= "$ContentType boundary=\"{$boundary}\"; \r\n";

    $body =  "--{$boundary}\r\n";
    $body.=  "Content-type: text/html; charset=\"windows-1251\";\r\n\r\n";
    $body.=  $mailMessage."\r\n";
            
    // Äëÿ âëîæåíèõ ôàéëîâ 
    
    if ((is_array($files))&&(!empty($files))){
        foreach($files as $filename => $filecontent){
           $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";
    
	mail(" ".MimeEncode($nameto)." <$to>", MimeEncode($subject), $body, $headers);

}

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);
        }
        
        return '=?' . $send_charset . '?B?' . base64_encode($str) . '?=';
        
    } else { return '';}
}


function eMailing ($action, $user_id='',$order_id='') {

    switch ($action) {
        
        case 'reg':	// ===================[ Îòïðàâêà ðååñòðàöèè ]=========================

            global $_POST;
            
            $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);
            }

            $subject = "Ðåãèñòðàöèÿ íà ñàéòå ïîëüçîâàòåëÿ : ".$user['username'];

            $mail = "

            Çäðàâñòâóéòå, ".$user['username']." ! <br/><br/>

            Âû óñïåøíî çàðåãèñòðèðîâàëèñü â íàøåì ìàãàçèíå <br/>
            Äëÿ âõîäà â <a href='http://extremstyle.ua/'>ëè÷íûé êàáèíåò</a> èñïîëüçóéòå ñëåäóþùèå äàííûå:
            <br/>
            <br/>
            <blockquote>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            </blockquote>				
            <br/>
            <br/>";
            
            $mail .= "
            Æåëàåì ïðèÿòíûõ ïîêóïîê!	<br/><br/>";
            
            if ($user['group']!=1) {
                sendMail ($user['email'], $user['username'], 'registration@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'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }
            
        break;
            
        case 'auto':	// ===================[ Îòïðàâêà àâòîðååñòðàöèè ]=========================

            global $_POST;
            
            $sql = "SELECT * FROM zlo_users WHERE email='".$_POST['order_email']."'";
            $result = mysql_query($sql) or die(mysql_error());
            if (mysql_affected_rows()!=0) {
                $user=mysql_fetch_assoc($result);
            }

            $subject = "Ðåãèñòðàöèÿ íà ñàéòå ïîëüçîâàòåëÿ : ".$user['username'];

            $mail = "

            Çäðàâñòâóéòå, ".$user['username']." ! <br/><br/>

            Âû óñïåøíî çàðåãèñòðèðîâàëèñü â íàøåì ìàãàçèíå <br/>
            Äëÿ âõîäà â <a href='http://extremstyle.ua/'>ëè÷íûé êàáèíåò</a> èñïîëüçóéòå ñëåäóþùèå äàííûå:
            <br/>
            <br/>
            <blockquote>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            </blockquote>				
            <br/>
            <br/>";
            
            $mail .= "
            Æåëàåì ïðèÿòíûõ ïîêóïîê!	<br/><br/>";
            
            // Ðàññûëêà óâåäîìëåíèé   
            if ($user['group']!=1) {
                sendMail ($user['email'], $user['username'], 'registration@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'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            // }
            
        break;	
            
        case 'order-new': // ===================[ Íîâûé çàêàç ]=========================
        
            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/>

            Ñïàñèáî çà Âàø çàêàç â èíòåðíåò ìàãàçèíå <a href='http://extremstyle.ua/'>extremstyle.ua</a><br/><br/>";

            $mail=ShowOrder($user_id, $order_id, $mail);

            $mail.= "
            Íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.
            Äåòàëüíóþ èíôîðìàöèþ è ñîñòîÿíèå çàêàçà Âû ìîæåòå ïðîâåðèòü â
            Âàøåì ëè÷íîì êàáèíåòå <a href='http://extremstyle.ua/account/'>http://extremstyle.ua/account/</a><br/><br/>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            <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);
            }
            
            eMailing('xml', $user_id, $order_id);
            
        break;

        case 'order-changed': // ===================[ Çàêàç èçìåíåí ]=========================
        
            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);
            }
            
        break;
            
        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;
        
        case 'remind': // ===================[ Íàïîìèíàíèå ïàðîëÿ ]=========================

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $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;
            
        case 'MessageToUser': // ===================[ MessageToUser ]=========================

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $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;
            
        case 'MessageToAdmin': // ===================[ MessageToUser ]=========================

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $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  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 (mysql_affected_rows()!=0) {
                $order=mysql_fetch_assoc($result);
             
                $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['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.="
                    <div class='order-details'>
                    <fieldset id='order-details' style='width:500px;'>
                    <legend>Òîâàðû</legend>";
                $mail.="<table>
                      <tr>
                        <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 * 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>".$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.="</table>
                   </div>";
                   
                
                }
            
            }
            
            $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;
}
?>