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)); }