/** * 敏感词列表 * @date: 2016-1-15 * @author: futao */ public function keywordlistAction() { $this->setLeftNav('keywordlist'); $req = $this->request; $page = intval($req->getQuery('page', null, 1)); $page = $page > 0 ? $page : 1; $limit = $this->pageNavLimit; $offset = $limit * ($page - 1); $filterWord = $req->getQuery('keyword', null, ''); if ($filterWord != '') { $where[] = 'keyword like "%' . $filterWord . '%"'; } if (count($where) > 0) { $whereStr = implode(" and ", $where); $wordModel = CosQKeyword::query()->where($whereStr); } else { $wordModel = CosQKeyword::query(); } $list = $wordModel->limit($limit, $offset)->orderBy('id desc')->execute()->toArray(); $total = CosQKeyword::count($whereStr); $this->view->setVar('keyword', $filterWord); $this->view->setVar('list', $list); $this->view->setVar('page', $page); $this->view->setVar('limit', $limit); $this->view->setVar('total', $total); }