@extends('layouts.blank')

@section('main_container')
@push('inline-scripts')
  

              $(document).ready(function() {

           

            $('#datatable1').dataTable({

             "aaSorting":[[2,"desc"]]
            });
    
               
          });
@endpush
 <!-- page content -->
<div class="right_col" role="main">
     <div class="">
        <div class="page-title">
          <div class="title_left">
            <h3></h3>
          </div>

         



        <div class="clearfix"></div>
         @if(Session::has('flash_message'))
                    <div class="row">
                        <div class="col-xs-12">
                            <span class="help-block" style="background-color: #27ae60; padding:10px; color: #FFF; ">
                                {{ Session::get('flash_message') }}<br>
                                
                               
                                 
                                 
                            </span>

                        </div>
                    </div>
                    @endif
         {!! Form::open(array('class' => 'form-horizontal form-label-left', 'method' => 'GEt')) !!}                
                <div class="row">
                    <div class="col-md-12 col-xs-12">
                        <div class="x_panel">
                            <div class="row">                            
                                <div class="col-md-3 col-xs-12">
                                    <div class="form-group">
                                        <label for="branch">Workweek</label>
                                        {!! Form::select('week', $_weeks, $week, array('id' => 'week', 'class' => 'form-control' ,'data-placeholder' => 'SELECT Workweek')) !!}
                                    </div>                                    
                                </div>

                                      <div class="col-md-3 col-xs-12">
                                    <div class="form-group">
                                        <label for="branch">Year</label>
                                        {!! Form::select('year', $_years, $year, array('id' => 'branches', 'class' => 'form-control' ,'data-placeholder' => 'SELECT Workweek')) !!}
                                    </div>                                    
                                </div>
                               
                                                                
                            </div>
                            <div class="row">
                                <div class="col-md-12 col-xs-12">
                                    
                                    <div class="btn-group">
                                        <button type="submit" class="btn btn-warning">Process</button>
                                    </div>
                                    <!--  <div class="btn-group">
                                        <button type="submit" name="export" value = "3" class="btn btn-primary">Download Excel Summary</button>
                                    </div> -->
                                </div>                                
                            </div>
                        </div>
                    </div>
                </div>  
            {!! Form::close() !!}   


        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                    <div class="x_title">
                        <h2>Week # {{$week}} </h2>
                      
                        <div class="clearfix"></div>
                    </div>
                    
                    <div>
                        <h2>{{ date('F-d-Y', strtotime($arr['week_start'])) }} to {{ date('F-d-Y', strtotime($arr['week_end']))  }}</h2>

                    </div>
                    <div class="x_content table-responsive">
                        <table  id="datatable1" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Store</th>
                                    <th>Weekly Target</th>
                                    <th>Actual Sales</th>
                                    <th>% to Goal</th>
                                     <th># of Transactions</th>
                                     <th>ATV</th>
                                      <th>Footcount</th>
                                    <th>Conversion</th>
                                     <th>Frame/Transactions</th>
                                     <th>Upsell%</th>
                                     <th>Frame Price Point</th>
                                     <th>25 Best Seller Inventory</th>
                                    <th>Action</th>
                                </tr>
                            </thead>


                            <tbody>
                              @foreach($data as $d)
                                    @php
                                        $_goal = 0.00;
                                        $_atv = 0.00;
                                        $_ft = 0.00;
                                        $_fpp = 0.00;
                                        $_upsell = 0.00;
                                        $_best = 0.00;
                                        $_foot = 0.00;
                                if($d->net_amount > 0 ){
                                    if($d->target > 0 ) {
                                        $_goal = ($d->net_amount  - $d->refund_amount )/ $d->target;
                                    }

                                    $_atv = ($d->net_amount  - $d->refund_amount ) / $d->total_trans;
                                }

                                if($d->total_trans > 0  && $d->frame_quantity > 0 ) {
                                    $_ft = $d->frame_quantity / $d->total_trans;

                                }
                                if($d->total_trans > 0 && $d->foot_count > 0 ){

                                    $_foot = $d->total_trans / $d->foot_count;
                                }

                                if($d->frame_quantity > 0 && $d->frame_amount >0) {
                                    $_fpp = $d->frame_amount / $d->frame_quantity;

                                }

                                 if($d->frame_quantity > 0 && $d->upsell_quantity >0) {
                                    $_upsell = $d->upsell_quantity / $d->frame_quantity;

                                }

                                if($d->best_seller_quantity > 0) {


                                    $_best = $d->best_seller_quantity/25;
                                }

                                    @endphp                                    
                                    <tr>
                                        <td>{{  $d->branch }}</td>
                                        <td>{{ number_format($d->target,2) }}</td>
                                        <td>{{ number_format($d->net_amount - $d->refund_amount,2) }}</td>
                                        <td>{{  round((float) $_goal  * 100 ) }}.%</td>
                                        <td>{{ $d->total_trans }}</td>
                                        <td>{{ round((float)$_atv ) }}</td>
                                        <td>{{ $d->foot_count }}</td>
                                        <td>{{ round((float)$_foot ) }}</td>
                                        <td>{{ round($_ft,2) }}</td>
                                        <td>{{ round((float) $_upsell  * 100 ) }}.%</td>
                                        <td>{{ round($_fpp,2) }}</td>
                                        <td> {{ round((float) $_best  * 100 ) }}.%</td>
                                        <td> <a href="{{ route('weekly.overview', ['branch_code' => $d->branch_code])}}"> Store Overview</a></td>
                                      
                                      
                                    </tr>
                                    @endforeach                                                                
                                </tbody>
                                
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
      </div>
</div>
<!-- /page content -->
    
@endsection