@extends('layouts.master')
@section('title')
    Dashboard
@endsection
@section('content')
    <!-- Start::app-content -->

        <div class="container-fluid">

            <!-- Start::page-header -->

            <div class="d-md-flex d-block align-items-center justify-content-between my-4 page-header-breadcrumb">
                <div>
                    <p class="fw-semibold fs-18 mb-0">@lang('Welcome back'), {{user()->name}}!</p>
                    <span class="fs-semibold text-muted">@lang('Track your sales activity, leads and deals here.')</span>
                </div>

            </div>
            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4">
                Akwizycja
            </h2>
            <div class="table-responsive">
                <table class="table table-list table-separate">
                    <thead>
                    <tr>
                        <th class="text-end"></th>
                        <th class="text-end">Jednostka</th>
                        <th class="text-end">{{implode('+', $agreementsPerYear->pluck('year')->toArray())}}</th>
                        @foreach($agreementsPerYear as $perYear)
                            <th class="text-end">{{$perYear->year}}</th>
                        @endforeach
                        <th class="text-end">{{date('Y')}}.01</th>
                        <th class="text-end">{{date('Y')}}.02</th>
                        <th class="text-end">{{date('Y')}}.03</th>
                        <th class="text-end">{{date('Y')}}.04</th>
                        <th class="text-end">{{date('Y')}}.05</th>
                        <th class="text-end">{{date('Y')}}.06</th>
                        <th class="text-end">{{date('Y')}}.07</th>
                        <th class="text-end">{{date('Y')}}.08</th>
                        <th class="text-end">{{date('Y')}}.09</th>
                        <th class="text-end">{{date('Y')}}.10</th>
                        <th class="text-end">{{date('Y')}}.11</th>
                        <th class="text-end">{{date('Y')}}.12</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td style="font-weight: bold; color: #F05521;">Liczba podpisanych umów</td>
                        <td class="text-end">[szt]</td>
                        <td class="text-end">{{$agreementsPerYear->sum('count')}}</td>
                        @foreach($agreementsPerYear as $perYear)
                            <td class="text-end">{{$perYear->count}}</td>
                        @endforeach
                        @for($i = 0; $i<12;$i++)
                            <td class="text-end">{{$agreementsPerMonth[$i]->count ?? 0}}</td>
                        @endfor
                    </tr>
                    <tr>
                        <td style="font-weight: bold; color: #F05521;">Wolumen pozyskany</td>
                        <td class="text-end">[MWh]</td>
                        <td class="text-end">{{format_number($agreementsPerYear->sum('volume'))}}</td>
                        @foreach($agreementsPerYear as $perYear)
                            <td class="text-end">{{format_number($perYear->volume)}}</td>
                        @endforeach
                        @for($i = 0; $i<12;$i++)
                            <td class="text-end">{{format_number($agreementsPerMonth[$i]->volume ?? 0)}}</td>
                        @endfor
                    </tr>

                    @foreach($sumVolumePerYear as $year => $volume)
                        <tr>
                            <td style="font-weight: bold; color: #F05521;">na {{$year}}</td>
                            <td class="text-end">[MWh]</td>
                            <td class="text-end">{{format_number($volume)}}</td>
                            @foreach($volumePerYear as $yearVolume)
                                <td class="text-end">{{format_number($yearVolume[$year] ?? 0)}}</td>
                            @endforeach
                            @for($i = 0; $i<12;$i++)
                                <td class="text-end">{{ format_number($volumePerMonths[$i][$year] ?? 0)}}</td>
                            @endfor
                        </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Umowy podpisane w: {{date('Y.m')}} ({{$agreementsInCurrentMonthSigned->count()}})
            </h2>
            <div class="table-responsive">
                <table class="table table-list table-separate">
                    <thead>
                        <tr>
                            <th>Klient</th>
                            <th class="text-end">Numer umowy</th>
                            <th class="text-end">Data podpisania</th>
                            <th class="text-end">Agent</th>
                            <th class="text-end">Typ</th>
                            <th class="text-end">Start umowy</th>
                            <th class="text-end">Koniec umowy</th>
                            <th class="text-end">Wolumen całkowity</th>
                            <th class="text-end">2025</th>
                            <th class="text-end">2026</th>
                            <th class="text-end">2027</th>
                            <th class="text-end">2028</th>
                            <th class="text-end">2029</th>
                            <th class="text-end">2030</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $totals = []; @endphp
                        @forelse($agreementsInCurrentMonthSigned as $agreementInCurrentMonthSigned)
                            @php
                                $calculateVolumePerYears = $agreementInCurrentMonthSigned->calculateVolumePerYear();

                                foreach ($calculateVolumePerYears as $year => $data) {
                                    if (empty($totals[$year])) {
                                        $totals[$year] = round($data, 2);
                                    } else {
                                        $totals[$year] += round($data, 2);
                                    }
                                }
                            @endphp
                            <tr>
                                <td>{{$agreementInCurrentMonthSigned->client_name}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->short_agreement_no}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->sign_date}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->agent}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->product}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->start_date}}</td>
                                <td class="text-end">{{$agreementInCurrentMonthSigned->end_date}}</td>
                                <td class="text-end" style="font-weight: bold; color: #F05521;">{{format_number($agreementInCurrentMonthSigned->volume)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2025] ?? 0)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2026] ?? 0)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2027] ?? 0)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2028] ?? 0)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2029] ?? 0)}}</td>
                                <td class="text-end">{{format_number($calculateVolumePerYears[2030] ?? 0)}}</td>
                            </tr>

                        @empty
                        @endforelse
                        <tr>
                            <td colspan="7"></td>
                            <td class="text-end" style="font-weight: bold;"><span class="me-2">Suma:</span> {{format_number($agreementsInCurrentMonthSigned->sum('volume'))}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2025] ?? 0)}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2026] ?? 0)}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2027] ?? 0)}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2028] ?? 0)}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2029] ?? 0)}}</td>
                            <td class="text-end" style="font-weight: bold;">{{format_number($totals[2030] ?? 0)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Umowy w podpisie ({{$agreementsInTheSignatureStatus->count()}})
            </h2>

            <div class="table-responsive">
                <table class="table table-list">
                    <thead>
                    <tr>
                        <th>Klient</th>
                        <th class="text-end">Numer umowy</th>
                        <th class="text-end">Agent</th>
                        <th class="text-end">Typ</th>
                        <th class="text-end">Start umowy</th>
                        <th class="text-end">Koniec umowy</th>
                        <th class="text-end">Wolumen całkowity</th>
                        <th class="text-end">2025</th>
                        <th class="text-end">2026</th>
                        <th class="text-end">2027</th>
                        <th class="text-end">2028</th>
                        <th class="text-end">2029</th>
                        <th class="text-end">2030</th>
                    </tr>
                    </thead>
                    <tbody>
                    @php $totals = []; @endphp
                    @forelse($agreementsInTheSignatureStatus as $agreementInTheSignatureStatus)
                        @php
                            $calculateVolumePerYears = $agreementInTheSignatureStatus->calculateVolumePerYear();
                            foreach ($calculateVolumePerYears as $year => $data) {
                                if (empty($totals[$year])) {
                                    $totals[$year] = round($data, 2);
                                } else {
                                    $totals[$year] += round($data, 2);
                                }
                            }
                        @endphp
                        <tr>
                            <td>{{$agreementInTheSignatureStatus->client_name}}</td>
                            <td class="text-end">{{$agreementInTheSignatureStatus->short_agreement_no}}</td>
                            <td class="text-end">{{$agreementInTheSignatureStatus->agent}}</td>
                            <td class="text-end">{{$agreementInTheSignatureStatus->product}}</td>
                            <td class="text-end">{{$agreementInTheSignatureStatus->start_date}}</td>
                            <td class="text-end">{{$agreementInTheSignatureStatus->end_date}}</td>
                            <td class="text-end" style="font-weight: bold; color: #F05521;">{{format_number($agreementInTheSignatureStatus->volume)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2025] ?? 0)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2026] ?? 0)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2027] ?? 0)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2028] ?? 0)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2029] ?? 0)}}</td>
                            <td class="text-end">{{format_number($calculateVolumePerYears[2030] ?? 0)}}</td>
                        </tr>
                    @empty
                    @endforelse
                    <tr>
                        <td colspan="6"></td>
                        <td class="text-end" style="font-weight: bold;"><span class="me-2">Suma:</span> {{format_number($agreementsInTheSignatureStatus->sum('volume'))}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2025] ?? 0)}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2026] ?? 0)}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2027] ?? 0)}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2028] ?? 0)}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2029] ?? 0)}}</td>
                        <td class="text-end" style="font-weight: bold;">{{format_number($totals[2030] ?? 0)}}</td>
                    </tr>
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Kontraktacje 2023
            </h2>

            <div class="table-responsive">
                <table class="table table-list">
                    <thead>
                    <tr>
                        <th style="background-color: #ea5a26;color: #FFF;">Status kontraktacji 2023 (Umowy zaakceptowane w 2023)</th>
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end"></th>
                        @foreach($contracts2023['years'] ?? []  as $year)
                            <th style="background-color: #ea5a26;color: #FFF;" class="text-end">{{$year}}</th>
                        @endforeach
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end">Razem</th>
                    </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td rowspan="2" style="vertical-align: top;">Umowy w przygotowaniu (na podstawie roku rozpoczęcia umowy)</td>
                            <td>Liczba</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{$contracts2023['W przygotowaniu'][$year]['count'] ?? 0}}</td>
                            @endforeach
                            <td class="text-end">{{$contracts2023['W przygotowaniu']['totals']['qty'] ?? 0}}</td>

                        </tr>
                        <tr>
                            <td>Wolumen [MWh]</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{format_number($contracts2023['W przygotowaniu'][$year]['volume'] ?? 0)}}</td>
                            @endforeach
                            <td class="text-end">{{format_number($contracts2023['W przygotowaniu']['totals']['volume'] ?? 0)}}</td>
                        </tr>

                        <tr>
                            <td rowspan="2" style="vertical-align: top;">Umowy w podpisie (na podstawie roku rozpoczęcia umowy)</td>
                            <td>Liczba</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{$contracts2023['W podpisie'][$year]['count'] ?? 0}}</td>
                            @endforeach
                            <td class="text-end">{{$contracts2023['W podpisie']['totals']['qty'] ?? 0}}</td>

                        </tr>
                        <tr>
                            <td>Wolumen [MWh]</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{format_number($contracts2023['W podpisie'][$year]['volume'] ?? 0)}}</td>
                            @endforeach
                            <td class="text-end">{{format_number($contracts2023['W podpisie']['totals']['volume'] ?? 0)}}</td>
                        </tr>

                        <tr>
                            <td rowspan="2" style="vertical-align: top;">Umowy podpisane (na podstawie roku rozpoczęcia umowy)</td>
                            <td>Liczba</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{$contracts2023['Podpisana'][$year]['count'] ?? 0}}</td>
                            @endforeach
                            <td class="text-end">{{$contracts2023['Podpisana']['totals']['qty'] ?? 0}}</td>

                        </tr>
                        <tr>
                            <td>Wolumen [MWh]</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td class="text-end">{{format_number($contracts2023['Podpisana'][$year]['volume'] ?? 0)}}</td>
                            @endforeach
                            <td class="text-end">{{format_number($contracts2023['Podpisana']['totals']['volume'] ?? 0)}}</td>
                        </tr>

                        <tr>
                            <td rowspan="2"  style="background-color: #c4c2c270;">
                                <b>Razem</b>
                            </td>
                            <td style="background-color: #c4c2c270;font-weight: bold;">Liczba</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                    {{ ($contracts2023['W przygotowaniu'][$year]['count'] ?? 0) + ($contracts2023['W podpisie'][$year]['count'] ?? 0) + ($contracts2023['Podpisana'][$year]['count'] ?? 0)}}
                                </td>
                            @endforeach
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ ($contracts2023['W przygotowaniu']['totals']['qty'] ?? 0) + ($contracts2023['W podpisie']['totals']['qty'] ?? 0) + ($contracts2023['Podpisana']['totals']['qty'] ?? 0)}}
                            </td>
                        </tr>
                        <tr>
                            <td style="background-color: #c4c2c270;font-weight: bold;">Wolumen [MWh]</td>
                            @foreach($contracts2023['years'] ?? []  as $year)
                                <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                    {{ format_number( ($contracts2023['W przygotowaniu'][$year]['volume'] ?? 0) + ($contracts2023['W podpisie'][$year]['volume'] ?? 0) + ($contracts2023['Podpisana'][$year]['volume'] ?? 0) )}}
                                </td>
                            @endforeach
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ format_number( ($contracts2023['W przygotowaniu']['totals']['volume'] ?? 0) + ($contracts2023['W podpisie']['totals']['volume'] ?? 0) + ($contracts2023['Podpisana']['totals']['volume'] ?? 0) )}}
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Kontraktacje 2024
            </h2>

            <div class="table-responsive">
                <table class="table table-list">
                    <thead>
                    <tr>
                        <th style="background-color: #ea5a26;color: #FFF;">Status kontraktacji 2024 (Umowy zaakceptowane w 2024)</th>
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end"></th>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <th style="background-color: #ea5a26;color: #FFF;" class="text-end">{{$year}}</th>
                        @endforeach
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end">Razem</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy w przygotowaniu (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2024['W przygotowaniu'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2024['W przygotowaniu']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2024['W przygotowaniu'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2024['W przygotowaniu']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy w podpisie (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2024['W podpisie'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2024['W podpisie']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2024['W podpisie'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2024['W podpisie']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy podpisane (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2024['Podpisana'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2024['Podpisana']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2024['Podpisana'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2024['Podpisana']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2"  style="background-color: #c4c2c270;">
                            <b>Razem</b>
                        </td>
                        <td style="background-color: #c4c2c270;font-weight: bold;">Liczba</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ ($contracts2024['W przygotowaniu'][$year]['count'] ?? 0) + ($contracts2024['W podpisie'][$year]['count'] ?? 0) + ($contracts2024['Podpisana'][$year]['count'] ?? 0)}}
                            </td>
                        @endforeach
                        <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                            {{ ($contracts2024['W przygotowaniu']['totals']['qty'] ?? 0) + ($contracts2024['W podpisie']['totals']['qty'] ?? 0) + ($contracts2024['Podpisana']['totals']['qty'] ?? 0)}}
                        </td>
                    </tr>
                    <tr>
                        <td style="background-color: #c4c2c270;font-weight: bold;">Wolumen [MWh]</td>
                        @foreach($contracts2024['years'] ?? []  as $year)
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ format_number( ($contracts2024['W przygotowaniu'][$year]['volume'] ?? 0) + ($contracts2024['W podpisie'][$year]['volume'] ?? 0) + ($contracts2024['Podpisana'][$year]['volume'] ?? 0) )}}
                            </td>
                        @endforeach
                        <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                            {{ format_number( ($contracts2024['W przygotowaniu']['totals']['volume'] ?? 0) + ($contracts2024['W podpisie']['totals']['volume'] ?? 0) + ($contracts2024['Podpisana']['totals']['volume'] ?? 0) )}}
                        </td>
                    </tr>
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Kontraktacje 2025
            </h2>

            <div class="table-responsive">
                <table class="table table-list">
                    <thead>
                    <tr>
                        <th style="background-color: #ea5a26;color: #FFF;">Status kontraktacji 2025 (Umowy zaakceptowane w 2025)</th>
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end"></th>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <th style="background-color: #ea5a26;color: #FFF;" class="text-end">{{$year}}</th>
                        @endforeach
                        <th style="background-color: #ea5a26;color: #FFF;" class="text-end">Razem</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy w przygotowaniu (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2025['W przygotowaniu'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2025['W przygotowaniu']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2025['W przygotowaniu'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2025['W przygotowaniu']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy w podpisie (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2025['W podpisie'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2025['W podpisie']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2025['W podpisie'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2025['W podpisie']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2" style="vertical-align: top;">Umowy podpisane (na podstawie roku rozpoczęcia umowy)</td>
                        <td>Liczba</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{$contracts2025['Podpisana'][$year]['count'] ?? 0}}</td>
                        @endforeach
                        <td class="text-end">{{$contracts2025['Podpisana']['totals']['qty'] ?? 0}}</td>

                    </tr>
                    <tr>
                        <td>Wolumen [MWh]</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td class="text-end">{{format_number($contracts2025['Podpisana'][$year]['volume'] ?? 0)}}</td>
                        @endforeach
                        <td class="text-end">{{format_number($contracts2025['Podpisana']['totals']['volume'] ?? 0)}}</td>
                    </tr>

                    <tr>
                        <td rowspan="2"  style="background-color: #c4c2c270;">
                            <b>Razem</b>
                        </td>
                        <td style="background-color: #c4c2c270;font-weight: bold;">Liczba</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ ($contracts2025['W przygotowaniu'][$year]['count'] ?? 0) + ($contracts2025['W podpisie'][$year]['count'] ?? 0) + ($contracts2025['Podpisana'][$year]['count'] ?? 0)}}
                            </td>
                        @endforeach
                        <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                            {{ ($contracts2025['W przygotowaniu']['totals']['qty'] ?? 0) + ($contracts2025['W podpisie']['totals']['qty'] ?? 0) + ($contracts2025['Podpisana']['totals']['qty'] ?? 0)}}
                        </td>
                    </tr>
                    <tr>
                        <td style="background-color: #c4c2c270;font-weight: bold;">Wolumen [MWh]</td>
                        @foreach($contracts2025['years'] ?? []  as $year)
                            <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                                {{ format_number( ($contracts2025['W przygotowaniu'][$year]['volume'] ?? 0) + ($contracts2025['W podpisie'][$year]['volume'] ?? 0) + ($contracts2025['Podpisana'][$year]['volume'] ?? 0) )}}
                            </td>
                        @endforeach
                        <td style="background-color: #c4c2c270;font-weight: bold;" class="text-end">
                            {{ format_number( ($contracts2025['W przygotowaniu']['totals']['volume'] ?? 0) + ($contracts2025['W podpisie']['totals']['volume'] ?? 0) + ($contracts2025['Podpisana']['totals']['volume'] ?? 0) )}}
                        </td>
                    </tr>
                    </tbody>
                </table>
            </div>

            <h2 class="page-title fw-semibold fs-22 mb-0 d-flex align-items-center mb-4 mt-4">
                Operacje
            </h2>

            <div class="table-responsive">
                <table class="table table-list table-separate">
                    <thead>
                        <tr>
                            <th>Operacje</th>
                            @foreach($pzsByYear as $year => $data)
                                <th>Liczba PPE {{$year}}</th>
                                <th>Liczba Klientów {{$year}}</th>
                            @endforeach

                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td>Przyjęte</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->where('status', 'Przyjęty')->count()}}</td>
                                <td>{{$pzsByYear[$year]->where('status', 'Przyjęty')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td>Jeszcze nie mozna złożyć (ponad 90 dni)</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->where('agreement_date', '>=', \Carbon\Carbon::now()->subDays(90)->toDateString())->where('status', 'Do złożenia')->count()}}</td>
                                <td>{{$pzsByYear[$year]->where('agreement_date', '>=', \Carbon\Carbon::now()->subDays(90)->toDateString())->where('status', 'Do złożenia')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td>Można złożyć</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->where('agreement_date', '<=', \Carbon\Carbon::now()->subDays(90)->toDateString())->where('status', 'Do złożenia')->count()}}</td>
                                <td>{{$pzsByYear[$year]->where('agreement_date', '<=', \Carbon\Carbon::now()->subDays(90)->toDateString())->where('status', 'Do złożenia')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td>Złożone</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->where('status', 'Złożony')->count()}}</td>
                                <td>{{$pzsByYear[$year]->where('status', 'Złożony')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td>Oczekujące na złożenie wypowiedzenia</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->whereNull('date_termination')->count()}}</td>
                                <td>{{$pzsByYear[$year]->whereNull('date_termination')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td>Wypowiedzenie złożone</td>
                            @foreach($pzsByYear as $year => $data)
                                <td>{{$pzsByYear[$year]->whereNotNull('date_termination')->count()}}</td>
                                <td>{{$pzsByYear[$year]->whereNotNull('date_termination')->groupBy('client_name')->count()}}</td>
                            @endforeach
                        </tr>
                    </tbody>
                </table>
            </div>

        </div>

    <!-- End::app-content -->
@endsection

@section('styles')
    <style>
        .title-and-buttons {display: none !important;}
        .page-header-breadcrumb {margin-top:0px !important;}
    </style>
@endsection