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 */ public static function get_staff_with_id($id){ return DB::table('users')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->get(); } public static function get_borrower_with_id($id){ return DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->get(); } public static function get_group_members($id){ return DB::table('borrowergroupmembers')->where('borrowergroup_id',$id)->where('branch_id',Session::get('user')['branch_id'])->get(); } public function add_borrowers(Request $request) { $photo = NULL; if(isset($_FILES['photo']) && !empty($_FILES['photo']['name'])) { $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data =array( 'branch_id'=>Session::get('user')['branch_id'], 'firstName'=>ucfirst(strtoupper($request->firstName)), 'middleName'=>ucfirst(strtoupper($request->middleName)), 'lastName'=>ucfirst(strtoupper($request->lastName)), 'uniqueNumber'=>$request->uniqueNumber, 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, 'employerName'=>$request->employerName, 'employerAddress'=>$request->employerAddress, 'businessName'=>$request->businessName, 'bankBranch'=>$request->bankBranch, 'nationalID'=>$request->nationalID, 'workStation'=>$request->workStation, 'employmentNumber'=>$request->employmentNumber, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, 'gender'=>$request->gender, 'address'=>$request->address, 'city'=>$request->city, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); DB::table('borrowers')->insert($data); $boorowerID = DB::getPdo()->lastInsertId(); foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } if($request->customerType=='Member'){ $methods2 = DB::table('registration_fee_settings')->where('branch_id',Session::get('user')['branch_id'])->orderBy('id','desc')->limit(1)->get(); foreach($methods2 as $row2){ $lg = $row2->ledger_id; } $registration_fee = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'ledger_id'=>$lg, 'amount'=>$request->registrationFee, 'date'=>date('Y-m-d'), ); DB::table('registration_fee')->insert($registration_fee); } return redirect('/customers/add_customers?sent'); } public function edit_borrowers(Request $request) { $photo1=$request->photo; // echo $photo1;exit; $file=$_FILES["file"]["name"]; // print_r($file);exit; $id =$request->id; $photo = NULL; if(isset($_FILES['photo']) && !empty($_FILES['photo']['name'])) { $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data =array( 'firstName'=>ucfirst(strtoupper($request->firstName)), 'middleName'=>ucfirst(strtoupper($request->middleName)), 'lastName'=>ucfirst(strtoupper($request->lastName)), 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, 'employerName'=>$request->employerName, 'employerAddress'=>$request->employerAddress, 'businessName'=>$request->businessName, 'bankBranch'=>$request->bankBranch, 'nationalID'=>$request->nationalID, 'workStation'=>$request->workStation, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, 'gender'=>$request->gender, 'address'=>$request->address, 'city'=>$request->city, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); $data1 =array( 'firstName'=>ucfirst(strtoupper($request->firstName)), 'middleName'=>ucfirst(strtoupper($request->middleName)), 'lastName'=>ucfirst(strtoupper($request->lastName)), 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, 'employerName'=>$request->employerName, 'employerAddress'=>$request->employerAddress, 'businessName'=>$request->businessName, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, 'gender'=>$request->gender, 'address'=>$request->address, 'city'=>$request->city, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); if(empty($photo1)){ DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); }else{ DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data1); } $boorowerID = $id; if (empty($file[0])){ // exit; } else{ foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } } return redirect('/customers/edit_customer?id='.base64_encode($id).'&edited=1'); } public function edit_company_insert(Request $request) { $photo1=$request->photo; // echo $photo1;exit; $file=$_FILES["file"]["name"]; // print_r($file);exit; $photo = ""; $id =$request->id; if(isset($_FILES['photo'])){ $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data =array( 'firstName'=>ucfirst(strtoupper($request->firstName)), 'middleName'=>ucfirst(strtoupper($request->middleName)), 'lastName'=>ucfirst(strtoupper($request->lastName)), 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, 'employerName'=>$request->employerName, 'employerAddress'=>$request->employerAddress, 'businessName'=>$request->businessName, 'bankBranch'=>$request->bankBranch, 'nationalID'=>$request->nationalID, 'workStation'=>$request->workStation, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, 'gender'=>$request->gender, 'address'=>$request->address, 'region'=>$request->region, 'district'=>$request->district, 'city'=>$request->city, //town 'street'=>$request->street, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); $data1 =array( 'firstName'=>ucfirst(strtoupper($request->firstName)), 'middleName'=>ucfirst(strtoupper($request->middleName)), 'lastName'=>ucfirst(strtoupper($request->lastName)), 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, 'employerName'=>$request->employerName, 'employerAddress'=>$request->employerAddress, 'businessName'=>$request->businessName, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, 'gender'=>$request->gender, 'address'=>$request->address, 'region'=>$request->region, 'district'=>$request->district, 'city'=>$request->city, //town 'street'=>$request->street, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); if(empty($photo1)){ DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); }else{ DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data1); } $boorowerID = $id; if (empty($file[0])){ // exit; } else{ foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } } return redirect('/customers/edit_company?id='.base64_encode($id).'&edited=1'); } public function add_companies_insert(Request $request) { $photo = NULL; if(isset($_FILES['photo']) && !empty($_FILES['photo']['name'])) { $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data =array( 'branch_id'=>Session::get('user')['branch_id'], 'firstName'=>ucfirst(strtoupper($request->firstName)), //company name 'middleName'=>ucfirst(strtoupper($request->middleName)), //acronym 'lastName'=>ucfirst(strtoupper($request->lastName)), //registration authority 'uniqueNumber'=>$request->uniqueNumber, 'customerType'=>$request->customerType, 'employmentDetails'=>$request->employmentDetails, //contact person titloe 'employerName'=>$request->employerName, //contact person name 'employerAddress'=>$request->employerAddress, //contact person address 'businessName'=>$request->businessName, 'bankBranch'=>$request->bankBranch, 'nationalID'=>$request->nationalID, 'workStation'=>$request->workStation, 'employmentNumber'=>$request->employmentNumber, 'phone'=>$request->mobile, 'email'=>$request->email, 'title'=>$request->title, 'birthday'=>$request->birthday, //registered date 'gender'=>$request->gender, 'address'=>$request->address, 'region'=>$request->region, 'district'=>$request->district, 'city'=>$request->city, //town 'street'=>$request->street, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'country'=>$request->country, 'workStatus'=>$request->workingStatus, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), 'status'=>1, ); DB::table('borrowers')->insert($data); $boorowerID = DB::getPdo()->lastInsertId(); foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } if($request->customerType=='Member'){ $registration_fee = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$boorowerID, 'amount'=>$request->registrationFee, 'date'=>date('Y-m-d'), ); DB::table('registration_fee')->insert($registration_fee); #check payment methods if($request->method==3){ $ledger_account=17; }else{ $ledger_account=18; } $ledgerregfee1= array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>41, 'amount'=>$request->registrationFee, 'cr_dr'=>'credit', 'time'=>date('H:i:s'), 'date'=>date('Y-m-d'), ); $ledgerregfee2 = array( 'branch_id'=>Session::get('user')['branch_id'], 'ledger_account_id'=>$ledger_account, 'amount'=>$request->registrationFee, 'cr_dr'=>'debit', 'time'=>date('H:i:s'), 'date'=>date('Y-m-d'), ); DB::table('daily_ledger')->insert($ledgerregfee1); DB::table('daily_ledger')->insert($ledgerregfee2); } return redirect('/customers/add_companies?sent'); } public function edit_group_insert(Request $request){ $id=$request->id; $photo = NULL; if(isset($_FILES['photo']) && !empty($_FILES['photo']['name'])) { $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'groupName'=>$request->groupName, 'uniqueNumber'=>$request->uniqueNumber, 'collector'=>$request->collector, 'leader'=>$request->leader, 'officerIncharge'=>$request->officerIncharge, 'meetingSchedule'=>$request->meetingSchedule, 'meetingDay'=>$request->meetingDay, 'birthday'=>$request->birthday, //registered date 'phone'=>$request->mobile, 'email'=>$request->email, 'address'=>$request->address, 'region'=>$request->region, 'district'=>$request->district, 'city'=>$request->city, //town 'street'=>$request->street, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'bankBranch'=>$request->bankBranch, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'status'=>1, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrowergroups')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); /* $id = DB::getPdo()->lastInsertId(); $borrowers = $request->borrowers; foreach($borrowers as $coll){ $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$coll, 'borrowergroup_id'=>$id, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrowergroupmembers')->insert($data); } DB::table('borrowergroups')->insert($data); $boorowerID = DB::getPdo()->lastInsertId(); foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'group_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } */ return redirect('/customers/edit_group?id='.base64_encode($id).'&&edited=1'); } public function delete_file(Request $request){ $file = $request->file; $file = 'public/assets/'.str_replace('./','',$file); $borrower = $request->user; DB::table('borrower_documents')->where('file',$request->file)->where('borrower_id',$borrower)->delete(); if(file_exists($file)){ unlink($file); } return redirect($_SERVER['HTTP_REFERER']); } public function view_borrower(Request $request){ $id = base64_decode($request->id); $borrowers = DB::table('borrowers')->where('id',$id)->get(); $loans = DB::table('loans')->where('borrower_id',$id)->get(); $savings = DB::table('savingaccount')->where('borrower_id',$id)->get(); return view('pages.view_borrower')->with('borrower',$borrowers)->with('loans',$loans)->with('savings',$savings); } public function view_member(Request $request){ $id = base64_decode($request->id); $borrowers = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->where('id',$id)->get(); $loans = DB::table('loans')->where('branch_id',Session::get('user')['branch_id'])->where('borrower_id',$id)->get(); $savings = DB::table('savingaccount')->where('branch_id',Session::get('user')['branch_id'])->where('borrower_id',$id)->get(); return view('pages.view_member')->with('borrower',$borrowers)->with('loans',$loans)->with('savings',$savings); } public function edit_customer(Request $request){ $id = base64_decode($request->id); $borrower = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->where('id',$id)->get(); $loans = DB::table('loans')->where('borrower_id',$id)->get(); $savings = DB::table('savingaccount')->where('borrower_id',$id)->get(); return view('pages.edit_customer')->with('borrower',$borrower)->with('loans',$loans)->with('savings',$savings); } public function edit_company(Request $request){ $id = base64_decode($request->id); $borrower = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->where('id',$id)->get(); $loans = DB::table('loans')->where('borrower_id',$id)->get(); $savings = DB::table('savingaccount')->where('borrower_id',$id)->get(); return view('pages.edit_company')->with('borrower',$borrower)->with('loans',$loans)->with('savings',$savings); } public function disable_customer(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>0, ); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_customers?disabled'); } public function disable_company(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>0, ); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_companies?disabled'); } public function undisable_customer(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>1, ); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_customers?undisabled'); } public function delete_customer(Request $request){ $id = base64_decode($request->id); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete(); return redirect('/customers/view_customers?deleted'); } public function delete_group(Request $request){ $id = base64_decode($request->id); DB::table('borrowergroups')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete(); return redirect('/customers/view_customers_groups?deleted'); } public function delete_company(Request $request){ $id = base64_decode($request->id); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete(); return redirect('/customers/view_companies?deleted'); } public function undisable_company(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>1, ); DB::table('borrowers')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_companies?undisabled'); } public function undisable_customer_group(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>1, ); DB::table('borrowergroups')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_customers_groups?undisabled'); } public function disable_customer_group(Request $request){ $id = base64_decode($request->id); $data = array( 'status'=>0, ); DB::table('borrowergroups')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data); return redirect('/customers/view_customers_groups?disabled'); } public function borrowers(Request $request){ $borrowers = DB::table('borrowers')->where('customerType','Member')->where('status',1)->where('branch_id',Session::get('user')['branch_id'])->get(); $borrowers1 = DB::table('borrowers')->where('customerType','Client')->where('status',1)->where('branch_id',Session::get('user')['branch_id'])->get(); $borrowers3 = DB::table('borrowers')->where('customerType', 'not like','Company')->where('status',0)->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.view_borrowers')->with('borrowers',$borrowers)->with('borrowers1',$borrowers1)->with('borrowers3',$borrowers3); } public function view_companies(Request $request){ $borrowers2 = DB::table('borrowers')->where('customerType','Company')->where('status',1)->where('branch_id',Session::get('user')['branch_id'])->get(); $borrowers3 = DB::table('borrowers')->where('customerType','Company')->where('status',0)->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.view_companies')->with('borrowers2',$borrowers2)->with('borrowers3',$borrowers3); } public function print_borrowers(Request $request){ $date1=base64_decode($_REQUEST['d1']); $date2=base64_decode($_REQUEST['d2']); if($date1==$date2 && $date1=='all'){ $borrowers = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); }else{ $borrowers = DB::table('borrowers')->where('date','>=',$date1)->where('date','<=',$date2)->where('branch_id',Session::get('user')['branch_id'])->get(); } return view('pages.print_borrowers')->with('borrowers',$borrowers); } public function search_borrower_group(Request $request){ $status=$request->status; $status_name=''; if($status=='Active'){ $borrowers = DB::table('borrowergroups')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->where('status',1)->get(); $status_name = $title = "list of Customer Groups"; }else{ $borrowers = DB::table('borrowergroups')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('branch_id',Session::get('user')['branch_id'])->where('status',0)->get(); $status_name = $title = "List of Disabled Customer Groups"; } ?>

Print Details

from .' to '.$request->to?>

Group Name	Unique Number	Group Leader	Collector	Members	Status/Action
groupName ?>	uniqueNumber ?>	get_borrower_with_id($group->leader); foreach($data as $d){ echo $d->title." ".$d->firstName." ".$d->middleName." ".$d->lastName; } ?>	get_staff_with_id($group->collector); foreach($data as $d){ echo $d->name; } ?>	get_group_members($group->id)); ?>	status==1){ echo 'Active'; }else{ echo 'Passive'; } ?>

