public function indexAction()
{
$auth = Zend_Auth::getInstance();
$log = $auth->getIdentity()->NOM_M . " " . $auth->getIdentity()->PRENOM;
$this->view->log = $log;
$dba = Zend_Registry::get('dba');
// On récupère l'instance de la BDD
$musiques = new Application_Model_Musique($dba);
$this->view->musiques = $musiques->fetchAll(null, "TITRE_M ASC", $this->item_per_page);
// On récupère l'ensemble des entrées dans la table MUSIQUE
$this->view->indexes = ceil(count($musiques->fetchAll()->toArray()) / $this->item_per_page);
$playlists_table = new Application_Model_Playlist($dba);
$playlists = $playlists_table->fetchAll()->toArray();
// On récupère l'ensemble des entrées dans la table PLAYLIST
$res = array();
foreach ($playlists as $playlist) {
$genre_table = new Application_Model_Genre($dba);
$genre_row = $genre_table->find($playlist["ID_GENRE"]);
$genre = $genre_row->current();
$zic_playlist = new Application_Model_DansPlaylist($dba);
$where = $dba->quoteInto("PLAY_ID = ?", $playlist["PLAY_ID"]);
$zic_playlist_results = $zic_playlist->fetchAll($where)->toArray();
$zic_list = array();
foreach ($zic_playlist_results as $zic) {
$musique_table = new Application_Model_Musique($dba);
$musique_row = $musique_table->find($zic["ID_MUSIQUE"]);
$current_musique = $musique_row->current();
$zic_list[] = $current_musique->toArray();
}
$res[] = array("ID_PLAYLIST" => $playlist["PLAY_ID"], "NOM_PLAYLIST" => $playlist["NOM_PLAY"], "NOM_GENRE" => $genre["NOM_G"], "MUSIQUES" => $zic_list);
}
$genre_table = new Application_Model_Genre($dba);
$genres = $genre_table->fetchAll()->toArray();
$this->view->genres = $genres;
usort($res, array('PlaylistController', 'compare'));
$this->view->playlist = $res;
}
