public function actionAdmin() { $tahun = isset($_GET['tahun']) ? $_GET['tahun'] : date('Y'); $dunit = Yii::$app->user->identity->unit_id; if ($dunit == '100000') { $command = Yii::$app->db->createCommand("SELECT \n sum(pagu) as total\n FROM t_mak where unit_mak in('BP','BHO','BU','Biro Umum','INSPEK','BDL') and t_mak.tahun=" . $tahun); $dataPagu = $command->queryScalar(); $command2 = Yii::$app->db->createCommand("SELECT \n sum(pagu)\n FROM t_mak where unit_mak in('DIFRZR', 'DPIBN', 'DPFRZR', 'DI2BN', 'DK2N') and t_mak.tahun=" . $tahun); $dataPagu2 = $command2->queryScalar(); $command3 = Yii::$app->db->createCommand("SELECT \n sum(pagu)\n FROM t_mak where unit_mak in('P2STPFRZR', 'P2STPIBN', 'DP2FRZR', 'DP2IBN') and t_mak.tahun=" . $tahun); $dataPagu3 = $command3->queryScalar(); $command4 = Yii::$app->db->createCommand("SELECT \n sum(pagu)\n FROM t_mak where unit_mak in('SKLN') and t_mak.tahun=" . $tahun); $dataPagu4 = $command4->queryScalar(); //akhir data pagu $totalPagu = $dataPagu + $dataPagu2 + $dataPagu3 + $dataPagu4; //mulai data realisasi } if ($dunit == '100000') { $count = \common\models\DaftarUnit::find()->where('unit_id in (110000,120000,130000,161100,151000)')->count(); $unit = \common\models\DaftarUnit::find()->where('unit_id in (110000,120000,130000,161100,151000)'); } else { $count = \common\models\DaftarUnit::find()->where('unit_id in (' . $dunit . ')')->count(); $unit = \common\models\DaftarUnit::find()->where('unit_id in (' . $dunit . ')'); } $pages = new Pagination(['totalCount' => $count]); $models = $unit->offset($pages->offset, $pages->pageSize = 100)->limit($pages->limit)->all(); $unitkerja = Yii::$app->db->createCommand("SELECT sum(pagu) FROM t_mak where t_mak.tahun=" . $tahun)->queryScalar(); $unitke = Yii::$app->db->createCommand("SELECT sum(pagu) FROM t_mak where t_mak.tahun=" . $tahun)->queryScalar(); $realisasi = Yii::$app->db->createCommand("SELECT sum(jml) FROM `simpel_rincian_biaya` where id_kegiatan=4")->queryScalar(); return $this->render('index', ['dataPagu2' => $dataPagu2, 'dataPagu3' => $dataPagu3, 'dataPagu4' => $dataPagu4, 'totalPagu' => $totalPagu, 'pages' => $pages, 'unit' => $unit, 'realisasi' => $realisasi, 'models' => $models, 'unitkerja' => $unitkerja, 'unitke' => $unitke, 'dunit' => $dunit]); }
public function actionLists($id) { $countKokab = \common\models\DaftarUnit::find()->where(['unit_parent_id' => $id])->count(); $Kokab = \common\models\DaftarUnit::find()->where(['unit_parent_id' => $id])->all(); if ($countKokab > 0) { echo "<option ><center>- Pilih - </center></option>"; foreach ($Kokab as $kota) { echo "<option value='" . $kota->unit_id . "'>" . $kota->nama . "</option>"; } } else { echo "<option>-</option>"; } }
public function actionAdmin() { $tahun = isset($_GET['tahun']) ? $_GET['tahun'] : date('Y'); $dunit = Yii::$app->user->identity->unit_id; if ($dunit == '100000') { $count = \common\models\DaftarUnit::find()->where('unit_id in (110000,120000,130000,161100,151000)')->count(); $unit = \common\models\DaftarUnit::find()->where('unit_id in (110000,120000,130000,161100,151000)'); } else { $count = \common\models\DaftarUnit::find()->where('unit_id in (' . $dunit . ')')->count(); $unit = \common\models\DaftarUnit::find()->where('unit_id in (' . $dunit . ')'); } $pages = new Pagination(['totalCount' => $count]); $models = $unit->offset($pages->offset, $pages->pageSize = 100)->limit($pages->limit)->all(); $realisasi = Yii::$app->db->createCommand("SELECT sum(jml) FROM `simpel_rincian_biaya` where id_kegiatan=4")->queryScalar(); return $this->render('index', ['pages' => $pages, 'unit' => $unit, 'realisasi' => $realisasi, 'models' => $models, 'dunit' => $dunit]); }
<?php switch ($unit->unit_id) { case 110000: $satker = DaftarUnit::find()->where('satker_id=110000 and unit_id in (111000,112000,113000,114000,115000)')->all(); break; case 120000: $satker = DaftarUnit::find()->where(' unit_id in (121000,122000,123000,124000)')->all(); break; case 130000: $satker = DaftarUnit::find()->where('unit_id in (131000,132000,133000)')->all(); break; case 161100: $satker = DaftarUnit::find()->where("unit_id='161100'")->all(); break; case 151000: $satker = DaftarUnit::find()->where("unit_id='151000'")->all(); break; } $n = 1; foreach ($satker as $sat) { ?> <tr> <td width="40"></td> <td width="50" bgcolor="gray" style="text-align:center;"> <div > <?php switch ($sat->unit_id) { case 110000: ?> <h6> <?php echo Html::a(HelperUnit::Apagu($sat->unit_id), Yii::$app->urlManager->createUrl(['simpel-keg/tabarsip', 'unit' => $sat->unit_id]), ['title' => Yii::t('yii', 'Proses')]);
public function Unit($id) { $gole = \common\models\DaftarUnit::find()->where(['unit_id' => $id])->one(); return $gole->nama; }
<?php switch ($unit->unit_id) { case 110000: $satker = DaftarUnit::find()->where('satker_id=110000 and unit_id in (111000,112000,113000,114000,115000)')->all(); break; case 120000: $satker = DaftarUnit::find()->where(' unit_id in (121000,122000,123000,124000)')->all(); break; case 130000: $satker = DaftarUnit::find()->where('unit_id in (131000,132000,133000)')->all(); break; case 161100: $satker = DaftarUnit::find()->where('unit_id in (0)')->all(); break; case 151000: $satker = DaftarUnit::find()->where('unit_id=0')->all(); break; default: echo ""; } foreach ($satker as $sat) { ?> <tr> <th width="240" bgcolor="gray" align="left"> <div class="pull-right"> <?php echo HelperUnit::Apagu($sat->unit_id); ?> </div>
echo $form->field($result, 'nama_detail')->textInput(['rows' => 6, 'value' => $result['nama_detail']])->label('Nama Kegiatan'); ?> <?php echo $form->field($result, 'detail_id')->hiddenInput(['rows' => 6, 'value' => $result['detail_id']])->label(false); ?> <?php echo $form->field($result, 'kode_mak')->hiddenInput(['rows' => 6, 'value' => $result['kode_mak']])->label(false); ?> <div id="kota"> <?php $data = ArrayHelper::map(\backend\models\DafKota::find()->asArray()->all(), 'kab_id', 'nama'); echo $form->field($result, 'kota_keberangkatan')->widget(Select2::classname(), ['data' => $data, 'theme' => Select2::THEME_BOOTSTRAP, 'options' => ['id' => 'brkota', 'placeholder' => 'Pilih Kota Keberangkatan'], 'pluginOptions' => ['allowClear' => true]]); ?> </div> <?php $unit = ArrayHelper::map(\common\models\DaftarUnit::find()->asArray()->all(), 'unit_id', 'nama'); echo $form->field($result, 'unit_id')->widget(Select2::classname(), ['data' => $unit, 'theme' => Select2::THEME_BOOTSTRAP, 'options' => ['required' => 'required', 'placeholder' => 'Pilih UNIT Kerja'], 'pluginOptions' => ['allowClear' => true]])->label('Unit Kerja'); ?> <?php echo $form->field($result, 'renc_tgl_mulai')->widget(DatePicker::classname(), ['options' => ['value' => $result['renc_tgl_mulai'], 'placeholder' => 'Enter birth date ...'], 'pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-m-d']])->label('Pergi Keberangkatan'); ?> <?php echo $form->field($result, 'tgl_penugasan')->widget(DatePicker::classname(), ['options' => ['placeholder' => 'Enter birth date ...'], 'pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-m-d']])->label('Tanggal Penugasan'); ?> </div> <div class="col-md-6"> <?php $data = ArrayHelper::map(\common\models\Pegawai::find()->asArray()->all(), 'nip', 'nama_cetak'); echo $form->field($result, 'nip_ppk')->widget(Select2::classname(), ['data' => $data, 'theme' => Select2::THEME_BOOTSTRAP, 'options' => ['placeholder' => 'Pilih Nama PPK'], 'pluginOptions' => ['allowClear' => true]])->label('Pilih Nama PPK');
?> </th> <td align="center"><?php $pag = HelperUnit::Pagu($unit->unit_id); $pagn = number_format(HelperUnit::Pagu($unit->unit_id), 0, ",", "."); echo $pagn; ?> </td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr> <?php $pimpin2 = DaftarUnit::find()->where("unit_parent_id='" . $unit->unit_id . "'")->all(); foreach ($pimpin2 as $sat) { ?> <tr> <th width="280" bgcolor="gray" align="left"> <div class="pull-right"> <?php echo HelperUnit::unit($sat->unit_id); ?> </div> </th> <td align="center"><?php $sql_pagu = "SELECT sum(b.alokasi_sub_mak) FROM serasi2015_sql.news_nas_suboutput a LEFT JOIN serasi2015_sql.news_sub_mak_tahun b on a.suboutput_id=b.sub_mak_id LEFT JOIN pegawai.daf_unit c on a.unit_id3=c.unit_id WHERE a.tahun=" . $tahun . " and c.unit_id=" . $sat['unit_id']; $nilaipagu = Yii::$app->db->createCommand($sql_pagu)->queryScalar();
<tr> <th scope="row"><?php echo \common\components\HelperUnit::Unit($dunit); ?> </th> <td></td> <td></td> <td></td> <td></td> </tr> <?php $satker = \common\models\DaftarUnit::find()->where('unit_id =' . $dunit)->all(); foreach ($satker as $sat) { ?> <tr> <th bgcolor="gray" align="left"> <div class="pull-right"> <?php echo \common\components\HelperUnit::Unit($sat->unit_id); ?> </div> </th> <td> <?php echo $sat->unit_id;
</td> </tr> <?php switch ($unit->unit_id) { case 110000: $ese = isset($_GET['unit_id']) ? $_GET['unit_id'] : '111000,112000,113000,114000,115000'; $satker = DaftarUnit::find()->where(' unit_id in (' . $ese . ')')->all(); break; case 120000: $ese = isset($_GET['unit_id']) ? $_GET['unit_id'] : '121000,122000,123000,124000'; $satker = DaftarUnit::find()->where(' unit_id in (' . $ese . ')')->all(); break; case 130000: $ese = isset($_GET['unit_id']) ? $_GET['unit_id'] : '131000,132000,133000'; $satker = DaftarUnit::find()->where(' unit_id in (' . $ese . ')')->all(); $jum = Yii::$app->db->createCommand("SELECT \n sum(alokasi_sub_mak) as total\n FROM pagu_mak where unit_id in(131000,132000,133000)")->queryScalar(); break; } $n = 1; foreach ($satker as $sat) { $ese = isset($_GET['unit_id']) ? $_GET['unit_id'] : $sat->unit_id; $hsl = Yii::$app->db->createCommand("SELECT \n sum(alokasi_sub_mak) as total\n FROM pagu_mak where unit_id in(" . $ese . ")")->queryScalar(); ?> <tr > <td align="right"><?php echo $n; ?> .</td> <td><?php
</tfoot> <tbody> <tr> <td style="background-color: white;" scope="row"></td> </tr> <tr> <th scope="row">Deputi PI</th> <td></td> <td></td> <td></td> <td> </td> </tr> <?php $satker = \common\models\DaftarUnit::find()->where('satker_id=110000 and unit_id in (111000,112000,113000,114000,115000)')->all(); foreach ($satker as $sat) { ?> <tr> <th bgcolor="gray" align="left"> <div class="pull-right"> <?php echo \common\components\HelperUnit::Apagu($sat->unit_id); ?> </div> </th> </tr>
public function AnakUnit($id) { $gole = \common\models\DaftarUnit::find()->where(['unit_parent_id' => $id])->one(); return $gole->unit_id; }