@extends('layouts.blank')

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

@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



        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                    <div class="x_title">
                        <h2>Store Name {{$branch_name}} </h2>
                      
                        <div class="clearfix"></div>
                    </div>
                    
                    <div>
                       

                    </div>
                    <div class="x_content table-responsive">
                        <table  id="datatable" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Workweek</th>
                                    <th>Start</th>
                                    <th>End</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>
                                 
                                </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['week'] }}</td>
                                    <td> {{$d['start_date'] }}</td>
                                    <td> {{ $d['end_date'] }} </td>
                                
                                        <td>Php.{{ number_format($d['target'],2) }}</td>
                                        <td>Php.{{ 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>
                                       
                                      
                                      
                                    </tr>
                                    @endforeach                                                                
                                </tbody>
                                
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
      </div>
</div>
<!-- /page content -->
    
@endsection