@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | কর্মী/কর্মকর্তার পাওনা তথ্য')
@section('content')
@php
    $funds = $funds ?? [];
    $leave = $leave ?? [];
    $employee = $employee ?? [];
    $fmt = fn ($v) => number_format((float) ($v ?? 0), 2, '.', '');
    $securityPrincipal = (float) ($funds['security_principal'] ?? 0);
    $securityInterest = (float) ($funds['security_interest'] ?? 0);
    $interestPeriod = '';
    if (! empty($funds['security_calc']['periods'])) {
        $unit = ($funds['security_calc']['period_unit'] ?? 'year') === 'month' ? 'মাস' : 'বছর';
        $interestPeriod = ((int) $funds['security_calc']['periods']).' '.$unit;
    }
    $leavePeriod = (($leave['encashable_days'] ?? 0) > 0)
        ? number_format((float) $leave['encashable_days'], 0).' দিন'
        : '';
    $oldSheet = old('sheet', []);

    $joiningDisplay = $employee['joining_date'] ?? '—';
    $serviceDisplay = $service_length ?? '—';
@endphp
<style>
    .dues-sheet-wrap { max-width: 980px; margin: 0 auto; }
    .dues-sheet {
        background: #fff;
        border: 1px solid #cbd5e1;
        padding: 1.25rem 1.5rem 1.5rem;
        font-family: 'Noto Sans Bengali', 'SolaimanLipi', 'Kalpurush', sans-serif;
        color: #111;
    }
    .dues-sheet .org { text-align: center; font-size: 1.15rem; font-weight: 700; margin: 0; }
    .dues-sheet .org-sub { text-align: center; font-size: .95rem; margin: 2px 0; }
    .dues-sheet .org-addr { text-align: center; font-size: .9rem; margin-bottom: .75rem; }
    .dues-sheet .title { text-align: center; font-size: 1.05rem; font-weight: 700; text-decoration: underline; margin: .5rem 0 1rem; }
    .dues-meta { width: 100%; margin-bottom: 1rem; font-size: .92rem; }
    .dues-meta td { padding: 2px 8px 2px 0; vertical-align: top; width: 33.33%; }
    .dues-table { width: 100%; border-collapse: collapse; font-size: .88rem; }
    .dues-table th, .dues-table td { border: 1px solid #222; padding: 5px 6px; vertical-align: middle; }
    .dues-table th { text-align: center; background: #fafafa; }
    .dues-table .c { text-align: center; width: 52px; }
    .dues-table .period { width: 110px; }
    .dues-table .amt { width: 140px; }
    .dues-table .remark { width: 18%; }
    .dues-table .red, .dues-table td.red, .dues-table .text-danger-row { color: #c00 !important; }
    .dues-table .bold td { font-weight: 700; }
    .dues-table .total-cell {
        text-align: right;
        font-weight: 700;
        padding-right: 10px;
        white-space: nowrap;
    }
    .dues-table input.form-control-sm {
        font-size: .82rem;
        height: 30px;
        border-radius: 2px;
    }
    .dues-table input[type=number]::-webkit-outer-spin-button,
    .dues-table input[type=number]::-webkit-inner-spin-button { -webkit-appearance: none; margin: 0; }
    .dues-table input[type=number] { -moz-appearance: textfield; appearance: textfield; }
    .dues-foot {
        display: flex;
        justify-content: space-between;
        margin-top: 1.75rem;
        font-size: .9rem;
        gap: 1rem;
    }
    .dues-foot .col { width: 42%; }
    .dues-foot .date-line {
        margin-top: .75rem;
        display: flex;
        align-items: center;
        gap: 6px;
    }
    .dues-foot .date-line input {
        width: 110px;
        height: 28px;
        border: 0;
        border-bottom: 1px dotted #333;
        border-radius: 0;
        background: transparent;
        padding: 0 4px;
        box-shadow: none;
    }
    .dues-extra { margin-top: 1rem; padding-top: .75rem; border-top: 1px dashed #cbd5e1; }
</style>

<div class="container-fluid pt-3 pb-4 dues-sheet-wrap">
    @if (session()->has('message'))
        <div class="alert alert-success py-2">{{ session('message') }}</div>
    @endif
    @if (session()->has('error'))
        <div class="alert alert-danger py-2">{{ session('error') }}</div>
    @endif
    @if ($errors->any())
        <div class="alert alert-danger py-2">
            <ul class="mb-0 pl-3">@foreach($errors->all() as $e)<li>{{ $e }}</li>@endforeach</ul>
        </div>
    @endif

    <div class="d-flex justify-content-between align-items-center mb-3">
        <h4 class="mb-0">কর্মী/কর্মকর্তার পাওনা তথ্য</h4>
        <a href="{{ route('admin.staff.separation.index') }}" class="btn btn-sm btn-outline-secondary">{{ __('Back') }}</a>
    </div>

    @if(($loans['remaining'] ?? 0) > 0)
        <div class="alert alert-warning">
            {{ __('Outstanding loan balance: :amount. Clear loans before final settlement.', ['amount' => number_format($loans['remaining'], 2)]) }}
        </div>
    @endif

    <form method="post" action="{{ route('admin.staff.separation.settlement.process', $separation->id) }}" id="duesSheetForm">
        @csrf
        <input type="hidden" name="use_leave_override" value="1">
        <input type="hidden" name="swf_cheque_no" value="{{ old('swf_cheque_no') }}">

        <div class="dues-sheet mb-3">
            <div class="org">{{ $organization }}</div>
            <div class="org-sub">কর্মসংস্থান সৃষ্টি কর্মসূচী (ঋণ কার্যক্রম)</div>
            @if(($organizationAddress ?? '') !== '')
                <div class="org-addr">{{ $organizationAddress }}</div>
            @endif
            <div class="title">কর্মী/কর্মকর্তার পাওনা তথ্য</div>

            <table class="dues-meta">
                <tr>
                    <td><strong>{{ $employee['name'] ?? '—' }}</strong> ({{ $employee['sid'] ?? '—' }})</td>
                    <td>পদবী ঃ {{ $employee['designation'] ?? '—' }}</td>
                    <td>সর্বশেষ শাখা ঃ {{ $employee['branch'] ?? '—' }}</td>
                </tr>
                <tr>
                    <td>যোগদানের তারিখঃ {{ $joiningDisplay }}</td>
                    <td>অব্যাহতির তারিখঃ {{ $employee['release_date'] ?? '—' }}</td>
                    <td>কর্মকাল ঃ {{ $serviceDisplay }}</td>
                </tr>
            </table>

            <table class="dues-table" id="duesCalcTable">
                <thead>
                <tr>
                    <th class="c">ক্রমিক নং</th>
                    <th>বিবরণ/ খাত</th>
                    <th class="period">দিন/তারিখ</th>
                    <th class="amt">পাওনার পরিমাণ</th>
                    <th class="remark">মন্তব্য</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td class="c">০১</td>
                    <td>জামানত</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[security]" data-block="a" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['security'] ?? $fmt($securityPrincipal) }}"></td>
                    <td><input type="text" name="sheet[remarks][security]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['security'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০২</td>
                    <td>জামানতের লাভ</td>
                    <td><input type="text" name="sheet[security_interest_period]" class="form-control form-control-sm" value="{{ $oldSheet['security_interest_period'] ?? $interestPeriod }}"></td>
                    <td><input type="number" step="0.01" min="0" name="sheet[security_interest]" data-block="a" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['security_interest'] ?? $fmt($securityInterest) }}"></td>
                    <td><input type="text" name="sheet[remarks][security_interest]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['security_interest'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৩</td>
                    <td>অর্জিত ছুটি</td>
                    <td><input type="text" name="sheet[leave_period]" class="form-control form-control-sm" value="{{ $oldSheet['leave_period'] ?? $leavePeriod }}"></td>
                    <td>
                        <input type="number" step="0.01" min="0" name="sheet[leave_salary]" id="leaveSalaryAmount" data-block="a"
                               class="form-control form-control-sm text-right calc-amt"
                               value="{{ $oldSheet['leave_salary'] ?? $fmt($leave['encashment'] ?? 0) }}">
                        <input type="hidden" name="leave_salary_amount" id="leaveSalaryAmountHidden" value="{{ old('leave_salary_amount', $leave['encashment'] ?? 0) }}">
                    </td>
                    <td><input type="text" name="sheet[remarks][leave]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['leave'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৪</td>
                    <td class="text-danger-row">বেতন পরিশোধিত</td>
                    <td><input type="text" name="sheet[salary_paid_period]" class="form-control form-control-sm" value="{{ $oldSheet['salary_paid_period'] ?? '' }}"></td>
                    <td><input type="number" step="0.01" min="0" name="sheet[salary_paid]" data-block="a" class="form-control form-control-sm text-right calc-amt text-danger-row" value="{{ $oldSheet['salary_paid'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][salary_paid]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['salary_paid'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৫</td>
                    <td class="text-danger-row">মধ্যাহ্ন ভোজ</td>
                    <td><input type="text" name="sheet[lunch_period]" class="form-control form-control-sm" value="{{ $oldSheet['lunch_period'] ?? '' }}"></td>
                    <td><input type="number" step="0.01" min="0" name="sheet[lunch]" data-block="a" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['lunch'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][lunch]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['lunch'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৬</td>
                    <td class="text-danger-row">যাতায়াত ভাতা</td>
                    <td><input type="text" name="sheet[conveyance_period]" class="form-control form-control-sm" value="{{ $oldSheet['conveyance_period'] ?? '' }}"></td>
                    <td><input type="number" step="0.01" min="0" name="sheet[conveyance]" data-block="a" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['conveyance'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][conveyance]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['conveyance'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৭</td>
                    <td class="text-danger-row">মোবাইল বিল</td>
                    <td><input type="text" name="sheet[mobile_period]" class="form-control form-control-sm" value="{{ $oldSheet['mobile_period'] ?? '' }}"></td>
                    <td><input type="number" step="0.01" min="0" name="sheet[mobile]" data-block="a" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['mobile'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][mobile]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['mobile'] ?? '' }}"></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">উপমোট ঃ</td>
                    <td class="total-cell" id="subtotalA">0.00</td>
                    <td></td>
                </tr>

                <tr>
                    <td class="c">০১</td>
                    <td>জিপিএফ</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[gpf]" data-block="b" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['gpf'] ?? $fmt($funds['gpf'] ?? 0) }}"></td>
                    <td><input type="text" name="gpf_cheque_no" class="form-control form-control-sm" placeholder="চেক নং" value="{{ old('gpf_cheque_no') }}"></td>
                </tr>
                <tr>
                    <td class="c">০২</td>
                    <td>সিপিএফ</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[cpf]" data-block="b" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['cpf'] ?? $fmt($funds['cpf'] ?? 0) }}"></td>
                    <td><input type="text" name="cpf_cheque_no" class="form-control form-control-sm" placeholder="চেক নং" value="{{ old('cpf_cheque_no') }}"></td>
                </tr>
                <tr>
                    <td class="c">০৩</td>
                    <td class="text-danger-row">আনুতোষিক</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[gratuity]" data-block="b" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['gratuity'] ?? $fmt($funds['gratuity'] ?? 0) }}"></td>
                    <td><input type="text" name="gf_cheque_no" class="form-control form-control-sm" placeholder="চেক নং" value="{{ old('gf_cheque_no') }}"></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">উপমোট ঃ</td>
                    <td class="total-cell" id="subtotalB">0.00</td>
                    <td></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">সর্বমোট কর্মীর পাওনা</td>
                    <td class="total-cell" id="grossPayable">0.00</td>
                    <td></td>
                </tr>

                <tr>
                    <td class="c">০১</td>
                    <td>আর্থিক অনিয়ম (যদি থাকে)</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[irregularity]" data-block="c" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['irregularity'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][irregularity]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['irregularity'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০২</td>
                    <td>জিপিএফ ঋণের স্থিতি</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[gpf_loan]" data-block="c" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['gpf_loan'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][gpf_loan]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['gpf_loan'] ?? '' }}"></td>
                </tr>
                <tr>
                    <td class="c">০৩</td>
                    <td>নোটিস পিরিয়ড ভঙ্গ</td>
                    <td class="text-center text-muted">—</td>
                    <td><input type="number" step="0.01" min="0" name="sheet[notice_breach]" data-block="c" class="form-control form-control-sm text-right calc-amt" value="{{ $oldSheet['notice_breach'] ?? '0.00' }}"></td>
                    <td><input type="text" name="sheet[remarks][notice_breach]" class="form-control form-control-sm" value="{{ $oldSheet['remarks']['notice_breach'] ?? '' }}"></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">মোট</td>
                    <td class="total-cell" id="subtotalC">0.00</td>
                    <td></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">অফিসের পাওনা</td>
                    <td class="total-cell" id="officeDues">0.00</td>
                    <td></td>
                </tr>
                <tr class="bold">
                    <td colspan="3" class="text-right">কর্মীর নীট পাওনা</td>
                    <td class="total-cell" id="netPayable">0.00</td>
                    <td></td>
                </tr>
                </tbody>
            </table>

            <div class="dues-extra form-row">
                <div class="form-group col-md-4 mb-2">
                    <label class="small font-weight-bold mb-1">জামানত চেক নং</label>
                    <input type="text" name="security_cheque_no" class="form-control form-control-sm" value="{{ old('security_cheque_no') }}">
                </div>
                <div class="form-group col-md-4 mb-2">
                    <label class="small font-weight-bold mb-1">ছুটিজনিত বেতন চেক নং</label>
                    <input type="text" name="leave_salary_cheque_no" class="form-control form-control-sm" value="{{ old('leave_salary_cheque_no') }}">
                </div>
            </div>

            <h6 class="mt-3 mb-2">{{ __('Witnesses (optional — printed on No-Demand Certificate)') }}</h6>
            <div class="form-row">
                @for($w = 1; $w <= 3; $w++)
                    <div class="form-group col-md-4">
                        <label class="small font-weight-bold">{{ __('Witness :n', ['n' => $w]) }}</label>
                        <input type="text" name="witness_{{ $w }}_name" class="form-control form-control-sm mb-1" maxlength="150" placeholder="{{ __('Name') }}" value="{{ old('witness_'.$w.'_name') }}">
                        <input type="text" name="witness_{{ $w }}_date" class="form-control form-control-sm" placeholder="dd.mm.yyyy" value="{{ old('witness_'.$w.'_date') }}" autocomplete="off">
                    </div>
                @endfor
            </div>

            <div class="dues-foot">
                <div class="col">
                    প্রস্তুতকারীর স্বাক্ষর
                    <div class="date-line">
                        <span>তারিখ ঃ</span>
                        <input type="text" name="sheet[prepared_date]" value="{{ $oldSheet['prepared_date'] ?? now()->format('d.m.Y') }}" placeholder="dd.mm.yyyy" autocomplete="off">
                    </div>
                </div>
                <div class="col" style="text-align:right;">
                    উপ-পরিচালক (অর্থ) স্বাক্ষর
                    <div class="date-line" style="justify-content:flex-end;">
                        <span>তারিখ ঃ</span>
                        <input type="text" name="sheet[finance_sign_date]" value="{{ $oldSheet['finance_sign_date'] ?? '' }}" placeholder="dd.mm.yyyy" autocomplete="off">
                    </div>
                </div>
            </div>
        </div>

        <div class="d-flex flex-wrap justify-content-between align-items-center mb-4" style="gap:.5rem;">
            <a class="btn btn-outline-secondary" href="{{ route('admin.staff.separation.final_clearance.branch', $separation->id) }}">
                {{ __('Branch Clearance') }} (নমুনা-১৫)
            </a>
            <button type="submit" class="btn btn-primary"
                    @if(($loans['remaining'] ?? 0) > 0) disabled @endif
                    onclick="return confirm(@json(__('Confirm final settlement and open dues sheet print?')));">
                {{ __('Confirm Final Settlement & Print') }}
            </button>
        </div>
    </form>
</div>
@endsection

@push('script')
<script>
(function () {
    function num(el) {
        var v = parseFloat(el && el.value != null ? el.value : 0);
        return isFinite(v) ? v : 0;
    }
    function fmt(n) {
        return (Math.round(n * 100) / 100).toLocaleString('en-US', {
            minimumFractionDigits: 2,
            maximumFractionDigits: 2
        });
    }
    function sumBlock(block) {
        var total = 0;
        document.querySelectorAll('.calc-amt[data-block="' + block + '"]').forEach(function (el) {
            total += num(el);
        });
        return total;
    }
    function recalc() {
        var a = sumBlock('a');
        var b = sumBlock('b');
        var c = sumBlock('c');
        var gross = a + b;
        var net = gross - c;
        var elA = document.getElementById('subtotalA');
        var elB = document.getElementById('subtotalB');
        var elC = document.getElementById('subtotalC');
        var elG = document.getElementById('grossPayable');
        var elO = document.getElementById('officeDues');
        var elN = document.getElementById('netPayable');
        if (elA) elA.textContent = fmt(a);
        if (elB) elB.textContent = fmt(b);
        if (elC) elC.textContent = fmt(c);
        if (elG) elG.textContent = fmt(gross);
        if (elO) elO.textContent = fmt(c);
        if (elN) elN.textContent = fmt(net);

        var src = document.getElementById('leaveSalaryAmount');
        var dest = document.getElementById('leaveSalaryAmountHidden');
        if (src && dest) dest.value = src.value;
    }

    document.querySelectorAll('.calc-amt').forEach(function (el) {
        el.addEventListener('input', recalc);
        el.addEventListener('change', recalc);
    });

    // Prevent theme datepickers attaching to plain text date fields
    document.querySelectorAll('#duesSheetForm input[placeholder="dd.mm.yyyy"]').forEach(function (el) {
        el.classList.remove('aiz-date-range', 'datepicker', 'flatpickr-input');
        el.removeAttribute('data-toggle');
    });

    recalc();
})();
</script>
@endpush