/**
* Prepare filters
*
* @return Mage_Paypal_Model_Resource_Payment_Transaction_Collection
*/
protected function _beforeLoad()
{
parent::_beforeLoad();
if ($this->isLoaded()) {
return $this;
}
// filters
if ($this->_createdBefore) {
$this->getSelect()->where('main_table.created_at < ?', $this->_createdBefore);
}
return $this;
}
/**
* Before collection load
*
* @return Mage_Catalog_Model_Resource_Category_Flat_Collection
*/
protected function _beforeLoad()
{
Mage::dispatchEvent($this->_eventPrefix . '_load_before', array($this->_eventObject => $this));
return parent::_beforeLoad();
}
/**
* Load collection data
*
* @return Mage_Core_Model_Resource_Store_Group_Collection
*/
public function _beforeLoad()
{
if (!$this->getLoadDefault()) {
$this->setWithoutDefaultFilter();
}
$this->addOrder('main_table.name', self::SORT_ORDER_ASC);
return parent::_beforeLoad();
}
/**
* Add joins to select
*
* @return Mage_Eav_Model_Resource_Form_Attribute_Collection
*/
protected function _beforeLoad()
{
$select = $this->getSelect();
$connection = $this->getConnection();
$entityType = $this->getEntityType();
$this->setItemObjectClass($entityType->getAttributeModel());
$eaColumns = array();
$caColumns = array();
$saColumns = array();
$eaDescribe = $connection->describeTable($this->getTable('eav/attribute'));
unset($eaDescribe['attribute_id']);
foreach (array_keys($eaDescribe) as $columnName) {
$eaColumns[$columnName] = $columnName;
}
$select->join(array('ea' => $this->getTable('eav/attribute')), 'main_table.attribute_id = ea.attribute_id', $eaColumns);
// join additional attribute data table
$additionalTable = $entityType->getAdditionalAttributeTable();
if ($additionalTable) {
$caDescribe = $connection->describeTable($this->getTable($additionalTable));
unset($caDescribe['attribute_id']);
foreach (array_keys($caDescribe) as $columnName) {
$caColumns[$columnName] = $columnName;
}
$select->join(array('ca' => $this->getTable($additionalTable)), 'main_table.attribute_id = ca.attribute_id', $caColumns);
}
// add scope values
if ($this->_getEavWebsiteTable()) {
$saDescribe = $connection->describeTable($this->_getEavWebsiteTable());
unset($saDescribe['attribute_id']);
foreach (array_keys($saDescribe) as $columnName) {
if ($columnName == 'website_id') {
$saColumns['scope_website_id'] = $columnName;
} else {
if (isset($eaColumns[$columnName])) {
$code = sprintf('scope_%s', $columnName);
$expression = $connection->getCheckSql('sa.%s IS NULL', 'ea.%s', 'sa.%s');
$saColumns[$code] = new Zend_Db_Expr(sprintf($expression, $columnName, $columnName, $columnName));
} elseif (isset($caColumns[$columnName])) {
$code = sprintf('scope_%s', $columnName);
$expression = $connection->getCheckSql('sa.%s IS NULL', 'ca.%s', 'sa.%s');
$saColumns[$code] = new Zend_Db_Expr(sprintf($expression, $columnName, $columnName, $columnName));
}
}
}
$store = $this->getStore();
$joinWebsiteExpression = $connection->quoteInto('sa.attribute_id = main_table.attribute_id AND sa.website_id = ?', (int) $store->getWebsiteId());
$select->joinLeft(array('sa' => $this->_getEavWebsiteTable()), $joinWebsiteExpression, $saColumns);
}
// add store attribute label
if ($store->isAdmin()) {
$select->columns(array('store_label' => 'ea.frontend_label'));
} else {
$storeLabelExpr = $connection->getCheckSql('al.value IS NULL', 'ea.frontend_label', 'al.value');
$joinExpression = $connection->quoteInto('al.attribute_id = main_table.attribute_id AND al.store_id = ?', (int) $store->getId());
$select->joinLeft(array('al' => $this->getTable('eav/attribute_label')), $joinExpression, array('store_label' => $storeLabelExpr));
}
// add entity type filter
$select->where('ea.entity_type_id = ?', (int) $entityType->getId());
return parent::_beforeLoad();
}
