From 498809ad376216244fbca21fa7d8540aabbc531f Mon Sep 17 00:00:00 2001 From: wzy <wzy19931122ai@163.com> Date: Thu, 25 Mar 2021 09:34:14 +0800 Subject: [PATCH] modify --- zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java | 81 +++++++++++++++++++++++++++++++--------- 1 files changed, 63 insertions(+), 18 deletions(-) diff --git a/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java b/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java index 42c91d3..7536626 100644 --- a/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java +++ b/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java @@ -775,17 +775,26 @@ Map<String, Integer> goodCZK = getRedisIds("shopping_goods_czk"); Map<String, Integer> goodZHK = getRedisIds("shopping_goods_zhk"); Map<String, Integer> shopIds = getRedisIds("shopId"); - Map<String, Integer> sysUsers = getRedisIds("sys_user"); + Map<String, Integer> sysUsers = getRedisIds("sys_users"); Map<String, Integer> vipInfos = getRedisIds("vip_info"); for (SysOrder order : orders) { List<Map<String, Object>> itemsMap = jdbcTemplate.queryForList("select * from sys_order_item where ORDER_ID=" + order.getId()); Integer shopId = shopIds.get(order.getShopId().toString()); order.setShopId(shopId.longValue()); + Integer statffId = sysUsers.get(order.getStaffId().toString()); - order.setStaffId(statffId.longValue()); + if (statffId != null) { + order.setStaffId(statffId.longValue()); + } else { + order.setStaffId(-order.getStaffId()); + } Integer vipId = vipInfos.get(order.getVipId().toString()); - order.setVipId(vipId.longValue()); + if (vipId != null) { + order.setVipId(vipId.longValue()); + } else { + order.setVipId(-order.getVipId()); + } order.setCompanyId(companyId); @@ -819,24 +828,46 @@ case "家居产品" : Map<String, Object> skuMap = jdbcTemplate.queryForMap("select * from shopping_goods_assemble where id=" + item.getAssembleId()); Long skuId = (Long) skuMap.get("assemble_sku_id"); - item.setGoodsId(goodsSku.get(skuId.toString()).longValue()); + Integer skuGoodsId = goodsSku.get(skuId.toString()); + if (skuGoodsId != null) { + item.setGoodsId(skuGoodsId.longValue()); + } else { + item.setGoodsId(-item.getAssembleId()); + } break; case "项目" : Map<String, Object> projMap = jdbcTemplate.queryForMap("select * from shopping_goods_assemble where id=" + item.getAssembleId()); Long projId = (Long) projMap.get("assemble_proj_id"); - item.setGoodsId(goodProj.get(projId.toString()).longValue()); + Integer projGoodsId = goodProj.get(projId.toString()); + if (projGoodsId != null) { + item.setGoodsId(projGoodsId.longValue()); + } else { + item.setGoodsId(-item.getAssembleId()); + } break; case "套餐" : Integer tcId = goodTc.get(item.getGoodsId().toString()); - item.setGoodsId(tcId.longValue()); + if (tcId != null) { + item.setGoodsId(tcId.longValue()); + } else { + item.setGoodsId(-item.getGoodsId()); + } break; case "充值卡" : Integer czkId = goodCZK.get(item.getGoodsId().toString()); - item.setGoodsId(czkId.longValue()); + if (czkId != null) { + item.setGoodsId(czkId.longValue()); + } else { + item.setGoodsId(-item.getGoodsId()); + } break; case "综合卡" : Integer zhkId = goodZHK.get(item.getGoodsId().toString()); - item.setGoodsId(zhkId.longValue()); + if (zhkId != null) { + item.setGoodsId(zhkId.longValue()); + } else { + item.setGoodsId(-item.getGoodsId()); + } break; default: } @@ -874,14 +905,26 @@ achieve.setAchieveType("美疗师业绩"); } Integer beaultId = sysUsers.get(achieve.getBeaultId().toString()); - achieve.setBeaultId(beaultId.longValue()); + if (beaultId != null) { + achieve.setBeaultId(beaultId.longValue()); + } else { + achieve.setBeaultId(-achieve.getBeaultId()); + } Integer saleId = sysUsers.get(achieve.getSaleId().toString()); - achieve.setSaleId(saleId.longValue()); + if (saleId != null) { + achieve.setSaleId(saleId.longValue()); + } else { + achieve.setSaleId(-achieve.getSaleId()); + } Integer achiVipId = vipInfos.get(achieve.getVipId().toString()); - achieve.setVipId(achiVipId.longValue()); - achieve.setGoodsCash(Double.parseDouble(achieve.getT2())); + if (achiVipId != null) { + achieve.setVipId(achiVipId.longValue()); + } else { + achieve.setVipId(-achieve.getVipId()); + } + achieve.setGoodsCash(Double.parseDouble(achieve.getT1())); achieve.setCompanyId(companyId); achieve.setShoppingGoodsId(shoppingGoodsIds.get(achieve.getShoppingGoodsId())); @@ -938,13 +981,15 @@ sysOrderFlowDao.insert(flow); } - for (AchieveNew achieveNew : sysOrder.getAchieveNews()) { - achieveNew.setOrderId(oldOrderId); - Long item = itemIds.get(achieveNew.getOrderItemId()); - achieveNew.setOrderItemId(item); - } + if (CollUtil.isNotEmpty(sysOrder.getAchieveNews())) { + for (AchieveNew achieveNew : sysOrder.getAchieveNews()) { + achieveNew.setOrderId(oldOrderId); + Long item = itemIds.get(achieveNew.getOrderItemId()); + achieveNew.setOrderItemId(item); + } - achieveNewDao.batchInsert(sysOrder.getAchieveNews()); + achieveNewDao.batchInsert(sysOrder.getAchieveNews()); + } } redisClient.saveMapValue("order", orderIds); -- Gitblit v1.9.1