public function actionDetail()
{
$model = new ModelMember();
$model_aduan = new ModelAduan();
$model_analytics = new ModelAnalytics();
$model_cat = new ModelKategori();
$request = Yii::$app->request;
$session = Yii::$app->session;
$username = $session->get('username');
if ($username != null) {
$member = $model->getSingleMember($request->get('id'));
$aduan = $model_aduan->getAduanMember($request->get('id'));
// Count aduan categori
$arrs_cat = array();
foreach ($model_cat->getKategori() as $key => $value) {
$c_aduan_cat = $model_analytics->getCountAduanCategory($value['id'], ' AND member="' . $request->get('id') . '"');
$arrs_cat[] = array('nama' => $value['nama'], 'count' => $c_aduan_cat['count']);
}
// Count aduan status
$status_diterima = $model_analytics->getCountAduanStatus('1', ' AND member="' . $request->get('id') . '"');
$status_dilaksanakan = $model_analytics->getCountAduanStatus('2', ' AND member="' . $request->get('id') . '"');
$status_ditolak = $model_analytics->getCountAduanStatus('3', ' AND member="' . $request->get('id') . '"');
$arrs_sts = array('Diterima' => $status_diterima['count'], 'Dilaksanakan' => $status_dilaksanakan['count'], 'Ditolak' => $status_ditolak['count']);
return $this->render('detail', ['data' => $member, 'data_aduan' => $aduan, 'count_category' => $arrs_cat, 'count_status' => $arrs_sts]);
} else {
return $this->redirect(Url::to(['login/index']));
}
}
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 ModelKategori();
$session = Yii::$app->session;
$username = $session->get('username');
if ($username != null) {
$request = Yii::$app->request;
if ($model->load(Yii::$app->request->post())) {
$model->updateKategori($request->get('id'));
}
$data = $model->getKategori();
$edit = $model->getSingleKategori($request->get('id'));
return $this->render('index', ['data' => $data, 'edit' => $edit]);
} else {
return $this->redirect(Url::to(['login/index']));
}
}
public function actionProfile()
{
$model = new ModelUser();
$modelKat = new ModelKategori();
$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]);
} else {
return $this->redirect(Url::to(['login/index']));
}
}
public function actionGetkategori()
{
$model = new ModelKategori();
$data = $model->getKategori();
header('Content-Type: application/json');
if ($data == false) {
echo json_encode(array('data' => $data, 'status' => '1'));
} else {
echo json_encode(array('data' => $data, 'status' => '2'));
}
// URL : http://back.end/index.php?r=api/getkategori
}
