git ignore edit

update main field and git ignore
added fill dropdown and save id
2025-08-20 17:37:22 +02:00 · 2025-08-20 17:30:13 +02:00 · 2025-08-19 16:33:11 +02:00
9 changed files with 1353 additions and 34 deletions
@@ -36,3 +36,10 @@ auth.json
 # Ignora cartelle di foto generate
 /public/photostrf/
 /public/photostrf/qrcodes/
+public/userarea/import_debug.log
+public/userarea/last_url.txt
+public/userarea/class/curl_auth_debug.log
+public/userarea/class/curl_request_debug.log
+public/userarea/last_url.txt
+public/userarea/class/curl_auth_debug.log
+public/userarea/class/curl_request_debug.log
@@ -31,6 +31,6 @@ Content-Length: 51
 < strict-transport-security: max-age=2592000
 < x-powered-by: ASP.NET
 < x-content-type-options: nosniff
-< date: Wed, 30 Jul 2025 13:38:07 GMT
+< date: Wed, 20 Aug 2025 15:35:19 GMT
 < 
 * Connection #0 to host 93.43.5.102 left intact
@@ -10,16 +10,16 @@
 *  issuer: C=US; O=Corporation Service Company; CN=Corporation Service Company RSA OV SSL CA
 *  SSL certificate verify result: unable to get local issuer certificate (20), continuing anyway.
 * using HTTP/2
-* [HTTP/2] [1] OPENED stream for https://93.43.5.102/limsapi/api/odata/CustomField(1083)?$expand=CustomFieldsValues
+* [HTTP/2] [1] OPENED stream for https://93.43.5.102/limsapi/api/odata/SchemaCustomField
 * [HTTP/2] [1] [:method: GET]
 * [HTTP/2] [1] [:scheme: https]
 * [HTTP/2] [1] [:authority: 93.43.5.102]
-* [HTTP/2] [1] [:path: /limsapi/api/odata/CustomField(1083)?$expand=CustomFieldsValues]
-* [HTTP/2] [1] [authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1Mzg4OTg4NywiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.fka4MClGYcSJycwopdVtHtp-59VPTCgT_waRi8qdLmE]
+* [HTTP/2] [1] [:path: /limsapi/api/odata/SchemaCustomField]
+* [HTTP/2] [1] [authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1NTcxMTMxOSwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.jY0MCCCy94eGWlodWV1TPv2SeQ7me_Hf1MJmU6TbVik]
 * [HTTP/2] [1] [accept: application/json]
-> GET /limsapi/api/odata/CustomField(1083)?$expand=CustomFieldsValues HTTP/2
+> GET /limsapi/api/odata/SchemaCustomField HTTP/2
 Host: 93.43.5.102
-Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1Mzg4OTg4NywiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.fka4MClGYcSJycwopdVtHtp-59VPTCgT_waRi8qdLmE
+Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjQ5MiIsIlhhZlNlY3VyaXR5QXV0aFBhc3NlZCI6IlhhZlNlY3VyaXR5QXV0aFBhc3NlZCIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJXZWJBcGlVc2VyIiwiWGFmU2VjdXJpdHkiOiJYYWZTZWN1cml0eSIsIlhhZkxvZ29uUGFyYW1zIjoicTFZS0xVNHQ4a3ZNVFZXeVVncFBUWElzeUFRSktPa29CU1FXRjVmbkY2VUF4Y3RUa3hJTE1rdUI0Z2FHU3JVQSIsImV4cCI6MTc1NTcxMTMxOSwiaXNzIjoiTXkiLCJhdWQiOiJodHRwOi8vbG9jYWxob3N0OjQyMDAifQ.jY0MCCCy94eGWlodWV1TPv2SeQ7me_Hf1MJmU6TbVik
 Accept: application/json

 < HTTP/2 200 
@@ -30,6 +30,6 @@ Accept: application/json
 < odata-version: 4.0
 < x-powered-by: ASP.NET
 < x-content-type-options: nosniff
-< date: Wed, 30 Jul 2025 13:38:08 GMT
+< date: Wed, 20 Aug 2025 15:35:19 GMT
 < 
 * Connection #0 to host 93.43.5.102 left intact
