Revize b9ed6a80

Feature #8345 Implementce filterů dat - Server

vytvořené objekty databáze, posílání json objektu klientu

application/controller/TableController.php

@@ -1 +1 @@
 <?php
 require "../model/DB.php";
+require "../model/Tag.php";
+require "../model/Word.php";
 $DB = new DB();
 
 // (B) SEARCH FOR USERS
 $results = $DB->select(
-    "SELECT * FROM dd_wordform limit 10"
+    "SELECT w.id, w.context, w.date, w.description, w.description2, w.description3, w.ending, w.finished,
+w.namedentity, w.position1, w.position2, w.positiondetail, w.word, w.tag_id, w.lemma_id, t.tag, l.lemma, l.pos FROM dd_wordform as w left join dd_tag as t on w.tag_id = t.id left join dd_lemma as l on w.lemma_id = l.id order by w.id LIMIT 100"
 );
 
-// (C) OUTPUT RESULTS
-$result = json_encode(count($results)==0 ? null : $results);
+var_dump($results);
+
+$output = Array();
+foreach ($results as $res) {
+    $tag = new Tag($res["tag_id"], $res["tag"]);
+    $lemma = new Lemma($res["lemma_id"], $res["lemma"], $res["pos"]);
+    $word = new Word($res["id"],  $res["context"], $res["date"], $res["description"], $res["description2"], $res["description3"], $res["ending"],
+        $res["finished"], $res["namedentity"], $res["position1"], $res["position2"], $res["positiondetail"], $res["word"], $lemma, $tag);
+    array_push($output, $word);
+}
+
+$result = json_encode(count($output)==0 ? null : $output);
 echo $result;