@extends('layouts.backend')
@section('extraCss')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedheader/3.1.2/css/fixedHeader.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedcolumns/3.3.3/css/fixedColumns.dataTables.min.css">
<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css" rel="stylesheet">
<style type="text/css">
table.dataTable {    
     margin-top: 0px !important; 
     margin-bottom: 0px !important;
    }

table.dataTable tr.odd { background-color: rgb(240, 241, 243);  }
table.dataTable tr.even{ background-color: white;  }
</style>
@endsection
@php
      $spscount = \App\CustomerPlan::with('customerRef')->whereHas('customerRef', function ($q) use ($pos_id)
                    {
                        $q->where('warehouse_id', $pos_id); 
                        $q->Distinct('customer_id');
                    })->where('current', 1)->where('status', 1)->whereBetween('start_date', [$startdate, $enddate])->count();
        
@endphp
@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>
            Daily Sales Summary Report
        </h4>
    </div>
    <div class="card-body">
        <form action="{{ route('pos-dsr-admin-report') }}">
            <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-admin-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="card-body table-responsive" >
             <h5> Total SPS :  </h5> 
            <table class="table cell-border " id="salesSumarryTable">
                <thead>
                   
                    <tr>
                        <th>Date</th>
                       
                        <th>Day</th>
                      
                        <th> Store Location</th>
                        <th>Foot fall</th>
                        <th>Repeat</th>
                        <th>New</th>
                        
                        <th>Total NOB</th>
                        <th>QTY</th>
                        <th>UPT</th>
                        <th>ABV</th>
                        <th>ASP</th>
                        <th>Target</th> 
                        <th> New SPS </th>   
                        <th> Old SPS </th>                  
                        <th>MRP</th>
                        <th>SPS Discount</th>
                        <th>Clearence Discount</th>
                        <th>Other Offer Discount</th>
                        <th>Gift Vouchers</th>
                        <th>Reward Points</th>
                        <th>Realised sale</th> 
                        <th>ACH%</th>  
                        <th>CONV%</th> 
                        <th>0 - 1499</th>   
                        <th>1500 - 2499</th>  
                        <th>2500 - 4999</th>  
                        <th>5000 - 7499</th>   
                        <th>7500 - 9999</th>  
                        <th>10000 & above</th> 
                        <th>Upper</th>
                        <th>Suit Sets</th>
                        <th>Bottom</th>
                        <th>Home</th>
                        <th>Accessory</th>
                        <th>Jewellery</th>
                    </tr>
                </thead>
                @if(!empty($salesData))
                <tbody>    @php $grealsale = $grealsoldqty = $grealmrp= $abv = $asp = $averaguabv = $averagasp = $averagupt = $totalCount =  0 ; 
                                
                           @endphp
                           @foreach($salesData as $key => $order) 
                           @php 
                               $totalTotal = 0;
                               $order['totalfinalamt'] = $order['totalfinalamt'] - $order['totalExchangeAmt'] ; 
                               $totalTotal += $order['totalfinalamt'];
                               $grealsale += $totalTotal;
                               $realmrp = $order['totalMrp'] - $order['totalExchangeAmt'] ; 
                               $grealmrp += $realmrp;
                               $order['totalQty'] = $order['totalQty'] - $order['exchangeCounts'] ;
                               $grealsoldqty += $order['totalQty'];

                               $averagupt += $order['upt'];
                       
                                if($order['totalBill'] > 0)
                                {
                                $abv= $totalTotal/  $order['totalBill']; 
                                }

                                $averaguabv += number_format((float)$abv, 2, '.', '');  

                                if($order['totalQty'] > 0)
                                {
                                $asp = $totalTotal/  $order['totalQty']; 
                                }

                                $averagasp += $asp;

                           @endphp
                           @if(!empty($order['totalMrp']))
                           @php  $totalCount++; @endphp
                            <tr>
                                <td >{{$key}}</td>
                                <td >{{date('l', strtotime($key))}}</td> 
                                <td >{{$pos->name}}</td>                                
                                <td >0</td>
                                <td >{{$order['oldcustomer']}}</td>
                                <td >{{$order['newcustomer']}}</td>                                
                                <td >{{$order['totalBill']}}</td>
                                <td >{{$order['totalQty']}}</td>                                
                                <td >{{number_format($order['upt'],2)}}</td>
                                <td>{{ number_format((float)$abv, 2, '.', '')  }}</td>
                                <td>{{ number_format((float)$asp, 2, '.', '')  }}</td> 
                                
                                <td >0</td> 
                                <td >{{$order['newspscount']}}</td>
                                <td >{{$order['oldspscount']}}</td>
                               
                                <td >{{$realmrp}}</td>
                                <td >{{$order['totalSpsDiscount']}}</td> 
                                <td >{{$order['clearence'] }}</td> 
                                <td>{{$order['otherOffer']}}</td>
                                <td>{{$order['totalGv']}}</td>
                                <td>{{$order['totalreward']}}</td>
                                <td >{{$order['totalfinalamt']}}</td> 
                                <td >0</td> 
                                <td >0</td> 
                                <td >{{$order['bill1000']}}</td> 
                                <td >{{$order['bill1500']}}</td> 
                                <td >{{$order['bill2500']}}</td> 
                                <td >{{$order['bill5000']}}</td> 
                                <td >{{$order['bill7000']}}</td> 
                                <td >{{$order['bill10000']}}</td> 
                                <td >0</td> 
                                <td >{{!empty($order['Suits']) ? $order['Suits'] : 0 }}</td> 
                                <td >{{ !empty($order['Bottom']) ? $order['Bottom'] : 0 }}</td> 
                                <td >0</td> 
                                <td >{{!empty($order['acceess']) ? $order['acceess'] :0 }}</td>    
                                <td >{{ !empty($order['jewelery']) ? $order['jewelery'] : 0 }}</td>      
                            </tr>
                            @endif
                    @endforeach
                </tbody> 
                <tfoot> {{$totalCount }}{{round($averaguabv)}}
                 @if(!empty($finals['totalMrp']))
                            <tr>
                                <td colspan = 4></td>                                
                               
                                <td>{{$finals['oldcustomer']}}</td>
                                <td>{{$finals['newcustomer']}}</td>
                                <td> {{$finals['totalBill']}}</td>
                                
                                <td> {{round($finals['totalQty'] - $finals['exchangeCounts'])}} </td>
                                
                                @php   $aupt=$averagupt/$totalCount; 
                                       $aabv=$averaguabv/$totalCount; 
                                       $aasp=$averagasp/$totalCount; 
                                @endphp

                                <td>{{ round ($aupt) }}</td>
                                <td>{{ round ($aabv) }}</td>
                                <td>{{ round ($aasp) }}</td>
                                <td>0</td>
                                <td> {{round($finals['newspscount'])}}</td>
                                <td> {{round($finals['oldspscount'])}}</td>                                
                               
                                <td> {{round($finals['totalMrp'] - $finals['totalExchangeAmt'])}} </td>
                                <td> {{round($finals['totalSpsDiscount'])}} </td>
                                <td> {{round($finals['clearence'])}} </td>
                                <td> {{round($finals['otherOffer'])}}</td>
                                <td> {{round($finals['totalGv'])}} </td>
                                <td> {{round($finals['totalreward'])}} </td>
                                <td> {{round($finals['totalfinalamt'] - $finals['totalExchangeAmt'])}} </td>
                                <td>0</td>
                                <td>0</td>
                                <td> {{round($finals['bill1000']) }} </td>
                                <td> {{round($finals['bill1500']) }} </td>
                                <td> {{round($finals['bill2500']) }} </td>
                                <td> {{round($finals['bill5000']) }} </td>
                                <td> {{round($finals['bill7000']) }} </td>
                                <td> {{round($finals['bill10000']) }} </td>
                                <td>0</td>
                                <td>{{ round($finals['Suits'])}}</td>
                                <td>{{ round($finals['Bottom'])}}</td>
                                <td>0</td>
                                <td>{{round($finals['acceess'])}}</td>
                                <td>{{round($finals['jewelery'])}}</td>
                                
                            </tr> 
                            @endif
                            <tr>
                        <th>Date</th>
                        
                        <th>Day</th>
                       
                        <th> Store Location</th>
                        <th>Foot fall</th>
                        <th>Repeat</th>
                        <th>New</th>
                        
                        <th>Total NOB</th>
                        <th>QTY</th>
                        <th>UPT</th>
                        <th>ABV</th>
                        <th>ASP</th>
                        <th>Target</th> 
                        <th> New SPS </th>   
                        <th> Old SPS </th>                  
                        <th>MRP</th>
                        <th>SPS Discount</th>
                        <th>Clearence Discount</th>
                        <th>Other Offer Discount</th>
                        <th>Gift Vouchers</th>
                        <th>Reward Points</th>
                        <th>Realised sale</th> 
                        <th>ACH%</th>  
                        <th>CONV%</th> 
                        <th>0 - 1499</th>   
                        <th>1500 - 2499</th>  
                        <th>2500 - 4999</th>  
                        <th>5000 - 7499</th>   
                        <th>7500 - 9999</th>  
                        <th>10000 & above</th> 
                        <th>Upper</th>
                        <th>Suit Sets</th>
                        <th>Bottom</th>
                        <th>Home</th>
                        <th>Accessory</th>
                        <th>Jewellery</th>
                    </tr>                 
                </tfoot>
               
                @endif
            </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.2/js/dataTables.fixedHeader.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/fixedcolumns/3.3.3/js/dataTables.fixedColumns.min.js" type="text/javascript"></script>
<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 type="text/javascript">
    $(function () { 
      
       $('#salesSumarryTable').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 ,
          scrollX: true,
          scrollY: "800px",
          scrollCollapse: true,
          
          fixedColumns:   {
            leftColumns: 3,
           
           } 
       } );
    });
  </script>
@endsection