Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 2363 Revision 2364
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: 2363 $
 8 
 * @version $Rev: 2364 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Logistiker_model extends CI_Model
 11 
class Logistiker_model extends CI_Model
12 
{
 12 
{
Zeile 43... Zeile 43...
43 
		return $logistiker;
 43 
		return $logistiker;
44 
	}
 44 
	}
Zeile 45... Zeile 45...
45 
 
 45 
 
46 
	public function save($daten)
 46 
	public function save($daten)
47 
	{
 47 
	{
48 
		if (!$this->input->post('id'))
 - 
 
49 
		{
 48 
		if (!$this->input->post('id')) {
50 
			$sql = "
 49 
			$sql = "
51 
				INSERT INTO
 50 
				INSERT INTO
52 
					logistiker
 51 
					logistiker
53 
				SET
 52 
				SET
54 
			";
 53 
			";
55 
			foreach ($daten as $key => $value)
 - 
 
56 
			{
 54 
			foreach ($daten as $key => $value) {
57 
				$felder[] = $key."=".$GLOBALS["order_db"]->escape($value);
 55 
				$felder[] = $key . "=" . $GLOBALS["order_db"]->escape($value);
58 
			}
 56 
			}
59 
			$sql .= implode(",", $felder);
 57 
			$sql .= implode(",", $felder);
60 
			$res = $this->db->query($sql);
 58 
			$res = $this->db->query($sql);
61 
			$id = $this->db->insert_id();
 - 
 
62 
		}
 59 
			$id = $this->db->insert_id();
63 
		else
 - 
 
64 
		{
 60 
		} else {
65 
			$sql = "UPDATE
 61 
			$sql = "UPDATE
66 
					logistiker
 62 
					logistiker
67 
				SET
 63 
				SET
68 
			";
 64 
			";
69 
			foreach ($daten as $key => $value)
 - 
 
70 
			{
 65 
			foreach ($daten as $key => $value) {
71 
				$felder[] = $key."=".$GLOBALS["order_db"]->escape($value);
 66 
				$felder[] = $key . "=" . $GLOBALS["order_db"]->escape($value);
72 
			}
 67 
			}
73 
			$sql .= implode(",", $felder);
 68 
			$sql .= implode(",", $felder);
74 
			$sql .= "
 69 
			$sql .= "
75 
				WHERE
 70 
				WHERE
76 
					id=".$this->input->post('id')."
 71 
					id=" . $this->input->post('id') . "
77 
			";
 72 
			";
78 
			$res = $this->db->query($sql);
 73 
			$res = $this->db->query($sql);
79 
		}
 74 
		}
80 
		if ($res)
 - 
 
81 
		{
 75 
		if ($res) {
82 
			echo "Daten wurden erfolgreich geändert!";
 - 
 
83 
		}
 76 
			echo "Daten wurden erfolgreich geändert!";
84 
		else
 - 
 
85 
		{
 77 
		} else {
86 
			echo "Leider ist ein Fehler aufgetreten. Bitte versuchen Sie es später noch einmal!";
 78 
			echo "Leider ist ein Fehler aufgetreten. Bitte versuchen Sie es später noch einmal!";
87 
		}
 79 
		}
88 
	}
 80 
	}
89
81 
 
90 
	public function del($id)
 82 
	public function del($id)
91 
	{
 83 
	{
92 
		$sql = "DELETE FROM
 84 
		$sql = "DELETE FROM
93 
				logistiker
 85 
				logistiker
94 
			WHERE
 86 
			WHERE
95 
				id=".$id."
 87 
				id=" . $id . "
96 
		";
 88 
		";
97 
		$res = $this->db->query($sql);
 89 
		$res = $this->db->query($sql);
98 
		if ($res)
 - 
 
99 
		{
 90 
		if ($res) {
100 
			echo "Logistiker wurde erfolgreich gelöscht!";
 - 
 
101 
		}
 91 
			echo "Logistiker wurde erfolgreich gelöscht!";
102 
		else
 - 
 
103 
		{
 92 
		} else {
104 
			echo "Leider ist ein Fehler aufgetreten. Bitte versuchen Sie es später noch einmal!";
 93 
			echo "Leider ist ein Fehler aufgetreten. Bitte versuchen Sie es später noch einmal!";
105 
		}
 94 
		}
Zeile 106... Zeile 95...
106 
	}
 95 
	}
Zeile 114... Zeile 103...
114 
			$sOrder = "ORDER BY  ";
 103 
			$sOrder = "ORDER BY  ";
115 
			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
 104 
			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
116 
				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
 105 
				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
