From 6e0338629774fffe5fbe7136dfce34ce83844a5c Mon Sep 17 00:00:00 2001
From: xue <>
Date: Tue, 30 May 2006 03:26:33 +0000
Subject: Blog demo is completed.

---
 demos/blog/protected/Pages/Posts/ListPost.php | 121 +++++++++++++++++++++++---
 1 file changed, 109 insertions(+), 12 deletions(-)

(limited to 'demos/blog/protected/Pages/Posts/ListPost.php')

diff --git a/demos/blog/protected/Pages/Posts/ListPost.php b/demos/blog/protected/Pages/Posts/ListPost.php
index 6d56b543..bed18222 100644
--- a/demos/blog/protected/Pages/Posts/ListPost.php
+++ b/demos/blog/protected/Pages/Posts/ListPost.php
@@ -1,13 +1,59 @@
 <?php
+/**
+ * ListPost class file
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.pradosoft.com/
+ * @copyright Copyright &copy; 2006 PradoSoft
+ * @license http://www.pradosoft.com/license/
+ * @version $Revision: $  $Date: $
+ */
 
+/**
+ * ListPost class
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.pradosoft.com/
+ * @copyright Copyright &copy; 2006 PradoSoft
+ * @license http://www.pradosoft.com/license/
+ */
 class ListPost extends BlogPage
 {
-	const DEFAULT_LIMIT=10;
+	private $_posts;
+	private $_category;
 
-	public function getPosts()
+	public function onInit($param)
+	{
+		parent::onInit($param);
+		$this->_posts=$this->DataAccess->queryPosts(
+				$this->getPostFilter(),
+				$this->getCategoryFilter(),
+				'ORDER BY create_time DESC',
+				'LIMIT '.$this->getPageOffset().','.$this->getPageSize());
+		if($this->Request['cat']!==null)
+		{
+			$catID=TPropertyValue::ensureInteger($this->Request['cat']);
+			$this->_category=$this->DataAccess->queryCategoryByID($catID);
+			$this->CategoryPanel->Visible=true;
+		}
+	}
+
+	private function getPageOffset()
+	{
+		if(($offset=TPropertyValue::ensureInteger($this->Request['offset']))<=0)
+			$offset=0;
+		return $offset;
+	}
+
+	private function getPageSize()
+	{
+		if(($limit=TPropertyValue::ensureInteger($this->Request['limit']))<=0)
+			$limit=TPropertyValue::ensureInteger($this->Application->Parameters['PostPerPage']);
+		return $limit;
+	}
+
+	private function getTimeFilter()
 	{
-		$timeFilter='';
-		$catFilter='';
 		if(($time=TPropertyValue::ensureInteger($this->Request['time']))>0)
 		{
 			$year=(integer)($time/100);
@@ -19,25 +65,76 @@ class ListPost extends BlogPage
 				$year++;
 			}
 			$endTime=mktime(0,0,0,$month,1,$year);
-			$timeFilter="create_time>=$startTime AND create_time<$endTime";
+			return "create_time>=$startTime AND create_time<$endTime";
 		}
+		else
+			return '';
+	}
+
+	private function getPostFilter()
+	{
+		$filter='a.status=0';
+		if(($timeFilter=$this->getTimeFilter())!=='')
+			return "$filter AND $timeFilter";
+		else
+			return $filter;
+	}
+
+	private function getCategoryFilter()
+	{
 		if(($catID=$this->Request['cat'])!==null)
 		{
 			$catID=TPropertyValue::ensureInteger($catID);
-			$catFilter="category_id=$catID";
+			return "category_id=$catID";
 		}
-		if(($offset=TPropertyValue::ensureInteger($this->Request['offset']))<=0)
-			$offset=0;
-		if(($limit=TPropertyValue::ensureInteger($this->Request['limit']))<=0)
-			$limit=self::DEFAULT_LIMIT;
-		return $this->DataAccess->queryPosts('',$timeFilter,$catFilter,'ORDER BY create_time DESC',"LIMIT $offset,$limit");
+		else
+			return '';
+	}
+
+	private function formUrl($newOffset)
+	{
+		$gets=array();
+		$gets['offset']=$newOffset;
+		if($this->Request['limit']!==null)
+			$gets['limit']=$this->Request['limit'];
+		if($this->Request['time']!==null)
+			$gets['time']=$this->Request['time'];
+		if($this->Request['cat']!==null)
+			$gets['cat']=$this->Request['cat'];
+		return $this->Service->constructUrl('Posts.ListPost',$gets);
+	}
+
+	public function getCategory()
+	{
+		return $this->_category;
 	}
 
 	public function onLoad($param)
 	{
 		parent::onLoad($param);
-		$this->PostList->DataSource=$this->getPosts();
+		$this->PostList->DataSource=$this->_posts;
 		$this->PostList->dataBind();
+		if($this->getPageOffset()>0)
+		{
+			if(($offset=$this->getPageOffset()-$this->getPageSize())<0)
+				$offset=0;
+			$this->PrevPage->NavigateUrl=$this->formUrl($offset);
+			$this->PrevPage->Visible=true;
+		}
+		if(count($this->_posts)===$this->getPageSize())
+		{
+			$this->NextPage->NavigateUrl=$this->formUrl($this->getPageOffset()+$this->getPageSize());
+			$this->NextPage->Visible=true;
+		}
+	}
+
+	public function deleteButtonClicked($sender,$param)
+	{
+		if($this->User->IsAdmin)
+		{
+			$this->DataAccess->deleteCategory($this->Category->ID);
+			$this->gotoDefaultPage();
+		}
 	}
 }
 
-- 
cgit v1.2.3