[Bug]: Laravel 12 - Incompatible #4289
Comments
|
|
That will install obsolete 1.1, though |
|
II have had the same problem. Apparently it has to do with the chunking that eloquent does when querying the DB. The only solution I have found is to do it in a more rudimentary way with the PhpSpreadSheet package. Attached below is an example similar to the one I used: <?php
namespace App\Traits;
use App\Models\Property;
use App\Models\Request;
use App\Models\Supply;
use App\Models\User;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Storage;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;
use Barryvdh\DomPDF\Facade\Pdf;
use Illuminate\Support\Facades\Log;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
trait ExportFile
{
private function pdf($query, $filename)
{
// Detectar columnas automáticamente
$columns = $query->first() ? array_keys($query->first()->getAttributes()) : [];
// Construir el HTML manualmente
$html = '<table border="1" cellpadding="0" cellspacing="0" width="100%"><thead><tr>';
foreach ($columns as $column) {
$html .= '<th>' . ucfirst($column) . '</th>';
}
$html .= '</tr></thead><tbody>';
$page = 1;
$perPage = 1000;
do {
$items = $query->forPage($page, $perPage)->get();
foreach ($items as $item) {
$html .= '<tr>';
foreach ($columns as $column) {
$html .= '<td>' . e($item->$column) . '</td>';
}
$html .= '</tr>';
}
$page ;
} while ($items->count() > 0);
$html .= '</tbody></table>';
// Generar el PDF
$pdf = Pdf::loadHTML($html)->setPaper('a4', 'landscape');
// Obtener el contenido binario del PDF
$pdfContent = $pdf->output();
// Guardar en storage local
$storagePath = 'exports/' . $filename . '_' . date('Ymd_His') . '.pdf';
Storage::disk('local')->put($storagePath, $pdfContent);
return $storagePath; // Ruta relativa en storage/app/pdf/
}
private function csv($data, $filename)
{
// 1. Detectar columnas automáticamente
$query = $data;
$columns = $data->first() ? array_keys($data->first()->getAttributes()) : [];
// 2. Crear un recurso temporal
$temp = fopen('php://temp', 'r ');
// 3. Escribir encabezados
fputcsv($temp, $columns);
// 4. Escribir los datos en chunks para eficiencia
$page = 1;
$perPage = 1000;
do {
$items = $query->forPage($page, $perPage)->get();
foreach ($items as $item) {
$row = [];
foreach ($columns as $column) {
$row[] = $item->$column;
}
fputcsv($temp, $row);
}
$page ;
} while ($items->count() > 0);
// 5. Obtener el contenido y guardarlo en storage
rewind($temp);
$csvContent = stream_get_contents($temp);
fclose($temp);
// 6. Guardar usando Storage
$storagePath = 'exports/' . $filename . '_' . date('Ymd_His') . '.csv';
Storage::disk('local')->put($storagePath, $csvContent);
return $storagePath;
}
private function xls($query, $filename, $file_type = 'xlsx')
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setTitle($filename);
$columns = $query->first() ? array_keys($query->first()->getAttributes()) : [];
foreach ($columns as $colIndex => $column) {
$cellCoordinate = Coordinate::stringFromColumnIndex($colIndex 1) . '1';
$sheet->setCellValue($cellCoordinate, ucfirst($column));
}
$page = 1;
$perPage = 1000;
$rowIndex = 2;
do {
$items = $query->forPage($page, $perPage)->get();
foreach ($items as $item) {
foreach ($columns as $colIndex => $column) {
$cellCoordinate = Coordinate::stringFromColumnIndex($colIndex 1) . $rowIndex;
$sheet->setCellValue($cellCoordinate, $item->$column);
}
$rowIndex ;
}
$page ;
} while ($items->count() > 0);
// Guardar en un recurso temporal
$tempFile = tmpfile();
$tempFilePath = stream_get_meta_data($tempFile)['uri'];
$writer = new Xlsx($spreadsheet);
$writer->save($tempFilePath);
// Leer el contenido binario
$excelContent = file_get_contents($tempFilePath);
// Guardar usando Storage en el disco local
$storagePath = 'exports/' . $filename . '_' . date('Ymd_His') .'.'.$file_type;
Storage::disk('local')->put($storagePath, $excelContent);
// Cerrar el recurso temporal
fclose($tempFile);
return $storagePath; // Devuelve la ruta relativa dentro de storage/app
}
private function get_data(){
return Data::where('id','>',0);
}
public function export($exports='data', $fileName, $file_type)
{
try {
$data = [];
switch ($exports) {
case 'data':
$data = $this->get_data();
break;
}
switch ($file_type) {
case 'pdf':
$path = $this->pdf($data, $fileName);
break;
case 'xlsx':
$path = $this->xls($data, $fileName, 'xlsx');
break;
case 'xls':
$path = $this->xls($data, $fileName,'xls');
break;
case 'csv':
$path = $this->csv($data, $fileName);
break;
}
return $path;
} catch (\Exception $e) {
Log::error(['[EXPORT ERROR]',$e->getMessage()]);
return false;
}
}
}
|
|
I use followings:
It installs 1.1 version. |
|
Please share the composer output when installing 3.1 |
Laravel Excel installation based on the instruction. The results are: |
I was able to solve this by installing simple-cache first Then install maatwebsiteexcel Ensure that Source: https://laracasts.com/discuss/channels/laravel/error-to-install-maatwebsiteexcel |
Ive tried this but since the psr is included in laravel it doesnt have any impact? For me, installing ^3.1 will cause error on php version. It ask for php7. Tried the other way to install |
|
Have you install I did install it first before installing I think ^3.1 will install phpspreadsheet automatically, but for Your maatwebsite/excel might be 1.x which is unsupported causing that error happen |
Ya, i have installed |
This one works for me. Since I already installed the latest |
Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?
What version of Laravel Excel are you using?
3.1
What version of Laravel are you using?
12
What version of PHP are you using?
8.3
Describe your issue
PHP Fatal error: Declaration of Maatwebsite\Excel\Cache\MemoryCache::get(string $key, mixed $default = null): mixed must be compatible with PsrExt\SimpleCache\CacheInterface::get($key, $default = ) in /home/---/dev/gitlab/stock-control/vendor/maatwebsite/excel/src/Cache/MemoryCache.php on line 63
PHP Fatal error: Declaration of Monolog\Logger::emergency(Stringable|string $message, array $context = []): void must be compatible with PsrExt\Log\LoggerInterface::emergency($message, array $context = []) in /home/---/dev/gitlab/stock-control/vendor/monolog/monolog/src/Monolog/Logger.php on line 683
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 25
How can the issue be reproduced?
composer require maatwebsite/excel:^3.1
What should be the expected behaviour?
--
The text was updated successfully, but these errors were encountered: