备件管理bug 修改

dhz

2022-06-22 4d198cd78684d17c849b0bd7d323894009ca17f5

 src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java

@@ -106,7 +106,7 @@
            params.put("state", params.get("state"));
        }

        sql.append(" group by a.ID order by a.GMT_CREATE desc");
        sql.append(" group by a.id,a.ORDER_NAME,a.STATE,a.CREATE_NAME,a.GMT_CREATE,a.ORDER_CODE order by a.GMT_CREATE desc");
        return sql.toString();
    }

@@ -329,7 +329,7 @@

        sql.setLength(0);
        sql.append(" select inventory_order_id,sum(inventory_num) inventory_num,sum(book_num) book_num,sum(loss_num) loss_num,sum(overage_num) overage_num  " +
                " from spare_part_detail where inventory_order_id=:orderId  ");
                " from spare_part_detail where inventory_order_id=:orderId  group by inventory_order_id ");
        Map sumInfo = baseDao.queryForMap(sql.toString(), param);
        detail.put("inventory_num", ConvertUtil.obj2StrBlank(sumInfo.get("inventory_num")));
        detail.put("book_num", ConvertUtil.obj2StrBlank(sumInfo.get("book_num")));