<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>


        @foreach($fees as $fee)
            <td @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"
                @endif style=" border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">
                <span><span
                            style="color:#000000">{{ $fee->name }}</span></span>
            </td>
        @endforeach
    </tr>
    <tr>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        @foreach($fees as $fee)
            @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>

            @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>
            @else
                <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;  height: 28px">
                    Số
                    lượng
                </td>
            @endif

        @endforeach
    </tr>
    @foreach($contracts as $contract)

        <tr>
            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal; height: 28px">{{ $loop->index + 1 }}     </td>
            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">{{ $contract->hostel->name }}</td>
            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">{{ $contract->room->name }}    </td>
            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">{{ $contract->name }}</td>
            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">{{ $monthCarbon->copy()->format('m/Y') }}</td>
            @foreach($fees as $fee)
                @php $ew = App\Components\Functions::getEwLatestRoom4($contract, $monthCarbon->copy(), $fee); @endphp
                @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();



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

                              $endElectric = $info['end'];
                              $endWater = $info['end'];
                    @endphp
                @endif
                @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;">{{ $q }}
                    </td>
                    <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">{{ $q }}
                    </td>

                @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;">
                        @if(in_array($fee->type, [
                      App\Models\HostelFee::ELECTRIC_BY_CLOCK,
                    App\Models\HostelFee::ELECTRIC ]))

                            @if($moneyDetail)
                                {{ $startElectric }}
                            @else
                                @if(!empty($ew['start_e']))
                                    {{ $ew['start_e'] }}
                                @else
                                    {{ $q }}
                                @endif
                            @endif

                        @else
                            @if($moneyDetail)
                                {{ $startWater }}
                            @else
                                @if(!empty($ew['start_w']))
                                    {{ $ew['start_w'] }}
                                @else
                                    {{ $q }}
                                @endif
                            @endif
                        @endif
                    </td>
                    @if($moneyDetail)
                        @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;">
                                {{ $endElectric }}
                            </td>
                        @else
                            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">
                                {{ $endWater }}
                            </td>
                        @endif
                    @else
                        @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;">
                                {{ $ew['end_e'] }}
                            </td>
                        @else
                            <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">
                                {{ $ew['end_w'] }}
                            </td>
                        @endif
                    @endif
                @else
                    <td style="border:1px solid #000000;  text-align:center; vertical-align:middle; white-space:normal;">
                        {{ $q }}

                    </td>
                @endif

            @endforeach
        </tr>
    @endforeach
    </tbody>
</table>
