Subversion-Projekte lars-tiefland.ci

<?php

/**

 *

 * @package WebanOS CI

 * @author Lars Tiefland <ltiefland@gmail.com>

 * @copyright 2016

 * @version $Rev: 1148 $

 */

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,

				erstellt_am,

				status,

				fremd_id,

				artikelstatus_buffer,

				rechnungstatus_buffer,

				lieferscheinstatus_buffer

			FROM

				Bestellung

			ORDER BY

				id DESC

			LIMIT

				100

		";

		$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;

	}

}

?>