PHP Builder::offset方法代碼示例

 /**
  * @param $value
  * @return $this
  */
 public function applyOffset($value)
 {
     /**
      * Save to conditons.
      */
     $this->addCondition('offset', $value);
     $this->model = $this->model->offset($value);
     return $this;
 }

 /**
  * Parse the query parameters with the given options.
  * Either for a single dataset or multiple.
  *
  * @param  mixed    $options
  * @param  boolean  $multiple
  * @return void
  */
 public function parse($options, $multiple = false)
 {
     $this->multiple = $multiple;
     if ($multiple) {
         $fullTextSearchColumns = $options;
         //Parse and apply offset using the laravel "offset" function
         if ($offset = $this->getParam('offset')) {
             $offset = intval($offset);
             $this->query->offset($offset);
         }
         //Parse and apply limit using the laravel "limit" function
         if ($limit = $this->getParam('limit')) {
             $limit = intval($limit);
             $this->query->limit($limit);
         }
         //Parse and apply the filters using the different laravel "where" functions
         //Every parameter that has not a predefined functionality gets parsed as a filter
         if ($filterParams = $this->getFilterParams()) {
             $this->parseFilter($filterParams);
         }
         //Parse an apply the fulltext search using the different laravel "where" functions
         //The fulltext search is only applied to the columns passed by $fullTextSearchColumns.
         if ($this->getParam('q') !== false) {
             $this->parseFulltextSearch($this->getParam('q'), $fullTextSearchColumns);
         }
     } else {
         $identification = $options;
         if (is_numeric($identification)) {
             $this->query->where('id', $identification);
         } else {
             if (is_array($identification)) {
                 foreach ($identification as $column => $value) {
                     $this->query->where($column, $value);
                 }
             }
         }
     }
     //Parse and apply field elements using the laravel "select" function
     //The needed fields for the with function (Primary and foreign keys) have to be added accordingly
     if ($fields = $this->getParam('fields')) {
         $this->parseFields($fields);
     }
     //Parse and apply sort elements using the laravel "orderBy" function
     if ($sort = $this->getParam('sort')) {
         $this->parseSort($sort);
     }
     //Parse and apply with elements using the Laravel "with" function
     if (($with = $this->getParam('with')) && $this->isEloquentBuilder) {
         $this->parseWith($with);
     }
     //Parse the config params
     if ($config = $this->getParam('config')) {
         $this->parseConfig($config);
     }
     if ($this->isEloquentBuilder) {
         //Attach the query builder object back to the eloquent builder object
         $this->builder->setQuery($this->query);
     }
 }

 /**
  * Set the "offset" value of the query.
  *
  * @param int $value
  * @return $this 
  * @static 
  */
 public static function offset($value)
 {
     return \Illuminate\Database\Query\Builder::offset($value);
 }