예제 #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Barang::find()->where('b0001.STATUS <> 3');
     $query->joinWith(['dbtr' => function ($q) {
         $q->where('d0001.NM_DISTRIBUTOR LIKE "%' . $this->nmdbtr . '%"');
     }]);
     $query->joinWith(['unitb' => function ($q) {
         $q->where('ub0001.NM_UNIT LIKE "%' . $this->unitbrg . '%"');
     }]);
     $query->joinWith(['tipebg' => function ($q) {
         $q->where('b1001.NM_TYPE LIKE "%' . $this->tipebrg . '%"');
     }]);
     $query->joinWith(['kategori' => function ($q) {
         $q->where('b1002.NM_KATEGORI LIKE "%' . $this->nmkategori . '%"');
     }]);
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $dataProvider->setSort(['attributes' => ['KD_BARANG', 'NM_BARANG', 'HPP', 'HARGA', 'nmdbtr' => ['asc' => ['d0001.NM_DISTRIBUTOR' => SORT_ASC], 'desc' => ['d0001.NM_DISTRIBUTOR' => SORT_DESC], 'label' => 'Supplier'], 'unitbrg' => ['asc' => ['ub0001.NM_UNIT' => SORT_ASC], 'desc' => ['ub0001.NM_UNIT' => SORT_DESC], 'label' => 'Unit Barang'], 'tipebrg' => ['asc' => ['b1001.NM_TYPE' => SORT_ASC], 'desc' => ['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', 'HPP', $this->HPP])->andFilterWhere(['like', 'HARGA', $this->HARGA])->andFilterWhere(['like', 'b0001.KD_BARANG', $this->KD_BARANG]);
     return $dataProvider;
     /*
             $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([
                 'ID' => $this->ID,
                 'HPP' => $this->HPP,
                 'HARGA' => $this->HARGA,
                 'BARCODE' => $this->BARCODE,
                 'NOTE' => $this->NOTE,
                 'STATUS' => $this->STATUS,
                 'CREATED_BY' => $this->CREATED_BY,
                 'CREATED_AT' => $this->CREATED_AT,
                 'UPDATED_AT' => $this->UPDATED_AT,
             ]);
     
             $query->andFilterWhere(['like', 'KD_BARANG', $this->KD_BARANG])
                 ->andFilterWhere(['like', 'NM_BARANG', $this->NM_BARANG])
                 ->andFilterWhere(['like', 'KD_SUPPLIER', $this->KD_SUPPLIER])
                 ->andFilterWhere(['like', 'KD_DISTRIBUTOR', $this->KD_DISTRIBUTOR])
                 ->andFilterWhere(['like', 'DATA_ALL', $this->DATA_ALL]);
     
             return $dataProvider;
     */
 }
예제 #2
0
파일: Barang.php 프로젝트: C12D/advanced
 public function getTbesm()
 {
     return $this->hasMany(Barang::className(), ['KD_BARANG' => 'KD_TYPE']);
 }
예제 #3
0
 /**
  * Finds the Barang model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $ID
  * @return Barang the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($ID)
 {
     if (($model = Barang::findOne($ID)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
 public function actionSimpan($id)
 {
     $rodetail = new Rodetail();
     $hsl = Yii::$app->request->post();
     $created = $hsl['Rodetail']['CREATED_AT'];
     $nmBarang = $hsl['Rodetail']['NM_BARANG'];
     $kdRo = $hsl['Rodetail']['KD_RO'];
     $kdBarang = $hsl['Rodetail']['KD_BARANG'];
     $qty = $hsl['Rodetail']['QTY'];
     $note = $hsl['Rodetail']['NOTE'];
     $ck = Rodetail::find()->where(['KD_BARANG' => $kdBarang, 'KD_RO' => $kdRo])->andWhere('STATUS <> 3')->one();
     if (count($ck) == 1) {
         \Yii::$app->getSession()->setFlash('error', '<br/><br/><p class="bg-danger" style="padding:15px"><b>Barang Sudah di Masukkan</b></p>');
         return $this->redirect(['buatro', 'id' => $id]);
     } else {
         $kdBrg = $hsl['Rodetail']['KD_BARANG'];
         $ckBrg = explode('.', $kdBrg);
         if ($ckBrg[0] == 'BRG') {
             $kdUnit = Barang::find('KD_UNIT')->where(['KD_BARANG' => $kdBrg])->one();
         } else {
             if ($ckBrg[0] == 'BRGU') {
                 $kdUnit = Barangumum::find('KD_UNIT')->where(['KD_BARANG' => $kdBrg])->one();
             }
         }
         $rodetail->UNIT = $kdUnit->KD_UNIT;
         $rodetail->CREATED_AT = $created;
         $rodetail->NM_BARANG = $nmBarang;
         $rodetail->KD_RO = $kdRo;
         $rodetail->KD_BARANG = $kdBarang;
         $rodetail->QTY = $qty;
         $rodetail->NOTE = $note;
         $rodetail->save();
         \Yii::$app->getSession()->setFlash('error', '<br/><br/><p class="bg-success" style="padding:15px"><b>Barang berhasil di Masukkan</b></p>');
         return $this->redirect(['buatro', 'id' => $id]);
     }
 }
예제 #5
0
파일: view.php 프로젝트: C12D/advanced
            <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\models\master\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $val->UNIT])->one();
    } else {
        $brg = lukisongroup\models\esm\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $val->UNIT])->one();
    }
    ?>

            <tr>
                <td><?php 
예제 #6
0
파일: _buat.php 프로젝트: C12D/advanced
$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\models\master\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $rows->UNIT])->one();
    } else {
        $brg = lukisongroup\models\esm\Unitbarang::find('NM_UNIT')->where(['KD_UNIT' => $rows->UNIT])->one();
    }
    ?>

				<td class=" accordion-toggle" data-toggle="collapse" data-target="#demo<?php 
    echo $a;
예제 #7
0
 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([' ']);
 }
예제 #8
0
파일: _form.php 프로젝트: C12D/advanced
		</div>
	</div>

	<div class="form-group">
		<div class="col-sm-12">
			<br/>
		</div>
	</div>

 </form>
 
 
<?php 
$form = ActiveForm::begin(['method' => 'post', 'action' => ['esm/requestorder/simpan?id=' . $id]]);
$brgar['Barang Umum'] = $brg = ArrayHelper::map(Barangumum::find()->all(), 'KD_BARANG', 'NM_BARANG');
$brgar['Barang ESM'] = $brgs = ArrayHelper::map(Barang::find()->all(), 'KD_BARANG', 'NM_BARANG');
$unit = ArrayHelper::map(Unitbarang::find()->all(), 'KD_UNIT', 'NM_UNIT');
echo $form->field($rodetail, 'CREATED_AT')->hiddenInput(['value' => date('Y-m-d H:i:s')])->label(false);
?>
	
<?php 
echo $form->field($rodetail, 'NM_BARANG')->hiddenInput(['value' => ''])->label(false);
?>
	

<?php 
echo $form->field($rodetail, 'KD_RO')->textInput(['value' => $id, 'readonly' => true])->label('Kode Request Order');
?>

<div class="row">
  <div class="col-xs-3"><?php