package store

import "context"

// OpenSidebarCounts telt open merge requests en open issues die de kijker
// mag zien. Zonder triage blijven andermans vertrouwelijke issues weg,
// dezelfde regel als ListIssues. Eén query, geen N+1.
func (s *Store) OpenSidebarCounts(ctx context.Context, repoID, viewerID int64, triage bool) (mrs, issues int, err error) {
	triageFlag := 0
	if triage {
		triageFlag = 1
	}
	err = s.db.QueryRowContext(ctx, `
SELECT
  (SELECT COUNT(*) FROM merge_requests WHERE repo_id = ? AND status = 'open'),
  (SELECT COUNT(*) FROM issues WHERE repo_id = ? AND status = 'open'
    AND (? = 1 OR confidential = 0 OR author_id = ?))`,
		repoID, repoID, triageFlag, viewerID,
	).Scan(&mrs, &issues)
	return mrs, issues, err
}
