/**
* 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');
}
