@extends('admin_dashboard')
@section('admin')

@php
    $date          = now()->toDateString();
    $current_month = now()->month;
    $current_year  = now()->year;

    // Daily works (today)
    use App\Models\DailyWorkInfo;
    use App\Models\LegalDocumentInfo;
    use App\Models\Group;
    use App\Models\Ledger_tran;
    use Carbon\Carbon;
    use Illuminate\Support\Facades\DB;

    $today     = Carbon::today()->toDateString();
    $works     = DailyWorkInfo::with(['member', 'workType', 'thanksUser'])->whereDate('work_date', $today)->latest()->get();
    $documents = LegalDocumentInfo::whereBetween('exp_ren_date', [
        Carbon::tomorrow()->startOfDay(),
        Carbon::today()->addDays(7)->endOfDay()
    ])->get();

    // Today's group-wise receive & payment
    $savingsLedgerCodes = [61, 62, 63, 64, 68, 129];
    $groups = Group::orderBy('group_code')->get();

    $groupTrans = DB::table('ledger_trans')
        ->whereDate('created_at', $today)
        ->whereIn('ledger_code', $savingsLedgerCodes)
        ->select(
            DB::raw('CAST(SUBSTRING(subledger_code, 2, 2) AS UNSIGNED) as group_code'),
            DB::raw('SUM(cr_amount) as total_receive'),
            DB::raw('SUM(dr_amount) as total_payment')
        )
        ->groupBy(DB::raw('CAST(SUBSTRING(subledger_code, 2, 2) AS UNSIGNED)'))
        ->get()
        ->keyBy('group_code');
@endphp

