function __construct() { if (!isset($this->m)) { $this->m = MatchaModel::setSenchaModel('App.model.patient.Medications'); } $this->m->setOrFilterProperties(['id']); }
function __construct() { if ($this->a == NULL) { $this->a = MatchaModel::setSenchaModel('App.model.miscellaneous.Amendment'); } $this->a->setOrFilterProperties(['assigned_to_uid']); }
public function getProviderCredentializations($params) { $this->getProviderCredentializationModel(); $this->pc->setOrFilterProperties(array('provider_id')); if (isset($params->fullList)) { $sql = "SELECT `ic`.`id` as insurance_company_id, `ic`.`name` as insurance_company_name,\n\t\t\t\t\t(SELECT id FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider1) as id,\n\t\t\t\t\t:provider2 as 'provider_id',\n\t\t\t\t\t(SELECT start_date FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider3) as start_date,\n\t\t\t\t\t(SELECT end_date FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider4) as end_date,\n\t\t\t\t\t(SELECT credentialization_notes FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider5) as credentialization_notes,\n\t\t\t\t\t(SELECT create_uid FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider6) as create_uid,\n\t\t\t\t\t(SELECT create_date FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider7) as create_date,\n\t\t\t\t\t(SELECT update_uid FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider8) as update_uid,\n\t\t\t\t\t(SELECT update_date FROM provider_credentializations as pc WHERE pc.insurance_company_id = ic.id and pc.provider_id = :provider9) as update_date\n\t\t\t\t FROM `insurance_companies` as ic"; $params = array(':provider1' => $params->providerId, ':provider2' => $params->providerId, ':provider3' => $params->providerId, ':provider4' => $params->providerId, ':provider5' => $params->providerId, ':provider6' => $params->providerId, ':provider7' => $params->providerId, ':provider8' => $params->providerId, ':provider9' => $params->providerId); return $this->pc->sql($sql)->all($params); } return $this->pc->load($params)->all(); }