public function actionGetkecamatan()
{
$function = new FunctionHelper();
$data = $function->arrsKecamatan();
header('Content-Type: application/json');
echo json_encode(array('data' => $data, 'status' => '1'));
}
public function actionIndex()
{
$model = new ModelAnalytics();
$model_cat = new ModelKategori();
$function = new FunctionHelper();
$session = Yii::$app->session;
$username = $session->get('username');
$user_level = $session->get('user_level');
$category = $session->get('category');
$kecamatan = $session->get('kecamatan');
// Count member, user dan aduan serta count dari status aduan
if ($username != null) {
if ($user_level == '4') {
$aduan = $model->getCount('t_aduan', ' WHERE category="' . $category . '"');
$status_diterima = $model->getCountAduanStatus('1');
$status_dilaksanakan = $model->getCountAduanStatus('2');
$status_ditolak = $model->getCountAduanStatus('3');
} else {
if ($user_level == '5') {
$aduan = $model->getCount('t_aduan', ' WHERE kecamatan="' . $kecamatan . '"');
$status_diterima = $model->getCountAduanStatus('1', ' AND kecamatan="' . $kecamatan . '"');
$status_dilaksanakan = $model->getCountAduanStatus('2', ' AND kecamatan="' . $kecamatan . '"');
$status_ditolak = $model->getCountAduanStatus('3', ' AND kecamatan="' . $kecamatan . '"');
} else {
$aduan = $model->getCount('t_aduan');
$status_diterima = $model->getCountAduanStatus('1');
$status_dilaksanakan = $model->getCountAduanStatus('2');
$status_ditolak = $model->getCountAduanStatus('3');
}
}
$member = $model->getCount('t_member');
$user = $model->getCount('t_user');
// Count aduan categori
$arrs_cat = array();
foreach ($model_cat->getKategori() as $key => $value) {
if ($user_level == '5') {
$c_aduan_cat = $model->getCountAduanCategory($value['id'], ' AND kecamatan="' . $kecamatan . '"');
} else {
$c_aduan_cat = $model->getCountAduanCategory($value['id']);
}
$arrs_cat[] = array('nama' => $value['nama'], 'count' => $c_aduan_cat['count']);
}
// Count untuk status aduan
$arrs_sts = array('Diterima' => $status_diterima['count'], 'Dilaksanakan' => $status_dilaksanakan['count'], 'Ditolak' => $status_ditolak['count']);
// get kecamatan
$getKecamatan = $function->arrsKecamatan();
$arrs_kec = array();
foreach ($getKecamatan as $key => $value) {
$count_kec = $model->getCountAduanKecamatan($value);
$arrs_kec[] = array('kec' => $value, 'count' => $count_kec['count']);
}
// return index
return $this->render('index', ['aduan' => $aduan, 'member' => $member, 'user' => $user, 'count_category' => $arrs_cat, 'count_status' => $arrs_sts, 'count_kec' => $arrs_kec]);
} else {
// permasalahannya ada di siini.
return $this->redirect(Url::to(['login/index']));
}
}
public function actionEdit()
{
$model = new ModelUser();
$modelKat = new ModelKategori();
$function = new FunctionHelper();
$getKecamatan = $function->arrsKecamatan();
$session = Yii::$app->session;
$username = $session->get('username');
$warning = '';
if ($username != null) {
$request = Yii::$app->request;
$getUser = $model->getSingleUser($request->get('id'));
$getKategori = $modelKat->getKategori();
if ($model->load(Yii::$app->request->post())) {
$model->updateUser($request->get('id'));
return $this->redirect(Url::to(['user/edit', 'id' => $request->get('id')]));
}
return $this->render('edit', ['data' => $getUser, 'warning' => $warning, 'getKategori' => $getKategori, 'getKecamatan' => $getKecamatan]);
} else {
return $this->redirect(Url::to(['login/index']));
}
}
use backend\assets\AppAsset;
use yii\helpers\Url;
use yii\helpers\Html;
use yii\bootstrap\Nav;
use yii\bootstrap\NavBar;
use yii\widgets\Breadcrumbs;
use common\widgets\Alert;
use yii\web\Session;
use backend\components\helper\FunctionHelper;
AppAsset::register($this);
$session = Yii::$app->session;
$id = $session->get('id');
$nik = $session->get('nik');
$nama = $session->get('nama');
$user_level = $session->get('user_level');
$function = new FunctionHelper();
$this->beginPage();
?>
<!DOCTYPE html>
<html lang="<?php
echo Yii::$app->language;
?>
">
<meta charset="<?php
echo Yii::$app->charset;
?>
">
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php
echo Html::csrfMetaTags();
?>
<!-- <h2>Bordered with Striped Rows</h2> -->
<div class="table-responsive">
<table class="table table-bordered table-hover table-striped">
<thead>
<tr>
<th>No</th>
<th>Name</th>
<th>Username</th>
<th>User Level</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$function = new FunctionHelper();
foreach ($data as $key => $value) {
echo '<tr>
<td>' . $no . '</td>
<td><a href="' . ($url = Url::to(['user/edit', 'id' => $value['id']]) . '">' . $value['nama'] . '</a></td>
<td>' . $value['username'] . '</td>
<td>' . $function->UserLevel($value['user_level']) . '</td>
<td><a href="' . ($url = Url::to(['user/delete', 'id' => $value['id']]) . '">Delete</a></td>
</tr>'));
$no++;
}
// var_dump($data);
?>
</tbody>
</table>
</div>
<?php
/* @var $this yii\web\View */
/* @var $name string */
/* @var $message string */
/* @var $exception Exception */
use yii\helpers\Html;
use yii\helpers\Url;
use yii\widgets\ActiveForm;
use backend\components\helper\FunctionHelper;
$function = new FunctionHelper();
$this->title = 'Detail Member';
?>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load("current", {packages:["corechart"]});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
// ================= Chart 1 ========================= //
var data = google.visualization.arrayToDataTable([
['Nama Kategori', 'Jumlah'],
<?php
foreach ($count_category as $key => $value) {
echo '["' . $value['nama'] . '", ' . $value['count'] . '],';
}
?>
]);
var options = {
title: 'Jumlah Aduan Sesuai Kategori',
is3D: true,
<table class="table table-bordered table-hover table-striped">
<thead>
<tr>
<th>No</th>
<th>Tanggal</th>
<th>Judul</th>
<th>Member</th>
<th>Kategori</th>
<th>Deskripsi</th>
<th>Status Aduan</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$function = new FunctionHelper();
foreach ($data as $key => $value) {
switch ($value['status_aduan']) {
case '1':
$css = 'class="btn btn-primary"';
break;
case '2':
$css = 'class="btn btn-success"';
break;
case '3':
$css = 'class="btn btn-danger"';
break;
}
echo '<tr>
<td>' . $no . '</td>
<td>' . $value['tanggal_aduan'] . '</td>
