PHP Pool::none方法代码示例

 public function index()
 {
     $this->set_title('Pools');
     $sql_query = Pool::none()->page($this->page_number())->perPage(CONFIG()->pool_index_default_limit);
     $order = $this->params()->order ?: 'id';
     $search_tokens = array();
     if ($this->params()->query) {
         $this->set_title($this->params()->query . " - Pools");
         // $query = array_map(function($v){return addslashes($v);}, explode($this->params()->query);
         // $query = Tokenize.tokenize_with_quotes($this->params[:query] || "")
         $query = explode(' ', addslashes($this->params()->query));
         foreach ($query as &$token) {
             if (preg_match('/^(order|limit|posts):(.+)$/', $token, $m)) {
                 if ($m[1] == "order") {
                     $order = $m[2];
                 } elseif ($m[1] == "limit") {
                     $sql_query->perPage(min((int) $m[2], 100));
                 } elseif ($m[1] == "posts") {
                     Post::generate_sql_range_helper(Tag::parse_helper($m[2]), "post_count", $sql_query);
                 }
             } else {
                 // # TODO: removing ^\w- from token.
                 // $token = preg_replace('~[^\w-]~', '', $token);
                 $search_tokens[] = $token;
             }
         }
     }
     if (!empty($search_tokens)) {
         // $value_index_query = QueryParser.escape_for_tsquery($search_tokens);
         $value_index_query = implode('_', $search_tokens);
         if ($value_index_query) {
             # If a search keyword contains spaces, then it was quoted in the search query
             # and we should only match adjacent words.    tsquery won't do this for us; we need
             # to filter results where the words aren't adjacent.
             #
             # This has a side-effect: any stopwords, stemming, parsing, etc. rules performed
             # by to_tsquery won't be done here.    We need to perform the same processing as
             # is used to generate search_index.    We don't perform all of the stemming rules, so
             # although "jump" may match "jumping", "jump beans" won't match "jumping beans" because
             # we'll filter it out.
             #
             # This also doesn't perform tokenization, so some obscure cases won't match perfectly;
             # for example, "abc def" will match "xxxabc def abc" when it probably shouldn't.    Doing
             # this more correctly requires Postgresql support that doesn't exist right now.
             foreach ($query as $q) {
                 # Don't do this if there are no spaces in the query, so we don't turn off tsquery
                 # parsing when we don't need to.
                 // if (!strstr($q, ' ')) continue;
                 $sql_query->where("(position(LOWER(?) IN LOWER(REPLACE(name, '_', ' '))) > 0 OR position(LOWER(?) IN LOWER(description)) > 0)", $q, $q);
             }
         }
     }
     if (empty($order)) {
         $order = empty($search_tokens) ? 'date' : 'name';
     }
     switch ($order) {
         case "name":
             $sql_query->order("name asc");
             break;
         case "date":
             $sql_query->order("created_at desc");
         case "updated":
             $sql_query->order("updated_at desc");
             break;
         case "id":
             $sql_query->order("id desc");
             break;
         default:
             $sql_query->order("created_at desc");
             break;
     }
     $this->pools = $sql_query->paginate();
     $samples = [];
     foreach ($this->pools as $p) {
         if (!($post = $p->get_sample())) {
             continue;
         }
         $p_id = (string) $p->id;
         $samples[$p_id] = $post;
     }
     $this->samples = $samples;
     $this->respond_to_list('pools');
 }