@extends('layouts.master')

@section('content')
<div class="container-fluid">
  <div class="page-header">
      <div class="row align-items-end">
          <div class="col-lg-8">
              <div class="page-header-title">
                  <i class="ik ik-bar-chart bg-blue"></i>
                  <div class="d-inline">
                      <h5>Sales Report {{ ucwords(strtolower($sme)) }} </h5>
                      <span>&nbsp;</span>
                  </div>
              </div>
          </div>
          <div class="col-lg-4">
              <nav class="breadcrumb-container" aria-label="breadcrumb">
                  <ol class="breadcrumb">
                      <li class="breadcrumb-item">
                          <a href="{{ route('home') }}"><i class="ik ik-home"></i></a>
                      </li>
                      <li class="breadcrumb-item active" aria-current="page">Sales Report</li>
                  </ol>
              </nav>
          </div>
      </div>
  </div><!-- page-header -->

  <div class="row">
      <div class="col-md-2">&nbsp;</div>
      <div class="col-md-12">
          <div class="card">
              <div class="card-header">
                <h4 style="text-decoration:underline;">Sales Report {{ ucwords(strtolower($sme)) }}:</h4><h4>&nbsp;{{ $datestring }}</h4>
              </div>
              <div class="card-body">
                              
                  <h5>Voucher Card</h5>                
                  <table id="vctable" class="table table-hover">
                    <thead>
                      <tr class="text-center">                        
                        <th>Retailer123</th>
                        <th>Product</th>
                        <th>Jumlah</th>       
                        <th>Harga</th> 
                        <th>Metode Bayar</th>                      
                        <th>Total</th> 
                        <th>Tanggal</th>
                      </tr>
                    </thead>
                    <tbody>
                                            @for($i=0;$i<count($sales_vc);$i++)
                        
                        <tr>
                            <td>{{ ucwords(strtolower($sales_vc[$i]['retailer'])) }} - {{ $val['qr_code']}}</td>
                            <td class="text-center">{{ $sales_vc[$i]['product'] }}</td>
                            <td class="text-right">{{ $sales_vc[$i]['quantity'] }}</td>
                            <td class="text-right">{{ number_format($sales_vc[$i]['price'],0,",",".") }}</td>
                            <td class="text-center">{{ $arr_pay_method[$val['pay_method']] }}</td>
                            <td class="text-right">{{ number_format(($sales_vc[$i]['price'] * $sales_vc[$i]['quantity']),0,",",".") }}</td>
                            <td class="text-right">{{ $sales_vc[$i]['sales_date'] }}</td>
                        </tr>                            
                                              @endfor
                    </tybody>
                    <tfoot>
                      <tr>
                        <td colspan="4" class="text-right font-weight-bold"><h6>Total:</h6></td>
                        <td class="text-right text-secondary font-weight-bold"><h6>{{ number_format($total_vc,0,",",".") }}</h6></td>
                        <td>&nbsp;</td>
                      </tr>
                    </tfoot>
                   </table> 
                   <h5>eVoucher</h5>   
                   <table id="evtable" class="table table-hover">
                    <thead>
                      <tr class="text-center">                        
                        <th>MSISDN</th>
                        <th>Saldo</th>
                        <th>Terjual (Rp)</th>                 
                        <th>Tanggal</th>              
                      </tr>
                    </thead>
                    <tbody>
                                          @for($i=0;$i<count($sales_ev);$i++)
                        
                        <tr>
                            <td>{{ $sales_ev[$i]['msisdn'] }}</td>                            
                            <td class="text-right">{{ $sales_ev[$i]['saldo_sore'] }}</td>
                            <td class="text-right">{{ number_format($sales_ev[$i]['sold'],0,",",".") }}</td> 
                            <td class="text-right">{{ $sales_ev[$i]['sales_date'] }}</td>
                        </tr>                            
                                              @endfor
                    </tbody>
                    <tfoot>
                      <tr>
                        <td colspan="2" class="text-right font-weight-bold"><h6>Total:</h6></td>
                        <td class="text-right text-secondary font-weight-bold"><h6>{{ number_format($total_ev,0,",",".") }}</h6></td>
                        <td>&nbsp;</td>
                      </tr>
                    </tfoot>
                   </table> 
                   
                   <div class="col-12 text-left">                     
                   <h4>Total Sales: <span class="text-primary">{{ number_format(($total_vc+$total_ev),0,",",".") }}</span></h4>
                    @role('Teritory Manager')
                     <a href="{{ route('salesreport.index') }}" class="btn btn-light mr-2"><i class="ik ik-home"></i> Kembali</a>                     
                     <a href="{{ route('salesreport.excel',$id_sme) }}" class="btn btn-success"><i class="ik ik-briefcase"></i> Excel Report</a>
                    @else                    
                    <a href="{{ route('srm.index') }}" class="btn btn-light mr-2"><i class="ik ik-home"></i> Kembali</a>                     
                    <a href="{{ route('srm.excelsme',$id_sme) }}" class="btn btn-success"><i class="ik ik-briefcase"></i> Excel Report untuk {{ ucwords(strtolower($sme)) }}</a>
                    @endrole                     
                   </div>
          </div>
          
      </div>      
      <div class="col-md-2">&nbsp;</div>
  </div>
</div><!-- container-fluid -->
@endsection