@@ -4,7 +4,6 @@ |
||
| 4 | 4 | |
| 5 | 5 | use App\Http\Models\Administrators; |
| 6 | 6 | use App\Http\Requests\AdministratorsRequest; |
| 7 | -use Illuminate\Http\Request; |
|
| 8 | 7 | use Illuminate\Support\Facades\Auth; |
| 9 | 8 | use Illuminate\Support\Facades\Redirect; |
| 10 | 9 | use Illuminate\Support\Facades\Session; |
@@ -90,7 +90,7 @@ |
||
| 90 | 90 | |
| 91 | 91 | $administrator->save(); |
| 92 | 92 | |
| 93 | - // Auth::login($administrator); => Autologin |
|
| 93 | + // Auth::login($administrator); => Autologin |
|
| 94 | 94 | Session::flash('success', "L'administrateur {$administrator->email} a bien été crée"); |
| 95 | 95 | return Redirect::route('administrators_index'); |
| 96 | 96 | |
@@ -12,15 +12,15 @@ discard block |
||
| 12 | 12 | /** |
| 13 | 13 | * Class AdministratorsController |
| 14 | 14 | */ |
| 15 | -class AdministratorsController extends Controller{ |
|
| 15 | +class AdministratorsController extends Controller { |
|
| 16 | 16 | |
| 17 | 17 | /** |
| 18 | 18 | * Page de liste des administrateurs |
| 19 | 19 | */ |
| 20 | - public function index(){ |
|
| 20 | + public function index() { |
|
| 21 | 21 | $administrators = Administrators::all(); |
| 22 | 22 | |
| 23 | - return view('Administrators/index',[ |
|
| 23 | + return view('Administrators/index', [ |
|
| 24 | 24 | 'administrators' => $administrators |
| 25 | 25 | ]); |
| 26 | 26 | } |
@@ -31,12 +31,12 @@ discard block |
||
| 31 | 31 | * @param $id |
| 32 | 32 | * @return mixed |
| 33 | 33 | */ |
| 34 | - public function remove($id){ |
|
| 34 | + public function remove($id) { |
|
| 35 | 35 | |
| 36 | 36 | // To load an administrator |
| 37 | 37 | $administrator = Administrators::find($id); |
| 38 | 38 | |
| 39 | - if($administrator){ |
|
| 39 | + if ($administrator) { |
|
| 40 | 40 | Session::flash('success', "L'administrateur {$administrator->email} a bien été supprimé"); |
| 41 | 41 | $administrator->delete(); |
| 42 | 42 | } |
@@ -51,7 +51,7 @@ discard block |
||
| 51 | 51 | * @param $id |
| 52 | 52 | * @return mixed |
| 53 | 53 | */ |
| 54 | - public function create(){ |
|
| 54 | + public function create() { |
|
| 55 | 55 | |
| 56 | 56 | return view('Administrators/create'); |
| 57 | 57 | } |
@@ -59,12 +59,12 @@ discard block |
||
| 59 | 59 | * To store an administrators |
| 60 | 60 | * ARgument $id est facultatif: null est sa valeur par défaut |
| 61 | 61 | */ |
| 62 | - public function store(AdministratorsRequest $request, $id = null){ |
|
| 62 | + public function store(AdministratorsRequest $request, $id = null) { |
|
| 63 | 63 | |
| 64 | 64 | // creation: créer un nouvel administrateur |
| 65 | - if($id == null){ |
|
| 65 | + if ($id == null) { |
|
| 66 | 66 | $administrator = new Administrators(); |
| 67 | - }else{ |
|
| 67 | + } else { |
|
| 68 | 68 | // edition: récupérer un administrateur |
| 69 | 69 | $administrator = Administrators::find($id); |
| 70 | 70 | } |
@@ -76,22 +76,22 @@ discard block |
||
| 76 | 76 | |
| 77 | 77 | // si l'utilisateur modifie |
| 78 | 78 | // son mot de passe en mode edition |
| 79 | - if(!empty($request->password)){ |
|
| 79 | + if (!empty($request->password)) { |
|
| 80 | 80 | $administrator->password = bcrypt($request->password); //if en mode edit |
| 81 | 81 | } |
| 82 | 82 | |
| 83 | - $administrator->super_admin = $request->super_admin; |
|
| 83 | + $administrator->super_admin = $request->super_admin; |
|
| 84 | 84 | $administrator->expiration_date = new \DateTime('+1 year'); |
| 85 | 85 | $administrator->active = true; |
| 86 | 86 | |
| 87 | 87 | //upload |
| 88 | 88 | $filename = ""; |
| 89 | - if($request->hasFile('image')) { |
|
| 89 | + if ($request->hasFile('image')) { |
|
| 90 | 90 | $file = $request->file('image'); |
| 91 | 91 | $filename = $file->getClientOriginalName(); // Récupère le nom original du fichier |
| 92 | - $destinationPath = public_path() . '/uploads/administrators'; // Indique où stocker le fichier |
|
| 92 | + $destinationPath = public_path().'/uploads/administrators'; // Indique où stocker le fichier |
|
| 93 | 93 | $file->move($destinationPath, $filename); // Déplace le fichier |
| 94 | - $administrator->photo = asset("uploads/administrators/". $filename); |
|
| 94 | + $administrator->photo = asset("uploads/administrators/".$filename); |
|
| 95 | 95 | } |
| 96 | 96 | |
| 97 | 97 | $administrator->save(); |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | * @param $id |
| 111 | 111 | * @return mixed |
| 112 | 112 | */ |
| 113 | - public function edit($id){ |
|
| 113 | + public function edit($id) { |
|
| 114 | 114 | |
| 115 | 115 | $administrator = Administrators::find($id); |
| 116 | 116 | |
@@ -35,7 +35,7 @@ |
||
| 35 | 35 | 'password' => 'required|confirmed|min:6', |
| 36 | 36 | 'image' => 'required|image', |
| 37 | 37 | ]; |
| 38 | - }else{ |
|
| 38 | + } else{ |
|
| 39 | 39 | return [ |
| 40 | 40 | 'firstname' => 'required|max:255', |
| 41 | 41 | 'lastname' => 'required|max:255', |
@@ -148,7 +148,6 @@ |
||
| 148 | 148 | |
| 149 | 149 | /** |
| 150 | 150 | * Fonction de like des films, enregistré en session |
| 151 | - * @param Request $request |
|
| 152 | 151 | */ |
| 153 | 152 | public function like($id, $action) |
| 154 | 153 | { |
@@ -92,8 +92,7 @@ discard block |
||
| 92 | 92 | $movie->visible = 1; |
| 93 | 93 | Session::flash("success","Le film {$movie->title} a bien été activé"); |
| 94 | 94 | |
| 95 | - } |
|
| 96 | - else{ |
|
| 95 | + } else{ |
|
| 97 | 96 | $movie->visible = 0; |
| 98 | 97 | Session::flash("success","Le film {$movie->title} a bien été desactivé"); |
| 99 | 98 | } |
@@ -117,8 +116,7 @@ discard block |
||
| 117 | 116 | $movie->cover = 1; |
| 118 | 117 | Session::flash("success","Le film {$movie->title} a bien été mis en avant"); |
| 119 | 118 | |
| 120 | - } |
|
| 121 | - else{ |
|
| 119 | + } else{ |
|
| 122 | 120 | $movie->cover = 0; |
| 123 | 121 | Session::flash("danger","Le film {$movie->title} a bien été retiré de l'avant"); |
| 124 | 122 | } |
@@ -160,7 +158,7 @@ discard block |
||
| 160 | 158 | |
| 161 | 159 | $likes[$id] = $movie->id; |
| 162 | 160 | |
| 163 | - }else{ |
|
| 161 | + } else{ |
|
| 164 | 162 | unset($likes[$id]); |
| 165 | 163 | } |
| 166 | 164 | Session::put("likes", $likes); |
@@ -20,17 +20,17 @@ discard block |
||
| 20 | 20 | * Sufficé par le mot clef Controller |
| 21 | 21 | * et doit hérité de la super classe Controller |
| 22 | 22 | */ |
| 23 | -class MoviesController extends Controller{ |
|
| 23 | +class MoviesController extends Controller { |
|
| 24 | 24 | |
| 25 | 25 | |
| 26 | 26 | /** |
| 27 | 27 | * Page Acceuil |
| 28 | 28 | */ |
| 29 | - public function index(){ |
|
| 29 | + public function index() { |
|
| 30 | 30 | |
| 31 | 31 | $movies = Movies::all(); |
| 32 | 32 | |
| 33 | - return view('Movies/index',[ |
|
| 33 | + return view('Movies/index', [ |
|
| 34 | 34 | 'movies' => $movies |
| 35 | 35 | ] |
| 36 | 36 | ); |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | /** |
| 40 | 40 | * Page Create |
| 41 | 41 | */ |
| 42 | - public function create(){ |
|
| 42 | + public function create() { |
|
| 43 | 43 | |
| 44 | 44 | $categories = Categories::all(); |
| 45 | 45 | $actors = Actors::all(); |
@@ -58,14 +58,14 @@ discard block |
||
| 58 | 58 | /** |
| 59 | 59 | * Page Read |
| 60 | 60 | */ |
| 61 | - public function read($id){ |
|
| 61 | + public function read($id) { |
|
| 62 | 62 | |
| 63 | 63 | return view('Movies/read'); |
| 64 | 64 | } |
| 65 | 65 | /** |
| 66 | 66 | * Page Read |
| 67 | 67 | */ |
| 68 | - public function edit($id){ |
|
| 68 | + public function edit($id) { |
|
| 69 | 69 | |
| 70 | 70 | $categories = Categories::all(); |
| 71 | 71 | $actors = Actors::all(); |
@@ -85,17 +85,17 @@ discard block |
||
| 85 | 85 | * Action qui va me permettre d'activer un film |
| 86 | 86 | * @param $id |
| 87 | 87 | */ |
| 88 | - public function activate($id){ |
|
| 88 | + public function activate($id) { |
|
| 89 | 89 | $movie = Movies::find($id); |
| 90 | 90 | |
| 91 | - if($movie->visible == 0){ |
|
| 91 | + if ($movie->visible == 0) { |
|
| 92 | 92 | $movie->visible = 1; |
| 93 | - Session::flash("success","Le film {$movie->title} a bien été activé"); |
|
| 93 | + Session::flash("success", "Le film {$movie->title} a bien été activé"); |
|
| 94 | 94 | |
| 95 | 95 | } |
| 96 | - else{ |
|
| 96 | + else { |
|
| 97 | 97 | $movie->visible = 0; |
| 98 | - Session::flash("success","Le film {$movie->title} a bien été desactivé"); |
|
| 98 | + Session::flash("success", "Le film {$movie->title} a bien été desactivé"); |
|
| 99 | 99 | } |
| 100 | 100 | |
| 101 | 101 | $movie->save(); |
@@ -108,19 +108,19 @@ discard block |
||
| 108 | 108 | * Action qui va me permettre de metter en avant un film |
| 109 | 109 | * @param $id |
| 110 | 110 | */ |
| 111 | - public function cover($id){ |
|
| 111 | + public function cover($id) { |
|
| 112 | 112 | // find() permet de retourner un Objet Movie |
| 113 | 113 | // depuis son id |
| 114 | 114 | $movie = Movies::find($id); |
| 115 | 115 | |
| 116 | - if($movie->cover == 0){ |
|
| 116 | + if ($movie->cover == 0) { |
|
| 117 | 117 | $movie->cover = 1; |
| 118 | - Session::flash("success","Le film {$movie->title} a bien été mis en avant"); |
|
| 118 | + Session::flash("success", "Le film {$movie->title} a bien été mis en avant"); |
|
| 119 | 119 | |
| 120 | 120 | } |
| 121 | - else{ |
|
| 121 | + else { |
|
| 122 | 122 | $movie->cover = 0; |
| 123 | - Session::flash("danger","Le film {$movie->title} a bien été retiré de l'avant"); |
|
| 123 | + Session::flash("danger", "Le film {$movie->title} a bien été retiré de l'avant"); |
|
| 124 | 124 | } |
| 125 | 125 | |
| 126 | 126 | $movie->save(); |
@@ -133,11 +133,11 @@ discard block |
||
| 133 | 133 | /** |
| 134 | 134 | * Suppresion |
| 135 | 135 | */ |
| 136 | - public function delete($id){ |
|
| 136 | + public function delete($id) { |
|
| 137 | 137 | |
| 138 | 138 | $movie = Movies::find($id); |
| 139 | 139 | |
| 140 | - if($movie){ |
|
| 140 | + if ($movie) { |
|
| 141 | 141 | Session::flash('success', "Le film {$movie->title} a bien été supprimé"); |
| 142 | 142 | $movie->delete(); |
| 143 | 143 | } |
@@ -160,20 +160,20 @@ discard block |
||
| 160 | 160 | // je recupère ma variable likes en session |
| 161 | 161 | // et je fixe un tableau par défaut |
| 162 | 162 | // si j'ai rien en sessions likes |
| 163 | - $likes = session("likes", []); |
|
| 163 | + $likes = session("likes", [ ]); |
|
| 164 | 164 | |
| 165 | 165 | // si l'action est "like" |
| 166 | 166 | if ($action == "like") { |
| 167 | 167 | |
| 168 | 168 | // J'ajoute mon movie dans le tableaux des likes en session |
| 169 | - $likes[$id] = $movie->id; |
|
| 169 | + $likes[ $id ] = $movie->id; |
|
| 170 | 170 | Session::flash('danger', "Le film {$movie->title} a bien été liké"); |
| 171 | 171 | |
| 172 | - }else{ |
|
| 172 | + } else { |
|
| 173 | 173 | |
| 174 | 174 | // je supprime le like dans le tableaux des likes |
| 175 | 175 | // unset() supprimer un element dans un tableau en PHP |
| 176 | - unset($likes[$id]); |
|
| 176 | + unset($likes[ $id ]); |
|
| 177 | 177 | |
| 178 | 178 | Session::flash('success', "Le film {$movie->title} a bien été disliké"); |
| 179 | 179 | } |
@@ -192,9 +192,9 @@ discard block |
||
| 192 | 192 | /** |
| 193 | 193 | * Store database |
| 194 | 194 | */ |
| 195 | - public function store(MoviesRequest $request){ |
|
| 195 | + public function store(MoviesRequest $request) { |
|
| 196 | 196 | |
| 197 | - $dateoutput = \DateTime::createFromFormat('d/m/Y',$request->date_release); |
|
| 197 | + $dateoutput = \DateTime::createFromFormat('d/m/Y', $request->date_release); |
|
| 198 | 198 | $movie = new Movies(); |
| 199 | 199 | $movie->type = $request->type; |
| 200 | 200 | $movie->title = $request->title; |
@@ -211,14 +211,14 @@ discard block |
||
| 211 | 211 | |
| 212 | 212 | $filename = ""; |
| 213 | 213 | |
| 214 | - if($request->hasFile('image')) { |
|
| 214 | + if ($request->hasFile('image')) { |
|
| 215 | 215 | $file = $request->file('image'); |
| 216 | 216 | $filename = $file->getClientOriginalName(); // Récupère le nom original du fichier |
| 217 | - $destinationPath = public_path() . '/uploads/movies'; // Indique où stocker le fichier |
|
| 217 | + $destinationPath = public_path().'/uploads/movies'; // Indique où stocker le fichier |
|
| 218 | 218 | $file->move($destinationPath, $filename); // Déplace le fichier |
| 219 | 219 | } |
| 220 | 220 | |
| 221 | - $movie->image = asset("uploads/movies/". $filename); |
|
| 221 | + $movie->image = asset("uploads/movies/".$filename); |
|
| 222 | 222 | $movie->save(); |
| 223 | 223 | |
| 224 | 224 | $actors = $request->actors; |
@@ -226,7 +226,7 @@ discard block |
||
| 226 | 226 | foreach ($actors as $actor) { |
| 227 | 227 | DB::table('actors_movies') |
| 228 | 228 | ->insert([ |
| 229 | - ['movies_id' => $movie->id, 'actors_id' => $actor] |
|
| 229 | + [ 'movies_id' => $movie->id, 'actors_id' => $actor ] |
|
| 230 | 230 | ]); |
| 231 | 231 | } |
| 232 | 232 | } |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | foreach ($directors as $director) { |
| 237 | 237 | DB::table('directors_movies') |
| 238 | 238 | ->insert([ |
| 239 | - ['movies_id' => $movie->id, 'directors_id' => $director] |
|
| 239 | + [ 'movies_id' => $movie->id, 'directors_id' => $director ] |
|
| 240 | 240 | ]); |
| 241 | 241 | } |
| 242 | 242 | } |
@@ -2,11 +2,7 @@ |
||
| 2 | 2 | |
| 3 | 3 | namespace App\Http\Requests; |
| 4 | 4 | |
| 5 | -use App\Http\Models\Administrators; |
|
| 6 | 5 | use Illuminate\Foundation\Http\FormRequest; |
| 7 | -use Illuminate\Support\Facades\Auth; |
|
| 8 | - |
|
| 9 | -use Illuminate\Support\Facades\Request; |
|
| 10 | 6 | |
| 11 | 7 | /** |
| 12 | 8 | * Class AdministratorsRequest |
@@ -28,7 +28,7 @@ discard block |
||
| 28 | 28 | $id = $this->route('id'); |
| 29 | 29 | |
| 30 | 30 | // Création d'administrateur |
| 31 | - if($id == null) { |
|
| 31 | + if ($id == null) { |
|
| 32 | 32 | return [ |
| 33 | 33 | 'firstname' => 'required|max:255', |
| 34 | 34 | 'lastname' => 'required|max:255', |
@@ -39,12 +39,12 @@ discard block |
||
| 39 | 39 | ]; |
| 40 | 40 | } |
| 41 | 41 | // Edition administrateur |
| 42 | - else{ |
|
| 42 | + else { |
|
| 43 | 43 | return [ |
| 44 | 44 | 'firstname' => 'required|max:255', |
| 45 | 45 | 'lastname' => 'required|max:255', |
| 46 | 46 | 'description' => 'required|min:10', |
| 47 | - 'email' => 'required|email|max:255|unique:administrators,email,' . $id, |
|
| 47 | + 'email' => 'required|email|max:255|unique:administrators,email,'.$id, |
|
| 48 | 48 | 'password' => 'confirmed|min:6', |
| 49 | 49 | 'image' => 'image', |
| 50 | 50 | ]; |
@@ -20,9 +20,9 @@ discard block |
||
| 20 | 20 | */ |
| 21 | 21 | public function isSuperAdmin(Administrators $administrator) |
| 22 | 22 | { |
| 23 | - if($administrator->super_admin == true){ |
|
| 23 | + if ($administrator->super_admin == true) { |
|
| 24 | 24 | return true; |
| 25 | - }else{ |
|
| 25 | + } else { |
|
| 26 | 26 | return false; |
| 27 | 27 | } |
| 28 | 28 | } |
@@ -36,9 +36,9 @@ discard block |
||
| 36 | 36 | { |
| 37 | 37 | |
| 38 | 38 | // si j'ai expiration au niveau des date d'expiratio n |
| 39 | - if($administrator->expiration_date > date('Y-m-d')){ |
|
| 39 | + if ($administrator->expiration_date > date('Y-m-d')) { |
|
| 40 | 40 | return true; |
| 41 | - }else{ |
|
| 41 | + } else { |
|
| 42 | 42 | return false; |
| 43 | 43 | } |
| 44 | 44 | } |
@@ -22,7 +22,7 @@ discard block |
||
| 22 | 22 | { |
| 23 | 23 | if($administrator->super_admin == true){ |
| 24 | 24 | return true; |
| 25 | - }else{ |
|
| 25 | + } else{ |
|
| 26 | 26 | return false; |
| 27 | 27 | } |
| 28 | 28 | } |
@@ -38,7 +38,7 @@ discard block |
||
| 38 | 38 | // si j'ai expiration au niveau des date d'expiratio n |
| 39 | 39 | if($administrator->expiration_date > date('Y-m-d')){ |
| 40 | 40 | return true; |
| 41 | - }else{ |
|
| 41 | + } else{ |
|
| 42 | 42 | return false; |
| 43 | 43 | } |
| 44 | 44 | } |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | |
| 37 | 37 | //1ere methode: Utilisation de MYSQL |
| 38 | 38 | // marche mais n'est peu souple |
| 39 | - /* |
|
| 39 | + /* |
|
| 40 | 40 | * $results = DB::select(' |
| 41 | 41 | SELECT ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age |
| 42 | 42 | FROM actors |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | |
| 60 | 60 | // MAITRISE |
| 61 | 61 | |
| 62 | - $results = DB::table('actors') |
|
| 62 | + $results = DB::table('actors') |
|
| 63 | 63 | ->select(DB::raw('ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age')) |
| 64 | 64 | ->first(); |
| 65 | 65 | |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | * de ma table movies |
| 12 | 12 | * Hérite de ma super classe Model |
| 13 | 13 | */ |
| 14 | -class Actors extends Model{ |
|
| 14 | +class Actors extends Model { |
|
| 15 | 15 | |
| 16 | 16 | /** |
| 17 | 17 | * Décrit le nom de la table |
@@ -30,7 +30,7 @@ discard block |
||
| 30 | 30 | * Get nb actors by city |
| 31 | 31 | * @return mixed |
| 32 | 32 | */ |
| 33 | - public function getNbActorsByCity(){ |
|
| 33 | + public function getNbActorsByCity() { |
|
| 34 | 34 | |
| 35 | 35 | $result = DB::table('actors') |
| 36 | 36 | ->select(DB::raw("COUNT(id) as nb"), "city") |
@@ -48,7 +48,7 @@ discard block |
||
| 48 | 48 | * 1er mode de Laravel pour construire mes requetes |
| 49 | 49 | * Cela me permet de conserver une syntaxe pure en Mysql |
| 50 | 50 | */ |
| 51 | - public function getAvgActors(){ |
|
| 51 | + public function getAvgActors() { |
|
| 52 | 52 | |
| 53 | 53 | //1ere methode: Utilisation de MYSQL |
| 54 | 54 | // marche mais n'est peu souple |
@@ -11,7 +11,7 @@ |
||
| 11 | 11 | * de ma table movies |
| 12 | 12 | * Hérite de ma super classe Model |
| 13 | 13 | */ |
| 14 | -class Cinema extends Model{ |
|
| 14 | +class Cinema extends Model { |
|
| 15 | 15 | |
| 16 | 16 | /** |
| 17 | 17 | * Décrit le nom de la table |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | * de ma table movies |
| 12 | 12 | * Hérite de ma super classe Model |
| 13 | 13 | */ |
| 14 | -class Comments extends Model{ |
|
| 14 | +class Comments extends Model { |
|
| 15 | 15 | |
| 16 | 16 | /** |
| 17 | 17 | * Décrit le nom de la table |
@@ -23,7 +23,7 @@ discard block |
||
| 23 | 23 | /** |
| 24 | 24 | * Return the average of notes |
| 25 | 25 | */ |
| 26 | - public function getAvgNote(){ |
|
| 26 | + public function getAvgNote() { |
|
| 27 | 27 | $results = DB::table('comments') |
| 28 | 28 | ->select(DB::raw('ROUND(AVG(note)) as avgnote')) |
| 29 | 29 | ->first(); |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | * de ma table movies |
| 12 | 12 | * Hérite de ma super classe Model |
| 13 | 13 | */ |
| 14 | -class Sessions extends Model{ |
|
| 14 | +class Sessions extends Model { |
|
| 15 | 15 | |
| 16 | 16 | |
| 17 | 17 | /** |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | /** |
| 25 | 25 | * Retourne la moyenne des heure de sessions |
| 26 | 26 | */ |
| 27 | - public function getAvgHourDate(){ |
|
| 27 | + public function getAvgHourDate() { |
|
| 28 | 28 | $result = DB::table('sessions') |
| 29 | 29 | ->select(DB::raw('ROUND(AVG(HOUR(date_session))) as avghour')) |
| 30 | 30 | ->first(); |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | WHERE date_session > NOW( ) |
| 43 | 43 | LIMIT 0 , 15 |
| 44 | 44 | */ |
| 45 | - public function getNextSession(){ |
|
| 45 | + public function getNextSession() { |
|
| 46 | 46 | |
| 47 | 47 | /* 1ere methode |
| 48 | 48 | $result = DB::select("SELECT sessions.date_session AS DATE, movies.title AS mtitle, cinema.title AS ctitle |
@@ -55,10 +55,10 @@ discard block |
||
| 55 | 55 | |
| 56 | 56 | $result = DB::table('sessions') |
| 57 | 57 | ->select("sessions.date_session", "movies.title AS mtitle", "cinema.title AS mcinema") |
| 58 | - ->join("movies", "sessions.movies_id",'=', "movies.id") |
|
| 59 | - ->join("cinema", "sessions.cinema_id",'=', "cinema.id") |
|
| 58 | + ->join("movies", "sessions.movies_id", '=', "movies.id") |
|
| 59 | + ->join("cinema", "sessions.cinema_id", '=', "cinema.id") |
|
| 60 | 60 | |
| 61 | - ->where("date_session", ">", DB::raw("NOW()")) |
|
| 61 | + ->where("date_session", ">", DB::raw("NOW()")) |
|
| 62 | 62 | ->orderBy('date_session', "ASC") |
| 63 | 63 | ->take(15) |
| 64 | 64 | ->get(); |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | * de ma table movies |
| 12 | 12 | * Hérite de ma super classe Model |
| 13 | 13 | */ |
| 14 | -class User extends Model{ |
|
| 14 | +class User extends Model { |
|
| 15 | 15 | |
| 16 | 16 | |
| 17 | 17 | /** |
@@ -23,10 +23,10 @@ discard block |
||
| 23 | 23 | /** |
| 24 | 24 | * Retourne les 24 derniers utilisateurs |
| 25 | 25 | */ |
| 26 | - public function getLastUsers(){ |
|
| 26 | + public function getLastUsers() { |
|
| 27 | 27 | |
| 28 | 28 | // retourne le resultat de ma requete SELECT * FROM movies |
| 29 | - $result = DB::table('user') |
|
| 29 | + $result = DB::table('user') |
|
| 30 | 30 | ->orderBy('created_at', 'DESC') |
| 31 | 31 | ->take(24) |
| 32 | 32 | ->get(); |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | /** |
| 42 | 42 | * Retourne tous les films |
| 43 | 43 | */ |
| 44 | - public function getAllMovies(){ |
|
| 44 | + public function getAllMovies() { |
|
| 45 | 45 | |
| 46 | 46 | // retourne le resultat de ma requete SELECT * FROM movies |
| 47 | 47 | return DB::table('user')->get(); |