@use('App\Services\Date')
@isset($data['revenue'])
    <div id="configuration">
        <div class="row">
            <div class="col-xs-12">
                <div class="card">
                    <div class="card-body collapse in">
                        <div>
                            @endisset
                            @isset($data['revenue'])
                                @php($isComparison = isset($data['comparedDates']) && count($data['comparedDates']))
                                <div class="text-center mb-3">
                                    <h2>
                                        <strong>
                                            @lang('reports::reports.Income Statement')
                                        </strong>
                                    </h2>
                                    <h4><b>{{ $data['companyName'] }}</b></h4>
                                    <h4>
                                        @if($isComparison)
                                            {{-- comparison mode does not display a single date range --}}
                                        @else
                                            @lang('from')  <span dir="ltr">{{$data['dates']['from']}}</span>  @lang('to') <span dir="ltr">{{$data['dates']['to']}}</span>
                                        @endif
                                    </h4>
                                </div>
                                <div>
                                    @if($isComparison)
                                        @php($columnCount = count($data['comparedDates']) + 1)
                                        @php($totalSalesCostByDate = [])
                                        @php($totalEarningByDate = [])
                                        @php($totalExpenseByDate = [])
                                        <table class="table table-borderless">
                                            <thead>
                                            <tr>
                                                <th></th>
                                                @foreach($data['comparedDates'] as $date)
                                                    <th>
                                                        <b class="font-size-large">
                                                            <h4>{{ Date::format($date) }}</h4>
                                                        </b>
                                                    </th>
                                                @endforeach
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['revenue']['categoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>

                                            {{-- Sales Section --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['sales']['subCategoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>
                                            @foreach($data['sales']['accounts'] ?? [] as $accountLabel => $periods)
                                                <tr>
                                                    <td>{{ $accountLabel }}</td>
                                                    @foreach($periods as $period)
                                                        @php($balance = $period['balance'] ?? 0)
                                                        <td>
                                                            @if($balance < 0)
                                                                ({{ number_format(abs($balance), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($balance), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td><b>{{ $data['sales']['subCategoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($value = $data['total']['sales'][$date] ?? 0)
                                                    <td><b>@if($value < 0) ({{ number_format(abs($value), 2, '.', ',') }}) @else {{ number_format(abs($value), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Purchases Section --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['purchases']['subCategoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>
                                            @foreach($data['purchases']['accounts'] ?? [] as $accountLabel => $periods)
                                                <tr>
                                                    <td>{{ $accountLabel }}</td>
                                                    @foreach($periods as $period)
                                                        @php($balance = $period['balance'] ?? 0)
                                                        <td>
                                                            @if($balance < 0)
                                                                ({{ number_format(abs($balance), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($balance), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td><b>{{ $data['purchases']['subCategoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($value = $data['total']['purchases'][$date] ?? 0)
                                                    <td><b>@if($value <= 0) ({{ number_format(abs($value), 2, '.', ',') }}) @else {{ number_format(abs($value), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Operating Expenses Section --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['operatingExpenses']['subCategoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>
                                            @foreach($data['operatingExpenses']['accounts'] ?? [] as $accountLabel => $periods)
                                                <tr>
                                                    <td>{{ $accountLabel }}</td>
                                                    @foreach($periods as $period)
                                                        @php($balance = $period['balance'] ?? 0)
                                                        <td>
                                                            @if($balance < 0)
                                                                ({{ number_format(abs($balance), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($balance), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['operatingExpenses']['subCategoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($value = $data['total']['operatingExpenses'][$date] ?? 0)
                                                    <td><b>@if($value <= 0) ({{ number_format(abs($value), 2, '.', ',') }}) @else {{ number_format(abs($value), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Totals --}}
                                            <tr>
                                                <td><b>@lang('reports::reports.total_sales_cost')</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($total = ($data['total']['purchases'][$date] ?? 0) + ($data['total']['operatingExpenses'][$date] ?? 0))
                                                    @php($totalSalesCostByDate[$date] = $total)
                                                    <td><b>@if($total < 0) ({{ number_format(abs($total), 2, '.', ',') }}) @else {{ number_format(abs($total), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <td><b>@lang('reports::reports.total_earning')</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($totalEarning = ($data['total']['sales'][$date] ?? 0) - ($totalSalesCostByDate[$date] ?? 0))
                                                    @php($totalEarningByDate[$date] = $totalEarning)
                                                    <td><b>@if($totalEarning <= 0) ({{ number_format(abs($totalEarning), 2, '.', ',') }}) @else {{ number_format(abs($totalEarning), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Expenses Category --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['expenses']['categoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>

                                            {{-- General Expenses --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['generalExpenses']['subCategoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>
                                            @foreach($data['generalExpenses']['accounts'] ?? [] as $accountLabel => $periods)
                                                <tr>
                                                    <td>{{ $accountLabel }}</td>
                                                    @foreach($periods as $period)
                                                        @php($balance = $period['balance'] ?? 0)
                                                        <td>
                                                            @if($balance < 0)
                                                                ({{ number_format(abs($balance), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($balance), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['generalExpenses']['subCategoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($value = $data['total']['generalExpenses'][$date] ?? 0)
                                                    <td><b>@if($value <= 0) ({{ number_format(abs($value), 2, '.', ',') }}) @else {{ number_format(abs($value), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Marketing Expenses --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['marketingExpenses']['subCategoryName'] }}</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    <td></td>
                                                @endforeach
                                            </tr>
                                            @foreach($data['marketingExpenses']['accounts'] ?? [] as $accountLabel => $periods)
                                                <tr>
                                                    <td>{{ $accountLabel }}</td>
                                                    @foreach($periods as $period)
                                                        @php($balance = $period['balance'] ?? 0)
                                                        <td>
                                                            @if($balance <= 0)
                                                                ({{ number_format(abs($balance), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($balance), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['marketingExpenses']['subCategoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($value = $data['total']['marketingExpenses'][$date] ?? 0)
                                                    <td><b>@if($value <= 0) ({{ number_format(abs($value), 2, '.', ',') }}) @else {{ number_format(abs($value), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>

                                            {{-- Total Expenses --}}
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['expenses']['categoryName'] }}</b></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($totalExpense = ($data['total']['generalExpenses'][$date] ?? 0) + ($data['total']['marketingExpenses'][$date] ?? 0))
                                                    @php($totalExpenseByDate[$date] = $totalExpense)
                                                    <td><b>@if($totalExpense < 0) ({{ number_format(abs($totalExpense), 2, '.', ',') }}) @else {{ number_format(abs($totalExpense), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <td colspan="{{ $columnCount }}"><hr/></td>
                                            </tr>
                                            <tr>
                                                <td><strong class="font-size-large">@lang('reports::reports.net_earnings')</strong></td>
                                                @foreach($data['comparedDates'] as $date)
                                                    @php($net = ($totalEarningByDate[$date] ?? 0) - ($totalExpenseByDate[$date] ?? 0))
                                                    <td><b>@if($net < 0) ({{ number_format(abs($net), 2, '.', ',') }}) @else {{ number_format(abs($net), 2, '.', ',') }} @endif</b></td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <td colspan="{{ $columnCount }}">
                                                    @lang('reports::reports.accrual_basis')
                                                    @if(request('without_opening_balance'))
                                                        @lang('reports::reports.without_opening_balances')
                                                    @endif
                                                    @if(app()->getLocale() == 'ar')
                                                        {{ Date::now('datetime') }}
                                                    @else
                                                        {{ Date::now('datetime') }}
                                                    @endif
                                                </td>
                                            </tr>
                                            </tbody>
                                        </table>
                                    @else
                                        <table class="table table-borderless">
                                            <thead>
                                            <tr>
                                                <th></th>
                                                <th><b class="font-size-large">@lang('reports::reports.total')</b></th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['revenue']['categoryName'] }}</strong></td>
                                                <td></td>
                                            </tr>

                                            {{-- Sales Section --}}
                                            @foreach($data['sales']['accounts'] as $account)
                                                @if(! (request('hide_zero_accounts') && $account['balance'] == 0 && ! $account['isHasTransactions']))
                                                    <tr>
                                                        <td>{{ $account['code'] }} - {{ $account['name'] }}</td>
                                                        <td>
                                                            @if($account['balance'] < 0)
                                                                ({{ number_format(abs($account['balance']), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($account['balance']), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr style="border-bottom: 3pt solid #00000036;border-top: 3pt solid #00000036;">
                                                <td><b>{{ __('reports::reports.total_other_revenue') }}</b></td>
                                                <td><b>@if($data['sales']['total'] < 0) ({{ number_format(abs($data['sales']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['sales']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Purchases Section --}}
                                            <tr>
                                                <td><strong class="font-size-large">@lang('reports::reports.Purchases')</strong></td>
                                                <td></td>
                                            </tr>
                                            @foreach($data['purchases']['accounts'] as $account)
                                                @if(! (request('hide_zero_accounts') && $account['balance'] == 0 && ! $account['isHasTransactions']))
                                                    <tr>
                                                        <td>{{ $account['code'] }} - {{ $account['name'] }}</td>
                                                        <td>
                                                            @if($account['balance'] < 0)
                                                                ({{ number_format(abs($account['balance']), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($account['balance']), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr style="border-bottom: 1pt solid #00000036;border-top: 1pt solid #00000036;">
                                                <td><b>@lang('reports::reports.total') @lang('reports::reports.Purchases')</b></td>
                                                <td><b>@if($data['purchases']['total'] < 0) ({{ number_format(abs($data['purchases']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['purchases']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Operating Expenses Section --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['operatingExpenses']['subcategoryName'] }}</strong></td>
                                                <td></td>
                                            </tr>
                                            @foreach($data['operatingExpenses']['accounts'] as $account)
                                                @if(! (request('hide_zero_accounts') && $account['balance'] == 0 && ! $account['isHasTransactions']))
                                                    <tr>
                                                        <td>{{ $account['code'] }} - {{ $account['name'] }}</td>
                                                        <td>
                                                            @if($account['balance'] < 0)
                                                                ({{ number_format(abs($account['balance']), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($account['balance']), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr style="border-bottom: 1pt solid #00000036;border-top: 1pt solid #00000036;">
                                                <td><b>@lang('reports::reports.total') {{ $data['operatingExpenses']['subcategoryName'] }}</b></td>
                                                <td><b>@if($data['operatingExpenses']['total'] < 0) ({{ number_format(abs($data['operatingExpenses']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['operatingExpenses']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Totals --}}
                                            <tr style="border-bottom: 3pt solid #00000036;border-top: 3pt solid #00000036;">
                                                <td><b>@lang('reports::reports.total_sales_cost')</b></td>
                                                <td><b>@if($data['totalSalesCost'] < 0) ({{ number_format(abs($data['totalSalesCost']), 2, '.', ',') }}) @else {{ number_format(abs($data['totalSalesCost']), 2, '.', ',') }} @endif</b></td>
                                            </tr>
                                            <tr style="border-bottom: 1pt solid #00000036;border-top: 1pt solid #00000036;">
                                                <td><b>@lang('reports::reports.total_earning')</b></td>
                                                <td><b>@if($data['TotalEarning'] < 0) ({{ number_format(abs($data['TotalEarning']), 2, '.', ',') }}) @else {{ number_format(abs($data['TotalEarning']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Expenses Category --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['expenses']['categoryName'] }}</strong></td>
                                                <td></td>
                                            </tr>

                                            {{-- General Expenses --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['generalExpenses']['subcategoryName'] }}</strong></td>
                                                <td></td>
                                            </tr>
                                            @foreach($data['generalExpenses']['accounts'] as $account)
                                                @if(! (request('hide_zero_accounts') && $account['balance'] == 0 && ! $account['isHasTransactions']))
                                                    <tr>
                                                        <td>{{ $account['code'] }} - {{ $account['name'] }}</td>
                                                        <td>
                                                            @if($account['balance'] < 0)
                                                                ({{ number_format(abs($account['balance']), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($account['balance']), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['generalExpenses']['subcategoryName'] }}</b></td>
                                                <td><b>@if($data['generalExpenses']['total'] < 0) ({{ number_format(abs($data['generalExpenses']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['generalExpenses']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Marketing Expenses --}}
                                            <tr>
                                                <td><strong class="font-size-large">{{ $data['marketingExpenses']['subcategoryName'] }}</strong></td>
                                                <td></td>
                                            </tr>
                                            @foreach($data['marketingExpenses']['accounts'] as $account)
                                                @if(! (request('hide_zero_accounts') && $account['balance'] == 0 && ! $account['isHasTransactions']))
                                                    <tr>
                                                        <td>{{ $account['code'] }} - {{ $account['name'] }}</td>
                                                        <td>
                                                            @if($account['balance'] < 0)
                                                                ({{ number_format(abs($account['balance']), 2, '.', '') }})
                                                            @else
                                                                {{ number_format(abs($account['balance']), 2, '.', '') }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr>
                                                <td><b>@lang('reports::reports.total') {{ $data['marketingExpenses']['subcategoryName'] }}</b></td>
                                                <td><b>@if($data['marketingExpenses']['total'] < 0) ({{ number_format(abs($data['marketingExpenses']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['marketingExpenses']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>

                                            {{-- Total Expenses & Net --}}
                                            <tr style="border-bottom: 3pt solid #00000036;border-top: 3pt solid #00000036;">
                                                <td><b>@lang('reports::reports.total') {{ $data['expenses']['categoryName'] }}</b></td>
                                                <td><b>@if($data['expenses']['total'] < 0) ({{ number_format(abs($data['expenses']['total']), 2, '.', ',') }}) @else {{ number_format(abs($data['expenses']['total']), 2, '.', ',') }} @endif</b></td>
                                            </tr>
                                            <tr>
                                                <td colspan="2"><hr/></td>
                                            </tr>
                                            <tr>
                                                <td><strong class="font-size-large">@lang('reports::reports.net_earnings')</strong></td>
                                                <td>
                                                    <b>@if($data['net'] < 0) ({{ number_format(abs($data['net']), 2, '.', ',') }}) @else {{ number_format(abs($data['net']), 2, '.', ',') }} @endif</b>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="2">
                                                    @lang('reports::reports.accrual_basis')
                                                    @if(request('without_opening_balance'))
                                                        @lang('reports::reports.without_opening_balances')
                                                    @endif
                                                    {{ Date::now('datetime') }}
                                                </td>
                                            </tr>
                                            </tbody>
                                        </table>
                                    @endif
                                </div>

                            @endisset
                            @isset($data['revenue'])

                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endisset