Merge branch 'main' of http://192.168.1.93:8418/solocla/trf_certest

.gitignore

@@ -54,4 +54,6 @@ yarn-error.log
 /public/photostrf/qrcodes/
 
 # Ignora tutti i log ovunque
-*.log
+*.log
+
+public/userarea/cache/

public/userarea/clone_parts_to_visible.php

@@ -0,0 +1,131 @@
+<?php
+header('Content-Type: application/json');
+include('include/headscript.php');
+
+$dbHandler = DBHandlerSelect::getInstance();
+$pdo = $dbHandler->getConnection();
+$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+$data = json_decode(file_get_contents('php://input'), true);
+
+$sourceIddatadb = isset($data['source_iddatadb']) ? (int)$data['source_iddatadb'] : 0;
+$targetList = $data['target_iddatadb_list'] ?? [];
+
+$targetIds = array_values(array_unique(array_filter(array_map('intval', (array)$targetList), function ($v) use ($sourceIddatadb) {
+    return $v > 0 && $v !== $sourceIddatadb;
+})));
+
+if ($sourceIddatadb <= 0 || empty($targetIds)) {
+    echo json_encode([
+        'success' => false,
+        'message' => 'Missing source or target records'
+    ]);
+    exit;
+}
+
+try {
+    $pdo->beginTransaction();
+
+    // 1. Load source parts
+    $stmtParts = $pdo->prepare("
+        SELECT id, part_number, part_description, mix, idmatrice, note, dateexpiry
+        FROM identification_parts
+        WHERE iddatadb = ?
+        ORDER BY part_number ASC, id ASC
+    ");
+    $stmtParts->execute([$sourceIddatadb]);
+    $sourceParts = $stmtParts->fetchAll(PDO::FETCH_ASSOC);
+
+    if (empty($sourceParts)) {
+        $pdo->rollBack();
+        echo json_encode([
+            'success' => false,
+            'message' => 'No parts found for source record'
+        ]);
+        exit;
+    }
+
+    // 2. Prepare statements
+    $stmtInsertPart = $pdo->prepare("
+        INSERT INTO identification_parts
+        (iddatadb, part_number, part_description, mix, idmatrice, note, dateexpiry, created_at, updated_at)
+        VALUES
+        (:iddatadb, :part_number, :part_description, :mix, :idmatrice, :note, :dateexpiry, NOW(), NOW())
+    ");
+
+    $stmtLoadCF = $pdo->prepare("
+        SELECT field_id, value_id, value_text
+        FROM identification_parts_customfields
+        WHERE part_id = ?
+        ORDER BY id ASC
+    ");
+
+    $stmtInsertCF = $pdo->prepare("
+        INSERT INTO identification_parts_customfields
+        (part_id, field_id, value_id, value_text, created_at, updated_at)
+        VALUES
+        (:part_id, :field_id, :value_id, :value_text, NOW(), NOW())
+    ");
+
+    $details = [];
+    $totalClonedParts = 0;
+
+    // 3. Clone source parts to each target record
+    foreach ($targetIds as $targetIddatadb) {
+        $clonedCountForTarget = 0;
+
+        foreach ($sourceParts as $part) {
+            $stmtInsertPart->execute([
+                ':iddatadb' => $targetIddatadb,
+                ':part_number' => $part['part_number'],
+                ':part_description' => $part['part_description'],
+                ':mix' => $part['mix'] ?? 'N',
+                ':idmatrice' => $part['idmatrice'] !== '' ? $part['idmatrice'] : null,
+                ':note' => $part['note'] ?? null,
+                ':dateexpiry' => $part['dateexpiry'] ?? null,
+            ]);
+
+            $newPartId = (int)$pdo->lastInsertId();
+
+            // Load source custom fields for this part
+            $stmtLoadCF->execute([(int)$part['id']]);
+            $customFields = $stmtLoadCF->fetchAll(PDO::FETCH_ASSOC);
+
+            foreach ($customFields as $cf) {
+                $stmtInsertCF->execute([
+                    ':part_id' => $newPartId,
+                    ':field_id' => (int)$cf['field_id'],
+                    ':value_id' => ($cf['value_id'] !== null && $cf['value_id'] !== '') ? (int)$cf['value_id'] : null,
+                    ':value_text' => $cf['value_text'] !== '' ? $cf['value_text'] : null,
+                ]);
+            }
+
+            $clonedCountForTarget++;
+            $totalClonedParts++;
+        }
+
+        $details[] = [
+            'target_iddatadb' => $targetIddatadb,
+            'cloned_parts' => $clonedCountForTarget
+        ];
+    }
+
+    $pdo->commit();
+
+    echo json_encode([
+        'success' => true,
+        'source_iddatadb' => $sourceIddatadb,
+        'cloned_targets' => count($targetIds),
+        'total_cloned_parts' => $totalClonedParts,
+        'details' => $details
+    ]);
+} catch (Throwable $e) {
+    if ($pdo->inTransaction()) {
+        $pdo->rollBack();
+    }
+
+    echo json_encode([
+        'success' => false,
+        'message' => 'Clone failed: ' . $e->getMessage()
+    ]);
+}

public/userarea/imported.php

@@ -342,8 +342,8 @@ $gridMeta = [
 
 ?>
 <script>
-window.gridData = <?= json_encode($gridDataArray, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) ?>;
+    window.gridData = <?= json_encode($gridDataArray, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) ?>;
-window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) ?>;
+    window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) ?>;
 </script>
 
 <!doctype html>
@@ -797,7 +797,7 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
             background-color: rgba(0, 0, 0, 0.5);
         }
 
-        #photosModal > .modal-content {
+        #photosModal>.modal-content {
             background-color: #fff;
             margin: 5% auto;
             padding: 20px;
@@ -892,9 +892,17 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
         }
 
         @keyframes new-row-pulse {
-            0%, 100% { background-color: transparent; }
+
-            50% { background-color: #cce5ff; }
+            0%,
+            100% {
+                background-color: transparent;
+            }
+
+            50% {
+                background-color: #cce5ff;
+            }
         }
+
         .row-just-created {
             animation: new-row-pulse 1s ease-in-out 3;
         }
@@ -1029,21 +1037,25 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
             font-size: 13px;
             color: #495057;
         }
+
         .pager-rows-per-page {
             display: flex;
             align-items: center;
             gap: 8px;
         }
+
         .pager-label {
             font-weight: 500;
             white-space: nowrap;
         }
+
         .pager-limit-group {
             display: inline-flex;
             border: 1px solid #ced4da;
             border-radius: 4px;
             overflow: hidden;
         }
+
         .pager-limit-btn {
             padding: 3px 10px;
             text-decoration: none;
@@ -1052,24 +1064,41 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
             transition: background .15s, color .15s;
             font-weight: 500;
         }
-        .pager-limit-btn:last-child { border-right: none; }
+
-        .pager-limit-btn:hover { background: #e9ecef; text-decoration: none; color: #212529; }
+        .pager-limit-btn:last-child {
+            border-right: none;
+        }
+
+        .pager-limit-btn:hover {
+            background: #e9ecef;
+            text-decoration: none;
+            color: #212529;
+        }
+
         .pager-limit-btn.active {
             background: #0d6efd;
             color: #fff;
         }
-        .pager-limit-btn.active:hover { background: #0b5ed7; color: #fff; }
+
+        .pager-limit-btn.active:hover {
+            background: #0b5ed7;
+            color: #fff;
+        }
+
         .pager-nav {
             display: flex;
             align-items: center;
             gap: 4px;
         }
+
         .pager-info {
             margin-right: 8px;
             font-weight: 500;
             white-space: nowrap;
         }
-        .pager-btn, .pager-num {
+
+        .pager-btn,
+        .pager-num {
             display: inline-flex;
             align-items: center;
             justify-content: center;
@@ -1083,16 +1112,25 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
             font-weight: 500;
             transition: background .15s, color .15s, border-color .15s;
         }
-        .pager-btn:hover, .pager-num:hover { background: #e9ecef; text-decoration: none; color: #212529; }
+
+        .pager-btn:hover,
+        .pager-num:hover {
+            background: #e9ecef;
+            text-decoration: none;
+            color: #212529;
+        }
+
         .pager-num.active {
             background: #0d6efd;
             color: #fff;
             border-color: #0d6efd;
         }
+
         .pager-btn.disabled {
             pointer-events: none;
             opacity: .4;
         }
+
         .pager-dots {
             padding: 0 2px;
             color: #adb5bd;
@@ -1112,20 +1150,20 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
                     <a href="imported.php?id=<?= $template_id ?>" class="btn btn-warning me-2">Imported (i)</a>
                     <a href="tolims.php?id=<?= $template_id ?>" class="btn btn-success">To LIMS (l)</a>
                     <?php if ($importref === ''): ?>
-                    <span class="ms-3">
+                        <span class="ms-3">
-                        <label class="form-check-label" style="font-size: 13px; cursor: pointer;">
+                            <label class="form-check-label" style="font-size: 13px; cursor: pointer;">
-                            <input type="checkbox" class="form-check-input" id="showAllUsers" <?= $show_all_users ? 'checked' : '' ?>
+                                <input type="checkbox" class="form-check-input" id="showAllUsers" <?= $show_all_users ? 'checked' : '' ?>
-                                onchange="window.location.href='imported.php?id=<?= $template_id ?>' + (this.checked ? '&all_users=1' : '')">
+                                    onchange="window.location.href='imported.php?id=<?= $template_id ?>' + (this.checked ? '&all_users=1' : '')">
-                            Show all users
+                                Show all users
-                        </label>
+                            </label>
-                    </span>
+                        </span>
-                    <span class="text-muted" style="font-size: 12px;">
+                        <span class="text-muted" style="font-size: 12px;">
-                        (<?= $usePagination ? count($importedData) . " of {$totalRows}" : count($importedData) ?> records<?= !$show_all_users ? ' — my records only' : '' ?>)
+                            (<?= $usePagination ? count($importedData) . " of {$totalRows}" : count($importedData) ?> records<?= !$show_all_users ? ' — my records only' : '' ?>)
-                    </span>
+                        </span>
                     <?php endif; ?>
                 </div>
                 <?php if ($usePagination): ?>
-                <?php
+                    <?php
                     $baseQuery = $_GET;
                     unset($baseQuery['limit'], $baseQuery['page']);
                     $pageQuery = $_GET;
@@ -1133,43 +1171,43 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
                     $pageBase = 'imported.php?' . http_build_query($pageQuery);
                     $fromRow = ($page - 1) * $perPage + 1;
                     $toRow = min($page * $perPage, $totalRows);
-                ?>
+                    ?>
-                <div class="pager-bar mb-2">
+                    <div class="pager-bar mb-2">
-                    <div class="pager-rows-per-page">
+                        <div class="pager-rows-per-page">
-                        <span class="pager-label">Rows per page</span>
+                            <span class="pager-label">Rows per page</span>
-                        <div class="pager-limit-group">
+                            <div class="pager-limit-group">
-                        <?php foreach ($allowedLimits as $lim):
+                                <?php foreach ($allowedLimits as $lim):
-                            $isActive = ($perPage === $lim);
+                                    $isActive = ($perPage === $lim);
-                            $url = 'imported.php?' . http_build_query(array_merge($baseQuery, ['limit' => $lim]));
+                                    $url = 'imported.php?' . http_build_query(array_merge($baseQuery, ['limit' => $lim]));
-                        ?>
+                                ?>
-                            <a href="<?= htmlspecialchars($url) ?>" class="pager-limit-btn <?= $isActive ? 'active' : '' ?>"><?= $lim ?></a>
+                                    <a href="<?= htmlspecialchars($url) ?>" class="pager-limit-btn <?= $isActive ? 'active' : '' ?>"><?= $lim ?></a>
-                        <?php endforeach; ?>
+                                <?php endforeach; ?>
+                            </div>
                         </div>
-                    </div>
+                        <?php if ($totalPages > 1): ?>
-                    <?php if ($totalPages > 1): ?>
+                            <div class="pager-nav">
-                    <div class="pager-nav">
+                                <span class="pager-info"><?= $fromRow ?>–<?= $toRow ?> of <?= $totalRows ?></span>
-                        <span class="pager-info"><?= $fromRow ?>–<?= $toRow ?> of <?= $totalRows ?></span>
+                                <a href="<?= htmlspecialchars($pageBase . '&page=1') ?>" class="pager-btn <?= $page <= 1 ? 'disabled' : '' ?>" title="First"><i class="fas fa-angle-double-left"></i></a>
-                        <a href="<?= htmlspecialchars($pageBase . '&page=1') ?>" class="pager-btn <?= $page <= 1 ? 'disabled' : '' ?>" title="First"><i class="fas fa-angle-double-left"></i></a>
+                                <a href="<?= htmlspecialchars($pageBase . '&page=' . ($page - 1)) ?>" class="pager-btn <?= $page <= 1 ? 'disabled' : '' ?>" title="Previous"><i class="fas fa-angle-left"></i></a>
-                        <a href="<?= htmlspecialchars($pageBase . '&page=' . ($page - 1)) ?>" class="pager-btn <?= $page <= 1 ? 'disabled' : '' ?>" title="Previous"><i class="fas fa-angle-left"></i></a>
+                                <?php
-                        <?php
+                                $startPage = max(1, $page - 2);
-                        $startPage = max(1, $page - 2);
+                                $endPage = min($totalPages, $page + 2);
-                        $endPage = min($totalPages, $page + 2);
+                                if ($startPage > 1): ?>
-                        if ($startPage > 1): ?>
+                                    <a href="<?= htmlspecialchars($pageBase . '&page=1') ?>" class="pager-num">1</a>
-                            <a href="<?= htmlspecialchars($pageBase . '&page=1') ?>" class="pager-num">1</a>
+                                    <?php if ($startPage > 2): ?><span class="pager-dots">...</span><?php endif; ?>
-                            <?php if ($startPage > 2): ?><span class="pager-dots">...</span><?php endif; ?>
+                                <?php endif;
-                        <?php endif;
+                                for ($p = $startPage; $p <= $endPage; $p++): ?>
-                        for ($p = $startPage; $p <= $endPage; $p++): ?>
+                                    <a href="<?= htmlspecialchars($pageBase . '&page=' . $p) ?>" class="pager-num <?= $p === $page ? 'active' : '' ?>"><?= $p ?></a>
-                            <a href="<?= htmlspecialchars($pageBase . '&page=' . $p) ?>" class="pager-num <?= $p === $page ? 'active' : '' ?>"><?= $p ?></a>
+                                <?php endfor;
-                        <?php endfor;
+                                if ($endPage < $totalPages): ?>
-                        if ($endPage < $totalPages): ?>
+                                    <?php if ($endPage < $totalPages - 1): ?><span class="pager-dots">...</span><?php endif; ?>
-                            <?php if ($endPage < $totalPages - 1): ?><span class="pager-dots">...</span><?php endif; ?>
+                                    <a href="<?= htmlspecialchars($pageBase . '&page=' . $totalPages) ?>" class="pager-num"><?= $totalPages ?></a>
-                            <a href="<?= htmlspecialchars($pageBase . '&page=' . $totalPages) ?>" class="pager-num"><?= $totalPages ?></a>
+                                <?php endif; ?>
+                                <a href="<?= htmlspecialchars($pageBase . '&page=' . ($page + 1)) ?>" class="pager-btn <?= $page >= $totalPages ? 'disabled' : '' ?>" title="Next"><i class="fas fa-angle-right"></i></a>
+                                <a href="<?= htmlspecialchars($pageBase . '&page=' . $totalPages) ?>" class="pager-btn <?= $page >= $totalPages ? 'disabled' : '' ?>" title="Last"><i class="fas fa-angle-double-right"></i></a>
+                            </div>
                         <?php endif; ?>
-                        <a href="<?= htmlspecialchars($pageBase . '&page=' . ($page + 1)) ?>" class="pager-btn <?= $page >= $totalPages ? 'disabled' : '' ?>" title="Next"><i class="fas fa-angle-right"></i></a>
-                        <a href="<?= htmlspecialchars($pageBase . '&page=' . $totalPages) ?>" class="pager-btn <?= $page >= $totalPages ? 'disabled' : '' ?>" title="Last"><i class="fas fa-angle-double-right"></i></a>
                     </div>
-                    <?php endif; ?>
-                </div>
                 <?php endif; ?>
                 <div class="card radius-10">
                     <div class="card-header">
@@ -1179,9 +1217,9 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
                                     <i class="fas fa-cogs"></i> Actions
                                 </button>
                                 <ul class="dropdown-menu dropdown-menu-end">
-                                    <?php if ((Auth::user()->hasRole('Admin'))) : ?>
+
-                                        <li><a class="dropdown-item export-all-lims-btn" href="#"><i class="fas fa-upload" style="color: #eb0b0b;"></i>Export All</a></li>
+                                    <li><a class="dropdown-item export-all-lims-btn" href="#"><i class="fas fa-upload" style="color: #eb0b0b;"></i>Export All</a></li>
-                                    <?php endif; ?>
+
                                     <li><a class="dropdown-item save-all-btn" href="#"><i class="fas fa-save" style="color: #28a745;"></i>Save All</a></li>
                                 </ul>
                             </div>
@@ -1208,6 +1246,7 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
                             </div>
                         </form>
                         <div id="partsModalContainer"></div>
+                        <div id="analysisModalContainer"></div>
                         <div id="annotationsModalContainer"></div>
                         <?php include 'photos_functions.php'; ?>
                     </div>
@@ -1218,7 +1257,12 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
         <a href="javaScript:;" class="back-to-top"><i class='bx bxs-up-arrow-alt'></i></a>
         <?php include('include/footer.php'); ?>
     </div>
-    <style>.btn i { margin-top: 0 !important; margin-bottom: 0 !important; }</style>
+    <style>
+        .btn i {
+            margin-top: 0 !important;
+            margin-bottom: 0 !important;
+        }
+    </style>
     <?php include('jsinclude.php'); ?>
     <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>
@@ -1231,6 +1275,7 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
     <script src="photos.js"></script>
     <script src="annotationsModal.js"></script>
     <script src="partsTable.js"></script>
+    <script src="analysisModal.js"></script>
 
     <div class="modal fade" id="exportConfirmModal" tabindex="-1" aria-labelledby="exportConfirmModalLabel" aria-hidden="true">
         <div class="modal-dialog">
@@ -1394,4 +1439,4 @@ window.gridMeta = <?= json_encode($gridMeta, JSON_UNESCAPED_UNICODE | JSON_UNESC
 
 </body>
 
-</html>
+</html>

public/userarea/modal_partsTable.php

@@ -26,7 +26,9 @@
                                 <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-primary btn-sm" id="clonePartsBtn" style="padding: 0.1rem 0.5rem; font-size: 0.8rem;">
+                                    <i class="fas fa-clone"></i> Clona 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>

public/userarea/modals_gridData.js

@@ -2,93 +2,111 @@
  * modals_gridData.js — Photos, Parts, Tested Component handlers for gridData pages
  */
 (function () {
-    'use strict';
+    "use strict";
 
     // ── Photos — use photos.js loadPopupContent (exported to window) ──
-    $(document).on('click', '.photos-btn', function () {
+    $(document).on("click", ".photos-btn", function () {
-        const iddatadb = $(this).data('iddatadb') || null;
+        const iddatadb = $(this).data("iddatadb") || null;
-        const idquotations = $(this).data('idquotations') || null;
+        const idquotations = $(this).data("idquotations") || null;
-        const modal = document.getElementById('photosModal');
+        const modal = document.getElementById("photosModal");
         if (!modal) return;
 
-        modal.style.display = 'block';
+        modal.style.display = "block";
 
-        if (typeof window.loadPopupContent === 'function') {
+        if (typeof window.loadPopupContent === "function") {
             window.loadPopupContent(iddatadb, idquotations);
         }
     });
 
     // Close photos modal
-    $(document).on('click', '.close-btn', function () {
+    $(document).on("click", ".close-btn", function () {
-        const modal = document.getElementById('photosModal');
+        const modal = document.getElementById("photosModal");
-        if (modal) modal.style.display = 'none';
+        if (modal) modal.style.display = "none";
     });
 
     // Close on backdrop click
-    $(document).on('click', '#photosModal', function (e) {
+    $(document).on("click", "#photosModal", function (e) {
         if (e.target === this) {
-            this.style.display = 'none';
+            this.style.display = "none";
         }
     });
 
     // ── Parts (matching import_edit2.php behavior) ─────────────────────
-    $(document).on('click', '.parts-btn', function () {
+    $(document).on("click", ".parts-btn", function () {
-        const iddatadb = $(this).data('iddatadb') || null;
+        const iddatadb = $(this).data("iddatadb") || null;
-        const idquotations = $(this).data('idquotations') || null;
+        const idquotations = $(this).data("idquotations") || null;
 
         $.ajax({
-            url: 'modal_partsTable.php',
+            url: "modal_partsTable.php",
-            method: 'GET',
+            method: "GET",
             data: { iddatadb: iddatadb },
             success: function (response) {
-                $('#partsModalContainer').html(response);
+                $("#partsModalContainer").html(response);
-                const modalElement = document.getElementById('partsModal');
+                const modalElement = document.getElementById("partsModal");
                 if (!modalElement) return;
 
-                $("#trfHeader").text(iddatadb || idquotations || '');
+                $("#trfHeader").text(iddatadb || idquotations || "");
-                $("#partsModal").data("iddatadb", iddatadb).data("idquotations", idquotations);
+
+                const visibleIddatadbList = Array.isArray(window.gridData)
+                    ? window.gridData
+                          .map((r) => parseInt(r.iddatadb, 10))
+                          .filter((v) => !isNaN(v) && v > 0)
+                    : [];
+
+                $("#partsModal")
+                    .data("iddatadb", iddatadb)
+                    .data("idquotations", idquotations)
+                    .data("visible-iddatadb-list", visibleIddatadbList);
 
                 let modal = bootstrap.Modal.getInstance(modalElement);
-                if (!modal) modal = new bootstrap.Modal(modalElement, { backdrop: true, keyboard: true, focus: true });
+                if (!modal)
+                    modal = new bootstrap.Modal(modalElement, {
+                        backdrop: true,
+                        keyboard: true,
+                        focus: true,
+                    });
                 modal.show();
 
-                if (typeof window.loadParts === 'function') {
+                if (typeof window.loadParts === "function") {
                     window.loadParts(iddatadb, idquotations);
                 }
             },
             error: function (xhr, status, error) {
-                console.error('Error loading parts:', error);
+                console.error("Error loading parts:", error);
-            }
+            },
         });
     });
 
-    $(document).on('hidden.bs.modal', '#partsModal', function () {
+    $(document).on("hidden.bs.modal", "#partsModal", function () {
-        const modalElement = document.getElementById('partsModal');
+        const modalElement = document.getElementById("partsModal");
         if (modalElement) {
             const modal = bootstrap.Modal.getInstance(modalElement);
             if (modal) modal.dispose();
         }
-        $('#partsModalContainer').empty();
+        $("#partsModalContainer").empty();
-        $('.modal-backdrop').remove();
+        $(".modal-backdrop").remove();
-        $('body').removeClass('modal-open').css('padding-right', '');
+        $("body").removeClass("modal-open").css("padding-right", "");
     });
 
     // ── Tested Component quick add ───────────────────────────────────────
-    $(document).on('click', '.add-part-btn', async function () {
+    $(document).on("click", ".add-part-btn", async function () {
-        const iddatadb = $(this).data('iddatadb') || null;
+        const iddatadb = $(this).data("iddatadb") || null;
-        const rowIndex = parseInt($(this).data('row'));
+        const rowIndex = parseInt($(this).data("row"));
         const row = window.gridData?.[rowIndex];
         const id = iddatadb || (row ? row.iddatadb : null);
         if (!id) return;
 
-        const $cell = $(this).closest('.grid-cell, div');
+        const $cell = $(this).closest(".grid-cell, div");
-        const $input = $cell.find('input');
+        const $input = $cell.find("input");
-        const raw = ($input.val() || '').trim();
+        const raw = ($input.val() || "").trim();
-        const parts = raw.split('|').map(s => s.trim()).filter(s => s.length > 0);
+        const parts = raw
+            .split("|")
+            .map((s) => s.trim())
+            .filter((s) => s.length > 0);
         const uniqueParts = [...new Set(parts)];
 
         if (!uniqueParts.length) {
-            alert('Insert a description first.');
+            alert("Insert a description first.");
             $input.focus();
             return;
         }
@@ -96,14 +114,17 @@
         try {
             for (const p of uniqueParts) {
                 const formData = new FormData();
-                formData.append('iddatadb', id);
+                formData.append("iddatadb", id);
-                formData.append('part_description', p);
+                formData.append("part_description", p);
-                await fetch('add_part_quick.php', { method: 'POST', body: formData });
+                await fetch("add_part_quick.php", {
+                    method: "POST",
+                    body: formData,
+                });
             }
             alert(`Added ${uniqueParts.length} part(s).`);
-            $input.val('');
+            $input.val("");
         } catch (e) {
-            alert('Error: ' + e.message);
+            alert("Error: " + e.message);
         }
     });
 
@@ -111,44 +132,47 @@
     let deleteIddatadb = null;
     let deleteRowIndex = null;
 
-    $(document).on('click', '.delete-btn', function () {
+    $(document).on("click", ".delete-btn", function () {
-        deleteIddatadb = $(this).data('iddatadb');
+        deleteIddatadb = $(this).data("iddatadb");
-        deleteRowIndex = parseInt($(this).data('row'));
+        deleteRowIndex = parseInt($(this).data("row"));
-        const modalEl = document.getElementById('deleteConfirmModal');
+        const modalEl = document.getElementById("deleteConfirmModal");
         if (modalEl) {
-            document.getElementById('deleteIddatadbText').textContent = deleteIddatadb;
+            document.getElementById("deleteIddatadbText").textContent =
+                deleteIddatadb;
             new bootstrap.Modal(modalEl).show();
         }
     });
 
-    $(document).on('click', '#deleteConfirmBtn', async function () {
+    $(document).on("click", "#deleteConfirmBtn", async function () {
-        const modalEl = document.getElementById('deleteConfirmModal');
+        const modalEl = document.getElementById("deleteConfirmModal");
         const modal = bootstrap.Modal.getInstance(modalEl);
         if (modal) modal.hide();
 
         if (!deleteIddatadb) return;
 
         try {
-            const resp = await fetch('delete_record.php', {
+            const resp = await fetch("delete_record.php", {
-                method: 'POST',
+                method: "POST",
-                headers: { 'Content-Type': 'application/json' },
+                headers: { "Content-Type": "application/json" },
-                body: JSON.stringify({ id: deleteIddatadb })
+                body: JSON.stringify({ id: deleteIddatadb }),
             });
             const result = await resp.json();
 
             if (result.success) {
                 // Remove from gridData
-                const idx = window.gridData.findIndex(r => r.iddatadb === deleteIddatadb);
+                const idx = window.gridData.findIndex(
+                    (r) => r.iddatadb === deleteIddatadb,
+                );
                 if (idx >= 0) window.gridData.splice(idx, 1);
 
                 // Re-render
                 const gr = window.gridRenderer;
                 if (gr) gr.renderVisibleRows();
             } else {
-                alert('Error: ' + result.message);
+                alert("Error: " + result.message);
             }
         } catch (e) {
-            alert('Error: ' + e.message);
+            alert("Error: " + e.message);
         }
 
         deleteIddatadb = null;
@@ -156,20 +180,26 @@
     });
 
     // ── Add new row ──────────────────────────────────────────────────────
-    $(document).on('click', '#addRowBtn', async function () {
+    $(document).on("click", "#addRowBtn", async function () {
         const btn = this;
         btn.disabled = true;
 
         try {
             const templateId = window.gridMeta?.templateId;
-            if (!templateId) { alert('Template ID missing'); return; }
+            if (!templateId) {
+                alert("Template ID missing");
+                return;
+            }
 
             const urlParams = new URLSearchParams(window.location.search);
-            const importref = urlParams.get('importref') || '';
+            const importref = urlParams.get("importref") || "";
-            const resp = await fetch('add_record.php', {
+            const resp = await fetch("add_record.php", {
-                method: 'POST',
+                method: "POST",
-                headers: { 'Content-Type': 'application/json' },
+                headers: { "Content-Type": "application/json" },
-                body: JSON.stringify({ template_id: templateId, importreferencecode: importref })
+                body: JSON.stringify({
+                    template_id: templateId,
+                    importreferencecode: importref,
+                }),
             });
             const result = await resp.json();
 
@@ -177,17 +207,20 @@
                 // Build new row object
                 const newRow = {
                     iddatadb: result.iddatadb,
-                    status: 'i',
+                    status: "i",
-                    idclient: window.gridMeta?.defaultIdclient || '',
+                    idclient: window.gridMeta?.defaultIdclient || "",
                     cliente_fornitore_id: null,
                     commessaweb: null,
-                    user_name: result.user_name || '',
+                    user_name: result.user_name || "",
-                    importreferencecode: result.importreferencecode || '',
+                    importreferencecode: result.importreferencecode || "",
-                    filename_import: '',
+                    filename_import: "",
-                    importdate: new Date().toISOString().slice(0, 19).replace('T', ' '),
+                    importdate: new Date()
+                        .toISOString()
+                        .slice(0, 19)
+                        .replace("T", " "),
                     fixedFields: {},
                     details: {},
-                    mainFieldValue: '',
+                    mainFieldValue: "",
                     _dirty: false,
                 };
 
@@ -199,20 +232,27 @@
                 if (gr) gr.renderVisibleRows();
 
                 // Highlight new row briefly
-                const newGridRow = document.querySelector(`.grid-row[data-id="${result.iddatadb}"]`);
+                const newGridRow = document.querySelector(
+                    `.grid-row[data-id="${result.iddatadb}"]`,
+                );
                 if (newGridRow) {
-                    newGridRow.classList.add('row-just-created');
+                    newGridRow.classList.add("row-just-created");
-                    newGridRow.scrollIntoView({ behavior: 'smooth', block: 'center' });
+                    newGridRow.scrollIntoView({
-                    setTimeout(() => newGridRow.classList.remove('row-just-created'), 4000);
+                        behavior: "smooth",
+                        block: "center",
+                    });
+                    setTimeout(
+                        () => newGridRow.classList.remove("row-just-created"),
+                        4000,
+                    );
                 }
             } else {
-                alert('Error: ' + (result.message || 'Unknown error'));
+                alert("Error: " + (result.message || "Unknown error"));
             }
         } catch (e) {
-            alert('Error: ' + e.message);
+            alert("Error: " + e.message);
         } finally {
             btn.disabled = false;
         }
     });
-
 })();

public/userarea/partsTable.js

@@ -1595,7 +1595,11 @@ $(document).ready(function () {
                 dataType: "json",
                 delay: 150,
                 data: function (params) {
-                    return { q: params.term || "", limit: 20, macro: selectedMacro || "" };
+                    return {
+                        q: params.term || "",
+                        limit: 20,
+                        macro: selectedMacro || "",
+                    };
                 },
                 processResults: function (data) {
                     return { results: data.results || [] };
@@ -1654,7 +1658,11 @@ $(document).ready(function () {
                 dataType: "json",
                 delay: 150,
                 data: function (params) {
-                    return { q: params.term || "", limit: 20, macro: selectedMacro || "" };
+                    return {
+                        q: params.term || "",
+                        limit: 20,
+                        macro: selectedMacro || "",
+                    };
                 },
                 processResults: function (data) {
                     return { results: data.results || [] };
@@ -1800,7 +1808,9 @@ $(document).ready(function () {
             $("#partsTableBody .part-matrice").each(function () {
                 const $target = $(this);
                 if (!$target.find(`option[value="${globalVal}"]`).length) {
-                    $target.append(new Option(globalText, globalVal, true, true));
+                    $target.append(
+                        new Option(globalText, globalVal, true, true),
+                    );
                 }
                 $target.val(globalVal).trigger("change");
             });
@@ -1969,7 +1979,109 @@ $(document).ready(function () {
         ".add-row-global, .add-mix-global, .add-mix-row, .remove-row, .propagate-matrice-btn, .propagate-all-btn, .note-btn",
         markUnsaved,
     );
+    $(document).on("click", "#clonePartsBtn", function (e) {
+        e.preventDefault();
 
+        const sourceIddatadb =
+            parseInt($("#partsModal").data("iddatadb"), 10) || null;
+        const visibleListRaw =
+            $("#partsModal").data("visible-iddatadb-list") || [];
+
+        if (!sourceIddatadb) {
+            const errorMsg = $(
+                '<div class="alert alert-danger temp-alert" role="alert">Source record not found.</div>',
+            );
+            $("#partsModal .modal-body").prepend(errorMsg);
+            setTimeout(() => {
+                errorMsg.fadeOut(500, function () {
+                    $(this).remove();
+                });
+            }, 5000);
+            return;
+        }
+
+        const targetIds = (Array.isArray(visibleListRaw) ? visibleListRaw : [])
+            .map((v) => parseInt(v, 10))
+            .filter((v) => !isNaN(v) && v > 0 && v !== sourceIddatadb);
+
+        if (!targetIds.length) {
+            const errorMsg = $(
+                '<div class="alert alert-warning temp-alert" role="alert">No other visible records available for clone.</div>',
+            );
+            $("#partsModal .modal-body").prepend(errorMsg);
+            setTimeout(() => {
+                errorMsg.fadeOut(500, function () {
+                    $(this).remove();
+                });
+            }, 5000);
+            return;
+        }
+
+        if (
+            !confirm(
+                `Confermi il clone delle parti del record ${sourceIddatadb} negli altri ${targetIds.length} record visibili?`,
+            )
+        ) {
+            return;
+        }
+
+        const $btn = $(this);
+        const originalHtml = $btn.html();
+        $btn.prop("disabled", true).html(
+            '<i class="fas fa-spinner fa-spin"></i> Clonazione...',
+        );
+
+        $.ajax({
+            url: "clone_parts_to_visible.php",
+            method: "POST",
+            contentType: "application/json",
+            dataType: "json",
+            data: JSON.stringify({
+                source_iddatadb: sourceIddatadb,
+                target_iddatadb_list: targetIds,
+            }),
+            success: function (response) {
+                $btn.prop("disabled", false).html(originalHtml);
+
+                if (response.success) {
+                    const successMsg = $(
+                        `<div class="alert alert-success temp-alert" role="alert">
+                            Clone completed. Source parts copied to ${response.cloned_targets || 0} record(s), total cloned parts: ${response.total_cloned_parts || 0}.
+                        </div>`,
+                    );
+                    $("#partsModal .modal-body").prepend(successMsg);
+                    setTimeout(() => {
+                        successMsg.fadeOut(500, function () {
+                            $(this).remove();
+                        });
+                    }, 5000);
+                } else {
+                    const errorMsg = $(
+                        `<div class="alert alert-danger temp-alert" role="alert">Clone error: ${response.message || "Unknown error"}</div>`,
+                    );
+                    $("#partsModal .modal-body").prepend(errorMsg);
+                    setTimeout(() => {
+                        errorMsg.fadeOut(500, function () {
+                            $(this).remove();
+                        });
+                    }, 5000);
+                }
+            },
+            error: function (xhr, status, error) {
+                $btn.prop("disabled", false).html(originalHtml);
+
+                const errorMsg = $(
+                    `<div class="alert alert-danger temp-alert" role="alert">Clone error: ${error} (${xhr.status})</div>`,
+                );
+                $("#partsModal .modal-body").prepend(errorMsg);
+                setTimeout(() => {
+                    errorMsg.fadeOut(500, function () {
+                        $(this).remove();
+                    });
+                }, 5000);
+            },
+        });
+    });
     // Esporta la funzione loadParts per essere usata da import_Edit2.php
     window.loadParts = loadParts;
 

public/userarea/schemi_base_response.json

@@ -760,7 +760,7 @@
         {
             "IdSchemaCustomFields": 182,
             "ConteggioClienti": 0,
-            "Nome": "Ralph Lauren - All testing V.6",
+            "Nome": "Ralph Lauren - All testing V.10",
             "Descrizione": "AGGIORNAMENTO AL 16\/03\/2026 per estrazione fatturazione"
         },
         {
@@ -876,6 +876,12 @@
             "ConteggioClienti": 0,
             "Nome": "ROSSIMODA",
             "Descrizione": "Per tutti i campioni di ROSSIMODA\r\n\r\n"
+        },
+        {
+            "IdSchemaCustomFields": 202,
+            "ConteggioClienti": 0,
+            "Nome": "LIMS-CIM - MAX MARA",
+            "Descrizione": "Schema per MAX MARA scambio dati Database"
         }
     ]
 }

public/userarea/tolims.php

@@ -2016,6 +2016,51 @@ function resolveFixedValue(string $key, $val, array $fixedLookup): string {
                 el.addEventListener('change', () => el.classList.toggle('has-value', el.value.trim() !== ''));
             });
         })();
+
+        // ── Column resize ──
+        (function() {
+            const resizers = document.querySelectorAll('.resizer');
+            let currentResizer = null, startX = 0, startWidth = 0, columnIndex = null;
+
+            function resize(e) {
+                if (!currentResizer || columnIndex === null) return;
+                const newWidth = Math.max(80, startWidth + (e.pageX - startX));
+                const sel = '[data-index="' + columnIndex + '"]';
+                const header = document.querySelector('.grid-header' + sel);
+                if (header) header.style.flex = '0 0 ' + newWidth + 'px';
+                const topCell = document.querySelector('.grid-top .grid-cell' + sel);
+                if (topCell) topCell.style.flex = '0 0 ' + newWidth + 'px';
+                document.querySelectorAll('.grid-row .grid-cell' + sel).forEach(function(cell) {
+                    cell.style.flex = '0 0 ' + newWidth + 'px';
+                });
+                var filterCell = document.querySelector('#gridFilterRow > .grid-cell:nth-child(' + (parseInt(columnIndex, 10) + 1) + ')');
+                if (filterCell) filterCell.style.flex = '0 0 ' + newWidth + 'px';
+            }
+
+            function stopResize() {
+                if (currentResizer) {
+                    document.removeEventListener('mousemove', resize);
+                    document.removeEventListener('mouseup', stopResize);
+                    currentResizer = null;
+                    columnIndex = null;
+                }
+            }
+
+            resizers.forEach(function(resizer) {
+                resizer.addEventListener('mousedown', function(e) {
+                    e.preventDefault();
+                    e.stopPropagation();
+                    currentResizer = this;
+                    var header = this.closest('.grid-header');
+                    if (!header) return;
+                    columnIndex = header.getAttribute('data-index');
+                    startX = e.pageX;
+                    startWidth = header.offsetWidth;
+                    document.addEventListener('mousemove', resize);
+                    document.addEventListener('mouseup', stopResize);
+                });
+            });
+        })();
     </script>
 </body>
 </html>