@php
$year = explode('-', $topsheetInfo->month_year);
$yearBn = $numto->bnNum($year[0]);
$monthBn = $numto->bnMonth($year[1]);
@endphp


@extends('master')

@section('title', 'বেতন বিল টপশিট')
@section('breadcrumbMainTitle', 'বেতন বিল টপশিট')

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

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

    th {
        background-color: #fafafa;
        font-weight: 500;
    }
</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-10 pb-4 text-center">
                <h3>বেতন বিল টপশিট</h3>
                <h5 class="pt-2">
                    {{ $yearBn . ', ' . $monthBn }}
                </h5>
            </div>
            <!--end::Header-->

            <!--begin::Card body-->
            <div class="card-body">

                <h5>{{ $topsheetInfo->category->category_name }}</h5>
                {{-- Topsheet Start --}}
                <table>
                    <thead>
                        <tr>
                            <th>ক্র/নং</th>
                            <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>
                            <th>নীট বেতন পরিশোধ</th>
                        </tr>
                    </thead>

                    <tbody>
                        @foreach ($topsheetData as $data)
                        <tr>
                            <td>{{ $numto->BnNum($loop->iteration) }}</td>
                            <td>{{ $data->employee->employee_name . ' , ' . $data->employee->designation->designation_name }}
                            </td>

                            @foreach ($bhataHeaderList as $header)
                            <td>
                                @php
                                $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'];
                                } else {
                                echo 0;
                                }
                                break; // Exit the loop once found
                                }
                                }
                                @endphp
                            </td>
                            @endforeach
                            <td>{{ $data->allowance_total }}</td>

                            @foreach ($kortonHeaderList as $header)
                            <td>
                                @php
                                $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'];
                                } else {
                                echo 0;
                                }
                                break; // Exit the loop once found
                                }
                                }
                                @endphp
                            </td>
                            @endforeach
                            <td></td>
                            <td>{{ $data->deduction_total }}</td>
                            <td>{{ $data->net_salary }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                {{-- Topsheet End --}}

            </div>
            <!--end::Card body-->
            {{-- Signatures --}}
            <div style="padding:40px 25px 15px; display: flex; gap: 6px; align-items: end; font-size: 12px; text-align: center">
                @foreach($signatoryList as $item)
                <div style="margin-right:60px;">
                    @if(isset($signatures[$item->user_id]))
                    <img src="{{asset('storage/employee/employee/profile/'.$signatures[$item->user_id])}}" alt="signature" style="width: 100px; height: auto;">
                    @endif
                    <!-- Content with border-top -->
                    <div style="border-top: 1px solid black; padding-top: 2px;">
                        <span>
                            {{$item->user->employee->designation->designation_name}}
                        </span>
                        <br />
                        <span>
                            {{$item->user->employee->department->department_name}}
                        </span>
                    </div>
                </div>
                @endforeach
            </div>
        </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