| | |
| | | WHERE EXISTS(SELECT 1 FROM issue_status iss WHERE iss.issue_status_type != 'CLOSE' AND i.issue_status_id = |
| | | iss.id) |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | COUNT(i.id) FROM issue i where |
| | | exists(select 1 from issue_status iss where iss.id = i.issue_status_id and iss.issue_status_type != 'CLOSE') |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | </choose> |
| | | ) AND EXISTS(SELECT 1 FROM issue_status iss WHERE iss.id = i.issue_status_id and iss.issue_status_type != 'CLOSE') |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | count(i.id) as todayCount from issue i where |
| | | i.register_id = #{loginUserId} |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | WHERE |
| | | EXISTS(select 1 from issue_status iss where iss.id = i.issue_status_id and iss.issue_status_type != 'CLOSE') |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | where iss.issue_status_type = 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | where iss.issue_status_type = 'CLOSE' |
| | | and i.modify_date between #{searchStartDate} and #{searchEndDate} |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | where 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | left outer join issue_status iss on iss.id = i.issue_status_id |
| | | WHERE 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND p.id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | and id.register_date |
| | | BETWEEN (CURDATE()) AND (CURDATE() + INTERVAL 1 DAY)) |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | WHERE 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join project p on p.id = i.project_id |
| | | WHERE 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND p.id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | where iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | (case when ir.change_issue_status_count > 3 then true else false end) as changeIssueStatusType, |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey, |
| | | i.issue_number as issueNumber, |
| | | p.project_key as projectKey |
| | | p.project_key as projectKey, |
| | | p.name as projectName |
| | | from issue i |
| | | inner join issue_risk ir on ir.issue_id = i.id |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | inner join project p on p.id = i.project_id |
| | | where iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND p.id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | where iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | WHERE 1=1 |
| | | AND i.register_id = #{loginUserId} |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | AND EXISTS (SELECT 1 FROM issue_status iss WHERE iss.id = i.issue_status_id AND iss.issue_status_type != 'CLOSE') |
| | | </if> |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | </if> |
| | | WHERE 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | </if> |
| | | WHERE 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | | where 1=1 |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | parameterType="kr.wisestone.owl.web.condition.WidgetCondition"> |
| | | select |
| | | d.department_name as departmentName, |
| | | p.name as projectName, |
| | | (select count(*) from issue i |
| | | inner join issue_department id on id.issue_id = i.id |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | |
| | | inner join project p on p.id = pr.project_id |
| | | WHERE |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | p.id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | 'CLOSE') AND |
| | | i.register_id = #{loginUserId} |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | 'CLOSE') |
| | | AND i.register_id = #{loginUserId} |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | </choose> |
| | | and iss.issue_status_type = 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | </otherwise> |
| | | </choose> |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | WHERE w.id = #{workspaceId} |
| | | AND iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | replace(i.complete_date, "-", ".") AS completeDate, |
| | | i.issue_number AS issueNumber, |
| | | p.project_key AS projectKey, |
| | | p.name AS projectName, |
| | | iss.name AS issueStatusName, |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey |
| | | FROM issue i |
| | |
| | | AND s.id = #{severityId} |
| | | AND iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |
| | |
| | | AND s.id = #{severityId} |
| | | AND iss.issue_status_type != 'CLOSE' |
| | | <choose> |
| | | <when test="meAndDownProjectIds.size != 0"> |
| | | <when test="meAndDownProjectIds != null and meAndDownProjectIds.size != 0"> |
| | | AND i.project_id IN |
| | | <foreach collection="meAndDownProjectIds" item="item" index="index" separator="," open="(" close=")"> |
| | | #{item} |