}
}
+ // Returns younger/older promotion year for a given education.
+ static public function extremePromotions($education)
+ {
+ return XDB::fetchOneRow("SELECT MIN(pe.promo_year) AS min, MAX(pe.promo_year) AS max
+ FROM profile_education AS pe
+ INNER JOIN profile_education_degree_enum AS pede ON (pe.degreeid = pede.id)
+ WHERE pede.degree = {?} AND FIND_IN_SET('primary', pe.flags)",
+ $education);
+ }
+
/** Print a name with the given formatting:
* %s = • for women
* %f = firstname
public function firstName()
{
- return $this->firstname;
+ return $this->firstname_ordinary;
}
public function firstNames()
public function lastName()
{
- return $this->lastname;
+ return $this->lastname_ordinary;
}
public function lastNames()
XDB::execute("UPDATE profiles
SET cv = NULL, freetext = NULL, freetext_pub = 'private',
- medals_pub = 'private', alias_pub = 'private',
+ medals_pub = 'private', alias_pub = 'hidden',
email_directory = NULL
WHERE pid = {?}",
$this->id());
return array();
}
}
+
+ public function getFullBinets()
+ {
+ if ($this->visibility->isVisible(Visibility::EXPORT_PRIVATE)) {
+ return XDB::fetchAllAssoc('SELECT binet_id, text, url
+ FROM profile_binets AS pb
+ LEFT JOIN profile_binet_enum AS pbe ON (pbe.id = pb.binet_id)
+ WHERE pid = {?}', $this->id());
+ } else {
+ return array();
+ }
+ }
+
public function getBinetsNames()
{
if ($this->visibility->isVisible(Visibility::EXPORT_PRIVATE)) {
IF ({?}, pse.text, NULL) AS section,
ppn.firstname_main AS firstname, ppn.lastname_main AS lastname, IF ({?}, pn.name, NULL) AS nickname,
IF (ppn.firstname_ordinary = \'\', ppn.firstname_main, ppn.firstname_ordinary) AS firstname_ordinary,
- IF (ppn.lastname_ordinary = \'\', ppn.firstname_main, ppn.lastname_ordinary) AS lastname_ordinary,
+ IF (ppn.lastname_ordinary = \'\', ppn.lastname_main, ppn.lastname_ordinary) AS lastname_ordinary,
pd.yourself, pd.promo, pd.short_name, pd.public_name AS full_name,
pd.directory_name, pd.public_name, pd.private_name,
IF (pp.pub >= {?}, pp.display_tel, NULL) AS mobile,
*/
public static function getAccountEquivalentName($name)
{
- switch ($name)
- {
- case self::DN_DIRECTORY:
- case self::DN_SORT:
+ switch ($name) {
+ case self::DN_DIRECTORY:
return 'directory_name';
- case self::DN_FULL:
- case self::DN_PUBLIC:
+ case self::DN_SORT:
+ return 'sort_name';
+ case self::DN_FULL:
+ case self::DN_PUBLIC:
+ case self::DN_PRIVATE:
+ case self::DN_SHORT:
return 'full_name';
- case self::DN_PRIVATE:
- case self::DN_SHORT:
- case self::DN_YOURSELF:
- default:
+ case self::DN_YOURSELF:
+ return 'display_name';
+ default:
return 'display_name';
}
}