public getPostOpComplicationsList ( $element_id, $operation_note_id, $subspecialty_id, $eye_id, $term = null ) |
public function getPostOpComplicationsList($element_id, $operation_note_id, $subspecialty_id, $eye_id, $term = null)
{
$criteria = new \CDbCriteria();
$criteria->addCondition('active = 1');
$criteria->addCondition('t.id NOT IN (SELECT DISTINCT complication_id ' . 'FROM ophciexamination_postop_et_complications ' . 'WHERE element_id = :element_id AND operation_note_id = :operation_note_id AND eye_id = :eye_id) ');
$criteria->params['element_id'] = $element_id;
$criteria->params['operation_note_id'] = $operation_note_id;
$criteria->params['eye_id'] = $eye_id;
if ($term && strlen($term) > 0) {
$term = addcslashes($term, '%_');
$criteria->addSearchCondition('t.name', $term);
} else {
$criteria->join = 'JOIN ophciexamination_postop_complications_subspecialty ON t.id = ophciexamination_postop_complications_subspecialty.complication_id';
$criteria->addCondition('subspecialty_id = :subspecialty_id');
$criteria->params['subspecialty_id'] = $subspecialty_id;
$criteria->order = 'ophciexamination_postop_complications_subspecialty.display_order ASC';
}
return $this->findAll($criteria);
}