@extends('layouts.default')
@section('title', 'Jail Master')
@push('head')


<link href="/assets/plugins/select2/dist/css/select2.min.css" rel="stylesheet" />
<!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>-->
<script src="/assets/plugins/select2/dist/js/select2.min.js" defer></script>
<link href="/assets/plugins/bootstrap-datepicker/dist/css/bootstrap-datepicker.css" rel="stylesheet" />
<script src="/assets/plugins/bootstrap-datepicker/dist/js/bootstrap-datepicker.js" defer></script>
<script src="/assets/plugins/sweetalert/dist/sweetalert.min.js"></script>

<script src="../assets/plugins/datatables.net/js/jquery.dataTables.min.js" defer></script>
<script src="../assets/plugins/datatables.net-bs5/js/dataTables.bootstrap5.min.js" defer></script>
<script src="../assets/plugins/datatables.net-responsive/js/dataTables.responsive.min.js" defer></script>
<script src="../assets/plugins/datatables.net-responsive-bs5/js/responsive.bootstrap5.min.js" defer></script>

<script src="../assets/plugins/sweetalert/dist/sweetalert.min.js"></script>

<style>
    /*Custom CSS*/
    span {
        transition: color 0.5s ease-in;
    }

    label:focus-within span {
        color: blue;
    }

    input {
        display: block;
        width: 100%;
    }

    label,
    select {

        display: block;
        width: 100%;
        max-width: 100%;
    }
    /*Profile Pic Start*/
    .picture-container{
        position: relative;
        cursor: pointer;
        text-align: center;
    }
    .picture{
        width: 106px;
        height: 106px;
        background-color: #999999;
        border: 4px solid #CCCCCC;
        color: #FFFFFF;
        border-radius: 50%;
        margin: 0px auto;
        overflow: hidden;
        transition: all 0.2s;
        -webkit-transition: all 0.2s;
    }
    .picture:hover{
        border-color: #2ca8ff;
    }
    .picture input[type="file"] {
        cursor: pointer;
        display: block;
        height: 100%;
        left: 0;
        opacity: 0 !important;
        position: absolute;
        top: 0;
        width: 100%;
    }

    .picture-src{
        width: 100%;

    }
    /*Profile Pic End*/
    .form-control:focus, .form-select:focus, .form-check-input:focus, .select2:focus-within{
        border-color: #6265e4 !important;
        box-shadow: 0 0 5px rgba(98, 101, 228, 1) !important;
    }


