public static function getBlockDetailsByLangID($blockID, $langID)
{
$blockIndex = new BlocksIndex();
$select = $blockIndex->select()->setIntegrityCheck(false)->from('BlocksIndex')->join('Blocks', 'Blocks.B_ID = BlocksIndex.BI_BlockID')->where('BlocksIndex.BI_LanguageID = ?', $langID)->where('BlocksIndex.BI_BlockID= ?', $blockID);
$block = $blockIndex->fetchRow($select);
if (empty($block)) {
$newrow = $blockIndex->createRow(array('BI_BlockID' => $blockID, 'BI_LanguageID' => $langID));
$newrow->save();
$block = $blockIndex->fetchRow($select);
}
return $block;
}
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);
}
}
}
}
