public function IndexAdmin() { $opex = Opex::whereYear('fecha', '=', date('Y'))->selectRaw('sum(monto) as monto, fecha as mes')->groupBy(\DB::raw('MONTH(fecha)'))->get(); $alumnos_activos = Role::find(1)->users()->where('cuenta_activa', true)->count(); $alumnos_totales = Role::find(1)->users()->count(); $coachs = Role::find(2)->users()->where('cuenta_activa', true)->count(); $pagos = PagoMensualidad::whereYear('fecha_pago', '=', date('Y'))->selectRaw('sum(monto) as monto, fecha_pago as mes')->groupBy(\DB::raw('MONTH(fecha_pago)'))->get(); return view('admin_home', compact('opex', 'alumnos_activos', 'alumnos_totales', 'pagos', 'coachs')); }