Revize 5aceeb68

Feature #8637 Návrh změn záznamů

application/model/DB.php

@@ -48 +48 @@
             if (array_key_exists("tag", $params)) {
                 $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
             }
-            if (array_key_exists("finished", $params)) {
-                $this->stmt->bindParam(':finished',$params['finished']);
-            }
             if (array_key_exists("description2", $params)) {
                 $this->stmt->bindParam(':description2',$params['description2']);
             }
@@ -85 +82 @@
         return $this->stmt->fetchAll();
     }
 
+    function createChangeRequest($request) {
+        $this->stmt = $this->pdo->prepare('INSERT INTO changes (wordform_id, message) VALUES (:wordform_id, :message)');
+        $this->stmt->bindParam(':wordform_id', $request['wordform_id']);
+        $this->stmt->bindParam(':message',$request['message']);
+        $this->stmt->execute();
+        return $this->stmt->fetchAll();
+    }
+
+    function removeChangeRequest($requestId) {
+        $this->stmt = $this->pdo->prepare('DELETE FROM changes WHERE id = :requestId');
+        $this->stmt->bindParam(':requestId', $requestId);
+        $this->stmt->execute();
+        return $this->stmt->fetchAll();
+    }
+
+    function getChangeRequests() {
+        $this->stmt = $this->pdo->prepare('SELECT c.id as changeId, c.message, w.id as wordformId, w.word, l.lemma FROM changes as c left join dd_wordform as w on c.wordform_id = w.id left join dd_lemma as l on w.lemma_id = l.id');
+        $this->stmt->execute();
+        return $this->stmt->fetchAll();
+    }
+
     function updateUserRole($userId, $role) {
         $this->stmt = $this->pdo->prepare("UPDATE users SET role = :role WHERE id = :userId");
         $this->stmt->bindParam(':role', $role);
@@ -730 +748 @@
 
 // (D) DATABASE SETTINGS - CHANGE TO YOUR OWN!
 define('DB_HOST', 'localhost');
-define('DB_NAME', 'dalim2');
+define('DB_NAME', 'dalimil2');
 define('DB_CHARSET', 'utf8');
 define('DB_USER', 'postgres');
 define('DB_PASSWORD', 'a');