public function indexAction() { $searchResult = Cible_FunctionsIndexation::indexationSearch(''); }
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); }