@extends('layouts.app')

@section('content')
<div class="container-fluid">
    @include('layouts.includes.sticky-table')

    <!-- 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">{{$title}}</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-10 d-flex justify-content-around gap-3">
                            @if(Auth::user()->downloadFile('StatusGizi', 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="StatusGizi" id="">
                                <input type="file" name="file_upload" id="" {{Auth::user()->downloadFile('StatusGizi', Session::get('year'))->status == 1 ?"disabled":""}} class="form-control" placeholder="upload PDF file">
                                <button type="submit" class="btn btn-success" {{Auth::user()->downloadFile('StatusGizi', 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="StatusGizi" 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('StatusGizi', Session::get('year')) && Auth::user()->downloadFile('StatusGizi', Session::get('year'))->file_name != "-")
                                <a type="button" class="btn btn-warning" href="{{ Auth::user()->downloadFile('StatusGizi', Session::get('year'))->file_path.Auth::user()->downloadFile('StatusGizi', 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="{{ route('StatusGizi.excel') }}" ><i class="mdi mdi-note"></i>Report</a>
                            <a type="button" class="btn btn-primary" href="{{ route('StatusGizi.add', ['year' => Session::get('year')]) }}"><i class="mdi mdi-plus"></i>Add</a>
                        </div>
                    </div>
                    <div class="table-responsive lock-header">
                        <table id="data" class="table table-bordered dt-responsive" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                            <thead class="text-center">
                            <tr style="width: 100%">
                                <th rowspan="2">No</th>
                                <th rowspan="2">Kecamatan</th>
                                @role('Admin|superadmin')
                                <th rowspan="2">Puskesmas</th>
                                @endrole
                                @role('Puskesmas|Pihak Wajib Pajak')
                                <th rowspan="2">Desa</th>
                                @endrole
                                <th rowspan="2">Jumlah Balita Yang Ditimbang</th>
                                <th colspan="2">Balita Berat Badan Kurang (BB/U)</th>
                                <th rowspan="2">Jumlah Balita Yang Diukur Tinggi Badan</th>
                                <th colspan="2">Balita Pendek (TB/U)</th>
                                <th rowspan="2">Jumlah Balita Yang Diukur Tinggi Badan</th>
                                <th colspan="2">Balita Kurang Gizi (BB/TB: < -2 s.d -3 SD)</th>
                                <th colspan="2">Balita Gizi Buruk(BB/TB: < -3 SD)</th>
                                @role('Admin|superadmin')
                                <th rowspan="2">Lock data</th>
                                <th rowspan="2">Lock upload</th>
                                <th rowspan="2">File Download</th>
                                <th rowspan="2">Detail Desa</th>
                                @endrole
                            </tr>
                            <tr>
                                <th>Jumlah</th>
                                <th>%</th>
                                <th>Jumlah</th>
                                <th>%</th>
                                <th>Jumlah</th>
                                <th>%</th>
                                <th>Jumlah</th>
                                <th>%</th>
                            </tr>
                            </thead>
                            <tbody>
                                @role('Admin|superadmin')
                                @foreach ($unit_kerja as $key => $item)
                                
                                <tr style={{$key % 2 == 0?"background: gray":""}}>
                                    <td>{{$key + 1}}</td>
                                    <td>{{$item->kecamatan}}</td> 
                                    <td class="unit_kerja">{{$item->nama}}</td> 
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_timbang')["total"]}}</td>
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'bb_kurang')["total"]}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_timbang')["total"] > 0?
                                    number_format($item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'bb_kurang')["total"]
                                    /$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_timbang')["total"] * 100, 2
                                    ):0}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_tinggi')["total"]}}</td>
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'tb_kurang')["total"]}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_tinggi')["total"] > 0?
                                    number_format($item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'tb_kurang')["total"]
                                    /$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_tinggi')["total"] * 100, 2
                                    ):0}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_gizi')["total"]}}</td>
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'gizi_kurang')["total"]}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_gizi')["total"] > 0?
                                    number_format($item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'gizi_kurang')["total"]
                                    /$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_gizi')["total"] * 100, 2
                                    ):0}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'gizi_buruk')["total"]}}</td>
                                    
                                    <td>{{$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_gizi')["total"] > 0?
                                    number_format($item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'gizi_buruk')["total"]
                                    /$item->unitKerjaAmbil('filterStatusGizi', Session::get('year'), 'jumlah_gizi')["total"] * 100, 2
                                    ):0}}</td>
                                    <td><input type="checkbox" name="lock" {{$item->general_lock_get(Session::get('year'), 'filterStatusGizi') == 1 ? "checked":""}} {{$item->general_lock_get(Session::get('year'), 'filterStatusGizi') == 2 ? "disabled":""}} class="data-lock" id="{{$item->id}}"></td>
                                    @if(isset($item->user) && $item->user->downloadFile('StatusGizi', Session::get('year')))
                                    <td><input type="checkbox" name="lock_upload" {{$item->user->downloadFile('StatusGizi', Session::get('year'))->status == 1 ? "checked":""}} class="data-lock-upload" id="{{$item->user->id}}"></td>
                                    @elseif(isset($item->user) && !$item->user->downloadFile('StatusGizi', Session::get('year')))
                                    <td><input type="checkbox" name="lock_upload" class="data-lock-upload" id="{{$item->user->id}}"></td>
                                    @else
                                    <td>-</td>
                                    @endif
                                    @if(isset($item->user) && $item->user->hasFile('StatusGizi', Session::get('year')))
                                    <td>
                                        @if($item->user->downloadFile('StatusGizi', Session::get('year'))->file_name != "-")
                                        <a type="button" class="btn btn-warning" href="{{ $item->user->downloadFile('StatusGizi', Session::get('year'))->file_path.$item->user->downloadFile('StatusGizi', Session::get('year'))->file_name }}" download="" ><i class="mdi mdi-note"></i>Download pdf file</a>
                                        @else
                                        -
                                        @endif
                                    </td>
                                    @else
                                    <td>-</td>
                                    @endif
                                    <td style="white-space: nowrap"><button class="btn btn-success detail" id="{{$item->id}}">Detail desa</button></td>         

                                    
                                    
                                    
                                </tr>
                                @endforeach
                                @endrole
                                @role('Puskesmas|Pihak Wajib Pajak')
                                @foreach ($desa as $key => $item)
                                @if($item->filterStatusGizi(Session::get('year')))
                                @php
                                $filterResult = $item->filterStatusGizi(Session::get('year'));
                                $isDisabled = $filterResult->status == 1 || $filterResult->status == 2 ? "disabled" : "";
                                @endphp
                                <tr style='{{$key % 2 == 0?"background: #e9e9e9":""}}'>
                                    <td>{{$key + 1}}</td>
                                    <td>{{$item->UnitKerja->kecamatan}}</td>
                                    <td class="unit_kerja">{{$item->nama}}</td>
                                    <td><input type="number" {{$isDisabled}} name="jumlah_timbang" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->jumlah_timbang}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    <td><input type="number" {{$isDisabled}} name="bb_kurang" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->bb_kurang}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    
                                    <td id="timbang{{$item->filterStatusGizi(Session::get('year'))->id}}">{{$item->filterStatusGizi(Session::get('year'))->jumlah_timbang>0?
                                        number_format($item->filterStatusGizi(Session::get('year'))->bb_kurang
                                        /$item->filterStatusGizi(Session::get('year'))->jumlah_timbang * 100, 2):0}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="jumlah_tinggi" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->jumlah_tinggi}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    <td><input type="number" {{$isDisabled}} name="tb_kurang" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->tb_kurang}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    
                                    <td id="tinggi{{$item->filterStatusGizi(Session::get('year'))->id}}">{{$item->filterStatusGizi(Session::get('year'))->jumlah_tinggi>0?
                                        number_format($item->filterStatusGizi(Session::get('year'))->tb_kurang
                                        /$item->filterStatusGizi(Session::get('year'))->jumlah_tinggi * 100, 2):0}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="jumlah_gizi" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->jumlah_tinggi}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    <td><input type="number" {{$isDisabled}} name="tb_kurang" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->tb_kurang}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    
                                    <td id="gizi{{$item->filterStatusGizi(Session::get('year'))->id}}">{{$item->filterStatusGizi(Session::get('year'))->jumlah_gizi>0?
                                        number_format($item->filterStatusGizi(Session::get('year'))->gizi_kurang
                                        /$item->filterStatusGizi(Session::get('year'))->jumlah_gizi * 100, 2):0}}</td>
                                    
                                    <td><input type="number" {{$isDisabled}} name="gizi_buruk" id="{{$item->filterStatusGizi(Session::get('year'))->id}}" value="{{$item->filterStatusGizi(Session::get('year'))->gizi_buruk}}" class="form-control data-input" style="border: none; width: 100%"></td>
                                    
                                    <td id="gizi_buruk{{$item->filterStatusGizi(Session::get('year'))->id}}">{{$item->filterStatusGizi(Session::get('year'))->jumlah_gizi>0?
                                        number_format($item->filterStatusGizi(Session::get('year'))->gizi_buruk
                                        /$item->filterStatusGizi(Session::get('year'))->jumlah_gizi * 100, 2):0}}</td>
                                    
                                    
                                </tr>
                                  @endif
                                @endforeach
                                @endrole
                            </tbody>
                        </table>
                    </div>

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


