/**
* 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 kegiatan()
{
$kegiatan = Kegiatan::where('active', '1')->orderBy('id', 'created_at')->paginate(10);
return view('sub.kegiatan', compact('kegiatan'));
}
public function actionCreate()
{
$model = new Kegiatan();
$id_user = Yii::app()->user->id;
$objRegional = Regional::model()->findByAttributes(array('id_user' => $id_user));
$id_regional = $objRegional->id_regional;
//peserta
if (Yii::app()->user->getLevel() == 3) {
$sql = "SELECT id_peserta,nama FROM peserta WHERE status_aktif=1 and id_regional = '" . $id_regional . "' order by nama";
} else {
$sql = "SELECT id_peserta,nama FROM peserta WHERE status_aktif=1 order by id_regional, nama";
}
$dbCommand = Yii::app()->db->createCommand($sql);
$peserta = $dbCommand->queryAll();
$absensi = array();
foreach ($peserta as $i => $item) {
$id = $item['id_peserta'];
$absensi[$id] = Absensi::model();
$absensi[$id]->id_peserta = $id;
}
//end peserta
if (isset($_POST['Absensi'])) {
$model->attributes = $_POST['Kegiatan'];
$model->id_regional = $id_regional;
if ($model->waktu_mulai > $model->waktu_selesai) {
Yii::app()->user->setFlash('errorWaktu', 'Waktu selesai lebih kecil atau sama dengan dari waktu mulai!');
$this->redirect(array('create'), array('model' => $model, 'absensi' => $absensi));
}
$model->deadline = date('Y-m-t 23:59:59');
$model->waktu_isi = date('Y-m-d H:i:s');
$model->status_isi = 1;
if ($model->save()) {
$valid = true;
foreach ($_POST['Absensi'] as $j => $item) {
if (isset($_POST['Absensi'][$j])) {
$absensi[$j] = new Absensi();
$absensi[$j]->id_peserta = $j;
$absensi[$j]->id_status = $_POST['Absensi'][$j]['id_status'];
$absensi[$j]->alasan = $_POST['Absensi'][$j]['alasan'];
$absensi[$j]->id_kegiatan = $model->id_kegiatan;
$absensi[$j]->save();
}
}
Yii::app()->user->setFlash('successTambah', 'Absensi sudah ditambahkan');
$this->actionView($model->id_kegiatan);
break;
} else {
Yii::app()->user->setFlash('gagalTambah', 'Gagal Simpan Kegiatan');
}
}
$this->render('create', array('model' => $model, 'absensi' => $absensi));
}
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;
}
