/** * Add a whereIn to the query * * @param string $field * @param array $values * @param bool $order * * @return $this */ public function whereIn($field, $values, $order = false) { $this->builder = $this->builder->whereIn($field, $values); if ($order) { $this->builder = $this->builder->orderByRaw(DB::raw("FIELD(" . $field . ", " . implode(',', $values) . ")")); } return $this; }
public function scopeHighestRes(Builder $query) { return $query->orderByRaw('(width * height) DESC'); }
/** * Order entries in a specific order. * * @param \Illuminate\Database\Eloquent\Builder $query * @param string $field * @param array $values * * @return \Illuminate\Database\Eloquent\Builder */ public function scopeOrderByField($query, $field, $values) { return $query->orderByRaw($field . ' <> "' . implode('", ' . $field . ' <> "', $values) . '"'); }