where('branch_id',Session::get('user')['branch_id'])->get(); foreach($acc_pr as $method){ $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); $tr=$dtr='-'; 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); $ledgerb=$ledgercr-$ledgerdr; $name = App\Http\Controllers\Load::get_borrower_id($method->borrower_id,'person'); $balance=$balance+$ledgerb; } echo number_format($balance,2); ?>
Savings
TSH
where('purchase_sell','purchase')->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); $c_s = DB::table('shareholders')->where('purchase_sell','sell')->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); $shares=$c_p-$c_s; echo number_format($shares,2); ?>
Shares
TSH
Total contributions
TSH
Users
where('branch_id',Session::get('user')['branch_id'])->count(); echo number_format($users); ?>
SMS