fixed cut

public/userarea/class/curl_auth_debug.log

@@ -31,6 +31,6 @@ Content-Length: 51
 < strict-transport-security: max-age=2592000
 < x-powered-by: ASP.NET
 < x-content-type-options: nosniff
-< date: Thu, 04 Sep 2025 12:59:20 GMT
+< date: Mon, 08 Sep 2025 11:59:10 GMT
 < 
 * Connection #0 to host 93.43.5.102 left intact

public/userarea/class/curl_request_debug.log

@@ -15,11 +15,11 @@
 * [HTTP/2] [1] [:scheme: https]
 * [HTTP/2] [1] [:authority: 93.43.5.102]
 * [HTTP/2] [1] [:path: /limsapi/api/odata/CustomField(1083)?$expand=CustomFieldsValues]
-* [HTTP/2] [1] [authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1Njk5Nzk2MCwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.zHug3m3GFz-uMMbRXi70DlHNfw0Islrxyy5vdJ7RKtA]
+* [HTTP/2] [1] [authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1NzMzOTk1MSwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.JywaxXVFGeXH44RCOZUPfDGuEr5dt0cHAWN_vmIiFaw]
 * [HTTP/2] [1] [accept: application/json]
 > GET /limsapi/api/odata/CustomField(1083)?$expand=CustomFieldsValues HTTP/2
 Host: 93.43.5.102
-Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1Njk5Nzk2MCwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.zHug3m3GFz-uMMbRXi70DlHNfw0Islrxyy5vdJ7RKtA
+Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1NzMzOTk1MSwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.JywaxXVFGeXH44RCOZUPfDGuEr5dt0cHAWN_vmIiFaw
 Accept: application/json
 
 < HTTP/2 200 
@@ -30,6 +30,6 @@ Accept: application/json
 < odata-version: 4.0
 < x-powered-by: ASP.NET
 < x-content-type-options: nosniff
-< date: Thu, 04 Sep 2025 12:59:23 GMT
+< date: Mon, 08 Sep 2025 11:59:14 GMT
 < 
 * Connection #0 to host 93.43.5.102 left intact

public/userarea/docs/Swagger documentation/.swagger-codegen-ignore

@@ -0,0 +1,23 @@
+# Swagger Codegen Ignore
+# Generated by swagger-codegen https://github.com/swagger-api/swagger-codegen
+
+# Use this file to prevent files from being overwritten by the generator.
+# The patterns follow closely to .gitignore or .dockerignore.
+
+# As an example, the C# client generator defines ApiClient.cs.
+# You can make changes and tell Swagger Codgen to ignore just this file by uncommenting the following line:
+#ApiClient.cs
+
+# You can match any string of characters against a directory, file or extension with a single asterisk (*):
+#foo/*/qux
+# The above matches foo/bar/qux and foo/baz/qux, but not foo/bar/baz/qux
+
+# You can recursively match patterns against a directory, file or extension with a double asterisk (**):
+#foo/**/qux
+# This matches foo/bar/qux, foo/baz/qux, and foo/bar/baz/qux
+
+# You can also negate patterns with an exclamation (!).
+# For example, you can ignore all files in a docs folder with the file extension .md:
+#docs/*.md
+# Then explicitly reverse the ignore rule for a single file:
+#!docs/README.md

public/userarea/docs/Swagger documentation/.swagger-codegen/VERSION

@@ -0,0 +1 @@
+3.0.34

public/userarea/error_log.txt

@@ -11,3 +11,4 @@
 2025-08-26 16:48:44 - Risposta non JSON valida: <?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="DevExpress.ExpressApp.SystemModule" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="DashboardViewItemDescriptor"><Key><PropertyRef Name="ViewId" /></Key><Property Name="ViewId" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem" BaseType="DevExpress.ExpressApp.NonPersistentLiteObject" Abstract="true"><Property Name="Visibility" Type="DevExpress.ExpressApp.Editors.ViewItemVisibility" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem_1OfIModelDashboardViewItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem" Abstract="true" /><EntityType Name="ViewDashboardOrganizationItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem_1OfIModelDashboardViewItem"><Property Name="ObjectType" Type="System.Type" /><Proper
 2025-08-26 16:49:24 - Risposta non JSON valida: <?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="DevExpress.ExpressApp.SystemModule" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="DashboardViewItemDescriptor"><Key><PropertyRef Name="ViewId" /></Key><Property Name="ViewId" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem" BaseType="DevExpress.ExpressApp.NonPersistentLiteObject" Abstract="true"><Property Name="Visibility" Type="DevExpress.ExpressApp.Editors.ViewItemVisibility" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem_1OfIModelDashboardViewItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem" Abstract="true" /><EntityType Name="ViewDashboardOrganizationItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem_1OfIModelDashboardViewItem"><Property Name="ObjectType" Type="System.Type" /><Proper
 2025-08-26 16:50:23 - Risposta non JSON valida: <?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="DevExpress.ExpressApp.SystemModule" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="DashboardViewItemDescriptor"><Key><PropertyRef Name="ViewId" /></Key><Property Name="ViewId" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem" BaseType="DevExpress.ExpressApp.NonPersistentLiteObject" Abstract="true"><Property Name="Visibility" Type="DevExpress.ExpressApp.Editors.ViewItemVisibility" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem_1OfIModelDashboardViewItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem" Abstract="true" /><EntityType Name="ViewDashboardOrganizationItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem_1OfIModelDashboardViewItem"><Property Name="ObjectType" Type="System.Type" /><Proper
+2025-09-08 08:39:17 - Risposta non JSON valida: <?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="DevExpress.ExpressApp.SystemModule" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="DashboardViewItemDescriptor"><Key><PropertyRef Name="ViewId" /></Key><Property Name="ViewId" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem" BaseType="DevExpress.ExpressApp.NonPersistentLiteObject" Abstract="true"><Property Name="Visibility" Type="DevExpress.ExpressApp.Editors.ViewItemVisibility" Nullable="false" /></EntityType><EntityType Name="DashboardOrganizationItem_1OfIModelDashboardViewItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem" Abstract="true" /><EntityType Name="ViewDashboardOrganizationItem" BaseType="DevExpress.ExpressApp.SystemModule.DashboardOrganizationItem_1OfIModelDashboardViewItem"><Property Name="ObjectType" Type="System.Type" /><Proper

public/userarea/get_commessaweb.php

@@ -0,0 +1,39 @@
+<?php
+require_once dirname(__DIR__, 2) . '/vendor/autoload.php';
+require_once dirname(__FILE__) . '/class/VisualLimsApiClient.class.php';
+
+header('Content-Type: application/json');
+
+ini_set('display_errors', '0');
+error_reporting(E_ALL);
+
+try {
+    $api = VisualLimsApiClient::getInstance();
+
+    // ID della CommessaWeb specifica (cambialo di volta in volta)
+    $id = 529435; // TODO: Cambia questo valore con l'ID desiderato
+
+    // Endpoint per recuperare la CommessaWeb specifica con espansione dello schema custom
+    $endpoint = "CommessaWeb({$id})";
+
+    // Opzioni per l'espansione: includi OrderCustomFields per ottenere i campi custom dello schema assegnato all'ordine
+    $options = ['$expand' => 'OrderCustomFields'];
+
+    // Debug: salva URL usato
+    $base_url = 'https://93.43.5.102/limsapi/api/odata/';
+    $query = http_build_query($options);
+    $full_url = $base_url . $endpoint . ($query ? '?' . $query : '');
+    file_put_contents(__DIR__ . '/last_url.txt', $full_url . PHP_EOL, FILE_APPEND);
+
+    // Chiamata API
+    $data = $api->get($endpoint, $options);
+
+    // Salva il JSON in locale
+    file_put_contents(__DIR__ . '/commessaweb_schema_response.json', json_encode($data, JSON_PRETTY_PRINT));
+
+    echo json_encode($data);
+} catch (Exception $e) {
+    file_put_contents(__DIR__ . '/error_log.txt', date('Y-m-d H:i:s') . ' - ' . $e->getMessage() . PHP_EOL, FILE_APPEND);
+    http_response_code(500);
+    echo json_encode(['error' => $e->getMessage()]);
+}

public/userarea/import_edit2.php

