public function buildCondition(PlFilter $f)
{
$c = $f->addCasteFilter();
$cu = $f->addUserFilter();
return XDB::format("{$c}.rights = {?} OR ({$c}.rights = {?} AND {$cu}.uid IN {?})", (string) Rights::everybody(), (string) Rights::restricted(), $this->uids);
}
protected function getSortTokens(PlFilter $uf)
{
$uf->requireAccounts();
return 'a.is_admin';
}
public function buildCondition(PlFilter $f)
{
$sub = $f->addGroupFilter();
return XDB::format($sub . '.gid IN {?}', $this->gids);
}
public function buildCondition(PlFilter $uf)
{
$sub = $uf->addRoomFilter();
if ($this->exact) {
return XDB::format("{$sub}.rid IN {?}", $this->rooms);
} else {
if (count($this->rooms) == 0) {
return false;
} else {
if (count($this->rooms) == 1) {
return $sub . '.rid ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $this->rooms[0]);
} else {
foreach ($this->rooms as $room) {
$temp[] = $sub . '.rid ' . XDB::formatWildcards(XDB::WILDCARD_CONTAINS, $room);
}
return '(' . implode(') ' . 'OR' . ' (', $temp) . ')';
}
}
}
}
protected function getSortTokens(PlFilter $f)
{
$sub = $f->addUserFilter();
return "COUNT({$sub}.uid)";
}
protected function getSortTokens(PlFilter $uf)
{
$sub = $uf->addStudiesFilter();
return $sub . '.promo';
}
protected function &getFilterResults(PlFilter $pf, PlLimit $limit)
{
$profiles = $pf->getProfiles($limit, Profile::FETCH_MINIFICHES);
return $profiles;
}
public function buildCondition(PlFilter $f)
{
$c = $f->addCasteFilter();
$cu = $f->addUserFilter();
return XDB::format("{$c}.rights = {?} AND {$cu}.uid IN {?}", (string) $this->rights, $this->uids);
}
public function buildCondition(PlFilter $f)
{
$i_s = $f->addSizeFilter();
return XDB::format($i_s . '.iid IS NULL');
}
public function buildCondition(PlFilter $f)
{
$g = $f->addGroupFilter();
return $g . '.priv = ' . (int) $this->priv;
}
public function buildCondition(PlFilter $f)
{
$p = $f->addParticipantsFilter();
return XDB::format("{$p}.participant IN {?}", $this->uids);
}
public function buildCondition(PlFilter $uf)
{
$uf->requireProfiles();
$ids = $this->ids;
$sub = $uf->addPartnerSharingFilter($this->partner_id);
return XDB::format("{$sub}.exposed_uid IN {?}", $ids);
}
