public function getDynamicUsers(\Club\UserBundle\Entity\Group $group)
{
$filter = new \Club\UserBundle\Entity\Filter();
if ($group->getGender() != null) {
$attr = new \Club\UserBundle\Entity\FilterAttribute();
$attr->setAttribute('gender');
$attr->setValue($group->getGender());
$filter->addAttributes($attr);
}
if ($group->getMaxAge() != null) {
$attr = new \Club\UserBundle\Entity\FilterAttribute();
$attr->setAttribute('max_age');
$attr->setValue($group->getMaxAge());
$filter->addAttributes($attr);
}
if ($group->getMinAge() != null) {
$attr = new \Club\UserBundle\Entity\FilterAttribute();
$attr->setAttribute('min_age');
$attr->setValue($group->getMinAge());
$filter->addAttributes($attr);
}
if ($group->getActiveMember() != null) {
$attr = new \Club\UserBundle\Entity\FilterAttribute();
$attr->setAttribute('active');
$attr->setValue(1);
$filter->addAttributes($attr);
}
return $this->_em->getRepository('ClubUserBundle:User')->getUsers($filter);
}
public function getQueryByGroup(\Club\UserBundle\Entity\Group $group)
{
$qb = $this->getQueryBuilder();
if ($group->getGender() != '') {
$qb = $this->filterGender($qb, $group->getGender());
}
if ($group->getMinAge() != '') {
$qb = $this->filterMinAge($qb, $group->getMinAge());
}
if ($group->getMaxAge() != '') {
$qb = $this->filterMaxAge($qb, $group->getMaxAge());
}
if ($group->getActiveMember() != '') {
$qb = $this->filterActive($qb, $group->getActiveMember());
}
if (count($group->getLocation()) > 0) {
$location_arr = array();
foreach ($group->getLocation() as $location) {
$location_arr[] = $location->getId();
}
$qb = $this->filterLocation($qb, $location_arr);
}
return $qb->getQuery();
}