public function update(Request $request, $id)
{
$data = $request->all();
$model = Users::find($id);
autoAssignDataToProperty($model, $request->all());
$password = bcrypt($request->input('password'));
$model->password = $password;
$model->save();
return redirect(URL::previous())->withSuccess(Lang::get('messages.update_success'));
}
public function show($id)
{
$users = DB::table('users')->select('id', 'name', 'email', 'nombre')->where('id', '=', session('id'))->get();
Request::session()->has('id', $users[0]->id);
$datos = $users[0]->id . $users[0]->nombre;
$nombre = $users[0]->nombre;
$email = $users[0]->email;
$user = \App\Users::find($id);
return view('maestro.grupos', compact('nombre', 'email', 'user'));
return Helper::isLogged();
}
public function status(StatusRequest $requests)
{
if (Request::ajax()) {
$action = $requests->input('action');
if ($action == 'delete') {
$user = Users::find($requests->input('id'));
$user->delete();
}
if (!empty($action)) {
$user = Users::find($requests->input('id'));
if ($user->is_active == 'blocked') {
$user->is_active = 'active';
} elseif ($user->is_active == 'active') {
$user->is_active = 'blocked';
}
$user->save();
}
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$users = Users::find($id);
$users->delete();
Request::session()->flash('success', 'Delete successful!');
return redirect('admin/users');
}
public function getUser($id)
{
$user = Users::find($id);
return view('users.find')->with('user', $user);
}
public function get()
{
$this->_methodName = 'get';
$this->resolveParams();
if (!Auth::check()) {
throw new \App\Exceptions\ExceptionApiMethodbad($this->_typeName, $this->_methodName, $this->_request_params);
}
if (!$this->checkUserUnable() && !Auth::checkAdmin()) {
throw new \App\Exceptions\ExceptionApiNotFulInfo($this->_request_params, $this->_typeName, $this->_methodName);
}
$arNeed = ['taskId' => 'required|numeric'];
$this->checkAttr($arNeed);
$this->checkAuth();
$dataOut['nowDate'] = Carbon::now()->toDateTimeString();
$task = \App\Task::whereId($this->_request_params['taskId'])->first();
if (is_null($task)) {
throw new \App\Exceptions\ExceptionApiContactnotfound($this->_request_params, $this->_typeName, $this->_methodName);
}
$dataOut['name'] = $task->name;
$dataOut['description'] = $task->description;
$dataOut['score'] = (int) $task->point;
$dataOut['timer'] = (int) $task->timer;
if (Auth::checkAdmin()) {
$dataOut['userDone'] = null;
$task_users = \App\UserTask::where('id_task', $task->id)->whereStatus('done')->get();
foreach ($task_users as $task_user) {
$user = \App\Users::find($task_user->id_user);
$dataOut['userDone'][] = ['userId' => $user->id, 'firstName' => $user->first_name, 'lastName' => $user->last_name, 'status' => $task_user->status];
}
$queryactive = DB::table('UserTask')->select(DB::raw('count(id_user) as active'))->where('id_task', $task->id)->where('status', 'active')->groupBy('id_task')->get();
if (count($queryactive) > 0) {
$dataOut['usersActiveCount'] = (int) $queryactive[0]->active;
} else {
$dataOut['usersActiveCount'] = 0;
}
$queryavailable = DB::table('UserTask')->select(DB::raw('count(id_user) as available'))->where('id_task', $task->id)->where('status', 'available')->groupBy('id_task')->get();
if (count($queryavailable) > 0) {
$dataOut['usersAvailableCount'] = (int) $queryavailable[0]->available;
} else {
$dataOut['usersAvailableCount'] = 0;
}
$querycancel = DB::table('UserTask')->select(DB::raw('count(id_user) as cancel'))->where('id_task', $task->id)->where('status', 'cancel')->groupBy('id_task')->get();
if (count($querycancel) > 0) {
$dataOut['usersCancelCount'] = (int) $querycancel[0]->cancel;
} else {
$dataOut['usersCancelCount'] = 0;
}
$querytimeout = DB::table('UserTask')->select(DB::raw('count(id_user) as timeout'))->where('id_task', $task->id)->where('status', 'timeout')->groupBy('id_task')->get();
if (count($querytimeout) > 0) {
$dataOut['usersTimeoutCount'] = (int) $querytimeout[0]->timeout;
} else {
$dataOut['usersTimeoutCount'] = 0;
}
$querydone = DB::table('UserTask')->select(DB::raw('count(id_user) as done'))->where('id_task', $task->id)->where('status', 'done')->groupBy('id_task')->get();
if (count($querydone) > 0) {
$dataOut['usersDoneCount'] = (int) $querydone[0]->done;
} else {
$dataOut['usersDoneCount'] = 0;
}
}
$this->_arData = $dataOut;
return $this;
}
public function delete()
{
$this->_methodName = 'delete';
if (!Auth::check() || !Auth::checkAdmin()) {
throw new \App\Exceptions\ExceptionApiMethodbad($this->_typeName, $this->_methodName, $this->_request_params);
}
$this->resolveParams();
$arNeed = ['userId' => 'required|numeric'];
$this->checkAttr($arNeed);
$reg_user = \App\Users::find($this->_request_params['userId']);
if (!is_null($reg_user)) {
$reg_user->delete();
return $this;
} else {
throw new \App\Exceptions\ExceptionApiUserNotFound($this->_request_params, $this->_typeName, $this->_methodName);
}
}
public function destroy($id)
{
Users::find($id)->delete();
return redirect_success('Admin\\UsersController@index', Lang::get('messages.delete_success'));
}
public function show()
{
$user_main = \App\Users::find($this->_idUser);
if (is_null($user_main)) {
return redirect('/users');
}
$users = DB::table('UserTask')->join('task', 'UserTask.id_task', '=', 'task.id')->where('UserTask.id_user', $this->_idUser)->select(DB::raw('UserTask.id as id_userTask, status, UserTask.id_user, task.name as name, task.id as id_task, point, UserTask.updated_at'))->get();
$rows = ['done' => '', 'timeout' => '', 'available' => '', 'cancel' => '', 'active' => ''];
foreach ($users as $user) {
$status = ['avaliable' => '', 'done' => '', 'active' => '', 'cancel' => '', 'timeout' => ''];
$status[$user->status] = 'selected';
$filesUser = \App\Files::where('id_taskUser', $user->id_userTask)->get();
$files = "";
if (!is_null($filesUser)) {
foreach ($filesUser as $value) {
$files .= $value->file . ';';
}
}
$infoUser = \App\InfoTask::where('id_taskUser', $user->id_userTask)->first();
if (is_null($infoUser)) {
$lat = "";
$lng = "";
$text = "";
} else {
$lat = $infoUser->lat;
$lng = $infoUser->lng;
$text = $infoUser->text;
}
$str = '<tr class="gradeC userRow fade in" data-id="' . $user->id_userTask . '" data-idtask="' . $user->id_task . '" data-files="' . $files . '" data-lat="' . $lat . '" data-lng="' . $lng . '" data-text="' . $text . '">
<td class="userEmail">
' . $user->name . '
</td>
<td class="center">
<div class="form-group"><select class="form-control select" id="select" autocomplete="off">
<option ' . $status['avaliable'] . ' value="avaliable">Available</option>
<option ' . $status['done'] . ' value="done">Performed</option>
<option ' . $status['active'] . ' value="active">Active</option>
<option ' . $status['cancel'] . ' value="cancel">Declined</option>
<option ' . $status['timeout'] . ' value="timeout">Overdued</option>
</select></div>
</td>
';
switch ($user->status) {
case 'done':
$rows['done'] .= $str . ' <td>
<button type="button" class="btn btn-success" >Read more</button>
</td>
</tr>';
break;
case 'timeout':
$rows['timeout'] .= $str . '</tr>';
break;
case 'available':
$rows['available'] .= $str . '</tr>';
break;
case 'cancel':
$rows['cancel'] .= $str . '</tr>';
break;
case 'active':
$rows['active'] .= $str . ' <td>
' . $user->updated_at . '
</td>
</tr>';
break;
default:
break;
}
}
$count = DB::table('UserTask')->join('task', 'UserTask.id_task', '=', 'task.id')->where('UserTask.id_user', $user_main->id)->where('UserTask.status', 'done')->groupBy('id_user')->select(DB::raw('sum(point) as point'))->get();
if (count($count) > 0) {
$user_main->bonusPoint += $count[0]->point;
}
return View::make('view.userInfo')->withRows($rows)->withUser($user_main);
}
public function postReset(ResetPasswordRequest $request)
{
$email = $request->email;
$old_password = $request->old_password;
$password = $request->password;
$password_confirm = $request->password_confirm;
// Vérification que le couple mail/old_password est valide
$user = new \App\Users();
$user = \App\Users::where('email', '=', $email)->where('forgotPass', '=', $old_password)->count();
if ($user > 0) {
// Mise à jour du mot de passe
if ($password === $password_confirm) {
// Mise à jour du mot de passe en base de données
$id_user = \App\Users::where('email', '=', $email)->get();
$id = $id_user[0]->id;
$user = \App\Users::find($id);
$user->password = \Hash::make($request->password . \Config::get('constante.salt'));
$user->save();
//redirection sur la page d'authentification
return redirect('/')->withFlashMessageError(Lang::get('global.successNewConfirmPassword'));
} else {
//redirection avec message d'erreur
return redirect('password/reset')->withFlashMessageError(Lang::get('global.errorConfirmPassword'));
}
} else {
//redirection avec message d'erreur
return redirect('password/reset')->withFlashMessageError(Lang::get('global.erreurEMailOldPassword'));
}
// Mise à jour du nouveau mot de passe
}
