/**
* Delete the values for $propertyType of $institutionMedicalCenter
*
* @param InstitutionMedicalCenter $institutionMedicalCenter
* @param InstitutionPropertyType $propertyType
*/
public function clearPropertyValues(InstitutionMedicalCenter $institutionMedicalCenter, InstitutionPropertyType $propertyType)
{
$dql = "DELETE FROM InstitutionBundle:InstitutionMedicalCenterProperty a WHERE a.institutionMedicalCenter = :institutionMedicalCenterId AND a.institutionPropertyType = :institutionPropertyTypeId";
$this->doctrine->getEntityManager()->createQuery($dql)->setParameter('institutionMedicalCenterId', $institutionMedicalCenter->getId())->setParameter('institutionPropertyTypeId', $propertyType->getId())->execute();
}
public function getPropertyValues(InstitutionPropertyType $propertyType, InstitutionMedicalCenter $medicalCenter)
{
$query = $this->getEntityManager()->createQuery('
SELECT a FROM InstitutionBundle:InstitutionMedicalCenterProperty a
INNER JOIN a.institutionMedicalCenter b
LEFT JOIN a.institutionPropertyType c
WHERE a.institutionMedicalCenter = :medicalCenter
AND a.institutionPropertyType = :propertyType ')->setParameter('medicalCenter', $medicalCenter)->setParameter('propertyType', $propertyType->getId());
return $query->getResult();
}
/**
* Get values of institution $institution for property type $propertyType
*
* @param Institution $institution
* @param InstitutionPropertyType $propertyType
* @return array InstitutionProperty
*/
public function getPropertyValues(Institution $institution, InstitutionPropertyType $propertyType)
{
$dql = "SELECT a FROM InstitutionBundle:InstitutionProperty a WHERE a.institution = :institutionId AND a.institutionPropertyType = :institutionPropertyTypeId";
$result = $this->doctrine->getEntityManager()->createQuery($dql)->setParameter('institutionId', $institution->getId())->setParameter('institutionPropertyTypeId', $propertyType->getId())->getResult();
return $result;
}
