@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 INVOICE
        </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($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="ExportInvoiceDSR-{{ $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>Invoice</th>
                            <th>Type</th>
                            <th>Cash</th>
                            <th>Card</th>
                            <th>UPI</th>
                            {{-- <th>Points Redeem</th> --}}
                            <th>Credit Note</th>
                            <th>Wallet</th>
                            <th>Qty</th>
                            <th>MRP</th>
                            <th>Discount</th>
                            <th>Voucher</th>
                            <th>SPS</th>
                            <th>Payable</th>
                            {{-- <th>Taxable</th> 
                            <th>CGST</th>
                            <th>SGST</th> --}}
                            <th>Taxable 5%</th>
                            <th>Taxable 12%</th>
                            <th>Tax 5%</th>
                            <th>Tax 12%</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($salesData as $date => $saleData)
                        @php
                            $isSales = $saleData['itype'] == 'Sales' ? 1 : 0;
                        @endphp
                        <tr>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['date'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">#{{ $saleData['invoice'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['itype'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['cash'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['card'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['upi'] }}</td>
                            {{-- <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['points'] }}</td> --}}
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['creditnote'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['wallet'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $isSales ? '' : '-' }}{{ $saleData['qty'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $isSales ? '' : '-' }}{{ $saleData['mrp'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['disc'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['voucher'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['spsoffer'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $isSales ? '' : '-' }}{{ $saleData['taxableamt'] }}</td>
                            {{-- <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $isSales ? '' : '-' }}{{ $saleData['payableamt'] }}</td> --}}
                            {{-- <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $isSales ? '' : '-' }}{{ $saleData['taxableamt'] }}</td> --}}
                            {{--<td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['cgstamt'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['sgstamt'] }}</td>--}}
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['fivepertaxable'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['tenpertaxable'] }}</td>
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['fivepertax'] }}</td>                           
                            <td class="{{ $isSales ? '' : 'text-danger' }}">{{ $saleData['tenpertax'] }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td colspan="3">&nbsp;</td>
                            <td>{{ $finals['cash'] }}</td>
                            <td>{{ $finals['card'] }}</td>
                            <td>{{ $finals['upi'] }}</td>
                            {{-- <td>{{ $finals['points'] }}</td> --}}
                            <td>{{ $finals['cnote'] }}</td>
                            <td>{{ $finals['wallet'] }}</td>
                            <td>{{ $finals['quantity'] }}</td>
                            <td>{{ $finals['mrp'] }}</td>
                            <td>{{ $finals['discount'] }}</td>
                            <td>{{ $finals['voucher'] }}</td>
                            <td>{{ $finals['sps'] }}</td>
                            <td>{{ ($finals['exvatamt']-$finals['cnote']- $finals['wallet']) }}</td>
                            {{-- <td>{{ $finals['taxableamt'] }}</td> --}}
                            {{-- <td>{{ $finals['cgst'] }}</td>
                            <td>{{ $finals['sgst'] }}</td>--}}
                            <td>{{ $finals['fivepertaxable'] }}</td>
                            <td>{{ $finals['tenpertaxable'] }}</td>
                            <td>{{ $finals['fivepertax'] }}</td>
                            <td>{{ $finals['tenpertax'] }}</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