public function actionLihatPOKBulanan() { if (isset($_POST['tahunAnggaran']) && isset($_POST['bulan'])) { AlatUmum::setCookieTahun($_POST['tahunAnggaran']); $connection = Yii::app()->db; $sql = "SELECT \n\t\t\t\t\tkegiatan.id as id,\n\t\t\t\t\tkegiatan.kode_kegiatan as kode_kegiatan,\n\t\t\t\t\tkegiatan.nama_kegiatan as nama,\n\t\t\t\t\tkegiatan.target as target,\n\t\t\t\t\tsatuan.nama as satuan,\n\t\t\t\t\tsumber_dana.nama as sumber_dana,\n\t\t\t\t\tpenanggung_jawab.nama as penanggung_jawab,\n\t\t\t\t\tprogram.tahun_anggaran as tahun_anggaran\n\t\t\t\t\tFROM \n\t\t\t\t\tkegiatan,layanan,program,satuan,sumber_dana,penanggung_jawab\n\t\t\t\t\tWHERE program.id = layanan.id_program \n\t\t\t\t\tAND layanan.id = kegiatan.id_layanan \n\t\t\t\t\tAND kegiatan.satuan = satuan.id\n\t\t\t\t\tAND kegiatan.penanggung_jawab = penanggung_jawab.id\n\t\t\t\t\tAND kegiatan.sumber_dana = sumber_dana.id\n\t\t\t\t\tAND kegiatan.status = '1'\n\t\t\t\t\tAND layanan.status = '1'\n\t\t\t\t\tAND program.status = '1'\n\t\t\t\t\tAND (program.tahun_anggaran = :tahun_anggaran\n\t\t\t\t\t\tAND kegiatan.bulan = :bulan)"; $command = $connection->createCommand($sql); $command->bindParam(':tahun_anggaran', $_POST['tahunAnggaran'], PDO::PARAM_STR); $command->bindParam(':bulan', $_POST['bulan'], PDO::PARAM_STR); $dataKegiatan = $command->queryAll(); // $dataKegiatan = Kegiatan::model()->findAll('bulan=:bulan',array(':bulan'=>'1')); $this->render('lihatRencanaPOKBulanan', array('dataKegiatan' => $dataKegiatan, 'tahunAnggaran' => $_POST['tahunAnggaran'], 'bulan' => $_POST['bulan'])); // echo $_POST['bulan']; } else { $this->render('lihatRencanaPOKBulanan'); } }
<div class="row"> <div class="col-md-16"> <div class="row"> <div class="col-md-16 f-panel-2"> <div class="f-panel-heading"> <h2>Jadwal POK Semester</h2> </div> <select class="col-md-3 btn f-button f-background-blue" id="tahun_anggaran"> <?php AlatUmum::activeOptListYears($tahun_anggaran); ?> </select> <button id="S1" class="col-md-3 btn f-button ">Semester 1</button> <button id="S2" class="col-md-3 btn f-button ">Semester 2</button> </div> <div class="col-md-16"> <div class="panel"> <div class="panel-body" id="semester"> <?php $this->renderPartial('_semester', array('dataKegiatan' => $dataKegiatan, 'max' => $max, 'min' => $min)); ?> </div> </div> </div> </div> <script type="text/javascript"> $(document).ready(function(){ $('#tahun_anggaran').change(function(){ var tahun_anggaran = document.getElementById('tahun_anggaran').value; $.ajax({
<div class="form-group"> <label>Nama Layanan</label> <input type="text" name="namaLy" placeholder="Judul" class="form-control" value="<?php echo $dataLayanan['nama_layanan']; ?> " required> </div> <div class="form-group"> <label>Nominal/Target Anggaran</label> <input type="number" name="targetLy" placeholder="Nominal" class="form-control" value="<?php echo intval($dataLayanan['target']); ?> " max="<?php echo intval($dataLayanan['target']); ?> " required> <dd>Maksimal : <?php echo AlatUmum::changeCurrency($dataLayanan['target']); ?> </dd> </div> <a href="<?php echo Yii::app()->user->returnUrl; ?> " class="btn">Kembali</a> <input type="submit" class="btn btn-primary" value="Simpan"> </div> </form> </div>
$jumlah = 0; ?> <td><?php foreach ($key->realisasi as $key2) { ?> <?php $jumlah += $key2->nominal; ?> <?php } ?> <?php echo AlatUmum::changeCurrency($jumlah); ?> (<?php echo AlatUmum::formatDecimal($jumlah / $key->target * 100); ?> %) </td> </td> <td><?php echo $key->Satuan['nama']; ?> </td> <td><?php echo $key->PenanggungJawab['nama']; ?> </td> <td><?php echo $key->SumberDana['nama']; ?>
foreach ($realisasi as $key4) { if ($key4['total'] == null) { echo "0"; } else { echo $key4['total']; } } ?> </td> <td><?php echo AlatUmum::changeCurrency($saldoakhir = $key['target'] - $key4['total']); ?> </td> </tr> <?php } ?> </table> </div> <div class="panel-footer">
<div class="form-group"> <label>Nominal/Target Anggaran</label> <input type="number" name="targetKg" placeholder="Nominal" class="form-control" value="<?php echo intval($dataKegiatan['target']); ?> " required> <dd>Maksimal : <?php echo AlatUmum::changeCurrency($dataKegiatan['target']); ?> </dd> </div> <div class="form-group"> <label>Bulan Rencana</label> <select class="form-control" name="bulanKg" required="required"> <?php AlatUmum::activeOptListMonth($dataKegiatan['bulan']); ?> </select> </div> <div class="form-group"> <label>Volume</label> <input type="number" value="<?php echo $dataKegiatan['volume']; ?> "name="volumeKg" placeholder="Judul" class="form-control" required> </div> <div class="form-group"> <label>Satuan</label> <select name="satuanKg" required class="form-control"> <?php foreach ($dataSatuan as $key) {
echo $dataProgram['kode_program']; ?> " class="form-control" > </div> <div class="form-group"> <label>Nama Program</label> <input type="text" name="namaTP" placeholder="Judul" value="<?php echo $dataProgram['nama_program']; ?> " class="form-control"> </div> <div class="form-group"> <label>Tahun Anggaran</label> <select name="tahunTP" class="form-control"> <?php AlatUmum::activeOptListYears("2016"); ?> </select> </div> <div class="form-group"> <label>Nominal/Target Anggaran</label> <input type="number" name="targetTP" placeholder="Nominal" value="<?php echo intval($dataProgram['target']); ?> " class="form-control"> </div> <p>Perhatikan data yang anda inputkan kembali</p> <a href="<?php echo Yii::app()->user->returnUrl; ?> " class="btn">Kembali</a>
<h4 class="modal-title" id="labelModalTP"><center>Tambah Program</center></h4> </div> <div class="modal-body"> <div class="form-group"> <label>Kode</label> <input type="text" name="kodeTP" value="50123.241" class="form-control" > </div> <div class="form-group"> <label>Nama Program</label> <input type="text" name="namaTP" placeholder="Judul" class="form-control"> </div> <div class="form-group"> <label>Tahun Anggaran</label> <select name="tahunTP" class="form-control"> <?php AlatUmum::optListYears(); ?> </select> </div> <div class="form-group"> <label>Nominal/Target Anggaran</label> <input type="number" name="targetTP" placeholder="Nominal" class="form-control"> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> <input type="submit" class="btn btn-primary" value="Simpan"> </div> </form> </div> </div>
?> </td> <td><?php echo $key3['volume']; ?> </td> <td><?php echo $key3['satuan']; ?> </td> <td><?php echo AlatUmum::changeCurrency($key3['harga_satuan']); ?> </td> <td><?php echo AlatUmum::changeCurrency($key3['target']); ?> </td> <td><?php echo $key3['sumber_dana']; ?> </td> <td><?php echo "-"; ?> </td> <td> <?php $realisasi = $this->realisasi($key3['id'], $_POST['bulanRealisasi']); foreach ($realisasi as $key4) {
<div class="panel-heading"> <h4>Input Data Realisasi</h4> </div> <div class="panel-body"> <form method="post" action="<?php echo Yii::app()->request->baseUrl; ?> /inputrealisasi/writerealisasi"> <table class="table"> <tr> <td>Tahun Anggaran</td> <td>:</td> <td> <select class="form-control" name="bulan" id="tahun_anggaran" required="required"> <?php AlatUmum::activeOptListYears(Yii::app()->request->cookies['tahun_anggaran']->value); ?> </select> </td> </tr> <tr> <td>Bulan Anggaran</td> <td>:</td> <td> <select class="form-control" name="bulan" required="required"> <?php for ($i = 1; $i < 13; $i++) { echo "<option value={$i}>" . date('M', mktime(0, 0, 0, $i + 1, 0, 0)) . "</option>"; } ?> </select>
} } ?> <tr> <th colspan="12"><center>Tahun Aanggaran 2015</center></th> </tr> <tr> <?php $hasil = $this->realisasisd(12); foreach ($hasil as $tampil) { if ($tampil['total'] == null) { echo "<td colspan='3'><center>0</center></td>"; } else { echo "<td colspan='12'><center>"; echo AlatUmum::ChangeCurrency($tampil['total']); echo "</center></td>"; } } ?> </tr> </table> <table class="table table-bordered"> <tr> <td colspan="13"><div class="alert alert-danger"><center><b>Detail Rekap Data Kegiatan</b></center></div></td> </tr> </table> <div class="col-md-5 panel panel-primary f-panel">
?> </td> <td><?php echo $key3->volume; ?> </td> <td><?php echo $key3->satuan; ?> </td> <td><?php echo AlatUmum::changeCurrency($key3->harga_satuan); ?> </td> <td><?php echo AlatUmum::changeCurrency($key3->target); ?> </td> <td><?php echo $key3->sumber_dana; ?> </td> <td></td> <td> <?php $realisasi = $this->realisasi($key3->id); foreach ($realisasi as $key4) { if ($key4['total'] == null) { echo "0"; } else {
<div class="form-group"> <label>Kode</label> <input type="text" name="kodeLy" placeholder="Layanan" value="0024" class="form-control" readonly> </div> <div class="form-group"> <label>Nama Layanan</label> <input type="text" name="namaLy" placeholder="Judul" class="form-control"> </div> <div class="form-group"> <label>Nominal/Target Anggaran</label> <input type="number" name="targetLy" placeholder="Nominal" class="form-control" max="<?php echo $dataMaxTarget; ?> " required> <dd>Maksimal : Rp <?php echo AlatUmum::changeCurrency($dataMaxTarget); ?> </dd> </div> </div> <div class="modal-footer"> <input type="hidden" name="id_program" value="<?php echo $id_program; ?> "> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> <input type="submit" class="btn btn-primary" value="Simpan"> </div> </form> </div> </div>
?> </td> <td><?php echo $key->nama_program; ?> </td> <td><?php echo AlatUmum::changeCurrency($key->target); ?> </td> <td><?php echo $realisasi = $this->getRealisasiFromProgram($key->id); ?> (<?php if ($realisasi != 0) { echo AlatUmum::formatDecimal($realisasi / $key->target * 100); } else { echo "0"; } ?> %)</td> <td><?php echo count($key->layanan); ?> </td> <td> <?php foreach ($key->layanan as $key2) { $counterKegiatan += count($key2->kegiatan); } echo $counterKegiatan;
Daftar Kegiatan & Rincian Bulan </div> <div class="panel-body"> <!-- // Deskripsi Umum Halaman --> <div class="row"> <div class="col-md-12"> Tabel berikut menyajikan daftar Kegiatan yang telah tercatat dalam database lengkap dengan rinciannya. <br> Terakhir ditambah : 08-11-2015 oleh Alfian Faiz </div> <div class="col-md-16"> <div class="f-box f-padding-1 alert alert-warning clearfix"> <form class="form-inline" action="#" method="post"> <div class="form-group"> <select name="tahun_anggaran" class="form-control"> <option>-- Pilih tahun -- </option> <?php AlatUmum::activeOptListYears(AlatUmum::getCookieTahun()); ?> </select> </div> <div class="form-group pull-right"> <input type="submit" name="cariRealisasi" value="Tampilkan Daftar" class="btn btn-danger form-control" > </div> </form> </div> </div> <?php if (isset($dataKegiatan)) { ?> <div class="col-sm-16 col-md-16"> <table class="table table-bordered"> <tr>