+ function handler_add_accounts(&$page, $action = null, $promo = null)
+ {
+ $page->changeTpl('admin/add_accounts.tpl');
+
+ if (Env::has('add_type') && Env::has('people')) {
+ $lines = explode("\n", Env::t('people'));
+ $separator = Env::t('separator');
+ $promotion = Env::i('promotion');
+ $nameTypes = DirEnum::getOptions(DirEnum::NAMETYPES);
+ $nameTypes = array_flip($nameTypes);
+
+ if (Env::t('add_type') == 'promo') {
+ $type = 'x';
+ $eduSchools = DirEnum::getOptions(DirEnum::EDUSCHOOLS);
+ $eduSchools = array_flip($eduSchools);
+ $eduDegrees = DirEnum::getOptions(DirEnum::EDUDEGREES);
+ $eduDegrees = array_flip($eduDegrees);
+ switch (Env::t('edu_type')) {
+ case 'X':
+ $degreeid = $eduDegrees[Profile::DEGREE_X];
+ $entry_year = $promotion;
+ $grad_year = $promotion + 3;
+ $promo = 'X' . $promotion;
+ $hrpromo = $promotion;
+ break;
+ case 'M':
+ $degreeid = $eduDegrees[Profile::DEGREE_M];
+ $grad_year = $promotion;
+ $entry_year = $promotion - 2;
+ $promo = 'M' . $promotion;
+ $hrpromo = $promo;
+ $type = 'master';
+ break;
+ case 'D':
+ $degreeid = $eduDegrees[Profile::DEGREE_D];
+ $grad_year = $promotion;
+ $entry_year = $promotion - 3;
+ $promo = 'D' . $promotion;
+ $hrpromo = $promo;
+ $type = 'phd';
+ break;
+ default:
+ $page->killError("La formation n'est pas reconnue:" . Env::t('edu_type') . '.');
+ }
+
+ XDB::startTransaction();
+ foreach ($lines as $line) {
+ if ($infos = self::formatNewUser($page, $line, $separator, $hrpromo, 6)) {
+ $sex = self::formatSex($page, $infos[3], $line);
+ if (!is_null($sex)) {
+ $fullName = $infos[1] . ' ' . $infos[0];
+ $directoryName = $infos[0] . ' ' . $infos[1];
+ $birthDate = self::formatBirthDate($infos[2]);
+ $xorgId = Profile::getXorgId($infos[4]);
+ if (is_null($xorgId)) {
+ $page->trigError("La ligne $line n'a pas été ajoutée car le matricule École est mal renseigné.");
+ continue;
+ }
+
+ XDB::execute('INSERT INTO profiles (hrpid, xorg_id, ax_id, birthdate_ref, sex)
+ VALUES ({?}, {?}, {?}, {?}, {?})',
+ $infos['hrid'], $xorgId, $infos[5], $birthDate, $sex);
+ $pid = XDB::insertId();
+ XDB::execute('INSERT INTO profile_name (pid, name, typeid)
+ VALUES ({?}, {?}, {?}),
+ ({?}, {?}, {?}),
+ ({?}, {?}, {?}),
+ ({?}, {?}, {?})',
+ $pid, $infos[0], $nameTypes['name_ini'],
+ $pid, $infos[0], $nameTypes['lastname'],
+ $pid, $infos[1], $nameTypes['firstname_ini'],
+ $pid, $infos[1], $nameTypes['firstname']);
+ XDB::execute('INSERT INTO profile_display (pid, yourself, public_name, private_name,
+ directory_name, short_name, sort_name, promo)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $pid, $infos[1], $fullName, $fullName, $directoryName, $fullName, $directoryName, $promo);
+ XDB::execute('INSERT INTO profile_education (pid, eduid, degreeid, entry_year, grad_year, flags)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?})',
+ $pid, $eduSchools[Profile::EDU_X], $degreeid, $entry_year, $grad_year, 'primary');
+ XDB::execute('INSERT INTO accounts (hruid, type, is_admin, state, full_name, directory_name, display_name, sex)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $infos['hrid'], $type, 0, 'pending', $fullName, $directoryName, $infos[1], $sex);
+ $uid = XDB::insertId();
+ XDB::execute('INSERT INTO account_profiles (uid, pid, perms)
+ VALUES ({?}, {?}, {?})',
+ $uid, $pid, 'owner');
+ Profile::rebuildSearchTokens($pid, false);
+ }
+ }
+ }
+ XDB::commit();
+ } else if (Env::t('add_type') == 'account') {
+ $type = Env::t('type');
+ $newAccounts = array();
+ foreach ($lines as $line) {
+ if ($infos = self::formatNewUser($page, $line, $separator, $type, 4)) {
+ $sex = self::formatSex($page, $infos[3], $line);
+ if (!is_null($sex)) {
+ $fullName = $infos[1] . ' ' . $infos[0];
+ $directoryName = $infos[0] . ' ' . $infos[1];
+ XDB::execute('INSERT INTO accounts (hruid, type, is_admin, state,
+ email, full_name, directory_name,
+ display_name, sex)
+ VALUES ({?}, {?}, {?}, {?},
+ {?}, {?}, {?}, {?}, {?})',
+ $infos['hrid'], $type, 0, 'pending',
+ $infos[2], $fullName, $directoryName,
+ $infos[1], $sex);
+ $newAccounts[$infos['hrid']] = $infos[1] . ' ' . $infos[0];
+ }
+ }
+ }
+ if (!empty($newAccounts)) {
+ $page->assign('newAccounts', $newAccounts);
+ }
+ } else if (Env::t('add_type') == 'ax_id') {
+ $type = 'x';
+ foreach ($lines as $line) {
+ if ($infos = self::formatNewUser($page, $line, $separator, $promotion, 3)) {
+ XDB::execute('UPDATE profiles
+ SET ax_id = {?}
+ WHERE hrpid = {?}',
+ $infos[2], $infos['hrid']);
+ }
+ }
+ }
+
+ $errors = $page->nb_errs();
+ if ($errors == 0) {
+ $page->trigSuccess("L'opération a été effectuée avec succès.");
+ } else {
+ $page->trigSuccess('L\'opération a été effectuée avec succès, sauf pour '
+ . (($errors == 1) ? 'l\'erreur signalée' : "les $errors erreurs signalées") . ' ci-dessus.');
+ }
+ } else if (Env::has('add_type')) {
+ $res = XDB::query('SELECT type
+ FROM account_types');
+ $page->assign('account_types', $res->fetchColumn());
+ $page->assign('add_type', Env::s('add_type'));