public function insert(Default_Model_Label $label) { $data = array('text' => $label->getText(), 'color' => $label->getColor(), 'private' => $label->isPrivate ? 1 : 0); $db = $this->getWriteAdapter(); $db->insert($this->getTableName(), $data); return $db->lastInsertId(); }
public function createLabel($text, $color) { $acl = Zend_Registry::get('Default_DiContainer')->getAclService(); if (!$acl->isAllowed('label', 'create')) { return false; } $label = new Default_Model_Label(); $label->setText($text)->setColor($color); $this->_mapper->insert($label); return true; }
public function countIssuesByLabel(Default_Model_Label $label) { $db = $this->getReadAdapter(); $sql = $db->select()->from(array('ill' => 'issue_label_linker'), array('count' => 'COUNT(*)'))->join(array('i' => 'issue'), 'ill.issue_id = i.issue_id')->where('ill.label_id = ?', $label->getLabelId()); $sql = $this->_addAclJoins($sql, 'i', 'issue_id'); return $db->fetchOne($sql); }