/** * 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]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Kategori::find()->where('STATUS <> 3')->groupBy(['PARENT', 'CORP_ID', 'KD_TYPE', 'KD_KATEGORI']); $dataProvider = 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 $dataProvider; } $query->andFilterWhere(['NM_KATEGORI' => $this->NM_KATEGORI, 'UPDATED_AT' => $this->UPDATED_AT, 'STATUS' => $this->STATUS, 'PARENT' => $this->PARENT, 'CORP_ID' => $this->getAttribute('corp.CORP_NM'), 'KD_TYPE' => $this->getAttribute('typebrg.NM_TYPE')]); $query->andFilterWhere(['like', 'KD_KATEGORI', $this->KD_KATEGORI])->andFilterWhere(['like', 'NM_KATEGORI', $this->NM_KATEGORI])->andFilterWhere(['like', 'NOTE', $this->NOTE]); // ->andFilterWhere(['like', 'CREATED_BY', $this->CREATED_BY]) // ->andFilterWhere(['like', 'UPDATED_BY', $this->UPDATED_BY]); return $dataProvider; }
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\master\models\Barangumum; 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'); $brgUmum = ArrayHelper::map(Barangumum::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' => 'roInput', 'enableClientValidation' => true, 'method' => 'post', 'action' => ['/purchasing/request-order/simpanfirst']]); ?> <?php //= $form->errorSummary($model); ?>
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\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]); ?>
/** * actionBrgkat() select2 Kategori mendapatkan barang * @author ptrnov <*****@*****.**> * @since 1.1 */ public function actionBrgkat() { $out = []; if (isset($_POST['depdrop_parents'])) { $parents = $_POST['depdrop_parents']; if ($parents != null) { $prn_id = $parents[0]; $model = Kategori::find()->asArray()->where(['PARENT' => $prn_id])->all(); foreach ($model as $key => $value) { $out[] = ['id' => $value['KD_KATEGORI'], 'name' => $value['NM_KATEGORI']]; } echo json_encode(['output' => $out, 'selected' => '']); return; } } echo Json::encode(['output' => '', 'selected' => '']); }
<?php use yii\helpers\Html; use yii\helpers\ArrayHelper; use kartik\grid\GridView; use yii\bootstrap\Modal; use lukisongroup\master\models\Barang; use lukisongroup\hrd\models\Corp; use lukisongroup\master\models\Tipebarang; use lukisongroup\master\models\Kategori; $userCorp = ArrayHelper::map(Corp::find()->where('CORP_STS<>3')->all(), 'CORP_ID', 'CORP_NM'); $typeBrg = ArrayHelper::map(Tipebarang::find()->where('STATUS<>3 and PARENT=1')->groupBy('NM_TYPE')->all(), 'KD_TYPE', 'NM_TYPE'); $kat = ArrayHelper::map(Kategori::find()->where('STATUS<>3 and PARENT=1')->groupBy('NM_KATEGORI')->all(), 'KD_KATEGORI', 'NM_KATEGORI'); /* * Declaration Componen User Permission * Function profile_user */ function getPermissionEmp() { if (Yii::$app->getUserOpt->profile_user()) { return Yii::$app->getUserOpt->profile_user()->emp; } else { return false; } } $this->sideCorp = 'Master Data'; /* Title Select Company pada header pasa sidemenu/menu samping kiri */ $this->sideMenu = 'umum_datamaster'; /* kd_menu untuk list menu pada sidemenu, get from table of database */ $this->title = Yii::t('app', 'Umum - Barang '); $aryStt = [['STATUS' => 0, 'STT_NM' => 'DISABLE'], ['STATUS' => 1, 'STT_NM' => 'ENABLE']];
use kartik\widgets\Select2; 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
/** * Finds the Kategori model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @param string $kd_kategori * @return Kategori the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($ID, $KD_KATEGORI) { if (($model = Kategori::find()->where(['ID' => $ID, 'KD_KATEGORI' => $KD_KATEGORI])->one()) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
use yii\helpers\Html; use kartik\form\ActiveForm; use yii\helpers\ArrayHelper; use kartik\widgets\Select2; use kartik\widgets\FileInput; use kartik\widgets\DepDrop; use yii\helpers\Url; use lukisongroup\master\models\Tipebarang; use lukisongroup\master\models\Kategori; use lukisongroup\master\models\Unitbarang; use lukisongroup\master\models\Suplier; use lukisongroup\hrd\models\Corp; // 'STATUS' => 1,'PARENT'=>0,'NM_TYPE'=> "<>UNKNOWN"] $drop = ArrayHelper::map(Corp::find()->all(), 'CORP_ID', 'CORP_NM'); $droptype = ArrayHelper::map(Tipebarang::find()->where('STATUS = 1 AND PARENT = 0 AND KD_TYPE <> 30')->all(), 'KD_TYPE', 'NM_TYPE'); $dropkat = ArrayHelper::map(Kategori::find()->where(['STATUS' => 1, 'PARENT' => 0])->all(), 'KD_KATEGORI', 'NM_KATEGORI'); $dropunit = ArrayHelper::map(Unitbarang::find()->all(), 'KD_UNIT', 'NM_UNIT'); $dropsup = ArrayHelper::map(Suplier::find()->all(), 'KD_SUPPLIER', 'NM_SUPPLIER'); ?> <div class="barang-form"> <?php $form = ActiveForm::begin(['type' => ActiveForm::TYPE_HORIZONTAL, 'method' => 'post', 'id' => 'form-umum-id', 'enableClientValidation' => true, 'options' => ['enctype' => 'multipart/form-data']]); ?> <?php echo $form->field($model, 'PARENT')->hiddenInput(['value' => 0, 'maxlength' => true])->label(false); ?> <?php echo $form->field($model, 'KD_CORP')->dropDownList($drop, ['id' => 'barang-kd_corp', 'prompt' => ' -- Pilih Salah Satu --'])->label('Perusahaan'); echo $form->field($model, 'KD_TYPE')->widget(DepDrop::classname(), ['type' => DepDrop::TYPE_SELECT2, 'data' => $droptype, 'options' => ['id' => 'barang-kd_type'], 'pluginOptions' => ['depends' => ['barang-kd_corp'], 'url' => Url::to(['/master/barangumum/umum-corp-type']), 'initialize' => true]]);
public function getKategori() { return $this->hasOne(Kategori::className(), ['KD_KATEGORI' => 'KD_KATEGORI']); }
$form = ActiveForm::begin(['type' => ActiveForm::TYPE_HORIZONTAL, 'options' => ['enctype' => 'multipart/form-data']]); ?> <?php echo $form->field($model, 'NM_BARANG')->textInput(['maxlength' => true]); ?> <?php $drop = ArrayHelper::map(Tipebarang::find()->where(['STATUS' => 1])->all(), 'KD_TYPE', 'NM_TYPE'); ?> <?php echo $form->field($model, 'KD_TYPE')->dropDownList($drop, ['prompt' => ' -- Pilih Salah Satu --'])->label('Type Barang'); ?> <?php $drop = ArrayHelper::map(Kategori::find()->where(['STATUS' => 1])->all(), 'KD_KATEGORI', 'NM_KATEGORI'); ?> <?php echo $form->field($model, 'KD_KATEGORI')->dropDownList($drop, ['prompt' => ' -- Pilih Salah Satu --'])->label('Kategori'); ?> <?php $drop = ArrayHelper::map(Unitbarang::find()->all(), 'ID', 'NM_UNIT'); ?> <?php echo $form->field($model, 'KD_UNIT')->dropDownList($drop, ['prompt' => ' -- Pilih Salah Satu --']); ?> <?php /* $drop = ArrayHelper::map(Distributor::find()->all(), 'KD_DISTRIBUTOR', 'NM_DISTRIBUTOR'); */ ?>