public function export(Request $request)
{
$data = $request->all();
// dd($data);
$query = PesananBarang::hydrateRaw('SELECT
pesanan_barangs.pemesan,pesanan_barangs.tanggal,pesanan_barangs.id as nomor_pesanan,barang_terpesans.kuantitas
FROM
pesanan_barangs,
barangs,
barang_terpesans
WHERE
pesanan_barangs.id = barang_terpesans.pesanan_barang_id
AND barang_terpesans.barang_id = barangs.id
AND pesanan_barangs.tanggal >="' . $data['mulai'] . '"
AND pesanan_barangs.tanggal <"' . $data['selesai'] . '"
AND barang_terpesans.barang_id=' . $data['barang'] . '')->toArray();
// dd($query);
Excel::create('laporanpesanan', function ($excel) use($query) {
$excel->sheet('Sheetname', function ($sheet) use($query) {
$sheet->fromArray($query);
});
})->export('xls');
}
public function keterangan(Request $request, $id)
{
$all = $request->all();
$pesanan = PesananBarang::find($id);
$pesanan->keterangan = $all['keterangan'];
$pesanan->save();
return redirect('pesanan/index');
}
