/**
* @Route("/search", name="search")
* @Method("GET")
* @Template("AppBundle:Search:index.html.twig")
*/
public function searchAction(Request $request)
{
$user = $this->get('security.context')->getToken()->getUser();
$searchKey = strtolower($request->query->get('searchKey'));
// $user = $this->get('security.context')->getToken()->getUser();
$finderBucket = $this->container->get('fos_elastica.index.search.bucket');
$finderItem = $this->container->get('fos_elastica.index.search.item');
$boolQuery1 = new \Elastica\Query\BoolQuery();
$terms1 = new \Elastica\Query\Terms();
$terms1->setTerms('name', array($searchKey));
$boolQuery1->addMust($terms1);
$queryId1 = new \Elastica\Query\Terms();
$queryId1->setTerms('id', [$user->getId()]);
$nestedQuery1 = new \Elastica\Query\Nested();
$nestedQuery1->setPath('user');
$nestedQuery1->setQuery($queryId1);
$boolQuery1->addMust($nestedQuery1);
$buckets = $finderBucket->search($boolQuery1);
$boolQuery2 = new \Elastica\Query\BoolQuery();
$termsTitle = new \Elastica\Query\Terms();
$termsContent = new \Elastica\Query\Terms();
$termsTitle->setTerms('title', array($searchKey));
$boolQuery2->addMust($termsTitle);
$termsContent->setTerms('content', array($searchKey));
$boolQuery2->addShould($termsContent);
$queryId2 = new \Elastica\Query\Terms();
$queryId2->setTerms('id', [$user->getId()]);
$nestedQuery2 = new \Elastica\Query\Nested();
$nestedQuery2->setPath('user');
$nestedQuery2->setQuery($queryId2);
$boolQuery2->addMust($nestedQuery2);
$items = $finderItem->search($boolQuery2);
return ['searchKey' => $searchKey, 'buckets' => $buckets, 'items' => $items, 'allBuckets' => $this->getAllBuckets($user)];
}
/**
* @param mixed $query
* @param string $lang
* @param string $type
*
* @return mixed|void
*/
public function defineSearch($query, $lang, $type)
{
$query = \Elastica\Util::escapeTerm($query);
$elasticaQueryLang = new \Elastica\Query\Term();
$elasticaQueryLang->setTerm('lang', $lang);
$elasticaQueryString = new \Elastica\Query\Match();
$elasticaQueryString->setFieldQuery('content', $query)->setFieldMinimumShouldMatch('content', '80%');
$elasticaQueryTitle = new \Elastica\Query\QueryString();
$elasticaQueryTitle->setDefaultField('title')->setBoost(2.0)->setQuery($query);
$elasticaQueryBool = new \Elastica\Query\BoolQuery();
$elasticaQueryBool->addMust($elasticaQueryLang)->addShould($elasticaQueryTitle)->addShould($elasticaQueryString)->setMinimumNumberShouldMatch(1);
$this->applySecurityContext($elasticaQueryBool);
if (!is_null($type)) {
$elasticaQueryType = new \Elastica\Query\Term();
$elasticaQueryType->setTerm('type', $type);
$elasticaQueryBool->addMust($elasticaQueryType);
}
$rootNode = $this->domainConfiguration->getRootNode();
if (!is_null($rootNode)) {
$elasticaQueryRoot = new \Elastica\Query\Term();
$elasticaQueryRoot->setTerm('root_id', $rootNode->getId());
$elasticaQueryBool->addMust($elasticaQueryRoot);
}
$this->query->setQuery($elasticaQueryBool);
$this->query->setHighlight(array('pre_tags' => array('<strong>'), 'post_tags' => array('</strong>'), 'fields' => array('content' => array('fragment_size' => 150, 'number_of_fragments' => 3))));
}
public function newsAction(Request $request)
{
$request = $this->getRequest();
$pageOffset = 0;
if ($request->query->get('p')) {
$page = $request->query->get('p');
$pageOffset = ($page - 1) * 6;
}
$finder = $this->container->get('fos_elastica.finder.search.posts');
$boolQuery = new \Elastica\Query\BoolQuery();
if ($request->query->get('q')) {
$search = $request->query->get('q');
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('allField', $search);
$fieldQuery->setFieldOperator('allField', 'AND');
$fieldQuery->setFieldMinimumShouldMatch('allField', '80%');
$fieldQuery->setFieldAnalyzer('allField', 'custom_search_analyzer');
$boolQuery->addMust($fieldQuery);
} else {
$fieldQuery = new \Elastica\Query\MatchAll();
}
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$query->setSize(1000);
$totalpages = ceil(count($finder->find($query)) / 6);
$query->setSize(6);
$query->setFrom($pageOffset);
$posts = $finder->find($query);
return $this->render('TeamIndexBundle:News:news.html.twig', array('posts' => $posts, 'totalpages' => $totalpages));
}
public function articlelistAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
$searchTerm = $request->query->get('q');
$page = 0;
$pageOffset = 0;
if ($request->query->get('p')) {
$page = $request->query->get('p');
$pageOffset = ($page - 1) * 12;
}
$finder = $this->container->get('fos_elastica.finder.search.article');
$boolQuery = new \Elastica\Query\BoolQuery();
$articles = "";
$totalpages = 0;
if ($request->query->get('q') != NULL) {
$searchTerm = $request->query->get('q');
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('allField', $searchTerm);
$fieldQuery->setFieldOperator('allField', 'AND');
$fieldQuery->setFieldMinimumShouldMatch('allField', '80%');
$fieldQuery->setFieldAnalyzer('allField', 'custom_search_analyzer');
$boolQuery->addMust($fieldQuery);
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$query->setSize(10000);
$articleCatgeories = $finder->find($query);
$totalpages = ceil(count($finder->find($query)) / 12);
$query->setSize(12);
$query->setFrom($pageOffset);
$articles = $finder->find($query);
}
return $this->render('OrthAdminBundle:Articles:articlelist.html.twig', array('totalpages' => $totalpages, 'articles' => $articles));
}
/**
*
* @Route("", name="centrale_lille_searchuser")
* @Method("GET")
*/
public function searchAction(Request $request)
{
$search = new SearchString();
$searchForm = $this->get('form.factory')->createNamed('', 'string_search_type', $search, array('action' => $this->generateUrl('centrale_lille_searchuser'), 'method' => 'GET'));
$searchForm->handleRequest($request);
$search = $searchForm->getData();
if (is_null($search->getStringSearch())) {
$result_machine = [];
$result_user = [];
} else {
//Recherche User
$typeUser = $this->get('fos_elastica.index.fablab.User');
$query_part_user = new \Elastica\Query\BoolQuery();
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery2 = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('email', $search->getStringSearch());
$fieldQuery->setFieldQuery('email', $search->getStringSearch());
$fieldQuery->setFieldFuzziness('email', 0.7);
$query_part_user->addShould($fieldQuery);
$fieldQuery2->setFieldQuery('username', $search->getStringSearch());
$fieldQuery2->setFieldQuery('username', $search->getStringSearch());
$fieldQuery2->setFieldFuzziness('username', 0.7);
$query_part_user->addShould($fieldQuery2);
$filters = new \Elastica\Filter\Bool();
$query_user = new \Elastica\Query\Filtered($query_part_user, $filters);
$result_user = $typeUser->search($query_user);
//Recherche Machine
$typeMachine = $this->get('fos_elastica.index.fablab.Machine');
$query_part_machine = new \Elastica\Query\Bool();
$fieldQuery3 = new \Elastica\Query\Match();
$fieldQuery4 = new \Elastica\Query\Match();
$fieldQuery3->setFieldQuery('machine_name', $search->getStringSearch());
$fieldQuery3->setFieldFuzziness('machine_name', 0.7);
$fieldQuery3->setFieldMinimumShouldMatch('machine_name', '80%');
$query_part_machine->addShould($fieldQuery3);
$fieldQuery4->setFieldQuery('description', $search->getStringSearch());
$fieldQuery4->setFieldFuzziness('description', 2);
$fieldQuery4->setFieldMinimumShouldMatch('description', '100%');
$query_part_machine->addShould($fieldQuery4);
$filters = new \Elastica\Filter\Bool();
$query_machine = new \Elastica\Query\Filtered($query_part_machine, $filters);
$result_machine = $typeMachine->search($query_machine);
//Recherche Machine
$typeMachine = $this->get('fos_elastica.index.fablab.Machine');
$query_part_machine = new \Elastica\Query\Bool();
$fieldQuery3 = new \Elastica\Query\Match();
$fieldQuery4 = new \Elastica\Query\Match();
$fieldQuery3->setFieldQuery('machine_name', $search->getStringSearch());
// $fieldQuery3->setFieldFuzziness('machine.machine_name', 0.7);
//$fieldQuery3->setFieldMinimumShouldMatch('machine_name', '80%');
$query_part_machine->addShould($fieldQuery3);
$fieldQuery4->setFieldQuery('description', $search->getStringSearch());
// $fieldQuery4->setFieldFuzziness('machine.machine_name', 0.7);
//$fieldQuery4->setFieldMinimumShouldMatch('machine_name', '100%');
$query_part_machine->addShould($fieldQuery4);
}
return $this->render('CentraleLilleSearchBundle:Default:search.html.twig', array('result_user' => $result_user, 'result_machine' => $result_machine, 'form' => $searchForm->createView(), 'search' => $search->getStringSearch()));
}
public function searchRelatedEpisodes(Episode $episode, $numberResults = 5)
{
$tagtext = implode(" ", $episode->getTags()->toArray());
$boolQuery = new \Elastica\Query\BoolQuery();
$multiquery = new \Elastica\Query\MultiMatch();
$multiquery->setFields(['name', 'description', 'series']);
$multiquery->setQuery($tagtext);
$multiquery->setType(\Elastica\Query\MultiMatch::TYPE_MOST_FIELDS);
$boolQuery->addMust($multiquery);
$activeQuery = new \Elastica\Query\Term();
$activeQuery->setTerm('is_active', true);
$boolQuery->addMust($activeQuery);
$excludeEpisodeQuery = new \Elastica\Query\Term();
$excludeEpisodeQuery->setTerm('id', $episode->getId());
$boolQuery->addMustNot($excludeEpisodeQuery);
return $this->episodeFinder->find($boolQuery, $numberResults);
}
/**
* @Route("/app/search", name="search")
* @Template("AppBundle::search.html.twig")
*/
public function searchAction(Request $request)
{
$q = $request->query->get('q');
$finder = $this->get('fos_elastica.finder.app');
$tenantHelper = $this->get('multi_tenant.helper');
$boolQuery = new \Elastica\Query\BoolQuery();
$fieldQuery = new \Elastica\Query\MultiMatch();
$fieldQuery->setQuery($q);
$fieldQuery->setFields(['_all']);
$boolQuery->addMust($fieldQuery);
$tenantQuery = new \Elastica\Query\Term();
$tenantQuery->setTerm('id', $tenantHelper->getCurrentTenant()->getId());
$nestedQuery = new \Elastica\Query\Nested();
$nestedQuery->setPath('tenant');
$nestedQuery->setQuery($tenantQuery);
$boolQuery->addMust($nestedQuery);
$results = $finder->findPaginated($boolQuery);
return ['results' => $results, 'query' => $q];
}
public function getArticles($user, $searchTerm, $page, $pageOffset, $category, $colors, $finder)
{
$boolQuery = new \Elastica\Query\BoolQuery();
if ($category != NULL) {
$categoryQuery = new \Elastica\Query\Terms();
$categoryQuery->setTerms('custdata.customCatRef', array($category));
$boolQuery->addMust($categoryQuery);
}
if ($searchTerm) {
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('customerRef', $user->getCustomerRef());
$boolQuery->addMust($fieldQuery);
$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);
} else {
$fieldQuery = new \Elastica\Query\MatchAll();
$boolQuery->addMust($fieldQuery);
}
$fieldQuery = new \Elastica\Query\Nested();
$fieldQuery->setPath('custdata.custcat.perm');
$boolNested = new \Elastica\Query\BoolQuery();
$fieldNested = new \Elastica\Query\Match();
$fieldNested->setField('custdata.custcat.perm.permStatus', 1);
$boolNested->addMust($fieldNested);
$fieldNested = new \Elastica\Query\Match();
$fieldNested->setField('custdata.custcat.perm.userRef', $user->getId());
$boolNested->addMust($fieldNested);
$fieldQuery->setQuery($boolNested);
$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);
}
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$query->setSize(12);
$query->setFrom($pageOffset);
$articles = $finder->find($query);
$result = array("articles" => $articles, "rQuery" => $query);
return $result;
}
public function findByCriteria(TrackRepositoryCriteria $criteria)
{
$boolQuery = new \Elastica\Query\BoolQuery();
if ($criteria->albumId()) {
$query = new \Elastica\Query\Term();
$query->setParam('album.id', $criteria->albumId());
$boolQuery->addMust($query);
}
if ($criteria->albumTitle()) {
$query = new \Elastica\Query\Match();
$query->setFieldQuery('album.title', $criteria->albumTitle());
$query->setFieldFuzziness('album.title', 2);
$boolQuery->addMust($query);
}
if ($criteria->trackName()) {
$query = new \Elastica\Query\Match();
$query->setFieldQuery('name', $criteria->trackName());
$query->setFieldFuzziness('name', 2);
$boolQuery->addMust($query);
}
if ($criteria->composer()) {
$query = new \Elastica\Query\Match();
$query->setFieldQuery('composer', $criteria->composer());
$query->setFieldFuzziness('composer', 2);
$boolQuery->addMust($query);
}
$this->elasticaSearch->setQuery($boolQuery);
$query = $this->elasticaSearch->getQuery();
$query->setSize($criteria->size());
$query->setFrom(($criteria->page() - 1) * $criteria->size());
$query->addSort(['name_not_analyzed' => ['order' => 'asc']]);
return $this->buildEntities($this->elasticaSearch->search()->getResults());
}
public function searchAdvanced(AdvancedSearch $advancedSearch)
{
if (!$advancedSearch->innerObjectIsDefine()) {
$match = new \Elastica\Query\MatchAll();
} else {
$match = new \Elastica\Query\BoolQuery();
if ($advancedSearch->getMarque()) {
$match->addMust(new \Elastica\Query\Match('modeleMarque.marque.id', $advancedSearch->getMarque()));
}
if ($advancedSearch->getModele()) {
$match->addMust(new \Elastica\Query\Match('modeleMarque.modele.id', $advancedSearch->getModele()));
}
if ($advancedSearch->getBoitier()) {
$match->addMust(new \Elastica\Query\Match('boitier.id', $advancedSearch->getBoitier()));
}
if ($advancedSearch->getCarburant()) {
$match->addMust(new \Elastica\Query\Match('carburant.id', $advancedSearch->getCarburant()));
}
}
$boolFilter = new \Elastica\Filter\BoolFilter();
if ($advancedSearch->getPrixMin()) {
$boolFilter->addMust(new \Elastica\Filter\Range('prix', array('gte' => intval($advancedSearch->getPrixMin()))));
}
if ($advancedSearch->getPrixMax()) {
$boolFilter->addMust(new \Elastica\Filter\Range('prix', array('lte' => $advancedSearch->getPrixMax())));
}
if ($advancedSearch->getKmMin()) {
$boolFilter->addMust(new \Elastica\Filter\Range('kmParcouru', array('gte' => intval($advancedSearch->getKmMin()))));
}
if ($advancedSearch->getKmMax()) {
$boolFilter->addMust(new \Elastica\Filter\Range('kmParcouru', array('lte' => $advancedSearch->getKmMax())));
}
$filtered = new \Elastica\Query\Filtered($match, $boolFilter);
$query = \Elastica\Query::create($filtered);
return $this->find($query);
}
/**
*
* @Route("", name="centrale_lille_search")
*/
public function searchAction()
{
$jsonContentUser = '';
$jsonContentMachine = '';
$jsonContentProjet = '';
$jsonContentSkills = '';
$jsonTotal = '';
$datauser = [];
$dataprojet = [];
$dataskills = [];
$datamachine = [];
$search = $this->get('request')->query->get('searchForm');
if (is_null($search)) {
$result_machine = [];
$result_user = [];
$result_skills = [];
$result_projet = [];
} else {
//User Json
$queryall = new \Elastica\Query\MatchAll();
$typeUser = $this->get('fos_elastica.index.fablab.User');
$result_alluser = $typeUser->search($queryall)->getResults();
foreach ($result_alluser as $result) {
$source = $result->getSource();
$datauser[] = array('name' => $source['username'], 'link' => 'userId');
}
$jsonContentUser = new JsonResponse($datauser, 200, array('Cache-Control' => 'no-cache'));
//Project Json
$queryall = new \Elastica\Query\MatchAll();
$typeProjet = $this->get('fos_elastica.index.fablab.Projet');
$result_allprojet = $typeProjet->search($queryall)->getResults();
foreach ($result_allprojet as $result) {
$source = $result->getSource();
$dataprojet[] = array('name' => $source['name'], 'link' => 'projectId');
}
$jsonContentProjet = new JsonResponse($dataprojet, 200, array('Cache-Control' => 'no-cache'));
//Skills Json
$queryall = new \Elastica\Query\MatchAll();
$typeSkills = $this->get('fos_elastica.index.fablab.Competence');
$result_allskills = $typeSkills->search($queryall)->getResults();
foreach ($result_allskills as $result) {
$source = $result->getSource();
$dataskills[] = array('name' => $source['name'], 'link' => 'skillsId');
}
$jsonContentSkills = new JsonResponse($dataskills, 200, array('Cache-Control' => 'no-cache'));
//Machine Json
$queryall = new \Elastica\Query\MatchAll();
$typeMachine = $this->get('fos_elastica.index.fablab.Machine');
$result_allmachine = $typeMachine->search($queryall)->getResults();
foreach ($result_allmachine as $result) {
$source = $result->getSource();
$type = $result->getType();
$datamachine[] = array('name' => $source['name'], 'link' => 'machineId');
}
$jsonContentMachine = new JsonResponse($datamachine, 200, array('Cache-Control' => 'no-cache'));
$jsonContentMachine = '"machine": ' . substr($jsonContentMachine, 83);
$jsonContentUser = '******' . substr($jsonContentUser, 83);
$jsonContentSkills = '"competence": ' . substr($jsonContentSkills, 83);
$jsonContentProjet = '"projet": ' . substr($jsonContentProjet, 83);
$jsonTotal = '{' . $jsonContentUser . ',' . $jsonContentMachine . ',' . $jsonContentProjet . ',' . $jsonContentSkills . '}';
//Recherche User
$typeUser = $this->get('fos_elastica.index.fablab.User');
$query_part_user = new \Elastica\Query\BoolQuery();
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery2 = new \Elastica\Query\Match();
$fieldQuery9 = new \Elastica\Query\Match();
$fieldQuery10 = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('email', $search);
$fieldQuery->setFieldFuzziness('email', 0.2);
$query_part_user->addShould($fieldQuery);
$fieldQuery9->setFieldQuery('firstname', $search);
$fieldQuery9->setFieldFuzziness('firstname', 0.2);
$query_part_user->addShould($fieldQuery9);
$fieldQuery10->setFieldQuery('lastname', $search);
$fieldQuery10->setFieldFuzziness('lastname', 0.2);
$query_part_user->addShould($fieldQuery10);
$fieldQuery2->setFieldQuery('username', $search);
$fieldQuery2->setFieldFuzziness('username', 0.2);
$query_part_user->addShould($fieldQuery2);
$filters = new \Elastica\Filter\Bool();
$query_user = new \Elastica\Query\Filtered($query_part_user, $filters);
$result_user = $typeUser->search($query_user);
//Recherche Machine
$typeMachine = $this->get('fos_elastica.index.fablab.Machine');
$query_part_machine = new \Elastica\Query\Bool();
$fieldQuery3 = new \Elastica\Query\Match();
$fieldQuery4 = new \Elastica\Query\Match();
$fieldQuery3->setFieldQuery('name', $search);
$fieldQuery3->setFieldFuzziness('name', 0.2);
$fieldQuery3->setFieldMinimumShouldMatch('name', '80%');
$query_part_machine->addShould($fieldQuery3);
$fieldQuery4->setFieldQuery('description', $search);
$fieldQuery4->setFieldFuzziness('description', 2);
$fieldQuery4->setFieldMinimumShouldMatch('description', '100%');
$query_part_machine->addShould($fieldQuery4);
$filters = new \Elastica\Filter\Bool();
$query_machine = new \Elastica\Query\Filtered($query_part_machine, $filters);
$result_machine = $typeMachine->search($query_machine);
//Recherche Skills
$typeSkills = $this->get('fos_elastica.index.fablab.Competence');
$query_part_skills = new \Elastica\Query\Bool();
$fieldQuery5 = new \Elastica\Query\Match();
$fieldQuery5->setFieldQuery('name', $search);
$fieldQuery5->setFieldFuzziness('name', 2);
$fieldQuery5->setFieldMinimumShouldMatch('name', '40%');
$query_part_skills->addShould($fieldQuery5);
$filters = new \Elastica\Filter\Bool();
$query_skills = new \Elastica\Query\Filtered($query_part_skills, $filters);
$result_skills = $typeSkills->search($query_skills);
//Recherche projet
$typeProjet = $this->get('fos_elastica.index.fablab.Projet');
$query_part_projet = new \Elastica\Query\Bool();
$fieldQuery6 = new \Elastica\Query\Match();
$fieldQuery7 = new \Elastica\Query\Match();
$fieldQuery6->setFieldQuery('name', $search);
$fieldQuery6->setFieldFuzziness('name', 0.2);
$fieldQuery6->setFieldMinimumShouldMatch('name', '80%');
$query_part_projet->addShould($fieldQuery6);
$fieldQuery7->setFieldQuery('summary', $search);
$fieldQuery7->setFieldFuzziness('summary', 2);
$fieldQuery7->setFieldMinimumShouldMatch('summary', '100%');
$query_part_projet->addShould($fieldQuery7);
$filters = new \Elastica\Filter\Bool();
$query_projet = new \Elastica\Query\Filtered($query_part_projet, $filters);
$result_projet = $typeProjet->search($query_projet);
//
$encoder = array(new JsonEncoder());
$normalizer = array(new ObjectNormalizer());
$serializer = new Serializer($normalizer, $encoder);
}
return $this->render('CentraleLilleSearchBundle:Default:search.html.twig', array('result_user' => $result_user, 'result_machine' => $result_machine, 'result_competence' => $result_skills, 'result_project' => $result_projet, 'search' => $search, 'userjson' => $jsonContentUser, 'machinejson' => $jsonContentMachine, 'jsonTotal' => $jsonTotal));
}
public function getBestImg($searchTerm, $articleRef, $colors, $finder)
{
$boolQuery = new \Elastica\Query\BoolQuery();
if ($searchTerm) {
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('desc1', $searchTerm);
$fieldQuery->setFieldOperator('desc1', 'OR');
$fieldQuery->setFieldMinimumShouldMatch('desc1', '80%');
$fieldQuery->setFieldAnalyzer('desc1', 'custom_search_analyzer');
$boolQuery->addShould($fieldQuery);
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('desc2', $searchTerm);
$fieldQuery->setFieldOperator('desc2', 'OR');
$fieldQuery->setFieldMinimumShouldMatch('desc2', '80%');
$fieldQuery->setFieldAnalyzer('desc2', 'custom_search_analyzer');
$varTerms = explode(" ", $searchTerm);
$boolQuery->addShould($fieldQuery);
$colorQuery = new \Elastica\Query\Terms();
$colorQuery->setTerms('variantvalues.otherTerms', $varTerms);
$colorNested = new \Elastica\Query\Nested('variantvalues');
$colorNested->setPath('variantvalues');
$colorNested->setQuery($colorQuery);
$boolQuery->addShould($colorNested);
if ($colors != NULL) {
$fieldQuery = new \Elastica\Query\Terms();
$fieldQuery->setTerms('otherTerms', $colors);
$boolQuery->addShould($fieldQuery);
}
}
$articleRefQuery = new \Elastica\Query\Terms();
$articleRefQuery->setTerms('articleRef', array($articleRef));
$boolQuery->addMust($articleRefQuery);
if ($colors != NULL) {
$colorQuery = new \Elastica\Query\Terms();
$colorQuery->setTerms('variantvalues.otherTerms', $colors);
$colorNested = new \Elastica\Query\Nested('variantvalues');
$colorNested->setPath('variantvalues');
$colorNested->setQuery($colorQuery);
$boolQuery->addMust($colorNested);
}
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$query->setSize(12);
$articleVar = $finder->find($query);
return $articleVar;
}
public function searchAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
$username = $request->query->get('oci_username');
$password = $request->query->get('oci_password');
$hookurl = $request->query->get('hookurl');
$response = new Response();
$response->headers->clearCookie('OCIHOOK');
$response->headers->clearCookie('OrthCookie');
$response->sendHeaders();
$response->send();
$response->headers->setCookie(new Cookie('OCIHOOK', $hookurl));
$cookieValue = uniqid();
$response->headers->setCookie(new Cookie('OrthCookie', uniqid()));
$response->sendHeaders();
$response->send();
$query = $em->createQuery("SELECT u FROM Orth\\IndexBundle\\Entity\\Users u WHERE u.email = :username");
$query->setParameter('username', $username);
$user = $query->getOneOrNullResult();
if ($user) {
// Get the encoder for the users password
$encoder_service = $this->get('security.encoder_factory');
$encoder = $encoder_service->getEncoder($user);
// Note the difference
if ($encoder->isPasswordValid($user->getPassword(), $password, '$2a$12$uWepESKverBsrLAuOPY')) {
// Get profile list
} else {
dump('fail1');
exit;
}
} else {
dump('fail');
exit;
}
$token = new UsernamePasswordToken($user, null, "default", $user->getRoles());
$this->get("security.context")->setToken($token);
//now the user is logged in
//now dispatch the login event
$request = $this->get("request");
$event = new InteractiveLoginEvent($request, $token);
$this->get("event_dispatcher")->dispatch("security.interactive_login", $event);
if ($request->query->get('FUNCTION') == NULL) {
return $this->redirectToRoute('orth_index_homepage', array(), 301);
}
$searchTerm = $request->query->get('SEARCHSTRING');
$page = 0;
$pageOffset = 0;
$catId = $request->query->get('cid');
$finder = $this->container->get('fos_elastica.finder.search.article');
$boolQuery = new \Elastica\Query\BoolQuery();
if ($request->query->get('c') != NULL and $request->query->get('SEARCHSTRING') == NULL) {
$catid = $request->query->get('c');
$categoryArray = [$request->query->get('c')];
$rootCategories = $em->getRepository('OrthIndexBundle:Categories')->findBy(array('parentId' => $catid));
foreach ($rootCategories as $childCategory) {
$childCategories = $em->getRepository('OrthIndexBundle:Categories')->findBy(array('parentId' => $childCategory->getId()));
$categoryArray[] = $childCategory->getId();
foreach ($childCategories as $grandchildCategory) {
$categoryArray[] = $grandchildCategory->getId();
}
}
$categoryQuery = new \Elastica\Query\Terms();
$categoryQuery->setTerms('catRef', $categoryArray);
$boolQuery->addMust($categoryQuery);
} elseif ($request->query->get('c') != NULL) {
$catid = $request->query->get('c');
$categoryQuery = new \Elastica\Query\Terms();
$categoryQuery->setTerms('catRef', array($catid));
$boolQuery->addMust($categoryQuery);
}
if ($request->query->get('SEARCHSTRING')) {
$fieldQuery = new \Elastica\Query\Match();
$fieldQuery->setFieldQuery('allField', $searchTerm);
$fieldQuery->setFieldOperator('allField', 'AND');
$fieldQuery->setFieldMinimumShouldMatch('allField', '80%');
$fieldQuery->setFieldAnalyzer('allField', 'custom_search_analyzer');
$boolQuery->addMust($fieldQuery);
}
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$totalpages = ceil(count($finder->find($query)) / 12);
$query->setSize(100);
$query->setFrom($pageOffset);
$articles = $finder->find($query);
foreach ($articles as $article) {
$variants = $article->getVariants();
foreach ($variants as $variant) {
$price = $em->getRepository('OrthIndexBundle:ArticleSuppliers')->getCustomPrice(array('id' => $variant), $user);
$category = $em->getRepository('OrthIndexBundle:Categories')->getRootCategory($article->getCategory()->getId());
$attribute = "";
foreach ($variant->getVariantvalues() as $values) {
$attribute .= " " . $values->getAttrname()->getAttributeName() . " " . $values->getAttributeValue() . "" . $values->getAttributeUnit();
}
if ($variant->getVariantvalues()) {
if ($article->getImages()[0]) {
$image = $article->getImages()[0]->getPicName();
} else {
$image = 'nopicture_all.jpg';
}
$result[] = array('shortName' => $article->getShortName() . "" . $attribute, 'articleNumber' => $variant->getSupplierArticleNumber(), 'price' => $price, 'category' => $category, 'image' => $image);
}
}
}
return $this->render('OrthIndexBundle:Oci:ocioutput.html.twig', array('results' => $result, 'page' => $page, 'totalpages' => $totalpages, 'hookurl' => $hookurl));
}
public function catsucheAction($catid, Request $request)
{
$em = $this->getDoctrine()->getManager();
$mainCat = [];
$page = 0;
$pageOffset = 0;
if ($request->query->get('p')) {
$page = $request->query->get('p');
$pageOffset = ($page - 1) * 12;
}
$finder = $this->container->get('fos_elastica.finder.search.articles');
$boolQuery = new \Elastica\Query\BoolQuery();
if ($request->query->get('q') !== NULL) {
$searchTerm = $request->query->get('q');
$fieldQuery = new \Elastica\Query\MultiMatch();
$fieldQuery->setFields(array('shortName', 'shortDescription', 'longDescription'));
$fieldQuery->setAnalyzer('custom_search_analyzer');
$fieldQuery->setOperator('AND');
$fieldQuery->setQuery($searchTerm);
$boolQuery->addMust($fieldQuery);
}
$categoryQuery = new \Elastica\Query\Terms();
$categoryQuery->setTerms('catRef', array($catid));
$boolQuery->addMust($categoryQuery);
$query = new \Elastica\Query();
$query->setQuery($boolQuery);
$query->setSize(10000000);
$totalpages = ceil(count($finder->find($query)) / 12);
$query->setSize(12);
$query->setFrom($pageOffset);
$articles = $finder->find($query);
return $this->render('OrthIndexBundle:Shop:kategorien.html.twig', array('articles' => $articles, 'page' => $page, 'totalpages' => $totalpages, 'categories' => $mainCat));
}
/**
* Apply PageType specific and Page specific boosts
*
* @return \Elastica\Query\BoolQuery
*/
protected function getPageBoosts()
{
$rescoreQueryBool = new \Elastica\Query\BoolQuery();
//Apply page type boosts
$pageClasses = $this->em->getRepository('KunstmaanNodeBundle:Node')->findAllDistinctPageClasses();
foreach ($pageClasses as $pageClass) {
$page = new $pageClass['refEntityName']();
if ($page instanceof SearchBoostInterface) {
$elasticaQueryTypeBoost = new \Elastica\Query\QueryString();
$elasticaQueryTypeBoost->setBoost($page->getSearchBoost())->setDefaultField('page_class')->setQuery(addslashes($pageClass['refEntityName']));
$rescoreQueryBool->addShould($elasticaQueryTypeBoost);
}
}
//Apply page specific boosts
$nodeSearches = $this->em->getRepository('KunstmaanNodeSearchBundle:NodeSearch')->findAll();
foreach ($nodeSearches as $nodeSearch) {
$elasticaQueryNodeId = new \Elastica\Query\QueryString();
$elasticaQueryNodeId->setBoost($nodeSearch->getBoost())->setDefaultField('node_id')->setQuery($nodeSearch->getNode()->getId());
$rescoreQueryBool->addShould($elasticaQueryNodeId);
}
return $rescoreQueryBool;
}
