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

 /**
+ *
  * @package WebanOS CI
  * @author Lars Tiefland <ltiefland@gmail.com>
  * @copyright 2016
- * @version $Rev: 2364 $
+ * @version $Rev: 2365 $
  */
 class Logistiker_model extends CI_Model
+{
 			$sOrder = substr_replace($sOrder, "", -2);
 			if ($sOrder == "ORDER BY") {
 				$sOrder = "";
+			}
+		}
+		$sQuery = "
-		$sQuery = "SELECT DISTINCT
+			SELECT DISTINCT
-					exported
+				exported
-				FROM
+			FROM
-					artikel_to_Bestellung ab
+				artikel_to_Bestellung ab
-				JOIN
+			JOIN
-					bestellung_logistiker bl
+				bestellung_logistiker bl
-				ON
+			ON
-					bl.logistiker=$id
+				bl.logistiker=$id
-				AND
+			AND
-					bl.bestellung = ab.Bestellung
+				bl.bestellung = ab.Bestellung
-				WHERE
+			WHERE
-					exported
+				exported
-				" . $sOrder . "
+			" . $sOrder . "
-				LIMIT " . $sLimit . "
+			LIMIT " . $sLimit . "
-			";
+		";
 		trigger_error($sQuery);
 		$rResult = $GLOBALS['order_db']->query($sQuery);
 				l.kname,
 				l.trackinglink
 			FROM
 				logistiker l,
 				bestellung_paketnummern bp
-				" . $sWhere . "
+			" . $sWhere . "
-				" . $sOrder . "
+			" . $sOrder . "
-				LIMIT " . $sLimit . "
+			LIMIT " . $sLimit . "
 		";
 		//echo $sQuery;
 		$rResult = $GLOBALS['order_db']->query($sQuery);

Subversion-Projekte lars-tiefland.ci