/**
* @param RequestInterface $request
* @param Select $select
* @param IndexBuilderInterface $indexBuilder
* @param MatchContainer[] $matchQueries
* @return Select
*/
private function addMatchQueries(RequestInterface $request, Select $select, IndexBuilderInterface $indexBuilder, array $matchQueries)
{
$queriesCount = count($matchQueries);
if ($queriesCount) {
$table = $this->temporaryStorage->storeDocumentsFromSelect($select);
foreach ($matchQueries as $matchContainer) {
$queriesCount--;
$matchScoreBuilder = $this->scoreBuilderFactory->create();
$matchSelect = $this->matchBuilder->build($matchScoreBuilder, $indexBuilder->build($request), $matchContainer->getRequest(), $matchContainer->getConditionType());
$select = $this->joinPreviousResultToSelect($matchSelect, $table, $matchScoreBuilder);
if ($queriesCount) {
$previousResultTable = $table;
$table = $this->temporaryStorage->storeDocumentsFromSelect($select);
$this->getConnection()->dropTable($previousResultTable->getName());
}
}
}
return $select;
}
/**
* @param RequestInterface $request
* @param MatchContainer[] $matchQueries
* @param ScoreBuilder $scoreBuilder
* @param Select $select
* @param IndexBuilderInterface $indexBuilder
* @return Select
* @internal param QueryContainer $queryContainer
*/
private function addMatchQueries(
RequestInterface $request,
array $matchQueries,
ScoreBuilder $scoreBuilder,
Select $select,
IndexBuilderInterface $indexBuilder
) {
if (!$matchQueries) {
$select->columns($scoreBuilder->build());
$select = $this->createAroundSelect($select, $scoreBuilder);
} elseif (count($matchQueries) === 1) {
$matchContainer = reset($matchQueries);
$this->matchBuilder->build(
$scoreBuilder,
$select,
$matchContainer->getRequest(),
$matchContainer->getConditionType()
);
$select->columns($scoreBuilder->build());
$select = $this->createAroundSelect($select, $scoreBuilder);
} elseif (count($matchQueries) > 1) {
$select->columns($scoreBuilder->build());
$select = $this->createAroundSelect($select, $scoreBuilder);
$subSelect = $select;
$select = $this->resource->getConnection(Resource::DEFAULT_READ_RESOURCE)->select();
$tables = array_merge(array_keys($matchQueries), ['main_select.relevance']);
$relevance = implode('.relevance + ', $tables);
$select
->from(
['main_select' => $subSelect],
[
$this->entityMetadata->getEntityId() => 'entity_id',
'relevance' => sprintf('(%s)', $relevance),
]
);
foreach ($matchQueries as $matchName => $matchContainer) {
$matchSelect = $indexBuilder->build($request);
$matchScoreBuilder = $this->scoreBuilderFactory->create();
$matchSelect = $this->matchBuilder->build(
$matchScoreBuilder,
$matchSelect,
$matchContainer->getRequest(),
$matchContainer->getConditionType()
);
$matchSelect->columns($matchScoreBuilder->build());
$select->join(
[$matchName => $this->createAroundSelect($matchSelect, $scoreBuilder)],
$matchName . '.entity_id = main_select.entity_id',
[]
);
}
}
return $select;
}
/**
* @return Select
*/
private function createSelect()
{
return $this->indexBuilder->build($this->request);
}
