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'));
}
