@extends('layouts.app')
@section('css')
    <style>
        body {
            font-family: Arial, sans-serif;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin: 20px auto;
            text-align: center;
        }
        th, td {
            border: 1px solid black;
            padding: 10px;
        }
        th {
            background-color: #f2f2f2;
        }
        .highlight-green {
            background-color: #c6efce;
        }
        .highlight-yellow {
            background-color: #fff2cc;
        }
        .grand-total {
            color: red;
            font-weight: bold;
        }
    </style>
@endsection
@section('content')

    @include('layouts.toolbar')

    <div id="kt_content_container" class="d-flex flex-column-fluid align-items-start container-xxl">
        <div class="content flex-row-fluid" id="kt_content">
            <div class="card card-page">
                <div class="card-body">
                    <div class="row gy-12 g-xl-12">
                        <div class="col-xxl-12">
                            <div class="card card-xxl-stretch">
                                <div class="card-header border-0 pt-5 pb-3">
                                    <h3 class="card-title fw-bold text-gray-800 fs-2">{{ucwords($student->first_name).' '.ucwords($student->last_name)}} - {{ucwords($monthName)}} Subsidies Details</h3>
                                </div>
                                <div class="card-body py-0">
                                    <div class="table-responsive">
                                        <table>
                                            <tr>
                                                <th rowspan="2" class="highlight-green">Month</th>
                                                <th rowspan="2">Provider Weekly Rate</th>
                                                <th rowspan="2">Week</th>
                                                <th rowspan="2">%</th>
                                                <th rowspan="2">Requested Amount</th>
                                                <th colspan="2">Maximum Reimbursement</th>
                                            </tr>
                                            <tr>
                                                <th>Maximum Reimbursement</th>
                                                <th>Payable</th>
                                            </tr>

                                            @if(isset($details) && count($details))
                                                @foreach($details as $key => $detail)
                                                    <tr>
                                                        @if($key == 0)
                                                            <td rowspan="{{count($details)}}"
                                                                class="highlight-green">{{ucwords($monthName)}}</td>
                                                        @endif
                                                        <td>{{int_to_money($detail['price'], '$')}}</td>
                                                        <td>{{dateFormat2($detail['week_start_date'])}} - {{dateFormat2($detail['week_end_date'])}}</td>
                                                        <td>{{($detail['week']  && is_array($detail['week']) && count($detail['week'])  && $detail['reimbursement_price'] != 0) ? (count($detail['week']) /5 * 100) : 0.00}} %</td>
                                                        <td>{{int_to_money($detail['price'], '$')}}</td>
                                                        <td>{{int_to_money($detail['reimbursement_price'], '$')}}</td>
                                                        @if($key == 0)
                                                            <td rowspan="{{count($details)+4}}">{{int_to_money(($sumReimbursementPrice - $sumReceivedReimbursement- $sumOtherReceivedReimbursement), '$', true)}}</td>
                                                        @endif
                                                    </tr>
                                                @endforeach
                                            @endif
                                            <tr>
                                                <td colspan="4" class="grand-total">Total:</td>
                                                <td class="highlight-yellow">{{int_to_money($sumPrice, '$')}}</td>
                                                <td class="highlight-yellow">{{int_to_money($sumReimbursementPrice, '$')}}</td>
                                            </tr>
                                            <tr>
                                                <td colspan="4" class="grand-total">Received Total:</td>
                                                <td class="highlight-yellow">{{int_to_money($sumReceivedPayments, '$')}}</td>
                                                <td class="highlight-yellow">{{int_to_money($sumReceivedReimbursement, '$')}}</td>
                                            </tr>
                                            <tr>
                                                <td colspan="4" class="grand-total">Grand Total:</td>
                                                <td class="highlight-yellow">{{int_to_money(($sumPrice - $sumReceivedPayments), '$', true)}}</td>
                                                <td class="highlight-yellow">{{int_to_money(($sumReimbursementPrice - $sumReceivedReimbursement), '$', true)}}</td>
                                            </tr>
                                            <tr>
                                                <td colspan="4" class="grand-total">Other Reimbursement Payment Received:</td>
                                                <td class="highlight-yellow"></td>
                                                <td class="highlight-yellow">{{int_to_money(($sumOtherReceivedReimbursement), '$', true)}}</td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script type="text/javascript">

    </script>
@endsection