How search User(name, email) or lowercase with pagination

administrator

Administrator
Nhân viên
9 Tháng tám 2021
87
0
6
This is code search name or email is lowercase with pagination
Mã:
use App\Models\User;
/**
* @param search_val
*
*
* @return App\Models\User with pagination
*/
public function getUserBySearch($search_val)
{
        $users = User::all();
        if(!empty($search_val)){
            $users = $users->where('name', 'ilike', "%{$search_val}%")->orWhere('mail', 'ilike', "%{$search_val}%");
        }
        $users = $users->orderBy('submit_date', 'DESC')->paginate(10);
        return $users;
}