<table cellspacing="0" style="border-collapse:collapse;"> <tbody> <tr> </tr> <tr> <td rowspan="2" style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> <span><span style="color:#000000">STT</span></span></td> <td rowspan="2" style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> <span><span style="color:#000000">Nhà</span></span></td> <td rowspan="2" style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> <span><span style="color:#000000">Phòng</span></span> </td> <td rowspan="2" style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> <span><span style="color:#000000">Khách</span></span></td> <td rowspan="2" style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> <span><span style="color:#000000">Tháng</span></span></td> <?php $__currentLoopData = $fees; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $fee): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <td <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_DYNAMIC, App\Models\HostelFee::WATER_DYNAMIC, App\Models\HostelFee::DYNAMIC, App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC, App\Models\HostelFee::WATER_BY_CLOCK, App\Models\HostelFee::WATER, ])): ?> colspan="2" <?php endif; ?> style=" border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <span><span style="color:#000000"><?php echo e($fee->name); ?></span></span> </td> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <?php $__currentLoopData = $fees; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $fee): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_DYNAMIC, App\Models\HostelFee::WATER_DYNAMIC, App\Models\HostelFee::DYNAMIC, ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> Đơn giá </td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> Số lượng </td> <?php elseif(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC, App\Models\HostelFee::WATER_BY_CLOCK, App\Models\HostelFee::WATER, ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> Chỉ số đầu </td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> Chỉ số cuối </td> <?php else: ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"> Số lượng </td> <?php endif; ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </tr> <?php $__currentLoopData = $contracts; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $contract): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <tr> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal; height: 28px"><?php echo e($loop->index + 1); ?> </td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($contract->hostel->name); ?></td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($contract->room->name); ?> </td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($contract->name); ?></td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($monthCarbon->copy()->format('m/Y')); ?></td> <?php $__currentLoopData = $fees; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $fee): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <?php $ew = App\Components\Functions::getEwLatestRoom4($contract, $monthCarbon->copy(), $fee); ?> <?php $q = App\Components\Functions::getEwLatestContract($contract, $fee);


            $moneyDetail = \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', $fee->id)
            ->first();



                ?> <?php if($moneyDetail): ?> <?php
                        $info = json_decode($moneyDetail->qty, true);
                               $startElectric = $info['start'];
                              $startWater = $info['start'];

                              $endElectric = $info['end'];
                              $endWater = $info['end'];
                    ?> <?php endif; ?> <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_DYNAMIC, App\Models\HostelFee::WATER_DYNAMIC, App\Models\HostelFee::DYNAMIC, ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($q); ?> </td> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"><?php echo e($q); ?> </td> <?php elseif(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC, App\Models\HostelFee::WATER_BY_CLOCK, App\Models\HostelFee::WATER, ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC ])): ?> <?php if($moneyDetail): ?> <?php echo e($startElectric); ?> <?php else: ?> <?php if(!empty($ew['start_e'])): ?> <?php echo e($ew['start_e']); ?> <?php else: ?> <?php echo e($q); ?> <?php endif; ?> <?php endif; ?> <?php else: ?> <?php if($moneyDetail): ?> <?php echo e($startWater); ?> <?php else: ?> <?php if(!empty($ew['start_w'])): ?> <?php echo e($ew['start_w']); ?> <?php else: ?> <?php echo e($q); ?> <?php endif; ?> <?php endif; ?> <?php endif; ?> </td> <?php if($moneyDetail): ?> <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php echo e($endElectric); ?> </td> <?php else: ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php echo e($endWater); ?> </td> <?php endif; ?> <?php else: ?> <?php if(in_array($fee->type, [ App\Models\HostelFee::ELECTRIC_BY_CLOCK, App\Models\HostelFee::ELECTRIC ])): ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php echo e($ew['end_e']); ?> </td> <?php else: ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php echo e($ew['end_w']); ?> </td> <?php endif; ?> <?php endif; ?> <?php else: ?> <td style="border:1px solid #000000; text-align:center; vertical-align:middle; white-space:normal;"> <?php echo e($q); ?> </td> <?php endif; ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </tr> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </tbody> </table>