Subversion-Projekte lars-tiefland.shop_ns

<?php
    /**
     * @package shop
     * @author Lars Tiefland <ltiefland@gmail.com>
     * @copyright 2012
     * @version $Id$
     */

    /**
     * @package shop
     * @author Lars Tiefland <ltiefland@gmail.com>
     * @copyright 2012
     * @version $Id$
     */

    namespace Weban;
    class Aktion
    {
        public function __construct( $id )
        {
            $sql = "SELECT
                    *
                FROM
                    Aktionen
                WHERE
                    id = $id
            ";
            $res = $GLOBALS["db"]->query( $sql );
            $row = $res->fetchRow();
            $row["artikel"] = aktionItems::Liste( $row["ID"] );
            foreach ( $row as $feld => $wert )
            {
                $this->$feld = $wert;
            }
        }

        public static function currentAktion()
        {
            $sql = "SELECT
                    id
                FROM
                    Aktionen
                WHERE
                    shops_id = " . $GLOBALS["INI"]["shops_ID"] . "
                AND
                    CURRENT_DATE() BETWEEN von AND bis
            ";
            $res = $GLOBALS["db"]->query( $sql );
            $row = $res->fetchrow();
            if ( $row["id"] )
            {
                $ret = new Aktion( $row["id"] );
            }
            return $ret;
        }
    }
?>