/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @return Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getOrderId()) {
$select->join(array('order_table' => $this->getTable($this->_tableName . '_order')), $this->getMainTable() . '.log_id = order_table.log_id')->where('order_table.order_id IN (?) ', $object->getOrderId())->order('order_id DESC');
}
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() . '.post_id = `cps`.post_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
* @param mixed $value
* @return Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->where('is_active=1 and (store_id=? OR store_id=0)', $object->getStoreId());
}
return $select;
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->join(array('cbs' => $this->getTable('ves_megamenu/megamenu_store')), $this->getMainTable() . '.megamenu_id = cbs.megamenu_id')->where('cbs.store_id in (0, ?) ', $object->getStoreId())->order('cbs.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)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->join(array('nns' => $this->getTable('hm_faq/faq_store')), $this->getMainTable() . '.item_id = `nns`.faq_id')->where('is_active=1 AND `nns`.store_id in (0, ?) ', $object->getStoreId())->order('creation_time DESC')->limit(1);
}
return $select;
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->join(array('cps' => $this->getTable('splash/splash_store')), $this->getMainTable() . '.splash_id = `cps`.splash_id')->where('active=1 AND `cps`.store_id in (' . Mage_Core_Model_App::ADMIN_STORE_ID . ', ?) ', $object->getStoreId())->order('store_id DESC')->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;
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
// Obey Account Sharing scope
if (Mage::getModel('customer/config_share')->isWebsiteScope()) {
$select->join(array('customer' => $this->getTable('customer/entity')), $this->getMainTable() . '.customer_id = customer.entity_id AND customer.website_id = ' . Mage::app()->getWebsite()->getId());
}
return $select;
}
/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @param TM_Testimonials_Model_Data $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('store' => $this->getTable('tm_testimonials/store')), $this->getMainTable() . '.testimonial_id = store.testimonial_id', array())->where('status = ?', 1)->where('store.store_id IN (?)', $storeIds)->order('store.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)
{
$select = parent::_getLoadSelect($field, $value, $object);
if (!is_null($object->getStoreId())) {
$select->where('store_id=0 or store_id=?', $object->getStoreId());
$select->order('store_id', 'desc');
}
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)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($data = $object->getStoreId()) {
$select->join(array('store' => $this->getTable('igallery/banner_store')), $this->getMainTable() . '.banner_id = `store`.banner_id')->where('`store`.store_id in (0, ?) ', $data);
}
$select->order('name DESC')->limit(1);
return $select;
}
/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @param Mage_Cms_Model_Page $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('amlanding_page_store' => $this->getTable('amlanding/page_store')), $this->getMainTable() . '.page_id = cms_page_store.page_id', array())->where('is_active = ?', 1)->where('amlanding_page_store.store_id IN (?)', $storeIds)->order('amlanding_page_store.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())->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
* @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 IN(?)', array(0, $object->getStoreId()));
$select->order('store_id desc');
$select->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)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($data = $object->getPageId()) {
$select->join(array('page' => $this->getTable('lookbookslider/page')), $this->getMainTable() . '.lookbookslider_id = `page`.lookbookslider_id')->where('`page`.page_id in (?) ', $data);
}
if ($data = $object->getCategoryId()) {
$select->join(array('category' => $this->getTable('lookbookslider/category')), $this->getMainTable() . '.lookbookslider_id = `category`.lookbookslider_id')->where('`category`.category_id in (?) ', $data);
}
//$select->order('name 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)
{
$select = parent::_getLoadSelect($field, $value, $object);
$tables = $select->getPart(Zend_Db_Select::FROM);
$table = $tables[$this->getMainTable()];
if ($table) {
$localeCode = $object->getResource()->getLocaleCode();
if ($localeCode == null) {
$localeCode = $this->_localeCode;
}
if ($localeCode !== self::CANONICAL_LOCALE_CODE) {
$this->_joinTranslatedColumns($select, $localeCode);
} else {
$this->_joinCanonicalColumns($select);
}
}
return $select;
}
/**
* Retrieve select object and join it to product entity table to get type ids
*
* @param string $field
* @param mixed $value
* @param object $object
* @return Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
return parent::_getLoadSelect($field, $value, $object)->joinInner(array('p' => $this->getTable('catalog/product')), 'product_id=p.entity_id', 'type_id');
}
/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @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() . ".post_id = `cps`.post_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
* @param mixed $value
* @param Mage_Eav_Model_Form_Fieldset $object
* @return Varien_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$select->joinLeft(array('default_label' => $this->getTable('eav/form_fieldset_label')), $this->getMainTable() . 'fieldset_id=default_label.fieldset_id AND default_label.store_id=0', array())->joinLeft(array('store_label' => $this->getTable('eav/form_fieldset_label')), $this->getMainTable() . 'fieldset_id=store_label.fieldset_id AND default_label.store_id=' . (int) $object->getStoreId(), array('label' => new Zend_Db_Expr('IFNULL(store_label.label, default_label.label)')));
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)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->join(array('wcs' => $this->getTable('auguria_sliders/stores')), $this->getMainTable() . '.slider_id = wcs.slider_id')->where('wcs.store_id in (0, ?) ', $object->getStoreId())->order('store_id DESC')->limit(1);
}
return $select;
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$select->where('store_id = ?', (int) $object->getStoreId());
return $select;
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$storeId = $object->getStoreId();
if ($storeId) {
$select->join(array('dsqs' => $this->getTable('rw_search_query_store')), $this->getMainTable() . '.query_id = `dsqs`.query_id')->where('status=1 AND `dsqs`.store_id IN (' . Mage_Core_Model_App::ADMIN_STORE_ID . ', ?) ', $storeId)->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
* @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;
}
/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @return Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->join(array('cbs' => $this->getTable('cms/block_store')), $this->getMainTable() . '.block_id = cbs.block_id')->where('is_active=1 AND cbs.store_id in (0, ?) ', $object->getStoreId())->order('store_id DESC')->limit(1);
}
return $select;
}
/**
* Retrieve select object for load object data.
* Join page information if page assigned.
* Join secondary table with meta data for root nodes.
*
* @param string $field
* @param mixed $value
* @param Enterprise_Cms_Model_Hierarchy_Node $object
* @return Varien_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$select->joinLeft(array('page_table' => $this->getTable('cms/page')), $this->getMainTable() . '.page_id = page_table.page_id', array('page_title' => 'title', 'page_identifier' => 'identifier', 'page_is_active' => 'is_active'))->joinLeft(array('metadata_table' => $this->_metadataTable), $this->getMainTable() . '.' . $this->getIdFieldName() . ' = metadata_table.node_id', array('meta_first_last', 'meta_next_previous', 'meta_chapter', 'meta_section', 'meta_cs_enabled', 'pager_visibility', 'pager_frame', 'pager_jump', 'menu_visibility', 'menu_layout', 'menu_brief', 'menu_excluded', 'menu_levels_down', 'menu_ordered', 'menu_list_type'));
$this->_applyParamFilters($select);
return $select;
}
protected function _getLoadSelect($field, $value, $object)
{
return parent::_getLoadSelect($field, $value, $object);
}
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$select->where('store_id', 0);
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)
{
$select = parent::_getLoadSelect($field, $value, $object);
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;
}
