Revize b315cd75

Feature #8524 Metoda pro tvorbu nových záznamů

application/controller/UpdateController.php

@@ -1 +1 @@
 <?php
 require "../model/DB.php";
-require "../model/Tag.php";
-require "../model/Word.php";
-require "../model/Lemma.php";
-$DB = new DB();
-
-$id = 4;
-
-$res = ["tag_id"=>1, "tag"=>"N-----------", "lemma_id"=>1, "lemma"=>"xxx", "pos"=>0, "id"=>4, "context"=>"", "date"=>"2015-06-08 00:00:00", "description"=>"",
-        "description2"=>"koho/co", "description3"=>"", "ending"=>"", "finished"=>true, "namedentity"=>0, "position1"=>"53", "position2"=>"38", "positiondetail"=>"",
-        "word"=>"abatyšeZměna2"];
 
-$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);
-
-$DB->update();
+$DB = new DB();
+$DB->insert();

application/model/DB.php

@@ -293 +293 @@
         $this->stmt->bindParam(':tag_id', $_POST['tag_id'], PDO::PARAM_INT);
     }
     $this->stmt->execute();
-}}
+}
+
+function insert(){
+    // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_wordform |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
+
+    $query = "SELECT MAX(id) FROM dd_wordform;";
+    $this->stmt = $this->pdo->prepare($query);
+    $this->stmt->execute();
+    $result = $this->stmt->fetchAll();
+    $result[0]["max"]+=1;
+
+
+    $query = "INSERT INTO dd_wordform ( id, ";
+    $values = "VALUES (" . $result[0]["max"] . ", ";
+
+     if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
+            $query .= " context, ";
+            $values .= " :context, ";
+        }
+            $query .= " date, ";
+            $values .=  " CURRENT_DATE, ";
+
+        if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
+            $query .= " description, ";
+            $values .= " :description, ";
+        }
+        if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
+            $query .= " description2, ";
+            $values .= " :description2, ";
+        }
+        if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
+            $query .= " description3, ";
+            $values .= " :description3, ";
+        }
+        if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
+            $query .= " ending, ";
+            $values .= " :ending, ";
+        }
+        if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
+            $query .= " finished, ";
+            $values .= " :finished, ";
+        }
+        if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
+            $query .= " namedentity, ";
+            $values .= " :namedentity, ";
+        }
+        if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
+            $query .= " position1, ";
+            $values .= " :position1, ";
+        }
+        if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
+            $query .= " position2, ";
+            $values .= " :position2, ";
+        }
+        if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
+            $query .= " positiondetail, ";
+            $values .= " :positiondetail, ";
+        }
+        if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
+            $query .= " prefix, ";
+            $values .= " :prefix, ";
+        }
+        if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
+            $query .= " suffix, ";
+            $values .= " :suffix, ";
+        }
+        if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
+            $query .= " word, ";
+            $values .= " :word, ";
+        }
+        if (array_key_exists("lemma_id", $_POST) && $_POST['lemma_id'] != "") {
+            $query .= " lemma_id, ";
+            $values .= " :lemma_id, ";
+        }
+        if (array_key_exists("tag_id", $_POST) && $_POST['tag_id'] != "") {
+            $query .= " tag_id ) ";
+            $values .= " :tag_id ); ";
+        }
+
+        $query .= $values;
+        $this->stmt = $this->pdo->prepare($query);
+
+            if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
+                $this->stmt->bindParam(':context', $_POST['context'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
+                $this->stmt->bindParam(':description', $_POST['description'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
+                $this->stmt->bindParam(':description2', $_POST['description2'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
+                $this->stmt->bindParam(':description3', $_POST['description3'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
+                $this->stmt->bindParam(':ending', $_POST['ending'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
+                $this->stmt->bindParam(':finished', $_POST['finished']);
+            }
+            if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
+                $this->stmt->bindParam(':namedentity', $_POST['namedentity'], PDO::PARAM_INT);
+            }
+            if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
+                $this->stmt->bindParam(':position1', $_POST['position1'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
+                $this->stmt->bindParam(':position2', $_POST['position2'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
+                $this->stmt->bindParam(':positiondetail', $_POST['positiondetail'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
+                $this->stmt->bindParam(':prefix', $_POST['prefix'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
+                $this->stmt->bindParam(':suffix', $_POST['suffix'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
+                $this->stmt->bindParam(':word', $_POST['word'], PDO::PARAM_STR);
+            }
+            if (array_key_exists("lemma_id", $_POST) && $_POST['lemma_id'] != "") {
+                $this->stmt->bindParam(':lemma_id', $_POST['lemma_id'], PDO::PARAM_INT);
+            }
+            if (array_key_exists("tag_id", $_POST) && $_POST['tag_id'] != "") {
+                $this->stmt->bindParam(':tag_id', $_POST['tag_id'], PDO::PARAM_INT);
+            }
+
+            $this->stmt->execute();
+
+    // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_lemma |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
+
+    $query = "SELECT MAX(id) FROM dd_lemma;";
+    $this->stmt = $this->pdo->prepare($query);
+    $this->stmt->execute();
+    $result = $this->stmt->fetchAll();
+    $result[0]["max"]+=1;
+
+    $query = "INSERT INTO dd_lemma ( id, ";
+    $values = "VALUES (" . $result[0]["max"] . ", ";
+        if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
+            $query .= " lemma, ";
+            $values .= " :lemma, ";
+        }
+        if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
+            $query .= " pos ) ";
+            $values .= " :pos ); ";
+        }
+
+    $query .= $values;
+    $this->stmt = $this->pdo->prepare($query);
+        if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
+            $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+        }
+        if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
+            $this->stmt->bindParam(':pos', $_POST['pos'], PDO::PARAM_INT);
+        }
+    $this->stmt->execute();
+
+// ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_manuscript |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
+
+    if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
+        $query = "SELECT * FROM dd_manuscript WHERE ";
+        $query .= " wordform_id = :wordform_id ;";
+    }
+
+    $this->stmt = $this->pdo->prepare($query);
+    if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
+        $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+    }
+    $this->stmt->execute();
+    $result = $this->stmt->fetchAll();
+
+    $to_insert = [];
+    $contained = [];
+    $found = false;
+
+    foreach ($result as $res) {
+        $integerIDs = array_map('intval', explode(',', $_POST['manuscript']));
+        foreach ($integerIDs as $new_value){
+            if($new_value == $res['manuscript']){
+                $found = true;
+                array_push($contained, $new_value);
+            }
+        }
+        if($found == false){
+            array_push($to_delete, $res);
+        }
+        $found = false;
+    }
+    $to_insert = array_diff($integerIDs, $contained);
+    foreach ($to_insert as $id_to_insert){
+        $query = "INSERT INTO dd_manuscript VALUES ( ";
+        $query .= " :wordform_id , ";
+        $query .= " " . $id_to_insert . " ); ";
+
+        $this->stmt = $this->pdo->prepare($query);
+        if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
+            $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+        }
+        $this->stmt->execute();
+    }
+
+    // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_tag |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
+    $query = "SELECT MAX(id) FROM dd_tag;";
+    $this->stmt = $this->pdo->prepare($query);
+    $this->stmt->execute();
+    $result = $this->stmt->fetchAll();
+    $result[0]["max"]+=1;
+
+
+    $query = "INSERT INTO dd_tag (id, ";
+    $values = "VALUES (" . $result[0]["max"] . ", ";
+
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
+            $query .= " tag ) ";
+            $values .= " :tag ); ";
+        }
+
+    $query .= $values;
+    $this->stmt = $this->pdo->prepare($query);
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
+            $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+        }
+    $this->stmt->execute();
+
+
+}
+
+}
 
 // (D) DATABASE SETTINGS - CHANGE TO YOUR OWN!
 define('DB_HOST', 'localhost');
 define('DB_NAME', 'dalim2');
 define('DB_CHARSET', 'utf8');
 define('DB_USER', 'postgres');
-define('DB_PASSWORD', 'a');
+define('DB_PASSWORD', 'MVcesko98');

application/view/Index.php

@@ -28 +28 @@
         data.append("lemma_id", 1);
         data.append("tag_id", 1);
         data.append("pos", 1);
-        data.append("manuscript", [1,2,3,4]);
+        data.append("manuscript", [1,2,3,4,5]);
         data.append("wordform_id", 4);
         data.append("tag", "A---------")
         //data.append("finished", "false");