@extends('layouts.app')

@section('content')
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">{{ __('Dashboard') }}</div>
                    <div class="card-body">
                        <div class="row">
                            <h4><b>{{ $data['project_name'] }}</b></h3>
                        </div>
                        <div class="row">
                            <div class="col-md-3">
                                <h4><b>Spend: </b></h3>
                            </div>
                            <div class="col-md-3">
                                <h4><b>R&nbsp;{{ number_format($data['debit'], 2) }}</b></h4>
                            </div>
                            <div class="col-md-6">
                                {{ $to_date }}
                            </div>
                        </div>

                        <table class="table">
                            <thead>
                                <tr>
                                    <td></td>
                                    <td><b>R&nbsp;{{ number_format($data['budget'], 2) }}</b></td>
                                    <td><b>R&nbsp;{{ number_format($data['debit'], 2) }}</b></td>
                                    <td><b>R&nbsp;{{ number_format($data['variance'], 2) }}</b></td>
                                    @if ($rate != 1)
                                        <td><b>$&nbsp;{{ number_format($data['dollar_budget'], 2) }}</b></td>
                                        <td><b>$&nbsp;{{ number_format($data['dollar'], 2) }}</b></td>
                                        <td><b>$&nbsp;{{ number_format($data['dollar_variance'], 2) }}</b></td>
                                    @endif
                                </tr>
                                <tr>
                                    <th>Description</th>
                                    <th>Budget</th>
                                    <th>Spend</th>
                                    <th>Variance</th>
                                    @if ($rate != 1)
                                        <th>Budget($)</th>
                                        <th>Spend($)</th>
                                        <th>Variance($)</th>
                                    @endif
                                </tr>
                            </thead>
                            @if (!empty($data['sub_cats']))
                                @foreach ($data['sub_cats'] as $sub)
                                    <tr>
                                        <th colspan="{{ $rate != 1 ? '4' : '7' }}">{{ $sub['name'] }}</th>
                                    </tr>
                                    @if (!empty($sub['line_cats']))
                                        @foreach ($sub['line_cats'] as $line)
                                            <tr>
                                                <td>
                                                    {{ $line['name'] }}
                                                    @if (auth()->user()->role == 'Admin')
                                                        <a
                                                            href="{{ url("transactions/{$line['categoryId']}?project={$data['categoryId']}&sub={$sub['categoryId']}&to={$to_date}") }}"><i
                                                                class="fa-solid fa-list"></i></a>
                                                    @endif
                                                </td>
                                                <td>R&nbsp;{{ number_format($line['budget'], 2) }}</td>
                                                <td>R&nbsp;{{ number_format($line['debit'], 2) }}</td>
                                                <td>R&nbsp;{{ number_format($line['variance'], 2) }}</td>
                                                @if ($rate != 1)
                                                    <td>$&nbsp;{{ number_format($line['dollar_budget'], 2) }}</td>
                                                    <td>$&nbsp;{{ number_format($line['dollar'], 2) }}</td>
                                                    <td>$&nbsp;{{ number_format($line['dollar_variance'], 2) }}</td>
                                                @endif
                                            </tr>
                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="{{ $rate != 1 ? '4' : '7' }}">No Lines</td>
                                        </tr>
                                    @endif
                                    <tr>
                                        <td></td>
                                        <td><b>R&nbsp;{{ number_format($sub['budget'], 2) }}</b></td>
                                        <td><b>R&nbsp;{{ number_format($sub['debit'], 2) }}</b></td>
                                        <td><b>R&nbsp;{{ number_format($sub['variance'], 2) }}</b></td>
                                        @if ($rate != 1)
                                            <td><b>$&nbsp;{{ number_format($sub['dollar_budget'], 2) }}</b></td>
                                            <td><b>$&nbsp;{{ number_format($sub['dollar'], 2) }}</b></td>
                                            <td><b>$&nbsp;{{ number_format($sub['dollar_variance'], 2) }}</b></td>
                                        @endif
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td colspan="{{ $rate != 1 ? '4' : '7' }}">No Sub Cats</td>
                                </tr>
                            @endif

                            <tr class="pt-2">
                                <th><span class="float-end">
                                        <h5>Totals&nbsp;</h3>
                                    </span>
                                </th>
                                <th>
                                    <h5><b>R&nbsp;{{ number_format($data['budget'], 2) }}</b></h5>
                                </th>
                                <th>
                                    <h5><b>R&nbsp;{{ number_format($data['debit'], 2) }}</b></h5>
                                </th>
                                <th>
                                    <h5><b>R&nbsp;{{ number_format($data['variance'], 2) }}</b></h5>
                                </th>
                                @if ($rate != 1)
                                    <th>
                                        <h5><b>$&nbsp;{{ number_format($data['dollar_budget'], 2) }}</b></h5>
                                    </th>
                                    <th>
                                        <h5><b>$&nbsp;{{ number_format($data['dollar'], 2) }}</b></h5>
                                    </th>
                                    <th>
                                        <h5><b>$&nbsp;{{ number_format($data['dollar_variance'], 2) }}</b></h5>
                                    </th>
                                @endif
                            </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection