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