public function getByLogin($_login) { $resultSet = $this->dbTable->fetchAll(array('login = ?' => $_login)); $enreg = $resultSet->current(); if ($enreg === null) { return null; } $membre = new Application_Model_Membre(); $membre->fromArray($enreg); return $membre; }
public function getAllWithMembre() { $select = Zend_Db_Table::getDefaultAdapter()->select()->from('tweet')->join('membre', 'membre.id = membre_id', 'login')->order('horodatage DESC'); $resultSet = $select->query(); $tweets = array(); foreach ($resultSet as $enreg) { $tweet = new Application_Model_Tweet(); $tweet->fromArray($enreg); $membre = new Application_Model_Membre(); $membre->setLogin($enreg['login']); $tweet->setMembre($membre); $tweets[] = $tweet; } return $tweets; }
public function indexAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $this->_redirect("/accueil"); // echo "identity remove"; // $auth->clearIdentity(); } $this->view->menu = "index"; $form = new Zend_Form(); $form->setMethod('post'); $form->addElement('text', 'LOGIN', array('label' => 'Login : '******'required' => true, 'filters' => array('StringTrim'))); $form->addElement('password', 'PASSWORD', array('label' => 'Password : '******'required' => true, 'filters' => array('StringTrim'))); $submit = new Zend_Form_Element_Submit('submit'); $submit->setLabel('Se Connecter')->setAttrib('class', 'valid_button gros-bouton'); $form->addElement($submit); if ($this->_request->isPost()) { $formData = $this->_request->getPost(); if ($form->isValid($formData)) { MyAcl::setCache(Zend_Cache::factory("Core", "File")); $acl = MyAcl::getInstance(); Acl_Db_Table_Row::setAcl($acl); $dba = Zend_Registry::get('dba'); $TMembres = new Application_Model_Membre($dba); $membre = $TMembres->createRow(); $membre->LOGIN = $formData["LOGIN"]; // ceci pourrait provenir d'un formulaire $membre->PASSWORD = $formData["PASSWORD"]; // ceci pourrait provenir d'un formulaire $result = $membre->authenticate(); // si OK : persistance 30min en session if (!$result->isValid()) { echo 'login ou mot de passe incorrect'; } else { echo "ok"; $this->_redirect("/accueil"); } } else { $form->populate($formData); } } $this->view->form = $form; }
public function ajouterAction() { $form = new Application_Form_Membre(); if ($this->getRequest()->isPost()) { $data = $this->_request->getPost(); if ($form->isValid($data)) { $membre = new Application_Model_Membre(); $membre->fromArray($data); $mapper = new Application_Model_Mapper_Membre(); $mapper->add($membre); $session = new Zend_Session_Namespace('messages'); $session->nouveauMembre = "Félicitation {$data['login']}, vous êtes désormais inscrit !"; $this->_helper->redirector('index'); } else { $form->populate($data); $form->buildBootstrapErrorDecorators(); $this->view->msgErreur = "Veuillez vérifier votre formulaire !"; } } $this->view->form = $form; }
public function changeorderAction() { $index = $_GET["index"]; $column = $_GET["column"]; $order = $_GET["order"]; $previous_search = $_GET["previous_search"]; $dba = Zend_Registry::get('dba'); $this->_helper->layout->disableLayout(true); $this->_helper->viewRenderer->setNoRender(true); $membres = new Application_Model_Membre($dba); if ($previous_search == "") { $select = $membres->select()->where("ACTIVE_M = ?", 1)->order("{$column} {$order}")->limit($this->_item_per_page, $this->_item_per_page * ($index - 1)); $select2 = $membres->select()->where("ACTIVE_M = ?", 1); } else { $select = $membres->select()->where("ACTIVE_M = ?", 1)->where("PRENOM LIKE '%" . $previous_search . "%' OR NOM_M LIKE '%" . $previous_search . "%'" . " OR LOGIN LIKE '%" . $previous_search . "%' OR ROLE LIKE '%" . $previous_search . "%'" . " OR PROMO LIKE '%" . $previous_search . "%' OR MAIL LIKE '%" . $previous_search . "%'" . " OR ECOLE LIKE '%" . $previous_search . "%'")->order("{$column} {$order}")->limit($this->_item_per_page, $this->_item_per_page * ($index - 1)); $select2 = $membres->select()->where("ACTIVE_M = ?", 1)->where("PRENOM LIKE '%" . $previous_search . "%' OR NOM_M LIKE '%" . $previous_search . "%'" . " OR LOGIN LIKE '%" . $previous_search . "%' OR ROLE LIKE '%" . $previous_search . "%'" . " OR PROMO LIKE '%" . $previous_search . "%' OR MAIL LIKE '%" . $previous_search . "%'" . " OR ECOLE LIKE '%" . $previous_search . "%'"); } $membres_results = $membres->fetchAll($select)->toArray(); $indexes = ceil(count($membres->fetchAll($select2)->toArray()) / $this->_item_per_page); $membres_result = array(); for ($i = 0; $i < count($membres_results); $i++) { $membres_result[$i] = array("ID_MEMBRE" => $membres_results[$i]["ID_MEMBRE"], "NOM_M" => $membres_results[$i]["NOM_M"], "PRENOM" => $membres_results[$i]["PRENOM"], "ROLE" => $membres_results[$i]["ROLE"], "LOGIN" => $membres_results[$i]["LOGIN"]); } $result = array("INDEXES" => $indexes, "MEMBRES" => $membres_result); $json = json_encode($result); echo $json; }
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; }