@php
    $monthYear = DateTime::createFromFormat('Y-m', $topsheetInfo->month_year);
    $month = $monthYear->format('F');
    $year = $monthYear->format('Y');
@endphp

@extends('master')
@section('content')
    <style>
        p {
            margin-bottom: 0.2rem !important;
        }

        /* Tables */
        table {
            width: 100%;
            font-size: 14px;
        }

        th,
        td {
            border: 1px solid #aaa !important;
            padding: 8px;
        }

        th {
            background-color: #fafafa;
            font-weight: 600;
        }
    </style>
    <section class="w-100">
        <div class="container-fluid">
            <div class="card mb-4">
                <!--begin::Header-->
                <div class="pt-5 pb-2 text-center">
                    <h3>{{ __('university_name') }}</h3>
                    <h5 style="font-weight: normal">{{ __('university_location') }}</h5>
                </div>
                <!--end::Header-->

                <div class="card-body">
                    <div class="row">
                        <p>The Manager</p>
                        <p>{{ $topsheetInfo->bank_name }}</p>
                        <p>{{ $topsheetInfo->branch_name }}</p>
                        @if ($topsheetInfo->branch_address)
                            <p>{{ $topsheetInfo->branch_address }}</p>
                        @endif
                    </div>

                    <div class="row text-center py-2">
                        <h3>Bank Advice</h3>
                        <h5>Salary Bill of {{ $topsheetInfo->category->category_name }} for the month of {{ $month }}
                            - {{ $year }}</h5>
                    </div>

                    <div class="row">
                        <p>Sir,</p>
                        <p>please transfer a total of sum Tk.{{ $topsheetInfo->net_salary_total }} (
                            @php
                                $numberToWordConvert = new \App\Lib\NumberToWordConvert();
                                echo $numberToWordConvert->convertNumber($topsheetInfo->net_salary_total);
                            @endphp
                            Only ) from our Current Deposit Account (CD) Number-{{ $topsheetInfo->bank_account_number }}
                            with
                            you
                            as the following Account numbers. </p>
                    </div>
                    <div class="row mt-6">
                        <div class="col-md-12">
                            <table>
                                <thead>
                                    <th>SL</th>
                                    <th>Name</th>
                                    <th>A/C No</th>
                                    <th>Routing Number</th>
                                    <th>Bank & Branch Name</th>
                                    <th>Net Pay</th>
                                </thead>

                                <tbody>
                                    @foreach ($bankAdvices as $item)
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                                            <td>{{ $item->employee->employee_name }}</td>
                                            <td>{{ $item->bank_account_number }}</td>
                                            <td>{{ $item->routing_no }}</td>
                                            <td>{{ $item->bank_name . ', ' . $item->branch_name }}</td>
                                            <td style="text-align: right; font-weight: 600;">{{ $item->net_salary }}</td>
                                        </tr>
                                    @endforeach

                                    <tr style="text-align: right; font-weight: 600;">
                                        <td colspan="5">Total Net Amount</td>
                                        <td>{{ $topsheetInfo->net_salary_total }}</td>
                                    </tr>

                                    <tr style="text-align: center;">
                                        <td colspan="6"><span
                                                style="font-weight: 600">Tk.{{ $topsheetInfo->net_salary_total }} (
                                                @php
                                                    $numberToWordConvert = new \App\Lib\NumberToWordConvert();
                                                    echo $numberToWordConvert->convertNumber(
                                                        $topsheetInfo->net_salary_total,
                                                    );
                                                @endphp
                                                Only )</span> Disbursement of the said amount kindly be allowed on
                                            <span style="font-weight: 600">
                                                @php
                                                    $date = new DateTime($topsheetInfo->month_year);
                                                    $date->modify('first day of next month');
                                                    echo $date->format('Y-m-d');
                                                @endphp
                                                .</span>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection