@extends('fronted.layout.main') @section('adcontent') @if ($message = Session::get('UserPermission')) @php $permissionArray = $message; $userRoll = session('userRoll'); @endphp @else @php $permissionArray = []; $userRoll = 'Admin'; @endphp @endif

@php $totalroom = DB::table('roomseats')->where('status',1)->count('roomno'); @endphp

Total Room : {{ $totalroom }}

Engaged Room : {{ $engagedroom }}

Total Seats : {{ $totalseats }}

Engaged Seats : {{ $engagedseats }}

ROOM-SEATS

Total Reg. : {{ $studentregister }}

This Month : {{ $count }}

REGISTRATION

@php $totalExpense = DB::table('expenses') ->join('expensedetails', 'expenses.id', '=', 'expensedetails.category_id') ->select(DB::raw('SUM(expensedetails.amount) as total')) ->value('total'); if ($totalExpense == '') { $totalExpense = 0; } @endphp