public function getmusiqueAction()
{
$dba = Zend_Registry::get('dba');
$id = $_GET["id"];
$this->_helper->layout->disableLayout(true);
$this->_helper->viewRenderer->setNoRender(true);
$dans_table = new Application_Model_DansPlaylist($dba);
$musique_table = new Application_Model_Musique($dba);
$musique_list = $musique_table->fetchAll()->toArray();
$where = $dba->quoteInto("PLAY_ID = ?", $id);
$tmp = $dans_table->fetchAll($where)->toArray();
$res_tab = array();
foreach ($tmp as $pl) {
foreach ($musique_list as $m) {
if ($pl["ID_MUSIQUE"] == $m["ID_MUSIQUE"]) {
$res_tab[] = $m;
}
}
}
array_multisort($res_tab, SORT_STRING);
$json = json_encode($res_tab);
echo $json;
}
public function deletemusiqueAction()
{
$dba = Zend_Registry::get('dba');
$this->_helper->layout->disableLayout(true);
$this->_helper->viewRenderer->setNoRender(true);
$id = $_GET["id"];
$index = $_GET["index"];
$column = $_GET["column"];
$order = $_GET["order"];
$previous_search = $_GET["previous_search"];
$is_autocomplete = $_GET["is_autocomplete"];
$dans_playlist_table = new Application_Model_DansPlaylist($dba);
$where = $dba->quoteInto("ID_MUSIQUE = ?", $id);
$dans_playlist_table->delete($where);
$musique_table = new Application_Model_Musique($dba);
$musique_table->delete($where);
$musiques = new Application_Model_Musique($dba);
if ($previous_search == "") {
$select = $musiques->select()->order("{$column} {$order}")->limit($this->item_per_page, $this->item_per_page * ($index - 1));
$select2 = null;
} else {
if ($is_autocomplete == "true") {
$select = $musiques->select()->where("TITRE_M = ?", $previous_search)->orWhere("ARTISTE = ?", $previous_search)->orWhere("ALBUM = ?", $previous_search)->orWhere("GENRE_M = ?", $previous_search)->orWhere("ANNEE = ?", $previous_search)->order("{$column} {$order}")->limit($this->item_per_page, $this->item_per_page * ($index - 1));
$select2 = $musiques->select()->where("TITRE_M = ?", $previous_search)->orWhere("ARTISTE = ?", $previous_search)->orWhere("ALBUM = ?", $previous_search)->orWhere("GENRE_M = ?", $previous_search)->orWhere("ANNEE = ?", $previous_search);
} else {
$select = $musiques->select()->where("TITRE_M LIKE ?", '%' . $previous_search . '%')->orWhere("ARTISTE LIKE ?", '%' . $previous_search . '%')->orWhere("ALBUM LIKE ?", '%' . $previous_search . '%')->orWhere("GENRE_M LIKE ?", '%' . $previous_search . '%')->orWhere("ANNEE LIKE ?", '%' . $previous_search . '%')->order("{$column} {$order}")->limit($this->item_per_page, $this->item_per_page * ($index - 1));
$select2 = $musiques->select()->where("TITRE_M LIKE ?", '%' . $previous_search . '%')->orWhere("ARTISTE LIKE ?", '%' . $previous_search . '%')->orWhere("ALBUM LIKE ?", '%' . $previous_search . '%')->orWhere("GENRE_M LIKE ?", '%' . $previous_search . '%')->orWhere("ANNEE LIKE ?", '%' . $previous_search . '%');
}
}
$musiques_results = $musiques->fetchAll($select)->toArray();
$indexes = ceil(count($musiques->fetchAll($select2)->toArray()) / $this->item_per_page);
$musiques_result = array();
date_default_timezone_set("Europe/Paris");
foreach ($musiques_results as $musique) {
$date = strtotime($musique["DATE_AJOUT"]);
$musiques_result[] = array("TITRE_M" => $musique["TITRE_M"], "ARTISTE" => $musique["ARTISTE"], "ALBUM" => $musique["ALBUM"], "ID_MUSIQUE" => $musique["ID_MUSIQUE"], "DATE_AJOUT" => date("d/m/Y", $date));
}
$result = array("INDEXES" => $indexes, "MUSIQUES" => $musiques_result);
$json = json_encode($result);
echo $json;
}
