<style> .red { color: #eb4034; } .uppercase { text-transform: uppercase } <?php if(isset($isExcel)): ?> #tb td, #tb th { border: 1px solid #000000; } td { text-align: center; } th { text-align: center; } <?php endif; ?> </style> <table class="table table-striped table-bordered table-hover" id="tb"> <tr> <th colspan="9" class="uppercase">Báo cáo tình hình sử dụng điện nước tháng <?php echo e($month->copy()->format('m/Y')); ?></th> </tr> <tr> <th rowspan="2">STT</th> <th rowspan="2">Nhà</th> <th rowspan="2">Phòng</th> <th colspan="3">Số điện</th> <th colspan="3">Số nước</th> </tr> <tr> <?php if(isset($isExcel)): ?> <th></th> <th></th> <th></th> <?php endif; ?> <th><strong>Chỉ số đầu</strong></th> <th><strong>Chỉ số cuối</strong></th> <th><strong>Chênh lệch</strong></th> <th><strong>Chỉ số đầu</strong></th> <th><strong>Chỉ số cuối</strong></th> <th><strong>Chênh lệch</strong></th> </tr> <tr> <td><strong>I</strong></td> <td><strong>Tất cả nhà</strong></td> <td><strong>Tất cả phòng</strong></td> <td></td> <td></td> <td><strong><?php echo e($sumElectric); ?></strong></td> <td></td> <td></td> <td><strong><?php echo e($sumWater); ?></strong></td> </tr> <?php $__currentLoopData = $hostels; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $hostel): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <tr> <td><strong><?php echo e(App\Components\Functions::numberToRomanRepresentation($loop->index + 2)); ?></strong></td> <td rowspan="<?php echo e($hostel->rooms->count() + 1); ?>"> <strong><?php echo e($hostel->name); ?></strong></td> <td><strong>Tất cả phòng</strong></td> <td></td> <td></td> <td><strong><?php echo e($hostel->ewMonth($month)->sum('delta_electric')); ?></strong></td> <td></td> <td></td> <td><strong><?php echo e($hostel->ewMonth($month)->sum('delta_water')); ?></strong></td> </tr> <?php $__currentLoopData = $hostel->rooms; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $room): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> <tr> <td><?php echo e($loop->index + 1); ?></td> <?php if(isset($isExcel)): ?> <td></td> <?php endif; ?> <td><?php echo e($room->name); ?></td> <?php if($room->ewMonth($month)->count() > 0): ?> <td><?php echo e($room->ewMonth($month)->sum('start_electric')); ?></td> <td><?php echo e($room->ewMonth($month)->sum('end_electric')); ?></td> <td><?php echo e($room->ewMonth($month)->sum('delta_electric')); ?></td> <td><?php echo e($room->ewMonth($month)->sum('start_water')); ?></td> <td><?php echo e($room->ewMonth($month)->sum('end_water')); ?></td> <td><?php echo e($room->ewMonth($month)->sum('delta_water')); ?></td> <?php else: ?> <?php if($room->ewMonth($month->copy()->subMonth())->count() > 0): ?> <td><?php echo e($room->ewMonth($month->copy()->subMonth())->sum('end_electric')); ?></td> <?php else: ?> <td><p class="red">N/A</p></td> <?php endif; ?> <td><p class="red">N/A</p></td> <td><p class="red">N/A</p></td> <?php if($room->ewMonth($month->copy()->subMonth())->count() > 0): ?> <td><?php echo e($room->ewMonth($month->copy()->subMonth())->sum('end_water')); ?></td> <?php else: ?> <td><p class="red">N/A</p></td> <?php endif; ?> <td><p class="red">N/A</p></td> <td><p class="red">N/A</p></td> <?php endif; ?> </tr> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?> </table>