@extends('layouts.app')

@section('content')
    <div class="page-header">
        <div class="row align-items-end">
            <div class="col-lg-8">
                <div class="page-header-title">
                    <div class="d-inline">
                        <h4>DWLR Missing Data</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Page-header end -->
    @php $user = Auth::user(); @endphp
    <!-- Page-body start -->
    <div class="page-body">
        <div class="card mb-2">
            <div class="card-block">
                <div class="row">

                    <div class="col-md-6 col-lg-2">
                        <div class="form-group">
                            <label for="validationCustom02">Region<span class="red">*</span></label>
                            <select class="form-control RegionFilter" name="RegionID" id="RegionID">
                                <option value="">--select--</option>
                                @foreach ($t_Master_Region as $row)
                                    <option value="{{ $row->RegionID }}"
                                        @if ($user->RoleID == 2 && $row->RegionID == $user->RegionID) selected = "selected" @endif>
                                        {{ $row->RegionName }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-6 col-lg-2 StateCodeDiv">
                        <label for="validationCustom02">State<span class="red">*</span></label>
                        <select class="form-control StateCodeFilter" name="StateCode" id="StateCode">
                            <option value="">--Select--</option>
                        </select>
                    </div>

                    <div class="col-md-2 mb-3 DistrictCodeDiv">
                        <label for="validationCustom02">District</label>
                        <select class="form-control district_id DistrictCodeFilter" name="DistrictCode" id="DistrictCode">
                            <option value="">--Select--</option>
                        </select>
                    </div>

                    @php 
                    $today = date('d-m-Y'); 
                    $today_minus_seven_day = date('d-m-Y', strtotime($today . ' -7 day')); 
                    @endphp

                    <div class="col-md-2 mb-0 ">
                        <label for="exampleSelect1">From Date<span class="red">*</span></label>
                        <div class="date-container w-100">
                            <input type="text" name="fromDate" pattern="\d{1,2}-\d{1,2}-\d{4}"
                                title="Enter in dd-mm-yyyy format" class="form-control datepicker" id="fromDate"
                                placeholder="dd-mm-yyyy" autocomplete="off" maxlength="255" value="{{ $today_minus_seven_day }}"><span class="material-symbols-outlined">calendar_month
                                </span>
                        </div>
                    </div>
                    <div class="col-md-2 mb-0 ">
                        <label for="exampleSelect1">To Date<span class="red">*</span></label>
                        <div class="date-container w-100">
                            <input type="text" pattern="\d{1,2}-\d{1,2}-\d{4}" title="Enter in dd-mm-yyyy format"
                                class="form-control datepicker" id="toDate" name="toDate" placeholder="dd-mm-yyyy"
                                autocomplete="off" maxlength="255" value="{{ $today  }}"><span class="material-symbols-outlined">calendar_month
                                </span>
                        </div>
                    </div>

                    <div class="col-md-2 mt-3 ">
                        <button type="bttton" class="btn btn-primary text-white filterBtn" style="cursor:pointer;"
                            name="filter">Filter</button>

                        <a href="#" id="downloadReport">
                            <img src="{{ asset('assets\images\excel.png') }}" data-toggle="tooltip" title="" alt="Excel Export" style="height: 35px;" data-original-title="Excel Export">
                        </a>
                    </div>

                </div>
            </div>
        </div>


        <div class="row" id="geowisereport" style="display:none">
            <div class="col-sm-12">
                <!-- Zero config.table start -->

                <div class="card">
                    <div class="card-block">
                        <div class="">
                            <table id="simpletable" class="table table-striped table-bordered nowrap">
                                <thead>
                                    <tr role="row">
                                        <th>WellNo</th>
                                        <th>District</th>
                                        <th>Block</th>
                                        <th>Missing Date</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>

                        </div>
                    </div>
                </div>
            </div>

        </div>




    </div>

    <link rel="stylesheet" href="{{ asset('bower_components\data_table\dataTables.dataTables.css') }}" >
    <link rel="stylesheet" href="{{ asset('bower_components\data_table\fixedColumns.dataTables.css') }}" >
    <link rel="stylesheet" href="{{ asset('bower_components\data_table\buttons.dataTables.css') }}" >
    <script src="{{ asset('bower_components\data_table\dataTables.js') }}"></script>
    <script src="{{ asset('bower_components\data_table\dataTables.fixedColumns.js') }}"></script>
    <script src="{{ asset('bower_components\data_table\fixedColumns.dataTables.js') }}"></script>


    <script>
        $(function() {

            @if ($user->RoleID == 2)
                $(".RegionFilter").css({
                    "pointer-events": "none",
                    "touch-action": "none",
                    "background": "#e9ecef"
                });
                $(".RegionFilter").trigger('change');
            @endif

            $("#check-list-box-div").hide();

            /* var today = new Date();
            $("#fromDate").datepicker({
                autoclose: true,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                endDate: today,
                orientation: "bottom",
                yearRange: "1969:" + new Date().getFullYear()
            });


            $("#toDate").datepicker({
                autoclose: true,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                endDate: today,
                orientation: "bottom",
                yearRange: "1969:" + new Date().getFullYear()
            }); */


            var today = new Date();

            function addDays(date, days) {
                var result = new Date(date);
                result.setDate(result.getDate() + days);
                return result;
            }

            $("#fromDate").datepicker({
                autoclose: true,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                maxDate: today,
                orientation: "bottom",
                yearRange: "1969:" + today.getFullYear(),
                onSelect: function (selectedDate) {
                    var date = $(this).datepicker('getDate');
                    var endDate = addDays(date, 30);
                    //$("#toDate").datepicker("option", "minDate", date);
                    //$("#toDate").datepicker("option", "maxDate", endDate);
                }
            });

            $("#toDate").datepicker({
                autoclose: true,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                maxDate: today,
                orientation: "bottom",
                yearRange: "1969:" + today.getFullYear(),
                onSelect: function (selectedDate) {
                    var date = $(this).datepicker('getDate');
                    var startDate = addDays(date, -30);
                    //$("#fromDate").datepicker("option", "maxDate", date);
                    //$("#fromDate").datepicker("option", "minDate", startDate);
                }
            });

            $(".filterBtn").click(function() {
                var RegionID = $("#RegionID").val();
                var stateCode = $("#StateCode").val();
                var DistrictCode = $("#DistrictCode").val();
                var fromDate = $("#fromDate").val();
                var toDate = $("#toDate").val();

                if (RegionID == '') {
                    bootbox.alert('Please select Region');
                    return false;
                } else if (stateCode == '') {
                    bootbox.alert('Please select State');
                    return false;
                }

                if (fromDate == '') {
                    bootbox.alert('Please select From Date');
                    return false;
                }

                if (toDate == '') {
                    bootbox.alert('Please select To Date');
                    return false;
                }

                var data = {
                    RegionID: RegionID,
                    stateCode: stateCode,
                    DistrictCode: DistrictCode,
                    fromDate: fromDate,
                    toDate: toDate,
                    "_token": "{{ csrf_token() }}"
                };

                $("#geowisereport").show();

                if ($.fn.DataTable.isDataTable('#simpletable')) {
                    $('#simpletable').DataTable().destroy();
                }

                var table = $('#simpletable').DataTable({
                    "processing": false,
                    retrieve: true,
                    /*
                    "language": {
                        'processing': '<i class="fa fa-spinner fa-spin fa-3x fa-fw"></i><span class="sr-only">Loading..n.</span>'
                    },
                    */
                    "serverSide": true,
                    "bFilter": true,
                    "bLengthChange": true,
                    "ordering": true,
                    "iDisplayLength": 10,
                    "responsive": true,
                    "bDestroy": true,
                    "ajax": {
                        "url": "{{ route('Exception1') }}",
                        "type": "POST",
                        "data": data,
                        "dataType": "json",
                        beforeSend: function() {
                            $(".loaderpk").css("display", "block");
                        },
                        complete: function() {
                            $(".loaderpk").css("display", "none");
                        },
                        "dataSrc": function(jsonData) {
                            $('#geowisereport').show();
                            return jsonData.data;
                        }
                    }
                });


            });

            $("#downloadReport").click(function() {
                var RegionID = $("#RegionID").val();
                var stateCode = $("#StateCode").val();
                var DistrictCode = $("#DistrictCode").val();
                var fromDate = $("#fromDate").val();
                var toDate = $("#toDate").val();

                if (RegionID == '') {
                    bootbox.alert('Please select Region');
                    return false;
                } else if (stateCode == '') {
                    bootbox.alert('Please select State');
                    return false;
                }

                if (fromDate == '') {
                    bootbox.alert('Please select From Date');
                    return false;
                }

                if (toDate == '') {
                    bootbox.alert('Please select To Date');
                    return false;
                }
                var data = {
                    RegionID: RegionID,
                    stateCode: stateCode,
                    DistrictCode: DistrictCode,
                    fromDate: fromDate,
                    toDate: toDate,
                };

                $.ajaxSetup({
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    }
                });
                
                $.ajax({
                    type: 'POST',
                    url: "/Download_DWLR_Missing_Date",
                    data: data,
                    xhrFields: {
                        responseType: 'blob'
                    },

                    success: function(data) {
                        console.log(data);
                        var a = document.createElement('a');
                        var url = window.URL.createObjectURL(data);
                        a.href = url;
                        a.download = 'DWLR_Missing_Date.xlsx';
                        document.body.append(a);
                        a.click();
                        a.remove();
                        window.URL.revokeObjectURL(url);
                    }
                });
            });


           

        });
    </script>
@endsection