From ad4e0124e5157a02a89325d3adefe6e70206c4e1 Mon Sep 17 00:00:00 2001 From: fomichev Date: Fri, 13 Dec 2024 11:53:42 +0300 Subject: [PATCH] =?utf8?q?=D0=9F=D1=80=D0=B0=D0=B2=D0=BA=D0=B8=20=D1=84?= =?utf8?q?=D0=BE=D1=80=D0=BC=D0=B8=D1=80=D0=BE=D0=B2=D0=B0=D0=BD=D0=B8?= =?utf8?q?=D1=8F=20=D1=82=D0=B0=D0=B1=D0=BB=D0=B8=D1=86=D1=8B?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../UsersMessageManagementController.php | 23 ++++++++----------- 1 file changed, 9 insertions(+), 14 deletions(-) diff --git a/erp24/controllers/UsersMessageManagementController.php b/erp24/controllers/UsersMessageManagementController.php index 9e3f40b6..5e614c76 100644 --- a/erp24/controllers/UsersMessageManagementController.php +++ b/erp24/controllers/UsersMessageManagementController.php @@ -4,6 +4,7 @@ namespace app\controllers; use PhpOffice\PhpSpreadsheet\Cell\Coordinate; use PhpOffice\PhpSpreadsheet\Spreadsheet; +use PhpOffice\PhpSpreadsheet\Writer\Xlsx; use Yii; use yii\base\DynamicModel; use yii\data\ArrayDataProvider; @@ -128,7 +129,6 @@ class UsersMessageManagementController extends Controller return $this->redirect(Yii::$app->request->referrer); } - $data = []; foreach ($users as $user) { $userPhone = $user['phone']; @@ -178,20 +178,15 @@ class UsersMessageManagementController extends Controller $sheet = $spreadsheet->getActiveSheet(); $sheet->setTitle('Users'); - $fields = array_keys($data[0]->getAttributes()); - - foreach ($fields as $index => $field) { - $column = Coordinate::stringFromColumnIndex($index + 1); - $sheet->setCellValue("{$column}1", $field); + foreach ($columns as $index => $column) { + $cell = Coordinate::stringFromColumnIndex($index + 1) . '1'; + $sheet->setCellValue($cell, $column); } - foreach ($data as $rowIndex => $user) { - foreach ($fields as $columnIndex => $field) { - $column = Coordinate::stringFromColumnIndex($columnIndex + 1); - $sheet->setCellValue( - "{$column}" . ($rowIndex + 2), - $user->$field - ); + foreach ($data as $rowIndex => $userData) { + foreach ($columns as $columnIndex => $column) { + $cell = Coordinate::stringFromColumnIndex($columnIndex + 1) . ($rowIndex + 2); + $sheet->setCellValue($cell, $userData[$column] ?? ''); } } @@ -204,7 +199,7 @@ class UsersMessageManagementController extends Controller $response->headers->add('Pragma', 'public'); ob_clean(); - $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); + $writer = new Xlsx($spreadsheet); $writer->save('php://output'); die; -- 2.39.5