@extends('layouts.app')

@section('content')
<div class="container">
    <h4>Stock & Sales Summary Report</h4>
    
<form method="GET" action="{{ route('stocksalessumm.index') }}" class="mb-3">
        <div class="row">
            <div class="col-md-3">
                <label>From Date:</label>
                <input type="date" name="fromdate" value="{{ $fromdate }}" class="form-control">
            </div>
            <div class="col-md-3">
                <label>To Date:</label>
                <input type="date" name="todate" value="{{ $todate }}" class="form-control">
            </div>
            <div class="col-md-3 align-self-end">
                <button type="submit" class="btn btn-primary">Filter</button>
            </div>
        </div>
    </form>

    <table class="table table-bordered table-striped small">
        <thead class="thead-dark">
            <tr class="text-center">
                <th style="text-align: left;">Sr#</th>
                <th style="text-align: left;">Item Name</th>
                <th style="text-align: right;">Trade<br>Price</th>
                <th style="text-align: right;">Opening<br>Qty</th>
                <th style="text-align: right;">Purchases<br>Qty</th>
                <th style="text-align: right;">Sales<br>Qty</th>
                <th style="text-align: right;">Bonus</th>
                <th style="text-align: right;">Balance<br>Qty</th>


            </tr>
        </thead>
        <tbody>
            @php $sr = 1; @endphp
 @foreach($results as $key => $row)
<tr>
    <td style="text-align: right;">{{ $key + 1 }}</td>
    <td style="text-align: light;">{{ $row->item_name }}</td>
    <td style="text-align: right;">{{ number_format($row->tradeprice, 2) }}</td>
    <td style="text-align: right;">{{ number_format($row->openingquantity),0,0 }}</td>
    <td style="text-align: right;">{{ number_format($row->qtyreceived),0,0 }}</td>
    <td style="text-align: right;">{{ number_format($row->qtyissued),0,0 }}</td>
    <td style="text-align: right;">{{ number_format($row->bonus),0,0 }}</td>
    <td style="text-align: right;">{{ number_format(($row->openingquantity + $row->qtyreceived) - ($row->qtyissued + $row->bonus)),0,0 }}</td>
</tr>
@endforeach
        </tbody>
    </table>
</div>
@endsection