117 
					"true") {
 106 
					"true") {
118 
					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
 107 
					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
119 
                                    " . $this->input->get('sSortDir_' . $i) .
 108 
									" . $this->input->get('sSortDir_' . $i) . ", ";
120 
						", ";
 - 
 
121 
				}
 109 
				}
122 
			}
 110 
			}
Zeile 123... Zeile 111...
123 
 
 111 
 
124 
			$sOrder = substr_replace($sOrder, "", -2);
 112 
			$sOrder = substr_replace($sOrder, "", -2);
125 
			if ($sOrder == "ORDER BY") {
 113 
			if ($sOrder == "ORDER BY") {
126 
				$sOrder = "";
 114 
				$sOrder = "";
127 
			}
 115 
			}
128 
		}
 116 
		}
129 
		$sQuery = "SELECT DISTINCT
 117 
		$sQuery = "SELECT DISTINCT
130 
                    exported
 118 
					exported
131 
                FROM
 119 
				FROM
132 
                    artikel_to_Bestellung ab
 120 
					artikel_to_Bestellung ab
133 
                JOIN
 121 
				JOIN
134 
                    bestellung_logistiker bl
 122 
					bestellung_logistiker bl
135 
                ON
 123 
				ON
136 
                    bl.logistiker=$id
 124 
					bl.logistiker=$id
137 
                AND
 125 
				AND
138 
                    bl.bestellung = ab.Bestellung
 126 
					bl.bestellung = ab.Bestellung
139 
                WHERE
 127 
				WHERE
140 
                    exported
 128 
					exported
141 
 
 129 
 
142 
                " . $sOrder . "
 130 
				" . $sOrder . "
143 
                LIMIT " . $sLimit . "
 131 
				LIMIT " . $sLimit . "
144 
            ";
 132 
			";
145 
		trigger_error($sQuery);
 133 
		trigger_error($sQuery);
Zeile 146... Zeile 134...
146 
		$rResult = $GLOBALS['order_db']->query($sQuery);
 134 
		$rResult = $GLOBALS['order_db']->query($sQuery);
147 
 
 135 
 
148 
		/* Data set length after filtering */
 136 
		/* Data set length after filtering */
149 
		$sQuery = "
 137 
		$sQuery = "
150 
                        SELECT FOUND_ROWS() AS total
 138 
						SELECT FOUND_ROWS() AS total
151 
                ";
 139 
				";
152 
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);
 140 
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);
Zeile 153... Zeile 141...
153 
		$aResultFilterTotal = $rResultFilterTotal->unbuffered_row('array');
 141 
		$aResultFilterTotal = $rResultFilterTotal->unbuffered_row('array');
154 
		$iFilteredTotal = $aResultFilterTotal["total"];
 142 
		$iFilteredTotal = $aResultFilterTotal["total"];
155 
 
 143 
 
156 
		/* Total data set length */
 144 
		/* Total data set length */
157 
		$sQuery = "
 145 
		$sQuery = "
158 
                        SELECT
 146 
			SELECT
159 
                    COUNT(" . $sIndexColumn . ") AS total
 147 
				COUNT(" . $sIndexColumn . ") AS total
160 
                FROM
 148 
			FROM
161 
                    artikel_to_Bestellung ab
 149 
				artikel_to_Bestellung ab
162 
                JOIN
 150 
			JOIN
163 
                    bestellung_logistiker bl
 151 
				bestellung_logistiker bl
164 
                ON
 152 
			ON
165 
                    bl.logistiker=$id
 153 
				bl.logistiker=$id
166 
                AND
 154 
			AND
167 
                    bl.bestellung = ab.Bestellung
 155 
				bl.bestellung = ab.Bestellung
168 
                WHERE
 156 
			WHERE
169 
                    exported
 157 
				exported
170 
                ";
 158 
		";
Zeile 181... Zeile 169...
181 
			"iTotalRecords" => $iTotal,
 169 
			"iTotalRecords" => $iTotal,
182 
			"iTotalDisplayRecords" => $iTotal,
 170 
			"iTotalDisplayRecords" => $iTotal,
183 
			"aaData" => array());
 171 
			"aaData" => array());
Zeile 184... Zeile 172...
184 
 
 172 
 
185 
		$sql = "SELECT
 173 
		$sql = "SELECT
186 
                    export_script
 174 
				export_script
187 
                FROM
 175 
			FROM
188 
                    logistiker
 176 
				logistiker
189 
                WHERE
 177 
			WHERE
190 
                    id = " . $id . "
 178 
				id = " . $id . "
191 
            ";
 179 
		";
