@foreach($fees as $fee) @if(in_array($fee->type, [ \App\Models\HostelFee::ELECTRIC, \App\Models\HostelFee::WATER, \App\Models\HostelFee::ELECTRIC_BY_CLOCK, \App\Models\HostelFee::WATER_BY_CLOCK, ])) @else @endif @endforeach @foreach($fees as $fee) @if(in_array($fee->type, [ \App\Models\HostelFee::ELECTRIC, \App\Models\HostelFee::WATER, \App\Models\HostelFee::ELECTRIC_BY_CLOCK, \App\Models\HostelFee::WATER_BY_CLOCK, ])) @else @endif @endforeach @foreach($contracts as $contract) @php $moneyInfosRoom = \App\Models\MoneyInfo::query() ->where('contract_id', $contract->id) ->whereIn('type', [\App\Models\MoneyInfo::VOUCHER_ROOM_PRICE, \App\Models\MoneyInfo::VOUCHER_CONTRACT]) ->whereBetween('date_action', [ $month->copy()->startOfMonth(), $month->copy()->endOfMonth() ]) ->first(); $startDate=null; $endDate = null; if($moneyInfosRoom) { $details = $moneyInfosRoom->details; if($details) { $detail = $details->first(); $startDate = \Carbon\Carbon::createFromFormat('Y-m-d', $detail->start_date)->format('d/m/Y'); $endDate = \Carbon\Carbon::createFromFormat('Y-m-d', $detail->end_date)->format('d/m/Y'); } } $moneyInfosRoom = optional($moneyInfosRoom); $moneyInfos = \App\Models\MoneyInfo::query() ->where('contract_id', $contract->id) ->when($typeDisplay == \App\User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) { $q->where(function ($q) use ($month) { $q->orWhere(function ($q) use ($month) { $q->whereBetween('date_action', [ $month->copy()->startOfMonth(), $month->copy()->endOfMonth() ]); $q->whereIn('type', [ \App\Models\MoneyInfo::VOUCHER_CONTRACT, \App\Models\MoneyInfo::VOUCHER_ROOM_PRICE ]); }); $q->orWhere(function ($q) use ($month) { $q->whereBetween('date_action', [ $month->copy()->subMonth()->startOfMonth(), $month->copy()->subMonth()->endOfMonth() ]); $q->where('type', \App\Models\MoneyInfo::VOUCHER_SERVICE); }); }); }, function ($q) use ($month) { $q->whereBetween('date_action', [ $month->copy()->startOfMonth(), $month->copy()->endOfMonth() ]); })->get(); @endphp @foreach($fees as $fee) @php $detail = \App\Models\MoneyDetail::query() ->where('hostel_fee_id', $fee->id) ->whereHas('moneyInfo', function($q) use ($contract, $moneyInfos) { $q->where('contract_id', $contract->id); }) ->whereIn('money_info_id', $moneyInfos->pluck('id')->toArray()) ->first(); $detail = optional($detail); @endphp @if(in_array($fee->type, [ \App\Models\HostelFee::ELECTRIC, \App\Models\HostelFee::WATER, \App\Models\HostelFee::ELECTRIC_BY_CLOCK, \App\Models\HostelFee::WATER_BY_CLOCK, ])) @else @endif @endforeach @endforeach

Nhà

Phòng

Khách

Tháng

Số tiền

Đã trả

Giảm giá

Còn lại

Tiền nhà

{{ $fee->name }}

{{ $fee->name }}

Ghi chú

Từ ngày

Đến ngày

Thành tiền

Số đầu

Số cuối

Thành tiền

Số lượng

Thành tiền

{{ $contract->hostel->name }}

{{ $contract->room->name}}

{{ $contract->name }}

{{ $month->copy()->format('m/Y') }}

{{ $moneyInfos->sum('amount') }}

{{ $moneyInfos->sum('pay') }}

{{ $moneyInfos->sum('discount') }}

{{ $moneyInfos->sum('remain') }}

{{ $startDate }}

{{ $endDate }}

{{ $moneyInfosRoom->amount }}

{{ $detail->start_index }}

{{ $detail->end_index }}

{{ $detail->amount }}

{{ $detail->qty }}

{{ $detail->amount }}

@foreach($moneyInfos as $moneyInfo) @if(!empty($moneyInfo->note)) {{ $moneyInfo->note }} @else            @endif @endforeach