@extends('layouts.backend')

@section('extraCss')  

<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css" rel="stylesheet">

<style type="text/css">
    .card-header{
        border-bottom-style:hidden !important;
    }
</style>

@endsection
@php $reqpos = request("pos_id"); @endphp

@section('mainContentArea')
<div class="card card-default">
        <div class="card-header">
            <h4>Customer Credit Note Report </h4>
        </div>       
         
        <!-- <div class="alert alert-default" style="overflow-x:auto;">
            <form action="{{ route('customer-wallet-report') }}" id="articlereport" method="post">
               @csrf               

                
            </form>
        </div> -->

         <div class="alert alert-default" >
            <form action="{{ route('customer-wallet-report') }}" id="articlereport" > 

                <table class="table filterPosSo">        
                   
                    <tr>
                        <td width="15%">Group</td>
                        <td width="15%">Store</td>   
                        <td>Start</td>
                        <td>Ends</td>                                          
                        <td colspan="2">ACTION</td>
                    </tr>
                    <tr>
                        <td>
                            <select name="storeType[]" id="storeType" class="input-md" multiple="multiple" > 
                                                     
                            @foreach($ALL_GROUP as $key => $type)
                            <option value="{{ $type->id }}" {{ ( !empty(request("storeType")) && in_array($type->id , request("storeType")) ? "selected" : "")  }}
                            {{ ( empty(request("storeType")) ? "selected" : "") }}>{{ $type->name }}</option>
                            @endforeach
                            </select>
                        </td>
                        <td>
                            <select name="pos_id[]" id="posStore" class="input-md"  multiple="multiple">                                
                                @foreach($ALL_POS as $pos)
                                <option value="{{ $pos->id }}" {{ ( !empty(request("pos_id")) && in_array($pos->id, request("pos_id")) ? "selected" : "") }}>{{ $pos->warehouse_code . ' ('.$pos->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>

                        <td><input type="text" class="form-control datepicker" id="sd" name="sd" value="{{!empty(request("sd")) ? request("sd") : '' }}" autocomplete="off"></td>
                        <td><input type="text" class="form-control datepicker" id="ed" name="ed" value="{{!empty(request("ed")) ? request("ed") : '' }}" autocomplete="off"></td>
                     
                     
                       
                        <td><button class="btn btn-block btn-success" id="submit"><i class="fa fas fa-search" ></i></button></td>
                        <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('customer-wallet-report') }}';"><i class="fa fas fa-refresh"></i></button></td>
                    </tr>
                </table>
            </form>
        </div> 

        <div class="d-flex justify-content-center">
           <div class="spinner-border text-primary " role="status" id="loader_div">
            <span class="sr-only">Loading...</span>
          </div>
        </div>

        <div class="card-body table-responsive" >

            <table class="table table-striped table-bordered " id="articleTables">
                <thead>
                   <tr>   
                        <th>S.No</th>   
                                      
                        <td>Name</td>    
                        <td>Mobile Number</td> 
                        <td> Total Credit Note</td>
                        <td> Total Used Note</td>
                        <td> Total Available</td>
                        <td>Exchange</td>
                        <td> Credit Note</td> 
                        <td> Used Note</td>                    
                        <td> Available</td> 
                        <td>Used In Bills</td>
                       <!--  <td>Expiry Date</td> -->
                     
                    </tr>
                </thead>
               
                <tbody>

                @if(count($customerInfo) > 0)
                
                @php $gctotal= $gutotal = $gatotal = $cttotal= $uttotal = $atotal =  0.0; $i= 1; @endphp
                @foreach($customerInfo as $key => $values)

                @php
                    $cttotal = $cttotal + $values['totalcredit'];
                    $uttotal = $uttotal + $values['totaldebit'];
                    $atotal = $atotal + $values['totalblance'];

                    $gctotal = $gctotal + $values['totalNote'];
                    $gutotal = $gutotal + $values['usedNote'];
                    $gatotal = $gatotal + $values['Credit-Note'];
                @endphp
                <tr> 
                    <td>{{ $i}}</td> 
                    
                    <td>{{ $values['name'] }}</td>    
                    <td>{{ $values['number'] }}</td> 
                    <td>{{ number_format((float)$values['totalcredit'], 2, '.', '') }}</td> 
                    <td>{{ number_format((float)$values['totaldebit'], 2, '.', '') }}</td> 
                    <td>{{ number_format((float)$values['totalblance'], 2, '.', '') }}</td> 
                    <td> 
                        @foreach($values['exchange'] as $key => $product)
                        @foreach($product as $products)
                            {{ $key}} {{$products}}<br>
                        @endforeach                        
                        @endforeach
                    </td> 
                    <td>{{ number_format((float)$values['totalNote'], 2, '.', '') }}</td> 
                    <td>{{ number_format((float)$values['usedNote'], 2, '.', '') }}</td>   
                    <td>{{ number_format((float)$values['Credit-Note'], 2, '.', '') }}</td>  
                    <td> 
                        @foreach($values['used'] as $keys => $used)
                        @foreach($used as $use)
                            {{ $keys}} {{$use}}<br>
                        @endforeach                        
                        @endforeach
                    </td>          
                    
                </tr> 
               @php $i++; @endphp
                @endforeach
                    
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan = 3></td>
                        <td>{{ round($cttotal) }}</td>
                        <td>{{ round($uttotal) }}</td>
                        <td>{{ round($atotal) }}</td>
                        <td ></td>
                        <td>{{ round($gctotal) }}</td>
                        <td>{{ round($gutotal) }}</td>
                        <td>{{ round($gatotal) }}</td>
                        <td></td>
                    </tr>
                </tfoot>
                
                @endif
            </table>
        </div>
</div>



@endsection

@section('extraJs')

<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" ></script>
<script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js" ></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.8.4/moment.min.js" ></script>
<script src="https://cdn.datatables.net/plug-ins/1.10.15/sorting/datetime-moment.js" ></script>

<script type="text/javascript">  
jQuery("#loader_div").hide();
$(document).ready(function() {
    $.fn.dataTable.moment( 'DD-MM-YYYY' );
    $('#articleTables').DataTable( {
        "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],         
          dom: 'Bfrtip',
          buttons: [ 
                     'colvis',
                     {
                        extend: 'excelHtml5',
                        autoFilter: true,
                        sheetName: 'Exported data',
                        exportOptions: {
                            columns: ':visible',
                        },
                        footer: true
                     }                     
           ], 
          colReorder: true,  
          paging: false 
       } );       
} );

var type = $('#storeType').val();
callstores(type);

$("#storeType").on('change', function () { 

var type = $('#storeType').val();
callstores(type);

});

function callstores(type)
{
  var _token   = $('meta[name="csrf-token"]').attr('content');   

  $.ajax({
  url:"{{ route('type-store-list') }}",
  method:"get",
  data:{type: type, _token:_token},
  success:function(res)
  { 

  if(res){ console.log(res);
  $("#posStore").empty();

  $.each(res,function(key,value){ //console.log(key,value);
  $("#posStore").append('<option value="'+key+'" >'+value+'</option>');
  });

  console.log( null);
  var values = null;
  $.each(values, function(i,e){ console.log(i,e);
      $("#posStore option[value='" + e + "']").prop("selected", true);
  });

  $('#posStore').multiselect({            
  enableFiltering: true,
  allSelectedText: 'All',
  maxHeight: 200,
  includeSelectAllOption: true,
  enableCaseInsensitiveFiltering: true  
  });        

  $('#posStore').multiselect('rebuild');

  }else{
  $("#posStore").empty();
  }
  }

  })
}


</script>

@endsection