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'); function generateRandomNumber($length = 8) { $number = '1234567890'; $numberLength = strlen($number); $randomNumber = ''; for ($i = 0; $i < $length; $i++) { $randomNumber .= $number[rand(0, $numberLength - 1)]; } $randomNumber='B000'.$randomNumber; $count = DB::table('borrowers')->where('uniqueNumber', $randomNumber)->get()->count(); if($count>0){ generateRandomNumber(); }else{ return $randomNumber; } } } public function add_sms_header(Request $request){ $branch = $request->branch; $price = $request->price; $header = $request->header; // ame sms_price branch_id $data = array( 'branch_id'=>$request->branch, 'name'=>$header, 'sms_price'=>$price, ); $count = DB::table('sms_header')->where('branch_id', $branch)->get()->count(); if($count > 0){ // updte DB::table('sms_header')->where('branch_id', $branch)->update($data); }else{ DB::table('sms_header')->insert($data); } return redirect($_SERVER['HTTP_REFERER']); } public function insert_account(Request $request) { $logo = ""; if(isset($_FILES['logo']) && !empty($_FILES['logo']['name'])) { $file_tmp =$_FILES['logo']['tmp_name']; $ext = pathinfo($_FILES['logo']['name'], PATHINFO_EXTENSION); $logo = "uploads/images/".date('ymd').time().".".$ext; move_uploaded_file($file_tmp,base_path('public/assets/').$logo); } $data =array( 'logo'=>$logo, 'name'=>$request->name, 'email'=>$request->email, 'phone'=>$request->phone, 'date'=>date('Y-m-d'), ); DB::table('accounts')->insert($data); $asset_idID = DB::getPdo()->lastInsertId(); return redirect('/api/add_account?sent=true&id='.base64_encode($asset_idID)); } public function insert_branch(Request $request) { $data =array( 'account_id'=>$request->account_id, 'name'=>$request->name, 'email'=>$request->email, 'phone'=>$request->phone, 'box'=>$request->box, 'location'=>$request->location, 'registered_by'=>1, 'date'=>date('Y-m-d'), ); DB::table('branches')->insert($data); $asset_idID = DB::getPdo()->lastInsertId(); return redirect('/api/add_branches?sent=true&id='.base64_encode($asset_idID)); } public function insert_admin(Request $request) { $ro = explode('|',$request->branch_id); $branch_id = $ro[1]; $account_id = $ro[0]; $data = array( 'branch_id'=>$branch_id, 'account_id'=>$account_id, 'name'=>$request->name, 'email'=>$request->email, 'mobile'=>$request->mobile, 'role'=>$request->role, 'password'=>Hash::make('default'), 'recover_password'=>'default', 'registered_by'=>1, 'created_at'=>date('Y-m-d'), ); DB::table('users')->insert($data); return redirect('/api/add_admin?sent=true'); } public function upload_clients_post(Request $request){ $inputFileName = $_FILES['file']["tmp_name"]; $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); $reader->setReadDataOnly(true); $worksheet = $reader->load($inputFileName); $values = $worksheet->getActiveSheet(); $rows = $values->toArray(); $i=$entry=0; foreach($rows as $row){ if($i > 0){ // skipping the excel title // [0] => Empl. No [1] => Gender [2] => Employee Name (All) [3] => Phone [4] => Email [5] => Address [6] => Location [7] => NIDA [8] => WorkStatus [9] => Employer [10] => Nationality $names = explode(' ',$row[2]); $fname = $names[0]; $mname = isset($names[2]) ? $names[1] : ""; $lname = isset($names[2]) ? $names[2] : $names[1]; $data =array( 'branch_id'=>$request->branch_id, 'firstName'=>ucfirst(strtoupper($fname)), 'middleName'=>ucfirst(strtoupper($mname)), 'lastName'=>ucfirst(strtoupper($lname)), 'uniqueNumber'=>generateRandomNumber(), 'customerType'=>'Client', 'employmentDetails'=>'', 'employerName'=>$row[9], 'employerAddress'=>'', 'businessName'=>'', 'bankBranch'=>'', 'nationalID'=>$row[7], 'workStation'=>$row[8], 'employmentNumber'=>$row[0], 'phone'=>$row[3], 'email'=>$row[4], 'title'=>'', 'birthday'=>'', 'gender'=>$row[1], 'address'=>$row[5], 'city'=>$row[6], 'bank'=>'', 'bankAccountNumber'=>'', 'country'=>$row[10], 'workStatus'=>$row[8], 'photo'=>'', 'description'=>'', 'registered_by'=>0, 'date'=>date('Y-m-d'), 'status'=>1, 'password'=>md5('default'), 'password_recover'=>'default', ); DB::table('borrowers')->insert($data); $entry++; } $i++; } return redirect('/api/upload_clients?sent=true&entry='.$entry); } public function upload_loans_post(Request $request){ $inputFileName = $_FILES['file']["tmp_name"]; $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); $reader->setReadDataOnly(true); $worksheet = $reader->load($inputFileName); $values = $worksheet->getActiveSheet(); $rows = $values->toArray(); $branch_id = $request->branch_id; $loanproducts = explode('/',$request->loanproduct); ?> 0){ $amount = (float)$row[3]; $years = 1; $interest = 13; //(float)$row[4]; $unique = $row[1]; $product = $row[2]; $balance_row = $row[7]; $schedule = $row[8]; // $approve_date = explode('/',str_replace(' ','',trim($row[6]))); $total_interest = $amount*$interest/100; $repayment_number = ceil(($balance_row)/$schedule); // $day = sprintf("%02d", $approve_date[0]); // $month = sprintf("%02d", $approve_date[1]); // $year = sprintf("%04d", $approve_date[2]); $time = strtotime(date('2020-12-25')); $newformat = date('Y-m-d',$time); echo "

