/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { return view('purposes.index', ['purposes' => Purpose::all()]); }
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(); }