PHP Builder::get方法代码示例

 /**
  * Get records from the database.
  *
  * @param int $per_page
  *
  * @return Collection
  */
 public function get($per_page = 20)
 {
     $this->per_page = $per_page;
     $this->buildQuery();
     return $this->query->get();
 }

 /**
  * Get the hydrated models without eager loading.
  *
  * @param  array  $columns
  * @return \Illuminate\Database\Eloquent\Model[]
  */
 public function getModels($columns = ['*'])
 {
     $results = $this->query->get($columns);
     $connection = $this->model->getConnectionName();
     return $this->model->hydrate($results, $connection)->all();
 }

 /**
  * @param Builder|EloquentBuilder $data
  * @return Traversable
  */
 protected function afterOperations($data)
 {
     if ($data instanceof EloquentBuilder) {
         return $data->get();
     } elseif ($data instanceof Builder) {
         return new ArrayIterator($data->get());
     }
     throw new RuntimeException('Unsupported type of data source.');
 }

 public function totalCount()
 {
     if ($this->options['distinctCountGroup'] && count($this->originalBuilder->groups) == 1) {
         $this->originalBuilder->groups = null;
     }
     if ($this->options['searchWithAlias']) {
         $cnt = count($this->originalBuilder->get());
     } else {
         $cnt = $this->originalBuilder->count();
     }
     return $cnt;
 }

 /**
  * Find data by multiple fields
  *
  * @param array $where
  * @param array $columns
  * @return mixed|Model
  */
 public function findWhere(array $where, $columns = ['*'])
 {
     return $this->wrap(function ($where, $columns = ['*']) {
         $this->applyWhere($where);
         return $this->model->get($columns);
     }, new Action(__METHOD__, func_get_args(), Action::READ));
 }

 /**
  * Gets results from prepared query
  *
  * @return null
  */
 protected function getResult()
 {
     if ($this->query_type == 'eloquent') {
         $this->result_object = $this->query->get();
         $this->result_array = $this->result_object->toArray();
     } else {
         $this->result_object = $this->query->get();
         $this->result_array = array_map(function ($object) {
             return (array) $object;
         }, $this->result_object);
     }
     if ($this->dataFullSupport) {
         $walk = function ($value, $key, $prefix = null) use(&$walk, &$result_array) {
             $key = !is_null($prefix) ? $prefix . "." . $key : $key;
             if (is_array($value)) {
                 array_walk($value, $walk, $key);
             } else {
                 $result_array = Arr::add($result_array, $key, $value);
             }
         };
         $result_array = array();
         array_walk($this->result_array, $walk);
         $this->result_array = $result_array;
     }
 }

 /**
  * Execute the query as a "select" statement.
  *
  * @param  array  $columns
  * @return array|static[]
  */
 public function get($columns = array('*'))
 {
     if ($this->model instanceof Model) {
         $this->model->filterQuery($this, 'after');
     }
     return parent::get($columns);
 }

 /**
  * Execute the query as a "select" statement.
  *
  * @param  array  $columns
  * @return array|static[]
  */
 public function get($columns = ['*'])
 {
     if (null !== $this->cacheMinutes) {
         return $this->getCached($columns);
     }
     return parent::get($columns);
 }

 /**
  * Execute the query as a "select" statement.
  *
  * @param  array  $columns
  * @return array|static[]
  */
 public function get($columns = array('*'))
 {
     if (!is_null($this->cacheMinutes)) {
         return $this->getCached($columns);
     }
     return parent::get($columns);
 }

 /**
  * flush events, build pagination and sort items
  * 
  * @return $this
  */
 public function build()
 {
     BurpEvent::flush('dataset.sort');
     BurpEvent::flush('dataset.page');
     $this->paginator = Paginator::make($this->total_rows, $this->per_page, $this->page);
     $offset = $this->paginator->offset();
     $this->limit($this->per_page, $offset);
     if (is_array($this->source)) {
         //orderby
         if (isset($this->orderby)) {
             list($field, $direction) = $this->orderby;
             array_orderby($this->source, $field, $direction);
         }
         //limit-offset
         if (isset($this->limit)) {
             $this->source = array_slice($this->source, $this->limit[1], $this->limit[0]);
         }
         $this->data = $this->source;
     } else {
         //orderby
         if (isset($this->orderby)) {
             $this->query = $this->query->orderBy($this->orderby[0], $this->orderby[1]);
         }
         //limit-offset
         if (isset($this->per_page)) {
             $this->query = $this->query->skip($offset)->take($this->per_page);
         }
         $this->data = $this->query->get();
     }
     return $this;
 }

 /**
  * Return all of the results.
  *
  * @return array
  * @throws TableNotSetException
  */
 public function results()
 {
     if (!$this->query) {
         throw new TableNotSetException("You must set a database table to get results from.");
     }
     return $this->query->get($this->select);
 }

 public function get($columns = array('*'))
 {
     for ($n = 0; $n < count($columns); $n++) {
         $columns[$n] = is_string($columns[$n]) ? snake_case($columns[$n]) : $columns[$n];
     }
     return parent::get($columns);
     // TODO: Change the autogenerated stub
 }

 /**
  * Execute the query as a "select" statement.
  *
  * @param  array $columns
  * @return array|static[]
  */
 public function get($columns = ['*'])
 {
     $cacheKey = $this->generateCacheKey();
     if (null === ($results = $this->cache->tags($this->cacheTag)->get($cacheKey))) {
         $results = parent::get($columns);
         $this->cache->tags($this->cacheTag)->forever($cacheKey, $results);
     }
     return $results;
 }

 /**
  * get list
  *
  * @param array $columns get columns list
  * @return array|static[]
  */
 public function get(array $columns = ['*'])
 {
     if ($this->dynamic === false) {
         return $this->query->get($columns);
     }
     if ($this->proxy === true) {
         $this->query = $this->getProxyManager()->get($this->query);
     }
     return $this->query->get($columns);
 }

 /**
  * Returns HTML with resource table
  *
  * @return string
  * @throws CollectionException
  */
 public function make()
 {
     if (empty($this->_columns)) {
         throw new CollectionException('At least one column is required to generate a resource table.');
     }
     // Prepare builder object before calling Table
     $this->_prepareBuilder();
     // Finally execute prepared query builder
     $items = $this->_builder->get();
     return with(new Table($items, ['collection_generator' => $this, 'columns' => $this->_columns, 'per_page' => $this->_perPage, 'paginate' => $this->_paginate, 'paginator_presenter' => $this->_getPaginatorPresenter($items), 'view_name' => $this->_viewName, 'filter' => $this->_filter, 'extra' => $this->_extraViewData]))->make();
 }