public function actionValid()
{
# code...
$model = new Customers();
if (Yii::$app->request->isAjax && $model->load($_POST)) {
Yii::$app->response->format = 'json';
return ActiveForm::validate($model);
}
}
/**
* update customers schedule group model.
* @return mixed
*/
public function actionCreateScdl()
{
$model = new Customers();
// first model using manipulate model in form
$post = Yii::$app->request->post();
$group = $post['Customers']['CusT'];
$CUST_KD = $post['Customers']['GruPCusT'];
$model1 = Customers::find()->where(['CUST_KD' => $CUST_KD])->one();
//update model
//query for select2 in schedule-group = form_scdl
$query = Yii::$app->db_esm->createCommand("SELECT * FROM `c0007` c7 WHERE NOT EXISTS (SELECT SCDL_GROUP FROM `c0001` `c1` WHERE c1.SCDL_GROUP = c7.ID)")->queryAll();
$cari_group = ArrayHelper::map($query, 'ID', 'SCDL_GROUP_NM');
//query for select2 in schedule-group = form_scdl
$querys = Yii::$app->db_esm->createCommand("SELECT * FROM `c0001` where SCDL_GROUP is null")->queryAll();
$cari_cus = ArrayHelper::map($querys, 'CUST_KD', 'CUST_NM');
if ($model->load(Yii::$app->request->post())) {
$model1->SCDL_GROUP = $group;
$model1->save();
return $this->redirect(['index']);
} else {
return $this->renderAjax('form_scdl', ['model' => $model, 'cari_group' => $cari_group, 'cari_cus' => $cari_cus]);
}
}
