public function get_aryBarang()
{
$sql = Barang::find()->where('KD_CORP="ESM" AND PARENT= 1 AND STATUS<>3')->all();
return ArrayHelper::map($sql, function ($sql, $defaultValue) {
return $sql->KD_BARANG . ',' . $sql->NM_BARANG;
}, 'NM_BARANG');
}
/**
* Lists all Barangalias models.
* @return mixed
*/
public function actionProduct()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$parents = $_POST['depdrop_parents'];
if ($parents != null) {
$id = $parents[0];
$model = Barang::find()->asArray()->where(['PARENT' => $id])->andwhere('STATUS <> 3')->all();
// print_r($model);
// die();
//$out = self::getSubCatList($cat_id);
// the getSubCatList function will query the database based on the
// cat_id and return an array like below:
// [
// ['id'=>'<sub-cat-id-1>', 'name'=>'<sub-cat-name1>'],
// ['id'=>'<sub-cat_id_2>', 'name'=>'<sub-cat-name2>']
// ]
foreach ($model as $key => $value) {
$out[] = ['id' => $value['KD_BARANG'], 'name' => $value['NM_BARANG']];
}
echo json_encode(['output' => $out, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
/**
* Check PO PLUS| kD_PO kD_BARANG =0 | Jika Ada, update Harga/QTY
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function findcheck($attribute, $params)
{
if (!$this->hasErrors()) {
$cntDetailPo = Purchasedetail::find()->where('STATUS<>3 AND KD_PO="' . $this->kD_PO . '" AND KD_BARANG="' . $this->kD_BARANG . '"')->count();
if ($cntDetailPo) {
$this->addError($attribute, 'SKU Alrady Exist,Please Update Quantity or Price');
} else {
$brg = Barang::find()->where(['KD_BARANG' => $this->kD_BARANG])->one();
//$roDetail = Rodetail::find()->where(['KD_RO'=>$kD_RO,'KD_BARANG'=>$this->kD_BARANG])->all();
$brgUnit = $brg->unitb;
$this->nM_BARANG = $brg->NM_BARANG;
$this->hARGA = $brg->PARENT == 1 ? $brg->HARGA_PABRIK : $brg->HARGA_SPL;
$this->nM_UNIT = $brgUnit->NM_UNIT;
$this->qTY_UNIT = $brgUnit->QTY;
$this->wEIGHT_UNIT = $brgUnit->WEIGHT;
}
}
}
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\master\models\Tipebarang;
use lukisongroup\master\models\Kategori;
use lukisongroup\master\models\Unitbarang;
use lukisongroup\master\models\Barang;
use lukisongroup\hrd\models\Corp;
$userCorp = ArrayHelper::map(Corp::find()->where('CORP_STS<>3')->all(), 'CORP_ID', 'CORP_NM');
$brgUnit = ArrayHelper::map(Unitbarang::find()->where('STATUS<>3')->orderBy('NM_UNIT')->all(), 'KD_UNIT', 'NM_UNIT');
$brgType = ArrayHelper::map(Tipebarang::find()->where('PARENT=1 AND STATUS<>3')->orderBy('NM_TYPE')->all(), 'KD_TYPE', 'NM_TYPE');
$brgKtg = ArrayHelper::map(Kategori::find()->where('PARENT=1 AND STATUS<>3')->orderBy('NM_KATEGORI')->all(), 'KD_KATEGORI', 'NM_KATEGORI');
$brgProdak = ArrayHelper::map(Barang::find()->where('PARENT=1 AND STATUS<>3')->orderBy('NM_BARANG')->all(), 'KD_BARANG', 'NM_BARANG');
?>
<?php
$form = ActiveForm::begin(['id' => 'roInput', 'enableClientValidation' => true, 'method' => 'post', 'action' => ['/purchasing/request-order/simpanfirst']]);
?>
<?php
//= $form->errorSummary($model);
?>
<?php
echo $form->field($roDetail, 'CREATED_AT', ['template' => "{input}"])->hiddenInput(['value' => date('Y-m-d H:i:s'), 'readonly' => true]);
?>
<?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 = Barang::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([' ']);
}
//print_r($aryProviderDataStock);
//print_r($aryProviderHeaderStock);
/*
* === STOCK =======================
* @author ptrnov [ptr.nov@gmail.com]
* @since 1.2
* ===================================
*/
foreach ($aryProviderHeaderStock as $key => $value) {
$colorb = 'rgba(255, 255, 142, 0.2)';
if ($key == 'CUST_NM') {
$lbl = "Customer Name";
$align = "left";
$pageSummary = 'Sub Total';
} else {
$kd = explode('_', $key);
//echo $kd[1];
$nmBrg = Barang::find()->where("KD_BARANG='" . $kd[1] . "'")->one();
$lblR = $nmBrg['NM_BARANG'];
$lbl = str_replace('MAXI', '', $lblR);
$align = "center";
$pageSummary = true;
}
/* Attribute Dinamik */
$attDinamikSTCK[] = ['attribute' => $key, 'label' => $lbl, 'hAlign' => 'right', 'vAlign' => 'middle', 'headerOptions' => ['style' => ['text-align' => 'center', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(97, 211, 96, 0.3)']], 'contentOptions' => ['style' => ['text-align' => $align, 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => $colorb]], 'pageSummaryFunc' => GridView::F_SUM, 'pageSummary' => $pageSummary, 'pageSummaryOptions' => ['style' => ['text-align' => 'center', 'width' => '30px', 'font-family' => 'tahoma', 'font-size' => '8pt', 'border-left' => '0px']]];
}
$gvStockSummary = GridView::widget(['id' => 'gv-summary-stock', 'dataProvider' => $aryProviderDataStock, 'showPageSummary' => true, 'columns' => $attDinamikSTCK, 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'gv-summary-stock']], 'summary' => false, 'hover' => true, 'responsive' => true, 'responsiveWrap' => true, 'bordered' => true]);
?>
<div style="font-family:tahoma, arial, sans-serif;font-size:9pt;text-align:center;color:red"><b>REVIEW - STOCK</b></div>
<?php
echo $gvStockSummary;
private function aryBrgID()
{
$dataCust = ArrayHelper::map(Barang::find()->where(['KD_CORP' => 'ESM', 'KD_TYPE' => '01', 'KD_KATEGORi' => '01'])->orderBy('NM_BARANG')->asArray()->all(), 'KD_BARANG', 'NM_BARANG');
return $dataCust;
}
/**
* actionBrgkat() select2 barang mendapatkan unit barang
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionBrgunit()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$ids = $_POST['depdrop_parents'];
$kat_id = empty($ids[0]) ? null : $ids[0];
$brg_id = empty($ids[1]) ? null : $ids[1];
if ($brg_id != null) {
$brgu = new Barang();
$model = Barang::find()->where("KD_BARANG='" . $brg_id . "'")->one();
$brgUnit = $model->unit;
//foreach ($brgUnit as $value) {
//$out[] = ['id'=>$value['UNIT'],'name'=> $value['NM_UNIT']];
$out[] = ['id' => $brgUnit->KD_UNIT, 'name' => $brgUnit->NM_UNIT];
//$out[] = ['id'=>'E07','name'=> $value->NM_UNIT];
// }
echo json_encode(['output' => $out, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
/**
* Deletes an existing Barang model.
* If deletion is successful, the browser will be redirected to the 'index' page.
* @param string $ID
* @return mixed
*/
public function actionDelete($id)
{
// $this->findModel($ID)->delete();
$model = Barang::find()->where(['ID' => $id])->one();
$model->STATUS = 3;
$model->UPDATED_BY = Yii::$app->user->identity->username;
$model->save();
return $this->redirect(['index']);
}
use yii\helpers\Url;
use kartik\builder\Form;
use kartik\widgets\TouchSpin;
use yii\web\JsExpression;
use yii\data\ActiveDataProvider;
use lukisongroup\purchasing\models\ro\RodetailSearch;
use lukisongroup\master\models\Tipebarang;
use lukisongroup\master\models\Barang;
use lukisongroup\master\models\Kategori;
use lukisongroup\master\models\Unitbarang;
use lukisongroup\hrd\models\Corp;
$userCorp = ArrayHelper::map(Corp::find()->all(), 'CORP_ID', 'CORP_NM');
$brgType = ArrayHelper::map(Tipebarang::find()->where(['PARENT' => 0])->orderBy('NM_TYPE')->all(), 'KD_TYPE', 'NM_TYPE');
$brgUnit = ArrayHelper::map(Unitbarang::find()->orderBy('NM_UNIT')->all(), 'KD_UNIT', 'NM_UNIT');
$brgKtg = ArrayHelper::map(Kategori::find()->where(['PARENT' => 0, 'STATUS' => 1])->orderBy('NM_KATEGORI')->all(), 'KD_KATEGORI', 'NM_KATEGORI');
$brgUmum = ArrayHelper::map(Barang::find()->where(['PARENT' => 0, 'STATUS' => 1])->orderBy('NM_BARANG')->all(), 'KD_BARANG', 'NM_BARANG');
?>
<?php
/*
* DESCRIPTION FORM AddItem
* Form Add Items Hanya ada pada Form Edit | ACTION addItem
* Items Barang tidak bisa di input Duplicated. | Unix by KD_RO dan KD_BARANG
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
?>
<div style="padding-top:20">
<!-- Render create form -->
<?php
/* echo $this->render('_form', [
public function actionBarangPrice()
{
if (Yii::$app->request->post('hasEditable')) {
$idx = Yii::$app->request->post('editableKey');
Yii::$app->response->format = Response::FORMAT_JSON;
$modelPrice = Barang::findOne($idx);
$out = Json::encode(['output' => '', 'message' => '']);
$post = [];
$posted = current($_POST['Barang']);
$post['Barang'] = $posted;
if ($modelPrice->load($post)) {
$output = '';
$modelPrice->save();
/* HARGA PABRIK */
if (isset($posted['HARGA_PABRIK'])) {
$output = Yii::$app->formatter->asDecimal($modelPrice->HARGA_PABRIK, 0);
}
/* HARGA LG */
if (isset($posted['HARGA_LG'])) {
$output = Yii::$app->formatter->asDecimal($modelPrice->HARGA_LG, 2);
}
/* HARGA SUPPLIER */
if (isset($posted['HARGA_DIST'])) {
$output = $modelPrice->HARGA_DIST;
}
/* HARGA SALES LG */
if (isset($posted['HARGA_SALES'])) {
$output = $modelPrice->HARGA_SALES;
}
$out = Json::encode(['output' => $output, 'message' => '']);
}
// return ajax json encoded response and exit
echo $out;
return;
}
$searchModel = new BarangSearch();
$dataProvider = $searchModel->searchBarang(Yii::$app->request->queryParams);
$model = new Barang();
$querys = Barang::find()->from('dbc002.b0001 AS db1')->leftJoin('dbc002.b1001 AS db2', 'db1.KD_BARANG = db2.KD_TYPE')->where(['NM_TYPE' => 'FDSFDG'])->all();
return $this->render('price', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'querys' => $querys]);
}
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\master\models\Barangumum;
use lukisongroup\master\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');
$brgAll = ArrayHelper::map(Barang::find()->orderBy('NM_BARANG')->all(), 'KD_BARANG', 'NM_BARANG');
/* $this->registerJs("
$.fn.modal.Constructor.prototype.enforceFocus = function() {};
",$this::POS_HEAD);
*/
$aryParent = [['PARENT' => 0, 'PAREN_NM' => 'UMUM'], ['PARENT' => 1, 'PAREN_NM' => 'PRODAK']];
$valParent = ArrayHelper::map($aryParent, 'PARENT', 'PAREN_NM');
?>
<?php
$form = ActiveForm::begin(['id' => 'poplus-Input', 'enableClientValidation' => true, 'enableAjaxValidation' => true, 'method' => 'post', 'action' => ['/purchasing/purchase-order/poplus-additem-save']]);
?>
<?php
//= $form->errorSummary($model);
?>
/**
* BARANG PRODUCTION || Lukisongroup
* PARENT = 1 [PRODUK]
* @author ptrnov [piter@lukison.com]
*/
public function searchBarangLG($params)
{
$query = Barang::find()->where('b0001.STATUS <> 3')->andWhere('b0001.PARENT=1 AND KD_CORP="LG"')->groupBy(['KD_BARANG', 'KD_CORP', 'KD_TYPE', 'KD_KATEGORI']);
$query->joinWith(['unitb' => function ($q) {
$q->where('ub0001.NM_UNIT LIKE "%' . $this->unitbrg . '%"');
}]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20]]);
$dataProvider->setSort(['attributes' => ['KD_BARANG', 'NM_BARANG', 'unitbrg' => ['asc' => ['ub0001.NM_UNIT' => SORT_ASC], 'desc' => ['ub0001.NM_UNIT' => SORT_DESC], 'label' => 'Unit Barang'], 'tipebrg' => ['asc' => ['dbc002.b1001.NM_TYPE' => SORT_ASC], 'desc' => ['dbc002.b1001.NM_TYPE' => SORT_DESC], 'label' => 'Tipe Barang'], 'nmkategori' => ['asc' => ['b1002.NM_KATEGORI' => SORT_ASC], 'desc' => ['b1002.NM_KATEGORI' => SORT_DESC], 'label' => 'Kategori']]]);
if (!($this->load($params) && $this->validate())) {
/**
* The following line will allow eager loading with country data
* to enable sorting by country on initial loading of the grid.
*/
return $dataProvider;
}
$query->andFilterWhere(['like', 'b0001.STATUS', $this->STATUS])->andFilterWhere(['like', 'NM_BARANG', $this->NM_BARANG])->andFilterWhere(['like', 'b0001.KD_BARANG', $this->KD_BARANG])->andFilterWhere(['like', 'b0001.KD_TYPE', $this->tipebrg])->andFilterWhere(['like', 'b0001.KD_KATEGORI', $this->nmkategori]);
return $dataProvider;
}
/**
* actionBrgkat() select2 Kategori mendapatkan barang
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionCariBrg()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$parents = $_POST['depdrop_parents'];
if ($parents != null) {
$kat_id = $parents[0];
$model = Barang::find()->asArray()->where(['KD_KATEGORI' => $kat_id])->all();
foreach ($model as $key => $value) {
$out[] = ['id' => $value['KD_BARANG'], 'name' => $value['NM_BARANG']];
}
echo json_encode(['output' => $out, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
use lukisongroup\master\models\Kategori;
use lukisongroup\master\models\Unitbarang;
use lukisongroup\hrd\models\Corp;
use kartik\money\MaskMoney;
use yii\helpers\Url;
// $userCorp = ArrayHelper::map(Corp::find()->where('CORP_STS<>3')->all(), 'CORP_ID', 'CORP_NM');
$brgUnit = ArrayHelper::map(Unitbarang::find()->where('STATUS<>3')->orderBy('NM_UNIT')->all(), 'KD_UNIT', 'NM_UNIT');
// $brgType = ArrayHelper::map(Tipebarang::find()->where('PARENT=0 AND STATUS<>3')->orderBy('NM_TYPE')->all(), 'KD_TYPE', 'NM_TYPE');
// $brgKtg = ArrayHelper::map(Kategori::find()->where('PARENT=0 AND STATUS<>3')->orderBy('NM_KATEGORI')->all(), 'KD_KATEGORI', 'NM_KATEGORI');
// $brgUmum = ArrayHelper::map(Barang::find()->where('PARENT=0 AND STATUS<>3')->orderBy('NM_BARANG')->all(), 'KD_BARANG', 'NM_BARANG');
/* $this->registerJs("
$.fn.modal.Constructor.prototype.enforceFocus = function() {};
",$this::POS_HEAD);
*/
$corp = Yii::$app->getUserOpt->Profile_user()->emp->EMP_CORP_ID;
$data = ArrayHelper::map(Barang::find()->where(['KD_CORP' => $corp])->all(), 'KD_BARANG', 'NM_BARANG');
?>
<?php
$form = ActiveForm::begin(['id' => $roDetail->formName(), 'enableClientValidation' => true, 'enableAjaxValidation' => true, 'method' => 'post', 'action' => ['/purchasing/request-order/simpanfirst'], 'validationUrl' => Url::toRoute('/purchasing/request-order/valid')]);
?>
<?php
//= $form->errorSummary($model);
?>
<!-- $form->field($roDetail, 'CREATED_AT',['template' => "{input}"])->hiddenInput(['value'=>date('Y-m-d H:i:s'),'readonly' => true]) ?> -->
<?php
echo $form->field($roDetail, 'NEW')->radioList(['1' => 'New ', '2' => ' Search'], ['item' => function ($index, $label, $name, $checked, $value) {
$return = '<label class="modal-radio">';
