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

 /**
+ *
  * @package WebanOS CI
  * @author Lars Tiefland <ltiefland@gmail.com>
  * @copyright 2016
- * @version $Rev: 2296 $
+ * @version $Rev: 2297 $
  */
 class Logistiker_model extends CI_Model
+{
 		if (empty($sWhere)) {
 			$sWhere = " where bp.logistiker=l.id AND l.id = $id ";
 		} else {
 			$sWhere = " $sWhere and bp.logistiker=l.id AND l.id = $id ";
+		}
+		$sLimit = $this->input->get('iDisplayStart') . "," . $this->input->get('iDisplayLength');
 		$sQuery = "SELECT
                     SQL_CALC_FOUND_ROWS
                     bp.*,
                     l.kname,
                     l.trackinglink
                 FROM
                     logistiker l,
                     bestellung_paketnummern bp
-                    $sWhere
+                    " . $sWhere . "
-                    $sOrder
+                    " . $sOrder . "
-                        $sLimit
+					" . $sLimit . "
                 ";
 		//echo $sQuery;
 		$rResult = $GLOBALS['order_db']->query($sQuery);

Subversion-Projekte lars-tiefland.ci