+ } elseif ($action == 'adds1920') {
+ // Adds promotion 1920 from AX db.
+ $report[] = 'Ajout de la promotion 1920';
+ $res = XDB::iterator('SELECT prenom, Nom_complet, ax_id
+ FROM fusionax_anciens
+ WHERE promotion_etude = 1920;');
+
+ $nameTypes = DirEnum::getOptions(DirEnum::NAMETYPES);
+ $nameTypes = array_flip($nameTypes);
+ $eduSchools = DirEnum::getOptions(DirEnum::EDUSCHOOLS);
+ $eduSchools = array_flip($eduSchools);
+ $eduDegrees = DirEnum::getOptions(DirEnum::EDUDEGREES);
+ $eduDegrees = array_flip($eduDegrees);
+ $degreeid = $eduDegrees[Profile::DEGREE_X];
+ $entry_year = 1920;
+ $grad_year = 1923;
+ $promo = 'X1920';
+ $sex = PlUser::GENDER_MALE;
+ $xorgId = 19200000;
+ $type = 'x';
+
+ while (list($firstname, $lastname, $ax_id) = $res->next()) {
+ $hrid = self::getHrid($firstname, $lastname, $promo);
+ $res1 = XDB::query('SELECT COUNT(*)
+ FROM accounts
+ WHERE hruid = {?}', $hrid);
+ $res2 = XDB::query('SELECT COUNT(*)
+ FROM profiles
+ WHERE hrpid = {?}', $hrid);
+ if (is_null($hrid) || $res1->fetchOneCell() > 0 || $res2->fetchOneCell() > 0) {
+ $report[] = $ax_id . ' non ajouté';
+ }
+ $fullName = $firstname . ' ' . $lastname;
+ $directoryName = $lastname . ' ' . $firstname;
+ ++$xorgId;
+
+ XDB::execute('REPLACE INTO profiles (hrpid, xorg_id, ax_id, sex)
+ VALUES ({?}, {?}, {?}, {?})',
+ $hrid, $xorgId, $ax_id, $sex);
+ $pid = XDB::insertId();
+ XDB::execute('REPLACE INTO profile_name (pid, name, typeid)
+ VALUES ({?}, {?}, {?})',
+ $pid, $lastname, $nameTypes['name_ini']);
+ XDB::execute('REPLACE INTO profile_name (pid, name, typeid)
+ VALUES ({?}, {?}, {?})',
+ $pid, $firstname, $nameTypes['firstname_ini']);
+ XDB::execute('REPLACE INTO profile_display (pid, yourself, public_name, private_name,
+ directory_name, short_name, sort_name, promo)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $pid, $firstname, $fullName, $fullName, $directoryName, $fullName, $directoryName, $promo);
+ XDB::execute('REPLACE 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('REPLACE INTO accounts (hruid, type, is_admin, state, full_name, directory_name, display_name, sex)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $hrid, $type, 0, 'active', $fullName, $directoryName, $lastname, $sex);
+ $uid = XDB::insertId();
+ XDB::execute('REPLACE INTO account_profiles (uid, pid, perms)
+ VALUES ({?}, {?}, {?})',
+ $uid, $pid, 'owner');
+ }
+ $report[] = 'Promo 1920 ajoutée.';
+ $next = 'view';
+ } elseif ($action == 'view') {
+ XDB::execute('CREATE OR REPLACE ALGORITHM=MERGE VIEW fusionax_xorg_anciens AS
+ SELECT p.pid, p.ax_id, pd.promo, pd.private_name, pd.public_name,
+ pd.sort_name, pd.short_name, pd.directory_name
+ FROM profiles AS p
+ INNER JOIN profile_display AS pd USING(pid)');
+ $next = 'clean';