/**
* @param $result
* @return IHolder
*/
public function populate($result)
{
$holder = new \App\Holder\Results\Respondent\Category();
if (isset($result["category_id_category"])) {
$holder->setCategory(Service::populateEntity($result, \App\Model\Category::getClassName(), "category"));
}
if (isset($result["entitycategory_id_entity_category"])) {
$holder->setEntitycategory(Service::populateEntity($result, EntityCategory::getClassName(), "entitycategory"));
}
return $holder;
}
public function getResultsRespondentCategory($filter)
{
$query = $this->entityManager->getRepository($this->repositoryName)->createQueryBuilder();
$query->select("category");
$query->addSelect("entitycategory");
$query->from(\App\Model\EntityCategory::getClassName(), "entitycategory");
$query->join(\App\Model\Category::getClassName(), "category", Join::WITH, "entitycategory.id_category = category.id_category");
if ($filter !== null) {
if ($filter->getIdRespondent() !== null) {
$query->andWhere($query->expr()->eq("entitycategory.id_respondent", $filter->getIdRespondent()));
}
}
return $this->getHolders($query, new \App\Holder\Mapper\Results\Respondent\Category());
}
/**
* @param EntityManager $entityManager
*/
public function __construct(EntityManager $entityManager)
{
parent::__construct($entityManager, Model\Category::getClassName());
}
