@include('dashboard/header')

Total Projects

@php $total = DB::table('projects')->count(); $tasks = DB::table('tasks')->get(); @endphp

{{ $total}}

Total Team Members

@php $completed = DB::table('users')->where('role', 0)->count(); @endphp

{{ $completed}}

Total Tasks Created

@php $allocated = DB::table('tasks')->count(); @endphp

{{ $allocated }}

Total Completed Tasks

@php $comp = DB::table('tasks')->where('status', 2)->count(); @endphp

{{ $comp }}

Total Pending Tasks

@php $pnd = DB::table('tasks')->where('status', '<', 2)->count(); @endphp

{{ $pnd }}