Mage_Poll_Model_Mysql4_Poll Class Reference

Inheritance diagram for Mage_Poll_Model_Mysql4_Poll:

List of all members.

Public Member Functions
	getRandomId ($object)
	checkAnswerId ($poll, $answerId)
	getVotedPollIdsByIp ($ipAddress, $pollId=false)
	resetVotesCount ($object)
	loadStoreIds (Mage_Poll_Model_Poll $object)
	_afterSave (Mage_Core_Model_Abstract $object)
	lookupStoreIds ($id)
Protected Member Functions
	_construct ()
	_initUniqueFields ()

---

Detailed Description

Poll Mysql4 resource model

Author:

Magento Core Team <core@magentocommerce.com>

Definition at line 33 of file Poll.php.

---

Member Function Documentation

_afterSave

(

Mage_Core_Model_Abstract $

object

)

Perform actions after object save

Parameters:

Varien_Object

$object

stores

answers

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 159 of file Poll.php.

    {
        /** stores */
        $deleteWhere = $this->_getWriteAdapter()->quoteInto('poll_id = ?', $object->getId());
        $this->_getWriteAdapter()->delete($this->getTable('poll/poll_store'), $deleteWhere);

        foreach ($object->getStoreIds() as $storeId) {
            $pollStoreData = array(
            'poll_id'   => $object->getId(),
            'store_id'  => $storeId
            );
            $this->_getWriteAdapter()->insert($this->getTable('poll/poll_store'), $pollStoreData);
        }

        /** answers */
        foreach ($object->getAnswers() as $answer) {
            $answer->setPollId($object->getId());
            $answer->save();
        }
    }

_construct

(

)

[protected]

Resource initialization

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 35 of file Poll.php.

    {
        $this->_init('poll/poll', 'poll_id');
    }

_initUniqueFields

(

)

[protected]

Initialize unique fields

Returns:

Mage_Core_Model_Mysql4_Abstract

Reimplemented from Mage_Core_Model_Mysql4_Abstract.

Definition at line 45 of file Poll.php.

    {
        $this->_uniqueFields = array(array(
            'field' => 'poll_title',
            'title' => Mage::helper('poll')->__('Poll with the same question')
        ));
        return $this;
    }

checkAnswerId	(	$	poll,
		$	answerId
	)

Check answer id existing for poll

Parameters:

	Mage_Poll_Model_Poll	$poll
	int	$answerId

Returns:

bool

Definition at line 92 of file Poll.php.

    {
        $select = $this->_getReadAdapter()->select()
            ->from($this->getTable('poll_answer'), 'answer_id')
            ->where('poll_id=?', $poll->getId())
            ->where('answer_id=?', $answerId);
        return $this->_getReadAdapter()->fetchOne($select);
    }

getRandomId

(

$

object

)

Get random identifier not closed poll

Parameters:

Mage_Poll_Model_Poll

$object

Returns:

int

Definition at line 60 of file Poll.php.

    {
        $read = $this->_getReadAdapter();
        $select = $read->select();

        if ($object->getExcludeFilter()) {
            $select->where('main_table.poll_id NOT IN(?)', $object->getExcludeFilter());
        }

        $select->from(array('main_table'=>$this->getMainTable()), $this->getIdFieldName())
            ->where('closed = ?', 0)
            ->order(new Zend_Db_Expr('RAND()'))
            ->limit(1);

        if (($storeId = $object->getStoreFilter())) {
            $select->join(
                array('store' => $this->getTable('poll/poll_store')),
                $read->quoteInto('main_table.poll_id=store.poll_id AND store.store_id = ?', $storeId),
                array()
            );
        }

        return $read->fetchOne($select);
    }

getVotedPollIdsByIp	(	$	ipAddress,
		$	pollId = false
	)

Get voted poll ids by specified IP-address

Will return non-empty only if appropriate option in config is enabled If poll id is not empty, it will look only for records with specified value

Parameters:

	string	$ipAddress
	int	$pollId

Returns:

array

Definition at line 111 of file Poll.php.

    {
        // check if validation by ip is enabled
        if (!Mage::getModel('poll/poll')->isValidationByIp()) {
            return array();
        }

        // look for ids in database
        $select = $this->_getReadAdapter()->select()
            ->distinct()
            ->from($this->getTable('poll_vote'), 'poll_id')
            ->where('ip_address=?', ip2long($ipAddress));
        if (!empty($pollId)) {
            $select->where('poll_id=?', $pollId);
        }
        $result = $this->_getReadAdapter()->fetchCol($select);
        if (empty($result)) {
            $result = array();
        }
        return $result;
    }

loadStoreIds

(

Mage_Poll_Model_Poll $

object

)

Definition at line 149 of file Poll.php.

    {
        $pollId   = $object->getId();
        $storeIds = array();
        if ($pollId) {
            $storeIds = $this->lookupStoreIds($pollId);
        }
        $object->setStoreIds($storeIds);
    }

lookupStoreIds

(

$

id

)

Get store ids to which specified item is assigned

Parameters:

int

$id

Returns:

array

Definition at line 186 of file Poll.php.

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

resetVotesCount

(

$

object

)

Definition at line 133 of file Poll.php.

    {
        $read = $this->_getReadAdapter();
        $select = $read->select();
        $select->from($this->getTable('poll_answer'), new Zend_Db_Expr("SUM(votes_count)"))
            ->where("poll_id = ?", $object->getPollId());

        $count = $read->fetchOne($select);

        $write = $this->_getWriteAdapter();
        $condition = $write->quoteInto("{$this->getIdFieldName()} = ?", $object->getPollId());
        $write->update($this->getMainTable(), array('votes_count' => $count), $condition);
        return $object;
    }

---

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

• app/code/core/Mage/Poll/Model/Mysql4/Poll.php