public function actionComplications($id)
{
if (!Procedure::model()->findByPk($id)) {
throw new Exception("Unknown procedure: {$id}");
}
$complications = array();
foreach (Yii::app()->db->createCommand()->select("b.name")->from("complication b")->join("procedure_complication pb", "pb.complication_id = b.id")->where("pb.proc_id = {$id} and b.active = 1")->order("b.name asc")->queryAll() as $row) {
$complications[] = $row['name'];
}
echo json_encode($complications);
}