@extends('layouts.app', ['path' => 'payroll.sheets'])
@section('title', 'Payroll Sheet Details - HRMS')

@section('content')
    <div class="content">

        <div class="d-md-flex d-block align-items-center justify-content-between page-breadcrumb mb-3">
            <div class="my-auto mb-2">
                <h2 class="mb-1">Payroll Sheet Details</h2>
                <nav>
                    <ol class="breadcrumb mb-0">
                        <li class="breadcrumb-item">
                            <a href="#"><i class="ti ti-smart-home"></i></a>
                        </li>
                        <li class="breadcrumb-item">
                            <a href="#">Payroll</a>
                        </li>
                        <li class="breadcrumb-item active" aria-current="page">
                            <a href="{{ route('payroll.sheets') }}">
                                Processing Sheets
                            </a>
                        </li>
                        <li class="breadcrumb-item active" aria-current="page">Sheet Details</li>
                    </ol>
                </nav>
            </div>
            <div class="d-flex my-xl-auto right-content align-items-center flex-wrap ">
                @can('payroll_structures.post_unpost_salary')
                    <div class="mb-2">
                        @php
                            $route = $isPost ? 'payroll.processing.unpost' : 'payroll.processing.post';
                            $btnText = $isPost ? 'Unpost Payroll' : 'Post Payroll';
                            $iconClass = $isPost ? 'ti ti-lock-open' : 'ti ti-lock';
                        @endphp
                        <a href="{{ route($route, enCryptData($id)) }}" class="btn btn-primary d-flex align-items-center"><i class="{{ $iconClass }} me-2"></i>{{ $btnText }}</a>
                    </div>
                @endcan
            </div>
        </div>
        
        @include('partials.new_alerts')

        <div class="col-12 d-flex">
            <div class="row flex-fill">

                <div class="col-lg-3 col-md-6 d-flex">
                    <div class="card flex-fill">
                        <div class="card-body">
                            <div class="d-flex align-items-center justify-content-between bg-light border rounded p-2">
                                <div class="">
                                    <span class="fs-14 fw-normal text-truncate mb-1">Total Payroll</span>
                                    <h5>{{amount_format_number($monthSum['payroll'])}}</h5>
                                </div>
                                <a href="#"
                                    class="avatar avatar-md avatar-rounded bg-transparent-primary border border-primary">
                                    <span class="text-primary"><i class="ti ti-brand-shopee"></i></span>
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6 d-flex">
                    <div class="card flex-fill">
                        <div class="card-body">
                            <div class="d-flex align-items-center justify-content-between bg-light border rounded p-2">
                                <div class="">
                                    <span class="fs-14 fw-normal text-truncate mb-1">Deductions</span>
                                    <h5>{{amount_format_number($monthSum['deductions'])}}</h5>
                                </div>
                                <a href="#"
                                    class="avatar avatar-md avatar-rounded bg-transparent-danger border border-danger">
                                    <span class="text-danger"><i class="ti ti-brand-shopee"></i></span>
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6 d-flex">
                <div class="card flex-fill">
                        <div class="card-body">
                            <div class="d-flex align-items-center justify-content-between bg-light border rounded p-2">
                                <div class="">
                                    <span class="fs-14 fw-normal text-truncate mb-1">Net Pay</span>
                                    <h5>{{amount_format_number($monthSum['net'])}}</h5>
                                </div>
                                <a href="#"
                                    class="avatar avatar-md avatar-rounded bg-transparent-success border border-success">
                                    <span class="text-success"><i class="ti ti-brand-shopee"></i></span>
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6 d-flex">
                    <div class="card flex-fill">
                        <div class="card-body">
                            <div class="d-flex align-items-center justify-content-between bg-light border rounded p-2">
                                <div class="">
                                    <span class="fs-14 fw-normal text-truncate mb-1">Allowances</span>
                                    <h5>{{amount_format_number($monthSum['allowances'])}}</h5>
                                </div>
                                <a href="#"
                                    class="avatar avatar-md avatar-rounded bg-transparent-skyblue border border-skyblue">
                                    <span class="text-skyblue"><i class="ti ti-brand-shopee"></i></span>
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>



        <div class="card">
            <div class="card-header d-flex align-items-center justify-content-between">
                <div>
                    <h5 class="mb-0">Payroll Sheet Details For {{ $month }}</h5>
                    <p class="text-muted mb-0">Employee payroll breakdown and calculations</p>
                    <p class="text-muted mb-0">Created on {{ $created_at }}</p>
                </div>
                <div class="d-flex gap-2">
                    @can('payroll_sheet.export_data')
                    <a href="{{ route('payroll.processing.download.excel',$payroll_process_id) }}">
                        <button type="button" class="btn btn-outline-primary" id="exportCsv">
                            <i class="ti ti-arrow-up-left me-2"></i>Export CSV
                        </button>
                    </a>
                    @endcan
                    @can('payroll_sheet.download_payslips')
                        <a href="{{ route('payroll.process.download', request('id')) }}" class="btn btn-primary"
                            id="downloadPayslips">
                            <i class="ti ti-file-download me-2"></i>Download Payslips
                        </a>
                    @endcan
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive" style="overflow-x: auto; max-width: 100%;">
                    <table class="table table-hover datatable" id="employee-detail-payroll-export-csv"
                        style="min-width: 1200px;">
                        <thead class="table-light">
                            <tr>    
                                {{-- General Information --}}
                                <th>Employee ID</th>
                                <th>Employee Name</th>
                                <th>Department</th>
                                <th>Designation</th>
                                <th>Worked Days</th>
                                <th>Gross Salary</th>
                                <th>Payable Salary</th>
                                <th>Taxable Salary</th>
                                {{-- Ends --}}

                                {{-- Earnings --}}
                                <th>Allowances</th>
                                <th>Bonuses</th>
                                <th>Arrears</th>
                                @if (!empty($data[0]['pay_item_calculations']))
                                    @foreach ($data[0]['pay_item_calculations'] as $pay_item)
                                        @if($pay_item['pay_item_id'] == null)
                                            @continue
                                        @endif
                                        @if($pay_item['pay_item_id'] != null &&$pay_item['type'] == "earning")
                                            <th class="">{{ $pay_item['name'] }}</th>
                                        @endif
                                    @endforeach
                                @endif
                                <th>Total Earnings</th>
                                {{-- Ends --}}

                                {{-- Deductions --}}
                                <th>Tax Amount</th>
                                <th>Advances</th>
                                <th>Loans</th>
                                @if (!empty($data[0]['pay_item_calculations']))
                                    @foreach ($data[0]['pay_item_calculations'] as $pay_item)
                                        @if($pay_item['pay_item_id'] == null)
                                            @continue
                                        @endif
                                        @if($pay_item['pay_item_id'] != null && $pay_item['type'] == "deduction")
                                            <th class="">{{ $pay_item['name'] }}</th>
                                        @endif
                                    @endforeach
                                @endif
                                <th>Total Deductions</th>


                                <th>Net Salary</th>
                                <th>Status</th>
                                <th class="no-sort">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($data as $item)
                                @php
                                    $total_allowance = 0;
                                    $total_bonus = 0;
                                    $total_advance = 0;
                                    $total_loan_installment = 0;
                                    $total_arrears_earning = 0;
                                    $total_arrears_deduction = 0;
                                    $total_arrears = 0;
                                    if (!empty($item['pay_item_calculations'])) {
                                        foreach ($item['pay_item_calculations'] as $pi) {
                                            $amt = isset($pi['calculated_amount']) ? (float) $pi['calculated_amount'] : 0;
                                            $item_type = strtolower($pi['item_type'] ?? '');
                                            $type = strtolower($pi['type'] ?? '');
                                            if ($item_type === 'advance') {
                                                $total_advance += $amt;
                                            }
                                            elseif ($item_type === 'bonus') {
                                                $total_bonus += $amt;
                                            }
                                            elseif ($item_type === 'allowance') {
                                                $total_allowance += $amt;
                                            }
                                            elseif ($item_type === 'loan_installment') {
                                                $total_loan_installment += $amt;
                                            }
                                            elseif ($item_type === 'arrears' && $type === 'earning') {
                                                $total_arrears += $amt;
                                            }
                                        }
                                    }
                                @endphp
                                <tr>
                                    {{-- General Information --}}
                                     <td data-order="{{ $item['employee_id_code'] ?? '' }}">
                                        <span class="badge bg-secondary-transparent">
                                            <p style="color: #3B7080;">
                                                {{ $item['employee_id_code'] }}
                                            </p>
                                        </span>
                                    </td>
                                    <td>{{ $item['employee_name'] }}</td>
                                    <td>{{ $item['department'] }}</td>
                                    <td>{{ $item['designation'] }}</td>
                                    <td class="text-end">{{ $item['pay_days'] }}</td>
                                    <td class="text-end">
                                        {{ amount_format_number($item['final_payslip_data']['payroll_summary']['gross_pay'] ?? 0) }}
                                    </td>
                                    <td class="text-end">
                                        {{ amount_format_number($item['final_payslip_data']['payroll_summary']['payable_amount'] ?? 0) }}
                                    </td>
                                    <td class="text-end">
                                        {{ amount_format_number($item['final_payslip_data']['payroll_summary']['taxable_salary'] ?? 0) }}
                                    </td>
                                    {{-- Ends --}}

                                    {{-- Earnings --}}
                                    <td class="text-end">
                                        {{ amount_format_number($total_allowance) }}
                                    </td>
                                    <td class="text-end">
                                        {{ amount_format_number($total_bonus) }}
                                    </td>
                                    <td class="text-end">
                                        {{ amount_format_number($total_arrears) }}
                                    </td>
                                    @if (!empty($item['pay_item_calculations']))
                                        @foreach ($item['pay_item_calculations'] as $pay_item)
                                            @if($pay_item['pay_item_id'] == null)
                                                @continue
                                            @endif
                                            @if($pay_item['pay_item_id'] != null && $pay_item['type'] == "earning")
                                                <td class="text-end">{{ amount_format_number($pay_item['calculated_amount'] ?? 0) }}</td>
                                            @endif
                                        @endforeach
                                    @endif
                                    <td class="text-end">
                                        {{ amount_format_number((float)($item['final_payslip_data']['payroll_summary']['total_earnings'] ?? 0) ) }}
                                    </td>
                                    {{-- Ends --}}


                                    {{-- Deductions --}}
                                    <td class="text-end">
                                        {{ amount_format_number($item['final_payslip_data']['payroll_summary']['tax_amount'] ?? 0) }}
                                    </td>
                                    <td class="text-end">
                                        {{ amount_format_number($total_advance) }}
                                    </td>

                                    <td class="text-end">
                                        {{ amount_format_number($total_loan_installment) }}
                                    </td>
                                    @if (!empty($item['pay_item_calculations']))
                                        @foreach ($item['pay_item_calculations'] as $pay_item)
                                            @if($pay_item['pay_item_id'] == null)
                                                @continue
                                            @endif
                                            @if($pay_item['pay_item_id'] != null && $pay_item['type'] == "deduction")
                                                <td class="text-end">{{ amount_format_number($pay_item['calculated_amount'] ?? 0) }}</td>
                                            @endif
                                        @endforeach
                                    @endif
                                    <td class="text-end">
                                        {{ amount_format_number(
                                            (float)($item['final_payslip_data']['payroll_summary']['total_deductions'] ?? 0) 
                                            +
                                            (float)($item['final_payslip_data']['payroll_summary']['tax_amount'] ?? 0)
                                        ) }}
                                    </td>
                                    {{-- Ends --}}

                                    <td class="text-end">
                                        {{ amount_format_number($item['final_payslip_data']['payroll_summary']['net_pay'] ?? 0) }}
                                    </td>
                                    <td>
                                        @if ($item['status'] == 'processed')
                                            <span class="badge badge-success">Processed</span>
                                        @elseif($item['status'] == 'failed')
                                            <span class="badge badge-danger">Failed</span>
                                        @else
                                            <span class="badge badge-warning">pending</span>
                                        @endif
                                    </td>
                                    <td>
                                        @can('payroll_sheet.download_single_payslip')
                                            <div class="action-icon d-inline-flex">
                                                <a title="Download Payslip" href="{{ route('payroll.process.download.payslip', enCryptData($item['id']?? '')) }}" class="me-2"><i class="ti ti-download"></i></a>
                                            </div>
                                        @endcan
                                    </td>
                                </tr>
                            @endforeach

                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('scripts')
<script>
    let payroll_process_name = "{{ $payroll_structure_name }}"
    let month = "{{ $month }}"
</script>
    <script src="{{ asset('assets/js/dev-script/payroll-process-detail.js?v='.config('api.version')) }}"></script>
@endpush