public function deleteAction()
{
$startTime = microtime(true);
Cible_FunctionsIndexation::indexationDeleteAll();
$endTime = microtime(true);
$totalTime = round($endTime - $startTime, 2) . " seconde";
echo json_encode(array('totalTime' => $totalTime));
}
public static function indexationBuild()
{
set_time_limit(0);
/* * ****** PAGE ******* */
$pageSelect = new PagesIndex();
$select = $pageSelect->select()->where('PI_Status = 1');
$pageData = $pageSelect->fetchAll($select)->toArray();
$cpt = count($pageData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $pageData[$i]['PI_PageID'];
$indexData['moduleID'] = 0;
$indexData['contentID'] = $pageData[$i]['PI_PageID'];
$indexData['languageID'] = $pageData[$i]['PI_LanguageID'];
$indexData['title'] = $pageData[$i]['PI_PageTitle'];
$indexData['text'] = '';
$indexData['link'] = '';
$indexData['contents'] = $pageData[$i]['PI_PageTitle'];
Cible_FunctionsIndexation::indexation($indexData);
}
/* * ****** TEXT ******* */
if (class_exists('Text', false)) {
$textSelect = new Text();
$select = $textSelect->select()->setIntegrityCheck(false)->from('TextData', array('ID' => 'TD_ID', 'LanguageID' => 'TD_LanguageID', 'Text' => 'TD_OnlineText'))->join('Blocks', 'B_ID = TD_BlockID', array('BlockID' => 'B_ID', 'ModuleID' => 'B_ModuleID'))->where('B_Online = 1')->join('PagesIndex', 'PI_PageID = B_PageID', array('PageID' => 'PI_PageID', 'Title' => 'PI_PageTitle'))->where('PI_Status = 1')->where('PI_LanguageID = TD_LanguageID');
$textData = $textSelect->fetchAll($select)->toArray();
$cpt = count($textData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $textData[$i]['PageID'];
$indexData['moduleID'] = $textData[$i]['ModuleID'];
$indexData['contentID'] = $textData[$i]['ID'];
$indexData['languageID'] = $textData[$i]['LanguageID'];
$indexData['title'] = $textData[$i]['Title'];
$indexData['text'] = '';
$indexData['link'] = '';
$indexData['contents'] = $textData[$i]['Title'] . " " . $textData[$i]['Text'];
Cible_FunctionsIndexation::indexation($indexData);
}
}
/* * ********************* */
/* * ****** NEWS ******* */
if (class_exists('NewsData', false)) {
$newsSelect = new NewsData();
$select = $newsSelect->select()->setIntegrityCheck(false)->from('NewsData', array('NewsID' => 'ND_ID', 'CategoryID' => 'ND_CategoryID'))->join('NewsIndex', 'NI_NewsDataID = ND_ID', array('LanguageID' => 'NI_LanguageID', 'NewsTitle' => 'NI_Title', 'NewsBrief' => 'NI_Brief', 'NewsText' => 'NI_Text', 'NewsImageAlt' => 'NI_ImageAlt'))->where('NI_Status = 1');
$newsData = $newsSelect->fetchAll($select);
$cpt = count($newsData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $newsData[$i]['CategoryID'];
$indexData['moduleID'] = 2;
$indexData['contentID'] = $newsData[$i]['NewsID'];
$indexData['languageID'] = $newsData[$i]['LanguageID'];
$indexData['title'] = $newsData[$i]['NewsTitle'];
$indexData['text'] = '';
$indexData['link'] = '';
$indexData['contents'] = $newsData[$i]['NewsTitle'] . " " . $newsData[$i]['NewsBrief'] . " " . $newsData[$i]['NewsText'] . " " . $newsData[$i]['NewsImageAlt'];
Cible_FunctionsIndexation::indexation($indexData);
}
}
/* * ********************* */
/* * ****** EVENTS ******* */
if (class_exists('EventsIndex', false)) {
$eventsSelect = new EventsIndex();
$select = $eventsSelect->select()->setIntegrityCheck(false)->from('EventsIndex', array('ID' => 'EI_EventsDataID', 'LanguageID' => 'EI_LanguageID', 'Title' => 'EI_Title', 'Brief' => 'EI_Brief', 'Text' => 'EI_Text', 'ImageAlt' => 'EI_ImageAlt'))->join('EventsData', 'ED_ID = EI_EventsDataID', array('CategoryID' => 'ED_CategoryID'))->where('EI_Status = 1');
$eventsData = $eventsSelect->fetchAll($select)->toArray();
$cpt = count($eventsData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $eventsData[$i]['CategoryID'];
$indexData['moduleID'] = 7;
$indexData['contentID'] = $eventsData[$i]['ID'];
$indexData['languageID'] = $eventsData[$i]['LanguageID'];
$indexData['title'] = $eventsData[$i]['Title'];
$indexData['text'] = '';
$indexData['link'] = '';
$indexData['contents'] = $eventsData[$i]['Title'] . " " . $eventsData[$i]['Brief'] . " " . $eventsData[$i]['Text'] . " " . $eventsData[$i]['ImageAlt'];
Cible_FunctionsIndexation::indexation($indexData);
}
}
/* * ********************* */
/* * ****** GALLERY ******* */
if (class_exists('Galleries', false)) {
$gallerySelect = new Galleries();
$select = $gallerySelect->select()->setIntegrityCheck(false)->from('Galleries', array('ID' => 'G_ID', 'CategoryID' => 'G_CategoryID'))->where('G_Online = 1')->join('GalleriesIndex', 'GI_GalleryID = G_ID', array('LanguageID' => 'GI_LanguageID', 'Title' => 'GI_Title', 'Description' => 'GI_Description'))->join('ImagesIndex', 'II_ImageID = G_ImageID', array('ImageTitle' => 'II_Title', 'ImageDescription' => 'II_Description'))->where('II_LanguageID = GI_LanguageID');
$galleryData = $gallerySelect->fetchAll($select);
$cpt = count($galleryData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $galleryData[$i]['CategoryID'];
$indexData['moduleID'] = 9;
$indexData['contentID'] = $galleryData[$i]['ID'];
$indexData['languageID'] = $galleryData[$i]['LanguageID'];
$indexData['title'] = $galleryData[$i]['Title'];
$indexData['text'] = '';
$indexData['link'] = 'gallery';
$indexData['contents'] = $galleryData[$i]['Title'] . " " . $galleryData[$i]['Description'] . " " . $galleryData[$i]['ImageTitle'] . " " . $galleryData[$i]['ImageDescription'];
Cible_FunctionsIndexation::indexation($indexData);
$imagesSelect = new GalleriesImages();
$select = $imagesSelect->select()->setIntegrityCheck(false)->from('Galleries_Images', array('ID' => 'GI_ImageID'))->where('GI_GalleryID = ?', $galleryData[$i]['ID'])->where('GI_Online = 1')->join('ImagesIndex', 'II_ImageID = GI_ImageID', array('LanguageID' => 'II_LanguageID', 'Title' => 'II_Title', 'Description' => 'II_Description'));
$imagesData = $imagesSelect->fetchAll($select);
$cptImage = count($imagesData);
for ($y = 0; $y < $cptImage; $y++) {
$indexData['action'] = "add";
$indexData['pageID'] = $galleryData[$i]['CategoryID'];
$indexData['moduleID'] = 9;
$indexData['contentID'] = $galleryData[$i]['ID'];
$indexData['languageID'] = $imagesData[$y]['LanguageID'];
$indexData['title'] = $imagesData[$y]['Title'];
$indexData['text'] = '';
$indexData['link'] = 'image';
$indexData['contents'] = $imagesData[$y]['Title'] . " " . $imagesData[$y]['Description'];
Cible_FunctionsIndexation::indexation($indexData);
}
}
}
/* * ********************* */
/* * ****** NEWSLETTERS ******* */
if (class_exists('NewsletterRelease', false)) {
$newsletterSelect = new NewsletterReleases();
$select = $newsletterSelect->select()->from('Newsletter_Releases', array('ID' => 'NR_ID', 'LanguageID' => 'NR_LanguageID', 'Title' => 'NR_Title'))->where('NR_Online = 1');
$newsletterData = $newsletterSelect->fetchAll($select)->toArray();
$cpt = count($newsletterData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['action'] = "add";
$indexData['pageID'] = $newsletterData[$i]['ID'];
$indexData['moduleID'] = 8;
$indexData['contentID'] = $newsletterData[$i]['ID'];
$indexData['languageID'] = $newsletterData[$i]['LanguageID'];
$indexData['title'] = $newsletterData[$i]['Title'];
$indexData['text'] = '';
$indexData['link'] = 'release';
$indexData['contents'] = $newsletterData[$i]['Title'];
Cible_FunctionsIndexation::indexation($indexData);
$articlesSelect = new NewsletterArticles();
$select = $articlesSelect->select()->from('Newsletter_Articles', array('ID' => 'NA_ID', 'Title' => 'NA_Title', 'Resume' => 'NA_Resume', 'Text' => 'NA_Text'))->where('NA_ReleaseID = ?', $newsletterData[$i]['ID']);
$articlesData = $articlesSelect->fetchAll($select);
$cptArticle = count($articlesData);
for ($y = 0; $y < $cptArticle; $y++) {
$indexData['action'] = "add";
$indexData['pageID'] = $newsletterData[$i]['ID'];
$indexData['moduleID'] = 8;
$indexData['contentID'] = $articlesData[$y]['ID'];
$indexData['languageID'] = $newsletterData[$i]['LanguageID'];
$indexData['title'] = $articlesData[$y]['Title'];
$indexData['text'] = '';
$indexData['link'] = 'article';
$indexData['contents'] = $articlesData[$y]['Title'] . " " . $articlesData[$y]['Resume'] . " " . $articlesData[$y]['Text'];
Cible_FunctionsIndexation::indexation($indexData);
}
}
}
/* * ********************* */
}
public function indexAction()
{
$searchResult = Cible_FunctionsIndexation::indexationSearch('');
}
public function deleteAction()
{
// variables
$pageID = (int) $this->_getParam('pageID');
$blockID = (int) $this->_getParam('blockID');
$eventID = (int) $this->_getParam('eventID');
$this->view->return = $this->view->baseUrl() . "/events/index/list/blockID/{$blockID}/pageID/{$pageID}";
$eventsObject = new EventsObject();
if (Cible_ACL::hasAccess($pageID)) {
if ($this->_request->isPost()) {
$del = $this->_request->getPost('delete');
if ($del && $eventID > 0) {
$eventsObject->delete($eventID);
$indexData['moduleID'] = $this->_moduleID;
$indexData['contentID'] = $eventID;
$indexData['languageID'] = Zend_Registry::get("currentEditLanguage");
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/event/" . $eventID);
}
if (!empty($pageID)) {
$this->_redirect("/events/index/list/blockID/{$blockID}/pageID/{$pageID}");
} else {
$this->_redirect("/events/index/list-all/");
}
} else {
if ($eventID > 0) {
// get event details
$this->view->event = $eventsObject->populate($eventID, Zend_Registry::get('currentEditLanguage'));
}
}
}
}
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 function deleteAction()
{
// web page title
$this->view->title = "Suppression d'une galerie";
//if ($this->view->aclIsAllowed('gallery','manage',true)){
// variables
$this->view->assign('isXmlHttpRequest', $this->_isXmlHttpRequest);
$this->view->assign('success', false);
$pageID = (int) $this->_getParam('pageID');
$blockID = (int) $this->_getParam('blockID');
$galleryID = (int) $this->_getParam('galleryID');
if ($blockID != '') {
$return = "/gallery/index/list/blockID/{$blockID}/pageID/{$pageID}";
} elseif ($this->_categoryID) {
$return = "/gallery/index/list/catID/{$this->_categoryID}";
} else {
$return = "/gallery/index/list/";
}
$this->view->return = $this->view->baseUrl() . $return;
$galleryObject = new GalleryObject();
$galleryDataIndex = $galleryObject->populate($galleryID, $this->_defaultEditLanguage);
if (!$galleryDataIndex) {
if ($this->_request->isPost()) {
$this->view->assign('success', true);
}
$this->view->assign('deleted', true);
$this->view->assign('galleryID', $galleryID);
} else {
$this->view->assign('deleted', false);
$this->view->gallery = $galleryDataIndex;
if ($this->_request->isPost()) {
$formData = $this->_request->getPost();
if ($galleryDataIndex) {
$gallerySelect = new GalleriesIndex();
$select = $gallerySelect->select()->where('GI_GalleryID = ?', $galleryID);
$galleryData = $gallerySelect->fetchAll($select);
foreach ($galleryData as $gallery) {
$indexData['moduleID'] = $this->_moduleID;
$indexData['contentID'] = $galleryID;
$indexData['languageID'] = $gallery['GI_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
$imageSelect = new GalleriesImages();
$select = $imageSelect->select()->setIntegrityCheck(false)->from('Galleries_Images')->where('GI_GalleryID = ?', $galleryID)->join('ImagesIndex', 'II_ImageID = GI_ImageID')->where('II_LanguageID = ?', $gallery['GI_LanguageID']);
$imageData = $imageSelect->fetchAll($select)->toArray();
$cpt = count($imageData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['moduleID'] = $this->_moduleID;
$indexData['contentID'] = $imageData[$i]['II_ImageID'];
$indexData['languageID'] = $imageData[$i]['II_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
}
}
//delete all images associated with the gallery
$galleryImagesSelect = new GalleriesImages();
$select = $galleryImagesSelect->select()->where('GI_GalleryID = ?', $galleryID);
$galleryImagesData = $galleryImagesSelect->fetchAll($select);
foreach ($galleryImagesData as $galleryImages) {
$imageDelete = new Images();
$where = "I_ID = " . $galleryImages['GI_ImageID'];
$imageDelete->delete($where);
$imageIndexDelete = new ImagesIndex();
$where = "II_ImageID = " . $galleryImages['GI_ImageID'];
$imageIndexDelete->delete($where);
}
$galleryImagesDelete = new GalleriesImages();
$where = "GI_GalleryID = " . $galleryID;
$galleryImagesDelete->delete($where);
$galleryObject->delete($galleryID);
/*
//delete the gallery
$galleryDelete = new Galleries();
$where = 'G_ID = ' . $galleryID;
$galleryDelete->delete($where);
$galleryIndexDelete = new GalleriesIndex();
$where = 'GI_GalleryID = ' . $galleryID;
$galleryIndexDelete->delete($where);
*/
//delete the gallery folder
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/gallery/" . $galleryID);
if (!$this->_isXmlHttpRequest) {
if ($blockID != '') {
$this->_redirect("/gallery/index/list/blockID/{$blockID}/pageID/{$pageID}");
} elseif ($this->_categoryID) {
$this->_redirect("/gallery/index/list/catID/{$this->_categoryID}");
} else {
$this->_redirect("/gallery/index/list/");
}
} else {
$buttonAction = $formData['buttonAction'];
$this->view->assign('success', true);
$this->view->assign('buttonAction', $buttonAction);
$this->view->assign('galleryID', $galleryID);
$this->view->assign('deleted', true);
}
}
}
}
//}
}
public static function deleteAllBlock($PageID)
{
$textSelect = new Blocks();
$select = $textSelect->select()->setIntegrityCheck(false)->from('Blocks')->where('B_PageID = ?', $PageID)->join('TextData', 'TD_BlockID = B_ID');
$textData = $textSelect->fetchAll($select);
foreach ($textData as $text) {
$indexData['moduleID'] = $text['B_ModuleID'];
$indexData['contentID'] = $text['TD_ID'];
$indexData['languageID'] = $text['TD_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
}
$Blocks = new Blocks();
$Where = "B_PageID = " . $PageID;
$Blocks->delete($Where);
}
function deleteAction()
{
$this->view->title = "'Suppression d'un article à une parution";
$this->view->assign('isXmlHttpRequest', $this->_isXmlHttpRequest);
$this->view->assign('success', false);
if ($this->view->aclIsAllowed('newsletter', 'manage', true)) {
// variables
$articleID = $this->_getParam('articleID');
$newsletterID = $this->_getParam('newsletterID');
$return = "/newsletter/index/edit/newsletterID/{$newsletterID}";
$this->view->return = $this->view->baseUrl() . $return;
$newsletterArticleSelect = new NewsletterArticles();
$select = $newsletterArticleSelect->select();
$select->where('NA_ID = ?', $articleID);
$newsletterArticleData = $newsletterArticleSelect->fetchRow($select);
if (!$newsletterArticleData) {
if ($this->_request->isPost()) {
$this->view->assign('success', true);
}
$this->view->assign('deleted', true);
$this->view->assign('articleID', $articleID);
} else {
$this->view->assign('deleted', false);
$this->view->newsletterArticle = $newsletterArticleData->toArray();
if ($this->_request->isPost()) {
$del = $this->_request->getPost('delete');
if ($del && $newsletterArticleData) {
// delete index
// check if release is online
$releaseSelect = new NewsletterReleases();
$select = $releaseSelect->select()->where('NR_ID = ?', $newsletterArticleData['NA_ReleaseID']);
$releaseData = $releaseSelect->fetchRow($select);
$indexData['moduleID'] = 8;
$indexData['contentID'] = $newsletterArticleData['NA_ID'];
$indexData['languageID'] = $releaseData['NR_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/newsletter/{$newsletterID}/{$articleID}");
// update position for all article higher
$newsletterArticlePosition = new NewsletterArticles();
$where = 'NA_PositionID > ' . $newsletterArticleData['NA_PositionID'];
$where .= ' AND NA_ReleaseID = ' . $newsletterArticleData['NA_ReleaseID'];
$where .= ' AND NA_ZoneID = ' . $newsletterArticleData['NA_ZoneID'];
$newsletterArticlePosition->update(array('NA_PositionID' => new Zend_Db_Expr('NA_PositionID - 1 ')), $where);
$newsletterArticleData->delete();
if (!$this->_isXmlHttpRequest) {
$this->_redirect($return);
} else {
$this->view->assign('success', true);
$this->view->assign('articleID', $articleID);
}
} else {
$this->_redirect($return);
}
}
}
}
}
public function deleteAction()
{
// web page title
$this->view->title = "Suppression d'une parution";
if ($this->view->aclIsAllowed('newsletter', 'manage', true)) {
// variables
$pageID = (int) $this->_getParam('pageID');
$blockID = (int) $this->_getParam('blockID');
$newsletterID = (int) $this->_getParam('newsletterID');
// generate the form
if (empty($pageID) && empty($blockID)) {
$returnUrl = "/newsletter/index/list-all/";
} else {
$returnUrl = "/newsletter/index/list/blockID/{$blockID}/pageID/{$pageID}";
}
$this->view->assign('return', "{$this->view->baseUrl()}{$returnUrl}");
$newsletterSelect = new NewsletterReleases();
$select = $newsletterSelect->select();
$select->where('NR_ID = ?', $newsletterID);
$newsletterData = $newsletterSelect->fetchRow($select);
$this->view->newsletter = $newsletterData->toArray();
if ($this->_request->isPost()) {
$del = $this->_request->getPost('delete');
if ($del && $newsletterData) {
// get all article in the release
$articlesSelect = new NewsletterArticles();
$select = $articlesSelect->select()->where('NA_ReleaseID = ?', $newsletterID);
$articlesData = $articlesSelect->fetchAll($select);
$indexData['pageID'] = $pageID;
$indexData['moduleID'] = 8;
$indexData['languageID'] = $newsletterData['NR_LanguageID'];
$indexData['action'] = 'delete';
foreach ($articlesData as $article) {
$indexData['contentID'] = $article['NA_ID'];
Cible_FunctionsIndexation::indexation($indexData);
}
$newsletterData->delete();
$newsletterArticleDelete = new NewsletterArticles();
$where = "NA_ReleaseID = " . $newsletterID;
$newsletterArticleDelete->delete($where);
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/newsletter/{$newsletterID}");
}
$this->_redirect($returnUrl);
}
}
}
public function editAction()
{
$this->view->title = "Modification d'un texte";
if ($this->view->aclIsAllowed('text', 'edit', true)) {
$_blockID = $this->_getParam('blockID');
$_pageid = $this->_getParam('pageID');
$_id = $this->_getParam('ID');
$base_dir = $this->getFrontController()->getBaseUrl();
$blockText = new Text();
$select = $blockText->select();
$select->where('TD_BlockID = ?', $_blockID);
$select->where('TD_LanguageID = ?', $this->_currentEditLanguage);
$block = $blockText->fetchRow($select);
$blockSelect = new Blocks();
$selectBloc = $blockSelect->select()->setIntegrityCheck(false)->from('Blocks')->where('B_ID = ?', $_blockID)->join('PagesIndex', 'PI_PageID = B_PageID')->where('PI_LanguageID = ?', $block['TD_LanguageID']);
// If block doesn't exist, creates it.
if (empty($block)) {
$block = $blockText->createRow(array('TD_BlockID' => $_blockID, 'TD_LanguageID' => $this->_currentEditLanguage));
$block->save();
// load it
$block = $blockText->fetchRow($select);
}
if ($_id) {
$returnLink = "{$base_dir}/text/index/list-approbation-request/";
} else {
$returnLink = "{$base_dir}/page/index/index/ID/{$_pageid}";
}
$form = new FormText(array('baseDir' => $base_dir, 'pageID' => $_pageid, 'cancelUrl' => $returnLink, 'toApprove' => $block["TD_ToApprove"]));
if (!$this->_request->isPost()) {
$block_data = empty($block) ? array() : $block->toArray();
$blockData = $blockSelect->fetchRow($selectBloc);
$block_data['PI_PageTitle'] = $blockData['PI_PageTitle'];
$form->populate($block_data);
} else {
$formData = $this->_request->getPost();
if ($form->isValid($formData)) {
if (isset($_POST['submitSaveSubmit'])) {
$block['TD_ToApprove'] = 1;
//header("location:".$returnLink);
} elseif (isset($_POST['submitSaveReturnWriting'])) {
$block['TD_ToApprove'] = 0;
//header("location:".$returnLink);
} elseif (isset($_POST['submitSaveOnline'])) {
$block['TD_OnlineTitle'] = $formData['TD_DraftTitle'];
$block['TD_OnlineText'] = $formData['TD_DraftText'];
$block['TD_ToApprove'] = 0;
//header("location:".$returnLink);
// index the new text if block online
$blockData = $blockSelect->fetchRow($selectBloc);
if ($blockData['B_Online'] == 1 && $blockData['PI_Status'] == 1) {
$indexData['pageID'] = $blockData['B_PageID'];
$indexData['moduleID'] = $blockData['B_ModuleID'];
$indexData['contentID'] = $block['TD_ID'];
$indexData['languageID'] = $block['TD_LanguageID'];
$indexData['title'] = $blockData['PI_PageTitle'];
$indexData['text'] = '';
$indexData['link'] = '';
$indexData['contents'] = $blockData['PI_PageTitle'] . " " . $block['TD_OnlineText'];
$indexData['action'] = 'update';
Cible_FunctionsIndexation::indexation($indexData);
}
} else {
$returnLink = "";
}
$block['TD_DraftTitle'] = $formData['TD_DraftTitle'];
$block['TD_DraftText'] = $formData['TD_DraftText'];
$block->save();
$oPage = new PagesObject();
$pageData['P_ID'] = $_pageid;
$pageData['PI_PageTitle'] = $formData['PI_PageTitle'];
$oPage->save($_pageid, $pageData, $this->_currentEditLanguage);
//if($returnLink <> "")
//$this->_redirect("/page/index/index/ID/$_pageid");
}
}
$this->view->assign('form', $form);
$this->view->assign('pageId', $_pageid);
$this->view->assign('onlineTitle', isset($block['TD_OnlineTitle']) ? $block['TD_OnlineTitle'] : '');
$this->view->assign('onlineText', isset($block['TD_OnlineText']) ? $block['TD_OnlineText'] : '');
}
}
function deleteAction()
{
$this->view->title = "Suppression d'une image";
//if ($this->view->aclIsAllowed('gallery','manage',true)){
$this->view->assign('isXmlHttpRequest', $this->_isXmlHttpRequest);
$this->view->assign('success', false);
$pageID = (int) $this->_getParam('pageID');
$blockID = (int) $this->_getParam('blockID');
$galleryID = (int) $this->_getParam('galleryID');
$imageID = (int) $this->_getParam('imageID');
$imageIndexSelect = new ImagesIndex();
$select = $imageIndexSelect->select()->where('II_ImageID = ?', $imageID);
$imageIndexData = $imageIndexSelect->fetchRow($select);
if (!$imageIndexData) {
if ($this->_request->isPost()) {
$this->view->assign('success', true);
}
$this->view->assign('deleted', true);
$this->view->assign('imageID', $imageID);
} else {
$imageObject = new ImageObject();
$imageIndexData = $imageObject->populate($imageID, Zend_Registry::get("languageID"));
//$imageIndexData = $imageObject->populate($imageID,$this->_defaultEditLanguage);
$this->view->assign('deleted', false);
$return = "/gallery/index/list/blockID/{$blockID}/pageID/{$pageID}";
$this->view->return = $this->view->baseUrl() . $return;
$this->view->image = $imageIndexData;
if ($this->_request->isPost()) {
//$del = $this->_request->getPost('delete');
//if ($del && $imageIndexData) {
if ($imageIndexData) {
$imageSelect = new ImagesIndex();
$select = $imageSelect->select()->where('II_ImageID = ?', $imageID);
$imageData = $imageSelect->fetchAll($select)->toArray();
$cpt = count($imageData);
for ($i = 0; $i < $cpt; $i++) {
$indexData['moduleID'] = $this->_moduleID;
$indexData['contentID'] = $imageData[$i]['II_ImageID'];
$indexData['languageID'] = $imageData[$i]['II_LanguageID'];
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
}
$imageObject->delete($imageID);
$galleryImageDelete = new GalleriesImages();
$where = 'GI_GalleryID = ' . $galleryID . " and GI_ImageID = " . $imageID;
$galleryImageDelete->delete($where);
//delete the gallery folder
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/gallery/" . $galleryID . "/" . $imageID);
if (!$this->_isXmlHttpRequest) {
$this->_redirect("/gallery/index/list/blockID/{$blockID}/pageID/{$pageID}");
} else {
$this->view->assign('success', true);
$this->view->assign('imageID', $imageID);
}
}
//$this->_redirect($return);
}
}
//}
}
public function deleteAction()
{
// variables
$pageID = (int) $this->_getParam('pageID');
$blockID = (int) $this->_getParam('blockID');
$newsID = (int) $this->_getParam('newsID');
if ($this->view->aclIsAllowed('news', 'publish', true)) {
$this->view->return = !empty($pageID) ? $this->view->baseUrl() . "/news/index/list/blockID/{$blockID}/pageID/{$pageID}" : $this->view->baseUrl() . "/news/index/list-all/";
$newsObject = new NewsObject();
if ($this->_request->isPost()) {
$del = $this->_request->getPost('delete');
if ($del && $newsID > 0) {
$newsObject->delete($newsID);
$indexData['moduleID'] = $this->_moduleID;
$indexData['contentID'] = $newsID;
$indexData['languageID'] = Zend_Registry::get("currentEditLanguage");
$indexData['action'] = 'delete';
Cible_FunctionsIndexation::indexation($indexData);
Cible_FunctionsGeneral::delFolder("../../{$this->_config->document_root}/data/images/news/" . $newsID);
}
if (!empty($pageID)) {
$this->_redirect("/news/index/list/blockID/{$blockID}/pageID/{$pageID}");
} else {
$this->_redirect("/news/index/list-all/");
}
} elseif ($newsID > 0) {
$this->view->news = $newsObject->populate($newsID, Zend_Registry::get('currentEditLanguage'));
}
}
}
public function indexAction()
{
$params['keywords'] = $searchParams['words'] = $searchWords = $this->_getParam('words');
$this->view->assign('words', $searchParams['words']);
$languageID = $lang = Zend_Registry::get('languageID');
$db = Zend_Registry::get("db");
$searchResults = array();
$searchCount = 0;
$searchResult = Cible_FunctionsIndexation::indexationSearch($searchParams);
//$this->view->dump($searchResult);
/* * ********* TEXT ************* */
$moduleID = 1;
$i = 0;
$y = 0;
$pageSelect = new PagesIndex();
$searchPage = array();
$pageIDArray = array();
foreach ($searchResult as $result) {
if ($result['moduleID'] == $moduleID && $result['languageID'] == $languageID || $result['moduleID'] == 0 && $result['languageID'] == $languageID) {
$select = $pageSelect->select()->where('PI_PageID = ?', $result['pageID'])->where('PI_LanguageID = ?', $result['languageID'])->where('PI_Status = 1');
$pageData = $pageSelect->fetchRow($select);
if ($pageData && !in_array($result['pageID'], $pageIDArray)) {
$pageIDArray[] = $result['pageID'];
$searchPage[$y]['moduleID'] = $result['moduleID'];
$searchPage[$y]['pageID'] = $result['pageID'];
$searchPage[$y]['contentID'] = $result['contentID'];
$searchPage[$y]['languageID'] = $result['languageID'];
$searchPage[$y]['title'] = $result['title'];
$searchPage[$y]['text'] = $result['text'];
$searchPage[$y]['link'] = $result['link'];
$searchPage[$y]['pageTitle'] = $pageData['PI_PageTitle'];
$searchPage[$y]['pageIndex'] = $pageData['PI_PageIndex'];
$y++;
$searchCount++;
}
array_splice($searchResult, $i, 1);
} else {
$i++;
}
}
$this->view->assign('searchPage', $searchPage);
/* * *************************** */
/* * ********* NEWS ************* */
$moduleID = 2;
$i = 0;
$y = 0;
$searchNews = array();
foreach ($searchResult as $result) {
if ($result['moduleID'] == $moduleID && $result['languageID'] == $languageID) {
$newsSelect = new NewsData();
$select = $newsSelect->select()->where('ND_ID = ?', $result['contentID']);
$newsData = $newsSelect->fetchRow($select);
$link = Cible_FunctionsCategories::getPagePerCategoryView($result['pageID'], 'details');
if ($newsData['ND_ReleaseDate'] <= date('Y-m-d') && $link != '') {
$searchNews[$y]['moduleID'] = $result['moduleID'];
$searchNews[$y]['pageID'] = $result['pageID'];
$searchNews[$y]['contentID'] = $result['contentID'];
$searchNews[$y]['languageID'] = $result['languageID'];
$searchNews[$y]['title'] = $result['title'];
$searchNews[$y]['text'] = $result['text'];
$searchNews[$y]['link'] = $link;
$y++;
$searchCount++;
}
array_splice($searchResult, $i, 1);
} else {
$i++;
}
}
$this->view->assign('searchNews', $searchNews);
/* * *************************** */
/* * ********* EVENTS ************* */
$moduleID = 7;
$i = 0;
$y = 0;
$searchEvents = array();
foreach ($searchResult as $result) {
if ($result['moduleID'] == $moduleID && $result['languageID'] == $languageID) {
$link = Cible_FunctionsCategories::getPagePerCategoryView($result['pageID'], 'details');
if ($link != '') {
$searchEvents[$y]['moduleID'] = $result['moduleID'];
$searchEvents[$y]['pageID'] = $result['pageID'];
$searchEvents[$y]['contentID'] = $result['contentID'];
$searchEvents[$y]['languageID'] = $result['languageID'];
$searchEvents[$y]['title'] = $result['title'];
$searchEvents[$y]['text'] = $result['text'];
$searchEvents[$y]['link'] = $link;
$y++;
$searchCount++;
}
array_splice($searchResult, $i, 1);
} else {
$i++;
}
}
$this->view->assign('searchEvents', $searchEvents);
/* * *************************** */
/* * ********* NEWSLETTERS ************* */
$moduleID = 8;
$i = 0;
$y = 0;
$searchNewsletters = array();
foreach ($searchResult as $result) {
if ($result['moduleID'] == $moduleID && $result['languageID'] == $languageID) {
$searchNewsletters[$y]['moduleID'] = $result['moduleID'];
$searchNewsletters[$y]['pageID'] = $result['pageID'];
$searchNewsletters[$y]['contentID'] = $result['contentID'];
$searchNewsletters[$y]['languageID'] = $result['languageID'];
$searchNewsletters[$y]['title'] = $result['title'];
$searchNewsletters[$y]['text'] = $result['text'];
if ($result['link'] == 'release') {
$searchNewsletters[$y]['link'] = Cible_FunctionsCategories::getPagePerCategoryView(0, 'details_release', 8) . "/ID/" . $result['contentID'];
} else {
$searchNewsletters[$y]['link'] = Cible_FunctionsCategories::getPagePerCategoryView(0, 'details_article', 8) . "/ID/" . $result['contentID'];
}
$y++;
$searchCount++;
array_splice($searchResult, $i, 1);
} else {
$i++;
}
}
$this->view->assign('searchNewsletters', $searchNewsletters);
/* * *************************** */
/* * ********* GALLERY ************* */
$moduleID = 9;
$i = 0;
$y = 0;
$searchGalleries = array();
$galleryID = array();
foreach ($searchResult as $result) {
if ($result['moduleID'] == $moduleID && $result['languageID'] == $languageID) {
$link = Cible_FunctionsCategories::getPagePerCategoryView($result['pageID'], 'details', 9);
if ($link != '' && !in_array($result['contentID'], $galleryID)) {
$searchGalleries[$y]['moduleID'] = $result['moduleID'];
$searchGalleries[$y]['pageID'] = $result['pageID'];
$searchGalleries[$y]['contentID'] = $result['contentID'];
$searchGalleries[$y]['languageID'] = $result['languageID'];
$searchGalleries[$y]['title'] = $result['title'];
$searchGalleries[$y]['text'] = $result['text'];
$galleryID[] = $result['contentID'];
/*
if($result['link'] == 'image')
$searchGalleries[$y]['link'] = $link."/ID/{$result['pageID']}";
else
$searchGalleries[$y]['link'] = $link."/ID/{$result['contentID']}";
*/
$searchGalleries[$y]['link'] = $link . "/ID/{$result['contentID']}";
$y++;
$searchCount++;
}
array_splice($searchResult, $i, 1);
} else {
$i++;
}
}
$this->view->assign('searchGalleries', $searchGalleries);
$this->view->assign('searchCount', $searchCount);
}
