/**
* @param $request
* @return QueryBuilder|mixed
*/
private function createQueryForRecordsRequest($request)
{
$em = DB::getEntityManager();
$peopleRepo = $em->getRepository(Person::getEntityNamespace());
$peopleQB = $peopleRepo->createQueryBuilder('person');
$peopleQB->innerJoin('person.records', 'record');
$peopleQB->where('person.organisation = ' . Apollo::getInstance()->getUser()->getOrganisationId());
$peopleQB->andWhere('person.is_hidden = 0');
$peopleQB = $this->orderRecords($peopleQB, $request['sort']);
return $peopleQB;
}
/**
* @return QueryBuilder
*/
private function getQueryValidPeople()
{
$em = DB::getEntityManager();
$peopleRepo = $em->getRepository(Person::getEntityNamespace());
$organisation_id = Apollo::getInstance()->getUser()->getOrganisationId();
$pqb = $peopleRepo->createQueryBuilder('p');
$pqb->where($pqb->expr()->andX($pqb->expr()->eq('p.organisation', $organisation_id), $pqb->expr()->eq('p.is_hidden', '0')));
return $pqb;
}
