whyczh
2021-06-03 81bdad137f96c25487424f442b6c49ebb4745eee
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
package com.whyc.util;
 
import cn.afterturn.easypoi.excel.entity.result.ExcelVerifyHandlerResult;
import cn.afterturn.easypoi.handler.inter.IExcelVerifyHandler;
import com.whyc.dto.Response;
import com.whyc.mapper.UserMapper;
import com.whyc.pojo.User;
import com.whyc.service.UserBridgeService;
import org.springframework.stereotype.Component;
 
import javax.annotation.Resource;
import java.util.*;
 
/**
 * @author 张辉
 * @since 2021/4/27
 */
@Component
public class UserExcelVerify implements IExcelVerifyHandler<User> {
 
    @Resource
    private UserMapper userMapper;
 
    @Resource
    private UserBridgeService userBridgeService;
    @Override
    public ExcelVerifyHandlerResult verifyHandler(User user) {
        //设置默认验证为true
        ExcelVerifyHandlerResult excelVerifyHandlerResult = new ExcelVerifyHandlerResult(true);
        Map<String,String> map = new HashMap<>();
        //验证数据库是否有此用户
        User userFound = userBridgeService.findPasswordAndSlatByUserName(user.getName());
        if (userFound.getId() != 0) {
            excelVerifyHandlerResult.setSuccess(false);
            map.put("用户校验错误信息","对不起,此用户已存在,请不要重复提交");
        }
        user.setCreateTime(new Date());
        user.setState(0);
        Map<String, String> encryptMap = DigestsUtil.encryptPassword(user.getPassword());
        user.setPassword(encryptMap.get("password"));
        user.setSalt(encryptMap.get("salt"));
        //给返回对象添加错误信息
        excelVerifyHandlerResult.setMsg(map.toString());
        return excelVerifyHandlerResult;
 
    }
}