예제 #1
0
파일: Issue.php 프로젝트: Roave/issues
 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);
 }