/** * Init collection of customers * @return AW_Referafriend_Model_Mysql4_Customer_Collection */ protected function _initSelect() { parent::_initSelect(); $select = $this->getSelect(); $select->join(array('inv' => $this->getTable('referafriend/invite')), "e.entity_id = inv.referrer_id AND inv.referral_id <> '0'")->group('inv.referrer_id'); return $this; }
public function addFieldToFilter($attribute, $condition = null) { if ($attribute == 'name') { $this->getSelect()->where($this->_getConditionSql('t.name', $condition)); return $this; } else { return parent::addFieldToFilter($attribute, $condition); } }
public function load($printQuery = false, $logQuery = false) { parent::load($printQuery, $logQuery); $this->_loadTags($printQuery, $logQuery); return $this; }
/** * Limit customers collection * * @param Mage_Customer_Model_Entity_Customer_Collection $collection */ public function limitCustomers($collection) { $collection->addAttributeToFilter('website_id', array('website_id' => array('in' => $this->_role->getRelevantWebsiteIds()))); }
public function addFieldToFilter($attribute, $condition = null) { if ($attribute == 'name') { $where = $this->_getConditionSql('t.name', $condition); $this->getSelect()->where($where, null, Varien_Db_Select::TYPE_CONDITION); return $this; } else { return parent::addFieldToFilter($attribute, $condition); } }
public function __construct() { parent::__construct(); }
public function setOrder($attribute, $dir = 'desc') { switch ($attribute) { case 'name': case 'status': $this->getSelect()->order($attribute . ' ' . $dir); break; default: parent::setOrder($attribute, $dir); } return $this; }