The followings are the available columns in table 'medication_common':
/**
* @throws Exception
*/
public function actionAdd()
{
$medicationId = $this->request->getParam('medication_id');
if (!Yii::app()->request->isAjaxRequest) {
$this->render('errorpage', array('errormessage' => 'notajaxcall'));
} else {
if (!is_numeric($medicationId)) {
echo 'error';
} else {
$newCSD = new CommonMedications();
$newCSD->medication_id = $medicationId;
if ($newCSD->save()) {
echo 'success';
} else {
echo 'error';
}
}
}
}
/**
* @throws Exception
*/
public function actionAdd()
{
$medicationId = $this->request->getParam("medication_id");
if (!Yii::app()->request->isAjaxRequest) {
$this->render("errorpage", array("errormessage" => "notajaxcall"));
} else {
if (!is_numeric($medicationId)) {
echo "error";
} else {
$newCSD = new CommonMedications();
$newCSD->medication_id = $medicationId;
if ($newCSD->save()) {
echo "success";
} else {
echo "error";
}
}
}
}
/**
* @param $subspecialty_id
*
* @return array
*/
public function listBySubspecialtyWithCommonMedications($subspecialty_id)
{
$criteria = new CDbCriteria();
$criteria->compare('subspecialty_id', $subspecialty_id);
$drugs = self::model()->with('subspecialtyAssignments')->findAll($criteria);
$common_medication_drugs = CommonMedications::model()->with('medication_drug')->findAll();
$return = array();
foreach ($drugs as $drug) {
$return[] = array('label' => $drug->name, 'value' => $drug->name, 'id' => $drug->id);
}
foreach ($common_medication_drugs as $common_medication_drug) {
$return[] = array('label' => $common_medication_drug->medication_drug->name, 'value' => $common_medication_drug->medication_drug->name, 'id' => $common_medication_drug->medication_drug->id . '@@M');
}
asort($return);
return CHtml::listData($return, 'id', 'label');
}