public function deleteDetail() { if (isset($_POST)) { $id = $_POST['id']; $det = DetailPenjualan::findOrFail($id); $penjualan = Penjualan::where('id', '=', $det->penjualan_id)->first(); // dd($penjualan->id); if (DetailPenjualan::destroy($id)) { $barangs = DetailPenjualan::where('penjualan_id', '=', $penjualan->id)->get(); $nominal = 0; foreach ($barangs as $key => $value) { $nominal += $value->total; } $penjualan->nominal = $nominal; $penjualan->save(); } } }
/** * Remove the specified customer from storage. * * @param int $id * @return Response */ public function destroy($id) { if ($pj = Penjualan::where('customer_id', '=', $id)->first()) { $pjid = $pj->id; DetailPenjualan::where('penjualan_id', '=', $pjid)->delete(); } Penjualan::where('customer_id', '=', $id)->delete(); Customer::destroy($id); return Redirect::to('admin/customer/tipe/1')->with('message', 'berhasil menghapus customer'); }
public function printChart() { $penjualans = Penjualan::orderBy('tgl_transfer', 'DESC')->take(7)->get(); $barangs = Barang::orderBy('id', 'DESC')->take(4)->get(); $customers = Penjualan::with('customer')->orderBy('tgl_transfer', 'DESC')->take(8)->get(); $baru = Penjualan::where('status', 1)->count(); $orders = Order::where('status', 1)->count(); $poBaru = Penjualan::where('tgl_transfer', '>=', '2015-11-01')->count(); $okt = Penjualan::whereBetween('tgl_transfer', ['2015-10-01', '2015-10-31'])->get(); $sep = Penjualan::whereBetween('tgl_transfer', ['2015-09-01', '2015-09-30'])->get(); $okts['dates'] = $okt->lists('tgl_transfer'); $okts['totals'] = $okt->lists('nominal'); $seps['dates'] = $sep->lists('tgl_transfer'); $seps['totals'] = $sep->lists('nominal'); $sumO = 0; foreach ($okts['totals'] as $t) { $sumO += $t; } $sumS = 0; foreach ($seps['totals'] as $t) { $sumS += $t; } $mar = Penjualan::whereBetween('tgl_transfer', ['2015-03-19', '2015-03-31'])->lists('nominal'); $apr = Penjualan::whereBetween('tgl_transfer', ['2015-04-01', '2015-04-31'])->lists('nominal'); $may = Penjualan::whereBetween('tgl_transfer', ['2015-05-01', '2015-05-31'])->lists('nominal'); $jun = Penjualan::whereBetween('tgl_transfer', ['2015-06-01', '2015-06-31'])->lists('nominal'); $jul = Penjualan::whereBetween('tgl_transfer', ['2015-07-01', '2015-07-31'])->lists('nominal'); $aug = Penjualan::whereBetween('tgl_transfer', ['2015-08-01', '2015-08-31'])->lists('nominal'); $nov = Penjualan::where('tgl_transfer', '>=', Carbon::now()->startOfMonth())->lists('nominal'); $lap['maret'] = 0; $lap['april'] = 0; $lap['mei'] = 0; $lap['juni'] = 0; $lap['juli'] = 0; $lap['agustus'] = 0; $lap['sept'] = $sumS; $lap['okt'] = $sumO; $lap['nov'] = 0; foreach ($mar as $m) { $lap['maret'] += $m; } foreach ($apr as $m) { $lap['april'] += $m; } foreach ($may as $m) { $lap['mei'] += $m; } foreach ($jun as $m) { $lap['juni'] += $m; } foreach ($jul as $m) { $lap['juli'] += $m; } foreach ($aug as $m) { $lap['agustus'] += $m; } foreach ($nov as $m) { $lap['nov'] += $m; } return View::make('admin/charts.linePoChart', compact('penjualans', 'barangs', 'customers', 'baru', 'poBaru', 'okts', 'seps', 'sumO', 'sumS', 'orders', 'lap')); }