@php
    $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 Grants Comission of Bangladesh</h3>
                    <p>UGC Bhaban, Agargaon, Sher-e-Banglanagar, Dhaka - 1207</p>
                    <h5 class="pt-2">
                        Yearly Salary Statement
                    </h5>
                    <p>Financial Year: {{ $financialYear }}</p>
                </div>
                <!--end::Header-->

                <!--begin::Card body-->
                <div class="card-body">
                    {{-- Employee Name & Bank Info --}}
                    <div style="display: flex; align-items: center; justify-content: space-between">
                        <div>
                            <p><b>Name: </b>{{ $employeeInfo->employee_name }}</p>
                            <p><b>Department: </b>{{ $employeeInfo->department->department_name }}</p>
                            <p><b>Designation: </b>{{ $employeeInfo->designation->designation_name }}</p>
                        </div>
                        <div>
                            <p><b>Employee ID: </b>{{ $employeeInfo->employee_id }}</p>
                            <p><b>Bank A/C: </b>{{ $employeeBankInfo->bank_account_number }}</p>
                            <p><b>Joining Date: </b>{{ $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>{{ $data->month_year }}
                                    </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 $item['allowance_amount'];
                                                            $codes[$header->code_id] += $item['allowance_amount'];
                                                        } else {
                                                            echo 0;
                                                        }
                                                        break; // Exit the loop once found
                                                    }
                                                }
                                            @endphp
                                        </td>
                                    @endforeach
                                    <td>{{ $data->allowance_total }}</td>

                                    @php
                                        $codes['total_allowance'] += $data->allowance_total;
                                    @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 $item['deduction_amount'];
                                                            $codes[$header->code_id] += $item['deduction_amount'];
                                                        } else {
                                                            echo 0;
                                                        }
                                                        break; // Exit the loop once found
                                                    }
                                                }
                                            @endphp
                                        </td>
                                    @endforeach
                                    <td>{{ $data->deduction_total }}</td>
                                    <td>{{ $data->net_salary }}</td>

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



                            <tr style="font-weight: bold">
                                <td>Total</td>

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

                                @foreach ($kortonHeaderList as $header)
                                    <td>
                                        @php
                                            echo $codes[$header->code_id];
                                        @endphp
                                    </td>
                                @endforeach
                                <td>
                                    @php
                                        echo $codes['total_deduction'];
                                    @endphp
                                </td>
                                <td>
                                    @php
                                        echo $codes['total_net_salary'];
                                    @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