@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>
            POS DSR
        </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>
                    <th><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('pos-dsr-report') }}';"><i class="fa fas fa-refresh"></i></button></th>
        
                </tr>
            </table>
        </form>
        <hr/>
        @if(!empty($salesData))
            @if(is_array($salesData) && sizeof($salesData) > 0)
            <div class="text-right" style="margin:10px;">
                <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>Date</th>
                            <th>Sold Qty</th>
                            <th>Carry Bag</th>
                            <th>Exchange Qty</th>
                            <th>Total Sold Qty</th>
                            <th>Cash</th>
                            <th>UPI</th>
                            <th>Card</th>
                            <th>Wallet Discount</th>
                            <th>Voucher Redeem</th>
                            <th>Credit Note</th>
                            <th>Sale Amount</th>
                            <th>Exchange Amount</th>
                            <th>Realized Sale</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php 
                             $gexeqty = $exeAmt = $gsoldqty = $gsoldamt = $gcarriybag = 0;
                        @endphp
                        @foreach($salesData as $date => $saleData)
                        <tr>
                            @php 
                                   $soldqty = $saleData['quantity']; 
                                   $gsoldqty = $gsoldqty + $soldqty;
                                   $gexeqty = $gexeqty + $saleData['exeqty'];
                                   $soldamt = $saleData['final']; 
                                   $gsoldamt = $gsoldamt + $soldamt;
                                   $exeAmt = $exeAmt + $saleData['exeAmt'];                                   
                            @endphp
                            <td>{{ $date }}</td>
                            <td>{{ $saleData['quantity'] }}</td>
                            <td>{{ $saleData['carriybag'] }}</td>
                            <td>{{ $saleData['exeqty'] }}</td>
                            <td>{{ $soldqty }}</td>
                            <td>{{ $saleData['cash'] }}</td>
                            <td>{{ $saleData['upi'] }}</td>
                            <td>{{ $saleData['card'] }}</td>
                            <td >{{ $saleData['wallet'] }}</td>
                            <td class="text-danger">{{ $saleData['points'] }}</td>
                            <td >{{ $saleData['credit'] }}</td>                            
                            <td>{{ $saleData['final'] }}</td>
                            <td class="text-danger">{{ $saleData['exeAmt'] }}</td>
                            <td >{{ $soldamt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td>&nbsp;</td>
                            <td>{{ $finals['quantity'] }}</td>
                            <td>{{ $finals['carriybag'] }}</td>
                            <td>{{ $gexeqty }}</td>
                            <td>{{ $gsoldqty }}</td>
                            <td>{{ $finals['cash'] }}</td>
                            <td>{{ $finals['upi'] }}</td>
                            <td>{{ $finals['card'] }}</td>
                            <td >{{ $finals['wallet'] }}</td>
                            <td class="text-danger">{{ $finals['points'] }}</td>
                            <td >{{ $finals['cnote'] }}</td>
                            <td>{{ round($finals['totals']) }}</td>
                            <td class="text-danger">{{ round($exeAmt) }}</td>
                            <td>{{ round($gsoldamt) }}</td>
                        </tr>
                         <tr>
                            <th>Date</th>
                            <th>Sold Qty</th>
                            <th>Carry Bag</th>
                            <th>Exchange Qty</th>
                            <th>Total Sold Qty</th>
                            <th>Cash</th>
                            <th>UPI</th>
                            <th>Card</th>
                            <th>Wallet Discount</th>
                            <th>Voucher Redeem</th>
                            <th>Credit Note</th>
                            <th>Sale Amount</th>
                            <th>Exchange Amount</th>
                            <th>Realized Sale</th>
                        </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