@extends('layouts/microfin_layout')
@section('title', '| Regular Loan Adjustment')
@section('content')
<style type="text/css">
    .form-group, .form-control{
        font-size: 11px !important;
        color: black !important;
    }
    .form-control{
        padding: 5px !important;
    }
    #search{
        font-size: 14px;
        margin-top: 18px;
    }
    .ui-datepicker-calendar 
    {
        display: none;
    }
</style>

<div class="row">
<div class="col-md-12">
<div class="" style="">
    <div class="">
        <div class="panel panel-default" style="background-color:#708090;">
            <div class="panel-heading" style="padding-bottom:0px;">
                <div class="panel-options">
                    <a href="{{route('regularLoanAdjustment.list')}}" class="btn btn-info pull-right addViewBtn">
                        <i class="glyphicon glyphicon-th-list addIcon"></i> Regular Loan Adjust List
                    </a>
                </div>
            
                <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Regular Loan Adjustment</h3>
            </div>

            <div class="panel-body panelBodyView" >
                <!-- Filtering Start-->
                <div class="row">
                    <div class="col-md-12">                                                
                        <form action="" class="form-horizontal form-groups" role="form" id="filterFormId" method="get">
                            @csrf
                            
                            <div class="col-md-2">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="reportLabel" class="control-label pull-left" style="color:black">Report Level:</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select class="form-control input-sm input-fields" id="filReportLevel" name="filReportLevel" aria-label="Default select example" autocomplete="off">
                                            @foreach ($data['reportLevel'] as $reportLevel)
                                                <option value="{{$reportLevel}}">{{$reportLevel}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-1" id="areaDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="area" class="control-label pull-left" style="color:black">Area:</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select id="filArea" name="filArea" class="form-control input-sm input-fields"
                                            style="color: black">
                                            <option value="">--All--</option>
                                            @foreach ($data['areaList'] as $area)
                                                <option value="{{$area->id}}">{{$area->name}}</option>
                                                @php
                                                    $barnchIds = str_replace(['"','[',']'], '', $area->branchId);
                                                    $barnchIds = explode(',', $barnchIds);
                                                    $branches = DB::table('gnr_branch')
                                                    ->whereIn('id',$barnchIds)
                                                    ->select(DB::raw("CONCAT ( LPAD(branchCode,3,0) ,' - ', name ) AS
                                                    name"))
                                                    ->get();
                                                @endphp
                                                @foreach ($branches as $branch)
                                                    <option value="" disabled="disabled">&nbsp {{$branch->name}}</option>
                                                @endforeach
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-1" id="zoneDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="Zone" class="control-label pull-left" style="color: black">Zone:</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select id="filZone" name="filZone" class="form-control input-sm input-fields" style="color: black">
                                            <option value="">--All--</option>
                                            @foreach ($data['zoneList'] as $zone)
                                                <option value="{{$zone->id}}">{{$zone->name}}</option>
                                                @php
                                                $areaIds = str_replace(['"','[',']'], '', $zone->areaId);
                                                $areaIds = explode(',', $areaIds);
                                                $areas = DB::table('gnr_area')
                                                ->whereIn('id',$areaIds)
                                                ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                                ->get();
                                                @endphp
                                                @foreach ($areas as $area)
                                                    <option value="" disabled="disabled">&nbsp {{$area->name}}</option>
                                                @endforeach
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-1" id="regionDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="Division" class="control-label pull-left" style="color: black">Division:</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select id="filRegion" name="filRegion" class="form-control input-sm input-fields" style="color: black">
                                            <option value="">--All--</option>
                                            @foreach ($data['regionList'] as $region)
                                                <option value="{{$region->id}}">{{$region->name}}</option>
                                                @php
                                                $zoneIds = str_replace(['"','[',']'], '', $region->zoneId);
                                                $zoneIds = explode(',', $zoneIds);
                                                $zones = DB::table('gnr_zone')
                                                ->whereIn('id',$zoneIds)
                                                ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                                ->get();
                                                @endphp
                                                @foreach ($zones as $zone)
                                                    <option value="" disabled="disabled">&nbsp {{$zone->name}}</option>
                                                @endforeach
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-1" id="branchDiv">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="Branch" class="control-label pull-left" style="color: black">Branch:</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select class="form-control input-sm input-fields" id="filBranch" name="filBranch" aria-label="Default select example" autocomplete="off">
                                            <option value="0">--All--</option>
                                            @foreach ($data['branchList'] as $key=>$branch)
                                                <option value="{{$key}}">{{$branch}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-2">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="monthFrom" class="control-label pull-left" style="color: black">Month To</label>
                                    </div>
                                    <div class="col-md-12">
                                        <input type="text" name="monthFrom" id="monthFrom" class="form-control input-sm input-fields" autocomplete="off" style="cursor:pointer">
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-2">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="" class="control-label pull-left" style="color: black">Member Code</label>
                                    </div>
                                    <div class="col-md-12">
                                        <input type="text" name="memberCode" class="form-control input-sm input-fields" autocomplete="off"  value="">
                                        {{-- <input type="text" name="memberCode" class="form-control input-sm input-fields" autocomplete="off" required value="049.0088.00008"> --}}
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-2">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="" class="control-label pull-left" style="color: black">Type</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select class="form-control input-sm input-fields" name="type" id="filterType">
                                            <option value="">Select</option>
                                            <option value="NoOfLoanDueInstallment">No. Of Due Installment</option>
                                            <option value="LastTrxMonth">Transection History</option>
                                        </select>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-2" id="trxHistory">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="" class="control-label pull-left" style="color: black">Transection History</label>
                                    </div>
                                    <div class="col-md-12">
                                        <select class="form-control input-sm input-fields" name="lastTrxMonth" id="lastTrxMonth">
                                            <option value="">Select</option>
                                            <option value="0">Last 1 month</option>
                                            <option value="1">Last 2 months</option>
                                            <option value="2">Last 3 months</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-2" id="dueInstallment">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        <label for="" class="control-label pull-left" style="color: black">No. Of Due Installment</label>
                                    </div>
                                    <div class="col-md-12">
                                        <input type="number" name="noOfLoanDueInstallment" id="noOfLoanDueInstallment" class="form-control input-sm input-fields" autocomplete="off" min="1"  value="">
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-1">
                                <div class="form-group">
                                    <label for="" style="'style' => 'color:#708090'">.</label>
                                    <div class="col-md-12">
                                        <button type="submit" id="reportSubmit" class="btn btn-primary input-fields" >Show</button>	
                                    </div>
                                </div>
                            </div>
                        </form>                       
                    </div>
                </div>
                <!-- filtering end-->

                <div class="row">
                    <div class="col-md-12"  id="reportingDiv" style=" margin-left: 0;margin-right: 0;padding-left: 0;padding-right: 0;">
                        
                    </div>
                </div>
            </div>		{{-- panel-body panelBodyView DIV --}}
        </div>
    </div>
</div>
</div>
</div>

<script>
    var loadingDiv='<div align="center" class="chart_column" style="height: 400px;"><img style="position:relative; top: 45%;" src="{{ asset('images/dashboards/loading.gif') }}"></div>';
    $("form").submit(function (event) {
        event.preventDefault();
        $("#loadingModal").show();
        var serializeValue = $(this).serialize();

        $.ajax({
            url: '{{ route("regularLoanAdjustment.dueLoanList") }}',
            method: 'GET',
            data: serializeValue,
            success: function (response) {
                if (response.responseTitle == "warning") {
                    $("#reportingDiv").html("");
                    toastr.warning(response.responseText,response.responseTitle);
                }else{
                    $("#reportingDiv").html(response);
                }
            },
            error: function (xhr, status, error) {
                console.error("ERROR:", xhr.responseText);
            },
            complete: function () {
                $("#loadingModal").hide();
            }
        });
    });

</script>

<script text="text/javascript">
    $(document).ready(function () {
        /*on change filReportLevel hide/show contents*/
        $("#filReportLevel").change(function (event) {
            if ($(this).val() == "Branch") {
                $("#branchDiv").show();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();

                $("#filArea").prop('required', false);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Area") {
                $("#branchDiv").hide();
                $("#areaDiv").show();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();
                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', true);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Zone") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").show();
                $("#regionDiv").hide();

                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', false);
                $("#filZone").prop('required', true);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Division") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").show();

                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', false);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', true);
            }
        });

        /*end on change filReportLevel hide/show contents*/
        $("#filReportLevel").trigger('change');

        $('#dueInstallment').hide();
        $('#trxHistory').hide();
        $('#filterType').change(function(event){
            if ($(this).val() == "") {
                $('#dueInstallment').hide();
                $('#trxHistory').hide();
                $('#lastTrxMonth').val('');
                $('#noOfLoanDueInstallment').val('');
            }

            if ($(this).val() == "NoOfLoanDueInstallment") {
                $('#dueInstallment').show();
                $('#trxHistory').hide();
                $('#lastTrxMonth').val('');
            }

            if ($(this).val() =="LastTrxMonth") {
                $('#dueInstallment').hide();
                $('#noOfLoanDueInstallment').val('');
                $('#trxHistory').show();
            }
        });
    });

</script>
<script type="text/javascript">
    var maxOlrsDate = "{{ $data['maxOlrsDate'] }}";
    var parts = maxOlrsDate.split('-');
    var year = parseInt(parts[0]);
    var month = parseInt(parts[1]); // 1-based

    // Advance one month
    if (month == 12) {
        year += 1;
        month = 0; 
    } else {
        month = month;
    }
    $("#monthFrom").datepicker({
        dateFormat: 'mm-yy',
        changeMonth: true,
        changeYear: true,
        showButtonPanel: true,
        minDate: new Date(year, month, 1),
        onClose: function(dateText, inst) {
            var month = $("#ui-datepicker-div .ui-datepicker-month :selected").val();
            var year = $("#ui-datepicker-div .ui-datepicker-year :selected").val();
            $(this).val($.datepicker.formatDate('mm-yy', new Date(year, month, 1)));
        }
    });

    $('#monthFrom').click(function(event) {
        this.value = '';
    }); 
</script>


@endsection