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);
             }
         }
     }
     /*         * ********************* */
 }
Exemple #2
0
 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);
             }
         }
     }
 }
Exemple #3
0
 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'));
             }
         }
     }
 }
Exemple #4
0
 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);
 }
Exemple #5
0
 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);
                 }
             }
         }
     }
     //}
 }
 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);
                 }
             }
         }
     }
 }
Exemple #7
0
 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);
         }
     }
 }
Exemple #8
0
 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'] : '');
     }
 }
Exemple #9
0
 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);
         }
     }
     //}
 }
Exemple #10
0
 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'));
         }
     }
 }