Subversion-Projekte lars-tiefland.content-management

<?php

    //ini_set( "display_errors", false );
    //ini_set( "error_reporting", "E_ALL & ~E_DEPRECATED" );
    define( "__USE_MDB2__", true );
    define( "__SHOP__", "neu.schnellversender.de" );
    define( "__SITE__", "mediaran.de" );
    define( "USE_SMARTY", true );

    require_once "module/functions.common.php";
    //PEAR::setErrorHandling( PEAR_ERROR_CALLBACK, 'errorHandler' );

    init_shop();

    foreach ( $GLOBALS["Eigenschaften"] as $property )
    {
        $p[] = "Eigenschaft_$property";
    }

    $properties = implode( ", ", $p );

    $sql_c = "SELECT
            id
        FROM
            content_management.countries
        WHERE
            `name-ger` = ?
    ";

    $sql_v_alt = "SELECT
            a.id,
            ifnull(a.rang,0) AS rang,
            a.kennung,
            a.short_line_2 AS interner_name,
            status as shop,
            ifnull(preis_neu1,0) as gewicht_von,
            ifnull(preis_neu2,0) as gewicht_bis,
            ifnull(preis_neu3,0) as wert_von,
            ifnull(preis_neu4,0) as wert_bis,
            ifnull(preis1,0) as preis,
            kurzbezeichnung as name,
            ifnull(z.id,9) as z_id
        FROM
            artikel a
        LEFT OUTER JOIN
            zahlungsarten z
        ON
            z.interner_name=a.short_line_1
        JOIN
            shops s
        ON
            s.id=a.status
        WHERE
            Father = -3
        ORDER BY
            status
    ";
    $sql_vp_alt = "SELECT
            $properties
        FROM
            artikel
        WHERE
            id=?
    ";

    $sql_v_neu = "
        INSERT INTO
            shipment
        (
            rang,
            kennung,
            interner_name,
            shop,
            gewicht_von,
            gewicht_bis,
            wert_von,
            wert_bis,
            preis,
            name,
            z_id
        )
        VALUES
        (
            ?,
            ?,
            ?,
            ?,
            ?,
            ?,
            ?,
            ?,
            ?,
            ?,
            ?
        )
    ";

    $sql_vp_neu = "
        INSERT INTO
            shipment_properties
        (
            s_id,
            property,
            value
        )
        VALUES
        (
            ?,
            ?,
            ?
        )
    ";

    $sql_vc = "
        INSERT INTO
            shipment_countries
        (
            s_id,
            c_id
        )
        VALUES
        (
            ?,
            ?
        )
    ";

    $sql_v_ls = "SELECT
            lieferstatus
        FROM
            artikel
        WHERE
            id=?
    ";
    $sth["c"] = $GLOBALS["db"]->prepare( $sql_c, array( 'text' ) );
    $sth["v_alt"] = $GLOBALS["db"]->prepare( $sql_v_alt );
    $sth["v_ls"] = $GLOBALS["db"]->prepare( $sql_v_ls, array( 'integer' ) );
    $sth["v_neu"] = $GLOBALS["db"]->prepare( $sql_v_neu );
    $sth["vc"] = $GLOBALS["db"]->prepare( $sql_vc, array( 'integer', 'integer' ),
        MDB2_PREPARE_MANIP );
    $sth["vp_alt"] = $GLOBALS["db"]->prepare( $sql_vp_alt, array( 'integer' ) );
    $sth["vp_neu"] = $GLOBALS["db"]->prepare( $sql_vp_neu, array( 'integer',
        'integer', 'integer' ), MDB2_PREPARE_MANIP );
    if ( PEAR::iserror( $sth["c"] ) )
    {
        die( $sth["c"]->getUserInfo() );
    }
    if ( PEAR::iserror( $sth["v_alt"] ) )
    {
        die( $sth["v_alt"]->getUserInfo() );
    }
    if ( PEAR::iserror( $sth["v_ls"] ) )
    {
        die( $sth["v_ls"]->getUserInfo() );
    }
    if ( PEAR::iserror( $sth["v_neu"] ) )
    {
        die( $sth["v_neu"]->getUserInfo() );
    }
    if ( PEAR::iserror( $sth["vp_alt"] ) )
    {
        die( $sth["vp_alt"]->getUserInfo() );
    }
    if ( PEAR::iserror( $sth["vp_neu"] ) )
    {
        die( $sth["vp_neu"]->getUserInfo() );
    }
    $Laender = array( "Deutschland", "Niederlande", "Österreich", "Belgien",
        "Luxemburg", "Dänemark", "Schweiz", "Frankreich",
        "Vereinigtes Königreich von Großbritannien und Nordirland", "Italien",
        "Spanien", "Portugal", "Schweden", "Finnland", "Norwegen",
        "Irland, Republik", "Griechenland", "Estland", "Lettland", "Malta",
        "Litauen", "Polen", "Slowenien", "Tschechische Republik", "Türkei",
        "Ungarn", "Zypern, Republik", "Kanada", "Vereinigte Staaten von Amerika",
        "Kroatien", "Bulgarien", "Rumänien" );
    foreach ( $Laender as $l_id => $Land )
    {
        $code = 1 << $l_id;
        $res = $sth["c"]->execute( $Land );
        if ( PEAR::iserror( $res ) )
        {
            die( $res->getUserInfo() );
        }
        //echo $res->getUserInfo();
        $row = $res->fetchRow();
        $land_id = $row["id"];
        if ( $land_id )
        {
            $Laender_codes[$code] = $land_id;
        }
    }

    //var_dump( $Laender_codes );
    $res = $sth["v_alt"]->execute();
    if ( PEAR::iserror( $res ) )
    {
        die( $res->getUserInfo() );
    }
    while ( $row = $res->fetchrow() )
    {
        $res_ls = $sth["v_ls"]->execute( array( $row["id"] ) );
        $row_ls = $res_ls->fetchrow();
        if ( PEAR::iserror( $res_ls ) )
        {
            die( $res_ls->getUserInfo() );
        }
        $res_vp = $sth["vp_alt"]->execute( array( $row["id"] ) );
        if ( PEAR::iserror( $res_vp ) )
        {
            die( $res_vp->getUserInfo() );
        }
        $row_vp = $res_vp->fetchRow();
        unset( $row["id"] );
        unset( $row_v_neu );
        if ( empty( $row["z_id"] ) )
        {
            $row["z_id"] = 9;
        }
        foreach ( $row as $value )
        {
            $row_v_neu[] = $value;
        }
        $res_v_neu = $sth["v_neu"]->execute( $row_v_neu );
        if ( PEAR::iserror( $res_v_neu ) )
        {
            die( $res_v_neu->getUserInfo() );
        }
        $id_v_neu = $GLOBALS["db"]->lastInsertId();
        foreach ( $GLOBALS["Eigenschaften"] as $e_nr )
        {
            unset( $vp );
            $vp[] = $id_v_neu;
            $vp[] = $e_nr;
            $vp[] = $row_vp["eigenschaft_" . $e_nr];
            $res_vp_neu = $sth["vp_neu"]->execute( $vp );
            if ( PEAR::iserror( $res_vp_neu ) )
            {
                die( $res_vp_neu->getUserInfo() );
            }
        }
        foreach ( $Laender_codes as $code => $l_id )
        {
            if ( $row_ls["lieferstatus"] & $code = $code )
            {
                unset( $vc );
                $vc[] = $id_v_neu;
                $vc[] = $l_id;
                $res_vc = $sth["vc"]->execute( $vc );
            }
        }
    }

?>