For the validation I have an issue which is that the trigger does not appear in the autoaction list.
Code:
$upload = $variables['var3']->getRaw( '_files' )->subTree( 'upload' );
$fileName = $upload->getString('name', '');
if (pathinfo($fileName, PATHINFO_EXTENSION) === 'csv') {
$filePath = $upload->getString('tmp_name', '');
$validationResult = validateCSV($filePath);
if (!$validationResult['status']) {
$variables['var3']->setError( 'ERROR_MESSAGE_HERE' );
}
}
function validateCSV($filePath)
{
if (($handle = fopen($filePath, 'r')) !== FALSE) {
$lineNumber = 0;
$columnCount = null;
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
$lineNumber++;
if ($columnCount === null) {
$columnCount = count($data);
}
if (count($data) != $columnCount) {
fclose($handle);
return [
'status' => false,
'message' => "Le fichier CSV est mal formaté. Ligne $lineNumber a un nombre incorrect de colonnes."
];
}
foreach ($data as $field) {
if (mb_detect_encoding($field, 'UTF-8', true) === false) {
fclose($handle);
return [
'status' => false,
'message' => "Le fichier CSV contient des caractères non UTF-8 à la ligne $lineNumber."
];
}
}
}
fclose($handle);
return [
'status' => true,
'message' => "Le fichier CSV est bien formaté."
];
} else {
return [
'status' => false,
'message' => "Impossible d'ouvrir le fichier."
];
}
}
krileon
