| | |
| | | for (BasicGlassType basicGlassType : twoGlassType) { |
| | | if (Objects.equals(basicGlassType.getBelong(), glassType.getTypeId())) { |
| | | Map<String,String> getMap = JSON.parseObject(JSON.toJSONString(basicGlassType), Map.class); |
| | | getMap.put("value",getMap.get("typeID")); |
| | | getMap.put("value",getMap.get("typeId")); |
| | | getMap.put("label",getMap.get("typeName")); |
| | | equalList.add(JSON.toJSONString(getMap) ); |
| | | } |
| | |
| | | <select id="getOrderList"> |
| | | select |
| | | *, |
| | | sum(fgi.quantity_available) as goodsQuantity |
| | | ifnull(sum(fgi.quantity_available),0) as goodsQuantity |
| | | from |
| | | `order` as o |
| | | left join mm.finished_goods_inventory as fgi |