PROFILE {{ $user->firstName." ".$user->middleName." ".$user->lastName }} Edit Details

Print Details

customerType=='Company'){ ?>

photo==NULL){?>

Unique# : {{ $user->uniqueNumber." ".ucfirst($user->customerType)}} Customer Number:id); echo $number;?>

Address : {{ $user->address }}
Location : {{ $user->city}} {{ $user->street}}
Country: {{ $user->country }}
Phone : {{ $user->phone }}
Email : {{ $user->email }}

Reg No : {{ $user->nationalID }}, {{ $user->gender}}

Reg Authority : {{ $user->lastName }}, {{ $user->gender}}

Reg Date : {{ $user->birthday }}, {{ $user->gender}}

Economic Activity : {{ $user->businessName}}

Created Date : {{ $user->date }}

Contact Person :{{ $user->employmentDetails }}, {{ $user->employerName }}, {{ $user->employmentNumber }}

Bank Account: {{ $user->bankAccountNumber }} {{ $user->bank }}

Descriptions; {{ $user->description }}

Account Available Balance(s) :
where('borrower_id',$user->id)->get(); foreach($acc as $row_acc){ $sumcr = DB::table('savingtransactions')->where('debitCredit','credit')->where('account_id',$row_acc->id)->sum('amount'); $sumdr = DB::table('savingtransactions')->where('debitCredit','debit')->where('account_id',$row_acc->id)->sum('amount'); $sum=$sumcr-$sumdr; echo $row_acc->savingAccount.': '.number_format($sum).'
'; } ?>

Loan Balance(s):
where('sstatus','!=','paid')->where('borrower_id',$user->id)->get(); foreach($loans as $loan){ if($loan->status != 'paid'){ ## Finding $principal_paid = DB::table('repaymentschedule')->where('loan_id',$loan->id)->where('borrower_id',$user->id)->sum('principal_paid'); $interest_paid = DB::table('repaymentschedule')->where('loan_id',$loan->id)->where('borrower_id',$user->id)->sum('interest_paid'); $fee_paid = DB::table('repaymentschedule')->where('loan_id',$loan->id)->where('borrower_id',$user->id)->sum('fee_paid'); $sum = $principal_paid + $interest_paid + $fee_paid; echo "Loan# ".$loan->loanNumber.", Due Amount: ".number_format($loan->dueAmount,2); echo ", Paid: ".number_format($sum,2); echo ($loan->status == 'granted') ? ", Active
" : ", ".ucfirst($loan->status)."
"; } } ?>

CUSTOMER PROFILE: {{ strtoupper($user->firstName." ".$user->middleName." ".$user->lastName) }}

photo==NULL){?>

Unique# : {{ $user->uniqueNumber}}
Customer Number:id); echo $number;?>

Date registered : {{ $user->date }}

NationalID	{{ $user->nationalID }}, {{ $user->country}}
Date of Birth	{{ $user->birthday }}, {{ $user->gender}}
Working Status	{{ $user->workStatus}}, Enployment#{{ $user->employmentNumber }}
Bank Account	where('id',$user->bank)->get(); foreach($methods as $method){ echo $user->bankAccountNumber.', '. $method->name.', '.$user->bankBranch; } ?>

Address	{{ $user->address }}
City	{{ $user->city}}
Country	{{ $user->country }}
Phone	{{ $user->phone }}
Email	{{ $user->email }}
Employer Name	employerName==NULL){ echo 'None'; }else{ echo $user->employerName; } ?>
Employer Address	employerAddress==NULL){ echo 'None'; }else{ echo $user->employerAddress; } ?>
Description	description==NULL){ echo 'None'; }else{ echo $user->description; } ?>

Share Accounts:

