/** * Add expiration date filter to select * * @param string $field * @param mixed $value * @param Mage_Persistent_Model_Session $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if (!$object->getLoadExpired()) { $select->where('updated_at >= ?', $object->getExpiredBefore()); } return $select; }
/** * Prepare wishlist load select query * * @param string $field * @param mixed $value * @param mixed $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($field == $this->_customerIdFieldName) { $select->order('wishlist_id ' . Zend_Db_Select::SQL_ASC)->limit(1); } return $select; }
/** * Retrieve the load select object * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if (!Mage::app()->isSingleStoreMode() && Mage::app()->getStore()->getId() > 0) { $select->where('store_id IN (?)', array(0, Mage::app()->getStore()->getId()))->order('store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $select->join(array('cps' => $this->getTable('store')), $this->getMainTable() . '.slideshow_id = `cps`.slideshow_id')->where('`cps`.store_id in (0, ?) ', $object->getStoreId())->order('store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data. * * @param string $field The field. * @param mixed $value The value. * @param Rootd_Link_Model_Node $object The link model. * * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if (!is_null($object->getStoreId())) { $select->where('store_id IN(?)', array(Mage_Core_Model_App::ADMIN_STORE_ID, $object->getStoreId()))->order('store_id ' . Varien_Db_Select::SQL_DESC)->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param DB1_AnyMarket_Model_Anymarketattributes $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('anymarket_anymarketattributes_store' => $this->getTable('db1_anymarket/anymarketattributes_store')), $this->getMainTable() . '.entity_id = anymarket_anymarketattributes_store.anymarketattributes_id', array())->where('anymarket_anymarketattributes_store.store_id IN (?)', $storeIds)->order('anymarket_anymarketattributes_store.store_id DESC')->limit(1); } return $select; }
/** * Add expiration date filter to select * * @param string $field * @param mixed $value * @param Mage_Persistent_Model_Session $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if (!$object->getLoadExpired()) { $tableName = $this->getMainTable(); $select->join(array('customer' => $this->getTable('customer/entity')), 'customer.entity_id = ' . $tableName . '.customer_id')->where($tableName . '.updated_at >= ?', $object->getExpiredBefore()); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Zoffio_DiscountTypes_Model_Title $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('discounttypes_title_store' => $this->getTable('zoffio_discounttypes/title_store')), $this->getMainTable() . '.entity_id = discounttypes_title_store.title_id', array())->where('discounttypes_title_store.store_id IN (?)', $storeIds)->order('discounttypes_title_store.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Esendex_Sms_Model_Trigger $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = [Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()]; $select->join(['sms_trigger_store' => $this->getTable('esendex_sms/trigger_store')], $this->getMainTable() . '.entity_id = sms_trigger_store.trigger_id', [])->where('sms_trigger_store.store_id IN (?)', $storeIds)->order('sms_trigger_store.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Iou_UltimatePopUp_Model_Popup_Comment $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('ultimatepopup_popup_comment_store' => $this->getTable('iou_ultimatepopup/popup_comment_store')), $this->getMainTable() . '.comment_id = ultimatepopup_popup_comment_store.comment_id', array())->where('ultimatepopup_popup_comment_store.store_id IN (?)', $storeIds)->order('ultimatepopup_popup_comment_store.store_id DESC')->limit(1); } return $select; }
protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $stores = array((int) $object->getStoreId(), Mage_Core_Model_App::ADMIN_STORE_ID); $select->join(array('tas' => $this->getTable('themeframework/page_store')), $this->getMainTable() . '.page_id = tas.page_id', array('store_id'))->where('status = ?', 1)->where('tas.store_id in (?) ', $stores)->order('store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { if ($field == 'default_state') { $select = $this->_getReadAdapter()->select()->from($this->getMainTable(), array('label'))->join(array('state_table' => $this->_stateTable), $this->getMainTable() . '.status = state_table.status', 'status')->where('state_table.state = ?', $value)->order('state_table.is_default DESC')->limit(1); } else { $select = parent::_getLoadSelect($field, $value, $object); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Devils_HomeWidget_Model_Image $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('dhis' => $this->getTable('devils_homewidget/image_store')), $this->getMainTable() . '.entity_id = dhis.entity_id', array())->where('is_active = ?', 1)->where('dhis.store_id IN (?)', $storeIds)->order('dhis.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('demac_multilocationinventory_stores' => $this->getTable('demac_multilocationinventory/stores')), $this->getMainTable() . '.id = demac_multilocationinventory_stores.location_id', array())->where('demac_multilocationinventory_stores.store_id IN (?)', $storeIds)->order('demac_multilocationinventory_stores.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Ibrams_CmsExtended_Model_Cmspage $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('cmsextended_cmspage_store' => $this->getTable('ibrams_cmsextended/cmspage_store')), $this->getMainTable() . '.entity_id = cmsextended_cmspage_store.cmspage_id', array())->where('cmsextended_cmspage_store.store_id IN (?)', $storeIds)->order('cmsextended_cmspage_store.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Rating_Model_Rating $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $adapter = $this->_getReadAdapter(); $table = $this->getMainTable(); $storeId = (int) Mage::app()->getStore()->getId(); $select = parent::_getLoadSelect($field, $value, $object); $codeExpr = $adapter->getIfNullSql('title.value', "{$table}.rating_code"); $select->joinLeft(array('title' => $this->getTable('rating/rating_title')), $adapter->quoteInto("{$table}.rating_id = title.rating_id AND title.store_id = ?", $storeId), array('rating_code' => $codeExpr)); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Url_Rewrite $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { /** @var $select Varien_Db_Select */ $select = parent::_getLoadSelect($field, $value, $object); if (!is_null($object->getStoreId())) { $select->where('store_id = ?', $object->getStoreId()); $select->order('is_system ' . Varien_Db_Select::SQL_DESC); $select->limit(1); } return $select; }
protected function _getLoadSelect($field, $value, $object) { $select = Mage_Core_Model_Resource_Db_Abstract::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = array(Mage_Core_Model_App::ADMIN_STORE_ID, (int) $object->getStoreId()); $select->join(array('cms_page_store' => $this->getTable('cms/page_store')), $this->getMainTable() . '.page_id = cms_page_store.page_id', array())->where('cms_page_store.store_id IN (?)', $storeIds)->order('cms_page_store.store_id DESC')->limit(1); } $ignoreActivationFlag = $object->getData('ignore_activation_flag'); if (!isset($ignoreActivationFlag) || !$ignoreActivationFlag) { $select->where('is_active = ?', 1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $adapter = $this->_getReadAdapter(); $locale = Mage::app()->getLocale()->getLocaleCode(); $systemLocale = Mage::app()->getDistroLocaleCode(); $regionField = $adapter->quoteIdentifier($this->getMainTable() . '.' . $this->getIdFieldName()); $condition = $adapter->quoteInto('lrn.locale = ?', $locale); $select->joinLeft(array('lrn' => $this->_regionNameTable), "{$regionField} = lrn.region_id AND {$condition}", array()); if ($locale != $systemLocale) { $nameExpr = $adapter->getCheckSql('lrn.region_id is null', 'srn.name', 'lrn.name'); $condition = $adapter->quoteInto('srn.locale = ?', $systemLocale); $select->joinLeft(array('srn' => $this->_regionNameTable), "{$regionField} = srn.region_id AND {$condition}", array('name' => $nameExpr)); } else { $select->columns(array('name'), 'lrn'); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param unknown_type $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->join($this->_reviewDetailTable, $this->getMainTable() . ".review_id = {$this->_reviewDetailTable}.review_id"); return $select; }
/** * Get load select * * @param string $field * @param value $value * @param Varien_Object $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $select->join(array('cps' => $this->getTable('checkout/agreement_store')), $this->getMainTable() . '.agreement_id = cps.agreement_id')->where('is_active=1')->where('cps.store_id IN (0, ?)', $object->getStoreId())->order('store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Log_Model_Customer $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($field == 'customer_id') { // load additional data by last login $table = $this->getMainTable(); $select->joinInner(array('lvt' => $this->_visitorTable), "lvt.visitor_id = {$table}.visitor_id", array('last_visit_at'))->joinInner(array('lvit' => $this->_visitorInfoTable), 'lvt.visitor_id = lvit.visitor_id', array('http_referer', 'remote_addr'))->joinInner(array('luit' => $this->_urlInfoTable), 'luit.url_id = lvt.last_url_id', array('url'))->order("{$table}.login_at DESC")->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * @return unknown */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->where('store_id = ?', (int) $object->getStoreId()); return $select; }
/** * Retrieve select object and join it to product entity table to get type ids * * @param string $field * @param mixed $value * @param Mage_CatalogInventory_Model_Stock_Item $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object)->join(array('p' => $this->getTable('catalog/product')), 'product_id=p.entity_id', array('type_id')); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->order('sort_order'); return $select; }
/** * Fetching data from event table at same time as from entity table * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $this->_joinEventData($select); return $select; }
/** * Retrieve select for load * * @param String $field * @param String $value * @param Mage_Core_Model_Abstract $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->where('store_id = ?', Mage_Core_Model_App::ADMIN_STORE_ID); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Cms_Model_Block $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $stores = array((int) $object->getStoreId(), Mage_Core_Model_App::ADMIN_STORE_ID); $select->join(array('cbs' => $this->getTable('cms/block_store')), $this->getMainTable() . '.block_id = cbs.block_id', array('store_id'))->where('is_active = ?', 1)->where('cbs.store_id in (?) ', $stores)->order('store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Core_Model_Abstract $object * @return Zend_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $this->_addValueToSelect($select, $object->getStoreId()); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param Mage_Eav_Model_Form_Element $object * @return Varien_Db_Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->join($this->getTable('eav/attribute'), $this->getTable('eav/attribute') . '.attribute_id = ' . $this->getMainTable() . '.attribute_id', array('attribute_code', 'entity_type_id')); return $select; }