Revize 12de28ea

Feature #8638 Implementovat filtr pro Poznámka 2

application/controller/TableController.php

@@ -53 +53 @@
         $array['lemma'] = $_POST['lemma']."%";
         $whereQuery .= " upper(l.lemma) LIKE upper(:lemma) AND";
     }
+    if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
+        $array['description2'] = "%".$_POST['description2']."%";
+        $whereQuery .= " upper(description2) LIKE upper(:description2) AND";
+    }
     if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
         $array['word'] = $_POST['word'];
         $whereQuery .= " upper(w.word) = upper(:word) AND";

application/model/DB.php

@@ -51 +51 @@
             if (array_key_exists("finished", $params)) {
                 $this->stmt->bindParam(':finished',$params['finished']);
             }
+            if (array_key_exists("description2", $params)) {
+                $this->stmt->bindParam(':description2',$params['description2']);
+            }
             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);