public static function getLoanBalance($loanaccount) { //$principal_paid = Loanrepayment::getPrincipalPaid($loanaccount); //$interest_paid = Loanrepayment::getInterestPaid($loanaccount); //$total_paid = $principal_paid + $interest_paid; //loan_amount = Loanaccount::getLoanAmount($loanaccount); //$balance = $loan_amount - $total_paid; $payments = DB::table('loantransactions')->where('loanaccount_id', '=', $loanaccount->id)->where('type', '=', 'credit')->sum('amount'); $loanamount = Loanaccount::getLoanAmount($loanaccount); $balance = $loanamount - $payments; return $balance; }
<td>0</td> <td>{{ $loanaccount->date_disbursed }}</td> <td>{{ asMoney($loanaccount->amount_disbursed + $loanaccount->top_up_amount)}}</td> <td>{{ asMoney(Loanaccount::getInterestAmount($loanaccount))}}</td> <td>{{ asMoney(Loanaccount::getLoanAmount($loanaccount)) }}</td> <td>{{ asMoney(Loanaccount::getLoanAmount($loanaccount)) }}</td> <td>{{ asMoney(0) }}</td> </tr> <?php $date = $loanaccount->repayment_start_date; $interest = Loanaccount::getInterestAmount($loanaccount); $principal = $loanaccount->amount_disbursed + $loanaccount->top_up_amount; $balance = Loanaccount::getLoanAmount($loanaccount); $days = 30; $totalint = 0; if ($loanaccount->repayment_duration != null) { $period = $loanaccount->repayment_duration; } else { $period = $loanaccount->period; } $principal_amount = $loanaccount->amount_disbursed / $period; $total_principal = 0; for ($i = 1; $i <= $period; $i++) { ?>
public static function getEMP($loanaccount) { $loanamount = Loanaccount::getLoanAmount($loanaccount); if ($loanaccount->repayment_duration > 0) { $period = $loanaccount->repayment_duration; } else { $period = $loanaccount->period; } if ($loanaccount->loanproduct->amortization == 'EP') { if ($loanaccount->loanproduct->formula == 'RB') { $principal = $loanaccount->amount_disbursed + $loanaccount->top_up_amount; $principal = $principal / $period; $interest = Loantransaction::getLoanBalance($loanaccount) * ($loanaccount->loanproduct->rate / 100); $mp = $principal + $interest; } if ($loanaccount->loanproduct->formula == 'SL') { $mp = $loanamount / $period; } } if ($loanaccount->loanproduct->amortization == 'EI') { $mp = $loanamount / $loanaccount->repayment_duration; } return $mp; }