Example #1
0
 /**
  * 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())));
 }
Example #5
0
 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);
     }
 }
Example #6
0
 public function __construct()
 {
     parent::__construct();
 }
Example #7
0
 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;
 }