public function deleteCollectionAction() { if ($this->view->aclIsAllowed('newsletter', 'edit', true)) { $returnUrl = "/newsletter/filter/list-collection/"; $collectionID = $this->_getParam('collectionID'); if ($this->_request->isPost()) { $del = $this->_request->getPost('delete'); if ($del && $collectionID > 0) { $collectionDelete = new NewsletterFilterCollectionsSet(); $where = "NFCS_ID = {$collectionID}"; $collectionDelete->delete($where); $filterSetSelect = new NewsletterFilterCollectionsFiltersSet(); $select = $filterSetSelect->select(); $select->where('NFCFS_CollectionSetID = ?', $collectionID); $filterSetData = $filterSetSelect->fetchAll($select)->toArray(); foreach ($filterSetData as $filterSet) { $filterSetDelete = new NewsletterFilterFiltersSet(); $where = 'NFFS_ID = ' . $filterSet['NFCFS_FilterSetID']; $filterSetDelete->delete($where); $filterDelete = new NewsletterFilterFilters(); $where = 'NFF_FilterSetID = ' . $filterSet['NFCFS_FilterSetID']; $filterDelete->delete($where); $collectionFilterSetDelete = new NewsletterFilterCollectionsFiltersSet(); $where = 'NFCFS_FilterSetID = ' . $filterSet['NFCFS_FilterSetID']; $collectionFilterSetDelete->delete($where); } } $this->_redirect($returnUrl); } else { $collectionSelect = new NewsletterFilterCollectionsSet(); $select = $collectionSelect->select(); $select->where('NFCS_ID = ?', $collectionID); $collectionData = $collectionSelect->fetchRow($select)->toArray(); $this->view->assign('collection', $collectionData); } } }