@extends("crudbooster::admin_template")
@section('content')
<style type="text/css">
  input::-webkit-outer-spin-button,
  input::-webkit-inner-spin-button {
  /* display: none; <- Crashes Chrome on hover */
  -webkit-appearance: none;
  margin: 0; /* <-- Apparently some margin are still there even though it's hidden */
}
td{
  font-size:18px;
}
#title{
  font-weight: bold;
}
#tahun{
  padding-right:20px;font-size:18px;font-weight:bold;
}
input{
  padding:2px;
}
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<?php
  $data = DB::table('target_sales')
  ->groupBy('tahun')
  ->where('id_sales',Request::segment(4))
  ->get();
?>

@if(Session::has('berhasil'))
    <div class="alert alert-success top30 fade in">
      <i class="fa fa-check-square epallert" aria-hidden="true"></i>
       {!! Session::get('berhasil') !!}
      <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
    </div>
@endif
<a href="../../list_sales"><i class="fa fa-chevron-circle-left "> Back To List Data Sales</i></a>
<br>
<br>
<?php $sales = DB::table('sales')->where('id',Request::segment(4))->first(); ?>
<div class="box box-primary">
  <div class="box-body" id="box">
  <div class="container" style="max-width:1050px">
    <div class="table-responsive">          
    <table class="table">
      <thead>
        <tr>
          <th>Name</th>
          <th>NIK</th>
          <th>Email</th>
          <th>Photo</th>
          <th>Phone 1</th>
          <th>Phone 2</th>
          <th>Phone 3</th>
          <th>Instagram</th>
          <th>Facebook</th>
          <th>Twitter</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td>{{$sales->nama}}</td>
          <td>{{$sales->nik}}</td>
          <td>{{$sales->email}}</td>
          <td>
            <a data-lightbox="roadtrip" title="Detail photo" href="{{asset($sales->photo)}}">
              <img src="{{asset($sales->photo)}}" style="width:50px">
            </a>
          </td>
          <td>{{$sales->no_telp}}</td>
          <td>{{$sales->no_telp_1}}</td>
          <td>{{$sales->no_telp_2}}</td>
          <td>
            @if($sales->instagram!='')
              <a href="http://instagram.com/{{$sales->instagram}}" target="_blank"><button class="btn btn-md btn-primary">Instagram</button></a>
            @else
              -
            @endif
          </td>
          <td>
            @if($sales->facebook!='')
              <a href="http://facebook.com/{{$sales->facebook}}" target="_blank"><button class="btn btn-md btn-primary">Facebook</button></a>
            @else
              -
            @endif
          </td>
          <td>
             @if($sales->twitter!='')
                <a href="http://twitter.com/{{$sales->twitter}}" target="_blank"><button class="btn btn-md btn-info">Twitter</button></a>
             @else
                -
             @endif
          </td>
        </tr>
      </tbody>
    </table>
  </div>
  </div>
  <hr>
  <form autocomplete="off" method="post" action="{{ action('AdminSalesController@postTarget') }}" enctype="multipart/form-data">   
    <input type="hidden" name="_token" value="{{ csrf_token() }}" />
    <div class="container" style="overflow-x: scroll;max-width:1050px">
  @if(count($data)!=0)
       <table id="myTable" class="order-list table table-bordered">
       <thead>
          <tr>
            <td id="title">Tahun</td>
            <td id="title">Januari</td>
            <td id="title">Februari</td>
            <td id="title">Maret</td>
            <td id="title">April</td>
            <td id="title">Mei</td>
            <td id="title">Juni</td>
            <td id="title">Juli</td>
            <td id="title">Agustus</td>
            <td id="title">September</td>
            <td id="title">Oktober</td>
            <td id="title">November</td>
            <td id="title">Desember</td>
          </tr>
      </thead>
      @foreach($data as $item)
        <?php
          $detail_data = DB::table('target_sales')
          ->where('id_sales',Request::segment(4))
          ->where('tahun',$item->tahun)
          ->get();
        ?>
        <tbocy>
          <tr>
            <td ><p id="tahun">{{$item->tahun}}</p></td>
            @foreach($detail_data as $dd)
              <?php
                $data = date('Y-m-d', strtotime(''.$dd->tahun.'-'.$dd->bulan.'-'.date('d').''));
                $data_now = date('Y-m-d');
              ?>
            <td>
              <?php
                $id_sales_spv = DB::table('sales')
                ->where('id',Request::segment(4))
                ->first();
              ?>
              <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="id_sales_spv[]" value="{{$id_sales_spv->id_sales_spv}}">
              <input type="hidden" name="id[]" value="{{$dd->id}}" />
              <input type="hidden" name="bulan[]" value="{{$dd->bulan}}" />
              <input type="hidden" name="tahun[]"  value="{{$dd->tahun}}" />
              @if($data < $data_now && $dd->target!=0)
                <input type="text" required value="{{$dd->target}}" readonly name="target[]"   style="cursor: not-allowed;" />
              @else
                <input type="text" required value="{{$dd->target}}" name="target[]"   />
              @endif
            </td>
            @endforeach
          </tr>
      </tbocy>
      @endforeach
