public function listAction()
{
$this->view->PageType = "list";
$DeptCode = $this->_request->getParam("dept");
$ColumnCode = $this->_request->getParam("column");
if (!empty($ColumnCode)) {
$ColumnMapper = new Application_Model_ColumnMapper();
$arr = $ColumnMapper->findColumnByCode($ColumnCode);
$this->view->arrPageColumn = $arr;
$arr = $ColumnMapper->findallColumn();
$this->view->arrColumn = $arr;
$DeptID = -1;
if (!empty($DeptCode)) {
$DeptMapper = new Application_Model_DepartmentMapper();
$arr = $DeptMapper->findDeptByCode($DeptCode);
$this->view->arrDept = $arr;
$DeptID = $arr[0]['DeptID'] ? $arr[0]['DeptID'] : -1;
}
$ArticleMapper = new Application_Model_ArticleMapper();
$arrListxw = $ArticleMapper->findArticleForListAll('publish', $DeptID, 'xw', -1);
$arrListzx = $ArticleMapper->findArticleForListAll('publish', $DeptID, 'zx', -1);
// $arrListhdkj = $ArticleMapper->findArticleForList('publish',$DeptID,3,-1);
// $arrListczzl = $ArticleMapper->findArticleForList('publish',$DeptID,4,-1);
// $arrListcysh = $ArticleMapper->findArticleForList('publish',$DeptID,5,-1);
// $arrListcgxy = $ArticleMapper->findArticleForList('publish',$DeptID,6,-1);
$this->view->arrListxw = $arrListxw;
$this->view->arrListzx = $arrListzx;
// $this->view->arrListhdkj = $arrListhdkj;
// $this->view->arrListczzl = $arrListczzl;
// $this->view->arrListcysh = $arrListcysh;
// $this->view->arrListcgxy = $arrListcgxy;
switch ($ColumnCode) {
case 'xw':
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListxw));
break;
case 'zx':
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListzx));
break;
// case 'hdkj': $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListhdkj)); break;
// case 'czzl': $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListczzl)); break;
// case 'cysh': $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListcysh)); break;
// case 'cgxy': $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListcgxy)); break;
// default : $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($arrListrdxw)); break;
}
$num = 10;
$page = 1;
//设置每一页显示的文章数目 //设置第一页显示
$paginator->setItemCountPerPage($num);
//设置每一页显示的文章数目
$paginator->setCurrentPageNumber($page);
//设置第一页显示
$paginator->setCurrentPageNumber($this->_getParam('page'));
//从url获取需要显示的页码
$this->view->paginator = $paginator;
} else {
$this->_redirect('/pengbei');
exit;
}
}
public function listarticleAction()
{
//获取学院信息
if ($_SESSION['user']['DeptID'] == 0) {
$DeptCode = $this->_request->getParam("dept");
$DeptMapper = new Application_Model_DepartmentMapper();
$arrDept = $DeptMapper->findDeptByCode($DeptCode);
if (!empty($arrDept)) {
$DeptID = $arrDept[0]['DeptID'];
} else {
$DeptID = -1;
}
//如果没有指定院系信息，默认查找所有学院文章（-1代表所有学院）
} else {
$DeptID = $_SESSION['user']['DeptID'];
}
//获取栏目信息
$ColumnID = $this->_request->getParam("column");
if ($ColumnID) {
$Column = $ColumnID;
} else {
$Column = -1;
}
//如果没有指定栏目信息，默认查找所有栏目文章（-1代表所有栏目）
//判断当前用户能获取文章的权限
$Self = 'no';
//默认查找所有文章
$Self = $this->_request->getParam("by");
//判断是否查找自己的文章
if ($Self == 'self') {
$UserID = $_SESSION['user']['UserID'];
} else {
$UserID = -1;
//如果没有指定用户信息，默认查找所有用户文章（-1代表所有用户）
}
//获取查找文章的时间区间
$BeginStamp = $this->_request->getParam("from");
$EndStamp = $this->_request->getParam("until");
if (empty($BeginStamp)) {
$BeginStamp = -1;
}
if (empty($EndStamp)) {
$EndStamp = -1;
}
/* 根据获取到的信息从数据库中查找文章 */
$ArticleMapper = new Application_Model_ArticleMapper();
$num = 20;
$page = 1;
//设置每一页显示的文章数目 //设置第一页显示
//查找全部文章
$rows_all = $ArticleMapper->findArticleByStampForList('all', $DeptID, $Column, $UserID, $BeginStamp, $EndStamp);
$paginator_all = new Zend_Paginator(new Zend_Paginator_Adapter_Array($rows_all));
//调用分页
$paginator_all->setItemCountPerPage($num);
//设置每一页显示的文章数目
$paginator_all->setCurrentPageNumber($page);
//设置第一页显示
$paginator_all->setCurrentPageNumber($this->_getParam('page'));
//从url获取需要显示的页码
//查找待审核的文章
$rows_wait = $ArticleMapper->findArticleByStampForList('wait', $DeptID, $Column, $UserID, $BeginStamp, $EndStamp);
$paginator_wait = new Zend_Paginator(new Zend_Paginator_Adapter_Array($rows_wait));
//调用分页
$paginator_wait->setItemCountPerPage($num);
//设置每一页显示的文章数目
$paginator_wait->setCurrentPageNumber($page);
//设置第一页显示
$paginator_wait->setCurrentPageNumber($this->_getParam('page'));
//从url获取需要显示的页码
//查找已退稿的文章
$rows_reject = $ArticleMapper->findArticleByStampForList('reject', $DeptID, $Column, $UserID, $BeginStamp, $EndStamp);
$paginator_reject = new Zend_Paginator(new Zend_Paginator_Adapter_Array($rows_reject));
//调用分页
$paginator_reject->setItemCountPerPage($num);
//设置每一页显示的文章数目
$paginator_reject->setCurrentPageNumber($page);
//设置第一页显示
$paginator_reject->setCurrentPageNumber($this->_getParam('page'));
//从url获取需要显示的页码
//查找已审核或修正的文章
$rows_publish = $ArticleMapper->findArticleByStampForList('publish', $DeptID, $Column, $UserID, $BeginStamp, $EndStamp);
$paginator_publish = new Zend_Paginator(new Zend_Paginator_Adapter_Array($rows_publish));
//调用分页
$paginator_publish->setItemCountPerPage($num);
//设置每一页显示的文章数目
$paginator_publish->setCurrentPageNumber($page);
//设置第一页显示
$paginator_publish->setCurrentPageNumber($this->_getParam('page'));
//从url获取需要显示的页码
/* 返回view的信息 */
if ($_SESSION['user']['DeptID'] == 0 && $_SESSION['user']['Type'] != 3) {
$this->view->DeptCodeSelected = $DeptCode;
$AllDeptMapper = new Application_Model_DepartmentMapper();
$arrAllDept = $AllDeptMapper->findAllDept();
$this->view->arrAllDept = $arrAllDept;
}
$this->view->PublishType = $this->_request->getParam("type");
if ($_SESSION['user']['Type'] == 1) {
if ($DeptID != -1) {
$this->view->ListTitle .= $arrDept[0]['DeptName'];
$this->view->ListTitle .= " 的 ";
}
}
$ColumnId = $this->_request->getParam("column");
$ColumnMapper = new Application_Model_ColumnMapper();
$arrColumn = $ColumnMapper->findColumnByCode($ColumnId);
if (!empty($arrColumn)) {
$this->view->ListTitle .= $arrColumn[0]['ColumnName'];
} else {
$this->view->ListTitle .= "全部文章";
}
$this->view->paginator_all = $paginator_all;
$this->view->paginator_wait = $paginator_wait;
$this->view->paginator_reject = $paginator_reject;
$this->view->paginator_publish = $paginator_publish;
}
