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