Symfomany /
laravelcinema
| @@ 14-107 (lines=94) @@ | ||
| 11 | * de ma table movies |
|
| 12 | * Hérite de ma super classe Model |
|
| 13 | */ |
|
| 14 | class Movies extends Model{ |
|
| 15 | ||
| 16 | ||
| 17 | ||
| 18 | //protected $fillable = ['title', 'description', 'categories_id']; |
|
| 19 | ||
| 20 | ||
| 21 | /** |
|
| 22 | * Décrit le nom de la table |
|
| 23 | * que classe fait référence |
|
| 24 | */ |
|
| 25 | protected $table = 'movies'; |
|
| 26 | ||
| 27 | ||
| 28 | ||
| 29 | /** |
|
| 30 | * Retourne tous les films |
|
| 31 | */ |
|
| 32 | public function getAllMovies(){ |
|
| 33 | ||
| 34 | // retourne le resultat de ma requete SELECT * FROM movies |
|
| 35 | return DB::table('movies')->get(); |
|
| 36 | ||
| 37 | } |
|
| 38 | ||
| 39 | ||
| 40 | /** |
|
| 41 | * Return moyenne des notes de presse |
|
| 42 | */ |
|
| 43 | public function getAvgNotePresse(){ |
|
| 44 | $result = DB::table('movies') |
|
| 45 | ->select(DB::raw("ROUND(AVG(note_presse)) as avgpress")) |
|
| 46 | ->first(); |
|
| 47 | ||
| 48 | return $result; |
|
| 49 | ||
| 50 | } |
|
| 51 | ||
| 52 | /***************************************************** Relationships ***********************************************************/ |
|
| 53 | ||
| 54 | ||
| 55 | /** |
|
| 56 | * Retourne la catégorie à laquelle appartient un objet film |
|
| 57 | * Many To One : n..1 |
|
| 58 | * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
|
| 59 | */ |
|
| 60 | public function categories() |
|
| 61 | { |
|
| 62 | return $this->belongsTo('App\Http\Models\Categories'); |
|
| 63 | } |
|
| 64 | ||
| 65 | /** |
|
| 66 | * belongsToMany(): Many To Many |
|
| 67 | */ |
|
| 68 | public function user() |
|
| 69 | { |
|
| 70 | return $this->belongsToMany('App\Http\Models\User', 'user_favoris', 'movies_id', 'user_id'); |
|
| 71 | } |
|
| 72 | ||
| 73 | /** |
|
| 74 | * belongsToMany(): Many To Many |
|
| 75 | * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany |
|
| 76 | */ |
|
| 77 | public function actors() |
|
| 78 | { |
|
| 79 | return $this->belongsToMany('App\Http\Models\Actors'); |
|
| 80 | } |
|
| 81 | ||
| 82 | public function directors() |
|
| 83 | { |
|
| 84 | return $this->belongsToMany('App\Http\Models\Directors'); |
|
| 85 | } |
|
| 86 | ||
| 87 | public function comments() |
|
| 88 | { |
|
| 89 | return $this->hasMany('App\Http\Models\Comments'); |
|
| 90 | } |
|
| 91 | ||
| 92 | public function sessions() |
|
| 93 | { |
|
| 94 | return $this->hasMany('App\Http\Models\Sessions'); |
|
| 95 | } |
|
| 96 | ||
| 97 | public function recommandations() |
|
| 98 | { |
|
| 99 | return $this->hasMany('App\Http\Models\Recommandations'); |
|
| 100 | } |
|
| 101 | ||
| 102 | ||
| 103 | ||
| 104 | ||
| 105 | ||
| 106 | ||
| 107 | } |
|
| 108 | ||
| 109 | ||
| 110 | ||
| @@ 14-95 (lines=82) @@ | ||
| 11 | * de ma table movies |
|
| 12 | * Hérite de ma super classe Model |
|
| 13 | */ |
|
| 14 | class User extends Model{ |
|
| 15 | ||
| 16 | ||
| 17 | /** |
|
| 18 | * Décrit le nom de la table |
|
| 19 | * que classe fait référence |
|
| 20 | */ |
|
| 21 | protected $table = 'user'; |
|
| 22 | ||
| 23 | /** |
|
| 24 | * Retourne les 24 derniers utilisateurs |
|
| 25 | */ |
|
| 26 | public function getLastUsers(){ |
|
| 27 | ||
| 28 | // retourne le resultat de ma requete SELECT * FROM movies |
|
| 29 | $result = DB::table('user') |
|
| 30 | ->orderBy('created_at', 'DESC') |
|
| 31 | ->take(24) |
|
| 32 | ->get(); // traduire en SQL |
|
| 33 | ||
| 34 | return $result; |
|
| 35 | } |
|
| 36 | ||
| 37 | ||
| 38 | /** |
|
| 39 | * Retourne tous les films |
|
| 40 | */ |
|
| 41 | public function getAllMovies(){ |
|
| 42 | ||
| 43 | // retourne le resultat de ma requete SELECT * FROM movies |
|
| 44 | return DB::table('user')->get(); |
|
| 45 | } |
|
| 46 | ||
| 47 | ||
| 48 | ||
| 49 | ||
| 50 | ||
| 51 | ||
| 52 | ||
| 53 | ||
| 54 | ||
| 55 | /** |
|
| 56 | * Retourne la catégorie à laquelle appartient un objet film |
|
| 57 | * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
|
| 58 | */ |
|
| 59 | public function categories() |
|
| 60 | { |
|
| 61 | return $this->belongsTo('App\Http\Models\Categories'); |
|
| 62 | } |
|
| 63 | ||
| 64 | ||
| 65 | public function comments() |
|
| 66 | { |
|
| 67 | return $this->hasMany('App\Http\Models\Comments'); |
|
| 68 | } |
|
| 69 | ||
| 70 | public function actors() |
|
| 71 | { |
|
| 72 | return $this->belongsToMany('App\Http\Models\Actors'); |
|
| 73 | } |
|
| 74 | ||
| 75 | public function directors() |
|
| 76 | { |
|
| 77 | return $this->belongsToMany('App\Http\Models\Directors'); |
|
| 78 | } |
|
| 79 | ||
| 80 | public function sessions() |
|
| 81 | { |
|
| 82 | return $this->hasMany('App\Http\Models\Sessions'); |
|
| 83 | } |
|
| 84 | ||
| 85 | public function recommandations() |
|
| 86 | { |
|
| 87 | return $this->hasMany('App\Http\Models\Recommandations'); |
|
| 88 | } |
|
| 89 | ||
| 90 | ||
| 91 | ||
| 92 | ||
| 93 | ||
| 94 | ||
| 95 | } |
|
| 96 | ||
| 97 | ||
| 98 | ||
