protected function _prepareCollection()
{
// Update statistic table values
Mage::getResourceModel('M2ePro/Listing')->updateStatisticColumns();
Mage::getResourceModel('M2ePro/Buy_Listing')->updateStatisticColumns();
// Get collection of listings
$collection = Mage::helper('M2ePro/Component_Buy')->getCollection('Listing');
// Set global filters
// ---------------------------------------
$filterSellingFormatTemplate = $this->getRequest()->getParam('filter_buy_selling_format_template');
$filterSynchronizationTemplate = $this->getRequest()->getParam('filter_buy_synchronization_template');
if ($filterSellingFormatTemplate != 0) {
$collection->addFieldToFilter('second_table.template_selling_format_id', (int) $filterSellingFormatTemplate);
}
if ($filterSynchronizationTemplate != 0) {
$collection->addFieldToFilter('second_table.template_synchronization_id', (int) $filterSynchronizationTemplate);
}
// ---------------------------------------
// join accounts
// ---------------------------------------
$collection->getSelect()->join(array('a' => Mage::getResourceModel('M2ePro/Account')->getMainTable()), '(`a`.`id` = `main_table`.`account_id`)', array('account_title' => 'title'));
// ---------------------------------------
$this->setCollection($collection);
return parent::_prepareCollection();
}
protected function _prepareCollection()
{
// Update statistic table values
Mage::getResourceModel('M2ePro/Listing')->updateStatisticColumns();
Mage::getResourceModel('M2ePro/Ebay_Listing')->updateStatisticColumns();
// Get collection of listings
$collection = Mage::helper('M2ePro/Component_Ebay')->getCollection('Listing');
$collection->getSelect()->join(array('a' => Mage::getResourceModel('M2ePro/Account')->getMainTable()), '(`a`.`id` = `main_table`.`account_id`)', array('account_title' => 'title'));
$collection->getSelect()->join(array('m' => Mage::getResourceModel('M2ePro/Marketplace')->getMainTable()), '(`m`.`id` = `main_table`.`marketplace_id`)', array('marketplace_title' => 'title'));
$this->setCollection($collection);
return parent::_prepareCollection();
}
