Subversion-Projekte lars-tiefland.content-management

<?php

    /**

     * eportiert Adressen von Kunden an GLS

     *

     * @package   Content-management

     * @author    Lars Tiefland <tiefland@weban.de>

     * @copyright 2009 Webagentur Niewerth

     * @license   propietary http://www.weban.de

     * @version   $Rev: 3931 $

     * @filesource

     *

     */

    /**

     *

     *   @package   Content-management

     *   @author    Lars Tiefland <tiefland@weban.de>

     *   @copyright 2009 Webagentur Niewerth

     */

    // SVN: $Id: gls_export.php 3931 2011-09-16 08:17:57Z tiefland $

    require_once 'Weban_Smarty.class.php';

    require_once '../Online-Shop/connect2.php';

    require_once 'File/Find.php';

    require_once 'module/functions.common.php';

    $GLOBALS["ui"] = new Weban_Smarty();

    $GLOBALS["ui"]->compile_dir = $_SERVER["DOCUMENT_ROOT"] . "/templates_c/";

    $GLOBALS["ui"]->compile_id = "Warenwirtschaft|export";

    $GLOBALS["ui"]->use_sub_dirs = true;

    $GLOBALS["ui"]->assign( "title", "Adressdaten nach GLS exportieren" );

    if ( isset( $user_rechte['Warenwirtschaft']['gls_export']['gls'] ) )

    {

        if ( $_GET['mode'] == 'new' )

        {

            gls_export();

        } elseif ( $_GET['file'] )

        {

            $file = $_GET['file'];

            if ( file_exists( $file ) )

            {

                //header( 'Content-Type: text/plain' );

                header( 'Content-Disposition: attachment; filename="' .

                    basename( $file ) . '"' );

                readfile( $file );

            }

        }

        else

        {

            if ( !file_exists( "archiv/$site" ) )

            {

                mkdir( "archiv/$site" );

            }

            $ff = new File_Find();

            $files = $ff->search( "/export_Bestellungen_gls_[0-9]{4}-[0-9]{2}-[0-9]{2}_[0-9]{2}-[0-9]{2}-[0-9]{2}.txt$/i",

                "archiv/$site/", "perl" );

            rsort( $files );

            foreach ( $files as $f_id => $file )

            {

                $files_arr[$f_id]["name"] = $file;

                $date = date( "d.m.Y H:i:s", filemtime( $file ) );

                $files_arr[$f_id]["desc"] = $date;

            }

            $GLOBALS["ui"]->assign( "files", $files_arr );

            $GLOBALS["ui"]->display( "export.tpl" );

        }

    }

    else

    {

        $GLOBALS["ui"]->assign( "meld",

            "Sie haben nicht das Recht dieses Tool zu nutzen!" );

        $GLOBALS["ui"]->assign( "error", true );

        $GLOBALS["ui"]->display( "meld.tpl" );

    }

    /**

     * gls_export()

     *

     * @return void

     */

    function gls_export()

    {

        global $site;

        $date = date( 'Y-m-d_H-i-s' );

        $f_name = "export_Bestellungen_gls_$date.txt";

        $f = fopen( "archiv/$site/$f_name", 'w' );

        $sql = "

            SELECT DISTINCT

                Bestellung

            FROM

                artikel_to_Bestellung

            WHERE

                status='erledigt';

        ";

        $res_b = mysql_query( $sql );

        while ( $row_b = mysql_fetch_assoc( $res_b ) )

        {

            $b_id = $row_b["Bestellung"];

            $sql = "

                SELECT

                    b.*,

                    l.E_Mail,

                    l.Vorname,

                    l.Name1,

                    l.Name2 as Firma,

                    l.Strasse,

                    l.Hausnummer,

                    l.PLZ,

                    l.Ort,

                    l.Land,

                    l.Telefon

                FROM

                    Bestellung b,

                    Logins l

                WHERE

                    l.ID=b.Login

                AND

                    b.id= $b_id

            ";

            $res = mysql_query( $sql );

            while ( $row = mysql_fetch_assoc( $res ) )

            {

                $sql_a = "

                    SELECT

                        ab.artikel,

                        a.short_line_1 AS rufname,

                        ab.preis_pro_Stueck AS preis,

                        ab.Menge

                    FROM

                        artikel_to_Bestellung ab

                    JOIN

                        artikel a

                    ON

                        a.ID=ab.artikel

                    WHERE

                        ab.Bestellung=$b_id

                ";

                $res_a = mysql_query( $sql_a );

                $f_row = array();

                $f_row[] = $row['ID'];

                $name = ( $row['liefer_Vorname'] ) ? $row['liefer_Vorname'] :

                    $row['Vorname'];

                $name .= ( $row['liefer_Name'] || $row['Name1'] ) ? " " : "";

                $name .= ( $row['liefer_Name'] ) ? $row['liefer_Name'] : $row['Name1'];

                $f_row[] = $name;

                $f_row[] = "";

                $f_row[] = ( $row['liefer_Firma'] ) ? $row['liefer_Firma'] :

                    $row['Firma'];

                $f_row[] = ( trim( $row['liefer_Strasse'] . ' ' . $row['liefer_Str_Nr'] ) ) ?

                    trim( $row['liefer_Strasse'] . ' ' . $row['liefer_Str_Nr'] ) :

                    trim( $row['Strasse'] . ' ' . $row['Hausnummer'] );

                $f_row[] = '';

                $land = getISOCode( ( $row['liefer_Land'] ) ? $row['liefer_Land'] :

                    $row['Land'] ) ? getISOCode( ( $row['liefer_Land'] ) ? $row['liefer_Land'] :

                    $row['Land'] ) : "DE";

                $f_row[] = $land;

                $f_row[] = ( $row['liefer_PLZ'] ) ? $row['liefer_PLZ'] : $row['PLZ'];

                $f_row[] = ( $row['liefer_Ort'] ) ? $row['liefer_Ort'] : $row['Ort'];

                $f_row[] = $row['ID'];

                $f_row[] = $row["Telefon"];

                $f_row[] = $row['E_Mail'];

                $f_row[] = $row['ID'];

                while ( $row_a = mysql_fetch_assoc( $res_a ) )

                {

                    $gesamt += $row_a["Menge"] * $row_a["preis"];

                    if ( strtolower( $row_a["rufname"] ) == "nachnahme" )

                    {

                        $f_row[] = "COD";

                        $f_row[] = $gesamt;

                    }

                    else

                    {

                        $f_row[] = "";

                        $f_row[] = "";

                    }

                }

                fwrite( $f, implode( "\t", $f_row ) . "\r\n" );

            } //end while

        }

        fclose( $f );

        if ( isset( $user_rechte['Warenwirtschaft']['export'] ) )

        {

            $file = "export.php";

        }

        else

        {

            $file = "gls_export.php";

        }

        header( 'Location: ' . $file );

    }

?>