Пример #1
0
 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;
 }
Пример #2
0
              <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++) {
    ?>
 


              
Пример #3
0
 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;
 }