WebSVN – lars-tiefland.content-management – /trunk/cronjobs/ebay_mail.php

<?php

    /**
     * @package   Content-management
     * @author    Webagentur Niewerth <tiefland@weban.de>
     * @copyright 2011 Webagentur Niewerth
     * @license   propietary http://www.weban.de
     * @version   $Rev: 3873 $
     * @filesource
     * 
     */

    /**
     * 
     * @package   Content-management
     * @author    Webagentur Niewerth <tiefland@weban.de>
     * @copyright 2011 Webagentur Niewerth
     */

    // SVN: $Id: ebay_mail.php 3873 2011-09-01 13:50:57Z tiefland $

    require_once "../Online-Shop/connect2.php";
    require_once
        "../Warenwirtschaft/includes/bestellungen/system/getBestellarten.php";

    $bestellarten = getBestellarten();

    $start_date = date( "Y-m-d H:i:00", strtotime( "-12 hours" ) );

    $shop = filter_input( INPUT_GET, "shop", FILTER_VALIDATE_INT );
    $bestellart_id = filter_input( INPUT_GET, "bestellart_id",
        FILTER_VALIDATE_INT );
    $button_id = filter_Input( INPUT_GET, "button_id", FILTER_VALIDATE_INT );

    if ( $bestellarten && !$bestellart_id )
    {
        die( "Dieser Shop arbeitet mit Bestellarten.<br>Bitte geben Sie die richtige an!" );
    } elseif ( !stristr( $bestellarten[$bestellart_id]["rufname"], "ebay" ) )
    {
        die( "Dies ist die Bestellart für Ebay-Bestellungen!<br>Bitte geben Sie die richtige an!" );
    }
    if ( !$button_id || !$shop )
    {
        die( "Fehler: Falscher Aufruf.<br>Es müssen 2 weitere Parameter übergeben werden!" );
    }

    $bestellart = false;
    $sql = "SELECT
            b.id,
            b.shops_ID,
            b.bestellart_id,
            l.E_Mail,
            l.Name1,
            l.Name2,
            l.Vorname,
            l.Anrede,
            b.erstellt_am
        FROM
            Bestellung b,
            Logins l
        WHERE
            shops_id=" . $shop . "
        AND
            l.id=b.login
        AND
            bestellart_id=" . $bestellart_id . "
        AND
            b.erstellt_am >='$start_date'
    ";
    $res = mysql_query( $sql );
    while ( $row = mysql_fetch_assoc( $res ) )
    {
        $erstellt_am = datetime2human( $row["erstellt_am"] );
        $Datum = $erstellt_am["Datum"];
        $Zeit = $erstellt_am["Zeit"];
        $Userdata = $row;
        $Heute = date( "d.m.Y" );
        $jetzt = date( "H:i" );
        $bestellart = false;
        $Bestellung = $row["id"];
        if ( is_array( $bestellarten ) && $Bestellung )
        {
            $sql_s = "
                SHOW
                    COLUMNS
                FROM
                    shops
                LIKE
                    'database'
            ";
            $res_s = mysql_query( $sql_s );
            if ( mysql_num_rows( $res_s ) )
            {
                $sql_sb = "SELECT
                        `database`
                    FROM
                        shops s,
                        Bestellung b
                    WHERE
                        s.ID=b.shops_ID
                    AND
                        b.ID=$Bestellung
                ";
                $res_sb = mysql_query( $sql_sb );
                $row_sb = mysql_fetch_assoc( $res_sb );
                if ( $row_sb["database"] )
                {
                    $database = $row_sb["database"] . ".";
                }
            }
            $settings_table = $database . "web_settings";
            $sql_ws = "
                SHOW
                    COLUMNS
                FROM
                    $settings_table
                LIKE
                    'bestellart_id'
            ";
            $res_ws = mysql_query( $sql_ws );
            $anz = mysql_num_rows( $res_ws );
            if ( $anz )
            {
                $bestellart = true;
                define( "BESTELLART", true );
            }
            else
            {
                $bestellart = false;
                define( "BESTELLART", false );
            }
        } elseif ( $Bestellung )
        {
            $sql_s = "
                SHOW
                    COLUMNS
                FROM
                    shops
                LIKE
                    'database'
            ";
            $database = "";
            $res_s = mysql_query( $sql_s );
            if ( mysql_num_rows( $res_s ) )
            {
                $sql = "SELECT
                        `database`
                    FROM
                        shops s,
                        Bestellung b
                    WHERE
                        s.ID=b.shops_ID
                    AND
                        b.ID=$Bestellung
                ";
                $res_sb = mysql_query( $sql_sb );
                $row_sb = mysql_fetch_assoc( $res_sb );
                if ( $row_sb["database"] )
                {
                    $database = $row_sb["database"] . ".";
                }
            }
            $settings_table = $database . "web_settings";
            $bestellart = false;
            define( "BESTELLART", false );
        }

        if ( $bestellart )
        {
            $query = "
            SELECT 
                * 
            FROM 
                $settings_table 
            WHERE 
                bestellart_id=" . $bestellart_id . " 
            AND
                shops_ID = " . $shop . "
            ORDER BY 
                Rang";
        }
        else
        {
            $query = "
            SELECT 
                * 
            FROM 
                $settings_table 
            WHERE
                shops_ID = " . $shop . "
            ORDER BY 
                Rang";
        }

        $result_w = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>$query<hr>" );
        if ( !mysql_num_rows( $result_w ) && $bestellart )
        {
            $query = "SELECT 
                * 
            FROM 
                $settings_table 
            WHERE
                shops_ID = " . $shop . "
            AND
                bestellart_id=" . $bestellart_id . "
            ORDER BY 
                Rang
        ";
            $result_w = mysql_query_logged( $query ) or die( mysql_errno() .
                ": " . mysql_error() . "<hr>$query<hr>" );
        }
        while ( $zeile_w = mysql_fetch_assoc( $result_w ) )
        {
            //        $web_settings[$zeile_w["shops_ID"]][$zeile_w["ID"]] = $zeile_w["Inhalt"];
            $buffer = $zeile_w["Inhalt"];
            $wsID = $zeile_w["ID"];
            if ( $wsID != 1000 )
            {
                if ( strpos( $buffer, '"' ) !== false )
                {
                    $buffer = str_replace( '"', "***", $buffer );
                }
                @eval( "\$buffer=\"$buffer\";" );
                if ( strpos( $buffer, '***' ) !== false )
                {

                    $buffer = str_replace( '***', '"', $buffer );
                }
            }
            $web_settings[$shop][$wsID] = rawurlencode( $buffer );
        }
        if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["button" .
            $button_id] ) )
        {
            $Felddaten = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["button" .
                $button_id] );
            if ( isset( $user_rechte["Warenwirtschaft"]["bestellung"]["button" .
                $button_id] ) and ( $web_settings[$row["shops_ID"]][$Felddaten[1]] ) )
            {
                // Mail Client dazuschalten (Markus 02.07.207)
                $buttonType = isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) ?
                    "button" : "submit";
                if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) )
                {
                    $mailData[$row["id"]][$button_id]['subject'] =
                        rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[1]] );
                    $mailData[$row["id"]][$button_id]['body'] = rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[2]] );
                    $mailData[$row["id"]][$button_id]['inTextField'] =
                        rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[3]] );
                    $to = $row["E_Mail"];
                    //$to = "tiefland@weban.de";
                    $mailData[$row["id"]][$button_id]['mailto'] = $to;
                    $FelddatenII = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] );
                    if ( $FelddatenII[0] == "websettingid" )
                    {
                        $mailData[$row["id"]][$button_id]['mailfrom'] =
                            rawurldecode( $web_settings[$row["shops_ID"]][$FelddatenII[1]] );
                    }

                    $_SESSION['mailData'] = $mailData;
                }
            }
        }
        $sql_d = "SELECT
                id
            FROM
                dokumente
            WHERE
                data_foreign=" . $row["id"] . "
            AND
                table_foreign='Bestellung'
            AND
                document LIKE 'ebayBestaetigung%'
        ";
        $res_d = mysql_query( $sql_d );
        $anz = mysql_num_rows( $res_d );
        if ( !$anz )
        {
            $_GET["shop"] = 1;
            $_POST = $_SESSION["mailData"][$row["id"]][$button_id];
            $_POST["id"] = 6;
            $_POST["Bestellung"] = $row["id"];
            $_POST["shops_ID"] = 1;
            $_POST["button"] = rawurldecode( $Felddaten[0] );
            $_POST["update"]["list"] = true;
            $_POST["adminMail"] = $_POST["mailfrom"];
            $url = "../Warenwirtschaft/MailClient/index.php";
            require $url;
        }
    }
?>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/cronjobs/ebay_mail.php – Revision 1
