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