public function actionIndex()
{
// if(Helper::checkRoute('index')){
$searchModel = new CustomersSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
if (Yii::$app->request->post('hasEditable')) {
$ID = \Yii::$app->request->post('editableKey');
Yii::$app->response->format = Response::FORMAT_JSON;
$model = Customers::findOne($ID);
// print_r($ID);
// die();
$out = Json::encode(['output' => '', 'message' => '']);
// fetch the first entry in posted data (there should
// only be one entry anyway in this array for an
// editable submission)
// - $posted is the posted data for Book without any indexes
// - $post is the converted array for single model validation
$post = [];
$posted = current($_POST['Customers']);
$post['Customers'] = $posted;
// load model like any single model validation
if ($model->load($post)) {
// can save model or do something before saving model
// custom output to return to be displayed as the editable grid cell
// data. Normally this is empty - whereby whatever value is edited by
// in the input by user is updated automatically.
$output = '';
/*save parent customers*/
$parent_model = Customers::find()->where(['CUST_KD' => $ID])->one();
$parent_model->CUST_GRP = $posted['CUST_KD'];
$parent_model->save();
// specific use case where you need to validate a specific
// editable column posted when you have more than one
// EditableColumn in the grid view. We evaluate here a
// check to see if buy_amount was posted for the Book model
if (isset($posted['CUST_GRP'])) {
$model->save();
// $output = Yii::$app->formatter->asDecimal($model->EMP_NM, 2);
$output = $model->CUST_GRP;
}
// similarly you can check if the name attribute was posted as well
// if (isset($posted['name'])) {
// $output = ''; // process as you need
// }
$out = Json::encode(['output' => $output, 'message' => '']);
// return ajax json encoded response and exit
echo $out;
return;
}
}
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
// }else{
// Yii::$app->user->logout();
// $this->redirect(array('/site/login'));
// }
}
/**
* Lists all Schedulegroup models.
* @return mixed
*/
public function actionIndex()
{
if (Helper::checkRoute('index')) {
$searchModel = new SchedulegroupSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$searchModelCustGrp = new CustomersSearch();
$dpListCustGrp = $searchModelCustGrp->searchCustGrp(Yii::$app->request->queryParams);
$aryStt = [['STATUS' => 0, 'STT_NM' => 'DISABLE'], ['STATUS' => 1, 'STT_NM' => 'ENABLE']];
$valStt = ArrayHelper::map($aryStt, 'STATUS', 'STT_NM');
//query for select2 in schedule-group = index
$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();
$data = ArrayHelper::map($query, 'ID', 'SCDL_GROUP_NM');
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'dpListCustGrp' => $dpListCustGrp, 'data' => $data, 'valStt' => $valStt]);
} else {
Yii::$app->user->logout();
$this->redirect(array('/site/login'));
//
}
}
