@if(isset($api)) @endif @php $cntRoomHostel = 0; $sumAllHostel = 0; $renterRoomCntHostel = 0; $sumRenterRoomHostel = 0; $sumRenterEmptyHostel=0; $reserveCntHostel=0; @endphp @foreach($hostels as $hostel) @php $sumRenterRoom=0; $sumRenterEmpty=0; $cntRoom = $hostel->rooms->count(); if($hostel->type_rent == App\Models\Hostel::TYPE_RENT_ALL) { $sumAll=$hostel->rooms->sum('price'); $renterRoomCntArr = App\Models\RenterRoom::query() ->where('hostel_id', $hostel->id) ->groupBy('room_id') ->get(); $renterRoomCnt = $renterRoomCntArr->count(); $sumRenterRoom = \App\Models\Contract::query() ->where('hostel_id', $hostel->id) ->where('status', '=', \App\Models\Contract::VALIDATED) ->whereIn('room_id', $renterRoomCntArr->pluck('room_id')->toArray()) ->sum('room_price'); $sumRenterEmpty = \App\Models\Room::query() ->where('hostel_id', $hostel->id) ->whereNotIn('id', $renterRoomCntArr->pluck('room_id')->toArray()) ->sum('price'); $reserveCntArr = App\Models\RoomReservation::query() ->where('hostel_id', $hostel->id) ->has('room') ->groupBy('room_id') ->pluck('room_id')->toArray(); //dump($reserveCntArr); $reserveCnt = count($reserveCntArr); } else { $sumAll = 0; $cntRoom = $hostel->rooms->sum('max_renters'); $renterRoomCntArr = App\Models\RenterRoom::query() ->with('room') ->has('room') ->where('hostel_id', $hostel->id) ->get(); //dd($renterRoomCntArr->pluck('room_id')->toArray()); $renterRoomCnt = $renterRoomCntArr->count(); foreach ($renterRoomCntArr as $item) { $sumRenterRoom+= $item->room->price; } foreach ($hostel->rooms as $room) { $sumAll+=$room->max_renters * $room->price; $used = \App\Models\RoomBed::query() ->where('room_id', $room->id) ->whereHas('contract', function($q) { $q->where('status', '<>', \App\Models\Contract::LIQUIDATED); }) ->count(); $empty = $room->beds->count() - $used; $sumRenterEmpty += $empty * $room->price; } $reserveCnt = App\Models\RoomReservation::query() ->has('room') ->where('hostel_id', $hostel->id) ->count(); } @endphp @php $cntRoomHostel += $cntRoom; $sumAllHostel+=$sumAll; $renterRoomCntHostel+=$renterRoomCnt; $sumRenterRoomHostel+=$sumRenterRoom; $sumRenterEmptyHostel+=$sumRenterEmpty; $reserveCntHostel+=$reserveCnt; @endphp @endforeach

Báo cáo tổng hợp hiện trạng thuê
STT	Nhà	Số phòng	Tổng tiền	Đang thuê	Tiền phòng thuê	Còn trống	Tiền phòng trống	Đang cọc giữ chỗ
{{ $loop->index + 1 }}	{{ $hostel->name }}	{{ $cntRoom}}	{{ number_format($sumAll, 0, '.', '.') }}	{{ $renterRoomCnt }}	{{ number_format($sumRenterRoom, 0, '.', '.') }}	{{ $cntRoom - $renterRoomCnt }}	{{ number_format($sumRenterEmpty, 0, '.', '.') }}	{{ $reserveCnt }}
Tổng		{{ $cntRoomHostel }}	{{ number_format($sumAllHostel, 0, '.', '.') }}	{{ $renterRoomCntHostel }}	{{ number_format($sumRenterRoomHostel, 0, '.', '.') }}	{{ $cntRoomHostel - $renterRoomCntHostel }}	{{ number_format($sumRenterEmptyHostel, 0, '.', '.') }}	{{ $reserveCntHostel }}