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

 /**
+ *
  * @package WebanOS CI
  * @author Lars Tiefland <ltiefland@gmail.com>
  * @copyright 2016
- * @version $Rev: 2304 $
+ * @version $Rev: 2305 $
  */
 class Logistiker_model extends CI_Model
+{
 		$aColumns = array(
 			'paketnummer',
 			'datum',
 			'bestellung',
 			);
+		if (isset($_GET['iSortCol_0'])) {
+			$sOrder = "ORDER BY  ";
+			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
+				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
+					"true") {
+					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
+                                    " . $GLOBALS["order_db"]->escape($this->
+						input->get('sSortDir_' . $i)) . ", ";
+				}
+			}
-		trigger_error(var_export($_GET, true));
+			$sOrder = substr_replace($sOrder, "", -2);
+			if ($sOrder == "ORDER BY") {
+				$sOrder = "";
+			}
+		}
 		$sWhere = "";
 		if ($this->input->get('sSearch') != "") {
 			$sWhere = "WHERE (";
 			for ($i = 0; $i < count($aColumns); $i++) {
 				if ($aColumns[$i] == "datum") {
 			"iTotalRecords" => $iTotal,
 			"iTotalDisplayRecords" => $iFilteredTotal,
 			"aaData" => array());
-		while ($aRow = $rResult->unbuffered_row('array')) {
-			trigger_error(var_export($aRow, true));
+		while ($aRow = $rResult->unbuffered_row('array')) {
 			//$aRow['datum'] = strtotime($aRow['datum']);
 			$aRow['datum'] = date('d.m.Y', $aRow['datum']);
 			$aRow['bestellung'] = ' <a href="/Warenwirtschaft/bestellungen.php?Bestellung=' .

Subversion-Projekte lars-tiefland.ci

(root)/backend/models/Logistiker_model.php – Revision 2304 → 2305