Example #1
0
 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;
 }