1.controller
@ResponseBody
@GetMapping("/selectLogin")
@Logging(title = "查询群体画像人员登录情况", describe = "查询群体画像人员登录情况", type = BusinessType.QUERY)
public Result selectLogin(String userIds, String startDate, String endDate) {
List<Map<String, Object>> mapList = groupPortraitService.selectLogin(extractMap(userIds, startDate, endDate));
return success(mapList);
}
private Map<String, Object> extractMap(String userIds, String startDate, String endDate) {
Map<String, Object> paramMap = new HashMap<>();
paramMap.put("userIds", spiltUserIds(userIds));
paramMap.put("startDate", startDate);
paramMap.put("endDate", endDate);
return paramMap;
}
private String[] spiltUserIds(String userIds) {
String[] str = null;
if (StringUtil.isNotNull(userIds)) {
str = userIds.split(",");
}
return str;
}
2.service
List<Map<String, Object>> selectLogin(Map<String, Object> paramMap);
@Override
public List<Map<String, Object>> selectLogin(Map<String, Object> paramMap) {
return groupPortraitMapper.selectLogin(paramMap);
}
3.mapper
List<Map<String, Object>> selectLogin(Map<String, Object> paramMap);
<select id="selectLogin" parameterType="map" resultType="map">
sql语句
</select>