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