public function getplaylistAction()
{
$id = $_GET["id"];
$dba = Zend_Registry::get('dba');
// On récupère l'instance de la BDD
$this->_helper->layout->disableLayout(true);
// Permet de ne pas afficher le layout
$this->_helper->viewRenderer->setNoRender(true);
// Permet de ne pas redirigé vers une autre page
$playlists = new Application_Model_DansPlaylist($dba);
$where = $dba->quoteInto("ID_MUSIQUE = ?", $id);
$playlist_results = $playlists->fetchAll($where)->toArray();
$result = array();
foreach ($playlist_results as $playlist) {
$playlist_table = new Application_Model_Playlist($dba);
$playlist_row = $playlist_table->find($playlist["PLAY_ID"]);
$current_playlist = $playlist_row->current();
$genre_table = new Application_Model_Genre($dba);
$genre_row = $genre_table->find($current_playlist["ID_GENRE"]);
$genre = $genre_row->current();
$result[] = array("PLAY_ID" => $current_playlist["PLAY_ID"], "NOM_PLAYLIST" => $current_playlist["NOM_PLAY"], "NOM_GENRE" => $genre["NOM_G"]);
}
date_default_timezone_set("Europe/Paris");
$musique_table = new Application_Model_Musique($dba);
$musique = $musique_table->fetchRow($where)->toArray();
$date = strtotime($musique["DATE_AJOUT"]);
$membre_table = new Application_Model_Membre($dba);
$where_membre = $dba->quoteInto("ID_MEMBRE = ?", $musique["ID_MEMBRE"]);
$membre = $membre_table->fetchRow($where_membre)->toArray();
usort($result, array('PlaylistController', 'compare'));
$complete_result = array("ID_MUSIQUE" => $musique["ID_MUSIQUE"], "MEMBRE" => $membre["LOGIN"], "TITRE_M" => $musique["TITRE_M"], "GENRE_M" => $musique["GENRE_M"], "ALBUM" => $musique["ALBUM"], "DATE" => date("d/m/Y", $date), "PLAYLIST" => $result);
$json = json_encode($complete_result);
// On renvoie le tout sous format JSON
echo $json;
}
