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>
