Skip to content

Instantly share code, notes, and snippets.

@sr2ds
Created April 23, 2018 16:21
Show Gist options
  • Save sr2ds/77182c42be7385cbddc5eb1c6d99f615 to your computer and use it in GitHub Desktop.
Save sr2ds/77182c42be7385cbddc5eb1c6d99f615 to your computer and use it in GitHub Desktop.
Search Method for Laravel Repository
public function search($input = []) {
$query = $this->model;
if (isset($input['tenant_id']))
$query = $query->ofTenantId($input['tenant_id']);
if (isset($input['keywords']) && ($k = $input['keywords'])) {
$query = $query
->where(function ($subquery) use ($k) {
return $subquery
->where('last_name', 'like', "%{$k}%")
->orWhere('first_name', 'like', "%{$k}%")
->orWhere('identity', 'like', "%{$k}%")
->orWhere('email', 'like', "%{$k}%");
});
}
return $query->select('users.*')->orderBy('users.created_at', 'desc');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment