protected function findModelcust($id)
{
if (($model = Customers::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
'style'=>[
'text-align'=>'center',
'width'=>'30px',
'font-family'=>'tahoma',
'font-size'=>'8pt',
'background-color'=>'rgba(0, 95, 218, 0.3)',
]
],
],
]
]; */
/* 0 | KODE CUSTOMER ALIAS TOTAL SUM
* Key-FIND : AttStatic
*/
$attDinamik[] = ['attribute' => 'CUST_GRP', 'value' => function ($model) {
$nmCustomer = Customers::find()->where(['CUST_KD' => $model['CUST_GRP']])->one();
return $nmCustomer->CUST_NM;
/* if ($nmCustomer->CUST_NM=='GIANT (DC CBT JKT GRO-GMS CONV)'){
$headerNm="GIANT";
}elseif($nmCustomer->CUST_NM=='STAR (BELTWAY OFFICE PARK)'){
$headerNm="STARMART";
}elseif($nmCustomer->CUST_NM=='HARI HARI SWALAYAN (LOKASARI)'){
$headerNm="HARI HARI";
}elseif($nmCustomer->CUST_NM=='ROBINSON (MALL TATURA PALU)'){
$headerNm="ROBINSON";
}
return $headerNm; */
/* 'value'=>function($model){
if ($model['CUST_NM']='GIANT (DC CBT JKT GRO-GMS CONV)'){
return $headerNm="GIANT";
}elseif($model['CUST_NM']='STAR (BELTWAY OFFICE PARK)'){
/**
* EXPORT DATA CUSTOMER TO EXCEL USING AJAX
* export_data
* @author wawan
*/
public function actionExportDataErp()
{
if (Yii::$app->request->isAjax) {
Yii::$app->response->format = Response::FORMAT_JSON;
$request = Yii::$app->request;
$dataKeySelect = $request->post('keysSelect');
foreach ($dataKeySelect as $key => $value) {
$array[] = $value;
}
}
$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_KD' => $array])->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 = "CustomerData";
// $this->export2excel($excel_content, $excel_file,1);
$this->export4excel($excel_content, $excel_file);
return true;
}
/**
* ACTION INDEX
*/
public function actionIndex()
{
/*CNT Barang Prodak*/
$cntBrgProdak = "SELECT COUNT(KD_BARANG) As KD_BARANG FROM b0001 WHERE PARENT=1";
$cntBrgPrdk = Barang::findBySql($cntBrgProdak)->one();
/*CNT Barang Umum*/
$cntBrgUmum = "SELECT COUNT(KD_BARANG) As KD_BARANG FROM b0001 WHERE PARENT=0";
$cntBrgUmn = Barang::findBySql($cntBrgUmum)->one();
/*CNT Barang Type*/
$cntType = "SELECT COUNT(NM_TYPE) as NM_TYPE FROM b1001";
$cntTyp = Tipebarang::findBySql($cntType)->one();
/*CNT Barang Kategori*/
$cntCategory = "SELECT COUNT(NM_KATEGORI) as NM_KATEGORI FROM b1002";
$cntCtg = Kategori::findBySql($cntCategory)->one();
/*CNT Barang Unit*/
$cntUnit = "SELECT COUNT(KD_UNIT) as KD_UNIT FROM ub0001";
$cntUnt = Unitbarang::findBySql($cntUnit)->one();
/*CNT Supplier*/
$cntSupplier = "SELECT COUNT(KD_SUPPLIER) as KD_SUPPLIER FROM s1000";
$cntSpl = Suplier::findBySql($cntSupplier)->one();
/*CNT Distributor*/
$cntDistributor = "SELECT COUNT(KD_DISTRIBUTOR) as KD_DISTRIBUTOR FROM d0001";
$cntDist = Distributor::findBySql($cntDistributor)->one();
/*CNT Customer*/
$cntCustomer = "SELECT COUNT(CUST_KD) as CUST_KD FROM c0001";
$cntCst = Customers::findBySql($cntCustomer)->one();
//print_r($cntBrgPrdk->KD_BARANG);
return $this->render('index', ['cntBrgPrdk' => $cntBrgPrdk->KD_BARANG, 'cntBrgUmn' => $cntBrgUmn->KD_BARANG, 'cntTyp' => $cntTyp->NM_TYPE, 'cntCtg' => $cntCtg->NM_KATEGORI, 'cntUnt' => $cntUnt->KD_UNIT, 'cntSpl' => $cntSpl->KD_SUPPLIER, 'cntDist' => $cntDist->KD_DISTRIBUTOR, 'cntCst' => $cntCst->CUST_KD]);
}
public function getCust()
{
return $this->hasOne(Customers::className(), ['CUST_KD' => 'CUST_ID']);
}
public function searchNoo($params)
{
// $query = Customers::find()->joinWith('cus',true,'JOIN')
// ->where('c0001.STATUS <> 3');
$query = Customers::find()->where("STATUS<>3 AND CUST_GRP='CUS.2016.000637'");
// ->orderBy(['CUST_KD'=>SORT_ASC]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 50]]);
$dataProvider->sort->attributes['cus.CUST_KTG_NM'] = ['asc' => ['c0001k.CUST_KTG_NM' => SORT_ASC], 'desc' => ['c0001k.CUST_KTG_NM' => SORT_DESC]];
$dataProvider->sort->attributes['custype.CUST_KTG_NM'] = ['asc' => ['c0001k.CUST_KTG_NM' => SORT_ASC], 'desc' => ['c0001k.CUST_KTG_NM' => SORT_DESC]];
$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 $dataProvider;
}
$query->andFilterWhere(['like', 'CUST_KD', $this->CUST_KD])->andFilterWhere(['like', 'CUST_KD_ALIAS', $this->CUST_KD_ALIAS])->andFilterWhere(['like', 'TLP1', $this->TLP1])->andFilterWhere(['like', 'TLP2', $this->TLP2])->andFilterWhere(['like', 'FAX', $this->FAX])->andFilterWhere(['like', 'CUST_KTG', $this->getAttribute('c0001k.CUST_KTG')])->andFilterWhere(['like', 'CUST_TYPE', $this->getAttribute('custype.CUST_KTG_NM')])->andFilterWhere(['like', 'CUST_NM', $this->CUST_NM])->andFilterWhere(['like', 'CUST_GRP', 'CUS.2016.000637'])->andFilterWhere(['like', 'MAP_LAT', $this->MAP_LAT])->andFilterWhere(['like', 'MAP_LNG', $this->MAP_LNG])->andFilterWhere(['like', 'PIC', $this->PIC])->andFilterWhere(['like', 'ALAMAT', $this->ALAMAT])->andFilterWhere(['like', 'EMAIL', $this->EMAIL])->andFilterWhere(['like', 'WEBSITE', $this->WEBSITE])->andFilterWhere(['like', 'NOTE', $this->NOTE])->andFilterWhere(['like', 'NPWP', $this->NPWP])->andFilterWhere(['like', 'DATA_ALL', $this->DATA_ALL])->andFilterWhere(['like', 'JOIN_DATE', $this->JOIN_DATE])->andFilterWhere(['like', 'CUST_GRP', $this->parentName])->andFilterWhere(['like', 'LAYER', $this->LAYER])->andFilterWhere(['like', 'GEO', $this->GEO])->andFilterWhere(['like', 'c0001.STATUS', $this->STATUS])->andFilterWhere(['like', 'c0001.DC_STATUS', $this->DC_STATUS]);
// ->andFilterWhere(['like', 'CORP_ID', $this->CORP_ID])
// ->andFilterWhere(['like', 'CREATED_BY', $this->CREATED_BY])
// ->andFilterWhere(['like', 'UPDATED_BY', $this->UPDATED_BY]);
$query->orderby(['CUST_GRP' => SORT_ASC]);
//SORT PENTING UNTUK RECURSIVE BIAR TREE BISA URUTAN, save => (IF (PATENT =0) {SORT=ID}, ELSE {SORT=PATENT}, note Parent=ID header
return $dataProvider;
}
public function getCuslayer()
{
return $this->hasOne(Customers::className(), ['LAYER' => 'LAYER_ID']);
}
public function getCustTbl()
{
return $this->hasOne(Customers::className(), ['CUST_KD' => 'KD_CUSTOMER']);
}
public function actionJsoncalendar_add()
{
if (Yii::$app->request->isAjax) {
$request = Yii::$app->request;
$model = new Scheduleheader();
$profile = Yii::$app->getUserOpt->Profile_user();
$usercreate = $profile->username;
$end = $request->post('tgl2');
$start = $request->post('tgl1');
$scdl_group = $request->post('scdl_group');
$user_id = $request->post('user_id');
$note = $request->post('note');
$model->TGL1 = $start;
$model->TGL2 = $end;
$model->CREATE_BY = $usercreate;
$model->CREATE_AT = date("Y-m-d H:i:s");
$model->NOTE = $note;
$model->SCDL_GROUP = $scdl_group;
$model->USER_ID = $user_id;
$carisdl = ScheduleDetail::find()->where(['TGL' => $model->TGL1, 'SCDL_GROUP' => $scdl_group])->one();
// print_r($carisdl);
// die();
// if exist data customers
if ($carisdl) {
echo 2;
} else {
if ($model->save()) {
// foreach date :author wawan
for ($date = strtotime($start); $date < strtotime($end); $date = strtotime("+1 day", $date)) {
$tgl = date("Y-m-d", $date);
$Customers = Customers::find()->where(['SCDL_GROUP' => $scdl_group])->asArray()->all();
foreach ($Customers as $key => $value) {
# code...
$connection = Yii::$app->db_esm;
$connection->createCommand()->batchInsert('c0002scdl_detail', ['TGL', 'CUST_ID', 'SCDL_GROUP', 'USER_ID'], [[$tgl, $value['CUST_KD'], $scdl_group, $user_id]])->execute();
}
}
}
}
}
return true;
}
public function actionCreateGroup($tgl1, $tgl2)
{
$ary = [['id' => 0, 'UBAH_NM' => 'permanen'], ['id' => 1, 'UBAH_NM' => 'Update']];
$val = ArrayHelper::map($ary, 'id', 'UBAH_NM');
$post = Yii::$app->request->post();
$post['Scheduleheadertemp']['STT_UBAH'];
// if equal 1 then update else save
if ($post['Scheduleheadertemp']['STT_UBAH'] == 1) {
$model = Scheduleheadertemp::find()->where(['TGL1' => $tgl1])->one();
if ($model->load(Yii::$app->request->post())) {
$model->TGL1 = $tgl1;
$model->TGL2 = $tgl2;
// cari group nama
$cari_groupName = Schedulegroup::find()->where(['ID' => $model->SCDL_GROUP])->asArray()->one();
/* split array author : wawan*/
$temp = explode(" ", $cari_groupName['SCDL_GROUP_NM']);
$result = '';
foreach ($temp as $t) {
$result .= $t[0];
}
//$model->NOTE = $result;
$model->NOTE = $cari_groupName['SCDL_GROUP_NM'];
/*Update by ptr.nov*/
$model->save();
return $this->redirect(['index']);
} else {
return $this->renderAjax('_formschedule', ['model' => $model, 'datagroup' => $datagroup, 'datauser' => $datauser, 'val' => $val, 'tgl1' => $tgl1]);
}
} else {
$model = new Scheduleheadertemp();
// data select2 for USER_ID where CRM and STATUS 10(active)
$connection = \Yii::$app->db_esm;
$querycariuser = '******' . $tgl1 . '") AND POSITION_SITE = "CRM" AND STATUS = 10';
$user = $connection->createCommand($querycariuser)->queryAll();
$datauser = ArrayHelper::map($user, 'id', 'username');
// data select2 for SCDL_GROUP
$connection = \Yii::$app->db_esm;
$model1 = $connection->createCommand('SELECT * from c0007 where ID NOT IN (SELECT DISTINCT(SCDL_GROUP) FROM c0002scdl_detail_temp WHERE TGL="' . $tgl1 . '")');
$query = $model1->queryAll();
$datagroup = ArrayHelper::map($query, 'ID', 'SCDL_GROUP_NM');
//componen user option
$profile = Yii::$app->getUserOpt->Profile_user();
$usercreate = $profile->username;
//proses save
if ($model->load(Yii::$app->request->post())) {
$model->TGL1 = $tgl1;
$model->TGL2 = $tgl2;
// cari group nama
$cari_groupName = Schedulegroup::find()->where(['ID' => $model->SCDL_GROUP])->asArray()->one();
/* split array author : wawan*/
$temp = explode(" ", $cari_groupName['SCDL_GROUP_NM']);
$result = '';
foreach ($temp as $t) {
$result .= $t[0];
}
//$model->NOTE = $result;
$model->NOTE = $cari_groupName['SCDL_GROUP_NM'];
/*Update by ptr.nov*/
$model->CREATE_BY = $usercreate;
$model->CREATE_AT = date("Y-m-d H:i:s");
if ($model->save()) {
// foreach date :author wawan
for ($date = strtotime($tgl1); $date <= strtotime($tgl2); $date = strtotime("+1 day", $date)) {
$tgl = date("Y-m-d", $date);
//batch insert customers author :wawan
$Customers = Customers::find()->where(['SCDL_GROUP' => $model->SCDL_GROUP])->asArray()->all();
foreach ($Customers as $key => $value) {
# code...
$connection = Yii::$app->db_esm;
$connection->createCommand()->batchInsert('c0002scdl_detail_temp', ['TGL', 'CUST_ID', 'SCDL_GROUP', 'USER_ID'], [[$tgl, $value['CUST_KD'], $model->SCDL_GROUP, $model->USER_ID]])->execute();
}
}
}
return $this->redirect(['index']);
} else {
return $this->renderAjax('_formschedule', ['model' => $model, 'datagroup' => $datagroup, 'datauser' => $datauser, 'val' => $val, 'tgl1' => $tgl1]);
}
}
}
public function getCusheader()
{
return $this->hasOne(Customers::className(), ['CUST_GRP' => 'CUST_ID_PARENT']);
}
public function aryData_cus()
{
return ArrayHelper::map(Customers::find()->where('STATUS<>3')->all(), 'CUST_KD', 'CUST_NM');
}
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use lukisongroup\master\models\Customers;
use kartik\widgets\Select2;
use yii\helpers\BaseHtml;
use lukisongroup\assets\LocateAsset;
LocateAsset::register($this);
/* @var $this yii\web\View */
/* @var $model lukisongroup\esm\models\Map */
/* @var $form yii\widgets\ActiveForm */
$datacus = ArrayHelper::map(Customers::find()->all(), 'CUST_KD', 'CUST_NM');
?>
<div class="map-form">
<?php
$form = ActiveForm::begin(['id' => $model->formName()]);
?>
<?php
echo $form->field($model, 'CUST_ID')->widget(Select2::classname(), ['data' => $datacus, 'options' => ['placeholder' => 'Pilih Nama Customers ...'], 'pluginOptions' => ['allowClear' => true]]);
?>
<div id="preSearch" class="center">
<p><br /></p> <?php
echo Html::a('IN', ['lookup'], ['class' => 'btn btn-success', 'onclick' => "javascript:beginSearch();return false;"]);
?>
</div>
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use kartik\widgets\Select2;
use lukisongroup\master\models\Customers;
use lukisongroup\hrd\models\Corp;
use lukisongroup\master\models\Distributor;
use kartik\label\LabelInPlace;
use lukisongroup\master\models\Terminvest;
use kartik\money\MaskMoney;
/* @var $this yii\web\View */
/* @var $model lukisongroup\master\models\Termcustomers */
/* @var $form yii\widgets\ActiveForm */
$data = Customers::find()->where('CUST_KD = CUST_GRP')->all();
$to = "CUST_KD";
$from = "CUST_NM";
$data1 = Corp::find()->all();
$to1 = "CORP_ID";
$from1 = "CORP_NM";
$data2 = Distributor::find()->all();
$to2 = 'KD_DISTRIBUTOR';
$from2 = "NM_DISTRIBUTOR";
$config = ['template' => "{input}\n{error}\n{hint}"];
?>
<div class="termcustomers-form">
<?php
$form = ActiveForm::begin(['id' => $model->formName()]);
?>
<?php
use yii\helpers\Html;
use kartik\grid\GridView;
use yii\bootstrap\Modal;
use yii\helpers\ArrayHelper;
use lukisongroup\master\models\Customers;
$this->params['breadcrumbs'][] = $this->title;
$this->sideCorp = 'Customers';
/* Title Select Company pada header pasa sidemenu/menu samping kiri */
$this->sideMenu = $sideMenu_control;
//'umum_datamaster'; /* kd_menu untuk list menu pada sidemenu, get from table of database */
$this->title = Yii::t('app', 'Customers');
/* title pada header page */
$datatype = ArrayHelper::map(Customers::find()->where('STATUS<>3')->groupBy('CUST_NM')->all(), 'CUST_KD', 'CUST_NM');
$gridColumns = [['class' => 'kartik\\grid\\SerialColumn', 'contentOptions' => ['class' => 'kartik-sheet-style'], 'width' => '10px', 'header' => 'No.', 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'verdana, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['attribute' => 'disnm', 'label' => 'Distributor', 'hAlign' => 'left', 'vAlign' => 'middle', 'filterType' => GridView::FILTER_SELECT2, 'filter' => $cus_dis, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true, 'contentOptions' => ['style' => ['text-align' => 'left', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]], 'filterInputOptions' => ['placeholder' => 'Select'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '210px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '210px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['attribute' => 'custpnma', 'label' => ' Customers.Parent', 'hAlign' => 'left', 'vAlign' => 'middle', 'group' => true, 'filterType' => GridView::FILTER_SELECT2, 'filter' => $cus_data, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true, 'contentOptions' => ['style' => ['text-align' => 'left', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]], 'filterInputOptions' => ['placeholder' => 'Select'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '250px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '250px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['attribute' => 'custnm', 'label' => 'Customers', 'hAlign' => 'left', 'vAlign' => 'middle', 'filterType' => GridView::FILTER_SELECT2, 'filter' => $child, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true, 'contentOptions' => ['style' => ['text-align' => 'left', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]], 'filterInputOptions' => ['placeholder' => 'Select'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '250px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '250px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['attribute' => 'KD_ALIAS', 'label' => ' Alias Code', 'hAlign' => 'left', 'vAlign' => 'middle', 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '60px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '50px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['attribute' => 'KD_CUSTOMERS', 'label' => ' ESM.Code', 'hAlign' => 'left', 'vAlign' => 'middle', 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '50px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '50px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]], ['class' => 'kartik\\grid\\ActionColumn', 'dropdown' => true, 'template' => '{update}{delete}', 'dropdownOptions' => ['class' => 'pull-right dropup'], 'dropdownButton' => ['class' => 'btn btn-default btn-xs'], 'buttons' => ['update' => function ($url, $model, $key) {
return '<li>' . Html::a('<span class="fa fa-edit fa-dm"></span>' . Yii::t('app', 'Edit'), ['update-alias', 'id' => $model->KD_CUSTOMERS], ['data-toggle' => "modal", 'data-target' => "#modal-create", 'data-title' => $model->KD_CUSTOMERS]) . '</li>';
}, 'delete' => function ($url, $model, $key) use($id_term) {
return '<li>' . Html::a('<span class="fa fa-trash fa-dm"></span>' . Yii::t('app', 'delete'), ['delete-alias', 'id' => $model->ID], []) . '</li>' . PHP_EOL;
}], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(126, 189, 188, 0.9)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]];
?>
<div class="container-full">
<div style="padding-left:15px; padding-right:15px">
<?php
echo $grid = GridView::widget(['id' => 'gv-brg-alias', 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'filterRowOptions' => ['style' => 'background-color:rgba(126, 189, 188, 0.9); align:center'], 'columns' => $gridColumns, 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'gv-brg-prodak']], 'toolbar' => ['{export}'], 'panel' => ['heading' => '<h7 class="panel-title">DISTRIBUTOR ALIAS CODE</h7>', 'before' => Html::a('<i class="glyphicon glyphicon-plus"></i> ' . Yii::t('app', 'Plus', ['modelClass' => 'Customersalias']), '/master/customers/tambah-alias-customers', ['class' => 'btn btn-primary', 'data-toggle' => "modal", 'id' => 'aliasmod', 'data-target' => "#modal-create", 'class' => 'btn btn-primary btn-sm']) . ' ' . Html::a('<i class="glyphicon glyphicon-off"></i> ' . Yii::t('app', 'Back', ['modelClass' => 'Customersalias']), '/master/customers', ['class' => 'btn btn-success btn-sm']), 'showFooter' => false], 'export' => ['target' => GridView::TARGET_BLANK], 'exportConfig' => [GridView::PDF => ['filename' => 'Alias' . '-' . date('ymdHis')], GridView::EXCEL => ['filename' => 'Alias' . '-' . date('ymdHis')]]]);
?>
</div>
</div>
<?php
/*Create and edit*/
$this->registerJs("\r\n \$.fn.modal.Constructor.prototype.enforceFocus = function(){};\r\n \$('#modal-create').on('show.bs.modal', function (event) {\r\n var button = \$(event.relatedTarget)\r\n var modal = \$(this)\r\n var title = button.data('title')\r\n var href = button.attr('href')\r\n //modal.find('.modal-title').html(title)\r\n modal.find('.modal-body').html('<i class=\"fa fa-spinner fa-spin\"></i>')\r\n \$.post(href)\r\n .done(function( data ) {\r\n modal.find('.modal-body').html(data)\r\n });\r\n })\r\n", $this::POS_READY);
use kartik\helpers\Html;
use kartik\grid\GridView;
use yii\bootstrap\Modal;
use kartik\nav\NavX;
use lukisongroup\master\models\Customers;
use yii\helpers\ArrayHelper;
// use lukisongroup\assets\MapAsset; /* CLASS ASSET CSS/JS/THEME Author: -wawan-*/
// MapAsset::register($this);
$this->params['breadcrumbs'][] = $this->title;
$this->sideCorp = 'Customers';
/* Title Select Company pada header pasa sidemenu/menu samping kiri */
$this->sideMenu = $sideMenu_control;
//'umum_datamaster'; /* kd_menu untuk list menu pada sidemenu, get from table of database */
$this->title = Yii::t('app', 'Customers');
/* title pada header page */
$parent = ArrayHelper::map(Customers::find()->where('STATUS<>3 and CUST_KD=CUST_GRP')->all(), 'CUST_KD', 'CUST_NM');
function tombolCustomers()
{
$title1 = Yii::t('app', 'Customers');
$options1 = ['id' => 'setting', 'style' => 'text-align:left'];
$icon1 = '<span class="fa fa-cogs fa-md"></span>';
$label1 = $icon1 . ' ' . $title1;
$url1 = Url::toRoute(['/master/customers/esm-index']);
//,'kd'=>$kd]);
$content = Html::a($label1, $url1, $options1);
return $content;
}
/**
* New|Change|Reset| Password Login
* @author ptrnov <*****@*****.**>
* @since 1.1
public function actionCetakpdf($id)
{
# code...
$data = Termcustomers::find()->where(['ID_TERM' => $id])->one();
$datainternal = Jobgrade::find()->where(['JOBGRADE_ID' => $data['JOBGRADE_ID']])->asArray()->one();
$datacus = Customers::find()->where(['CUST_KD' => $data->CUST_KD])->asArray()->one();
// $term = Termgeneral::find()->where(['ID'=>$data['GENERAL_TERM']])->asArray()
// ->one();
$datadis = Distributor::find()->where(['KD_DISTRIBUTOR' => $data->DIST_KD])->asArray()->one();
$datacorp = Corp::find()->where(['CORP_ID' => $data->PRINCIPAL_KD])->asArray()->one();
$sql = "SELECT c.INVES_TYPE,c.ID_TERM,c.BUDGET_PLAN,c.BUDGET_ACTUAL,c.PERIODE_START,c.PERIODE_END,b.TARGET_VALUE from c0005 c LEFT JOIN c0003 b on c.ID_TERM = b.ID_TERM where c.ID_TERM='" . $id . "'";
$data1 = Termbudget::findBySql($sql)->all();
$sqlsum = "SELECT SUM(BUDGET_PLAN) as BUDGET_PLAN,SUM(BUDGET_ACTUAL) as BUDGET_ACTUAL from c0005 where ID_TERM='" . $id . "'";
$datasum = Termbudget::findBySql($sqlsum)->one();
$dataProvider = new ArrayDataProvider(['key' => 'ID_TERM', 'allModels' => $data1, 'pagination' => ['pageSize' => 20]]);
$content = $this->renderPartial('_pdf', ['data' => $data, 'datainternal' => $datainternal, 'datacus' => $datacus, 'datadis' => $datadis, 'datacorp' => $datacorp, 'datasum' => $datasum, 'dataProvider' => $dataProvider]);
$pdf = new Pdf(['mode' => Pdf::MODE_CORE, 'format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'destination' => Pdf::DEST_BROWSER, 'content' => $content, 'cssFile' => '@lukisongroup/web/widget/pdf-asset/kv-mpdf-bootstrap.min.css', 'cssInline' => '.kv-heading-1{font-size:12px}', 'options' => ['title' => 'Term-Customers', 'subject' => 'Term'], 'methods' => ['SetHeader' => ['Copyright@LukisonGroup ' . date("r")], 'SetFooter' => ['{PAGENO}']]]);
return $pdf->render();
}
public function actionParentCus()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$parents = $_POST['depdrop_parents'];
if ($parents != null) {
$parentCus = $parents[0];
$model = Customers::find()->asArray()->where(['CUST_GRP' => $parentCus])->andwhere('CUST_KD<> CUST_GRP')->all();
foreach ($model as $key => $value) {
$out[] = ['id' => $value['CUST_KD'], 'name' => $value['CUST_NM']];
}
echo json_encode(['output' => $out, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
<div class="col-md-12"> <hr style="height:10px;margin-top: 1px; margin-bottom: 1px;color:#94cdf0"> </div> </div> </div> <!-- PARTIES/PIHAK !--> <div class="row"> <div class="col-xs-6 col-sm-6 col-md-6" style="font-family: tahoma ;font-size: 9pt;padding-left:30px"> <div> <!-- echo pihak($model); ?> --> </div> <dl> <?php $data = Customers::find()->where(['CUST_KD' => $model->CUST_KD])->asArray()->one(); $datadis = Distributor::find()->where(['KD_DISTRIBUTOR' => $model->DIST_KD])->asArray()->one(); $datacorp = Corp::find()->where(['CORP_ID' => $model->PRINCIPAL_KD])->asArray()->one(); ?> <dt><h6><u><b>PARTIES/PIHAK BERSANGKUTAN :</b></u></h6></dt> <dd>1 : <?php echo $data['CUST_NM']; ?> </dd> <dd>2 : <?php echo $datadis['NM_DISTRIBUTOR']; ?> </dd>
public function getCus()
{
# code...
return $this->hasOne(Customers::className(), ['CUST_KD' => 'CUST_KD_PARENT']);
}
private function aryCustID()
{
$dataCust = ArrayHelper::map(Customers::find()->orderBy('CUST_NM')->asArray()->all(), 'CUST_KD', 'CUST_NM');
return $dataCust;
}
public function aryData_Customers($cust_kd)
{
return ArrayHelper::map(Customers::find()->where('STATUS<>3')->andwhere(['CUST_GRP' => $cust_kd])->all(), 'CUST_NM', 'CUST_NM');
}