| | |
| | | if (startTime == null) continue; |
| | | long durationDay = (now.getTime() - startTime.getTime()) / 1000; |
| | | String status = GREEN; // 默认状态为绿色 |
| | | if (redTime != null && durationDay >= redTime) { |
| | | if (redTime != null && redTime !=0 && durationDay >= redTime) { |
| | | status = RED; // 如果超过红色时间阈值,则状态为红色 |
| | | } else if (yellowTime != null && durationDay >= yellowTime) { |
| | | } else if (yellowTime != null && yellowTime !=0 && durationDay >= yellowTime) { |
| | | status = YELLOW; // 否则,如果超过黄色时间阈值,则状态为黄色 |
| | | } |
| | | List<String> processInsIds = map.get(status); |
| | |
| | | <if test="query.reserveOrPrevious != null and query.reserveOrPrevious == 'previous'"> |
| | | and TPP.process_ins_id is not null |
| | | </if> |
| | | <if test="query.projectCategory == null"> |
| | | and TPI.used_status = 2 |
| | | </if> |
| | | <if test="query.projectCategory == 3"> |
| | | and (TPI.project_status = 'working' or TPI.project_status = 'stop') |
| | | </if> |