public function dashboard() { // METHODE ORM $nbacteurs = Actors::count(); $nbcommentaire = Commentaire::count(); $avgcommentaire = Commentaire::avg('note'); $countnotepresse = Movies::count('note_presse'); $avgnotepresse = Movies::avg('note_presse'); $moviescount = Movies::count('id'); $avgmovies = Movies::avg('duree'); $actor = new Actors(); //methode query builder $avgacteur = $actor->getAvgActors(); $notepresse2 = new Movies(); $countnotepresse2 = $notepresse2->getAvgNoteMovies(); $avgsession = Sessions::count('id'); $session = new Sessions(); $sessionavg = $session->getAvgSession2(); $lastuser = new User(); $last = $lastuser->getLastUsers(); // 15 prochaine (TROISIEME METHODE ) $nextsession = Sessions::where('date_session', "<", Carbon::now())->take(15)->get(); // premiere methode avec 2 jointures : $seance = new Sessions(); $resultseance = $seance->getNextSession(); $allcategories = Categories::all(); $alldirectors = Directors::count('id'); $distrib = new Movies(); $distributeur = $distrib->countDistributeur(); $villeacteur = new Actors(); $villebyacteur = $villeacteur->getVilleByActors(); // exit(dump($villebyacteur )); return view('Main/dashboard', ['nbacteurs' => $nbacteurs, 'nbcommentaire' => $nbcommentaire, 'avgacteur' => $avgacteur->age, 'avgcommentaire' => $avgcommentaire, 'avgnotepresse' => $avgnotepresse, 'countnotepresse' => $countnotepresse, 'moviescount' => $moviescount, 'avgmovies' => $avgmovies, 'countnotepresse2' => $countnotepresse2->note, 'avgsession' => $avgsession, 'sessionavg' => $sessionavg->date, 'last' => $last, 'nextsession' => $nextsession, 'allcategories' => $allcategories, 'alldirectors' => $alldirectors, 'distributeur' => $distributeur, 'villeacteur' => $villebyacteur]); }
/** * Displays index page * * @return \Illuminate\View\View */ public function indexAction() { $data = array(); $categories = Categories::all(); $data = array('page_title' => 'Categories', 'categories' => $categories->count() ? $categories : array(), 'stylesheets' => array('data_table'), 'javascripts' => array('data_table', 'category')); return view('cms.category.index', $data); }
/** * Page Read */ public function edit($id) { $categories = Categories::all(); $actors = Actors::all(); $directors = Directors::all(); $movie = Movies::find($id); return view('Movies/edit', ['movie' => $movie, 'categories' => $categories, 'actors' => $actors, 'directors' => $directors]); }
/** * Me retournera mes données de catégorie. */ public function categories() { $tab = []; $categories = Categories::all(); foreach ($categories as $categorie) { $tab[] = [$categorie->title, count($categorie->movies)]; } return $tab; }
public function index() { //creation d'un objet du model Categories // $model = new Categories(); // $categories = $model->getAllCategories(); $categories = Categories::all(); //transporteur //transport des données du Controller à la vue return view("Categories/index", ['categories' => $categories]); }
/** * Page de liste des catégories */ public function index() { // récupérer toutes mes catégories $categories = Categories::all(); return view('Categories/index', ['categories' => $categories]); }
/** * Page de liste des catégories. */ public function index() { $categories = Categories::all(); return view('Categories/index', ['categories' => $categories]); }