public function indexAction()
{
$auth = Zend_Auth::getInstance();
$log = $auth->getIdentity()->NOM_M . " " . $auth->getIdentity()->PRENOM;
$this->view->log = $log;
$dba = Zend_Registry::get('dba');
$evenements = new Application_Model_Evenement($dba);
$evenements_results = $evenements->fetchAll();
$genre_table = new Application_Model_Genre($dba);
$genres = $genre_table->fetchAll()->toArray();
$genre_playlist = array();
foreach ($genres as $genre) {
$playlist_table = new Application_Model_Playlist($dba);
$where = $dba->quoteInto("ID_GENRE = ?", $genre["ID_GENRE"]);
$playlists_results = $playlist_table->fetchAll($where)->toArray();
$playlists = array();
foreach ($playlists_results as $playlist) {
$playlists[] = array("PLAY_ID" => $playlist["PLAY_ID"], "NOM_PLAY" => $playlist["NOM_PLAY"]);
}
if (count($playlists) > 0) {
$genre_playlist[] = array("ID_GENRE" => $genre["ID_GENRE"], "GENRE" => $genre["NOM_G"], "PLAYLISTS" => $playlists);
}
}
$result = array();
foreach ($evenements_results as $evenement) {
$joue_table = new Application_Model_Joue($dba);
$select = $joue_table->select()->where("EVENEMENT_ID = ?", $evenement->EVENEMENT_ID);
$joue_results = $joue_table->fetchAll($select)->toArray();
$color = "blue";
if ($evenement->ID_EMISSION != NULL) {
$color = "red";
}
if (count($joue_results) > 0) {
$color = "orange";
}
$item = array("EVENEMENT_ID" => $evenement->EVENEMENT_ID, "D_H_DEBUT" => $evenement->D_H_DEBUT, "D_H_FIN" => $evenement->D_H_FIN, "NOM_EV" => $evenement->NOM_EV, "COLOR" => $color);
$result[] = $item;
}
$emission_table = new Application_Model_Emission($dba);
$select = $emission_table->select()->where("PATH_E IS NOT NULL");
$this->view->podcast = $emission_table->fetchAll($select)->toArray();
$this->view->genre_playlist = $genre_playlist;
$this->view->evenements = $result;
}
function getfatherAction()
{
$id = $_GET["id"];
$dba = Zend_Registry::get('dba');
$this->_helper->layout->disableLayout(true);
$this->_helper->viewRenderer->setNoRender(true);
$genres_table = new Application_Model_Genre($dba);
$where = $dba->quoteInto("ID_GENRE = ?", $id);
$genre_tab = $genres_table->fetchAll()->toArray();
$genres = $genres_table->fetchAll($where)->toArray();
$res = array();
foreach ($genre_tab as $gt) {
if ($gt["ID_GENRE"] == $genres[0]["GEN_ID_GENRE"]) {
$res[] = $gt;
}
}
$json = json_encode($res);
// On renvoie le tout sous format JSON
echo $json;
}
public function ajouterAction()
{
$dba = Zend_Registry::get('dba');
$this->_helper->layout->disableLayout(true);
$this->_helper->viewRenderer->setNoRender(true);
$id_genre = $_POST["id_genre"];
$nom_play = $_POST["nom_play"];
$result = array();
if ($id_genre != null && $nom_play != null) {
$datas = array('NOM_PLAY' => $nom_play, 'ID_GENRE' => $id_genre);
$result["STATUS"] = "OK";
$result["NOM_PLAY"] = $nom_play;
$genre_table = new Application_Model_Genre($dba);
$genre_row = $genre_table->find($id_genre);
$genre = $genre_row->current();
$result["GENRE_NAME"] = $genre->NOM_G;
$dba->beginTransaction();
try {
$dba->insert('PLAYLIST', $datas);
$dba->commit();
} catch (Exception $e) {
$dba->rollBack();
echo $e->getMessage();
}
$playlist_table = new Application_Model_Playlist($dba);
$where = $dba->quoteInto("NOM_PLAY = ?", $nom_play);
$playlist = $playlist_table->fetchRow($where, "PLAY_ID DESC");
$result["PLAY_ID"] = $playlist->PLAY_ID;
} else {
$result["STATUS"] = "FAIL";
}
$json = json_encode($result);
echo $json;
}