</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>

        $('#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 tinggi = $(this).parent().parent().find(`#tinggi${id}`);
        let timbang = $(this).parent().parent().find(`#timbang${id}`);
        let gizi = $(this).parent().parent().find(`#gizi${id}`);
        let gizi_buruk = $(this).parent().parent().find(`#gizi_buruk${id}`);
        
		$.ajaxSetup({
			headers: {
				'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
			}
		});

		$.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("StatusGizi.store") }}',
			'data'	: {'name' : name, 'value' : value, 'id': id, 'year': params},
			success	: function(res){
                timbang.text(`${res.timbang}`);
                tinggi.text(`${res.tinggi}`);
                gizi.text(`${res.gizi}`);
                gizi_buruk.text(`${res.gizi_buruk}`);
			}
		});
        console.log(name, value, id);
        })
        $("#filter").click(function(){
            let year = $("#tahun").val();
            window.location.href = "/JumlahKematianIbu?year="+year;


        })
        $('#data').on('click', '.detail', function(){
            let id = $(this).attr('id');
            let $clickedRow = $(this).closest('tr'); // Get the clicked row element
            if ($clickedRow.next().hasClass('detail-row')) {

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

		$.ajax({
			'type' 	: 'GET',
			'url'	: `/general/detail_desa/${id}`,
			'data'	: {'id': id, 'mainFilter': 'filterStatusGizi'},
			success	: function(res){
                console.log(res);


                $clickedRow.nextAll('.detail-row').remove();
                res.desa.forEach(function(item) {
                    let newRow = `
                    <tr class="detail-row" style="background: #f9f9f9;">
              <td></td>
              <td></td>
            <td>${item.nama}</td>
             <td>${item.jumlah_timbang}</td>
             <td>${item.bb_kurang}</td>
             <td>${item.jumlah_timbang > 0 ?(item.bb_kurang/item.jumlah_timbang) * 100:0}</td>
             <td>${item.jumlah_tinggi}</td>
             <td>${item.tb_kurang}</td>
             <td>${item.jumlah_tinggi > 0 ?(item.tb_kurang/item.jumlah_tinggi) * 100:0}</td>
             <td>${item.jumlah_gizi}</td>
             <td>${item.gizi_kurang}</td>
             <td>${item.jumlah_gizi > 0?(item.gizi_kurang/item.jumlah_gizi) * 100:0}</td>
             <td>${item.gizi_buruk}</td>
             <td>${item.jumlah_gizi > 0?(item.gizi_buruk/item.jumlah_gizi) * 100:0}</td>
            </tr>
                `;
                $clickedRow.after(newRow); // Insert the new row after the clicked row
                $clickedRow = $clickedRow.next(); // Move reference to the new row for subsequent inserts
            });
			}
		}); 
            }
            console.log(id);
        })
        $('#data').on('click', '.data-lock', function(){
            let id = $(this).attr('id');
            let year = $("#tahun").val();
            $.ajaxSetup({
			headers: {
				'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
			}
		});
            if($(this).is(':checked')){
            $.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("general.lock") }}',
			'data'	: {'id': id, 'status': 1, 'year': year, 'name': 'filterStatusGizi'},
			success	: function(res){
				console.log(res);
			}
		});
            } else {
                $.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("general.lock") }}',
			'data'	: {'id': id, 'status': 0, 'year': year, 'name': 'filterStatusGizi'},
			success	: function(res){
				console.log(res);
			}
		});
            }
        })
        $('#data').on('click', '.data-lock-upload', function(){
            let id = $(this).attr('id');
            let year = $("#tahun").val();
            $.ajaxSetup({
			headers: {
				'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
			}
		});
            if($(this).is(':checked')){
            $.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("general.lock_upload") }}',
			'data'	: {'id': id, 'status': 1, 'year': year, 'name': "StatusGizi"},
			success	: function(res){
				console.log(res);
			}
		});
            } else {
                $.ajax({
			'type' 	: 'POST',
			'url'	: '{{ route("general.lock_upload") }}',
			'data'	: {'id': id, 'status': 0, 'year': year, 'name': "StatusGizi"},
			success	: function(res){
				console.log(res);
			}
		});
            }
        })
    </script>
@endpush
@endsection