/**
  * @param Site $site
  * @return array
  */
 public function findAllByParentSites(Site $site)
 {
     $siteIds = $site->getParentSiteIds();
     array_push($siteIds, $site->getId());
     $q = $this->createQueryBuilder('q')->where('q.site IN (:site_ids)')->setParameter('site_ids', $siteIds)->getQuery();
     $results = $q->getResult();
     return $results;
 }
 /**
  * @param Site $site
  * @return mixed
  */
 public function countBySite(Site $site)
 {
     $siteIds = $site->getParentSiteIds();
     array_push($siteIds, $site->getId());
     $q = $this->createQueryBuilder('o')->select('count(o.id)')->where('o.site IN (:site_ids)')->setParameter('site_ids', $siteIds)->getQuery();
     return $q->getSingleScalarResult();
 }