@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;
    }
    #reportSubmit{
        font-size: 12px;
        margin-top: 20px;
    }
    .amount{
        text-align: left;
    }
    .nameStyle{
        text-align: right;
    }
    .code{
        text-align: center;
    }
</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.create')}}" class="btn btn-info pull-right addViewBtn">
                                <i class="glyphicon glyphicon-plus-sign addIcon"></i> Add Regular Loan Adjustment
                            </a>
                        </div>
                        <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Regular Loan Adjustment List</h3>
                    </div>

                    <div class="panel-body panelBodyView">
                        
                        <!-- Filtering Start-->
                        <div class="row" style="padding: 1.3rem; border-radius: 8px;">
                            <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 @if (isset($data['searchData']['filReportLevel']) && $data['searchData']['filReportLevel'] == $reportLevel) selected @endif 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 @if (isset($data['searchData']['filArea']) && $data['searchData']['filArea'] == $area->id) selected @endif 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 @if (isset($data['searchData']['filZone']) && $data['searchData']['filZone'] == $zone->id) selected @endif 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 @if (isset($data['searchData']['filRegion']) && $data['searchData']['filRegion'] == $region->id) selected @endif 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 @if (isset($data['searchData']['filBranch']) && $data['searchData']['filBranch'] == $key) selected @endif 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" @if (isset($data['searchData']['monthFrom'])) value="{{$data['searchData']['monthFrom']}}"@endif>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label for="" style="color:#708090">.</label>
                                            <div class="col-md-12">
                                                <button type="submit" class="btn btn-primary input-fields" >Show</button>	
                                            </div>
                                        </div>
                                    </div>
                                </form>                       
                            </div>
                       
                            <!-- filtering end-->
                            
                            <div class="row">
                                <div class="col-md-12"  id="reportingDiv">
                                    <table class="table table-striped table-bordered view">
                                        <thead>
                                            <tr>
                                                <th>SL</th>
                                                <th>Adjustment Date</th>
                                                <th>Branch</th>
                                                <th>Gender</th>
                                                <th>Product</th>
                                                <th>Loan Code</th>
                                                <th>Total Installment (Rescheduled amount)</th>
                                                <th>total Princepal</th>
                                                <th>total Interest</th>
                                                <th>partial Paid Princepal</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @forelse ($data["regularLoanAdjustmentLists"] as $loanAdjustment)
                                                <tr>
                                                    <td>{{$loop->iteration}}</td>
                                                    <td>{{date_format(date_create($loanAdjustment->adjustmentDate),"d-m-Y")}}</td>
                                                    <td class="code">{{$data['branchList'][$loanAdjustment->branch_id]}}</td>
                                                    <td class="nameStyle">{{$data['genderList'][$loanAdjustment->gender]}}</td>
                                                    <td class="code">{{$data['loanProductList'][$loanAdjustment->product_id]}}</td>
                                                    <td class="code">{{$loanAdjustment->loanCode}}</td>
                                                    <td class="amount">{{number_format( $loanAdjustment->totalInstallment)}}</td>
                                                    <td class="amount">{{number_format( $loanAdjustment->totalPrincepal,2)}}</td>
                                                    <td class="amount">{{number_format( $loanAdjustment->totalInterest,2)}}</td>
                                                    <td class="amount">{{number_format( $loanAdjustment->partialPaidPrincepal,2)}}</td>
                                                    <td>
                                                        <button class="btn btn-sm btn-primary alt-details" data-adjustment-id="{{ $loanAdjustment->id }}">
                                                            <i class='fas fa-undo'></i>
                                                        </button>
                                                    </td>
                                                </tr>
                                            @empty
                                                <tr><p>No Data Found!</p></tr>
                                            @endforelse
                                            <tr>
                                                <td colspan="6">Total</td>
                                                <td class="amount">{{number_format($data['totalInstallment'])}}</td>
                                                <td class="amount">{{number_format($data['totalPrincepal'],2)}}</td>
                                                <td class="amount">{{number_format($data['totalInterest'],2)}}</td>
                                                <td class="amount">{{number_format($data['totalPaidPrincepal'],2)}}</td>
                                                <td></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                    {{-- @if (count($data['loanAdjustments'])>0)
                                        {{$data['loanAdjustments']->appends(request()->input())->render()}}                                        
                                    @endif --}}
                                </div>
                            </div>
                        </div>
                    </div>		
                </div>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="loanDetailModal" tabindex="-1" aria-labelledby="loanDetailModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg" style="margin-top: 18rem;">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="loanDetailModalLabel" style="color: black">Loan Details</h5>
                {{-- <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> --}}
            </div>
            <div class="modal-body" id="oldLoanDetailContent">
                <!-- AJAX content will load here -->
            </div>
        </div>
    </div>
</div>

<script>
    $(document).ready(function () {
        $('.alt-details').on('click', function () {
            var adjustmentId = $(this).data('adjustment-id');

            Swal.fire({
                // title: 'Are you sure?',
                title: " Do You want to alter this loan schedules!!!",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Yes, proceed'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        url: '{{ route('regularLoanAdjustment.altLoanSchedule') }}',
                        method: 'POST',
                        data: { adjustmentId: adjustmentId },
                        success: function (response) {
                            if (response.responseTitle === "warning" || response.responseTitle === "error") {
                                toastr.warning(response.responseText, response.responseTitle);
                            } else {
                                toastr.success(response.responseText, response.responseTitle);
                                setTimeout(function () {
                                    location.reload();
                                }, 1500); // small delay so toastr message shows before reload
                            }
                        },
                        error: function (xhr) {
                            Swal.fire('Error', 'Something went wrong. Please try again.', 'error');
                        }
                    });
                }
            });
        });
    });
</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();
                // $("#filZone").val('');
                // $("#filRegion").val('');
                // $("#filArea").val('');

                $("#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();
                // $("#filZone").val('');
                // $("#filRegion").val('');
                // $("#filBranch").val('');
                //$("#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();
                // $("#filArea").val('');
                // $("#filRegion").val('');
                // $("#filBranch").val('');
                //$("#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();
                // $("#filArea").val('');
                // $("#filZone").val('');
                // $("#filBranch").val('');

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

        let searchLevel = "{{isset($data['searchData']['filReportLevel']) ? $data['searchData']['filReportLevel']:''}}";
        switch (searchLevel) {
            case "Branch":
                $("#branchDiv").show();
                $("#regionDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                break;
            case "Area":
                $("#areaDiv").show();
                $("#branchDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();
                break;
            case "Zone":
                $("#zoneDiv").show();
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#regionDiv").hide();
                break;
            case "Division":
                $("#regionDiv").show();
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                break;
            default:
                $("#branchDiv").show();
                break;
        }
    });

</script>
<script type="text/javascript">
    $("#monthFrom").datepicker({
        dateFormat: 'mm-yy',
        changeMonth: true,
        changeYear: true,
        showButtonPanel: true,
        minDate: '04-2025',
        maxDate: 'c',      
        
        // Customize the appearance for month/year selection
        beforeShow: function(input, inst) {
            inst.dpDiv.addClass('month-year-picker');
        },
        
        // Handle close event to format properly
        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).datepicker('setDate', new Date(year, month, 1));
        }
    });

    // Hide the day selection part with CSS
    $('<style>\
        .month-year-picker .ui-datepicker-calendar {\
            display: none;\
        }\
        .month-year-picker .ui-datepicker-current {\
            display: none;\
        }\
    </style>').appendTo('head');

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