@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 untuk Area {{ Auth::user()->myarea }} </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-12">
          <div class="card">
              <div class="card-header">
                @if($startdate == "" && $enddate == "")
                <h4>Sales Report: {{ date("j F Y") }}</h4>
                @else
                <h4>Sales Report: {{ $datestring }}</h4>
                @endif
              </div>
              <div class="card-body">
              @if($message = Session::get('success'))
                <div class="alert alert-danger alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                  <h4><i class="ik ik-alert-circle"></i> Error!</h4>
                  <p>{{ $message }}</p>
                </div>
                @endif
              <form method="POST" action="{{ route('salesreport.date') }}" class="form-inline">
                @csrf
                <div class="row mb-20">
                  <div class="col-5 text-right">
                    <label for="startdate" class="font-weight-bold">Tanggal Awal</label>
                    <input type="date" class="form-control mb-2 mr-sm-2" name="startdate" required="required" value="04/02/2020">                    
                  </div>
                  <div class="col-5 text-right">
                    <label for="enddate" class="font-weight-bold">Tanggal Akhir</label>
                    <input type="date" class="form-control mb-2 mr-sm-2" name="enddate" required="required">
                  </div>
                  <div class="col-2 mt-1 text-right">
                    <label>&nbsp;</label>
                    <input type="hidden" name="intervaldate" value="1"/>
                    <input type="submit" class="btn btn-warning" name="submit" value="Submit"/>                    
                  </div>
                  
                </div>                                
              </form>
                                            
                  <table id="userstable" class="table table-hover">
                    <thead>
                      <tr class="text-center">                        
                        <th rowspan="2" class="align-middle">SME</th>
                        <th colspan="{{ count($products) }}">Voucher Card (Rp)</th>
                        
                        <th rowspan="2" class="align-middle">EVoucher (Rp)</th>       
                        <th rowspan="2" class="align-middle">Total (Rp)</th>               
                        <th rowspan="2" class="align-middle">Tanggal</th>  
                      </tr>
                      <tr>
                        @foreach($products as $val)
                          <th>{{ $val->name}}</th>
                        @endforeach
                      </tr>
                    </thead>      
                    <tbody>
                                            @foreach($sales as $key => $val)                      
                                                @for($i=0;$i<count($val);$i++)
                                                  @if($rowspan > 1)
                            @if($i == 0)
                              <tr>
                                <td rowspan="{{ $rowspan }}"><a href=" {{ route('salesreport.sme',$val[$i]['id_sales']) }}?start={{$startdate}}&end={{ $enddate}}"  
                                        class="btn btn-link">{{ ucwords(strtolower($key)) }}</a>
                                </td>
                                @foreach($val[$i]['sales_vc'] as $val0)
                                      @foreach($val0 as $key1 => $val1)                            
                                      <td class="text-right">{{ $val1 !="" ? number_format($val1,0,",",".") : 0}}</td>  
                                                                              @endforeach
                                    @endforeach
                                <td class="text-right">{{ number_format($val[$i]['sales_ev'],0,",",".") }}</td>
                                                                    <td class="text-right">{{ number_format($jumlah_sales_sme,0,",",".") }}</td>
                                  <td class="text-right">{{ $val[$i]['sales_date'] }}</td>
                              </tr>
                                                          @else
                              <tr>
                                @foreach($val[$i]['sales_vc'] as $val0)
                                  @foreach($val0 as $key1 => $val1)                            
                                      <td class="text-right">{{ $val1 !="" ? number_format($val1,0,",",".") : 0}}</td>  
                                                                          @endforeach
                                @endforeach
                                <td class="text-right">{{ number_format($val[$i]['sales_ev'],0,",",".") }}</td>
                                                                    <td class="text-right">{{ number_format($jumlah_sales_sme,0,",",".") }}</td>
                                  <td class="text-right">{{ $val[$i]['sales_date'] }}</td>
                              </tr>
                                                          @endif
                          @else
                              <tr>
                                <td><a href=" {{ route('salesreport.sme',$val[$i]['id_sales']) }}?start={{$startdate}}&end={{ $enddate}}"  
                                        class="btn btn-link">{{ ucwords(strtolower($key)) }}</a></td>                        
                                    @foreach($val[$i]['sales_vc'] as $val0)
                                      @foreach($val0 as $key1 => $val1)                            
                                      <td class="text-right">{{ $val1 !="" ? number_format($val1,0,",",".") : 0}}</td>  
                                                                              @endforeach
                                    @endforeach
                                <td class="text-right">{{ number_format($val[$i]['sales_ev'],0,",",".") }}</td>
                                                                    <td class="text-right">{{ number_format($jumlah_sales_sme,0,",",".") }}</td>
                                  <td class="text-right">{{ $val[$i]['sales_date'] }}</td>
                              </tr>
                                                          @endif
                          
                            @endfor
                      @endforeach
                    </tbody>    
                    <tfoot>
                      <tr>
                        <td class="text-right font-weight-bold"><h6>Total Sales:</h6></td>   
                        @foreach($sum_sales_vc as $key => $val)
                        <td class="text-right text-secondary font-weight-bold"><h6>{{ number_format($val,0,",",".") }}</h6></td>
                        @endforeach                     
                        <td class="text-right text-secondary font-weight-bold"><h6>{{ number_format($jumlah_sales_ev,0,",",".") }}</h6></td>
                        <td class="text-right text-secondary font-weight-bold"><h6>{{ number_format($jumlah_sales_ev_vc,0,",",".") }}</h6></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td colspan="{{ 4 + count($products) - 1 }}">&nbsp;</td>
                        <td class="text-right">
                          <a href="{{ route('salesreport.excel',rand(1,99)) }}" class="btn btn-success" style="margin-left: 15px;"><i class="ik ik-download"></i>&nbsp;Export Report to Excel</a>
                        </td>   
                      </tr>
                    </tfoot>          
                   </table>                                                                                  
          </div>
          
      </div>            
  </div>
</div><!-- container-fluid -->
@endsection