Name: ".$row[0]."

"; echo "

Amount: ".number_format($amount,2)."

"; echo "

Interest: ".number_format($interest,2)."

"; echo "

Repayments: ".number_format($repayment_number,2)."

"; echo "

Balance: ".number_format($balance_row,2)."

"; echo "

Approved: ".$newformat."

"; echo "

Schedule: ".$schedule."

"; if($method == 'reducing_balance'){ $data = array( 'loan_amount' => $amount, 'term_years' => $years, 'interest' => $interest, 'terms' => $repayment_number ); $amortization = new Amortization($data); $inputs = $amortization->results['inputs']; $summary = $amortization->results['summary']; $schedule = $amortization->results['schedule']; ?> where('uniqueNumber',$borrower_id)->where('branch_id',$branch_id)->get(); foreach($borrowers as $user){ ############################################################################### $style=""; $insert=$deleted=false; foreach($schedule as $term_detail){ $i++; ?> >

S/N	Date	Principal	Interest	Total Payment	Outstanding Balance	Inserted
	>	>	>	>	>

#######################################################################################################

$date, 'payment' =>$payment, 'interest' =>$interest, 'principal' =>$principal, 'balance' =>$balance-$payment, ); } $data = array_reverse($data); ?>

S/N	Date	Principal	Interest	Total Payment	Outstanding Balance

#######################################################################################################

$schedule){ $balance = $balance - $schedule; }else{ $schedule = $balance; $balance = $interest_schedule = 0; $principal_schedule = $schedule; } $principal_balance = $principal_balance - $principal_schedule; $data[] = array( 'date'=>$date, 'payment' =>$schedule, 'interest' =>$interest_schedule, 'principal' =>$principal_schedule, 'principal_balance' =>$principal_balance, 'balance' =>$balance, ); $matuarityDate = $date; } $loanID=0; // for($i=1;$i<=$years * $repayment_number;$i++){ // $date = date('d/m/Y', strtotime('+'.$i.' months',$time)); // $payment = $interest + $principal; // $balance = $balance - $payment; // $principal_balance = $principal_balance - $principal; // $data[] = array( // 'date'=>$date, // 'payment' =>$payment, // 'interest' =>$interest, // 'principal' =>$principal, // 'principal_balance' =>$principal_balance, // 'balance' =>$balance, // ); // } // $data = array_reverse($data); $borrowers = DB::table('borrowers')->where('uniqueNumber',$unique)->get(); foreach($borrowers as $user){ $loan = array( 'branch_id'=>$branch_id, 'loanProduct'=>$product, 'borrower_id'=>$user->id, 'borrowerType'=>'person', 'disbursed_by'=>'Cheque', 'principalAmount'=>$principal_only, 'dueAmount'=>$row[7], 'loanReleaseDate'=>$newformat, 'matuarityDate'=>$matuarityDate, 'interestMethod'=>'reducing_balance', 'loanInterest'=>$interest, 'loanDuration'=>$repayment_number, 'repaymentsNumber'=>$repayment_number, 'description'=>'uploaded', 'registered_by'=>0, 'date'=>date('Y-m-d'), 'status'=>'granted', 'loanNumber'=>generateRandomNumber() ); print_r($loan); DB::table('loans')->insert($loan); $loanID = DB::getPdo()->lastInsertId(); ?>

S/N	Date	Principal	Interest	Total Payment	Principal Balance	Total Balance

$branch_id, 'loan_id'=>$loanID, 'loanProduct'=>$product, 'borrower_id'=>$user->id, 'principal'=>$dd['principal'], 'interest'=>$dd['interest'], 'fee'=>0, 'dueDate'=> $dd['date'], 'amount'=>$dd['payment'], 'registered_by'=>0, 'date'=>date('Y-m-d'), 'status'=>'wait', ); DB::table('repaymentschedule')->insert($repaymentData); print_r($repaymentData); ?>

#######################################################################################################

where('branch_id',$_REQUEST['branch'])->get(); foreach($borrower as $user){ $data[] = array( 'uniqueNumber'=>$user->uniqueNumber, 'name'=>$user->firstName.' '.$user->middleName.' '.$user->lastName, ); } foreach ($data as $key => $row) { $sort[$key] = $row['name']; } array_multisort($sort, SORT_ASC, $data); $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('./public/format_loans.xlsx'); $worksheet = $spreadsheet->getSheet(0); $i=1; foreach($data as $value){ $i++; $worksheet->getCell('A'.$i)->setValue($value['name']); $worksheet->getCell('B'.$i)->setValue($value['uniqueNumber']); $spreadsheet->getActiveSheet()->getProtection()->setSheet(true); $spreadsheet->getDefaultStyle()->getProtection()->setLocked(false); $worksheet->getStyle('A'.$i)->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('B'.$i)->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); } $worksheet->getStyle('A1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('B1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('C1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('D1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('E1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('F1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('G1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('H1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('I1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $worksheet->getStyle('J1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED); $styleArrayFirstRow = [ 'font' => [ 'bold' => true, ] ]; $worksheet->getStyle('A1:J1')->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('4082f5'); $worksheet->getStyle('A1:J1')->applyFromArray($styleArrayFirstRow); $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx'); $file_name='Customer-member-list'; $writer->save($file_name); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename="'.$file_name.'.xlsx"'); $writer->save("php://output"); } }