@extends('layouts.layout-horizontal')
@section('title', 'Customer Product Report')
@section('css')
<style>
    @media print {
        .pc-header, .pc-sidebar, .report-filter, .btn, footer, .movement-detail-section { display: none !important; }
        .pc-container, .pc-content, body { margin: 0 !important; background: #fff !important; }
        .card { border: none !important; box-shadow: none !important; }
        a { color: #111827 !important; text-decoration: none !important; }
    }
</style>
@endsection

@section('content')
<div class="card">
    <form method="GET" class="report-filter">
        <div class="filter-group">
            <label>From</label>
            <input type="date" name="start_date" value="{{ $startDate }}">
        </div>
        <div class="filter-group">
            <label>To</label>
            <input type="date" name="end_date" value="{{ $endDate }}">
        </div>
        <div class="filter-group" style="min-width:260px">
            <label>Client</label>
            <select name="party_id" class="form-select form-select-sm">
                <option value="">All Clients</option>
                @foreach($parties as $party)
                    <option value="{{ $party->id }}" @selected((string)$partyId === (string)$party->id)>{{ $party->name }}</option>
                @endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-primary filter-btn">
            <i class="ph-duotone ph-funnel"></i> Filter
        </button>
        @if($partyId)
            <a href="{{ request()->fullUrlWithQuery(['download' => 'pdf']) }}" target="_blank" class="btn btn-danger filter-btn">
                <i class="ph-duotone ph-file-pdf"></i> PDF
            </a>
            <button type="button" class="btn btn-secondary filter-btn" onclick="window.print()">
                <i class="ph-duotone ph-printer"></i> Print
            </button>
        @endif
    </form>
    <div class="card-body">
        @if($partyId)
        <div class="border rounded p-3 mb-3 bg-light">
            <div class="d-flex align-items-start justify-content-between flex-wrap gap-2 mb-2">
                <div>
                    <h5 class="mb-1">{{ $selectedParty->name ?? 'Selected Client' }} Product Reorder List</h5>
                    <div class="text-muted small">{{ \Carbon\Carbon::parse($startDate)->format('d-M-Y') }} to {{ \Carbon\Carbon::parse($endDate)->format('d-M-Y') }}</div>
                </div>
                <span class="badge bg-primary">{{ $summaryItems->count() }} products</span>
            </div>
            <div class="table-responsive">
                <table class="table table-sm table-hover align-middle mb-0">
                    <thead>
                        <tr>
                            <th>Product</th>
                            <th>Movement</th>
                            <th class="text-end">Total Qty</th>
                            <th class="text-end">Last Rate</th>
                            <th>Last Date</th>
                            <th class="text-end">Orders</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($summaryItems as $row)
                            <tr>
                                <td><a href="{{ route('products.edit', $row->product_id) }}" class="fw-semibold">{{ $row->product_name }}</a></td>
                                <td><span class="badge {{ $row->type === 'Sale' ? 'bg-success' : 'bg-primary' }}">{{ $row->type }}</span></td>
                                <td class="text-end">{{ indian_number($row->total_qty, 3) }}</td>
                                <td class="text-end">{{ indian_number($row->last_rate, 2) }}</td>
                                <td>{{ \Carbon\Carbon::parse($row->last_date)->format('d-M-Y') }}</td>
                                <td class="text-end">{{ $row->orders }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="6" class="text-center text-muted py-3">No products for this client.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        @endif
        <div class="movement-detail-section" data-st data-st-export="excel">
            <div class="table-responsive">
                <table class="table table-hover table-sm align-middle">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Client</th>
                            <th>Product</th>
                            <th>Type</th>
                            <th class="text-end">Rate</th>
                            <th class="text-end">Quantity</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($items as $item)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($item->date)->format('d-M-Y') }}</td>
                            <td>{{ $item->party_name }}</td>
                            <td>
                                <a href="{{ route('products.edit', $item->product_id) }}">{{ $item->product_name }}</a>
                            </td>
                            <td>
                                <span class="badge {{ $item->type === 'Sale' ? 'bg-success' : 'bg-primary' }}">{{ $item->type }}</span>
                            </td>
                            <td class="text-end">{{ indian_number($item->rate, 2) }}</td>
                            <td class="text-end">{{ indian_number($item->qty, 3) }}</td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="6" class="text-center text-muted py-4">No movements found for this filter.</td>
                        </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection