public function profileAction() { // page title $this->view->title = "Votre profil"; // get user data $authData = $this->view->user; $authID = $authData['EU_ID']; $users = new ExtranetUsers(); $select = $users->select()->where("EU_ID = ?", $authID); $userData = $users->fetchRow($select); /********** ACTIONS ***********/ $form = new FormExtranetUser(array('baseDir' => $this->view->baseUrl(), 'cancelUrl' => $this->getFrontController()->getBaseUrl(), 'profile' => true)); $this->view->form = $form; if (!$this->_request->isPost()) { $form->populate($userData->toArray()); } else { $formData = $this->_request->getPost(); if ($form->isValid($formData)) { // validate username is unique $findUser = new ExtranetUsers(); $select = $findUser->select()->where('EU_Username = ?', $userData['EU_Username'])->where('EU_ID <> ?', $authID); $findUserData = $findUser->fetchAll($select); // username is allready use if ($findUserData->count() > 0) { $form->getElement('EU_Username')->addError('Un autre utilisateur possède déjà ce nom d\'utilisateur'); } else { $userData['EU_LName'] = $form->getValue('EU_LName'); $userData['EU_FName'] = $form->getValue('EU_FName'); $userData['EU_Email'] = $form->getValue('EU_Email'); $userData['EU_Username'] = $form->getValue('EU_Username'); if ($form->getValue('EU_Password') != "") { $userData['EU_Password'] = md5($form->getValue('EU_Password')); } $userData->save(); $this->_redirect(''); } } } }
public static function getAdministratorData($administratorID) { $users = new ExtranetUsers(); $select = $users->select()->where("EU_ID = ?", $administratorID); return $users->fetchRow($select); }