/**
* 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;
}
