App\Ninja\Repositories\ExpenseCategoryRepository::find PHP Method

    public function find($filter = null)
    {
        $query = DB::table('expense_categories')->where('expense_categories.account_id', '=', Auth::user()->account_id)->select('expense_categories.name as category', 'expense_categories.public_id', 'expense_categories.user_id', 'expense_categories.deleted_at');
        if (!\Session::get('show_trash:expense_category')) {
            $query->where('expense_categories.deleted_at', '=', null);
        }
        if ($filter) {
            $query->where(function ($query) use($filter) {
                $query->where('expense_categories.name', 'like', '%' . $filter . '%');
            });
        }
        return $query;
    }

 /**
  * @param $clientPublicId
  * @param $search
  * @return \Illuminate\Http\JsonResponse
  */
 public function getDatatable($search)
 {
     // we don't support bulk edit and hide the client on the individual client page
     $datatable = new ExpenseCategoryDatatable();
     $query = $this->categoryRepo->find($search);
     return $this->datatableService->createDatatable($datatable, $query);
 }