/** * GHet user by ID * * @return Response */ public function store() { /** * Création d'un utilisateurs + Création d'une room si pas de room ou alors complet */ // Remplissage des data, pour l'insertion $data = \Input::get('data'); $pseudoExist = \App\Users::where('pseudo', '=', $data['pseudo'])->count(); if ($pseudoExist >= 1) { return response()->json('Votre pseudo est déjà utiliser sur cette partie, veuillez saisir un autre pseudo', 200); } else { \App\Users::create($data); } // Dérnier inscris $users = \App\Users::orderBy('id', 'desc')->limit(1)->get(); /* Création d'une room */ $userRoom = \App\User_Room::count(); if ($userRoom == 0 || $userRoom == 5 || $userRoom == 10 || $userRoom == 15 || $userRoom == 20 || $userRoom == 25 || $userRoom == 30 || $userRoom == 35 || $userRoom == 40 || $userRoom == 45 || $userRoom == 50 || $userRoom == 55 || $userRoom == 60 || $userRoom == 65 || $userRoom == 70 || $userRoom == 75 || $userRoom == 80 || $userRoom == 85 || $userRoom == 90 || $userRoom == 95 || $userRoom == 100) { $room = new \App\Room(); $room->status = 1; $room->save(); } // dérniere Room $showRoom = \App\Room::orderBy('id', 'desc')->limit(1)->get(); /* Création des users sur une room */ $user_room = new \App\User_Room(); $user_room->id_users = $users[0]->id; $user_room->id_room = $showRoom[0]->id; $user_room->score; $user_room->gagner; $user_room->nbr_ligne; $user_room->save(); return response()->json('Création du joueur avec succès', 200); }
public function show() { $users = DB::table('user')->count(); $tasks = DB::table('task')->count(); $count = DB::table('UserTask')->join('task', 'UserTask.id_task', '=', 'task.id')->where('UserTask.status', 'done')->select(DB::raw('sum(point) as point'))->get(); if (count($count) > 0) { $sum = $count[0]->point; } else { $sum = 0; } $querydone = DB::table('UserTask')->select(DB::raw('count(id_task) as done'))->where('status', 'done')->get(); if (count($querydone) > 0) { $countDone = (int) $querydone[0]->done; } else { $countDone = 0; } $users_list = \App\Users::orderBy('created_at', 'desc')->take(5)->get(); $rowsUsers = ""; foreach ($users_list as $user) { $rowsUsers .= '<tr class="gradeC userRow" id="' . $user->id . '"> <td class="userEmail"> ' . $user->email . ' </td> <td class="userLastName"> ' . $user->last_name . ' </td> <td class="center userFirstName"> ' . $user->first_name . ' </td> <td class="center userCity"> ' . $user->city . ' </td>'; } $tasks_list = \App\Task::orderBy('created_at', 'desc')->take(5)->get(); $rowsTask = ""; foreach ($tasks_list as $task) { $rowsTask .= '<tr class="gradeC taskRow" id="' . $task->id . '"> <td class="taskName"> ' . $task->name . ' </td> <td class="center userFirstName"> ' . $task->point . ' </td> <td class="center userStreet"> ' . $task->timer . ' </td></tr>'; } return View::make($this->_view, ['taskCount' => $tasks, 'userCount' => $users, 'usersScoreCount' => $count[0]->point, 'usersDoneCount' => $countDone, 'rowsUsers' => $rowsUsers, 'rowsTask' => $rowsTask, 'classMain' => 'active', 'classUsers' => '', 'classTasks' => '']); }
public function index() { $users = Users::orderBy('created_at', 'asc')->paginate(20); return view('page.userslist', compact('users')); }