public function users() { $users = Beneficiary::where('residents.id', '=', Auth::user()->id)->leftJoin('projects', 'projects.id', '=', 'beneficiaries.project_id')->leftJoin('project_resident', 'project_resident.project_id', '=', 'projects.id')->leftJoin('residents', 'residents.id', '=', 'project_resident.resident_id')->orderBy('beneficiaries.name', 'DESC')->select(['beneficiaries.*', 'projects.name as name_p'])->paginate(5); return view('residente.user', compact('users')); }
public function directBen($id) { $proyecto = Project::find($id); $homes = Beneficiary::where('project_id', '=', $proyecto->id)->get(); $boolean = false; if (count($homes) >= $proyecto->quantity) { Session::flash('message', 'Este proyecto tiene el maximo numero de beneficiarios'); return redirect()->to('admin/proyectos'); } else { return view('admin.beneficiario.create', compact('proyecto', 'boolean')); } }