@@ -21,8 +21,8 @@ if ($_SERVER['REQUEST_METHOD'] !== 'POST' || !isset($_POST['template_id']) || !i
 
 $template_id = intval($_POST['template_id']) ?? $_SESSION['template_id'];
 $selected_rows = $_POST['selected_rows'] ?? $_SESSION['selected_rows'];
-$columns = json_decode($_POST['columns'], true) ?? $_SESSION['columns']; // Header dell'XLS
+$columns = json_decode($_POST['columns'], true) ?? $_SESSION['columns'];
-$rows = json_decode($_POST['rows'], true) ?? $_SESSION['rows'];       // Dati dell'XLS
+$rows = json_decode($_POST['rows'], true) ?? $_SESSION['rows'];
 $newFilename = htmlspecialchars($_POST['filename']) ?? $_SESSION['filename'];
 
 // Log dei dati ricevuti
@@ -31,7 +31,7 @@ error_log("Columns: " . json_encode($columns));
 error_log("Rows: " . json_encode($rows));
 
 // Recupera l'ID dell'utente loggato
-$user_id = $iduserlogin ?? 1; // Default a 1 se non definito
+$user_id = $iduserlogin ?? 1;
 
 $db = DBHandlerSelect::getInstance();
 $pdo = $db->getConnection();
@@ -98,26 +98,26 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
     <?php include('cssinclude.php'); ?>
     <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css" integrity="sha512-DTOQO9RWCH3ppGqcWaEA1BIZOC6xxalwEsw9c2QQeAIftl+Vegovlnee1c9QX4TctnWMn13TZye+giMm8e2Lw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
     <style>
-        /* Colori pastello per input/select */
+        .cell-changed {
+            background-color: #fff3b0 !important;
+            transition: background-color 0.3s ease;
+        }
+
         input.auto-input,
         select.auto-input {
             background-color: #d4edda;
-            /* Verde pastello */
         }
 
         input.manual-input,
         select.manual-input {
             background-color: #fff3cd;
-            /* Giallino pastello */
         }
 
         input.required-input,
         select.required-input {
             background-color: #f8d7da;
-            /* Rossino chiaro */
         }
 
-        /* Stili base per input/select */
         input,
         select {
             width: 100%;
@@ -128,14 +128,11 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             font-size: 14px;
         }
 
-        /* Mantieni leggibilità del testo */
         input,
         select {
             color: #333;
-            /* Colore scuro per contrasto */
         }
 
-        /* Stili per i badge di stato */
         .status-badge {
             display: inline-block;
             padding: 2px 8px;
@@ -161,7 +158,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             color: white;
         }
 
-        /* Stili esistenti rimangono invariati */
         .grid-container {
             overflow-x: auto;
             max-width: 100%;
@@ -254,6 +250,11 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             align-items: center;
         }
 
+        .grid-top .save-all-cell {
+            flex: 0 0 210px;
+            align-items: flex-start;
+        }
+
         .propagate-btn {
             background: none;
             border: none;
@@ -370,7 +371,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             box-shadow: 0 0 5px rgba(0, 123, 255, 0.5);
         }
 
-        /* Stile per l'header dei pulsanti combinati */
         .grid-cell.button-cell,
         .grid-header.button-header {
             min-width: 210px !important;
@@ -391,6 +391,20 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             background-color: #d4edda !important;
             transition: background-color 0.3s ease;
         }
+
+        .save-all-btn {
+            background-color: #28a745;
+            color: white;
+            border: none;
+            border-radius: 5px;
+            padding: 8px 16px;
+            cursor: pointer;
+            font-size: 14px;
+        }
+
+        .save-all-btn:hover {
+            background-color: #218838;
+        }
     </style>
     <title>Edit Imported Data - <?= htmlspecialchars($titlewebsite, ENT_QUOTES, 'UTF-8'); ?></title>
 </head>
@@ -413,6 +427,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                 <h6 class="mb-0">Modifica Dati Importati</h6>
                                 <div id="unsavedChanges" style="display:none; color: red; font-weight: bold; margin:10px 0;">
                                     ⚠️ Unsaved changes detected! Please save before leaving this page.
+                                    <ul id="changedFields" style="margin-top:5px; font-weight:normal; color:darkred;"></ul>
                                 </div>
                             </div>
                         </div>
@@ -420,9 +435,10 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                     <div class="card-body">
                         <form id="editForm">
                             <div class="grid-container">
-                                <!-- Riga superiore per gli input dei campi manuali -->
                                 <div class="grid-top">
-                                    <div class="grid-cell button-cell" style="flex: 0 0 210px;"></div> <!-- Actions -->
+                                    <div class="grid-cell save-all-cell">
+                                        <button type="button" class="save-all-btn" title="Save All Rows"><i class="fas fa-save"></i> Save All</button>
+                                    </div>
                                     <?php if ($mainFieldMapping): ?>
                                         <div class="grid-cell" style="flex: 0 0 150px;">
                                             <?php
@@ -450,9 +466,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                             ?>
                                         </div>
                                     <?php endif; ?>
-                                    <div class="grid-cell" style="flex: 0 0 150px;"></div> <!-- status -->
+                                    <div class="grid-cell" style="flex: 0 0 150px;"></div>
                                     <?php
-                                    // Campi automatici (is_manual = 0) escluso main_field
                                     $autoIndex = 0;
                                     foreach ($allMappings as $mapping) {
                                         if (!$mapping['is_manual'] && $mapping['main_field'] != 1) {
@@ -471,7 +486,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                             $autoIndex++;
                                         }
                                     }
-                                    // Campi manuali (is_manual = 1) escluso main_field
                                     $manualIndex = 0;
                                     foreach ($allMappings as $mapping) {
                                         if ($mapping['is_manual'] && $mapping['main_field'] != 1) {
@@ -483,7 +497,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                             if ($mapping['is_required']) $inputClass .= ' required-input';
                                             echo "<div class='grid-cell' style='flex: 0 0 150px;'>";
                                             if ($mapping['data_type'] === 'SceltaMultipla') {
-                                                echo "<select class='custom-field dropdown-select $inputClass' data-column='manual_$manualIndex' data-field-id='{$mapping['field_id']}' data-selected-value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
+                                                echo "<select class='custom-field dropdown-select $inputClass' data-column='manual_$manualIndex' data-field-id='{$mapping['field_id']}' data-selected-value='" . htmlspecialchars($fieldValue) . "' " . ($mainFieldMapping['is_required'] ? 'required' : '') . ">";
                                                 echo "<option value=''>Seleziona...</option>";
                                                 echo "</select>";
                                             } elseif ($mapping['data_type'] === 'DATE') {
@@ -498,15 +512,14 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                             $manualIndex++;
                                         }
                                     }
-                                    echo "<div class='grid-cell' style='flex: 0 0 200px;'></div>"; // AWB
+                                    echo "<div class='grid-cell' style='flex: 0 0 200px;'></div>";
-                                    echo "<div class='grid-cell' style='flex: 0 0 250px;'></div>"; // Tracking Info
+                                    echo "<div class='grid-cell' style='flex: 0 0 250px;'></div>";
-                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>"; // importreferencecode
+                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
-                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>"; // filename_import
+                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
-                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>"; // importdate
+                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
                                     ?>
                                 </div>
 
-                                <!-- Header della tabella -->
                                 <div class="grid-row">
                                     <div class="grid-header button-header" style="flex: 0 0 210px;">Actions</div>
                                     <?php if ($mainFieldMapping): ?>
@@ -543,7 +556,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                     ?>
                                 </div>
 
-                                <!-- Righe della tabella -->
                                 <?php foreach ($importedData as $index => $row): ?>
                                     <div class="grid-row" data-id="<?= $row['iddatadb'] ?>">
                                         <div class="grid-cell button-cell" style="flex: 0 0 210px; position: relative;">
@@ -698,24 +710,196 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
     <script src="tracking.js"></script>
     <script>
         document.addEventListener("DOMContentLoaded", function() {
+            console.log("Page loaded, initializing event listeners");
+
             const inputs = document.querySelectorAll(".cell-input, .dropdown-select, .carrier-select, .awb-input");
             const unsavedDiv = document.getElementById("unsavedChanges");
+            const changedList = document.getElementById("changedFields");
             let hasChanges = false;
+            let changedFields = {};
+
+            function renderChangedList() {
+                console.log("Rendering changed fields list:", changedFields);
+                changedList.innerHTML = "";
+                Object.keys(changedFields).forEach(rowIndex => {
+                    const fields = changedFields[rowIndex];
+                    if (fields.length > 0) {
+                        const li = document.createElement("li");
+                        li.textContent = `Row ${parseInt(rowIndex) + 1}: ${fields.join(", ")}`;
+                        changedList.appendChild(li);
+                    }
+                });
+                unsavedDiv.style.display = Object.keys(changedFields).length > 0 ? "block" : "none";
+            }
 
             inputs.forEach(el => {
                 el.addEventListener("change", () => {
+                    console.log("Input changed:", el.name);
                     hasChanges = true;
-                    unsavedDiv.style.display = "block";
+                    const gridCell = el.closest(".grid-cell");
+                    const colIndex = gridCell?.dataset.index;
+                    const rowIndex = gridCell?.dataset.row;
+                    let label = "Unknown field";
+
+                    if (colIndex) {
+                        const header = document.querySelector(`.grid-header[data-index="${colIndex}"]`);
+                        if (header) {
+                            label = header.textContent.replace(":", "").trim();
+                        }
+                    }
+
+                    if (rowIndex !== undefined) {
+                        if (!changedFields[rowIndex]) {
+                            changedFields[rowIndex] = [];
+                        }
+                        if (!changedFields[rowIndex].includes(label)) {
+                            changedFields[rowIndex].push(label);
+                        }
+                        gridCell.classList.add("cell-changed");
+                    }
+
+                    renderChangedList();
                 });
             });
 
             document.querySelectorAll(".save-btn").forEach(btn => {
                 btn.addEventListener("click", () => {
-                    hasChanges = false;
+                    const rowIndex = btn.dataset.row;
-                    unsavedDiv.style.display = "none";
+                    console.log(`Saving row ${rowIndex}`);
+                    const row = btn.closest('.grid-row');
+                    const iddatadb = row.getAttribute('data-id');
+                    const formData = new FormData();
+
+                    const inputs = row.querySelectorAll(`input[name^="rows[${rowIndex}][details]"], select[name^="rows[${rowIndex}][details]"]`);
+                    inputs.forEach(input => {
+                        const matches = input.name.match(/rows\[\d+\]\[details\]\[(\d+)\]\[field_value\]/);
+                        if (matches) {
+                            const mappingId = matches[1];
+                            formData.append(`details${mappingId}field_value`, input.value);
+                            if (input.tagName === 'SELECT' && input.classList.contains('dropdown-select')) {
+                                input.setAttribute('data-selected-value', input.value);
+                            }
+                        }
+                    });
+                    formData.append('iddatadb', iddatadb);
+
+                    fetch('save_edited_row.php', {
+                            method: 'POST',
+                            body: formData
+                        })
+                        .then(response => {
+                            if (!response.ok) throw new Error(`HTTP error! status: ${response.status}`);
+                            return response.json();
+                        })
+                        .then(data => {
+                            console.log("Save response:", data);
+                            if (data.success) {
+                                const cells = row.querySelectorAll('.grid-cell');
+                                cells.forEach(cell => {
+                                    cell.classList.remove('flash-success');
+                                    void cell.offsetWidth;
+                                    cell.classList.add('flash-success');
+                                });
+                                setTimeout(() => cells.forEach(cell => cell.classList.remove('flash-success')), 500);
+
+                                if (changedFields[rowIndex]) {
+                                    delete changedFields[rowIndex];
+                                    document.querySelectorAll(`.grid-cell[data-row="${rowIndex}"]`)
+                                        .forEach(cell => cell.classList.remove("cell-changed"));
+                                    renderChangedList();
+                                    hasChanges = Object.keys(changedFields).length > 0;
+                                }
+
+                                alert('Salvataggio riga avvenuto con successo!');
+                            } else {
+                                alert('Errore durante il salvataggio: ' + data.message);
+                            }
+                        })
+                        .catch(error => {
+                            console.error("Save error:", error);
+                            alert('Errore durante il salvataggio: ' + error.message);
+                        });
                 });
             });
 
+            document.querySelector('.save-all-btn').addEventListener('click', async () => {
+                console.log("Saving all rows");
+                const rows = document.querySelectorAll('.grid-row');
+                let successCount = 0;
+                let errorMessages = [];
+
+                for (const row of rows) {
+                    const saveBtn = row.querySelector('.save-btn');
+                    if (!saveBtn) {
+                        console.warn(`No save button found in row with data-id: ${row.getAttribute('data-id')}`);
+                        continue;
+                    }
+                    const rowIndex = saveBtn.dataset.row;
+                    const iddatadb = row.getAttribute('data-id');
+                    if (!rowIndex || !iddatadb) {
+                        console.warn(`Missing rowIndex or iddatadb in row:`, row);
+                        continue;
+                    }
+                    console.log(`Processing row ${rowIndex} with iddatadb ${iddatadb}`);
+                    const formData = new FormData();
+
+                    const inputs = row.querySelectorAll(`input[name^="rows[${rowIndex}][details]"], select[name^="rows[${rowIndex}][details]"]`);
+                    inputs.forEach(input => {
+                        const matches = input.name.match(/rows\[\d+\]\[details\]\[(\d+)\]\[field_value\]/);
+                        if (matches) {
+                            const mappingId = matches[1];
+                            formData.append(`details${mappingId}field_value`, input.value);
+                            if (input.tagName === 'SELECT' && input.classList.contains('dropdown-select')) {
+                                input.setAttribute('data-selected-value', input.value);
+                            }
+                        }
+                    });
+                    formData.append('iddatadb', iddatadb);
+
+                    try {
+                        const response = await fetch('save_edited_row.php', {
+                            method: 'POST',
+                            body: formData
+                        });
+                        if (!response.ok) throw new Error(`HTTP error! status: ${response.status}`);
+                        const data = await response.json();
+
+                        console.log(`Row ${rowIndex} save response:`, data);
+                        if (data.success) {
+                            successCount++;
+                            const cells = row.querySelectorAll('.grid-cell');
+                            cells.forEach(cell => {
+                                cell.classList.remove('flash-success');
+                                void cell.offsetWidth;
+                                cell.classList.add('flash-success');
+                            });
+                            setTimeout(() => cells.forEach(cell => cell.classList.remove('flash-success')), 500);
+
+                            if (changedFields[rowIndex]) {
+                                delete changedFields[rowIndex];
+                                document.querySelectorAll(`.grid-cell[data-row="${rowIndex}"]`)
+                                    .forEach(cell => cell.classList.remove("cell-changed"));
+                            }
+                        } else {
+                            errorMessages.push(`Riga ${parseInt(rowIndex) + 1}: ${data.message}`);
+                        }
+                    } catch (error) {
+                        console.error(`Row ${rowIndex} save error:`, error);
+                        errorMessages.push(`Riga ${parseInt(rowIndex) + 1}: ${error.message}`);
+                    }
+                }
+
+                renderChangedList();
+                hasChanges = Object.keys(changedFields).length > 0;
+                console.log(`Save all completed: ${successCount} successes, ${errorMessages.length} errors`);
+
+                if (errorMessages.length === 0) {
+                    alert(`Tutte le ${successCount} righe salvate con successo!`);
+                } else {
+                    alert(`Salvate ${successCount} righe con successo.\nErrori:\n${errorMessages.join('\n')}`);
+                }
+            });
+
             window.addEventListener("beforeunload", function(e) {
                 if (hasChanges) {
                     e.preventDefault();
@@ -724,9 +908,9 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             });
         });
     </script>
-
     <script>
         document.addEventListener("DOMContentLoaded", function() {
+            console.log("Initializing cell expansion and propagation");
             const inputs = document.querySelectorAll('.cell-input');
             inputs.forEach(input => {
                 input.addEventListener('focus', function() {
@@ -737,48 +921,10 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                 });
             });
 
-            const saveButtons = document.querySelectorAll('.save-btn');
-            saveButtons.forEach(button => {
-                button.addEventListener('click', function() {
-                    const rowIndex = this.getAttribute('data-row');
-                    const row = this.closest('.grid-row');
-                    const iddatadb = row.getAttribute('data-id');
-                    const formData = new FormData();
-
-                    const inputs = row.querySelectorAll(`input[name^="rows[${rowIndex}]"], select[name^="rows[${rowIndex}]"]`);
-                    inputs.forEach(input => {
-                        const name = input.name.replace(`rows[${rowIndex}]`, '').replace(/\[|\]/g, '');
-                        formData.append(name, input.value);
-                    });
-                    formData.append('iddatadb', iddatadb);
-                    formData.append('mapping', JSON.stringify(<?= json_encode($allMappings) ?>));
-
-                    fetch('save_edited_row.php', {
-                            method: 'POST',
-                            body: formData
-                        })
-                        .then(response => response.json())
-                        .then(data => {
-                            if (data.success) {
-                                const cells = row.querySelectorAll('.grid-cell');
-                                cells.forEach(cell => {
-                                    cell.classList.remove('flash-success');
-                                    void cell.offsetWidth;
-                                    cell.classList.add('flash-success');
-                                });
-                                setTimeout(() => cells.forEach(cell => cell.classList.remove('flash-success')), 500);
-                                alert('Salvataggio avvenuto con successo!');
-                            } else {
-                                alert('Errore durante il salvataggio: ' + data.message);
-                            }
-                        })
-                        .catch(error => alert('Errore durante il salvataggio: ' + error.message));
-                });
-            });
-
             const propagateButtons = document.querySelectorAll('.propagate-btn');
             propagateButtons.forEach(button => {
                 button.addEventListener('click', function() {
+                    console.log("Propagating value for column:", this.getAttribute('data-column'));
                     const column = this.getAttribute('data-column');
                     const input = this.previousElementSibling;
                     const value = input.value;
@@ -797,6 +943,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                 if (targetInput) {
                                     targetInput.value = value;
                                     if (targetInput.tagName === 'SELECT') {
+                                        targetInput.setAttribute('data-selected-value', value);
                                         const event = new Event('change');
                                         targetInput.dispatchEvent(event);
                                     }
@@ -814,6 +961,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
             let columnIndex = 0;
             resizers.forEach(resizer => {
                 resizer.addEventListener('mousedown', function(e) {
+                    console.log("Starting column resize");
                     currentResizer = resizer;
                     const header = resizer.parentElement;
                     columnIndex = header.getAttribute('data-index');
@@ -836,6 +984,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
 
                 function stopResize() {
                     if (currentResizer) {
+                        console.log("Stopping column resize");
                         document.removeEventListener('mousemove', resize);
                         document.removeEventListener('mouseup', stopResize);
                         currentResizer = null;
@@ -846,11 +995,15 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
     </script>
     <script>
         document.addEventListener("DOMContentLoaded", function() {
+            console.log("Initializing dropdown population");
             const dropdownData = {};
 
             async function populateDropdowns() {
                 const dropdowns = document.querySelectorAll('.dropdown-select');
-                if (dropdowns.length === 0) return;
+                if (dropdowns.length === 0) {
+                    console.log("No dropdowns found");
+                    return;
+                }
 
                 const uniqueFieldIds = [
                     ...new Set(Array.from(dropdowns).map(d => d.getAttribute('data-field-id')))
@@ -859,31 +1012,34 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                 const missingFieldIds = uniqueFieldIds.filter(fieldId => !dropdownData[fieldId]);
 
                 if (missingFieldIds.length > 0) {
+                    console.log("Fetching dropdown data for field IDs:", missingFieldIds);
                     try {
                         const response = await fetch(
                             `get_customfield_values.php?field_ids=${missingFieldIds.join(",")}`
                         );
+                        if (!response.ok) throw new Error(`HTTP error! status: ${response.status}`);
                         const data = await response.json();
 
                         if (data.error) {
-                            console.error("Errore fetch multiplo:", data.error);
+                            console.error("Fetch error:", data.error);
                         } else {
                             for (const fieldId of Object.keys(data)) {
                                 dropdownData[fieldId] = data[fieldId] || [];
                             }
                         }
                     } catch (error) {
-                        console.error("Errore generale nel fetch multiplo:", error);
+                        console.error("Fetch error:", error);
                     }
                 }
 
                 dropdowns.forEach(dropdown => {
                     const fieldId = dropdown.getAttribute('data-field-id');
                     const selectedValue = dropdown.getAttribute('data-selected-value') || '';
-                    const currentValue = dropdown.value; // Preserva il valore corrente
+                    const currentValue = dropdown.value;
 
                     if (!fieldId || !dropdownData[fieldId]) {
                         dropdown.innerHTML = '<option value="">Errore nel caricamento</option>';
+                        console.warn(`No data for fieldId ${fieldId}`);
                         return;
                     }
 
@@ -892,7 +1048,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                         const option = document.createElement('option');
                         option.value = value.IdCustomFieldsValue;
                         option.textContent = value.Valore;
-                        // Usa il valore corrente se disponibile, altrimenti usa data-selected-value
                         if (currentValue && currentValue === String(value.IdCustomFieldsValue)) {
                             option.selected = true;
                         } else if (!currentValue && selectedValue === String(value.IdCustomFieldsValue)) {
@@ -903,87 +1058,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
 
                     if ((currentValue || selectedValue) && dropdown.value !== (currentValue || selectedValue)) {
                         dropdown.value = '';
-                        console.warn(`Valore ${currentValue || selectedValue} non trovato per fieldId ${fieldId}`);
+                        console.warn(`Value ${currentValue || selectedValue} not found for fieldId ${fieldId}`);
                     }
                 });
             }
 
-            // Chiama populateDropdowns solo al caricamento iniziale
             populateDropdowns();
-
-            document.querySelectorAll('.save-btn').forEach(btn => {
-                btn.addEventListener('click', function() {
-                    const rowIndex = this.getAttribute('data-row');
-                    const row = this.closest('.grid-row');
-                    const iddatadb = row.getAttribute('data-id');
-                    const formData = new FormData();
-
-                    const inputs = row.querySelectorAll(`input[name^="rows[${rowIndex}]"], select[name^="rows[${rowIndex}]"]`);
-                    inputs.forEach(input => {
-                        const name = input.name.replace(`rows[${rowIndex}]`, '').replace(/\[|\]/g, '');
-                        formData.append(name, input.value);
-                        // Aggiorna data-selected-value per i dropdown
-                        if (input.tagName === 'SELECT' && input.classList.contains('dropdown-select')) {
-                            input.setAttribute('data-selected-value', input.value);
-                        }
-                    });
-                    formData.append('iddatadb', iddatadb);
-                    formData.append('mapping', JSON.stringify(<?= json_encode($allMappings) ?>));
-
-                    fetch('save_edited_row.php', {
-                            method: 'POST',
-                            body: formData
-                        })
-                        .then(response => response.json())
-                        .then(data => {
-                            if (data.success) {
-                                const cells = row.querySelectorAll('.grid-cell');
-                                cells.forEach(cell => {
-                                    cell.classList.remove('flash-success');
-                                    void cell.offsetWidth;
-                                    cell.classList.add('flash-success');
-                                });
-                                setTimeout(() => cells.forEach(cell => cell.classList.remove('flash-success')), 500);
-                                alert('Salvataggio avvenuto con successo!');
-                            } else {
-                                alert('Errore durante il salvataggio: ' + data.message);
-                            }
-                        })
-                        .catch(error => alert('Errore durante il salvataggio: ' + error.message));
-                });
-            });
-
-            const propagateButtons = document.querySelectorAll('.propagate-btn');
-            propagateButtons.forEach(button => {
-                button.addEventListener('click', function() {
-                    const column = this.getAttribute('data-column');
-                    const input = this.previousElementSibling;
-                    const value = input.value;
-
-                    const gridTopCells = document.querySelector('.grid-top').querySelectorAll('.grid-cell');
-                    const targetTopIndex = Array.from(gridTopCells).findIndex(cell =>
-                        cell.querySelector('.propagate-btn[data-column="' + column + '"]')
-                    );
-
-                    if (targetTopIndex !== -1) {
-                        const rows = document.querySelectorAll('.grid-row');
-                        rows.forEach(row => {
-                            const cells = row.querySelectorAll('.grid-cell');
-                            if (cells.length > targetTopIndex) {
-                                const targetInput = cells[targetTopIndex].querySelector('select.dropdown-select, input');
-                                if (targetInput) {
-                                    targetInput.value = value;
-                                    if (targetInput.tagName === 'SELECT') {
-                                        targetInput.setAttribute('data-selected-value', value); // Aggiorna anche qui
-                                        const event = new Event('change');
-                                        targetInput.dispatchEvent(event);
-                                    }
-                                }
-                            }
-                        });
-                    }
-                });
-            });
         });
     </script>
 </body>

public/userarea/modal_parts.php

@@ -1,4 +1,4 @@
-<!-- Modal -->
+<!-- Modal modificato con pulsante per riconoscimento vocale -->
 <div class="modal fade" id="partsModal" tabindex="-1" aria-labelledby="partsModalLabel" aria-hidden="true">
     <div class="modal-dialog modal-xl" style="max-width: 80% !important; width: 80% !important;">
         <div class="modal-content">
@@ -15,6 +15,7 @@
                                 <input type="checkbox" id="showMixParts" name="showMixParts" style="margin-right: 5px;">
                                 <label for="showMixParts" style="font-size: 0.9rem; margin-right: 10px;">Mix</label>
                                 <button type="button" class="btn btn-info btn-sm" id="renumberPartsBtn" style="padding: 0.1rem 0.5rem; font-size: 0.8rem;">Rinumera Parti</button>
+                                <button type="button" class="btn btn-secondary btn-sm ms-2" id="toggleVoiceBtn" style="padding: 0.1rem 0.5rem; font-size: 0.8rem;"><i class="fas fa-microphone"></i> Voce</button>
                             </div>
                         </div>
                         <ul id="partsList" class="list-group"></ul>

public/userarea/parts.js

@@ -20,6 +20,115 @@ $(document).ready(function () {
     // selection
     let selectedPartNumber = null;
 
+    // ===================
+    // VOICE RECOGNITION SETUP
+    // ===================
+    const SpeechRecognition =
+        window.SpeechRecognition || window.webkitSpeechRecognition;
+    let recognition = null;
+    let isVoiceActive = false;
+    const magicWord = "salva"; // Parola magica scelta: "prossima" (fa andare alla riga successiva)
+
+    if (SpeechRecognition) {
+        recognition = new SpeechRecognition();
+        recognition.lang = "it-IT"; // Lingua italiana
+        recognition.continuous = true; // Ascolto continuo
+        recognition.interimResults = false; // Solo risultati finali per semplicità
+
+        recognition.onresult = function (event) {
+            const transcript = event.results[
+                event.results.length - 1
+            ][0].transcript
+                .trim()
+                .toLowerCase();
+            console.log("Transcript vocale:", transcript);
+
+            const $currentRow = $("#partsTableBody tr:last"); // Ultima riga corrente
+            const $descriptionInput = $currentRow.find(".part-description");
+
+            if (transcript.includes(magicWord)) {
+                // Rimuovi la parola magica e aggiungi il resto alla descrizione corrente
+                const cleanedTranscript = transcript
+                    .replace(magicWord, "")
+                    .trim();
+                if (cleanedTranscript) {
+                    $descriptionInput.val(
+                        (
+                            $descriptionInput.val() +
+                            " " +
+                            cleanedTranscript
+                        ).trim(),
+                    );
+                    $descriptionInput.trigger("blur"); // Salva se necessario
+                }
+                // Aggiungi nuova riga (simile a click su +)
+                const maxPartNumber = Math.max(
+                    ...$("#partsTableBody tr")
+                        .map(function () {
+                            return (
+                                parseInt($(this).find(".part-number").val()) ||
+                                0
+                            );
+                        })
+                        .get(),
+                );
+                addNewRow(maxPartNumber + 1);
+                // Focus sulla nuova descrizione
+                const $newRow = $("#partsTableBody tr:last");
+                $newRow.find(".part-description").focus();
+            } else {
+                // Aggiungi il transcript alla descrizione corrente
+                $descriptionInput.val(
+                    ($descriptionInput.val() + " " + transcript).trim(),
+                );
+                $descriptionInput.trigger("blur"); // Salva se necessario
+            }
+        };
+
+        recognition.onerror = function (event) {
+            console.error("Errore riconoscimento vocale:", event.error);
+            if (event.error === "no-speech" || event.error === "aborted") {
+                // Riavvia se necessario
+                if (isVoiceActive) recognition.start();
+            } else {
+                alert("Errore nel riconoscimento vocale: " + event.error);
+                toggleVoiceRecognition();
+            }
+        };
+
+        recognition.onend = function () {
+            if (isVoiceActive) {
+                recognition.start(); // Riavvia per ascolto continuo
+            }
+        };
+    } else {
+        console.warn("Riconoscimento vocale non supportato dal browser.");
+        $("#toggleVoiceBtn").hide(); // Nascondi pulsante se non supportato
+    }
+
+    function toggleVoiceRecognition() {
+        if (!recognition) return;
+
+        isVoiceActive = !isVoiceActive;
+        const $btn = $("#toggleVoiceBtn");
+        if (isVoiceActive) {
+            $btn.addClass("btn-danger").html(
+                '<i class="fas fa-microphone-slash"></i> Stop Voce',
+            );
+            recognition.start();
+            // Focus iniziale sull'ultima descrizione
+            const $currentRow = $("#partsTableBody tr:last");
+            $currentRow.find(".part-description").focus();
+        } else {
+            $btn.removeClass("btn-danger")
+                .addClass("btn-secondary")
+                .html('<i class="fas fa-microphone"></i> Voce');
+            recognition.stop();
+        }
+    }
+
+    $("#toggleVoiceBtn").on("click", toggleVoiceRecognition);
+
     // ===================
     // POPUP HANDLING
     // ===================
@@ -488,8 +597,13 @@ $(document).ready(function () {
             mix: part.partDescription.startsWith("Mix") ? "Y" : "N",
         }));
 
+        console.log(
+            "Dati inviati a renumber_parts.php:",
+            JSON.stringify({ iddatadb: iddatadb, parts: partsToSave }),
+        );
+
         $.ajax({
-            url: "save_parts.php",
+            url: "renumber_parts.php",
             method: "POST",
             data: JSON.stringify({
                 iddatadb: iddatadb,
@@ -497,12 +611,17 @@ $(document).ready(function () {
             }),
             contentType: "application/json",
             success: function (response) {
+                console.log("Risposta da renumber_parts.php:", response);
                 if (response.success) {
                     $rows.each(function (index) {
                         const $row = $(this);
-                        if (response.part_ids && response.part_ids[index]) {
+                        const newPartId =
-                            $row.attr("data-part-id", response.part_ids[index]);
+                            response.part_ids && response.part_ids[index]
-                            $row.data("part-id", response.part_ids[index]);
+                                ? response.part_ids[index]
+                                : $row.data("part-id");
+                        if (newPartId) {
+                            $row.attr("data-part-id", newPartId);
+                            $row.data("part-id", newPartId);
                         }
                         const $saveStatus = $row.find(".save-status");
                         const $saveLoading = $row.find(".save-loading");
@@ -515,14 +634,21 @@ $(document).ready(function () {
                     updateDescriptions();
                     markUnsaved();
                 } else {
+                    console.error("Errore dal server:", response.message);
                     alert(
-                        "Errore nel salvataggio delle parti: " +
+                        "Errore nella rinumerazione delle parti: " +
                             response.message,
                     );
                 }
             },
             error: function (xhr, status, error) {
-                alert("Errore nel salvataggio delle parti: " + error);
+                console.error("Errore AJAX:", status, error, xhr.responseText);
+                alert(
+                    "Errore nella rinumerazione delle parti: " +
+                        error +
+                        " - " +
+                        xhr.responseText,
+                );
             },
         });
     }

public/userarea/photos.js

@@ -396,11 +396,32 @@ document.addEventListener("DOMContentLoaded", function () {
             closeCollageBtn.addEventListener("click", () => {
                 console.log("Chiusura modale collage");
                 document.getElementById("collageModal").style.display = "none";
+                if (isCropping) {
+                    console.log(
+                        "Chiusura modale durante ritaglio, esco dalla modalità ritaglio",
+                    );
+                    exitCropMode();
+                }
+                if (isRemovingBackground) {
+                    console.log(
+                        "Chiusura modale durante rimozione sfondo, esco dalla modalità",
+                    );
+                    exitBackgroundRemovalMode();
+                }
             });
         }
 
         // Inizializza canvas con Fabric.js
         let canvas;
+        let cropRect = null;
+        let isCropping = false;
+        let croppedImage = null; // Memorizza l'immagine da ritagliare
+        let isApplyingCrop = false; // Flag per prevenire duplicazioni
+        let isRemovingBackground = false; // Flag per modalità rimozione sfondo
+        let backgroundRemovalImage = null; // Immagine in modalità rimozione sfondo
+        let history = []; // Pila per salvare gli stati del canvas
+        const maxHistory = 20; // Limite massimo di stati nella pila
+
         function initCollageCanvas() {
             if (typeof fabric === "undefined") {
                 console.error("Fabric.js non è caricato!");
@@ -413,8 +434,467 @@ document.addEventListener("DOMContentLoaded", function () {
                 backgroundColor: "#fff",
                 selection: true,
             });
+            // Imposta stile globale per i controlli
+            fabric.Object.prototype.set({
+                cornerColor: "black",
+                cornerStrokeColor: "black",
+                cornerSize: 12,
+                borderColor: "black",
+                transparentCorners: false,
+            });
             // Abilita ridimensionamento e trascinamento
-            canvas.on("object:modified", () => canvas.renderAll());
+            canvas.on("object:modified", () => {
+                console.log("Oggetto modificato nel canvas");
+                saveCanvasState();
+                canvas.renderAll();
+            });
+            // Gestisci selezione per abilitare/disabilitare pulsanti
+            canvas.on("selection:created", () => {
+                console.log("Evento selection:created triggerato");
+                updateButtons();
+            });
+            canvas.on("selection:updated", () => {
+                console.log("Evento selection:updated triggerato");
+                updateButtons();
+            });
+            canvas.on("selection:cleared", () => {
+                console.log("Evento selection:cleared triggerato");
+                if (!isCropping && !isRemovingBackground) {
+                    updateButtons();
+                } else if (isCropping && cropRect) {
+                    console.log(
+                        "Ignoro selection:cleared perché in modalità ritaglio",
+                    );
+                    canvas.setActiveObject(cropRect); // Ripristina selezione del rettangolo
+                    canvas.renderAll();
+                } else if (isRemovingBackground) {
+                    console.log(
+                        "Ignoro selection:cleared perché in modalità rimozione sfondo",
+                    );
+                    canvas.setActiveObject(backgroundRemovalImage); // Ripristina selezione dell'immagine
+                    canvas.renderAll();
+                }
+            });
+            // Gestisci click sul canvas per la rimozione dello sfondo
+            canvas.on("mouse:down", (event) => {
+                if (isRemovingBackground && backgroundRemovalImage) {
+                    console.log(
+                        "Click sul canvas in modalità rimozione sfondo",
+                    );
+                    handleBackgroundColorSelection(event);
+                }
+            });
+            // Salva lo stato iniziale del canvas
+            saveCanvasState();
+            // Forza un aggiornamento iniziale dei pulsanti
+            updateButtons();
+        }
+
+        // Salva lo stato del canvas nella pila
+        function saveCanvasState() {
+            if (isCropping || isRemovingBackground) {
+                console.log(
+                    "Non salvo lo stato perché in modalità ritaglio o rimozione sfondo",
+                );
+                return;
+            }
+            console.log("Salvataggio stato del canvas");
+            const state = JSON.stringify(
+                canvas.toJSON([
+                    "cornerColor",
+                    "cornerStrokeColor",
+                    "cornerSize",
+                    "borderColor",
+                    "transparentCorners",
+                ]),
+            );
+            history.push(state);
+            if (history.length > maxHistory) {
+                history.shift(); // Rimuovi lo stato più vecchio se superato il limite
+            }
+            console.log("Stato salvato, lunghezza pila:", history.length);
+            updateButtons();
+        }
+
+        // Ripristina l'ultimo stato del canvas
+        function undo() {
+            if (history.length <= 1) {
+                console.log("Nessuno stato da annullare");
+                return;
+            }
+            console.log("Annullamento ultima azione");
+            history.pop(); // Rimuovi lo stato corrente
+            const previousState = history[history.length - 1];
+            if (previousState) {
+                canvas.clear();
+                canvas.loadFromJSON(previousState, () => {
+                    canvas.renderAll();
+                    console.log("Stato ripristinato");
+                    updateButtons();
+                });
+            } else {
+                console.warn("Nessuno stato precedente disponibile");
+                canvas.clear();
+                canvas.setBackgroundColor("#fff");
+                canvas.renderAll();
+                updateButtons();
+            }
+        }
+
+        // Aggiorna stato dei pulsanti
+        function updateButtons() {
+            const cropBtn = document.getElementById("cropImageBtn");
+            const applyCropBtn = document.getElementById("applyCropBtn");
+            const cancelCropBtn = document.getElementById("cancelCropBtn");
+            const removeBackgroundBtn = document.getElementById(
+                "removeBackgroundBtn",
+            );
+            const removeImageBtn = document.getElementById("removeImageBtn");
+            const undoBtn = document.getElementById("undoBtn");
+            const instruction = document.getElementById(
+                "backgroundRemovalInstruction",
+            );
+            const activeObject = canvas.getActiveObject();
+            console.log(
+                "updateButtons: activeObject =",
+                activeObject ? activeObject.type : null,
+                "isCropping =",
+                isCropping,
+                "isRemovingBackground =",
+                isRemovingBackground,
+                "history.length =",
+                history.length,
+            );
+            if (isCropping && cropRect) {
+                console.log(
+                    "Modo ritaglio attivo, applyCropBtn e cancelCropBtn abilitati",
+                );
+                cropBtn.disabled = true;
+                applyCropBtn.disabled = false;
+                cancelCropBtn.disabled = false;
+                removeBackgroundBtn.disabled = true;
+                removeImageBtn.disabled = true;
+                undoBtn.disabled = true;
+                instruction.style.display = "none";
+            } else if (isRemovingBackground && backgroundRemovalImage) {
+                console.log(
+                    "Modo rimozione sfondo attivo, removeBackgroundBtn disabilitato",
+                );
+                cropBtn.disabled = true;
+                applyCropBtn.disabled = true;
+                cancelCropBtn.disabled = true;
+                removeBackgroundBtn.disabled = true;
+                removeImageBtn.disabled = true;
+                undoBtn.disabled = true;
+                instruction.style.display = "block";
+            } else if (
+                activeObject &&
+                activeObject.type === "image" &&
+                !isCropping &&
+                !isRemovingBackground
+            ) {
+                console.log(
+                    "Abilitazione cropImageBtn, removeBackgroundBtn e removeImageBtn",
+                );
+                cropBtn.disabled = false;
+                applyCropBtn.disabled = true;
+                cancelCropBtn.disabled = true;
+                removeBackgroundBtn.disabled = false;
+                removeImageBtn.disabled = false;
+                undoBtn.disabled = history.length <= 1;
+                instruction.style.display = "none";
+            } else {
+                console.log("Disabilitazione tutti i pulsanti");
+                cropBtn.disabled = true;
+                applyCropBtn.disabled = true;
+                cancelCropBtn.disabled = true;
+                removeBackgroundBtn.disabled = true;
+                removeImageBtn.disabled = true;
+                undoBtn.disabled = history.length <= 1;
+                instruction.style.display = "none";
+            }
+        }
+
+        // Entra in modalità ritaglio
+        function enterCropMode() {
+            const activeObject = canvas.getActiveObject();
+            if (!activeObject || activeObject.type !== "image") {
+                console.warn("Nessuna immagine selezionata per il ritaglio");
+                alert("Seleziona un'immagine prima di attivare il ritaglio!");
+                return;
+            }
+            console.log(
+                "Entrata in modalità ritaglio per immagine:",
+                activeObject,
+            );
+            isCropping = true;
+            croppedImage = activeObject; // Memorizza l'immagine da ritagliare
+            canvas.discardActiveObject(); // Deseleziona l'immagine
+            // Crea un rettangolo di ritaglio
+            cropRect = new fabric.Rect({
+                left: activeObject.left,
+                top: activeObject.top,
+                width: activeObject.width * activeObject.scaleX * 0.5,
+                height: activeObject.height * activeObject.scaleY * 0.5,
+                fill: "rgba(0, 0, 0, 0.3)",
+                stroke: "red",
+                strokeWidth: 2,
+                hasBorders: true,
+                hasControls: true,
+                lockRotation: true,
+                selectable: true,
+                cornerColor: "black",
+                cornerStrokeColor: "black",
+                cornerSize: 12,
+                borderColor: "black",
+                transparentCorners: false,
+            });
+            canvas.add(cropRect);
+            canvas.setActiveObject(cropRect);
+            canvas.renderAll();
+            updateButtons();
+            console.log("Rettangolo di ritaglio creato e applicato");
+        }
+
+        // Esci dalla modalità ritaglio
+        function exitCropMode() {
+            if (cropRect) {
+                console.log("Rimozione rettangolo di ritaglio");
+                canvas.remove(cropRect);
+                cropRect = null;
+            }
+            isCropping = false;
+            croppedImage = null;
+            isApplyingCrop = false;
+            canvas.discardActiveObject();
+            canvas.renderAll();
+            updateButtons();
+            console.log("Uscita dalla modalità ritaglio");
+        }
+
+        // Applica il ritaglio
+        function applyCrop() {
+            if (isApplyingCrop) {
+                console.log("applyCrop già in esecuzione, ignoro chiamata");
+                return;
+            }
+            console.log("applyCrop chiamato, stato:", {
+                isCropping,
+                cropRect: !!cropRect,
+                croppedImage: !!croppedImage,
+            });
+            if (!isCropping || !cropRect || !croppedImage) {
+                console.warn("Condizioni per il ritaglio non soddisfatte", {
+                    isCropping,
+                    cropRect: !!cropRect,
+                    croppedImage: !!croppedImage,
+                });
+                alert(
+                    "Nessun rettangolo di ritaglio attivo o immagine selezionata!",
+                );
+                exitCropMode();
+                return;
+            }
+            isApplyingCrop = true;
+            console.log("Applicazione ritaglio all'immagine:", croppedImage);
+            const img = croppedImage;
+            const cropX = (cropRect.left - img.left) / img.scaleX;
+            const cropY = (cropRect.top - img.top) / img.scaleY;
+            const cropWidth = (cropRect.width * cropRect.scaleX) / img.scaleX;
+            const cropHeight = (cropRect.height * cropRect.scaleY) / img.scaleY;
+            console.log("Parametri di ritaglio:", {
+                cropX,
+                cropY,
+                cropWidth,
+                cropHeight,
+            });
+
+            // Crea un'immagine ritagliata
+            fabric.Image.fromURL(
+                img.getSrc(),
+                (newImg) => {
+                    newImg.set({
+                        left: cropRect.left,
+                        top: cropRect.top,
+                        scaleX: img.scaleX,
+                        scaleY: img.scaleY,
+                        cropX: cropX,
+                        cropY: cropY,
+                        width: cropWidth,
+                        height: cropHeight,
+                        hasControls: true,
+                        hasBorders: true,
+                        cornerColor: "black",
+                        cornerStrokeColor: "black",
+                        cornerSize: 12,
+                        borderColor: "black",
+                        transparentCorners: false,
+                    });
+                    canvas.remove(img); // Rimuovi l'immagine originale
+                    canvas.remove(cropRect); // Rimuovi il rettangolo di ritaglio
+                    canvas.add(newImg); // Aggiungi l'immagine ritagliata
+                    canvas.setActiveObject(newImg);
+                    exitCropMode();
+                    saveCanvasState(); // Salva lo stato dopo il ritaglio
+                    canvas.renderAll();
+                    console.log("Ritaglio applicato con successo");
+                },
+                { crossOrigin: "anonymous" },
+            );
+        }
+
+        // Entra in modalità rimozione sfondo
+        function enterBackgroundRemovalMode() {
+            const activeObject = canvas.getActiveObject();
+            if (!activeObject || activeObject.type !== "image") {
+                console.warn(
+                    "Nessuna immagine selezionata per la rimozione dello sfondo",
+                );
+                alert(
+                    "Seleziona un'immagine prima di attivare la rimozione dello sfondo!",
+                );
+                return;
+            }
+            console.log(
+                "Entrata in modalità rimozione sfondo per immagine:",
+                activeObject,
+            );
+            isRemovingBackground = true;
+            backgroundRemovalImage = activeObject;
+            updateButtons();
+            console.log(
+                "Modalità rimozione sfondo attivata, clicca sull'immagine per selezionare il colore",
+            );
+        }
+
+        // Esci dalla modalità rimozione sfondo
+        function exitBackgroundRemovalMode() {
+            isRemovingBackground = false;
+            backgroundRemovalImage = null;
+            canvas.discardActiveObject();
+            canvas.renderAll();
+            updateButtons();
+            console.log("Uscita dalla modalità rimozione sfondo");
+        }
+
+        // Gestisci la selezione del colore dello sfondo
+        function handleBackgroundColorSelection(event) {
+            if (!isRemovingBackground || !backgroundRemovalImage) {
+                console.warn(
+                    "Condizioni per la rimozione dello sfondo non soddisfatte",
+                );
+                return;
+            }
+            const pointer = canvas.getPointer(event.e);
+            const img = backgroundRemovalImage;
+
+            // Crea una canvas temporanea per ottenere i dati dei pixel
+            const tempCanvas = document.createElement("canvas");
+            tempCanvas.width = img.width;
+            tempCanvas.height = img.height;
+            const ctx = tempCanvas.getContext("2d");
+            ctx.drawImage(img.getElement(), 0, 0, img.width, img.height);
+
+            // Calcola la posizione relativa del click rispetto all'immagine
+            const imgLeft = img.left;
+            const imgTop = img.top;
+            const scaleX = img.scaleX;
+            const scaleY = img.scaleY;
+            const x = (pointer.x - imgLeft) / scaleX;
+            const y = (pointer.y - imgTop) / scaleY;
+
+            // Ottieni il colore del pixel cliccato
+            const pixelData = ctx.getImageData(x, y, 1, 1).data;
+            const targetColor = {
+                r: pixelData[0],
+                g: pixelData[1],
+                b: pixelData[2],
+            };
+            console.log("Colore dello sfondo selezionato:", targetColor);
+
+            // Rimuovi il colore dello sfondo
+            removeBackground(img, targetColor);
+        }
+
+        // Rimuovi il colore dello sfondo
+        function removeBackground(img, targetColor) {
+            console.log("Inizio rimozione sfondo con colore:", targetColor);
+            const tempCanvas = document.createElement("canvas");
+            tempCanvas.width = img.width;
+            tempCanvas.height = img.height;
+            const ctx = tempCanvas.getContext("2d");
+            ctx.drawImage(img.getElement(), 0, 0, img.width, img.height);
+
+            const imageData = ctx.getImageData(
+                0,
+                0,
+                tempCanvas.width,
+                tempCanvas.height,
+            );
+            const data = imageData.data;
+            const tolerance = 50; // Tolleranza per colori simili
+
+            // Scansiona i pixel e rendi trasparenti quelli che corrispondono al colore target
+            for (let i = 0; i < data.length; i += 4) {
+                const r = data[i];
+                const g = data[i + 1];
+                const b = data[i + 2];
+                // Verifica se il colore è simile al targetColor
+                if (
+                    Math.abs(r - targetColor.r) <= tolerance &&
+                    Math.abs(g - targetColor.g) <= tolerance &&
+                    Math.abs(b - targetColor.b) <= tolerance
+                ) {
+                    data[i + 3] = 0; // Imposta l'alpha a 0 (trasparente)
+                }
+            }
+
+            ctx.putImageData(imageData, 0, 0);
+            const newImageUrl = tempCanvas.toDataURL("image/png");
+
+            // Crea una nuova immagine con lo sfondo rimosso
+            fabric.Image.fromURL(
+                newImageUrl,
+                (newImg) => {
+                    newImg.set({
+                        left: img.left,
+                        top: img.top,
+                        scaleX: img.scaleX,
+                        scaleY: img.scaleY,
+                        hasControls: true,
+                        hasBorders: true,
+                        cornerColor: "black",
+                        cornerStrokeColor: "black",
+                        cornerSize: 12,
+                        borderColor: "black",
+                        transparentCorners: false,
+                    });
+                    canvas.remove(img); // Rimuovi l'immagine originale
+                    canvas.add(newImg); // Aggiungi l'immagine con sfondo rimosso
+                    canvas.setActiveObject(newImg);
+                    exitBackgroundRemovalMode();
+                    saveCanvasState(); // Salva lo stato dopo la rimozione dello sfondo
+                    canvas.renderAll();
+                    console.log("Sfondo rimosso con successo");
+                },
+                { crossOrigin: "anonymous" },
+            );
+        }
+
+        // Rimuovi l'immagine selezionata
+        function removeImage() {
+            const activeObject = canvas.getActiveObject();
+            if (!activeObject || activeObject.type !== "image") {
+                console.warn("Nessuna immagine selezionata per la rimozione");
+                alert("Seleziona un'immagine da rimuovere!");
+                return;
+            }
+            console.log("Rimozione immagine selezionata:", activeObject);
+            canvas.remove(activeObject);
+            canvas.discardActiveObject();
+            saveCanvasState(); // Salva lo stato dopo la rimozione
+            canvas.renderAll();
+            console.log("Immagine rimossa con successo");
         }
 
         // Aggiungi foto selezionate al canvas
@@ -430,21 +910,35 @@ document.addEventListener("DOMContentLoaded", function () {
                 }
                 checkboxes.forEach((cb) => {
                     const imgPath = cb.getAttribute("data-path");
-                    fabric.Image.fromURL(imgPath, (img) => {
+                    fabric.Image.fromURL(
-                        img.set({
+                        imgPath,
-                            left: Math.random() * 600, // Posizione random iniziale
+                        (img) => {
-                            top: Math.random() * 400,
+                            img.set({
-                            scaleX: 0.5, // Scala iniziale
+                                left: Math.random() * 600, // Posizione random iniziale
-                            scaleY: 0.5,
+                                top: Math.random() * 400,
-                            hasControls: true, // Abilita resize/rotate
+                                scaleX: 0.5, // Scala iniziale
-                            hasBorders: true,
+                                scaleY: 0.5,
-                        });
+                                hasControls: true, // Abilita resize/rotate
-                        canvas.add(img);
+                                hasBorders: true,
-                        canvas.renderAll();
+                                cornerColor: "black",
-                    });
+                                cornerStrokeColor: "black",
+                                cornerSize: 12,
+                                borderColor: "black",
+                                transparentCorners: false,
+                            });
+                            canvas.add(img);
+                            canvas.renderAll();
+                            console.log(
+                                "Immagine aggiunta al canvas:",
+                                imgPath,
+                            );
+                        },
+                        { crossOrigin: "anonymous" },
+                    );
                 });
                 // Deseleziona checkbox dopo aggiunta
                 checkboxes.forEach((cb) => (cb.checked = false));
+                saveCanvasState(); // Salva lo stato dopo l'aggiunta
             });
         }
 
@@ -470,6 +964,7 @@ document.addEventListener("DOMContentLoaded", function () {
                 // Chiudi modale e ricarica popup
                 document.getElementById("collageModal").style.display = "none";
                 loadPopupContent(iddatadb);
+                console.log("Collage salvato e modale chiuso");
             });
         }
 
@@ -479,7 +974,10 @@ document.addEventListener("DOMContentLoaded", function () {
             clearCanvasBtn.addEventListener("click", () => {
                 canvas.clear();
                 canvas.setBackgroundColor("#fff");
+                history = []; // Resetta la pila di stati
+                saveCanvasState(); // Salva lo stato vuoto
                 canvas.renderAll();
+                console.log("Canvas pulito");
             });
         }
 
@@ -491,6 +989,8 @@ document.addEventListener("DOMContentLoaded", function () {
                 if (activeObject) {
                     canvas.bringToFront(activeObject);
                     canvas.renderAll();
+                    saveCanvasState(); // Salva lo stato dopo il cambio di livello
+                    console.log("Oggetto portato in primo piano");
                 } else {
                     alert("Seleziona un'immagine sul canvas!");
                 }
@@ -504,6 +1004,8 @@ document.addEventListener("DOMContentLoaded", function () {
                 if (activeObject) {
                     canvas.sendToBack(activeObject);
                     canvas.renderAll();
+                    saveCanvasState(); // Salva lo stato dopo il cambio di livello
+                    console.log("Oggetto mandato in fondo");
                 } else {
                     alert("Seleziona un'immagine sul canvas!");
                 }
@@ -517,6 +1019,8 @@ document.addEventListener("DOMContentLoaded", function () {
                 if (activeObject) {
                     canvas.bringForward(activeObject);
                     canvas.renderAll();
+                    saveCanvasState(); // Salva lo stato dopo il cambio di livello
+                    console.log("Oggetto spostato avanti di un livello");
                 } else {
                     alert("Seleziona un'immagine sul canvas!");
                 }
@@ -530,12 +1034,68 @@ document.addEventListener("DOMContentLoaded", function () {
                 if (activeObject) {
                     canvas.sendBackwards(activeObject);
                     canvas.renderAll();
+                    saveCanvasState(); // Salva lo stato dopo il cambio di livello
+                    console.log("Oggetto spostato indietro di un livello");
                 } else {
                     alert("Seleziona un'immagine sul canvas!");
                 }
             });
         }
 
+        // Gestione ritaglio immagini
+        const cropImageBtn = document.getElementById("cropImageBtn");
+        if (cropImageBtn) {
+            cropImageBtn.addEventListener("click", () => {
+                console.log("Pulsante Ritaglia cliccato");
+                enterCropMode();
+            });
+        }
+
+        const applyCropBtn = document.getElementById("applyCropBtn");
+        if (applyCropBtn) {
+            applyCropBtn.addEventListener("click", () => {
+                console.log("Pulsante Applica Ritaglio cliccato");
+                applyCrop();
+            });
+        }
+
+        const cancelCropBtn = document.getElementById("cancelCropBtn");
+        if (cancelCropBtn) {
+            cancelCropBtn.addEventListener("click", () => {
+                console.log("Pulsante Annulla Ritaglio cliccato");
+                exitCropMode();
+            });
+        }
+
+        // Gestione rimozione sfondo
+        const removeBackgroundBtn = document.getElementById(
+            "removeBackgroundBtn",
+        );
+        if (removeBackgroundBtn) {
+            removeBackgroundBtn.addEventListener("click", () => {
+                console.log("Pulsante Rimuovi Sfondo cliccato");
+                enterBackgroundRemovalMode();
+            });
+        }
+
+        // Gestione rimozione immagine
+        const removeImageBtn = document.getElementById("removeImageBtn");
+        if (removeImageBtn) {
+            removeImageBtn.addEventListener("click", () => {
+                console.log("Pulsante Rimuovi Immagine cliccato");
+                removeImage();
+            });
+        }
+
+        // Gestione undo
+        const undoBtn = document.getElementById("undoBtn");
+        if (undoBtn) {
+            undoBtn.addEventListener("click", () => {
+                console.log("Pulsante Annulla cliccato");
+                undo();
+            });
+        }
+
         // Assicurati che il loader sia nascosto all'apertura del popup
         const loader = document.getElementById("loader");
         if (loader) {

public/userarea/photos_popup.php

@@ -4,6 +4,8 @@ include('include/headscript.php');
 // Includi Fabric.js solo per questa pagina
 ?>
 
+<script src="https://cdnjs.cloudflare.com/ajax/libs/fabric.js/5.3.1/fabric.min.js"></script>
+
 <?php
 // Includi l'autoloader di Composer
 require_once __DIR__ . '/../../vendor/autoload.php';
@@ -171,7 +173,7 @@ $result->saveToFile($qrCodeFile);
         <img id="enlargedImage" class="image-modal-content" src="" alt="Immagine ingrandita">
     </div>
 
-    <!-- Nuovo modale per collage -->
+    <!-- Modale per collage -->
     <div id="collageModal" class="modal" style="display: none; position: fixed; z-index: 1002; left: 0; top: 0; width: 100%; height: 100%; overflow: auto; background-color: rgba(0,0,0,0.8);">
         <div class="modal-content" style="background: white; margin: 5% auto; padding: 20px; width: 80%; max-width: 1200px; position: relative;">
             <span class="close-collage" style="position: absolute; top: 10px; right: 20px; font-size: 30px; cursor: pointer;">&times;</span>
@@ -194,13 +196,20 @@ $result->saveToFile($qrCodeFile);
             <canvas id="collageCanvas" width="800" height="600" style="border: 1px solid #ccc; margin-top: 20px;"></canvas>
 
             <!-- Bottoni azioni -->
-            <div style="margin-top: 20px;">
+            <div style="margin-top: 20px; display: flex; flex-wrap: wrap; gap: 5px;">
-                <button id="saveCollageBtn">Salva Collage</button>
+                <button id="saveCollageBtn" title="Salva il collage"><i class="fas fa-save"></i></button>
-                <button id="clearCanvasBtn">Pulisci Canvas</button>
+                <!-- <button id="clearCanvasBtn" title="Pulisci il canvas"><i class="fas fa-trash"></i></button> -->
-                <button id="bringToFrontBtn" title="Porta in primo piano">In Alto</button>
+                <button id="bringToFrontBtn" title="Porta in primo piano"><i class="fas fa-arrow-up"></i></button>
-                <button id="sendToBackBtn" title="Manda in fondo">In Fondo</button>
+                <button id="sendToBackBtn" title="Manda in fondo"><i class="fas fa-arrow-down"></i></button>
-                <button id="bringForwardBtn" title="Sposta avanti di un livello">Avanti</button>
+                <button id="bringForwardBtn" title="Sposta avanti di un livello"><i class="fas fa-arrow-circle-up"></i></button>
-                <button id="sendBackwardBtn" title="Sposta indietro di un livello">Indietro</button>
+                <button id="sendBackwardBtn" title="Sposta indietro di un livello"><i class="fas fa-arrow-circle-down"></i></button>
+                <button id="cropImageBtn" title="Ritaglia immagine selezionata" disabled><i class="fas fa-crop"></i></button>
+                <button id="applyCropBtn" title="Applica ritaglio" disabled><i class="fas fa-crop"></i> Applica</button>
+                <button id="cancelCropBtn" title="Annulla ritaglio" disabled><i class="fas fa-crop"></i> Annulla</button>
+                <button id="removeBackgroundBtn" title="Rimuovi sfondo immagine selezionata" disabled><i class="fas fa-eraser"></i> Rimuovi Sfondo</button>
+                <button id="removeImageBtn" title="Rimuovi immagine selezionata" disabled><i class="fas fa-trash-alt"></i> Rimuovi</button>
+                <button id="undoBtn" title="Annulla ultima azione" disabled><i class="fas fa-undo"></i></button>
+                <p id="backgroundRemovalInstruction" style="display: none; color: #007bff;">Clicca sull'immagine per selezionare il colore dello sfondo da rimuovere</p>
             </div>
         </div>
     </div>
@@ -283,4 +292,56 @@ $result->saveToFile($qrCodeFile);
         font-size: 16px;
         color: white;
     }
+
+    /* Stile per i pulsanti del modale collage */
+    #collageModal button {
+        padding: 8px 12px;
+        margin: 5px;
+        border: none;
+        cursor: pointer;
+        border-radius: 4px;
+        display: flex;
+        align-items: center;
+        gap: 5px;
+        font-size: 14px;
+    }
+
+    #saveCollageBtn {
+        background: #28a745;
+        color: white;
+    }
+
+    #clearCanvasBtn {
+        background: #dc3545;
+        color: white;
+    }
+
+    #bringToFrontBtn,
+    #sendToBackBtn,
+    #bringForwardBtn,
+    #sendBackwardBtn {
+        background: #007bff;
+        color: white;
+        padding: 8px;
+        /* Pulsanti solo icona più piccoli */
+    }
+
+    #cropImageBtn,
+    #applyCropBtn,
+    #cancelCropBtn,
+    #removeBackgroundBtn,
+    #removeImageBtn,
+    #undoBtn {
+        background: #ffc107;
+        color: white;
+    }
+
+    #collageModal button:disabled {
+        background: #ccc;
+        cursor: not-allowed;
+    }
+
+    #collageModal button i {
+        font-size: 16px;
+    }
 </style>

public/userarea/renumber_parts.php

@@ -0,0 +1,63 @@
+<?php
+header('Content-Type: application/json');
+include('include/headscript.php');
+
+$dbHandler = DBHandlerSelect::getInstance();
+$pdo = $dbHandler->getConnection();
+
+$data = json_decode(file_get_contents('php://input'), true);
+
+$iddatadb = $data['iddatadb'] ?? null;
+$parts = $data['parts'] ?? [];
+
+if (!$iddatadb || empty($parts)) {
+    echo json_encode(['success' => false, 'message' => 'Dati mancanti']);
+    exit;
+}
+
+try {
+    $pdo->beginTransaction();
+
+    // Elimina tutte le parti esistenti per l'iddatadb per evitare conflitti di unicità
+    $stmt = $pdo->prepare("DELETE FROM identification_parts WHERE iddatadb = :iddatadb");
+    $stmt->execute([':iddatadb' => $iddatadb]);
+
+    // Prepara l'inserimento delle nuove parti
+    $stmt = $pdo->prepare("
+        INSERT INTO identification_parts
+        (iddatadb, part_number, part_description, mix, created_at, updated_at)
+        VALUES (:iddatadb, :part_number, :part_description, :mix, NOW(), NOW())
+    ");
+
+    $part_ids = [];
+    foreach ($parts as $part) {
+        $partNumber = $part['part_number'] ?? null;
+        $partDescription = $part['part_description'] ?? '';
+        $mix = $part['mix'] ?? 'N';
+
+        if (!$partNumber || !$partDescription) {
+            throw new PDOException("Numero parte o descrizione mancante per parte: " . json_encode($part));
+        }
+
+        $stmt->execute([
+            ':iddatadb' => $iddatadb,
+            ':part_number' => $partNumber,
+            ':part_description' => $partDescription,
+            ':mix' => $mix
+        ]);
+        $part_ids[] = $pdo->lastInsertId();
+    }
+
+    $pdo->commit();
+    echo json_encode([
+        'success' => true,
+        'part_ids' => $part_ids,
+        'message' => 'Parti rinumerate con successo'
+    ]);
+} catch (PDOException $e) {
+    $pdo->rollBack();
+    echo json_encode([
+        'success' => false,
+        'message' => 'Errore nel salvataggio: ' . $e->getMessage()
+    ]);
+}