@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>Water Level Yearly</h4>
                    </div>
                </div>
            </div>

        </div>
    </div>
    <style>
        .text-right {
            text-align: right;
        }
    </style>
    <!-- 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-4 mb-0">
                        <div class="form-check form-check-inline">
                            <label class="form-check-label">
                                <input class="form-check-input ord" type="radio" name="ord" value="1" checked>
                                Administrative
                            </label>
                        </div>
                        {{-- <div class="form-check form-check-inline">
                            <label class="form-check-label">
                                <input class="form-check-input ord" type="radio" name="ord" value="2">
                                Hydrological
                            </label>
                        </div> --}}
                    </div>

                </div>
                <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-2">
                        <label for="validationCustom02">State</label>
                        <select class="form-control StateCodeFilter" name="StateCode" id="StateCode">
                            <option value="">--Select--</option>                            
                        </select>
                    </div>
                    <div class="col-md-2 administrative">
                        <label for="validationCustom02">District</label>
                        <select class="form-control district_id" name="DistrictCode" id="DistrictCode">
                            <option value="">--Select--</option>
                        </select>
                    </div>

                    <div class="col-md-2 hydrological" style="display:none">
                        <label for="validationCustom02">Basin</label>
                        <select class="form-control BasinCodeFilter" name="BasinCode" id="BasinCode">
                            <option value="">--Select--</option>
                        </select>
                    </div>


                    <div class="col-md-2 hydrological" style="display:none">
                        <label for="validationCustom02">Sub Basin</label>
                        <select class="form-control SubBasinCode" name="SubBasinCode" id="SubBasinCode">
                            <option value="">--Select--</option>

                        </select>
                    </div>
                    <div class="col-md-2">
                        <label for="validationCustom02">From Year<span class="red">*</span></label>
                        <select class="form-control" name="fromYear" id="fromYear">

                            @for ($year = date('Y'); $year >= 1969; $year--)
                                <option value="{{ $year }}">{{ $year }}</option>
                            @endfor
                        </select>
                    </div>
                    <div class="col-md-2">
                        <label for="validationCustom02">To Year<span class="red">*</span></label>
                        <select class="form-control" name="toYear" id="toYear">
                            @for ($year = date('Y'); $year >= 1969; $year--)
                                <option value="{{ $year }}">{{ $year }}</option>
                            @endfor
                        </select>
                    </div>

                    <div class="col-md-6 col-lg-2">
                        <div class="form-group">
                            <label for="validationCustom02">Well Type</label>
                            <select class="form-control WellType" name="WellType" id="WellType">
                                <option value="">--Select--</option>
                                @foreach ($well_type_list as $row)                                
                                <option value="{{ $row->combo_value }}">{{ $row->combo_text }}</option>
                                @endforeach
                            </select>
                        </div> 
                    </div> 
    
    
                    <div class="col-md-6 col-lg-2">
                        <div class="form-group">
                            <label for="validationCustom02">Aquifer</label>
                            <select class="form-control AqTap" name="AqTap" id="AqTap">
                                <option value="">--Select--</option>
                                @foreach ($AqTap_list as $row)                                
                                <option value="{{ $row->combo_value }}">{{ $row->combo_text }}</option>
                                @endforeach
                            </select>
                        </div> 
                    </div> 

                    <div class="col-md-6 col-lg-2">
                        <div class="form-group">
                            <label for="validationCustom02">Project</label>
                            <select class="form-control ProjectID" name="ProjectID" id="ProjectID">
                                <option value="">--select--</option>
                                @foreach ($mst_project as $row)                                
                                    <option value="{{ $row->id }}" >{{ $row->project_name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-2 col-lg-2">
                        <div class="form-group">
                            <label class="visibility-hidden">Filter</label>
                            <div class="d-flex">
                            <button type="bttton" class="btn btn-sm btn-primary text-white filter_btn mr-2" name="Search">Filter</button> 
                            <form action="/DownloadWaterLevelWellWiseYearly" method="POST"> 
                                @csrf
                                <input type="hidden" name="ord" id="post_ord" value="1">
                                <input type="hidden" name="regionID" id="post_regionID" >
                                <input type="hidden" name="stateCode" id="post_stateCode" >
                                <input type="hidden" name="districtCode" id="post_districtCode" >
                                <input type="hidden" name="basinCode" id="post_basinCode" >
                                <input type="hidden" name="subBasinCode" id="post_subBasinCode">
                                <input type="hidden" name="fromYear" id="post_fromYear" >
                                <input type="hidden" name="toYear" id="post_toYear">
                                <input type="hidden" name="WellType" id="post_WellType">
                                <input type="hidden" name="AqTap" id="post_AqTap">
                                <input type="hidden" name="ProjectID" id="post_ProjectID">
                                 <!---<button type="submit" class="btn btn-sm btn-primary text-white" name="Search">Download</button>---> 
                                                   
                               <a href="#" id="downloadReport">
                                    <img src="https://gwdata.cgwb.gov.in/public/assets\images\excel.png" data-toggle="tooltip" title="" alt="Excel Export" style="height: 35px;" data-original-title="Excel Export">
                                </a>
                            </form>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
        <div class="row card_data">
            <div class="col-sm-12">
                <!-- Zero config.table start -->
                <div class="card">
                    <div class="card-block"> 
                    
                        
                        <div class="table-responsive">
                            <table id="simpletable" class="table table-striped table-bordered nowrap">
                                <thead>
                                    <tr>
                                        <th>WellNo</th>
                                        <th>District</th>
                                        <th>Block</th>
                                        <th>Village</th>
                                        {{-- <th>Basin</th> --}}
                                        {{-- <th>SubBasin</th> --}}
                                        <th>Year</th>
                                        <th>Jan</th>
                                        <th>Feb</th>
                                        <th>Mar</th>
                                        <th>Apr</th>
                                        <th>May</th>
                                        <th>Jun</th>
                                        <th>Jul</th>
                                        <th>Aug</th>
                                        <th>Sep</th>
                                        <th>Oct</th>
                                        <th>Nov</th>
                                        <th>Dec</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>
                        </div>
                    </div>
                </div>

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

    {{-- <script src="{{ asset('bower_components\datatables.net\js\jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('bower_components\datatables.net-buttons\js\dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('bower_components\datatables.net-bs4\js\dataTables.bootstrap4.min.js') }}"></script> --}}

    <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 src="{{ asset('bower_components\data_table\dataTables.buttons.js') }}"></script>
    <script src="{{ asset('bower_components\data_table\buttons.dataTables.js') }}"></script>
    <script src="{{ asset('bower_components\data_table\buttons.colVis.min.js') }}"></script>

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

            function getResults() {
                $('.card_data').show();
                if ($.fn.DataTable.isDataTable('#simpletable')) {
                    $('#simpletable').DataTable().destroy();
                }

                var data = {};
                ord = $('.ord:checked').val();
                // alert(ord);

                var regionID = $("#RegionID").val();
                var stateCode = $("#StateCode").val();
                var districtCode = $("#DistrictCode").val();
                var basin = $("#BasinCode").val();
                var subBasin = $("#SubBasinCode").val();
                var fromYear = $("#fromYear").val();
                var toYear = $("#toYear").val();
                var WellType = $("#WellType").val();
                var AqTap = $("#AqTap").val();
                var ProjectID = $("#ProjectID").val();

                if(ord == 1){
                    data ={"ord": ord, "regionID": regionID, "stateCode": stateCode, "districtCode": districtCode,  "fromYear": fromYear, "toYear": toYear ,"WellType":WellType, "AqTap":AqTap, "ProjectID":ProjectID,"_token": "{{ csrf_token() }}" };

                }else if(ord == 2){
                    data ={"ord": ord, "regionID": regionID, "stateCode": stateCode, "districtCode": districtCode, "basinCode": basin, "subBasinCode": subBasin, "fromYear": fromYear, "toYear": toYear ,"WellType":WellType, "AqTap":AqTap, "ProjectID":ProjectID,"_token": "{{ csrf_token() }}" };
                }

                $('#post_ord').val(ord);
                $('#post_regionID').val(regionID);
                $('#post_stateCode').val(stateCode);
                $('#post_districtCode').val(districtCode);
                $('#post_basinCode').val(basin);
                $('#post_subBasinCode').val(subBasin);
                $('#post_fromYear').val(fromYear);
                $('#post_toYear').val(toYear);
                $('#post_WellType').val(WellType);
                $('#post_AqTap').val(AqTap);
                $('#post_ProjectID').val(ProjectID);
                
                var table = $('#simpletable').DataTable({
                    "processing": false, // for show progress bar,
                    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,
                    "bDestroy": true,
                    "responsive": true,
                    "scrollX": true,
                    "fixedColumns": {"leftColumns": 4},
                    // "dom": 'Bfrtip',
                    // "buttons": [{"extend": 'colvis'}],
                    
                    "ajax": {
                        "url": "{{ route('RPT_WaterLevelWellWiseYearly') }}",
                        "type": "POST",
                        "data": data,
                        "dataType": "json",
                        beforeSend: function() {
                            $(".loaderpk").css("display", "block");
                        },
                        complete: function() {
                            $(".loaderpk").css("display", "none");
                        },                  
                        "dataSrc": function(jsonData) {
                            console.log(jsonData);
                            // $('.theme-loader-black').hide();
                            // $(".theme-loader").css("display", "none");
                            // alert(JSON.Stringify(jsonData.data));
                            return jsonData.data;
                        }
                    },
                    "columnDefs": [
                        {
                            "targets": [4,5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15], // Indexes for columns to align right
                            "className": "text-right"
                        }
                    ]
                });
            }

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

                if (RegionID == '') {
                    bootbox.alert('Please select Region');
                    return false;
                }
                // $('.theme-loader-black').show();
                // $('.theme-loader').show();
                // $(".theme-loader").css("display", "block");
                getResults();
            });

            $("#downloadReport").click(function() {
                var RegionID = $("#RegionID").val();
                if (RegionID == '') {
                    bootbox.alert('Please select Region');
                    return false;
                }
                var data = {};
                ord = $('.ord:checked').val();
                // alert(ord);

                var regionID = $("#RegionID").val();
                var stateCode = $("#StateCode").val();
                var districtCode = $("#DistrictCode").val();
                var basin = $("#BasinCode").val();
                var subBasin = $("#SubBasinCode").val();
                var fromYear = $("#fromYear").val();
                var toYear = $("#toYear").val();
                var WellType = $("#WellType").val();
                var AqTap = $("#AqTap").val();
                var ProjectID = $("#ProjectID").val();

                if(ord == 1){
                    data ={"ord": ord, "regionID": regionID, "stateCode": stateCode, "districtCode": districtCode,  "fromYear": fromYear, "toYear": toYear ,"WellType":WellType, "AqTap":AqTap, "ProjectID":ProjectID,"_token": "{{ csrf_token() }}" };

                }else if(ord == 2){
                    data ={"ord": ord, "regionID": regionID, "stateCode": stateCode, "districtCode": districtCode, "basinCode": basin, "subBasinCode": subBasin, "fromYear": fromYear, "toYear": toYear ,"WellType":WellType, "AqTap":AqTap, "ProjectID":ProjectID,"_token": "{{ csrf_token() }}" };
                }
                $.ajaxSetup({
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    }
                });
                $.ajax({
                    type: 'POST',
                    url: "/DownloadWaterLevelWellWiseYearly",
                    data: data,
                    xhrFields: {
                        responseType: 'blob'
                    },
                    beforeSend: function() {
                        $(".loaderpk").css("display", "block");
                    },
                    complete: function() {
                        $(".loaderpk").css("display", "none");
                    },
                    success: function(data) {
                        var a = document.createElement('a');
                        var url = window.URL.createObjectURL(data);
                        a.href = url;
                        a.download = 'WaterLevelWellWiseYearly.xlsx';
                        document.body.append(a);
                        a.click();
                        a.remove();
                        window.URL.revokeObjectURL(url);
                    }
                });
            });


            $(".ord").click(function() {
                val = $(this).val();
                if (val == '1') {
                    $('.hydrological').hide();
                    $('.administrative').show();
                } else {
                    $('.administrative').hide();
                    $('.hydrological').show();
                }
            });


        });


        
        $( window ).on("load", function() {
            $('.card_data').hide();
        });

        
    </script>
@endsection