_init('pacsoft/rate'); $this->_countryTable = $this->getTable('directory/country'); $this->_regionTable = $this->getTable('directory/country_region'); } public function _initSelect() { parent::_initSelect(); $this->_select->joinLeft( array('country_table' => $this->_countryTable), 'country_table.country_id = main_table.dest_country_id', array('dest_country' => 'iso2_code')) ->joinLeft( array('region_table' => $this->_regionTable), 'region_table.region_id = main_table.dest_region_id', array('dest_region' => 'code')); } public function setWebsiteFilter($websiteId) { return $this->addFieldToFilter('website_id', $websiteId); } }