@section('title')
<title>Data Laporan</title>
@stop
@extends('layouts.admin.app')
@section('content')

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            Dashboard
            {{-- <small>Control panel</small> --}}
        </h1>
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Dashboard</li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">
        <!-- Main row -->
        <div class="row">

            <section class="col-lg-12">
                <div class="box">
                    <div class="box-header">
                        <i class="fa fa-bar-chart"></i>Chart Konsultasi 1 tahun
                    </div>
                    <!-- /.box-header -->
                    <div class="box-body">

                        {!! $chartKonsultasi->container() !!}

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </section>

            <section class="col-lg-4">
                <div class="box">
                    <div class="box-header">
                        <i class="fa fa-bar-chart"></i>Chart Konsultasi 1 tahun selesai Dengan Solusi/tidak ada solusi
                    </div>
                    <!-- /.box-header -->
                    <div class="box-body">

                        {!! $chartPie->container() !!}

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </section>

            <section class="col-lg-4">
                <div class="box">
                    <div class="box-header">
                        <i class="fa fa-bar-chart"></i>Chart Inkubarot 1 Tahun
                    </div>
                    <!-- /.box-header -->
                    <div class="box-body">

                        {!! $chartPiesInkubator->container() !!}

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </section>

            <section class="col-lg-4">
                <div class="box">
                    <div class="box-header">
                        <i class="fa fa-bar-chart"></i>Chart HKI 1 Tahun
                    </div>
                    <!-- /.box-header -->
                    <div class="box-body">

                        {!! $chartHki->container() !!}

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </section>

            <section class="col-lg-12 connectedSortable">
                <div class="box box-success">
                    <div class="box-header with-border">
                        <h3 class="box-title">List Inkubator</h3>

                        <div class="box-tools pull-right">
                            <button type="button" class="btn btn-box-tool" data-widget="collapse"><i
                                    class="fa fa-minus"></i></button>
                        </div>
                    </div>
                     <div class="box-body">
                        <div class="nav-tabs-custom">
                            <ul class="nav nav-tabs pull-right">
                                <li><a href="#HKI" data-toggle="tab">HKI</a></li>
                                <li><a href="#Inkubator" data-toggle="tab">Inkubator</a></li>
                                <li class="active"><a class="batang" href="#Konsultasi"
                                    data-toggle="tab">Konsultasi</a></li>
                                <li class="pull-left header"><i class="fa fa-file-powerpoint-o"></i>List Laporan</li>
                            </ul>
                            @if (!isset($xawal))
    
                                <form action="{{ route('Laporan') }}">
                                    @csrf
                                    <center>
                                        <select style="widht:200px" name="awal" id="tahun">
                                            <option>--Select Tahun--</option>
                                            @foreach ($dateRange as $year)
                                                <option value="{{ $year }}">{{ $year }}</option>
                                            @endforeach
                                        </select>
                                        <button class="btn btn-info">
                                            CARI
                                        </button>
                                    </center>
                                </form>
                            @else
                                <form action="{{ route('Laporan') }}">
                                    @csrf
                                    <center>
                                        <select style="widht:200px" name="awal" id="tahun">
                                            <option>--Select Tahun--</option>
                                            @foreach ($dateRange as $year)
                                                <option value="{{ $year }}" {{ $xawal == $year ? 'selected' : '' }}>
                                                    {{ $year }}</option>
                                            @endforeach
                                        </select>
                                        <button class="btn btn-info">
                                            CARI
                                        </button>
    
                                        <a class="btn btn-danger" id="export">
                                            EXPORT PDF
                                        </a>
    
                                    </center>
                                </form>
                            @endif
                            <div class="tab-content no-padding">
                                <!-- Morris chart - Sales -->
                                <div class="tab-pane active" style="position: relative; height: 300px;" id="Konsultasi">
                                    <div class="col-lg-12">
                                        <div class="table-responsive">
    
                                            <table id="example1" class="table table-bordered table-striped">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Judul Konsultasi</th>
                                                        <th>Nama Unit Usaha</th>
                                                        <th>Nama User </th>
                                                        <th>Aspek</th>
                                                        <th>Kendala Yang Dialami User</th>
                                                        <th>Kategori</th>
                                                        <th>Status</th>
                                                        <th>Keterangan Admin</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach ($listDataKonsultasi as $e => $ldk)
                                                        <tr>
                                                            <td>{{ $e + 1 }}</td>
                                                            <td>{{ $ldk->title }}</td>
                                                            <td>{{ $ldk->nama_unit_usaha }}</td>
                                                            <td>{{ $ldk->name }}</td>
                                                            <td>{{ $ldk->aspeks_name }}</td>
                                                            <td>{{ $ldk->kendala }}</td>
                                                            <td>{{ $ldk->kat_name }}</td>
                                                            <td>{{ $ldk->lable }}</td>
                                                            <td>{{ $ldk->keterangan_admin }}</td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
    
                                    </div>
    
                                </div>
                                <div class="chart tab-pane" id="Inkubator" style="position: relative; height: 300px;">
                                    <div class="col-lg-12">
                                        <div class="table-responsive">
    
                                            <table id="example2" class="table table-bordered table-striped">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Judul Konsultasi</th>
                                                        <th>Nama Unit Usaha</th>
                                                        <th>Nama User </th>
                                                        <th>Aspek</th>
                                                        <th>Kendala Yang Dialami User</th>
                                                        <th>Kategori</th>
                                                        <th>Status</th>
                                                        <th>Keterangan Admin</th>
    
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach ($listInkubator as $e => $li)
                                                        <tr>
                                                            <td>{{ $e + 1 }}</td>
                                                            <td>{{ $li->title }}</td>
                                                            <td>{{ $li->nama_unit_usaha }}</td>
                                                            <td>{{ $li->name }}</td>
                                                            <td>{{ $li->aspeks_name }}</td>
                                                            <td>{{ $li->kendala }}</td>
                                                            <td>{{ $li->kat_name }}</td>
                                                            <td>{{ $li->lable }}</td>
                                                            <td>{{ $li->keterangan_admin }}</td>
    
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <div class="chart tab-pane" id="HKI" style="position: relative; height: 300px;">
                                    <div class="col-lg-12">
                                        <div class="table-responsive">
                                            <table id="example3" class="table table-bordered table-striped">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Judul Konsultasi</th>
                                                        <th>Nama Unit Usaha</th>
                                                        <th>Nama User </th>
                                                        <th>Aspek</th>
                                                        <th>Kendala Yang Dialami User</th>
                                                        <th>Kategori</th>
                                                        <th>Status</th>
                                                        <th>Keterangan Admin</th>
    
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach ($listHki as $e => $lh)
                                                        <tr>
                                                            <td>{{ $e + 1 }}</td>
                                                            <td>{{ $lh->title }}</td>
                                                            <td>{{ $lh->nama_unit_usaha }}</td>
                                                            <td>{{ $lh->name }}</td>
                                                            <td>{{ $lh->aspeks_name }}</td>
                                                            <td>{{ $lh->kendala }}</td>
                                                            <td>{{ $lh->kat_name }}</td>
                                                            <td>{{ $lh->lable }}</td>
                                                            <td>{{ $lh->keterangan_admin }}</td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
    
                                    </div>
                                </div>
                            </div>
                        </div>
                     </div>
                </div>
            </section>

        </div>
        <!-- /.row (main row) -->

    </section>
    <!-- /.content -->
