Subversion-Projekte lars-tiefland.ci

Revision

Revision 1149 | Revision 1152 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1132 lars 1 
<?php
2 
 
3 
/**
4 
 *
5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
8 
 * @version $Rev: 1150 $
9 
 */
10 
 
11 
class Order_model extends CI_Model
12 
{
13 
	public function __construct()
14 
	{
15 
		parent::__construct();
1136 lars 16 
		$this->load->model('bestelladresse_model', 'bestelladresse');
17 
		$this->load->model('artikel_to_bestellung_model', 'artikel');
1132 lars 18 
	}
19 
 
20 
	public function get_list()
21 
	{
22 
		$orders = array();
23 
		$sql = "SELECT
24 
				id,
25 
				bill_addr_id,
1148 lars 26 
				ship_addr_id,
27 
				erstellt_am,
28 
				status,
29 
				fremd_id,
30 
				artikelstatus_buffer,
1149 lars 31 
				rechnungsstatus_buffer,
1150 lars 32 
				lieferscheinstatus_buffer,
33 
				s.name
1132 lars 34 
			FROM
1150 lars 35 
				Bestellung b
36 
			JOIN
37 
				shops s
38 
			ON
39 
				s.id=b.shops_id
1132 lars 40 
			ORDER BY
1146 lars 41 
				id DESC
1145 lars 42 
			LIMIT
43 
				100
1132 lars 44 
		";
45 
		$res = $GLOBALS['order_db']->query($sql);
1134 lars 46 
		while ($order = $res->unbuffered_row('array'))
1132 lars 47 
		{
1142 lars 48 
			$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
49 
			$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
50 
			$artikel = $this->artikel->get($order['id']);
1136 lars 51 
			$order['artikel'] = $artikel;
52 
			$order['shipAddr'] = $shipAddr;
53 
			$order['billAddr'] = $billAddr;
1132 lars 54 
			$orders[] = $order;
55 
		}
56 
		return $orders;
57 
	}
58 
}
59 
 
60 
?>