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