public function findstatusname($workflowname, $recordstatus) { $status = Wfstatus::model()->findbysql("select wfstatusname\r\n from wfstatus a\r\n inner join workflow b on b.workflowid = a.workflowid\r\n where b.wfname = '" . $workflowname . "' and a.wfstat = " . $recordstatus); if ($status != null) { return $status->wfstatusname; } else { return 0; } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = Wfstatus::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }