public function show2($id)
{
$loanaccount = Loanaccount::findOrFail($id);
$interest = Loanaccount::getInterestAmount($loanaccount);
$loanbalance = Loantransaction::getLoanBalance($loanaccount);
$principal_paid = Loanrepayment::getPrincipalPaid($loanaccount);
$interest_paid = Loanrepayment::getInterestPaid($loanaccount);
$loanguarantors = $loanaccount->guarantors;
return View::make('css.loanshow', compact('loanaccount', 'loanguarantors', 'interest', 'principal_paid', 'interest_paid', 'loanbalance'));
}
public static function getInterestDue($loanaccount)
{
$remaining_period = Loantransaction::getRemainingPeriod($loanaccount);
$principal_paid = Loanrepayment::getPrincipalPaid($loanaccount);
$principal_balance = $loanaccount->amount_disbursed - $principal_paid;
if ($loanaccount->loanproduct->formula == 'RB') {
$interest_due = $principal_balance * ($loanaccount->interest_rate / 100);
}
// get principal due on Straight Line
if ($loanaccount->loanproduct->formula == 'SL') {
$interest_amount = Loanaccount::getInterestAmount($loanaccount);
$interest_paid = Loanrepayment::getInterestPaid($loanaccount);
$interest_balance = $interest_amount - $interest_paid;
$interest_due = 0;
if ($interest_balance > 0 && $remaining_period > 0) {
$interest_due = $interest_balance / $remaining_period;
}
//if($loanaccount->loanproduct->amortization == 'EI'){
//$interest_due = $interest_amount / $loanaccount->repayment_duration;
//}
}
return $interest_due;
}
public function offprint($id)
{
$loanaccount = Loanaccount::findOrFail($id);
$organization = Organization::find(1);
$principal_paid = Loanrepayment::getPrincipalPaid($loanaccount);
$principal_due = $loanaccount->amount_disbursed - $principal_paid;
$interest_due = $principal_due * ($loanaccount->interest_rate / 100);
$pdf = PDF::loadView('pdf.offset', compact('loanaccount', 'organization', 'principal_paid', 'interest_due', 'principal_due'))->setPaper('a4')->setOrientation('potrait');
return $pdf->stream('Offset.pdf');
}
public static function getPrincipalBal($loanaccount)
{
$principal_amount = $loanaccount->amount_disbursed + $loanaccount->top_up_amount;
$principal_paid = Loanrepayment::getPrincipalPaid($loanaccount);
$principal_bal = $principal_amount - $principal_paid;
return $principal_bal;
}
