public function getdatachart(Request $request)
{
$tahun = $request->input('tahun');
$bulan = $request->input('bulan');
$nama = [];
$jumlah = [];
$barangs = Detailjual::with(['r_jual' => function ($query) use($tahun, $bulan) {
$query->where(DB::raw('YEAR(tgl)'), '=', $tahun)->whereMonth('tgl', '=', $bulan);
}])->get();
foreach ($barangs as $barang) {
array_push($nama, $barang->r_barang->namaBarang);
array_push($jumlah, Detailjual::with(['r_jual' => function ($query) use($tahun, $bulan) {
$query->where(DB::raw('YEAR(tgl)'), '=', $tahun)->whereMonth('tgl', '=', $bulan);
}])->where('idBarang', '=', $barang->idBarang)->sum('jumlah'));
}
return View('datachart', compact('jumlah', 'nama'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$pjl = Penjualan::find($id);
$pjl->delete();
$dtl = Detailjual::where('kodeJual', '=', $id);
$dtl->delete();
return redirect('penjualan');
}
