@php
    $startYear = explode('-', $financialYear)[0];
    $endYear = explode('-', $financialYear)[1];
    $codes = ['total_allowance' => 0, 'total_deduction' => 0, 'total_net_salary' => 0];
@endphp


@extends('master')

@section('title', 'Yearly salary statement')
@section('breadcrumbMainTitle', 'Yearly salary statement')

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

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

    th {
        background-color: #fafafa;
        font-weight: 500;
    }

    p {
        margin-bottom: 0.2rem !important;
    }
</style>

@section('content')
    <div class="post d-flex flex-column-fluid" id="kt_post">
        <!--begin::Container-->
        <div id="kt_content_container" class="container-fluid">
            <!--begin::Card-->
            <div class="card">
                <!--begin::Header-->
                <div class="border-0 pt-5 pb-2 text-center">
                    <h3>{{ __('university_name') }}</h3>
                    <h5 style="font-weight: normal">{{ __('university_location') }}</h5>
                    <h5 class="pt-2">
                        বেতন বিবরণী
                    </h5>
                    <p>অর্থবছর: {{ $numto->BnNum($startYear) . ' - ' . $numto->BnNum($endYear) }} ( জুলাই-
                        {{ $numto->BnNum($startYear) }} হতে জুন- {{ $numto->BnNum($endYear) }} পর্যন্ত বেতন বিবরণী )</p>
                </div>
                <!--end::Header-->

                <!--begin::Card body-->
                <div class="card-body">
                    {{-- Employee Info --}}
                    <div style="display: flex; align-items: center; justify-content: space-between">
                        <div>
                            <p><b>নাম: </b>{{ $employeeInfo->employee_name }}</p>
                            <p><b>পদবি : </b> {{ $employeeInfo->designation->designation_name ?? '' }} </p>
                            <p><b>দপ্তর : </b> {{ $employeeInfo->department->department_name ?? '' }} </p>
                        </div>
                        <div>
                            <p><b>টি আই এন : </b> {{ $employeeInfo->etin ?? '' }} </p>
                            <p><b>যোগদানের তারিখ : </b> {{ BnDate($employeeInfo->joining_date ?? '') }} </p>
                        </div>
                    </div>

                    {{-- Statement Start --}}
                    <table>
                        <thead>
                            <tr>
                                <th>মাস</th>
                                @foreach ($bhataHeaderList as $header)
                                    <th>{{ $header->code_details->code_title }}</th>
                                @endforeach
                                <th>মোট বেতন ও ভাতাদি</th>

                                @foreach ($kortonHeaderList as $header)
                                    <th>{{ $header->code_details->code_title }}</th>
                                @endforeach
                                <th>মোট কর্তন</th>
                                <th>নীট বেতন পরিশোধ</th>
                            </tr>
                        </thead>

                        <tbody>
                            @foreach ($topsheetStatementData as $data)
                                <tr>
                                    <td>
                                        @php
                                            $month_year_bn = explode('-', $data->month_year);
                                            echo $numto->bnMonth($month_year_bn[1]) .
                                                ', ' .
                                                $numto->BnNum($month_year_bn[0]);
                                        @endphp
                                    </td>

                                    @foreach ($bhataHeaderList as $header)
                                        <td>
                                            @php
                                                if (!isset($codes[$header->code_id])) {
                                                    $codes[$header->code_id] = 0;
                                                }
                                                $allowanceArray = json_decode($data->allowances, true);

                                                foreach ($allowanceArray as $item) {
                                                    if (
                                                        isset($item['code_id']) &&
                                                        $item['code_id'] === $header->code_id
                                                    ) {
                                                        if (isset($item['allowance_amount'])) {
                                                            echo $numto->BnNum(($item['allowance_amount'] ?? 0));
                                                            $codes[$header->code_id] += ($item['allowance_amount'] ?? 0);
                                                        } else {
                                                            echo 0;
                                                        }
                                                        break; // Exit the loop once found
                                                    }
                                                }
                                            @endphp
                                        </td>
                                    @endforeach
                                    <td>{{ $numto->BnNum(($data->allowance_total ?? 0)) }}</td>

                                    @php
                                        $codes['total_allowance'] += ($data->allowance_total ?? 0);
                                    @endphp

                                    @foreach ($kortonHeaderList as $header)
                                        <td>
                                            @php
                                                if (!isset($codes[$header->code_id])) {
                                                    $codes[$header->code_id] = 0;
                                                }

                                                $kortonArray = json_decode($data->deductions, true);
                                                foreach ($kortonArray as $item) {
                                                    if (
                                                        isset($item['deduction_type_id']) &&
                                                        $item['deduction_type_id'] === $header->code_id
                                                    ) {
                                                        if (isset($item['deduction_amount'])) {
                                                            echo $numto->BnNum(($item['deduction_amount'] ?? 0));
                                                            $codes[$header->code_id] += ($item['deduction_amount'] ?? 0);
                                                        } else {
                                                            echo 0;
                                                        }
                                                        break; // Exit the loop once found
                                                    }
                                                }
                                            @endphp
                                        </td>
                                    @endforeach
                                    <td>{{ $numto->BnNum(($data->deduction_total ?? 0)) }}</td>
                                    <td>{{ $numto->BnNum(($data->net_salary ?? 0)) }}</td>

                                    @php
                                        $codes['total_deduction'] += ($data->deduction_total ?? 0);
                                        $codes['total_net_salary'] += ($data->net_salary ?? 0);
                                    @endphp
                                </tr>
                            @endforeach



                            <tr style="font-weight: bold">
                                <td>মোট</td>

                                @foreach ($bhataHeaderList as $header)
                                    <td>
                                        @php
                                            echo $numto->BnNum($codes[$header->code_id]);
                                        @endphp
                                    </td>
                                @endforeach
                                <td>
                                    @php
                                        echo $numto->BnNum(($codes['total_allowance'] ?? 0));
                                    @endphp
                                </td>

                                @foreach ($kortonHeaderList as $header)
                                    <td>
                                        @php
                                            echo $numto->BnNum($codes[$header->code_id]);
                                        @endphp
                                    </td>
                                @endforeach
                                <td>
                                    @php
                                        echo $numto->BnNum(($codes['total_deduction'] ?? 0));
                                    @endphp
                                </td>
                                <td>
                                    @php
                                        echo $numto->BnNum(($codes['total_net_salary'] ?? 0));
                                    @endphp
                                </td>
                            </tr>

                        </tbody>
                    </table>
                    {{-- Topsheet End --}}

                </div>
                <!--end::Card body-->
            </div>
            <!--end::Card-->
            <div class="text-end mt-10">
                <a href="{{ url()->previous() }}" class="btn btn-sm btn-secondary">
                    <span class="indicator-label">Back</span>
                </a>
                <a class="text-secondary" href="#">
                    <button class="btn btn-sm btn-success">
                        Download
                    </button>
                </a>
            </div>
        </div>
        <!--end::Container-->
    </div>

@endsection