|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace App\Http\Models; |
|
4
|
|
|
|
|
5
|
|
|
use Illuminate\Database\Eloquent\Model; |
|
6
|
|
|
use Illuminate\Support\Facades\DB; |
|
7
|
|
|
|
|
8
|
|
|
|
|
9
|
|
|
/** |
|
10
|
|
|
* Classe qui va stocker mes requetes autoirs |
|
11
|
|
|
* de ma table movies |
|
12
|
|
|
* Hérite de ma super classe Model |
|
13
|
|
|
*/ |
|
14
|
|
View Code Duplication |
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
|
|
|
|
|
102
|
|
|
|
Symfomany /
laravelcinema
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.