public function add($needFields = array(), $data = array(), $charset = 'UTF-8') { $index = new Zend_Search_Lucene(ZY_ROOT . '/index', true); $doc = new Zend_Search_Lucene_Document(); foreach ($needFields as $key => $field) { switch ($field) { case 'keywords': $doc->addField(Zend_Search_Lucene_Field::keyword($key, $data[$key], $charset)); break; case 'text': $doc->addField(Zend_Search_Lucene_Field::text($key, $data[$key], $charset)); break; case 'unindexed': $doc->addField(Zend_Search_Lucene_Field::unindexed($key, $data[$key], $charset)); break; default: $doc->addField(Zend_Search_Lucene_Field::$field($key, $data[$key], $charset)); break; } } $index->addDocument($doc); $index->commit(); $index->optimize(); return TRUE; }
public function buildAction() { // create the index $index = Zend_Search_Lucene::create(APPLICATION_PATH . '/indexes'); // fetch all of the current pages $mdlPage = new Model_Page(); $currentPages = $mdlPage->fetchAll(); if ($currentPages->count() > 0) { // create a new search document for each page foreach ($currentPages as $p) { $page = new CMS_Content_Item_Page($p->id); $doc = new Zend_Search_Lucene_Document(); // you use an unindexed field for the id because you want the id to be // included in the search results but not searchable $doc->addField(Zend_Search_Lucene_Field::unIndexed('page_id', $page->id)); // you use text fields here because you want the content to be searchable // and to be returned in search results $doc->addField(Zend_Search_Lucene_Field::text('page_name', $page->name)); $doc->addField(Zend_Search_Lucene_Field::text('page_headline', $page->headline)); $doc->addField(Zend_Search_Lucene_Field::text('page_description', $page->description)); $doc->addField(Zend_Search_Lucene_Field::text('page_content', $page->content)); // add the document to the index $index->addDocument($doc); } } // optimize the index $index->optimize(); // pass the view data for reporting $this->view->indexSize = $index->numDocs(); }
public function buildplaces() { ini_set('memory_limit', '1000M'); set_time_limit(0); $time = time(); Zend_Search_Lucene_Analysis_Analyzer::setDefault(new Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive()); /** * Create index */ $index = Zend_Search_Lucene::create($this->_indexPath); /** * Get all users */ $sql = $this->_db->select()->from($this->_name, array('id', 'name', 'placepic'))->limit(7500); $result = $this->_db->fetchAssoc($sql); foreach ($result as $values) { $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::keyword('placeid', $values['id'])); $doc->addField(Zend_Search_Lucene_Field::text('placename', $values['name'])); $doc->addField(Zend_Search_Lucene_Field::unStored('placepic', $values['placepic'])); $index->addDocument($doc); } $index->commit(); $elapsed = time() - $time; print_r($elapsed); }
public function __construct(Storefront_Resource_Product_Item_Interface $item, $category) { $this->addField(Zend_Search_Lucene_Field::keyword('productId', $item->productId, 'UTF-8')); $this->addField(Zend_Search_Lucene_Field::text('categories', $category, 'UTF-8')); $this->addField(Zend_Search_Lucene_Field::text('name', $item->name, 'UTF-8')); $this->addField(Zend_Search_Lucene_Field::unStored('description', $item->description, 'UTF-8')); $this->addField(Zend_Search_Lucene_Field::text('price', $this->_formatPrice($item->getPrice()), 'UTF-8')); }
/** * This method is called before the first test of this test class is run. * * Build a temporary index with a couple of documents */ public static function setUpBeforeClass() { // ensure no index exist system(sprintf("rm -rf %s", self::indexDir())); // create the index $index = Zend_Search_Lucene::create(self::indexDir()); // add some documents for ($i = 0; $i < 3; $i++) { $document = new Zend_Search_Lucene_Document(); $document->addField(Zend_Search_Lucene_Field::text('title', "foo bar baz {$i}")); $document->addField(Zend_Search_Lucene_Field::text('content', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc pharetra laoreet sodales. Aenean consequat ornare aliquam. Etiam vestibulum ultrices elit nec vestibulum')); $index->addDocument($document); } $index->commit(); }
function searchImportFragment($fragment, $index) { if ($fragment->getType() != "text") { return; } $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::text('uri', $fragment->getUri(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('user', $fragment->getCreatorId(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('created', $fragment->getCreateDate(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('modified', $fragment->getModifyDate(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('title', $fragment->getTitle(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('content', $fragment->getSaveContent(), INDEX_CHARSET)); $doc->addField(Zend_Search_Lucene_Field::text('searchtext', $fragment->getTitle() . " " . $fragment->getContent(), INDEX_CHARSET)); $ret = $index->addDocument($doc); }
function index($title, $content, $url, $keywords, $user_id) { $this->initLuceneEngine(); $id = $this->getId($url); $indexer = $this->zend->get_Zend_Search_Lucene(); $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::Keyword('id', $id)); $doc->addField(Zend_Search_Lucene_Field::Keyword('userid', $user_id)); $doc->addField(Zend_Search_Lucene_Field::Keyword('url', $url)); $doc->addField(Zend_Search_Lucene_Field::UnStored("content", $content, 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::text("title", $title, 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::text("keywords", $keywords, 'utf-8')); $indexer->addDocument($doc); $indexer->commit(); //$indexer->optimize(); return TRUE; }
/** * Add node to index * * @param Zoo_Content_Interface $item */ protected function _build(Zoo_Content_Interface $item) { // Delete existing document, if exists $hits = $this->index->find('nid:' . $item->id); foreach ($hits as $hit) { $this->index->delete($hit->id); } // (Re-)Index document $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::text('nid', $item->id)); $doc->addField(Zend_Search_Lucene_Field::unIndexed('link', $item->url())); $doc->addField(Zend_Search_Lucene_Field::unStored('title', $item->title)); $doc->addField(Zend_Search_Lucene_Field::unStored('type', $item->type)); $doc->addField(Zend_Search_Lucene_Field::unStored('published', $item->published)); $doc->addField(Zend_Search_Lucene_Field::unStored('uid', $item->uid)); list($content) = Zoo::getService('content')->getRenderedContent($item->id, 'Display'); $doc->addField(Zend_Search_Lucene_Field::unStored('contents', strip_tags($content))); return $doc; }
public function updateLuceneIndex() { $index = trackTable::getLuceneIndex(); // remove existing entries foreach ($index->find('pk:' . $this->getId()) as $hit) { $index->delete($hit->id); } $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::Keyword('pk', $this->getId())); $doc->addField(Zend_Search_Lucene_Field::text('track_name', $this->getName(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::UnIndexed('track_url', $this->getUrl(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::Keyword('play_it_user_id', $this->getSfGuardUser()->getId())); $doc->addField(Zend_Search_Lucene_Field::text('track_name', $this->getName(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::text('track_type', $this->getPlayList()->getObjectType(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::text('playlist_name', $this->getPlayList()->getTitle(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::Keyword('play_owner_id', $this->getPlayList()->getPlayOwner()->getId())); $doc->addField(Zend_Search_Lucene_Field::text('play_owner_name', $this->getPlayList()->getPlayOwner()->getName(), 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::UnStored('play_owner_name_fr', $this->getPlayList()->getPlayOwner()->getNameFr(), 'utf-8')); $index->addDocument($doc); $index->commit(); }
/** * php index.php db index * */ public function index() { $query = "SELECT * FROM Products AS p JOIN Categories AS c ON p.CategoryID = c.CategoryId JOIN Suppliers AS s ON p.SupplierID = s.SupplierID"; $stmt = $this->db->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); $indexDir = APP_PATH . '/' . self::INDEX_DIR; is_dir($indexDir) || mkdir($indexDir, 0777, true); $index = self::create($indexDir); foreach ($rows as $row) { $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::keyword('ProductName', $row['ProductName'])); $doc->addField(Zend_Search_Lucene_Field::text('Quantity', $row['QuantityPerUnit'])); $doc->addField(Zend_Search_Lucene_Field::keyword('Category', $row['CategoryName'])); $doc->addField(Zend_Search_Lucene_Field::unIndexed('Description', $row['Description'])); $doc->addField(Zend_Search_Lucene_Field::unStored('City', $row['City'])); $doc->addField(Zend_Search_Lucene_Field::keyword('CompanyName', $row['CompanyName'])); $doc->addField(Zend_Search_Lucene_Field::binary('Picture', $row['Picture'])); $index->addDocument($doc); } }
function insert($dataObj, $user_id = 0, $object_type = JS_TEXT_DATA, $indexedContent = '', $isIndexed = TRUE, $keyHints = '') { $this->initLuceneEngine(); $id = $this->getId($keyHints); $dataObjStr = ''; if (!is_string($dataObj)) { $dataObjStr = json_encode($dataObj); } $data = PREFIX_JS_DATA . ' ' . $dataObjStr . ' ' . SUFFIX_JS_DATA; if (write_file('./js-data/' . $id . '.js', $data)) { $indexer = $this->zend->get_Zend_Search_Lucene(); $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::Keyword('id', $id)); $doc->addField(Zend_Search_Lucene_Field::Keyword('userid', $user_id)); $doc->addField(Zend_Search_Lucene_Field::Keyword('object_type', $object_type)); if ($isIndexed) { if ($object_type === JS_TEXT_DATA) { $doc->addField(Zend_Search_Lucene_Field::UnStored("content", $indexedContent, 'utf-8')); $doc->addField(Zend_Search_Lucene_Field::text("title", $dataObj['title'], 'utf-8')); } else { if ($object_type === JS_STRUCTURED_DATA && is_string($dataObj)) { $dataObj = json_decode($dataObj); //unset Reserved Fields unset($dataObj['id']); unset($dataObj['userid']); unset($dataObj['object_type']); foreach ($dataObj as $key => $value) { $doc->addField(Zend_Search_Lucene_Field::UnStored($key, $value, 'utf-8')); } } } } $indexer->addDocument($doc); $indexer->commit(); //$indexer->optimize(); return TRUE; } return FALSE; }
public function buildforum() { ini_set('memory_limit', '1000M'); set_time_limit(0); Zend_Search_Lucene_Analysis_Analyzer::setDefault(new Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive()); /** * Create index */ $index = Zend_Search_Lucene::create($this->_indexPath); /** * Get all users */ $sql = $this->_db->select()->from('forum_questions', array('tags', 'question', 'id')); $result = $this->_db->fetchAssoc($sql); /** * Create a document for each user and add it to the index */ /*foreach ($users as $user) { $doc = new Zend_Search_Lucene_Document(); /** * Fill document with data */ /* $doc->addField(Zend_Search_Lucene_Field::unIndexed('title', $user->id)); $doc->addField(Zend_Search_Lucene_Field::text('contents', $user->name)); //$doc->addField(Zend_Search_Lucene_Field::unIndexed('birthday', $user['dob'], 'UTF-8')); /** * Add document */ /*$index->addDocument($doc); } $index->optimize(); $index->commit();*/ foreach ($result as $values) { $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::keyword('questionid', $values['id'])); $doc->addField(Zend_Search_Lucene_Field::unStored('questions', $values['question'])); $tag = explode(',', $values['tags']); $tags = implode(' ', $tag); $doc->addField(Zend_Search_Lucene_Field::text('tags', $tags)); $index->addDocument($doc); } $index->commit(); }
protected function addToIndex($data) { if (trim($this->z_indexate) == '') { return; } if (!isset($data['id'])) { return; } $fields = explode(';', trim($this->z_indexate)); $searchIndex = Z_Search::getInstance(); //создаем документ $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::keyword('_id', $data['id'])); $doc->addField(Zend_Search_Lucene_Field::unIndexed('_type', $this->z_model->info('name'))); foreach ($fields as $field) { if (isset($data[$field])) { $doc->addField(Zend_Search_Lucene_Field::text($field, $data[$field])); } } //удаляем старый документ $hits = $searchIndex->find('_id:' . $data['id']); foreach ($hits as $hit) { $searchIndex->delete($hit->id); } //добавляем документ $searchIndex->addDocument($doc); }
private function insertPageDocument($user, $doc) { $doc->addField(Zend_Search_Lucene_Field::keyword('userid', $user['userid'])); $doc->addField(Zend_Search_Lucene_Field::keyword('type', $user['type'])); $doc->addField(Zend_Search_Lucene_Field::text('username', $user['username'])); $doc->addField(Zend_Search_Lucene_Field::unIndexed('user_url', $user['user_url'])); $doc->addField(Zend_Search_Lucene_Field::unIndexed('propic', $user['pagepic_url'])); $doc->addField(Zend_Search_Lucene_Field::unIndexed('vote', $user['page_vote'])); $doc->addField(Zend_Search_Lucene_Field::keyword('category', $user['category'])); $doc->addField(Zend_Search_Lucene_Field::keyword('subcategory', $user['subcategory'])); $doc->addField(Zend_Search_Lucene_Field::keyword('bids', $user['bids'])); return $doc; }
function run_index_documents($task, $args) { try { define('SF_ROOT_DIR', sfConfig::get('sf_root_dir')); define('SF_APP', 'backend'); define('SF_ENVIRONMENT', 'prod'); define('SF_DEBUG', false); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; ini_set("memory_limit", "2048M"); ini_set("display_errors", 1); $databaseManager = new sfDatabaseManager(); $databaseManager->initialize(); $search_config_file = SF_ROOT_DIR . '/config/search.xml'; $documents = simplexml_load_file($search_config_file); $all = 0; $search_index_path = SF_ROOT_DIR . '/cache/search/'; if (is_dir($search_index_path)) { $index_files = glob($search_index_path . '/*'); foreach ($index_files as $index_file) { if (is_file($index_file)) { unlink($index_file); } } } $search_index = Zend_Search_Lucene::create($search_index_path); $search_index->setMaxBufferedDocs(20000); Zend_Search_Lucene_Analysis_Analyzer::setDefault(new Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive()); $ndoc = 0; foreach ($documents as $document) { $document_name = $document->attributes(); if (array_key_exists(0, $args) && $document_name != $args[0]) { continue; } echo "Indexing " . $document_name . "\n"; $classPeer = $document_name . 'Peer'; $c = new Criteria(); $document_instances = call_user_func(array($classPeer, 'doSelect'), $c); foreach ($document_instances as $document_instance) { $common_field_val = ""; $id = $document_instance->getId(); $search_doc = new Zend_Search_Lucene_Document(); $date = $document_instance->getCreatedAt(); $search_doc->addField(Zend_Search_Lucene_Field::UnIndexed('did', $id, 'utf-8')); $search_doc->addField(Zend_Search_Lucene_Field::UnIndexed('ddate', $date, 'utf-8')); $search_doc->addField(Zend_Search_Lucene_Field::UnIndexed('dtype', $document_name, 'utf-8')); $search_doc->addField(Zend_Search_Lucene_Field::UnIndexed('dstatus', $document_instance->getPublicationStatus(), 'utf-8')); foreach ($document as $field_name) { $attr = get_object_vars($field_name); $attributes = $attr['@attributes']; $getFunction = 'get' . $attributes['name']; $fieldContent = ""; $fieldContent = $document_instance->{$getFunction}(); if ($attributes['name'] == "Label" and substr($fieldContent, 0, 8) == "no label") { $fieldContent = ""; } if ($attributes['name'] == "ViennaClasses" || $attributes['name'] == "NiceClasses") { $parts = explode(",", $fieldContent); $nbr = count($parts); //echo "============>".$nbr."\n"; $search_doc->addField(Zend_Search_Lucene_Field::UnIndexed($attributes['name'] . "_cnt", $nbr, 'utf-8')); //$e = 1; for ($e = 0; $e < 15; $e++) { if (empty($parts[$e])) { $parts[$e] = "---"; } $search_doc->addField(Zend_Search_Lucene_Field::keyword($attributes['name'] . $e, trim($parts[$e]), 'utf-8')); $e++; } } elseif ($attributes['name'] == "ApplicationNumber" || $attributes['name'] == "RegisterNumber") { $search_doc->addField(Zend_Search_Lucene_Field::keyword($attributes['name'], $fieldContent, 'utf-8')); } else { $search_doc->addField(Zend_Search_Lucene_Field::text($attributes['name'], UtilsHelper::cyrillicConvert($fieldContent), 'utf-8')); } } $search_index->addDocument($search_doc); $ndoc++; echo $ndoc . "\t\t\r"; } } echo echo_cms_line(" " . $ndoc . " documents indexed\n"); $search_index->commit(); $search_index->optimize(); } catch (Exception $e) { echo_cms_error("ERROR ADD_DOCUMENT : " . $e->getMessage()); } echo echo_cms_sep(); exit; }
/** * @param $revision * @return bool|Zend_Search_Lucene_Document */ private function getDocumentForRevision($revision) { $path = getDocumentRevisionPath($revision->id); if (!file_exists($path)) { return array("error" => "File not found"); } //Convert the file to a lucene document $mime = $revision->file_mime_type; switch ($mime) { case 'application/pdf': $document = createPDFDocument($path); break; case 'application/msword': $document = createDocDocument($path); break; case 'application/vnd.oasis.opendocument.text': $document = createOdtDocument($path); break; case 'application/vnd.openxmlformats-officedocument.wordprocessingml.document': $document = createDocXDocument($path); break; case 'text/html': $document = createHTMLDocument($path); break; case 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet': $document = createXLSXDocument($path); break; case 'application/rtf': $document = createRTFDocument($path); case 'text/csv': case 'text/plain': $document = createTextDocument($path); break; case 'application/vnd.openxmlformats-officedocument.presentationml.presentation': $document = createPPTXDocument($path); break; case 'application/vnd.oasis.opendocument.spreadsheet': case 'application/vnd.ms-powerpoint': case 'application/vnd.ms-excel': default: return array("error" => "Mime type {$mime} not supported"); } if (!$document) { return array("error" => "Failed to parse document"); } $document->addField(Zend_Search_Lucene_Field::text("filename", $revision->filename)); return array("error" => false, "document" => $document); }
public static function addPageToIndex($page, $toasterSearchIndex = false) { if (!self::initIndex()) { return false; } if ($page instanceof Application_Model_Models_Page) { $page = $page->toArray(); $containers = Application_Model_Mappers_ContainerMapper::getInstance()->findByPageId($page['id']); $page['content'] = ''; if (!empty($containers)) { foreach ($containers as $container) { $page['content'] .= $container->getContent(); } } } $document = new Zend_Search_Lucene_Document(); $document->addField(Zend_Search_Lucene_Field::keyword('pageId', $page['id'])); $document->addField(Zend_Search_Lucene_Field::unStored('metaKeyWords', $page['metaKeywords'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::unStored('metaDescription', $page['metaDescription'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::unStored('headerTitle', $page['headerTitle'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::unStored('content', $page['content'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::text('draft', $page['draft'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::text('teaserText', $page['teaserText'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::text('url', $page['url'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::text('navName', $page['navName'], 'UTF-8')); $document->addField(Zend_Search_Lucene_Field::text('h1', $page['h1'], 'UTF-8')); // $document->addField(Zend_Search_Lucene_Field::text('previewImage', $page['previewImage'])); self::$_index->addDocument($document); }
public function actionDoIndex() { $document = Document::model()->findAll(); Yii::import('application.vendor.*'); require_once 'Zend/Search/Lucene.php'; $index = new Zend_Search_Lucene(Yii::getPathOfAlias('application.index'), true); try { foreach ($document as $doc) { $indexDoc = new Zend_Search_Lucene_Document(); $indexDoc->addField(Zend_Search_Lucene_Field::text("title", CHtml::encode($doc->title), 'utf-8')); $indexDoc->addField(Zend_Search_Lucene_Field::text("content", CHtml::encode($doc->content), 'utf-8')); $indexDoc->addField(Zend_Search_Lucene_Field::text("author", CHtml::encode($doc->author), 'utf-8')); $indexDoc->addField(Zend_Search_Lucene_Field::unIndexed("id", CHtml::encode($doc->id), 'utf-8')); $indexDoc->addField(Zend_Search_Lucene_Field::keyword("url", CHtml::encode($doc->url), 'utf-8')); $index->addDocument($indexDoc); } $index->commit(); Yii::app()->user->setFlash('success', 'Indexing success!'); } catch (Exception $e) { Yii::app()->user->setFlash('error', 'Indexing fail, try again!'); } $this->redirect(array('document/admin')); }
/** * indexFieldNow * @param GenericElementField $objField * @param string $strField * @param integer $intFieldType * @param string|array|object $mixedFieldValue * @param Zend_Search_Lucene_Document $objDoc * @return void * @author Thomas Schedler <*****@*****.**> */ protected final function indexFieldNow($objField, $strField, $intFieldType, $mixedFieldValue, Zend_Search_Lucene_Document &$objDoc) { try { $strValue = ''; $strValueIds = ''; if ($objField->typeId == GenericSetup::FIELD_TYPE_ID_TAG) { $mixedValue = $mixedFieldValue; if (is_object($mixedValue) || is_array($mixedValue)) { foreach ($mixedValue as $objTag) { $strValue .= $objTag->title . ', '; $strValueIds .= '[' . $objTag->id . ']'; } $strValue = rtrim($strValue, ', '); } } elseif (!is_object($mixedFieldValue) && $objField->sqlSelect != '') { $sqlSelect = $objField->sqlSelect; $arrIds = array(); if (is_array($mixedFieldValue)) { $arrIds = $mixedFieldValue; } else { if ($mixedFieldValue != '') { if (strpos($mixedFieldValue, '[') !== false) { $mixedFieldValue = trim($mixedFieldValue, '[]'); $arrIds = explode('][', $mixedFieldValue); } else { $arrIds = array($mixedFieldValue); } } } if (is_array($arrIds)) { if (count($arrIds) > 0) { $strReplaceWhere = ''; foreach ($arrIds as $strId) { $strReplaceWhere .= $strId . ','; } $strReplaceWhere = trim($strReplaceWhere, ','); $objReplacer = new Replacer(); $sqlSelect = $objReplacer->sqlReplacer($sqlSelect, $this->setup->getLanguageId(), $this->setup->getRootLevelId(), ' AND tbl.id IN (' . $strReplaceWhere . ')'); $objCategoriesData = $this->core->dbh->query($sqlSelect)->fetchAll(Zend_Db::FETCH_OBJ); if (count($objCategoriesData) > 0) { foreach ($objCategoriesData as $objCategories) { $strValue .= $objCategories->title . ', '; $strValueIds .= '[' . $objCategories->id . ']'; } $strValue = rtrim($strValue, ', '); } } } } else { $strValue = html_entity_decode($mixedFieldValue, ENT_COMPAT, $this->core->sysConfig->encoding->default); } if (is_string($strValue) && $strValue != '') { if ($intFieldType == GenericSetup::FILE_FIELD) { $objFiles = $this->getModelFiles()->loadFilesById($strValue); $arrValues = array(); if (count($objFiles) > 0) { foreach ($objFiles as $objFile) { $arrValues[] = array('path' => $objFile->path, 'filename' => $objFile->filename, 'version' => $objFile->version); } } $strValueIds = $strValue; $strValue = serialize($arrValues); } if ($strValueIds != '') { $objDoc->addField(Zend_Search_Lucene_Field::unIndexed($strField . 'Ids', $strValueIds, $this->core->sysConfig->encoding->default)); } $this->core->logger->debug($strField . ': ' . $strValue); switch ($objField->idSearchFieldTypes) { case Search::FIELD_TYPE_KEYWORD: $objDoc->addField(Zend_Search_Lucene_Field::keyword($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_UNINDEXED: $objDoc->addField(Zend_Search_Lucene_Field::unIndexed($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_BINARY: $objDoc->addField(Zend_Search_Lucene_Field::binary($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_TEXT: $objDoc->addField(Zend_Search_Lucene_Field::text($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_UNSTORED: $objDoc->addField(Zend_Search_Lucene_Field::unStored($strField, strip_tags($strValue), $this->core->sysConfig->encoding->default)); break; } } } catch (Exception $exc) { $this->core->logger->err($exc); } }
/** * addToIndex * @param string $strIndexPath * @param string $strKey * @author Thomas Schedler <*****@*****.**> * @version 1.0 */ protected final function addToIndex($strIndexPath, $strKey) { try { if (!is_object($this->objIndex) || !$this->objIndex instanceof Zend_Search_Lucene) { if (count(scandir($strIndexPath)) > 2) { $this->objIndex = Zend_Search_Lucene::open($strIndexPath); } else { $this->objIndex = Zend_Search_Lucene::create($strIndexPath); } } $objDoc = new Zend_Search_Lucene_Document(); $objDoc->addField(Zend_Search_Lucene_Field::keyword('key', $strKey)); $objDoc->addField(Zend_Search_Lucene_Field::unIndexed('date', $this->setup->getPublishDate('d.m.Y'))); $objDoc->addField(Zend_Search_Lucene_Field::unIndexed('rootLevelId', $this->setup->getRootLevelId())); /** * index fields */ foreach ($this->setup->FieldNames() as $strField => $intFieldType) { $objField = $this->setup->getField($strField); if (is_object($objField) && $objField->idSearchFieldTypes != Search::FIELD_TYPE_NONE) { $strValue = ''; if (is_array($objField->getValue()) && $objField->sqlSelect != '') { $arrIds = $objField->getValue(); $sqlSelect = $objField->sqlSelect; if (is_array($arrIds)) { if (count($arrIds) > 0) { $strReplaceWhere = ''; foreach ($arrIds as $strId) { $strReplaceWhere .= $strId . ','; } $strReplaceWhere = trim($strReplaceWhere, ','); $objReplacer = new Replacer(); $sqlSelect = $objReplacer->sqlReplacer($sqlSelect, $this->setup->getLanguageId(), $this->setup->getRootLevelId(), ' AND tbl.id IN (' . $strReplaceWhere . ')'); $objCategoriesData = $this->core->dbh->query($sqlSelect)->fetchAll(Zend_Db::FETCH_OBJ); if (count($objCategoriesData) > 0) { foreach ($objCategoriesData as $objCategories) { $strValue .= $objCategories->title . ', '; } $strValue = rtrim($strValue, ', '); } } } } else { $strValue = $objField->getValue(); } if ($strValue != '') { switch ($objField->idSearchFieldTypes) { case Search::FIELD_TYPE_KEYWORD: $objDoc->addField(Zend_Search_Lucene_Field::keyword($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_UNINDEXED: $objDoc->addField(Zend_Search_Lucene_Field::unIndexed($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_BINARY: $objDoc->addField(Zend_Search_Lucene_Field::binary($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_TEXT: $objDoc->addField(Zend_Search_Lucene_Field::text($strField, $strValue, $this->core->sysConfig->encoding->default)); break; case Search::FIELD_TYPE_UNSTORED: $objDoc->addField(Zend_Search_Lucene_Field::unStored($strField, strip_tags($strValue), $this->core->sysConfig->encoding->default)); break; } } } } // Add document to the index. $this->objIndex->addDocument($objDoc); $this->objIndex->optimize(); } catch (Exception $exc) { $this->core->logger->err($exc); } }
$query = "\tSELECT a.*, MAX(b.`timestamp`) AS `last_visited`\n\t\t\t\t\t\tFROM `event_files` AS a\n\t\t\t\t\t\tLEFT JOIN `statistics` AS b\n\t\t\t\t\t\tON b.`module` = 'events'\n\t\t\t\t\t\tAND b.`action` = 'file_download'\n\t\t\t\t\t\tAND b.`action_field` = 'file_id'\n\t\t\t\t\t\tAND b.`action_value` = a.`efile_id`\n\t\t\t\t\t\tWHERE a.`event_id` = " . $db->qstr($result['event_id']); $event_files = $db->GetAll($query); //var_dump($event_files);die(); $filesBody = null; foreach ($event_files as $file) { if (is_null($file['file_name'])) { continue; } $path = pathinfo($file['file_name']); $document = Entrada_Search_Lucene_Document::factory(FILE_STORAGE_PATH . "/" . $file['efile_id'], $path['extension']); if (!is_null($document)) { $filesBody .= ' ' . $document->body; } } $document = new Zend_Search_Lucene_Document(); $document->addField(Zend_Search_Lucene_Field::text('title', $result['event_title'])); $document->addField(Zend_Search_Lucene_Field::keyword('event_id', $result['event_id'])); $document->addField(Zend_Search_Lucene_Field::unStored('description', $result['event_description'])); $document->addField(Zend_Search_Lucene_Field::unStored('goals', $result['event_goals'])); $document->addField(Zend_Search_Lucene_Field::unStored('objectives', $result['event_objectives'])); $document->addField(Zend_Search_Lucene_Field::unStored('message', $result['event_message'])); $document->addField(Zend_Search_Lucene_Field::keyword('audience_type', $result['audience_type'])); $document->addField(Zend_Search_Lucene_Field::keyword('audience_value', $result['event_cohort'])); $document->addField(Zend_Search_Lucene_Field::keyword('event_start', $result['event_start'])); $document->addField(Zend_Search_Lucene_Field::unStored('files_body', $filesBody)); $document->addField(Zend_Search_Lucene_Field::keyword('organisation_id', $result['organisation_id'])); $index->addDocument($document); } break; case 'optimize': $index = Zend_Search_Lucene::open($path . '/' . $input->index);