Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java =================================================================== diff -u -r38955 -r38956 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java (.../RealTimeBulletinBoardWorkloadHelper.java) (revision 38955) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java (.../RealTimeBulletinBoardWorkloadHelper.java) (revision 38956) @@ -1584,7 +1584,7 @@ String invocieUrgentAmountSql = "select ti.tousseName,sum(ti.urgentAmount) tiUrgentAmount" //不回收的物品 需扣除装配数量 - + ", sum(case when t.amount>0 and ti.urgentAmount > 0 and ti.amount -t.amount>ti.urgentAmount " + + ", sum(case when t.amount>0 and ti.urgentAmount > 0 and ti.amount -t.amount>=ti.urgentAmount " + "then ti.urgentAmount " + "when t.amount>0 and ti.urgentAmount > 0 and ti.amount -t.amount0 then 0 "