@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>
            Category Wise Sales Report
        </h4>
    </div>
    <div class="card-body">
        <form action="">
            <table class="table table-striped">
                <tr>                    
                    <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($category))
            @if(is_array($category) && sizeof($category) > 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-bordered data-table">
                    <thead>
                        <tr>
                            <th>Category</th>
                            <th>Qty</th>
                            <th>Exchange</th>
                            <th>Exchange Qty</th>
                            <th>Net Sales</th>  
                            <th>Gross Sales</th>                            
                        </tr>
                    </thead>
                    <tbody>
                        @php 
                        $total=0; $qty=0; $ntotal = $etotal = $etqty = 0 ;
                        @endphp
                        @foreach($category as $date => $cat_value)                       
                        <tr>
                            <td>{{ $cat_value['category'] }}</td>
                            <td>{{ $cat_value['qty'] }}</td>
                            <td>{{ !empty($cat_value['exchange']['exchange']) ? $cat_value['exchange']['exchange'] : 0 }}</td>
                            <td>{{ !empty($cat_value['exchange']['eqty']) ? $cat_value['exchange']['eqty'] : 0  }}</td>
                            <td>{{ $cat_value['net'] }}</td>
                            <td>{{ $cat_value['sale'] }}</td>
                            @php 
                            $eamt=  !empty($cat_value['exchange']['exchange']) ? $cat_value['exchange']['exchange'] : 0;
                            $eqty=  !empty($cat_value['exchange']['eqty']) ? $cat_value['exchange']['eqty'] : 0;
                            $etotal += $eamt; $etqty += $eqty; $total +=$cat_value['sale']; $ntotal +=$cat_value['net']; $qty +=$cat_value['qty'];
                            @endphp
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td>&nbsp;</td>                             
                            <td>{{ $qty }}</td>
                            <td>{{ $etotal }}</td>
                            <td>{{ $etqty }}</td>
                            <td>{{ $ntotal - $etotal }}</td>
                            <td>{{ $total - $etotal}}</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 = $('.reportTable').DataTable({
          orderCellsTop: true,
          fixedHeader: true
      });
    });
  </script>
@endsection