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>
