PHP Eloquent::where方法代码示例

 /**
  * Perform column search
  *
  * @return void
  */
 public function doColumnSearch()
 {
     $input = $this->input;
     $columns = $input['columns'];
     // if older version, set the column name to query's fields
     // or if new version but does not use mData support
     if (!$this->new_version or !$this->mDataSupport and $this->new_version) {
         for ($i = 0; $i < count($columns); $i++) {
             if (!isset($this->columns[$i])) {
                 continue;
             }
             $columns[$i]['name'] = $this->columns[$i];
             if (stripos($columns[$i]['name'], ' AS ') !== false or $columns[$i]['name'] instanceof Expression) {
                 $columns[$i]['name'] = '';
                 $columns[$i]['searchable'] = false;
                 $columns[$i]['orderable'] = false;
             }
         }
     }
     for ($i = 0, $c = count($columns); $i < $c; $i++) {
         if ($columns[$i]['searchable'] == "true" and !empty($columns[$i]['search']['value']) and !empty($columns[$i]['name'])) {
             $column = $columns[$i]['name'];
             $keyword = $this->setupKeyword($columns[$i]['search']['value']);
             // wrap column possibly allow reserved words to be used as column
             $column = $this->wrapColumn($column);
             if ($this->isCaseInsensitive()) {
                 $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [strtolower($keyword)]);
             } else {
                 $col = strstr($column, '(') ? $this->connection->raw($column) : $column;
                 $this->query->where($col, 'LIKE', $keyword);
             }
         }
     }
 }

 protected function validateOwnership(Eloquent $model)
 {
     // Validate correct resource
     if ($model_id = Request::segment(2)) {
         $count = $model->where('id', $model_id)->where('user_id', Auth::id())->count();
         if ($count === 0) {
             return $this->respondNotFound();
         }
     }
 }

 /**
  * Perform column search
  *
  * @param  array $columns
  * @return void
  */
 public function doColumnSearch(array $columns)
 {
     for ($i = 0, $c = count($columns); $i < $c; $i++) {
         if ($columns[$i]['searchable'] == "true" and !empty($columns[$i]['search']['value']) and !empty($columns[$i]['name'])) {
             $column = $columns[$i]['name'];
             $keyword = $this->setupKeyword($columns[$i]['search']['value']);
             // wrap column possibly allow reserved words to be used as column
             $column = $this->wrapColumn($column);
             if ($this->isCaseInsensitive()) {
                 $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [strtolower($keyword)]);
             } else {
                 $col = strstr($column, '(') ? $this->connection->raw($column) : $column;
                 $this->query->where($col, 'LIKE', $keyword);
             }
         }
     }
 }

 /**
  * Фильтр: диапазон дат
  *
  * @param      $form_field
  * @param      $label
  * @param null $db_field
  */
 function addFilterRangeDate($form_field, $label, $db_field = null)
 {
     if (!$db_field) {
         $db_field = $form_field;
     }
     $gr = $this->form->putTbGroup($form_field)->setLabel($label);
     $gr->putTbDate('from')->setLabel('С')->setWrapClass('col-md-6')->setAppendClear();
     $gr->putTbDate('to')->setLabel('по')->setWrapClass('col-md-6')->setAppendClear();
     $from = \Input::get($form_field . '.from');
     $to = \Input::get($form_field . '.to');
     if ($from) {
         $this->model->where(function ($query) use($db_field, $from) {
             $query->where($db_field, '>=', \Carbon\Carbon::parse($from)->format('Y-m-d H:i:s'));
         });
     }
     if ($to) {
         $this->model->where(function ($query) use($db_field, $to) {
             $query->where($db_field, '<=', \Carbon\Carbon::parse($to)->format('Y-m-d H:i:s'));
         });
     }
 }

 /**
  * Delete a row with store_key
  *
  * @param $key
  * @return int
  */
 public static function storeDelete($key)
 {
     return parent::where(self::$storeColumn['key'], $key)->delete();
 }

 /**
  * @param string $slug
  * @return mixed
  */
 public function getBySlug($slug)
 {
     return $this->model->where('slug', $slug)->firstOrFail();
 }

 /**
  * Edit data by id
  * @param  mixed $value
  * @param  array $data
  * @param  string $field
  * @return int How many record has been changed
  */
 public function edit($value, array $data, $field = 'id')
 {
     $result = $this->model->where($field, $value)->update($data);
     return $result;
 }