From 44c77aa818894b0dbc108cffb6381b61005a5bdf Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Tue, 25 Jun 2024 10:41:39 +0300
Subject: [PATCH] =?utf8?q?=D0=AD=D0=BA=D1=81=D0=BF=D0=BE=D1=80=D1=82=20?=
 =?utf8?q?=D1=82=D0=B0=D0=B1=D0=BB=D0=B8=D1=86=D1=8B=20=D0=BF=D1=80=D0=BE?=
 =?utf8?q?=D0=BC=D0=BE=D0=BA=D0=BE=D0=B4=D0=BE=D0=B2=20=D0=B2=20xlsx?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/views/promocode/edit.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/erp24/views/promocode/edit.php b/erp24/views/promocode/edit.php
index d0deaf92..f6d59bb1 100644
--- a/erp24/views/promocode/edit.php
+++ b/erp24/views/promocode/edit.php
@@ -12,6 +12,8 @@ use \yii_app\helpers\PrintBlockHelper;
 /** @var $model Promocode */
 /** @var $dataProvider ActiveDataProvider */
 
+$this->registerJsFile('https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js', ['position' => \yii\web\View::POS_END]);
+
 ?>
 
 
@@ -64,6 +66,18 @@ use \yii_app\helpers\PrintBlockHelper;
 
     <?php if (isset($dataProvider) && $model->base == 1): ?>
 
+        <button id="button" onclick="htmlTableToExcel('xlsx')">Экспортировать таблицу промокодов в EXCEL</button>
+
+        <script>
+            function htmlTableToExcel(type){
+                var data = document.querySelector('table');
+                var excelFile = XLSX.utils.table_to_book(data, {sheet: "sheet1"});
+                XLSX.write(excelFile, { bookType: type, bookSST: true, type: 'base64' });
+                moment.locale('ru');
+                XLSX.writeFile(excelFile, 'SingleUsePromocodeTable_' + moment().format('L') + '.' + type);
+            }
+        </script>
+
         <?= GridView::widget([
             'dataProvider' => $dataProvider,
             'columns' => [
-- 
2.39.5