function _getWhere(Am_Query $db)
{
$a = $db->getAlias();
switch ($this->type) {
case 'any':
$c = '';
break;
case 'paid':
$c = 'AND payout_detail_id IS NOT NULL';
break;
case 'not-paid':
$c = 'AND payout_detail_id IS NULL';
break;
}
return "EXISTS\n (SELECT * FROM ?_aff_commission\n WHERE aff_id={$a}.user_id\n {$c})";
}
function addDefaultSort(Am_Query $q)
{
$a = $q->getAlias();
$type = $this->createRecord()->getAccessType();
$q->leftJoin('?_resource_access_sort', "ras", "{$a}.{$this->_key} = ras.resource_id AND ras.resource_type='{$type}'");
$q->addField('ras.sort_order', '_sort_order');
$q->setOrder('_sort_order');
}
private function getAlias(Am_Query $q)
{
return is_null($this->tableAlias) ? $q->getAlias() : $this->tableAlias;
}
public function _getWhere(Am_Query $q)
{
$a = $q->getAlias();
$ids = array_filter(array_map('intval', $this->ids));
if (!$ids) {
return;
}
$ids = implode(',', $ids);
return "NOT EXISTS (SELECT * FROM ?_user_user_group uug WHERE {$a}.user_id = uug.user_id AND uug.user_group_id IN ({$ids}))";
}
public function _getWhere(Am_Query $q)
{
if (!$this->ids) {
return null;
}
$a = $q->getAlias();
$ids = join(',', $this->ids);
return "{$a}.user_id IN ({$ids})";
}
