/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @param \Ashsmith\Blog\Model\Post $object
* @return \Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$select->where('is_active = ?', 1)->limit(1);
}
return $select;
}
/**
* Retrieve load select with filter by url_key and activity
*
* @param string $url_key
* @param int $isActive
* @return \Magento\Framework\DB\Select
*/
protected function _getLoadByMethodIDSelect($method_id, $isActive = null)
{
$select = parent::_getLoadSelect('method_id', $method_id, null);
if (!is_null($isActive)) {
$select->where('active = ?', !empty($isActive) ? 1 : 0);
}
return $select;
}
/**
* 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 load select with filter by country_id
*
* @param string $url_key
* @param null|\Magento\Framework\DB\Select $select
* @return \Magento\Framework\DB\Select
*/
protected function _getLoadByCountryIDSelect($country_id, $select = null)
{
if (empty($select)) {
$select = parent::_getLoadSelect('country_id', $country_id, null);
} else {
$select->where('country_id = ?', $country_id);
}
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;
}
/**
* Default select items not yet exported
*
* @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->where('is_exported = ?', 0)->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);
return $select;
}
/**
* Retrieve load select with filter by country code
*
* @param string $code
* @return \Magento\Framework\DB\Select
*/
protected function _getLoadByCodeSelect($code)
{
$select = parent::_getLoadSelect('code', $code, null);
return $select;
}
/**
* Retrieve select object for load object data
*
* @param string $field
* @param mixed $value
* @param \Msd\Statistics\Model\Statistics\ $object
* @return \Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
$select->where('active = ?', 1);
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;
}
/**
* 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 \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 \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 object for load object data
*
* @param string $field
* @param mixed $value
* @param \Magento\Cms\Model\Block|AbstractModel $object
* @return Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$entityMetadata = $this->metadataPool->getMetadata(BlockInterface::class);
$linkField = $entityMetadata->getLinkField();
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$stores = [(int) $object->getStoreId(), Store::DEFAULT_STORE_ID];
$select->join(['cbs' => $this->getTable('cms_block_store')], $this->getMainTable() . '.' . $linkField . ' = cbs.' . $linkField, ['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->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 int $value
* @param \Magento\CatalogInventory\Model\Stock\Item $object
* @return \Magento\Framework\DB\Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object)->join(['p' => $this->getTable('catalog_product_entity')], 'product_id=p.entity_id', ['type_id']);
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 \Swissup\Testimonials\Model\Data $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(['tts' => $this->getTable('swissup_testimonials_store')], $this->getMainTable() . '.testimonial_id = tts.testimonial_id', ['store_id'])->where('tts.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 \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 \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 \Sample\News\Model\Author $object
* @return \Zend_Db_Select
*/
protected function _getLoadSelect($field, $value, $object)
{
$select = parent::_getLoadSelect($field, $value, $object);
if ($object->getStoreId()) {
$storeIds = [Store::DEFAULT_STORE_ID, (int) $object->getStoreId()];
$select->join(['sample_news_author_store' => $this->getTable('sample_news_author_store')], $this->getMainTable() . '.author_id = sample_news_author_store.author_id', [])->where('is_active = ?', 1)->where('sample_news_author_store.store_id IN (?)', $storeIds)->order('sample_news_author_store.store_id DESC')->limit(1);
}
return $select;
}
/**
* Retrieve load select with filter by merchant transaction idcode
*
* @param string $code
* @return \Magento\Framework\DB\Select
*/
protected function _getLoadByMerchantTransactionId($mt_id)
{
$select = parent::_getLoadSelect('merchant_transaction_id', $mt_id, null);
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 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;
}
