/** * Execute the job. * * @return void */ public function handle() { MutasiStokBahan::where('tanggal', $this->tanggal)->delete(); $bahans = \App\Bahan::MutasiStok($this->tanggal); $inserts = []; foreach ($bahans as $bahan) { array_push($inserts, ['bahan_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]); } MutasiStokBahan::insert($inserts); }
protected function _stokBahanPertahun(Request $request) { $tahun = $request->get('tahun') ? $request->get('tahun') : date('Y'); $start = Carbon::parse('first day of January ' . $tahun); $end = Carbon::parse('last day of December ' . $tahun); $bahans = \App\Bahan::MutasiStok($start->format('Y-m-d'), $end->format('Y-m-d')); return ['tanggal' => Carbon::createFromFormat('Y', $tahun), 'bahans' => $bahans]; }