@@ -5,3 +5,4 @@
 2025-07-04 10:42:49 - Autenticazione fallita: HTTP 400, Errore cURL: , Risposta: {"title":"Bad Request","status":400,"detail":"Cannot persist the object. It was modified or deleted (purged) by another application.","instance":"POST /api/authentication/authenticate","errorCode":"96bfc1252b"}
 2025-07-04 10:44:13 - Autenticazione fallita: HTTP 400, Errore cURL: , Risposta: {"title":"Bad Request","status":400,"detail":"Cannot persist the object. It was modified or deleted (purged) by another application.","instance":"POST /api/authentication/authenticate","errorCode":"96bfc1252b"}
 2025-07-04 10:48:07 - Autenticazione fallita: HTTP 400, Errore cURL: , Risposta: {"title":"Bad Request","status":400,"detail":"Cannot persist the object. It was modified or deleted (purged) by another application.","instance":"POST /api/authentication/authenticate","errorCode":"96bfc1252b"}
+2025-08-19 16:29:25 - Autenticazione fallita: HTTP 400, Errore cURL: , Risposta: {"title":"Bad Request","status":400,"detail":"Cannot persist the object. It was modified or deleted (purged) by another application.","instance":"POST /api/authentication/authenticate","errorCode":"96bfc1252b"}
@@ -78,3 +78,13 @@ https://93.43.5.102/limsapi/api/odata/SchemaCustomField
 https://93.43.5.102/limsapi/api/odata/SchemaCustomField
 https://93.43.5.102/limsapi/api/odata/SchemaCustomField
 https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
+https://93.43.5.102/limsapi/api/odata/SchemaCustomField
@@ -21,7 +21,7 @@ $schemajson = $template['schemajson'] ? json_decode($template['schemajson'], tru
 $isSchemajsonEmpty = empty(trim($template['schemajson']));

 // Recupera i campi dalla tabella template_mapping
-$stmt = $pdo->prepare("SELECT id, field_id, excel_column, is_manual, manual_default, data_type, is_required, default_value, has_list, length, decimals, min_value, max_value, default_curr_date, tablename, field_label FROM template_mapping WHERE template_id = ?");
+$stmt = $pdo->prepare("SELECT id, field_id, excel_column, is_manual, manual_default, data_type, is_required, default_value, has_list, length, decimals, min_value, max_value, default_curr_date, tablename, field_label, main_field FROM template_mapping WHERE template_id = ?");
 $stmt->execute([$id]);
 $mappings = $stmt->fetchAll(PDO::FETCH_ASSOC);

@@ -42,6 +42,52 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
    <?php include('cssinclude.php'); ?>
    <title>Configure Template <?= htmlspecialchars($template['name'], ENT_QUOTES, 'UTF-8'); ?></title>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
+    <style>
+        .dropdown-select {
+            width: 100%;
+            box-sizing: border-box;
+            border: 1px solid #ced4da;
+            border-radius: 4px;
+            padding: 5px;
+            font-size: 14px;
+            appearance: none;
+            background: white url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="12" height="12" fill="%23333"><path d="M7.293 4.293a1 1 0 011.414 0L10 6.586l1.293-1.293a1 1 0 111.414 1.414l-2 2a1 1 0 01-1.414 0l-2-2a1 1 0 010-1.414z"/></svg>') no-repeat right 5px center;
+        }
+
+        .dropdown-select:focus {
+            outline: none;
+            border-color: #80bdff;
+            box-shadow: 0 0 5px rgba(0, 123, 255, 0.5);
+        }
+
+        #loading-overlay {
+            display: none;
+            position: fixed;
+            top: 0;
+            left: 0;
+            width: 100%;
+            height: 100%;
+            background: rgba(0, 0, 0, 0.7);
+            z-index: 9999;
+            justify-content: center;
+            align-items: center;
+        }
+
+        #loading-overlay div {
+            color: white;
+            font-size: 24px;
+            padding: 20px;
+            background: #333;
+            border-radius: 10px;
+            box-shadow: 0 0 10px rgba(0, 0, 0, 0.5);
+        }
+
+        #schemaFieldsTable th:first-child,
+        #schemaFieldsTable td:first-child {
+            width: 50px;
+            text-align: center;
+        }
+    </style>
 </head>

 <body>
