Example #1
0
 /**
  * Custom load SQL
  *
  * @param string $field - field to match $value to
  * @param string|int $value - $value to load record based on
  * @param Mage_Core_Model_Abstract $object - object we're trying to load to
  */
 protected function _getLoadSelect($field, $value, $object)
 {
     $select = parent::_getLoadSelect($field, $value, $object);
     if ($object->getPostType() === 'post') {
         if ($sql = $this->getPermalinkSqlColumn()) {
             $select->columns(array('permalink' => $sql));
         }
     }
     return $select;
 }
Example #2
0
 /**
  * Alter default load select so only pages (and not posts) are returned
  *
  * @param string $field
  * @param string $value
  * @param Mage_Core_Model_Abstract $object
  * @return Varien_Db_Select
  */
 protected function _getLoadSelect($field, $value, $object)
 {
     $select = parent::_getLoadSelect($field, $value, $object)->where("`post_type`=?", 'page');
     return $select;
 }