public static function creditAccounts($data) { $savingaccount = Savingaccount::findOrFail(array_get($data, 'account_id')); $savingtransaction = new Savingtransaction(); $savingtransaction->date = array_get($data, 'date'); $savingtransaction->savingaccount()->associate($savingaccount); $savingtransaction->amount = array_get($data, 'amount'); $savingtransaction->type = array_get($data, 'type'); $savingtransaction->description = 'savings deposit'; $savingtransaction->save(); // deposit if (array_get($data, 'type') == 'credit') { foreach ($savingaccount->savingproduct->savingpostings as $posting) { if ($posting->transaction == 'deposit') { $debit_account = $posting->debit_account; $credit_account = $posting->credit_account; } } $data = array('credit_account' => $credit_account, 'debit_account' => $debit_account, 'date' => array_get($data, 'date'), 'amount' => array_get($data, 'amount'), 'initiated_by' => 'system', 'description' => 'cash deposit'); $journal = new Journal(); $journal->journal_entry($data); Audit::logAudit(date('Y-m-d'), Confide::user()->username, 'savings deposit', 'Savings', array_get($data, 'amount')); } }
$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); }
public function savinglisting() { $savings = Savingaccount::all(); $organization = Organization::find(1); $pdf = PDF::loadView('pdf.savingreports.savingbalances', compact('savings', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Savings Listing.pdf'); }
public function statement($id) { $account = Savingaccount::findOrFail($id); $transactions = $account->transactions; $credit = DB::table('savingtransactions')->where('savingaccount_id', '=', $account->id)->where('type', '=', 'credit')->sum('amount'); $debit = DB::table('savingtransactions')->where('savingaccount_id', '=', $account->id)->where('type', '=', 'debit')->sum('amount'); $balance = $credit - $debit; $organization = Organization::findOrFail(1); $pdf = PDF::loadView('pdf.statement', compact('transactions', 'organization', 'account', 'balance'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('statement.pdf'); }
$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>
/** * Remove the specified savingaccount from storage. * * @param int $id * @return Response */ public function destroy($id) { Savingaccount::destroy($id); return Redirect::route('savingaccounts.index'); }
public function savingtransactions($acc_id) { $account = Savingaccount::findorfail($acc_id); $balance = Savingaccount::getAccountBalance($account); return View::make('css.savingtransactions', compact('account', 'balance')); }