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')); // } }