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]);
}
