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(); }