@extends('layouts.app') @section('title', 'Item Details - Sales Report') @section('content')

Item Details - {{ $summary['item_name'] }}

Sales details for {{ $summary['item_name'] }}

Item Information
{{ $summary['item_name'] }}
Item Name
{{ $summary['item_description'] ?? 'N/A' }}
Description
{{ $summary['unit'] ?? 'N/A' }}
Unit
{{ $summary['total_sales'] }}
Total Sales
{{ $summary['total_invoices'] }}
Total Invoices
{{ number_format($summary['total_quantity'], 2) }}
Total Quantity
${{ number_format($summary['total_amount'], 2) }}
Total Amount
${{ number_format($summary['average_price'], 2) }}
Avg Price
Sales Details
@if($itemSales->count() > 0)
@foreach($itemSales as $sale) @php $invoice = $sale->salesInvoice; $paid = $invoice->transections()->where('transaction_type', 'payment')->sum('amount'); $due = $invoice->invoice_amount - $paid; $status = $due <= 0 ? 'paid' : ($due < $invoice->invoice_amount ? 'partial' : 'unpaid'); @endphp @endforeach
Invoice No Customer Invoice Date Quantity Rate Line Total Invoice Amount Invoice Paid Invoice Due Status Actions
{{ $invoice->invoice_no }}
{{ $invoice->customer->company_name ?? $invoice->customer->name }}
{{ $invoice->customer->email }}
{{ \Carbon\Carbon::parse($invoice->invoice_date)->format('M d, Y') }}
{{ \Carbon\Carbon::parse($invoice->invoice_date)->format('h:i A') }}
{{ number_format($sale->quantity, 2) }} ${{ number_format($sale->rate, 2) }} ${{ number_format($sale->total_amount, 2) }} ${{ number_format($invoice->invoice_amount, 2) }} ${{ number_format($paid, 2) }} ${{ number_format($due, 2) }} @if($status === 'paid') Paid @elseif($status === 'partial') Partial @else Unpaid @endif
@else
No Sales Found

No sales found for this item in the selected date range.

@endif
@endsection @section('styles') @endsection