getConfiguredType($typeId);
if ($type === null) {
logNewMessage(LOG_ERR, 'User tried to access invalid upload type: ' . $typeId);
die();
}
// check if account type is ok
if ($type->isHidden()) {
logNewMessage(LOG_ERR, 'User tried to access hidden upload: ' . $type->getId());
die();
}
if (!checkIfNewEntriesAreAllowed($type->getId()) || !checkIfWriteAccessIsAllowed($type->getId())) {
logNewMessage(LOG_ERR, 'User tried to access forbidden upload: ' . $type->getId());
die();
}
echo '
';
$container = new htmlResponsiveRow();
$selectedModules = explode(',', $_POST['selectedModules']);
if ($_FILES['inputfile'] && ($_FILES['inputfile']['size'] > 0)) {
// check if input file is well formatted
$data = []; // input values without first row
$ids = []; // =>
// get input fields from modules
$uploadColumns = getUploadColumns($type, $selectedModules);
// read input file
logNewMessage(LOG_DEBUG, 'Reading CSV file');
$handle = fopen($_FILES['inputfile']['tmp_name'], "r");
if ($handle !== false) {
$head = fgetcsv($handle, 2000, escape: '');
if ($head !== false ) { // head row
foreach ($head as $i => $headItem) {
$ids[$headItem] = $i;
}
}
while (($line = fgetcsv($handle, 2000, escape: '')) !== false ) { // account rows
$data[] = $line;
}
fclose($handle);
}
$errors = [];
// check if all required columns are present
$checkcolumns = [];
$columns = [];
foreach ($uploadColumns as $uploadColumn) {
$columns = array_merge($columns, $uploadColumn);
}
foreach ($columns as $column) {
if (isset($column['required']) && ($column['required'] === true)) {
if (isset($ids[$column['name']])) {
$checkcolumns[] = $ids[$column['name']];
}
else {
$errors[] = [_("A required column is missing in your CSV file."), $column['name']];
}
}
}
// check if all required attributes are given
$invalidColumns = [];
$id_names = array_keys($ids);
foreach ($checkcolumns as $checkcolumn) {
foreach ($data as $dataRow) {
if (empty($dataRow[$checkcolumn])) {
$invalidColumns[] = $id_names[$checkcolumn];
break;
}
}
}
foreach ($data as $dataRow) {
if (empty($dataRow[$ids['dn_rdn']])) {
$invalidColumns[] = 'dn_rdn';
break;
}
}
foreach ($invalidColumns as $invalidColumn) {
$errors[] = [_("One or more values of the required column \"$invalidColumn\" are missing."), ""];
}
// check if values in unique columns are correct
foreach ($columns as $column) {
if (isset($column['unique']) && ($column['unique'] === true) && isset($ids[$column['name']])) {
$colNumber = $ids[$column['name']];
$values_given = [];
foreach ($data as $dataRow) {
$values_given[] = $dataRow[$colNumber];
}
$values_unique = array_unique($values_given);
if (count($values_given) !== count($values_unique)) {
$duplicates = [];
foreach ($values_given as $key => $value) {
if (!isset($values_unique[$key]) && ($value !== null) && ($value !== '')) {
$duplicates[] = htmlspecialchars($value);
}
}
if (!empty($duplicates)) {
$duplicates = array_values(array_unique($duplicates));
$errors[] = [_("This column is defined to include unique entries but duplicates were found:") . ' ' . $column['name'], implode(', ', $duplicates)];
}
}
}
}
logNewMessage(LOG_DEBUG, 'End of generic checks');
// if input data is invalid just display error messages (max 50)
if ($errors !== []) {
foreach ($errors as $error) {
$container->add(new htmlStatusMessage("ERROR", $error[0], $error[1]));
}
$container->addVerticalSpacer('2rem');
massPrintBackButton($type->getId(), $selectedModules, $container);
}
// let modules build accounts
else {
$accounts = buildUploadAccounts($type, $data, $ids, $selectedModules, $container);
if ($accounts !== false) {
$rdnList = getRDNAttributes($type->getId(), $selectedModules);
$suffix = $type->getSuffix();
foreach ($accounts as $i => $account) {
// set DN
// check against list of possible RDN attributes
if (!isset($account[$data[$i][$ids['dn_rdn']]])) {
$errors[] = [_('Account %s:') . ' dn_rdn', _("Invalid RDN attribute!"), [$i]];
}
elseif (!in_array($data[$i][$ids['dn_rdn']], $rdnList)) {
$errors[] = [_('Account %s:') . ' dn_rdn ' . $account[$data[$i][$ids['dn_rdn']]], _("Invalid RDN attribute!"), [$i]];
}
else {
$rdnValue = $account[$data[$i][$ids['dn_rdn']]];
if (is_array($rdnValue)) {
$rdnValue = $rdnValue[0];
}
$account_dn = $data[$i][$ids['dn_rdn']] . "=" . ldap_escape($rdnValue, '', LDAP_ESCAPE_DN) . ",";
$account_dn = ($data[$i][$ids['dn_suffix']] == "") ? $account_dn . $suffix : $account_dn . $data[$i][$ids['dn_suffix']];
$accounts[$i]['dn'] = $account_dn;
}
// set overwrite
if (isset($ids['overwrite']) && ($data[$i][$ids['overwrite']] === 'true')) {
$accounts[$i]['INFO.overwrite'] = 'true';
}
}
// print errors if DN could not be built
if ($errors !== []) {
foreach ($errors as $error) {
$container->add(new htmlStatusMessage("ERROR", $error[0], $error[1], $error[2]));
}
}
else {
// store accounts in session
$_SESSION['mass_accounts'] = lamEncrypt(json_encode($accounts));
$_SESSION['mass_errors'] = [];
$_SESSION['mass_failed'] = [];
$_SESSION['mass_postActions'] = [];
$_SESSION['mass_data'] = lamEncrypt(json_encode($data));
$_SESSION['mass_ids'] = $ids;
$_SESSION['mass_typeId'] = $type->getId();
$_SESSION['mass_selectedModules'] = $selectedModules;
if (isset($_SESSION['mass_pdf'])) {
unset($_SESSION['mass_pdf']);
}
if (isset($_POST['createPDF']) && ($_POST['createPDF'] == 'on')) {
$pdfStructurePersistenceManager = new PdfStructurePersistenceManager();
$pdfStructures = $pdfStructurePersistenceManager->getPDFStructures($_SESSION['config']->getName(), $type->getId());
$pdfStructureName = (string) $_POST['pdfStructure'];
if (!in_array($pdfStructureName, $pdfStructures)) {
logNewMessage(LOG_ERR, 'Invalid PDF structure: ' . $pdfStructureName);
die();
}
$_SESSION['mass_pdf']['structure'] = $pdfStructureName;
$fontName = (string) $_POST['pdf_font'];
$fonts = getPdfFonts();
if (!in_array($fontName, $fonts)) {
logNewMessage(LOG_ERR, 'Invalid font name: ' . $fontName);
die();
}
$_SESSION['mass_pdf']['font'] = $fontName;
$_SESSION['mass_pdf']['counter'] = 0;
$tempFilesManager = new LamTemporaryFilesManager();
$_SESSION['mass_pdf']['file'] = $tempFilesManager->registerTemporaryFile('.zip');
}
else {
$_SESSION['mass_pdf']['structure'] = null;
}
// show links for upload and LDIF export
$container->addVerticalSpacer('2rem');
$container->add(new htmlOutputText(_("LAM has checked your input and is now ready to create the accounts.")));
$container->addVerticalSpacer('3rem');
$formRow = new htmlResponsiveRow();
$uploadButton = new htmlButton('upload', _("Upload accounts to LDAP"));
$uploadButton->setCSSClasses(['lam-primary']);
$formRow->addLabel($uploadButton);
$ldifButton = new htmlButton('showldif', _("Show LDIF file"));
$ldifButton->setCSSClasses(['lam-secondary']);
$formRow->addField($ldifButton);
addSecurityTokenToMetaHTML($formRow);
$container->add(new htmlForm('uploadform', 'massBuildAccounts.php', $formRow));
$container->addVerticalSpacer('2rem');
massPrintBackButton($type->getId(), $selectedModules, $container);
}
}
else {
$container->addVerticalSpacer('2rem');
massPrintBackButton($type->getId(), $selectedModules, $container);
}
}
}
else {
$container->add(new htmlStatusMessage('ERROR', _('Please provide a file to upload.')));
$container->addVerticalSpacer('2rem');
massPrintBackButton($type->getId(), $selectedModules, $container);
}
parseHtml(null, $container, [], false, $type->getScope());
echo '
';
include __DIR__ . '/../../lib/adminFooter.inc';
/**
* Prints a back button to the page where the user enters a file to upload.
*
* @param string $typeId account type (e.g. user)
* @param string[] $selectedModules selected modules for upload
* @param htmlResponsiveRow $container table container
*/
function massPrintBackButton(string $typeId, array $selectedModules, htmlResponsiveRow $container): void {
$row = new htmlResponsiveRow();
$backButton = new htmlButton('submit', _('Back'));
$row->add($backButton);
$row->add(new htmlHiddenInput('type', $typeId));
$createPDF = '0';
if (isset($_POST['createPDF']) && ($_POST['createPDF'] == 'on')) {
$createPDF = '1';
}
$row->add(new htmlHiddenInput('createPDF', $createPDF));
$row->add(new htmlHiddenInput('pdfStructure', $_POST['pdfStructure']));
foreach ($selectedModules as $selectedModule) {
$row->add(new htmlHiddenInput($typeId . '___' . $selectedModule, 'on'));
}
addSecurityTokenToMetaHTML($row);
$container->add(new htmlForm('backform', 'masscreate.php', $row));
}