Feedback Read-View

1 files changed, 36 insertions, 0 deletions

diff --git a/model/Feedback.php b/model/Feedback.php
index 7ba697d..578650a 100644
--- a/model/Feedback.php
+++ b/model/Feedback.php
@@ -45,4 +45,40 @@ class Feedback extends ModelBase
 			'issuetext' => $info['issuetext'],
 		));
 	}
+
+	public function isLoggedIn()
+	{
+		return
+			isset($_SERVER['PHP_AUTH_USER']) &&
+			$_SERVER['PHP_AUTH_USER'] == $this->get('FEEDBACK.USERNAME') &&
+			$_SERVER['PHP_AUTH_PW'] == $this->get('FEEDBACK.PASSWORD');
+	}
+
+	public function requestLogin()
+	{
+		header('WWW-Authenticate: Basic realm="Kadse?"');
+		header('HTTP/1.0 401 Unauthorized');
+		echo 'You are no real Winkekatzenoperator!!!1!';
+		exit;
+	}
+
+	public function read($from, $to)
+	{
+		$db = new PDO($this->get('FEEDBACK.DSN'));
+		$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+		$stm = $db->prepare('
+			SELECT *
+			  FROM feedback
+			 WHERE reported BETWEEN :from AND :to
+		');
+		$stm->setFetchMode(PDO::FETCH_ASSOC);
+
+		$stm->execute(array(
+			'from' => $from,
+			'to' => $to,
+		));
+
+		return $stm;
+	}
 }