192 
		$res = $GLOBALS['order_db']->query($sql);
 180 
		$res = $GLOBALS['order_db']->query($sql);
193 
		$nrow = $res->unbuffered_row('array');
 181 
		$nrow = $res->unbuffered_row('array');
194 
		if (strstr($nrow["export_script"], "=")) {
 182 
		if (strstr($nrow["export_script"], "=")) {
195 
			$qs = explode(";", $nrow["export_script"]);
 183 
			$qs = explode(";", $nrow["export_script"]);
Zeile 240... Zeile 228...
240 
			$sOrder = "ORDER BY  ";
 228 
			$sOrder = "ORDER BY  ";
241 
			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
 229 
			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
242 
				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
 230 
				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
243 
					"true") {
 231 
					"true") {
244 
					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
 232 
					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
245 
                                    " . $this->input->get('sSortDir_' . $i) .
 233 
									" . $this->input->get('sSortDir_' . $i) . ", ";
246 
						", ";
 - 
 
247 
				}
 234 
				}
248 
			}
 235 
			}
Zeile 249... Zeile 236...
249 
 
 236 
 
250 
			$sOrder = substr_replace($sOrder, "", -2);
 237 
			$sOrder = substr_replace($sOrder, "", -2);
Zeile 295... Zeile 282...
295 
			$sWhere = " where bp.logistiker=l.id AND l.id = $id ";
 282 
			$sWhere = " where bp.logistiker=l.id AND l.id = $id ";
296 
		} else {
 283 
		} else {
297 
			$sWhere = " $sWhere and bp.logistiker=l.id AND l.id = $id ";
 284 
			$sWhere = " $sWhere and bp.logistiker=l.id AND l.id = $id ";
298 
		}
 285 
		}
299 
		$sLimit = $this->input->get('iDisplayStart') . "," . $this->input->get('iDisplayLength');
 286 
		$sLimit = $this->input->get('iDisplayStart') . "," . $this->input->get('iDisplayLength');
300 
		$sQuery = "SELECT
 287 
		$sQuery = "
- 
 
 288 
			SELECT
301 
                    SQL_CALC_FOUND_ROWS
 289 
				SQL_CALC_FOUND_ROWS
302 
                    bp.*,
 290 
				bp.*,
303 
                    l.kname,
 291 
				l.kname,
304 
                    l.trackinglink
 292 
				l.trackinglink
305 
                FROM
 293 
			FROM
306 
                    logistiker l,
 294 
				logistiker l,
307 
                    bestellung_paketnummern bp
 295 
				bestellung_paketnummern bp
308 
                    " . $sWhere . "
 296 
				" . $sWhere . "
309 
                    " . $sOrder . "
 297 
				" . $sOrder . "
310 
					LIMIT " . $sLimit . "
 298 
				LIMIT " . $sLimit . "
311 
                ";
 299 
		";
312 
		//echo $sQuery;
 300 
		//echo $sQuery;
313 
		$rResult = $GLOBALS['order_db']->query($sQuery);
 301 
		$rResult = $GLOBALS['order_db']->query($sQuery);
Zeile 314... Zeile 302...
314 
 
 302 
 
315 
		/* Data set length after filtering */
 303 
		/* Data set length after filtering */
316 
		$sQuery = "
 304 
		$sQuery = "
317 
                        SELECT FOUND_ROWS() AS total
 305 
			SELECT FOUND_ROWS() AS total
318 
                ";
 306 
		";
319 
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);
 307 
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);
320 
		$aResultFilterTotal = $rResultFilterTotal->unbuffered_row('array');
 308 
		$aResultFilterTotal = $rResultFilterTotal->unbuffered_row('array');
Zeile 321... Zeile 309...
321 
		$iFilteredTotal = $aResultFilterTotal["total"];
 309 
		$iFilteredTotal = $aResultFilterTotal["total"];
322 
 
 310 
 
323 
		/* Total data set length */
 311 
		/* Total data set length */
324 
		$sQuery = "
 312 
		$sQuery = "
325 
                        SELECT
 313 
			SELECT
326 
                    COUNT(bp.id) AS total
 314 
				COUNT(bp.id) AS total
327 
                FROM
 315 
			FROM
328 
                    logistiker l,
 316 
				logistiker l,
329 
                    bestellung_paketnummern bp
 317 
				bestellung_paketnummern bp
330 
                WHERE
 318 
			WHERE
331 
                    bp.logistiker=l.id
 319 
				bp.logistiker=l.id
332 
                AND
 320 
			AND
Zeile 333... Zeile 321...
333 
                    l.id = $id
 321 
				l.id = $id
334 
                ";
 322 
		";
335 
 
 323