Revize 7f347c4a

Feature #8345 Implementce filterů dat - Server

stránkování na serveru

application/controller/TableController.php

@@ -21 +21 @@
 }
 
 $output = Array();
+$output["data"] = Array();
 $temp_value = null;
 foreach ($results as $res) {
     if ($temp_value != null && $res["id"] != $temp_value->id) {
-        array_push($output, $temp_value);
+        array_push($output["data"], $temp_value);
         $temp_value = null;
     }
     if ($temp_value == null) {
@@ -40 +41 @@
         array_push($temp_value->manuscript, $res["manuscript"]);
     }
 }
+$output["count"] = count($output["data"]);
+if (array_key_exists("page", $_POST) && array_key_exists("items_per_page", $_POST)) {
+    $output["data"] = array_slice($output["data"], $_POST['page'] * $_POST['items_per_page'], $_POST['items_per_page']);
+} else {
+    $output["data"] = array_slice($output["data"], 0, 50);
+}
 echo json_encode(count($output)==0 ? null : $output);
 
 
@@ -65 +72 @@
         $array['positiondetail'] = $_POST['positiondetail'];
         $whereQuery .= " w.positiondetail = :positiondetail AND";
     }
+    if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
+        $array['finished'] = $_POST['finished'];
+        $whereQuery .= " w.finished = :finished AND";
+    }
     if (array_key_exists("manuscript", $_POST) && $_POST['manuscript'] != "") {
         $array['manuscript'] = Array();
         $nums = explode(",", $_POST['manuscript']);