Exemple #1
0
 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);
 }
Exemple #2
0
 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;
 }
Exemple #3
0
* 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');
 }
Exemple #5
0
 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');
 }
Exemple #6
0
        <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>
-->
Exemple #7
0
 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));
?>
Exemple #9
0
      
    

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