/**
* Lists all models.
*/
public function actionIndex()
{
$tahun = Kegiatan::model()->getAllYears();
$model = Kegiatan::model()->findAll();
$dataProvider = null;
$puskaji = 0;
$bidang = 0;
$kategori = 0;
$tahun_selected = 0;
if (isset($_GET['yt0'])) {
//$dataProvider = array('aaa' => 'aaaaa');
$puskaji = $_GET['puskaji'];
$bidang = $_GET['bidang'];
$kategori = $_GET['kategori'];
$tahun_selected = $_GET['tahun_selected'];
if ($tahun_selected != '') {
if ($kategori == '1') {
if ($bidang != '') {
$dataProvider = Kegiatan::model()->findAllByAttributes(array('id_bidang' => (int) $bidang));
} else {
if ($puskaji != '') {
$dataProvider = Kegiatan::model()->findAllByAttributes(array('puskaji' => (int) $puskaji));
} else {
$dataProvider = Kegiatan::model()->findAll();
}
}
} else {
if ($kategori == '2') {
if ($bidang != '') {
$dataProvider = Kegiatan::model()->getDetailKegiatanByBidang($bidang);
} else {
if ($puskaji != '') {
$dataProvider = Kegiatan::model()->getDetailKegiatanByPuskaji($puskaji);
} else {
$dataProvider = DetailKegiatan::model()->findAll();
}
}
} else {
if ($kategori == '3') {
if ($bidang != '') {
$id_personil = Personil::model()->getPersonilByBidang($bidang);
$dataProvider = KegiatanPersonil::model()->countByBidang($bidang, $tahun_selected);
} else {
if ($puskaji != '') {
$dataProvider = KegiatanPersonil::model()->countByPuskaji($puskaji, $tahun_selected);
} else {
$dataProvider = KegiatanPersonil::model()->countAll($tahun_selected);
}
}
}
}
}
}
}
$this->render('index', array('dataProvider' => $dataProvider, 'puskaji' => $puskaji, 'bidang' => $bidang, 'kategori' => $kategori, 'model' => $model, 'tahun' => $tahun, 'tahun_selected' => $tahun_selected));
}
public static function findBidangByPersonil($id_personil)
{
$bidang = Personil::model()->findAllByPk($id_personil);
$data = self::model()->findAllByPk($bidang[0]['bidang']);
return $data;
}
<?php
echo $form->error($model, 'kode_bidang');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'personil');
?>
<?php
if ($model->id_personil != '') {
//$data = KabupatenController::getListKab($model->kode_prov);
//echo var_dump($data);
//die();
$bidang = Personil::model()->findByAttributes(array('bidang' => $bidang));
echo $form->dropDownList($model, 'id_personil', array(Personil::getPersonilByBidang($bidang)), array('empty' => 'Pilih Personil'));
} else {
echo $form->dropDownList($model, 'id_personil', array(), array('empty' => 'Pilih Personil'));
}
?>
<?php
echo $form->error($model, 'id_personil');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'username');
?>
<?php
echo $form->textField($model, 'username', array('size' => 25, 'maxlength' => 25));
public static function getPersonilByBidang($id)
{
$criteria = new CDbCriteria();
$criteria->select = 'id';
$criteria->condition = 'bidang=:bidang';
$criteria->params = array(':bidang' => $id);
$criteria->order = 'id ASC';
$id_personil = Personil::model()->findAll($criteria);
return $id_personil;
}
if (Yii::app()->user->getState('role') == Akun::ADMIN) {
echo "<th>Aksi</th>";
}
?>
</thead>
<tfoot>
<tr>
</tr>
</tfoot>
<tbody>
<?php
$ii = 1;
foreach ($dataProvider as $data) {
echo "<tr id=\"\">";
echo "<td>" . $ii++ . "</td>";
$pers = Personil::model()->findByPk($data->id_personil);
echo "<td>" . $pers['nama'] . "</td>";
echo "<td class=\"text-left\">" . $data->username . "</td>";
$role = Akun::model()->getRole($data->kode_role);
echo "<td class=\"text-left\">" . $role . "</td>";
if (Yii::app()->user->getState('role') == Akun::ADMIN) {
echo "<td class=\"text-left\">" . CHtml::link('Ubah', array('Akun/update', 'id' => $data->id)) . " |" . CHtml::link('Hapus', array('Akun/delete', 'id' => $data->id), array('submit' => array('Akun/delete', 'id' => $data->id), 'class' => 'delete', 'confirm' => 'Anda yakin untuk menghapus akun?')) . "</td>";
}
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'detail-kegiatan-personil-form', 'method' => 'get', 'enableAjaxValidation' => true));
?>
<p class="note">Field dengan <span class="required">*</span> harus diisi.</p>
<?php
echo $form->errorSummary($model);
?>
<div class="row">
<?php
echo $form->labelEx($model, 'Nama Personil');
?>
<?php
$namapersonil = Personil::model()->findByPk($model->id_personil);
echo CHtml::textField('namapersonil', $namapersonil['nama'], array('disabled' => 'disabled'));
?>
<?php
echo $form->error($model, 'id_personil');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'Puskaji');
$puskaji = 0;
?>
<?php
echo CHtml::dropDownList('puskaji', $puskaji, Puskaji::model()->getPuskajiList(), array('empty' => 'Pilih Puskaji', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('personil/dinamis'), 'data' => array('puskaji' => 'js:this.value'), 'update' => '#bidang')));
?>
public function actionDinamis()
{
$data = Personil::model()->findAllByAttributes(array('bidang' => $_POST['bidang']));
$dataBaru = CHtml::listData($data, 'id', 'nama');
echo CHtml::tag('option', array('value' => ''), 'Pilih Personil', true);
foreach ($dataBaru as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
<div class="row">
<div class="box">
<div class="col-lg-12 text-center">
<h2 class="section-heading">Rangkuman</h2>
<?php
echo $this->renderPartial('_form', array('model' => $model, 'puskaji' => $puskaji, 'tahun' => $tahun, 'bidang' => $bidang, 'kategori' => $kategori, 'tahun_selected' => $tahun_selected));
if ($dataProvider !== null) {
$ii = 0;
$series = array();
$series1 = array();
$series2 = array();
foreach ($dataProvider as $data) {
if ($kategori == 3) {
$namapersonil = Personil::model()->getNamaPersonil($data['id']);
$nama = $namapersonil->nama;
} else {
if ($kategori == 2) {
$nama = $data['nama_kegiatan'] . "<br />" . $data['nama'];
} else {
$nama = $data->nama;
}
}
if ($kategori != 3) {
$series[$ii] = array('name' => $nama, 'data' => array((int) $data['persen_anggaran']));
$series1[$ii] = array('name' => $nama, 'data' => array((int) $data['persen_waktu']));
} else {
$series2[$ii] = array('name' => $nama, 'data' => array((int) $data['jumlah']));
}
$ii++;
}
