X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fuserfilter%2Fconditions.inc.php;h=2ad8d1dd7ceed6587220a2439d73d09df5c4912e;hb=73317355964c4cd538157f8b281a1384b7e38e4d;hp=5bc066886383f553c0bcdb515ed869d1b389a46f;hpb=45a465516f68f40cd7205ec6c332f44b8c921fae;p=platal.git diff --git a/classes/userfilter/conditions.inc.php b/classes/userfilter/conditions.inc.php index 5bc0668..2ad8d1d 100644 --- a/classes/userfilter/conditions.inc.php +++ b/classes/userfilter/conditions.inc.php @@ -1,6 +1,6 @@ '; const OP_NOTGREATER = '<='; const OP_LESSER = '<'; @@ -166,7 +166,15 @@ abstract class UserFilterCondition implements PlFilterCondition $cond = new $class($values); break; + case 'school_id': + $values = $export->v('values', array()); + $school_type = $export->s('school_type'); + $cond = new UFC_SchoolId($school_type, $values); + break; + case 'has_profile': + case 'has_email_redirect': + case 'has_valid_email': $class = 'ufc_' . str_replace('_', '', $type); $cond = new $class(); break; @@ -324,6 +332,43 @@ class UFC_Hrpid extends UserFilterCondition } } // }}} +// {{{ class UFC_HasEmailRedirect +/** Filters users, keeping only those with a valid email redirection (only X.org accounts). + */ +class UFC_HasEmailRedirect extends UserFilterCondition +{ + public function buildCondition(PlFilter $uf) + { + $sub_redirect = $uf->addActiveEmailRedirectFilter(); + return 'rf.redirect IS NOT NULL'; + } + + public function export() + { + $export = $this->buildExport('has_email_redirect'); + return $export; + } +} +// }}} +// {{{ class UFC_HasValidEmail +/** Filters users, keeping only those with a valid email address (all accounts). + */ +class UFC_HasValidEmail extends UserFilterCondition +{ + public function buildCondition(PlFilter $uf) + { + $sub_redirect = $uf->addEmailRedirectFilter(); + $uf->requireAccounts(); + return 'ra' . $sub_redirect . '.flags = \'active\' OR a.email IS NOT NULL'; + } + + public function export() + { + $export = $this->buildExport('has_valid_email'); + return $export; + } +} +// }}} // {{{ class UFC_Ip /** Filters users based on one of their last IPs * @param $ip IP from which connection are checked @@ -365,7 +410,7 @@ class UFC_Comment extends UserFilterCondition public function buildCondition(PlFilter $uf) { $uf->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() @@ -474,6 +519,14 @@ class UFC_SchoolId extends UserFilterCondition } return XDB::format('p.' . $type . '_id IN {?}', $ids); } + + public function export() + { + $export = $this->buildExport('school_id'); + $export['school_type'] = $this->type; + $export['values'] = $this->ids; + return $export; + } } // }}} // {{{ class UFC_EducationSchool @@ -530,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 $type; - private $text; - private $mode; - - public function __construct($type, $text, $mode) - { - $this->type = $type; - $this->text = $text; - $this->mode = $mode; - } + private $initial; - 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; } } @@ -610,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; @@ -625,6 +647,7 @@ class UFC_NameTokens extends UserFilterCondition } $this->soundex = $soundex; $this->exact = $exact; + $this->general_type = $general_type; } public function buildCondition(PlFilter $uf) @@ -642,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; } @@ -802,6 +829,32 @@ class UFC_Sex extends UserFilterCondition } } // }}} +// {{{ class UFC_NLSubscribed +/** Filters users based on NL subscription + * @param $nlid NL whose subscribers we are selecting + * @param $issue Select only subscribers who have not yet received that issue + */ +class UFC_NLSubscribed extends UserFilterCondition +{ + private $nlid; + private $issue_id; + public function __construct($nlid, $issue_id = null) + { + $this->nlid = $nlid; + $this->issue_id = $issue_id; + } + + public function buildCondition(PlFilter $uf) + { + $sub = $uf->addNewsLetterFilter($this->nlid); + $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; + } +} +// }}} // {{{ class UFC_Group /** Filters users based on group membership * @param $group Group whose members we are selecting @@ -809,29 +862,64 @@ class UFC_Sex 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) { - // Groups have AX visibility. - if ($uf->getVisibilityLevel() == ProfileVisibility::VIS_PUBLIC) { - return self::COND_TRUE; + // Groups are only visible for users with perm 'groups'. + if (!S::user()->checkPerms(User::PERM_GROUPS)) { + return self::COND_FALSE; } $sub = $uf->addGroupFilter($this->group); $where = 'gpm' . $sub . '.perms IS NOT NULL'; 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 @@ -847,12 +935,9 @@ class UFC_Binet extends UserFilterCondition public function buildCondition(PlFilter $uf) { - // Binets are private. - if ($uf->getVisibilityLevel() != ProfileVisibility::VIS_PRIVATE) { - return self::CONF_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); } } // }}} @@ -872,11 +957,8 @@ class UFC_Section extends UserFilterCondition public function buildCondition(PlFilter $uf) { // Sections are private. - if ($uf->getVisibilityLevel() != ProfileVisibility::VIS_PRIVATE) { - return self::CONF_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); } } // }}} @@ -895,36 +977,29 @@ class UFC_Email extends UserFilterCondition public function buildCondition(PlFilter $uf) { $foreign = array(); - $virtual = array(); - $aliases = array(); - $cond = array(); + $local = array(); + $cond = array(); if (count($this->emails) == 0) { - return PlFilterCondition::COND_TRUE; + return PlFilterCondition::COND_FALSE; } foreach ($this->emails as $entry) { if (User::isForeignEmailAddress($entry)) { $foreign[] = $entry; - } else if (User::isVirtualEmailAddress($entry)) { - $virtual[] = $entry; } else { - @list($user, $domain) = explode('@', $entry); - $aliases[] = $user; + list($local_part, ) = explode('@', $entry); + $local[] = $local_part; } } if (count($foreign) > 0) { $sub = $uf->addEmailRedirectFilter($foreign); - $cond[] = XDB::format('e' . $sub . '.email IS NOT NULL OR a.email IN {?}', $foreign); - } - if (count($virtual) > 0) { - $sub = $uf->addVirtualEmailFilter($virtual); - $cond[] = 'vr' . $sub . '.redirect IS NOT NULL'; + $cond[] = XDB::format('ra' . $sub . '.redirect IS NOT NULL OR ra' . $sub . '.redirect IN {?} OR a.email IN {?}', $foreign, $foreign); } - if (count($aliases) > 0) { - $sub = $uf->addAliasFilter($aliases); - $cond[] = 'al' . $sub . '.alias IS NOT NULL'; + if (count($local) > 0) { + $sub = $uf->addAliasFilter($local); + $cond[] = 'sa' . $sub . '.email IS NOT NULL'; } return '(' . implode(') OR (', $cond) . ')'; } @@ -933,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 */ @@ -967,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; @@ -988,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)'; } } } @@ -1003,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 @@ -1065,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); } @@ -1091,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); } @@ -1130,11 +1136,13 @@ class UFC_Corps extends UserFilterCondition const ORIGIN = 2; private $corps; + private $id; private $type; - public function __construct($corps, $type = self::CURRENT) + public function __construct($corps, $id = null, $type = self::CURRENT) { $this->corps = $corps; + $this->id = $id; $this->type = $type; } @@ -1146,8 +1154,14 @@ class UFC_Corps extends UserFilterCondition * pcec for profile_corps_enum - current */ $sub = $uf->addCorpsFilter($this->type); - $cond = $sub . '.abbreviation = ' . $corps; - $cond .= ' AND ' . $uf->getVisibilityCondition($sub . '.corps_pub'); + if (is_null($this->id)) { + $cond = $sub . '.abbreviation = ' . $this->corps; + } else { + $cond = $sub . '.id = ' . $this->id; + } + // XXX(x2006barrois): find a way to get rid of that hardcoded + // reference to 'pc'. + $cond .= ' AND ' . $uf->getVisibilityConditionForField('pc.corps_pub'); return $cond; } } @@ -1159,9 +1173,12 @@ class UFC_Corps extends UserFilterCondition class UFC_Corps_Rank extends UserFilterCondition { private $rank; - public function __construct($rank) + private $id; + + public function __construct($rank, $id = null) { $this->rank = $rank; + $this->id = $id; } public function buildCondition(PlFilter $uf) @@ -1171,10 +1188,14 @@ class UFC_Corps_Rank extends UserFilterCondition * pcr for profile_corps_rank */ $sub = $uf->addCorpsRankFilter(); - $cond = $sub . '.abbreviation = ' . $rank; + if (is_null($this->id)) { + $cond = $sub . '.abbreviation = ' . $this->rank; + } else { + $cond = $sub . '.id = ' . $this->id; + } // 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; } } @@ -1212,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; } } @@ -1242,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); } } @@ -1269,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::CONF_TRUE; - } - } else { - $conds[] = $uf->getVisibilityCondition($jsub . '.pub'); - } - 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) . ')'; } - return implode(' OR ', $conds); + if (count($conds) == 0) { + return self::COND_TRUE; + } + return $uf->getVisibilityConditionForField($jsub . '.pub') . ' AND ( ' . implode(' OR ', $conds) . ' )'; } } // }}} @@ -1310,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); @@ -1345,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; } @@ -1355,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) { @@ -1391,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) { @@ -1409,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'); } } // }}} @@ -1490,12 +1505,42 @@ class UFC_Mentor_Terms extends UserFilterCondition abstract class UFC_UserRelated extends UserFilterCondition { protected $user; - public function __construct(PlUser &$user) + public function __construct(PlUser $user) { $this->user =& $user; } } // }}} +// {{{ 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 */ @@ -1535,7 +1580,7 @@ class UFC_WatchRegistration extends UFC_UserRelated class UFC_WatchPromo extends UFC_UserRelated { private $grade; - public function __construct(PlUser &$user, $grade = UserFilter::GRADE_ING) + public function __construct(PlUser $user, $grade = UserFilter::GRADE_ING) { parent::__construct($user); $this->grade = $grade; @@ -1554,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 */ @@ -1588,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: ?>