private function findAllCodes($string)
{
$length = 8;
$regex = '/[A-Z0-9]{' . $length . '}/';
$prepared_string = preg_replace('/\\ /', '', $string);
$matches = array();
$codes = array();
$ret = array();
$offset = 0;
$old_offset = 1;
while ($offset != $old_offset) {
preg_match($regex, $prepared_string, $matches, PREG_OFFSET_CAPTURE, $offset);
if (!isset($matches[0])) {
break;
}
$codes[] = $matches[0][0];
$old_offset = $offset;
$offset = $matches[0][1] + 1;
}
$code = new Entity\Code();
foreach ($codes as $value) {
$code->setValue($value);
if ($code->checkCode()) {
$ret[] = clone $code;
}
$code->normalize();
if ($code->checkCode()) {
$ret[] = clone $code;
}
}
return $this->array_unique_callback($ret, function ($code) {
return $code->getValue();
});
}
public function searchAction()
{
$logger = $this->getServiceLocator()->get('Logger');
$form = new Form\SearchOrder();
$result = array();
/*
* - use "" (quotes) to search exakt strings with spaces
* - use - (minus) to exclude a string
* - use space as and operator
* - use (a,b,c) as or operator
*/
$searchText = $this->params()->fromQuery('q');
if (!empty($searchText)) {
$form->get('q')->setValue($searchText);
$matches = array();
preg_match('/"[^"]+"/', $searchText, $matches);
$searchElements = preg_replace('/"/', '', $matches);
$logger->info('found matches:');
$logger->info($matches);
$searchArray = split(' ', $searchText);
$exclude = false;
$excludeElements = array();
foreach ($searchArray as $element) {
if (preg_match('/^"/', $element)) {
$exclude = true;
}
if (!$exclude) {
if (preg_match('/^-/', $element)) {
$excludeElements[] = preg_replace('/^-/', '', $element);
} else {
$searchElements[] = $element;
}
}
if (preg_match('/"$/', $element)) {
$exclude = false;
}
}
$logger->info('search elements:');
$logger->info($searchElements);
$logger->info('exclude elements:');
$logger->info($excludeElements);
$searchString = array();
$em = $this->getServiceLocator()->get('Doctrine\\ORM\\EntityManager');
$result = array();
/*
* search code
*/
$qb = $em->getRepository("ErsBase\\Entity\\Order")->createQueryBuilder('o');
$qb->join('o.code', 'oc');
$qb->join('o.packages', 'p');
$qb->join('p.code', 'pc');
$i = 0;
foreach ($searchElements as $element) {
if ($i == 0) {
$qb->where('oc.value LIKE :param' . $i);
} else {
$qb->orWhere('oc.value LIKE :param' . $i);
}
$qb->setParameter('param' . $i, $element);
$i++;
$code = new Entity\Code();
$code->setValue($element);
if ($code->checkCode()) {
$qb->orWhere('oc.value LIKE :param' . $i);
$qb->orWhere('pc.value LIKE :param' . $i);
$qb->setParameter('param' . $i, $code->getValue());
$i++;
}
}
$check_first = $i;
foreach ($excludeElements as $elemnt) {
if ($i == $check_first) {
$qb->where('oc.value NOT LIKE :param' . $i);
} else {
$qb->orWhere('oc.value NOT LIKE :param' . $i);
}
$qb->orWhere('pc.value NOT LIKE :param' . $i);
$qb->setParameter('param' . $i, $element);
$i++;
}
$result = array_merge($result, $qb->getQuery()->getResult());
/*
* search firstname, surname, email, birthdate
* of buyer and participant
*/
$qb = $em->getRepository("ErsBase\\Entity\\Order")->createQueryBuilder('o');
$qb->join('o.buyer', 'b');
$qb->join('o.packages', 'p');
$qb->join('p.participant', 'u');
$i = 0;
foreach ($searchElements as $element) {
$b_expr = $qb->expr()->lower($qb->expr()->concat('b.firstname', $qb->expr()->concat($qb->expr()->literal(' '), 'b.surname')));
$u_expr = $qb->expr()->lower($qb->expr()->concat('u.firstname', $qb->expr()->concat($qb->expr()->literal(' '), 'u.surname')));
$be_expr = $qb->expr()->lower('b.email');
$ue_expr = $qb->expr()->lower('u.email');
if ($i == 0) {
$qb->where($qb->expr()->like($b_expr, ':param' . $i));
} else {
$qb->orWhere($qb->expr()->like($b_expr, ':param' . $i));
}
$qb->orWhere($qb->expr()->like($u_expr, ':param' . $i));
$qb->orWhere($qb->expr()->like($be_expr, ':param' . $i));
$qb->orWhere($qb->expr()->like($ue_expr, ':param' . $i));
$qb->setParameter('param' . $i, '%' . strtolower($element) . '%');
$i++;
}
$result = array_merge($result, $qb->getQuery()->getResult());
} else {
$logger->warn($form->getMessages());
}
return new ViewModel(array('form' => $form, 'result' => $result));
}
