private function createFilters(SearchEngineOptions $options) { $filters = []; $status_opts = $options->getStatus(); foreach ($options->getDataboxes() as $databox) { foreach ($databox->get_statusbits() as $n => $status) { if (!array_key_exists($n, $status_opts)) { continue; } if (!array_key_exists($databox->get_sbas_id(), $status_opts[$n])) { continue; } $filters[] = ['term' => ['status.status-' . $n => $status_opts[$n][$databox->get_sbas_id()]]]; } } $filters[] = ['terms' => ['base_id' => array_map(function (\collection $coll) { return $coll->get_base_id(); }, $options->getCollections())]]; $filters[] = ['term' => ['type' => $options->getSearchType() === SearchEngineOptions::RECORD_RECORD ? 'record' : 'story']]; if ($options->getDateFields() && ($options->getMaxDate() || $options->getMinDate())) { $range = []; if ($options->getMaxDate()) { $range['lte'] = $options->getMaxDate()->format(DATE_ATOM); } if ($options->getMinDate()) { $range['gte'] = $options->getMinDate()->format(DATE_ATOM); } foreach ($options->getDateFields() as $dateField) { $filters[] = ['range' => ['caption.' . $dateField->get_name() => $range]]; } } if ($options->getRecordType()) { $filters[] = ['term' => ['phrasea_type' => $options->getRecordType()]]; } return $filters; }
private function getQueryIndex($query, SearchEngineOptions $options) { $index = '*'; $index_keys = []; foreach ($options->getDataboxes() as $databox) { $index_keys[] = $this->CRCdatabox($databox); } if (count($index_keys) > 0) { if ($options->getFields() || $options->getBusinessFieldsOn()) { if ($query !== '' && $options->isStemmed() && $options->getLocale()) { $index = 'metadatas' . implode('_stemmed_' . $options->getLocale() . ', metadatas', $index_keys) . '_stemmed_' . $options->getLocale(); $index .= ', metas_realtime_stemmed_' . $options->getLocale() . '_' . implode(', metas_realtime_stemmed_' . $options->getLocale() . '_', $index_keys); } else { $index = 'metadatas' . implode(',metadatas', $index_keys); $index .= ', metas_realtime' . implode(', metas_realtime', $index_keys); } } else { if ($query !== '' && $options->isStemmed() && $options->getLocale()) { $index = 'documents' . implode('_stemmed_' . $options->getLocale() . ', documents', $index_keys) . '_stemmed_' . $options->getLocale(); $index .= ', docs_realtime_stemmed_' . $options->getLocale() . '_' . implode(', docs_realtime_stemmed_' . $options->getLocale() . '_', $index_keys); } else { $index = 'documents' . implode(', documents', $index_keys); $index .= ', docs_realtime' . implode(', docs_realtime', $index_keys); } } } return $index; }
/** * Prepares the query * * @param string $query * @return PhraseaEngine */ private function addQuery($query, SearchEngineOptions $options) { foreach ($options->getDataboxes() as $databox) { $this->queries[$databox->get_sbas_id()] = $query; } $status = $options->getStatus(); foreach ($this->queries as $sbas => $qs) { if ($status) { $requestStat = 'xxxx'; for ($i = 4; $i <= 32; $i++) { if (!isset($status[$i])) { $requestStat = 'x' . $requestStat; continue; } $val = 'x'; if (isset($status[$i][$sbas])) { if ($status[$i][$sbas] == '0') { $val = '0'; } elseif ($status[$i][$sbas] == '1') { $val = '1'; } } $requestStat = $val . $requestStat; } $requestStat = ltrim($requestStat, 'x'); if ($requestStat !== '') { $this->queries[$sbas] .= ' AND (recordstatus=' . $requestStat . ')'; } } if ($options->getFields()) { $this->queries[$sbas] .= ' IN (' . implode(' OR ', array_map(function (\databox_field $field) { return $field->get_name(); }, $options->getFields())) . ')'; } if (($options->getMinDate() || $options->getMaxDate()) && $options->getDateFields()) { if ($options->getMinDate()) { $this->queries[$sbas] .= ' AND ( ' . implode(' >= ' . $options->getMinDate()->format('Y-m-d') . ' OR ', array_map(function (\databox_field $field) { return $field->get_name(); }, $options->getDateFields())) . ' >= ' . $options->getMinDate()->format('Y-m-d') . ' ) '; } if ($options->getMaxDate()) { $this->queries[$sbas] .= ' AND ( ' . implode(' <= ' . $options->getMaxDate()->format('Y-m-d') . ' OR ', array_map(function (\databox_field $field) { return $field->get_name(); }, $options->getDateFields())) . ' <= ' . $options->getMaxDate()->format('Y-m-d') . ' ) '; } } } $this->singleParse('main', $query, $options); foreach ($this->queries as $sbas => $db_query) { $this->singleParse($sbas, $this->queries[$sbas], $options); } $base_ids = array_map(function (\collection $collection) { return $collection->get_base_id(); }, $options->getCollections()); foreach ($options->getDataboxes() as $databox) { $sbas_id = $databox->get_sbas_id(); $this->colls[$sbas_id] = []; foreach ($databox->get_collections() as $collection) { if (in_array($collection->get_base_id(), $base_ids)) { $this->colls[$sbas_id][] = $collection->get_base_id(); } } if (sizeof($this->colls[$sbas_id]) <= 0) { continue; } if ($this->needthesaurus[$sbas_id]) { if ($domth = $databox->get_dom_thesaurus()) { $this->qp[$sbas_id]->thesaurus2($this->indep_treeq[$sbas_id], $sbas_id, $databox->get_dbname(), $domth, true); $this->qp['main']->thesaurus2($this->indep_treeq['main'], $sbas_id, $databox->get_dbname(), $domth, true); } } $emptyw = false; $this->qp[$sbas_id]->set_default($this->indep_treeq[$sbas_id], $emptyw); $this->qp[$sbas_id]->distrib_in($this->indep_treeq[$sbas_id]); $this->qp[$sbas_id]->factor_or($this->indep_treeq[$sbas_id]); $this->qp[$sbas_id]->setNumValue($this->indep_treeq[$sbas_id], $databox->get_sxml_structure()); $this->qp[$sbas_id]->thesaurus2_apply($this->indep_treeq[$sbas_id], $sbas_id); $this->arrayq[$sbas_id] = $this->qp[$sbas_id]->makequery($this->indep_treeq[$sbas_id]); } return $this; }