This model allows for the definition of "secondary to" options for disorders specified in CommonOphthalmicDisorder
They should be provided as choices in disorder widgets that use the common disorder drop downs in diagnoses selection.
The followings are the available columns in table 'common_ophthalmic_disorder':
/**
* Wrapper to handle ordering for secondary to disorders
*
* @param $cod
* @return mixed
*/
public function getNextDisplayOrderForParent($cod)
{
if (!array_key_exists($cod->id, $this->second_display_order)) {
$criteria = new CDbCriteria();
$criteria->addCondition('parent_id = :id');
$criteria->params[':id'] = $cod->id;
$criteria->order = 'display_order desc';
$criteria->limit = 1;
if ($st = SecondaryToCommonOphthalmicDisorder::model()->find($criteria)) {
$this->second_display_order[$cod->id] = $st->display_order;
} else {
$this->second_display_order[$cod->id] = 0;
}
}
return ++$this->second_display_order[$cod->id];
}
public function actionImport($args)
{
$filename = $args[0];
if (!$filename) {
$this->usageError('Import filename required');
}
if (!file_exists($filename)) {
$this->usageError("Cannot find import file " . $filename);
}
if (!$this->reset_parent) {
$this->required_cols[] = 'disorder_id';
}
$connection = Yii::app()->db;
$transaction = $connection->beginTransaction();
try {
SecondaryToCommonOphthalmicDisorder::model()->deleteAll();
$file = file($filename);
$columns = array();
$count = 0;
$warnings = array();
foreach ($file as $index => $line) {
if (!$index) {
$columns = str_getcsv($line, ',', '"');
foreach ($this->required_cols as $req) {
if (!in_array($req, $columns)) {
throw new Exception("Missing required column '{$req}' from file {$filename}");
}
}
} else {
if (!strlen(trim($line))) {
// skip empty line
continue;
}
$record = str_getcsv($line, ',', '"');
$data = array();
foreach ($columns as $i => $col) {
$data[$col] = $record[$i];
}
if (!($subspecialty = $this->getSubspecialty($data['subspecialty_code']))) {
$warnings[] = "no subspecialty found for {$data['subspecialty_code']}";
} else {
if ($this->reset_parent) {
$this->resetSubspecialty($subspecialty);
}
if ($cod = $this->getCOD($data['parent_disorder_id'], $subspecialty)) {
if ($st_disorder = $this->getDisorder($data['disorder_id'])) {
$st = new SecondaryToCommonOphthalmicDisorder();
$st->parent_id = $cod->id;
$st->disorder_id = $st_disorder->id;
$st->save();
$count++;
} else {
if (!$this->reset_parent) {
$warnings[] = "Cannot find disorder with id {$data['disorder_id']}";
}
}
} else {
$warnings[] = "{$data['parent_disorder_id']} not a common disorder for {$subspecialty->name}";
}
}
}
}
echo "Committing changes ...\n";
$transaction->commit();
echo "{$count} records created\n";
if ($warnings) {
echo "There were " . count($warnings) . " warnings:\n";
foreach ($warnings as $warn) {
echo $warn . "\n";
}
}
} catch (Exception $e) {
$transaction->rollback();
$this->usageError($e->getMessage());
}
}
public function getLetter_string()
{
$text = "";
$findings = array();
$finding_ids = array();
if ($et_findings = Element_OphCiExamination_FurtherFindings::model()->find('event_id=?', array($this->event_id))) {
foreach (OphCiExamination_FurtherFindings_Assignment::model()->findAll('element_id=?', array($et_findings->id)) as $finding) {
$finding_ids[] = $finding->finding_id;
$findings[] = $finding;
}
}
$disorders = array();
$disorder_ids = array('Left' => array(), 'Right' => array(), 'Both' => array());
$is_principal = array();
foreach (OphCiExamination_Diagnosis::model()->findAll('element_diagnoses_id=?', array($this->id)) as $diagnosis) {
$disorder_ids[$diagnosis->eye->name][] = $diagnosis->disorder_id;
$disorders[] = $diagnosis;
$is_principal[$diagnosis->disorder_id] = $diagnosis->principal;
}
$secto_strings = array();
$used_disorder_ids = array();
$used_finding_ids = array();
if (isset(\Yii::app()->session['selected_firm_id']) && \Yii::app()->session['selected_firm_id'] !== null) {
$firm = \Firm::model()->findByPk(\Yii::app()->session['selected_firm_id']);
$subspecialty = $firm->serviceSubspecialtyAssignment->subspecialty;
foreach ($disorders as $disorder) {
foreach (\SecondaryToCommonOphthalmicDisorder::model()->with('parent')->findAll('t.disorder_id=? and parent.subspecialty_id=?', array($disorder->disorder_id, $subspecialty->id)) as $secto_disorder) {
if ($secto_disorder->letter_macro_text) {
if ($secto_disorder->parent->disorder_id) {
if (in_array($secto_disorder->parent->disorder_id, $disorder_ids[$disorder->eye->name]) || in_array($secto_disorder->parent->disorder_id, $disorder_ids['Both'])) {
$secto_strings[] = ($is_principal[$disorder->disorder_id] || $is_principal[$secto_disorder->parent->disorder_id] ? '' : 'Secondary diagnosis: ') . $disorder->eye->name . " " . $secto_disorder->letter_macro_text;
$used_disorder_ids[] = $disorder->disorder_id;
$used_disorder_ids[] = $secto_disorder->parent->disorder_id;
}
} elseif ($secto_disorder->parent->finding_id) {
if (in_array($secto_disorder->parent->finding_id, $finding_ids)) {
$secto_strings[] = ($is_principal[$disorder->disorder_id] ? '' : 'Secondary diagnosis: ') . $disorder->eye->name . " " . $secto_disorder->letter_macro_text;
$used_disorder_ids[] = $disorder->disorder_id;
$used_finding_ids[] = $secto_disorder->parent->finding_id;
}
}
}
}
}
foreach ($findings as $finding) {
foreach (\SecondaryToCommonOphthalmicDisorder::model()->with('parent')->findAll('t.finding_id=? and parent.subspecialty_id=?', array($finding->finding_id, $subspecialty->id)) as $secto_disorder) {
if ($secto_disorder->letter_macro_text) {
if ($secto_disorder->parent->disorder_id) {
if ($eye = $this->getEyeForDisorder($secto_disorder->parent->disorder_id, $disorder_ids)) {
$secto_strings[] = ($is_principal[$secto_disorder->parent->disorder_id] ? '' : 'Secondary diagnosis: ') . $eye . " " . $secto_disorder->letter_macro_text;
$used_disorder_ids[] = $secto_disorder->parent->disorder_id;
$used_finding_ids[] = $finding->finding_id;
}
}
}
}
}
}
$criteria = new \CDbCriteria();
$criteria->addCondition('element_diagnoses_id=:ed');
$criteria->params[':ed'] = $this->id;
$criteria->addCondition('principal=1');
if (!empty($used_disorder_ids)) {
$criteria->addNotInCondition('disorder_id', $used_disorder_ids);
}
if ($principal = OphCiExamination_Diagnosis::model()->find($criteria)) {
$text .= "Principal diagnosis: " . $principal->eye->adjective . " " . $principal->disorder->term . "\n";
}
if (!empty($secto_strings)) {
$text .= implode("\n", $secto_strings) . "\n";
}
$criteria = new \CDbCriteria();
$criteria->addCondition('element_diagnoses_id=:ed');
$criteria->params[':ed'] = $this->id;
$criteria->addCondition('principal=0');
if (!empty($used_disorder_ids)) {
$criteria->addNotInCondition('disorder_id', $used_disorder_ids);
}
foreach (OphCiExamination_Diagnosis::model()->findAll($criteria) as $diagnosis) {
if ($diagnosis->disorder) {
$text .= "Secondary diagnosis: " . $diagnosis->eye->adjective . " " . $diagnosis->disorder->term . "\n";
}
}
if ($ff = Element_OphCiExamination_FurtherFindings::model()->find('event_id=?', array($this->event_id))) {
if ($string = $ff->getFurtherFindingsAssignedString($used_finding_ids)) {
$text .= "Further Findings: {$string}\n";
}
}
return $text;
}
/**
* Returns a JSON response. Empty if the provided disorder id is not in the common list for the
* current session firm subspecialty. Otherwise, contains details of disorder, and all secondary to disorders
* configured for the disorder/subspecialty
*
* @param $id
*/
public function actionIsCommonOphthalmicWithSecondary($id)
{
$firm = Firm::model()->findByPk(Yii::app()->session['selected_firm_id']);
$result = array();
if ($subspecialty_id = $firm->getSubspecialtyID()) {
if ($cd = CommonOphthalmicDisorder::model()->with(array('disorder', 'secondary_to_disorders'))->findByAttributes(array('disorder_id' => $id, 'subspecialty_id' => $subspecialty_id))) {
$result['disorder'] = array('id' => $cd->disorder_id, 'term' => $cd->disorder->term);
if ($sts = $cd->secondary_to_disorders) {
$result['secondary_to'] = array();
foreach ($sts as $st) {
$result['secondary_to'][] = array('id' => $st->id, 'term' => $st->term);
}
}
echo CJSON::encode($result);
} elseif ($sts = SecondaryToCommonOphthalmicDisorder::model()->with(array('disorder', 'parent'))->findAll('t.disorder_id = :disorder_id AND parent.subspecialty_id = :subspecialty_id', array(":disorder_id" => $id, ":subspecialty_id" => $subspecialty_id))) {
$result['disorder'] = array('id' => $sts[0]->disorder_id, 'term' => $sts[0]->disorder->term);
$result['owned_by'] = array();
foreach ($sts as $st) {
$result['owned_by'][] = array('id' => $st->parent->disorder_id);
}
echo CJSON::encode($result);
}
}
}
