public function getXMLFile($path = "", $lang = "") { $moduleID = 14; $db = Zend_Registry::get('db'); $xmlString = ""; $arrayForXML = array(); $productCollection = new ProductsCollection(array('lang' => $lang)); $select2 = $db->select()->distinct()->from('Blocks')->join('BlocksIndex', 'BlocksIndex.BI_BlockID = Blocks.B_ID')->join('ModuleCategoryViewPage', 'ModuleCategoryViewPage.MCVP_PageID = Blocks.B_PageID')->join('ModuleViews', 'ModuleViews.MV_ID = ModuleCategoryViewPage.MCVP_ViewID')->join('PagesIndex', 'PagesIndex.PI_PageID = ModuleCategoryViewPage.MCVP_PageID')->where('Blocks.B_ModuleID = ?', $moduleID)->where('PagesIndex.PI_LanguageID = ?', $lang)->where('ModuleCategoryViewPage.MCVP_ModuleID = ?', $moduleID)->where('Blocks.B_Online = 1')->where('BlocksIndex.BI_LanguageID =?', $lang)->order('Blocks.B_Position ASC'); $Rows = $db->fetchAll($select2); foreach ($Rows as $row) { $details_page = $row['PI_PageIndex']; $list_page = Cible_FunctionsCategories::getPagePerCategoryView($row['MCVP_CategoryID'], 'list', $moduleID, $lang); if (in_array($row['MV_Name'], $this->_specificAction)) { $productArray = $productCollection->getProductsUrl(); foreach ($productArray as $product) { $arrayURL = array(); array_push($arrayURL, $path . "/" . $details_page . "/" . $product); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); } } } return $arrayForXML; }
public function __construct($options = null) { parent::__construct($options); $moduleID = -1; $moduleName = ''; if (!empty($options['moduleID'])) { $moduleID = $options['moduleID']; $moduleName = Cible_FunctionsModules::getModuleNameByID($moduleID); } // input text for the title of the text module $categoryTitle = new Zend_Form_Element_Text('Title'); $categoryTitle->setLabel($this->getView()->getCibleText('form_category_title_label') . '*')->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty', true, array('messages' => array('isEmpty' => $this->_view->getCibleText('validation_message_empty_field'))))->setAttrib('class', 'stdTextInput'); $this->addElement($categoryTitle); $categoryDescription = new Zend_Form_Element_Text('WordingShowAllRecords'); $categoryDescription->setLabel($this->_view->getCibleText('form_category_view_all_label')); $this->addElement($categoryDescription); $views = Cible_FunctionsCategories::getCategoryViews($moduleID); foreach ($views as $view) { $pickerName = $view['MV_Name']; $controllerName = new Zend_Form_Element_Text("{$pickerName}_controllerName"); $controllerName->setLabel($this->getView()->getCibleText("form_select_option_view_{$moduleName}_{$pickerName}"))->setAttrib('onfocus', "openPagePicker('page-picker-{$pickerName}');"); $this->addElement($controllerName); $pagePicker = new Cible_Form_Element_PagePicker("{$pickerName}_pageID", array('associatedElement' => "{$pickerName}_controllerName", 'onclick' => "javascript:closePagePicker(\"page-picker-{$pickerName}\")")); $pagePicker->setLabel($this->_view->getCibleText('form_category_associated_page_label')); $pagePicker->setDecorators(array('ViewHelper', array(array('row' => 'HtmlTag'), array('tag' => 'dd', 'class' => "page-picker", 'id' => "page-picker-{$pickerName}")))); $this->addElement($pagePicker); } $module = new Zend_Form_Element_Hidden('ModuleID'); $module->setValue($moduleID)->removeDecorator('label')->removeDecorator('DtDdWrapper'); $this->addElement($module); }
public function getXMLFile($path = "", $lang = "") { $moduleID = 2; $db = Zend_Registry::get('db'); $xmlString = ""; $arrayForXML = array(); $select2 = $db->select()->distinct()->from('Blocks')->join('BlocksIndex', 'BlocksIndex.BI_BlockID = Blocks.B_ID')->join('ModuleCategoryViewPage', 'ModuleCategoryViewPage.MCVP_PageID = Blocks.B_PageID')->join('ModuleViews', 'ModuleViews.MV_ID = ModuleCategoryViewPage.MCVP_ViewID')->join('PagesIndex', 'PagesIndex.PI_PageID = ModuleCategoryViewPage.MCVP_PageID')->where('Blocks.B_ModuleID = ?', $moduleID)->where('PagesIndex.PI_LanguageID = ?', $lang)->where('ModuleCategoryViewPage.MCVP_ModuleID = ?', $moduleID)->where('Blocks.B_Online = 1')->where('BlocksIndex.BI_LanguageID =?', $lang)->order('Blocks.B_Position ASC'); $Rows = $db->fetchAll($select2); foreach ($Rows as $row) { if (in_array($row['MV_Name'], $this->_specificAction)) { $select3 = $db->select()->distinct()->from('NewsIndex')->join('NewsData', 'NewsIndex.NI_NewsDataID = NewsData.ND_ID')->where('NewsIndex.NI_Status = 1')->where('NewsIndex.NI_LanguageID =?', $lang)->order('NewsData.ND_ReleaseDate DESC'); $NewsRows = $db->fetchAll($select3); foreach ($NewsRows as $NewsRow) { $details_page = Cible_FunctionsCategories::getPagePerCategoryView($row['MCVP_CategoryID'], 'details', $moduleID, $lang); $arrayURL = array(); array_push($arrayURL, $path . "/" . $details_page . "/" . $NewsRow['ND_ReleaseDate'] . "/" . $NewsRow['NI_ValUrl']); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); } } } return $arrayForXML; }
private function _newAccountClient() { $confirm_page = Zend_Registry::get('absolute_web_root') . "/" . Cible_FunctionsCategories::getPagePerCategoryView(0, 'confirm_email', $this->_moduleId, $this->_data['language']) . "/email/{$this->_data['email']}/validateNumber/{$this->_data['validatedEmail']}"; $this->_message = str_replace('##validated_email_link##', $confirm_page, $this->_message); $this->_message = str_replace('##siteName##', $this->_siteName, $this->_message); foreach ($this->_data as $key => $value) { $search = '##' . $key . '##'; $this->_message = str_replace($search, $value, $this->_message); } $this->_emailRenderData['message'] = $this->_message; }
public function editCategoriesAction() { if ($this->view->aclIsAllowed($this->view->current_module, 'edit')) { $id = $this->_getParam('ID'); $categoriesObject = new CategoriesObject(); $options = array('moduleID' => Cible_FunctionsModules::getModuleIDByName($this->view->current_module), 'cancelUrl' => "{$this->view->baseUrl()}/{$this->view->current_module}/index/list-categories/"); $form = new FormCategory($options); $this->view->assign('form', $form); if ($this->_request->isPost()) { $formData = $this->_request->getPost(); if ($form->isValid($formData)) { // save $categoriesObject->save($id, $formData, $this->_currentEditLanguage); $allViews = Cible_FunctionsCategories::getCategoryViews($this->_moduleID); $views = Cible_FunctionsCategories::getCategoryViews($this->_moduleID, $id); $reference_views = array(); foreach ($views as $view) { $reference_views[$view['MV_ID']] = $view; } $views = $reference_views; $this->view->dump($views); foreach ($allViews as $view) { $this->view->dump($view); $data = array('MCVP_ModuleID' => $this->_moduleID, 'MCVP_CategoryID' => $id, 'MCVP_ViewID' => $view['MV_ID'], 'MCVP_PageID' => $formData["{$view['MV_Name']}_pageID"]); if (!empty($formData["{$view['MV_Name']}_pageID"])) { if (isset($views[$view['MV_ID']]) && isset($views[$view['MV_ID']]['MCVP_ID'])) { $this->_db->update('ModuleCategoryViewPage', $data, "MCVP_ID = '{$views[$view['MV_ID']]['MCVP_ID']}'"); } else { $this->_db->insert('ModuleCategoryViewPage', $data); } } } $this->_redirect("{$this->view->current_module}/index/list-categories/"); } else { $formData = $this->_request->getPost(); $form->populate($formData); } } else { $data = $categoriesObject->populate($id, $this->_currentEditLanguage); $views = Cible_FunctionsCategories::getCategoryViews($this->_moduleID, $id); if ($views) { foreach ($views as $view) { if (!empty($view['MCVP_PageID'])) { $data["{$view['MV_Name']}_pageID"] = $view['MCVP_PageID']; $data["{$view['MV_Name']}_controllerName"] = $view['PI_PageIndex']; } } } $form->populate($data); } } }
public function getXMLFile($path = "", $lang = "") { $action_infolettre = "details_release"; $action_article = "details_article"; $moduleID = 8; $db = Zend_Registry::get('db'); $xmlString = ""; $arrayForXML = array(); $selectY = "SELECT DISTINCT `ModuleViews`.`MV_Name` FROM `Blocks`\r\n INNER JOIN `BlocksIndex` ON BlocksIndex.BI_BlockID = Blocks.B_ID\r\n INNER JOIN `ModuleCategoryViewPage` ON ModuleCategoryViewPage.MCVP_PageID = Blocks.B_PageID\r\n INNER JOIN `ModuleViews` ON ModuleViews.MV_ID = ModuleCategoryViewPage.MCVP_ViewID\r\n INNER JOIN `PagesIndex` ON PagesIndex.PI_PageID = ModuleCategoryViewPage.MCVP_PageID\r\n WHERE (Blocks.B_ModuleID = 8) AND (PagesIndex.PI_LanguageID ='" . $lang . "')\r\n AND (ModuleCategoryViewPage.MCVP_ModuleID = 8) AND (Blocks.B_Online = 1)\r\n AND (BlocksIndex.BI_LanguageID ='" . $lang . "') ORDER BY `Blocks`.`B_Position` ASC"; $Rows = $db->fetchAll($selectY); foreach ($Rows as $row) { if (in_array($row['MV_Name'], $this->_specificAction)) { if ($row['MV_Name'] == $action_infolettre) { $arrayURL = array(); $select3 = $db->select()->distinct()->from('Newsletter_Releases')->where('NR_Online = 1')->where('NR_Date < ?', date("Y-m-d H:m:s"))->where('NR_LanguageID =?', $lang); $NewsRows = $db->fetchAll($select3); foreach ($NewsRows as $NewsRow) { $details_page = Cible_FunctionsCategories::getPagePerCategoryView($NewsRow['NR_CategoryID'], 'details_release', $moduleID, $lang); array_push($arrayURL, $path . "/" . $details_page . "/" . $NewsRow['NR_Date'] . "/" . $NewsRow['NR_ValUrl']); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); //echo $NewsRow['NR_ValUrl']; } } else { if ($row['MV_Name'] == $action_article) { $select3 = $db->select()->distinct()->from('Newsletter_Releases')->join('Newsletter_Articles', 'Newsletter_Articles.NA_ReleaseID = Newsletter_Releases.NR_ID')->where('NR_Online = 1')->where('NR_Date < ?', date("Y-m-d H:m:s"))->where('NR_LanguageID =?', $lang); $NewsRows = $db->fetchAll($select3); foreach ($NewsRows as $NewsRow) { $arrayURL = array(); $details_page = Cible_FunctionsCategories::getPagePerCategoryView($NewsRow['NR_CategoryID'], 'details_article', $moduleID, $lang); array_push($arrayURL, $path . "/" . $details_page . "/" . $NewsRow['NR_Date'] . "/" . $NewsRow['NA_ValUrl']); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); } } } } } return $arrayForXML; }
public function listAction() { $this->view->title = "Liste des galleries"; if ($this->view->aclIsAllowed('gallery', 'manage', true)) { // variables $this->view->params = $this->_getAllParams(); $blockID = $this->_getParam('blockID'); $pageID = $this->_getParam('pageID'); $baseDir = $this->view->baseUrl(); $base = substr($baseDir, 0, strpos($baseDir, "/{$this->_config->document_root}/")); if ($blockID != '') { $blockParameters = Cible_FunctionsBlocks::getBlockParameters($blockID); $this->_categoryID = $blockParameters[0]['P_Value']; } $this->view->headScript()->appendFile($baseDir . '/js/jquery.json-1.3.min.js'); $this->view->headScript()->appendFile($baseDir . '/js/tiny_mce/plugins/imagemanager/js/mcimagemanager.js'); //get category details $this->view->categoryDetails = Cible_FunctionsCategories::getCategoryDetails($this->_categoryID); // get all galleries $galleriesSelect = new Galleries(); $select = $galleriesSelect->select()->setIntegrityCheck(false)->from('Galleries')->join('GalleriesIndex', 'G_ID = GI_GalleryID')->join('Images', 'G_ImageID = I_ID')->where('GI_LanguageID = ?', $this->_defaultEditLanguage)->order('G_Position')->order('GI_Title'); if ($this->_categoryID > 0) { $select->where('G_CategoryID = ?', $this->_categoryID); } $galleriesData = $galleriesSelect->fetchAll($select); $this->view->galleriesData = $galleriesData->toArray(); $this->view->imagesAjaxLink = "{$baseDir}/gallery/index/list-all-images"; if ($blockID != '') { $this->view->imagesEditLink = "{$baseDir}/gallery/image/edit/blockID/{$blockID}"; } else { $this->view->imagesEditLink = "{$baseDir}/gallery/image/edit"; } $this->view->imagesDeleteLink = "{$baseDir}/gallery/image/delete"; /* $galleriesImages = new GalleriesImages(); $select = $galleriesImages->select()->setIntegrityCheck(false) ->from('Galleries_Images') ->join('ImagesIndex', 'II_ImageID = GI_ImageID') ->where('GI_GalleryID = ?', $galleryID); $ImagesData = $galleriesImages->fetchAll($select); */ } }
public function getXMLFile($path = "", $lang = "") { $moduleID = 9; $db = Zend_Registry::get('db'); $xmlString = ""; $arrayForXML = array(); $select2 = $db->select()->distinct()->from('Blocks')->join('BlocksIndex', 'BlocksIndex.BI_BlockID = Blocks.B_ID')->join('ModuleCategoryViewPage', 'ModuleCategoryViewPage.MCVP_PageID = Blocks.B_PageID')->join('ModuleViews', 'ModuleViews.MV_ID = ModuleCategoryViewPage.MCVP_ViewID')->join('PagesIndex', 'PagesIndex.PI_PageID = ModuleCategoryViewPage.MCVP_PageID')->where('Blocks.B_ModuleID = ?', $moduleID)->where('PagesIndex.PI_LanguageID = ?', $lang)->where('ModuleCategoryViewPage.MCVP_ModuleID = ?', $moduleID)->where('Blocks.B_Online = 1')->where('BlocksIndex.BI_LanguageID =?', $lang)->order('Blocks.B_Position ASC'); $Rows = $db->fetchAll($select2); foreach ($Rows as $row) { if (in_array($row['MV_Name'], $this->_specificAction)) { $select3 = $db->select()->distinct()->from('GalleriesIndex')->join('Galleries', 'GalleriesIndex.GI_GalleryID = Galleries.G_ID')->where('GalleriesIndex.GI_LanguageID =?', $lang); $NewsRows = $db->fetchAll($select3); foreach ($NewsRows as $NewsRow) { $details_page = Cible_FunctionsCategories::getPagePerCategoryView($row['MCVP_CategoryID'], 'details', $moduleID, $lang); $arrayURL = array(); array_push($arrayURL, $path . "/" . $details_page . "/" . $NewsRow['GI_ValUrl']); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); $select4 = $db->select()->distinct()->from('Galleries_Images')->where('Galleries_Images.GI_GalleryID=?', $NewsRow['G_ID']); $RowsGalleryImages = $db->fetchAll($select4); $iii = 0; foreach ($RowsGalleryImages as $RowsGalleryImage) { $arrayURL = array(); array_push($arrayURL, $path . "/" . $details_page . "/" . $NewsRow['GI_ValUrl'] . "#!prettyPhoto[gallery1]/" . $iii . "/"); array_push($arrayURL, "0.5"); array_push($arrayURL, "weekly"); array_push($arrayURL, date("Y-m-d H:m:s")); array_push($arrayForXML, $arrayURL); $iii++; } } } } return $arrayForXML; }
public function listAction() { $blockID = $this->_getParam('BlockID'); $blockParameters = Cible_FunctionsBlocks::getBlockParameters($blockID); $categoryID = $blockParameters[0]['P_Value']; $galleriesSelect = new Galleries(); $select = $galleriesSelect->select()->setIntegrityCheck(false)->from('Galleries')->join('GalleriesIndex', 'GI_GalleryID = G_ID AND GI_LanguageID = ' . Zend_Registry::get("languageID"))->join('Images', 'I_ID = G_ImageID')->where('G_CategoryID = ?', $categoryID)->where('G_Online = 1')->order('G_Position'); $galleriesData = $galleriesSelect->fetchAll($select)->toArray(); $config = Zend_Registry::get('config')->toArray(); $thumbMaxHeight = $config['gallery']['image']['thumb']['maxHeight']; $thumbMaxWidth = $config['gallery']['image']['thumb']['maxWidth']; $i = 0; foreach ($galleriesData as $gallery) { $galleriesData[$i]['I_ThumbLink'] = str_replace($gallery['I_OriginalLink'], $thumbMaxWidth . 'x' . $thumbMaxHeight . '_' . $gallery['I_OriginalLink'], $gallery['I_OriginalLink']); $galleriesData[$i]['linkDetails'] = Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details', 9); $i++; } // var_dump($galleriesData); $details_page = Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details', 9); $this->view->assign('details_page', $details_page); $this->view->assign('galleriesData', $galleriesData); }
public function listarchivesAction() { // Newsletter ID and Category ID $categoryID = $this->_getParam('categoryID'); $newsletterID = $this->_getParam('newsletterID'); $back_to_newsletter = !empty($newsletterID) ? "/ID/{$newsletterID}" : ''; // Get the Newsletter ID to dont show $newsletterSelect = new NewsletterReleases(); $select = $newsletterSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID', array())->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID', array())->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID', array())->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID', array())->where('CI_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_Online = ?', 1)->order('NR_Date DESC'); $newsletterData = $newsletterSelect->fetchRow($select); $actualNewsletterOnline = $newsletterData['NR_ID']; if ($actualNewsletterOnline != '') { if (empty($categoryID) || $categoryID == '') { $categoryID = $newsletterData['NR_CategoryID']; } //get all releases exept the one online $releasesSelect = new NewsletterReleases(); $select = $releasesSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')->join('Status', 'Newsletter_Releases.NR_Online = Status.S_ID')->where('CI_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_Online = ?', 1)->where('NR_CategoryID = ?', $categoryID)->where('NR_ID <> ?', $actualNewsletterOnline)->order('NR_Date DESC'); $releasesData = $releasesSelect->fetchAll($select); $this->view->assign('listArchives', $releasesData); $this->view->assign('subscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'subscribe', 8)); $this->view->assign('unsubscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'unsubscribe', 8)); //$this->view->assign('detailsRelease', $this->view->baseUrl()."/".Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details_release', 8)); $this->view->assign('detailsRelease', Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details_release', 8)); //$this->view->assign('back_to_release', Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details_release', 8)); $this->view->assign('back_to_release', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'details_release', 8) . $back_to_newsletter); $this->view->assign('archivesLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($categoryID, 'list_archives', 8) . '/categoryID/' . $categoryID); } else { $this->view->assign('listArchives', array()); $blockID = $this->_getParam('BlockID'); $blockParams = Cible_FunctionsBlocks::getBlockParameters($blockID)->toArray(); $newsletterCategoryID = $blockParams[0]['P_Value']; $this->view->assign('subscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'subscribe', 8)); $this->view->assign('unsubscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'unsubscribe', 8)); $this->view->assign('back_to_release', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8) . $back_to_newsletter); $this->view->assign('archivesLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'list_archives', 8) . '/categoryID/' . $newsletterCategoryID); } }
public function listpromosAction() { $blockID = $this->_request->getParam('BlockID'); if ($blockID) { $this->_blockID = $blockID; $params = Cible_FunctionsBlocks::getBlockParameters($blockID); } foreach ($params as $param) { $blockParams[$param['P_Number']] = $param['P_Value']; } $this->view->assign('autoPlay', $blockParams[2]); $this->view->assign('delais', $blockParams[3]); $this->view->assign('transition', $blockParams[4]); $this->view->assign('navi', $blockParams[5]); $this->view->assign('effect', $blockParams[6]); if ($blockParams[7]) { $category = Cible_FunctionsCategories::getCategoryDetails($blockParams[7]); $this->view->assign('promoLbl', $category['CI_Title']); } else { $this->view->assign('promoLbl', $this->view->getClientText('catalog_promo_default_label_render')); } $oPromo = new PromosObject(); $promos = $oPromo->getPromosByCategory($blockParams[7]); $this->view->assign('promos', $promos); }
public function getCategoriesList() { $categories = array(); $data = Cible_FunctionsCategories::getRootCategoriesList($this->_moduleId); foreach ($data as $category) { $categories[$category['C_ID']] = $category; } return $categories; }
/** * Sends mass mailing. * Prepares data and tests the recipients list before sendig emails. * * @param int $releaseID The release of the the newsletter to send. * * @return array Contains data corresponding to the send result. */ public function sendMassMailingAction($releaseID = null) { $this->disableView(); if (!$releaseID) { $releaseID = $_REQUEST['releaseID']; } // $releaseID = $this->view->params['releaseID']; // 1- Get all newsletter to send $dateTimeNow = date('Y-m-d H:i:s'); $newsletterSelect = new NewsletterReleases(); $select = $newsletterSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID')->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID')->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID')->where('CI_LanguageID = NR_LanguageID')->where('NMI_LanguageID = NR_LanguageID')->where('NR_Status <> 1')->where('NR_ID = ?', $releaseID); $newsletterData = $newsletterSelect->fetchAll($select); foreach ($newsletterData as $release) { $listSent = array(); $listDest = array(); $listIds = array(); $mailLog = array(); $date = new Zend_Date($release['NR_Date'], null, Zend_Registry::get('languageSuffix') == 'fr' ? 'fr_CA' : 'en_CA'); $date_string = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_LONG_NO_DAY, '.'); $date_string_url = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_SQL, '-'); $releaseLanguage = $release['NR_LanguageID']; $this->view->assign('languageRelease', $releaseLanguage); $filteredData = $this->_countFilterMembers($release['NR_CollectionFiltersID'], $releaseLanguage); $members = $filteredData['members']; $selection = $filteredData['selection']; $dateTimeStart = date('Y-m-d H:i:s'); $member_count = 0; $stats = array('action' => 'set', 'sentTo' => 0, 'targetedTotal' => 0); if ($release['NR_Status'] == 0 || $release['NR_Status'] == 3) { //Send to all recipient even if they have already received it $member_count = count($members); } elseif ($release['NR_Status'] == 2) { $member_count = count($members); $stats['action'] = 'increment'; //Send to recipient who have not already received it $alreadyMembersRecievedSelect = new NewsletterReleasesMembers(); $select = $alreadyMembersRecievedSelect->select()->where('NRM_ReleaseID = ?', $release['NR_ID']); $alreadyMembersRecievedData = $alreadyMembersRecievedSelect->fetchAll($select); $already_received_count = count($alreadyMembersRecievedData); $membersTmp = array(); for ($i = 0; $i < $member_count; $i++) { $received = "false"; for ($j = 0; $j < $already_received_count; $j++) { if ($members[$i]['GP_MemberID'] == $alreadyMembersRecievedData[$j]['NRM_MemberID']) { $received = "true"; } } if ($received == "false") { array_push($membersTmp, $members[$i]); } } $members = $membersTmp; $member_count = count($members); } $stats['targetedTotal'] = $member_count; if (!empty($members) && $member_count > 0) { $newsletterArticlesSelect = new NewsletterArticles(); $select = $newsletterArticlesSelect->select(); $select->where('NA_ReleaseID = ?', $release['NR_ID'])->order('NA_ZoneID')->order('NA_PositionID'); $newsletterArticlesData = $newsletterArticlesSelect->fetchAll($select); $this->view->articles = $newsletterArticlesData->toArray(); $registry = Zend_Registry::getInstance()->set('format', 'email'); $config = Zend_Registry::get('config')->toArray(); $nbMax = $config['massMailing']['packof']; $sleep = $config['massMailing']['sleep']; $server = $config['massMailing']['server']; $i = 0; set_time_limit(0); $emailValidator = new Zend_Validate_EmailAddress(); $sentToCount = 0; $failedEmailAddress = array(); for ($k = 0; $k < $member_count; $k++) { try { if ($i == $nbMax) { $protocol->quit(); $protocol->disconnect(); sleep($sleep); $i = 0; } if ($i == 0) { $transport = new Zend_Mail_Transport_Smtp(); $protocol = new Zend_Mail_Protocol_Smtp($server); $protocol->connect(); $protocol->helo($server); $transport->setConnection($protocol); } $protocol->rset(); if ($emailValidator->isValid($members[$k]['GP_Email'])) { $date = new Zend_Date($release['NR_Date'], null, Zend_Registry::get('languageSuffix') == 'fr' ? 'fr_CA' : 'en_CA'); $date_string = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_LONG_NO_DAY, '.'); $date_string_url = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_SQL, '-'); $newsletterCategoryID = $release['NR_CategoryID']; $this->view->assign('unsubscribeLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'unsubscribe', 8)); $this->view->assign('subscribeLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'subscribe', 8, $releaseLanguage)); $this->view->assign('archiveLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'list_archives', 8, $releaseLanguage)); //$this->view->assign('details_release', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8) . "/ID/" . $release['NR_ID']); $this->view->assign('details_release', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8, $releaseLanguage) . "/" . $date_string_url . "/" . $release['NR_Title']); $this->view->assign('details_page', Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_article', 8)); $this->view->assign('isOnline', $release['NR_Online']); $this->view->assign('newsletterID', $release['NR_ID']); $this->view->assign('memberId', $members[$k]['GP_MemberID']); $this->view->assign('moduleId', $this->_moduleID); $this->view->assign('dateString', $date_string); $this->view->assign('parutionDate', $date_string_url); $bodyText = $this->view->render($release['NM_DirectoryEmail']); $salutationsSelect = new Salutations(); $select = $salutationsSelect->select()->setIntegrityCheck(false); $salutationId = $members[$k]['GP_Salutation']; if (is_null($salutationId)) { $salutationId = 0; } $select->from('Salutations')->join('Static_Texts', 'ST_Identifier = S_StaticTitle')->where('ST_LangID = ?', Zend_Registry::get("languageID"))->where('S_ID = ?', $salutationId); $salutationsData = $salutationsSelect->fetchRow($select); $bodyText = str_replace('#prenom#', $members[$k]['GP_FirstName'], $bodyText); $bodyText = str_replace('#nom#', $members[$k]['GP_LastName'], $bodyText); $bodyText = str_replace('#courtoisie#', $salutationsData['ST_Value'], $bodyText); //$newsletterData['NR_AfficherTitre'] = $form->getValue('NR_AfficherTitre'); $newsletterAfficherTitre = $release['NR_AfficherTitre']; $newsletterTextIntro = $release['NR_TextIntro']; $newsletterTextIntro = str_replace('##prenom##', $members[$k]['GP_FirstName'], $newsletterTextIntro); $newsletterTextIntro = str_replace('##nom##', $members[$k]['GP_LastName'], $newsletterTextIntro); $newsletterTextIntro = str_replace('##salutation##', $salutationsData['ST_Value'], $newsletterTextIntro); $this->view->intro = $newsletterTextIntro; $this->view->newsletterAfficherTitre = $newsletterAfficherTitre; $mail = new Zend_Mail(); $mail->setBodyHtml($bodyText); $mail->setFrom($release['NM_FromEmail'], $release['NMI_FromName']); $mail->addTo($members[$k]['GP_Email']); $mail->setSubject($release['NR_Title']); if (!$mail->send()) { array_push($failedEmailAddress, array('fname' => $members[$k]['GP_FirstName'], 'lname' => $members[$k]['GP_LastName'], 'email' => $members[$k]['GP_Email'])); } $sentToCount++; $releaseMember = new NewsletterReleasesMembers(); $releaseMemberData = $releaseMember->createRow(); $releaseMemberData['NRM_ReleaseID'] = $release['NR_ID']; $releaseMemberData['NRM_MemberID'] = $members[$k]['GP_MemberID']; $releaseMemberData['NRM_DateTimeReceived'] = date('Y-m-d H:i:s'); $insert = $releaseMemberData->save(); $i++; } else { array_push($failedEmailAddress, array('fname' => $members[$k]['GP_FirstName'], 'lname' => $members[$k]['GP_LastName'], 'email' => $members[$k]['GP_Email'])); } } catch (Exception $exc) { $index = $releaseID . '-'; $index .= $k + 1 . '-'; $index .= $members[$k]['GP_MemberID']; $mailLog[$index]['message'] = $exc->getCode() . '-' . $exc->getFile() . '-' . $exc->getLine(); $mailLog[$index]['log'] = $protocol->getResponse(); $columnsMap = array('NEL_IdIndex' => 'NEL_IdIndex', 'NEL_CodeFileLine' => 'NEL_CodeFileLine', 'NEL_Response' => 'NEL_Response', 'NEL_Timestamp' => 'timestamp'); $writer = new Zend_Log_Writer_Db($this->_db, 'Newsletter_ErrorsLog', $columnsMap); $oZLog = new Zend_Log($writer); $oZLog->setEventItem('NEL_IdIndex', $index); $oZLog->setEventItem('NEL_CodeFileLine', $mailLog[$index]['message']); $oZLog->setEventItem('NEL_Response', $mailLog[$index]['log'][0]); $oZLog->log('errors', 4); } } $protocol->quit(); $protocol->disconnect(); } else { echo Zend_Json::encode(array('sentTo' => '0', 'targetedTotal' => '0', 'failedEmail' => array(), 'select' => $selection)); break; } $stats['sentTo'] = $sentToCount; $dateTimeEnd = date('Y-m-d H:i:s'); $release['NR_MailingDateTimeStart'] = $dateTimeStart; $release['NR_MailingDateTimeEnd'] = $dateTimeEnd; $release['NR_SendTo'] = $stats['action'] == 'set' ? $stats['sentTo'] : $release['NR_SendTo'] + $stats['sentTo']; $release['NR_TargetedTotal'] = $stats['action'] == 'set' ? $stats['targetedTotal'] : $release['NR_TargetedTotal'] + $stats['targetedTotal']; $release['NR_Status'] = 1; $release->save(); if (count($failedEmailAddress) > 0) { $this->_recordEmails($failedEmailAddress, $releaseID); } $this->_stats = array('invalidEmails' => count($failedEmailAddress), 'errors' => count($mailLog), 'totalToSend' => $stats['targetedTotal'], 'totalSent' => $stats['sentTo']); if ($this->_isXmlHttpRequest) { array_push($listSent, $release['NR_Title']); array_push($listIds, $release['NR_ID']); array_push($listDest, $release['NR_AdminEmail']); $data = array('list' => $listSent, 'dest' => $listDest, 'ids' => $listIds); $this->_adminNotification($data); $this->_logSending($data); } echo Zend_Json::encode(array('sentTo' => $stats['sentTo'], 'targetedTotal' => $stats['targetedTotal'], 'failedEmail' => $failedEmailAddress, 'select' => $selection)); exit; } // If all the newsletter have a status = 1, we don't pass through the foreach // So redirect the action to the newsletter // echo(Zend_Json::encode(array('sentTo' => '0', 'targetedTotal' => '0', 'failedEmail' => array(), 'select' => ''))); // exit; }
public function listall3columnsAction() { $_blockID = $this->_request->getParam('BlockID'); $newsObject = new NewsCollection($_blockID); $details_page = Cible_FunctionsCategories::getPagePerCategoryView($newsObject->getBlockParam('1'), 'details'); $this->view->assign('details_page', $details_page); $news = $newsObject->getList(); $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($news)); $paginator->setItemCountPerPage($newsObject->getBlockParam('2')); $paginator->setCurrentPageNumber($this->_request->getParam('page')); $this->view->assign('params', $newsObject->getBlockParams()); $this->view->assign('paginator', $paginator); }
public function calendrierAction() { $_blockID = $this->_request->getParam('BlockID'); $this->view->BlockID = $_blockID; $events1 = new EventsCollection($_blockID); $details_page = Cible_FunctionsCategories::getPagePerCategoryView($events1->getBlockParam('1'), 'details'); $detail_page = $this->view->baseUrl() . '/' . $details_page . "/"; if ($this->_isXmlHttpRequest) { $_year = $this->_request->getParam('Year'); $_month = $this->_request->getParam('Month'); $eventsObject = new EventsCollection($_blockID); $events = $eventsObject->getListYearMonth($_year, $_month, null); $responseObject = array(); $resultObject = array(); foreach ($events as $key => $result) { foreach ($result['dates'] as $keydate1 => $row1) { $date_string = ''; $date_stringURL = ''; $resultObject['EventID'] = $result['ED_ID']; $resultObject['Title'] = strip_tags(utf8_encode($result['EI_Title'])); $resultObject['Description'] = strip_tags($result['EI_Brief']); $resultObject['StartDate'] = $row1['EDR_StartDate']; $resultObject['EndDate'] = $row1['EDR_EndDate']; //$resultObject['URL'] = $this->baseUrl() . '/' . $this->details_page . "/" . $date_string_url . "/" . $event['EI_ValUrl']; foreach ($result['dates'] as $keydate => $row) { $startDate = new Zend_Date($row['EDR_StartDate'], null, 'fr_CA'); $endDate = new Zend_Date($row['EDR_EndDate'], null, 'fr_CA'); $date_stringURL = sprintf("%d-%d-%d", $startDate->get(Zend_Date::DAY), $startDate->get(Zend_Date::MONTH), $startDate->get(Zend_Date::YEAR)); if (!empty($date_string)) { $date_string .= ' et '; } if ($startDate->get(Zend_Date::MONTH) == $endDate->get(Zend_Date::MONTH) && $startDate->get(Zend_Date::YEAR) == $endDate->get(Zend_Date::YEAR)) { if ($startDate->get(Zend_Date::DAY) != $endDate->get(Zend_Date::DAY)) { $date_string .= sprintf("%d-%d %s %d", $startDate->get(Zend_Date::DAY), $endDate->get(Zend_Date::DAY), $startDate->get(Zend_Date::MONTH_NAME), $startDate->get(Zend_Date::YEAR)); } else { $date_string .= sprintf("%d %s %d", $startDate->get(Zend_Date::DAY), $startDate->get(Zend_Date::MONTH_NAME), $startDate->get(Zend_Date::YEAR)); } } else { $date_string .= sprintf("%d %s %d au %d %s %d", $startDate->get(Zend_Date::DAY), $startDate->get(Zend_Date::MONTH_NAME), $startDate->get(Zend_Date::YEAR), $endDate->get(Zend_Date::DAY), $endDate->get(Zend_Date::MONTH_NAME), $endDate->get(Zend_Date::YEAR)); } } $resultObject['URL'] = $detail_page . $date_stringURL . "/" . $result['EI_ValUrl']; $resultObject['DateComplete'] = utf8_encode($date_string); $resultObject['CellsIds'] = ""; array_push($responseObject, $resultObject); } } $this->getHelper('viewRenderer')->setNoRender(); echo json_encode($responseObject); } }
public function listApprobationRequestAction() { if ($this->view->aclIsAllowed('LecteurRss', 'publish')) { $tables = array('LecteurRssData' => array('ND_ID', 'ND_CategoryID', 'ND_ReleaseDate'), 'LecteurRssIndex' => array('NI_LecteurRssDataID', 'NI_LanguageID', 'NI_Title', 'NI_Status'), 'CategoriesIndex' => array('CI_Title')); $field_list = array('NI_Title' => array('width' => '400px'), 'CI_Title' => array(), 'ND_ReleaseDate' => array('width' => '120px')); $LecteurRss = new LecteurRssData(); $select = $LecteurRss->select()->from('LecteurRssData')->setIntegrityCheck(false)->join('LecteurRssIndex', 'LecteurRssData.ND_ID = LecteurRssIndex.NI_LecteurRssDataID')->joinRight('CategoriesIndex', 'LecteurRssData.ND_CategoryID = CategoriesIndex.CI_CategoryID')->joinRight('Languages', 'Languages.L_ID = LecteurRssIndex.NI_LanguageID')->where('LecteurRssData.ND_ToApprove = ?', 1)->where('LecteurRssIndex.NI_LanguageID = CategoriesIndex.CI_LanguageID')->order('NI_Title'); $options = array('disable-export-to-excel' => 'true', 'filters' => array('filter_1' => array('default_value' => null, 'associatedTo' => 'CI_Title', 'choices' => Cible_FunctionsCategories::getFilterCategories($this->_moduleID)), 'filter_2' => array('default_value' => null, 'associatedTo' => 'CI_LanguageID', 'choices' => Cible_FunctionsGeneral::getFilterLanguages())), 'action_panel' => array('width' => '50', 'actions' => array('edit' => array('label' => $this->view->getCibleText('button_edit'), 'url' => "{$this->view->baseUrl()}/LecteurRss/index/edit/LecteurRssID/%ID%/lang/%LANG%/approbation/true", 'findReplace' => array(array('search' => '%ID%', 'replace' => 'ND_ID'), array('search' => '%LANG%', 'replace' => 'L_Suffix')))))); $mylist = new Cible_Paginator($select, $tables, $field_list, $options); $this->view->assign('mylist', $mylist); } }
public function readAction() { $this->disableLayout(); $this->disableView(); $ressource_dir = dirname(dirname(__FILE__)) . '/ressources'; /* var_dump($this->_request); exit;*/ $feed = $this->_request->getParam('feed'); $catID = $this->_request->getParam('catID'); $feed = str_replace('.xml', "-{$catID}.xml", $feed); $rssLimit = Cible_FunctionsCategories::getRssItemsLimitPerCategory($catID); $langId = Cible_FunctionsGeneral::getLanguageID($this->_request->getParam('lang')); Zend_Registry::set('languageID', $langId); $lang = $this->_request->getParam('lang'); $feed_url = Zend_Registry::get('absolute_web_root') . "/{$this->_request->getParam('lang')}/{$this->_request->getParam('feed')}"; if (file_exists("{$ressource_dir}/{$lang}/{$feed}")) { $lastUpdate = new Zend_Date(filemtime("{$ressource_dir}/{$lang}/{$feed}")); $now = new Zend_Date(); } if (file_exists("{$ressource_dir}/{$lang}/{$feed}") && !$now->isLater($lastUpdate->addMinute($this->_config->rss->refresh->delay))) { $xml = file_get_contents("{$ressource_dir}/{$lang}/{$feed}"); } else { $file = fopen("{$ressource_dir}/{$lang}/{$feed}", "w"); $select = $this->_db->select(); $select->from('NewsData')->joinLeft('NewsIndex', 'NewsData.ND_ID = NewsIndex.NI_NewsDataID')->joinleft('CategoriesIndex', 'CategoriesIndex.CI_CategoryID = NewsData.ND_CategoryID')->joinleft('Categories', 'Categories.C_ID = NewsData.ND_CategoryID')->where('CategoriesIndex.CI_LanguageID = ?', $langId)->where('NewsIndex.NI_LanguageID = ?', $langId)->where('Categories.C_ID = ?', $catID)->where('Categories.C_ShowInRss = ?', 1)->order('ND_Date DESC')->limit($rssLimit); //die($select); $news = $this->_db->fetchAll($select); $feedPubDate = date("r", strtotime('now')); $xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>"; $xml .= "<rss version=\"2.0\">"; $xml .= "<channel>"; $xml .= "<title>" . $this->_config->site->title . "</title>"; $xml .= "<description>"; $xml .= str_replace('##SITE_NAME##', $this->_config->site->title, $this->view->getCibleText('rss_read_description_field_label')); $xml .= "</description>"; $xml .= "<lastBuildDate>{$feedPubDate}</lastBuildDate>"; $xml .= "<link>{$feed_url}</link>"; foreach ($news as $details) { if ($details['NI_Status'] == 1) { // Titres des nouvelles (FR) $title = str_replace("'", "'", $details['NI_Title']); $title = str_replace("<br>", "<br />", $title); $title = str_replace("&", "&", $title); // Textes des nouvelles (FR) $description = str_replace("'", "'", $this->KeepTextOnly($details["NI_Brief"])); $description = htmlspecialchars($description); $description = str_replace("<br>", "<br />", $description); $pubDate = date("r", strtotime($details["ND_ReleaseDate"])); $news_url = Zend_Registry::get('absolute_web_root') . '/' . Cible_FunctionsCategories::getPagePerCategoryView($details["ND_CategoryID"], 'details') . "/ID/{$details['ND_ID']}"; $xml .= "<item>"; $xml .= "<title>{$title}</title>"; $xml .= "<description>{$description}</description>"; $xml .= "<pubDate>{$pubDate}</pubDate>"; $xml .= "<guid>{$news_url}</guid>"; $xml .= "<link>{$news_url}</link>"; $xml .= "</item>"; } } $xml .= "</channel>"; $xml .= "</rss>"; fwrite($file, $xml); fclose($file); } $this->_response->setHeader('Content-Type', 'application/rss+xml'); echo $xml; }
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); }
public function listAllAction() { if ($this->view->aclIsAllowed('events', 'edit', true)) { // NEW LIST GENERATOR CODE // $tables = array('EventsData' => array('ED_ID', 'ED_CategoryID'), 'EventsIndex' => array('EI_EventsDataID', 'EI_LanguageID', 'EI_Title', 'EI_Status'), 'Status' => array('S_Code'), 'CategoriesIndex' => array('CI_Title')); $field_list = array('EI_Title' => array('width' => '300px'), 'CI_Title' => array(), 'S_Code' => array('width' => '80px', 'postProcess' => array('type' => 'dictionnary', 'prefix' => 'status_'))); $events = new EventsData(); $select = $events->select()->from('EventsData')->setIntegrityCheck(false)->join('EventsIndex', 'EventsData.ED_ID = EventsIndex.EI_EventsDataID')->join('Status', 'EventsIndex.EI_Status = Status.S_ID')->joinRight('CategoriesIndex', 'EventsData.ED_CategoryID = CategoriesIndex.CI_CategoryID')->joinRight('Categories', 'EventsData.ED_CategoryID = Categories.C_ID')->joinRight('Languages', 'Languages.L_ID = EventsIndex.EI_LanguageID')->where('EI_LanguageID = ?', $this->_defaultEditLanguage)->where('EventsIndex.EI_LanguageID = CategoriesIndex.CI_LanguageID')->where('C_ModuleID = ?', $this->_moduleID); //->order('EI_Title'); $options = array('commands' => array($this->view->link($this->view->url(array('controller' => 'index', 'action' => 'add')), $this->view->getCibleText('button_add_events'), array('class' => 'action_submit add'))), 'filters' => array('events-category-filter' => array('default_value' => null, 'associatedTo' => 'ED_CategoryID', 'choices' => Cible_FunctionsCategories::getFilterCategories($this->_moduleID)), 'events-status-filter' => array('label' => 'Filtre 2', 'default_value' => null, 'associatedTo' => 'S_Code', 'choices' => array('' => $this->view->getCibleText('filter_empty_status'), 'online' => $this->view->getCibleText('status_online'), 'offline' => $this->view->getCibleText('status_offline')))), 'action_panel' => array('width' => '50', 'actions' => array('edit' => array('label' => $this->view->getCibleText('button_edit'), 'url' => "{$this->view->baseUrl()}/events/index/edit/eventID/%ID%/lang/%LANG%/return/list-all/", 'findReplace' => array(array('search' => '%ID%', 'replace' => 'ED_ID'), array('search' => '%LANG%', 'replace' => 'L_Suffix'))), 'delete' => array('label' => $this->view->getCibleText('button_delete'), 'url' => "{$this->view->baseUrl()}/events/index/delete/eventID/%ID%/return/list-all/", 'findReplace' => array('search' => '%ID%', 'replace' => 'ED_ID'))))); $mylist = new Cible_Paginator($select, $tables, $field_list, $options); $this->view->assign('mylist', $mylist); } }
private function _buildData($orderOnly = false) { $url = Cible_FunctionsCategories::getPagePerCategoryView(0, 'list_collections', 14); $this->view->headLink()->appendStylesheet($this->view->locateFile('cart.css')); $account = Cible_FunctionsGeneral::getAuthentication(); if (!$account) { $this->_redirect($url); } $oMember = new MemberProfile(); $user = $oMember->findMember($account); $orderId = $this->_getParam('qr'); $oOrder = new OrderCollection(); if ($orderId) { $oOrder->setOrderId($orderId); } $oOrder->setUserId($user['member_id']); $oOrder->setOrderOnly($orderOnly); $select = $oOrder->getData(); return $select; }