/**
* Display a listing of the resource.
*
* @return Response
*/
public function index($id)
{
//
$genre = Genres::where('id', $id)->get();
$songs = Files::where('genre_id', $id)->get();
return view('genre')->with('songs', $songs)->with('genre', $genre);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index($id)
{
//
//
$artist = Artists::where('id', $id)->get();
$songs = Files::where('created_by', $id)->get();
return view('artist')->with('songs', $songs)->with('artist', $artist);
}
public function searchForSongs($criteria)
{
//
$songs = Files::where(function ($query) use($criteria) {
$query->where('files.name', 'like', '%' . $criteria . '%');
})->select('files.*')->get();
return $songs;
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function buy($id)
{
//
$file = Files::where('id', $id)->get();
if (Auth::user()->money < $file[0]->price) {
return redirect()->back()->with('errors', 'You need more caaashhhh');
} else {
$user = User::find(Auth::user()->id);
$user->money = $user->money - $file[0]->price;
$user->save();
$buy = new Buys();
$buy->buyed_by = Auth::user()->id;
$buy->file_id = $id;
$buy->save();
return redirect()->back();
}
}
public function getAllTaskUser()
{
$this->_methodName = 'getAllTaskUser';
$this->resolveParams();
$this->checkAuth();
$user = Auth::user();
$tasks = \App\UserTask::where(['id_user' => $user->id])->get();
foreach ($tasks as $task) {
$taskInfo = \App\Task::find($task->id_task);
if (!is_null($taskInfo) && ($taskInfo->status == 'active' || $taskInfo->status == 'available')) {
$timer = explode(':', $taskInfo->timer);
if (count($timer) > 2) {
$data = $task->created_at;
$data->addHours($timer[0]);
$data->addMinutes($timer[1]);
if (!Carbon::now()->between($task->created_at, $data)) {
$task->status = 'timeout';
$task->save();
}
}
}
$infoUser = \App\InfoTask::where('id_taskUser', $task->id)->first();
if (is_null($infoUser)) {
$lat = "";
$lng = "";
$text = "";
} else {
$lat = $infoUser->lat;
$lng = $infoUser->lng;
$text = $infoUser->text;
}
$filesUser = "";
$files = \App\Files::where('id_taskUser', $task->id)->get();
if (!is_null($files)) {
foreach ($files as $file) {
$filesUser[] = $file->file;
}
}
$array = ['userTaskId' => (int) $task->id, 'taskId' => (int) $taskInfo->id, 'name' => $taskInfo->name, 'description' => $taskInfo->description, 'status' => $task->status, 'time' => $taskInfo->timer, 'score' => (int) $taskInfo->point, 'files' => $filesUser, 'lat' => $lat, 'lng' => $lng, 'text' => $text, 'date_change' => $task->updated_at->toDateTimeString()];
if ($task->status == 'active' || $task->status == 'available') {
$timer = explode(':', $taskInfo->timer);
$data = $task->created_at;
$data->addHours($timer[0]);
$data->addMinutes($timer[1]);
$time = Carbon::now()->diff($data)->h . ':' . Carbon::now()->diff($data)->i . ':' . Carbon::now()->diff($data)->s;
$array['timer'] = $time;
}
$this->_arData['data'][] = $array;
}
return $this;
}
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);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (!File::isDirectory('uploads/' . $id)) {
File::makeDirectory('uploads/' . $id);
File::makeDirectory('uploads/' . $id . '/thumb');
}
$file = Files::where('pages_id', $id)->get();
$page = Pages::findOrFail($id);
$parentCategory = Pages::where('id', '!=', $id)->lists('name', 'id')->prepend('-- brak --', 0);
$childs = Pages::where('pages_id', '=', $id)->orderBy('position', 'asc')->get();
return view('admin.pages.edit')->with(['page' => $page, 'childs' => $childs, 'urlPath' => 'pages', 'title' => 'Edycja', 'file' => $file, 'parentCategory' => $parentCategory]);
}
