From a78d0583053acaa4edfd6ed6abde379786708408 Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Sat, 10 Jul 2021 14:18:55 +0800
Subject: [PATCH] fix

---
 zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java |   95 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 95 insertions(+), 0 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 0d35302..9856f9c 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
@@ -784,6 +784,18 @@
                     }
                 }
 
+                if ("否".equals(shoppingGoods.getIsOnce())) {
+                    shoppingGoods.setIsOnce("0");
+                } else {
+                    shoppingGoods.setIsOnce("1");
+                }
+
+                if ("否".equals(shoppingGoods.getIsPresent())) {
+                    shoppingGoods.setIsPresent("0");
+                } else {
+                    shoppingGoods.setIsPresent("1");
+                }
+
                 Long oldId = shoppingGoods.getId();
                 shoppingGoods.setId(null);
                 shoppingGoodsDao.insert(shoppingGoods);
@@ -1591,4 +1603,87 @@
 
     }
 
+
+    @DS("slave")
+    public Map<String, List<Long>> roleOld() {
+        List<Map<String, Object>> maps = jdbcTemplate.queryForList("select a.id, a.name, a.role_id, b.role_name from users a inner join sys_role b on find_in_set(b.role_id, a.role_id)");
+
+        List<Long> jkgw = new ArrayList<>();
+        List<Long> mls = new ArrayList<>();
+        for (Map<String, Object> map : maps) {
+            String roleName = map.get("role_name").toString();
+
+            if ("健康顾问".equals(roleName)) {
+                jkgw.add((Long) map.get("id"));
+            } else {
+                mls.add((Long) map.get("id"));
+            }
+        }
+
+        Map<String, List<Long>> result = new HashMap<>();
+        result.put("jkgw", jkgw);
+        result.put("mls", mls);
+        return result;
+    }
+
+    public void roleNew(Map<String, List<Long>> role) {
+        List<Long> jkgw = role.get("jkgw");
+        List<Long> mls = role.get("mls");
+        Map<String, Integer> sysUsersMap = getRedisIds("sys_users");
+
+        for (Long aLong : jkgw) {
+            Integer id = sysUsersMap.get(aLong.toString());
+            SysUsers sysUsers = new SysUsers();
+            sysUsers.setSuId(id.longValue());
+            sysUsers.setRoleIds("56");
+            sysUsersDao.updateByModel(sysUsers);
+        }
+
+        for (Long ml : mls) {
+            Integer id = sysUsersMap.get(ml.toString());
+            SysUsers sysUsers = new SysUsers();
+            sysUsers.setSuId(id.longValue());
+            sysUsers.setRoleIds("55");
+            sysUsersDao.updateByModel(sysUsers);
+        }
+
+    }
+
+    @DS("slave")
+    public Map<String, String> roleOld2() {
+        List<Map<String, Object>> maps = jdbcTemplate.queryForList("select * from sys_shopstaff_info where find_in_set('美疗师', POST_TYPE_NAME) or find_in_set('健康顾问', POST_TYPE_NAME)");
+        Map<String, String> result = new HashMap<>();
+        for (Map<String, Object> map : maps) {
+
+            result.put(map.get("id").toString(), map.get("POST_TYPE_NAME").toString());
+        }
+
+        return result;
+    }
+
+    public void roleNew2(Map<String, String> map) {
+
+        Map<String, Integer> shopStaff = getRedisIds("shop_staff");
+        for (Map.Entry<String, String> entry : map.entrySet()) {
+            String id = entry.getKey();
+            Integer newId = shopStaff.get(id);
+
+            SysUsers sysUsers = new SysUsers();
+            sysUsers.setSuId(newId.longValue());
+            if (entry.getValue().contains("健康顾问,")) {
+                sysUsers.setRoleIds("56");
+            }
+
+            if (entry.getValue().contains("美疗师,")) {
+                sysUsers.setRoleIds("55");
+            }
+
+            if (entry.getValue().contains("健康顾问,美疗师,")) {
+                sysUsers.setRoleIds("55,56");
+            }
+
+            sysUsersDao.updateByModel(sysUsers);
+        }
+    }
+
 }

--
Gitblit v1.9.1