Subversion-Projekte lars-tiefland.ci

<?php

/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 1142 $
 */

class Order_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
                $this->load->model('bestelladresse_model', 'bestelladresse');
                $this->load->model('artikel_to_bestellung_model', 'artikel');
        }

        public function get_list()
        {
                $orders = array();
                $sql = "SELECT
                                id,
                                bill_addr_id,
                                ship_addr_id
                        FROM
                                Bestellung
                        ORDER BY
                                id
                ";
                $res = $GLOBALS['order_db']->query($sql);
                while ($order = $res->unbuffered_row('array'))
                {
                        $billAddr = $this->bestelladresse->get($order['bill_addr_id']);
                        $shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
                        $artikel = $this->artikel->get($order['id']);
                        $order['artikel'] = $artikel;
                        $order['shipAddr'] = $shipAddr;
                        $order['billAddr'] = $billAddr;
                        $orders[] = $order;
                }
                return $orders;
        }
}

?>