public function indexAction()
{
//TODO: Überprüfung auf Passwort und unique E-Mail auch in EditController
$namespace = new Zend_Session_Namespace('user');
if ($this->getRequest()->isPost() and $this->form->isValid($this->getRequest()->getParams())) {
if ($this->form->getValue('Token') == $namespace->Token) {
//get parameters for test of unique username
$userTable = new User();
$tableRow = User::COL_USERNAME;
$value = $this->getRequest()->getParam(User::COL_USERNAME);
if ($this->getRequest()->getParam(User::COL_PASSWORD) != $this->getRequest()->getParam(User_Form_Edit::PASSWORD_CLONE)) {
$element = $this->form->getElement(User_Form_Edit::PASSWORD_CLONE);
$element->addError("Error: Your password and the repeating don't match.");
$this->form->markAsError();
return $this->render('index');
} elseif (Default_SimpleQuery::isValueInTableColumn($value, $userTable, $tableRow, 'string')) {
$element = $this->form->getElement(User::COL_USERNAME);
$element->addError("Error: This username is already used.");
$this->form->markAsError();
return $this->render('index');
} else {
try {
//values checked, insert
$guid = Ble422_Guid::getGuid();
$userTable = new User();
$userTable->getAdapter()->beginTransaction();
$userId = $userTable->insert(array(User::COL_USERNAME => $this->form->getValue(User::COL_USERNAME), User::COL_FIRSTNAME => $this->form->getValue(User::COL_FIRSTNAME), User::COL_LASTNAME => $this->form->getValue(User::COL_LASTNAME), User::COL_PASSWORD => "{SHA}" . base64_encode(pack("H*", sha1($this->form->getValue(User::COL_PASSWORD)))), User::COL_EMAIL => $this->form->getValue(User::COL_USERNAME), User::COL_INSTITUTION => $this->form->getValue(User::COL_INSTITUTION), User::COL_STREET => $this->form->getValue(User::COL_STREET), User::COL_COUNTRY => $this->form->getValue(User::COL_COUNTRY), User::COL_PHONE => $this->form->getValue(User::COL_PHONE), User::COL_FAX => $this->form->getValue(User::COL_FAX), User::COL_CITY => $this->form->getValue(User::COL_CITY), User::COL_GUID => $guid, User::COL_ACTIVE => 0));
$toAdress = $this->form->getValue(User::COL_USERNAME);
$bodyText = "Please click this link to confirm your new account:\r\n" . Zend_Registry::get('APP_HOST') . '/default/registeruser/confirm/' . User::COL_GUID . '/' . $guid;
$mail = new Default_Mail($toAdress, 'WebGR register user message', $bodyText);
$mail->send();
$userTable->getAdapter()->commit();
$namespace->Token = '';
$this->redirectTo('success');
} catch (Exception $e) {
$userTable->getAdapter()->rollBack();
throw new Exception('error at register a new user: '******'success');
}
} else {
//no post or some element(s) not valid
//$this->form->setAction(Zend_Controller_Front::getInstance()->getBaseUrl()."/user/new");
if ($this->form->getValue('Token') == null) {
$guid = new Ble422_Guid();
$namespace->Token = $guid->__toString();
$this->form->getElement('Token')->setValue($guid->__toString());
}
}
}
public function indexAction()
{
//remove all elements, only username (=e-mail) stays
$this->form = new User_Form_Edit();
$elems = $this->form->getElements();
foreach ($elems as $elem) {
if (!($elem->getName() == User::COL_USERNAME || $elem->getName() == 'submit')) {
$this->form->removeElement($elem->getName());
}
}
//#####################new###################################
$this->form->setDecorators(array('FormElements', array('HtmlTag', array('tag' => 'table', 'class' => 'login_form')), array('Description', array('placement' => 'prepend')), 'Form'));
$this->form->setElementDecorators(array('ViewHelper', 'Errors', array('decorator' => array('td' => 'HtmlTag'), 'options' => array('tag' => 'td')), array('Label', array('tag' => 'td')), array('decorator' => array('tr' => 'HtmlTag'), 'options' => array('tag' => 'tr'))));
//###########################################################
if ($this->getRequest()->isPost()) {
if ($this->form->isValid($this->getRequest()->getParams())) {
//lookup if e-mail exists and send mail
$e_mail = $this->form->getValue(User::COL_USERNAME);
if (Default_SimpleQuery::isValueInTableColumn($e_mail, new User(), User::COL_USERNAME, 'string')) {
$user = new User();
$select = $user->select();
$where = $user->getAdapter()->quoteInto(User::COL_USERNAME . ' = ?', $e_mail, 'string');
$select->where($where);
$rowset = $user->fetchAll($select);
if ($rowset->count() == 1) {
$newGuid = Ble422_Guid::getGuid();
$data = array(User::COL_GUID => $newGuid);
$user->update($data, $where);
$toAdress = $this->form->getValue(User::COL_USERNAME);
$host = Zend_Registry::get('APP_HOST');
$bodyText = 'Please click this link to reset your password:'******'/default/forgotpassword/myresetpassword/' . User::COL_GUID . '/' . $newGuid;
$mail = new Default_Mail($toAdress, 'WebGR forgot password message', $bodyText);
$mail->send();
}
}
//show message anyway, not depending on success
Zend_Registry::set('MESSAGE', 'if you are known to the system, the message was sent');
$this->view->message = 'if you are known to the system, the message was sent';
$this->render('message');
} else {
//not valid
$this->view->form = $this->form;
}
} else {
//not post
$this->view->form = $this->form;
}
//prevent robots and abuser to:
//- send e-mail to all possible e-mail adresses
//- send massive multiple e-mails to known adress
//- e-mail server dos
//lookup if e-mail exists and send mail
//show message anyway, not depending on success
}
public function newselectexpAction()
{
$namespace = new Zend_Session_Namespace('training');
if ($this->getRequest()->isPost()) {
if ($this->form->isValid($this->getRequest()->getParams())) {
if ($this->form->getValue('Token') == $namespace->Token) {
//insert/update
//get form value and set namespace
$this->defaultNamespace->expId = $this->form->getValue(CalibrationExercise::COL_EXPERTISE_ID);
$namespace->Token = $newToken;
$newToken = Ble422_Guid::getGuid();
$this->form->getElement('Token')->setValue($newToken);
//put validated values in GET params
$this->redirectTo('newselectavailablekeys', $this->form->getValues());
} else {
//form token is not equal session token
$this->form->reset();
$this->redirectTo('outofdate');
}
} else {
//not valid
$this->render('form');
}
} else {
//not post
//$this->form = new Ce_Form_Search();
//$this->form->setAction('/ce/new/newtrainselectavailablekeys/'.Workshop::COL_ID.'/TEMP');
if ($this->form->getValue('Token') == null) {
$guid = new Ble422_Guid();
$namespace->Token = $guid->__toString();
$this->form->getElement('Token')->setValue($guid->__toString());
$this->view->form = $this->form;
$this->render('form');
}
}
}
public function indexAction()
{
if ($this->callingCeId == NULL) {
$this->_forward("index", "index");
}
$dbAdapter = Zend_Registry::get('DB_CONNECTION1');
$namespace = new Zend_Session_Namespace('ce');
if ($this->getRequest()->isPost()) {
if ($this->form->isValid($this->getRequest()->getParams())) {
if ($this->form->getValue('Token') == $namespace->Token) {
//insert/update
$ceTable = new CalibrationExercise();
$data = array(CalibrationExercise::COL_NAME => $this->form->getValue(CalibrationExercise::COL_NAME), CalibrationExercise::COL_DESCRIPTION => $this->form->getValue(CalibrationExercise::COL_DESCRIPTION), CalibrationExercise::COL_COMPAREABLE => $this->form->getValue(CalibrationExercise::COL_COMPAREABLE), CalibrationExercise::COL_RANDOMIZED => $this->form->getValue(CalibrationExercise::COL_RANDOMIZED), CalibrationExercise::COL_WORKSHOP_ID => $this->form->getValue(CalibrationExercise::COL_WORKSHOP_ID), CalibrationExercise::COL_KEY_TABLE_ID => $this->form->getValue(CalibrationExercise::COL_KEY_TABLE_ID), CalibrationExercise::COL_EXPERTISE_ID => $this->form->getValue(CalibrationExercise::COL_EXPERTISE_ID));
$where = $ceTable->getAdapter()->quoteInto(CalibrationExercise::COL_ID . ' = ?', $this->form->getValue(CalibrationExercise::COL_ID));
$ceTable->update($data, $where);
$newToken = Ble422_Guid::getGuid();
$this->form->getElement('Token')->setValue($newToken);
$namespace->Token = $newToken;
} else {
//form token is not equal session token
$this->form->reset();
$this->redirectTo('outofdate');
}
} else {
//not valid
}
} else {
//not post
$this->form->setAction(Zend_Controller_Front::getInstance()->getBaseUrl() . '/ce/edit/index');
if ($this->form->getValue('Token') == null) {
$guid = new Ble422_Guid();
$namespace->Token = $guid->__toString();
$this->form->getElement('Token')->setValue($guid->__toString());
}
/**
* get all set values for calibration exercise
*/
//use Left Join to get the CE without assigned KeyTable/Expertise, too
//use left join for workshop to get training ce's too
$select = $dbAdapter->select();
$select->from(array('ce' => CalibrationExercise::TABLE_NAME));
$select->joinLeft(array('ws' => Workshop::TABLE_NAME), $dbAdapter->quoteIdentifier('ce.' . CalibrationExercise::COL_WORKSHOP_ID) . '=' . $dbAdapter->quoteIdentifier('ws.' . Workshop::COL_ID));
$select->joinLeft(array('kt' => KeyTable::TABLE_NAME), $dbAdapter->quoteIdentifier('ce.' . CalibrationExercise::COL_KEY_TABLE_ID) . '=' . $dbAdapter->quoteIdentifier('kt.' . KeyTable::COL_ID));
$select->joinLeft(array('exp' => Expertise::TABLE_NAME), $dbAdapter->quoteIdentifier('ce.' . CalibrationExercise::COL_EXPERTISE_ID) . '=' . $dbAdapter->quoteIdentifier('exp.' . Expertise::COL_ID));
$select->where($dbAdapter->quoteIdentifier('ce.' . CalibrationExercise::COL_ID) . ' = ?', $this->callingCeId);
$resultArray = $dbAdapter->fetchAll($select);
//fill form with values
$this->form->setValues($resultArray[0]);
}
$this->view->isStopped = $this->form->getValue(CalibrationExercise::COL_IS_STOPPED);
if (isset($this->defaultNamespace->returningAction) && isset($this->defaultNamespace->returningActionId)) {
switch ($this->defaultNamespace->returningAction) {
case 'ce/editkeytable/index':
$this->form->getElement(CalibrationExercise::COL_KEY_TABLE_ID)->setValue($this->defaultNamespace->returningActionId);
break;
case 'ce/editexpertise/index':
$this->form->getElement(CalibrationExercise::COL_EXPERTISE_ID)->setValue($this->defaultNamespace->returningActionId);
break;
default:
$this->defaultNamespace->returningAction = NULL;
$this->defaultNamespace->returningActionId = NULL;
throw new Zend_Exception();
break;
}
}
$this->defaultNamespace->returningAction = NULL;
$this->defaultNamespace->returningActionId = NULL;
/**
* get Shown Attributes List
*/
$selectShownAttr = $dbAdapter->select();
$selectShownAttr->from(CeHasAttributeDescriptor::TABLE_NAME);
$selectShownAttr->join(AttributeDescriptor::TABLE_NAME, CeHasAttributeDescriptor::TABLE_NAME . '.ATDE_ID = ' . AttributeDescriptor::TABLE_NAME . '.ATDE_ID', array(AttributeDescriptor::COL_NAME));
$selectShownAttr->where(CeHasAttributeDescriptor::COL_CAEX_ID . " = ?", $this->callingCeId);
$resultShownAttr = $dbAdapter->fetchAll($selectShownAttr);
$this->view->resultShownAttr = $resultShownAttr;
//remove already used attributes from selectbox
$elem = $this->formAttrSelCon->getElement('attr');
foreach ($resultShownAttr as $row) {
$elem->removeMultiOption($row[AttributeDescriptor::COL_ID]);
}
unset($elem);
//info/actions about participants
$this->view->numOfParti = $this->countParticipants();
$this->defaultNamespace->callingAction = 'ce/edit/index';
$this->defaultNamespace->callingActionId = $this->callingCeId;
$this->view->form = $this->form;
$this->formAttrSelCon->setAction(Zend_Controller_Front::getInstance()->getBaseUrl() . '/ce/edit/addattribute');
$this->view->formAttrSelCon = $this->formAttrSelCon;
/**
* imageset attributes fish and image
*/
//---get Attributes List
$selectAttr = $dbAdapter->select();
$selectAttr->from(ImagesetAttributes::TABLE_NAME);
$selectAttr->join(AttributeDescriptor::TABLE_NAME, ImagesetAttributes::TABLE_NAME . '.ATDE_ID = ' . AttributeDescriptor::TABLE_NAME . '.ATDE_ID');
$selectAttr->joinLeft(ValueList::TABLE_NAME, AttributeDescriptor::TABLE_NAME . '.' . AttributeDescriptor::COL_UNIT . '=' . ValueList::TABLE_NAME . '.' . ValueList::COL_ID, array('UNIT' => ValueList::COL_VALUE));
$selectAttr->where(ImagesetAttributes::COL_CE_ID . " = ?", $this->callingCeId);
//show only FISH-group & IMAGE-group attributes
$selectAttr->where('(' . AttributeDescriptor::COL_GROUP . " = ?", 'FISH');
$selectAttr->orWhere(AttributeDescriptor::COL_GROUP . " = ?)", 'IMAGE');
$resultAttr = $dbAdapter->fetchAll($selectAttr);
//remove already used attributes from selectbox
$elem = $this->formAttrSelConFish->getElement('attr');
foreach ($resultAttr as $row) {
$elem->removeMultiOption($row[AttributeDescriptor::COL_ID]);
}
unset($elem);
//remove already used attributes from selectbox
$elem = $this->formAttrSelConImage->getElement('attr');
foreach ($resultAttr as $row) {
$elem->removeMultiOption($row[AttributeDescriptor::COL_ID]);
}
unset($elem);
//set add form
$this->formAttrSelConFish->setAction(Zend_Controller_Front::getInstance()->getBaseUrl() . '/ce/edit/addimagesetattribute');
$this->view->formAttrSelConFish = $this->formAttrSelConFish;
$this->imageSetForm->addDynamicElements($resultAttr, true, true);
if (Default_SimpleQuery::isCeStopped($this->callingCeId)) {
$this->imageSetForm->addElement('submit', 'submit', array('label' => 'save'));
} else {
//set description to remove the "remove attribute"-link from form
foreach ($this->imageSetForm->getElements() as $elem) {
$elem->setDescription(NULL);
}
}
//set dynamic values
$this->imageSetForm->dynPopulate($resultAttr, ImagesetAttributes::COL_VALUE, array(CalibrationExercise::COL_ID => $this->callingCeId));
if (count($resultAttr) == 0) {
$this->view->noImageset = true;
} else {
$this->view->noImageset = false;
}
/**
* get already defined imagelist
*/
$selectImages = $dbAdapter->select();
$selectImages->from(array('cehim' => CeHasImage::TABLE_NAME));
$selectImages->join(array('im' => Image::TABLE_NAME), 'cehim.' . CeHasImage::COL_IMAGE_ID . '=' . 'im.' . Image::COL_ID);
$selectImages->where(CalibrationExercise::COL_ID . '=?', $this->callingCeId);
$this->view->imageArray = $dbAdapter->fetchAll($selectImages);
$this->view->ceId = $this->callingCeId;
$this->view->imageSetForm = $this->imageSetForm;
//set add form
$this->formAttrSelConImage->setAction(Zend_Controller_Front::getInstance()->getBaseUrl() . '/ce/edit/addimagesetattribute');
$this->view->formAttrSelConImage = $this->formAttrSelConImage;
if ($this->form->getElement(CalibrationExercise::COL_RANDOMIZED)->getValue() == 1) {
$this->view->isRandom = TRUE;
}
$this->defaultNamespace->message = NULL;
}
