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>