Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1281 Revision 1309
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: 1281 $
8
 * @version $Rev: 1309 $
9
 */
9
 */
Zeile 10... Zeile 10...
10
 
10
 
11
class Order_model extends CI_Model
11
class Order_model extends CI_Model
12
{
12
{
13
	public function __construct()
13
	public function __construct()
14
	{
14
	{
15
		parent::__construct();
15
		parent::__construct();
16
		$this->load->model('bestelladresse_model', 'bestelladresse');
16
		$this->load->model('bestelladresse_model', 'bestelladresse');
-
 
17
		$this->load->model('artikel_to_bestellung_model', 'artikel');
17
		$this->load->model('artikel_to_bestellung_model', 'artikel');
18
		$this->load->model('dokumente_model', 'dokumente');
Zeile 18... Zeile 19...
18
	}
19
	}
19
 
20
 
20
	public function get_list()
21
	public function get_list()
Zeile 31... Zeile 32...
31
		";
32
		";
32
		$res = $GLOBALS['order_db']->query($sql);
33
		$res = $GLOBALS['order_db']->query($sql);
33
		while ($order = $res->unbuffered_row('array'))
34
		while ($order = $res->unbuffered_row('array'))
34
		{
35
		{
35
			$order = $this->get($order['id']);
36
			$order = $this->get($order['id']);
36
			$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
-
 
37
			$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
-
 
38
			$artikel = $this->artikel->get($order['id']);
-
 
39
 
-
 
40
			$artikelstatus_buffer = unserialize($order["artikelstatus_buffer"]);
-
 
41
			foreach ($artikelstatus_buffer as $key => $value)
-
 
42
			{
-
 
43
				switch ($key)
-
 
44
				{
-
 
45
					case "statusOffen":
-
 
46
						$info[$key]["class"] = "status_red";
-
 
47
						break;
-
 
48
					case "statusInBearbeitung":
-
 
49
						$info[$key]["class"] = "status_yellow";
-
 
50
						break;
-
 
51
					case "statusReserviert":
-
 
52
						$info[$key]["class"] = "status_blue";
-
 
53
						break;
-
 
54
					case "statusErledigt":
-
 
55
						$info[$key]["class"] = "status_green";
-
 
56
						break;
-
 
57
					case "statusAbgeschlossen":
-
 
58
					default:
-
 
59
						$info[$key]["class"] = "status_white";
-
 
60
						break;
-
 
61
 
-
 
62
				}
-
 
63
				$info[$key]["wert"] = $value;
-
 
64
			}
-
 
65
			$order["info"] = $info;
-
 
66
			$rechnungsstatus_buffer = unserialize($order["rechnungsstatus_buffer"]);
-
 
67
			foreach ($rechnungsstatus_buffer as $key => $value)
-
 
68
			{
-
 
69
				switch ($key)
-
 
70
				{
-
 
71
					case "rechnungSchreiben":
-
 
72
						$rstatus[$key]["class"] = "status_red";
-
 
73
						break;
-
 
74
					case "rechnungGeschrieben":
-
 
75
						$rstatus[$key]["class"] = "status_yellow";
-
 
76
						break;
-
 
77
					case "rechnungBezahlt":
-
 
78
						$rstatus[$key]["class"] = "status_green";
-
 
79
						break;
-
 
80
 
-
 
81
				}
-
 
82
				$rstatus[$key]["wert"] = $value;
-
 
83
			}
-
 
84
			$order["rechnungsstatus"] = $rstatus;
-
 
85
			$lieferscheinstatus_buffer = unserialize($order["lieferscheinstatus_buffer"]);
-
 
86
			foreach ($lieferscheinstatus_buffer as $key => $value)
-
 
87
			{
-
 
88
				switch ($key)
-
 
89
				{
-
 
90
					case "lieferscheinSchreiben":
-
 
91
						$lstatus[$key]["class"] = "status_yellow";
-
 
92
						break;
-
 
93
					case "lieferscheinGeschrieben":
-
 
94
						$lstatus[$key]["class"] = "status_green";
-
 
95
						break;
-
 
96
					case "lieferscheinOffen":
-
 
97
						$lstatus[$key]["class"] = "status_red";
-
 
98
						break;
-
 
99
 
-
 
100
				}
-
 
101
				$lstatus[$key]["wert"] = $value;
-
 
102
			}
-
 
103
			$order['lieferscheinstatus'] = $lstatus;
-
 
104
 
-
 
105
			$order['artikel'] = $artikel;
-
 
106
			$order['shipAddr'] = $shipAddr;
-
 
107
			$order['billAddr'] = $billAddr;
-
 
108
			$orders[] = $order;
37
			$orders[] = $order;
109
		}
38
		}
110
		return $orders;
39
		return $orders;
111
	}
40
	}
Zeile 150... Zeile 79...
150
		$res = $GLOBALS['order_db']->query($sql);
79
		$res = $GLOBALS['order_db']->query($sql);
151
		$order = $res->unbuffered_row('array');
80
		$order = $res->unbuffered_row('array');
152
		$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
81
		$billAddr = $this->bestelladresse->get($order['bill_addr_id']);
153
		$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
82
		$shipAddr = $this->bestelladresse->get($order['ship_addr_id']);
154
		$artikel = $this->artikel->get($order['id']);
83
		$artikel = $this->artikel->get($order['id']);
155
 
-
 
-
 
84
		$dokumente = $this->dokumente->get_list($order['id']);
156
		$artikelstatus_buffer = unserialize($order["artikelstatus_buffer"]);
85
		$artikelstatus_buffer = unserialize($order["artikelstatus_buffer"]);
157
		foreach ($artikelstatus_buffer as $key => $value)
86
		foreach ($artikelstatus_buffer as $key => $value)
158
		{
87
		{
159
			switch ($key)
88
			switch ($key)
160
			{
89
			{
Zeile 215... Zeile 144...
215
 
144
 
216
			}
145
			}
217
			$lstatus[$key]["wert"] = $value;
146
			$lstatus[$key]["wert"] = $value;
218
		}
147
		}
219
		$order['lieferscheinstatus'] = $lstatus;
-
 
-
 
148
		$order['lieferscheinstatus'] = $lstatus;
220
 
149
		$order['dokumente'] = $dokumente;
221
		$order['artikel'] = $artikel;
150
		$order['artikel'] = $artikel;
222
		$order['shipAddr'] = $shipAddr;
151
		$order['shipAddr'] = $shipAddr;
Zeile 223... Zeile 152...
223
		$order['billAddr'] = $billAddr;
152
		$order['billAddr'] = $billAddr;