@extends('layouts.backend')

@section('extraCss')
    <style>
        .select2-container--open .select2-dropdown--below {
        min-width:200px !important;
        }
        .tblPosOrdList td, .tblPosOrdList th {
        font-size:12px;
        }
    </style>
@endsection

@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4> 
        Warehouse Report 
        </h4>
    </div>


    <div class="alert alert-default">
        <form action="{{ route('warehouse-sales-report') }}">
            <h4> Filter  </h4>
            <table class="table filterPosSo">
                <tr>                    
                    <td >FROM</td>
                    <td>TO</td>
                    <td >DATE FROM</td>
                    <td >DATE TO</td>                   
                    <td colspan="2">ACTION</td>
                </tr>
                <tr>
                    
                    <td>
                        <select name="from_pos" id="from_pos" class="select2"  style="width:150px;">
                            <option value="">Any</option>
                            @foreach($ALL_WAREHOUSES as $warehouse)
                            <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                            @endforeach
                        </select>
                    </td>
                    <td>
                        <select name="to_pos" id="to_poss" class="select2" style="width:150px;">
                            <option value="">Any</option>
                          
                            @foreach($ALL_WAREHOUSES as $warehouse)
                            <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                            @endforeach
                           
                        </select>
                    </td>
                    <td>
                        <input name="datefrom" id="datefrom" class="form-control datepicker" value="{{ request('datefrom') }}" style="width:150px;">
                    </td>
                    <td>
                        <input name="dateto" id="dateto" class="form-control datepicker" value="{{ request('dateto') }}" style="width:150px;">
                    </td>
                   
                    <td><button class="btn btn-block btn-success"><i class="fa fas fa-search"></i></button></td>
                    <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('warehouse-sales-report') }}';"><i class="fa fas fa-refresh"></i></button></td>
                    </tr>
            </table>
        </form>
    </div>

    <div class="card-body">
    <table class="table table-bordered tblPosOrdList table-responsive">
            <thead>
                <tr>
                    <th>S.NO</th>
                    <th>DATE</th>
                    <th>LOCATION</th>
                    <th>ARTICLE NO.</th>
                    <th>DESCRIPTION</th>
                    <th>SUB CATEGORY</th>
                    <th>FIT</th>
                    <th>COLOR</th>
                    <th>IMAGE</th>
                    <th>FIRST IN DATE</th>
                    @foreach($sizes as $sizearray)
                      <th>{{ $sizearray }}</th>
                    @endforeach                    
                    <th>MRP</th>
                    <th>IF ANY SCHEME APPLIED</th>
                    <th>DICOUNT %</th>
                    <th>DISCOUNT AMOUNT</th>
                    <th>AMOUNT REALIZED</th>
                </tr>
            </thead>
            <tbody>
                                @if($salesdata->count() > 0)
                @foreach($salesdata as $key => $posSalesOrder) 
                   @foreach($posSalesOrder->items as $items)
                <tr>
                    <td> {{ $key+ $salesdata->firstItem() }} </td>
                    <td>{{ $posSalesOrder->date_added }}</td>
                    <td>{{ $posSalesOrder->mwarehouse->address }}</td>
                    <td>                   
                        {{ $items->article}}<br> 
                    </td>
                    <td>
                        @if( !empty($items->product->long_desc))
                        {{ $items->product->long_desc}}<br>
                        @else   
                        N/A </br>
                        @endif 
                    </td>
                    <td>
                        @if( !empty($items->product->category))
                        {{ $items->product->category->name }}<br>
                        @else   
                        N/A </br>
                        @endif 
                    </td>
                    <td>

                    </td>
                    <td>                  
                        {{ $items->color}}                    
                    </td>
                    <td>                  
                        @if( !empty($items->product))
                        {{ $items->product->image }}<br>
                        @else   
                        N/A </br>
                        @endif                 
                    </td>
                    <td> N/A</td>

                    @php  

                    foreach($posSalesOrder->items as $items)
                    {

                        $pre_sales_id_pre = $items->pre_sales_id;

                        if($pre_sales_id_pre != $items->pre_sales_id )
                        {
                           $xs = $s = $m= $l = $xl = $XXL = $XL3 = $XL4 = $XL5 = $XL7 = $XL6 = $FREE = 0;
                        }

                        if($items->size == 'XS')
                        {
                           $xs += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added)  ;                             
                        }
                        elseif($items->size == 'S')
                        {
                           $s += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added) ; 
                        }
                        elseif($items->size == 'M')
                        {
                           $m += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added)  ;  
                        }
                        elseif($items->size == 'L')
                        {
                            $l += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == 'XL')
                        {
                            $xl += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == 'XXL')
                        {
                             $XXL += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == '3XL')
                        {
                             $XL3 += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == '4XL')
                        {
                             $XL4 += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == '5XL')
                        {
                             $XL5 += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == '6XL')
                        {
                             $XL6 += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == '7XL')
                        {
                             $XL7 += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }
                        elseif($items->size == 'FREE')
                        {
                              $FREE += $items->sizeinfo($items->article,$items->size,$items->color,$items->date_added);
                        }

                    } 

                    @endphp

                    <td>  {{ $xs}} </td>
                    <td>  {{ $s}}  </td>
                    <td>  {{ $m}}  </td>
                    <td>  {{ $l}}  </td>
                    <td>  {{ $xl}} </td>


                    <td>  {{$XXL}}  </td>
                    <td>  {{$XL3}}   </td>
                    <td>  {{$XL4}}  </td>
                    <td>  {{$XL5}}  </td>
                    <td>  {{$XL6}}   </td>
                    <td>  {{$XL7}}   </td>
                    <td>  {{$FREE}} </td>
                    <td>                        
                        {{ $items->mrp}}<br>                       
                    </td>

                    <td> 

                    </td>
                    <td>                      
                        {{ $items->discountp}}<br>
                       
                    </td>
                    <td>                      
                        {{ $items->discount}}<br>
                   
                    </td>

                    <td>                        
                        {{ $items->finalprc}}<br>                       
                    </td>

                </tr>

                  @endforeach
                @endforeach
                @else
                <tr>
                    <td colspan="10"><div class="alert alert-danger">No sale order found!</div></td>
                </tr>
              @endif
            </tbody>
    </table>
            @php
            $urlHost = request()->getHttpHost();
            if(strstr($urlHost, 'localhost')) {
            $postUrl = 'http://localhost/sutionline/suti-pos/process.php';
            } else {
            $postUrl = 'https://www.sutionline.com/suti-pos/process.php';
            }
            @endphp
            <form action="{{ $postUrl }}" target="_blank" method="post" name="sofrm">
            <input type="hidden" name="so_id" id="so_id" value="0">
            <input type="hidden" name="act" id="act2" value="">
            </form>
            <form action="{{ $postUrl }}" target="_blank" method="post" name="sofrm2">
            <input type="hidden" name="so_id" id="so_id2" value="0">
            <input type="hidden" name="act" id="act" value="print-so-invoice">
            </form>
        <div class="text-right">
        {!! $salesdata->render() !!}
        </div>
</div>
</div>
@endsection

@section('extraJs')
@endsection