Add comments option to quickstart.

4 files changed, 314 insertions, 0 deletions

diff --git a/demos/quickstart/protected/comments/CommentList.php b/demos/quickstart/protected/comments/CommentList.php
new file mode 100644
index 00000000..7ea5be6b
--- /dev/null
+++ b/demos/quickstart/protected/comments/CommentList.php
@@ -0,0 +1,55 @@
+<?php
+
+Prado::using('System.I18N.*');
+
+/**
+ * CommentList class.
+ *
+ * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
+ * @version : $  Sat May 27 17:53:15 AZOST 2006 $
+ * @package Demo.Quickstart.comments
+ * @since 3.0
+ */
+class CommentList extends TTemplateControl
+{
+	private $_exclude = array('Comments', 'GettingStarted.Introduction');
+
+	private $_quickstart;
+	
+	public function onLoad($param)
+	{
+		parent::onLoad($param);
+		
+		$this->_quickstart = new QuickStartComments();
+	
+		$page = $this->getService()->getRequestedPagePath();
+
+		$this->listComments($page);
+	}
+	
+	protected function listComments($page)
+	{
+		$this->comments->setDataSource($this->_quickstart->getComments($page));
+		$this->comments->dataBind();		
+	}
+
+	public function addComment_Clicked($sender, $param)
+	{
+		$page = $this->getService()->getRequestedPagePath();
+		$this->_quickstart->addNewComment($page, 
+			$this->email->getText(), $this->content->getText());
+		$this->multiView1->setActiveViewIndex(1);
+		$this->listComments($page);
+	}
+	
+	public function setVisible($value)
+	{
+		$page = $this->getService()->getRequestedPagePath();
+		if(in_array($page, $this->_exclude))
+			parent::setVisible(false);
+		else
+			parent::setVisible($value);
+	}
+}
+
+?>
\ No newline at end of file
diff --git a/demos/quickstart/protected/comments/CommentList.tpl b/demos/quickstart/protected/comments/CommentList.tpl
new file mode 100644
index 00000000..7ea7b870
--- /dev/null
+++ b/demos/quickstart/protected/comments/CommentList.tpl
@@ -0,0 +1,84 @@
+<div id="comments">
+
+<com:TRepeater ID="comments">
+	<prop:HeaderTemplate>
+		<h2 class="comment_header">Comments</h2>
+	</prop:HeaderTemplate>
+	<prop:ItemTemplate>
+		<div class="comment_item comment_item<%# $this->ItemIndex%2 %>">
+			<span class="number" id="comment_<%# $this->ItemIndex+1 %>"><%# $this->ItemIndex+1 %></span>
+			<span class="email">
+				<%# str_replace(array('@','.'),array(' at ',' dot '), strtoupper($this->DataItem['email'])) %>
+			</span>
+			<span class="date">
+				<com:TDateFormat Value=<%# intval($this->DataItem['date_added']) %> />
+			</span>
+			<div class="comment">
+				<com:TSafeHtml>
+					<%# $this->DataItem['comment'] %>
+				</com:TSafeHtml>
+			</div>
+		</div>
+	</prop:ItemTemplate>
+</com:TRepeater>
+
+<com:TMultiView ID="multiView1" ActiveViewIndex="0">
+	<com:TView ID="view1">
+		<div class="add_comments">
+			<h3>Add your comment</h3>
+			<p>Add comments and notes that can solve or clarify a particular problem or task.
+				Please use the forum to ask questions. You may be HTML in your comment.</p>
+			<div class="comment_email">
+			<com:TLabel ID="email_label" Text="Email:" ForControl="email"/>
+			<com:TTextBox ID="email" />
+			<com:TRequiredFieldValidator
+				ControlToValidate="email"
+				Display="Dynamic"
+				ErrorMessage="An email address is required." />
+			<com:TEmailAddressValidator	
+				ControlToValidate="email" 
+				CheckMXRecord="false"
+				Display="Dynamic"
+				ErrorMessage="Please provide your email address."/>
+			</div>
+			<div class="comment_content">
+				<com:TLabel ID="content_label" Text="Comment:" ForControl="content"/>
+				<com:TTextBox ID="content" TextMode="MultiLine"/>
+				<div class="please_add">
+				<com:TRequiredFieldValidator
+					ControlToValidate="content"
+					Display="Dynamic"
+					ErrorMessage="Please add your comment." />
+				</div>
+			</div>
+			<com:TPlaceHolder Visible=<%= strlen($this->content->Text) %> >
+			<div class="comment_preview">
+				<h3 style="margin:0">Preview comment</h3>
+					<div class="comment">
+						<com:TSafeHtml>
+							<%= $this->content->Text %>
+						</com:TSafeHtml>
+					</div>
+				</div>
+			</com:TPlaceHolder>			
+			<div class="add_comment">
+				<com:TButton ID="previewComment" Text="Preview Comment" />
+				<com:TButton ID="addComment" Text="Add Comment" OnClick="addComment_Clicked"/>
+			</div>
+		</div>
+	</com:TView>
+	<com:TView ID="view2">
+		<div class="comment_added">
+		<div class="thank">Thank you, your comment is quequed for moderation.</div>
+		<div class="comment_preview">
+			<h3 style="margin:0">Preview comment</h3>
+			<div class="comment">
+			<com:TSafeHtml>
+				<%= $this->content->Text %>
+			</com:TSafeHtml>
+			</div>
+		</div>
+		</div>
+	</com:TView>
+</com:TMultiView>
+</div>
\ No newline at end of file
diff --git a/demos/quickstart/protected/comments/QuickStartComments.php b/demos/quickstart/protected/comments/QuickStartComments.php
new file mode 100644
index 00000000..c138bd94
--- /dev/null
+++ b/demos/quickstart/protected/comments/QuickStartComments.php
@@ -0,0 +1,175 @@
+<?php
+
+/**
+ * QuickStartComments class.
+ *
+ * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
+ * @version : $  Sat May 27 16:49:19 AZOST 2006 $
+ * @package Demos.QuickStart.comments
+ * @since 3.0
+ */
+class QuickStartComments
+{
+	/**
+	 * @var string sqlite database source.
+	 */
+	private $_database;
+	/**
+	 * @var sqlite connection.
+	 */
+	private $_connection;
+	
+	/**
+	 * Sets the sqlite comment database file.
+	 */
+	public function __construct()
+	{
+		$this->_database = realpath(dirname(__FILE__).'/comments.db');
+	}
+	
+	/**
+	 * Closed the database connection.
+	 */
+	public function __destruct()
+	{
+		if(!is_null($this->_connection))
+			sqlite_close($this->_connection);
+	}
+	
+	/**
+	 * @return resource sqlite database connection.
+	 */
+	protected function getConnection()
+	{
+		if(is_null($this->_connection))
+			$this->_connection = sqlite_open($this->_database);
+		return $this->_connection;
+	}
+	
+	/**
+	 * Quote database input data.
+	 */
+	protected function quote($value)
+	{
+		return sqlite_escape_string($value);
+	}
+	
+	/**
+	 * Executes an sqlite query.
+	 * @param string SQL
+	 * @return mixed query results.
+	 */
+	protected function query($sql)
+	{
+		return sqlite_query($this->getConnection(), $sql);
+	}
+	
+	/**
+	 * Returns a row from the sqlite result.
+	 * @param resource sqlite result
+	 * @return array database record.
+	 */
+	protected function fetch($resource)
+	{
+		if($resource !== false)
+			return sqlite_fetch_array($resource);
+		else
+			return false;
+	}
+	
+	/**
+	 * Fetch all the records for given SQL query.
+	 * @param string SQL query.
+	 * @return array result set.
+	 */
+	protected function fetchAll($sql)
+	{
+		$rs = $this->query($sql);
+		$rows = array();
+		while($row = $this->fetch($rs))
+			$rows[] = $row;
+		return $rows;
+	}
+	
+	/**
+	 * Returns all the comments for a given page.
+	 * @param string specific page comments
+	 * @return array list of comments
+	 */
+	public function getComments($pageID)
+	{
+		$page = $this->quote($pageID);
+		$sql = "SELECT * FROM comments WHERE page=\"$page\" AND approved = 1 ORDER BY date_added ASC";
+		return $this->fetchAll($sql);
+	}
+	
+	/**
+	 * Adds a new comment for moderation.
+	 * @param string ID of the page to comment belongs
+	 * @param string email address of the commenter
+	 * @param string comment contents
+	 */
+	public function addNewComment($pageID, $email, $comment)
+	{
+		$page = $this->quote($pageID);
+		$email = $this->quote($email);
+		$comment = $this->quote($comment);
+		$date_added = time();
+		$sql = <<<EOD
+		INSERT INTO comments(page, email, comment, date_added)
+				VALUES ("$page", "$email", "$comment", "$date_added")
+EOD;
+		return $this->query($sql);
+	}
+	
+	/**
+	 * Update an existing comment.
+	 * @param string comment ID
+	 * @param string page ID
+	 * @param string email address
+	 * @param string updated comment.
+	 */
+	public function updateComment($commentID, $page, $email, $content)
+	{
+		$ID = intval($commentID);
+		$email = $this->quote($email);
+		$comment = $this->quote($content);
+		$page = $this->quote($page);
+		$sql = <<<EOD
+		UPDATE comments SET 
+			email = "$email", comment = "$comment", page = "$page"
+			WHERE id = $ID;
+EOD;
+		$this->query($sql);
+	}
+	
+	/**
+	 * Delete a comment.
+	 * @param string comment ID
+	 */
+	public function deleteComment($commentID)
+	{
+		$ID = intval($commentID);
+		$this->query("DELETE FROM comments WHERE id=$ID");
+	}
+		
+	/**
+	 * @return array all the quequed comments.
+	 */
+	public function getQuequedComments()
+	{
+		return $this->fetchAll("SELECT * FROM comments WHERE approved != 1");
+	}
+	
+	/**
+	 * Approve a quequed comment.
+	 * @param string comment ID.
+	 */
+	public function approveComment($commentID)
+	{
+		$ID = intval($commentID);
+		$this->query("UPDATE comments SET approved = 1 WHERE id=$ID");
+	}
+}
+
+?>
\ No newline at end of file
diff --git a/demos/quickstart/protected/comments/comments.db b/demos/quickstart/protected/comments/comments.db
new file mode 100644
index 00000000..b81d7123
--- /dev/null
+++ b/demos/quickstart/protected/comments/comments.db