private function makeElasticQuery()
{
$exceptedQuery = new \Elastica\Query();
$aggregationFilters = new \Elastica\Aggregation\Filters("emotion");
$negative = new \Elastica\Filter\Range('valeur', array('lt' => 0));
$aggregationFilters->addFilter($negative, 'negative');
$neutral = new \Elastica\Filter\Range('valeur', array('lt' => 1, 'gt' => -1));
$aggregationFilters->addFilter($neutral, 'neutral');
$positive = new \Elastica\Filter\Range('valeur', array('gt' => 0));
$aggregationFilters->addFilter($positive, 'positive');
$dateHisto = new \Elastica\Aggregation\DateHistogram('nb', 'date', 'month');
$aggregationFilters->addAggregation($dateHisto);
$exceptedQuery->addAggregation($aggregationFilters);
return $exceptedQuery;
}
public function getArticles($user, $searchTerm, $page, $pageOffset, $category, $orderby, $colors, $finder, $elasticIndex)
{
$boolQuery = new \Elastica\Query\BoolQuery();
if ($category != NULL) {
$query = $this->getEntityManager()->createQuery("SELECT c.id FROM OrthIndexBundle:Categories c WHERE c.id LIKE :category")->setParameter('category', $category . "%");
$queryResult = $query->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);
foreach ($queryResult as $categoryId) {
$categoryArray[] = $categoryId['id'];
}
$categoryQuery = new \Elastica\Query\Terms();
$categoryQuery->setTerms('catRef', $categoryArray);
$boolQuery->addMust($categoryQuery);
}
if ($searchTerm) {
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('allField', $searchTerm);
$fieldQuery->setFieldOperator('allField', 'AND');
$fieldQuery->setFieldMinimumShouldMatch('allField', '70%');
$fieldQuery->setFieldFuzziness('allField', '0.8');
$fieldQuery->setFieldAnalyzer('allField', 'custom_search_analyzer');
$boolQuery->addMust($fieldQuery);
}
if ($colors != NULL) {
$colorQuery = new \Elastica\Query\Terms();
$colorQuery->setTerms('variants.variantvalues.otherTerms', $colors);
$colorNested = new \Elastica\Query\Nested('variants');
$colorNested->setPath('variants.variantvalues');
$colorNested->setQuery($colorQuery);
$boolQuery->addMust($colorNested);
}
$agg = new \Elastica\Aggregation\Terms("catRef");
$agg->setSize(5000);
$agg->setField('catRef');
$boolFilter = new \Elastica\Filter\Bool();
if ($user == "anon.") {
$boolFilter->addShould(new \Elastica\Filter\Terms('customized', array(0)));
} else {
$boolFilter->addShould(new \Elastica\Filter\Terms('customized', array(0, $user->getCustomerRef())));
}
$filtered = new \Elastica\Query\Filtered($boolQuery, $boolFilter);
$query = new \Elastica\Query();
$query->setQuery($filtered);
//if( $colors != NULL) {
// $query->setFilter($colorNested);
//}
if ($orderby == 'desc') {
$query->setSort(array('variants.price' => array('order' => 'desc')));
} elseif ($orderby == 'asc') {
$query->setSort(array('variants.price' => array('order' => 'asc')));
}
$query->addAggregation($agg);
$query->setSize(12);
$query->setFrom($pageOffset);
$articles = $finder->find($query);
$aggregations = $elasticIndex->search($query);
$result = array("articles" => $articles, "aggs" => $aggregations, "rQuery" => $query);
return $result;
}
