public static function updateInventory() { foreach (Bullet::all() as $bullet) { $rounds_purchased = DB::table('inventories')->where('bullet_id', $bullet->id)->sum('rounds'); $rounds_fired = DB::table('shoots')->where('bullet_id', $bullet->id)->sum('rounds'); $bullet->inventory = $rounds_purchased - $rounds_fired; $bullet->save(); } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $orderID, $id) { // create the new Order $inventory = Inventory::find($id); $order = Order::find($orderID); $bullet = Bullet::find($request->bullet_id); // Get the data $inventory->boxes = $request->boxes; $inventory->rounds_per_box = $request->rounds_per_box; $inventory->rounds = $request->rounds_per_box * $request->boxes; $inventory->cost_per_box = $request->cost_per_box; $inventory->cost = $request->cost_per_box * $request->boxes; $inventory->notes = $request->notes; // Make relationships $inventory->bullet()->associate($bullet); $inventory->order()->associate($order); // Update the totals $inventory->order->updateCost(); $inventory->order->updateRounds(); $inventory->order->save(); // Save the Order $inventory->save(); // Update inventory for all Bullets Bullet::updateInventory(); session()->flash('message', 'Inventory has been Saved'); session()->flash('message-type', 'success'); return redirect()->action('InventoryController@show', [$order->id, $inventory->id]); }
public function scopePurposes() { foreach (Purpose::all() as $purpose) { } $inventory = Bullet::where('cartridge_id', $this->id)->select(DB::raw('SUM(`inventory`) as inventory, purpose_id'))->groupBy('purpose_id')->get(); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $tripID, $id) { // create the new Order $shoot = Shoot::find($id); $trip = Trip::find($tripID); $bullet = Bullet::find($request->bullet_id); // Get the data $shoot->rounds = $request->rounds; $shoot->firearm_id = $request->firearm_id; $shoot->notes = $request->notes; $shoot->trip()->associate($trip); $shoot->bullet()->associate($bullet); // Save the Order $shoot->save(); // Update inventory for all Bullets Bullet::updateInventory(); session()->flash('message', 'Shoot has been Saved'); session()->flash('message-type', 'success'); return redirect()->action('ShootController@show', [$trip->id, $shoot->id]); }
public function showManufacturers($manufacturer) { return view('bullets.index', ['cartridges' => Cartridge::all(), 'bullets' => Bullet::where('manufacturer', $manufacturer)->get(), 'sort' => 'inventory']); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // Find the Order $order = Order::find($id); // Update the data $order->store_id = $request->store_id; $order->order_date = $request->order_date; $order->notes = $request->notes; // Update the totals $order->updateCost(); $order->updateRounds(); // Save it $order->save(); // Update inventory for all Bullets Bullet::updateInventory(); session()->flash('message', 'Order has been saved'); session()->flash('message-type', 'success'); return redirect()->action('OrderController@show', [$order->id]); }