/**
* @param Site $site
* @param LoanOfficer $loanOfficer
* @return \Doctrine\ORM\QueryBuilder
*/
public function findAllByLoanOfficerQuery(Site $site, LoanOfficer $loanOfficer)
{
$siteIds = $site->getChildSiteIds();
array_push($siteIds, $site->getId());
$q = $this->createQueryBuilder('q')->where('q.site IN (:site_ids)')->andWhere('q.deleted = 0')->andWhere('q.loan_officer = :loan_officer')->orderBy('q.created', 'DESC')->setParameter('loan_officer', $loanOfficer->getId())->setParameter('site_ids', $siteIds);
return $q;
}
