public function actionAjaxCreate($field, $value)
{
$model = new Fdm2Dimension2();
$model->{$field} = $value;
try {
if ($model->save()) {
return TRUE;
} else {
return var_export($model->getErrors());
}
} catch (Exception $e) {
throw new CHttpException(500, $e->getMessage());
}
}
/**
* get or create record for table
* @param int $fret_id - ref type (first dimension level)
* @param int $ref_id - refernce table record id
* @param string $code
* @param string $name
* @return type
*/
public static function getDim2Id($fret_id, $ref_id, $code, $name = false)
{
if (!$name) {
$name = $code;
}
//search existing record
$criteria = new CDbCriteria();
$criteria->compare('fdm2_sys_ccmp_id', Yii::app()->sysCompany->getActiveCompany());
$criteria->compare('fdm2_fret_id', $fret_id);
$criteria->compare('fdm2_ref_id', $ref_id);
if ($fdm2 = Fdm2Dimension2::model()->find($criteria)) {
return $fdm2->fdm2_id;
}
$fret = FretRefType::model()->findByPk($fret_id);
//add record
$fdm2 = new Fdm2Dimension2();
$fdm2->fdm2_fret_id = $fret_id;
$fdm2->fdm2_ref_id = $ref_id;
$fdm2->fdm2_fdm1_id = $fret->fret_fdm1_id;
$fdm2->fdm2_code = substr($code, 0, 10);
$fdm2->fdm2_name = $name;
$fdm2->save();
return $fdm2->primaryKey;
}
