public function login(Request $request)
{
$nik = $request->get('nik');
$password = $request->get('password');
$user = UserModel::where('nik', $nik)->where('password', $password)->first();
$user_role = strtoupper($user->role);
if ($user_role == "MASYARAKAT") {
$daftar_pengaduan = Pengaduan::where('id_masyarakat', $user->id)->where('id_status', 6)->get();
// status rejected
} else {
if ($user_role == "SKPD") {
$SKPD = PenanggungJawab::where('id_skpd', $user->id)->first();
$daftar_pengaduan = Pengaduan::where('id_kategori', $SKPD->id_kategori)->where('id_status', 2)->get();
// status forwarded
} else {
$daftar_pengaduan = "";
}
}
if (count($user) < 1) {
return redirect('login');
} else {
Session::put('id_user', $user->id);
Session::put('username', $user->username);
Session::put('role', $user_role);
if ($user_role != "ADMIN" && $daftar_pengaduan != "[]") {
Session::flash('notification', $daftar_pengaduan);
}
return redirect('index');
}
}
public static function getJumlahAduanClosedForNMonthsByCategory($jumBulanTerakhir, $id_kategori)
{
$jumAduan = new StatistikAduan();
$month = date('m');
$year = date('Y');
$j = 0;
for ($i = $jumBulanTerakhir; $i >= 0; $i--) {
$m = $month - $i;
$y = $year;
if ($m <= 0) {
$m = 12 + $m;
$y = $y - 1;
}
$bulanFormatted = Pengaduan::getMonthName($m);
$tahunFormatted = $y;
$dateStr = $bulanFormatted . " " . $tahunFormatted;
$jumAduan->date[$j] = $dateStr;
$jumAduan->jumlah[$j] = Pengaduan::getJumlahAduanClosedByCategory($dateStr, $id_kategori);
$j++;
}
return $jumAduan;
}
public function pengaduanku($sortBy)
{
$listPengaduan = Pengaduan::getListPengaduanByUser($sortBy, Session::get('id_user'));
return view('pages.pengaduanku', compact('listPengaduan'));
}
public function kirim($slug)
{
$idStatus = StatusModel::where('nama', 'forwarded')->first()['id'];
Pengaduan::updateStatus($slug, $idStatus, NULL);
return redirect('pengaduan/' . $slug)->with('message', 'PENGADUAN TERKIRIM');
}
