View Issue Detail

ID	Project	Category	Submitted / Last Updated
01305	UserSpice	Plugins	2021-08-29 19:39:59 / 2021-12-26 01:48:40
Reported	Muhammed Cotwal	Assigned To	Unassigned
Priority	low	Reported	5.3.4
Status	closed fixed	Resolution Version and Commit	5.3.8
Summary	Upgrade reports plugin as follows to make it current and to fix it from failing on big datasets
Description	1) composer update to get to latest version 2) make files download as xlsx instead of xls in reports.php: 1) add the ff after use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; 2) change code after the ff comment: // Set active sheet index to the first sheet, so Excel opens this as the first sheet: // Redirect output to a client’s web browser (Xlsx) header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="'.$title.'.xlsx"'); header('Cache-Control: max-age=0'); ob_clean(); $writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); $writer->save('php://output'); exit;

November 2021

oh boy - the text above looks crazy - below comment is the entire new reports.php (dont forget to composer update)
November 2021

<?php require_once "../../../users/init.php"; if(!pluginActive("reports",true)){ die("Plugin not active"); } $db = DB::getInstance(); if(!isset($user) || $user->isLoggedIn()){ $uid = 0; }else{ $uid = $user->data()->id; } require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Helper\Sample; use PhpOffice\PhpSpreadsheet\IOFactory; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $report = Input::get('report'); if(file_exists($abs_us_root.$us_url_root."usersc/plugins/reports/reportfiles/".$report.".php")){ include $abs_us_root.$us_url_root."usersc/plugins/reports/reportfiles/".$report.".php"; global $access, $spreadsheet; if(!$access){ logger($uid,"reports","Tried to run $report without permission"); die("You do not have access to generate this report"); } }else{ logger($uid,"reports","Tried to run $report that doesn not exist"); die("This report does not exist"); } function createExcelHeading($data){ $headings = []; foreach($data[0] as $k=>$v){ $headings[] = ucfirst($k); } return $headings; } $spreadsheet->removeSheetByIndex(0); for ($i=0; $i < count($reports) ; $i++) { $rowID = 1; $thisSheet = $spreadsheet->createSheet(); $thisSheet->setTitle($reports[$i]['title']); //grab headings if(isset($reports[$i]['headings'])){ $headings = $reports[$i]['headings']; }else{ $headings = createExcelHeading($reports[$i]['data']); } $columnID = 'A'; foreach($headings as $k=>$value){ $spreadsheet->setActiveSheetIndex($i)->setCellValue($columnID.$rowID, $value); $spreadsheet->getActiveSheet()->getStyle($columnID.$rowID) ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_BLUE); $columnID++; } $rowID++; //insert data $columns = []; foreach($reports[$i]['data'] as $k=>$v){ $columnID = 'A'; foreach($v as $key=>$value){ $columns[] = $columnID; $spreadsheet->setActiveSheetIndex($i)->setCellValue($columnID.$rowID, $value); $columnID++; } $rowID++; } foreach($columns as $c){ $spreadsheet->getActiveSheet()->getColumnDimension($c)->setAutoSize(true); } } // Set active sheet index to the first sheet, so Excel opens this as the first sheet $spreadsheet->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Xlsx) header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="'.$title.'.xlsx"'); header('Cache-Control: max-age=0'); ob_clean(); $writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); $writer->save('php://output'); exit;
November 2021

not exactly formatting correctly, but im sure you can use the code above and beautify the code.
November 2021

This is not a feature request - currently the reports plugin will fail on any big dataset.
November 2021

This turned into 3.5 hours of git hell thanks to all the recursive repositories in this composer update. Yikes.
November 2021

oh boy - shit man - sorry! In South Africa we have a chocolate called BarOne. The slogan for the chocolate is: "For a 25 hours day!", so when you back here and we meet up - remind me I owe you 3 and half Bar Ones for your time - lol :P~