function deleteAction()
{
$this->view->title = "Supprimer une page";
// retrieve the ID of the parent page
$PageID = $this->_getParam('ID');
if (Cible_ACL::hasAccess($PageID)) {
// generates tree by Language and send the result to the view
Zend_Registry::set('baseUrl', $this->view->baseUrl());
$this->view->TreeView = $this->view->getTreeView();
if ($this->_request->isPost()) {
//$PageID = (int)$this->_request->getPost('PageID');
// if is set delete, then delete
$delete = isset($_POST['delete']);
if ($delete && $PageID > 0) {
Cible_FunctionsPages::deleteAllChildPage($PageID);
Cible_FunctionsPages::deleteAllBlock($PageID);
$pageSelect = new PagesIndex();
$select = $pageSelect->select()->where('PI_PageID = ?', $PageID);
$pageData = $pageSelect->fetchAll($select)->toArray();
foreach ($pageData as $page) {
$indexData['moduleID'] = 0;
$indexData['contentID'] = $PageID;
$indexData['languageID'] = $page['PI_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
}
$Page = new Pages();
$Where = 'P_ID = ' . $PageID;
$Page->delete($Where);
$PageIndex = new PagesIndex();
$Where = 'PI_PageID = ' . $PageID;
$PageIndex->delete($Where);
if (!$this->_request->isXmlHttpRequest()) {
$this->_redirect('/');
}
} else {
if (!$this->_isXmlHttpRequest) {
$this->_redirect('/page/edit/ID/' . $PageID);
}
}
} else {
if ($PageID > 0) {
$Page = new Pages();
$this->view->page = $Page->fetchRow('P_ID=' . $PageID);
$PageIndex = new PagesIndex();
$Select = $PageIndex->select()->where("PI_PageID = ?", $PageID)->where("PI_LanguageID = ?", $this->_defaultEditLanguage);
$this->view->pageindex = $PageIndex->fetchRow($Select);
}
}
}
}
public static function getHomePageDetails()
{
$pagesSelect = new Pages();
$select = $pagesSelect->select()->setIntegrityCheck(false)->from('Pages')->join('PagesIndex', 'PI_PageID = P_ID')->where('PI_LanguageID = ?', Zend_Registry::get('languageID'))->where('P_Home = 1');
return $pagesSelect->fetchRow($select)->toArray();
}
function deleteAction()
{
$this->view->title = "Delete Pages";
$pages = new Pages();
if ($this->_request->isPost()) {
Zend_Loader::loadClass('Zend_Filter_Alpha');
$filter = new Zend_Filter_Alpha();
$id = (int) $this->_request->getPost('id');
$del = $filter->filter($this->_request->getPost('del'));
if ($del == 'Yes' && $id > 0) {
$where = 'id = ' . $id;
$rows_affected = $pages->delete($where);
}
} else {
$id = (int) $this->_request->getParam('id');
if ($id > 0) {
// only render if we have an id and can find the pages.
$this->view->pages = $pages->fetchRow('id=' . $id);
if ($this->view->pages->id > 0) {
// render template automatically
return;
}
}
}
// redirect back to the pages list unless we have rendered the view
$this->_redirect('/admin');
}
public function deleteBlockAction()
{
// variables
$_pageID = (int) $this->_getParam('ID');
$_blockID = (int) $this->_getParam('blockID');
if (Cible_ACL::hasAccess($_pageID)) {
if ($this->_request->isPost()) {
// if is set delete, then delete
$delete = isset($_POST['delete']);
if ($delete && $_blockID > 0) {
// never remove the news themselves
/* DELETE ROW IN BLOCK TABLE(S) */
if (method_exists($this, 'delete')) {
$this->delete($_blockID);
}
$this->deleteBlock($_blockID);
if ($this->_isXmlHttpRequest) {
$this->disableView();
echo Zend_Json::encode(array('result' => true));
return;
}
}
$this->_redirect('/page/manage/index/ID/' . $_pageID);
} else {
if ($_pageID > 0) {
// get page information
$page = new Pages();
$this->view->page = $page->fetchRow('P_ID=' . $_pageID);
$pageIndex = new PagesIndex();
$select = $pageIndex->select()->where("PI_PageID = ?", $_pageID)->where("PI_LanguageID = ?", Zend_Registry::get("languageID"));
$this->view->pageIndex = $pageIndex->fetchRow($select);
// get block information
$blockIndex = new BlocksIndex();
$select = $blockIndex->select()->where('BI_BlockID = ?', $_blockID)->where('BI_LanguageID = ?', Zend_Registry::get("languageID"));
$this->view->blockIndex = $blockIndex->fetchRow($select);
}
}
}
}