const DN_PUBLIC = 'public_name';
const DN_SHORT = 'short_name';
const DN_SORT = 'sort_name';
+ /* education related names */
+ const EDU_X = 'École polytechnique';
+ const DEGREE_X = 'Ingénieur';
+ const DEGREE_M = 'Master';
+ const DEGREE_D = 'Doctorat';
static public $name_variants = array(
self::LASTNAME => array(self::VN_MARITAL, self::VN_ORDINARY),
$cond = ' AND pub IN ' . XDB::formatArray($this->visibility);
}
$res = XDB::query('SELECT *
- FROM photo
+ FROM profile_photos
WHERE attachmime IN (\'jpeg\', \'png\')
- ' . $cond . ' AND uid = {?}',
+ ' . $cond . ' AND pid = {?}',
$this->id());
if ($res->numRows() > 0) {
$photo = $res->fetchOneAssoc();
public function getBinets()
{
return XDB::fetchColumn('SELECT binet_id
- FROM binets_ins
+ FROM profile_binets
WHERE user_id = {?}', $this->id());
}
IF(pn_ul.name IS NULL, pn_l.name, pn_ul.name) AS lastname_ordinary,
pd.promo AS promo, pd.short_name, pd.directory_name AS full_name,
pd.directory_name, pp.display_tel AS mobile, pp.pub AS mobile_pub,
- ph.pub AS photo_pub, ap.uid AS owner_id
+ ph.attach IS NOT NULL AS has_photo, ph.pub AS photo_pub,
+ p.last_change < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_old,
+ ap.uid AS owner_id
FROM profiles AS p
INNER JOIN profile_display AS pd ON (pd.pid = p.pid)
INNER JOIN profile_education AS pe ON (pe.uid = p.pid AND FIND_IN_SET(\'primary\', pe.flags))
LEFT JOIN profile_name AS pn_n ON (pn_n.pid = p.pid
AND pn_n.typeid = ' . self::getNameTypeId('nickname', true) . ')
LEFT JOIN profile_phones AS pp ON (pp.uid = p.pid AND pp.link_type = \'user\' AND tel_type = \'mobile\')
- LEFT JOIN photo AS ph ON (ph.uid = p.pid)
+ LEFT JOIN profile_photos AS ph ON (ph.pid = p.pid)
LEFT JOIN account_profiles AS ap ON (ap.pid = p.pid AND FIND_IN_SET(\'owner\', ap.perms))
WHERE p.pid IN ' . XDB::formatArray($pids) . '
GROUP BY p.pid
return $table[$type];
}
}
+
+ public static function rebuildSearchTokens($pid)
+ {
+ XDB::execute('DELETE FROM search_name
+ WHERE uid = {?}',
+ $pid);
+ $keys = XDB::iterator("SELECT CONCAT(n.particle, n.name) AS name, e.score,
+ FIND_IN_SET('public', e.flags) AS public
+ FROM profile_name AS n
+ INNER JOIN profile_name_enum AS e ON (n.typeid = e.id)
+ WHERE n.pid = {?}",
+ $pid);
+
+ foreach ($keys as $i => $key) {
+ if ($key['name'] == '') {
+ continue;
+ }
+ $toks = preg_split('/[ \'\-]+/', $key['name']);
+ $token = '';
+ $first = 5;
+ while ($toks) {
+ $token = strtolower(replace_accent(array_pop($toks) . $token));
+ $score = ($toks ? 0 : 10 + $first) * ($key['score'] / 10);
+ XDB::execute('REPLACE INTO search_name (token, uid, soundex, score, flags)
+ VALUES ({?}, {?}, {?}, {?}, {?})',
+ $token, $uid, soundex_fr($token), $score, $key['public']);
+ $first = 0;
+ }
+ }
+ }
+
+ /** The school identifier consists of 6 digits. The first 3 represent the
+ * promotion entry year. The last 3 indicate the student's rank.
+ *
+ * Our identifier consists of 8 digits and both half have the same role.
+ * This enables us to deal with bigger promotions and with a wider range
+ * of promotions.
+ *
+ * getSchoolId returns a school identifier given one of ours.
+ * getXorgId returns a X.org identifier given a school identifier.
+ */
+ public static function getSchoolId($xorgId)
+ {
+ if (!preg_match('/^[0-9]{8}$/', $xorgId)) {
+ return null;
+ }
+
+ $year = intval(substr($xorgId, 0, 4));
+ $rank = intval(substr($xorgId, 5, 3));
+ if ($year < 1996) {
+ return null;
+ } elseif ($year < 2000) {
+ $year = intval(substr(1900 - $year, 1, 3));
+ return sprintf('%02u0%03u', $year, $rank);
+ } else {
+ $year = intval(substr(1900 - $year, 1, 3));
+ return sprintf('%03u%03u', $year, $rank);
+ }
+ }
+
+ public static function getXorgId($schoolId)
+ {
+ $year = intval(substr($schoolId, 0, 3));
+ $rank = intval(substr($schoolId, 3, 3));
+
+ if ($year > 200) {
+ $year /= 10;
+ }
+ if ($year < 96) {
+ return null;
+ } else {
+ return sprintf('%04u%04u', 1900 + $year, $rank);
+ }
+ }
}
/** Iterator over a set of Profiles