$loanproducts = Loanproduct::all();
return View::make('autoloans', compact('loanproducts'));
});
Route::get('automated/savings', function () {
$savingproducts = Savingproduct::all();
return View::make('automated', compact('savingproducts'));
});
Route::post('automated', function () {
$members = DB::table('members')->where('is_active', '=', true)->get();
$category = Input::get('category');
if ($category == 'savings') {
$savingproduct_id = Input::get('savingproduct');
$savingproduct = Savingproduct::findOrFail($savingproduct_id);
foreach ($savingproduct->savingaccounts as $savingaccount) {
if ($savingaccount->member->is_active && Savingaccount::getLastAmount($savingaccount) > 0) {
$data = array('account_id' => $savingaccount->id, 'amount' => Savingaccount::getLastAmount($savingaccount), 'date' => date('Y-m-d'), 'type' => 'credit');
Savingtransaction::creditAccounts($data);
}
}
Autoprocess::record(date('Y-m-d'), 'saving', $savingproduct);
} else {
$loanproduct_id = Input::get('loanproduct');
$loanproduct = Loanproduct::findOrFail($loanproduct_id);
foreach ($loanproduct->loanaccounts as $loanaccount) {
if ($loanaccount->member->is_active && Loanaccount::getEMP($loanaccount) > 0) {
$data = array('loanaccount_id' => $loanaccount->id, 'amount' => Loanaccount::getEMP($loanaccount), 'date' => date('Y-m-d'));
Loanrepayment::repayLoan($data);
}
}
Autoprocess::record(date('Y-m-d'), 'loan', $loanproduct);
}
$total = 0;
?>
<td style="border-bottom:0.1px solid black; border-right:0.1px solid black;"> {{$member->membership_no }}</td>
<td style="border-bottom:0.1px solid black; border-right:0.1px solid black;"> {{$member->name }}</td>
@foreach($savingproducts as $savingproduct)
<td style="border-bottom:0.1px solid black; border-right:0.1px solid black;">
@foreach($member->savingaccounts as $savingaccount)
@if($savingaccount->savingproduct->name == $savingproduct->name)
<?php
$total = $total + Savingaccount::getLastAmount($savingaccount);
?>
{{ asMoney(Savingaccount::getLastAmount($savingaccount))}}
@endif
@endforeach
</td>
