Example #1
0
 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;
 }
Example #2
0
 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;
 }