Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 88

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 215

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 216

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 217

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 218

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 219

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 220
middleware('auth'); } /** * Show the application dashboard. * * @return \Illuminate\Contracts\Support\Renderable */ #################################################SAMPLE CODES ################################################################################### public function income_types(){ $methods = DB::table('incometypes')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/income_types')->with('methods',$methods); } public function add_income_types(Request $request) { $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'name'=>$request->incometypes, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('incometypes')->insert($data); return redirect('/settings/income_types'); } public function loan_products(){ $fees = DB::table('fee')->where('branch_id',Session::get('user')['branch_id'])->get(); $interest = DB::table('loaninterestmethods')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('transactiontype')->where('branch_id',Session::get('user')['branch_id'])->get(); $loanproducts = DB::table('loanproducts')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/loan_products')->with('methods',$methods)->with('interests',$interest)->with('fees',$fees)->with('loanproducts',$loanproducts); } ######################################################################SAMPLE CODES#################################################################################### public function add_savings_accounts(){ //get account Number function generateRandomNumber($length = 9) { $number = '1234567890'; $numberLength = strlen($number); $randomNumber = ''; for ($i = 0; $i < $length; $i++) { $randomNumber .= $number[rand(0, $numberLength - 1)]; } $randomNumber='8001'.$randomNumber; $count = DB::table('savingaccount')->where('savingAccount', $randomNumber)->get()->count(); if($count>0){ generateRandomNumber(); }else{ return $randomNumber; } } $accountNumber = generateRandomNumber(); $methods = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods1 = DB::table('borrowers')->where('customerType','Client')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods2 = DB::table('borrowers')->where('customerType','Company')->where('branch_id',Session::get('user')['branch_id'])->get(); $products = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->orderby('id','DESC')->get(); return view('/pages/add_savings_accounts')->with('methods',$methods)->with('methods1',$methods1)->with('methods2',$methods2)->with('products',$products)->with('accountNumber',$accountNumber); } public function get_open_account_fee(Request $request){ $id=$request->id; $pf = DB::table('savingproductfees')->where('savingproduct_id',$id)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($pf as $sf){ $m = DB::table('savingfee1')->where('id',$sf->savingfee_id)->where('type','opening')->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($m as $f){ ?>
0, ); DB::table('savingaccount')->where('id',$request->id)->update($data); return redirect('/savings/view_savings_acounts'); } public function close_saving_account(Request $request){ $fee=$request->feeAmount; $data = array( 'status'=>1, 'close_fee'=>$fee, 'closed_by'=>Auth::id(), 'closed_date'=>date('Y-m-d'), ); DB::table('savingaccount')->where('id',$request->id)->update($data); ##daily ledger####### /* if($request->method==3){ $ledger_account=17; }else{ $ledger_account=18; } $datetime=date('H:i:s'); $ledger1 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_account, 'amount'=>$fee, 'cr_dr'=>'debit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger1); $ledger2 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>49, 'amount'=>$fee, 'cr_dr'=>'credit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger2);*/ ##daily ledger####### return redirect('/savings/view_savings_acounts'); } public function insert_savings_accounts(Request $request) { if(isset($request->feeAmount)){ $fee=$request->feeAmount; $method=$request->method; }else{ $fee=0; $method=0; } $borrower=explode('/',$request->borrower_id); $borrower_id=(int)$borrower[0]; $borrowerType=$borrower[1]; $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$borrower_id, 'borrowerType'=>$borrowerType, 'savingProduct_id'=>$request->savingProduct_id, 'savingAccount'=>$request->savingAccount, 'fee'=>$fee, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('savingaccount')->insert($data); ##daily ledger /*if($fee>0){ if($method==3){ $ledger_account=17; }else{ $ledger_account=18; } $datetime=date('H:i:s'); $ledger1 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_account, 'amount'=>$fee, 'cr_dr'=>'debit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); $ledger2 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>49, 'amount'=>$fee, 'cr_dr'=>'credit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger1); DB::table('daily_ledger')->insert($ledger2); }*/ ##daily ledger####### return redirect('/savings/add_savings_accounts?added'); } public function delete_savings_account(Request $request){ $id=base64_decode($request->account_id); $methods = DB::table('savingaccount')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete(); return redirect('savings/view_savings_acounts?del'); } public function delete_savings_transactions(Request $request){ $id=base64_decode($request->id); $batch_id=base64_decode($request->batch); DB::table('savingtransactions')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete(); //delete transaction from daily ledger and update general ledger... DB::table('daily_ledger')->where('ledger_source_id',$id)->where('batch_id',$batch_id)->where('branch_id',Session::get('user')['branch_id'])->delete(); #update ledger itakuja hapa... return redirect('savings_transactions/view_savings_transactions?del'); } public function delete_savings_transactions_batch(Request $request){ $batch_id=base64_decode($request->batch); DB::table('savingtransactions')->where('batch',$batch_id)->where('branch_id',Session::get('user')['branch_id'])->delete(); //delete transaction from daily ledger and update general ledger... DB::table('daily_ledger')->where('batch_id',$batch_id)->where('branch_id',Session::get('user')['branch_id'])->delete(); #update ledger itakuja hapa... return redirect('savings_transactions/upload_excel_savings?del'); } public function view_savings_acounts(){ $methods1 = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('savingaccount AS a')->where('a.branch_id',Session::get('user')['branch_id']) ->leftJoin('borrowers AS b', function($join){ $join->on('a.borrower_id', '=', 'b.id'); }) ->select('a.*','b.firstName', 'b.middleName', 'b.lastName') ->orderBy('b.firstName', 'ASC') ->orderBy('b.middleName', 'ASC') ->orderBy('b.lastName', 'ASC') ->get(); return view('/pages/view_savings_acounts')->with('methods',$methods)->with('methods1',$methods1)->with('m',$m); } public function print_view_savings_acounts(){ $methods1 = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/print_view_savings_acounts')->with('methods',$methods)->with('methods1',$methods1)->with('m',$m); } public function savings_reports(){ $methods1 = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/savings_reports')->with('methods',$methods)->with('methods1',$methods1)->with('groups',$groups)->with('m',$m); } public function view_savings_transactions(){ $methods1 = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('savingtransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); //$creditledge = DB::table('savingtransactions')->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); return view('/pages/view_savings_transactions')->with('methods',$methods)->with('m',$m)->with('methods1',$methods1); } public function view_savings_single(){ $id=base64_decode($_REQUEST['id']); $methods = DB::table('savingtransactions')->where('account_id',$id)->where('branch_id',Session::get('user')['branch_id'])->get(); $creditledge=DB::table('savingtransactions')->where('account_id',$id)->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('savingtransactions')->where('account_id',$id)->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); return view('/pages/view_savings_single')->with('methods',$methods)->with('creditledge',$creditledge)->with('debitledge',$debitledge); } public function approve_transactions(){ $methods1 = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('savingtransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); $creditledge=DB::table('savingtransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('savingtransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); return view('/pages/approve_transactions')->with('methods',$methods)->with('creditledge',$creditledge)->with('debitledge',$debitledge)->with('m',$m)->with('methods1',$methods1)->with('groups',$groups); } public function approve_transactions_post(Request $request){ $id = $request->id; $data = array( 'approve_status'=>'approved', 'approved_by'=>Auth::id(), 'approved_date'=>date('Y-m-d') ); DB::table('savingtransactions')->where('id',$id)->update($data); foreach(DB::table('savingtransactions')->where('id',$id)->get() as $repay){ /// SMS START HERE ############################################################# // creating array for post data $debitCredit=$repay->debitCredit == 'credit' ? "credited":"debited"; $batch = time()."-".rand()."-".uniqid(); foreach(DB::table('borrowers')->where('id',$repay->borrower_id)->where('branch_id',Session::get('user')['branch_id'])->get() as $user){ $sms = 'Dear '.$user->firstName.", your account has been ".$debitCredit." TSH ".number_format($repay->amount).". For more details visit https://aloan.co.tz"; $data =array( 'branch_id'=>Session::get('user')['branch_id'], 'sent_id'=>$repay->borrower_id, 'type'=>'customer', 'mobile'=>"255".substr(preg_replace('/\D/', '', $user->phone),-9), 'sms'=>$sms, 'batch'=>$batch, ); DB::table('sms_sent')->insert($data); $send = app('App\Http\Controllers\Load')->send_sms($batch,Session::get('user')['branch_id']); } } return redirect('/savings_transactions/approve_transactions'); } public function upload_excel_savings(){ $methods = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods1 = DB::table('borrowers')->where('customerType','Client')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods2 = DB::table('borrowers')->where('customerType','Company')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/upload_excel_savings')->with('methods',$methods)->with('methods1',$methods1)->with('methods2',$methods2)->with('m',$m); } public function add_savings_transactions(){ $methods = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods1 = DB::table('borrowers')->where('customerType','Client')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods2 = DB::table('borrowers')->where('customerType','Company')->where('branch_id',Session::get('user')['branch_id'])->get(); $m = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/add_savings_transactions')->with('methods',$methods)->with('methods1',$methods1)->with('methods2',$methods2)->with('m',$m); } public function insert_savings_transactions(Request $request) { $datetime=$request->date.' '.date("H:i", strtotime($request->time)); $deb=explode('/',$request->type); $type=$deb[0]; $debitCredit=$deb[1]; //get borrower and account $acc=explode('/',$request->account_id); $account_id=$acc[0]; $borrower_id=$acc[1]; $fee=$request->feeAmount; //get product_id $p = DB::table('savingaccount')->where('id',$account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($p as $pr){ $product=$pr->savingProduct_id; } //generate batch id $batch_id = 'SV-'.rand().'-'.time(); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$borrower_id, 'account_id'=>$account_id, 'amount'=>$request->amount, 'debitCredit'=>$debitCredit, 'type'=>$type, 'datetime'=>$datetime, 'description'=>$request->description, 'batch'=>$batch_id, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('savingtransactions')->insert($data); $source_id=DB::getPdo()->lastInsertId(); ##daily ledger####### $ledger_account_fetch = DB::table('savingproduct')->where('savingproduct.id',$product) ->join('ledger_accounts','savingproduct.ledger_id','=','ledger_accounts.id')->get(); foreach($ledger_account_fetch as $ss){ $ledger_product_id = $ss->ledger_id; $ledger_account = $ss->bank; } $method = $request->method; if($method==3){ foreach(DB::table('ledger_accounts')->where('visible','cash')->where('branch_id',Session::get('user')['branch_id'])->get() as $cash){ $ledger_account=$cash->id; } } if($debitCredit=='credit'){ $ledger_crdr='debit'; }else{ $ledger_crdr='credit'; } $ledger1 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_account, 'amount'=>$request->amount, 'batch_id'=>$batch_id, 'ledger_source_id'=>$source_id, 'cr_dr'=>$ledger_crdr, 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger1); $ledger2 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_product_id, 'amount'=>$request->amount, 'batch_id'=>$batch_id, 'ledger_source_id'=>$source_id, 'cr_dr'=>$debitCredit, 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger2); if($type=="withdrawal"){ ##daily ledger for withdrawal fee####### //check percent or amount... $a=0; if(is_numeric($fee)){ $a=$fee; }else{ $a=(float)(str_replace('%','',$fee)); $a=(($a/100)*$request->amount); } #insert fee transaction $datafee = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$borrower_id, 'account_id'=>$account_id, 'amount'=>$a, 'batch_id'=>$batch_id, 'ledger_source_id'=>$source_id, 'debitCredit'=>'debit', 'type'=>'Withdrawal fee', 'datetime'=>$datetime, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('savingtransactions')->insert($datafee); #end fee... #withdrawal fee... //get fee product id... foreach(DB::table('savingfee1')->where('type','withdrawal')->get() as $pr){ $savingfeeproduct=$pr->id; } $saving_product=$ledger_product_id; $ledger_account_fetch = DB::table('savingfee1')->where('savingfee1.id',$savingfeeproduct) ->join('ledger_accounts','savingfee1.ledger_id','=','ledger_accounts.id')->get(); foreach($ledger_account_fetch as $ss){ $ledger_product_id = $ss->ledger_id; $ledger_account = $ss->bank; } $method = 4; if($method==3){ foreach(DB::table('ledger_accounts')->where('visible','cash')->get() as $cash){ $ledger_account=$cash->id; } } $datetime=date('H:i:s'); $ledger1 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$saving_product, 'amount'=>$a, 'batch_id'=>$batch_id, 'ledger_source_id'=>$source_id, 'cr_dr'=>'debit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger1); $ledger2 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_product_id, 'amount'=>$a, 'batch_id'=>$batch_id, 'ledger_source_id'=>$source_id, 'cr_dr'=>'credit', 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger2); } ##daily ledger####### return redirect('/savings_transactions/add_savings_transactions'); } public function search_saving_transactions(Request $request){ $from=$request->from; $to=$request->to; $savingType=$request->savingType; //account Number if($request->account_id!='all'){ $methods = DB::table('savingtransactions')->where('account_id',$request->account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $methods = DB::table('savingtransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); if($savingType!='all'){ $saving = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($saving as $savingrow){ $methods = DB::table('savingtransactions')->where('account_id',$savingrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } } } //by date... if($from!='' && $to!='' && $savingType!='all' && $request->account_id!='all'){ $saving = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($saving as $savingrow){ $methods = DB::table('savingtransactions')->where('account_id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); } }elseif($from!='' && $to!='' && $savingType=='all' &&$request->account_id!='all'){ $methods = DB::table('savingtransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('account_id',$request->account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from!='' && $to!='' && $savingType!='all' && $request->account_id=='all'){ $saving = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($saving as $savingrow){ $methods = DB::table('savingtransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('account_id',$savingrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } }elseif($from!='' && $to!='' && $savingType=='all' &&$request->account_id=='all'){ $methods = DB::table('savingtransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->get(); } $creditledge=DB::table('savingtransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('savingtransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); ?> account_id); foreach($accounts as $account){ $borrower=''; if($account->borrowerType=='person'){ $borrower = app('App\Http\Controllers\Load')::get_borrower_id($method->borrower_id); } if($account->borrowerType=='group'){ $borrower = app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id); } foreach($creditledge as $ledger){ $ledgercr= $ledger->amount; } foreach($debitledge as $ledger){ $ledgerdr= $ledger->amount; } $ledger=$ledgercr-$ledgerdr; ?> debitCredit=='debit'){ $debit=$method->amount; }else{ $credit=$method->amount; } ?>
Name Account# Ledger Balance Date Type Descriptions Debit Credit Receipt Action
savingAccount; ?> datetime; ?> type; ?> description; ?>
from; $to=$request->to; $savingType=$request->savingType; //account Number and by date... if($from!='' && $to!='' && $savingType!='all' && $request->account_id!='all'){ $methods = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); }elseif($from!='' && $to!='' && $savingType=='all' &&$request->account_id!='all'){ $methods = DB::table('savingaccount')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('id',$request->account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from!='' && $to!='' && $savingType!='all' &&$request->account_id=='all'){ $methods = DB::table('savingaccount')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); } elseif($from=='' && $to=='' && $savingType!='all' && $request->account_id=='all'){ $methods = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from=='' && $to=='' && $savingType=='all' &&$request->account_id=='all'){ $methods = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from!='' && $to!='' && $savingType=='all' &&$request->account_id=='all'){ $methods = DB::table('savingaccount')->where('id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); } $creditledge=DB::table('savingtransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('savingtransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); ?> id,$method->branch_id); $debitledge= app('App\Http\Controllers\Load')::get_savingtransactions_debit($method->id,$method->branch_id); $lasttr= app('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); ?>
Name Account Group/person Product Ledger Balance Last Transactions View
borrower_id,'person'); ?> savingAccount;?> borrowerType;?> savingProduct_id); ?> View
from; $to=$request->to; $savingType=$request->savingType; //account Number and by date... if($from!='' && $to!='' && $savingType!='all'){ $methods = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); }elseif($from!='' && $to!='' && $savingType=='all'){ $methods = DB::table('savingaccount')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->get(); } elseif($from=='' && $to=='' && $savingType!='all'){ $methods = DB::table('savingaccount')->where('savingProduct_id',$savingType)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from=='' && $to=='' && $savingType=='all'){ $methods = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); } $creditledge=DB::table('savingtransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('savingtransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); ?> branch_id,$method->id); $withdrawal=app('App\Http\Controllers\Load')::get_savingtransactions_by_type('withdrawal',$method->branch_id,$method->id); $fee=app('App\Http\Controllers\Load')::get_savingtransactions_by_type('fee',$method->branch_id,$method->id); $interest=app('App\Http\Controllers\Load')::get_savingtransactions_by_type('interest',$method->branch_id,$method->id); $d=$deposit+$d; $w=$withdrawal+$w; $f=$fee+$f; $i=$interest+$i; $tr=$dtr=''; $ledger=0; $creditledge=app('App\Http\Controllers\Load')::get_savingtransactions_credit($method->id,$method->branch_id); $debitledge= app('App\Http\Controllers\Load')::get_savingtransactions_debit($method->id,$method->branch_id); $lasttr= app('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=$ledgercr-$ledgerdr; $l=$ledger+$l; $ledger=number_format($ledgercr-$ledgerdr); ?>
Client Account # Group/person Savings Product Deposits Withdraws Fees Interests Ledger Balance Last Transactions
borrowerType=='person'){ echo app('App\Http\Controllers\Load')::get_borrower_id($method->borrower_id); }else{ echo app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id); } ?> savingAccount;?> borrowerType;?> savingProduct_id); ?>
Total