@extends('admin.layouts.master')
@section('content')
    @php
        $extraFees = [];
        $courtFees = [];
        $feeParts = [];
        $paidFeeParts = [];
        $totalContracts = [];
        $total = [];
        $downPayments = [];
        $totalOfficeMoney = [];
        $remainingAmounts = [];
        $totalExtraFees = [];
        $unpaidFeePart = [];
        $paidFeePart = [];
    @endphp
    @push('styles')
        <style>
            @media print {
                table {
                    color: black !important;
                }
                table.table-bordered.dataTable tbody th, table.table-bordered.dataTable tbody td {
                    border-bottom-width: medium !important;
                    border-right-width: medium !important;
                    border-left-width: medium !important;
                    border-top-width: medium !important;
                    border-color: black !important;
                    font-size: 20px;
                    color: black;
                }

                table.table-bordered.dataTable thead th, table.table-bordered.dataTable tbody td {
                    border-bottom-width: medium !important;
                    border-right-width: medium !important;
                    border-left-width: medium !important;
                    border-top-width: medium !important;
                    border-color: black !important;
                    font-size: 20px;
                    color: black;
                }
            }
        </style>
    @endpush
    <section id="basic-datatable">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-content collapse show">
                        <div class="card-body">
                            <div class="users-list-filter">
                                <form action="{{route('admin.financial-reports.index')}}" method="get">
                                    <div class="row justify-content-center">
                                        <div class="col-12 col-sm-6 col-lg-6">
                                            <label for="users-list-role">من</label>
                                            <fieldset class="form-group">
                                                <input type="date" class="form-control" name="from"
                                                       value="{{Request::get('from')}}">
                                            </fieldset>
                                        </div>
                                        <div class="col-12 col-sm-6 col-lg-6">
                                            <label for="users-list-status">إلى</label>
                                            <fieldset class="form-group">
                                                <input type="date" class="form-control" name="to"
                                                       value="{{Request::get('to')}}">
                                            </fieldset>
                                        </div>
                                    </div>
                                    <div class="text-center">
                                        <button class="btn btn-primary w-25 btn-lg" type="submit">بحث</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="card">
                    <div class="card-content">
                        <div class="card-body card-dashboard">
                            <div class="table-responsive">
                                <table
                                    class="display table table-hover-animation table-bordered border-2 border-black text-center"
                                    style="color: black" id="report">
                                    <thead class="thead-dark">
                                    <tr class="bg-secondary">
                                        <th class="text-center border border-2 border-black">#</th>
                                        <th class="text-center border border-2 border-black">اسم الموكل</th>
                                        <th class="text-center border border-2 border-black">الكود</th>
                                        <th class="text-center border border-2 border-black">قيمة العقد</th>
                                        <th class="text-center border border-2 border-black">المصاريف الإضافية</th>
                                        <th class="text-center border border-2 border-black">إجمالي قيمة العقد</th>
                                        <th class="text-center border border-2 border-black">المقدم</th>
                                        <th class="text-center border border-2 border-black">نسبة المكتب</th>
                                        <th class="text-center border border-2 border-black">أتعاب المكتب</th>
                                        <th class="text-center border border-2 border-black">الدفعات المستحقة بالفترة
                                            المحددة
                                        </th>
                                        <th class="text-center border border-2 border-black">المسدد بالفترة الحالية</th>
                                        <th class="text-center border border-2 border-black">المتبقي</th>
                                    </tr>
                                    </thead>
                                    <tbody class="border border-2 border-black">
                                    @foreach($fees as $fee)
                                        <tr class="border border-2 border-black">
                                            <td class="border border-2 border-black">{{$fee->id}}</td>
                                            <td class="border border-2 border-black">{{$fee->client->name}}</td>
                                            <td class="border border-2 border-black">
                                                @foreach($fee->fee_cases as $fee_case)
                                                    {{$fee_case->case_id}} {{$loop->count > 1 ? ',' : null}}
                                                @endforeach
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$totalContracts[$loop->index] = $fee->total_fee}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                @foreach($fee->fee_parts->where('type',\App\Fee::EXTRA_FEES) as $extraFee)
                                                    @php
                                                        $extraFees[$loop->index] = $extraFee->money;
                                                    @endphp
                                                @endforeach
                                                @foreach(($fee->fee_parts->where('type',\App\Fee::COURT_FEES)) as $courtFee)
                                                    @php
                                                        $courtFees[$loop->index] = $courtFee->money;
                                                    @endphp
                                                @endforeach
                                                {{$totalExtraFees[$loop->index] = array_sum($extraFees) + array_sum($courtFees)}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$total[$loop->index] = $totalExtraFees[$loop->index]+$fee->total_fee}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$downPayments[$loop->index] = $fee->down_payment}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$fee->office_percentage}}%
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$totalOfficeMoney[$loop->index] = $fee->office_money}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                @foreach($fee->fee_parts->where('type',\App\Fee::REQUIRED) as $feePart)
                                                    @php
                                                        $feeParts[$loop->index] = $feePart->money;
                                                    @endphp
                                                @endforeach
                                                {{$unpaidFeePart[$loop->index] = array_sum($feeParts)}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                @foreach($fee->fee_parts->where('type',\App\Fee::REQUIRED) as $feePart)
                                                    @php
                                                        if ($feePart->is_paid == 1)
                                                            $paidFeeParts[$loop->index] = $feePart->money;
                                                    @endphp
                                                @endforeach
                                                {{$paidFeePart[$loop->index] = array_sum($paidFeeParts)}}
                                            </td>
                                            <td class="border border-2 border-black">
                                                {{$remainingAmounts[$loop->index] = $unpaidFeePart[$loop->index] - $paidFeePart[$loop->index]}}
                                            </td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                    <tfoot>
                                    <tr class="bg-secondary">
                                        <td colspan="3" class="border border-2 border-black">الإجمالي</td>
                                        <td class="border border-2 border-black">{{array_sum($totalContracts)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($totalExtraFees)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($total)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($downPayments)}}</td>
                                        <td class="border border-2 border-black"></td>
                                        <td class="border border-2 border-black">{{array_sum($totalOfficeMoney)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($unpaidFeePart)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($paidFeePart)}}</td>
                                        <td class="border border-2 border-black">{{array_sum($remainingAmounts)}}</td>
                                    </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    @push('scripts')
        <script>
            $(document).ready(function () {
                $('#report').DataTable({
                    dom: 'Bfrtip',
                    buttons: [
                        {
                            text: 'طباعة',
                            extend: 'print',
                            footer: true,
                            className: 'btn btn-primary',
                            title: '',
                            customize: function (win) {
                                var css = '@page { size: landscape; }',
                                    head = win.document.head || win.document.getElementsByTagName('head')[0],
                                    style = win.document.createElement('style');
                                style.media = 'print';
                                style.appendChild(win.document.createTextNode(css));
                                head.appendChild(style);
                            },
                            messageTop: '<div class="border border-black border-2 text-center p-1 mb-1">التقرير المالي</div><div class="text-center">من {{Request::get('from')??\Carbon\Carbon::now()->startOfWeek()->format('Y-m-d')}} إلي {{Request::get('to')??\Carbon\Carbon::now()->endOfWeek()->format('Y-m-d')}}</div>'
                        }
                    ]
                });
            });
        </script>
    @endpush
@endsection