Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1204 Revision 1273
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: 1204 $
 8 
 * @version $Rev: 1273 $
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 113... Zeile 113...
113 
	public function get($id)
 113 
	public function get($id)
114 
	{
 114 
	{
115 
		$orders = array();
 115 
		$orders = array();
116 
		$sql = "SELECT
 116 
		$sql = "SELECT
117 
				b.id,
 117 
				b.id,
- 
 
 118 
				b.language,
118 
				b.shops_ID,
 119 
				b.shops_ID,
119 
				b.login,
 120 
				b.login,
120 
				bill_addr_id,
 121 
				bill_addr_id,
121 
				ship_addr_id,
 122 
				ship_addr_id,
122 
				erstellt_am,
 123 
				erstellt_am,
Zeile 128... Zeile 129...
128 
				artikelstatus_buffer,
 129 
				artikelstatus_buffer,
129 
				rechnungsstatus_buffer,
 130 
				rechnungsstatus_buffer,
130 
				lieferscheinstatus_buffer,
 131 
				lieferscheinstatus_buffer,
131 
				bezahlt,
 132 
				bezahlt,
132 
				bezahlt_am,
 133 
				bezahlt_am,
133 
				s.name AS shop
 134 
				s.name AS shop,
- 
 
 135 
				ba.name AS bestllart
134 
			FROM
 136 
			FROM
135 
				Bestellung b
 137 
				Bestellung b
136 
			JOIN
 138 
			JOIN
137 
				shops s
 139 
				shops s
138 
			ON
 140 
			ON
139 
				s.id=b.shops_id
 141 
				s.id=b.shops_id
- 
 
 142 
			JOIN
- 
 
 143 
				bestellart ba
- 
 
 144 
			ON
- 
 
 145 
				ba.id=b.bestellart
140 
			WHERE
 146 
			WHERE
141 
				b.id=".$id."
 147 
				b.id=".$id."
142 
		";
 148 
		";
143 
		$res = $GLOBALS['order_db']->query($sql);
 149 
		$res = $GLOBALS['order_db']->query($sql);
144 
		$order = $res->unbuffered_row('array');
 150 
		$order = $res->unbuffered_row('array');