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']);
 }
示例#2
0
}
?>

                </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';
示例#3
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';
        }
示例#6
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;