@extends('admin.layouts.app')

@section('title', 'Sales')
@section('page_title', 'Sale Management')

@section('content')
<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Sales List</h5>
            <a href="{{ route('sales.create') }}" class="btn btn-primary">
                <i class="fas fa-plus"></i> Add Sale
            </a>
        </div>
    </div>
    <div class="card-body">
        <form method="GET" class="row g-2 mb-3">
            <div class="col-md-3">
                <select name="customer_id" class="form-select form-select-sm" onchange="this.form.submit()">
                    <option value="">All Customers</option>
                    @foreach($customers as $customer)
                        <option value="{{ $customer->id }}" {{ request('customer_id') == $customer->id ? 'selected' : '' }}>{{ $customer->name }}</option>
                    @endforeach
                </select>
            </div>
        </form>
        <div class="table-responsive">
            <style>
                .sales-table { font-size: 12px; }
                .sales-table th { padding: 8px 5px; background: #3b82f6; color: white; }
                .sales-table td { padding: 6px 5px; vertical-align: middle; }
            </style>
            <table class="table table-bordered table-striped sales-table">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Date</th>
                        <th>Invoice No</th>
                        <th>Shipment No</th>
                        <th>Customer</th>
                        <th>Branch</th>
                        <th>Total</th>
                        <th>Discount</th>
                        <th>TDS</th>
                        <th>VDS</th>
                        <th>Paid</th>
                        <th>Due</th>
                        <th>Status</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($sales as $sale)
                        @php
                            $shipmentNumber = $sale->items->pluck('shipment_number')->filter()->unique()->implode(', ') ?: '-';
                        @endphp
                        <tr>
                            <td>{{ $sale->id }}</td>
                            <td>{{ date('d-m-Y', strtotime($sale->date)) }}</td>
                            <td>{{ $sale->invoice_no }}</td>
                            <td>{{ $shipmentNumber }}</td>
                            <td>{{ $sale->customer->name ?? 'N/A' }}</td>
                            <td>{{ $sale->branch->name ?? '-' }}</td>
                            <td>{{ number_format($sale->total, 2) }}</td>
                            <td>{{ number_format($sale->discount ?? 0, 2) }}</td>
                            <td>{{ number_format($sale->tds ?? 0, 2) }}</td>
                            <td>{{ number_format($sale->vds ?? 0, 2) }}</td>
                            <td>{{ number_format($sale->paid, 2) }}</td>
                            <td>{{ number_format($sale->due, 2) }}</td>
                            <td>
                                @if($sale->status == 'completed')
                                    <span class="badge bg-success">Completed</span>
                                @elseif($sale->status == 'pending')
                                    <span class="badge bg-warning">Pending</span>
                                @else
                                    <span class="badge bg-secondary">{{ ucfirst($sale->status) }}</span>
                                @endif
                            </td>
                            <td>
                                <a href="{{ route('sales.show', $sale->id) }}" class="btn btn-sm btn-info">
                                    <i class="fas fa-eye"></i>
                                </a>
                                <a href="{{ route('sales.print', $sale->id) }}" class="btn btn-sm btn-secondary" target="_blank">
                                    <i class="fas fa-print"></i>
                                </a>
                                <a href="{{ route('sales.edit', $sale->id) }}" class="btn btn-sm btn-warning">
                                    <i class="fas fa-edit"></i>
                                </a>
                                <form action="{{ route('sales.destroy', $sale->id) }}" method="POST" style="display:inline;">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')">
                                        <i class="fas fa-trash"></i>
                                    </button>
                                </form>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="14" class="text-center">No sales found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="fw-bold" style="background: #e9ecef;">
                        <td colspan="6" class="text-end">Total:</td>
                        <td>{{ number_format($totalSum, 2) }}</td>
                        <td>{{ number_format($discountSum, 2) }}</td>
                        <td>{{ number_format($tdsSum, 2) }}</td>
                        <td>{{ number_format($vdsSum, 2) }}</td>
                        <td>{{ number_format($paidSum, 2) }}</td>
                        <td>{{ number_format($dueSum, 2) }}</td>
                        <td colspan="2"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        {{ $sales->links() }}
    </div>
</div>
@endsection