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 
			}