WebSVN – lars-tiefland.ci – Diff – /backend/models/Logistiker_model.php



/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 2288 $
 */

 
class Logistiker_model extends CI_Model
{

                $sWhere
                $sOrder
                $sLimit
            ";

 

		$rResult = $GLOBALS['order_db']->query($sQuery);
 
		/* Data set length after filtering */
		$sQuery = "
                        SELECT FOUND_ROWS() AS total
                ";
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);

		$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');
		$iFilteredTotal = $aResultFilterTotal["total"];

                AND
                    bl.bestellung = ab.Bestellung
                WHERE
                    exported
                ";
		$rResultTotal = $GLOBALS['order_db']->query($sQuery);
		$aResultTotal = $aResultTotal->unbuffert_row('array');
		$iTotal = $aResultTotal["total"];

 

                FROM
                    logistiker
                WHERE
                    id = " . $id . "
            ";
		$res = $GLOBALS['order_db']->query($sql);
		$nrow = $res->unbuffered_row('array');
		if (strstr($nrow["export_script"], "=")) {
			$qs = explode(";", $nrow["export_script"]);
			foreach ($qs as $val) {
				list($key, $wert) = explode("=", $val);

		if ($this->input->get('sSearch') != "") {
			$sWhere = "WHERE (";
			for ($i = 0; $i < count($aColumns); $i++) {
				if ($aColumns[$i] == "datum") {
					$a = " from_unixtime(datum) ";
					$sWhere .= $a . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch')) .
						"%' OR ";
				} else {
					$sWhere .= $aColumns[$i] . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->
						get('sSearch')) . "%' OR ";
				}

 
			}

				} else {
					$sWhere .= " AND ";
				}
				if ($aColumns[$i] == "datum") {
					$r = " from_unixtime(datum) ";
					$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .
						$i)) . "%' ";
				} else {
					$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .
						$i)) . "%' ";
				}

 
			}

 
                    $sOrder
                        $sLimit
                ";
		//echo $sQuery;

		$rResult = $GLOBALS['order_db']->query($sQuery);
 
		/* Data set length after filtering */
		$sQuery = "
                        SELECT FOUND_ROWS() AS total
                ";
		$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);

		$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');
		$iFilteredTotal = $aResultFilterTotal["total"];

                AND
                    l.id = $id
                ";

 
 
		$rResultTotal = $GLOBALS['order_db']->query($sQuery);

		$aResultTotal = $aResultTotal->unbuffert_row('array');

