GitLab

Java后端需要升级：

• 前端例程中心界面按例程统计例程数算法问题，统计的是所有例程匹配到的数目。
• 如果指定了系列编号，应只统计此系列编号下的例程数。
• 涉及的接口

https://api.fmdevelopers.com.cn/mfang/api/template/tag?current=1&size=30
   <select id="getAllTags" resultType="TemplateTag">
        SELECT
        mtt.id,
        mtt.`name`,
        mtt.type,
        COUNT( mtt.id ) AS use_count
        FROM
        mf_template_tag AS mtt
        JOIN mf_template_tag_rls mttr ON mtt.id = mttr.tag_id
        JOIN mf_template AS mt ON mttr.template_id = mt.id
        JOIN mf_template_code_info AS mtci ON mt.id = mtci.id
        WHERE
        1 = 1
        <if test="req.allowMerge != null and req.allowMerge != ''">
            AND mt.allow_merge = #{req.allowMerge}
        </if>
        <if test="req.serialNumber != null and req.serialNumber != ''">
            AND mt.serial_number = #{req.serialNumber}
        </if>
        <if test="req.driverGitBranch != null and req.driverGitBranch != ''">
            AND mtci.driver_git_branch = #{req.driverGitBranch}
        </if>
        GROUP BY
        mtt.`name`
        ORDER BY
        use_count DESC
    </select>