public static function offsetLoan($data) { $loanaccount_id = array_get($data, 'loanaccount_id'); $loanaccount = Loanaccount::findorfail($loanaccount_id); $amount = array_get($data, 'amount'); $date = array_get($data, 'date'); $principal_bal = Loanaccount::getPrincipalBal($loanaccount); $interest_bal = Loanaccount::getInterestBal($loanaccount); //pay principal Loanrepayment::payPrincipal($loanaccount, $date, $principal_bal); //pay interest Loanrepayment::payInterest($loanaccount, $date, $interest_bal); Loantransaction::repayLoan($loanaccount, $amount, $date); }
public static function getInterestDue($loanaccount) { $remaining_period = Loantransaction::getRemainingPeriod($loanaccount); $principal_paid = Loanrepayment::getPrincipalPaid($loanaccount); $principal_balance = $loanaccount->amount_disbursed - $principal_paid; if ($loanaccount->loanproduct->formula == 'RB') { $interest_due = $principal_balance * ($loanaccount->interest_rate / 100); } // get principal due on Straight Line if ($loanaccount->loanproduct->formula == 'SL') { $interest_amount = Loanaccount::getInterestAmount($loanaccount); $interest_paid = Loanrepayment::getInterestPaid($loanaccount); $interest_balance = $interest_amount - $interest_paid; $interest_due = 0; if ($interest_balance > 0 && $remaining_period > 0) { $interest_due = $interest_balance / $remaining_period; } //if($loanaccount->loanproduct->amortization == 'EI'){ //$interest_due = $interest_amount / $loanaccount->repayment_duration; //} } return $interest_due; }
* orders controllers */ Route::resource('orders', 'OrdersController'); Route::post('orders/update/{id}', 'OrdersControler@update'); Route::get('orders/edit/{id}', 'OrdersControler@edit'); Route::get('orders/delete/{id}', 'OrdersControler@destroy'); Route::get('savings', function () { $mem = Confide::user()->username; $memb = DB::table('members')->where('membership_no', '=', $mem)->pluck('id'); $member = Member::find($memb); return View::make('css.savingaccounts', compact('member')); }); Route::post('loanguarantors', function () { $mem_id = Input::get('member_id'); $member = Member::findOrFail($mem_id); $loanaccount = Loanaccount::findOrFail(Input::get('loanaccount_id')); $guarantor = new Loanguarantor(); $guarantor->member()->associate($member); $guarantor->loanaccount()->associate($loanaccount); $guarantor->amount = Input::get('amount'); $guarantor->save(); return Redirect::to('memloans/' . $loanaccount->id); }); Route::get('backups', function () { //$backups = Backup::getRestorationFiles('../app/storage/backup/'); return View::make('backup'); }); Route::get('backups/create', function () { echo '<pre>'; $instance = Backup::getBackupEngineInstance(); print_r($instance);
public function offprint($id) { $loanaccount = Loanaccount::findOrFail($id); $organization = Organization::find(1); $principal_paid = Loanrepayment::getPrincipalPaid($loanaccount); $principal_due = $loanaccount->amount_disbursed - $principal_paid; $interest_due = $principal_due * ($loanaccount->interest_rate / 100); $pdf = PDF::loadView('pdf.offset', compact('loanaccount', 'organization', 'principal_paid', 'interest_due', 'principal_due'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Offset.pdf'); }
public function loanlisting() { $loans = Loanaccount::all(); $organization = Organization::find(1); $pdf = PDF::loadView('pdf.loanreports.loanbalances', compact('loans', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Loan Listing.pdf'); }
<th>#</th> <th>Date</th> <th>Description</th> <th>Cr</th> <th>Dr</th> <!-- <th>Balance</th> --> <th></th> </thead> <tbody> <?php $i = 2; $balance = $loanaccount->amount_disbursed + Loanaccount::getInterestAmount($loanaccount); ?> <tr> <td> 1</td> <td>{{ $loanaccount->date_disbursed }}</td> <td>Loan disbursement</td> <td> 0.00</td> <td >{{ asMoney($loanaccount->amount_disbursed)}}</td> <td> <!-- <a href="{{ URL::to('loantransactions/receipt/')}}" target="_blank"> <span class="glyphicon glyphicon-file" aria-hidden="true"></span> Receipt</a> -->
public static function getInterestBal($loanaccount) { $interest_amount = Loanaccount::getInterestAmount($loanaccount); $interest_paid = Loanrepayment::getInterestPaid($loanaccount); $interest_bal = $interest_amount - $interest_paid; return $interest_bal; }
?> {{$date}}</td> <td>Loan disbursed </td> <td>{{asMoney($account->amount_disbursed)}}</td> <td>{{asMoney(0)}}</td> <td>{{asMoney($account->amount_disbursed)}}</td> <!-- <td>{{asMoney(Loanaccount::getInterestAmount($account))}}</td> --> </tr> <?php $repayments = DB::table('loanrepayments')->where('loanaccount_id', '=', $account->id)->get(); $principal_balance = $account->amount_disbursed; $interest_balance = Loanaccount::getInterestAmount($account); $prinpaid = 0; $intpaid = 0; ?> @foreach($repayments as $repayment) <tr> <td> <?php $date = date("d-M-Y", strtotime($repayment->date)); ?>
@endforeach @foreach($loanproducts as $loanproduct) <td style="border-bottom:0.1px solid black; border-right:0.1px solid black;"> @foreach($member->loanaccounts as $loanaccount) @if($loanaccount->loanproduct->name == $loanproduct->name) <?php $total = $total + Loanaccount::getEMP($loanaccount); ?> {{asMoney(Loanaccount::getEMP($loanaccount) ) }} @endif @endforeach </td> @endforeach <td style="border-bottom:0.1px solid black; border-right:0.1px solid black;">
public function statement($id) { $account = Loanaccount::findOrFail($id); $transactions = $account->loantransactions; /* print_r($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.loanstatement', compact('transactions', 'organization', 'account'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('loanstatement.pdf'); }
public function topup($id) { $data = Input::all(); $date = Input::get('top_up_date'); $amount = Input::get('amount'); $loanaccount = Loanaccount::findOrFail($id); $loanaccount->is_top_up = true; $loanaccount->top_up_amount = $amount; $loanaccount->top_up_date = $date; $loanaccount->update(); Loantransaction::topupLoan($loanaccount, $amount, $date); return Redirect::to('loans/show/' . $loanaccount->id); }
public function cssupdate($id) { $mem_id = Input::get('member_id'); $member = Member::findOrFail($mem_id); $loanaccount = Loanaccount::findOrFail(Input::get('loanaccount_id')); $guarantor = Loanguarantor::findOrFail($id); $validator = Validator::make($data = Input::all(), Loanguarantor::$rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $guarantor->member()->associate($member); $guarantor->loanaccount()->associate($loanaccount); $guarantor->amount = Input::get('amount'); $guarantor->save(); return Redirect::to('memloans/' . $loanaccount->id); }