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_deposits_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='5001'.$randomNumber; $count = DB::table('depositaccount')->where('depositAccount', $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(); $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get(); $products = DB::table('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/add_deposits_accounts')->with('methods',$methods)->with('products',$products)->with('accountNumber',$accountNumber)->with('groups',$groups); } public function insert_deposits_accounts(Request $request) { $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, 'depositProduct_id'=>$request->depositProduct_id, 'depositAccount'=>$request->depositAccount, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('depositaccount')->insert($data); return redirect('/deposits/add_deposits_accounts'); } public function view_deposits_acounts(){ $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('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('depositaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/view_deposits_acounts')->with('methods',$methods)->with('methods1',$methods1)->with('groups',$groups)->with('m',$m); } public function deposits_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('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('depositaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/deposits_reports')->with('methods',$methods)->with('methods1',$methods1)->with('groups',$groups)->with('m',$m); } public function view_deposits_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('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('deposittransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); //$creditledge = DB::table('deposittransactions')->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); $creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('deposittransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); return view('/pages/view_deposits_transactions')->with('methods',$methods)->with('creditledge',$creditledge)->with('debitledge',$debitledge)->with('m',$m)->with('methods1',$methods1)->with('groups',$groups); } public function view_personal_deposits_transactions(){ $id=base64_decode($_REQUEST['id']); $product=base64_decode($_REQUEST['product_id']); $account=base64_decode($_REQUEST['account_id']); $methods = DB::table('deposittransactions')->where('account_id',$account)->where('branch_id',Session::get('user')['branch_id'])->get(); $creditledge=DB::table('deposittransactions')->where('account_id',$account)->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('deposittransactions')->where('account_id',$account)->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); return view('/pages/view_personal_deposits_transactions')->with('methods',$methods)->with('creditledge',$creditledge)->with('debitledge',$debitledge); } public function approve_deposit_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('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('deposittransactions')->where('approve_status',Null)->where('branch_id',Session::get('user')['branch_id'])->get(); //$creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); //$debitledge=DB::table('deposittransactions')->where('debitCredit','debit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); return view('/pages/approve_deposit_transactions')->with('methods',$methods)->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('deposittransactions')->where('id',$id)->update($data); return redirect('/deposits_transactions/approve_deposit_transactions'); } public function add_deposits_transactions(){ $methods = DB::table('borrowers')->where('customerType','!=','Member')->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('depositaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('/pages/add_deposits_transactions')->with('methods',$methods)->with('groups',$groups)->with('m',$m); } public function insert_deposits_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]; $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$borrower_id, 'account_id'=>$account_id, 'amount'=>$request->amount, 'debitCredit'=>$debitCredit, 'type'=>$type, 'type'=>$request->method, 'datetime'=>$datetime, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('deposittransactions')->insert($data); ##daily ledger####### if($request->method=="Cash"){ $ledger_account=17; }else{ $ledger_account=18; } 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, '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'=>31, 'amount'=>$request->amount, 'cr_dr'=>$debitCredit, 'time'=>$datetime, 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledger2); ##daily ledger####### return redirect('/deposits_transactions/add_deposits_transactions'); } public function search_approve_deposit_transactions(Request $request){ $from=$request->from; $to=$request->to; $depositType=$request->depositType; //account Number /* if($request->account_id!='all'){ $methods = DB::table('deposittransactions')->where('account_id',$request->account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $methods = DB::table('deposittransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); if($depositType!='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('account_id',$depositrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } } }*/ //by date... if($from!='' && $to!='' && $depositType!='all' && $request->account_id!='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('account_id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); } }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id!='all'){ $methods = DB::table('deposittransactions')->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!='' && $depositType!='all' && $request->account_id=='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('account_id',$depositrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id=='all'){ $methods = DB::table('deposittransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->get(); } //$creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); //$debitledge=DB::table('deposittransactions')->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,'person'); } if($account->borrowerType=='group'){ $borrower = app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id); } $creditledger = app('App\Http\Controllers\Load')::get_deposittransactions_credit($method->account_id,$method->branch_id); $debitledger = app('App\Http\Controllers\Load')::get_deposittransactions_debit($method->account_id,$method->branch_id); foreach($creditledger as $ledger){ $ledgercr= $ledger->amount; } foreach($debitledger as $ledger){ $ledgerdr= $ledger->amount; } $ledger=$ledgercr-$ledgerdr; ?> debitCredit=='debit'){ $debit=$method->amount; }else{ $credit=$method->amount; } ?>

Name	Account#	Ledger Balance	Date	Type	Debit	Credit	Receipt	Approve
	depositAccount;?>		datetime;?>	type;?>				approve_status=='approved'){ echo 'Approved on '.$method->approved_date; }else{ ?> Approve

from; $to=$request->to; $depositType=$request->depositType; //account Number if($request->account_id!='all'){ $methods = DB::table('deposittransactions')->where('account_id',$request->account_id)->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $methods = DB::table('deposittransactions')->where('branch_id',Session::get('user')['branch_id'])->get(); if($depositType!='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('account_id',$depositrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } } } //by date... if($from!='' && $to!='' && $depositType!='all' && $request->account_id!='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('account_id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); } }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id!='all'){ $methods = DB::table('deposittransactions')->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!='' && $depositType!='all' && $request->account_id=='all'){ $deposit = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($deposit as $depositrow){ $methods = DB::table('deposittransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('account_id',$depositrow->id)->where('branch_id',Session::get('user')['branch_id'])->get(); } }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id=='all'){ $methods = DB::table('deposittransactions')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->get(); } //$creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); //$debitledge=DB::table('deposittransactions')->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,'person'); } if($account->borrowerType=='group'){ $borrower = app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id,'group'); } $creditledger = app('App\Http\Controllers\Load')::get_deposittransactions_credit($method->account_id,$method->branch_id); $debitledger = app('App\Http\Controllers\Load')::get_deposittransactions_debit($method->account_id,$method->branch_id); foreach($creditledger as $ledger){ $ledgercr= $ledger->amount; } foreach($debitledger 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
	depositAccount; ?>		datetime; ?>	type; ?>	description; ?>

from; $to=$request->to; $depositType=$request->depositType; //account Number and by date... if($from!='' && $to!='' && $depositType!='all' && $request->account_id!='all'){ $methods = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id!='all'){ $methods = DB::table('depositaccount')->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!='' && $depositType!='all' &&$request->account_id=='all'){ $methods = DB::table('depositaccount')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); } elseif($from=='' && $to=='' && $depositType!='all' && $request->account_id=='all'){ $methods = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from=='' && $to=='' && $depositType=='all' &&$request->account_id=='all'){ $methods = DB::table('depositaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from!='' && $to!='' && $depositType=='all' &&$request->account_id=='all'){ $methods = DB::table('depositaccount')->where('id',$request->account_id)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); } $creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('deposittransactions')->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_deposittransactions_debit($method->id,$method->branch_id); $lasttr= app('App\Http\Controllers\Load')::get_last_deposittransactions($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
borrowerType=='person'){ echo app('App\Http\Controllers\Load')::get_borrower_id($method->borrower_id,'person'); }else{ echo app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id,'group'); } ?>	depositAccount;?>	borrowerType;?>	depositProduct_id); ?>			View