@@ -90,6 +136,7 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                                <table id="schemaFieldsTable" class="table table-striped">
                                    <thead>
                                        <tr>
+                                            <th>Main</th>
                                            <th>Title</th>
                                            <th>ID</th>
                                            <th>Type</th>
@@ -100,23 +147,38 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                                    <tbody id="schemaFieldsBody">
                                        <?php foreach ($mappings as $mapping): ?>
                                            <tr>
+                                                <td>
+                                                    <input type="checkbox" class="main-field-checkbox" data-mapping-id="<?php echo $mapping['id']; ?>" <?php echo $mapping['main_field'] == 1 ? 'checked' : ''; ?>>
+                                                </td>
                                                <td><?php echo htmlspecialchars($mapping['field_label'] ?? 'N/A'); ?></td>
                                                <td><?php echo htmlspecialchars($mapping['field_id'] ?? 'N/A'); ?></td>
                                                <td><?php echo htmlspecialchars($mapping['data_type'] ?? 'N/A'); ?></td>
                                                <td>
-                                                    <select class="form-select mapping-select" data-id="<?php echo $mapping['id']; ?>" data-field-id="<?php echo $mapping['field_id']; ?>">
-                                                        <option value="">Select Option</option>
-                                                        <option value="xls" <?php echo !$mapping['is_manual'] && $mapping['excel_column'] ? 'selected' : ''; ?>>Map to XLS Column</option>
-                                                        <option value="manual" <?php echo $mapping['is_manual'] ? 'selected' : ' '; ?>>Manual Entry</option>
+                                                    <?php
+                                                    $isSceltaMultipla = $mapping['data_type'] === 'SceltaMultipla';
+                                                    $mappingValue = $isSceltaMultipla ? 'manual' : ($mapping['excel_column'] ? 'xls' : ($mapping['is_manual'] ? 'manual' : ''));
+                                                    ?>
+                                                    <select class="form-select mapping-select" data-id="<?php echo $mapping['id']; ?>" data-field-id="<?php echo $mapping['field_id']; ?>" <?php echo $isSceltaMultipla ? 'disabled' : ''; ?>>
+                                                        <?php if (!$isSceltaMultipla): ?>
+                                                            <option value="">Select Option</option>
+                                                            <option value="xls" <?php echo $mappingValue === 'xls' ? 'selected' : ''; ?>>Map to XLS Column</option>
+                                                        <?php endif; ?>
+                                                        <option value="manual" <?php echo $mappingValue === 'manual' ? 'selected' : ''; ?>>Manual Entry</option>
                                                    </select>
-                                                    <select class="form-select xls-columns" style="display:<?php echo !$mapping['is_manual'] && $mapping['excel_column'] ? 'block' : 'none'; ?>" data-id="<?php echo $mapping['id']; ?>" <?php echo $mapping['excel_column'] ? 'data-current-xls="' . htmlspecialchars($mapping['excel_column']) . '"' : ''; ?>></select>
+                                                    <select class="form-select xls-columns" style="display:<?php echo $mappingValue === 'xls' ? 'block' : 'none'; ?>" data-id="<?php echo $mapping['id']; ?>" <?php echo $mapping['excel_column'] ? 'data-current-xls="' . htmlspecialchars($mapping['excel_column']) . '"' : ''; ?>></select>
                                                    <?php if ($mapping['excel_column']): ?>
                                                        <span class="mapped-column" style="margin-left: 5px;"><?php echo htmlspecialchars($mapping['excel_column']); ?></span>
                                                        <button class="btn btn-danger btn-sm remove-xls" data-id="<?php echo $mapping['id']; ?>" style="margin-left: 5px;">X</button>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