</div>

@endsection
@section('footer')
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.1/Chart.min.js" charset="utf-8"></script>
{!! $chartKonsultasi->script() !!}
{!! $chartPie->script() !!}
{!! $chartPiesInkubator->script() !!}
{!! $chartHki->script() !!}

<script>
    $().click();
    $(".js-example-basic-multiple-limit").select2({
        maximumSelectionLength: 2
    });
    $(function() {
        $('#example1').DataTable({
            'paging': true,
            'lengthChange': true,
            'searching': true,
            'ordering': false,
            'info': true,
            'autoWidth': false
        })
        $('#example2').DataTable({
            'paging': true,
            'lengthChange': true,
            'searching': true,
            'ordering': false,
            'info': true,
            'autoWidth': false
        })
        $('#example3').DataTable({
            'paging': true,
            'lengthChange': true,
            'searching': true,
            'ordering': false,
            'info': true,
            'autoWidth': false
        })
    })

    $("#export").click(function() {
        let tahun = $('#tahun option:selected').val();
        let datastr = "tahun=" + tahun;
        $.ajax({
            type: "get",
            url: '/printPdf',
            data: datastr,
            xhrFields: {
                responseType: 'blob' // to avoid binary data being mangled on charset conversion
            },
            beforeSend: function() {
                swal.fire({
                    html: '<h5> Sedang Dalam Proses Export Pdf... </h5>',
                    showConfirmButton: false,
                    onRender: function() {
                        // there will only ever be one sweet alert open.
                        $('.swal2-content').prepend(sweet_loader);
                    }
                });
            },
            success: function(blob, status, xhr) {
                // check for a filename
                var filename = "";
                var disposition = xhr.getResponseHeader('Content-Disposition');
                if (disposition && disposition.indexOf('attachment') !== -1) {
                    swal.fire({
                        icon: 'success',
                        html: '<h5>Success!</h5>'
                    });

                    var filenameRegex = /filename[^;=\n]*=((['"]).*?\2|[^;\n]*)/;
                    var matches = filenameRegex.exec(disposition);
                    if (matches != null && matches[1]) filename = matches[1].replace(/['"]/g, '');
                }

                if (typeof window.navigator.msSaveBlob !== 'undefined') {
                    // IE workaround for "HTML7007: One or more blob URLs were revoked by closing the blob for which they were created. These URLs will no longer resolve as the data backing the URL has been freed."
                    alert('sukses brow !!')
                    window.navigator.msSaveBlob(blob, filename);
                } else {
                    var URL = window.URL || window.webkitURL;
                    var downloadUrl = URL.createObjectURL(blob);

                    if (filename) {
                        // use HTML5 a[download] attribute to specify filename
                        var a = document.createElement("a");
                        // safari doesn't support this yet
                        if (typeof a.download === 'undefined') {
                            alert('sukses brow !!')
                            window.location.href = downloadUrl;
                        } else {
                            a.href = downloadUrl;
                            a.download = filename;
                            document.body.appendChild(a);
                            a.click();
                        }
                    } else {
                        window.location.href = downloadUrl;
                    }

                    setTimeout(function() {
                        URL.revokeObjectURL(downloadUrl);
                    }, 100); // cleanup
                }
            }
        });

    });
</script>

@stop