<style>
    .stat-card { border-radius: 14px; border: none; box-shadow: 0 2px 12px rgba(0,0,0,.07); transition: transform .2s, box-shadow .2s; }
    .stat-card:hover { transform: translateY(-4px); box-shadow: 0 8px 24px rgba(0,0,0,.12); }
    .stat-icon { width: 46px; height: 46px; border-radius: 12px; display: flex; align-items: center; justify-content: center; font-size: 1.25rem; flex-shrink: 0; }
    .stat-row { display: flex; flex-direction: column; gap: 4px; }
    .stat-row-item { display: flex; justify-content: space-between; align-items: center; font-size: .82rem; }
    .stat-row-item .label { color: #6b7280; }
    .stat-row-item .val   { font-weight: 700; color: #111827; font-size: .88rem; font-family: monospace; }
    .stat-title { font-size: .78rem; font-weight: 700; text-transform: uppercase; letter-spacing: .6px; margin-bottom: 10px; }
    .divider { border-top: 1px dashed #e5e7eb; margin: 8px 0; }

    .section-heading {
        font-size: .8rem; font-weight: 700; text-transform: uppercase; letter-spacing: .7px;
        color: #6b7280; margin-bottom: 14px; display: flex; align-items: center; gap: 8px;
    }
    .section-heading::after { content: ''; flex: 1; height: 1px; background: #e5e7eb; }

    #basic-datatable-works thead th,
    #basic-datatable-docs thead th  { font-size: .78rem; text-transform: uppercase; letter-spacing: .4px; white-space: nowrap; }
    #basic-datatable-works tbody td,
    #basic-datatable-docs tbody td  { font-size: .875rem; vertical-align: middle; }

    .expiry-badge { font-size: .72rem; font-weight: 600; padding: 3px 9px; border-radius: 20px; }
    .dash-page-title { font-size: 1.2rem; font-weight: 800; color: #111827; letter-spacing: -.3px; }
    .today-chip { background: #d1fae5; color: #065f46; font-size: .75rem; font-weight: 600; padding: 3px 10px; border-radius: 20px; }
</style>

<div class="content">
    <div class="container-fluid">

        {{-- ── Page header ── --}}
        <div class="d-flex align-items-center justify-content-between mb-4">
            <div>
                <div class="dash-page-title"><i class="bi bi-speedometer2 me-2 text-success"></i>Dashboard</div>
                <small class="text-muted">{{ now()->format('l, d F Y') }}</small>
            </div>
            <span class="today-chip"><i class="bi bi-circle-fill me-1" style="font-size:.5rem;"></i>Live</span>
        </div>

        

        {{-- ── Today's Group Transactions ── --}}
        <div class="section-heading"><i class="bi bi-people-fill text-primary"></i> Today's Group Receive & Payment</div>
        <div class="card shadow-sm mb-4" style="border-radius:14px; border:none;">
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0 w-100">
                        <thead style="background: linear-gradient(135deg,#3f4e2f,#325b10); color:#fff;">
                            <tr>
                                <th class="ps-3">#</th>
                                <th>Group Name</th>
                                <th class="text-end pe-3" style="color:#bbf7d0;">Today Receive (৳)</th>
                                <th class="text-end pe-3" style="color:#fecaca;">Today Payment (৳)</th>
                                <th class="text-end pe-3">Net (৳)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $grandReceive = 0;
                                $grandPayment = 0;
                            @endphp
                            @forelse($groups as $key => $group)
                            @php
                                $trans   = $groupTrans->get($group->group_code);
                                $receive = $trans ? floatval($trans->total_receive) : 0;
                                $payment = $trans ? floatval($trans->total_payment) : 0;
                                $net     = $receive - $payment;
                                $grandReceive += $receive;
                                $grandPayment += $payment;
                            @endphp
                            <tr>
                                <td class="ps-3 text-muted small">{{ $key + 1 }}</td>
                                <td class="fw-semibold">
                                    <span class="badge rounded-pill me-1" style="background:#dbeafe;color:#1e40af;font-size:.72rem;">{{ $group->group_code }}</span>
                                    {{ $group->group_name }}
                                </td>
                                <td class="text-end pe-3" style="color:{{ $receive > 0 ? '#16a34a' : '#9ca3af' }};font-weight:{{ $receive > 0 ? '700' : '400' }};font-family:monospace;">
                                    {{ $receive > 0 ? number_format($receive, 2) : '—' }}
                                </td>
                                <td class="text-end pe-3" style="color:{{ $payment > 0 ? '#dc2626' : '#9ca3af' }};font-weight:{{ $payment > 0 ? '700' : '400' }};font-family:monospace;">
                                    {{ $payment > 0 ? number_format($payment, 2) : '—' }}
                                </td>
                                <td class="text-end pe-3" style="font-weight:700;font-family:monospace;color:{{ $net >= 0 ? '#0369a1' : '#b91c1c' }};">
                                    {{ $net != 0 ? number_format($net, 2) : '—' }}
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="5" class="text-center py-4 text-muted">No groups found.</td>
                            </tr>
                            @endforelse
                        </tbody>
                        @if($groups->count() > 0)
                        <tfoot>
                            <tr style="background:#f0f9ff;font-weight:700;">
                                <td colspan="2" class="ps-3" style="font-size:.85rem;color:#1e40af;">TOTAL</td>
                                <td class="text-end pe-3" style="color:#16a34a;font-family:monospace;">{{ number_format($grandReceive, 2) }}</td>
                                <td class="text-end pe-3" style="color:#dc2626;font-family:monospace;">{{ number_format($grandPayment, 2) }}</td>
                                <td class="text-end pe-3" style="color:{{ ($grandReceive - $grandPayment) >= 0 ? '#0369a1' : '#b91c1c' }};font-family:monospace;">
                                    {{ number_format($grandReceive - $grandPayment, 2) }}
                                </td>
                            </tr>
                        </tfoot>
                        @endif
                    </table>
                </div>
            </div>
        </div>

        {{-- ── Today's Work ── --}}
        <div class="section-heading"><i class="bi bi-clipboard2-check-fill text-warning"></i> Today's Work</div>
        <div class="card shadow-sm mb-4" style="border-radius:14px; border:none;">
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table id="basic-datatable-works" class="table table-hover align-middle mb-0 w-100">
                        <thead style="background: linear-gradient(135deg,#78350f,#d97706); color:#fff;">
                            <tr>
                                <th class="ps-3">#</th>
                                <th>Date</th>
                                <th>Manpower</th>
                                <th>Work Type</th>
                                <th>Detail</th>
                                <th>Thanks By</th>
                                <th>Remarks</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($works as $key => $work)
                            <tr>
                                <td class="ps-3 text-muted small">{{ $key + 1 }}</td>
                                <td class="text-nowrap small text-muted">
                                    <i class="bi bi-calendar2 me-1"></i>
                                    {{ \Carbon\Carbon::parse($work->work_date)->format('d-m-Y') }}
                                </td>
                                <td class="fw-semibold">{{ $work->member->member_name ?? '—' }}</td>
                                <td>
                                    <span class="badge rounded-pill" style="background:#fef3c7; color:#92400e; font-weight:600; font-size:.75rem;">
                                        {{ $work->workType->work_name ?? '—' }}
                                    </span>
                                </td>
                                <td>{{ $work->details }}</td>
                                <td class="small text-muted">{{ $work->thanksUser->name ?? '—' }}</td>
                                <td class="small text-muted">{{ $work->remarks }}</td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="7" class="text-center py-4 text-muted">
                                    <i class="bi bi-clipboard2-x fs-3 d-block mb-1"></i>No work entries for today.
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        {{-- ── Expiring Documents ── --}}
        <div class="section-heading"><i class="bi bi-file-earmark-exclamation-fill text-danger"></i> Documents Expiring Within 7 Days</div>
        <div class="card shadow-sm mb-4" style="border-radius:14px; border:none;">
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table id="basic-datatable-docs" class="table table-hover align-middle mb-0 w-100">
                        <thead style="background: linear-gradient(135deg,#14532d,#16a34a); color:#fff;">
                            <tr>
                                <th class="ps-3">#</th>
                                <th>Document Type</th>
                                <th>Authority Name</th>
                                <th>Expiry / Renew Date</th>
                                <th>Days Left</th>
                                <th>Remarks</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($documents as $key => $document)
                            @php
                                $daysLeft = now()->diffInDays(\Carbon\Carbon::parse($document->exp_ren_date), false);
                                $badgeClass = $daysLeft <= 2 ? 'background:#fee2e2;color:#991b1b;' : 'background:#fef3c7;color:#92400e;';
                            @endphp
                            <tr>
                                <td class="ps-3 text-muted small">{{ $key + 1 }}</td>
                                <td class="fw-semibold">{{ $document->document_type }}</td>
                                <td>{{ $document->authority }}</td>
                                <td class="text-nowrap small">
                                    <i class="bi bi-calendar2-event me-1 text-danger"></i>
                                    {{ \Carbon\Carbon::parse($document->exp_ren_date)->format('d-m-Y') }}
                                </td>
                                <td>
                                    <span class="expiry-badge" style="{{ $badgeClass }}">
                                        {{ $daysLeft }} day{{ $daysLeft == 1 ? '' : 's' }}
                                    </span>
                                </td>
                                <td class="small text-muted">{{ $document->remarks }}</td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="6" class="text-center py-4 text-muted">
                                    <i class="bi bi-check-circle fs-3 d-block mb-1 text-success"></i>No documents expiring soon.
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

    </div>
</div>

@endsection