/**
  * @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;
 }