/**
* Resett votes count
*
* @param Mage_Poll_Model_Poll $object
* @return Mage_Poll_Model_Poll
*/
public function resetVotesCount($object)
{
$adapter = $this->_getWriteAdapter();
$select = $adapter->select()->from($this->getTable('poll_answer'), new Zend_Db_Expr("SUM(votes_count)"))->where('poll_id = ?', $object->getPollId());
$adapter->update($this->getMainTable(), array('votes_count' => new Zend_Db_Expr("({$select})")), array('poll_id = ' . $adapter->quote($object->getPollId())));
return $object;
}
/**
* Resett votes count
*
* @param Mage_Poll_Model_Poll $object
* @return Mage_Poll_Model_Poll
*/
public function resetVotesCount($object)
{
$read = $this->_getReadAdapter();
$select = $read->select();
$select->from($this->getTable('poll_answer'), new Zend_Db_Expr("SUM(votes_count)"))->where('poll_id = :poll_id');
$count = $read->fetchOne($select, array(':poll_id' => $object->getPollId()));
$write = $this->_getWriteAdapter();
$condition = $write->quoteInto("{$this->getIdFieldName()} = ?", $object->getPollId());
$write->update($this->getMainTable(), array('votes_count' => $count), $condition);
return $object;
}
