@extends('layouts.backend')
@section('extraCss')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedheader/3.1.2/css/fixedHeader.dataTables.min.css">
@endsection
@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>
            Product Wise Sales Report
        </h4>
    </div>
    <div class="card-body">
        <form action="">
            <table class="table table-striped">
                <tr>
                    <th>Barcode</th>
                    <td><input type="text" class="form-control" name="barcode" value="{{ request('barcode') }}"></td>
                    <th>Article</th>
                    <td><input type="text" class="form-control" name="article" value="{{ request('article') }}"></td>
                    <th>Color</th>
                    <td><input type="text" class="form-control" name="color" value="{{ request('color') }}"></td>
                    <th>Size</th>
                    <td><input type="text" class="form-control" name="size" value="{{ request('size') }}"></td>
                    <th>From Date</th>
                    <td><input type="text" readonly class="form-control datepicker" required name="startdate" value="{{ $startdate }}"></td>
                    <th>End Date</th>
                    <td><input type="text" readonly class="form-control datepicker" required name="enddate" value="{{ $enddate }}"></td>
                    <th><button class="btn btn-success"><i class="fa fas fa-search"></i> Search</button></th>
                </tr>
            </table>
        </form>
        <hr/>
        @if(!empty($salesData))
            @if(is_array($salesData) && sizeof($salesData) > 0)
            <div class="text-right">
                <form method="post" action="{{ route('export-data-to-excel') }}" target="_blank">
                    @csrf
                    <input type="hidden" name="label" value="ExportDSR-{{ $startdate }}-to-{{ $enddate }}">
                    <input type="hidden" name="html" value="" id="exportedVal">
                    <button class="btn btn-sm btn-warning" type="button" onclick="$('#exportedVal').val($('.exportedData').html());this.form.submit();">Export</button>
                </form>
            </div>
            <div class="exportedData">
                <table class="table table-striped table-bordered" id="productsTables">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Invoice</th>
                            <th>Code</th>
                            <th>Style</th>
                            <th>Color</th>
                            <th>Hsn</th>
                            <th>Size</th>
                            <th>MRP</th>
                            <th>Clearance</th>
                            <th>Discount</th>
                            <th>Voucher</th>
                            <th>SPS</th>
                            <th>Net Price</th>
                            <th>Taxable</th>
                            <th>Tax</th>
                            <th>CGST</th>
                            <th>SGST</th>
                            <th>QTY</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($salesData as $date => $saleData)
                        <tr>
                            <td>{{ $saleData['date'] }}</td>
                            <td>#{{ $saleData['bill_no'] }}</td>
                            <td>{{ $saleData['productcode'] }}</td>
                            <td>{{ $saleData['article'] }}</td>
                            <td>{{ $saleData['color'] }}</td>
                            <td>{{ $saleData['hsn'] }}</td>
                            <td>{{ $saleData['size'] }}</td>
                            <td>{{ $saleData['mrp'] }}</td>
                            <td>{{ $saleData['clearance'] }}</td>
                            <td>{{ $saleData['discount'] }}</td>
                            <td>{{ $saleData['voucher'] }}</td>
                            <td>{{ $saleData['sps'] }}</td>
                            <td>{{ $saleData['selling_price'] }}</td>
                            <td>{{ $saleData['exvat'] }}</td>
                            <td>{{ $saleData['tax_per'] }}</td>
                            <td>{{ $saleData['cgst'] }}</td>
                            <td>{{ $saleData['sgst'] }}</td>
                            <td>{{ $saleData['qty'] }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>{{ number_format($finals['mrp'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['clearance'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['discount'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['voucher'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['sps'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['selling_price'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['exvat'], 2, '.', '') }}</td>
                            <td>&nbsp;</td>
                            <td>{{ number_format($finals['cgst'], 2, '.', '') }}</td>
                            <td>{{ number_format($finals['sgst'], 2, '.', '') }}</td>
                            <td>{{ $finals['qty'] }}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
            @else
            <div class="alert alert-warning">No record found</div>
            @endif     
        @else
        <div class="alert alert-warning">Please select the dates above to get the report</div>
        @endif
    </div>
</div>
@endsection
@section('extraJs')
<script src="https://cdn.datatables.net/fixedheader/3.1.8/js/dataTables.fixedHeader.min.js"></script>
<script type="text/javascript">    

$(function () { 
    var table = $('#productsTables').DataTable({
        "lengthMenu": [[100, 250, 500, -1], [100, 250, 500, "All"]],
        orderCellsTop: true,
        fixedHeader: true,
        autoFilter: true,
    });
});
    
  </script>
@endsection