public function deleterecursiveAction() { //delete workshop files //delete workshop -> triggers delete ce //delete ws info -> DB on delete cascade //delete ce //delete imageset attributes -> DB on delete cascade //delete ce has image -> DB on delete cascade //delete ce has attribute desc. -> DB on delete cascade //delete participants -> DB on delete cascade //delete annotations -> DB on delete cascade //delete dots -> DB on delete cascade $request = $this->getRequest(); $workId = intval($this->getRequest()->getParam(Workshop::COL_ID)); if (AuthQuery::getUserRole() == 'admin') { $request = $this->getRequest(); $workId = intval($this->getRequest()->getParam(Workshop::COL_ID)); $workshop = new Workshop(); $rowset = $workshop->find($workId); if (count($rowset) == 1) { $table = new WorkshopInfo(); //$tableAdapter = $table->getAdapter(); $select = $table->select(); //$select->from(WorkshopInfo::TABLE_NAME); $select->where(WorkshopInfo::COL_WORKSHOP_ID . ' = ?', $workId, 'int'); echo $select; $rowset = $table->fetchAll($select); if (count($rowset) >= 1) { $rowsetArray = $rowset->toArray(); $RELATIVE_WORKSHOP_FILES_PATH = 'infoFiles'; //without pre- and post-slash! foreach ($rowsetArray as $row) { try { $filename = $row[WorkshopInfo::COL_FILE]; if ($filename != NULL) { $myFile = $RELATIVE_WORKSHOP_FILES_PATH . '/' . $filename; $fh = fopen($myFile, 'w'); fclose($fh); unlink($myFile); } } catch (Exception $e) { throw new Zend_Exception('Error: can not open file'); } } } //note: delete of workshop_info is executed from db $workshop->delete($workshop->getAdapter()->quoteInto(Workshop::COL_ID . ' = ?', $workId)); } } $redirect = new Zend_Controller_Action_Helper_Redirector(); $redirect->setGoto('myws', 'search', 'workshop'); }
private function process(array $params) { //params-array filters (where) and/or shows more info (joins) $dbAdapter = Zend_Registry::get('DB_CONNECTION1'); $select = $dbAdapter->select(); $select->from(array('celist' => View_CeList::NAME), array(View_CeList::COL_WORK_NAME, View_CeList::COL_CAEX_NAME, View_CeList::COL_CAEX_DESC, View_CeList::COL_CAEX_ID, View_CeList::COL_WORK_ID, View_CeList::COL_CAEX_TRAIN, 'images' => new Zend_Db_Expr('count(cehim.' . CeHasImage::COL_ID . ')'))); $select->joinLeft(array('exp' => Expertise::TABLE_NAME), $dbAdapter->quoteIdentifier('celist.' . View_CeList::COL_EXPE_ID) . '=' . $dbAdapter->quoteIdentifier('exp.' . Expertise::COL_ID)); $select->joinLeft(array('key' => KeyTable::TABLE_NAME), $dbAdapter->quoteIdentifier('celist.' . View_CeList::COL_KETA_ID) . '=' . $dbAdapter->quoteIdentifier('key.' . KeyTable::COL_ID)); $select->joinLeft(array('cehim' => CeHasImage::TABLE_NAME), $dbAdapter->quoteIdentifier('celist.' . View_CeList::COL_CAEX_ID) . '=' . $dbAdapter->quoteIdentifier('cehim.' . CeHasImage::COL_CALIBRATION_EXERCISE_ID), array()); $select->joinLeft(array('vali1' => ValueList::TABLE_NAME), $dbAdapter->quoteIdentifier('vali1.' . ValueList::COL_ID) . '=' . $dbAdapter->quoteIdentifier('exp.' . Expertise::COL_SPECIES), array(Expertise::COL_SPECIES => 'vali1.' . ValueList::COL_VALUE)); $select->joinLeft(array('vali2' => ValueList::TABLE_NAME), $dbAdapter->quoteIdentifier('vali2.' . ValueList::COL_ID) . '=' . $dbAdapter->quoteIdentifier('exp.' . Expertise::COL_SUBJECT), array(Expertise::COL_SUBJECT => 'vali2.' . ValueList::COL_VALUE)); $select->group('celist.' . View_CeList::COL_CAEX_ID); $headerArray = array(array('raw' => View_CeList::COL_CAEX_NAME, 'name' => 'CE name'), array('raw' => View_CeList::COL_WORK_NAME, 'name' => 'Workshop name'), array('raw' => Expertise::COL_AREA, 'name' => 'Exp area'), array('raw' => Expertise::COL_SPECIES, 'name' => 'Exp species'), array('raw' => Expertise::COL_SUBJECT, 'name' => 'Exp subject'), array('raw' => KeyTable::COL_FILENAME, 'name' => 'Protocol')); if (array_key_exists(User::COL_ID, $params)) { //filter... $select->joinLeft(array('part' => Participant::TABLE_NAME), $dbAdapter->quoteIdentifier('celist.' . View_CeList::COL_CAEX_ID) . '=' . $dbAdapter->quoteIdentifier('part.' . Participant::COL_CE_ID), array('part.' . Participant::COL_ID)); //where i am participant $select->where('part.' . Participant::COL_USER_ID . '=?', $params[User::COL_ID]); $userId = $params[User::COL_ID]; $select->joinLeft(array('work' => Workshop::TABLE_NAME), 'work.' . Workshop::COL_ID . '=' . 'celist.' . View_CeList::COL_WORK_ID, array(Workshop::COL_USER_ID)); //or where i am workshop-manager $select->orWhere('work.' . Workshop::COL_USER_ID . '= ?', $userId); array_push($headerArray, array('raw' => View_CeList::COL_IMAGES, 'name' => 'Images')); } if (array_key_exists(CalibrationExercise::COL_EXPERTISE_ID, $params)) { $select->where('celist.' . CalibrationExercise::COL_EXPERTISE_ID . '=?', $params[CalibrationExercise::COL_EXPERTISE_ID]); // $select->joinLeft(array('cehim'=>CeHasImage::TABLE_NAME), // $dbAdapter->quoteIdentifier('celist.' . View_CeList::COL_CAEX_ID). '=' . $dbAdapter->quoteIdentifier('cehim.' .CeHasImage::COL_CALIBRATION_EXERCISE_ID), // array()); } //Hinzugefügt am 14.10.2009 Tabellenzeilen mit WS name = training exercise //sollten nicht angezeigt werden (im Menüpunkt search calibration exercises) //kompletter if-Zweig wurde hinzugefügt if ($this->getRequest()->getModuleName() == 'ce' && $this->getRequest()->getControllerName() == 'search' && $this->getRequest()->getActionName() == 'list') { $select->where(CalibrationExercise::COL_WORKSHOP_ID . ' is not null'); } //echo $select; /** * Paginator control */ $paginator = new Ble422_Paginator_Extended($select, $this->getRequest()); $paginator->setHeader($headerArray); $paginator->setCurrentPageNumber($this->getRequest()->getParam('page'))->setItemCountPerPage(10)->setPageRange(5)->orderBy($this->getRequest()->getParam('orderBy')); //$this->_getParam('pageRange')); Zend_View_Helper_PaginationControl::setDefaultViewPartial('partials/list_pagination_control.phtml'); $detailId = $this->getRequest()->getParam('detailId'); if ($detailId != null) { $detailId = intval($detailId); /** * show wether CE is stopped */ try { if (Default_SimpleQuery::isCeStopped($detailId)) { $this->view->ceInfo = 'CE is <b>STOPPED</b>'; } else { $this->view->ceInfo = 'CE is <b>RUNNING</b>'; } } catch (exception $e) { $this->view->ceInfo = $e->getMessage(); } /** * show Coordinator */ if ($coordinators = Participant::getCoordinators($detailId)) { $this->view->ceCoordinators = $coordinators; } /** * imageset and shown attributes */ $imagesetSelect = $dbAdapter->select(); $imagesetSelect->from('v_imageset_info'); $imagesetSelect->where(CalibrationExercise::COL_ID . '=?', $detailId); $imagesetSelect->group(AttributeDescriptor::COL_NAME); $imagesetArray = $dbAdapter->fetchAll($imagesetSelect); $this->view->imagesetArray = $imagesetArray; $shownAttrSelect = $dbAdapter->select(); $shownAttrSelect->from(array('cehat' => CeHasAttributeDescriptor::TABLE_NAME)); $shownAttrSelect->join(array('attr' => AttributeDescriptor::TABLE_NAME), 'cehat.' . CeHasAttributeDescriptor::COL_ATDE_ID . '= attr.' . AttributeDescriptor::COL_ID); $shownAttrSelect->where(CalibrationExercise::COL_ID . '=?', $detailId); $shownAttrArray = $dbAdapter->fetchAll($shownAttrSelect); $this->view->shownAttrArray = $shownAttrArray; $this->view->detailId = $detailId; } $this->view->userRole = AuthQuery::getUserRole(); $this->view->expeId = $this->getRequest()->getParam(CalibrationExercise::COL_EXPERTISE_ID); $this->view->paginator = $paginator; $this->render('list'); }
public function detailsAction() { $wsId = $this->getRequest()->getParam(Workshop::COL_ID); $dbAdapter = Zend_Registry::get('DB_CONNECTION1'); $wsSelect = $dbAdapter->select(); $wsSelect->from(array('work' => Workshop::TABLE_NAME)); $wsSelect->join(array('inst' => ValueList::TABLE_NAME), 'inst.' . ValueList::COL_ID . "=" . 'work.' . Workshop::COL_HOST_ORGANISATION, array('instname' => ValueList::COL_NAME)); $wsSelect->join(array('local' => ValueList::TABLE_NAME), 'local.' . ValueList::COL_ID . "=" . 'work.' . Workshop::COL_LOCATION, array('location' => ValueList::COL_NAME)); $wsSelect->join(array('user' => User::TABLE_NAME), 'user.' . User::COL_ID . "=" . 'work.' . Workshop::COL_USER_ID, array('manager' => User::COL_USERNAME)); $wsSelect->where(Workshop::COL_ID . '=?', $wsId); $workshopArray = $dbAdapter->fetchAll($wsSelect); /** * ce list */ $ceSelect = $dbAdapter->select(); $ceSelect->from(CalibrationExercise::TABLE_NAME); $ceSelect->where(CalibrationExercise::COL_WORKSHOP_ID . '=?', $wsId); $this->view->ceArray = $dbAdapter->fetchAll($ceSelect); /** * links */ $infoTable = new WorkshopInfo(); $linkSelect = $infoTable->select(); $linkSelect->where(WorkshopInfo::COL_WORKSHOP_ID . "=?", $wsId); $linkSelect->where(WorkshopInfo::COL_FILE . " IS NULL"); $linkResult = $infoTable->fetchAll($linkSelect); if ($linkResult != null) { $linkArray = $linkResult->toArray(); } else { $linkArray = array(); } /** * files */ $fileSelect = $infoTable->select(); $fileSelect->where(WorkshopInfo::COL_WORKSHOP_ID . "=?", $wsId); $fileSelect->where(WorkshopInfo::COL_LINK . " IS NULL"); $fileResult = $infoTable->fetchAll($fileSelect); if ($fileResult != null) { $fileArray = $fileResult->toArray(); } else { $fileArray = array(); } $this->view->userRole = AuthQuery::getUserRole(); $this->view->workshopArray = $workshopArray[0]; $this->view->linkArray = $linkArray; $this->view->fileArray = $fileArray; $this->view->wsId = $wsId; }