/** * Sets the excepted routes. * * @return void */ public static function setExcept($except) { static::$except = $except; }
/** * Lấy $take reader phục vụ selectize reader * !! KHÔNG dùng với withUser() * * @param \Illuminate\Database\Query\Builder|static $query * @param mixed|null $ignore * @param int $take * * @return \Illuminate\Database\Query\Builder|static */ public function scopeForSelectize($query, $ignore = null, $take = 10) { return $query->except($ignore)->leftJoin('users', "{$this->table}.user_id", '=', 'users.id')->leftJoin('user_groups', 'user_groups.id', '=', 'users.group_id')->addSelect(["{$this->table}.user_id as id", "users.name", "users.username", "user_groups.full_name as group_name"])->take($take); }