/**
* EXPORT DATA CUSTOMER TO EXCEL USING AJAX
* export_data
* @author wawan
*/
public function actionPilihExportData()
{
$model = new Customers();
$model->scenario = "export";
if ($model->load(Yii::$app->request->post())) {
$data_cus = Customers::find()->select('CUST_KD,CUST_NM,(SELECT CUST_KTG_NM FROM c0001k WHERE CUST_KTG=CUST_TYPE limit 1) AS TYPE_NM, ALAMAT,TLP1,PIC')->orderBy('CUST_NM ASC')->where(['CUST_GRP' => $model->CUST_GRP])->asArray()->all();
$cusDataProviderMTI = new ArrayDataProvider(['key' => 'CUST_KD', 'allModels' => $data_cus]);
$aryCusDataProviderMTI = $cusDataProviderMTI->allModels;
$excel_data = Postman4ExcelBehavior::excelDataFormat($aryCusDataProviderMTI);
$excel_title = $excel_data['excel_title'];
$excel_ceils = $excel_data['excel_ceils'];
$excel_content = [['sheet_name' => 'MTI CUSTOMER', 'sheet_title' => $excel_title, 'ceils' => $excel_ceils, 'headerColor' => Postman4ExcelBehavior::getCssClass("header"), 'headerColumnCssClass' => ['CUST_KD' => Postman4ExcelBehavior::getCssClass('header'), 'CUST_NM' => Postman4ExcelBehavior::getCssClass('header'), 'TYPE_NM' => Postman4ExcelBehavior::getCssClass('header'), 'ALAMAT' => Postman4ExcelBehavior::getCssClass('header'), 'TLP1' => Postman4ExcelBehavior::getCssClass('header'), 'PIC' => Postman4ExcelBehavior::getCssClass('header')], 'oddCssClass' => Postman4ExcelBehavior::getCssClass("odd"), 'evenCssClass' => Postman4ExcelBehavior::getCssClass("even")]];
//$excel_file = "CustomerDataERPPilih".'-'.date('Ymd-his');
$excel_file = "CustomerData";
//$this->export2excel($excel_content, $excel_file,1);
$this->export4excel($excel_content, $excel_file);
// return $this->redirect('esm-index');
} else {
return $this->renderAjax('_pilih_export', ['model' => $model]);
}
}
public function actionValid()
{
# code...
$post = Yii::$app->request->post();
if ($post['Customers']['parentnama'] == 1) {
$model = new Customers();
$model->scenario = "create";
} else {
$model = new Customers();
$model->scenario = "parentcreate";
}
// $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($id)
{
$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();
$query = Schedulegroup::find()->all();
$field_group_nm = Schedulegroup::find()->where(['ID' => $id])->one();
$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 = $id;
$model1->save();
return $this->redirect(['index', 'SCDL_GROUP' => $id]);
} else {
return $this->renderAjax('form_scdl', ['model' => $model, 'cari_group' => $cari_group, 'cari_cus' => $cari_cus, 'field_group_nm' => $field_group_nm]);
}
}
