/**
* 敏感词列表
* @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);
}
