The followings are the available columns in table 'site_subspecialty_anaesthetic_agent':
public function actionAdd()
{
$subspecialtyId = $this->request->getParam('subspecialty_id');
$siteId = $this->request->getParam('site_id');
$anaestheticAgentId = $this->request->getParam('anaesthetic_agent_id');
if (!Yii::app()->request->isAjaxRequest) {
$this->render('errorpage', array('errormessage' => 'notajaxcall'));
} else {
if (!is_numeric($subspecialtyId) || !is_numeric($siteId) || !is_numeric($anaestheticAgentId)) {
echo 'error';
} else {
$criteria = new CDbCriteria();
$criteria->condition = 'anaesthetic_agent_id=:anaesthetic_agent_id AND site_id=:site_id AND subspecialty_id=:subspecialty_id';
$criteria->params = array(':anaesthetic_agent_id' => $anaestheticAgentId, ':site_id' => $siteId, ':subspecialty_id' => $subspecialtyId);
$currentSSAA = SiteSubspecialtyAnaestheticAgent::model()->findall($criteria);
if (!$currentSSAA) {
$newSSAA = new SiteSubspecialtyAnaestheticAgent();
$newSSAA->subspecialty_id = $subspecialtyId;
$newSSAA->site_id = $siteId;
$newSSAA->anaesthetic_agent_id = $anaestheticAgentId;
if ($newSSAA->save()) {
echo 'success added to SSAA';
} else {
echo 'error';
}
} else {
echo 'success';
}
}
}
}
public function actionAdd()
{
$subspecialtyId = $this->request->getParam("subspecialty_id");
$siteId = $this->request->getParam("site_id");
$anaestheticAgentId = $this->request->getParam("anaesthetic_agent_id");
if (!Yii::app()->request->isAjaxRequest) {
$this->render("errorpage", array("errormessage" => "notajaxcall"));
} else {
if (!is_numeric($subspecialtyId) || !is_numeric($siteId) || !is_numeric($anaestheticAgentId)) {
echo "error";
} else {
$newSSAAD = new SiteSubspecialtyAnaestheticAgentDefault();
$newSSAAD->subspecialty_id = $subspecialtyId;
$newSSAAD->site_id = $siteId;
$newSSAAD->anaesthetic_agent_id = $anaestheticAgentId;
if ($newSSAAD->save()) {
// If an agent is selected that is not in the site_subspecialy_anaesthetic_agent table,
// then the selected agent should automatically be added to that table as well
$criteria = new CDbCriteria();
$criteria->condition = 'anaesthetic_agent_id=:anaesthetic_agent_id AND site_id=:site_id AND subspecialty_id=:subspecialty_id';
$criteria->params = array(':anaesthetic_agent_id' => $anaestheticAgentId, ':site_id' => $siteId, ':subspecialty_id' => $subspecialtyId);
$currentSSAA = SiteSubspecialtyAnaestheticAgent::model()->findall($criteria);
if (!$currentSSAA) {
$newSSAA = new SiteSubspecialtyAnaestheticAgent();
$newSSAA->subspecialty_id = $subspecialtyId;
$newSSAA->site_id = $siteId;
$newSSAA->anaesthetic_agent_id = $anaestheticAgentId;
if ($newSSAA->save()) {
echo "success added to SSAA";
} else {
echo "error";
}
} else {
echo "success";
}
} else {
echo "error";
}
}
}
}
