return $this->promo;
}
+ public function yearpromo()
+ {
+ return intval(substr($this->promo, 1, 4));
+ }
+
/** Print a name with the given formatting:
* %s = • for women
* %f = firstname
{
return str_replace(array('%s', '%f', '%l', '%F', '%S', '%p'),
array($this->isFemale() ? '•' : '',
- $this->first_name, $this->last_name,
- $this->full_name, $this->short_name,
- $this->promo), $format);
+ $this->firstName(), $this->lastName(),
+ $this->fullName(), $this->shortName(),
+ $this->promo()), $format);
}
public function fullName($with_promo = false)
return array_unique($vals);
}
+ public function nationalities()
+ {
+ $nats = array();
+ if ($this->nationality1) {
+ $nats[] = $this->nationality1;
+ }
+ if ($this->nationality2) {
+ $nats[] = $this->nationality2;
+ }
+ if ($this->nationality3) {
+ $nats[] = $this->nationality3;
+ }
+ return $nats;
+ }
+
public function __get($name)
{
if (property_exists($this, $name)) {
return property_exists($this, $name) || isset($this->data[$name]);
}
+ /** Sets the level of visibility of the profile
+ * Sets $this->visibility to a list of valid visibilities.
+ * @param one of the self::VISIBILITY_* values
+ */
public function setVisibilityLevel($visibility)
{
if ($visibility != self::VISIBILITY_PRIVATE
}
}
+ /** Determine whether an item with visibility $visibility can be displayed
+ * with the current level of visibility of the profile
+ * @param $visibility The level of visibility to be checked
+ */
+ public function isVisible($visibility)
+ {
+ return in_array($visibility, $this->visibility);
+ }
/* Photo
*/
public function getPhoto($fallback = true)
{
- /* TODO: migrate photo table to profile_photo, change uid to pid
- */
$cond = '';
if ($this->visibility) {
- $cond = ' AND pub IN ' . XDB::formatArray($this->visibility);
+ $cond = XDB::format(' AND pub IN {?}', $this->visibility);
}
- $res = XDB::query('SELECT *
+ $res = XDB::query("SELECT *
FROM profile_photos
- WHERE attachmime IN (\'jpeg\', \'png\')
- ' . $cond . ' AND pid = {?}',
+ WHERE attachmime IN ('jpeg', 'png')
+ " . $cond . ' AND pid = {?}',
$this->id());
if ($res->numRows() > 0) {
$photo = $res->fetchOneAssoc();
$where .= ' AND FIND_IN_SET(\'mail\', pa.flags)';
}
if ($this->visibility) {
- $where .= ' AND pa.pub IN ' . XDB::formatArray($this->visibility);
+ $where .= XDB::format(' AND pa.pub IN {?}', $this->visibility);
}
$type = array();
if ($flags & self::ADDRESS_PRO) {
$type[] = 'home';
}
if (count($type) > 0) {
- $where .= ' AND pa.type IN ' . XDB::formatArray($type);
+ $where .= XDB::format(' AND pa.type IN {?}', $type);
}
$limit = is_null($limit) ? '' : XDB::format('LIMIT {?}', (int)$limit);
return XDB::iterator('SELECT pa.text, pa.postalCode, pa.type, pa.latitude, pa.longitude,
LEFT JOIN geoloc_administrativeareas AS ga ON (ga.id = pa.administrativeAreaId)
LEFT JOIN geoloc_administrativeareas AS gas ON (gas.id = pa.subAdministrativeAreaId)
LEFT JOIN geoloc_countries AS gc ON (gc.iso_3166_1_a2 = pa.countryId)
- LEFT JOIN profile_phones AS ppfix ON (ppfix.link_type = \'address\' AND ppfix.uid = pa.pid AND ppfix.link_id = pa.id AND ppfix.tel_type = \'fixed\')
- LEFT JOIN profile_phones AS ppfax ON (ppfax.link_type = \'address\' AND ppfax.uid = pa.pid AND ppfax.link_id = pa.id AND ppfax.tel_type = \'fax\')
+ LEFT JOIN profile_phones AS ppfix ON (ppfix.link_type = \'address\' AND ppfix.pid = pa.pid AND ppfix.link_id = pa.id AND ppfix.tel_type = \'fixed\')
+ LEFT JOIN profile_phones AS ppfax ON (ppfax.link_type = \'address\' AND ppfax.pid = pa.pid AND ppfax.link_id = pa.id AND ppfax.tel_type = \'fax\')
WHERE ' . $where . '
ORDER BY pa.id
' . $limit);
*/
public function getEducations($flags, $limit = null)
{
- $where = XDB::format('pe.uid = {?}', $this->id());
+ $where = XDB::format('pe.pid = {?}', $this->id());
if ($flags & self::EDUCATION_MAIN) {
$where .= ' AND FIND_IN_SET(\'primary\', pe.flags)';
} else if ($flags & self::EDUCATION_EXTRA) {
public function getNetworking($flags, $limit = null)
{
- $where = XDB::format('pn.uid = {?}', $this->id());
+ $where = XDB::format('pn.pid = {?}', $this->id());
if ($flags & self::NETWORKING_WEB) {
$where .= ' AND pn.network_type = 0'; // XXX hardcoded reference to web site index
}
if ($this->visibility) {
- $where .= ' AND pn.pub IN ' . XDB::formatArray($this->visibility);
+ $where .= XDB::format(' AND pn.pub IN {?}', $this->visibility);
}
$limit = is_null($limit) ? '' : XDB::format('LIMIT {?}', (int)$limit);
return XDB::iterator('SELECT pne.name, pne.icon,
public function getJobs($flags, $limit = null)
{
- $where = XDB::format('pj.uid = {?}', $this->id());
+ $where = XDB::format('pj.pid = {?}', $this->id());
$cond = 'TRUE';
if ($this->visibility) {
- $where .= ' AND pj.pub IN ' . XDB::formatArray($this->visibility);
- $cond = 'pj.email_pub IN ' . XDB::formatArray($this->visibility);
+ $where .= XDB::format(' AND pj.pub IN {?}', $this->visibility);
+ $cond = XDB::format('pj.email_pub IN {?}', $this->visibility);
}
$limit = is_null($limit) ? '' : XDB::format('LIMIT {?}', (int)$limit);
return XDB::iterator('SELECT pje.name, pje.acronym, pje.url, pje.email, pje.NAF_code,
public function getBinets()
{
return XDB::fetchColumn('SELECT binet_id
- FROM binets_ins
- WHERE user_id = {?}', $this->id());
+ FROM profile_binets
+ WHERE pid = {?}', $this->id());
}
return User::getSilent($this);
}
+ public function compareNames($firstname, $lastname)
+ {
+ $_lastname = mb_strtoupper($this->lastName());
+ $_firstname = mb_strtoupper($this->firstName());
+ $lastname = mb_strtoupper($lastname);
+ $firstname = mb_strtoupper($firstname);
+
+ $isOk = (mb_strtoupper($_firstname) == mb_strtoupper($firstname));
+ $tokens = preg_split("/[ \-']/", $lastname, -1, PREG_SPLIT_NO_EMPTY);
+ $maxlen = 0;
+
+ foreach ($tokens as $str) {
+ $isOk &= (strpos($_lastname, $str) !== false);
+ $maxlen = max($maxlen, strlen($str));
+ }
+
+ return ($isOk && ($maxlen > 2 || $maxlen == strlen($_lastname)));
+ }
+
private static function fetchProfileData(array $pids, $respect_order = true)
{
if (count($pids) == 0) {
$order = '';
}
+ require_once 'directory.enums.inc.php';
return XDB::Iterator('SELECT p.*, p.sex = \'female\' AS sex, pe.entry_year, pe.grad_year,
pn_f.name AS firstname, pn_l.name AS lastname, pn_n.name AS nickname,
IF(pn_uf.name IS NULL, pn_f.name, pn_uf.name) AS firstname_ordinary,
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))
- INNER JOIN profile_name AS pn_f ON (pn_f.pid = p.pid
- AND pn_f.typeid = ' . self::getNameTypeId('firstname', true) . ')
- INNER JOIN profile_name AS pn_l ON (pn_l.pid = p.pid
- AND pn_l.typeid = ' . self::getNameTypeId('lastname', true) . ')
- LEFT JOIN profile_name AS pn_uf ON (pn_uf.pid = p.pid
- AND pn_uf.typeid = ' . self::getNameTypeId('firstname_ordinary', true) . ')
- LEFT JOIN profile_name AS pn_ul ON (pn_ul.pid = p.pid
- AND pn_ul.typeid = ' . self::getNameTypeId('lastname_ordinary', true) . ')
- 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\')
+ INNER JOIN profile_education AS pe ON (pe.pid = p.pid AND FIND_IN_SET(\'primary\', pe.flags))
+ INNER JOIN profile_name AS pn_f ON (pn_f.pid = p.pid AND pn_f.typeid = {?})
+ INNER JOIN profile_name AS pn_l ON (pn_l.pid = p.pid AND pn_l.typeid = {?})
+ LEFT JOIN profile_name AS pn_uf ON (pn_uf.pid = p.pid AND pn_uf.typeid = {?})
+ LEFT JOIN profile_name AS pn_ul ON (pn_ul.pid = p.pid AND pn_ul.typeid = {?})
+ LEFT JOIN profile_name AS pn_n ON (pn_n.pid = p.pid AND pn_n.typeid = {?})
+ LEFT JOIN profile_phones AS pp ON (pp.pid = p.pid AND pp.link_type = \'user\' AND tel_type = \'mobile\')
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) . '
+ WHERE p.pid IN {?}
GROUP BY p.pid
- ' . $order);
+ ' . $order,
+ DirEnum::getID(DirEnum::NAMETYPES, 'firstname'),
+ DirEnum::getID(DirEnum::NAMETYPES, 'lastname'),
+ DirEnum::getID(DirEnum::NAMETYPES, 'firstname_ordinary'),
+ DirEnum::getID(DirEnum::NAMETYPES, 'lastname_ordinary'),
+ DirEnum::getID(DirEnum::NAMETYPES, 'nickname'), $pids);
}
public static function getPID($login)
return XDB::fetchAllAssoc('uid', 'SELECT ap.uid, ap.pid
FROM account_profiles AS ap
WHERE FIND_IN_SET(\'owner\', ap.perms)
- AND ap.uid IN ' . XDB::formatArray($uids) .'
- ' . $order);
+ AND ap.uid IN {?}
+ ' . $order, $uids);
}
/** Return the profile associated with the given login.
|| $name == self::DN_SHORT || $name == self::DN_SORT;
}
- public static function getNameTypeId($type, $for_sql = false)
- {
- if (!S::has('name_types')) {
- $table = XDB::fetchAllAssoc('type', 'SELECT id, type
- FROM profile_name_enum');
- S::set('name_types', $table);
- } else {
- $table = S::v('name_types');
- }
- if ($for_sql) {
- return XDB::escape($table[$type]);
- } else {
- return $table[$type];
- }
- }
-
public static function rebuildSearchTokens($pid)
{
XDB::execute('DELETE FROM search_name
- WHERE uid = {?}',
+ WHERE pid = {?}',
$pid);
$keys = XDB::iterator("SELECT CONCAT(n.particle, n.name) AS name, e.score,
FIND_IN_SET('public', e.flags) AS public
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)
+ XDB::execute('REPLACE INTO search_name (token, pid, soundex, score, flags)
VALUES ({?}, {?}, {?}, {?}, {?})',
- $token, $uid, soundex_fr($token), $score, $key['public']);
+ $token, $pid, 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)
+ {
+ if (!preg_match('/^[0-9]{6}$/', $schoolId)) {
+ return null;
+ }
+
+ $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);
+ }
}
}
projects / platal.git / blobdiff