package com.whyc.service;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import com.whyc.constant.UserOperation;
|
import com.whyc.mapper.UserLogMapper;
|
import com.whyc.pojo.UserLog;
|
import com.whyc.util.DateUtil;
|
import com.whyc.util.ExcelUtil;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class UserLogService {
|
|
@Resource
|
private UserLogMapper mapper;
|
|
public PageInfo<UserLog> getPage(int pageNum, int pageSize, UserLog userLog) {
|
QueryWrapper<UserLog> wrapper = Wrappers.query();
|
if(userLog.getUId()!=null){
|
wrapper.eq("uId",userLog.getUId());
|
}
|
if(userLog.getOperationType()!=null){
|
wrapper.eq("uOprateType",userLog.getOperationType());
|
}
|
wrapper.between("uOprateDay",userLog.getOperationTime(),userLog.getOperationTime2());
|
|
PageHelper.startPage(pageNum,pageSize,true);
|
List<UserLog> userLogList = mapper.selectList(wrapper);
|
userLogList.stream().forEach(userLog1 -> {
|
switch (userLog1.getOperationType()){
|
case 1: userLog1.setOperationTypeStr(UserOperation.TYPE_LOGIN.getTypeName());break;
|
case 2: userLog1.setOperationTypeStr(UserOperation.TYPE_LOGOUT.getTypeName());break;
|
case 3: userLog1.setOperationTypeStr(UserOperation.TYPE_ADD.getTypeName());break;
|
case 4: userLog1.setOperationTypeStr(UserOperation.TYPE_UPDATE.getTypeName());break;
|
case 5: userLog1.setOperationTypeStr(UserOperation.TYPE_DELETE.getTypeName());break;
|
default:userLog1.setOperationTypeStr(UserOperation.TYPE_UNRECOGNIZED.getTypeName());
|
}
|
});
|
PageInfo<UserLog> pageInfo = new PageInfo<>(userLogList);
|
return pageInfo;
|
|
}
|
|
public void exportExcel(HttpServletResponse response, String[][] value) {
|
|
String[] columnTitleArr = new String[]{"操作人姓名","操作类型","操作时间","终端IP","操作事件","具体参数"};
|
String now = DateUtil.YYYY_MM_DD_HH_MM_SS_UNION.format(new Date());
|
ExcelUtil.exportExcel("UserLog-"+now,"测试sheet1",columnTitleArr,value,new HSSFWorkbook(),response);
|
}
|
}
|
