$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>