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;

application/model/Lemma.php

@@ +1 @@
+<?php
+
+class Lemma {
+    public $id;
+    public $lemma;
+    public $pos;
+
+    public function __construct($id, $lemma, $pos)
+    {
+        $this->id = $id;
+        $this->lemma = $lemma;
+        $this->pos = $pos;
+    }
+}

application/model/Tag.php

@@ +1 @@
+<?php
+
+class Tag {
+    public $id;
+    public $tag;
+
+    function __construct($id, $tag)
+    {
+        $this->id = $id;
+        $this->tag = $tag;
+    }
+}

application/model/Word.php

@@ +1 @@
+<?php
+class Word {
+    public $id;
+    public $context;
+    public $date;
+    public $description;
+    public $description2;
+    public $description3;
+    public $ending;
+    public $finished;
+    public $namedentity;
+    public $position1;
+    public $position2;
+    public $positiondetail;
+    public $word;
+    public $lemma;
+    public $tag;
+
+    function __construct($id, $context, $date, $description, $description2, $description3, $ending, $finished, $namedentity, $position1, $position2, $positiondetail, $word, $lemma, $tag)
+    {
+        $this->id = $id;
+        $this->context = $context;
+        $this->date = $date;
+        $this->description = $description;
+        $this->description2 = $description2;
+        $this->description3 = $description3;
+        $this->ending = $ending;
+        $this->finished = $finished;
+        $this->namedentity = $namedentity;
+        $this->position1 = $position1;
+        $this->position2 = $position2;
+        $this->positiondetail = $positiondetail;
+        $this->word = $word;
+        $this->lemma = $lemma;
+        $this->tag = $tag;
+    }
+}

application/view/Index.php

@@ -6 +6 @@
     function doSearch () {
         // (A1) GET SEARCH TERM
         var data = new FormData();
-
         // (A2) AJAX - USE HTTP:// NOT FILE://
         var xhr = new XMLHttpRequest();
         xhr.open("POST", "../controller/TableController.php");