@extends('layouts.app')
@section('title') {{'Return Product Report'}} @endsection
@section('content')

    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Return Product Report
            </div>

            <div class="panel-body">
            <div class="form-group">
            <form action="" method="get" autocomplete="off">
                <div class="form-group">
                    
                    <label for="name" class="col-md-1 control-label"> From  </label>
                    <div class="col-md-2">
                        <input id="start_date" type="text" class="form-control" autocomplete="off" name="start_date" value="{!! @$_GET['start_date'] !!}" required >
                    </div>
                    <label for="name" class="col-md-1 control-label"> To  </label>
                    <div class="col-md-2">
                        <input id="end_date" type="text" class="form-control" autocomplete="off" name="end_date" value="{!! @$_GET['end_date'] !!}" required >
                    </div>
                    <div class="col-md-1">
                        <button type="submit" class="btn btn-default">Search</button>
                    </div>
                </div>
            </form>
          </div>


              <div class="form-group mt-1" style="width:100%; overflow: scroll;" >

                <table id="myTable" class="table table-striped table-hover mt-1">
                    <thead class="header" id="myHeader">
                    <tr>
                        <th> S.N. </th>
                        <th> ID </th>
                        <th> Product Name </th>
                        <th> Total Sales </th>
                        <th> Total Return </th>
                        <th> Return % </th>
                    </tr>
                    </thead>
                    <tbody>
                    @php $i=0; @endphp
                    @if(isset($product_list[0]))
                        @foreach($product_list as $row)
                            @php $i++;

                              $product_sales = $row->product_sales;
                              $product_return = $row->product_return;
                              
                              if($product_sales > 0)
                                {
                                   $percentage =$product_return / $product_sales * 100;
                                }else{
                                   $percentage = 0; 
                                }  
                              
                            @endphp
                            <tr>
                                <td>{{$i}}</td>
                                <td>{{$row->id}}</td>
                                <td>{{$row->product_name}}</td>
                                <td>{{ number_format(max($product_sales,0))}}</td>
                                <td>{{ number_format(max($product_return,0))}}</td>
                                <td>{{ number_format($percentage,2)}} %</td>
                            </tr>
                        @endforeach
                    @endif
                    </tbody>
                </table>

              </div>
            </div>
        </div>
    </div>
<style>
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr th {
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }

    table#myTable thead#myHeader{
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr:last-child th{
        top: 32px;
    }
</style>

    <script>
        jQuery( function($) {
            $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
            $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
        } );
    </script>
@endsection