@extends('Utama.master')
@section('sidebar')
<li class="nav-item d-none d-sm-inline-block">
        <a href="#" class="nav-link">Pelatihan dan Sertifikasi Profesional</a>
</li>
<li class="nav-item d-none d-sm-inline-block">
        <a href="#" class="nav-link"></a>
</li>
@stop
@section('content')
    <!-- Main content -->
    <section class="content">
      <div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-header">
                <h3 class="card-title">Pelatihan dan Sertifikasi Profesional</h3>

                <div class="card-tools">
                </div>
                  <div class="float-right mr-3">
                    <div id="dvjson"></div>
                    <button type="button" class="btn btn-sm btn-primary hide-role-userrr" style="margin-top:-.3rem" onclick="export_to_excel()">Ekspor ke excel</button>
                </div>
              </div>
              <!-- /.card-header -->
              <div class="card-body table-responsive p-0" style="height: 500px;">
                <table class="table table-sort table-arrows table-striped table-bordered table-sm">
                  <thead>
                    <tr>
                      <th>No</th>
                      <th>NIP</th>
                      <th>Nama Lengkap</th>
                      <th>Nama Pelatihan/Sertifikasi</th>
                      <th colspan="2">Aksi</th>
                    </tr>
                  </thead>
                  <tbody id="data-output">
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
        </div>
    </section>
    <!-- /.content -->
@stop 
@push('js')
<script type="text/javascript">
  // var url_api = "http://103.77.207.53:8000/api/";
    var url_api = "https://apisdm.ukitoraja.ac.id/api/"; 
  var _data_json = null;
  $(document).ready(function(){
    load_data(); //panggil fungsi untuk ambil data
    load_data_excel();
  });

  function tableHtmlToExcel(tableID, filename = ''){
    var downloadLink;
    var dataType = 'application/vnd.ms-excel';
    var tableSelect = document.getElementById(tableID);
    var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');
   
    filename = filename?filename+'.xls':'excel_data.xls';
   
    downloadLink = document.createElement("a");
    
    document.body.appendChild(downloadLink);
    
    if(navigator.msSaveOrOpenBlob){
        var blob = new Blob(['\ufeff', tableHTML], {
            type: dataType
        });
        navigator.msSaveOrOpenBlob( blob, filename);
    }else{
        downloadLink.href = 'data:' + dataType + ', ' + tableHTML;
   
        downloadLink.download = filename;
       
        downloadLink.click();
    }
}

function export_to_excel(){
    if(_data_json != null){
   $("#dvjson").excelexportjs({
  containerid:"dvjson",
  datatype:'json',
  dataset: _data_json,
  columns: getColumns(_data_json)    
});
}
  }

  function load_data_excel(){
    $.ajax({
      url : url_api+"pelatihan-profesional/exportData",
      method:"GET",
      data:{
        _token : "{{csrf_token()}}"
      },
      headers: {"Authorization": "Bearer " + getCookie("passport_token")},
      success:function(data){
        var output = "";
        console.log(data);
        _data_json = data;
      },error:function(){

      }
    });
  }

  function load_data(){ //ambil data
       $.ajax({
      url: url_api+"user/getData?data=pelatihan-profesional", //url api untuk data karyawan (inner join cuti)
      method:"GET",
      data:{
        _token : "{{csrf_token()}}"
      },
      headers: {"Authorization": "Bearer " + getCookie("passport_token")},
      success:function(data){
        var output = "";
        console.log(data);
         $.each(data,function(k,v){
          output += '<tr>' +
                      '<td>'+ (k+1) +'</td>' +
                      '<td>'+ v.nip +'</td>' +
                      '<td>'+ v.nama_lengkap+'</td>'+
                      '<td>'+ v.nama_ps+'</td>'+
                      '<td><button type="button" class="btn btn-info"><a style="color:white" href="/SertifikasiProfesionalHistori?id_user='+v.id_user+'">Histori</a></button></td>'; 
                      if(!(_role == "user" || _role=="kepala-unit")){
                        output += '<td><button type="button" class="btn btn-primary"><a style="color:white" href="/SertifikasiProfesionalTambah?id_user='+v.id_user+'">Tambah</a></button></td>'; 
                      }
                      output +='</tr>'; 
         });
         $('#data-output').html(output);
      },error:function(jqXHR, textStatus, errorThrown){
        console.log("error");
        alert(errorThrown); //pesan error
      }
    });
    }
</script>
@endpush