Subversion-Projekte lars-tiefland.prado

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
/**
3 
 * ListPost class file
4 
 *
5 
 * @author Qiang Xue <qiang.xue@gmail.com>
6 
 * @link http://www.pradosoft.com/
7 
 * @copyright Copyright &copy; 2006 PradoSoft
8 
 * @license http://www.pradosoft.com/license/
9 
 * @version $Id: ListPost.php 1398 2006-09-08 19:31:03Z xue $
10 
 */
11 
 
12 
/**
13 
 * ListPost class
14 
 *
15 
 * @author Qiang Xue <qiang.xue@gmail.com>
16 
 * @link http://www.pradosoft.com/
17 
 * @copyright Copyright &copy; 2006 PradoSoft
18 
 * @license http://www.pradosoft.com/license/
19 
 */
20 
class ListPost extends BlogPage
21 
{
22 
	private $_posts;
23 
	private $_category;
24 
 
25 
	public function onInit($param)
26 
	{
27 
		parent::onInit($param);
28 
		$this->_posts=$this->DataAccess->queryPosts(
29 
				$this->getPostFilter(),
30 
				$this->getCategoryFilter(),
31 
				'ORDER BY a.status DESC, create_time DESC',
32 
				'LIMIT '.$this->getPageOffset().','.$this->getPageSize());
33 
		if($this->Request['cat']!==null)
34 
		{
35 
			$catID=TPropertyValue::ensureInteger($this->Request['cat']);
36 
			$this->_category=$this->DataAccess->queryCategoryByID($catID);
37 
			$this->CategoryPanel->Visible=true;
38 
		}
39 
		$this->Title=$this->Application->Parameters['SiteTitle'];
40 
	}
41 
 
42 
	private function getPageOffset()
43 
	{
44 
		if(($offset=TPropertyValue::ensureInteger($this->Request['offset']))<=0)
45 
			$offset=0;
46 
		return $offset;
47 
	}
48 
 
49 
	private function getPageSize()
50 
	{
51 
		if(($limit=TPropertyValue::ensureInteger($this->Request['limit']))<=0)
52 
			$limit=TPropertyValue::ensureInteger($this->Application->Parameters['PostPerPage']);
53 
		return $limit;
54 
	}
55 
 
56 
	private function getTimeFilter()
57 
	{
58 
		if(($time=TPropertyValue::ensureInteger($this->Request['time']))>0)
59 
		{
60 
			$year=(integer)($time/100);
61 
			$month=$time%100;
62 
			$startTime=mktime(0,0,0,$month,1,$year);
63 
			if(++$month>12)
64 
			{
65 
				$month=1;
66 
				$year++;
67 
			}
68 
			$endTime=mktime(0,0,0,$month,1,$year);
69 
			return "create_time>=$startTime AND create_time<$endTime";
70 
		}
71 
		else
72 
			return '';
73 
	}
74 
 
75 
	private function getPostFilter()
76 
	{
77 
		$filter='(a.status=0 OR a.status=3)';
78 
		if(($timeFilter=$this->getTimeFilter())!=='')
79 
			return "$filter AND $timeFilter";
80 
		else
81 
			return $filter;
82 
	}
83 
 
84 
	private function getCategoryFilter()
85 
	{
86 
		if(($catID=$this->Request['cat'])!==null)
87 
		{
88 
			$catID=TPropertyValue::ensureInteger($catID);
89 
			return "category_id=$catID";
90 
		}
91 
		else
92 
			return '';
93 
	}
94 
 
95 
	private function formUrl($newOffset)
96 
	{
97 
		$gets=array();
98 
		$gets['offset']=$newOffset;
99 
		if($this->Request['limit']!==null)
100 
			$gets['limit']=$this->Request['limit'];
101 
		if($this->Request['time']!==null)
102 
			$gets['time']=$this->Request['time'];
103 
		if($this->Request['cat']!==null)
104 
			$gets['cat']=$this->Request['cat'];
105 
		return $this->Service->constructUrl('Posts.ListPost',$gets);
106 
	}
107 
 
108 
	public function getCategory()
109 
	{
110 
		return $this->_category;
111 
	}
112 
 
113 
	public function onLoad($param)
114 
	{
115 
		parent::onLoad($param);
116 
		$this->PostList->DataSource=$this->_posts;
117 
		$this->PostList->dataBind();
118 
		if($this->getPageOffset()>0)
119 
		{
120 
			if(($offset=$this->getPageOffset()-$this->getPageSize())<0)
121 
				$offset=0;
122 
			$this->PrevPage->NavigateUrl=$this->formUrl($offset);
123 
			$this->PrevPage->Visible=true;
124 
		}
125 
		if(count($this->_posts)===$this->getPageSize())
126 
		{
127 
			$this->NextPage->NavigateUrl=$this->formUrl($this->getPageOffset()+$this->getPageSize());
128 
			$this->NextPage->Visible=true;
129 
		}
130 
	}
131 
 
132 
	public function deleteButtonClicked($sender,$param)
133 
	{
134 
		if($this->User->IsAdmin)
135 
		{
136 
			$this->DataAccess->deleteCategory($this->Category->ID);
137 
			$this->gotoDefaultPage();
138 
		}
139 
	}
140 
}
141 
 
142 
?>