@extends('layouts.master')
@section('title')
    {{translate('edit schedule')}}
@endsection
@section('content')

    <script type="text/javascript">
        function updatesum() {
            var principalTotal = 0;
            var interestTotal = 0;
            var feesTotal = 0;
            var penaltyTotal = 0;
            var inputTotalDueAmountTotal = 0;

            for (var i = 0; i < '{{\App\Models\LoanSchedule::where('loan_id',$loan->id)->count()+$rows}}'; i++) {
                var principal = document.getElementById("principal" + i).value;
                var interest = document.getElementById("interest" + i).value;
                var fees = document.getElementById("fees" + i).value;
                var penalty = document.getElementById("penalty" + i).value;

                if (principal == "")
                    principal = 0;
                if (interest == "")
                    interest = 0;
                if (fees == "")
                    fees = 0;
                if (penalty == "")
                    penalty = 0;

                var totaldue = parseFloat(principal) + parseFloat(interest) + parseFloat(fees) + parseFloat(penalty);
                document.getElementById("due" + i).value = Math.floor(totaldue * 100) / 100;

                principalTotal = parseFloat(principalTotal) + parseFloat(principal) * 100;
                interestTotal = parseFloat(interestTotal) + parseFloat(interest) * 100;
                feesTotal = parseFloat(feesTotal) + parseFloat(fees) * 100;
                penaltyTotal = parseFloat(penaltyTotal) + parseFloat(penalty) * 100;

                inputTotalDueAmountTotal = parseFloat(inputTotalDueAmountTotal) + parseFloat(totaldue) * 100;
            }
            document.getElementById("principalTotal").value = Math.floor(principalTotal * 100) / 10000;
            document.getElementById("interestTotal").value = Math.floor(interestTotal * 100) / 10000;
            document.getElementById("feesTotal").value = Math.floor(feesTotal * 100) / 10000;
            document.getElementById("penaltyTotal").value = Math.floor(penaltyTotal * 100) / 10000;
            document.getElementById("inputTotalDueAmountTotal").value = Math.floor(inputTotalDueAmountTotal * 100) / 10000;

            var total_principal_amount = 0;
            var pending_balance = 0;
            var principalTotal = document.getElementById("principalTotal").value;
            for (var i = 0; i < '{{\App\Models\LoanSchedule::where('loan_id',$loan->id)->count()+$rows}}'; i++) {
                var principal = document.getElementById("principal" + i).value;
                total_principal_amount = (parseFloat(total_principal_amount) + parseFloat(principal));
                pending_balance = parseFloat(principalTotal) - parseFloat(total_principal_amount);
                document.getElementById("principal_balance" + i).value = Math.ceil(pending_balance * 100) / 100;
            }

        }
    </script>
    <div class="box box-info">
        <div class="panel-heading">
            <h6 class="panel-title">{{translate('edit schedule')}}</h6>

            <div class="heading-elements">

            </div>
        </div>
        {!! Form::open(array('url' => url('loan/'.$loan->id.'/schedule/update'), 'method' => 'post', 'class' => 'form-horizontal')) !!}

        <div class="panel-body table-responsive no-padding">
            <ol>
                <li><b>Due Date</b> can not be less than the Loan Release Date of <b>{{$loan->release_date}}</b>
                </li>
                <li>Description is optional</li>
                <li>If you have set automated loan penalties and you see <b>System Generated Penalty</b> rows
                    below, you can delete them by visiting <b>Edit Loan</b>, checking <b>Overriding System
                        Generated Penalties</b> field and putting 0 in <b>Manual Penalty Amount</b></li>
            </ol>
            <table class="table table-bordered table-condensed  table-hover">
                <thead>
                <tr class="bg-gray">
                    <th>#</th>
                    <th>{{translate('due date')}}</th>
                    <th>{{translate('principal amount')}}</th>
                    <th></th>
                    <th>{{translate('interest amount')}}</th>
                    <th></th>
                    <th>{{translate('fee amount')}}</th>
                    <th></th>
                    <th>{{translate('penalty amount')}}</th>
                    <th></th>
                    <th>{{translate('due amount')}}</th>
                    <th>{{translate('principal balance')}}</th>
                    <th>{{translate('description')}}</th>
                </tr>
                </thead>
                <tbody>
                <input type="hidden" name="count" class="form-control"
                       value="{{\App\Models\LoanSchedule::where('loan_id',$loan->id)->count()+$rows}}">