-                                                    <input type="text" class="form-control manual-default" placeholder="Default value" value="<?php echo htmlspecialchars($mapping['manual_default'] ?? ''); ?>" style="display:<?php echo $mapping['is_manual'] ? 'block' : 'none'; ?>" data-field-id="<?php echo $mapping['field_id']; ?>">
+                                                    <?php if ($mapping['data_type'] === 'SceltaMultipla'): ?>
+                                                        <select class="form-select dropdown-select manual-default" data-id="<?php echo $mapping['id']; ?>" data-field-id="<?php echo $mapping['field_id']; ?>" data-manual-default="<?php echo htmlspecialchars($mapping['manual_default'] ?? ''); ?>" style="display:block;">
+                                                            <option value="">Seleziona...</option>
+                                                        </select>
+                                                    <?php else: ?>
+                                                        <input type="text" class="form-control manual-default" placeholder="Default value" value="<?php echo htmlspecialchars($mapping['manual_default'] ?? ''); ?>" style="display:<?php echo $mapping['is_manual'] ? 'block' : 'none'; ?>" data-field-id="<?php echo $mapping['field_id']; ?>">
+                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                        <?php endforeach; ?>
@@ -138,6 +200,7 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
    </div>

    <?php include('jsinclude.php'); ?>
+    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script>
        let availableXlsColumns = <?php echo json_encode($xlsHeaders); ?> || [];
        let usedColumnsFromDB = <?php echo json_encode($usedColumnsFromDB); ?> || [];
@@ -180,8 +243,8 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    type: 'array'
                });
                let sheet = workbook.Sheets[workbook.SheetNames[0]];
-                let rowIndex = parseInt(document.getElementById('headerRow').textContent) || 1; // Usa header_row dal template
-                let startColumn = parseInt(document.getElementById('startColumn').textContent) || 1; // Usa start_column come numero
+                let rowIndex = parseInt(document.getElementById('headerRow').textContent) || 1;
+                let startColumn = parseInt(document.getElementById('startColumn').textContent) || 1;

                let sheetData = XLSX.utils.sheet_to_json(sheet, {
                    header: 1,
@@ -189,7 +252,7 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    raw: false,
                    range: 0
                });
-                console.log("Dati della riga " + rowIndex + ":", sheetData[rowIndex - 1]); // Debug: stampa la riga delle intestazioni
+                console.log("Dati della riga " + rowIndex + ":", sheetData[rowIndex - 1]);
                if (!sheetData[rowIndex - 1]) {
                    document.getElementById('schemaFieldsBody').querySelectorAll('select.xls-columns').forEach(select => {
                        select.innerHTML = '<option value="">Nessuna intestazione trovata</option>';
@@ -197,11 +260,10 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    return;
                }

-                // Estrai le intestazioni a partire dalla colonna specificata, includendo le vuote
                let headers = sheetData[rowIndex - 1].slice(startColumn - 1).map(header => header === undefined ? "" : header);
-                console.log("Intestazioni estratte:", headers); // Debug: stampa le intestazioni estratte
+                console.log("Intestazioni estratte:", headers);
                availableXlsColumns = [...headers];
-                usedColumnsFromDB = []; // Resetta le colonne usate dopo un nuovo caricamento
+                usedColumnsFromDB = [];
                saveXlsHeaders(headers);
                updateXlsDropdowns();
            };
@@ -229,18 +291,18 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
            let usedColumns = Array.from(document.querySelectorAll('select.xls-columns'))
                .filter(select => select.style.display === 'block' && select.value)
                .map(select => select.value)
-                .concat(usedColumnsFromDB); // Aggiunge le colonne già salvate nel DB
+                .concat(usedColumnsFromDB);

            document.querySelectorAll('select.xls-columns').forEach(select => {
                let currentValue = select.value || select.dataset.currentXls || '';
                let options = availableXlsColumns
-                    .filter(col => !usedColumns.includes(col) || col === currentValue) // Esclude colonne già usate, tranne la corrente
+                    .filter(col => !usedColumns.includes(col) || col === currentValue)
                    .map(col => `<option value="${col}" ${col === currentValue ? 'selected' : ''}>${col}</option>`)
                    .join('');
                select.innerHTML = '<option value="">Select XLS Column</option>' + options;
                select.dataset.currentXls = currentValue;
                if (currentValue && !options.includes(currentValue)) {
-                    select.value = ''; // Reset se il valore non è più valido
+                    select.value = '';
                }
            });
        }
