fixed for matrici

fixed nologin
added nologin
2025-10-03 08:52:37 +02:00 · 2025-09-27 13:38:26 +02:00 · 2025-09-27 13:37:37 +02:00 · 2025-09-27 13:36:26 +02:00 · 2025-09-27 13:33:23 +02:00 · 2025-09-27 13:28:21 +02:00
18 changed files with 938 additions and 173 deletions
@@ -0,0 +1,131 @@
+<?php
+require_once "class/VisualLimsApiClient.class.php";
+include('include/headscript.php');
+
+$dbHandler = DBHandlerSelect::getInstance();
+$pdo = $dbHandler->getConnection();
+
+header("Content-Type: application/json");
+
+// 🔹 Configura directory log (creala se non esiste)
+$logDir = __DIR__ . '/logs/api/';
+if (!is_dir($logDir)) {
+    mkdir($logDir, 0755, true);
+}
+
+// 🔹 Base URL API
+$apiBaseUrl = 'https://93.43.5.102/limsapi/api/odata/';
+
+// 🔹 Hardcoded values
+$iddatadb = 846;
+$commessaId = 533357;
+
+try {
+    // 🔹 STEP 4: Fetch Field Values with Labels (usa dati reali per iddatadb=845)
+    $stmt = $pdo->prepare("
+        SELECT
+          idd.field_value,
+          m.field_label,
+          m.schema_id,
+          m.field_id
+        FROM
+          import_data_details as idd
+          JOIN template_mapping m ON idd.mapping_id = m.id
+        WHERE idd.id = :iddatadb
+    ");
+    $stmt->execute(['iddatadb' => $iddatadb]);
+    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
+
+    $fieldValues = [];
+    $valueMap = [];  // Mappa per field_id -> valore
+    foreach ($rows as $row) {
+        $fieldValues[] = [
+            "IdCommesseCustomFields" => (int) $row['field_id'],
+            "Valore" => $row['field_value'],
+            "FieldLabel" => $row['field_label']
+        ];
+        $valueMap[(int) $row['field_id']] = $row['field_value'];  // Mappa per ID definizione
+    }
+
+    // Logga i fieldValues in error_log
+    $logFieldValues = "FieldValues dal DB (iddatadb={$iddatadb}):\n" . json_encode($fieldValues, JSON_PRETTY_PRINT);
+    error_log($logFieldValues);
+
+    // 🔹 Initialize API client
+    $api = VisualLimsApiClient::getInstance();
+
+    // 🔹 STEP A: GET iniziale per CommesseCustomFields con espansione CustomField
+    $expand = "CommesseCustomFields(\$expand=CustomField)";  // Espansione come da istruzioni fornitore
+    $commessaWithFields = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=" . $expand);
+
+    // 🔹 STEP B: Prepara payload PATCH (tutti i campi, sovrascrivi se match su CustomField.IdCustomField == field_id)
+    $commessaCustomFields = [];
+    foreach ($commessaWithFields["CommesseCustomFields"] as $customField) {
+        $definitionId = (int) ($customField["CustomField"]["IdCustomField"] ?? 0);  // Usa IdCustomField dal CustomField
+        $currentValue = $customField["Valore"] ?? '';
+        $newValue = isset($valueMap[$definitionId]) ? $valueMap[$definitionId] : $currentValue;
+
+        $commessaCustomFields[] = [
+            "IdCommesseCustomFields" => (int) $customField["IdCommesseCustomFields"],
+            "Valore" => $newValue
+        ];
+    }
+
+    // 🔹 Unico file di log per tutto
+    $logFile = $logDir . "commessa_{$commessaId}_patch_and_get_" . time() . ".txt";
+    $logContent = "FieldValues dal DB (iddatadb={$iddatadb}):\n" . json_encode($fieldValues, JSON_PRETTY_PRINT) . "\n\n";
+
+    // Log curl-like per GET iniziale
+    $logContent .= "GET iniziale:\n" .
+        "curl --location --request GET '{$apiBaseUrl}CommessaWeb({$commessaId})?\$expand=CommesseCustomFields(\$expand=CustomField)' \\\n" .
+        "--header 'Authorization: Bearer ••••••'\n\n" .
+        "RESPONSE:\n" . json_encode($commessaWithFields, JSON_PRETTY_PRINT) . "\n\n---\n";
+
+    if (!empty($commessaCustomFields)) {
+        $updatePayload = ["CommesseCustomFields" => $commessaCustomFields];
+
+        // Log curl-like per PATCH
+        $jsonPayload = json_encode($updatePayload, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
+        $logContent .= "PATCH:\n" .
+            "curl --location --request PATCH '{$apiBaseUrl}CommessaWeb({$commessaId})' \\\n" .
+            "--header 'Content-Type: application/json' \\\n" .
+            "--header 'Authorization: Bearer ••••••' \\\n" .
+            "--data '{$jsonPayload}'\n\n";
+
+        $patchResponse = $api->patch("CommessaWeb({$commessaId})", $updatePayload);
+
+        $logContent .= "PATCH RESPONSE:\n" . json_encode($patchResponse, JSON_PRETTY_PRINT) . "\n\n---\n";
+    } else {
+        $logContent .= "PATCH: Nessun campo custom da aggiornare\n\n---\n";
+    }
+
+    // 🔹 STEP C: GET di controllo post-PATCH
+    $commessaAfterPatch = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=" . $expand);
+
+    // Log curl-like per GET di controllo
+    $logContent .= "GET di controllo:\n" .
+        "curl --location --request GET '{$apiBaseUrl}CommessaWeb({$commessaId})?\$expand=CommesseCustomFields(\$expand=CustomField)' \\\n" .
+        "--header 'Authorization: Bearer ••••••'\n\n" .
+        "RESPONSE:\n" . json_encode($commessaAfterPatch, JSON_PRETTY_PRINT);
+
+    // Salva log unico
+    file_put_contents($logFile, $logContent);
+
+    // 🔹 Output a schermo
+    echo json_encode([
+        "success" => true,
+        "message" => "PATCH eseguito su commessa {$commessaId} con dati da iddatadb {$iddatadb}",
+        "commessaAfterPatch" => $commessaAfterPatch,
+        "totalCustomFieldsUpdated" => count($commessaCustomFields),
+        "fieldValues" => $fieldValues,
+        "logFile" => $logFile
+    ]);
+} catch (Exception $e) {
+    error_log("Patch Error: " . $e->getMessage() . "\nTrace: " . $e->getTraceAsString());
+
+    echo json_encode([
+        "success" => false,
+        "message" => "Patch failed: " . $e->getMessage(),
+        "logFile" => $logFile ?? 'Nessun log generato'
+    ]);
+}
@@ -48,7 +48,7 @@ $routines = $stmt->fetchAll(PDO::FETCH_ASSOC);
            <div class="page-content">
                <div class="card mb-4">
                    <div class="card-header">
-                        <h5 class="mb-0">UpdateXLS Template</h5>
+                        <h5 class="mb-0">Update XLS Template</h5>
                    </div>
                    <div class="card-body">
                        <p class="mb-2">Edit the following form in order to update the selected import XLS template</p>
@@ -99,6 +99,30 @@ $routines = $stmt->fetchAll(PDO::FETCH_ASSOC);
                                    <input type="text" name="target_table" class="form-control" value="<?php echo htmlspecialchars($template['target_table']); ?>" readonly required>
                                </div>

+                                <div class="mb-3">
+                                    <label class="form-label">Button Size</label>
+                                    <select name="button_size" class="form-control">
+                                        <option value="small" <?php echo ($template['button_size'] ?? 'medium') === 'small' ? 'selected' : ''; ?>>Small</option>
+                                        <option value="medium" <?php echo ($template['button_size'] ?? 'medium') === 'medium' ? 'selected' : ''; ?>>Medium</option>
+                                        <option value="large" <?php echo ($template['button_size'] ?? 'medium') === 'large' ? 'selected' : ''; ?>>Large</option>
+                                    </select>
+                                </div>
+
+                                <div class="mb-3">
+                                    <label class="form-label">Button Background Color</label>
+                                    <input type="color" name="button_bg_color" class="form-control" value="<?php echo htmlspecialchars($template['button_bg_color'] ?? '#007bff'); ?>">
+                                </div>
+
+                                <div class="mb-3">
+                                    <label class="form-label">Button Text Color</label>
+                                    <input type="color" name="button_text_color" class="form-control" value="<?php echo htmlspecialchars($template['button_text_color'] ?? '#ffffff'); ?>">
+                                </div>
+
+                                <div class="mb-3">
+                                    <label class="form-label">Button Label</label>
+                                    <input type="text" name="button_label" class="form-control" value="<?php echo htmlspecialchars($template['button_label'] ?? 'Click Me'); ?>">
+                                </div>
+
                                <div class="mb-3">
                                    <label class="form-label">Select Client *</label>
                                    <select name="client_id" id="clientSelect" class="form-control" required>
@@ -7,6 +7,26 @@ $pdo = $dbHandler->getConnection();

 header("Content-Type: application/json");

+// 🔹 Configura directory log (creala se non esiste)
+$logDir = __DIR__ . '/logs/api/';
+if (!is_dir($logDir)) {
+    mkdir($logDir, 0755, true);
+}
+
+// 🔹 Base URL API
+$apiBaseUrl = 'https://93.43.5.102/limsapi/api/odata/';
+
+// 🔹 Funzione per validare e convertire date
+function validateDate($value)
+{
+    // Prova a validare come data (accetta formati comuni)
+    $date = DateTime::createFromFormat('Y-m-d', $value) ?: DateTime::createFromFormat('Y-m-d H:i:s', $value);
+    if ($date) {
+        return $date->format('Y-m-d\TH:i:sP'); // Formato ISO 8601
+    }
+    return null; // Imposta null se non è una data valida
+}
+
 try {
    $iddatadb = $_POST['iddatadb'] ?? null;
    if (!$iddatadb) {
@@ -56,13 +76,20 @@ try {
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

    $fieldValues = [];
+    $valueMap = [];
    foreach ($rows as $row) {
        $fieldValues[] = [
            "IdCommesseCustomFields" => (int) $row['field_id'],
-            "Valore" => $row['field_value']
+            "Valore" => $row['field_value'],
+            "FieldLabel" => $row['field_label']
        ];
+        $valueMap[(int) $row['field_id']] = $row['field_value'];
    }

+    // Logga i fieldValues in error_log
+    $logFieldValues = "FieldValues dal DB (iddatadb={$iddatadb}):\n" . json_encode($fieldValues, JSON_PRETTY_PRINT);
+    error_log($logFieldValues);
+
    // 🔹 Initialize API client
    $api = VisualLimsApiClient::getInstance();

@@ -73,14 +100,29 @@ try {
        "Richiedente" => "Test Web Import",
        "Descrizione" => "TEST CommessaWeb",
    ];
+
+    // Costruisci log curl-like per STEP 5
+    $jsonPayload = json_encode($commessaWebPayload, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
+    $logContentStep5 = "curl --location --request POST '{$apiBaseUrl}CommessaWeb' \\\n" .
+        "--header 'Content-Type: application/json' \\\n" .
+        "--header 'Authorization: Bearer ••••••' \\\n" .
+        "--data '{$jsonPayload}'";
+
    $commessaWeb = $api->post("CommessaWeb", $commessaWebPayload);

+    $logContentStep5 .= "\n\nRESPONSE:\n" . json_encode($commessaWeb, JSON_PRETTY_PRINT);
+
+    // Salva log
+    $logFileStep5 = $logDir . "commessa_create_step5_" . $iddatadb . "_" . time() . ".txt";
+    file_put_contents($logFileStep5, $logContentStep5);
+
    $commessaId = $commessaWeb["IdCommessa"];
-    // Estraiamo il numero della commessa usando CodiceCommessa
    $commessaWebCode = substr($commessaWeb["CodiceCommessa"] ?? "TEST CommessaWeb", 0, 30); // Limite a 30 caratteri

    // 🔹 STEP 6: Create Campioni (Samples) for each part
    $campioni = [];
+    $logContentStep6 = "";
+
    foreach ($parts as $index => $part) {
        $matriceId = (int) ($part["idmatrice"] ?? 0);

@@ -96,8 +138,18 @@ try {
            "NoteWeb" => $part["part_description"] ?? ""
        ];

+        // Costruisci curl-like per questo campione
+        $jsonPayload = json_encode($campionePayload, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
+        $logContentStep6 .= "CAMPIONE #{$index}\n" .
+            "curl --location --request POST '{$apiBaseUrl}Campione' \\\n" .
+            "--header 'Content-Type: application/json' \\\n" .
+            "--header 'Authorization: Bearer ••••••' \\\n" .
+            "--data '{$jsonPayload}'\n\n";
+
        $campione = $api->post("Campione", $campionePayload);

+        $logContentStep6 .= "RESPONSE:\n" . json_encode($campione, JSON_PRETTY_PRINT) . "\n\n---\n";
+
        $campione["PartNumber"] = $part["part_number"] ?? "";
        $campione["Material"] = $part["material"] ?? "";
        $campione["Color"] = $part["color"] ?? "";
@@ -106,25 +158,58 @@ try {
        $campioni[] = $campione;
    }

+    // Salva log per STEP 6
+    $logFileStep6 = $logDir . "commessa_{$commessaId}_campioni_step6_" . time() . ".txt";
+    file_put_contents($logFileStep6, $logContentStep6);
+
    // 🔹 STEP 7: Update Custom Fields for CommessaWeb
    if (!empty($fieldValues)) {
-        $commessaWithFields = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=CommesseCustomFields");
+        // GET con espansione per CustomField
+        $expand = "CommesseCustomFields(\$expand=CustomField)";
+        $commessaWithFields = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=" . $expand);
+
+        // Logga il GET
+        $logContentGet = "curl --location --request GET '{$apiBaseUrl}CommessaWeb({$commessaId})?\$expand=CommesseCustomFields(\$expand=CustomField)' \\\n" .
+            "--header 'Authorization: Bearer ••••••'\n\n" .
+            "RESPONSE:\n" . json_encode($commessaWithFields, JSON_PRETTY_PRINT);
+        $logFileGet = $logDir . "commessa_{$commessaId}_get_step7_" . time() . ".txt";
+        file_put_contents($logFileGet, $logContentGet);
+
+        // Prepara payload PATCH
        $commessaCustomFields = [];
        foreach ($commessaWithFields["CommesseCustomFields"] as $customField) {
-            foreach ($fieldValues as $fieldValue) {
-                if ($customField["IdCommesseCustomFields"] == $fieldValue["IdCommesseCustomFields"]) {
-                    $commessaCustomFields[] = [
-                        "IdCommesseCustomFields" => $customField["IdCommesseCustomFields"],
-                        "Valore" => $fieldValue["Valore"]
-                    ];
-                    break;
-                }
+            $definitionId = (int) ($customField["CustomField"]["IdCustomField"] ?? 0);
+            $fieldId = (int) $customField["IdCommesseCustomFields"];
+            $currentValue = $customField["Valore"] ?? '';
+            $fieldType = $customField["CustomField"]["Tipo"] ?? '';
+            $newValue = isset($valueMap[$definitionId]) ? $valueMap[$definitionId] : $currentValue;
+
+            // Valida se il campo è di tipo Data
+            if ($fieldType === 'Data' && $newValue !== $currentValue) {
+                $newValue = validateDate($newValue);
            }
+
+            $commessaCustomFields[] = [
+                "IdCommesseCustomFields" => $fieldId,
+                "Valore" => $newValue
+            ];
        }

        if (!empty($commessaCustomFields)) {
            $updatePayload = ["CommesseCustomFields" => $commessaCustomFields];
-            $api->patch("CommessaWeb({$commessaId})", $updatePayload);
+
+            // Logga payload e response
+            $jsonPayload = json_encode($updatePayload, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
+            $logContentStep7 = "curl --location --request PATCH '{$apiBaseUrl}CommessaWeb({$commessaId})' \\\n" .
+                "--header 'Content-Type: application/json' \\\n" .
+                "--header 'Authorization: Bearer ••••••' \\\n" .
+                "--data '{$jsonPayload}'";
+
+            $patchResponse = $api->patch("CommessaWeb({$commessaId})", $updatePayload);
+
+            $logContentStep7 .= "\n\nRESPONSE:\n" . json_encode($patchResponse, JSON_PRETTY_PRINT);
+            $logFileStep7 = $logDir . "commessa_{$commessaId}_update_step7_" . time() . ".txt";
+            file_put_contents($logFileStep7, $logContentStep7);
        }
    }

@@ -140,18 +225,40 @@ try {
        'iddatadb' => $iddatadb
    ]);

-    // 🔹 STEP 9: Send CommessaWeb to laboratory
+    // 🔹 STEP 9: Send CommessaWeb to laboratory (commentato come richiesto)
+    /*
    $sendResult = $api->post("CommessaWeb({$commessaId})/InviaCommessa", []);

-    // 🔹 STEP 10: Prepare final response
+    // Logga il POST
+    $logContentStep9 = "curl --location --request POST '{$apiBaseUrl}CommessaWeb({$commessaId})/InviaCommessa' \\\n" .
+                       "--header 'Content-Type: application/json' \\\n" .
+                       "--header 'Authorization: Bearer ••••••' \\\n" .
+                       "--data '{}'\n\n" .
+                       "RESPONSE:\n" . json_encode($sendResult, JSON_PRETTY_PRINT);
+    $logFileStep9 = $logDir . "commessa_{$commessaId}_send_step9_" . time() . ".txt";
+    file_put_contents($logFileStep9, $logContentStep9);
+    */
+
+    // 🔹 STEP 10: GET di controllo post-PATCH
+    $expand = "CommesseCustomFields(\$expand=CustomField)";
+    $commessaAfterPatch = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=" . $expand);
+
+    // Logga il GET di controllo
+    $logContentStep10 = "curl --location --request GET '{$apiBaseUrl}CommessaWeb({$commessaId})?\$expand=CommesseCustomFields(\$expand=CustomField)' \\\n" .
+        "--header 'Authorization: Bearer ••••••'\n\n" .
+        "RESPONSE:\n" . json_encode($commessaAfterPatch, JSON_PRETTY_PRINT);
+    $logFileStep10 = $logDir . "commessa_{$commessaId}_get_step10_" . time() . ".txt";
+    file_put_contents($logFileStep10, $logContentStep10);
+
+    // 🔹 STEP 11: Prepare final response
    $finalCommessa = [
        "Cliente" => $clienteId,
        "SchemaCustomField" => $schemaId,
        "Richiedente" => $commessaWeb["Richiedente"] ?? "Web Import",
        "Descrizione" => $commessaWeb["Descrizione"] ?? "",
-        "CommesseCustomFields" => $fieldValues,
+        "CommesseCustomFields" => $commessaAfterPatch["CommesseCustomFields"] ?? [],
        "Campioni" => $campioni,
-        "Inviata" => 1
+        "Inviata" => 0 // Non inviato, come richiesto
    ];

    echo json_encode([
@@ -159,14 +266,26 @@ try {
        "commessaWeb" => $finalCommessa,
        "commessaWebApiResponse" => $commessaWeb, // Incluso per debug
        "totalCampioni" => count($campioni),
-        "totalCustomFields" => count($fieldValues),
-        "message" => "Export successful"
+        "totalCustomFields" => count($commessaAfterPatch["CommesseCustomFields"] ?? []),
+        "message" => "Export successful",
+        "logFiles" => [
+            "step5_create" => $logFileStep5,
+            "step6_campioni" => $logFileStep6,
+            "step7_patch" => $logFileStep7,
+            "step10_get" => $logFileStep10
+        ]
    ]);
 } catch (Exception $e) {
    error_log("LIMS Export Error: " . $e->getMessage() . "\nTrace: " . $e->getTraceAsString());

    echo json_encode([
        "success" => false,
-        "message" => "Export failed: " . $e->getMessage()
+        "message" => "Export failed: " . $e->getMessage(),
+        "logFiles" => [
+            "step5_create" => $logFileStep5 ?? null,
+            "step6_campioni" => $logFileStep6 ?? null,
+            "step7_patch" => $logFileStep7 ?? null,
+            "step10_get" => $logFileStep10 ?? null
+        ]
    ]);
 }
@@ -1,19 +1,33 @@
 <?php
-require_once dirname(__DIR__, 2) . '/vendor/autoload.php'; // Torna al livello di public per trovare vendor/
-require_once dirname(__FILE__) . '/class/VisualLimsApiClient.class.php';
+require_once dirname(__DIR__, 2) . '/vendor/autoload.php';
+require_once __DIR__ . '/class/VisualLimsApiClient.class.php';

 header('Content-Type: application/json');

-// Disabilita la visualizzazione degli errori PHP per evitare output HTML
+// Disable PHP error display
 ini_set('display_errors', '0');
 error_reporting(E_ALL);

 try {
    $api = VisualLimsApiClient::getInstance();
-    $data = $api->get("Cliente"); // Recupera i clienti

-    // Salva la risposta in un file per debug
-    file_put_contents(__DIR__ . '/clienti_response.json', json_encode($data));
+    // Parametri OData
+    $params = [
+        '$select' => 'IdCliente,Nominativo,CodiceNazioneFatturazione',
+        '$orderby' => 'Nominativo asc'
+    ];
+
+    // Costruisce query string con encoding corretto
+    $queryString = http_build_query($params);
+
+    // Componi endpoint finale
+    $endpoint = "Cliente?$queryString";
+
+    // Richiama API
+    $data = $api->get($endpoint);
+
+    // Salva risposta per debug
+    file_put_contents(__DIR__ . '/clienti_response.json', json_encode($data, JSON_PRETTY_PRINT));

    echo json_encode($data);
 } catch (Exception $e) {
@@ -9,7 +9,7 @@ error_reporting(E_ALL);

 try {
    $api = VisualLimsApiClient::getInstance();
-    $rapporto_id = 515081;
+    $rapporto_id = 533329;

    // Costruzione manuale dell'endpoint con espansione annidata
    $endpoint = "Rapporto($rapporto_id)?\$expand=CampioniDatiRapporto(\$expand=AnalisiDatiRapporto,CustomFieldsDatiRapporto)";
@@ -662,6 +662,11 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                            } else {
                                                echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
                                            }
+                                            // Status (subito dopo main_field)
+                                            $fixedColumnsReduced = ['status'];
+                                            foreach ($fixedColumnsReduced as $col) {
+                                                echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
+                                            }
                                            // Campi automatici (escluso main_field)
                                            $autoIndex = ($mainFieldMapping && !$mainFieldMapping['is_manual']) ? 1 : 0;
                                            foreach ($allMappings as $mapping) {
@@ -712,11 +717,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    $manualIndex++;
                                                }
                                            }
-                                            // Colonne status, Import Reference Code, filename_import
-                                            $fixedColumnsReduced = ['status'];
-                                            foreach ($fixedColumnsReduced as $col) {
-                                                echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
-                                            }
+                                            // Colonne Import Reference Code, filename_import
                                            echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>"; // Import Reference Code
                                            echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>"; // filename_import
                                            // AWB Number e Tracking Info
@@ -734,6 +735,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>" . htmlspecialchars($mainFieldMapping['field_label']) . "<div class='resizer'></div></div>";
                                                $headerIndex++;
                                            }
+                                            // Header per status (subito dopo main_field)
+                                            foreach ($fixedColumnsReduced as $col) {
+                                                $displayName = $slugMapping[$col] ?? $col;
+                                                echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>$displayName<div class='resizer'></div></div>";
+                                                $headerIndex++;
+                                            }
                                            // Header per campi automatici (escluso main_field)
                                            foreach ($allMappings as $mapping) {
                                                if (!$mapping['is_manual'] && $mapping['main_field'] != 1) {
@@ -748,12 +755,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    $headerIndex++;
                                                }
                                            }
-                                            // Header per status, Import Reference Code, filename_import
-                                            foreach ($fixedColumnsReduced as $col) {
-                                                $displayName = $slugMapping[$col] ?? $col;
-                                                echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>$displayName<div class='resizer'></div></div>";
-                                                $headerIndex++;
-                                            }
+                                            // Header per Import Reference Code, filename_import
                                            echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>Import Reference Code<div class='resizer'></div></div>";
                                            $headerIndex++;
                                            echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>File<div class='resizer'></div></div>";
@@ -770,13 +772,11 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    <div style="display: flex; gap: 5px; justify-content: center;">
                                                        <?php if (!$is_readonly): ?>
                                                            <button type="button" class="save-btn action-btn" data-row="<?= $index ?>" style="background: #28a745; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: pointer; flex: 1;"><i class="fas fa-save"></i></button>
-                                                            <button type="button" class="photos-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #007bff; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: pointer; flex: 1;"><i class="fas fa-camera"></i></button>
-                                                            <button type="button" class="parts-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #ffc107; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: pointer; flex: 1;"><i class="fas fa-puzzle-piece"></i></button>
                                                        <?php else: ?>
                                                            <button type="button" class="save-btn action-btn" data-row="<?= $index ?>" style="background: #ccc; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: not-allowed; flex: 1;" disabled><i class="fas fa-save"></i></button>
-                                                            <button type="button" class="photos-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #ccc; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: not-allowed; flex: 1;" disabled><i class="fas fa-camera"></i></button>
-                                                            <button type="button" class="parts-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #ccc; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: not-allowed; flex: 1;" disabled><i class="fas fa-puzzle-piece"></i></button>
                                                        <?php endif; ?>
+                                                        <button type="button" class="photos-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #007bff; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: pointer; flex: 1;"><i class="fas fa-camera"></i></button>
+                                                        <button type="button" class="parts-btn action-btn" data-row="<?= $index ?>" data-iddatadb="<?= $row['iddatadb'] ?>" style="background: #ffc107; color: white; border: none; padding: 8px 12px; border-radius: 5px; cursor: pointer; flex: 1;"><i class="fas fa-puzzle-piece"></i></button>
                                                    </div>
                                                </div>
                                                <?php
@@ -806,6 +806,25 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    echo "</div>";
                                                    $cellIndex++;
                                                }
+                                                // Status (subito dopo main_field)
+                                                $fixedColumnsReduced = ['status'];
+                                                foreach ($fixedColumnsReduced as $col) {
+                                                    $value = $row[$col] ?? '';
+                                                    echo "<div class='grid-cell editable-cell' data-col='$col' data-row='$index' data-index='$cellIndex' style='flex: 0 0 150px;'>";
+                                                    if ($col === 'status') {
+                                                        $badgeClass = $value === 'i' ? 'status-i' : ($value === 'P' ? 'status-P' : 'status-l');
+                                                        $badgeText = $value === 'i' ? 'Imported' : ($value === 'P' ? 'Progress' : 'LIMS');
+                                                        // Aggiungi il numero di commessaweb se lo status è 'l'
+                                                        if ($value === 'l') {
+                                                            $commessaWeb = isset($row['commessaweb']) ? htmlspecialchars($row['commessaweb']) : '';
+                                                            $badgeText .= " ($commessaWeb)";
+                                                        }
+                                                        echo "<span class='status-badge $badgeClass'>" . htmlspecialchars($badgeText) . "</span>";
+                                                        echo "<input type='hidden' name='rows[$index][$col]' value='" . htmlspecialchars($value ?? 'i') . "'>";
+                                                    }
+                                                    echo "</div>";
+                                                    $cellIndex++;
+                                                }
                                                // Campi automatici (escluso main_field)
                                                $autoIndex = ($mainFieldMapping && !$mainFieldMapping['is_manual']) ? 1 : 0;
                                                foreach ($allMappings as $mapping) {
@@ -863,20 +882,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                        $manualIndex++;
                                                    }
                                                }
-                                                // Colonna status
-                                                $fixedColumnsReduced = ['status'];
-                                                foreach ($fixedColumnsReduced as $col) {
-                                                    $value = $row[$col] ?? '';
-                                                    echo "<div class='grid-cell editable-cell' data-col='$col' data-row='$index' data-index='$cellIndex' style='flex: 0 0 150px;'>";
-                                                    if ($col === 'status') {
-                                                        $badgeClass = $value === 'i' ? 'status-i' : ($value === 'P' ? 'status-P' : 'status-l');
-                                                        $badgeText = $value === 'i' ? 'Imported' : ($value === 'P' ? 'Progress' : 'LIMS');
-                                                        echo "<span class='status-badge $badgeClass'>" . htmlspecialchars($badgeText) . "</span>";
-                                                        echo "<input type='hidden' name='rows[$index][$col]' value='" . htmlspecialchars($value ?? 'i') . "'>";
-                                                    }
-                                                    echo "</div>";
-                                                    $cellIndex++;
-                                                }
                                                // Colonne Import Reference Code e filename_import
                                                echo "<div class='grid-cell' data-col='importreferencecode' data-row='$index' data-index='$cellIndex' style='flex: 0 0 150px;'>";
                                                echo "<span>" . htmlspecialchars($row['importreferencecode']) . "</span>";
@@ -1,17 +1,4 @@
 <?php
-// Abilita errori per debug
-ini_set('display_errors', 1);
-ini_set('display_startup_errors', 1);
-error_reporting(E_ALL);
-ini_set('log_errors', 1);
-ini_set('error_log', __DIR__ . '/import_debug.log');
-if (!file_exists(__DIR__ . '/import_debug.log')) {
-    file_put_contents(__DIR__ . '/import_debug.log', "Inizio importazione alle " . date('Y-m-d H:i:s') . "\n", FILE_APPEND);
-}
-
-// Log iniziale
-error_log("Inizio importazione alle " . date('Y-m-d H:i:s'));
-
 include('include/headscript.php');

 if ($_SERVER['REQUEST_METHOD'] !== 'POST' || !isset($_POST['template_id']) || !isset($_POST['selected_rows']) || !isset($_POST['filename'])) {
@@ -25,11 +12,6 @@ $columns = json_decode($_POST['columns'], true) ?? $_SESSION['columns'];
 $rows = json_decode($_POST['rows'], true) ?? $_SESSION['rows'];
 $newFilename = htmlspecialchars($_POST['filename']) ?? $_SESSION['filename'];

-// Log dei dati ricevuti
-error_log("Received Data - Template ID: $template_id, Selected Rows: " . json_encode($selected_rows));
-error_log("Columns: " . json_encode($columns));
-error_log("Rows: " . json_encode($rows));
-
 // Recupera l'ID dell'utente loggato
 $user_id = $iduserlogin ?? 1;

@@ -39,8 +21,8 @@ $pdo = $db->getConnection();
 // Genera un UUID univoco per importreferencecode
 $importReferenceCode = date('YmdHis') . '-' . uniqid();

-// Recupera tutti i mapping dal template
-$stmt = $pdo->prepare("SELECT id, excel_column, data_type, is_required, manual_default, is_manual, field_label, field_id, main_field FROM template_mapping WHERE template_id = ?");
+// Recupera tutti i mapping dal template, includendo is_visible_import
+$stmt = $pdo->prepare("SELECT id, excel_column, data_type, is_required, manual_default, is_manual, field_label, field_id, main_field, is_visible_import FROM template_mapping WHERE template_id = ?");
 $stmt->execute([$template_id]);
 $allMappings = $stmt->fetchAll(PDO::FETCH_ASSOC);

@@ -52,7 +34,7 @@ if (empty($allMappings)) {
 // Trova il campo main_field
 $mainFieldMapping = null;
 foreach ($allMappings as $mapping) {
-    if ($mapping['main_field'] == 1) {
+    if ($mapping['main_field'] == 1 && $mapping['is_visible_import'] == 1) {
        $mainFieldMapping = $mapping;
        break;
    }
@@ -97,6 +79,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
    <link rel="icon" href="assets/images/favicon-32x32.png" type="image/png" />
    <?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" />
+    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr@4.6.13/dist/flatpickr.min.css">
+    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet">
    <style>
        .cell-changed {
            background-color: #fff3b0 !important;
@@ -415,6 +399,17 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        #exportResponseModal .modal-backdrop {
            z-index: 1299 !important;
        }
+
+        .add-part-btn {
+            padding: 2px 5px;
+            font-size: 10px;
+            line-height: 1;
+            border-radius: 3px;
+        }
+
+        .flatpickr-input {
+            cursor: pointer;
+        }
    </style>
    <title>Edit Imported Data - <?= htmlspecialchars($titlewebsite, ENT_QUOTES, 'UTF-8'); ?></title>
 </head>
@@ -453,7 +448,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                        <div class="grid-cell" style="flex: 0 0 150px;">
                                            <?php
                                            $fieldValue = $mainFieldMapping['manual_default'] ?? '';
-                                            if ($mainFieldMapping['data_type'] === 'DATE' && $mainFieldMapping['manual_default'] === 'today') {
+                                            if ($mainFieldMapping['data_type'] === 'Data' && $mainFieldMapping['manual_default'] === 'today') {
                                                $fieldValue = date('Y-m-d');
                                            }
                                            $inputClass = $mainFieldMapping['is_manual'] ? 'manual-input' : 'auto-input';
@@ -463,8 +458,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                echo "<option value=''>Seleziona...</option>";
                                                echo "</select>";
                                                echo "<button type='button' class='propagate-btn' data-column='main_field'><i class='fas fa-arrow-down'></i></button>";
-                                            } elseif ($mainFieldMapping['data_type'] === 'DATE') {
-                                                echo "<input type='date' class='custom-field $inputClass' data-column='main_field' value='" . htmlspecialchars($fieldValue) . "' " . ($mainFieldMapping['is_required'] ? 'required' : '') . ">";
+                                            } elseif ($mainFieldMapping['data_type'] === 'Data') {
+                                                echo "<input type='text' class='custom-field date-picker $inputClass' data-column='main_field' value='" . htmlspecialchars($fieldValue) . "' " . ($mainFieldMapping['is_required'] ? 'required' : '') . ">";
                                                echo "<button type='button' class='propagate-btn' data-column='main_field'><i class='fas fa-arrow-down'></i></button>";
                                            } elseif ($mainFieldMapping['data_type'] === 'INT') {
                                                echo "<input type='number' class='custom-field $inputClass' data-column='main_field' value='" . htmlspecialchars($fieldValue) . "' " . ($mainFieldMapping['is_required'] ? 'required' : '') . ">";
@@ -480,7 +475,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                    <?php
                                    $autoIndex = 0;
                                    foreach ($allMappings as $mapping) {
-                                        if (!$mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                        if (!$mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                            $inputClass = 'auto-input';
                                            if ($mapping['is_required']) $inputClass .= ' required-input';
                                            if ($mapping['data_type'] === 'SceltaMultipla') {
@@ -498,20 +493,20 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                    }
                                    $manualIndex = 0;
                                    foreach ($allMappings as $mapping) {
-                                        if ($mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                        if ($mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                            $fieldValue = $mapping['manual_default'] ?? '';
-                                            if ($mapping['data_type'] === 'DATE' && $mapping['manual_default'] === 'today') {
+                                            if ($mapping['data_type'] === 'Data' && $mapping['manual_default'] === 'today') {
                                                $fieldValue = date('Y-m-d');
                                            }
                                            $inputClass = 'manual-input';
                                            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) . "' " . ($mainFieldMapping['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) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                echo "<option value=''>Seleziona...</option>";
                                                echo "</select>";
-                                            } elseif ($mapping['data_type'] === 'DATE') {
-                                                echo "<input type='date' class='custom-field $inputClass' data-column='manual_$manualIndex' value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
+                                            } elseif ($mapping['data_type'] === 'Data') {
+                                                echo "<input type='text' class='custom-field date-picker $inputClass' data-column='manual_$manualIndex' value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                            } elseif ($mapping['data_type'] === 'INT') {
                                                echo "<input type='number' class='custom-field $inputClass' data-column='manual_$manualIndex' value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                            } else {
@@ -522,6 +517,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                            $manualIndex++;
                                        }
                                    }
+                                    // Aggiunta per Tested Component (senza propagate)
+                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
                                    echo "<div class='grid-cell' style='flex: 0 0 200px;'></div>";
                                    echo "<div class='grid-cell' style='flex: 0 0 250px;'></div>";
                                    echo "<div class='grid-cell' style='flex: 0 0 150px;'></div>";
@@ -543,17 +540,20 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                    <?php
                                    $headerIndex = $mainFieldMapping ? 3 : 2;
                                    foreach ($allMappings as $mapping) {
-                                        if (!$mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                        if (!$mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                            echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>" . htmlspecialchars($mapping['field_label']) . "<div class='resizer'></div></div>";
                                            $headerIndex++;
                                        }
                                    }
                                    foreach ($allMappings as $mapping) {
-                                        if ($mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                        if ($mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                            echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>" . htmlspecialchars($mapping['field_label']) . "<div class='resizer'></div></div>";
                                            $headerIndex++;
                                        }
                                    }
+                                    // Aggiunta header per Tested Component
+                                    echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 150px; position: relative;'>Tested Component<div class='resizer'></div></div>";
+                                    $headerIndex++;
                                    echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 200px; position: relative;'>AWB Number<div class='resizer'></div></div>";
                                    $headerIndex++;
                                    echo "<div class='grid-header' data-index='$headerIndex' style='flex: 0 0 250px; position: relative;'>Tracking Info<div class='resizer'></div></div>";
@@ -583,7 +583,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                            $detail = array_filter($manualDetails, fn($d) => $d['mapping_id'] == $mainFieldMapping['id'] && $d['datadb_id'] == $row['iddatadb']);
                                            $detail = reset($detail) ?: ['field_value' => $mainFieldMapping['manual_default']];
                                            $fieldValue = $detail['field_value'] ?? $mainFieldMapping['manual_default'] ?? '';
-                                            if ($mainFieldMapping['data_type'] === 'DATE' && $mainFieldMapping['manual_default'] === 'today' && empty($fieldValue)) {
+                                            if ($mainFieldMapping['data_type'] === 'Data' && $mainFieldMapping['manual_default'] === 'today' && empty($fieldValue)) {
                                                $fieldValue = date('Y-m-d');
                                            }
                                            $requiredClass = ($mainFieldMapping['is_required'] && (is_null($fieldValue) || $fieldValue === '')) ? 'missing-required' : '';
@@ -595,8 +595,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    <select name="rows[<?= $index ?>][details][<?= $mainFieldMapping['id'] ?>][field_value]" class="cell-input dropdown-select <?= $inputClass ?>" data-mapping-id="<?= $mainFieldMapping['id'] ?>" data-field-id="<?= $mainFieldMapping['field_id'] ?>" data-selected-value="<?= htmlspecialchars($fieldValue) ?>" <?= $mainFieldMapping['is_required'] ? 'required' : '' ?>>
                                                        <option value="">Seleziona...</option>
                                                    </select>
-                                                <?php elseif ($mainFieldMapping['data_type'] === 'DATE'): ?>
-                                                    <input type="date" name="rows[<?= $index ?>][details][<?= $mainFieldMapping['id'] ?>][field_value]" value="<?= htmlspecialchars($fieldValue) ?>" class="cell-input <?= $inputClass ?>" <?= $mainFieldMapping['is_required'] ? 'required' : '' ?>>
+                                                <?php elseif ($mainFieldMapping['data_type'] === 'Data'): ?>
+                                                    <input type="text" name="rows[<?= $index ?>][details][<?= $mainFieldMapping['id'] ?>][field_value]" value="<?= htmlspecialchars($fieldValue) ?>" class="cell-input date-picker <?= $inputClass ?>" <?= $mainFieldMapping['is_required'] ? 'required' : '' ?>>
                                                <?php elseif ($mainFieldMapping['data_type'] === 'INT'): ?>
                                                    <input type="number" name="rows[<?= $index ?>][details][<?= $mainFieldMapping['id'] ?>][field_value]" value="<?= htmlspecialchars($fieldValue) ?>" class="cell-input <?= $inputClass ?>" <?= $mainFieldMapping['is_required'] ? 'required' : '' ?>>
                                                <?php else: ?>
@@ -615,7 +615,7 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                        $rowDetails = array_filter($manualDetails, fn($d) => $d['datadb_id'] == $row['iddatadb']);
                                        $autoIndex = 0;
                                        foreach ($allMappings as $mapping) {
-                                            if (!$mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                            if (!$mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                                $detail = array_filter($rowDetails, fn($d) => $d['mapping_id'] == $mapping['id']);
                                                $detail = reset($detail) ?: ['field_value' => $mapping['manual_default']];
                                                $fieldValue = $detail['field_value'] ?? $mapping['manual_default'] ?? '';
@@ -627,8 +627,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    echo "<select name='rows[$index][details][{$mapping['id']}][field_value]' class='cell-input dropdown-select $inputClass' data-mapping-id='{$mapping['id']}' data-field-id='{$mapping['field_id']}' data-selected-value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                    echo "<option value=''>Seleziona...</option>";
                                                    echo "</select>";
-                                                } elseif ($mapping['data_type'] === 'DATE') {
-                                                    echo "<input type='date' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
+                                                } elseif ($mapping['data_type'] === 'Data') {
+                                                    echo "<input type='text' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input date-picker $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                } elseif ($mapping['data_type'] === 'INT') {
                                                    echo "<input type='number' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                } else {
@@ -641,11 +641,11 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                        }
                                        $manualIndex = 0;
                                        foreach ($allMappings as $mapping) {
-                                            if ($mapping['is_manual'] && $mapping['main_field'] != 1) {
+                                            if ($mapping['is_manual'] && $mapping['main_field'] != 1 && $mapping['is_visible_import'] == 1) {
                                                $detail = array_filter($rowDetails, fn($d) => $d['mapping_id'] == $mapping['id']);
                                                $detail = reset($detail) ?: ['field_value' => $mapping['manual_default']];
                                                $fieldValue = $detail['field_value'] ?? $mapping['manual_default'] ?? '';
-                                                if ($mapping['data_type'] === 'DATE' && $mapping['manual_default'] === 'today' && empty($fieldValue)) {
+                                                if ($mapping['data_type'] === 'Data' && $mapping['manual_default'] === 'today' && empty($fieldValue)) {
                                                    $fieldValue = date('Y-m-d');
                                                }
                                                $requiredClass = ($mapping['is_required'] && (is_null($fieldValue) || $fieldValue === '')) ? 'missing-required' : '';
@@ -656,8 +656,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                    echo "<select name='rows[$index][details][{$mapping['id']}][field_value]' class='cell-input dropdown-select $inputClass' data-mapping-id='{$mapping['id']}' data-field-id='{$mapping['field_id']}' data-selected-value='" . htmlspecialchars($fieldValue) . "' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                    echo "<option value=''>Seleziona...</option>";
                                                    echo "</select>";
-                                                } elseif ($mapping['data_type'] === 'DATE') {
-                                                    echo "<input type='date' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
+                                                } elseif ($mapping['data_type'] === 'Data') {
+                                                    echo "<input type='text' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input date-picker $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                } elseif ($mapping['data_type'] === 'INT') {
                                                    echo "<input type='number' name='rows[$index][details][{$mapping['id']}][field_value]' value='" . htmlspecialchars($fieldValue) . "' class='cell-input $inputClass' " . ($mapping['is_required'] ? 'required' : '') . ">";
                                                } else {
@@ -668,6 +668,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                                $manualIndex++;
                                            }
                                        }
+                                        // Aggiunta cella per Tested Component
+                                        echo "<div class='grid-cell editable-cell' data-col='tested_component' data-row='$index' data-index='$cellIndex' style='flex: 0 0 150px; display: flex; align-items: center;'>";
+                                        echo "<input type='text' name='rows[$index][tested_component]' value='' class='cell-input manual-input' style='flex: 1; margin-right: 5px;'>";
+                                        echo "<button type='button' class='add-part-btn btn btn-sm btn-primary' data-row='$index'><i class='fas fa-plus'></i></button>";
+                                        echo "</div>";
+                                        $cellIndex++;
                                        ?>
                                        <div class="grid-cell" style="flex: 0 0 200px;">
                                            <select name="rows[<?= $index ?>][carrier]" class="carrier-select">
@@ -719,11 +725,30 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
    <?php include('jsinclude.php'); ?>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/fabric.js/5.3.1/fabric.min.js"></script>
+    <script src="https://cdn.jsdelivr.net/npm/flatpickr@4.6.13/dist/flatpickr.min.js"></script>
+    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="photos.js"></script>
    <script src="parts.js"></script>
    <script src="tracking.js"></script>
    <script src="export_to_lims.js"></script>
    <script>
+        // Initialize Flatpickr for all date inputs
+        document.addEventListener("DOMContentLoaded", function() {
+            flatpickr(".date-picker", {
+                dateFormat: "Y-m-d",
+                allowInput: true,
+                onOpen: function(selectedDates, dateStr, instance) {
+                    instance.input.closest('.grid-cell').classList.add('expanded');
+                },
+                onClose: function(selectedDates, dateStr, instance) {
+                    instance.input.closest('.grid-cell').classList.remove('expanded');
+                    // Trigger change event to handle unsaved changes
+                    const event = new Event('change');
+                    instance.input.dispatchEvent(event);
+                }
+            });
+        });
+
        $(document).on("click", ".export-lims-btn", function() {
            let rowId = $(this).data("row");
            let idDataDb = $(this).data("iddatadb");
@@ -752,16 +777,13 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        });

        document.addEventListener("DOMContentLoaded", function() {
-            console.log("Page loaded, initializing event listeners");
-
-            const inputs = document.querySelectorAll(".cell-input, .dropdown-select, .carrier-select, .awb-input");
+            const inputs = document.querySelectorAll(".cell-input, .dropdown-select, .carrier-select, .awb-input, .date-picker");
            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];
@@ -776,7 +798,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {

            inputs.forEach(el => {
                el.addEventListener("change", () => {
-                    console.log("Input changed:", el.name);
                    hasChanges = true;
                    const gridCell = el.closest(".grid-cell");
                    const colIndex = gridCell?.dataset.index;
@@ -807,7 +828,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            document.querySelectorAll(".save-btn").forEach(btn => {
                btn.addEventListener("click", () => {
                    const rowIndex = btn.dataset.row;
-                    console.log(`Saving row ${rowIndex}`);
                    const row = btn.closest('.grid-row');
                    const iddatadb = row.getAttribute('data-id');
                    const formData = new FormData();
@@ -834,7 +854,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                            return response.json();
                        })
                        .then(data => {
-                            console.log("Save response:", data);
                            if (data.success) {
                                const cells = row.querySelectorAll('.grid-cell');
                                cells.forEach(cell => {
@@ -858,14 +877,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                            }
                        })
                        .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 = [];
@@ -873,16 +890,13 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                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]"]`);
@@ -906,7 +920,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                        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');
@@ -926,14 +939,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                            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!`);
@@ -942,8 +953,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                }
            });

-
-
            window.addEventListener("beforeunload", function(e) {
                if (hasChanges) {
                    e.preventDefault();
@@ -955,10 +964,8 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        // Gestisci la chiusura dei modali per rimuovere i backdrop
        document.querySelectorAll('#exportConfirmModal, #exportResponseModal').forEach(modal => {
            modal.addEventListener('hidden.bs.modal', () => {
-                console.log(`Modal ${modal.id} closed, removing backdrops`);
                // Rimuovi tutti i backdrop residui
                document.querySelectorAll('.modal-backdrop').forEach(backdrop => {
-                    console.log('Removing backdrop:', backdrop);
                    backdrop.remove();
                });
                // Ripristina il body
@@ -974,7 +981,6 @@ 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() {
@@ -988,7 +994,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            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;
@@ -1010,6 +1015,17 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                                        targetInput.setAttribute('data-selected-value', value);
                                        const event = new Event('change');
                                        targetInput.dispatchEvent(event);
+                                    } else if (targetInput.classList.contains('date-picker')) {
+                                        // Update Flatpickr instance
+                                        const flatpickrInstance = targetInput._flatpickr;
+                                        if (flatpickrInstance && value) {
+                                            flatpickrInstance.setDate(value, true);
+                                        }
+                                        const event = new Event('change');
+                                        targetInput.dispatchEvent(event);
+                                    } else {
+                                        const event = new Event('change');
+                                        targetInput.dispatchEvent(event);
                                    }
                                }
                            }
@@ -1025,7 +1041,6 @@ 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');
@@ -1048,7 +1063,6 @@ 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;
@@ -1059,13 +1073,11 @@ 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) {
-                    console.log("No dropdowns found");
                    return;
                }

@@ -1076,7 +1088,6 @@ 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(",")}`
@@ -1084,16 +1095,12 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                        if (!response.ok) throw new Error(`HTTP error! status: ${response.status}`);
                        const data = await response.json();

-                        if (data.error) {
-                            console.error("Fetch error:", data.error);
-                        } else {
+                        if (data.error) {} else {
                            for (const fieldId of Object.keys(data)) {
                                dropdownData[fieldId] = data[fieldId] || [];
                            }
                        }
-                    } catch (error) {
-                        console.error("Fetch error:", error);
-                    }
+                    } catch (error) {}
                }

                dropdowns.forEach(dropdown => {
@@ -1103,7 +1110,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {

                    if (!fieldId || !dropdownData[fieldId]) {
                        dropdown.innerHTML = '<option value="">Errore nel caricamento</option>';
-                        console.warn(`No data for fieldId ${fieldId}`);
                        return;
                    }

@@ -1122,7 +1128,6 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {

                    if ((currentValue || selectedValue) && dropdown.value !== (currentValue || selectedValue)) {
                        dropdown.value = '';
-                        console.warn(`Value ${currentValue || selectedValue} not found for fieldId ${fieldId}`);
                    }
                });
            }
@@ -1130,6 +1135,52 @@ foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            populateDropdowns();
        });
    </script>
+    <script>
+        $(document).on('click', '.add-part-btn', function() {
+            const rowIndex = $(this).data('row');
+            const row = $(this).closest('.grid-row');
+            const iddatadb = row.data('id');
+            const input = row.find(`input[name="rows[${rowIndex}][tested_component]"]`);
+            const description = input.val().trim();
+
+            if (!description) {
+                alert('Inserisci un valore per Tested Component');
+                return;
+            }
+
+            const data = {
+                iddatadb: iddatadb,
+                parts: [{
+                    part_number: '1', // Imposta part_number a '1'
+                    part_description: description,
+                    mix: 'N'
+                }]
+            };
+
+            $.ajax({
+                url: 'save_parts.php',
+                method: 'POST',
+                contentType: 'application/json',
+                data: JSON.stringify(data),
+                success: function(response) {
+                    if (response.success) {
+                        alert('Parte aggiunta con successo!');
+                        input.val(''); // Pulisci l'input dopo l'aggiunta
+                        // Opzionale: aggiorna la tabella delle parti se il modal è aperto
+                        const partsModal = $('#partsModal');
+                        if (partsModal.hasClass('show')) {
+                            loadParts(iddatadb);
+                        }
+                    } else {
+                        alert('Errore: ' + response.message);
+                    }
+                },
+                error: function() {
+                    alert('Errore durante la richiesta AJAX');
+                }
+            });
+        });
+    </script>
    <!-- Modale di conferma per l'esportazione -->
    <div class="modal fade" id="exportConfirmModal" tabindex="-1" aria-labelledby="exportConfirmModalLabel" aria-hidden="true">
        <div class="modal-dialog">
@@ -0,0 +1,25 @@
+<?php
+require_once(__DIR__ . '/../class/db-functions.php');
+
+$db = DBHandlerSelect::getInstance()->getConnection();
+
+ini_set('display_errors', 1);
+ini_set('display_startup_errors', 1);
+error_reporting(E_ALL | E_STRICT);
+
+// Inizializza la sessione
+if (session_status() == PHP_SESSION_NONE) {
+    session_start();
+}
+
+// Imposta variabili di sessione di default per evitare errori
+$_SESSION['iduserlogin'] = null; // Nessun utente loggato
+$_SESSION['nameuser'] = 'Ospite';
+$_SESSION['surnameuser'] = '';
+$_SESSION['emailuser'] = '';
+$_SESSION['photouser'] = '';
+$photouser = $_SESSION['photouser'];
+$photousername = '';
+
+// Include file di lingua, se necessario
+require_once(__DIR__ . '/../../languages/en/general.php');
@@ -1,4 +1,4 @@
-<!-- Modal modificato con pulsante per riconoscimento vocale e download -->
+<!-- Modal modificato con pulsante per riconoscimento vocale, download e selezione matrici -->
 <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">
@@ -9,10 +9,12 @@
            <div class="modal-body">
                <div class="row">
                    <div class="col-md-6">
-                        <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 10px;">
+                        <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 10px; min-width: 0;">
                            <h6 style="margin: 0; white-space: nowrap;">Elenco Parti</h6>
-                            <div style="display: flex; align-items: center;">
-                                <input type="checkbox" id="showMixParts" name="showMixParts" style="margin-right: 5px;">
+                            <div style="display: flex; align-items: center; min-width: 0;">
+                                <select id="global-matrice" class="ms-2" style="width: 250px !important; min-width: 250px !important;">
+                                </select>
+                                <input type="checkbox" id="showMixParts" name="showMixParts" style="margin-right: 5px; margin-left: 10px;">
                                <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>
@@ -45,13 +47,14 @@
                    <div class="col-md-6">
                        <h6>Foto del Campione</h6>
                        <div style="display: flex; align-items: center; margin-bottom: 10px;">
-                            <button type="button" class="btn btn-primary btn-sm" id="downloadPhotoBtn" style="padding: 0.1rem 0.5rem; font-size: 0.8rem; margin-right: 10px;"><i class="fas fa-download"></i> </button>
+                            <button type="button" class="btn btn-primary btn-sm" id="downloadPhotoBtn" style="padding: 0.1rem 0.5rem; font-size: 0.8rem; margin-right: 10px;"><i class="fas fa-download"></i></button>
                            <div id="photoSelectorContainer" style="display: none;"></div>
                        </div>
                        <div style="position: relative; width: 100%; min-height: 400px;">
                            <img id="samplePhoto" src="" alt="Foto del campione" style="max-width: 100%; max-height: 100%; object-fit: contain; position: absolute; top: 0; left: 0;">
                            <canvas id="photoCanvas" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;"></canvas>
-                            <canvas id="overlayCanvas" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%; z-index: 1000;"></canvas> <!-- Nuovo canvas per Fabric.js -->
+                            <canvas id="overlayCanvas" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%; z-index: 1000;"></canvas>
+                            <div id="descriptionList" class="draggable-description" style="display: none;"></div>
                            <div id="markerContainer"></div>
                        </div>
                    </div>
@@ -249,4 +252,59 @@
        border: 2px solid #000;
        margin: 2px;
    }
+
+    /* Stili per Select2 in #partsList e #global-matrice */
+    #partsList .select2-container,
+    .select2-container--default #global-matrice {
+        width: 250px !important;
+        min-width: 250px !important;
+        margin-left: 10px;
+    }
+
+    #partsList .select2-selection--single,
+    .select2-container--default #global-matrice .select2-selection--single {
+        height: 26px !important;
+        padding: 0.2rem 0.5rem !important;
+        font-size: 0.9rem !important;
+        border: 1px solid #ced4da !important;
+        background-color: #fff !important;
+    }
+
+    #partsList .select2-selection__rendered,
+    .select2-container--default #global-matrice .select2-selection__rendered {
+        line-height: 24px !important;
+        overflow: hidden !important;
+        text-overflow: ellipsis !important;
+        white-space: nowrap !important;
+    }
+
+    #partsList .select2-selection__arrow,
+    .select2-container--default #global-matrice .select2-selection__arrow {
+        height: 26px !important;
+    }
+
+    #partsList .save-status,
+    #partsList .save-loading {
+        margin-left: 5px;
+    }
+
+    .select2-container--open .select2-dropdown {
+        z-index: 1051 !important;
+        border: 1px solid #aaa !important;
+        border-radius: 4px !important;
+        background: white !important;
+        overflow-y: auto !important;
+        max-height: 200px !important;
+    }
+
+    .select2-container--default .select2-search--dropdown .select2-search__field {
+        width: 100% !important;
+        padding: 0.2rem !important;
+    }
+
+    .select2-container--default .part-matrice,
+    .select2-container--default #global-matrice {
+        width: 250px !important;
+        min-width: 250px !important;
+    }
 </style>
@@ -12,11 +12,13 @@ $(document).ready(function () {

    let photoAnnotations = {};
    let partColors = {};
+    let partMatrice = {};
    let selectedPartNumber = null;
    let unsavedChanges = false;
    let fabricCanvas = null;
    let descriptionTextbox = null;
    let markerObjects = {};
+    let matrici = [];

    // ===================
    // VOICE RECOGNITION SETUP
@@ -137,8 +139,35 @@ $(document).ready(function () {
            .data("iddatadb", iddatadb)
            .data("idquotations", idquotations);

-        loadPhoto(iddatadb, idquotations);
-        loadExistingParts(iddatadb, idquotations);
+        // Precarica le matrici se iddatadb (assumendo matrici solo per iddatadb)
+        if (iddatadb) {
+            if (matrici.length === 0) {
+                $.ajax({
+                    url: "get_matrice.php",
+                    method: "GET",
+                    dataType: "json",
+                    success: function (data) {
+                        matrici = data.value || [];
+                        initializeGlobalSelect2();
+                        loadPhoto(iddatadb, idquotations);
+                        loadExistingParts(iddatadb, idquotations);
+                    },
+                    error: function (xhr, status, error) {
+                        matrici = [];
+                        initializeGlobalSelect2();
+                        loadPhoto(iddatadb, idquotations);
+                        loadExistingParts(iddatadb, idquotations);
+                    },
+                });
+            } else {
+                initializeGlobalSelect2();
+                loadPhoto(iddatadb, idquotations);
+                loadExistingParts(iddatadb, idquotations);
+            }
+        } else {
+            loadPhoto(iddatadb, idquotations);
+            loadExistingParts(iddatadb, idquotations);
+        }

        const modal = new bootstrap.Modal(
            document.getElementById("partsModal"),
@@ -175,6 +204,7 @@ $(document).ready(function () {
        };
        photoAnnotations = {};
        partColors = {};
+        partMatrice = {};
        selectedPartNumber = null;
        unsavedChanges = false;
        if (fabricCanvas) {
@@ -184,10 +214,12 @@ $(document).ready(function () {
        }
        descriptionTextbox = null;
        markerObjects = {};
+        matrici = [];
        // Clear UI elements
        $("#photoSelectorContainer").empty().hide();
        $("#samplePhoto").attr("src", "");
        $("#partsTableBody").empty();
+        $("#global-matrice").empty(); // Pulisci select globale se presente
        // Remove any temporary messages
        $(".temp-alert").remove();
    });
@@ -535,6 +567,7 @@ $(document).ready(function () {
                    if (response.success) {
                        $row.remove();
                        delete partColors[partNumber];
+                        delete partMatrice[partNumber];
                        if (markerObjects[partNumber]) {
                            fabricCanvas.remove(markerObjects[partNumber]);
                            delete markerObjects[partNumber];
@@ -576,6 +609,7 @@ $(document).ready(function () {
        } else {
            $row.remove();
            delete partColors[partNumber];
+            delete partMatrice[partNumber];
            if (markerObjects[partNumber]) {
                fabricCanvas.remove(markerObjects[partNumber]);
                delete markerObjects[partNumber];
@@ -717,6 +751,9 @@ $(document).ready(function () {
                            </tr>`;
                        $("#partsTableBody").append(newRow);
                        partColors[part.part_number] = defaultColor;
+                        if (part.idmatrice) {
+                            partMatrice[part.part_number] = part.idmatrice;
+                        }
                    });
                } else {
                    addNewRow(1);
@@ -743,6 +780,163 @@ $(document).ready(function () {
        });
    }

+    // Funzione per inizializzare Select2 sulle tendine delle matrici
+    function initializeSelect2($select, partNumber, partId, idmatrice) {
+        if (typeof $.fn.select2 === "undefined") {
+            $select.replaceWith(
+                '<input type="text" class="form-control form-control-sm" placeholder="Select2 non disponibile" disabled>',
+            );
+            return;
+        }
+
+        const options = matrici.map(function (matrice) {
+            return {
+                id: matrice.IdMatrice,
+                text: matrice.NomeMatriceTraduzione,
+            };
+        });
+
+        $select.select2({
+            placeholder: "Seleziona matrice",
+            allowClear: true,
+            data: options,
+            dropdownParent: $("#partsModal"),
+            matcher: function (params, data) {
+                if (!params.term || params.term.length < 3) {
+                    return data;
+                }
+                const term = params.term.toUpperCase();
+                if (data.text.toUpperCase().indexOf(term) >= 0) {
+                    return data;
+                }
+                return null;
+            },
+        });
+
+        if (partId && partId !== "new" && idmatrice) {
+            const matrice = matrici.find((m) => m.IdMatrice == idmatrice);
+            if (matrice) {
+                const option = new Option(
+                    matrice.NomeMatriceTraduzione,
+                    matrice.IdMatrice,
+                    true,
+                    true,
+                );
+                $select.append(option).trigger("change");
+                partMatrice[partNumber] = matrice.IdMatrice;
+            }
+        }
+
+        $select.on("change", function () {
+            const idmatrice = $(this).val();
+            const $listItem = $(this).closest("li");
+            const $saveStatus = $listItem.find(".save-status");
+            const $saveLoading = $listItem.find(".save-loading");
+
+            partMatrice[partNumber] = idmatrice || null;
+
+            if (partId && partId !== "new") {
+                $saveLoading.show();
+                $saveStatus.hide();
+
+                const iddatadb = $("#partsModal").data("iddatadb");
+                const idquotations = $("#partsModal").data("idquotations");
+                const endpoint = idquotations
+                    ? "save_matrice_quotation.php"
+                    : "save_matrice.php"; // Assumendo esista per quotations, altrimenti adatta
+                const data = idquotations
+                    ? { idquotations: idquotations }
+                    : { iddatadb: iddatadb };
+
+                $.ajax({
+                    url: endpoint,
+                    method: "POST",
+                    data: JSON.stringify({
+                        ...data,
+                        parts: [
+                            {
+                                id: partId,
+                                idmatrice: idmatrice || null,
+                            },
+                        ],
+                    }),
+                    contentType: "application/json",
+                    success: function (response) {
+                        if (response.success) {
+                            $saveLoading.hide();
+                            $saveStatus.show();
+                            setTimeout(() => $saveStatus.hide(), 2000);
+                        } else {
+                            const errorMsg = $(
+                                '<div class="alert alert-danger temp-alert" role="alert">Errore nel salvataggio della matrice: ' +
+                                    response.message +
+                                    "</div>",
+                            );
+                            $("#partsModal .modal-body").prepend(errorMsg);
+                            setTimeout(function () {
+                                errorMsg.fadeOut(500, function () {
+                                    $(this).remove();
+                                });
+                            }, 5000);
+                            $saveLoading.hide();
+                        }
+                    },
+                    error: function (xhr, status, error) {
+                        const errorMsg = $(
+                            '<div class="alert alert-danger temp-alert" role="alert">Errore nel salvataggio della matrice: ' +
+                                error +
+                                " (" +
+                                xhr.status +
+                                ")</div>",
+                        );
+                        $("#partsModal .modal-body").prepend(errorMsg);
+                        setTimeout(function () {
+                            errorMsg.fadeOut(500, function () {
+                                $(this).remove();
+                            });
+                        }, 5000);
+                        $saveLoading.hide();
+                    },
+                });
+            }
+        });
+    }
+
+    // Funzione per inizializzare Select2 sul dropdown globale
+    function initializeGlobalSelect2() {
+        const $select = $("#global-matrice");
+        if (typeof $.fn.select2 === "undefined") {
+            $select.replaceWith(
+                '<input type="text" class="form-control form-control-sm" placeholder="Select2 non disponibile" disabled>',
+            );
+            return;
+        }
+
+        const options = matrici.map(function (matrice) {
+            return {
+                id: matrice.IdMatrice,
+                text: matrice.NomeMatriceTraduzione,
+            };
+        });
+
+        $select.select2({
+            placeholder: "Seleziona matrice globale",
+            allowClear: true,
+            data: options,
+            dropdownParent: $("#partsModal"),
+            matcher: function (params, data) {
+                if (!params.term || params.term.length < 3) {
+                    return data;
+                }
+                const term = params.term.toUpperCase();
+                if (data.text.toUpperCase().indexOf(term) >= 0) {
+                    return data;
+                }
+                return null;
+            },
+        });
+    }
+
    // ===================
    // PARTS LIST
    // ===================
@@ -763,6 +957,7 @@ $(document).ready(function () {
        $("#partsTableBody tr").each(function () {
            const partNumber = $(this).find(".part-number").val();
            const partDescription = $(this).find(".part-description").val();
+            const partId = $(this).data("part-id");
            const partColor =
                partColors[partNumber] ||
                (partDescription.startsWith("Mix") ? "#0000ff" : "#ff0000");
@@ -778,17 +973,30 @@ $(document).ready(function () {
                    )
                    .join("");
                const listItem = `
-                    <li class="list-group-item" data-part-number="${partNumber}">
+                    <li class="list-group-item" data-part-number="${partNumber}" data-part-id="${partId}">
                        ${partNumber} - ${partDescription}
                        <div style="display: flex; align-items: center;">
+                            <button type="button" class="btn btn-primary btn-sm propagate-matrice-btn" style="padding: 0.1rem 0.3rem; font-size: 0.8rem; margin-right: 3px;"><i class="fas fa-arrow-right fa-xs"></i></button>
+                            <select class="part-matrice" style="width: 250px !important; margin-right: 10px;"></select>
                            <button type="button" class="btn btn-success btn-sm add-to-mix-btn" style="padding: 0.1rem 0.3rem; font-size: 0.8rem;"><i class="fas fa-plus fa-xs"></i></button>
                            <div class="color-picker-container">
                                <div class="color-option selected-color" style="background-color: ${partColor}; margin-left: 5px;"></div>
                                <div class="color-picker">${colorOptions}</div>
                            </div>
+                            <span class="save-status text-success" style="display: none; margin-left: 5px;"><i class="fas fa-check fa-xs"></i></span>
+                            <span class="save-loading text-warning" style="display: none; margin-left: 5px;"><i class="fas fa-spinner fa-spin fa-xs"></i></span>
                        </div>
                    </li>`;
                $("#partsList").append(listItem);
+                const $select = $("#partsList").find(
+                    `li[data-part-number="${partNumber}"] .part-matrice`,
+                );
+                initializeSelect2(
+                    $select,
+                    partNumber,
+                    partId,
+                    partMatrice[partNumber],
+                );
            }
        });

@@ -862,11 +1070,32 @@ $(document).ready(function () {
        }
    });

+    $(document).on("click", ".propagate-matrice-btn", function () {
+        const $listItem = $(this).closest("li");
+        const globalVal = $("#global-matrice").val();
+        if (globalVal) {
+            $listItem.find(".part-matrice").val(globalVal).trigger("change");
+        } else {
+            const errorMsg = $(
+                '<div class="alert alert-danger temp-alert" role="alert">Seleziona una matrice globale prima di propagare.</div>',
+            );
+            $("#partsModal .modal-body").prepend(errorMsg);
+            setTimeout(function () {
+                errorMsg.fadeOut(500, function () {
+                    $(this).remove();
+                });
+            }, 5000);
+        }
+    });
+
    $("#partsList").on("click", "li", function (e) {
        if (
            $(e.target).hasClass("add-to-mix-btn") ||
            $(e.target).hasClass("color-option") ||
-            $(e.target).closest(".color-picker-container").length
+            $(e.target).closest(".color-picker-container").length ||
+            $(e.target).hasClass("part-matrice") ||
+            $(e.target).closest(".select2-container").length ||
+            $(e.target).hasClass("propagate-matrice-btn")
        )
            return;
        selectedPartNumber = $(this).data("part-number");
@@ -892,6 +1121,7 @@ $(document).ready(function () {
            ? { idquotations: idquotations }
            : { iddatadb: iddatadb };
        let newPartColors = {};
+        let newPartMatrice = {};
        let newMarkerObjects = {};

        let partsData = $rows
@@ -908,6 +1138,7 @@ $(document).ready(function () {
        partsData.forEach((part, index) => {
            const newNumber = index + 1;
            newPartColors[newNumber] = partColors[part.partNumber] || "#ff0000";
+            newPartMatrice[newNumber] = partMatrice[part.partNumber] || null;
            if (markerObjects[part.partNumber]) {
                newMarkerObjects[newNumber] = markerObjects[part.partNumber];
            }
@@ -934,6 +1165,7 @@ $(document).ready(function () {
        }

        partColors = newPartColors;
+        partMatrice = newPartMatrice;
        markerObjects = newMarkerObjects;

        const partsToSave = partsData.map((part) => ({
@@ -941,6 +1173,7 @@ $(document).ready(function () {
            part_number: part.partNumber,
            part_description: part.partDescription,
            mix: part.partDescription.startsWith("Mix") ? "Y" : "N",
+            idmatrice: partMatrice[part.partNumber] || null,
        }));

        $.ajax({
@@ -1157,7 +1390,7 @@ $(document).ready(function () {
            width: annotations.descriptionSize.width,
            scaleX: 1,
            scaleY: 1,
-            backgroundColor: "rgba(255, 255, 255, 0.8)",
+            backgroundColor: "rgba(255, 255, 255, 0)", // Changed to fully transparent
            fontFamily: "Arial",
            fontSize: 24,
            fill: "#000000",
@@ -185,13 +185,21 @@ document.addEventListener("DOMContentLoaded", function () {
            return;
        }

-        for (const file of files) {
+        loader.style.display = "flex";
+        console.log(`Inizio upload di ${files.length} file`);
+
+        let successCount = 0;
+        let errorMessages = [];
+        let uploadPromises = [];
+
+        for (let i = 0; i < files.length; i++) {
+            const file = files[i];
            if (!file.type.startsWith("image/")) {
-                alert("Per favore, carica solo immagini!");
+                alert(`File ${file.name} non è un'immagine, saltato!`);
                continue;
            }

-            loader.style.display = "flex";
+            console.log(`Preparazione upload file ${i + 1}: ${file.name}`);

            const formData = new FormData();
            formData.append("photo", file);
@@ -201,23 +209,43 @@ document.addEventListener("DOMContentLoaded", function () {
                formData.append("iddatadb", iddatadb);
            }

-            try {
-                const response = await fetch("upload_photo.php", {
-                    method: "POST",
-                    body: formData,
+            const uploadPromise = fetch("upload_photo.php", {
+                method: "POST",
+                body: formData,
+            })
+                .then((response) => response.json())
+                .then((result) => {
+                    if (result.success) {
+                        successCount++;
+                        console.log(`Successo per ${file.name}`);
+                    } else {
+                        errorMessages.push(
+                            `Errore per ${file.name}: ${result.message}`,
+                        );
+                    }
+                })
+                .catch((error) => {
+                    errorMessages.push(
+                        `Errore per ${file.name}: ${error.message}`,
+                    );
                });
-                const result = await response.json();
-                if (result.success) {
-                    loadPopupContent(iddatadb, idquotations);
-                } else {
-                    alert("Errore durante il caricamento: " + result.message);
-                }
-            } catch (error) {
-                alert("Errore durante il caricamento: " + error.message);
-            } finally {
-                loader.style.display = "none";
-            }
+
+            uploadPromises.push(uploadPromise);
        }
+
+        await Promise.all(uploadPromises);
+
+        loader.style.display = "none";
+        console.log(
+            `Fine upload: ${successCount} riusciti, ${errorMessages.length} errori`,
+        );
+
+        if (errorMessages.length > 0) {
+            alert("Errori durante l'upload:\n" + errorMessages.join("\n"));
+        }
+
+        // Ricarica sempre alla fine per aggiornare la lista, anche se parziale successo
+        loadPopupContent(iddatadb, idquotations);
    }

    function attachPhotoEventListeners(iddatadb, idquotations) {
@@ -21,6 +21,10 @@ try {
    $idschema = intval($_POST['idschema'] ?? 0); // Nuovo campo
    $schemaname = trim($_POST['schemaname'] ?? ''); // Corretto da schemamaname
    $idroutine = isset($_POST['idroutine']) && $_POST['idroutine'] !== '' ? intval($_POST['idroutine']) : null; // Aggiunto idroutine
+    $button_size = trim($_POST['button_size'] ?? 'medium'); // Nuovo campo
+    $button_bg_color = trim($_POST['button_bg_color'] ?? '#007bff'); // Nuovo campo
+    $button_text_color = trim($_POST['button_text_color'] ?? '#ffffff'); // Nuovo campo
+    $button_label = trim($_POST['button_label'] ?? 'Click Me'); // Nuovo campo

    // Controllo sui campi obbligatori
    if (empty($id) || empty($name) || empty($header_row) || empty($start_column) || empty($target_table) || $idschema <= 0) {
@@ -36,10 +40,12 @@ try {
    $db = DBHandlerSelect::getInstance();
    $pdo = $db->getConnection();

-    // Aggiorna il database, includendo idschema, schemaname e idroutine
+    // Aggiorna il database, includendo i nuovi campi
    $stmt = $pdo->prepare("UPDATE excel_templates 
                           SET name = ?, header_row = ?, start_column = ?, description = ?, target_table = ?, 
-                               idclient = ?, clientname = ?, schemaname = ?, idschema = ?, idroutine = ?, updated_at = NOW() 
+                               idclient = ?, clientname = ?, schemaname = ?, idschema = ?, idroutine = ?, 
+                               button_size = ?, button_bg_color = ?, button_text_color = ?, button_label = ?, 
+                               updated_at = NOW() 
                           WHERE id = ?");
    $stmt->execute([
        $name,
@@ -52,6 +58,10 @@ try {
        $schemaname,
        $idschema,
        $idroutine,
+        $button_size,
+        $button_bg_color,
+        $button_text_color,
+        $button_label,
        $id
    ]);

@@ -0,0 +1,68 @@
+<?php
+require_once "class/VisualLimsApiClient.class.php";
+include('include/headscript.php');
+
+header("Content-Type: application/json");
+
+// 🔹 Configura directory log (creala se non esiste)
+$logDir = __DIR__ . '/logs/api/';
+if (!is_dir($logDir)) {
+    mkdir($logDir, 0755, true);
+}
+
+// 🔹 Base URL API
+$apiBaseUrl = 'https://93.43.5.102/limsapi/api/odata/';
+
+// 🔹 Hardcoded commessaId
+$commessaId = 533357;
+
+try {
+    // 🔹 Initialize API client
+    $api = VisualLimsApiClient::getInstance();
+
+    // 🔹 STEP 1: POST InviaCommessa
+    $logContentStep1 = "curl --location --request POST '{$apiBaseUrl}CommessaWeb({$commessaId})/InviaCommessa' \\\n" .
+        "--header 'Content-Type: application/json' \\\n" .
+        "--header 'Authorization: Bearer ••••••' \\\n" .
+        "--data '{}'\n\n";
+
+    $sendResult = $api->post("CommessaWeb({$commessaId})/InviaCommessa", []);
+
+    $logContentStep1 .= "RESPONSE:\n" . json_encode($sendResult, JSON_PRETTY_PRINT);
+    $logFileStep1 = $logDir . "commessa_{$commessaId}_send_step1_" . time() . ".txt";
+    file_put_contents($logFileStep1, $logContentStep1);
+
+    // 🔹 STEP 2: GET di controllo post-invio
+    $expand = "CommesseCustomFields(\$expand=CustomField)";
+    $commessaAfterSend = $api->get("CommessaWeb(" . $commessaId . ")?\$expand=" . $expand);
+
+    // Log curl-like per GET di controllo
+    $logContentStep2 = "curl --location --request GET '{$apiBaseUrl}CommessaWeb({$commessaId})?\$expand=CommesseCustomFields(\$expand=CustomField)' \\\n" .
+        "--header 'Authorization: Bearer ••••••'\n\n" .
+        "RESPONSE:\n" . json_encode($commessaAfterSend, JSON_PRETTY_PRINT);
+    $logFileStep2 = $logDir . "commessa_{$commessaId}_get_step2_" . time() . ".txt";
+    file_put_contents($logFileStep2, $logContentStep2);
+
+    // 🔹 Output a schermo
+    echo json_encode([
+        "success" => true,
+        "message" => "Commessa {$commessaId} inviata e verificata",
+        "sendResult" => $sendResult,
+        "commessaAfterSend" => $commessaAfterSend,
+        "logFiles" => [
+            "step1_send" => $logFileStep1,
+            "step2_get" => $logFileStep2
+        ]
+    ]);
+} catch (Exception $e) {
+    error_log("Send/Check Error: " . $e->getMessage() . "\nTrace: " . $e->getTraceAsString());
+
+    echo json_encode([
+        "success" => false,
+        "message" => "Operation failed: " . $e->getMessage(),
+        "logFiles" => [
+            "step1_send" => $logFileStep1 ?? null,
+            "step2_get" => $logFileStep2 ?? null
+        ]
+    ]);
+}
@@ -90,11 +90,11 @@
                                    <tr>
                                        <th>ID</th>
                                        <th><?= htmlspecialchars($nametemplate, ENT_QUOTES, 'UTF-8'); ?></th>
-                                        <th><?= htmlspecialchars($lastmodtemplate, ENT_QUOTES, 'UTF-8'); ?></th>
                                        <th><?= htmlspecialchars($rowheader, ENT_QUOTES, 'UTF-8'); ?></th>
                                        <th><?= htmlspecialchars($columnheader, ENT_QUOTES, 'UTF-8'); ?></th>
                                        <th><?= htmlspecialchars($desctemplate, ENT_QUOTES, 'UTF-8'); ?></th>
                                        <th>Client Name</th>
+                                        <th>Button Label</th>
                                        <th>Status</th> <!-- Aggiunta colonna Status -->
                                        <th><?= htmlspecialchars($action, ENT_QUOTES, 'UTF-8'); ?></th>
                                    </tr>
@@ -147,13 +147,7 @@
                        data: 'name', // Nome del template
                        title: "Template Name"
                    },
-                    {
-                        data: 'updated_at', // Ultima modifica, formattata come data leggibile
-                        title: "Last Modified",
-                        render: function(data) {
-                            return new Date(data).toLocaleDateString();
-                        }
-                    },
+
                    {
                        data: 'header_row', // Riga degli header
                        title: "Header Row"
@@ -176,6 +170,11 @@
                            return `${clientName} (ID: ${clientId})`;
                        }
                    },
+                    {
+                        data: 'button_label', // Nuova colonna per Button Label
+                        title: "Button Label",
+                        defaultContent: 'Click Me'
+                    },
                    {
                        data: 'status', // Stato con Toggle Switch
                        title: "Status",
Author	SHA1	Message	Date
solocla	a0b12463c0	fixed for matrici	2025-10-03 08:52:37 +02:00
solocla	07ddcafd3f	fixed nologin	2025-09-27 13:38:26 +02:00
solocla	7843d4b1fc	added nologin	2025-09-27 13:37:37 +02:00
solocla	4eae855e23	added headscriptnologin	2025-09-27 13:36:26 +02:00
solocla	c709f64a17	remove login smartphone	2025-09-27 13:33:23 +02:00
solocla	d5f0690f59	background trasparent annotation	2025-09-27 13:28:21 +02:00
solocla	6bbd3fcae9	fixed get clienti with id, nominativo and country	2025-09-27 09:53:21 +02:00
solocla	9e19e9e1d4	fixed export to lims, fixed multiple upload, added calendar to Data	2025-09-27 09:44:00 +02:00
solocla	7caee9c994	prova	2025-09-26 11:27:33 +02:00
solocla	f8320315f7	historical added commessaweb., edit added tested components	2025-09-26 09:28:49 +02:00
solocla	7397d86bc2	fixed template dashboard	2025-09-25 14:26:22 +02:00
solocla	2deb1f101a	hide column and fixed edit template	2025-09-25 14:18:09 +02:00