where('borrower_id',$user->id)->get(); foreach($shares as $share){ $tc = DB::table('shareSettings')->where('id',$share->shareType)->get(); foreach($tc as $t){ $type=$t->shareName; $price=$t->nominalprice; } $c_p = DB::table('shareholders')->where('member_id',$user->id)->where('share_type',$share->shareType)->where('purchase_sell','purchase')->sum('amount'); $c_s = DB::table('shareholders')->where('member_id',$user->id)->where('share_type',$share->shareType)->where('purchase_sell','sell')->sum('amount'); $c_sh=$c_p-$c_s; $s=$c_sh/$price; ?>

Account Number	Account Name	Number of Shares	Price per Share	Amount
account;?>

Savings Accounts:

@php $methods= DB::table('savingaccount')->where('borrower_id',$user->id)->where('branch_id',$user->branch_id)->where('borrowerType','person')->get(); @endphp @foreach($methods as $method) @php $tr='';$dtr=''; $creditledge=App\Http\Controllers\Load::get_savingtransactions_credit($method->id,$method->branch_id); $debitledge= App\Http\Controllers\Load::get_savingtransactions_debit($method->id,$method->branch_id); $lasttr= App\Http\Controllers\Load::get_last_savingtransactions($method->id); foreach($lasttr as $last){ $tr= number_format($last->amount); $dtr= $last->datetime; } foreach($creditledge as $ledger){ $ledgercr= $ledger->amount; } foreach($debitledge as $ledger){ $ledgerdr= $ledger->amount; } $ledger=number_format($ledgercr-$ledgerdr); @endphp @endforeach

Account Number	Account Name	Ledger Balance	Last Transactions
{{$method->savingAccount}}	@php $data = DB::table('savingproduct')->where('id',$method->savingProduct_id)->where('branch_id',$user->branch_id)->get(); foreach($data as $d){ echo $d->name; } @endphp	{{$ledger}}	{{$tr.', '.$dtr}}
Total Contributions:	{{ number_format(($c_sh+$ledgercr-$ledgerdr),2) }}

Loans Balances:

where('status','!=','paid')->where('borrower_id',$user->id)->get(); $paid=0; $balance=$sum=0; foreach($loans as $row){ ?>

Loan Name	Granted	Matuarity	Principal	Interest%	DueFees	Penalty	Due	Paid	Balance
where('id',$row->loanProduct)->get() as $product){ echo $product->loan_product_name; } if($row->status != 'paid'){ ## Finding $principal_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('principal_paid'); $interest_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('interest_paid'); $fee_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('fee_paid'); $sum = $principal_paid + $interest_paid + $fee_paid; } ?>	{{ $row->loanReleaseDate}}	{{ $row->matuarityDate}}	{{ number_format($row->principalAmount,2)}}	{{ number_format($row->loanInterest,2)}}	{{ number_format($row->dueFees,2) }}	{{ number_format($row->penalty,2) }}	{{ number_format($row->dueAmount,2)}}	{{ number_format($sum,2)}}	dueAmount - $sum; echo number_format($balance,2); ?>

Loans Records Print Details

@php $loans = DB::table('loans')->where('status','!=','paid')->where('borrower_id',$user->id)->get(); $paid=0; $balance=0; foreach($loans as $row){ @endphp status != 'paid'){ ## Finding $principal_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('principal_paid'); $interest_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('interest_paid'); $fee_paid = DB::table('repaymentschedule')->where('loan_id',$row->id)->where('borrower_id',$user->id)->sum('fee_paid'); $sum = $principal_paid + $interest_paid + $fee_paid; echo "Loan# ".$row->loanNumber.", Due Amount: ".number_format($row->dueAmount,2); echo ", Paid: ".number_format($sum,2); echo ($row->status == 'granted') ? ", Active
" : ", ".ucfirst($row->status)."
"; } ?> @php } @endphp

Action/Status	Loan product/Number	Granted	Matuarity	Principal	Interest%	DueFees	Penalty	Due	Paid	Balance	LastPayment
	where('id',$row->loanProduct)->get() as $product){ echo '#'.$row->loanNumber." : ".$product->loan_product_name; } ?>	{{ $row->loanReleaseDate}}	{{ $row->matuarityDate}}	{{ number_format($row->principalAmount,2)}}	{{ number_format($row->loanInterest,2)}}	{{ number_format($row->dueFees,2) }}	{{ number_format($row->penalty,2) }}	{{ number_format($row->dueAmount,2)}}	{{ number_format($sum,2)}}	dueAmount - $sum; echo number_format($balance,2); ?>	where('approve_status','approved')->where('loan_id',$row->id)->where('borrower_id',$user->id)->where('loanproduct_id',$row->loanProduct)->orderBy('id','DESC')->limit(1)->get(); foreach($last as $tx){ echo number_format($tx->amount,2)." ".$tx->collectionDate; } ?>

Saving Records Print Details

Account	Product	Ledger Balance	Last Transactions	View
{{$method->savingAccount}}	@php $data = DB::table('savingproduct')->where('id',$method->savingProduct_id)->where('branch_id',$user->branch_id)->get(); foreach($data as $d){ echo $d->name; } @endphp	{{$ledger}}	{{$tr.' '.$dtr}}	View

Account	Type	Shares	Price per Share	Amount
account;?>

@php $files=DB::table('borrower_documents')->where('branch_id',$user->branch_id)->where('borrower_id',$user->id)->get(); foreach($files as $row){ @endphp @php } @endphp

Vie File	Action
Click to view file	Delete