2021-07-04项目实训小程序选座后端第一周(3)
这两天进行简单的基本功能尝试,自己和简单实现了一下必须的基本方法实现,因为和前端没有具体讨论接口定义,只是先提前约定使用数据库字段格式,自行尝试实现一些基本的方法。
下面展示一些 用户基本接口实现
。
//获得所有的用户列表
@GetMapping("/getalluser")
public List<UserData> getalluser(){
return userManageService.getalluser();
}
//根据openid获取用户信息
@PostMapping("/queryuserbyopenid")
public UserData queryuserbyopenid(@RequestParam("user_openid")String user_openid){
return userManageService.queryuserbyopenid(user_openid);
}
//查看所有黑名单列表
@GetMapping("/getblacklist")
public List<Blacklist> getblacklist(){
return userManageService.getblacklist();
}
//根据openid获取黑名单用户信息
@PostMapping("/queryblacklistbyopenid")
public Blacklist queryblacklistbyopenid(@RequestParam("user_openid")String user_openid){
return userManageService.queryblacklistbyopenid(user_openid);
}
因为在需求中要求在显示用户信息时,要显示该用户的申请活动次数,报修次数,所以在查询过程中,会进行多个表的操作,会有一些繁琐。
下面展示实现过程
。
//获取所有用户信息openid、username、user_id、isblacklist、activitynum、repairnum
public List<UserData> getalluser() {
List<UserData> list = userManageMapper.getalluser();
List<String> blackopenidlist = userManageMapper.getallblacklistopenid();
//将repairlist转化为map
List<UserData> repairlist = userManageMapper.getallreparinum();
Map<String, Integer> remap = repairlist.stream().collect(Collectors.toMap(UserData::getUser_openid, UserData::getRepairnum, (key1, key2) -> key2));
//将activitylist转化为map
List<UserData> activitylist = userManageMapper.getallactivitynum();
Map<String, Integer> actmap = activitylist.stream().collect(Collectors.toMap(UserData::getUser_openid, UserData::getActivitynum, (key1, key2) -> key2));
for (UserData one : list) {
if (blackopenidlist.contains(one.getUser_openid())) {
one.setIsblacklist("是");
} else {
one.setIsblacklist("否");
}
if (remap.get(one.getUser_openid()) != null) {
one.setRepairnum(remap.get(one.getUser_openid()));
}
if (actmap.get(one.getUser_openid()) != null) {
one.setActivitynum(actmap.get(one.getUser_openid()));
}
}
return list;
}