@extends('layouts.master')
@section('title')
    {{translate('loan calculator')}}
@endsection
@section('content')
        <div class="box box-info">
        <div class="panel-body table-responsive no-padding">
            <table id="" class="table table-bordered table-condensed table-hover">
                <thead>
                <tr style="background-color: #D1F9FF">
                    <th>{{translate('released')}}</th>
                    <th>{{translate('maturity')}}</th>
                    <th>{{translate('repayment')}}</th>
                    <th>{{translate('principal')}}</th>
                    <th>{{translate('interest')}}%</th>
                    <th>{{translate('interest')}}</th>
                    <th>{{translate('fee')}}</th>
                    <th>{{translate('due')}}</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td>{{$request->release_date}}</td>
                    <td>{{date_format(date_add(date_create($request->first_payment_date),
            date_interval_create_from_date_string($period .' '.$request->repayment_cycle. ' s')),'Y-m-d')}}</td>
                    <td id="repayment">
                        @if($request->repayment_cycle=='daily')
                            {{translate('daily')}}
                        @endif
                        @if($request->repayment_cycle=='weekly')
                            {{translate('weekly')}}
                        @endif
                        @if($request->repayment_cycle=='monthly')
                            {{translate('monthly')}}
                        @endif
                        @if($request->repayment_cycle=='bi_monthly')
                            {{translate('bi_monthly')}}
                        @endif
                        @if($request->repayment_cycle=='quarterly')
                            {{translate('quarterly')}}
                        @endif
                        @if($request->repayment_cycle=='semi_annual')
                            {{translate('semi_annually')}}
                        @endif
                        @if($request->repayment_cycle=='annually')
                            {{translate('annual')}}
                        @endif
                    </td>
                    <td>{{currency_converter($request->principal)}}</td>
                    <td>  {{currency_converter($request->interest_rate)}}%/{{$request->interest_period}}</td>
                    <td id="interest"></td>
                    <td id="fees">0</td>
                    <td id="due"></td>
                </tr>
                </tbody>
            </table>
        </div>
    </div>
    <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 < '{{$period}}'; 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 < '{{$period}}'; 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">
            <h3 class="panel-title">{{translate('edit schedule')}}</h3>

            <div class="heading-elements">

            </div>
        </div>
        {!! Form::open(array('url' => url('loan/loan_calculator/store'), 'method' => 'post','target'=>'_blank', 'class' => 'form-horizontal')) !!}
        <input type="hidden" name="release_date" value="{{$request->release_date}}">
        <input type="hidden" name="maturity_date" value="{{date_format(date_add(date_create($request->first_payment_date),
            date_interval_create_from_date_string($period .' '.$request->repayment_cycle. ' s')),'Y-m-d')}}">
        <input type="hidden" name="repayment_cycle" id="repayment_cycle" value="{{$request->repayment_cycle}}">
        <input type="hidden" name="interest_rate" id="interest_rate" value="{{$request->interest_rate}}">
        <input type="hidden" name="release_date" value="{{$request->release_date}}">
        <input type="hidden" name="interest_period" value="{{$request->interest_period}}">
        <input type="hidden" name="first_payment_date" value="{{$request->first_payment_date}}">
        <input type="hidden" name="principal_amount" value="{{$request->principal}}">
        <input type="hidden" name="total_interest" id="total_interest_field" value="">
        <input type="hidden" name="total_due" id="total_due_field" value="">

        <div class="panel-body table-responsive no-padding">

            <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="{{$period}}">