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