public function findVendor($vendorPublicId)
{
$vendorId = Vendor::getPrivateId($vendorPublicId);
$query = $this->find()->where('expenses.vendor_id', '=', $vendorId);
return $query;
}
/** * @param $vendorPublicId * @return \Illuminate\Http\JsonResponse */ public function getDatatableVendor($vendorPublicId) { $datatable = new ExpenseDatatable(false, true); $query = $this->expenseRepo->findVendor($vendorPublicId); if (!Utils::hasPermission('view_all')) { $query->where('expenses.user_id', '=', Auth::user()->id); } return $this->datatableService->createDatatable($datatable, $query); }