From 7a163c226c99eb97fb9ce59ce5774da513bcdfd1 Mon Sep 17 00:00:00 2001
From: MaZderMind
Date: Tue, 31 Mar 2015 21:38:03 +0200
Subject: Feedback Read-View

---
 model/Feedback.php | 36 ++++++++++++++++++++++++++++++++++++
 1 file changed, 36 insertions(+)

(limited to 'model/Feedback.php')

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;
+	}
 }
-- 
cgit v1.2.3