@extends('layouts.layout-horizontal')
@section('title', 'HSN 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>HSN Code</th>
                        <th class="text-end">Total Quantity</th>
                        <th class="text-end">Taxable Value</th>
                        <th class="text-end">Tax Amount</th>
                        <th class="text-end">Total Value</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($hsnData as $row)
                    <tr>
                        <td>{{ $row->hsn }}</td>
                        <td class="text-end">{{ indian_number($row->total_qty, 2) }}</td>
                        <td class="text-end">{{ indian_number($row->taxable_value, 2) }}</td>
                        <td class="text-end">{{ indian_number($row->tax_amount, 2) }}</td>
                        <td class="text-end">{{ indian_number($row->total_value, 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light fw-bold">
                    <tr>
                        <td class="text-end">Totals:</td>
                        <td class="text-end">{{ indian_number($hsnData->sum('total_qty'), 2) }}</td>
                        <td class="text-end">{{ indian_number($hsnData->sum('taxable_value'), 2) }}</td>
                        <td class="text-end">{{ indian_number($hsnData->sum('tax_amount'), 2) }}</td>
                        <td class="text-end">{{ indian_number($hsnData->sum('total_value'), 2) }}</td>
                    </tr>
                </tfoot>
            </table>
            </div>
        </div>
    </div>
</div>
@endsection