@extends('layouts.layout-horizontal')
@section('title', 'GST Purchase Return Report')

@section('content')
<div class="card">
    <form method="GET" class="report-filter">
        <div class="filter-group">
            <label>From</label>
            <input type="date" name="start_date" value="{{ $startDate }}">
        </div>
        <div class="filter-group">
            <label>To</label>
            <input type="date" name="end_date" value="{{ $endDate }}">
        </div>
        <button type="submit" class="btn btn-primary filter-btn">
            <i class="ph-duotone ph-funnel"></i> Filter
        </button>
    </form>
    <div class="card-body">
        <div data-st data-st-export="excel,print">
            <div class="table-responsive">
            <table class="table table-hover table-sm align-middle">
                <thead class="table-light">
                    <tr>
                        <th>Date</th>
                        <th>Bill No</th>
                        <th>Supplier</th>
                        <th>GSTIN</th>
                        <th>Reason</th>
                        <th>Product</th>
                        <th>HSN</th>
                        <th class="text-end">Qty</th>
                        <th class="text-end">Rate</th>
                        <th class="text-end">Taxable Amt</th>
                        <th class="text-end">Tax %</th>
                        <th class="text-end">Tax Amt</th>
                        <th class="text-end">Total</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($items as $item)
                    <tr>
                        <td>{{ \Carbon\Carbon::parse($item->invoice_date)->format('d-M-Y') }}</td>
                        <td>{{ $item->bill_no }}</td>
                        <td>{{ $item->supplier_name }}</td>
                        <td>{{ $item->supplier_gstin ?: '-' }}</td>
                        <td>
                            <span class="badge {{ $item->reason == 'damage' ? 'bg-danger' : 'bg-warning' }}">
                                {{ ucfirst($item->reason) }}
                            </span>
                        </td>
                        <td>{{ $item->product_name }}</td>
                        <td>{{ $item->hsn }}</td>
                        <td class="text-end">{{ indian_number($item->qty, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->rate, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->line_amount, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->tax_percent, 2) }}%</td>
                        <td class="text-end">{{ indian_number($item->line_tax_amount, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->line_total, 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light fw-bold">
                    <tr>
                        <td colspan="9" class="text-end">Totals:</td>
                        <td class="text-end">{{ indian_number($items->sum('line_amount'), 2) }}</td>
                        <td></td>
                        <td class="text-end">{{ indian_number($items->sum('line_tax_amount'), 2) }}</td>
                        <td class="text-end">{{ indian_number($items->sum('line_total'), 2) }}</td>
                    </tr>
                </tfoot>
            </table>
            </div>
        </div>
    </div>
</div>
@endsection