Mage_Cms_Model_Mysql4_Page Class Reference

Inheritance diagram for Mage_Cms_Model_Mysql4_Page:

List of all members.

Public Member Functions
	load (Mage_Core_Model_Abstract $object, $value, $field=null)
	getIsUniquePageToStores (Mage_Core_Model_Abstract $object)
	checkIdentifier ($identifier, $storeId)
	lookupStoreIds ($id)
Protected Member Functions
	_construct ()
	_beforeSave (Mage_Core_Model_Abstract $object)
	_afterSave (Mage_Core_Model_Abstract $object)
	_afterLoad (Mage_Core_Model_Abstract $object)
	_getLoadSelect ($field, $value, $object)
	isNumericPageIdentifier (Mage_Core_Model_Abstract $object)

---

Detailed Description

Definition at line 35 of file Page.php.

---

Member Function Documentation

_afterLoad

(

Mage_Core_Model_Abstract $

object

)

[protected]

Parameters:

Mage_Core_Model_Abstract

$object

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 112 of file Page.php.

    {
        $select = $this->_getReadAdapter()->select()
            ->from($this->getTable('cms/page_store'))
            ->where('page_id = ?', $object->getId());

        if ($data = $this->_getReadAdapter()->fetchAll($select)) {
            $storesArray = array();
            foreach ($data as $row) {
                $storesArray[] = $row['store_id'];
            }
            $object->setData('store_id', $storesArray);
        }

        return parent::_afterLoad($object);
    }

_afterSave

(

Mage_Core_Model_Abstract $

object

)

[protected]

Assign page to store views

Parameters:

Mage_Core_Model_Abstract

$object

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 85 of file Page.php.

    {
        $condition = $this->_getWriteAdapter()->quoteInto('page_id = ?', $object->getId());
        $this->_getWriteAdapter()->delete($this->getTable('cms/page_store'), $condition);

        foreach ((array)$object->getData('stores') as $store) {
            $storeArray = array();
            $storeArray['page_id'] = $object->getId();
            $storeArray['store_id'] = $store;
            $this->_getWriteAdapter()->insert($this->getTable('cms/page_store'), $storeArray);
        }

        return parent::_afterSave($object);
    }

_beforeSave

(

Mage_Core_Model_Abstract $

object

)

[protected]

Process page data before saving

Parameters:

Mage_Core_Model_Abstract

$object

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 50 of file Page.php.

    {
        $format = Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
        foreach (array('custom_theme_from', 'custom_theme_to') as $dataKey) {
            if ($date = $object->getData($dataKey)) {
                $object->setData($dataKey, Mage::app()->getLocale()->date($date, $format, null, false)
                    ->toString(Varien_Date::DATETIME_INTERNAL_FORMAT)
                );
            }
            else {
                $object->setData($dataKey, new Zend_Db_Expr('NULL'));
            }
        }

        if (!$this->getIsUniquePageToStores($object)) {
            Mage::throwException(Mage::helper('cms')->__('Page Identifier for specified store already exist.'));
        }

        if ($this->isNumericPageIdentifier($object)) {
            Mage::throwException(Mage::helper('cms')->__('Page Identifier cannot consist only of numbers.'));
        }

        if (! $object->getId()) {
            $object->setCreationTime(Mage::getSingleton('core/date')->gmtDate());
        }

        $object->setUpdateTime(Mage::getSingleton('core/date')->gmtDate());
        return $this;
    }

_construct

(

)

[protected]

Initialize resource model

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 40 of file Page.php.

    {
        $this->_init('cms/page', 'page_id');
    }

_getLoadSelect	(	$	field,
		$	value,
		$	object
	)			[protected]

Retrieve select object for load object data

Parameters:

	string	$field
	mixed	$value

Returns:

Zend_Db_Select

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 136 of file Page.php.

    {
        $select = parent::_getLoadSelect($field, $value, $object);

        if ($object->getStoreId()) {
            $select->join(
                        array('cps' => $this->getTable('cms/page_store')),
                        $this->getMainTable().'.page_id = `cps`.page_id'
                    )
                    ->where('is_active=1 AND `cps`.store_id in (0, ?) ', $object->getStoreId())
                    ->order('store_id DESC')
                    ->limit(1);
        }
        return $select;
    }

checkIdentifier	(	$	identifier,
		$	storeId
	)

Check if page identifier exist for specific store return page id if page exists

Parameters:

	string	$identifier
	int	$storeId

Returns:

int

Definition at line 196 of file Page.php.

    {
        $select = $this->_getReadAdapter()->select()->from(array('main_table'=>$this->getMainTable()), 'page_id')
            ->join(
                array('cps' => $this->getTable('cms/page_store')),
                'main_table.page_id = `cps`.page_id'
            )
            ->where('main_table.identifier=?', $identifier)
            ->where('main_table.is_active=1 AND `cps`.store_id in (0, ?) ', $storeId)
            ->order('store_id DESC');

        return $this->_getReadAdapter()->fetchOne($select);
    }

getIsUniquePageToStores

(

Mage_Core_Model_Abstract $

object

)

Check for unique of identifier of page to selected store(s).

Parameters:

Mage_Core_Model_Abstract

$object

Returns:

bool

Definition at line 158 of file Page.php.

    {
        $select = $this->_getWriteAdapter()->select()
                ->from($this->getMainTable())
                ->join(array('cps' => $this->getTable('cms/page_store')), $this->getMainTable().'.page_id = `cps`.page_id')
                ->where($this->getMainTable().'.identifier = ?', $object->getData('identifier'));
        if ($object->getId()) {
            $select->where($this->getMainTable().'.page_id <> ?',$object->getId());
        }
        $select->where('`cps`.store_id IN (?)', (array)$object->getData('stores'));

        if ($this->_getWriteAdapter()->fetchRow($select)) {
            return false;
        }

        return true;
    }

isNumericPageIdentifier

(

Mage_Core_Model_Abstract $

object

)

[protected]

Check whether page identifier is numeric

Parameters:

Mage_Core_Model_Abstract

$object

Returns:

bool

Date:

Wed Mar 26 18:12:28 EET 2008

Definition at line 183 of file Page.php.

    {
        return preg_match('/^[0-9]+$/', $object->getData('identifier'));
    }

load	(	Mage_Core_Model_Abstract $	object,
		$	value,
		$	field = null
	)

Load an object

Parameters:

	Mage_Core_Model_Abstract	$object
	mixed	$value
	string	$field field to load by (defaults to model id)

Returns:

Mage_Core_Model_Mysql4_Abstract

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 100 of file Page.php.

    {
        if (strcmp($value, (int)$value) !== 0) {
            $field = 'identifier';
        }
        return parent::load($object, $value, $field);
    }

lookupStoreIds

(

$

id

)

Get store ids to which specified item is assigned

Parameters:

int

$id

Returns:

array

Definition at line 216 of file Page.php.

    {
        return $this->_getReadAdapter()->fetchCol($this->_getReadAdapter()->select()
            ->from($this->getTable('cms/page_store'), 'store_id')
            ->where("{$this->getIdFieldName()} = ?", $id)
        );
    }

---

The documentation for this class was generated from the following file:

• app/code/core/Mage/Cms/Model/Mysql4/Page.php