<?php
class ImportAssistant {
public static function extractMappingsFromRequest(array $allowedFields, string $inputKey = 'import_mapping'): array {
$rawMappings = $_POST[$inputKey] ?? [];
if (!is_array($rawMappings)) {
return [];
}
$mappings = [];
foreach (array_keys($allowedFields) as $field) {
$value = trim((string) ($rawMappings[$field] ?? ''));
if ($value !== '') {
$mappings[$field] = $value;
}
}
return $mappings;
}
public static function normalizeMappings(array $allowedFields, array $mappings): array {
$normalized = [];
foreach (array_keys($allowedFields) as $field) {
$normalized[$field] = trim((string) ($mappings[$field] ?? ''));
}
return $normalized;
}
public static function mapRow(array $row, array $allowedFields, array $mappings = []): array {
$normalizedRow = [];
foreach ($row as $header => $value) {
$normalizedRow[self::normalizeKey((string) $header)] = $value;
}
$result = [];
foreach (array_keys($allowedFields) as $field) {
$mappedHeader = trim((string) ($mappings[$field] ?? ''));
if ($mappedHeader !== '') {
$result[$field] = $normalizedRow[self::normalizeKey($mappedHeader)] ?? '';
continue;
}
$result[$field] = $normalizedRow[self::normalizeKey($field)] ?? '';
}
return $result;
}
public static function normalizeKey(string $value): string {
$value = trim(mb_strtolower($value, 'UTF-8'));
$value = str_replace(['é', 'è', 'ê', 'ë'], 'e', $value);
$value = str_replace(['à', 'â', 'ä'], 'a', $value);
$value = str_replace(['î', 'ï'], 'i', $value);
$value = str_replace(['ô', 'ö'], 'o', $value);
$value = str_replace(['ù', 'û', 'ü'], 'u', $value);
$value = str_replace(['ç'], 'c', $value);
$value = preg_replace('/[^a-z0-9]+/u', '_', $value) ?? $value;
return trim($value, '_');
}
}