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; }