@extends('layouts.app')
@section('title', __( 'Supplier Product Sell' ))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>SUPPLIER WISE SALES POSITION</h1>
</section>
<!-- Main content -->
<section class="content">
    <div class="row">
       <div class="col-md-12 no-print">
           <form>
                <div class="col-md-1">
                    <label>Shorting</label>
                    <select name="shorting" onchange="this.form.submit()">
                        <option value="50" {{ request('shorting')==50 ? 'selected' :''}}>50</option>
                        <option value="100" {{ request('shorting')==100 ? 'selected' :''}}>100</option>
                        <option value="500" {{ request('shorting')==500 ? 'selected' :''}}>500</option>
                        <option value="1000" {{ request('shorting')==1000 ? 'selected' :''}}>1000</option>
                        <option value="5000" {{ request('shorting')==5000 ? 'selected' :''}}>All</option>
                    </select>
                </div>
                <div class="col-md-3">
                  <div class="form-group">
                     <label>Supplier</label>
                     <select class="form-control" name="supplier_id" onchange="this.form.submit()">
                         @foreach($suppliers as $key=> $item)
                         <option value="{{$key}}" {{ request()->supplier_id==$key ?'selected':''}}>{{$item}}</option>
                         @endforeach
                     </select>
                  </div>
                </div>

              <div class="col-md-3">
                <label>Date From</label>
                <input type="text" name="start" class="form-control" id="start" value="{{request()->start ? request()->start:''}}" autocomplete="off">
              </div>
              <div class="col-md-3">
                <label>Date To</label>
                <input type="text" name="end" class="form-control" id="end" value="{{request()->end ? request()->end:''}}" autocomplete="off">
              </div>
              <div class="col-md-2">
                  <button type="submit" class="btn btn-xs btn-success" style="margin-top:26px">SUBMIT</button>
                  <a href="{{ action('ReportController@supplierSellProduct')}}" class="btn btn-xs btn-info" style="margin-top:26px">Refrsh</a>
                  <a onclick="window.print();" class="btn btn-xs btn-info" style="margin-top:26px"><i class="fa fa-print"></i></a>
                  <a class="btn btn-xs btn-info" style="margin-top:26px" id="excel"><i class="fa fa-download"></i></a>
              </div>
           </form>
       </div>
       <div class="col-md-12">
           <div class="box box-solid">
               <div class="table">
                    <table class="table table-striped">
                        <tr>
                            <th>Suuplier : </th>
                            <th colspan="7">{{$sup}}</th>
                        </tr>
                        <tr>
                            <th>Barcode</th>
                            <th>Product</th>
                            <th>Sell Qty</th>
                            <th>Return Qty</th>
                            <th>CPU</th>
                            <th>RPU</th>
                            <th>Discount</th>
                            <th>Vat</th>
                            <th>Total Sale</th>
                            <th>Total Purchase</th>
                        </tr>
                        <tbody>
                            @php
                                $count=0;
                                $total=0;
                                $total_purchase=0;
                                $total_discount=0;
                                $total_tax=0;
                            @endphp
                            @foreach($results as $result)
                            @php
                            
                            if($result->sell_qty == 0){
                                break;
                            }
                            
                            $sub_total= ($result->sell_qty * $result->sell_price_inc_tax) -  $result->discount_amount;
                            $pur_total=$result->sell_qty * $result->default_purchase_price;
                            $total_discount +=$result->discount_amount;
                            $total_tax +=$result->tax;
                            $total +=$sub_total;
                            $total_purchase +=$pur_total;
                            $count++;
                            @endphp
                            <tr>
                                <td>{{ $result->id}}</td>
                                <td>{{ $result->name}}</td>
                                <td>{{ $result->sell_qty ?? 0}}</td>
                                <td>{{ $result->return_qty ?? 0}}</td>
                                <td>{{ $result->default_purchase_price}}</td>
                                <td>{{ $result->sell_price_inc_tax}}</td>
                                <td>{{ $result->discount_amount}}</td>
                                <td>{{ $result->tax}}</td>
                                <td>{{$sub_total}}</td>
                                <td>{{$pur_total}}</td>
                            
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th></th>
                                <th>Total</th>
                                <th>{{$results->sum('sell_qty')}}</th>
                                <th>{{$results->sum('return_qty')}}</th>
                                <th>0</th>
                                <th>0</th>
                                <th>{{ number_format($total_discount,2)}}</th>
                                <th>{{ number_format($total_tax,2)}}</th>
                                
                                <th>{{ number_format($total,2)}}</th>
                                <th>{{ number_format($total_purchase,2)}}</th>
                            </tr>
                        </tfoot>
                    </table>  
                </div>
            </div>
            @if($count ==50)
            <p>{!! urldecode(str_replace("/?","?",$results->appends(Request::all())->render())) !!}</p>
            @endif
       </div>
    </div>
</section>
@stop


@section('javascript')
<script src="//cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script type="text/javascript">
    $('#start, #end').datepicker({  format: 'yyyy-mm-dd' });
    
    $("#excel").click(function () {
        $(".table").table2excel({
            exclude: '.exclude',
            filename: 'sales_position.xls'
        });
    })
</script>
@endsection