/** * Prepare wishlist load select query * * @param string $field * @param mixed $value * @param \Magento\Framework\Model\AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($field == $this->_customerIdFieldName) { $select->order('wishlist_id ' . \Magento\Framework\DB\Select::SQL_ASC)->limit(1); } return $select; }
/** * Add expiration date filter to select * * @param string $field * @param mixed $value * @param \Magento\Persistent\Model\Session $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if (!$object->getLoadExpired()) { $tableName = $this->getMainTable(); $select->join(['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 \Magento\Review\Model\Rating $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $connection = $this->getConnection(); $table = $this->getMainTable(); $storeId = (int) $this->_storeManager->getStore(\Magento\Store\Model\Store::ADMIN_CODE)->getId(); $select = parent::_getLoadSelect($field, $value, $object); $codeExpr = $connection->getIfNullSql('title.value', "{$table}.rating_code"); $select->joinLeft(['title' => $this->getTable('rating_title')], $connection->quoteInto("{$table}.rating_id = title.rating_id AND title.store_id = ?", $storeId), ['rating_code' => $codeExpr]); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param \Magento\UrlRewrite\Model\UrlRewrite $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { /** @var $select \Magento\Framework\DB\Select */ $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId() !== null) { $select->where('store_id IN(?)', [\Magento\Store\Model\Store::DEFAULT_STORE_ID, $object->getStoreId()]); $select->order('store_id ' . \Magento\Framework\DB\Select::SQL_DESC); $select->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param \Magento\Framework\Model\AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $connection = $this->getConnection(); $locale = $this->_localeResolver->getLocale(); $systemLocale = \Magento\Framework\AppInterface::DISTRO_LOCALE_CODE; $regionField = $connection->quoteIdentifier($this->getMainTable() . '.' . $this->getIdFieldName()); $condition = $connection->quoteInto('lrn.locale = ?', $locale); $select->joinLeft(['lrn' => $this->_regionNameTable], "{$regionField} = lrn.region_id AND {$condition}", []); if ($locale != $systemLocale) { $nameExpr = $connection->getCheckSql('lrn.region_id is null', 'srn.name', 'lrn.name'); $condition = $connection->quoteInto('srn.locale = ?', $systemLocale); $select->joinLeft(['srn' => $this->_regionNameTable], "{$regionField} = srn.region_id AND {$condition}", ['name' => $nameExpr]); } else { $select->columns(['name'], 'lrn'); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param \Magento\Cms\Model\Page $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $storeIds = [\Magento\Store\Model\Store::DEFAULT_STORE_ID, (int) $object->getStoreId()]; $select->join(['cms_page_store' => $this->getTable('cms_page_store')], $this->getMainTable() . '.page_id = cms_page_store.page_id', [])->where('is_active = ?', 1)->where('cms_page_store.store_id IN (?)', $storeIds)->order('cms_page_store.store_id DESC')->limit(1); } return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param \Magento\Framework\Model\AbstractModel $object * @return $this */ 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 FormFieldset $object * @return Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $labelExpr = $select->getConnection()->getIfNullSql('store_label.label', 'default_label.label'); $select->joinLeft(['default_label' => $this->getTable('eav_form_fieldset_label')], $this->getMainTable() . '.fieldset_id = default_label.fieldset_id AND default_label.store_id=0', [])->joinLeft(['store_label' => $this->getTable('eav_form_fieldset_label')], $this->getMainTable() . '.fieldset_id = store_label.fieldset_id AND default_label.store_id=' . (int) $object->getStoreId(), ['label' => $labelExpr]); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param \Magento\Cms\Model\Block $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $stores = [(int) $object->getStoreId(), \Magento\Store\Model\Store::DEFAULT_STORE_ID]; $select->join(['cbs' => $this->getTable('cms_block_store')], $this->getMainTable() . '.block_id = cbs.block_id', ['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 AbstractModel $object * @return \Magento\Framework\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 * @param \Magento\Framework\Model\AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->order('sort_order'); return $select; }
/** * Retrieve select for load * * @param String $field * @param String $value * @param \Magento\Framework\Model\AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->where('store_id = ?', \Magento\Store\Model\Store::DEFAULT_STORE_ID); return $select; }
/** * Get load select * * @param string $field * @param mixed $value * @param \Magento\Framework\Model\AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); if ($object->getStoreId()) { $select->join(['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 \Magento\Eav\Model\Form\Element $object * @return \Magento\Framework\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', ['attribute_code', 'entity_type_id']); return $select; }
/** * Retrieve select object for load object data * * @param string $field * @param mixed $value * @param AbstractModel $object * @return \Magento\Framework\DB\Select */ protected function _getLoadSelect($field, $value, $object) { $select = parent::_getLoadSelect($field, $value, $object); $select->where('store_id = ?', (int) $object->getStoreId()); return $select; }