From 2ba5c12719e78b1231d121b154f10ebb194bf6ed Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Wed, 10 Jul 2024 16:03:10 +0300
Subject: [PATCH] =?utf8?q?=D0=94=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D0=B5=D0=BD?=
 =?utf8?q?=D0=B8=D1=8F=20=D0=BA=D0=BD=D0=BE=D0=BF=D0=BA=D0=B8=20=D1=8D?=
 =?utf8?q?=D0=BA=D1=81=D0=BF=D0=BE=D1=80=D1=82=D0=B0=20=D1=82=D0=B0=D0=B1?=
 =?utf8?q?=D0=BB=D0=B8=D1=86=D1=8B=20=D0=B7=D0=B0=D0=BA=D1=83=D0=BF=D0=BA?=
 =?utf8?q?=D0=B8=20=D0=B2=20xslx?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/modul/shipment/shipment.php | 18 +++++++++++++++++-
 erp24/views/shipment/shipment.php |  2 ++
 2 files changed, 19 insertions(+), 1 deletion(-)

diff --git a/erp24/modul/shipment/shipment.php b/erp24/modul/shipment/shipment.php
index bac52581..f883dee8 100644
--- a/erp24/modul/shipment/shipment.php
+++ b/erp24/modul/shipment/shipment.php
@@ -39,6 +39,9 @@ echo'<h3 class="page-title mb-0 text-primary">
 Заказ товара '.($OrderData["name"] ?? '').' id='.$orderId.'</h3>
 <p> ваша роль <b>'. ($users_group[$_SESSION["group_id"]] ?? '').'</b>
 <span onclick="deleteAll();" class="btn btn-danger btn-sm me-2">очистить данные у этой закупки</span>
+<div style="float: right; margin: 20px;">
+<button class="btn btn-success btn-sm" onclick="htmlTableToExcel();">Экспорт таблицы в Excel документ</button>
+</div>
 </p>';
 
 
@@ -52,7 +55,7 @@ showOrderStoresPanel();
 echo'<div id=edit_div></div>';
 if(!empty($store_id)) echo'<input type=hidden name=store_id_id value='.$store_id.' id=store_id_id>';
 
-echo'<div class="table-responsive mt-3"><table class="zak">';
+echo'<div class="table-responsive mt-3"><table id="shipmentTable" class="zak">';
 $html='<thead><tr class="zg"><th class="text-right w-10">наименование 
 
 <span onclick="ajaxUpdateStoreZakup();" class="btn btn-blue btn-sm me-2">пересчитать данные</span>';
@@ -292,6 +295,19 @@ $data=$db::getRows($sql);
  
 $_CONFIG["jscss"] ="<script>
 
+function htmlTableToExcel() {
+    const type = 'xlsx';
+    var data = document.getElementById('shipmentTable');
+    $.each(data.querySelectorAll('input'), (ind, x) => {
+        x.parentNode.textContent = x.value;
+    });
+    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, 'ShipmentTable_' + moment().format('L') + '.' + type);
+    window.location.reload();
+}
+
 function ajaxUpdateStoreZakup(){
  $('#modal-7 .modal-body').html('Считаем данные');
 jQuery('#modal-7').modal('show', {backdrop: 'static'}); $('#modal-7 .modal-title').text('Обновляем данные');
diff --git a/erp24/views/shipment/shipment.php b/erp24/views/shipment/shipment.php
index 1b9d55ef..908c115e 100644
--- a/erp24/views/shipment/shipment.php
+++ b/erp24/views/shipment/shipment.php
@@ -1,5 +1,7 @@
 <?php
 
+$this->registerJsFile('https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js', ['position' => \yii\web\View::POS_END]);
+
 chdir(__DIR__ . '/../../');
 
 include 'modul/shipment/shipment.php';
\ No newline at end of file
-- 
2.39.5