X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fprofile.php;h=c10b069d84811913e201acbd5af1a3f03c8854c3;hb=a43cdc7aab599efc9ebc698e91c131d3a40d6bee;hp=8af99abd6bd972f90977cf17de1034b7e1f18e1b;hpb=44ec5eb58bc3015d1c2823dc49ab01dc567147e9;p=platal.git diff --git a/classes/profile.php b/classes/profile.php index 8af99ab..c10b069 100644 --- a/classes/profile.php +++ b/classes/profile.php @@ -1,6 +1,6 @@ array('public'), - 'ax' => array('ax', 'public'), - 'private' => array('private', 'ax', 'public')); - - const VISIBILITY_PUBLIC = 'public'; - const VISIBILITY_AX = 'ax'; - const VISIBILITY_PRIVATE = 'private'; /* name tokens */ const LASTNAME = 'lastname'; @@ -60,111 +53,210 @@ class Profile self::FIRSTNAME => array(self::VN_ORDINARY, self::VN_INI, self::VN_OTHER) ); - const ADDRESS_MAIN = 0x000001; - const ADDRESS_PERSO = 0x000002; - const ADDRESS_PRO = 0x000004; - const ADDRESS_ALL = 0x000006; - const ADDRESS_POSTAL = 0x000008; - - const EDUCATION_MAIN = 0x000010; - const EDUCATION_EXTRA = 0x000020; - const EDUCATION_ALL = 0x000040; - const EDUCATION_FINISHED = 0x000080; - const EDUCATION_CURRENT = 0x000100; - - const JOBS_MAIN = 0x001000; - const JOBS_ALL = 0x002000; - const JOBS_FINISHED = 0x004000; - const JOBS_CURRENT = 0x008000; - - const NETWORKING_ALL = 0x000000; - const NETWORKING_WEB = 0x010000; - const NETWORKING_IM = 0x020000; - const NETWORKING_SOCIAL = 0x040000; - - const FETCH_ADDRESSES = 0x000001; - const FETCH_CORPS = 0x000002; - const FETCH_EDU = 0x000004; - const FETCH_JOBS = 0x000008; - const FETCH_MEDALS = 0x000010; - const FETCH_NETWORKING = 0x000020; - const FETCH_PHONES = 0x000040; - const FETCH_PHOTO = 0x000080; - - // xor of all FETCH_XYZ - const FETCH_ALL = 0x0000FF; + const ADDRESS_MAIN = 0x00000001; + const ADDRESS_PERSO = 0x00000002; + const ADDRESS_PRO = 0x00000004; + const ADDRESS_ALL = 0x00000006; + const ADDRESS_POSTAL = 0x00000008; + + const EDUCATION_MAIN = 0x00000010; + const EDUCATION_EXTRA = 0x00000020; + const EDUCATION_ALL = 0x00000040; + const EDUCATION_FINISHED = 0x00000080; + const EDUCATION_CURRENT = 0x00000100; + + const JOBS_MAIN = 0x00001000; + const JOBS_ALL = 0x00002000; + const JOBS_FINISHED = 0x00004000; + const JOBS_CURRENT = 0x00008000; + + const NETWORKING_ALL = 0x00070000; + const NETWORKING_WEB = 0x00010000; + const NETWORKING_IM = 0x00020000; + const NETWORKING_SOCIAL = 0x00040000; + + const PHONE_LINK_JOB = 0x00100000; + const PHONE_LINK_ADDRESS = 0x00200000; + const PHONE_LINK_PROFILE = 0x00400000; + const PHONE_LINK_COMPANY = 0x00800000; + const PHONE_LINK_ANY = 0x00F00000; + + const PHONE_TYPE_FAX = 0x01000000; + const PHONE_TYPE_FIXED = 0x02000000; + const PHONE_TYPE_MOBILE = 0x04000000; + const PHONE_TYPE_ANY = 0x07000000; + + const PHONE_ANY = 0x07F00000; + + const FETCH_ADDRESSES = 0x000001; + const FETCH_CORPS = 0x000002; + const FETCH_EDU = 0x000004; + const FETCH_JOBS = 0x000008; + const FETCH_MEDALS = 0x000010; + const FETCH_NETWORKING = 0x000020; + const FETCH_MENTOR_COUNTRY = 0x000080; + const FETCH_PHONES = 0x000100; + const FETCH_JOB_TERMS = 0x000200; + const FETCH_MENTOR_TERMS = 0x000400; + + const FETCH_MINIFICHES = 0x00012D; // FETCH_ADDRESSES | FETCH_EDU | FETCH_JOBS | FETCH_NETWORKING | FETCH_PHONES + + const FETCH_ALL = 0x0007FF; // OR of FETCH_* + + static public $descriptions = array( + 'search_names' => 'Noms', + 'nationality1' => 'Nationalité', + 'nationality2' => '2e nationalité', + 'nationality3' => '3e nationalité', + 'promo_display' => 'Promotion affichée', + 'email_directory' => 'Email annuaire papier', + 'networking' => 'Messageries…', + 'tels' => 'Téléphones', + 'edus' => 'Formations', + 'promo' => 'Promotion de sortie', + 'birthdate' => 'Date de naissance', + 'yourself' => 'Nom affiché', + 'freetext' => 'Commentaire', + 'freetext_pub' => 'Affichage du commentaire', + 'photo' => 'Photographie', + 'photo_pub' => 'Affichage de la photographie', + 'addresses' => 'Adresses', + 'corps' => 'Corps', + 'cv' => 'CV', + 'jobs' => 'Emplois', + 'section' => 'Section', + 'binets' => 'Binets', + 'medals' => 'Décorations', + 'medals_pub' => 'Affichage des décorations', + 'competences' => 'Compétences', + 'langues' => 'Langues', + 'expertise' => 'Expertises (mentoring)', + 'terms' => 'Compétences (mentoring)', + 'countries' => 'Pays (mentoring)' + ); + + private $fetched_fields = 0x000000; private $pid; private $hrpid; + private $owner; + private $owner_fetched = false; private $data = array(); private $visibility = null; + private function __construct(array $data) { $this->data = $data; $this->pid = $this->data['pid']; $this->hrpid = $this->data['hrpid']; - if (!S::logged()) { - $this->setVisibilityLevel(self::VISIBILITY_PUBLIC); - } else { - $this->setVisibilityLevel(self::VISIBILITY_PRIVATE); - } + $this->visibility = new ProfileVisibility(); } - static private $contexts = array(); - - /** Returns the best visibility context toward $visibility - * @param $visibility A wished visibility level - * @return An array of compatible visibilities - * - * if $visibility is null, the best visibility is returned - */ - static public function getVisibilityContext($visibility = null) + public function id() { - if (array_key_exists($visibility, self::$contexts)) { - return self::$contexts[$visibility]; - } + return $this->pid; + } - $asked_vis = $visibility; + public function hrid() + { + return $this->hrpid; + } - if (S::logged()) { - $minvis = self::VISIBILITY_PRIVATE; - } else { - $minvis = self::VISIBILITY_PUBLIC; - } - if ($visibility == null) { - $visibility = $minvis; + public function owner() + { + if ($this->owner == null && !$this->owner_fetched) { + $this->owner_fetched = true; + $this->owner = User::getSilent($this); } + return $this->owner; + } - if ($minvis == self::VISIBILITY_PUBLIC) { - $visibility = self::VISIBILITY_PUBLIC; + public function isActive() + { + if ($this->owner()) { + return $this->owner->isActive(); } + return false; + } + + public function promo() + { + return $this->promo; + } + + public function yearpromo() + { + return intval(substr($this->promo, 1, 4)); + } - $visibility = self::$v_values[$visibility]; - self::$contexts[$asked_vis] = $visibility; + /** Check if user is an orange (associated with several promos) + */ + public function isMultiPromo() + { + return $this->grad_year != $this->entry_year + $this->mainEducationDuration(); + } - return $visibility; + /** Returns an array with all associated promo years. + */ + public function yearspromo() + { + $promos = array(); + $d = -$this->deltaPromoToGradYear(); + for ($g = $this->entry_year + $this->mainEducationDuration(); $g <= $this->grad_year; ++$g) { + $promos[] = $g + $d; + } + return $promos; } - public function id() + public function mainEducation() { - return $this->pid; + if (empty($this->promo)) { + return null; + } else { + return $this->promo{0}; + } } - public function hrid() + public function mainGrade() { - return $this->hrpid; + switch ($this->mainEducation()) { + case 'X': + return UserFilter::GRADE_ING; + case 'M': + return UserFilter::GRADE_MST; + case 'D': + return UserFilter::GRADE_PHD; + default: + return null; + } } - public function promo() + public function mainEducationDuration() { - return $this->promo; + switch ($this->mainEducation()) { + case 'X': + return 3; + case 'M': + return 2; + case 'D': + return 3; + default: + return 0; + } } - public function yearpromo() + /** Number of years between the promotion year until the + * graduation year. In standard schools it's 0, but for + * Polytechnique the promo year is the entry year. + */ + public function deltaPromoToGradYear() { - return intval(substr($this->promo, 1, 4)); + if ($this->mainEducation() == 'X') { + return $this->mainEducationDuration(); + } + return 0; } /** Print a name with the given formatting: @@ -225,6 +317,21 @@ class Profile return $this->sex == PlUser::GENDER_FEMALE; } + public function isDead() + { + return ($this->deathdate != null); + } + + public function displayEmail() + { + $o = $this->owner(); + if ($o != null) { + return $o->bestEmail(); + } else { + return $this->email_directory; + } + } + public function data() { $this->first_name; @@ -247,14 +354,15 @@ class Profile public function nationalities() { $nats = array(); + $countries = DirEnum::getOptions(DirEnum::COUNTRIES); if ($this->nationality1) { - $nats[] = $this->nationality1; + $nats[$this->nationality1] = $countries[$this->nationality1]; } if ($this->nationality2) { - $nats[] = $this->nationality2; + $nats[$this->nationality2] = $countries[$this->nationality2]; } if ($this->nationality3) { - $nats[] = $this->nationality3; + $nats[$this->nationality3] = $countries[$this->nationality3]; } return $nats; } @@ -277,21 +385,53 @@ class Profile return property_exists($this, $name) || isset($this->data[$name]); } + public function __unset($name) + { + if (property_exists($this, $name)) { + $this->$name = null; + } else { + unset($this->data[$name]); + } + } + + + /** + * Clears a profile. + * *always deletes in: profile_addresses, profile_binets, profile_job, + * profile_langskills, profile_mentor, profile_networking, + * profile_phones, profile_skills, watch_profile + * *always keeps in: profile_corps, profile_display, profile_education, + * profile_medals, profile_name, profile_photos, search_name + * *modifies: profiles + */ + public function clear() + { + $tables = array( + 'profile_job', 'profile_langskills', 'profile_mentor', + 'profile_networking', 'profile_skills', 'watch_profile', + 'profile_phones', 'profile_addresses', 'profile_binets'); + + foreach ($tables as $t) { + XDB::execute('DELETE FROM ' . $t . ' + WHERE pid = {?}', + $this->id()); + } + + XDB::execute("UPDATE profiles + SET cv = NULL, freetext = NULL, freetext_pub = 'private', + medals_pub = 'private', alias_pub = 'private', + email_directory = NULL + WHERE pid = {?}", + $this->id()); + } + /** Sets the level of visibility of the profile * Sets $this->visibility to a list of valid visibilities. - * @param one of the self::VISIBILITY_* values + * @param one of the self::VIS_* values */ public function setVisibilityLevel($visibility) { - if ($visibility != self::VISIBILITY_PRIVATE - && $visibility != self::VISIBILITY_AX - && $visibility != self::VISIBILITY_PUBLIC) { - Platal::page()->kill("Visibility invalide: " . $visibility); - } - $this->visibility = self::$v_values[$visibility]; - if ($this->mobile && !in_array($this->mobile_pub, $this->visibility)) { - unset($this->data['mobile']); - } + $this->visibility->setLevel($visibility); } /** Determine whether an item with visibility $visibility can be displayed @@ -300,16 +440,48 @@ class Profile */ public function isVisible($visibility) { - return in_array($visibility, $this->visibility); + return $this->visibility->isVisible($visibility); + } + + /** Stores the list of fields which have already been fetched for this Profile + */ + public function setFetchedFields($fields) + { + if (($fields | self::FETCH_ALL) != self::FETCH_ALL) { + Platal::page()->kill("Invalid fetched fields: $fields"); + } + + $this->fetched_fields = $fields; } - public static function getCompatibleVisibilities($visibility) + /** Have we already fetched this field ? + */ + private function fetched($field) { - return self::$v_values[$visibility]; + if (!array_key_exists($field, ProfileField::$fields)) { + Platal::page()->kill("Invalid field: $field"); + } + + return ($this->fetched_fields & $field); } - private function getProfileField($cls) + /** If not already done, fetches data for the given field + * @param $field One of the Profile::FETCH_* + * @return A ProfileField, or null + */ + private function getProfileField($field) { + if (!array_key_exists($field, ProfileField::$fields)) { + Platal::page()->kill("Invalid field: $field"); + } + if ($this->fetched($field)) { + return null; + } else { + $this->fetched_fields = $this->fetched_fields | $field; + } + + $cls = ProfileField::$fields[$field]; + return ProfileField::getForPID($cls, $this->id(), $this->visibility); } @@ -317,6 +489,7 @@ class Profile */ private function consolidateFields() { + // Link phones to addresses if ($this->phones != null) { if ($this->addresses != null) { $this->addresses->addPhones($this->phones); @@ -327,30 +500,37 @@ class Profile } } + // Link addresses to jobs if ($this->addresses != null && $this->jobs != null) { $this->jobs->addAddresses($this->addresses); } + + // Link jobterms to jobs + if ($this->jobs != null && $this->jobterms != null) { + $this->jobs->addJobTerms($this->jobterms); + } } /* Photo */ private $photo = null; - public function setPhoto(ProfilePhoto $photo) + public function getPhoto($fallback = true, $data = false) { - $this->photo = $photo; - } - - public function getPhoto($fallback = true) - { - if ($this->photo == null) { - $this->setPhoto($this->getProfileField('ProfilePhoto')); - } - - if ($this->photo != null) { - return $this->photo->pic; + if ($this->has_photo) { + if ($data && ($this->photo == null || $this->photo->mimeType == null)) { + $res = XDB::fetchOneAssoc('SELECT attach, attachmime, x, y, last_update + FROM profile_photos + WHERE pid = {?}', $this->pid); + $this->photo = PlImage::fromData($res['attach'], 'image/' .$res['attachmime'], $res['x'], $res['y'], $res['last_update']); + } else if ($this->photo == null) { + $this->photo = PlImage::fromData(null, null, $this->photo_width, $this->photo_height); + } + return $this->photo; } else if ($fallback) { - return PlImage::fromFile(dirname(__FILE__).'/../htdocs/images/none.png', - 'image/png'); + if ($this->mainEducation() == 'X') { + return PlImage::fromFile(dirname(__FILE__) . '/../htdocs/images/none_x.png', 'image/png'); + } + return PlImage::fromFile(dirname(__FILE__) . '/../htdocs/images/none_md.png', 'image/png'); } return null; } @@ -364,28 +544,73 @@ class Profile $this->consolidateFields(); } - public function getAddresses($flags, $limit = null) + private function fetchAddresses() { - if ($this->addresses == null) { - $this->setAddresses($this->getProfileField('ProfileAddresses')); + if ($this->addresses == null && !$this->fetched(self::FETCH_ADDRESSES)) { + $addr = $this->getProfileField(self::FETCH_ADDRESSES); + if ($addr) { + $this->setAddresses($addr); + $this->fetchPhones(); + } } + } + + public function getAddresses($flags, $limit = null) + { + $this->fetchAddresses(); if ($this->addresses == null) { - return PlIteratorUtils::emptyIterator(); + return array(); } return $this->addresses->get($flags, $limit); } + public function iterAddresses($flags, $limit = null) + { + return PlIteratorUtils::fromArray($this->getAddresses($flags, $limit), 1, true); + } + public function getMainAddress() { - $it = $this->getAddresses(self::ADDRESS_PERSO | self::ADDRESS_MAIN); - if ($it->total() == 0) { - return null; + $main = $this->getAddresses(self::ADDRESS_MAIN); + $perso = $this->getAddresses(self::ADDRESS_PERSO); + + if (count($main)) { + return array_pop($main); + } else if (count($perso)) { + return array_pop($perso); } else { - return $it->next(); + return null; } } + /* Phones + */ + private $phones = null; + public function setPhones(ProfilePhones $phones) + { + $this->phones = $phones; + $this->consolidateFields(); + } + + private function fetchPhones() + { + if ($this->phones == null && !$this->fetched(self::FETCH_PHONES)) { + $phones = $this->getProfileField(self::FETCH_PHONES); + if (isset($phones)) { + $this->setPhones($phones); + } + } + } + + public function getPhones($flags, $limit = null) + { + $this->fetchPhones(); + if ($this->phones == null) { + return array(); + } + return $this->phones->get($flags, $limit); + } /* Educations */ @@ -397,12 +622,12 @@ class Profile public function getEducations($flags, $limit = null) { - if ($this->educations == null) { - $this->setEducations($this->getProfileField('ProfileEducation')); + if ($this->educations == null && !$this->fetched(self::FETCH_EDU)) { + $this->setEducations($this->getProfileField(self::FETCH_EDU)); } if ($this->educations == null) { - return PlIteratorUtils::emptyIterator(); + return array(); } return $this->educations->get($flags, $limit); } @@ -412,6 +637,21 @@ class Profile return $this->getEducations(self::EDUCATION_EXTRA, $limit); } + /* Corps + */ + private $corps = null; + public function setCorps(ProfileCorps $corps) + { + $this->corps = $corps; + } + + public function getCorps() + { + if ($this->corps == null && !$this->fetched(self::FETCH_CORPS)) { + $this->setCorps($this->getProfileField(self::FETCH_CORPS)); + } + return $this->corps; + } /** Networking */ @@ -423,11 +663,14 @@ class Profile public function getNetworking($flags, $limit = null) { - if ($this->networks == null) { - $this->setNetworking($this->getProfileField('ProfileNetworking')); + if ($this->networks == null && !$this->fetched(self::FETCH_NETWORKING)) { + $nw = $this->getProfileField(self::FETCH_NETWORKING); + if ($nw) { + $this->setNetworking($nw); + } } if ($this->networks == null) { - return PlIteratorUtils::emptyIterator(); + return array(); } return $this->networks->get($flags, $limit); } @@ -435,11 +678,11 @@ class Profile public function getWebSite() { $site = $this->getNetworking(self::NETWORKING_WEB, 1); - if ($site->total() != 1) { + if (count($site) != 1) { return null; } - $site = $site->next(); - return $site['address']; + $site = array_pop($site); + return $site; } @@ -452,14 +695,23 @@ class Profile $this->consolidateFields(); } - public function getJobs($flags, $limit = null) + private function fetchJobs() { - if ($this->jobs == null) { - $this->setJobs($this->getProfileField('ProfileJobs')); + if ($this->jobs == null && !$this->fetched(self::FETCH_JOBS)) { + $jobs = $this->getProfileField(self::FETCH_JOBS); + if ($jobs) { + $this->setJobs($jobs); + $this->fetchAddresses(); + } } + } + + public function getJobs($flags, $limit = null) + { + $this->fetchJobs(); if ($this->jobs == null) { - return PlIteratorUtils::emptyIterator(); + return array(); } return $this->jobs->get($flags, $limit); } @@ -467,25 +719,109 @@ class Profile public function getMainJob() { $job = $this->getJobs(self::JOBS_MAIN, 1); - if ($job->total() != 1) { + if (count($job) != 1) { return null; } - return $job->next(); + return array_pop($job); } + /** JobTerms + */ + private $jobterms = null; + public function setJobTerms(ProfileJobTerms $jobterms) + { + $this->jobterms = $jobterms; + $this->consolidateFields(); + } + + private $mentor_countries = null; + public function setMentoringCountries(ProfileMentoringCountries $countries) + { + $this->mentor_countries = $countries; + } + + public function getMentoringCountries() + { + if ($this->mentor_countries == null && !$this->fetched(self::FETCH_MENTOR_COUNTRY)) { + $this->setMentoringCountries($this->getProfileField(self::FETCH_MENTOR_COUNTRY)); + } + + if ($this->mentor_countries == null) { + return array(); + } else { + return $this->mentor_countries->countries; + } + } + + /** List of job terms to specify mentoring */ + private $mentor_terms = null; + /** + * set job terms to specify mentoring + * @param $terms a ProfileMentoringTerms object listing terms only for this profile + */ + public function setMentoringTerms(ProfileMentoringTerms $terms) + { + $this->mentor_terms = $terms; + } + /** + * get all job terms that specify mentoring + * @return an array of JobTerms objects + */ + public function getMentoringTerms() + { + if ($this->mentor_terms == null && !$this->fetched(self::FETCH_MENTOR_TERMS)) { + $this->setMentoringTerms($this->getProfileField(self::FETCH_MENTOR_TERMS)); + } + + if ($this->mentor_terms == null) { + return array(); + } else { + return $this->mentor_terms->get(); + } + } + + /* Binets */ public function getBinets() { - return XDB::fetchColumn('SELECT binet_id - FROM profile_binets - WHERE pid = {?}', $this->id()); + if ($this->visibility->isVisible(ProfileVisibility::VIS_PRIVATE)) { + return XDB::fetchColumn('SELECT binet_id + FROM profile_binets + WHERE pid = {?}', $this->id()); + } else { + return array(); + } + } + public function getBinetsNames() + { + if ($this->visibility->isVisible(ProfileVisibility::VIS_PRIVATE)) { + return XDB::fetchColumn('SELECT text + FROM profile_binets AS pb + LEFT JOIN profile_binet_enum AS pbe ON (pbe.id = pb.binet_id) + WHERE pb.pid = {?}', $this->id()); + } else { + return array(); + } } + /* Medals + */ + private $medals = null; + public function setMedals(ProfileMedals $medals) + { + $this->medals = $medals; + } - public function owner() + public function getMedals() { - return User::getSilent($this); + if ($this->medals == null && !$this->fetched(self::FETCH_MEDALS)) { + $this->setMedals($this->getProfileField(self::FETCH_MEDALS)); + } + if ($this->medals == null) { + return array(); + } + return $this->medals->medals; } public function compareNames($firstname, $lastname) @@ -510,7 +846,7 @@ class Profile private static function fetchProfileData(array $pids, $respect_order = true, $fields = 0x0000, $visibility = null) { if (count($pids) == 0) { - return array(); + return null; } if ($respect_order) { @@ -519,19 +855,31 @@ class Profile $order = ''; } + $visibility = new ProfileVisibility($visibility); - $it = 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, + $it = XDB::Iterator('SELECT p.pid, p.hrpid, p.xorg_id, p.ax_id, p.birthdate, p.birthdate_ref, + p.next_birthday, p.deathdate, p.deathdate_rec, p.sex = \'female\' AS sex, + IF ({?}, p.cv, NULL) AS cv, p.medals_pub, p.alias_pub, p.email_directory, + p.last_change, p.nationality1, p.nationality2, p.nationality3, + IF (p.freetext_pub IN {?}, p.freetext, NULL) AS freetext, + pe.entry_year, pe.grad_year, + IF ({?}, pse.text, NULL) AS section, + pn_f.name AS firstname, pn_l.name AS lastname, + IF( {?}, pn_n.name, NULL) 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.attach IS NOT NULL AS has_photo, ph.pub AS photo_pub, + 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 IN {?}, pp.display_tel, NULL) AS mobile, + (ph.pub IN {?} AND ph.attach IS NOT NULL) AS has_photo, + ph.x AS photo_width, ph.y AS photo_height, p.last_change < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_old, + pm.expertise AS mentor_expertise, 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.pid = p.pid AND FIND_IN_SET(\'primary\', pe.flags)) + LEFT JOIN profile_section_enum AS pse ON (pse.id = p.section) 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 @@ -544,10 +892,19 @@ class Profile AND pn_n.typeid = ' . self::getNameTypeId('nickname', true) . ') 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 profile_mentor AS pm ON (pm.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, + $visibility->isVisible(ProfileVisibility::VIS_PRIVATE), // CV + $visibility->levels(), // freetext + $visibility->isVisible(ProfileVisibility::VIS_PRIVATE), // section + $visibility->isVisible(ProfileVisibility::VIS_PRIVATE), // nickname + $visibility->levels(), // mobile + $visibility->levels(), // photo + $pids + ); return new ProfileIterator($it, $pids, $fields, $visibility); } @@ -588,7 +945,9 @@ class Profile public static function get($login, $fields = 0x0000, $visibility = null) { if (is_array($login)) { - return new Profile($login); + $pf = new Profile($login); + $pf->setVisibilityLevel($visibility); + return $pf; } $pid = self::getPID($login); if (!is_null($pid)) { @@ -619,7 +978,7 @@ class Profile /** Return profiles for the list of pids. */ - public static function getBulkProfilesWithPIDs(array $pids, $fields = self::FETCH_ADDRESSES, $visibility = null) + public static function getBulkProfilesWithPIDs(array $pids, $fields = 0x0000, $visibility = null) { if (count($pids) == 0) { return array(); @@ -650,6 +1009,26 @@ class Profile || $name == self::DN_SHORT || $name == self::DN_SORT; } + /** Returns the closest "accounts only" name type for $name + */ + public static function getAccountEquivalentName($name) + { + switch ($name) + { + case self::DN_DIRECTORY: + case self::DN_SORT: + return 'directory_name'; + case self::DN_FULL: + case self::DN_PUBLIC: + return 'full_name'; + case self::DN_PRIVATE: + case self::DN_SHORT: + case self::DN_YOURSELF: + default: + return 'display_name'; + } + } + public static function getNameTypeId($type, $for_sql = false) { if (!S::has('name_types')) { @@ -666,39 +1045,66 @@ class Profile } } - public static function rebuildSearchTokens($pid) + public static function rebuildSearchTokens($pids, $transaction = true) { - XDB::execute('DELETE FROM search_name - WHERE pid = {?}', - $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 (!is_array($pids)) { + $pids = array($pids); + } + $keys = XDB::iterator("(SELECT n.pid AS pid, n.name AS name, e.score AS score, + IF(FIND_IN_SET('public', e.flags), 'public', '') AS public + FROM profile_name AS n + INNER JOIN profile_name_enum AS e ON (n.typeid = e.id) + WHERE n.pid IN {?} AND NOT FIND_IN_SET('not_displayed', e.flags)) + UNION + (SELECT n.pid AS pid, n.particle AS name, 0 AS score, + IF(FIND_IN_SET('public', e.flags), 'public', '') AS public + FROM profile_name AS n + INNER JOIN profile_name_enum AS e ON (n.typeid = e.id) + WHERE n.pid IN {?} AND NOT FIND_IN_SET('not_displayed', e.flags)) + ", + $pids, $pids); + $names = array(); + while ($key = $keys->next()) { if ($key['name'] == '') { continue; } - $toks = preg_split('/[ \'\-]+/', $key['name']); + $pid = $key['pid']; + $toks = preg_split('/[ \'\-]+/', strtolower(replace_accent($key['name'])), + -1, PREG_SPLIT_NO_EMPTY); + $toks = array_reverse($toks); + + /* Split the score between the tokens to avoid the user to be over-rated. + * Let says my user name is "Machin-Truc Bidule" and I also have a user named + * 'Machin Truc'. Distributing the score force "Machin Truc" to be displayed + * before "Machin-Truc" for both "Machin Truc" and "Machin" searches. + */ + $eltScore = ceil(((float)$key['score'])/((float)count($toks))); $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, pid, soundex, score, flags) - VALUES ({?}, {?}, {?}, {?}, {?})', - $token, $pid, soundex_fr($token), $score, $key['public']); - $first = 0; + foreach ($toks as $tok) { + $token = $tok . $token; + $names["$pid-$token"] = XDB::format('({?}, {?}, {?}, {?}, {?})', + $token, $pid, soundex_fr($token), + $eltScore, $key['public']); } } + if ($transaction) { + XDB::startTransaction(); + } + XDB::execute('DELETE FROM search_name + WHERE pid IN {?}', + $pids); + if (count($names) > 0) { + XDB::rawExecute('INSERT INTO search_name (token, pid, soundex, score, flags) + VALUES ' . implode(', ', $names)); + } + if ($transaction) { + XDB::commit(); + } } /** 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. @@ -752,12 +1158,20 @@ class ProfileIterator implements PlIterator { private $iterator = null; private $fields; + private $visibility; + + const FETCH_ALL = 0x000033F; // FETCH_ADDRESSES | FETCH_CORPS | FETCH_EDU | FETCH_JOBS | FETCH_MEDALS | FETCH_NETWORKING | FETCH_PHONES | FETCH_JOB_TERMS - public function __construct(PlIterator $it, array $pids, $fields = 0x0000, $visibility = null) + public function __construct(PlIterator $it, array $pids, $fields = 0x0000, ProfileVisibility $visibility = null) { require_once 'profilefields.inc.php'; - $visibility = Profile::getVisibilityContext($visibility); + + if ($visibility == null) { + $visibility = new ProfileVisibility(); + } + $this->fields = $fields; + $this->visibility = $visibility; $subits = array(); $callbacks = array(); @@ -766,57 +1180,28 @@ class ProfileIterator implements PlIterator $callbacks[0] = PlIteratorUtils::arrayValueCallback('pid'); $cb = PlIteratorUtils::objectPropertyCallback('pid'); - if ($fields & Profile::FETCH_ADDRESSES) { - $callbacks[Profile::FETCH_ADDRESSES] = $cb; - $subits[Profile::FETCH_ADDRESSES] = new ProfileFieldIterator('ProfileAddresses', $pids, $visibility); - } - - if ($fields & Profile::FETCH_CORPS) { - $callbacks[Profile::FETCH_CORPS] = $cb; - $subits[Profile::FETCH_CORPS] = new ProfileFieldIterator('ProfileCorps', $pids, $visibility); - } - - if ($fields & Profile::FETCH_EDU) { - $callbacks[Profile::FETCH_EDU] = $cb; - $subits[Profile::FETCH_EDU] = new ProfileFieldIterator('ProfileEducation', $pids, $visibility); - } - - if ($fields & Profile::FETCH_JOBS) { - $callbacks[Profile::FETCH_JOBS] = $cb; - $subits[Profile::FETCH_JOBS] = new ProfileFieldIterator('ProfileJobs', $pids, $visibility); - } - - if ($fields & Profile::FETCH_MEDALS) { - $callbacks[Profile::FETCH_MEDALS] = $cb; - $subits[Profile::FETCH_MEDALS] = new ProfileFieldIterator('ProfileMedals', $pids, $visibility); - } - - if ($fields & Profile::FETCH_NETWORKING) { - $callbacks[Profile::FETCH_NETWORKING] = $cb; - $subits[Profile::FETCH_NETWORKING] = new ProfileFieldIterator('ProfileNetworking', $pids, $visibility); - } - - if ($fields & Profile::FETCH_PHONES) { - $callbacks[Profile::FETCH_PHONES] = $cb; - $subits[Profile::FETCH_PHONES] = new ProfileFieldIterator('ProfilePhones', $pids, $visibility); - } - - if ($fields & Profile::FETCH_PHOTO) { - $callbacks[Profile::FETCH_PHOTO] = $cb; - $subits[Profile::FETCH_PHOTO] = new ProfileFieldIterator('ProfilePhoto', $pids, $visibility); + $fields = $fields & self::FETCH_ALL; + for ($field = 1; $field < $fields; $field *= 2) { + if (($fields & $field) ) { + $callbacks[$field] = $cb; + $subits[$field] = new ProfileFieldIterator($field, $pids, $visibility); + } } $this->iterator = PlIteratorUtils::parallelIterator($subits, $callbacks, 0); } - private function hasData($flag, $vals) + private function hasData($field, $vals) { - return ($this->fields & $flag) && ($vals[$flag] != null); + return ($this->fields & $field) && ($vals[$field] != null); } private function fillProfile(array $vals) { $pf = Profile::get($vals[0]); + $pf->setVisibilityLevel($this->visibility->level()); + $pf->setFetchedFields($this->fields); + if ($this->hasData(Profile::FETCH_PHONES, $vals)) { $pf->setPhones($vals[Profile::FETCH_PHONES]); } @@ -826,12 +1211,15 @@ class ProfileIterator implements PlIterator if ($this->hasData(Profile::FETCH_JOBS, $vals)) { $pf->setJobs($vals[Profile::FETCH_JOBS]); } + if ($this->hasData(Profile::FETCH_JOB_TERMS, $vals)) { + $pf->setJobTerms($vals[Profile::FETCH_JOB_TERMS]); + } if ($this->hasData(Profile::FETCH_CORPS, $vals)) { $pf->setCorps($vals[Profile::FETCH_CORPS]); } if ($this->hasData(Profile::FETCH_EDU, $vals)) { - $pf->setEdu($vals[Profile::FETCH_EDU]); + $pf->setEducations($vals[Profile::FETCH_EDU]); } if ($this->hasData(Profile::FETCH_MEDALS, $vals)) { $pf->setMedals($vals[Profile::FETCH_MEDALS]); @@ -839,9 +1227,6 @@ class ProfileIterator implements PlIterator if ($this->hasData(Profile::FETCH_NETWORKING, $vals)) { $pf->setNetworking($vals[Profile::FETCH_NETWORKING]); } - if ($this->hasData(Profile::FETCH_PHOTO, $vals)) { - $pf->setPhoto($vals[Profile::FETCH_PHOTO]); - } return $pf; }