@@ -250,6 +312,70 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
            let schemaId = <?php echo json_encode($template['idschema'] ?? 0); ?>;
            let isSchemajsonEmpty = <?php echo json_encode($isSchemajsonEmpty); ?>;

+            // Crea l'overlay di caricamento
+            const loadingOverlay = document.createElement('div');
+            loadingOverlay.id = 'loading-overlay';
+            loadingOverlay.innerHTML = '<div>Loading Dropdown Options...</div>';
+            document.body.appendChild(loadingOverlay);
+
+            async function populateDropdowns() {
+                const dropdowns = document.querySelectorAll('.dropdown-select');
+                if (dropdowns.length === 0) return;
+
+                const dropdownData = {};
+
+                // Recupera i dati solo per i field_id univoci
+                const uniqueFieldIds = [...new Set(Array.from(dropdowns).map(d => d.getAttribute('data-field-id')))].filter(fieldId => fieldId);
+                for (const fieldId of uniqueFieldIds) {
+                    if (!dropdownData[fieldId]) {
+                        try {
+                            const response = await fetch(`get_customfield_values.php?field_id=${fieldId}`);
+                            const data = await response.json();
+                            if (data.error) {
+                                console.error('Errore per field_id', fieldId, ':', data.error);
+                                continue;
+                            }
+                            dropdownData[fieldId] = data.CustomFieldsValues || [];
+                        } catch (error) {
+                            console.error('Errore nel fetch per field_id', fieldId, ':', error);
+                        }
+                    }
+                }
+
+                // Popola tutti i dropdown con i dati recuperati
+                dropdowns.forEach(dropdown => {
+                    const fieldId = dropdown.getAttribute('data-field-id');
+                    const manualDefault = dropdown.getAttribute('data-manual-default') || '';
+                    if (!fieldId || !dropdownData[fieldId]) {
+                        dropdown.innerHTML = '<option value="">Errore nel caricamento</option>';
+                        return;
+                    }
+
+                    dropdown.innerHTML = '<option value="">Seleziona...</option>';
+                    dropdownData[fieldId].forEach(value => {
+                        const option = document.createElement('option');
+                        option.value = value.IdCustomFieldsValue;
+                        option.textContent = value.Valore;
+                        if (manualDefault === String(value.IdCustomFieldsValue)) {
+                            option.selected = true;
+                        }
+                        dropdown.appendChild(option);
+                    });
+                });
+            }
+
+            // Carica i dropdown con overlay
+            async function loadDropdownsWithOverlay() {
+                console.log('Inizio caricamento tendine');
+                loadingOverlay.style.display = 'flex';
+                await new Promise(resolve => setTimeout(resolve, 500));
+                await populateDropdowns();
+                console.log('Caricamento tendine completato');
+                loadingOverlay.style.display = 'none';
+            }
+
+            loadDropdownsWithOverlay();
+
            async function loadClientAndSchemaNames() {
                if (<?php echo json_encode($template['idclient'] ?? 0); ?> > 0) {
                    let response = await fetch(`get_clienti.php?id=<?php echo $template['idclient']; ?>`);
@@ -267,7 +393,7 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t

            async function updateSchemaDetails() {
                if (!schemaId) {
-                    document.getElementById('schemaFieldsBody').innerHTML = '<tr><td colspan="5" class="text-warning">No schema associated.</td></tr>';
+                    document.getElementById('schemaFieldsBody').innerHTML = '<tr><td colspan="6" class="text-warning">No schema associated.</td></tr>'; // Aggiornato colspan a 6
                    return;
                }

@@ -284,7 +410,7 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    await saveSchemaJson(templateId, JSON.stringify(data));
                    alert('Schema updated successfully. Refresh the page to see changes.');
                } catch (error) {
-                    document.getElementById('schemaFieldsBody').innerHTML = '<tr><td colspan="5" class="text-danger">Error: ' + error.message + '</td></tr>';
+                    document.getElementById('schemaFieldsBody').innerHTML = '<tr><td colspan="6" class="text-danger">Error: ' + error.message + '</td></tr>'; // Aggiornato colspan a 6
                } finally {
                    updateSchemaButton.disabled = false;
                    updateSchemaButton.textContent = 'Update Schema Details';
@@ -336,9 +462,66 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    }
                    saveMapping(mappingId, event.target.value, manualInput.value, xlsSelect.value);
                    updateXlsDropdowns();
+                } else if (event.target.classList.contains('main-field-checkbox')) {
+                    const checkbox = event.target;
+                    const mappingId = checkbox.dataset.mappingId;
+                    const value = checkbox.checked ? 1 : 0;
+
+                    // Se checked, deseleziona tutti gli altri visivamente
+                    if (checkbox.checked) {
+                        document.querySelectorAll('.main-field-checkbox').forEach(cb => {
+                            if (cb !== checkbox) cb.checked = false;
+                        });
+                    }
+
+                    // Salva l'aggiornamento
+                    fetch('update_main_field.php', {
+                            method: 'POST',
+                            headers: {
+                                'Content-Type': 'application/json'
+                            },
+                            body: JSON.stringify({
+                                template_id: <?php echo $id; ?>,
+                                mapping_id: mappingId,
+                                value: value
+                            })
+                        }).then(response => response.json())
+                        .then(data => {
+                            if (!data.success) {
+                                console.error("❌ Error updating main_field:", data.message);
+                                // Revert checkbox state on error
+                                checkbox.checked = !checkbox.checked;
+                                // Riselezione visiva degli altri se errore
+                                if (value === 1) {
+                                    document.querySelectorAll('.main-field-checkbox').forEach(cb => {
+                                        cb.checked = cb.dataset.originalChecked === 'true';
+                                    });
+                                }
+                            } else {
+                                // Aggiorna lo stato originale dopo successo
+                                document.querySelectorAll('.main-field-checkbox').forEach(cb => {
+                                    cb.dataset.originalChecked = cb.checked;
+                                });
+                            }
+                        })
+                        .catch(error => {
+                            console.error("❌ Fetch error:", error);
+                            checkbox.checked = !checkbox.checked;
+                            // Riselezione visiva degli altri se errore
+                            if (value === 1) {
+                                document.querySelectorAll('.main-field-checkbox').forEach(cb => {
+                                    cb.checked = cb.dataset.originalChecked === 'true';
+                                });
+                            }
+                        });
                }
            });

