@extends('layouts.app')

@section('content')
<div class="container-fluid">

    <!-- start page title -->
    <div class="row">
        <div class="col-12">
            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                <h4 class="mb-sm-0">Detail Wilayah</h4>

                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="javascript: void(0);">Input Data</a></li>
                        <li class="breadcrumb-item active">{{$title}}</li>
                    </ol>
                </div>

            </div>
        </div>
    </div>
    <!-- end page title -->

    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div class="row justify-content-start mb-2">
                        {{-- <div class="col-md-2">
                            <button class="btn btn-primary col-md-12 btn-tambah-program"><i class="mdi mdi-plus"></i> Tambah</button>
                        </div> --}}
                    </div>
                    {{-- <h4 class="card-title">Pengguna</h4> --}}
                    {{-- <p class="card-title-desc">DataTables has most features enabled by
                        default, so all you need to do to use it with your own tables is to call
                        the construction function: <code>$().DataTable();</code>.
                    </p> --}}
                    <div class="table-responsive">
                        {{-- <form action="{{url('import_DetailWilayah')}}" method="post" enctype="multipart/form-data">
                            @csrf
                            <div class="row">
                                <div class="col-10">
                                    <label for="">Contoh File Import : <a href="{{asset('import/DetailWilayah Example.xlsx')}}" target="_blank">Download</a></label>
                                    <input type="file" name="excel_file" class="form-control" id="">
                                </div>
                                <div class="col-2">
                                    <label for="">-</label><br>
                                    <button type="submit" class="btn btn-success">Import</button>
                                    <a href="{{url("/export_DetailWilayah")}}" class="btn btn-primary">Export</a>
                                </div>
                            </div>
                        </form> --}}
                        <div class="row justify-content-start mb-2">
                            <div class="col-md-10 d-flex justify-content-around gap-3">
                                @if(Auth::user()->downloadFile('DetailWilayah', Session::get('year')))
                                <form action="/upload/general" method="post" class="d-flex gap-5" enctype="multipart/form-data">
                                    @csrf
                                    <input type="hidden" name="name" value="DetailWilayah" id="">
                                    <input type="file" name="file_upload" id="" {{Auth::user()->downloadFile('DetailWilayah', Session::get('year'))->status == 1 ?"disabled":""}} class="form-control" placeholder="upload PDF file">
                                    <button type="submit" class="btn btn-success" {{Auth::user()->downloadFile('DetailWilayah', Session::get('year'))->status == 1?"disabled":""}}>Upload</button>

                                </form>
                                @else
                                <form action="/upload/general" method="post" class="d-flex gap-5" enctype="multipart/form-data">
                                    @csrf
                                    <input type="hidden" name="name" value="DetailWilayah" id="">
                                    <input type="file" name="file_upload" id="" class="form-control" placeholder="upload PDF file">
                                    <button type="submit" class="btn btn-success">Upload</button>

                                </form>
                                @endif
                                @if(Auth::user()->hasFile('DetailWilayah', Session::get('year')) && Auth::user()->downloadFile('DetailWilayah', Session::get('year'))->file_name != "-")
                                    <a type="button" class="btn btn-warning" href="{{ Auth::user()->downloadFile('DetailWilayah', Session::get('year'))->file_path.Auth::user()->downloadFile('DetailWilayah', Session::get('year'))->file_name }}" download="" ><i class="mdi mdi-note"></i>Download pdf file</a>
                                @endif
                                <a type="button" class="btn btn-warning" href="{{url("/export_DetailWilayah")}}" ><i class="mdi mdi-note"></i>Report</a>
                            </div>
                        </div>
                        <br>
                        <table id="data" class="table table-bordered dt-responsive" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                            <thead class="text-center">
                            <tr>
                                <th rowspan="2">No</th>
                                <th rowspan="2">Unit Kerja</th>
                                <th rowspan="2">Luas Wilayah (km2)</th>
                                <th colspan="3">Jumlah</th>
                                <th rowspan="2">Jumlah penduduk</th>
                                <th rowspan="2">Jumlah rumah tangga</th>
                                <th rowspan="2">rata rata jiwa/rumah tangga</th>
                                <th rowspan="2">Kepadatan Penduduk per km2</th>
                            </tr>
                            <tr>
                                <th>Desa</th>
                                <th>Kelurahan</th>
                                <th>Desa + Kelurahan</th>
                            </tr>
                            </thead>
                            <tbody>
                                @role('Admin|superadmin')
                                @foreach ($unit_kerja as $key => $item)
                                @php
                                    $status = $item->status;
                                    $isDisabled = $status == 2?"Disabled":"";
                                @endphp
                                <tr style={{$key % 2 == 0?"background: gray":""}}>
                                    <td>{{$key + 1}}</td>
                                    <td>{{$item->nama}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="luas_wilayah" id="{{$item->id}}" value="{{$item->luas_wilayah}}" class="form-control data-input" style="border: none"></td>
                                    
                                    <td>{{$item->Desa()->count()}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="kelurahan" id="{{$item->id}}" value="{{$item->kelurahan}}" class="form-control data-input" style="border: none"></td>
                                    
                                    <td id="desaKelurahan{{$item->id}}">{{$item->Desa()->count() + $item->kelurahan}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="jumlah_penduduk" id="{{$item->id}}" value="{{$item->jumlah_penduduk}}" class="form-control data-input" style="border: none"></td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="jumlah_rumah_tangga" id="{{$item->id}}" value="{{$item->jumlah_rumah_tangga}}" class="form-control data-input" style="border: none"></td>
                                    
                                    <td id="rata_rata_rumah_tangga{{$item->id}}">{{$item->jumlah_rumah_tangga > 0 ? number_format(($item->jumlah_penduduk/($item->jumlah_rumah_tangga))*100, '2'):0}}%</td>

                                    <td id="kepadatan_penduduk{{$item->id}}">{{$item->luas_wilayah > 0 ? number_format(($item->jumlah_penduduk/($item->luas_wilayah))*100, '2'):0}}%</td>
                                </tr>
                                @endforeach
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td>{{$total_luas_wilayah}}</td>
                                        <td>{{$total_desa}}</td>
                                        <td>{{$total_kelurahan}}</td>
                                        <td>{{$total_kelurahan + $total_desa}}</td>
                                        <td>{{$total_jumlah_penduduk}}</td>
                                        <td>{{$total_jumlah_rumah_tangga}}</td>
                                        <td>{{$total_jumlah_rumah_tangga > 0?number_format(($total_jumlah_penduduk/$total_jumlah_rumah_tangga) * 100, '2'):0}}%</td>
                                        <td>{{$total_luas_wilayah > 0?number_format(($total_jumlah_penduduk/$total_luas_wilayah) * 100, '2'):0}}%</td>
                                    </tr>
                                @endrole
                            </tbody>
                        </table>
                    </div>

                </div>
            </div>
        </div> <!-- end col -->
    </div> <!-- end row -->


</div>

<div class="modal fade" tabindex="-1">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="title">Tambah Program</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
        </div>
        <div class="modal-body">

        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
          <input type="submit" value="Submit" class="btn btn-primary" id="submitButton" form="storeForm">
        </div>
        {!! Form::close() !!}
      </div>
    </div>
  </div>

@push('scripts')
    <!-- Required datatable js -->
    <script src="{{asset('assets/libs/datatables.net/js/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js')}}"></script>
    <!-- Buttons examples -->
    <script src="{{asset('assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js')}}"></script>
    <script src="{{asset('assets/libs/jszip/jszip.min.js')}}"></script>
    <script src="{{asset('assets/libs/pdfmake/build/pdfmake.min.js')}}"></script>
    <script src="{{asset('assets/libs/pdfmake/build/vfs_fonts.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-buttons/js/buttons.html5.min.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-buttons/js/buttons.print.min.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-buttons/js/buttons.colVis.min.js')}}"></script>
    <!-- Responsive examples -->
    <script src="{{asset('assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js')}}"></script>
    <script src="{{asset('assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js')}}"></script>

@endpush

@push('scripts')
    <script>
        // var table = $('#datatable').DataTable({
        //     responsive:false,
        //     processing: true,
        //     serverSide: true,
        //     order: [[ 0, "asc" ]],
        //     ajax: {
        //         'url': '{{ route("datatable.sub_kegiatan") }}',
        //         'type': 'GET',
        //         'beforeSend': function (request) {
        //             request.setRequestHeader("X-CSRFToken", '{{ csrf_token() }}');
        //         },
        //         data: function (d) {
        //             d.kegiatan_id = $('#kegiatan_id').val();
        //         },
        //     },
        //     columns: [
        //         {data:'kode',name:'kode'},
        //         {data:'nama',name:'nama'},
        //         {data:'sasaran',name:'sasaran'},
        //         {data: 'indikator', name:'indikator'}
        //     ],
        // });

        $('#data').on('input', '.data-input', function(){
		let name = $(this).attr('name');
		let value = $(this).val();
		let data = {};
        var url_string = window.location.href;
         var url = new URL(url_string);
        let params = url.searchParams.get("year");
        let id = $(this).attr('id');
        let desaKelurahan = $(this).parent().parent().find(`#desaKelurahan${id}`);
        let rata_rata_rumah_tangga = $(this).parent().parent().find(`#rata_rata_rumah_tangga${id}`);
        let kepadatan_penduduk = $(this).parent().parent().find(`#kepadatan_penduduk${id}`);

		$.ajaxSetup({
			headers: {
				'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
			}
		});

		$.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("DetailWilayah.store") }}',
			'data'	: {'name' : name, 'value' : value, 'id': id},
			success	: function(res){
                desaKelurahan.text(`${res.desaKelurahan}`);
                rata_rata_rumah_tangga.text(`${res.rata_rata_rumah_tangga}%`);
                kepadatan_penduduk.text(`${res.kepadatanPenduduk}%`);
			}
		});

        console.log(name, value, id, params);
        })
    </script>
@endpush
@endsection