/**
* 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'));
}
}