Revision 2287	Revision 2288
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: 2287 $`	8	`* @version $Rev: 2288 $`
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 65...	Zeile 65...
65	`$sWhere`	65	`$sWhere`
66	`$sOrder`	66	`$sOrder`
67	`$sLimit`	67	`$sLimit`
68	`";`	68	`";`
Zeile 69...	Zeile 69...
69		69
Zeile 70...	Zeile 70...
70	`$rResult = $this->order_db->query($sQuery);`	70	`$rResult = $GLOBALS['order_db']->query($sQuery);`
71		71
72	`/* Data set length after filtering */`	72	`/* Data set length after filtering */`
73	`$sQuery = "`	73	`$sQuery = "`
74	`SELECT FOUND_ROWS() AS total`	74	`SELECT FOUND_ROWS() AS total`
75	`";`	75	`";`
76	`$rResultFilterTotal = $this->order_db->query($sQuery);`	76	`$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);`
Zeile 77...	Zeile 77...
77	`$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');`	77	`$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');`
78	`$iFilteredTotal = $aResultFilterTotal["total"];`	78	`$iFilteredTotal = $aResultFilterTotal["total"];`
Zeile 90...	Zeile 90...
90	`AND`	90	`AND`
91	`bl.bestellung = ab.Bestellung`	91	`bl.bestellung = ab.Bestellung`
92	`WHERE`	92	`WHERE`
93	`exported`	93	`exported`
94	`";`	94	`";`
95	`$rResultTotal = $this->order_db->query($sQuery);`	95	`$rResultTotal = $GLOBALS['order_db']->query($sQuery);`
96	`$aResultTotal = $aResultTotal->unbuffert_row('array');`	96	`$aResultTotal = $aResultTotal->unbuffert_row('array');`
97	`$iTotal = $aResultTotal["total"];`	97	`$iTotal = $aResultTotal["total"];`
Zeile 98...	Zeile 98...
98		98
Zeile 111...	Zeile 111...
111	`FROM`	111	`FROM`
112	`logistiker`	112	`logistiker`
113	`WHERE`	113	`WHERE`
114	`id = " . $id . "`	114	`id = " . $id . "`
115	`";`	115	`";`
116	`$res = $this->order_db->query($sql);`	116	`$res = $GLOBALS['order_db']->query($sql);`
117	`$nrow = $res->unbuffered_row('array');`	117	`$nrow = $res->unbuffered_row('array');`
118	`if (strstr($nrow["export_script"], "=")) {`	118	`if (strstr($nrow["export_script"], "=")) {`
119	`$qs = explode(";", $nrow["export_script"]);`	119	`$qs = explode(";", $nrow["export_script"]);`
120	`foreach ($qs as $val) {`	120	`foreach ($qs as $val) {`
121	`list($key, $wert) = explode("=", $val);`	121	`list($key, $wert) = explode("=", $val);`
Zeile 159...	Zeile 159...
159	`if ($this->input->get('sSearch') != "") {`	159	`if ($this->input->get('sSearch') != "") {`
160	`$sWhere = "WHERE (";`	160	`$sWhere = "WHERE (";`
161	`for ($i = 0; $i < count($aColumns); $i++) {`	161	`for ($i = 0; $i < count($aColumns); $i++) {`
162	`if ($aColumns[$i] == "datum") {`	162	`if ($aColumns[$i] == "datum") {`
163	`$a = " from_unixtime(datum) ";`	163	`$a = " from_unixtime(datum) ";`
164	`$sWhere .= $a . " LIKE '%" . $this->order_db->escape($this->input->get('sSearch')) .`	164	`$sWhere .= $a . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch')) .`
165	`"%' OR ";`	165	`"%' OR ";`
166	`} else {`	166	`} else {`
167	`$sWhere .= $aColumns[$i] . " LIKE '%" . $this->order_db->escape($this->input->`	167	`$sWhere .= $aColumns[$i] . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->`
168	`get('sSearch')) . "%' OR ";`	168	`get('sSearch')) . "%' OR ";`
169	`}`	169	`}`
Zeile 170...	Zeile 170...
170		170
171	`}`	171	`}`
Zeile 182...	Zeile 182...
182	`} else {`	182	`} else {`
183	`$sWhere .= " AND ";`	183	`$sWhere .= " AND ";`
184	`}`	184	`}`
185	`if ($aColumns[$i] == "datum") {`	185	`if ($aColumns[$i] == "datum") {`
186	`$r = " from_unixtime(datum) ";`	186	`$r = " from_unixtime(datum) ";`
187	`$sWhere .= $r . " LIKE '%" . $this->order_db->escape($this->input->get('sSearch_' .`	187	`$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .`
188	`$i)) . "%' ";`	188	`$i)) . "%' ";`
189	`} else {`	189	`} else {`
190	`$sWhere .= $r . " LIKE '%" . $this->order_db->escape($this->input->get('sSearch_' .`	190	`$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .`
191	`$i)) . "%' ";`	191	`$i)) . "%' ";`
192	`}`	192	`}`
Zeile 193...	Zeile 193...
193		193
194	`}`	194	`}`
Zeile 212...	Zeile 212...
212		212
213	`$sOrder`	213	`$sOrder`
214	`$sLimit`	214	`$sLimit`
215	`";`	215	`";`
216	`//echo $sQuery;`	216	`//echo $sQuery;`
Zeile 217...	Zeile 217...
217	`$rResult = $this->order_db->query($sQuery);`	217	`$rResult = $GLOBALS['order_db']->query($sQuery);`
218		218
219	`/* Data set length after filtering */`	219	`/* Data set length after filtering */`
220	`$sQuery = "`	220	`$sQuery = "`
221	`SELECT FOUND_ROWS() AS total`	221	`SELECT FOUND_ROWS() AS total`
222	`";`	222	`";`
223	`$rResultFilterTotal = $this->order_db->query($sQuery);`	223	`$rResultFilterTotal = $GLOBALS['order_db']->query($sQuery);`
Zeile 224...	Zeile 224...
224	`$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');`	224	`$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');`
225	`$iFilteredTotal = $aResultFilterTotal["total"];`	225	`$iFilteredTotal = $aResultFilterTotal["total"];`
Zeile 236...	Zeile 236...
236	`AND`	236	`AND`
237	`l.id = $id`	237	`l.id = $id`
238	`";`	238	`";`
Zeile 239...	Zeile 239...
239		239
240		240
241	`$rResultTotal = $this->order_db->query($sQuery);`	241	`$rResultTotal = $GLOBALS['order_db']->query($sQuery);`
Zeile 242...	Zeile 242...
242	`$aResultTotal = $aResultTotal->unbuffert_row('array');`	242	`$aResultTotal = $aResultTotal->unbuffert_row('array');`

Subversion-Projekte lars-tiefland.ci

(root)/backend/models/Logistiker_model.php – Revision 2287 → 2288