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