protected function getSortTokens(PlFilter $uf)
{
$uf->requireAccounts();
return 'a.is_admin';
}
public function buildCondition(PlFilter $uf)
{
$uf->requireAccounts();
if ($this->active) {
$date = '$UID IS NOT NULL AND a.state = \'active\'';
} else {
$date = '$UID IS NOT NULL AND a.state != \'pending\'';
}
if (!is_null($this->comparison)) {
$date .= ' AND a.registration_date != \'0000-00-00 00:00:00\' AND a.registration_date ' . $this->comparison . ' ' . XDB::format('{?}', $this->date->format('Y-m-d'));
}
return $date;
}
