+ 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);
+ var_dump($eduDegrees);
+ switch (Env::t('edu_type')) {
+ case 'X':
+ $degreeid = $eduDegrees[Profile::DEGREE_X];
+ $entry_year = $promotion;
+ $grad_year = $promotion + 3;
+ $promo = 'X' . $promotion;
+ break;
+ case 'M':
+ $degreeid = $eduDegrees[Profile::DEGREE_M];
+ $grad_year = $promotion;
+ $entry_year = $promotion - 2;
+ $promo = 'M' . $promotion;
+ break;
+ case 'D':
+ $degreeid = $eduDegrees[Profile::DEGREE_D];
+ $grad_year = $promotion;
+ $entry_year = $promotion - 3;
+ $promo = 'D' . $promotion;
+ break;
+ default:
+ $page->killError("La formation n'est pas reconnue:" . Env::t('edu_type') . '.');
+ }
+
+ foreach ($lines as $line) {
+ if (($infos = self::formatNewUser($line, $separator, $promotion, 6))
+ && ($sex = self::formatSex($page, $infos[3], $line))) {
+ $name = $infos[1] . ' ' . $infos[0];
+ $birthDate = self::formatBirthDate($infos[2]);
+ $xorgId = Profile::getXorgId($infos[4]);
+
+ 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']);
+ XDB::execute('INSERT INTO profile_name (pid, name, typeid)
+ VALUES ({?}, {?}, {?})',
+ $pid, $infos[1], $nameTypes['firstname_ini']);
+ XDB::execute('INSERT INTO profile_display (pid, yourself, public_name, private_name,
+ directory_name, short_name, sort_name, promo)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $pid, $infos[1], $name, $name, $name, $name, $infos[0] . ' ' . $infos[1], $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, display_name, sex)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $infos['hrid'], $type, 0, 'active', $name, $infos[1], $sex);
+ $uid = XDB::insertId();
+ XDB::execute('INSERT INTO account_profiles (uid, pid, perms)
+ VALUES ({?}, {?}, {?})',
+ $uid, $pid, 'owner');
+ }
+ }
+ } else if (Env::t('add_type') == 'account') {
+ $type = Env::t('type');
+ foreach ($lines as $line) {
+ if (($infos = self::formatNewUser($line, $separator, $type, 4))
+ && ($sex = self::formatSex(&$page, $infos[3], $line))) {
+ XDB::execute('INSERT INTO accounts (hruid, type, is_admin, state, email, full_name, display_name, sex)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $infos['hrid'], $type, 0, 'active', $infos[2], $infos[1] . ' ' . $infos[0], $infos[1], $sex);
+ }
+ }
+ } else if (Env::t('add_type') == 'ax_id') {
+ $type = 'x';
+ foreach ($lines as $line) {
+ if ($infos = self::formatNewUser($line, $separator, $promotion, 3)) {
+ XDB::execute('UPDATE profiles
+ SET ax_id = {?}
+ WHERE hrpid = {?}',
+ $infos[2], $infos['hrid']);
+ }
+ }
+ }
+
+ if ($page->nb_errs == 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 les "
+ . $page->nb_errs . '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'));