/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$ppk = Ppk::find($id);
if ($ppk->delete()) {
return Response::json(array('success' => TRUE));
}
}
public function ppk($id)
{
if (Request::ajax()) {
$ppk = Ppk::find($id);
$ppk->delete();
return $ppk->nama;
}
}
public function kemaskiniPpk()
{
if (Request::ajax()) {
$data = Input::all();
$id = $data['id'];
$ppk = Ppk::find($id);
$ppk->nama = $data['nama'];
$ppk->noTel = $data['noTel'];
$ppk->speedDial = $data['speedDial'];
$ppk->noFaks = $data['noFaks'];
$ppk->alamat = $data['alamat'];
if ($ppk->save()) {
return 'Save Succeeded';
} else {
return 'Failed to save';
}
return 1;
}
}
public function actionTableReport()
{
$data = Satker::model()->findByAttributes(array('code' => '622280'));
$ppk = array();
$limit = array();
$realization = array();
$rate = array();
$countData = array();
$ratePpk = array();
$limitPpk = array();
$totalRealPpk = array();
if ($data) {
$packageAccount = PackageAccount::model()->findAllByAttributes(array('satker_code' => "{$data->code}"));
$countData[$data->code] = 0;
$limit[$data->code] = 0;
$realization[$data->code] = 0;
$rate[$data->code] = 0;
if ($packageAccount) {
$countData[$data->code] = count($packageAccount);
foreach ($packageAccount as $pa) {
$limit[$data->code] += $pa->limit;
$realData = Realization::model()->findAllByAttributes(array('packageAccount_code' => "{$data->code}"));
$totalRealization = 0;
if ($realData) {
foreach ($realData as $r) {
$totalRealization += $r->total_spm;
}
}
$realization[$data->code] += $totalRealization;
}
}
if ($limit[$data->code] != 0) {
$rate[$data->code] = $realization[$data->code] / $limit[$data->code] * 100;
}
$ppks = Ppk::model()->findAll();
if ($ppks) {
foreach ($ppks as $ppk) {
$paPpk = PackageAccount::model()->findAllByAttributes(array('ppk_code' => "{$ppk->code}"));
$limitPpk[$ppk->code] = 0;
$ratePpk[$ppk->code] = 0;
$totalRealPpk[$ppk->code] = 0;
if ($paPpk) {
foreach ($paPpk as $p) {
$limitPpk[$ppk->code] += $p->limit;
$realPpk = Realization::model()->findAllByAttributes(array('packageAccount_code' => "{$p->code}"));
$realizationPpk = 0;
if ($realPpk) {
foreach ($realPpk as $dataReal) {
$realizationPpk += $dataReal->total_spm;
}
}
$totalRealPpk[$ppk->code] += $realizationPpk;
}
if ($limitPpk != 0) {
$ratePpk[$ppk->code] = $totalRealPpk[$ppk->code] / $limitPpk[$ppk->code] * 100;
}
}
}
}
}
echo $data->name . "</br>";
echo $limit[$data->code] . "</br>";
echo $realization[$data->code] . "</br>";
// $this->title = 'Tabel Penggunaan Anggaran';
// $say = 'Ini adalah page report penggunaan anggaran';
// $this->render('tableReport', array(
// 'say' => $say,
// ));
}
/package/download" class="btn btn-primary"><i class="fa fa-fw fa-download"></i> Download Form Input Paket</a>-->
<a href="<?php
echo yii::app()->baseUrl;
?>
/package/entry" class="btn btn-primary"><i class="fa fa-fw fa-plus"></i> Entri Data</a>
<a href="<?php
echo yii::app()->baseUrl;
?>
/package/clear" onclick="return confirm('Yakin ingin menghapus semua data paket dan akun paket?')" class="btn btn-default"><i class="fa fa fa-trash"></i>Bersihkan Data</a>
</div>
<div class="panel-body">
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'package-grid', 'dataProvider' => $model->search(), 'filter' => new Package('search'), 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage * $this->grid->dataProvider->pagination->pageSize + ($row+1)'), array('name' => 'code', 'type' => 'raw', 'value' => 'CHtml::link($data->code,array("package/view","id"=>$data->id))'), array('name' => 'name', 'type' => 'raw', 'value' => '$data->name'), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'ppk_code', 'sortable' => true, 'value' => 'isset($data->ppk->official_name)?$data->ppk->official_name:"-"', 'filter' => Ppk::model()->getPpkOptions(), 'editable' => array('type' => 'select', 'url' => $this->createUrl('editable'), 'placement' => 'bottom', 'inputclass' => 'span3', 'source' => Ppk::model()->getPpkOptions(), 'success' => 'js: function(data) {
var arr=JSON.parse(data);
var url=' . CJSON::encode(Yii::app()->baseUrl . "/package/childUpdate") . ';
var packageCode=arr.model["code"];
var ppkCode=arr.model["ppk_code"];
var provinceCode=arr.model["province_code"];
var cityCode=arr.model["city_code"];
$.ajax({
url: url,
dataType: "json",
data: {
code: packageCode,
cityCode: cityCode,
provinceCode: provinceCode,
ppkCode:ppkCode,
},
</td>
<td><?php
echo CHtml::dropDownList('city_code[]', "string", City::model()->getProvinceGroupOptions(), array('prompt' => 'Pilih'));
?>
</td>
</tr>
<?php
}
?>
<tr>
<td><?php
echo CHtml::dropDownList('code[]', "string", Subcomponent::model()->getSubcomponentOptions(), array('prompt' => 'Pilih', 'type' => 'selc', 'onfocus' => 'removeDuplicate()'));
?>
</td>
<td><?php
echo CHtml::dropDownList('ppk_code[]', "string", Ppk::model()->getPpkOptions(), array('prompt' => 'Pilih'));
?>
</td>
<td><?php
// echo CHtml::dropDownList('province_code[]', "string", Province::model()->getOptionsCodeName(), array('prompt' => 'Pilih'));
?>
</td>
<td><?php
echo CHtml::dropDownList('city_code[]', "string", City::model()->getProvinceGroupOptions(), array('prompt' => 'Pilih'));
?>
</td>
</tr>
<?php
}
?>
</tbody>
/**
* Check completeness data of master
* @return boolean
*/
public function checkMaster()
{
$complete = false;
$ppk = Ppk::model()->exists();
$satker = Satker::model()->exists();
$activity = Activity::model()->exists();
$output = Output::model()->exists();
$suboutput = Suboutput::model()->exists();
$component = Component::model()->exists();
$subcomponent = Subcomponent::model()->exists();
$account = Account::model()->exists();
$province = Province::model()->exists();
$city = City::model()->exists();
if ($ppk && $satker && $activity && $output && $suboutput & $component && $subcomponent && $account && $province && $city) {
$complete = TRUE;
}
return $complete;
}
public function actionClear()
{
//Check record data on database
$exist = Ppk::model()->exists();
if ($exist) {
//Clear Data
Yii::app()->db->createCommand()->truncateTable(Ppk::model()->tableName());
Yii::app()->user->setFlash('success', 'Data berhasil dibersihkan.');
$this->redirect(array('index'));
} else {
Yii::app()->user->setFlash('error', 'Data tidak ditemukan.');
$this->redirect(array('index'));
}
}
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'package-form', 'enableAjaxValidation' => true, 'htmlOptions' => array('enctype' => 'multipart/form-data')));
?>
<?php
echo $form->errorSummary($model);
if ($model->isNewRecord) {
?>
<?php
echo $form->dropDownList($model, 'code', Subcomponent::model()->getSubcomponentOptions(), array("prompt" => "Pilih Paket"));
}
echo $form->dropDownList($model, 'province_code', Province::model()->getOptionsCodeName(), array("prompt" => "Pilih Provinsi", 'id' => 'province'));
?>
<?php
echo $form->dropDownList($model, 'city_code', City::model()->getOptionsCodeName(), array("prompt" => "Pilih Kota", 'id' => 'city'));
?>
<?php
echo $form->dropDownList($model, 'ppk_code', Ppk::model()->getPpkOptions(), array("prompt" => "Pilih PPK"));
?>
<div class="form-actions">
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'primary', 'label' => $model->isNewRecord ? 'Tambah' : 'Simpan'));
?>
</div>
<?php
$this->endWidget();
public function kemaskini($id)
{
$ppk = Ppk::find($id);
return View::make('admin.kemaskini.ppk')->with('title', 'Kemaskini PPK')->with('ppk', $ppk);
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Ppk the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Ppk::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<table class="table table-condensed">
<thead>
<tr>
<th>Bil</th>
<th>Nama</th>
<th>No Telefon</th>
<th>Speed Dial</th>
<th>Faks</th>
<th>Alamat</th>
<th class="center">Pilihan</th>
</tr>
</thead>
<tbody>
<?php
$ppk = Ppk::orderBy('id', 'ASC')->get();
$bil = 0;
?>
@foreach($ppk as $tempat)
<?php
$bil++;
?>
<tr>
<td class='center' valign='middle'>{{ $bil }}</td>
<td class='center' valign='middle'>{{ $tempat->nama }}</td>
<td class='center' valign='middle'>{{ $tempat->noTel }}</td>
<td class='center' valign='middle'>{{ $tempat->speedDial }}</td>
<td class='center' valign='middle'>{{ $tempat->noFaks }}</td>
<td class='center' valign='middle'>{{ $tempat->alamat }}</td>
<td class='center'><a class='delete btn btn-danger' data-id="{{ $tempat->id }}" href='#'>
<i class='glyphicon glyphicon-trash icon-white'></i>Delete</a></td>
public function daftarPpkPost()
{
if (Request::ajax()) {
$data = Input::all();
$ppk = new Ppk();
$ppk->nama = strtoupper($data['nama']);
$ppk->noTel = $data['noTel'];
$ppk->speedDial = $data['speedDial'];
$ppk->noFaks = $data['noFaks'];
$ppk->alamat = strtoupper($data['alamat']);
if ($ppk->save()) {
return 1;
} else {
return 0;
}
}
}
