addLoop($__currentLoopData); foreach($__currentLoopData as $hostel): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> contractValids; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $contract): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> room; $ew = App\Components\Functions::getEwLatestRoom5($contract->room, $contract, $monthCarbon->copy()); ?> where( 'hostel_id', $hostel->id ) ->whereIn('type', [ \App\Models\HostelFee::ELECTRIC, \App\Models\HostelFee::ELECTRIC_BY_CLOCK ]) ->first(); $feeW = \App\Models\HostelFee::query() ->where( 'hostel_id', $hostel->id ) ->whereIn('type', [ \App\Models\HostelFee::WATER, \App\Models\HostelFee::WATER_BY_CLOCK ]) ->first(); $qE = App\Components\Functions::getEwLatestContract($contract, $feeE); $qW = App\Components\Functions::getEwLatestContract($contract, $feeW); $moneyDetailE = null; $moneyDetailW=null; if($feeE) { $moneyDetailE = \App\Models\MoneyDetail::query() ->whereHas('moneyInfo', function($query) use ($monthCarbon, $contract) { $query->whereBetween('date_action', [ $monthCarbon->copy()->startOfMonth(), $monthCarbon->copy()->endOfMonth()]); $query->where('type', \App\Models\MoneyInfo::VOUCHER_SERVICE); $query->where('contract_id', $contract->id); }) ->where('hostel_fee_id', $feeE->id) ->first(); } if($feeW) { $moneyDetailW = \App\Models\MoneyDetail::query() ->whereHas('moneyInfo', function($query) use ($monthCarbon, $contract) { $query->whereBetween('date_action', [ $monthCarbon->copy()->startOfMonth(), $monthCarbon->copy()->endOfMonth()]); $query->where('type', \App\Models\MoneyInfo::VOUCHER_SERVICE); $query->where('contract_id', $contract->id); }) ->where('hostel_fee_id', $feeW->id) ->first(); } ?> qty, true); $startElectric = $info['start']; $endElectric = $info['end']; ?> qty, true); $startWater = $info['start']; $endWater = $info['end']; ?> popLoop(); $loop = $__env->getLastLoop(); ?> popLoop(); $loop = $__env->getLastLoop(); ?>

Nhà trọ	Phòng trọ	Hợp đồng	Tháng	Ngày chốt	Số điện đầu	Số điện cuối	Số nước đầu	Số nước cuối	SĐT người chốt
name); ?>	name); ?>	name); ?>	format('m/Y')); ?>	format('d/m/Y')); ?>		0		0	user()->phone); ?>