aswi2021mr-proper-gitlab/application/controller/TableController.php @ 082263b5

<?php
require "../model/DB.php";
require "../model/Tag.php";
require "../model/Word.php";
require "../model/Lemma.php";
$DB = new DB();

$parArray = Array();
$whereQuery = createWhereQuery($parArray);

$results = $DB->select(
        "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, m.manuscript,
l.pos FROM dd_manuscript as m left join dd_wordform as w on m.wordform_id = w.id left join dd_tag as t on w.tag_id = t.id left join dd_lemma as l on w.lemma_id = l.id ".$whereQuery." order by w.id", $parArray);

$output = Array();
$output["data"] = Array();
$temp_value = null;
foreach ($results as $res) {
    if ($temp_value != null && $res["id"] != $temp_value->id) {
        array_push($output["data"], $temp_value);
        $temp_value = null;
    }
    if ($temp_value == null) {
        $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);
        if (array_key_exists("manuscript", $res)) {
            array_push($word->manuscript, $res["manuscript"]);
        }
        $temp_value = $word;
    } else {
        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']);
} else {
    $output["data"] = array_slice($output["data"], 0, 50);
}
echo json_encode(count($output)==0 ? null : $output);


function createWhereQuery(&$array) {
    $whereQuery = "WHERE";
    if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
        $array['lemma'] = $_POST['lemma']."%";
        $whereQuery .= " upper(l.lemma) LIKE upper(:lemma) AND";
    }
    if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
        $array['word'] = $_POST['word'];
        $whereQuery .= " upper(w.word) = upper(:word) AND";
    }
    if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
        $array['position1'] = $_POST['position1'];
        $whereQuery .= " w.position1 = :position1 AND";
    }
    if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
        $array['position2'] = $_POST['position2'];
        $whereQuery .= " w.position2 = :position2 AND";
    }
    if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
        $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']);
        $whereQuery .= " m.manuscript in (";
        for ($x = 0; $x < count($nums); $x += 1) {
            $array['manuscript'][$x] = $nums[$x];
            $whereQuery .= ":manuscript".$x.",";
        }
        $whereQuery = substr_replace($whereQuery, "", -1, 1);
        $whereQuery .= ") AND";
    }
    $tag = "____________%";
    if (array_key_exists("tag_pos", $_POST) && $_POST['tag_pos'] != "") {
        $tag = substr_replace($tag, $_POST['tag_pos'], 0, 1);
    }
    if (array_key_exists("tag_case", $_POST) && $_POST['tag_case'] != "") {
        $tag = substr_replace($tag, $_POST['tag_case'], 1, 1);
    }
    if (array_key_exists("tag_number", $_POST) && $_POST['tag_number'] != "") {
        $tag = substr_replace($tag, $_POST['tag_number'], 2, 1);
    }
    if (array_key_exists("tag_gender", $_POST) && $_POST['tag_gender'] != "") {
        $tag = substr_replace($tag, $_POST['tag_gender'], 3, 1);
    }
    if (array_key_exists("tag_degree", $_POST) && $_POST['tag_degree'] != "") {
        $tag = substr_replace($tag, $_POST['tag_degree'], 4, 1);
    }
    if (array_key_exists("tag_shape", $_POST) && $_POST['tag_shape'] != "") {
        $tag = substr_replace($tag, $_POST['tag_shape'], 5, 1);
    }
    if (array_key_exists("tag_num", $_POST) && $_POST['tag_num'] != "") {
        $tag = substr_replace($tag, $_POST['tag_num'], 6, 1);
    }
    if (array_key_exists("tag_sentence", $_POST) && $_POST['tag_sentence'] != "") {
        $tag = substr_replace($tag, $_POST['tag_sentence'], 7, 1);
    }
    if (array_key_exists("tag_verb_person", $_POST) && $_POST['tag_verb_person'] != "") {
        $tag = substr_replace($tag, $_POST['tag_verb_person'], 8, 1);
    }
    if (array_key_exists("tag_verb_time", $_POST) && $_POST['tag_verb_time'] != "") {
        $tag = substr_replace($tag, $_POST['tag_verb_time'], 9, 1);
    }
    if (array_key_exists("tag_verb_degree", $_POST) && $_POST['tag_verb_degree'] != "") {
        $tag = substr_replace($tag, $_POST['tag_verb_degree'], 10, 1);
    }
    if (array_key_exists("tag_verb_aspect", $_POST) && $_POST['tag_verb_aspect'] != "") {
        $tag = substr_replace($tag, $_POST['tag_verb_aspect'], 11, 1);
    }
    $array['tag'] = $tag;
    $whereQuery .= " upper(t.tag) LIKE upper(:tag)";
    return $whereQuery;
}