status; $status_name=''; if($status=='Active'){ $borrowers = DB::table('borrowers')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('customerType',$request->customerType)->where('branch_id',Session::get('user')['branch_id'])->where('status',1)->get(); $status_name=" "; }else{ $borrowers = DB::table('borrowers')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('customerType',$request->customerType)->where('branch_id',Session::get('user')['branch_id'])->where('status',0)->get(); $status_name="Dissabled"; } if($request->customerType=='Client'){ $title="List of ".$status_name." Clients"; }elseif($request->customerType=='Member'){ $title="List of ".$status_name." Members"; }elseif($request->customerType=='Company'){ $title="List of ".$status_name." Companies"; } ?>

Print Details

from .' to '.$request->to?>

Full Name	Economic Activity	Unique#	Phone	Email	Satus/Action
firstName))." ".ucfirst(strtoupper($borrower->middleName))." ".ucfirst(strtoupper($borrower->lastName)) ?>	businessName==''){ echo 'None'; }else{ echo $borrower->businessName; } ?>	uniqueNumber; ?>	phone; ?>	email; ?>	status==1){ echo 'Active'; }else{ echo 'Passive'; } ?>

status; $status_name=''; $customerType='Company'; if($status=='Active'){ $borrowers = DB::table('borrowers')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('customerType','Company')->where('branch_id',Session::get('user')['branch_id'])->where('status',1)->get(); $status_name=" "; }else{ $borrowers = DB::table('borrowers')->where('date','>=',$request->from)->where('date','<=',$request->to)->where('customerType','Company')->where('branch_id',Session::get('user')['branch_id'])->where('status',0)->get(); $status_name="Dissabled"; } if($customerType=='Client'){ $title="List of ".$status_name." Clients"; }elseif($customerType=='Member'){ $title="List of ".$status_name." Members"; }elseif($customerType=='Company'){ $title="List of ".$status_name." Companies"; } ?>