from; $to=$request->to; $depositType=$request->depositType; //account Number and by date... if($from!='' && $to!='' && $depositType!='all'){ $methods = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('date','>=',$request->from)->where('date','<=',$request->to)->get(); }elseif($from!='' && $to!='' && $depositType=='all'){ $methods = DB::table('depositaccount')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->get(); } elseif($from=='' && $to=='' && $depositType!='all'){ $methods = DB::table('depositaccount')->where('depositProduct_id',$depositType)->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from=='' && $to=='' && $depositType=='all'){ $methods = DB::table('depositaccount')->where('branch_id',Session::get('user')['branch_id'])->get(); } $creditledge=DB::table('deposittransactions')->where('debitCredit','credit')->where('branch_id',Session::get('user')['branch_id'])->select(DB::raw('SUM(amount) as amount'))->get(); $debitledge=DB::table('deposittransactions')->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_deposittransactions_by_type('withdrawal',$method->branch_id,$method->id); $fee=app('App\Http\Controllers\Load')::get_deposittransactions_by_type('fee',$method->branch_id,$method->id); $interest=app('App\Http\Controllers\Load')::get_deposittransactions_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_deposittransactions_credit($method->id,$method->branch_id); $debitledge= app('App\Http\Controllers\Load')::get_deposittransactions_debit($method->id,$method->branch_id); $lasttr= app('App\Http\Controllers\Load')::get_last_deposittransactions($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	Deposits Product	Deposits	Withdraws	Fees	Interests	Ledger Balance	Last Transactions
borrowerType=='person'){ echo app('App\Http\Controllers\Load')::get_borrower_id($method->borrower_id,'person'); }else{ echo app('App\Http\Controllers\Load')::get_borrowergroup_by_id($method->borrower_id,'group'); } ?>	depositAccount;?>	borrowerType;?>	depositProduct_id); ?>
Total