public static function getListPengaduanByUser($sortBy, $id_masyarakat)
{
if ($sortBy == "default") {
$model = PengaduanModel::where('id_masyarakat', $id_masyarakat)->get();
} else {
if ($sortBy == "tanggal") {
$model = PengaduanModel::where('id_masyarakat', $id_masyarakat)->orderBy('created_at', 'DESC')->get();
} else {
if ($sortBy == "status") {
$model = PengaduanModel::where('id_masyarakat', $id_masyarakat)->orderBy('id_status', 'ASC')->get();
}
}
}
$array = [];
$i = 0;
foreach ($model as $pengaduan) {
$temp = new Pengaduan();
$temp->setJudul($pengaduan['judul']);
$temp->setSlug($pengaduan['slug']);
$temp->setIdStatus($pengaduan['id_status']);
$temp->setDeskripsi($pengaduan['deskripsi']);
$temp->setGambar($pengaduan['gambar']);
$temp->setIdKategori($pengaduan['id_kategori']);
$temp->setIdMasyarakat($pengaduan['id_masyarakat']);
$temp->setKategori($pengaduan['id_kategori']);
$temp->setStatus($pengaduan['id_status']);
$temp->setLampiran($pengaduan['lampiran']);
$temp->setCreatedDate($pengaduan['created_at']);
$temp->setPelapor($pengaduan['pelapor']);
$array[$i] = $temp;
$i++;
}
return $array;
}
public function insert(Request $request)
{
$id_user = Session::get('id_user');
// Form handling
$judul = $request->get('judul');
$deskripsi = $request->get('deskripsi');
$status = StatusModel::where('nama', 'pending')->first();
$id_kategori = $request->get('id_kategori');
// lampiran
date_default_timezone_set("UTC");
$lampiran = Input::file('lampiran');
if ($lampiran != null) {
$ext = $lampiran->getClientOriginalExtension();
$lampiran_filename = $id_user . "-" . Date("YmdHis", time()) . "." . $ext;
$lampiran->move(public_path() . '/pengaduan-lampiran', $lampiran_filename);
} else {
$lampiran_filename = "NULL";
}
// gambar
$gambar = Input::file('gambar');
if ($gambar != null) {
$ext = $gambar->getClientOriginalExtension();
$gambar_filename = $id_user . "-" . Date("YmdHis", time()) . "." . $ext;
$gambar->move(public_path() . '/pengaduan-gambar', $gambar_filename);
} else {
$gambar_filename = "NULL";
}
// Save to database
$pengaduan = new Pengaduan();
$pengaduan->setJudul($judul);
$pengaduan->setIdKategori($id_kategori);
$pengaduan->setLampiran($lampiran_filename);
$pengaduan->setGambar($gambar_filename);
$pengaduan->setDeskripsi($deskripsi);
$pengaduan->setIdMasyarakat($id_user);
$pengaduan->setIdStatus($status->id);
$pengaduan->setSlug($this->generateSlug($judul, new PengaduanModel()));
$pengaduan->savePengaduan();
return redirect('buat-pengaduan')->with('message', "PENGADUAN INSERTED");
}
