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 searchbuttonAction()
{
$value = $_GET["value"];
$column = $_GET["column"];
$order = $_GET["order"];
$dba = Zend_Registry::get('dba');
$this->_helper->layout->disableLayout(true);
$this->_helper->viewRenderer->setNoRender(true);
$musique_table = new Application_Model_Musique($dba);
$select = $musique_table->select()->where("TITRE_M LIKE ?", '%' . $value . '%')->orWhere("ARTISTE LIKE ?", '%' . $value . '%')->orWhere("ALBUM LIKE ?", '%' . $value . '%')->orWhere("GENRE_M LIKE ?", '%' . $value . '%')->orWhere("ANNEE LIKE ?", '%' . $value . '%')->order("{$column} {$order}")->limit($this->item_per_page);
$select2 = $musique_table->select()->where("TITRE_M LIKE ?", '%' . $value . '%')->orWhere("ARTISTE LIKE ?", '%' . $value . '%')->orWhere("ALBUM LIKE ?", '%' . $value . '%')->orWhere("GENRE_M LIKE ?", '%' . $value . '%')->orWhere("ANNEE LIKE ?", '%' . $value . '%');
$musiques = $musique_table->fetchAll($select)->toArray();
$indexes = ceil(count($musique_table->fetchAll($select2)->toArray()) / $this->item_per_page);
$musiques_result = array();
date_default_timezone_set("Europe/Paris");
foreach ($musiques 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;
}
