Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 2365 Revision 2367
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: 2365 $
8
 * @version $Rev: 2367 $
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 244... Zeile 244...
244
		if ($this->input->get('sSearch') != "") {
244
		if ($this->input->get('sSearch') != "") {
245
			$sWhere = "WHERE (";
245
			$sWhere = "WHERE (";
246
			for ($i = 0; $i < count($aColumns); $i++) {
246
			for ($i = 0; $i < count($aColumns); $i++) {
247
				if ($aColumns[$i] == "datum") {
247
				if ($aColumns[$i] == "datum") {
248
					$a = " from_unixtime(datum) ";
248
					$a = " from_unixtime(datum) ";
249
					$sWhere .= $a . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch')) .
249
					$sWhere .= $a . " LIKE '%" . $this->input->get('sSearch') . "%' OR ";
250
						"%' OR ";
-
 
251
				} else {
250
				} else {
252
					$sWhere .= $aColumns[$i] . " LIKE '%" . $GLOBALS['order_db']->escape($this->
251
					$sWhere .= $aColumns[$i] . " LIKE '%" . $this->input->get('sSearch') . "%' OR ";
253
						input->get('sSearch')) . "%' OR ";
-
 
254
				}
252
				}
Zeile 255... Zeile 253...
255
 
253
 
256
			}
254
			}
257
			$sWhere = substr_replace($sWhere, "", -3);
255
			$sWhere = substr_replace($sWhere, "", -3);
Zeile 267... Zeile 265...
267
				} else {
265
				} else {
268
					$sWhere .= " AND ";
266
					$sWhere .= " AND ";
269
				}
267
				}
270
				if ($aColumns[$i] == "datum") {
268
				if ($aColumns[$i] == "datum") {
271
					$r = " from_unixtime(datum) ";
269
					$r = " from_unixtime(datum) ";
272
					$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .
270
					$sWhere .= $r . " LIKE '%" . $this->input->get('sSearch_' . $i) . "%' ";
273
						$i)) . "%' ";
-
 
274
				} else {
271
				} else {
275
					$sWhere .= $r . " LIKE '%" . $GLOBALS['order_db']->escape($this->input->get('sSearch_' .
272
					$sWhere .= $r . " LIKE '%" . $this->input->get('sSearch_' . $i) . "%' ";
276
						$i)) . "%' ";
-
 
277
				}
273
				}
Zeile 278... Zeile 274...
278
 
274
 
279
			}
275
			}