Print Details

from .' to '.$request->to?>

Full Name	Economic Activity	Unique#	Phone	Email	Satus/Action
firstName))." ".ucfirst(strtoupper($borrower->middleName))." ".ucfirst(strtoupper($borrower->lastName)) ?>	businessName==''){ echo 'None'; }else{ echo $borrower->businessName; } ?>	uniqueNumber; ?>	phone; ?>	email; ?>	status==1){ echo 'Active'; }else{ echo 'Passive'; } ?>

where('uniqueNumber', $randomNumber)->where('branch_id',Session::get('user')['branch_id'])->get()->count(); if($count>0){ generateRandomNumber(); }else{ return $randomNumber; } } $accountNumber = generateRandomNumber(); $borrowers = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('registration_fee_settings')->where('year',date('Y'))->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.add_borrowers')->with('borrowers',$borrowers)->with('uniqueNumber',$accountNumber)->with('methods',$methods); } public function add_companies(){ //get unique Number function generateRandomNumber($length = 8) { $number = '1234567890'; $numberLength = strlen($number); $randomNumber = ''; for ($i = 0; $i < $length; $i++) { $randomNumber .= $number[rand(0, $numberLength - 1)]; } $randomNumber='C000'.$randomNumber; $count = DB::table('borrowers')->where('uniqueNumber', $randomNumber)->get()->count(); if($count>0){ generateRandomNumber(); }else{ return $randomNumber; } } $accountNumber = generateRandomNumber(); $borrowers = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $methods = DB::table('registration_fee_settings')->where('year',date('Y'))->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.add_companies')->with('borrowers',$borrowers)->with('uniqueNumber',$accountNumber)->with('methods',$methods); } public function borrowers_group(){ //get unique Number function generateRandomNumber($length = 8) { $number = '1234567890'; $numberLength = strlen($number); $randomNumber = ''; for ($i = 0; $i < $length; $i++) { $randomNumber .= $number[rand(0, $numberLength - 1)]; } $randomNumber='G000'.$randomNumber; $count = DB::table('borrowers')->where('uniqueNumber', $randomNumber)->get()->count(); if($count>0){ generateRandomNumber(); }else{ return $randomNumber; } } $accountNumber = generateRandomNumber(); $borrowers = DB::table('borrowers')->where('branch_id',Session::get('user')['branch_id'])->get(); $staffs = DB::table('users')->where('role','collector')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.add_borrowers_groups')->with('borrowers',$borrowers)->with('staffs',$staffs)->with('uniqueNumber',$accountNumber); } public function edit_group(Request $request){ $id = base64_decode($request->id); $groups = DB::table('borrowergroups')->where('id',$id)->get(); $borrowers = DB::table('borrowers')->where('status',1)->get(); $staffs = DB::table('users')->where('role','collector')->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.edit_group')->with('groups',$groups)->with('borrowers',$borrowers)->with('staffs',$staffs); } public function view_borrowers_groups(){ $borrowers = DB::table('borrowergroups')->where('status',1)->where('branch_id',Session::get('user')['branch_id'])->get(); $borrowers1 = DB::table('borrowergroups')->where('status',0)->where('branch_id',Session::get('user')['branch_id'])->get(); return view('pages.view_borrowers_groups')->with('groups',$borrowers)->with('groups1',$borrowers1); } public function view_single_borrowergroup(Request $request){ $id = base64_decode($request->id); $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->where('id',$id)->get(); return view('pages.view_single_borrowergroup')->with('groups',$groups); } public function groups_insert(Request $request){ $photo = ""; if(isset($_FILES['photo'])){ $file_tmp =$_FILES['photo']['tmp_name']; $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $photo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$photo); } $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'groupName'=>$request->groupName, 'uniqueNumber'=>$request->uniqueNumber, 'collector'=>$request->collector, 'leader'=>$request->leader, 'officerIncharge'=>$request->officerIncharge, 'meetingSchedule'=>$request->meetingSchedule, 'meetingDay'=>$request->meetingDay, 'birthday'=>$request->birthday, //registered date 'phone'=>$request->mobile, 'email'=>$request->email, 'address'=>$request->address, 'region'=>$request->region, 'district'=>$request->district, 'city'=>$request->city, //town 'street'=>$request->street, 'bank'=>$request->bank, 'bankAccountNumber'=>$request->bankAccountNumber, 'bankBranch'=>$request->bankBranch, 'photo'=>$photo, 'description'=>$request->description, 'registered_by'=>Auth::id(), 'status'=>1, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->insert($data); $id = DB::getPdo()->lastInsertId(); $borrowers = $request->borrowers; foreach($borrowers as $coll){ $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$coll, 'borrowergroup_id'=>$id, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrowergroupmembers')->insert($data); } /* DB::table('borrowergroups')->insert($data); $boorowerID = DB::getPdo()->lastInsertId(); foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'group_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } */ return redirect('/customers/add_customers_groups?id=&sent'); } public function add_members(Request $request){ $id = $request->id; $borrowers = $request->borrowers; foreach($borrowers as $coll){ $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'borrower_id'=>$coll, 'borrowergroup_id'=>$id, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrowergroupmembers')->insert($data); } /* DB::table('borrowergroups')->insert($data); $boorowerID = DB::getPdo()->lastInsertId(); foreach ($_FILES["file"]["name"] as $f => $name) { $path = $name; $ext = pathinfo($path, PATHINFO_EXTENSION); $document = "./uploads/docs/".date('Ymd')."-".rand()."-".time().".".$ext; move_uploaded_file($_FILES["file"]["tmp_name"][$f], base_path('public/assets/').$document); $data = array( 'branch_id'=>Session::get('user')['branch_id'], 'group_id'=>$boorowerID, 'file'=>$document, 'registered_by'=>Auth::id(), 'date'=>date('Y-m-d'), ); DB::table('borrower_documents')->insert($data); } */ return redirect('/customers/view_single_borrowergroup?id='.base64_encode($id)); } public function remove_member(Request $request){ $id = base64_decode($request->id); $group_id = base64_decode($request->group_id); // echo $id.' '.$group_id;exit; DB::table('borrowergroupmembers')->where('borrower_id',$id)->where('borrowergroup_id',$group_id)->where('branch_id',Session::get('user')['branch_id'])->delete(); return redirect('/customers/view_single_borrowergroup?id='.base64_encode($group_id)); } }