@PostMapping("login")
    public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {
        log.info("[執(zhí)行登錄接口]");
        String username = data.get("username");
        String email = data.get("email");
        String phone = data.get("phone");
        String password = data.get("password");
        List resultList = null;
        Map<String, String> map = new HashMap<>();
        if(username != null && "".equals(username) == false){
            map.put("username", username);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }
        else if(email != null && "".equals(email) == false){
            map.put("email", email);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }
        else if(phone != null && "".equals(phone) == false){
            map.put("phone", phone);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }else{
            return error(30000, "賬號或密碼不能為空");
        }
        if (resultList == null || password == null) {
            return error(30000, "賬號或密碼不能為空");
        }
        //判斷是否有這個用戶
        if (resultList.size()<=0){
            return error(30000,"用戶不存在");
        }
        User byUsername = (User) resultList.get(0);
        Map<String, String> groupMap = new HashMap<>();
        groupMap.put("name",byUsername.getUserGroup());
        List groupList = userGroupService.select(groupMap, new HashMap<>()).getResultList();
        if (groupList.size()<1){
            return error(30000,"用戶組不存在");
        }
        UserGroup userGroup = (UserGroup) groupList.get(0);
        //查詢用戶審核狀態(tài)
        if (!StringUtils.isEmpty(userGroup.getSourceTable())){
            String sql = "select examine_state from "+ userGroup.getSourceTable() +" WHERE user_id = " + byUsername.getUserId();
            String res = String.valueOf(service.runCountSql(sql).getSingleResult());
            if (res==null){
                return error(30000,"用戶不存在");
            }
            if (!res.equals("已通過")){
                return error(30000,"該用戶審核未通過");
            }
        }
        //查詢用戶狀態(tài)
        if (byUsername.getState()!=1){
            return error(30000,"用戶非可用狀態(tài)，不能登錄");
        }
        String md5password = service.encryption(password);
        if (byUsername.getPassword().equals(md5password)) {
            // 存儲Token到數(shù)據(jù)庫
            AccessToken accessToken = new AccessToken();
            accessToken.setToken(UUID.randomUUID().toString().replaceAll("-", ""));
            accessToken.setUser_id(byUsername.getUserId());
            tokenService.save(accessToken);
            // 返回用戶信息
            JSONObject user = JSONObject.parseObject(JSONObject.toJSONString(byUsername));
            user.put("token", accessToken.getToken());
            JSONObject ret = new JSONObject();
            ret.put("obj",user);
            return success(ret);
        } else {
            return error(30000, "賬號或密碼不正確");
        }
}

/**
     * 注冊
     * @param user
     * @return
     */
    @PostMapping("register")
    public Map<String, Object> signUp(@RequestBody User user) {
        // 查詢用戶
        Map<String, String> query = new HashMap<>();
        query.put("username",user.getUsername());
        List list = service.select(query, new HashMap<>()).getResultList();
        if (list.size()>0){
            return error(30000, "用戶已存在");
        }
        user.setUserId(null);
        user.setPassword(service.encryption(user.getPassword()));
        service.save(user);
        return success(1);
}
/**
     * 用戶ID：[0,8388607]用戶獲取其他與用戶相關(guān)的數(shù)據(jù)
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "user_id")
    private Integer userId;
    /**
     * 賬戶狀態(tài)：[0,10](1可用|2異常|3已凍結(jié)|4已注銷)
     */
    @Basic
    @Column(name = "state")
    private Integer state;
    /**
     * 所在用戶組：[0,32767]決定用戶身份和權(quán)限
     */
    @Basic
    @Column(name = "user_group")
    private String userGroup;
    /**
     * 上次登錄時間：
     */
    @Basic
    @Column(name = "login_time")
    private Timestamp loginTime;
    /**
     * 手機號碼：[0,11]用戶的手機號碼，用于找回密碼時或登錄時
     */
    @Basic
    @Column(name = "phone")
    private String phone;
    /**
     * 手機認證：[0,1](0未認證|1審核中|2已認證)
     */
    @Basic
    @Column(name = "phone_state")
    private Integer phoneState;
    /**
     * 用戶名：[0,16]用戶登錄時所用的賬戶名稱
     */
    @Basic
    @Column(name = "username")
    private String username;
    /**
     * 昵稱：[0,16]
     */
    @Basic
    @Column(name = "nickname")
    private String nickname;
    /**
     * 密碼：[0,32]用戶登錄所需的密碼，由6-16位數(shù)字或英文組成
     */
    @Basic
    @Column(name = "password")
    private String password;
    /**
     * 郵箱：[0,64]用戶的郵箱，用于找回密碼時或登錄時
     */
    @Basic
    @Column(name = "email")
    private String email;
    /**
     * 郵箱認證：[0,1](0未認證|1審核中|2已認證)
     */
    @Basic
    @Column(name = "email_state")
    private Integer emailState;
    /**
     * 頭像地址：[0,255]
     */
    @Basic
    @Column(name = "avatar")
    private String avatar;
    /**
     * 創(chuàng)建時間：
     */
    @Basic
    @Column(name = "create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Timestamp createTime;
    @Basic
    @Transient
    private String code;
}

@RequestMapping(value = "/del")
    @Transactional
    public Map<String, Object> del(HttpServletRequest request) {
        service.delete(service.readQuery(request), service.readConfig(request));
        return success(1);
}
    @Transactional
    public void delete(Map<String,String> query,Map<String,String> config){
        StringBuffer sql = new StringBuffer("DELETE FROM ").append("`").append(table).append("`").append(" ");
        sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.GROUP_BY))));
        log.info("[{}] - 刪除操作：{}",table,sql);
        Query query1 = runCountSql(sql.toString());
        query1.executeUpdate();
    }

@RequestMapping(value = {"/sum_group", "/sum"})
    public Map<String, Object> sum(HttpServletRequest request) {
        Query count = service.sum(service.readQuery(request), service.readConfig(request));
        return success(count.getResultList());
}