function index($ctx) { $page = $_GET['page'] ? intval($_GET['page']) : 0; $size = $_GET['size'] ? intval($_GET['size']) : 10; $s = $_GET['s']; $keyword_type = $_GET['keyword_type']; $ctx->s = $s; $ctx->page = $page; $ctx->size = $size; $ctx->keyword_type = $keyword_type; $where = "1"; if ($s || $keyword_type) { $s2 = Db::escape_like_string($s); $where .= " and id in(\n\t\t\t\tselect item_id from wx_reply_keywords where 1"; if ($s) { $where .= " and keyword like '%{$s2}%'"; } if ($keyword_type) { $keyword_type = Db::escape($keyword_type); $where .= " and type='{$keyword_type}'"; } $where .= ")"; } $ds = WxReplyItem::paginate($page, $size, $where, 'id desc'); $ctx->ds = $ds; }