public function update(Request $request)
 {
     $user = UserModel::find($request->get('id_skpd'));
     $user->username = $request->get('username');
     $user->password = $request->get('password');
     $user->save();
     $skpd = SKPDModel::where('id', $request->get('id_skpd'))->first();
     $skpd->nama = $request->get('nama');
     $skpd->alamat = $request->get('alamat');
     $skpd->save();
     DB::table('ppl_citizenreport_penanggungjawab')->where('id_skpd', $request->get('id_skpd'))->update(array('id_kategori' => $request->get('id_kategori')));
     return redirect('manajemen-skpd')->with('message', 'Akun SKPD telah diupdate.');
 }
 public function editSKPD($id_skpd)
 {
     $skpd = SKPDModel::where('id', $id_skpd)->first();
     $listKategori = KategoriModel::all();
     return view('pages.admin.edit_skpd', compact('skpd', 'listKategori'));
 }