/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, },
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, // )); }
</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>
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')); } }
/** * 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; }
$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();
/** * 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; }