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();
}
