/** * 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 function actionIndex() { $dataKegiatan = Kegiatan::model()->find('id=1'); $bulan; $dataChart = array(); $i = 1; foreach ($dataKegiatan->realisasi as $key) { // $dataChart[date('M',mktime(0,0,0,$i+1,0,0))] = $key->nominal; array_push($dataChart, $key->nominal); // print_r($dataChart[date('M',mktime(0,0,0,$i+1,0,0))]); $i++; } // print_r($dataChart); $this->render('index', array('dataChart' => $dataChart)); }
/** * 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 Kegiatan the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Kegiatan::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * List rekap Kegiatan Khusus * @param integer $bulan to choose bulan. * @param integer $tahun to choose $tahun. * @param string $temp to join other string. * @return array rekap Kegiatan Khusus. */ public function listKhusus($bulan, $tahun, $temp) { $dataReader = Kegiatan::model()->getRekapKegiatan($bulan, $tahun, '4'); $temp = $temp . "<h4>Khusus</h4><table><tr><td>Regional<hr></td><td>Kegiatan<hr></td><td align='center'>Pembicara<hr></td><td align='center'>Materi<hr></td><td align='center'>Tanggal Pelaksanaan<hr></td></tr>"; while (($row = $dataReader->read()) !== false) { $arr = explode("-", $row['tanggal']); $temp = $temp . "<tr><td>" . $row['nama'] . "</td><td align='center'>" . $row['nama_kegiatan'] . "</td><td align='center'>" . $row['pembicara'] . "</td><td align='center'>" . $row['materi'] . "</td><td align='center'>" . $arr[2] . "/" . $arr[1] . "</td></tr>"; } $temp = $temp . "</table>"; return $temp; }
public function actionUpdateKegiatan() { if ($_POST) { $kegiatan = Kegiatan::model()->find('id=:id', array(':id' => $_POST['id'])); $backup = $this->updateTheKegiatan($kegiatan); $kegiatan->nama_kegiatan = $_POST['namaKg']; $kegiatan->kode_kegiatan = $_POST['kodeKg']; $kegiatan->id_layanan = $_POST['id_layanan']; $kegiatan->target = $_POST['targetKg']; $kegiatan->bulan = $_POST['bulanKg']; $kegiatan->volume = $_POST['volumeKg']; $kegiatan->harga_satuan = $_POST['harga_satuanKg']; $kegiatan->satuan = $_POST['satuanKg']; $kegiatan->sumber_dana = $_POST['sumber_danaKg']; $kegiatan->penanggung_jawab = $_POST['penanggung_jawabKg']; $kegiatan->id_rekaman = 0; $kegiatan->versi = 0; $kegiatan->status = 1; if ($backup == 1 && $kegiatan->validate()) { Yii::app()->user->setFlash('success', 'Selamat, update kegiatan berhasil'); $kegiatan->save(); // echo $kegiatan->nama_program; $id_layanan = $_POST['id_layanan']; $this->actionKegiatan($id_layanan); } else { Yii::app()->user->setFlash('error', 'Maaf, simpan kegiatan gagal. Mohon periksa kembali data yang anda inputkan'); $this->redirect(array('/errPage/errDB')); } } }
/** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete($id) { $model = $this->loadModel($id); $kegiatan = Kegiatan::model()->findByPk($model->id_kegiatan); $model->delete(); $other_kg = DetailKegiatan::model()->findAllByAttributes(array('id_kegiatan' => $kegiatan->id)); $waktu_avg = 0; $anggaran_avg = 0; $jumlah = 0; if (!empty($other_kg)) { $ii = 0; foreach ($other_kg as $data) { $waktu_avg = $waktu_avg + $data->persen_waktu; $anggaran_avg = $anggaran_avg + $data->persen_anggaran; $jumlah = $jumlah + $data->anggaran; $ii++; } $waktu_avg = $waktu_avg / $ii; $anggaran_avg = $anggaran_avg / $ii; } $kegiatan->persen_waktu = $waktu_avg; $kegiatan->persen_anggaran = $anggaran_avg; $kegiatan->anggaran = $jumlah; $nama_kegiatan = $kegiatan->nama; $id_kegiatan = $kegiatan->id; $kegiatan->save(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if (!isset($_GET['ajax'])) { Yii::app()->user->setFlash('successDelete', "Berhasil menghapus detail kegiatan!"); $this->redirect(array('index', 'id' => $id_kegiatan, 'nama_kegiatan' => $nama_kegiatan)); } }
public function actionAddKegiatan($id, $id_personil) { if ($id != null) { $model = $this->loadModel($id); } else { $model = new KegiatanPersonil(); $model->id_personil = $id_personil; } if (isset($_GET['yt0'])) { echo var_dump($model->id_personil); echo var_dump($_GET['id_detail_kegiatan']); $kegiatan = new KegiatanPersonil(); $kegiatan->id_personil = $model->id_personil; $kegiatan->id_detail_kegiatan = $_GET['id_detail_kegiatan']; $dk = DetailKegiatan::model()->getIdKegiatan($_GET['id_detail_kegiatan']); $k = Kegiatan::model()->getTahunKegiatan($dk[0]['id_kegiatan']); $kegiatan->tahun = $k[0]['tahun']; if ($kegiatan->save()) { // create new detail_kegiatan_personil echo var_dump($id_personil); $detail = DetailKegiatan::model()->findByPk($_GET['id_detail_kegiatan']); if ($id != null) { for ($a = 1; $a <= 12; $a++) { for ($b = 1; $b <= 4; $b++) { $val = "w" . $a . $b; if ($detail->{$val} != NULL) { $model->{$val} = $kegiatan->id_detail_kegiatan; } } } $model->save(); } else { $dkp = new DetailKegiatanPersonil(); $dkp->id_personil = $kegiatan->id_personil; $dkp->tahun = $kegiatan->tahun; for ($a = 1; $a <= 12; $a++) { for ($b = 1; $b <= 4; $b++) { $val = "w" . $a . $b; if ($detail->{$val} != NULL) { $dkp->{$val} = $kegiatan->id_detail_kegiatan; } } } $dkp->save(); } $this->redirect(array('index', 'id' => $model->id)); } } $this->render('tambahKegiatan', array('model' => $model)); }
<td>Jumlah Layanan</td> <td>Jumlah Kegiatan</td> <td>Persentase Realisasi</td> <td>Tahun Anggaran</td> </tr> <tr> <td><?php echo count($dataProgram); ?> </td> <td><?php echo count(Layanan::model()->findAll()); ?> </td> <td><?php echo count(Kegiatan::model()->findAll()); ?> </td> <td><?php echo DatabaseUmum::getPersentaseRealisasi("all", "1"); ?> (<a href="#">halaman rekap</a>)</td> <td> <select class="form-control" id="tahun_anggaran"> <?php AlatUmum::activeOptListYears(Yii::app()->request->cookies['tahun_anggaran']->value); ?> </select> </td> </tr> </table>
public function getTahunKegiatan($id) { $criteria = new CDbCriteria(); $criteria->select = 'tahun'; $criteria->condition = 'id=:id'; $criteria->params = array(':id' => $id); $tahun = Kegiatan::model()->findAll($criteria); return $tahun; }
echo $form->labelEx($model, 'nama'); ?> <?php echo $form->textField($model, 'nama', array('size' => 60, 'maxlength' => 255)); ?> <?php echo $form->error($model, 'nama'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'kegiatan_id'); ?> <?php echo $form->dropDownList($model, 'kegiatan_id', CHtml::listData(Kegiatan::model()->findAll(), 'id', 'optionKegiatan')); ?> <?php echo $form->error($model, 'kegiatan_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'parent_id'); ?> <?php echo $form->dropDownList($model, 'parent_id', array_merge(array('--parent--'), CHtml::listData(ButirKegiatan::model()->findAll(), 'id', 'nama'))); ?> <?php echo $form->error($model, 'parent_id');
public function actionGetMaxRealisasi() { if (Yii::app()->request->isAjaxRequest) { $maxRealisasi = Kegiatan::model()->find("id=:id", array(':id' => $_POST['id_kegiatan'])); echo $maxRealisasi['target']; } }
/** * 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. */ public function loadModel() { if ($this->_model === null) { if (isset($_GET['id'])) { $this->_model = Kegiatan::model()->findbyPk($_GET['id']); } if ($this->_model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } } return $this->_model; }