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