Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1167 Revision 1173
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: 1167 $
 8 
 * @version $Rev: 1173 $
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 
				b.id,
 - 
 
25 
				bill_addr_id,
 - 
 
26 
				ship_addr_id,
 - 
 
27 
				erstellt_am,
 - 
 
28 
				status,
 - 
 
29 
				fremd_id,
 - 
 
30 
				artikelstatus_buffer,
 - 
 
31 
				rechnungsstatus_buffer,
 - 
 
32 
				lieferscheinstatus_buffer,
 - 
 
33 
				bezahlt,
 - 
 
34 
				bezahlt_am,
 - 
 
35 
				s.name
 24 
				b.id
36 
			FROM
 25 
			FROM
37 
				Bestellung b
 - 
 
38 
			JOIN
 - 
 
39 
				shops s
 - 
 
40 
			ON
 - 
 
41 
				s.id=b.shops_id
 26 
				Bestellung b
42 
			ORDER BY
 27 
			ORDER BY
43 
				b.id DESC
 28 
				b.id DESC
44 
			LIMIT
 29 
			LIMIT
45 
				100
 30 
				100
46 
		";
 31 
		";
47 
		$res = $GLOBALS['order_db']->query($sql);
 32 
		$res = $GLOBALS['order_db']->query($sql);
48 
		while ($order = $res->unbuffered_row('array'))
 33 
		while ($order = $res->unbuffered_row('array'))
- 
 
 34 
		{
49 
		{
 35 
			$order = $this->get($order['id']);
50 
			$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
 36 
			$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
51 
			$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
 37 
			$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
Zeile 52... Zeile 38...
52 
			$artikel = $this->artikel->get($order['id']);
 38 
			$artikel = $this->artikel->get($order['id']);
Zeile 121... Zeile 107...
121 
			$order['billAddr'] = $billAddr;
 107 
			$order['billAddr'] = $billAddr;
122 
			$orders[] = $order;
 108 
			$orders[] = $order;
123 
		}
 109 
		}
124 
		return $orders;
 110 
		return $orders;
125 
	}
 111 
	}
- 
 
 112 
 
- 
 
 113 
	public function get($id)
- 
 
 114 
	{
- 
 
 115 
		$orders = array();
- 
 
 116 
		$sql = "SELECT
- 
 
 117 
				b.id,
- 
 
 118 
				bill_addr_id,
- 
 
 119 
				ship_addr_id,
- 
 
 120 
				erstellt_am,
- 
 
 121 
				status,
- 
 
 122 
				fremd_id,
- 
 
 123 
				artikelstatus_buffer,
- 
 
 124 
				rechnungsstatus_buffer,
- 
 
 125 
				lieferscheinstatus_buffer,
- 
 
 126 
				bezahlt,
- 
 
 127 
				bezahlt_am,
- 
 
 128 
				s.name
- 
 
 129 
			FROM
- 
 
 130 
				Bestellung b
- 
 
 131 
			JOIN
- 
 
 132 
				shops s
- 
 
 133 
			ON
- 
 
 134 
				s.id=b.shops_id
- 
 
 135 
			WHERE
- 
 
 136 
				b.id=".$id."
- 
 
 137 
		";
- 
 
 138 
		$res = $GLOBALS['order_db']->query($sql);
- 
 
 139 
		$order = $res->unbuffered_row('array');
- 
 
 140 
		$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
- 
 
 141 
		$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
- 
 
 142 
		$artikel = $this->artikel->get($order['id']);
- 
 
 143 
 
- 
 
 144 
		$artikelstatus_buffer = unserialize($order["artikelstatus_buffer"]);
- 
 
 145 
		foreach ($artikelstatus_buffer as $key => $value)
- 
 
 146 
		{
- 
 
 147 
			switch ($key)
- 
 
 148 
			{
- 
 
 149 
				case "statusOffen":
- 
 
 150 
					$info[$key]["class"] = "status_red";
- 
 
 151 
					break;
- 
 
 152 
				case "statusInBearbeitung":
- 
 
 153 
					$info[$key]["class"] = "status_yellow";
- 
 
 154 
					break;
- 
 
 155 
				case "statusReserviert":
- 
 
 156 
					$info[$key]["class"] = "status_blue";
- 
 
 157 
					break;
- 
 
 158 
				case "statusErledigt":
- 
 
 159 
					$info[$key]["class"] = "status_green";
- 
 
 160 
					break;
- 
 
 161 
				case "statusAbgeschlossen":
- 
 
 162 
				default:
- 
 
 163 
					$info[$key]["class"] = "status_white";
- 
 
 164 
					break;
- 
 
 165 
 
- 
 
 166 
			}
- 
 
 167 
			$info[$key]["wert"] = $value;
- 
 
 168 
		}
- 
 
 169 
		$order["info"] = $info;
- 
 
 170 
		$rechnungsstatus_buffer = unserialize($order["rechnungsstatus_buffer"]);
- 
 
 171 
		foreach ($rechnungsstatus_buffer as $key => $value)
- 
 
 172 
		{
- 
 
 173 
			switch ($key)
- 
 
 174 
			{
- 
 
 175 
				case "rechnungSchreiben":
- 
 
 176 
					$rstatus[$key]["class"] = "status_red";
- 
 
 177 
					break;
- 
 
 178 
				case "rechnungGeschrieben":
- 
 
 179 
					$rstatus[$key]["class"] = "status_yellow";
- 
 
 180 
					break;
- 
 
 181 
				case "rechnungBezahlt":
- 
 
 182 
					$rstatus[$key]["class"] = "status_green";
- 
 
 183 
					break;
- 
 
 184 
 
- 
 
 185 
			}
- 
 
 186 
			$rstatus[$key]["wert"] = $value;
- 
 
 187 
		}
- 
 
 188 
		$order["rechnungsstatus"] = $rstatus;
- 
 
 189 
		$lieferscheinstatus_buffer = unserialize($order["lieferscheinstatus_buffer"]);
- 
 
 190 
		foreach ($lieferscheinstatus_buffer as $key => $value)
- 
 
 191 
		{
- 
 
 192 
			switch ($key)
- 
 
 193 
			{
- 
 
 194 
				case "lieferscheinSchreiben":
- 
 
 195 
					$lstatus[$key]["class"] = "status_yellow";
- 
 
 196 
					break;
- 
 
 197 
				case "lieferscheinGeschrieben":
- 
 
 198 
					$lstatus[$key]["class"] = "status_green";
- 
 
 199 
					break;
- 
 
 200 
				case "lieferscheinOffen":
- 
 
 201 
					$lstatus[$key]["class"] = "status_red";
- 
 
 202 
					break;
- 
 
 203 
 
- 
 
 204 
			}
- 
 
 205 
			$lstatus[$key]["wert"] = $value;
- 
 
 206 
		}
- 
 
 207 
		$order['lieferscheinstatus'] = $lstatus;
- 
 
 208 
 
- 
 
 209 
		$order['artikel'] = $artikel;
- 
 
 210 
		$order['shipAddr'] = $shipAddr;
- 
 
 211 
		$order['billAddr'] = $billAddr;
- 
 
 212 
 
- 
 
 213 
		return $order;
- 
 
 214 
	}
126 
}
 215 
}
Zeile 127... Zeile 216...
127 
 
 216 
 
128 
?>
 217 
?>