public function kdbarang($kdDbtr, $kdType, $kdKategori, $kdUnit) { $model = new Barang(); $ck = Barang::find()->select('KD_BARANG')->where('STATUS <> 3')->orderBy(['ID' => SORT_DESC])->one(); if (count($ck) == 0) { $nkd = 1; } else { $kd = explode('.', $ck->KD_BARANG); $nkd = $kd[6] + 1; } $kd = "BRG." . $kdDbtr . "." . $kdType . "." . $kdKategori . "." . $kdUnit . "." . str_pad($nkd, "4", "0", STR_PAD_LEFT); return $kd; }
use kartik\grid\GridView; use yii\widgets\ActiveForm; use yii\helpers\ArrayHelper; use kartik\widgets\Select2; use kartik\widgets\DepDrop; use yii\helpers\Url; use kartik\builder\Form; use kartik\widgets\TouchSpin; use yii\web\JsExpression; use yii\data\ActiveDataProvider; use lukisongroup\esm\models\Barang; use lukisongroup\master\models\Kategori; use lukisongroup\master\models\Unitbarang; $brgUnit = ArrayHelper::map(Unitbarang::find()->orderBy('NM_UNIT')->all(), 'KD_UNIT', 'NM_UNIT'); $brgKtg = ArrayHelper::map(Kategori::find()->orderBy('NM_KATEGORI')->all(), 'KD_KATEGORI', 'NM_KATEGORI'); $brgProdak = ArrayHelper::map(Barang::find()->orderBy('NM_BARANG')->all(), 'KD_BARANG', 'NM_BARANG'); /* $this->registerJs(" $.fn.modal.Constructor.prototype.enforceFocus = function() {}; ",$this::POS_HEAD); */ ?> <?php $form = ActiveForm::begin(['id' => 'sa-input', 'enableClientValidation' => true, 'method' => 'post', 'action' => ['/purchasing/sales-order/simpanfirst']]); ?> <?php //= $form->errorSummary($model); ?> <?php
public function actionSimpantambah() { $Detaildinas = new Sadetail(); if ($Detaildinas->load(Yii::$app->request->post()) && $Detaildinas->validate()) { $hsl = \Yii::$app->request->post(); $kdro = $hsl['Sadetail']['KD_SA']; $kdBarang = $hsl['Sadetail']['KD_BARANG']; $nmBarang = Barang::findOne(['KD_BARANG' => $kdBarang]); $kdUnit = $hsl['Sadetail']['UNIT']; $rqty = $hsl['Sadetail']['RQTY']; $note = $hsl['Sadetail']['NOTE']; /* * Detail Request Order **/ $Detaildinas->KD_SA = $kdro; $Detaildinas->CREATED_AT = date('Y-m-d H:i:s'); $Detaildinas->NM_BARANG = $nmBarang->NM_BARANG; $Detaildinas->KD_BARANG = $kdBarang; $Detaildinas->UNIT = $kdUnit; $Detaildinas->RQTY = $rqty; $Detaildinas->NOTE = $note; $Detaildinas->STATUS = 0; $Detaildinas->dinasve(); return $this->redirect(['index?SalesorderSearch[KD_SA]=' . $kdro]); } else { return $this->redirect(['index']); } }
<td class="head">Quantity</td> <td class="head">Satuan Barang</td> <td class="head">Harga</td> <td class="head">Total Harga</td> </tr> <tbody> <?php $total = 0; $a = 0; foreach ($pod as $key => $val) { $a = $a + 1; $ckBrg = explode('.', $val->KD_BARANG); if ($ckBrg[0] == 'BRG') { $nmBrg = Barang::find('NM_BARANG')->where(['KD_BARANG' => $val->KD_BARANG])->one(); } else { if ($ckBrg[0] == 'BRGU') { $nmBrg = Barangumum::find('NM_BARANG')->where(['KD_BARANG' => $val->KD_BARANG])->one(); } } $ckUnit = preg_replace("/[^A-Z\\']/", '', $val->UNIT); if ($ckUnit == 'U') { $brg = lukisongroup\master\models\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $val->UNIT])->one(); } else { $brg = lukisongroup\esm\models\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $val->UNIT])->one(); } ?> <tr> <td><?php
public function actionCreatepo() { $post = Yii::$app->request->post(); $coall = count($post['hargaBarang']); $kdpo = $post['kdpo']; for ($i = 0; $i < $coall; $i++) { $kdBrg = $post['kdBarang'][$i]; $harga = $post['hargaBarang'][$i]; $ckBrg = explode('.', $kdBrg); if ($ckBrg[0] == 'BRG') { $nmBrg = Barang::find('NM_BARANG')->where(['KD_BARANG' => $kdBrg])->one(); $nmBrg->HARGA = $harga; $nmBrg->save(); } else { if ($ckBrg[0] == 'BRGU') { $nmBrg = Barangumum::find('NM_BARANG')->where(['KD_BARANG' => $kdBrg])->one(); $nmBrg->HARGA = $harga; $nmBrg->save(); } } $detpo = Purchasedetail::find('ID')->where(['KD_BARANG' => $kdBrg, 'KD_PO' => $kdpo])->one(); $cons = \Yii::$app->db_esm; $command = $cons->createCommand(); $command->update('p0002', ['HARGA' => $harga], "ID='{$detpo->ID}'")->execute(); } $po = Purchaseorder::find()->where(['KD_PO' => $kdpo])->one(); $po->STATUS = '101'; $po->PAJAK = $post['pajak']; $po->DISC = $post['disc']; $po->NOTE = $post['note']; $po->ETA = $post['eta']; $po->ETD = $post['etd']; $po->SHIPPING = $post['shipping']; $po->BILLING = $post['billing']; $po->DELIVERY_COST = $post['delvCost']; $po->save(); return $this->redirect([' ']); }
$a = 0; foreach ($podet as $po => $rows) { $a = $a + 1; ?> <?php if ($a == 1) { echo "</form>"; } ?> <tr style="cursor:pointer;"> <?php $ckBrg = explode('.', $rows->KD_BARANG); if ($ckBrg[0] == 'BRG') { $nmBrg = Barang::find('NM_BARANG', 'HARGA')->where(['KD_BARANG' => $rows->KD_BARANG])->one(); } else { if ($ckBrg[0] == 'BRGU') { $nmBrg = Barangumum::find('NM_BARANG', 'HARGA')->where(['KD_BARANG' => $rows->KD_BARANG])->one(); } } $ckUnit = preg_replace("/[^A-Z\\']/", '', $rows->UNIT); if ($ckUnit == 'U') { $brg = lukisongroup\master\models\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $rows->UNIT])->one(); } else { $brg = lukisongroup\esm\models\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $rows->UNIT])->one(); } ?> <td class=" accordion-toggle" data-toggle="collapse" data-target="#demo<?php echo $a;
<?php // echo $this->render('_search', ['model' => $searchModel]); ?> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'WAKTU', ['attribute' => 'CUST_KD', 'format' => 'html', 'value' => function ($model, $key, $index, $widget) { $cus_atrb = Customer::find()->where(['CUST_KD' => $model->CUST_KD])->one(); if (count($cus_atrb) == 0) { return '<div style="color:red"> CUST_KD Changed </div>'; } else { return $cus_atrb['CUST_NM']; } }], ['attribute' => 'KD_BARANG', 'format' => 'html', 'value' => function ($model, $key, $index, $widget) { $brg_atrb = Barang::find()->where(['KD_BARANG' => $model->KD_BARANG])->one(); if (count($brg_atrb) == 0) { return '<div style="color:red"> KD_BARANG Changed </div>'; } else { return $brg_atrb['NM_BARANG']; } }], ['label' => 'Stock-Unit', 'hAlign' => 'right', 'attribute' => 'STOCK_GUDANG_UNIT'], ['label' => 'Stock-PCS', 'hAlign' => 'right', 'attribute' => 'STOCK_GUDANG_PCS'], 'CREATED_BY'], 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'active']], 'toolbar' => ['{export}'], 'panel' => ['type' => 'warning', 'before' => Html::a('<i class="glyphicon glyphicon-plus"></i> ' . Yii::t('app', 'Stock Gudang ', ['modelClass' => 'customer']), '/salespromo/stock-gudang/create', ['data-toggle' => "modal", 'data-target' => "#stock-gudang", 'class' => 'btn btn-success']), 'showFooter' => false], 'export' => ['target' => GridView::TARGET_BLANK], 'exportConfig' => [GridView::PDF => ['filename' => 'customer' . '-' . date('ymdHis')], GridView::EXCEL => ['filename' => 'customer' . '-' . date('ymdHis')]]]); ?> <?php $this->registerJs("\n\t\t\$.fn.modal.Constructor.prototype.enforceFocus = function() {};\t\n \$('#stock-gudang').on('show.bs.modal', function (event) {\n var button = \$(event.relatedTarget)\n var modal = \$(this)\n var title = button.data('title') \n var href = button.attr('href') \n modal.find('.modal-title').html(title)\n modal.find('.modal-body').html('<i class=\"fa fa-spinner fa-spin\"></i>')\n \$.post(href)\n .done(function( data ) {\n modal.find('.modal-body').html(data)\t\t\t\t\t\n });\n }),\t\t\t\n ", $this::POS_READY); Modal::begin(['id' => 'stock-gudang', 'header' => '<h4 class="modal-title">Input Stock Gudang</h4>']); Modal::end(); ?> </div> </div>