/** * Execute the job. * * @return void */ public function handle() { MutasiStokProduk::where('tanggal', $this->tanggal)->delete(); $bahans = \App\Produk::MutasiStok($this->tanggal); $inserts = []; foreach ($bahans as $bahan) { array_push($inserts, ['produk_id' => $bahan['id'], 'before' => $bahan['before'], 'pembelian' => $bahan['pembelian'], 'penjualan' => $bahan['penjualan'], 'adjustment_increase' => $bahan['adjustment_increase'], 'adjustment_reduction' => $bahan['adjustment_reduction'], 'sisa' => $bahan['sisa'], 'tanggal' => $this->tanggal]); } MutasiStokProduk::insert($inserts); }
protected function _stok(Request $request) { $tanggal = $request->get('tanggal') ? $request->get('tanggal') : date('Y-m-d'); $produks = \App\MutasiStokProduk::where('tanggal', $tanggal)->with(['produk'])->get(); return ['tanggal' => Carbon::parse($tanggal), 'produks' => $produks]; }