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']);

application/model/DB.php

@@ -45 +45 @@
             if (array_key_exists("tag", $params)) {
                 $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
             }
+            if (array_key_exists("tag", $params)) {
+                $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("finished", $params)) {
+                $this->stmt->bindParam(':finished',$params['finished']);
+            }
             if (array_key_exists("manuscript", $params)) {
                 for ($x = 0; $x < count($params["manuscript"]); $x += 1) {
                     $this->stmt->bindParam(':manuscript'.$x,$params["manuscript"][$x], PDO::PARAM_INT);

application/view/Index.php

@@ -6 +6 @@
     function doSearch () {
         // (A1) GET SEARCH TERM
         var data = new FormData();
-        data.append("manuscript", "0,3"); //příklad pro filtraci manuscriptů, asi se ještě upraví
-        // data.append("lemma", "ok");
+        //data.append("manuscript", "0,3"); //příklad pro filtraci manuscriptů, asi se ještě uprav
+        data.append("page", "1");
+        data.append("items_per_page", "50");
+        data.append("finished", "false");
         // data.append("tag_pos", "V");
         // data.append("tag_verb_aspect", "P");
         // data.append("tag_number", "S");