项目资源库

/* 项目总数getTotalProjectCount */

 select COUNT(distinct p.id)
    from projects p
             join repositories r on p.id = r.project_id
             join version_releases v on r.id = v.repository_id;

/* 项目公开数getPublicProjectCount */
select COUNT(distinct p.id)
from projects p
join repositories r on p.id = r.project_id
join version_releases v on r.id = v.repository_id
where p.is_public = 1;

/* 项目发布版本数getTotalReleaseCount */
select COUNT(*)
from version_releases;

/* 项目转换成果数 getTotalConversionCount */
select COUNT(*)
from project_resource_library
where is_transferred_to_achievement = 1