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'); } public function customers_reports(Request $request){ $loans = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->get(); $loansdistinct = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->limit(30)->get(); $users = DB::table('users')->where('branch_id',Session::get('user')['branch_id'])->where('role','collector')->get(); $borrowers = 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(); return View('pages.customers_reports')->with('loans',$loans)->with('loansdistinct',$loansdistinct)->with('users',$users)->with('borrowers',$borrowers)->with('groups',$groups); } public function loan_reports(Request $request){ $loans = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->get(); $loansdistinct = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->limit(30)->get(); $users = DB::table('users')->where('branch_id',Session::get('user')['branch_id'])->where('role','collector')->get(); $borrowers = 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(); return View('pages.loan_reports')->with('loans',$loans)->with('loansdistinct',$loansdistinct)->with('users',$users)->with('borrowers',$borrowers)->with('groups',$groups); } public function search_customer_report(Request $request){ $staffs = $request->staffs; $borrower = $request->borrower; $from = $request->from; $to = $request->to; $result=array(); if($staffs == 'all' && $borrower == 'all'){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); }else if($staffs > 0 && $borrower == 'all'){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('collector',$staffs)->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); }else if($staffs > 0 && $borrower > 0){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->where('collector',$staffs)->select('borrower_id','borrowerType')->distinct()->get(); }else if($staffs == 'all' && $borrower > 0){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); } if($from = "" && $to == ""){ if($staffs == 'all' && $borrower > 0){ $result = DB::table('loans')->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); } elseif($borrower == 'all' && $staffs > 0){ $result = DB::table('loans')->where('collector',$borrower)->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); }else{ $result = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->get(); } } ?> borrower_id,$loanb->borrowerType); ?> principalAmount; $d=$d+$due; $pn=$pn+$penalty; $pd=$pd+$paid; ?>

Loan#	Released	Matuarity	Principal	Interest%	Due	Penalty	Paid	Balance	LastPayment
borrower_id).' '; if($loanb->borrowerType=='person'){ echo app('App\Http\Controllers\Load')::get_borrowerUniqueNumber($loanb->borrower_id); }else{ echo app('App\Http\Controllers\Load')::get_groupUniqueNumber($loanb->borrower_id); } ?>
loanNumber;?>	loanReleaseDate;?>	matuarityDate; ?>	principalAmount,2); ?>	loanInterest."%" ;?>	id,$loan->borrower_id); echo number_format($due); ?>	id,$loan->borrower_id); echo number_format($penalty,2); ?>	id,$loan->borrower_id); echo number_format($paid,2); ?>		id,$loan->borrower_id); echo $last; ?>
Total

where('branch_id',Session::get('user')['branch_id'])->get(); $loansdistinct = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('borrower_id','borrowerType')->distinct()->limit(30)->get(); $users = DB::table('users')->where('branch_id',Session::get('user')['branch_id'])->where('role','collector')->get(); $borrowers = 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(); return View('pages.disbursement_reports')->with('loans',$loans)->with('loansdistinct',$loansdistinct)->with('users',$users)->with('borrowers',$borrowers)->with('groups',$groups); } public function search_disbursement_reports(Request $request){ $staffs = $request->staffs; $borrower = $request->borrower; $from = $request->from; $to = $request->to; $result=array(); if($staffs == 'all' && $borrower == 'all'){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('branch_id',Session::get('user')['branch_id'])->get(); }else if($staffs > 0 && $borrower == 'all'){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('collector',$staffs)->where('branch_id',Session::get('user')['branch_id'])->get(); }else if($staffs > 0 && $borrower > 0){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->where('collector',$staffs)->get(); }else if($staffs == 'all' && $borrower > 0){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->get(); } if($from = "" && $to == ""){ if($staffs == 'all' && $borrower > 0){ $result = DB::table('loans')->where('borrower_id',$borrower)->where('branch_id',Session::get('user')['branch_id'])->get(); } elseif($borrower == 'all' && $staffs > 0){ $result = DB::table('loans')->where('collector',$borrower)->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $result = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->get(); } } ?> borrower_id,$loanb->borrowerType); $p=$pd=$d=$pn=$b=0; foreach($result as $loan){ ?> id,$loan->borrower_id); $paid = app("App\Http\Controllers\Load")::get_borrower_paid_amount($loan->id,$loan->borrower_id); ?>

Customer	Loan#	Disbursed Date	Matuarity	Disbursed Amount	Interest%	Duration	Outstanding
borrower_id,$loan->borrowerType).' '; if($loan->borrowerType=='person'){ echo app("App\Http\Controllers\Load")::get_borrowerUniqueNumber($loan->borrower_id); }else{ echo app("App\Http\Controllers\Load")::get_groupUniqueNumber($loan->borrower_id); } ?>	loanNumber;?>	loanReleaseDate;?>	matuarityDate ;?>	principalAmount,2) ;?>	loanInterest."%" ;?>	loanDuration." ".$loan->durationType ;?>

where('branch_id',Session::get('user')['branch_id'])->get(); $loansdistinct = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('loanProduct')->distinct()->limit(30)->get(); $users = DB::table('users')->where('branch_id',Session::get('user')['branch_id'])->where('role','collector')->get(); $borrowers = 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(); return View('pages.loan_products_report')->with('loans',$loans)->with('loansdistinct',$loansdistinct)->with('users',$users)->with('borrowers',$borrowers)->with('groups',$groups); } public function search_loan_products_report(Request $request){ $from = $request->from; $to = $request->to; $result=array(); if($from == "" && $to == ""){ $result = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->get(); }elseif($from != "" && $to == ""){ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $result = DB::table('loans')->where('loanReleaseDate','>=',$from)->where('loanReleaseDate','<=',$to)->where('branch_id',Session::get('user')['branch_id'])->get(); } $loansdistinct = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->select('loanProduct')->distinct()->limit(30)->get(); ?> loanProduct,$from,$to); ?> id,$loan->borrower_id); $penalty = app("App\Http\Controllers\Load")::get_borrower_penalty_amount($loan->id,$loan->borrower_id); $paid = app("App\Http\Controllers\Load")::get_borrower_paid_amount_range2($loan->id,$loan->borrower_id,$loan->loanProduct); $last = app("App\Http\Controllers\Load")::get_loanproduct_last_repayment($loan->loanProduct); $p=$p+$loan->principalAmount; $d=$d+$due; $pn=$pn+$penalty; $pd=$pd+$paid; } ?>

Loan Product			Principal	Due	Penalty	Paid	Balance	LastPayment
loanProduct) as $loanProduct){ echo $loanProduct->loan_product_name; } ?>
Total