</table>
</div>
<br>
<input type="button" id="addrow" class="btn btn-md- btn-success" value="Tambah Tahun" />
<input type="submit" class="btn btn-md- btn-primary" value="Simpan" />
</form>
@else
<form autocomplete="off" method="post" action="{{ action('AdminSalesController@postTarget') }}" enctype="multipart/form-data">   
  <input type="hidden" name="_token" value="{{ csrf_token() }}" />
  <table id="myTable" class="table table-bordered order-list">
      <thead>
          <tr>
            <td id="title">Tahun</td>
            <td id="title">Januari</td>
            <td id="title">Februari</td>
            <td id="title">Maret</td>
            <td id="title">April</td>
            <td id="title">Mei</td>
            <td id="title">Juni</td>
            <td id="title">Juli</td>
            <td id="title">Agustus</td>
            <td id="title">September</td>
            <td id="title">Oktober</td>
            <td id="title">November</td>
            <td id="title">Desember</td>
          </tr>
      </thead>
      <tbody>
          <tr>
            <td>
              <p id="tahun">{{date('Y')}}
              </p>
            </td>
            <td>
              <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="1" />
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
              <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="2" />
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="3"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="4"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="5"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="6"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="7"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="8"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="9"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="10"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="11"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td>
            <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}">
              <input type="hidden" name="bulan[]" value="12"/>
              <input type="hidden" name="tahun[]" value="{{date('Y')}}" />
              <input type="text" required value="0" name="target[]"    />
            </td>
            <td><a class="deleteRow"></a>
            </td>
          </tr>
      </tbody>
  </table>
</div>
<br>
<input type="button" id="addrow" class="btn btn-md- btn-success" value="Tambah Tahun" />
<input type="submit" class="btn btn-md- btn-primary" value="Simpan" />
</form>
@endif
</div>
</div>

@push('bottom')
<script src='{{asset("vendor/crudbooster/jquery.price_format.2.0.min.js")}}'></script>
<script type="text/javascript">  
 $(document).ready(function () {
  // webshims.setOptions('forms-ext', {
  //     replaceUI: 'auto',
  //     types: 'text'
  //   });

    $('input[type=text]').priceFormat({
           'prefix':'',
          'thousandsSeparator' : ',',
          'centsLimit': '0',
          'clearOnEmpty':false,
        });
    
    $("#addrow").on("click", function () {
        var d = new Date();
        var n = d.getFullYear();
        var counter = n+1+$('#myTable tr').length - 2;
        var newRow = $("<tr>");
        var cols = "";

        cols += '<td><p id="tahun">'+counter+'</p></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="1" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="2" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="3" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="4" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="5" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="6" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="7" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="8" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="9" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="10" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="11" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        cols += '<td> <input type="hidden" name="id_sales[]" value="{{Request::segment(4)}}"> <input type="hidden" name="bulan[]" value="12" /><input type="hidden" name="tahun[]" value='+counter+' /><input type="text" required value="0" name="target[]"    /></td>';
        newRow.append(cols);
        $("table.order-list").append(newRow);
        // webshims.polyfill('forms forms-ext');
        $('input[type=text]').priceFormat({
           'prefix':'',
          'thousandsSeparator' : ',',
          'centsLimit': '0',
          'clearOnEmpty':false,
        });
        counter++;
    });

    
    
});
</script>

@endpush 
@endsec