@extends('layouts.backend')

@section('extraCss')  

@endsection

@section('mainContentArea')
<div class="card card-default">
        <div class="card-header">
            <h4>Audit Article Sizewise Report</h4>
        </div>       
         
        <div class="alert alert-default" style="overflow-x:auto;">
            <form action="{{ route('audit-article-size-wise-report') }}" id="articlereport">
                <h4>Filter  </h4>
                <table class="table filterPosSo">        
                    <tr>  
                         <a class="btn btn-md btn-primary" id="excelR" style="float:right; margin-bottom:10px;" href=" {{  ($warehouseName) ? route('auditArticleSizeexport',[implode(",",$pos_id),$subsectionv,$article,$color] ) : '#' }} ">Export Excel</a> 
                    </tr>
                    <tr>
                        <td width="15%">Warehouse</td>
                        <td width="15%">Store</td>
                        <td width="15%">Category</td>
                        <td width="15%">Article</td>
                        <td width="15%">Color</td>                        
                        <td colspan="2">ACTION</td>
                    </tr>
                    <tr>

                        <td>
                            <select name="warehouse_id[]" id="warehouse" class="input-md"  multiple="multiple" >
                                
                                @foreach($ALL_WAREHOUSES as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ ( !empty(request("warehouse_id")) && in_array($warehouse->id, request("warehouse_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>

                        <td>
                            <select name="warehouse_id[]" id="Pos" class="input-md"  multiple="multiple">                                
                                @foreach($ALL_POS as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ ( !empty(request("warehouse_id")) && in_array($warehouse->id, request("warehouse_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>
                        
                        <td>
                            <select name="subsection" id="subsection" class="input-md" >
                                <option value="">Any</option>
                                 @foreach($subsections as $subsection)
                                <option value="{{ $subsection->subsection }}" {{ request('subsection') == $subsection->subsection ? 'selected' : '' }}>{{ $subsection->subsection  }}</option>
                           
                                 @endforeach
                            </select>
                        </td> 

                        <td>
                            <input name="article" id="article" class="form-control" value="{{ request('article') }}" >
                        </td>

                        <td>
                            <input name="color" id="color" class="form-control" value="{{ request('color') }}" >
                        </td>
                       
                        <td><button class="btn btn-block btn-success"><i class="fa fas fa-search" id="submit"></i></button></td>
                        <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('audit-article-size-wise-report') }}';"><i class="fa fas fa-refresh"></i></button></td>
                    </tr>
                </table>
            </form>
        </div>

        <div class="card-body" style="overflow-x:auto;">

            <table class="table table-striped table-bordered " id="articleTables">
                <thead>
                   
                    <tr>
                        <th>#</th>
                        <th>store</th>
                        <th>Section</th>
                        <th>Subsection</th>
                        <th>Image</th>
                        <th>Article</th>
                        <th>Color</th>
                        @foreach($sizes as $size)
                        <th>{{$size}}</th>
                        @endforeach
                        <th>Total</th>
                    </tr>
                </thead>
                @php if(count($rows) > 0) { @endphp
                <tbody>
                
                @php $totalcountallsize  = 0 ;  @endphp 
                @foreach($rows as $key => $row)
                   @php $totalrow = 0 ; @endphp
                    <tr>
                         @php $article = \App\Article::with('category')->with('maincategory')->select('image')->where('code',$productRows[$row]['article'])->first(); @endphp
                         
                        <td>{{ $key + 1 }}</td>
                        <td>{{ $productRows[$row]['store'] }}</td>
                        <td>{{ !empty($article->maincategory) ? $article->maincategory->name : $productRows[$row]['section'] }}</td>
                        <td>{{ !empty($article->category) ? $article->category->name : $productRows[$row]['subsection'] }}</td>
                       
                        <td><img src="{{  empty($article->image) || $article->image == 'NULL' ? 'https://via.placeholder.com/100x100.png?text=No Photo' : asset('/uploads/articles/'.$article->image) }}" 
                            style="width:100px;" class="img-fluid center-block img-rounded"></td>
                        <td>{{ $productRows[$row]['article'] }}</td>
                        <td>{{ $productRows[$row]['color'] }}</td>

                        @foreach($sizes as $size)
                        <td>
                            {{ empty($articleProductCombinations[$row][$size]) ? 0 : $articleProductCombinations[$row][$size] }}
                            @php
                                
                            if(empty($productCountSize[$size])) {
                                $productCountSize[$size] = 0;
                            }
                            if(empty($articleProductCombinations[$row][$size])) {
                                $articleProductCombinations[$row][$size] = 0;
                            } 
                             $totalrow +=    (int)$articleProductCombinations[$row][$size] ;
                            $productCountSize[$size]+= (int)$articleProductCombinations[$row][$size];
                            @endphp
                        </td>
                        @endforeach
                                                 <td>{{$totalrow}}</td>
                    </tr>

                @endforeach

                </tbody>
                <tfoot>
                <tr>
                        <td colspan="7"></td> 
                        @foreach($sizes as $size)
                         
                         <td> {{ empty($productCountSize[$size]) ? 0 : $productCountSize[$size] }} </td> 
                      
                        @endforeach
                        <td>{{$grandTotal}}</td>
                        
                </tr>
                </tfoot>
               @php } @endphp
            </table>
        </div>
</div>
@endsection

@section('extraJs')

<script type="text/javascript">  


    $("#submit").click(function () {    

        if (($('#warehouse').val() == '') && ($('#Pos').val() == '')) {

            alert("Please Select Warehouse / Store");
           
            $("#articlereport").attr("disabled", "disabled");

            return false;
        }
        
    });
$(document).ready(function() {
    $('#articleTables').DataTable( {
        "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],         
          dom: 'Bfrtip',
          buttons: ['colvis'],         
          colReorder: true,  
          paging: false 
       } );       
          } );
</script>

@endsection