</style>
@endpush
@section('content')
<section class="mb-4 bg-white">
    <h3 class="h3-responsive font-weight-bold text-center p-3">JAIL MASTER</h3>
    <div class="row align-items-center">
        <div class="col-md-12 mb-5">
            <div class="panel panel-inverse">
                <div class="panel-heading">
                    <h4 class="panel-title">JAIL MASTER</h4>
                </div>
                <form method="POST">
                    @csrf
                    <div class="panel-body">
                        <div class="row">
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>State</span>
                                        <select class="form-select form-select-sm" name='state' id='state'>
                                            <option value='0'>------Select State------</option>
                                            @if(!empty($allDepartment))
                                            @if(count($allDepartment)>0)
                                            @foreach($allDepartment as $item)
                                            <option value='{{ $item->state_code }}'>{{$item->state_name_english}}</option>
                                            @endforeach
                                            @endif
                                            @endif
                                        </select>
                                    </label>
                                </div>
                            </div>

                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>District</span>
                                        <select class="form-select form-select-sm" name="district" id="district">
                                            <option value="0">Select District</option>

                                        </select>
                                    </label>
                                </div>
                            </div> 
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Jail ID</span>
                                        <input type='text' id='jail_id' name='jail_id' class='form-control form-control-sm'  value=''>
                                    </label>
                                </div>
                            </div> 
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Jail Type</span>
                                        <select class="form-select form-select-sm" name="jailtype" id="jailtype">
                                            <option value="0">Select Jail Type</option>
                                            <option value="C">Central Jail</option>
                                            <option value="D">District Jail</option>
                                            <option value="S">Sub Jail</option>
                                            <option value="O">Open Air Jail</option>
                                            <option value="W">Women Jail</option>
                                            <option value="B">Borstal School</option>

                                        </select>
                                    </label>
                                </div>
                            </div> 
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Jail Name</span>
<!--                                        <select class="form-select form-select-sm" name="jail" id="jail">
                                            <option value="0">Select Jail</option>

                                        </select>-->
                                        <input type='text' id='jail_name' name='jail_name' class='form-control form-control-sm'  value=''>
                                    </label>
                                </div>
                            </div> 
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Jail Address</span>
<!--                                        <select class="form-select form-select-sm" name="jail" id="jail">
                                            <option value="0">Select Jail</option>

                                        </select>-->
                                        <input type='text' id='jail_address' name='jail_address' class='form-control form-control-sm'  value=''>
                                    </label>
                                </div>
                            </div> 

                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Email</span>
                                        <input type='text' id='email' name='email' class='form-control form-control-sm'  value=''>
                                        <input type='hidden' id='old_email' name='old_email' class='form-control form-control-sm'  value=''>
                                    </label>
                                </div>
                            </div> 
                            <div class='col-md-2 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>Mobile</span>
                                        <input type='text' id='mobile' name='mobile' class='form-control form-control-sm'  value=''>
                                    </label>
                                </div>
                            </div> 

                            <div class='col-md-1 mb-2'>
                                <div class='md-form'>
                                    <label for='pin' class=''><span>&nbsp;</span>
                                        <input type='button' id='submit' name='button' class='btn btn-primary btn-sm form-control'  value='Save'>
                                        <input type='button' id='tdata' style='display:none' name='tbutton' class='btn btn-primary btn-sm form-control'  value='SUBMIT'>
                                        <input type='hidden' id='id' name='id' value=''>
                                    </label>
                                </div>
                            </div>  
                        </div>
                        <!--                        <div class="panel-body">
                                                    <div class="row" id='inputcol'>
                                                        
                                                    </div>
                                                </div>-->
                    </div>
                </form>
                <div class="panel panel-inverse">
                    <div class="panel-heading">
                        <h4 class="panel-title">Jail Master Data</h4>
                        <div class="panel-heading-btn">
                            <a href="#" class="btn btn-xs btn-icon btn-circle btn-default" data-toggle="panel-expand">
                                <i class="fa fa-expand"></i>
                            </a>
                            <a href="#" class="btn btn-xs btn-icon btn-circle btn-success" data-toggle="panel-reload">
                                <i class="fa fa-repeat"></i>
                            </a>
                            <a href="#" class="btn btn-xs btn-icon btn-circle btn-warning" data-toggle="panel-collapse">
                                <i class="fa fa-minus"></i>
                            </a>
                            <a href="#" class="btn btn-xs btn-icon btn-circle btn-danger" data-toggle="panel-remove">
                                <i class="fa fa-times"></i>
                            </a>
                        </div>
                    </div>
                    <div class="panel-body">
                        <div class="row">
                            <div class="col-sm-12" id="table">

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

