@extends('layouts.app')
@section('title','Purchase History')
@section('content')
@php($uae=fn($t)=>\Illuminate\Support\Carbon::parse($t,'UTC')->setTimezone('Asia/Dubai')->format('d M Y'))
@php($keep=fn(array $extra)=>route('sales.history.index',array_filter(array_merge(request()->only(['q','customer_q','from','to','include_void']),$extra),fn($v)=>$v!==null&&$v!=='')))
<style>
.hist-filter{display:grid;grid-template-columns:repeat(auto-fit,minmax(170px,1fr));gap:10px;align-items:end}.hist-filter label{display:grid;gap:6px;font-size:12px;color:var(--sub)}
.hist-neg{color:#b42318}.hist-tag{display:inline-flex;padding:3px 8px;border-radius:999px;font-size:11px;font-weight:700;background:var(--bg);border:1px solid var(--border)}
.hist-chips{display:flex;gap:8px;flex-wrap:wrap;margin-bottom:14px}
@media(max-width:650px){.pagetop{flex-direction:column}}
</style>
<div class="pagetop"><div><div class="eyebrow">Sales / Purchase History</div><h1>Purchase History</h1><p class="desc">{{ $company->name }} — what each customer bought and who bought each product, from posted invoice and return lines</p></div></div>
@if($errors->any())<div class="note" role="alert">{{ $errors->first() }}</div>@endif
<div class="hist-chips">
@if(!empty($filters['customer_id']))<span class="hist-tag">Customer: {{ $customer ? $customer->name.' ('.$customer->code.')' : 'no visible purchases' }}</span><a class="btn" href="{{ $keep(['product_id'=>$filters['product_id']??null]) }}">Clear customer</a>@endif
@if(!empty($filters['product_id']))<span class="hist-tag">Product: {{ $product ? $product->sku.' · '.$product->name : 'no visible sales' }}</span><a class="btn" href="{{ $keep(['customer_id'=>$filters['customer_id']??null]) }}">Clear product</a>@endif
</div>
<div class="panel" style="padding:16px;margin-bottom:18px"><form method="GET" class="hist-filter">
@if(!empty($filters['customer_id']))<input type="hidden" name="customer_id" value="{{ $filters['customer_id'] }}">@endif
@if(!empty($filters['product_id']))<input type="hidden" name="product_id" value="{{ $filters['product_id'] }}">@endif
<label>Product (SKU, name or barcode)<input name="q" value="{{ request('q') }}"></label>
<label>Customer (name or code)<input name="customer_q" value="{{ request('customer_q') }}"></label>
<label>From<input type="date" name="from" value="{{ request('from') }}"></label>
<label>To<input type="date" name="to" value="{{ request('to') }}"></label>
<label style="display:flex;gap:6px;align-items:center"><input type="checkbox" name="include_void" value="1" @checked($filters['include_void'])> Show void invoices</label>
<div style="display:flex;gap:8px"><button class="btn primary">Search</button><a class="btn" href="{{ route('sales.history.index') }}">Reset</a></div>
</form><small class="quiet">Dates are invoice dates (UAE) and return receipt dates. Amounts are invoice values including VAT, not cash collected.</small></div>

@forelse($totals as $currency=>$t)
<div class="stats" style="margin-bottom:18px">
<div class="panel stat"><label>Sales ({{ $currency }})</label><div class="value">{{ number_format((float)$t['sales'],2) }}</div></div>
<div class="panel stat"><label>Returns</label><div class="value hist-neg">{{ number_format((float)$t['returns'],2) }}</div></div>
<div class="panel stat"><label>Net incl. VAT</label><div class="value">{{ number_format((float)$t['net'],2) }}</div></div>
<div class="panel stat"><label>Net quantity</label><div class="value">{{ \App\Support\StockQuantity::display($t['net_quantity']) }}</div></div>
</div>
@empty
<div class="note" style="margin-bottom:18px">No purchases match these filters within your access.</div>
@endforelse

@if($by && $summary->count())
<div class="sectionhead"><div><h2>{{ $by==='product'?'Products bought by this customer':'Customers who bought this product' }}</h2><small>Open a row to see its invoices.</small></div></div>
<div class="panel tablewrap" style="margin-bottom:20px"><table class="data"><thead><tr><th>{{ $by==='product'?'Product':'Customer' }}</th><th>Net qty</th><th>Net amount</th><th>Last purchase</th><th>Invoice lines</th></tr></thead><tbody>
@foreach($summary as $row)<tr>
<td>@if($by==='product')<a href="{{ $keep(['customer_id'=>$filters['customer_id'],'product_id'=>$row->company_product_id]) }}"><strong>{{ $row->sku }}</strong></a><br><span class="quiet">{{ $row->name }}</span>@else<a href="{{ $keep(['product_id'=>$filters['product_id'],'customer_id'=>$row->customer_id]) }}"><strong>{{ $row->customer_name }}</strong></a><br><span class="quiet">{{ $row->customer_code }}</span>@endif</td>
<td>{{ \App\Support\StockQuantity::display(number_format((float)$row->quantity,4,'.','')) }}</td><td>{{ $row->currency }} {{ number_format((float)$row->total,2) }}</td><td>{{ $row->last_purchase_at ? $uae($row->last_purchase_at) : '—' }}</td><td>{{ $row->invoice_lines }}</td></tr>@endforeach
</tbody></table></div>
@endif

<div class="sectionhead"><div><h2>Invoice and return lines</h2><small>{{ $lines->total() }} line(s)</small></div></div>
<div class="panel tablewrap"><table class="data"><thead><tr><th>Date</th><th>Document</th><th>Customer</th><th>Product</th><th>Qty</th><th>Unit price</th><th>Discount</th><th>Net</th><th>VAT</th><th>Total</th></tr></thead><tbody>
@forelse($lines as $line)
<tr><td>{{ $uae($line->document_at) }}</td>
<td>@if($line->kind==='invoice')<a href="{{ route('sales.orders.show',$line->document_id) }}">Invoice {{ $line->document_number }}</a>@if($line->status==='void') <span class="hist-tag hist-neg">Void</span>@endif @else<a href="{{ route('sales.returns.show',$line->document_id) }}">Return {{ $line->document_number }}</a>@endif</td>
<td><a href="{{ $keep(['customer_id'=>$line->customer_id,'product_id'=>$filters['product_id']??null]) }}">{{ $line->customer_name }}</a><br><span class="quiet">{{ $line->customer_code }}</span></td>
<td><a href="{{ $keep(['product_id'=>$line->company_product_id,'customer_id'=>$filters['customer_id']??null]) }}">{{ $line->sku_snapshot }}</a><br><span class="quiet">{{ $line->name_snapshot }}</span></td>
<td class="{{ (float)$line->quantity<0?'hist-neg':'' }}">{{ \App\Support\StockQuantity::display(number_format((float)$line->quantity,4,'.','')) }}</td><td>{{ number_format((float)$line->gross_unit_price,4) }}</td><td>{{ $line->discount_amount===null?'—':number_format((float)$line->discount_amount,2) }}</td>
<td>{{ number_format((float)$line->taxable_amount,2) }}</td><td>{{ number_format((float)$line->vat_amount,2) }}</td><td class="{{ (float)$line->line_total<0?'hist-neg':'' }}"><strong>{{ $line->currency }} {{ number_format((float)$line->line_total,2) }}</strong></td></tr>
@empty<tr><td colspan="10" class="emptytable">No lines.</td></tr>@endforelse
</tbody></table></div>
<div style="margin-top:14px">{{ $lines->links() }}</div>
@endsection