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);
}
}
}
