/** * 文章列表 */ public function listAction() { $sql = $this->db->select()->from('article')->ORDER('art_id DESC'); $article = $this->db->fetchAll($sql); $paginator = YUN_Paginator::factory($article, $this->_request, 1); $this->view->paginator = $paginator; }
/** * 文件列表 */ public function listAction() { $keyword = $this->view->keyword = $this->_getParam('keyword'); $cateId = $this->view->cateId = (int) $this->_getParam('cate_id', 0); $select = $this->file->listSql(); if ($cateId > 0) { $select->where('file.cate_id=?', $cateId); } if (!empty($keyword)) { $select->where('file.filename like ? OR file.description like ?', "%{$keyword}%", "%{$keyword}%"); } $select = $select->order('file.file_id DESC'); $rows = $this->db->fetchAll($select); $this->view->paginator = YUN_Paginator::factory($rows, $this->_request, 10); }