/** * Execute the job. * * @return void */ public function handle() { $oldStok = StokBahan::all(); $oldStokKey = array_column($oldStok->toArray(), 'bahan_id'); $bahans = Bahan::stok()->orderBy('bahans.id')->get(); foreach ($bahans as $bahan) { if (in_array($bahan->id, $oldStokKey)) { StokBahan::where('bahan_id', $bahan->id)->update(['stok' => $bahan->sisa_stok]); } else { StokBahan::create(['bahan_id' => $bahan->id, 'stok' => $bahan->sisa_stok]); } } }
public function showTest(Request $request) { $action = $request->get('act') ? $request->get('act') : 'bahan'; $action = strtolower($action); if ($action == 'produk') { return \App\Produk::stok()->orderBy('produks.id')->get(); } elseif ($action == 'bahan') { return \App\Bahan::stok()->orderBy('bahans.id')->get(); } else { abort(404); } }