本文整理汇总了PHP中Magento\Framework\Model\Resource\Db\Collection\AbstractCollection::_initSelect方法的典型用法代码示例。如果您正苦于以下问题：PHP AbstractCollection::_initSelect方法的具体用法？PHP AbstractCollection::_initSelect怎么用？PHP AbstractCollection::_initSelect使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Magento\Framework\Model\Resource\Db\Collection\AbstractCollection的用法示例。
在下文中一共展示了AbstractCollection::_initSelect方法的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _initSelect
/**
* Initialize select object
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$locale = $this->_localeResolver->getLocale();
$this->addBindParam(':region_locale', $locale);
$this->getSelect()->joinLeft(['rname' => $this->_regionNameTable], 'main_table.region_id = rname.region_id AND rname.locale = :region_locale', ['name']);
return $this;
}示例2: _initSelect
/**
* Initialize select, add country iso3 code and region name
*
* @return void
*/
public function _initSelect()
{
parent::_initSelect();
$this->_select->joinLeft(['country_table' => $this->_countryTable], 'country_table.country_id = main_table.dest_country_id', ['dest_country' => 'iso3_code'])->joinLeft(['region_table' => $this->_regionTable], 'region_table.region_id = main_table.dest_region_id', ['dest_region' => 'code']);
$this->addOrder('dest_country', self::SORT_ORDER_ASC);
$this->addOrder('dest_region', self::SORT_ORDER_ASC);
$this->addOrder('dest_zip', self::SORT_ORDER_ASC);
$this->addOrder('condition_value', self::SORT_ORDER_ASC);
}示例3: _initSelect
/**
* Initialize select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->addFieldToSelect(array('path', 'value'))->addFieldToFilter('scope', $this->_scope);
if (!is_null($this->_scopeId)) {
$this->addFieldToFilter('scope_id', $this->_scopeId);
}
return $this;
}示例4: _initSelect
/**
* Initialize select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->addFieldToSelect(['path', 'value'])->addFieldToFilter('scope', $this->_scope);
if ($this->_scopeId !== null) {
$this->addFieldToFilter('scope_id', $this->_scopeId);
}
return $this;
}示例5: _initSelect
/**
* Initialize select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->getSelect()->join(['detail' => $this->getReviewDetailTable()], 'main_table.review_id = detail.review_id', ['detail_id', 'title', 'detail', 'nickname', 'customer_id']);
return $this;
}示例6: _initSelect
/**
* Initialize select object
*
* @return $this
*/
protected function _initSelect()
{
return parent::_initSelect()->getSelect()->join(array('cp_table' => $this->getTable('catalog_product_entity')), 'main_table.product_id = cp_table.entity_id', array('type_id'));
}示例7: _initSelect
/**
* Init collection select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->_joinTables();
return $this;
}示例8: _initSelect
/**
* Join reports info table
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->getSelect()->join(array('report' => $this->getTable('paypal_settlement_report')), 'report.report_id = main_table.report_id', array('report.account_id', 'report.report_date'));
return $this;
}示例9: _initSelect
/**
* Init collection select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->_joinAttributeSet();
return $this;
}示例10: _initSelect
/**
* Init select
*
* @return \Magento\ImportExport\Model\Resource\History\Collection
*/
protected function _initSelect()
{
parent::_initSelect();
$this->getSelect()->joinLeft(['link_table' => $this->_linkTable], 'link_table.user_id = main_table.user_id', ['username'])->where('execution_time != ?', History::IMPORT_VALIDATION);
return $this;
}示例11: _initSelect
/**
* Initialize select object
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$select = $this->getSelect();
$select->join(array('default_label' => $this->getTable('eav_form_fieldset_label')), 'main_table.fieldset_id = default_label.fieldset_id AND default_label.store_id = 0', array());
if ($this->getStoreId() == 0) {
$select->columns('label', 'default_label');
} else {
$labelExpr = $select->getAdapter()->getIfNullSql('store_label.label', 'default_label.label');
$joinCondition = $this->getConnection()->quoteInto('main_table.fieldset_id = store_label.fieldset_id AND store_label.store_id = ?', (int) $this->getStoreId());
$select->joinLeft(array('store_label' => $this->getTable('eav_form_fieldset_label')), $joinCondition, array('label' => $labelExpr));
}
return $this;
}示例12: _initSelect
/**
* Initialize db query
*
* @return void
*/
protected function _initSelect()
{
parent::_initSelect();
$this->addOrder('severity', self::SORT_ORDER_ASC)->addOrder('created_at');
}示例13: _initSelect
/**
* Initialize select
*
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->getSelect()->where("user_id > 0");
return $this;
}示例14: _initSelect
/**
* @return $this
*/
protected function _initSelect()
{
parent::_initSelect();
$this->addOrder('notification_id', self::SORT_ORDER_DESC)->addFieldToFilter('is_read', array('neq' => 1))->addFieldToFilter('is_remove', array('neq' => 1))->addFieldToFilter('severity', \Magento\Framework\Notification\MessageInterface::SEVERITY_CRITICAL)->setPageSize(1);
return $this;
}