@extends('setting.nav')

@section('title', 'Product Master')

@section('content')
    <div class="container-fluid mt-4">

        <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-3">
            <div>
                <h4 class="mb-1">Product Master</h4>
                <p class="text-muted mb-0" style="font-size:.875rem;">
                    What you sell, and for how much. A mail classified <strong>Pricing Enquiry</strong> says
                    somebody wants a price; these rows are where that price comes from, and a quotation line
                    will point at one of them.
                    The catalogue belongs to the account — everyone in your team sees the same list, and only
                    an administrator can change it.
                </p>
            </div>
            @if ($isAdmin)
                <button class="btn btn-primary" type="button" data-bs-toggle="modal" data-bs-target="#addProduct">
                    <i class="bi bi-plus-lg me-1"></i>Add product
                </button>
            @endif
        </div>

        @if (session('success'))
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                {{ session('success') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif

        @if (session('error'))
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                {{ session('error') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif

        @if ($errors->any())
            <div class="alert alert-danger">
                <strong>Please fix the following:</strong>
                <ul class="mb-0 mt-1">
                    @foreach ($errors->all() as $error)
                        <li>{{ $error }}</li>
                    @endforeach
                </ul>
            </div>
        @endif

        {{-- A catalogue that is entirely switched off looks fine on this screen —
             every row is present, just grey — and the consequence only appears
             on the reply screen as "nothing can be quoted". Said here instead,
             where the switches are. --}}
        @php
            $activeCount = $products->where('is_active', true)->count();
        @endphp

        @if ($products->isNotEmpty() && $activeCount === 0 && $search === '')
            <div class="alert alert-warning">
                <strong>None of your {{ $products->count() }}
                    {{ $products->count() === 1 ? 'product is' : 'products are' }} active.</strong>
                Inactive products are not offered to the AI and cannot be quoted, so
                <strong>Prepare quotation</strong> on a pricing enquiry will have nothing to work from.
                Switch at least one on with the tick in the Active column.
            </div>
        @endif

        {{-- Units offered as suggestions rather than a closed list: a business
             with its own unit should not have to pick the wrong one. --}}
        <datalist id="productUnits">
            @foreach ($units as $unit)
                <option value="{{ $unit }}"></option>
            @endforeach
        </datalist>

        <div class="row g-4">

            {{-- ============================ CATALOGUE ============================ --}}
            <div class="col-xl-8">
                <div class="card shadow-sm">
                    <div class="card-header d-flex flex-wrap align-items-center justify-content-between gap-2">
                        <h6 class="mb-0">
                            Products
                            <span class="text-muted fw-normal">({{ number_format($products->count()) }})</span>
                        </h6>
                        <form action="{{ route('products.index') }}" method="GET" class="d-flex gap-2 m-0">
                            <input type="search" class="form-control form-control-sm" name="q"
                                value="{{ $search }}" placeholder="Code, name or alias" style="min-width:14rem;">
                            <button class="btn btn-sm btn-outline-secondary" type="submit">Search</button>
                            @if ($search !== '')
                                <a class="btn btn-sm btn-link" href="{{ route('products.index') }}">Clear</a>
                            @endif
                        </form>
                    </div>

                    <div class="card-body p-0">
                        <div class="table-responsive">
                            <table class="table table-hover align-middle mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th style="min-width:16rem;">Product</th>
                                        <th style="min-width:7rem;">Code</th>
                                        <th class="text-end" style="min-width:9rem;"
                                            title="The price that applies today at quantity 1">Price today</th>
                                        <th class="text-end">Tax</th>
                                        <th>Unit</th>
                                        <th class="text-center">Active</th>
                                        <th class="text-end" style="min-width:9rem;">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($products as $product)
                                        @php
                                            // Priced from the loaded relation so the whole
                                            // catalogue costs one pricing query, not one per row.
                                            $current = $product->priceOn($today, 1);
                                            $bands = $product->pricing
                                                ->where('is_active', true)
                                                ->sortBy([['minimum_quantity', 'asc'], ['valid_from', 'desc']]);
                                        @endphp
                                        <tr>
                                            <td>
                                                <div class="fw-semibold">{{ $product->name }}</div>
                                                @if ($product->description)
                                                    <div class="text-muted mt-1" style="font-size:.8125rem;">
                                                        {{ \Illuminate\Support\Str::limit($product->description, 110) }}
                                                    </div>
                                                @endif
                                                @if ($product->ai_aliases)
                                                    <div class="text-muted mt-1" style="font-size:.75rem;">
                                                        also matches: {{ $product->ai_aliases }}
                                                    </div>
                                                @endif
                                            </td>
                                            <td><code>{{ $product->product_code }}</code></td>
                                            <td class="text-end text-nowrap">
                                                @if ($current)
                                                    <span class="fw-semibold">
                                                        {{ number_format((float) $current->price, 2) }}
                                                    </span>
                                                    <span class="text-muted">{{ $current->currency }}</span>
                                                    @if ($bands->count() > 1)
                                                        <div class="text-muted" style="font-size:.75rem;">
                                                            {{ $bands->count() }} price bands
                                                        </div>
                                                    @endif
                                                @else
                                                    {{-- No applicable price is a real state, not a zero:
                                                         nothing can be quoted from this product today. --}}
                                                    <span class="badge bg-warning text-dark">No price today</span>
                                                @endif
                                            </td>
                                            <td class="text-end text-nowrap">
                                                {{ rtrim(rtrim(number_format((float) $product->tax_percentage, 2), '0'), '.') }}%
                                            </td>
                                            <td class="text-nowrap">{{ $product->unit }}</td>
                                            <td class="text-center">
                                                @if ($isAdmin)
                                                    <form action="{{ route('products.toggle', $product->id) }}"
                                                        method="POST" class="m-0">
                                                        @csrf
                                                        <button type="submit"
                                                            class="btn btn-sm {{ $product->is_active ? 'btn-success' : 'btn-outline-secondary' }}"
                                                            title="{{ $product->is_active ? 'Deactivate' : 'Activate' }}">
                                                            <i class="bi {{ $product->is_active ? 'bi-check-lg' : 'bi-dash-lg' }}"></i>
                                                        </button>
                                                    </form>
                                                @else
                                                    <span class="badge {{ $product->is_active ? 'bg-success' : 'bg-secondary' }}">
                                                        {{ $product->is_active ? 'Active' : 'Inactive' }}
                                                    </span>
                                                @endif
                                            </td>
                                            <td class="text-end text-nowrap">
                                                <button class="btn btn-sm btn-outline-secondary" type="button"
                                                    data-bs-toggle="collapse"
                                                    data-bs-target="#prices{{ $product->id }}"
                                                    title="Price history and quantity bands">
                                                    <i class="bi bi-clock-history"></i>
                                                </button>
                                                @if ($isAdmin)
                                                    <button class="btn btn-sm btn-outline-secondary" type="button"
                                                        data-bs-toggle="modal"
                                                        data-bs-target="#editProduct{{ $product->id }}">
                                                        Edit
                                                    </button>
                                                    <form action="{{ route('products.destroy', $product->id) }}"
                                                        method="POST" class="d-inline"
                                                        onsubmit="return confirm('Delete {{ $product->name }} and its {{ $product->pricing->count() }} price record(s)?\n\nDeactivating it instead keeps the history and stops it being quoted.');">
                                                        @csrf
                                                        @method('DELETE')
                                                        <button class="btn btn-sm btn-outline-danger" type="submit">
                                                            <i class="bi bi-trash"></i>
                                                        </button>
                                                    </form>
                                                @endif
                                            </td>
                                        </tr>

                                        {{-- The price book for one product: every band and every
                                             window, current and historic. This is the evidence
                                             behind a quotation, so withdrawn rows stay visible. --}}
                                        <tr class="collapse" id="prices{{ $product->id }}">
                                            <td colspan="7" class="bg-light">
                                                <div class="p-2">
                                                    <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-2">
                                                        <strong style="font-size:.875rem;">
                                                            Price book — {{ $product->product_code }}
                                                        </strong>
                                                        @if ($isAdmin)
                                                            <button class="btn btn-sm btn-outline-primary" type="button"
                                                                data-bs-toggle="modal"
                                                                data-bs-target="#addPrice{{ $product->id }}">
                                                                <i class="bi bi-plus-lg me-1"></i>Add a price
                                                            </button>
                                                        @endif
                                                    </div>

                                                    <table class="table table-sm mb-0 bg-white">
                                                        <thead>
                                                            <tr>
                                                                <th class="text-end">Price</th>
                                                                <th>Quantity</th>
                                                                <th>Applies</th>
                                                                <th>Source</th>
                                                                <th class="text-center">State</th>
                                                                @if ($isAdmin)
                                                                    <th class="text-end"></th>
                                                                @endif
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            @forelse ($product->pricing as $price)
                                                                <tr class="{{ $price->is_active ? '' : 'text-muted' }}">
                                                                    <td class="text-end text-nowrap">
                                                                        {{ number_format((float) $price->price, 2) }}
                                                                        <span class="text-muted">{{ $price->currency }}</span>
                                                                    </td>
                                                                    <td class="text-nowrap">{{ $price->bandLabel() }}</td>
                                                                    <td class="text-nowrap">{{ $price->windowLabel() }}</td>
                                                                    <td class="text-nowrap" style="font-size:.8125rem;">
                                                                        @if ($price->source === \App\Models\ProductPricing::SOURCE_IMPORT)
                                                                            <span class="text-muted">
                                                                                Import
                                                                                @if ($price->import_id)
                                                                                    <a href="{{ route('products.imports.show', $price->import_id) }}"
                                                                                        title="The run that wrote this price">#{{ $price->import_id }}</a>
                                                                                @endif
                                                                            </span>
                                                                        @else
                                                                            <span class="text-muted">Entered</span>
                                                                        @endif
                                                                    </td>
                                                                    <td class="text-center text-nowrap">
                                                                        @if (!$price->is_active)
                                                                            <span class="badge bg-secondary">Withdrawn</span>
                                                                        @elseif ($current && $current->id === $price->id)
                                                                            <span class="badge bg-success">Quoted today</span>
                                                                        @elseif ($price->isCurrent())
                                                                            <span class="badge bg-info text-dark"
                                                                                title="In force, but another band applies at quantity 1">
                                                                                In force
                                                                            </span>
                                                                        @elseif ($price->valid_from && $price->validFromDate() > $today)
                                                                            <span class="badge bg-primary">Future</span>
                                                                        @else
                                                                            <span class="badge bg-light text-dark">Expired</span>
                                                                        @endif
                                                                    </td>
                                                                    @if ($isAdmin)
                                                                        <td class="text-end">
                                                                            @if ($price->is_active)
                                                                                <form
                                                                                    action="{{ route('products.prices.destroy', [$product->id, $price->id]) }}"
                                                                                    method="POST" class="d-inline"
                                                                                    onsubmit="return confirm('Withdraw this price?\n\nIt stays on file so quotations that used it can still be explained.');">
                                                                                    @csrf
                                                                                    @method('DELETE')
                                                                                    <button class="btn btn-sm btn-outline-danger"
                                                                                        type="submit" title="Withdraw">
                                                                                        <i class="bi bi-x-lg"></i>
                                                                                    </button>
                                                                                </form>
                                                                            @endif
                                                                        </td>
                                                                    @endif
                                                                </tr>
                                                            @empty
                                                                <tr>
                                                                    <td colspan="6" class="text-muted">
                                                                        No prices on file — nothing can be quoted from
                                                                        this product.
                                                                    </td>
                                                                </tr>
                                                            @endforelse
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="7" class="text-center text-muted py-4">
                                                @if ($search !== '')
                                                    Nothing matches "{{ $search }}".
                                                @else
                                                    No products yet. Add one, or import your price list from a
                                                    spreadsheet on the right.
                                                @endif
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>

            {{-- ============================== IMPORT ============================== --}}
            <div class="col-xl-4">

                @if ($isAdmin)
                    <div class="card shadow-sm mb-4">
                        <div class="card-header">
                            <h6 class="mb-0">Import a price list</h6>
                        </div>
                        <div class="card-body">
                            <p class="text-muted" style="font-size:.8125rem;">
                                Rows are matched on <strong>product code</strong>: a code you already have is
                                updated, a new one is created. Nothing is ever deleted by an import — a partial
                                price list is normal, and an omission is not a retirement.
                            </p>

                            <form action="{{ route('products.import') }}" method="POST"
                                enctype="multipart/form-data" class="mb-3">
                                @csrf
                                <label class="form-label" for="importFile">Excel or CSV file</label>
                                <input type="file" class="form-control mb-2" id="importFile" name="file"
                                    accept=".xlsx,.xls,.csv,.ods" required>
                                <button class="btn btn-primary w-100" type="submit">
                                    <i class="bi bi-upload me-1"></i>Upload and import
                                </button>
                            </form>

                            <hr>

                            <form action="{{ route('products.import.drive') }}" method="POST">
                                @csrf
                                <label class="form-label" for="driveLink">Google Drive or Sheets link</label>
                                <input type="url" class="form-control mb-2" id="driveLink" name="link"
                                    value="{{ old('link') }}"
                                    placeholder="https://docs.google.com/spreadsheets/d/..." required>
                                <div class="form-text mb-2">
                                    The file has to be shared as <strong>Anyone with the link</strong> — otherwise
                                    Google serves a sign-in page instead of the data.
                                </div>
                                <button class="btn btn-outline-primary w-100" type="submit">
                                    <i class="bi bi-cloud-download me-1"></i>Fetch and import
                                </button>
                            </form>

                            <hr>

                            <a class="btn btn-sm btn-link px-0" href="{{ route('products.sample') }}">
                                <i class="bi bi-file-earmark-arrow-down me-1"></i>Download the sample workbook
                            </a>
                            <div class="text-muted" style="font-size:.75rem;">
                                Column names are matched loosely — "Product Code", "SKU" and "Item Code" all work,
                                and the header row does not have to be the first row.
                            </div>
                        </div>
                    </div>
                @endif

                <div class="card shadow-sm">
                    <div class="card-header">
                        <h6 class="mb-0">Import history</h6>
                    </div>
                    <div class="card-body p-0">
                        <div class="list-group list-group-flush">
                            @forelse ($imports as $run)
                                <a class="list-group-item list-group-item-action"
                                    href="{{ route('products.imports.show', $run->id) }}">
                                    <div class="d-flex justify-content-between align-items-start gap-2">
                                        <div>
                                            <div class="fw-semibold" style="font-size:.875rem;">
                                                {{ \Illuminate\Support\Str::limit($run->file_name, 40) }}
                                            </div>
                                            <div class="text-muted" style="font-size:.75rem;">
                                                {{ $run->created_at?->format('d M Y H:i') }}
                                                · {{ $run->source === \App\Models\PricingImport::SOURCE_DRIVE ? 'Google Drive' : 'Upload' }}
                                            </div>
                                            <div class="text-muted mt-1" style="font-size:.75rem;">
                                                {{ $run->summaryLine() }}
                                            </div>
                                        </div>
                                        <span class="badge bg-{{ $run->statusClass() }} text-nowrap">
                                            {{ ucfirst($run->status) }}
                                        </span>
                                    </div>
                                </a>
                            @empty
                                <div class="list-group-item text-muted" style="font-size:.875rem;">
                                    No imports yet. Every run is recorded here with its counts and any rejected
                                    rows, so a price that looks wrong can be traced to the file that set it.
                                </div>
                            @endforelse
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- ============================== MODALS ============================== --}}
    @if ($isAdmin)
        <div class="modal fade" id="addProduct" tabindex="-1" aria-hidden="true">
            <div class="modal-dialog modal-lg modal-dialog-scrollable">
                <form class="modal-content" action="{{ route('products.store') }}" method="POST">
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title">Add a product</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body">
                        @include('products._fields', ['product' => null])
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-primary">Add product</button>
                    </div>
                </form>
            </div>
        </div>

        @foreach ($products as $product)
            <div class="modal fade" id="editProduct{{ $product->id }}" tabindex="-1" aria-hidden="true">
                <div class="modal-dialog modal-lg modal-dialog-scrollable">
                    <form class="modal-content" action="{{ route('products.update', $product->id) }}" method="POST">
                        @csrf
                        @method('PUT')
                        <div class="modal-header">
                            <h5 class="modal-title">{{ $product->name }}</h5>
                            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                        </div>
                        <div class="modal-body">
                            @include('products._fields', ['product' => $product])
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button>
                            <button type="submit" class="btn btn-primary">Save changes</button>
                        </div>
                    </form>
                </div>
            </div>

            <div class="modal fade" id="addPrice{{ $product->id }}" tabindex="-1" aria-hidden="true">
                <div class="modal-dialog">
                    <form class="modal-content" action="{{ route('products.prices.store', $product->id) }}"
                        method="POST">
                        @csrf
                        <div class="modal-header">
                            <h5 class="modal-title">Add a price — {{ $product->product_code }}</h5>
                            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                        </div>
                        <div class="modal-body">
                            <p class="text-muted" style="font-size:.8125rem;">
                                A price is added, never edited. Whatever this replaces is closed the day before
                                this one starts and kept on file — so a quotation raised last month still adds
                                up at last month's figure.
                            </p>

                            <div class="row g-3">
                                <div class="col-6">
                                    <label class="form-label" for="price{{ $product->id }}">Price</label>
                                    <input type="number" class="form-control" id="price{{ $product->id }}"
                                        name="price" step="0.01" min="0" required>
                                </div>
                                <div class="col-6">
                                    <label class="form-label" for="priceCurrency{{ $product->id }}">Currency</label>
                                    <select class="form-select" id="priceCurrency{{ $product->id }}" name="currency">
                                        @foreach ($currencies as $currency)
                                            <option value="{{ $currency }}"
                                                @selected($product->currency === $currency)>{{ $currency }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-6">
                                    <label class="form-label" for="minQty{{ $product->id }}">Quantity from</label>
                                    <input type="number" class="form-control" id="minQty{{ $product->id }}"
                                        name="minimum_quantity" min="1" value="1" required>
                                </div>
                                <div class="col-6">
                                    <label class="form-label" for="maxQty{{ $product->id }}">Quantity up to</label>
                                    <input type="number" class="form-control" id="maxQty{{ $product->id }}"
                                        name="maximum_quantity" min="1" placeholder="No limit">
                                    <div class="form-text">
                                        Leave blank for "and up". A narrower band wins over a wider one.
                                    </div>
                                </div>
                                <div class="col-6">
                                    <label class="form-label" for="from{{ $product->id }}">Applies from</label>
                                    <input type="date" class="form-control" id="from{{ $product->id }}"
                                        name="valid_from" value="{{ $today }}" required>
                                </div>
                                <div class="col-6">
                                    <label class="form-label" for="to{{ $product->id }}">Applies until</label>
                                    <input type="date" class="form-control" id="to{{ $product->id }}"
                                        name="valid_to">
                                    <div class="form-text">Blank = until further notice.</div>
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button>
                            <button type="submit" class="btn btn-primary">Add price</button>
                        </div>
                    </form>
                </div>
            </div>
        @endforeach
    @endif
@endsection