OEModule\OphCiExamination\models\OphCiExamination_PostOpComplications::getPostOpComplicationsList PHP Метод

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