File manager - Edit - /home/linknsbh/restawy.online/app/Http/Controllers/Admin/DashboardController.php
Back
<?php namespace App\Http\Controllers\Admin; use App\Http\Controllers\Controller; use App\Models\Language; use App\Models\Membership; use App\Models\User; use Carbon\Carbon; use Illuminate\Contracts\View\View; use Illuminate\Http\RedirectResponse; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; class DashboardController extends Controller { public function dashboard(): View { $data['incomes'] = Membership::select(DB::raw('MONTH(created_at) month'), DB::raw('sum(price) total'))->where('status', 1)->groupBy('month')->whereYear('created_at', date('Y'))->get(); $data['users'] = User::join('memberships', 'users.id', '=', 'memberships.user_id') ->select(DB::raw('MONTH(users.created_at) month'), DB::raw('count(*) total')) ->groupBy('month') ->whereYear('users.created_at', date('Y')) ->where([ ['memberships.status','=',1], ['memberships.start_date','<=', Carbon::now()->format('Y-m-d')], ['memberships.expire_date', '>=', Carbon::now()->format('Y-m-d')] ]) ->get(); $data['defaultLang'] = Language::where('is_default', 1)->first(); return view('admin.dashboard',$data); } public function changeTheme(Request $request): RedirectResponse { return redirect()->back()->withCookie(cookie()->forever('admin-theme', $request->theme)); } }
| ver. 1.4 |
Github
|
.
| PHP 8.2.31 | Generation time: 0.12 |
proxy
|
phpinfo
|
Settings