Subversion-Projekte lars-tiefland.ci

Revision

Revision 1150 | Revision 1158 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1150 Revision 1152
Zeile 3... Zeile 3...
3 
/**
 3 
/**
4 
 *
 4 
 *
5 
 * @package WebanOS CI
 5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
 7 
 * @copyright 2016
8 
 * @version $Rev: 1150 $
 8 
 * @version $Rev: 1152 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Order_model extends CI_Model
 11 
class Order_model extends CI_Model
12 
{
 12 
{
Zeile 19... Zeile 19...
19 
 
 19 
 
20 
	public function get_list()
 20 
	public function get_list()
21 
	{
 21 
	{
22 
		$orders = array();
 22 
		$orders = array();
23 
		$sql = "SELECT
 23 
		$sql = "SELECT
24 
				id,
 24 
				b.id,
25 
				bill_addr_id,
 25 
				bill_addr_id,
26 
				ship_addr_id,
 26 
				ship_addr_id,
27 
				erstellt_am,
 27 
				erstellt_am,
28 
				status,
 28 
				status,
Zeile 36... Zeile 36...
36 
			JOIN
 36 
			JOIN
37 
				shops s
 37 
				shops s
38 
			ON
 38 
			ON
39 
				s.id=b.shops_id
 39 
				s.id=b.shops_id
40 
			ORDER BY
 40 
			ORDER BY
41 
				id DESC
 41 
				b.id DESC
42 
			LIMIT
 42 
			LIMIT
43 
				100
 43 
				100
44 
		";
 44 
		";
45 
		$res = $GLOBALS['order_db']->query($sql);
 45 
		$res = $GLOBALS['order_db']->query($sql);
46 
		while ($order = $res->unbuffered_row('array'))
 46 
		while ($order = $res->unbuffered_row('array'))