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);
}