@endsection
@push('scripts')
<script>
$(document).ready(function () {

//$('#submit').hide();
    $('#state').change(function () {
        var state = $(this).val();
        var districtUrl = "{{ url('jaillist')}}";
        var i = 0, j = 0, m = 0;
        var id;
        $.get(districtUrl,
                {state: state},
                function (data) {
                    // alert(data);
                    var model = $('#table');
                    model.empty();
                    var html = "<table id='data-table-default' class='table table-striped table-bordered align-middle'>";
                    html += "<thead>";
                    html += "<tr>";
                    html += "<td>District</td><td>Jail Id</td><td>Jail</td><td>Address</td><td>Email</td><td>Mobile</td>";
                    html += "</tr></thead><tbody>";
                    var result = (data[0]);
                    var columns = String(Object.keys(result[0])).split(',');
                    var id = 1;
                    $.each(result, function (k, v) {
                        html += "<tr>";
                        j = 0;

//                        $.each(columns, function (k1, v1) {

                        html += "<td>" + eval("v." + columns[0]) + "</td>";
                        html += "<td>" + eval("v." + columns[4]) + "</td>";
                        html += "<td>" + eval("v." + columns[1]) + "</td>";
                        html += "<td>" + eval("v." + columns[2]) + "</td>";
                        html += "<td>" + eval("v." + columns[3]) + "</td>";                        
                        html += "<td>" + eval("v." + columns[5]) + "</td>";

                        j++;
                        m++;

//                        });

//                        alert(eval("v." + columns[0]));
//                        alert(eval("v." + columns[1]));
//                        alert(eval("v." + columns[2]));
//                        alert(eval("v." + columns[3]));
//                        alert(eval("v." + columns[4]));
//                        ++j;
                        html += "<td class='text-center'><a href='#' id='edit-" + eval("v." + columns[6]) + "' class='pr-1 text-success' title='Edit'><i class='fas fa-lg fa-fw me-5px fa-user-edit'></i></a></td>";
                        html += "</tr>";
                        ++id;
                    });

                    html += "</tbody>";
                    html += "</table>";

                    model.append(html);
                    $('#email').val('');    
                }

        );
        var districtUrl1 = "{{ url('getDistrict')}}";
        $.post(districtUrl1,
                {state: state, "_token": "{{ csrf_token() }}"},
                function (data) {
                    var model = $('#district');
                    model.empty();
                    var html = "<option value='0'>Select District</option>";
                    $.each(data, function (index, element) {
                        html += "<option value='" + element.district_code + "'>" + element.district_name_english + "</option>";
                    });
                    model.append(html);
                }
        );
    });

    $('#district').change(function () {
        var state = $("#state").val();
        var district = $(this).val();
        var districtUrl = "{{ url('districtjaillist')}}";
        var i = 0, j = 0, m = 0;
        var id;
        $.get(districtUrl,
                {state: state, district: district},
                function (data) {
                    // alert(data);
                    var model = $('#table');
                    model.empty();
                    var html = "<table id='data-table-default' class='table table-striped table-bordered align-middle'>";
                    html += "<thead>";
                    html += "<tr>";
                    html += "<td>District</td><td>Jail Id</td><td>Jail</td><td>Address</td><td>Email</td><td>Mobile</td>";
                    html += "</tr></thead><tbody>";
                    var result = (data[0]);
                    var columns = String(Object.keys(result[0])).split(',');
                    var id = 1;
                    $.each(result, function (k, v) {
                        html += "<tr>";
                        j = 0;

//                        $.each(columns, function (k1, v1) {

                        html += "<td>" + eval("v." + columns[0]) + "</td>";
                        html += "<td>" + eval("v." + columns[4]) + "</td>";
                        html += "<td>" + eval("v." + columns[1]) + "</td>";
                        html += "<td>" + eval("v." + columns[2]) + "</td>";
                        html += "<td>" + eval("v." + columns[3]) + "</td>";                        
                        html += "<td>" + eval("v." + columns[5]) + "</td>";

                        j++;
                        m++;

//                        });

//                        alert(eval("v." + columns[0]));
//                        alert(eval("v." + columns[1]));
//                        alert(eval("v." + columns[2]));
//                        alert(eval("v." + columns[3]));
//                        alert(eval("v." + columns[4]));
//                        ++j;
html += "<td class='text-center'><a href='#' id='edit-" + eval("v." + columns[6]) + "' class='pr-1 text-success' title='Edit'><i class='fas fa-lg fa-fw me-5px fa-user-edit'></i></a></td>";
                        html += "</tr>";
                        ++id;
                    });

                    html += "</tbody>";
                    html += "</table>";

                    model.append(html);
                    $('#email').val('');
                }

        );
        var districtUrl1 = "{{ url('getJail')}}";
        $.post(districtUrl1,
                {state: state, district: district, "_token": "{{ csrf_token() }}"},
                function (data) {
                    var model = $('#jail');
                    model.empty();
                    var html = "<option value='0'>Select Jail</option>";
                    $.each(data, function (index, element) {
                        html += "<option value='" + element.id + "'>" + element.jail_name + "</option>";
                    });
                    model.append(html);
                }
        );
    });


    $('#jail').change(function () {
        var loc_id = $(this).val();
        var districtUrl = "{{ url('getEmail')}}";
        var i = 0, j = 0, m = 0;
        var id;
        $.get(districtUrl,
                {loc_id: loc_id},
                function (data) {
                    $.each(data, function (index, element) {
                        $("#email").val(element.email);
                        $("#old_email").val(element.email);
                    });
                    
                }

        );
        $("#id").val(loc_id);
        $('#email').val('');
    });


    $('#data-table-default').DataTable({responsive: true,
        "fnRowCallback": function (nRow, aData, iDisplayIndex) {
            var oSettings = this.fnSettings();
            $("td:first", nRow).html(oSettings._iDisplayStart + iDisplayIndex + 1);
            return nRow;
        },
    });
    $(document).on("click", '#submit', function () {
        var email = $("#email").val();
        var old_email = $("#old_email").val();
        var id = $("#id").val();
        var state = $("#state").val();
        var district = $("#district").val();
        var jail_id = $("#jail_id").val();
        var jailtype = $("#jailtype").val();
        var jail_name = $("#jail_name").val();
        var jail_address = $("#jail_address").val();
        var mobile = $("#mobile").val();
        var btnval = $("#submit").val();
        if (jail_id == "") {
            alert("Enter Jail Id");
            $("#jail_id").focus();
            return false;
        }
        if (jail_name == "") {
            alert("Enter Jail Name");
            $("#jail_name").focus();
            return false;
        }
        if (jail_address == "") {
            alert("Enter Jail Address");
            $("#jail_address").focus();
            return false;
        }
//        if (email == "") {
//            alert("Enter Jail Email Id");
//            $("#email").focus();
//            return false;
//        }
        var districtUrl = "{{ url('savejailemail')}}";
        $.post(districtUrl,
                {id: id, email: email, old_email: old_email, state: state, district: district, jail_id: jail_id, jailtype: jailtype, jail_name: jail_name, jail_address: jail_address, mobile: mobile, btnval: btnval, "_token": "{{ csrf_token() }}"},
                function (data) {
                    alert(data);
                    $('#district').trigger('change');
                    $('#email').val('');
                    $("#jail_id").val('');
                    $("#jailtype").val('0');
                    $("#jail_name").val('');
                    $("#jail_address").val('');
                    $("#mobile").val('');
                }
        );
    });
    
    $(document).on('click', 'a', function () {

    var ids = this.id;
    ids = ids.split("-");
    var act = ids[0];
    var pid = ids[1];
    var districtUrl = "";
    var cols = '';
    if (act == "edit")
        districtUrl = "{{ url('editjailmaster')}}";
    else if (act == "delete")
        districtUrl = "{{ url('deletejailmaster')}}";
    $.get(districtUrl,
            {id: pid},
            function (data) {
                if (act == "delete") {
                    alert(data);
                    $('#state').trigger('change');
                } else if (act == "edit") {
                    $("#submit").val("Update");
                    var result = (data[0]);
                    var columns = String(Object.keys(result[0])).split(',');
                    // alert(columns);
                    var i = 0;
                    $.each(columns, function (k, v) {

                        $.each(result, function (k, v) {
                            j = 0;
                            m = 0;
                            $("#state").val(eval("v." + columns[7]));
                            $("#district").val(eval("v." + columns[8]));
                            $("#jail_id").val(eval("v." + columns[0]));
                            $("#id").val(eval("v." + columns[10]));
                            $("#jailtype").val(eval("v." + columns[6]));
                            $("#jail_name").val(eval("v." + columns[2]));
                            $("#jail_address").val(eval("v." + columns[3]));
                            $("#email").val(eval("v." + columns[9]));
                            $("#old_email").val(eval("v." + columns[9]));
                            $("#mobile").val(eval("v." + columns[11]));
                        });
                    });

                }
            }
    );


});
    
    
    
    
    
    
});

//function someFunction() {
//var table = $("#masterTable").val();
//var key = $(this).attr('id');
//alert(key);
//}
</script>


@endpush