Subversion-Projekte lars-tiefland.ci

<?php

/**
 * @author Lars Tiefland
 * @copyright 2016
 */

class Versand_uebersicht extends CI_Controller
{
        public function __construct()
        {
                parent::__construct();
                $GLOBALS['order_db'] = $this->load->database('order_db', TRUE);
                $GLOBALS['db_red'] = $this->load->database('db_red', TRUE);
                $versand_laender = getVersandLaender();
                $zahlarten = getZahlarten();
                $this->smarty->assign('zahlarten', $zahlarten);
                $this->smarty->assign('Laender', $versand_laender);
        }

        function index()
        {
                $versand_uebersicht['basketVersand'] = $this->get_versandkosten();
                $this->smarty->assign('versand_uebersicht', $versand_uebersicht);
                $this->smarty->view('versand_uebersicht.tpl');
        }

        private function get_versandkosten($land = null)
        {
                if (is_null($land))
                {
                        $land = 47;
                        $lCode = getWebanLCode($land);
                        $shopID = $GLOBALS["INI"]['shops_ID'];
                        if (isset($_SESSION["KundengruppeShopID"]) && $_SESSION["KundengruppeShopID"] !=
                                "")
                        {
                                $shopID = $_SESSION["KundengruppeShopID"];
                        }
                        $sql_Z_extra = "";
                        if (column_exists("zahlungsarten", "express", $GLOBALS["INI"]["dbConnect"]["database"],
                                $this->db))
                        {
                                $sql_Z_extra = "express,";
                        }

                        $sql = "
                                SELECT
                                        a.ID,
                                        Father,
                                        kurzbezeichnung as kurz,
                                        langbezeichnung    as lang,
                                        beschreibung as beschr,
                                        preis1 as preis,
                                        preis2 as aufschlag,
                                        short_line_1 as rufname,
                                        versand_abschlag,
                                        1 as Versand,
                                        preis_neu1,
                                        preis_neu2,
                                        preis_neu3,
                                        preis_neu4,
                                        Eigenschaft_1,
                                        Eigenschaft_2,
                                        Eigenschaft_3,
                                        Eigenschaft_4,
                                        Eigenschaft_5,
                                        ".$sql_Z_extra."
                                        z.name AS z_name
                                FROM
                                        artikel a
                                JOIN
                                        zahlungsarten z
                                ON
                                        z.interner_name=a.short_line_1
                                WHERE
                                        father=-3
                                AND
                                        language='".$GLOBALS['INI']['language']."'
                                AND
                                        lieferstatus & ".$lCode."=".$lCode."
                        ";
                        /*foreach ($GLOBALS["Eigenschaften"] as $nr)
                        {
                                if (Eigenschaft($nr) == true)
                                {
                                        $sql .= "
                                                AND
                                                        Eigenschaft_$nr = 1
                                        ";
                                }
                                else
                                {
                                        $sql .= "
                                                AND
                                                (
                                                        (Eigenschaft_$nr = 0)
                                                        OR
                                                        (Eigenschaft_$nr IS NULL)
                                                )
                                        ";
                                }
                        }*/
                        $sql .= "
                                ORDER BY
                                        short_line_1,
                                        rang
                        ";
                        $res = $this->db->query($sql);
                        echo $this->db->last_query();
                        $items = $res->result_array();
                        return $items;
                }
        }
}

?>