/** * Display a listing of the resource. * * @return Response */ public function index() { $data = PengadaanBarang::all(); return view('aktivitas.pengadaan.index', compact('data')); // }
public function export(Request $request) { $data = $request->all(); // dd($data); $query = PengadaanBarang::hydrateRaw('SELECT pengadaan_barangs.tanggal, pengadaan_barangs.id as nomor_pengadaan, barang_terimas.kuantitas FROM pengadaan_barangs, barangs, barang_terimas WHERE pengadaan_barangs.id = barang_terimas.pengadaan_barang_id AND barang_terimas.barang_id = barangs.id AND pengadaan_barangs.tanggal >="' . $data['mulai'] . '" AND pengadaan_barangs.tanggal <"' . $data['selesai'] . '" AND barang_terimas.barang_id=' . $data['barang'] . ''); // dd($query); Excel::create('laporanpengadaan', function ($excel) use($query) { $excel->sheet('Sheetname', function ($sheet) use($query) { $sheet->fromArray($query); }); })->export('xls'); }