龚焕茏
2024-07-22 84172752f938bf71c8f502b60558692cf5734ae7
feat:用户导入,获取为空
1个文件已修改
36 ■■■■ 已修改文件
src/main/java/com/ycl/jxkg/service/impl/UserServiceImpl.java 36 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/ycl/jxkg/service/impl/UserServiceImpl.java
@@ -227,25 +227,23 @@
    public String importExcel(MultipartFile file) {
        List<User> userList = new ArrayList<>();
        List<String> errorList = new ArrayList<>();
        EasyExcel.read(file.getInputStream(), UserExcelVo.class, new PageReadListener<UserExcelVo>(dataList -> {
            dataList.forEach(item -> {
                User user = new User();
                user.setUserName(item.getUserName());
                user.setPassword(authenticationService.pwdEncode("!Password123456789"));
                user.setRealName(item.getRealName());
                user.setSex(item.getSex());
                user.setPhone(item.getPhone());
                try {
                    user.setBirthDay(new SimpleDateFormat("yyyy-MM-dd").parse(item.getBirthDay()));
                } catch (ParseException e) {
                    errorList.add(item.getRealName());
                }
                user.setAge(item.getAge());
                user.setRole(item.getRole());
                user.setStatus(UserStatusEnum.Enable.getCode());
                userList.add(user);
            });
        }));
        EasyExcel.read(file.getInputStream(), UserExcelVo.class, new PageReadListener<UserExcelVo>(dataList -> dataList.forEach(item -> {
            User user = new User();
            user.setUserName(item.getUserName());
            user.setPassword(authenticationService.pwdEncode("!Password123456789"));
            user.setRealName(item.getRealName());
            user.setSex(item.getSex());
            user.setPhone(item.getPhone());
            try {
                user.setBirthDay(new SimpleDateFormat("yyyy-MM-dd").parse(item.getBirthDay()));
            } catch (ParseException e) {
                errorList.add(item.getRealName());
            }
            user.setAge(item.getAge());
            user.setRole(item.getRole());
            user.setStatus(UserStatusEnum.Enable.getCode());
            userList.add(user);
        }))).sheet().doRead();
        if (!errorList.isEmpty()) {
            return "以下数据日期格式错误:\\n" + String.join(",", errorList);
        } else {