/** * Run the database seeds. * * @return void */ public function run() { try { //DELETE TABLES DB::table('osu_genres')->delete(); DB::table('osu_languages')->delete(); //COUNTS if (!DB::table('osu_counts')->where('name', 'pp_rank_column')->get()) { DB::table('osu_counts')->insert([['name' => 'pp_rank_column', 'count' => 90], ['name' => 'usercount', 'count' => 500000]]); } //END COUNTS //GENRES DB::table('osu_genres')->insert([['genre_id' => 99, 'name' => 'Any'], ['genre_id' => 1, 'name' => 'Unspecified'], ['genre_id' => 2, 'name' => 'Video Game'], ['genre_id' => 3, 'name' => 'Anime'], ['genre_id' => 4, 'name' => 'Rock'], ['genre_id' => 5, 'name' => 'Pop'], ['genre_id' => 6, 'name' => 'Other'], ['genre_id' => 7, 'name' => 'Novelty'], ['genre_id' => 9, 'name' => 'Hip Hop'], ['genre_id' => 10, 'name' => 'Electronic']]); $any_genre = \App\Models\Genre::find(99); $any_genre->genre_id = 0; $any_genre->save(); // END GENRES //LANGUAGES DB::table('osu_languages')->insert([['language_id' => 99, 'name' => 'Any', 'display_order' => 0], ['language_id' => 1, 'name' => 'Other', 'display_order' => 11], ['language_id' => 2, 'name' => 'English', 'display_order' => 1], ['language_id' => 3, 'name' => 'Japanese', 'display_order' => 6], ['language_id' => 4, 'name' => 'Chinese', 'display_order' => 2], ['language_id' => 5, 'name' => 'Instrumental', 'display_order' => 10], ['language_id' => 6, 'name' => 'Korean', 'display_order' => 7], ['language_id' => 7, 'name' => 'French', 'display_order' => 3], ['language_id' => 8, 'name' => 'German', 'display_order' => 4], ['language_id' => 9, 'name' => 'Swedish', 'display_order' => 9], ['language_id' => 10, 'name' => 'Spanish', 'display_order' => 8], ['language_id' => 11, 'name' => 'Italian', 'display_order' => 5]]); $any_language = \App\Models\Language::find(99); $any_language->language_id = 0; $any_language->save(); //END LANGUAGES } catch (\Illuminate\Database\QueryException $e) { echo $e->getMessage() . "\r\n"; } catch (Exception $ex) { echo $ex->getMessage() . "\r\n"; } }
public function genreId($id) { $genre = Genre::find($id); if (!$genre) { return Response::json(['error' => 'Genre not found'], 404); } return ['genre' => $genre]; }
public function show($id) { $genres = Genre::find($id); if (!$genres) { return Response::json(['error' => 'Genre not found'], 404); } return ['genres' => $genres]; }
public function getGenre($genreID) { $genre = Genre::find($genreID); if (!$genre) { return response()->json(['error' => 'Genre not found'], 404); } else { return json_encode(array('genre' => $genre)); } }
public function actionUpdate($id) { $model = $this->findModel($id); $genres = Genre::find()->all(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', ['model' => $model, 'genres' => $genres]); } }
public function findUniqueGenres($dvds) { $added = []; $genres = []; foreach ($dvds as $dvd) { if (!array_key_exists($dvd->genre_id, $added)) { $added[$dvd->genre_id] = true; $genres[] = Genre::find($dvd->genre_id); } } return $genres; }
public function genres($id) { $genre = Genre::find($id); $dvds = Dvd::with('genre', 'rating', 'label')->where('genre_id', '=', "{$id}")->get(); return view('genre', ['dvds' => $dvds, 'genre' => $genre]); }
public function show($id) { $genre = Genre::find($id); $dvds = Dvd::with('rating', 'genre', 'label')->where('genre_id', '=', $id)->get(); return view('genre', ['genre' => $genre, 'dvds' => $dvds]); }
/** * Lists all Genre models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Genre::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function genreResults($genreId) { $genre = Genre::find($genreId); $dvds = $genre->dvds; return view('genres', ["dvds" => $dvds, "genre" => $genre]); }
public function getChangepresentstatus($projectid, $projectstatus) { $category = Genre::find($projectid); $category->active = $projectstatus; $category->save(); }
public function display_dvds_by_genre($genre_id) { $dvds = Dvd::with('genre', 'rating', 'label')->where('genre_id', '=', $genre_id)->get(); $genre = Genre::find($genre_id); return view("dvds_by_genre", ['dvds' => $dvds, 'genre' => $genre]); }