public function buildForm(FormBuilderInterface $builder, array $options)
{
$this->options = $options;
$this->institution = $builder->getData();
$status = InstitutionStatus::getBitValueLabels();
if (!$this->institution instanceof Institution) {
throw InstitutionFormException::nonInstitutionFormData(__CLASS__, $this->institution);
}
$this->_add($builder, 'name', 'text');
$this->_add($builder, 'status', 'choice', array('label' => 'Status', 'choices' => $status));
$this->_add($builder, 'description', 'textarea', array('required' => false));
$this->_add($builder, 'medicalProviderGroups', 'collection', array('type' => 'medicalProviderGroup_list', 'allow_add' => true, 'allow_delete' => true, 'options' => array('required' => false)));
$this->_add($builder, 'country', FancyCountryFieldType::NAME, array('label' => 'Country', 'error_bubbling' => false));
$this->_add($builder, 'city', GlobalCityListType::NAME, array('label' => 'City', 'error_bubbling' => false));
$this->_add($builder, 'zipCode', 'text', array('label' => 'Zip / Postal Code'));
$this->_add($builder, 'state', 'state_list', array('label' => 'State / Province'));
$this->_add($builder, 'contactEmail', 'text', array('label' => 'Email Address ', 'required' => false));
$this->_add($builder, 'address1', 'detailed_street_address', array('label' => 'Hospital Address'));
$this->_add($builder, 'addressHint', 'text', array('label' => 'Helpful hint for getting there?', 'required' => false));
$this->_add($builder, 'contactDetails', 'collection', array('type' => 'simple_contact_detail'));
$this->_add($builder, 'websites', 'website_custom_field', array('label' => 'Website', 'required' => false));
$this->_add($builder, 'socialMediaSites', 'social_media_sites_custom_field');
$this->_add($builder, 'logo', new InstitutionMediaFileType($this->institution->getLogo()));
$this->_add($builder, 'featuredMedia', new InstitutionMediaFileType($this->institution->getFeaturedMedia()));
$this->_add($builder, 'coordinates', 'hidden');
$this->_add($builder, 'type', 'choice', array('label' => 'Institution Type', 'empty_value' => false, 'multiple' => false, 'choices' => InstitutionTypes::getFormChoices()));
}
/**
* Added/Updated recentlyApproved institution type listing. Removed when updated from APPROVED to INACTIVE, SUSPENDED or INACTIVE
* @param Institution $institution
*/
function updateInstitutionListing(Institution $institution)
{
$criteria = array('institution' => $institution->getId(), 'institutionMedicalCenter' => null);
$recentlyApprovedListing = $this->em->getRepository('AdminBundle:RecentlyApprovedListing')->findOneBy($criteria);
if ($recentlyApprovedListing) {
if ($institution->getStatus() == InstitutionStatus::getBitValueForActiveAndApprovedStatus()) {
$recentlyApprovedListing->setDateUpdated(new \DateTime());
$this->em->persist($recentlyApprovedListing);
} else {
$this->em->remove($recentlyApprovedListing);
}
$this->em->flush();
} else {
if ($institution->getStatus() == InstitutionStatus::getBitValueForActiveAndApprovedStatus()) {
$recentlyApprovedListingService = new RecentlyApprovedListingService();
$recentlyApprovedListingService->setEntityManager($this->em);
$recentlyApprovedListing = new RecentlyApprovedListing();
$recentlyApprovedListing->setInstitution($institution);
$recentlyApprovedListing->setInstitutionMedicalCenter(null);
$recentlyApprovedListing->setDateUpdated(new \DateTime());
$recentlyApprovedListing->setStatus(1);
$this->em->persist($recentlyApprovedListing);
$this->em->flush($recentlyApprovedListing);
}
}
}
function setFilterOptions()
{
$statusOptions = array(ListFilter::FILTER_KEY_ALL => ListFilter::FILTER_LABEL_ALL) + InstitutionStatus::getBitValueLabels();
$this->setNameFilterOption();
$this->setPayingClientOption();
$this->setCountryFilterOption();
$this->setTypeFilterOption();
$this->setStatusFilterOption($statusOptions);
}
function setInstitutionFilterOption()
{
$qb = $this->doctrine->getEntityManager()->createQueryBuilder();
$qb->select('a.id, a.name')->from('InstitutionBundle:Institution', 'a')->where('a.status = :status')->orderBy('a.name', 'ASC')->setParameter('status', InstitutionStatus::getBitValueForActiveAndApprovedStatus());
$institutions = $qb->getQuery()->getResult(Query::HYDRATE_ARRAY);
$options = array(ListFilter::FILTER_KEY_ALL => ListFilter::FILTER_LABEL_ALL);
foreach ($institutions as $each) {
$options[$each['id']] = $each['name'];
}
$this->filterOptions['institution'] = array('label' => 'Institution', 'selected' => $this->queryParams['institution'], 'options' => $options);
}
function setFilteredResults()
{
$this->queryBuilder = $this->doctrine->getEntityManager()->createQueryBuilder();
$this->queryBuilder->select('a, inst')->from('InstitutionBundle:InstitutionMedicalCenter', 'a')->innerJoin('a.institution', 'inst');
$this->queryBuilder->andWhere('inst.status = :approved_status')->setParameter('approved_status', InstitutionStatus::getBitValueForApprovedStatus());
$name = \trim($this->queryParams['name']);
if ('' != $name) {
$this->queryBuilder->andWhere('inst.name LIKE :name')->setParameter('name', "%{$name}%");
}
if ($this->queryParams['country'] != ListFilter::FILTER_KEY_ALL) {
$this->queryBuilder->andWhere('inst.country = :country');
$this->queryBuilder->setParameter('country', $this->queryParams['country']);
}
if ($this->queryParams['city'] != ListFilter::FILTER_KEY_ALL) {
$this->queryBuilder->andWhere('inst.city = :city');
$this->queryBuilder->setParameter('city', $this->queryParams['city']);
}
$sortBy = $this->sortBy ? $this->sortBy : 'name';
$sort = "a.{$sortBy} " . $this->sortOrder;
$this->queryBuilder->add('orderBy', $sort);
$this->pagerAdapter->setQueryBuilder($this->queryBuilder);
$this->filteredResult = $this->pager->getResults();
}
public function getAllInstitutionByParams($params)
{
$query = $this->createQueryBuilder('a')->where('a.status = :status')->andWhere('a.name LIKE :searchTerm')->setParameter('status', InstitutionStatus::getBitValueForActiveAndApprovedStatus())->setParameter('searchTerm', '%' . $params['searchTerm'] . '%');
if ($params['countryId'] != 'all') {
$query->andWhere('a.country = :country')->setParameter('country', $params['countryId']);
}
if ($params['cityId'] != 'all') {
$query->andWhere('a.city = :city')->setParameter('city', $params['cityId']);
}
$query = $query->orderBy('a.name');
return $query->getQuery()->getResult();
}
/**
* Get the top specializations and treatments for specified city
*
* @param unknown $country
* @param number $max
* @return multitype:unknown
*/
public function getCityTopTreatments($city, $max = 5)
{
$connection = $this->getEntityManager()->getConnection();
if (is_object($city)) {
$city = $city->getId();
}
$stmt = $connection->prepare('
SELECT b.id, b.name AS name, b.slug AS specialization_slug, COUNT(DISTINCT d.city_id) AS count
FROM institution_specializations a
LEFT JOIN specializations b ON a.specialization_id = b.id
INNER JOIN institution_medical_centers c ON a.institution_medical_center_id = c.id
LEFT JOIN institutions AS d ON c.institution_id = d.id
WHERE d.city_id = :city
AND d.status = :institutionStatus
AND c.status = :imcStatus
GROUP BY b.id
ORDER BY count DESC
LIMIT :max
');
$stmt->bindValue('institutionStatus', InstitutionStatus::getBitValueForActiveAndApprovedStatus(), \PDO::PARAM_INT);
$stmt->bindValue('imcStatus', InstitutionMedicalCenterStatus::APPROVED, \PDO::PARAM_INT);
$stmt->bindValue('city', $city, \PDO::PARAM_INT);
$stmt->bindValue('max', $max, \PDO::PARAM_INT);
$stmt->execute();
$topSpecializations = $stmt->fetchAll();
$stmt = $connection->prepare('
SELECT c.id, c.name AS name, c.slug AS treatment_slug, COUNT(DISTINCT e.city_id) AS count, z.slug AS specialization_slug
FROM institution_specializations a
INNER JOIN institution_treatments b ON a.id = b.institution_specialization_id
LEFT JOIN treatments c ON b.treatment_id = c.id
INNER JOIN institution_medical_centers d ON a.institution_medical_center_id = d.id
LEFT JOIN institutions AS e ON d.institution_id = e.id
LEFT JOIN specializations AS z ON a.specialization_id = z.id
WHERE e.city_id = :city
AND c.id IS NOT NULL
AND e.status = :institutionStatus
AND d.status = :imcStatus
GROUP BY c.id
ORDER BY count DESC
LIMIT :max
');
$stmt->bindValue('institutionStatus', InstitutionStatus::getBitValueForActiveAndApprovedStatus(), \PDO::PARAM_INT);
$stmt->bindValue('imcStatus', InstitutionMedicalCenterStatus::APPROVED, \PDO::PARAM_INT);
$stmt->bindValue('city', $city, \PDO::PARAM_INT);
$stmt->bindValue('max', $max, \PDO::PARAM_INT);
$stmt->execute();
$topTreatments = $stmt->fetchAll();
return array($topSpecializations, $topTreatments);
}
/**
* Check if the $institution is Approved
*
* @param Institution $institution
* @return boolean
* @author acgvelarde
*/
public function isApproved(Institution $institution)
{
return $institution->getStatus() == InstitutionStatus::getBitValueForApprovedStatus();
}
/**
*
* @return \Doctrine\ORM\QueryBuilder
*/
private function getQueryBuilderForInstitutionPublicProfileData()
{
$qb = $this->doctrine->getEntityManager()->createQueryBuilder();
$qb->select('inst, imc, ct, co, st, icd, fm, lg')->from('InstitutionBundle:Institution', 'inst')->innerJoin('inst.institutionMedicalCenters', 'imc', Join::WITH, 'imc.status = :imcActiveStatus')->setParameter('imcActiveStatus', InstitutionMedicalCenterStatus::APPROVED)->leftJoin('inst.city', 'ct')->leftJoin('inst.country', 'co')->leftJoin('inst.state', 'st')->leftJoin('inst.contactDetails', 'icd')->leftJoin('inst.featuredMedia', 'fm')->leftJoin('inst.logo', 'lg')->where('1=1')->andWhere('inst.status = :activeStatus')->setParameter('activeStatus', InstitutionStatus::getBitValueForApprovedStatus());
return $qb;
}
/**
* Get query builder for a fully eagerloaded medical center
*
* @return \Doctrine\ORM\QueryBuilder
*/
private function getQueryBuilderForFullInstitutionMedicalCenterProfile()
{
$qb = $this->doctrine->getEntityManager()->createQueryBuilder();
$qb->select('imc, inst, co, st, ct, inst_lg, imc_lg, inst_fm, imc_m, imc_cd, imc_bh, inst_sp, sp, sp_lg, tr, sub_sp')->from('InstitutionBundle:InstitutionMedicalCenter', 'imc')->innerJoin('imc.institution', 'inst')->leftJoin('inst.country', 'co')->leftJoin('inst.state', 'st')->leftJoin('inst.city', 'ct')->leftJoin('inst.logo', 'inst_lg')->leftJoin('inst.featuredMedia', 'inst_fm')->leftJoin('imc.logo', 'imc_lg')->leftJoin('imc.media', 'imc_m')->leftJoin('imc.contactDetails', 'imc_cd')->leftJoin('imc.businessHours', 'imc_bh')->leftJoin('imc.institutionSpecializations', 'inst_sp')->leftJoin('inst_sp.specialization', 'sp')->leftJoin('sp.media', 'sp_lg')->leftJoin('sp.treatments', 'tr')->leftJoin('tr.subSpecializations', 'sub_sp')->where('1=1')->andWhere('imc.status = :imcActiveStatus')->setParameter('imcActiveStatus', InstitutionMedicalCenterStatus::APPROVED)->andWhere('inst.status = :instActiveStatus')->setParameter('instActiveStatus', InstitutionStatus::getBitValueForApprovedStatus());
return $qb;
}
/**
* Add Institution Details, step 2 when creating new institution
*
* @param Request $request
* @return \Symfony\Component\HttpFoundation\Response
* @author Chaztine Blance
*/
public function addDetailsAction(Request $request)
{
$medicalProviderGroup = $this->getDoctrine()->getRepository('InstitutionBundle:MedicalProviderGroup')->getActiveMedicalGroups();
$medicalProviderGroupArr = array();
foreach ($medicalProviderGroup as $e) {
$medicalProviderGroupArr[] = array('value' => $e->getName(), 'id' => $e->getId());
}
$this->get('services.contact_detail')->initializeContactDetails($this->institution, array(ContactDetailTypes::PHONE));
$this->institution->setName('');
//set institution name to empty
// redirect to edit institution if status is already active
if ($this->get('services.institution')->isActive($this->institution)) {
return $this->redirect($this->generateUrl('admin_institution_edit_details', array('institutionId' => $this->institution->getId())));
}
if ($request->isMethod('GET')) {
$form = $this->createForm(new InstitutionProfileFormType(), $this->institution);
}
if ($request->isMethod('POST')) {
$formVariables = $request->get(InstitutionProfileFormType::NAME);
unset($formVariables['_token']);
$removedFields = \array_diff(InstitutionProfileFormType::getFieldNames(), array_keys($formVariables));
$form = $this->createForm(new InstitutionProfileFormType(), $this->institution, array(InstitutionProfileFormType::OPTION_HIDDEN_FIELDS => array(''), InstitutionProfileFormType::OPTION_BUBBLE_ALL_ERRORS => false, InstitutionProfileFormType::OPTION_REMOVED_FIELDS => $removedFields));
$formRequestData = $request->get($form->getName());
if (isset($formRequestData['medicalProviderGroups'])) {
// we always expect 1 medical provider group
// if it is empty remove it from the array
if (isset($formRequestData['medicalProviderGroups'][0]) && '' == trim($formRequestData['medicalProviderGroups'][0])) {
unset($formRequestData['medicalProviderGroups'][0]);
}
}
$form->bind($formRequestData);
if ($form->isValid()) {
$institution = $form->getData();
// update the sign up step status
$institution->setSignupStepStatus(0);
// update to active status
$institution->setStatus(InstitutionStatus::getBitValueForActiveStatus());
$this->get('services.contact_detail')->removeInvalidContactDetails($institution);
$this->get('services.institution.factory')->save($institution);
$this->get('session')->setFlash('notice', "Successfully completed details of {$institution->getName()}.");
return $this->redirect($this->generateUrl('admin_institution_view', array('institutionId' => $this->institution->getId())));
}
}
return $this->render('AdminBundle:Institution:addDetails.html.twig', array('form' => $form->createView(), 'institution' => $this->institution, 'id' => $this->institution->getId(), 'medicalProvidersJSON' => \json_encode($medicalProviderGroupArr)));
}
/**
* Sign up page handler
*
* @param Request $request
*/
public function signUpAction(Request $request)
{
$error_message = '';
$success = false;
// checking for security context here does not work since this is not firewalled
// TODO: find a better approach
// if ($this->get('session')->get('institutionId')) {
// redirect to dashboard if there is an active session
//return $this->redirect($this->generateUrl('institution_homepage'));
// }
$factory = $this->get('services.institution.factory');
$institution = $factory->createInstance();
$institutionUser = new InstitutionUser();
$this->get('services.contact_detail')->initializeContactDetails($institutionUser, array(ContactDetailTypes::PHONE, ContactDetailTypes::MOBILE));
$form = $this->createForm(new InstitutionUserSignUpFormType(), $institutionUser);
if ($request->isMethod('POST')) {
$form->bind($request);
if ($form->isValid()) {
$postData = $request->get('institutionUserSignUp');
$institutionUser = $form->getData();
// initialize required database fields
$institution->setName(uniqid());
$institution->setAddress1('');
$institution->setContactEmail('');
$institution->setContactNumber('');
$institution->setDescription('');
$institution->setCoordinates('');
$institution->setType(trim($postData['type']));
/* FIX ME! */
$institution->setState(null);
$institution->setWebsites('');
$institution->setStatus(InstitutionStatus::getBitValueForInactiveStatus());
$institution->setZipCode('');
$institution->setSignupStepStatus(1);
// this is always the first step
$factory->save($institution);
$institutionUserService = $this->get('services.institution_user');
// create Institution user
$institutionUser->setEmail($form->get('email')->getData());
$institutionUser->setFirstName($form->get('firstName')->getData());
$institutionUser->setLastName($form->get('lastName')->getData());
$institutionUser->setContactNumber('');
$institutionUser->setPassword($institutionUserService->encryptPassword($form->get('password')->getData()));
$institutionUser->setJobTitle($form->get('jobTitle')->getData());
$institutionUser->setInstitution($institution);
$institutionUser->setStatus(SiteUser::STATUS_ACTIVE);
$this->get('services.contact_detail')->removeInvalidContactDetails($institutionUser);
// dispatch event
$this->get('event_dispatcher')->dispatch(InstitutionBundleEvents::ON_ADD_INSTITUTION, $this->get('events.factory')->create(InstitutionBundleEvents::ON_ADD_INSTITUTION, $institution, array('institutionUser' => $institutionUser)));
// auto login
$roles = $institutionUserService->getUserRolesForSecurityToken($institutionUser);
$securityToken = new UsernamePasswordToken($institutionUser, $institutionUser->getPassword(), 'institution_secured_area', $roles);
$this->get('session')->set('_security_institution_secured_area', \serialize($securityToken));
$this->get('security.context')->setToken($securityToken);
$institutionUserService->setSessionVariables($institutionUser);
// commented out due to duplicate messages
$request->getSession()->setFlash('callout', "");
return $this->redirect($this->generateUrl('institution_signup_setup_profile'));
} else {
$request->getSession()->setFlash('error', "We need you to correct some of your input. Please check the fields in red.");
}
}
return $this->render('InstitutionBundle:SignUp:signUp.html.twig', array('form' => $form->createView(), 'institutionTypes' => InstitutionTypes::getFormChoices()));
}
}
public static function getBitValueForActiveAndApprovedStatus()
{
return self::ACTIVE | self::APPROVED;
}
/**
* Get bit value of status
* @param int $status
*/
public static function getBitValue($status)
{
return \array_key_exists($status, static::$bits) ? static::$bits[$status] : null;
}
public static function getBitValueLabels()
{
return static::$bitValueLabels;
}
public static function _setStaticValues()
{
static::$bits = array(self::ACTIVE => self::ACTIVE, self::INACTIVE => self::INACTIVE, self::APPROVED => self::ACTIVE + self::APPROVED, self::UNAPPROVED => self::ACTIVE + self::UNAPPROVED, self::SUSPENDED => self::ACTIVE + self::SUSPENDED);
$list = static::getStatusList();
static::$bitValueLabels = array();
foreach (static::$bits as $key => $v) {
if (\array_key_exists($key, $list)) {
static::$bitValueLabels[$v] = $list[$key];
}
}
}
}
InstitutionStatus::_setStaticValues();
private function searchCitiesByNameWithTreatment(SearchParameterBag $searchParams)
{
$connection = $this->container->get('doctrine')->getEntityManager()->getConnection();
$treatmentId = null;
$name = '"%' . $searchParams->get('searchedTerm') . '%"';
$institutionStatus = InstitutionStatus::getBitValueForActiveAndApprovedStatus();
$imcStatus = InstitutionMedicalCenterStatus::APPROVED;
switch ($searchParams->get('treatmentType')) {
case 'specialization':
$treatmentId = $searchParams->get('specializationId');
$sql = "\n SELECT a.id AS city_id, a.name AS city_name, b.id AS country_id, b.name AS country_name\n FROM cities AS a\n LEFT JOIN countries AS b ON a.country_id = b.id\n INNER JOIN institutions AS c ON a.id = c.city_id AND b.id = c.country_id\n INNER JOIN institution_medical_centers AS d ON c.id = d.institution_id\n INNER JOIN institution_specializations AS e ON d.id = e.institution_medical_center_id\n WHERE a.name LIKE {$name}\n AND c.status = {$institutionStatus}\n AND d.status = {$imcStatus}\n AND e.specialization_id = {$treatmentId}\n ";
break;
case 'subSpecialization':
$treatmentId = $searchParams->get('subSpecializationId');
$sql = "\n SELECT a.id AS city_id, a.name AS city_name, b.id AS country_id, b.name AS country_name\n FROM cities AS a\n LEFT JOIN countries AS b ON a.country_id = b.id\n INNER JOIN institutions AS c ON a.id = c.city_id AND b.id = c.country_id\n INNER JOIN institution_medical_centers AS d ON c.id = d.institution_id\n INNER JOIN institution_specializations AS e ON d.id = e.institution_medical_center_id\n INNER JOIN institution_treatments AS f ON f.specialization_id = e.id\n LEFT JOIN treatments AS g ON f.treatment_id = g.id\n INNER JOIN treatment_sub_specializations AS h ON g.id = h.treatment_id\n WHERE a.name LIKE {$name}\n AND c.status = {$institutionStatus}\n AND d.status = {$imcStatus}\n AND h.sub_specialization_id = {$treatmentId}\n ";
break;
case 'treatment':
$treatmentId = $searchParams->get('treatmentId');
$sql = "\n SELECT a.id AS city_id, a.name AS city_name, b.id AS country_id, b.name AS country_name\n FROM cities AS a\n LEFT JOIN countries AS b ON a.country_id = b.id\n INNER JOIN institutions AS c ON a.id = c.city_id AND b.id = c.country_id\n INNER JOIN institution_medical_centers AS d ON c.id = d.institution_id\n INNER JOIN institution_specializations AS e ON d.id = e.institution_medical_center_id\n INNER JOIN institution_treatments AS f ON f.specialization_id = e.id\n WHERE a.name LIKE {$name}\n AND c.status = {$institutionStatus}\n AND d.status = {$imcStatus}\n AND f.treatment_id = {$treatmentId}\n ";
break;
}
$stmt = $connection->executeQuery($sql);
//TODO: use prepared statements. there seems to be a bug though: the code
//below will return an empty result
// $stmt = $connection->prepare($sql);
// $stmt->bindValue('name', '"%'.$searchParams->get('term').'%"');
// $stmt->bindValue('treatmentId', $treatmentId, \PDO::PARAM_INT);
//$stmt->bindValue('institutionStatus', InstitutionStatus::INACTIVE, \PDO::PARAM_INT);
return $stmt->fetchAll();
}
