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 );
    }

?>