/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Province::find();
$dataproviderpro = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20]]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataproviderpro;
}
$query->andFilterWhere(['PROVINCE_ID' => $this->PROVINCE_ID]);
$query->andFilterWhere(['like', 'PROVINCE', $this->PROVINCE]);
return $dataproviderpro;
}
public function actionUpdatecus($id)
{
$readonly = Customers::find()->where(['CUST_KD' => $id])->asArray()->one();
// data for view
$model = $this->findModelcust($id);
$model->scenario = "detail";
$dropparentkategori = ArrayHelper::map(Kategoricus::find()->where('CUST_KTG_PARENT = CUST_KTG')->asArray()->all(), 'CUST_KTG', 'CUST_KTG_NM');
$droppro = ArrayHelper::map(Province::find()->asArray()->all(), 'PROVINCE_ID', 'PROVINCE');
$dropdis = ArrayHelper::map(\lukisongroup\master\models\Distributor::find()->all(), 'KD_DISTRIBUTOR', 'NM_DISTRIBUTOR');
if ($model->load(Yii::$app->request->post())) {
if ($model->validate()) {
$model->UPDATED_AT = date("Y-m-d H:i:s");
$model->UPDATED_BY = Yii::$app->user->identity->username;
// $model->save();
if ($model->save()) {
echo 1;
} else {
echo 0;
}
}
// print_r($model->save());
// die();
// return $this->redirect(['index']);
} else {
return $this->renderAjax('set_detail', ['model' => $model, 'dropparentkategori' => $dropparentkategori, 'droppro' => $droppro, 'dropdis' => $dropdis, 'readonly' => $readonly]);
}
}
/**
* Display Single model province.
* Display Single model Distributor.
* Display Single model Kategoricus.
* update Customers.
* @author wawan
* @since 1.1.0
* @param string $id
* @return mixed
*/
public function actionViewcust($id)
{
/*province data*/
$valpro = ArrayHelper::map(Province::find()->asArray()->all(), 'PROVINCE_ID', 'PROVINCE');
/*distributor data*/
$datadis_view = ArrayHelper::map(Distributor::find()->where('STATUS<>3')->all(), 'KD_DISTRIBUTOR', 'NM_DISTRIBUTOR');
$kategori_view = ArrayHelper::map(Kategoricus::find()->where('CUST_KTG_PARENT = CUST_KTG')->asArray()->all(), 'CUST_KTG', 'CUST_KTG_NM');
$model = $this->findModelcust($id);
if ($model->load(Yii::$app->request->post())) {
$model->UPDATED_AT = date("Y-m-d H:i:s");
$model->UPDATED_BY = Yii::$app->user->identity->username;
//$model->save(false);
if ($model->save()) {
//$model->refresh();
return $this->redirect(['/master/customers/esm-index', 'id_prn' => $model->CUST_GRP]);
//Yii::$app->session->setFlash('kv-detail-success', 'Success Message');
}
} else {
return $this->renderAjax('_view_cus', ['model' => $model, 'valpro' => $valpro, 'datadis_view' => $datadis_view, 'kategori_view' => $kategori_view]);
}
}
use lukisongroup\master\models\Kategoricus;
use lukisongroup\master\models\Province;
use lukisongroup\master\models\Kota;
use yii\web\JsExpression;
use yii\bootstrap\Modal;
use yii\helpers\Url;
use kartik\widgets\DepDrop;
/* @var $this yii\web\View */
/* @var $model lukisongroup\master\models\Customerskat */
/* @var $form yii\widgets\ActiveForm */
$dropdis = ArrayHelper::map(\lukisongroup\master\models\Distributor::find()->all(), 'KD_DISTRIBUTOR', 'NM_DISTRIBUTOR');
$config = ['template' => "{input}\n{error}\n{hint}"];
// $dropparent = ArrayHelper::map(\lukisongroup\master\models\Kategori::find()->all(),'CUST_KTG_PARENT', 'CUST_KTG_NM');
$no = 0;
$dropparentkategori = ArrayHelper::map(Kategoricus::find()->where(['CUST_KTG_PARENT' => $no])->asArray()->all(), 'CUST_KTG', 'CUST_KTG_NM');
$droppro = ArrayHelper::map(Province::find()->asArray()->all(), 'PROVINCE_ID', 'PROVINCE');
// $dropcity = ArrayHelper::map(Kota::find()->all(),'POSTAL_CODE','CITY_NAME');
// print_r( $dropparentkategori);
// die();
// Modal::begin([
// 'header'=>'<h4>Vlookup</h4>',
// 'id'=> 'modal',
// 'size'=>'modal-lg',
// ]);
// echo"<div id='modalcalon'></div>";
// modal::end();
?>
<div class="customerskat-form">
<?php
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use lukisongroup\master\models\Province;
use kartik\widgets\Select2;
/* @var $this yii\web\View */
/* @var $model lukisongroup\master\models\Kota */
/* @var $form yii\widgets\ActiveForm */
$prov = ArrayHelper::map(Province::find()->all(), 'PROVINCE_ID', 'PROVINCE');
?>
<div class="kota-form">
<?php
$form = ActiveForm::begin(['id' => $model->formName(), 'enableClientValidation' => true]);
?>
<!-- $form->field($model, 'CITY_ID')->textInput() ?> -->
<?php
echo $form->field($model, 'PROVINCE_ID')->widget(Select2::classname(), ['data' => $prov, 'options' => ['placeholder' => 'Pilih Province..'], 'pluginOptions' => ['allowClear' => true]]);
?>
<?php
echo $form->field($model, 'PROVINCE')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'TYPE')->textInput(['maxlength' => true]);
