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"); }