/** * Display a listing of all manageable people. * * @param Request $request * @return \Illuminate\View\View */ public function managePeopleIndex(Request $request) { // If request is a search if ($request->method() === "PUT") { $peoples = People::where('name', 'LIKE', '%' . $request->search . '%')->where(function ($query) use($request) { if ($request->curr_student_checkbox != null) { $query->orWhere('type', '=', 'current_student'); } if ($request->past_student_checkbox != null) { $query->orWhere('type', '=', 'past_student'); } if ($request->curr_staff_checkbox != null) { $query->orWhere('type', '=', 'current_staff'); } if ($request->past_staff_checkbox != null) { $query->orWhere('type', '=', 'past_staff'); } if ($request->partner_checkbox != null) { $query->orWhere('type', '=', 'partner'); } })->get(); } else { $peoples = People::all(); } return view('admin.people.index', ['peoples' => $peoples]); }
public function show(Request $request) { debug($request->session()); $areas = Area::with(['personas' => function ($q) { $q->where('destacado', 0); }])->get(); $destacados = People::where('destacado', 1)->get(); return view('consejo', ['tab' => 'consejo'])->with('areas', $areas)->with('destacados', $destacados); }
public function uploadCsv() { $file = Input::file('csv'); Excel::load($file, function ($reader) { // Getting all results $results = $reader->get()->toArray(); foreach ($results as $result) { $oldData = People::where('id', '=', $result['id'])->first(); if (!is_null($oldData)) { $oldData->fill($result)->save(); } else { $data = People::create($result); } } return redirect()->action('HomeController@viewPeople'); }); }
/** * Get the list of current students. * * @return mixed */ public static function getPeopleType($type) { return People::where('type', '=', $type)->get(); }
/** * @param AddRoleRequest $request * @return \Illuminate\View\View */ public function postAddroleindex(AddRoleRequest $request) { $branch = Branch::findOrFail($request->get('branch_id')); $people = People::where('document', $request->get('document'))->get(); if (!$branch->worker->isEmpty()) { $worker = $branch->worker; $int = 0; foreach ($worker as $w) { if ($w->people_id == $people[0]->id) { $int++; } } if ($int != 0) { flash()->overlay('No se pudo realizar la operación debido a que ya está registrada la persona ' . $people[0]->names . ' como empleado de esta sucursal.', 'Notificación de errores'); $people = People::all(); return redirect(url('/admin/role')); } else { $branch->worker()->save(new Worker(['people_id' => $people[0]->id])); $user = $people[0]->user; $user->roles()->sync($request->get('role_ids')); flash()->success('Se realizó la asignación de roles con éxito.'); return redirect(url('/admin/role')); } } else { $branch->worker()->save(new Worker(['people_id' => $people[0]->id])); $user = $people[0]->user; $user->roles()->sync($request->get('role_ids')); flash()->success('Se realizó la asignación de roles con éxito.'); return redirect(url('/admin/role')); } }