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