X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fuserfilter%2Fconditions.inc.php;h=2ad8d1dd7ceed6587220a2439d73d09df5c4912e;hb=73317355964c4cd538157f8b281a1384b7e38e4d;hp=c689f0b4999d28e5b4a4e7205f4ade446c888f68;hpb=8a70ca6fac73380af967fdd9271a834be25b021e;p=platal.git diff --git a/classes/userfilter/conditions.inc.php b/classes/userfilter/conditions.inc.php index c689f0b..2ad8d1d 100644 --- a/classes/userfilter/conditions.inc.php +++ b/classes/userfilter/conditions.inc.php @@ -1,6 +1,6 @@ requireProfiles(); - return $uf->getVisibilityCondition('p.freetext_pub') . ' AND p.freetext ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->text); + return $uf->getVisibilityConditionForField('p.freetext_pub') . ' AND p.freetext ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->text); } public function export() @@ -583,67 +583,35 @@ class UFC_EducationField extends UserFilterCondition } } // }}} -// {{{ class UFC_Name -/** Filters users based on name - * @param $type Type of name field on which filtering is done (firstname, lastname...) - * @param $text Text on which to filter - * @param $mode Flag indicating search type (prefix, suffix, with particule...) +// {{{ class UFC_NameInitial +/** Filters users based on sort_name + * @param $initial Initial on which to filter */ -class UFC_Name extends UserFilterCondition +class UFC_NameInitial extends UserFilterCondition { - const EXACT = XDB::WILDCARD_EXACT; // 0x000 - const PREFIX = XDB::WILDCARD_PREFIX; // 0x001 - const SUFFIX = XDB::WILDCARD_SUFFIX; // 0x002 - const CONTAINS = XDB::WILDCARD_CONTAINS; // 0x003 - const PARTICLE = 0x004; - const VARIANTS = 0x008; + private $initial; - private $type; - private $text; - private $mode; - - public function __construct($type, $text, $mode) - { - $this->type = $type; - $this->text = $text; - $this->mode = $mode; - } - - private function buildNameQuery($type, $variant, $where, UserFilter $uf) + public function __construct($initial) { - $sub = $uf->addNameFilter($type, $variant); - return str_replace('$ME', 'pn' . $sub, $where); + $this->initial = $initial; } public function buildCondition(PlFilter $uf) { - $left = '$ME.name'; - if (($this->mode & self::PARTICLE) == self::PARTICLE) { - $left = 'CONCAT($ME.particle, \' \', $ME.name)'; - } - $right = XDB::formatWildcards($this->mode & self::CONTAINS, $this->text); - - $cond = $left . $right; - $conds = array($this->buildNameQuery($this->type, null, $cond, $uf)); - if (($this->mode & self::VARIANTS) != 0 && isset(Profile::$name_variants[$this->type])) { - foreach (Profile::$name_variants[$this->type] as $var) { - $conds[] = $this->buildNameQuery($this->type, $var, $cond, $uf); - } + $table = 'sort_name'; + if ($uf->accountsRequired()) { + $table = Profile::getAccountEquivalentName($table); + $sub = 'a'; + } else { + $uf->addDisplayFilter(); + $sub = 'pd'; } - return implode(' OR ', $conds); + return 'SUBSTRING(' . $sub . '.' . $table . ', 1, 1) ' . XDB::formatWildcards(XDB::WILDCARD_PREFIX, $this->initial); } public function export() { - $export = $this->buildExport($this->type); - if ($this->mode & self::VARIANTS) { - $export['search_in_variants'] = true; - } - if ($this->mode & self::PARTICLE) { - $export['search_in_particle'] = true; - } - $export['comparison'] = self::comparisonFromXDBWildcard($this->mode & 0x3); - $export['text'] = $this->text; + $export = $this->buildExport($this->initial); return $export; } } @@ -663,8 +631,9 @@ class UFC_NameTokens extends UserFilterCondition private $flags; private $soundex; private $exact; + private $general_type; - public function __construct($tokens, $flags = array(), $soundex = false, $exact = false) + public function __construct($tokens, $flags = array(), $soundex = false, $exact = false, $general_type = '') { if (is_array($tokens)) { $this->tokens = $tokens; @@ -678,6 +647,7 @@ class UFC_NameTokens extends UserFilterCondition } $this->soundex = $soundex; $this->exact = $exact; + $this->general_type = $general_type; } public function buildCondition(PlFilter $uf) @@ -695,6 +665,10 @@ class UFC_NameTokens extends UserFilterCondition if ($this->flags != null) { $c .= XDB::format(' AND ' . $sub . '.flags IN {?}', $this->flags); } + if ($this->general_type) { + $c .= XDB::format(' AND ' . $sub . '.general_type = {?}', $this->general_type); + } + $c .= ' AND (' . $uf->getVisibilityConditionAbsolute(Visibility::EXPORT_PRIVATE) . ' OR ' . $sub . '.general_type != \'nickname\')'; $conds[] = $c; } @@ -864,7 +838,7 @@ class UFC_NLSubscribed extends UserFilterCondition { private $nlid; private $issue_id; - public function __construct($nlid, $issue_id) + public function __construct($nlid, $issue_id = null) { $this->nlid = $nlid; $this->issue_id = $issue_id; @@ -873,7 +847,11 @@ class UFC_NLSubscribed extends UserFilterCondition public function buildCondition(PlFilter $uf) { $sub = $uf->addNewsLetterFilter($this->nlid); - return XDB::format($sub . '.last < {?}', $this->issue_id); + $cond = $sub . '.nlid IS NOT NULL'; + if (!is_null($this->issue_id)) { + $cond = XDB::format($cond . ' AND ( ' . $sub . '.last IS NULL OR ' . $sub . '.last < {?})', $this->issue_id); + } + return $cond; } } // }}} @@ -884,12 +862,19 @@ class UFC_NLSubscribed extends UserFilterCondition */ class UFC_Group extends UserFilterCondition { + const BOTH = 0; + const NOTIFIED = 1; + const UNNOTIFIED = 2; + private $group; private $anim; - public function __construct($group, $anim = false) + private $notified; + + public function __construct($group, $anim = false, $notified = self::BOTH) { $this->group = $group; $this->anim = $anim; + $this->notified = $notified; } public function buildCondition(PlFilter $uf) @@ -903,10 +888,38 @@ class UFC_Group extends UserFilterCondition if ($this->anim) { $where .= ' AND gpm' . $sub . '.perms = \'admin\''; } + if ($this->notified != self::BOTH) { + $where .= ' AND ' . ($this->notified == self::UNNOTIFIED ? 'NOT ' : '') + . "FIND_IN_SET('notify', gpm" . $sub . '.flags)'; + } return $where; } } // }}} +// {{{ class UFC_GroupFormerMember +/** Filters users based on group former membership + * @param $group Group whose former members we are selecting + */ +class UFC_GroupFormerMember extends UserFilterCondition +{ + private $group; + + public function __construct($group) + { + $this->group = $group; + } + + public function buildCondition(PlFilter $uf) + { + // Groups are only visible for users with perm 'groups'. + if (!S::user()->checkPerms(User::PERM_GROUPS)) { + return self::COND_FALSE; + } + $sub = $uf->addGroupFormerMemberFilter(); + return XDB::format('gpfm' . $sub . '.asso_id = {?}', $this->group); + } +} +// }}} // {{{ class UFC_Binet /** Selects users based on their belonging to a given (list of) binet * @param $binet either a binet_id or an array of binet_ids @@ -922,12 +935,9 @@ class UFC_Binet extends UserFilterCondition public function buildCondition(PlFilter $uf) { - // Binets are private. - if ($uf->getVisibilityLevel() != ProfileVisibility::VIS_PRIVATE) { - return self::COND_TRUE; - } $sub = $uf->addBinetsFilter(); - return XDB::format($sub . '.binet_id IN {?}', $this->val); + // Binets are private. + return XDB::format($uf->getVisibilityConditionAbsolute(Visibility::EXPORT_PRIVATE) . ' AND ' . $sub . '.binet_id IN {?}', $this->val); } } // }}} @@ -947,11 +957,8 @@ class UFC_Section extends UserFilterCondition public function buildCondition(PlFilter $uf) { // Sections are private. - if ($uf->getVisibilityLevel() != ProfileVisibility::VIS_PRIVATE) { - return self::COND_TRUE; - } $uf->requireProfiles(); - return XDB::format('p.section IN {?}', $this->section); + return XDB::format($uf->getVisibilityConditionAbsolute(Visibility::EXPORT_PRIVATE) . ' AND p.section IN {?}', $this->section); } } // }}} @@ -974,7 +981,7 @@ class UFC_Email extends UserFilterCondition $cond = array(); if (count($this->emails) == 0) { - return PlFilterCondition::COND_TRUE; + return PlFilterCondition::COND_FALSE; } foreach ($this->emails as $entry) { @@ -988,7 +995,7 @@ class UFC_Email extends UserFilterCondition if (count($foreign) > 0) { $sub = $uf->addEmailRedirectFilter($foreign); - $cond[] = XDB::format('ra' . $sub . '.redirect IS NOT NULL OR ra' . $sub . '.redirect IN {?}', $foreign); + $cond[] = XDB::format('ra' . $sub . '.redirect IS NOT NULL OR ra' . $sub . '.redirect IN {?} OR a.email IN {?}', $foreign, $foreign); } if (count($local) > 0) { $sub = $uf->addAliasFilter($local); @@ -1001,31 +1008,36 @@ class UFC_Email extends UserFilterCondition // {{{ class UFC_Address abstract class UFC_Address extends UserFilterCondition { - /** Valid address type ('hq' is reserved for company addresses) + /** Valid address type */ - const TYPE_HOME = 1; - const TYPE_PRO = 2; - const TYPE_ANY = 3; + const TYPE_HOME = 1; + const TYPE_PRO = 2; + const TYPE_NON_HQ = 3; + const TYPE_HQ = 4; + const TYPE_ANY = 7; /** Text for these types */ protected static $typetexts = array( self::TYPE_HOME => 'home', self::TYPE_PRO => 'pro', + self::TYPE_HQ => 'hq', ); protected $type; /** Flags for addresses */ + const FLAG_NONE = 0x0000; const FLAG_CURRENT = 0x0001; const FLAG_TEMP = 0x0002; const FLAG_SECOND = 0x0004; const FLAG_MAIL = 0x0008; const FLAG_CEDEX = 0x0010; + const FLAG_AX_MAIL = 0x0020; // Binary OR of those flags - const FLAG_ANY = 0x001F; + const FLAG_ANY = 0x003F; /** Text of these flags */ @@ -1035,6 +1047,7 @@ abstract class UFC_Address extends UserFilterCondition self::FLAG_SECOND => 'secondary', self::FLAG_MAIL => 'mail', self::FLAG_CEDEX => 'cedex', + self::FLAG_AX_MAIL => 'ax_mail', ); protected $flags; @@ -1056,13 +1069,13 @@ abstract class UFC_Address extends UserFilterCondition } } if (count($types)) { - $conds[] = XDB::format($sub . '.type IN {?}', $types); + $conds[] = XDB::format('pa' . $sub . '.type IN {?}', $types); } if ($this->flags != self::FLAG_ANY) { foreach(self::$flagtexts as $flag => $text) { if ($flag & $this->flags) { - $conds[] = 'FIND_IN_SET(' . XDB::format('{?}', $text) . ', ' . $sub . '.flags)'; + $conds[] = 'FIND_IN_SET(' . XDB::format('{?}', $text) . ', pa' . $sub . '.flags)'; } } } @@ -1071,61 +1084,6 @@ abstract class UFC_Address extends UserFilterCondition } // }}} -// {{{ class UFC_AddressText -/** Select users based on their address, using full text search - * @param $text Text for filter in fulltext search - * @param $textSearchMode Mode for search (one of XDB::WILDCARD_*) - * @param $type Filter on address type - * @param $flags Filter on address flags - * @param $country Filter on address country - * @param $locality Filter on address locality - */ -class UFC_AddressText extends UFC_Address -{ - - private $text; - private $textSearchMode; - - public function __construct($text = null, $textSearchMode = XDB::WILDCARD_CONTAINS, - $type = null, $flags = self::FLAG_ANY, $country = null, $locality = null) - { - parent::__construct($type, $flags); - $this->text = $text; - $this->textSearchMode = $textSearchMode; - $this->country = $country; - $this->locality = $locality; - } - - private function mkMatch($txt) - { - return XDB::formatWildcards($this->textSearchMode, $txt); - } - - public function buildCondition(PlFilter $uf) - { - $sub = $uf->addAddressFilter(); - $conds = $this->initConds($sub, $uf->getVisibilityCondition($sub . '.pub')); - if ($this->text != null) { - $conds[] = $sub . '.text' . $this->mkMatch($this->text); - } - - if ($this->country != null) { - $subc = $uf->addAddressCountryFilter(); - $subconds = array(); - $subconds[] = $subc . '.country' . $this->mkMatch($this->country); - $subconds[] = $subc . '.countryFR' . $this->mkMatch($this->country); - $conds[] = implode(' OR ', $subconds); - } - - if ($this->locality != null) { - $subl = $uf->addAddressLocalityFilter(); - $conds[] = $subl . '.name' . $this->mkMatch($this->locality); - } - - return implode(' AND ', $conds); - } -} -// }}} // {{{ class UFC_AddressField /** Filters users based on their address, * @param $val Either a code for one of the fields, or an array of such codes @@ -1133,23 +1091,23 @@ class UFC_AddressText extends UFC_Address * @param $type Filter on address type * @param $flags Filter on address flags */ -class UFC_AddressField extends UFC_Address +class UFC_AddressComponent extends UFC_Address { - const FIELD_COUNTRY = 1; - const FIELD_ADMAREA = 2; - const FIELD_SUBADMAREA = 3; - const FIELD_LOCALITY = 4; - const FIELD_ZIPCODE = 5; + static $components = array('postal_code', 'locality', 'administrative_area_level_3', 'administrative_area_level_2', 'administrative_area_level_1', 'country'); /** Data of the filter */ private $val; private $fieldtype; + private $exact; public function __construct($val, $fieldtype, $type = null, $flags = self::FLAG_ANY) { - parent::__construct($type, $flags); + if (!in_array($fieldtype, self::$components)) { + Platal::page()->killError('Invalid address field type: ' . $this->fieldtype); + } + parent::__construct($type, $flags); if (!is_array($val)) { $val = array($val); } @@ -1159,29 +1117,9 @@ class UFC_AddressField extends UFC_Address public function buildCondition(PlFilter $uf) { - $sub = $uf->addAddressFilter(); - $conds = $this->initConds($sub, $uf->getVisibilityCondition($sub . '.pub')); - - switch ($this->fieldtype) { - case self::FIELD_COUNTRY: - $field = 'countryId'; - break; - case self::FIELD_ADMAREA: - $field = 'administrativeAreaId'; - break; - case self::FIELD_SUBADMAREA: - $field = 'subAdministrativeAreaId'; - break; - case self::FIELD_LOCALITY: - $field = 'localityId'; - break; - case self::FIELD_ZIPCODE: - $field = 'postalCode'; - break; - default: - Platal::page()->killError('Invalid address field type: ' . $this->fieldtype); - } - $conds[] = XDB::format($sub . '.' . $field . ' IN {?}', $this->val); + $sub = $uf->addAddressFilter($this->fieldtype); + $conds = $this->initConds($sub, $uf->getVisibilityConditionForField('pa' . $sub . '.pub')); + $conds[] = XDB::format('pace' . $sub . '.id IN {?}', $this->val); return implode(' AND ', $conds); } @@ -1223,7 +1161,7 @@ class UFC_Corps extends UserFilterCondition } // XXX(x2006barrois): find a way to get rid of that hardcoded // reference to 'pc'. - $cond .= ' AND ' . $uf->getVisibilityCondition('pc.corps_pub'); + $cond .= ' AND ' . $uf->getVisibilityConditionForField('pc.corps_pub'); return $cond; } } @@ -1257,7 +1195,7 @@ class UFC_Corps_Rank extends UserFilterCondition } // XXX(x2006barrois): find a way to get rid of that hardcoded // reference to 'pc'. - $cond .= ' AND ' . $uf->getVisibilityCondition('pc.corps_pub'); + $cond .= ' AND ' . $uf->getVisibilityConditionForField('pc.corps_pub'); return $cond; } } @@ -1295,7 +1233,7 @@ class UFC_Job_Company extends UserFilterCondition $sub = $uf->addJobCompanyFilter(); $cond = $sub . '.' . $this->type . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->value); $jsub = $uf->addJobFilter(); - $cond .= ' AND ' . $uf->getVisibilityCondition($jsub . '.pub'); + $cond .= ' AND ' . $uf->getVisibilityConditionForField($jsub . '.pub'); return $cond; } } @@ -1325,7 +1263,7 @@ class UFC_Job_Terms extends UserFilterCondition $conditions[] = $sub[$i] . '.jtid_1 = ' . XDB::escape($jtid); } $jsub = $uf->addJobFilter(); - $conditions[] = $uf->getVisibilityCondition($jsub . '.pub'); + $conditions[] = $uf->getVisibilityConditionForField($jsub . '.pub'); return implode(' AND ', $conditions); } } @@ -1352,24 +1290,18 @@ class UFC_Job_Description extends UserFilterCondition $conds = array(); $jsub = $uf->addJobFilter(); - // CV is private => if only CV requested, and not private, - // don't do anything. Otherwise restrict to standard job visibility. - if ($this->fields == UserFilter::JOB_CV) { - if ($uf->getVisibilityLevel() != ProfileVisibility::VIS_PRIVATE) { - return self::COND_TRUE; - } - } if ($this->fields & UserFilter::JOB_USERDEFINED) { $conds[] = $jsub . '.description ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->description); } - if ($this->fields & UserFilter::JOB_CV && $uf->getVisibilityLevel() == ProfileVisibility::VIS_PRIVATE) { + if ($this->fields & UserFilter::JOB_CV) { $uf->requireProfiles(); - $conds[] = 'p.cv ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->description); + // CV is private + $conds[] = '( ' . $uf->getVisibilityConditionAbsolute(Visibility::EXPORT_PRIVATE) . ' AND p.cv ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->description) . ')'; } if (count($conds) == 0) { return self::COND_TRUE; } - return $uf->getVisibilityCondition($jsub . '.pub') . ' AND ( ' . implode(' OR ', $conds) . ' )'; + return $uf->getVisibilityConditionForField($jsub . '.pub') . ' AND ( ' . implode(' OR ', $conds) . ' )'; } } // }}} @@ -1393,7 +1325,7 @@ class UFC_Networking extends UserFilterCondition { $sub = $uf->addNetworkingFilter(); $conds = array(); - $conds[] = $uf->getVisibilityCondition($sub . '.pub'); + $conds[] = $uf->getVisibilityConditionForField($sub . '.pub'); $conds[] = $sub . '.address ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->value); if ($this->type != -1) { $conds[] = $sub . '.nwid = ' . XDB::format('{?}', $this->type); @@ -1428,7 +1360,7 @@ class UFC_Phone extends UserFilterCondition { $phone = new Phone(array('display' => $number)); $phone->format(); - $this->number = $phone->search(); + $this->number = $phone->search; $this->num_type = $num_type; $this->phone_type = $phone_type; } @@ -1438,7 +1370,7 @@ class UFC_Phone extends UserFilterCondition $sub = $uf->addPhoneFilter(); $conds = array(); - $conds[] = $uf->getVisibilityCondition($sub . '.pub'); + $conds[] = $uf->getVisibilityConditionForField($sub . '.pub'); $conds[] = $sub . '.search_tel = ' . XDB::format('{?}', $this->number); if ($this->num_type != self::NUM_ANY) { @@ -1474,7 +1406,7 @@ class UFC_Medal extends UserFilterCondition // This will require profiles => table 'p' will be available. $sub = $uf->addMedalFilter(); - $conds[] = $uf->getVisibilityCondition('p.medals_pub'); + $conds[] = $uf->getVisibilityConditionForField('p.medals_pub'); $conds[] = $sub . '.mid = ' . XDB::format('{?}', $this->medal); if ($this->grade != null) { @@ -1492,7 +1424,7 @@ class UFC_Photo extends UserFilterCondition public function buildCondition(PlFilter $uf) { $sub = $uf->addPhotoFilter(); - return $sub . '.attach IS NOT NULL AND ' . $uf->getVisibilityCondition($sub . '.pub'); + return $sub . '.attach IS NOT NULL AND ' . $uf->getVisibilityConditionForField($sub . '.pub'); } } // }}} @@ -1579,6 +1511,36 @@ abstract class UFC_UserRelated extends UserFilterCondition } } // }}} +// {{{ class UFC_DeltaTen +class UFC_DeltaTen extends UserFilterCondition +{ + public function buildCondition(PlFilter $uf) + { + $sub = $uf->addDeltaTenFilter(UserFilter::DELTATEN); + return $sub . '.message IS NOT NULL'; + } +} +// }}} +// {{{ class UFC_DeltaTen_Message +/** Filters users by deltaten message + * @param $message Message for the DeltaTen program + */ +class UFC_DeltaTen_Message extends UserFilterCondition +{ + private $message; + + public function __construct($message) + { + $this->message = $message; + } + + public function buildCondition(PlFilter $uf) + { + $sub = $uf->addDeltaTenFilter(UserFilter::DELTATEN_MESSAGE); + return $sub . '.message ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->message); + } +} +// }}} // {{{ class UFC_Contact /** Filters users who belong to selected user's contacts */ @@ -1637,6 +1599,27 @@ class UFC_WatchPromo extends UFC_UserRelated } } // }}} +// {{{ class UFC_WatchGroup +/** Filters users belonging to a group watched by selected user + * @param $user Selected user (the one watching group) + */ +class UFC_WatchGroup extends UFC_UserRelated +{ + public function buildCondition(PlFilter $uf) + { + $groups = $this->user->watchGroups(); + if (count($groups) == 0) { + return PlFilterCondition::COND_FALSE; + } + $conditions = array(); + foreach ($groups as $group) { + $sub = $uf->addGroupFilter($group); + $conditions[] = 'gpm' . $sub . '.perms IS NOT NULL'; + } + return implode(' OR ', $conditions); + } +} +// }}} // {{{ class UFC_WatchContact /** Filters users watched by selected user */ @@ -1671,6 +1654,72 @@ class UFC_MarketingHash extends UserFilterCondition } } // }}} +// {{{ class UFC_PartnerSharing +/** Filters users, keeping only those sharing data with a given partner. + */ +class UFC_PartnerSharing extends UserFilterCondition +{ + const PTA = 'pta'; + + private $partner_id; + + public function __construct($partner_id) + { + $this->partner_id = $partner_id; + } + + public function buildCondition(PlFilter $uf) + { + $sub = $uf->addPartnerSharingFilter($this->partner_id); + return XDB::format("$sub.exposed_uid IS NOT NULL"); + } +} +// }}} +// {{{ class UFC_PartnerSharingEmail +/** Filters users, keeping only those allowing emails to be sent by + * a given partner. + */ +class UFC_PartnerSharingEmail extends UserFilterCondition +{ + private $partner_id; + + public function __construct($partner_id) + { + $this->partner_id = $partner_id; + } + + public function buildCondition(PlFilter $uf) + { + $sub = $uf->addPartnerSharingFilter($this->partner_id); + return XDB::format("$sub.allow_email IN ('digest', 'direct')"); + } +} +// }}} +// {{{ class UFC_PartnerSharingID +/** Filters users according to a list of partner-known IDs + */ +class UFC_PartnerSharingID extends UserFilterCondition +{ + private $partner_id; + private $ids; + + public function __construct($partner_id) + { + $this->partner_id = $partner_id; + $ids = func_get_args(); + array_shift($ids); + $this->ids = pl_flatten($ids); + } + + public function buildCondition(PlFilter $uf) + { + $uf->requireProfiles(); + $ids = $this->ids; + $sub = $uf->addPartnerSharingFilter($this->partner_id); + return XDB::format("$sub.exposed_uid IN {?}", $ids); + } +} +// }}} -// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8: ?>