+            // Salva lo stato originale dei checkbox al caricamento
+            document.querySelectorAll('.main-field-checkbox').forEach(cb => {
+                cb.dataset.originalChecked = cb.checked;
+            });
+
            document.getElementById('schemaFieldsBody').addEventListener('change', function(event) {
                if (event.target.classList.contains('xls-columns')) {
                    let tr = event.target.closest('tr');
@@ -347,12 +530,11 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                    let mappedColumn = tr.querySelector('.mapped-column');
                    let removeBtn = tr.querySelector('.remove-xls');

-                    // Aggiungi dinamicamente mappedColumn e removeBtn se non esistono
                    if (!mappedColumn) {
                        mappedColumn = document.createElement('span');
                        mappedColumn.className = 'mapped-column';
                        mappedColumn.style.marginLeft = '5px';
-                        tr.querySelector('td:nth-child(4)').appendChild(mappedColumn);
+                        tr.querySelector('td:nth-child(5)').appendChild(mappedColumn); // Aggiornato a nth-child(5) per la nuova colonna
                    }
                    if (!removeBtn) {
                        removeBtn = document.createElement('button');
@@ -360,9 +542,8 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                        removeBtn.textContent = 'X';
                        removeBtn.style.marginLeft = '5px';
                        removeBtn.setAttribute('data-id', mappingId);
-                        tr.querySelector('td:nth-child(4)').appendChild(removeBtn);
+                        tr.querySelector('td:nth-child(5)').appendChild(removeBtn); // Aggiornato a nth-child(5)

-                        // Aggiungi l'event listener per il nuovo pulsante
                        removeBtn.addEventListener('click', function(e) {
                            let tr = e.target.closest('tr');
                            let xlsSelect = tr.querySelector('.xls-columns');
@@ -391,12 +572,25 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                }
            });

+            document.getElementById('schemaFieldsBody').addEventListener('change', function(event) {
+                if (event.target.classList.contains('manual-default') && event.target.tagName === 'SELECT') {
+                    let tr = event.target.closest('tr');
+                    let mappingId = event.target.getAttribute('data-id');
+                    let xlsSelect = tr.querySelector('.xls-columns');
+                    console.log("Manual default dropdown changed:", {
+                        id: mappingId,
+                        value: event.target.value
+                    });
+                    saveMapping(mappingId, 'manual', event.target.value, xlsSelect.value);
+                }
+            });
+
            document.getElementById('schemaFieldsBody').addEventListener('input', function(event) {
-                if (event.target.classList.contains('manual-default')) {
+                if (event.target.classList.contains('manual-default') && event.target.tagName === 'INPUT') {
                    let tr = event.target.closest('tr');
                    let mappingId = tr.querySelector('.mapping-select').getAttribute('data-id');
                    let xlsSelect = tr.querySelector('.xls-columns');
-                    console.log("Manual default changed:", {
+                    console.log("Manual default input changed:", {
                        id: mappingId,
                        value: event.target.value
                    });
@@ -448,8 +642,8 @@ $xlsHeaders = $template['xls_headers'] ? json_decode($template['xls_headers'], t
                        console.log("Save response:", data);
                        if (!data.success) console.error("❌ Error saving mapping:", data.message);
                        if (data.success && excelColumn) {
-                            usedColumnsFromDB = usedColumnsFromDB.filter(col => col !== excelColumn); // Rimuovi dalla lista se salvata
-                            usedColumnsFromDB.push(excelColumn); // Aggiungi la nuova colonna usata
+                            usedColumnsFromDB = usedColumnsFromDB.filter(col => col !== excelColumn);
+                            usedColumnsFromDB.push(excelColumn);
                            updateXlsDropdowns();
                        }
                    })
@@ -0,0 +1,41 @@
+<?php
+ini_set('display_errors', 1);
+ini_set('display_startup_errors', 1);
+error_reporting(E_ALL);
+
+include('include/headscript.php'); // Assumi che questo includa la connessione DB
+
+// Recupera il payload JSON
+$data = json_decode(file_get_contents('php://input'), true);
+
+$template_id = intval($data['template_id']);
+$mapping_id = intval($data['mapping_id']);
+$value = intval($data['value']);
+
+if ($template_id <= 0 || $mapping_id <= 0) {
+    echo json_encode(['success' => false, 'message' => 'Invalid IDs']);
+    exit;
+}
+
+$db = DBHandlerSelect::getInstance();
+$pdo = $db->getConnection();
+
+try {
+    $pdo->beginTransaction();
+
+    if ($value === 1) {
+        // Setta tutti main_field a 0 per questo template
+        $stmt = $pdo->prepare("UPDATE template_mapping SET main_field = 0 WHERE template_id = ?");
+        $stmt->execute([$template_id]);
+    }
+
+    // Setta il valore per questo mapping
+    $stmt = $pdo->prepare("UPDATE template_mapping SET main_field = ? WHERE id = ? AND template_id = ?");
+    $stmt->execute([$value, $mapping_id, $template_id]);
+
+    $pdo->commit();
+    echo json_encode(['success' => true]);
+} catch (Exception $e) {
+    $pdo->rollBack();
+    echo json_encode(['success' => false, 'message' => $e->getMessage()]);
+}
Author	SHA1	Message	Date
solocla	caf5568779	git ignore edit	2025-08-20 17:37:22 +02:00
solocla	0728fd8f01	update main field and git ignore	2025-08-20 17:30:13 +02:00
solocla	434bb0d993	added fill dropdown and save id	2025-08-19 16:33:11 +02:00