/**
  * 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);
 }
 public function searchForGenres($criteria)
 {
     //
     $genres = Genres::where(function ($query) use($criteria) {
         $query->where('genres.name', 'like', '%' . $criteria . '%');
     })->select('genres.*')->get();
     return $genres;
 }
Example #3
0
 /**
  * Check against existing genres in storage.
  *
  * @param  string $genre
  * @return Response
  */
 private function checkExistingGenres($genre)
 {
     $existing = Genres::where('type', $genre)->first();
     if (count($existing) == 0) {
         return false;
     } else {
         return $existing;
     }
 }
Example #4
0
 public function getGenres()
 {
     echo "Started " . date("H:i:s") . "...... <br/><br/>";
     $movie_count = Movies::all()->count();
     echo $movie_count . " movies<br/>";
     flush();
     ob_flush();
     for ($x = $this->counter; $x < 1000; $x += 10) {
         $movies = Movies::take(10)->offset($x)->get();
         foreach ($movies as $movie) {
             if ($movie->imdb_id) {
                 $client = new \GuzzleHttp\Client();
                 $my_token = env('IMDB_KEY');
                 $url = 'http://api.myapifilms.com/imdb/idIMDB?idIMDB=' . $movie->imdb_id . '&token=' . $my_token . '&format=json&language=en-us';
                 $imdb_response = $client->get($url);
                 $imdb_body = $imdb_response->getBody();
                 $imdb_api = json_decode($imdb_body);
                 if (count($imdb_api->data->movies)) {
                     $imdb = $imdb_api->data->movies[0];
                     echo $movie->name . " : ";
                     if ($imdb->genres) {
                         $data = [];
                         foreach ($imdb->genres as $genre) {
                             $genre_id = Genres::where('type', $genre)->value('genre_id');
                             if ($genre_id) {
                                 $data[] = $genre_id;
                             }
                         }
                         $movie->genres()->sync($data);
                         echo " genres added<br/>";
                     } else {
                         echo "no genres<br/>";
                     }
                     flush();
                     ob_flush();
                 }
             }
         }
     }
     echo "<br/><br/>Finished " . date("H:i:s");
 }