/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$active = 'users';
$users = Users::all();
if ($users = Users::find($id)) {
return view('users.show', compact('users', 'active'));
} else {
Request::session()->flash('Error', 'this user not found Please ty again');
return view('users.index', compact('users', 'active'));
}
}
public function save(SettingsRequest $requests)
{
$id = $requests->input('id');
$user = Users::findOrFail($id);
$user->name = $requests->input('name');
$user->firstname = $requests->input('firstname');
$user->email = $requests->input('email');
$user->phone = $requests->input('phone');
$user->gender = $requests->input('gender');
$user->bio = $requests->input('bio');
$user->country = $requests->input('country');
$user->city = $requests->input('city');
$user->state = $requests->input('state');
$user->street = $requests->input('street');
$user->zip = $requests->input('zip');
$user->user_level = $requests->input('user_level');
$user->save();
$users = Users::all();
return redirect('users')->with(compact('users'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$users = Users::all();
return view('users.index', compact('users'));
//return view('users.index');
}
public function index()
{
$users = Users::all();
return view('users.index')->with('users', $users);
}
public function create()
{
$this->_methodName = 'create';
$this->resolveParams();
if ($this->checkAuth() && !Auth::checkAdmin()) {
throw new \App\Exceptions\ExceptionApiMethodbad($this->_typeName, $this->_methodName, $this->_request_params);
}
$arNeed = ['name' => 'required', 'description' => 'required', 'score' => 'required|numeric', 'timer' => 'required', 'userAvailable' => 'required_without:userAll', 'userAll' => 'required_without:userAvailable|in:true,false'];
$this->checkAttr($arNeed);
$this->checkAuth();
$this->checkAuthAdmin();
$task = new \App\Task();
$task->name = $this->_request_params['name'];
$task->description = $this->_request_params['description'];
$task->point = $this->_request_params['score'];
$task->timer = $this->_request_params['timer'];
$task->save();
if (!isset($this->_request_params['userAvailable'])) {
$users = \App\Users::all();
} else {
$userArray = explode(';', $this->_request_params['userAvailable']);
$users = \App\Users::whereIn('id', $userArray)->get();
}
foreach ($users as $user) {
$task_user = new \App\UserTask();
$task_user->id_task = $task->id;
$task_user->id_user = $user->id;
$task_user->status = 'available';
$task_user->save();
$users_array[] = $user->email;
}
$MESSAGE = 'Added new task';
$url = 'https://api.parse.com/1/push';
$data = array('where' => ['email' => ['$in' => $users_array]], 'data' => array('alert' => $task->name, 'title' => $MESSAGE));
$_data = json_encode($data);
$headers = array('X-Parse-Application-Id: ' . $this->APPLICATION_ID, 'X-Parse-REST-API-Key: ' . $this->REST_API_KEY, 'Content-Type: application/json', 'Content-Length: ' . strlen($_data));
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_POSTFIELDS, $_data);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec($curl);
$this->_arData['data']['idTask'] = $task->id;
return $this;
}
public function show()
{
$tasks_list = \App\Task::orderBy('created_at', 'desc')->get();
$rowsTask = "";
foreach ($tasks_list as $task) {
$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;
}
$rowsTask .= '<tr class="gradeC taskRow" id="' . $task->id . '" data-id="' . $task->id . '">
<td class="taskName taskCell">
' . $task->name . '
</td>
<td class="taskCell">
' . $task->created_at . '
</td>
<td class="center taskCell">
' . $dataOut['usersDoneCount'] . '
</td>
<td class="center taskCell">
' . $dataOut['usersCancelCount'] . '
</td>
<td class="center taskTime taskCell">
' . $dataOut['usersTimeoutCount'] . '
</td>
<td class="center taskTime taskCell">
' . $dataOut['usersAvailableCount'] . '
</td>
<td class="deleteCheck">
<div class="checkbox">
<label>
<input type="checkbox" data-id="' . $task->id . '">
</label>
</div>
</td></tr>';
}
$users = \App\Users::all();
$rowsUsers = '<select multiple="multiple" id="select">';
foreach ($users as $user) {
$rowsUsers .= '<option value="' . $user->id . '">' . $user->first_name . ' ' . $user->last_name . '</option>';
}
$rowsUsers .= '</select>';
return View::make('view.task')->withTitle('TaskGame - Tasks')->withRows($rowsTask)->withUsers($rowsUsers)->withPaginate('');
}
