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})"; }