|
|
principalAmount;
$total_i = $total_i + $loan->loanInterest;
$access = DB::table('user_task')->where('page','loan')->where('user_id',Auth::id())->get();
foreach($access as $user){
if($user->task == 'Review'){
?>
View
task == 'Edit'){
## Cheking if this loan approved and reviews
$approved = count(DB::table('repaymentschedule')->where('loan_id',$loan->id)->get());
if($loan->reviewed=='No' && $approved == 0){
?> Edit Edit
|
get_borrower_id($loan->borrower_id,$loan->borrowerType));
?>
|
status) ?>
|
repaymentsNumber < 12){
// $repayNumber = $loan->repaymentsNumber ." months";
}else{
$repayNumber = $loan->loanDuration." years";
}
foreach(DB::table('loanproducts')->where('id',$loan->loanProduct)->get() as $product){
echo $product->loan_product_name." ".$repayNumber;
}
?>
|
loanReleaseDate))?> |
matuarityDate ?> |
principalAmount,2) ?> |
loanInterest,2)."%" ?> |
get_borrower_penalty_amount($loan->id,$loan->borrower_id);
$total_penalt = $total_penalt + $penalty;
echo number_format($penalty,2);
?>
|
select(DB::raw("SUM(principal) as principal"),DB::raw("SUM(interest) as interest"),DB::raw("SUM(fee) as fee"),DB::raw("SUM(penalty) as penalty"))
->where('loan_id', $loan->id)->get();
foreach($data as $da){
$principal = $da->principal;
$interest = $da->interest;
$fee = $da->fee;
$penalty = $da->penalty;
}
$due = $principal + $interest;
echo number_format($due,2);
$total_due = $total_due + $due;
?>
|
get_borrower_paid_amount($loan->id,$loan->borrower_id);
$total_paid = $total_paid + $paid;
echo number_format($paid,2);
?>
|
|