@extends('admin.layouts.app')

@section('title', 'Item Wise Sales Report')
@section('page_title', 'Item Wise Sales Report')

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Item Wise Sales Report</h5>
    </div>
    <div class="card-body">
        <form action="{{ route('item-wise-sales') }}" method="GET" class="mb-4">
            <div class="row">
                <div class="col-md-2">
                    <label class="form-label">From Date</label>
                    <input type="date" name="from_date" class="form-control" value="{{ $from_date }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">To Date</label>
                    <input type="date" name="to_date" class="form-control" value="{{ $to_date }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">Product Name</label>
                    <select name="product_name" class="form-select">
                        <option value="">All Products</option>
                        @foreach($allProducts as $product)
                            <option value="{{ $product->name }}" {{ $product_name == $product->name ? 'selected' : '' }}>{{ $product->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Filter</button>
                    <a href="{{ route('item-wise-sales') }}" class="btn btn-secondary ms-2">Reset</a>
                    <a href="{{ route('item-wise-sales.print', request()->query()) }}" target="_blank" class="btn btn-success ms-2">
                        <i class="bi bi-printer"></i> Print
                    </a>
                </div>
            </div>
        </form>

        <div class="row mb-4">
            <div class="col-md-4">
                <div class="card bg-primary text-white">
                    <div class="card-body text-center">
                        <h6>Total Amount</h6>
                        <h3>{{ number_format($totalAmount, 2) }}</h3>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-success text-white">
                    <div class="card-body text-center">
                        <h6>Total Quantity</h6>
                        <h3>{{ number_format($totalQty, 2) }}</h3>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-info text-white">
                    <div class="card-body text-center">
                        <h6>Avg Rate</h6>
                        <h3>{{ $totalQty > 0 ? number_format($totalAmount / $totalQty, 2) : '0.00' }}</h3>
                    </div>
                </div>
            </div>
        </div>

        <style>
    .report-table { font-size: 13px; }
    .report-table th, .report-table td { padding: 6px 8px; }
</style>

<div class="table-responsive">
            <table class="table table-bordered table-striped report-table">
                <thead class="table-dark">
                    <tr>
                        <th style="width: 50px;">Sl No</th>
                        <th>Shipment No</th>
                        <th>Invoice No</th>
                        <th>Customer Name</th>
                        <th>Branch</th>
                        <th>Product Code</th>
                        <th>Product Name</th>
                        <th class="text-center">Quantity</th>
                        <th class="text-center">Rate</th>
                        <th class="text-center">Amount</th>
                    </tr>
                </thead>
                <tbody>
                    @php $sl = 1; @endphp
                    @forelse($reportData as $row)
                        <tr>
                            <td>{{ $sl++ }}</td>
                            <td>{{ $row['shipment_number'] }}</td>
                            <td>{{ $row['invoice_no'] }}</td>
                            <td>{{ $row['customer_name'] }}</td>
                            <td>{{ $row['branch_name'] }}</td>
                            <td>{{ $row['product_code'] }}</td>
                            <td><strong>{{ $row['product_name'] }}</strong></td>
                            <td class="text-center">{{ number_format($row['quantity'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['rate'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['amount'], 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="10" class="text-center">No sales found for selected date range</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <th colspan="7" class="text-end">Total:</th>
                        <th class="text-center">{{ number_format($totalQty, 2) }}</th>
                        <th></th>
                        <th class="text-end">{{ number_format($totalAmount, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection