@extends('layouts/microfin_layout')
@section('title', '| Add Loan Rebate')
@section('content')

@php
use \App\Http\Controllers\microfin\savings\MfnSavingsDepositTypeController as createForm;
@endphp

<div class="row add-data-form">
    <div class="col-md-12">
        <div class="col-md-10 col-md-offset-1 fullbody">
            <div class="viewTitle" style="border-bottom:1px solid white;">
                <a href="{{ url('viewMfnLoanRebates/') }}" class="btn btn-info pull-right addViewBtn">
                    <i class="glyphicon glyphicon-th-list viewIcon"></i>
                    Loan Rebate List
                </a>
            </div>
            <div class="panel panel-default panel-border">
                <div class="panel-heading">
                    <div class="panel-title">New Loan Rebate</div>
                </div>
                <div class="panel-body">
                    <div class="row">

                        {!! Form::open(array('url' => '', 'role' => 'forl', 'id' => 'rootwizard', 'class' => 'form-horizontal form-groups', 'novalidate' => '')) !!}

                        <div class="tab-content no-margin">
                            <div class="tab-pane with-bg active" id="fwv-1">
                                <div class="panel panel-default" style="padding:0!important;">

                                    <div class="panel-body" style="padding:5px 10px;">
                                        <div class="row">
                                            <div class="col-xs-6">

                                                {!! Form::hidden('memberId',null,['id'=>'memberId']) !!}
                                                {!! Form::hidden('branchId',null,['id'=>'branchId']) !!}
                                                {!! Form::hidden('samityId',null,['id'=>'samityId']) !!}
                                                {!! Form::hidden('workingAreaId',null,['id'=>'workingAreaId']) !!}
                                                {!! Form::hidden('totalRebateAmount',null,['id'=>'totalRebateAmount']) !!}

                                                @if(!in_array($userRoleId, Config('services.branch_level_user_roles')))
                                                {!! createForm::select('filBranch',$branchList,null,'Branch:',['id'=>'filBranch','autocomplete'=>'off']) !!}
                                                @endif

                                                {!! createForm::select('filSamity',$samityList,null,'Samity:',['id'=>'filSamity','autocomplete'=>'off']) !!}

                                                {!! createForm::text('member','','Member:',['id'=>'member','autocomplete'=>'off']) !!}
                                                {!! createForm::select('loanId',[''=>'Select'],null,'Loan Id:',['id'=>'loanId','autocomplete'=>'off']) !!}

                                                {!! createForm::text('rebateDate',null,'Rebate Date:',['id'=>'rebateDate','autocomplete'=>'off','readonly'=>'readonly','style'=>'cursor:pointer']) !!}

                                                {!! createForm::text('principalAmount','','Principal Amount:',['id'=>'principalAmount','autocomplete'=>'off','readonly'=>'readonly']) !!}
                                                {!! createForm::text('interestAmount','','Interest Amount:',['id'=>'interestAmount','autocomplete'=>'off','readonly'=>'readonly']) !!}
                                                {!! createForm::text('rebateAmount','','Rebate Amount:',['id'=>'rebateAmount','autocomplete'=>'off', 'readonly'=>'readonly']) !!}
                                                {!! createForm::text('rebateAdjustAmount','','Rebate Adjust Amount:',['id'=>'rebateAdjustAmount','autocomplete'=>'off', 'readonly'=>'readonly', 'amountLimit'=>0]) !!}

                                                <div class="form-group">
                                                    {!! Form::label('notes', 'Notes:', ['class' => 'col-sm-4 control-label']) !!}
                                                    <div class="col-sm-8">
                                                        {!! Form::textarea('notes','',['class'=>'form-control','rows'=>4]) !!}
                                                    </div>
                                                </div>

                                            </div>{{-- End First Column --}}

                                            {{-- Second Coloum --}}
                                            <div class="col-xs-6">

                                                @php
                                                  $tableRows = ['Payable','Transaction','Outstanding','Installment','Advance','Due','Rebateable','Payable After Rebate'];
                                                @endphp

                                                <h4 id="loanInfoTableHeading">Loan Information</h4>
                                                <table id="loanInfoTable" class="table table-striped table-bordered">
                                                    <thead>
                                                        <tr>
                                                            <th>Loan</th>
                                                            <th>Total</th>
                                                            <th>Principal</th>
                                                            <th>Interest</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach ($tableRows as $tableRow)
                                                          <tr class="{{$tableRow}}">
                                                              <td class="name">{{$tableRow}}</td>
                                                              <td class="amount"></td>
                                                              <td class="amount"></td>
                                                              <td class="amount"></td>
                                                          </tr>
                                                        @endforeach

                                                    </tbody>
                                                </table>
                                                
                                            </div>
                                            {{-- End Second Coloum --}}

                                        </div>

                                        <div class="rebateScheduleTable panel-body" style="padding:5px 10px;"></div>

                                        <ul class="pager wizard pull-right">
                                            {!! Form::submit('Submit', ['id' => 'submit', 'class' => 'btn btn-info']) !!}
                                        </ul>

                                    </div>
                                </div>


                            </div>


                        </div>
                        {!! Form::close() !!}
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

    @php
      $members = [];
    @endphp
    

    <div id="memberList" class="container" style="display: none;position: absolute;">
        <table id="memberListTable" class="table table-fixed" style="font-size: 10px;">
            <tbody id="memberListTableBody" style=" display:block;height: 120px;overflow-y: auto !important;overflow-x: hidden;float:left;">
                @foreach ($members as $member)
                @php
                $branchName = DB::table('gnr_branch')->where('id',$member->branchId)->value('name');
                $samity = DB::table('mfn_samity')->where('id',$member->samityId)->select('name','workingAreaId')->first();
                $workingAreaName = DB::table('gnr_working_area')->where('id',$samity->workingAreaId)->value('name');
                @endphp
                <tr>
                    <td memberId="{{$member->id}}" branchId="{{$member->branchId}}" samityId="{{$member->samityId}}" workingAreaId="{{$samity->workingAreaId}}" style="text-align: left;">
                        <span class="memberName" style="font-size: 11;font-weight: bold;">{{$member->name}}</span> -
                        <span class="memberCode" style="font-size: 11;font-weight: bold;">{{$member->code}}</span><br>
                        {{'Branch: '.$branchName}}<br>
                        {{'Samity: '.$samity->name}}<br>
                        {{'Working Area: '.$workingAreaName}}
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>


    <style type="text/css">
        #rootwizard .panel-body .row {
            margin-bottom: 10px;
        }

        #rootwizard,
        #rootwizard .form-control {
            font-size: 11px !important;
            padding: 5px !important;
        }
        
        #rootwizard label {
            margin-bottom: 0 !important;
            color: #555 !important;
        }

        .validate-has-error {
            color: #FF0000;
        }

        .error {
            color: red;
        }

        #loanInfoTable,
        #loanInfoTableHeading {
            color: black;
        }

        #loanInfoTable tbody {
            width: 100px !important;
        }

        #loanInfoTable tbody tr.Rebateable td {
            color: red;
        }
    </style>

    <script type="text/javascript">
        $(document).ready(function() {
            
            $("#rebateAdjustAmount").attr("type", "hidden")
            $("label[for='rebateAdjustAmount']").hide();

            $("#filBranch").change(function(event) {
                var branchId = $(this).val();
                $("#filSamity option:gt(0)").remove();
                $("#memberListTableBody").empty();

                if (branchId == '') {
                    return false;
                }

                $.ajax({
                        url: './getMfnBranchWiseSamityList',
                        type: 'POST',
                        dataType: 'json',
                        data: {
                            branchId: branchId
                        },
                    })
                    .done(function(samityList) {
                        $.each(samityList, function(index, val) {
                            $("#filSamity").append("<option value='" + index + "'>" + val + "</option>");
                        });
                    })
                    .fail(function() {
                        alert("response error");
                    });

            });

            $("#filSamity").change(function(event) {
                var samityId = $(this).val();
                $("#memberListTableBody").empty();
                if (branchId != '') {
                    $.ajax({
                            url: './getSamityWiseMemeberDropDownList',
                            type: 'POST',
                            dataType: 'json',
                            data: {
                                samityId: samityId
                            },
                        })
                        .done(function(concatString) {
                            $("#memberListTableBody").append(concatString);
                            setMemberListTableSize();
                        })
                        .fail(function() {
                            console.log("error");
                        });
                }
            });

            function num(argument) {
                return argument.toLocaleString('en-US', {
                    minimumFractionDigits: 2,
                    maximumFractionDigits: 2
                });
            }

            $("#rebateAmount").on('input', function() {
                this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');  
            });
            
            $("#rebateAdjustAmount").on('input', function() {
                this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');
            });

            

            /*Form*/
            $('form').submit(function(event) {
                event.preventDefault();

                $("#submit").prop('disabled', true);

                $.ajax({
                    type: 'post',
                    url: './storeMfnLoanRebate',
                    data: $('form').serialize(),
                    dataType: 'json',
                    success: function(_response) {

                        $(".error").remove();
                        if (_response.errors) {
                            $("#submit").prop('disabled', false);
                            $.each(_response.errors, function(name, error) {
                                $("#" + name).after("<p class='error'>* " + _response.errors[name] + "</p>");
                            });
                        } else {
                            if (_response.responseTitle == 'Warning!') {
                                toastr.warning(_response.responseText, _response.responseTitle, opts);
                            } else {
                                toastr.success(_response.responseText, _response.responseTitle, opts);

                                setTimeout(function() {
                                    window.location.href = '{{ url("viewMfnLoanRebates/") }}';
                                }, 3000);

                            }

                        }
                    },
                    error: function(_response) {
                        $("#submit").prop('disabled', false);
                        alert('Response Error');
                    }
                });

            });
            /* End Form*/

            /*Hide Errors On Filed input or Change*/
            $(document).on('input', 'input', function() {
                $(this).closest('div').find('.error').remove();
            });
            $(document).on('change', 'select', function() {
                $(this).closest('div').find('.error').remove();
            });
            /*End Hide Errors On Filed input or Change*/

            /*show the member list table on double click the member text field*/
            $("#member").click(function(event) {
                $("#memberList").show('slow/400/fast');
            });
            /*end show the member list table on double click the member text field*/

            /*on select td set the valus of hidden field for the member*/
            //  $("#memberListTable tbody tr td").on('click', function(event) {
            //     $("#memberId").val($(this).attr('memberId'));
            //     $("#branchId").val($(this).attr('branchId'));
            //     $("#samityId").val($(this).attr('samityId'));
            //     $("#workingAreaId").val($(this).attr('workingAreaId'));

            //     $("#member").val($(this).find('.memberName').text() + ' - '+$(this).find('.memberCode').text());

            //     $("#memberList").hide('slow/400/fast');   

            //     $("#product").trigger('change');
            //     $("#memberId").trigger('change');
            //  });
            $(document).on('click', '#memberListTable tbody tr td', function(event) {
                $("#memberId").val($(this).attr('memberId'));
                $("#branchId").val($(this).attr('branchId'));
                $("#samityId").val($(this).attr('samityId'));
                $("#workingAreaId").val($(this).attr('workingAreaId'));

                $("#member").val($(this).find('.memberName').text() + ' - ' + $(this).find('.memberCode').text());

                $("#memberList").hide('slow/400/fast');

                $("#product").trigger('change');
                $("#memberId").trigger('change');
            });
            /*end on select td set the valus of hidden field for the member*/

            /*set the memberList position*/
            function setMemberListTableSize() {
                var top = $('#member').offset().top - 90;
                var left = $('#member').offset().left - 15;
                var width = $('#member').width() + 13;

                $("#memberList").css({
                    top: top
                });
                $("#memberList").css({
                    left: left
                });
                $("#memberList").width(width);
                $("#memberListTable tbody tr td").width(width);
            }

            setMemberListTableSize();

            $(window).resize(function() {
                setMemberListTableSize();
            });

            /*end set the memberList position*/

            var matchedIndex = new Array();
            /*make search throgh table of member*/
            $("#member").on('input', function(event) {

                // Reset the values
                $("#memberId").val('');
                $("#branchId").val('');
                $("#samityId").val('');


                var inputValue = $(this).val().toLowerCase();

                $("#memberList").show('slow/400/fast');

                matchedIndex = [];

                $("#memberListTable tbody tr td").each(function(index, el) {
                    var memberName = $(el).find('.memberName').text().toLowerCase();
                    var memberCode = $(el).find('.memberCode').text().toLowerCase();
                    var fullText = memberName + ' - ' + memberCode;

                    if (memberName.indexOf(inputValue) !== -1 || memberCode.indexOf(inputValue) !== -1 || fullText.indexOf(inputValue) !== -1) {
                        $(el).show();
                        matchedIndex.push($(el).closest('tr').index());
                    } else {
                        $(el).hide();
                    }

                });
                /* Act on the event */
            });
            /*end make search throgh table of member*/

            $(document).keydown(function(e) {

                //Enter key
                if (e.keyCode == 13 && matchedIndex.length == 1) {
                    e.preventDefault();
                    $("#memberListTable tbody tr").eq(matchedIndex[0]).find('td').trigger('click');
                }

            });


            /*on change memberId get the loans*/
            $("#memberId").change(function(event) {
                $("#rebateAmount").val('');
                $("#rebateAdjustAmount").val('');

                var memberId = $(this).val();
                console.log(memberId);

                if (memberId == '' || memberId == null) {
                    $("#savingsCode").find("option:gt(0)").remove();
                    return false;
                }

                $.ajax({
                        url: './getMfnActiveLoanAccountsOfParticularMember',
                        type: 'POST',
                        dataType: 'json',
                        data: {
                            memberId: memberId
                        },
                    })
                    .done(function(loanAccounts) {
                        $("#loanId").find("option:gt(0)").remove();
                        $.each(loanAccounts, function(index, loanCode) {
                            $("#loanId").append("<option value='" + index + "'>" + loanCode + "</option>");
                        });
                    })
                    .fail(function() {
                        alert("error");
                    });

            });

            $("#memberId").change(function(event) {
                console.log('check adjustment');

                // only to check the loan collection adjustment is authorized or not so operation does not matter...
                var memberId = $(this).val();

                $.ajax({
                        url: './mfnGetRegularLoanAccountsOfParticularMember',
                        type: 'POST',
                        dataType: 'json',
                        data: {
                            memberId: memberId,
                            operation: 'waiver'
                        },
                    })
                    .done(function(loanAccounts) {
                        console.log('check adhustment : ', loanAccounts);
                        if (loanAccounts.isAdjustmentAuthorized > 0) {
                            $("#loanId").find("option:gt(0)").remove();
                            alert('Please authorize the loan collection adjustment at first!')
                        }
                    })
                    .fail(function() {
                        alert("error");
                    });
            });
            /*end on change memberId get the loans*/

            /*get account balance info on change loan id*/
            $("#loanId").change(function(event) {

                $("#rebateAmount, #rebateAdjustAmount").val('')                
                $("#rebateAmount, #rebateAdjustAmount").prop('readonly', true)             
                var loanId = $(this).val()

                if (loanId == '' || loanId == null) {
                    $("#rebateAmount, #rebateAdjustAmount, #waiverType").val('');
                    return false;
                }

                var rebateDate = $("#rebateDate").val();

                $.ajax({
                        url: './mfnGetLoanInfoForRebate',
                        type: 'POST',
                        dataType: 'json',
                        data: {
                            loanId: loanId
                        },
                        async: false,
                    })
                    .done(function(data) {
                        console.log(data)
                        if (data.error) {
                            toastr.warning(data.msg, '!! Warning !!')
                            return
                        }

                        $("#principalAmount").val(data['principalAmount']);
                        $("#interestAmount").val(data['interestAmount']);
                        $("#outstandingAmount").val(data['outStandingAmount']);
                        $("#rebateDate").val(data['rebateDate']);

                        $("#rebateAmount").val(data['rebateAmount'])
                        // $("#rebateAdjustAmount").val(0).prop('readonly', !data['canEditRebateAmount']).attr('amountLimit', data['rebateAmount'].replace(',', ''))   
                        $("#totalRebateAmount").val(data['rebateAmount'])   
                        
                        if(data['canEditRebateAmount']){
                            $("label[for='rebateAdjustAmount']").show()
                            $("#rebateAdjustAmount").prop('readonly', false).attr("type", "")
                            $("#rebateAdjustAmount").val(0).attr('amountLimit', data['rebateAmount'].replace(',', ''))   
                        }
                        
                        $(".rebateScheduleTable").html(data['rebateScheduleTable'])

                        var element = $("#loanInfoTable tbody").find('.Payable');
                        element.find('td').eq(1).html(data['payableTotal']);
                        element.find('td').eq(2).html(data['payablePricipal']);
                        element.find('td').eq(3).html(data['payableInterest']);

                        var element = $("#loanInfoTable tbody").find('.Transaction');
                        element.find('td').eq(1).html(data['traTotal']);
                        element.find('td').eq(2).html(data['traPrincipal']);
                        element.find('td').eq(3).html(data['traInterest']);

                        var element = $("#loanInfoTable tbody").find('.Outstanding');
                        element.find('td').eq(1).html(data['outStandingAmount']);
                        element.find('td').eq(2).html(data['principalAmount']);
                        element.find('td').eq(3).html(data['interestAmount']);

                        var element = $("#loanInfoTable tbody").find('.Installment');
                        element.find('td').eq(1).html(data['installmentTotal']);
                        element.find('td').eq(2).html(data['installmentPrincipal']);
                        element.find('td').eq(3).html(data['installmentInterest']);

                        var element = $("#loanInfoTable tbody").find('.Advance');
                        element.find('td').eq(1).html(data['advanceTotal']);
                        element.find('td').eq(2).html(data['advancePricipal']);
                        element.find('td').eq(3).html(data['advanceInterest']);

                        var element = $("#loanInfoTable tbody").find('.Due');
                        element.find('td').eq(1).html(data['dueTotal']);
                        element.find('td').eq(2).html(data['duePricipal']);
                        element.find('td').eq(3).html(data['dueInterest']);

                        // var element = $("#loanInfoTable tbody").find('.Rebateable');
                        // element.find('td').eq(1).html(data['interestAmount']);
                        // element.find('td').eq(2).html(0);
                        // element.find('td').eq(3).html(data['interestAmount']);
                        var element = $("#loanInfoTable tbody").find('.Rebateable');
                        element.find('td').eq(1).html(data['rebateAmount']);
                        element.find('td').eq(2).html(0);
                        element.find('td').eq(3).html(data['rebateAmount']);                        
                    })
                    .fail(function() {
                        alert("error");
                    });

                $('#waiverType').trigger('change');

            });
            /*end get account balance info on change loan id*/


            $(document).mouseup(function(e) {
                var container = $("#memberList");
                // if the target of the click isn't the container nor a descendant of the container
                if (!container.is(e.target) && container.has(e.target).length === 0) {
                    container.hide('slow/400/fast');
                }
            });


            /*check the amount limit of waiver amount*/
            $("#rebateAdjustAmount").on('input', function(event) {
                $(".amountLimit").remove();
                var amountLimit = parseFloat($(this).attr('amountlimit'));
                var inputAmount = 0;
                if (this.value != '') {
                    inputAmount = parseFloat(this.value)
                    rebateAmount = amountLimit - inputAmount
                    $("#rebateAmount").val(rebateAmount.toLocaleString())
                    $("#rebateAdjustAmount").val(inputAmount.toLocaleString())                    
                }

                if (inputAmount > amountLimit) {
                    this.value = ''
                    $("#rebateAmount").val(amountLimit.toLocaleString())

                    $(this).after("<p class='amountLimit' style='color:red;'>* Rebate adjust amount can not be greater than rebate amount.</p>")

                    var element = $("#loanInfoTable tbody tr:last");
                    element.find('td').eq(1).html('');
                    element.find('td').eq(2).html('');
                    element.find('td').eq(3).html('');
                } else {
                    
                    rebateAmount = amountLimit - inputAmount
                    var element = $("#loanInfoTable tbody").find('.Rebateable');
                    element.find('td').eq(1).html(rebateAmount.toLocaleString());
                    element.find('td').eq(2).html(0);
                    element.find('td').eq(3).html(rebateAmount.toLocaleString());
                        
                    calculatePayableAmountAfterRebate(inputAmount);
                }
            });
            /*end check the amount limit of waiver amount*/

            /*calculate payable amount after rebate*/
            function calculatePayableAmountAfterRebate(rebateAmount) {
                var rebateAmount = parseFloat(rebateAmount);
                var principalAmount = 0;
                var interestAmount = 0;
                if ($("#principalAmount").val().replace(',', '') != '') {
                    var principalAmount = parseFloat($("#principalAmount").val().replace(',', ''));
                }
                if ($("#interestAmount").val().replace(',', '') != '') {
                    var interestAmount = parseFloat($("#interestAmount").val().replace(',', ''));
                }
                var element = $("#loanInfoTable tbody tr:last");
                element.find('td').eq(1).html(num(principalAmount + interestAmount - rebateAmount));
                element.find('td').eq(2).html(num(principalAmount));
                element.find('td').eq(3).html(num(interestAmount - rebateAmount));
            }
            /*end calculating payable amount after rebate*/

        }); /*End Ready*/
    </script>

    @endsection