/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $carts = Cart::content(); $id = $request->input('id'); $rowid = $request->input('rowid'); $jumlah = $request->input('jumlah'); $barang = DB::table('barang'); $stok = $barang->whereIn('idBarang', $id)->lists('jumlahBarang'); foreach ($jumlah as $key => $val) { $jumlah['jumlah' . $key] = $jumlah[$key]; $idx = array_search($key, $stok); $stok['stok' . $idx] = $stok[$idx]; $rules['jumlah' . $key] = 'required|numeric|max:' . $stok[$idx]; $messages['jumlah' . $key . '.max'] = 'jumlah beli barang dengan "kode ' . $key . '" melebihi stok yang ada.'; $messages['jumlah' . $key . '.required'] = 'jumlah beli barang dengan "kode ' . $key . '" harus di isi.'; } $validator = Validator::make($jumlah, $rules, $messages); if ($validator->fails()) { return redirect('penjualan/create')->withErrors($validator)->withInput(); } else { $jual = new Penjualan(); $jual->kodeJual = $request->input('kodeJual'); $jual->userId = Auth::user()->userId; $jual->idPelanggan = $request->input('namaplg'); $jual->tgl = Dateindo::datenow(); $jual->save(); foreach ($carts as $cart) { // foreach ($jumlah as $key => $value) DB::table('detail_jual')->insert(['idBarang' => $cart->id, 'jumlah' => $jumlah[$cart->id], 'kodeJual' => $request->input('kodeJual')]); $barangs = DB::table('barang')->where('idBarang', '=', $cart->id)->get(); foreach ($barangs as $brg) { DB::table('barang')->where('idBarang', '=', $cart->id)->update(['jumlahBarang' => $brg->jumlahBarang - $jumlah[$cart->id]]); } } Cart::destroy(); return redirect('penjualan/create'); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $jual = new Penjualan(); $jual->kodeJual = $request->input('kodeJual'); $jual->tanggal = $this->getDate(); $jual->total = Cart::total(); $jual->nama = Auth::User()->nama; $jual->idPelanggan = $request->input('idPelanggan'); $jual->save(); $carts = Cart::content(); foreach ($carts as $cart) { $detailjual = new Detailjual(); $detailjual->kodeJual = $request->input('kodeJual'); $detailjual->kodeBarang = $cart->id; $detailjual->jumlah = $cart->qty; $detailjual->save(); } Cart::destroy(); return redirect('penjualan'); }