@extends('admin.admin_dashboard')

@section('customcss')
<style>

    .pf-summary-card {
        border-radius: 12px;
        transition: all 0.2s ease-in-out;
    }

    .pf-summary-card:hover {
        transform: translateY(-2px);
    }

    .pf-summary-label {
        font-size: 13px;
        color: #6c757d;
        margin-bottom: 6px;
    }

    .pf-summary-value {
        font-size: 24px;
        font-weight: 700;
        line-height: 1.2;
        color: #1e1e2d;
    }

    .pf-summary-sub {
        font-size: 12px;
        color: #999;
        margin-top: 4px;
    }

    .pf-table tfoot th {
        background: #f8f9fa;
        font-weight: 700;
    }

    .pf-empty-state {
        padding: 50px 20px;
        text-align: center;
        color: #6c757d;
    }
</style>
@endsection

@section('admin')

<div class="content-body default-height">
    <div class="container-fluid">

        <div class="row page-titles">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                <li class="breadcrumb-item"><a href="javascript:void(0)">Provident Fund</a></li>
                <li class="breadcrumb-item active"><a href="javascript:void(0)">Reports</a></li>
            </ol>
        </div>

        <div class="row">

            <div class="col-xl-12">
                <div class="filter cm-content-box box-primary">
                    <div class="content-title SlideToolHeader">
                        <div class="cpa">
                            <i class="fa-sharp fa-solid fa-filter me-2"></i>Filter Provident Fund Report
                        </div>
                        <div class="tools">
                            <a href="javascript:void(0);" class="expand handle"><i class="fal fa-angle-down"></i></a>
                        </div>
                    </div>

                    <div class="cm-content-body form excerpt">
                        <div class="card-body">
                            <form method="GET" action="{{ route('admin.provident-fund.reports.index') }}">
                                <div class="row">
                                    <div class="col-xl-3 col-sm-6 mb-3">
                                        <label class="form-label">Member Type</label>
                                        <select name="member_type" class="form-control default-select h-auto wide">
                                            <option value="all" {{ ($filters['member_type'] ?? 'all') === 'all' ? 'selected' : '' }}>All</option>
                                            <option value="employee" {{ ($filters['member_type'] ?? '') === 'employee' ? 'selected' : '' }}>Employee</option>
                                            <option value="teacher" {{ ($filters['member_type'] ?? '') === 'teacher' ? 'selected' : '' }}>Teacher</option>
                                        </select>
                                    </div>

                                    <div class="col-xl-3 col-sm-6 mb-3">
                                        <label class="form-label">Search Member</label>
                                        <input
                                            type="text"
                                            name="keyword"
                                            class="form-control"
                                            value="{{ $filters['keyword'] ?? '' }}"
                                            placeholder="Name / Code / Designation / Phone"
                                        >
                                    </div>

                                    <div class="col-xl-2 col-sm-6 mb-3">
                                        <label class="form-label">Date From</label>
                                        <div class="input-hasicon">
                                            <input type="date" name="date_from" class="form-control" value="{{ $filters['date_from'] ?? '' }}">
                                            <div class="icon"><i class="far fa-calendar"></i></div>
                                        </div>
                                    </div>

                                    <div class="col-xl-2 col-sm-6 mb-3">
                                        <label class="form-label">Date To</label>
                                        <div class="input-hasicon">
                                            <input type="date" name="date_to" class="form-control" value="{{ $filters['date_to'] ?? '' }}">
                                            <div class="icon"><i class="far fa-calendar"></i></div>
                                        </div>
                                    </div>

                                    <div class="col-xl-2 col-sm-12 align-self-end mb-3">
                                        <div class="d-flex gap-2">
                                            <button class="btn btn-primary w-100" type="submit">
                                                <i class="fa fa-filter me-1"></i>Filter
                                            </button>
                                            <a href="{{ route('admin.provident-fund.reports.index') }}" class="btn btn-danger light w-100">
                                                Reset
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Summary Cards --}}
            <div class="col-xl-12">
                <div class="row">
                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body ">
                                <div class="pf-summary-label">Total Provident Fund</div>
                                <div class="pf-summary-value">{{ number_format($summary['total_balance'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Available + Locked Balance</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Available Balance</div>
                                <div class="pf-summary-value">{{ number_format($summary['available_balance'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Current usable balance</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Locked Balance</div>
                                <div class="pf-summary-value">{{ number_format($summary['locked_balance'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Pending locked amount</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Total Members</div>
                                <div class="pf-summary-value">{{ $summary['member_count'] ?? 0 }}</div>
                                <div class="pf-summary-sub">Employee + Teacher accounts</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Employee Contribution</div>
                                <div class="pf-summary-value">{{ number_format($summary['employee_contribution'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Total member contribution</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">School Contribution</div>
                                <div class="pf-summary-value">{{ number_format($summary['school_contribution'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Institution contribution</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Increment Credit</div>
                                <div class="pf-summary-value">{{ number_format($summary['increment_credit'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Policy based increment</div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xl-3 col-md-6 col-sm-6">
                        <div class="card pf-summary-card">
                            <div class="card-body">
                                <div class="pf-summary-label">Total Withdrawn</div>
                                <div class="pf-summary-value">{{ number_format($summary['total_withdrawn'] ?? 0) }}</div>
                                <div class="pf-summary-sub">Disbursed withdrawal amount</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Withdrawal Summary --}}
            <div class="col-xl-12">
                <div class="filter cm-content-box box-primary">
                    <div class="content-title SlideToolHeader">
                        <div class="cpa">
                            <i class="fa-solid fa-money-check-dollar me-2"></i>Withdrawal Summary
                        </div>
                        <div class="tools">
                            <a href="javascript:void(0);" class="expand handle"><i class="fal fa-angle-down"></i></a>
                        </div>
                    </div>

                    <div class="cm-content-body form excerpt">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-xl-3 col-md-6 col-sm-6">
                                    <div class="card bg-light">
                                        <div class="card-body">
                                            <div class="pf-summary-label">Pending Request Amount</div>
                                            <div class="pf-summary-value fs-28">{{ number_format($withdrawalStats['pending_amount'] ?? 0) }}</div>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-xl-3 col-md-6 col-sm-6">
                                    <div class="card bg-light">
                                        <div class="card-body">
                                            <div class="pf-summary-label">Approved Amount</div>
                                            <div class="pf-summary-value fs-28">{{ number_format($withdrawalStats['approved_amount'] ?? 0) }}</div>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-xl-3 col-md-6 col-sm-6">
                                    <div class="card bg-light">
                                        <div class="card-body">
                                            <div class="pf-summary-label">Completed Amount</div>
                                            <div class="pf-summary-value fs-28">{{ number_format($withdrawalStats['completed_amount'] ?? 0) }}</div>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-xl-3 col-md-6 col-sm-6">
                                    <div class="card bg-light">
                                        <div class="card-body">
                                            <div class="pf-summary-label">Pending Requests</div>
                                            <div class="pf-summary-value fs-28">{{ $withdrawalStats['pending_count'] ?? 0 }}</div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


            {{-- Member Report Table --}}
            <div class="col-xl-12">
                <div class="filter cm-content-box box-primary">
                    <div class="content-title SlideToolHeader">
                        <div class="cpa">
                            <i class="fa-solid fa-file-lines me-1"></i>Provident Fund Member Report
                        </div>
                        <div class="tools">
                            <a href="javascript:void(0);" class="expand handle"><i class="fal fa-angle-down"></i></a>
                        </div>
                    </div>

                    <div class="cm-content-body form excerpt">
                        <div class="card-body pb-4">
                            <div class="table-responsive">
                                <table class="table table-striped table-hover pf-table">
                                    <thead>
                                        <tr>
                                            <th>S.No</th>
                                            <th>Name</th>
                                            <th>Designation</th>
                                            <th>Code</th>
                                            <th class="text-end">Employee Contrib.</th>
                                            
                                            <th class="text-end">Increment</th>
                                            <th class="text-end">Withdrawn</th>
                                            <th class="text-end">Available</th>
                                            <th class="text-end">Locked</th>
                                            <th class="text-end">Total Balance</th>
                                            <th>Last Txn</th>
                                            <th>Last Increment</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse ($members as $key => $member)
                                            <tr>
                                                <td>{{ $key + 1 }}</td>
                                                <td>{{ $member['member_name'] ?? '-' }}</td>
                                                <td>{{ $member['member_designation'] ?? '-' }}</td>
                                                <td>{{ $member['member_code'] ?? '-' }}</td>
                                                <td class="text-end">{{ number_format($member['employee_contribution'] ?? 0) }}</td>
                                                {{-- <td class="text-end">{{ number_format($member['school_contribution'] ?? 0, 2) }}</td> --}}
                                                <td class="text-end">{{ number_format($member['increment_credit'] ?? 0) }}</td>
                                                <td class="text-end">{{ number_format($member['total_withdrawn'] ?? 0) }}</td>
                                                <td class="text-end">{{ number_format($member['available_balance'] ?? 0) }}</td>
                                                <td class="text-end">{{ number_format($member['locked_balance'] ?? 0) }}</td>
                                                <td class="text-end fw-bold">{{ number_format($member['total_balance'] ?? 0) }}</td>
                                                <td>
                                                    {{ !empty($member['last_transaction_at']) ? \Carbon\Carbon::parse($member['last_transaction_at'])->format('d M, Y h:i A') : '-' }}
                                                </td>
                                                <td>
                                                    {{ !empty($member['last_increment_at']) ? \Carbon\Carbon::parse($member['last_increment_at'])->format('d M, Y h:i A') : '-' }}
                                                </td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="13">
                                                    <div class="pf-empty-state">
                                                        <i class="fa fa-folder-open mb-3" style="font-size: 28px;"></i>
                                                        <div>No provident fund report data found.</div>
                                                    </div>
                                                </td>
                                            </tr>
                                        @endforelse
                                    </tbody>

                                    @if(($members ?? collect())->count() > 0)
                                        <tfoot>
                                            <tr>
                                                <th colspan="4" class="text-end">Grand Total</th>
                                                <th class="text-end">{{ number_format($summary['employee_contribution'] ?? 0) }}</th>
                                                {{-- <th class="text-end">{{ number_format($summary['school_contribution'] ?? 0, 2) }}</th> --}}
                                                <th class="text-end">{{ number_format($summary['increment_credit'] ?? 0) }}</th>
                                                <th class="text-end">{{ number_format($summary['total_withdrawn'] ?? 0) }}</th>
                                                <th class="text-end">{{ number_format($summary['available_balance'] ?? 0) }}</th>
                                                <th class="text-end">{{ number_format($summary['locked_balance'] ?? 0) }}</th>
                                                <th class="text-end">{{ number_format($summary['total_balance'] ?? 0) }}</th>
                                                <th colspan="2"></th>
                                            </tr>
                                        </tfoot>
                                    @endif
                                </table>

                                <div class="d-flex align-items-center justify-content-between flex-wrap mt-3">
                                    <p class="mb-2 me-3">
                                        Total {{ ($members ?? collect())->count() }} records found in provident fund report.
                                    </p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div>
    </div>
</div>

@endsection

@section('customjs')
@endsection