/** * 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; } } }