for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Azine\EmailBundle\Entity\Repositories;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query;
/**
* SentEmailRepository.
*
* This class was generated by the Doctrine ORM. Add your own custom
* repository methods below.
*/
class SentEmailRepository extends EntityRepository
{
* Search SentEmails by search params.
* @param $searchParams
* @return Query
public function search($searchParams = array())
$queryBuilder = $this->createQueryBuilder('e');
if (!empty($searchParams)) {
$searchAttributes = array(
'recipients',
'template',
'sent',
'variables',
'token',
);
foreach ($searchAttributes as $attribute) {
if (empty($searchParams[$attribute])) {
continue;
}
$attributeValue = $searchParams[$attribute];
$queryBuilder->andWhere('e.'.$attribute.' LIKE :'.$attribute)
->setParameter($attribute, '%'.$attributeValue.'%');
return $queryBuilder->getQuery();