| | |
|---|
| | | //填充各个区县数据 |
|---|
| | | for (CheckScore checkScore : dashboard) { |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | map.put("score", checkScore.getScore().setScale(2,RoundingMode.HALF_UP)); |
|---|
| | | map.put("score", checkScore.getScore().setScale(1,RoundingMode.HALF_UP)); |
|---|
| | | resultMap.put(checkScore.getDeptName(), map); |
|---|
| | | } |
|---|
| | | return resultMap; |
|---|
| | |
|---|
| | | left join ( |
|---|
| | | WITH cte AS ( |
|---|
| | | SELECT *,row_number() OVER(PARTITION BY serial_number ORDER BY create_time DESC) rn FROM t_work_order |
|---|
| | | WHERE deleted = 0 |
|---|
| | | WHERE deleted = 0 and status != 'AUDITING_SUCCESS' and status != 'AUDITING_FAIL' |
|---|
| | | ) SELECT * FROM cte WHERE rn=1 |
|---|
| | | ) w on m.serial_number = w.serial_number and w.deleted = 0 |
|---|
| | | left join t_yw_unit u on p.unit_id = u.id and u.deleted = 0 |
|---|
