Working on the moderation schedule iterator

5 files changed, 366 insertions, 0 deletions

diff --git a/design/database.sql b/design/database.sql
index 2dbd90c..b908bc0 100644
--- a/design/database.sql
+++ b/design/database.sql
@@ -94,6 +94,22 @@ CREATE TABLE page (
     UNIQUE  KEY(url)
 );
 
+CREATE TABLE moderator_schedule (
+    position    TINYINT UNSIGNED NOT NULL,
+    user_id     INTEGER UNSIGNED NOT NULL,
+
+    PRIMARY KEY(position, user_id)
+);
+
+CREATE TABLE moderator_exceptions ( 
+    year        INTEGER UNSIGNED NOT NULL,
+    week        TINYINT UNSIGNED NOT NULL,
+    user_id     INTEGER UNSIGNED NOT NULL,
+
+    PRIMARY KEY(year, week)
+);
+
+
 -- The following creates some sample data
 INSERT INTO `category` (`shortname`, `name`, `description`, `options`)
 VALUES
diff --git a/htdocs/moderate/schedule/delete.php b/htdocs/moderate/schedule/delete.php
new file mode 100644
index 0000000..76b8866
--- /dev/null
+++ b/htdocs/moderate/schedule/delete.php
@@ -0,0 +1,49 @@
+<?php
+
+/* Foursquare Community Site
+ * 
+ * Copyright (C) 2011 Foursquare Church.
+ * 
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once('../../src/base.inc.php');
+
+// Verify User is admin
+if (!isset($_SESSION['currentUser']) or !$_SESSION['currentUser']->isAdmin()) {
+    header('Location: ' . buildUrl('moderate/'));
+    exit;
+}
+
+$error = '';
+
+$user = false;
+if (isset($_GET['id']) and is_numeric($_GET['id'])) {
+    $user = User::getById($_GET['id']);
+    
+    if ($user !== false and isset($_GET['confirmed'])) {
+        $user->delete();
+        
+        header('Location: index.php');
+    }
+
+}
+
+require_once('../src/header.inc.php');
+
+echo "<h3>Delete Users</h3>";
+
+if ($user !== false) {
+    echo "<p>Are you sure you want to delete " . $user->getName() ."?</p>"
+        . "<p><a href=\"delete.php?id=". $user->getId() ."&confirmed\">Yes</a>"
+        . " <a href=\"index.php\">No</a></p>";
+
+} else {
+    echo "<p>No user to delete.</p>";
+}
+
+require_once('../src/footer.inc.php');
+
+?>
+
diff --git a/htdocs/moderate/schedule/editor.php b/htdocs/moderate/schedule/editor.php
new file mode 100644
index 0000000..fe715f7
--- /dev/null
+++ b/htdocs/moderate/schedule/editor.php
@@ -0,0 +1,144 @@
+<?php
+
+/* Foursquare Community Site
+ * 
+ * Copyright (C) 2011 Foursquare Church.
+ * 
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once('../../src/base.inc.php');
+
+// Verify User is admin
+if (!isset($_SESSION['currentUser']) or !$_SESSION['currentUser']->isAdmin()) {
+    header('Location: ' . buildUrl('moderate/'));
+    exit;
+}
+
+$error = '';
+
+// Get the current user object.
+$user = new User();
+if (isset($_GET['id']) and is_numeric($_GET['id'])) {
+    $user = User::getById($_GET['id']);
+}
+
+// Save changes?
+if ($_SERVER['REQUEST_METHOD'] == 'POST') {
+    // Name
+    if (isset($_POST['name']) and trim($_POST['name']) != '') {
+        $user->setName($_POST['name']);
+
+    } else {
+        $error .= '<p>Name is a required field.</p>';
+    }
+
+    // Email
+    if (isset($_POST['email']) and trim($_POST['email']) != '') {
+        $user->setEmail($_POST['email']);
+
+    } else {
+        $error .= '<p>Email is a required field.</p>';
+    }
+
+    // Source
+    if (isset($_POST['source']) and trim($_POST['source']) != '') {
+        $user->setSource($_POST['source']);
+
+    } else {
+        $error .= '<p>Source is a required field.</p>';
+    }
+
+    // Set Admin
+    $admin = isset($_POST['admin']) and $_POST['admin'] == '1';
+    $user->setAdmin($admin);
+
+    // Set Notify
+    $notify = isset($_POST['notify']) and $_POST['notify'] == '1';
+    $user->setNotify($notify);
+
+    // Send new password
+    if (isset($_POST['newpass']) and $_POST['newpass'] == '1') {
+        $user->sendNewPassword();
+    }
+
+    // Save the user
+    if ($error == '') {
+        if ($user->save()) {
+            // Return to users list
+            header("Location: index.php");
+
+        } else {
+            $error .= '<p>An error has occured.</p>';
+        }
+    }
+}
+
+require_once('../src/header.inc.php');
+
+echo "<h3>Edit User</h3>";
+
+if ($error != '') {
+    echo "<div class=\"errorbox\">$error</div>";
+}
+
+$url = "editor.php";
+
+if (isset($_GET['id'])) {
+    $url .= '?id=' . $_GET['id'];
+}
+
+echo "<form action=\"$url\" method=\"post\">";
+
+?>
+
+<p><label>Name: <input type="text" name="name" value="<?= $user->getName() ?>" /></label></p>
+<p><label>Email: <input type="text" name="email" value="<?= $user->getEmail() ?>" /></label></p>
+<p><label>Source: <?php sourceDropdown('source', $user->getSource()) ?></label></p>
+<p><label>
+<input type="checkbox" name="admin" value="1"  <?= $user->isAdmin() ? 'checked="checked"' : '' ?> />
+Administrator</label></p>
+<p><label>
+<input type="checkbox" name="notify" value="1" <?= $user->getNotify() ? 'checked="checked"' : '' ?> />
+Notify of posts</label></p>
+
+<?php
+    if (isset($_GET['id'])) {
+        echo "<p><label><input type=\"checkbox\" name=\"newpass\" value=\"1\" />"
+            . "Send new password</label></p>";
+    }
+?>
+
+<p>
+<input type="submit" class="bigbutton" value="Save" />
+<a href="index.php" class="bigbutton">Cancel</a>
+</p>
+
+
+</form>
+
+<?php
+
+function sourceDropdown($name, $select) {
+    echo "<select name=\"$name\">";
+    
+    foreach(Source::getSources() as $source) {
+        if ($source->getId() == $select) {
+            echo "<option value=\"". $source->getId()
+                ."\" selected=\"selected\">"
+                . $source->getName() ."</option>";
+
+        } else {
+            echo "<option value=\"". $source->getId() ."\">"
+                . $source->getName() ."</option>";
+        }
+    }
+
+    echo "</select>";
+}
+
+require_once('../src/footer.inc.php');
+
+?>
+
diff --git a/htdocs/moderate/schedule/index.php b/htdocs/moderate/schedule/index.php
new file mode 100644
index 0000000..93dfc3a
--- /dev/null
+++ b/htdocs/moderate/schedule/index.php
@@ -0,0 +1,52 @@
+<?php
+
+/* Foursquare Community Site
+ * 
+ * Copyright (C) 2011 Foursquare Church.
+ * 
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once('../../src/base.inc.php');
+
+
+require_once('../src/header.inc.php');
+
+echo "<h3>Moderation Schedule</h3>";
+
+// List out moderators in order with next moderation week
+
+
+echo "<h3>Exceptions</h3>";
+echo "<p><a href=\"exception.php\">New Exception</a></p>";
+
+// List out exceptions in order.
+
+$ui = new UserIterator();
+$ui->query();
+
+echo "<div class=\"userrow header\">"
+    . "<span class=\"name\">Name</span>"
+    . " <span class=\"email\">Email</span>"
+    . " <span class=\"admin\">Admin</span>"
+    . " <span class=\"actions\">Actions</span></div>";
+
+foreach ($ui as $user) {
+    printf("<div class=\"userrow\">"
+        . "<span class=\"name\">%s</span>"
+        . " <span class=\"email\"><a href=\"mailto:%s\">%s</a></span>"
+        . " <span class=\"admin\">%s</span>"
+        . " <span class=\"actions\">"
+        . " <a class=\"smallbutton\" href=\"editor.php?id=%s\">edit</a>"
+        . " <a class=\"smallbutton\" href=\"delete.php?id=%s\">delete</a></span></div>",
+        $user->getName(),
+        $user->getEmail(), $user->getEmail(),
+        $user->isAdmin() ? 'Yes' : 'No',
+        $user->getId(), $user->getId()
+        );
+}
+
+require_once('../src/footer.inc.php');
+
+?>
diff --git a/htdocs/src/ModerationSchedule.inc.php b/htdocs/src/ModerationSchedule.inc.php
new file mode 100644
index 0000000..cca6697
--- /dev/null
+++ b/htdocs/src/ModerationSchedule.inc.php
@@ -0,0 +1,105 @@
+<?php
+
+/* Foursquare Community Site
+ * 
+ * Copyright (C) 2011 Foursquare Church.
+ * 
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once "base.inc.php";
+
+class ModerationSchedule implements Iterator {
+    private $moderators;
+    private $exceptions;
+
+    private $year;
+    private $week;
+    private $expos;
+
+    public function __construct() {
+        $this->moderators = array();
+        $this->exceptions = array();
+    }
+
+    public function getNumberOfModerators() {
+        return count($this->moderators);
+    }
+
+
+    // Iterator methods
+
+    public function rewind() {
+        $this->year = date('o');
+        $this->week = date('W') + 0;
+        $this->expos = 0;
+    }
+
+    public function current() {
+        // Get the scheduled mod.
+        $modpos = $this->week % $this->getNumberOfModerators();
+        $moderator = $this->moderators[$modpos]['user_id'];
+
+        // Check for exceptions
+        if (count($this->exceptions) > 0) {
+            // Skip exceptions prior to the current() date.
+            while (
+                // We have exceptions to search
+                $this->expos < count($this->exceptions) and
+                // and the year is less than the current() year
+                ($this->exceptions[$this->expos]['year'] < $this->year or
+                // or if it is the current() year, but less than the week.
+                ($this->exceptions[$this->expos]['year'] == $this->year
+                and $this->exceptions[$this->expos]['week'] < $this->week))
+                ) {
+
+                $this->expos++;
+            }
+
+            // Check if the top exception is for today.
+            if ($this->exceptions[$this->expos]['year'] == $this->year
+                and $this->exceptions[$this->expos]['week'] == $this->week
+            ) {
+                // Yes, return the replacement
+                $moderator = $this->exceptions[$this->expos]['user_id'];
+            }
+        }
+        
+        return User::getById($moderator);
+    }
+
+    public function key() {
+        // TODO: Return "key" for "current" moderator (date)
+    }
+
+    public function next() {
+        // TODO: Impl. next
+    }
+
+    public function valid() {
+        // The schedule continues forever.
+        return true;
+    }
+
+    private function query() {
+        $db = getDatabase();
+        $this->rewind();
+
+        // Get the moderators
+        $query = "SELECT * FROM moderation_schedule ORDER BY position"; 
+        $this->moderators = $db->fetchAssocRows($query);
+
+        // Get the exceptions
+        $year = date('o');
+        $week = date('W');
+
+        $query = "SELECT * FROM moderator_exceptions"
+            . " WHERE year >= $year AND week >= $week"
+            . " ORDER BY year, week";
+        $this->exceptions = $db->fetchAssocRows($query);
+    }
+}
+
+?>
+