public function actionGenerate() { if ($_POST['tahun']) { $data = Yii::$app->db->createCommand("SELECT a.*, b.unit_id FROM serasi2015_sql.news_sub_mak_tahun as a join serasi2015_sql.news_nas_suboutput as b on a.suboutput_id=b.suboutput_id\n where a.kode_mak in (524113,524111,524119,524114) ")->queryAll(); //524114 tidak filter $pagu = Yii::$app->db->createCommand("SELECT * FROM pagu_mak")->queryAll(); foreach ($pagu as $ke) { Yii::$app->db->createCommand('DELETE FROM pagu_mak WHERE id_pagu=' . $ke['id_pagu'])->execute(); } foreach ($data as $key) { // print_r($key['suboutput_id']); // die(); Yii::$app->db->createCommand()->insert('pagu_mak', ['tahun' => $key['tahun'], 'alokasi_sub_mak' => $key['alokasi_sub_mak'], 'kd_satker' => $key['kd_satker'], 'nas_prog_id' => $key['nas_prog_id'], 'nas_keg_id' => $key['nas_keg_id'], 'kdoutput' => $key['kdoutput'], 'kdsoutput' => $key['kdsoutput'], 'kdkmpnen' => $key['kdkmpnen'], 'kdskmpnen' => $key['kdskmpnen'], 'kdsoutput' => $key['kdsoutput'], 'kode_mak' => $key['kode_mak'], 'suboutput_id' => $key['suboutput_id'], 'unit_id' => \common\components\HelperUnit::Out($key['suboutput_id'])], ['tahun' => $_POST['tahun']])->execute(); } Yii::$app->session->setFlash('success', 'Update Pagu Anggaran Berhasil'); } Yii::$app->session->setFlash('success', 'Update Pagu Anggaran Berhasil'); return $this->redirect(['index']); }
} ?> </tr> <?php $no = 1; foreach ($models as $key) { ?> <tr align="center"> <td><?php echo $no; ?> </td> <td align="left"><?php echo \common\components\HelperUnit::Pegawai($key['pegawai_id']); ?> </td> <?php for ($i = 01; $i <= 31; $i++) { ?> <td width="10"> <?php $tahun = substr($key['tgl_berangkat'], 0, 4); $bln = substr($key['tgl_berangkat'], 5, 2); if ($i < 10) { $da = '0' . $i; } elseif ($i == 20) { $da = $i . '0'; } elseif ($i == 30) { $da = $i . '0';
$hitung = "SELECT count(a.id_kegiatan) FROM simpel_keg a LEFT JOIN pegawai.daf_unit b on a.unit_id=b.unit_id WHERE status=4 and b.unit_parent_id='" . $sat->unit_id . "' "; $count = Yii::$app->db->createCommand($hitung)->queryScalar(); echo $count; break; default: $hitung = "SELECT count(a.id_kegiatan) FROM simpel_keg a LEFT JOIN pegawai.daf_unit b on a.unit_id=b.unit_id WHERE status=4 and b.unit_parent_id='" . $sat->unit_id . "' "; $count = Yii::$app->db->createCommand($hitung)->queryScalar(); echo $count; break; } ?> </td> <td align="center" width="260">Rp. <?php $pag = number_format(HelperUnit::Pagu($sat->unit_id), 0, ",", "."); echo $pag; ?> </td> </tr> <?php $n++; } ?> <?php $no++; } ?> <tr> <td style="background-color: white;" scope="row"></td> </tr>
switch ($result['jenis_detail_id']) { case "3": echo $form->field($model, 'no_reg')->textInput(['readOnly' => true, 'require' => true, 'value' => str_pad($dat, 4, "0", STR_PAD_LEFT) . '/SPPD-DN/BU/' . \common\components\MyHelper::Romawi(date('m')) . '/' . date('Y')])->label('No. Kwitansi'); break; case "4": echo $form->field($model, 'no_reg')->textInput(['readOnly' => true, 'require' => true, 'value' => str_pad($dat, 4, "0", STR_PAD_LEFT) . '/SPPD-DN/BU/' . \common\components\MyHelper::Romawi(date('m')) . '/' . date('Y')])->label('No. Kwitansi'); break; case "5": echo $form->field($model, 'no_reg')->textInput(['readOnly' => true, 'require' => true, 'value' => str_pad($dat, 4, "0", STR_PAD_LEFT) . '/SPPD-LN/BU/' . \common\components\MyHelper::Romawi(date('m')) . '/' . date('Y')])->label('No. Kwitansi'); break; } ?> <?php echo $form->field($model, 'nip_ppk')->hiddenInput(['readonly' => true, 'rows' => 6, 'value' => HelperUnit::Ppk(HelperUnit::ParentUnit($_GET['unit']))])->label(false); ?> </div> </div> <div class="modal-footer"> <div class="row"> <div class="col-md-6"> <h5 align="left"><?php echo Html::a('Batal', ['create'], ['class' => 'btn btn-success ', 'data-dismiss' => 'modal']); ?> </h5> </div> <div class="col-md-6">
?> </div> </th> <td align="center"><?php $pag = HelperUnit::Pagu($sat->unit_id); $pagn = number_format(HelperUnit::Pagu($sat->unit_id), 0, ",", "."); echo $pagn; ?> </td> <td align="center"> <?php $re = HelperUnit::Real($sat->unit_id); $ren = number_format(HelperUnit::Real($sat->unit_id), 0, ",", "."); echo $ren; ?> </td> <td align="center"><?php echo number_format($pag - $re, 0, ",", "."); ?> </td> <td align="center"><?php $data = @($re / $pag) * 100; if (!empty($data)) { echo number_format($data, 0, ",", "."); } else { echo '0'; }
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::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(); $pagn = number_format($nilaipagu, 0, ",", "."); echo $pagn; ?> </td> <td align="center"> <?php
<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> <td></td> <td></td> <td></td> </tr>
<div class="wp-posts-index"> <div class="row"> </div> <br/> <div id="datadinasGridview"> <h3 align="center">Daftar Kegiatan Berdasarkan Unit Kerja <br/><?php echo HelperUnit::Unit($_GET['unit']); ?> </h3> <?php echo GridView::widget(['dataProvider' => $dataSerasi, 'id' => 'akun', 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'Tanggal', 'headerOptions' => ['width' => '10'], 'value' => function ($data) { return substr($data['renc_tgl_mulai'], 8, 2) . ' - ' . substr($data['renc_tgl_selesai'], 8, 2) . ' ' . \common\components\MyHelper::BacaBulan(substr($data['renc_tgl_mulai'], 5, 2)) . ' ' . substr($data['renc_tgl_mulai'], 0, 4); }], ['attribute' => 'Bidang', 'headerOptions' => ['width' => '255'], 'value' => function ($data) { return HelperUnit::Unit($data['unit_id']); }], ['attribute' => 'Mata Anggaran', 'headerOptions' => ['width' => '255'], 'value' => function ($data) { return $data['nas_prog_id'] . '.' . $data['nas_keg_id'] . '.' . $data['kdoutput'] . '.' . $data['kdsoutput'] . '.' . $data['kdkmpnen'] . '.' . $data['kdskmpnen'] . '.' . $data['kode_mak']; }], ['attribute' => 'Nama Kegiatan', 'headerOptions' => ['width' => '455'], 'value' => function ($data) { return $data['nama_detail']; }], ['attribute' => 'Jenis Kegiatan', 'headerOptions' => ['width' => '120'], 'value' => function ($data) { switch ($data['jenis_detail_id']) { case "3": return 'External'; break; case "4": return 'Dalam Negri'; break; case "5": return 'Luar Negri'; break;