Revize 282c9938

Feature #8345 Implementce filterů dat - Server

oprava chyb vracení záznamů

application/controller/TableController.php

@@ -34 +34 @@
         array_push($temp_value->manuscript, $res["manuscript"]);
     }
 }
+
+if ($temp_value != null) {
+    array_push($output["data"], $temp_value);
+}
 $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']);
@@ -47 +51 @@
     $whereQuery = "WHERE";
     if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $array['lemma'] = $_POST['lemma']."%";
-        $whereQuery .= " l.lemma LIKE :lemma AND";
+        $whereQuery .= " upper(l.lemma) LIKE upper(:lemma) AND";
     }
     if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
         $array['word'] = $_POST['word'];
-        $whereQuery .= " w.word = :word AND";
+        $whereQuery .= " upper(w.word) = upper(:word) AND";
     }
     if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
         $array['position1'] = $_POST['position1'];
@@ -118 +122 @@
         $tag = substr_replace($tag, $_POST['tag_verb_aspect'], 11, 1);
     }
     $array['tag'] = $tag;
-    $whereQuery .= " t.tag LIKE :tag";
+    $whereQuery .= " upper(t.tag) LIKE upper(:tag)";
     return $whereQuery;
 }