public function getTrashMessagesNumber() { $model = new Default_Model_Messages(); $select = $model->getMapper()->getDbTable()->select()->from(array('u' => 'messages'), array('id' => 'COUNT(u.id)'))->where("" . "(u.idUserTo = '" . Zend_Registry::get('user')->getId() . "' AND u.trashedTo = 1 AND NOT u.deletedTo) " . "OR " . "(u.idUserFrom = '" . Zend_Registry::get('user')->getId() . "' AND u.trashedFrom = 1 AND NOT u.deletedFrom)")->order('u.created DESC')->setIntegrityCheck(false); $model->fetchRow($select); return $model->getId(); }
public function deleteFrom(Default_Model_Messages $value) { $id = $value->getId(); $data = array('deletedFrom' => '1'); $this->getDbTable()->update($data, array('id = ?' => $id)); return $id; }