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.dto.Response;
|
import com.whyc.mapper.DocLogMapper;
|
import com.whyc.pojo.DocLog;
|
import com.whyc.util.ActionUtil;
|
import com.whyc.util.DateUtil;
|
import com.whyc.util.ExcelUtil;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.util.Calendar;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class DocLogService {
|
@Autowired(required = false)
|
private DocLogMapper mapper;
|
|
public void recordOperationLog(Long uId,String name, Integer operationType, Date operationTime, String terminalIp, String operationMsg, String operationDetail) {
|
DocLog docLog=new DocLog();
|
docLog.setId(uId.intValue());
|
docLog.setName(name);
|
docLog.setOprateType(operationType);
|
docLog.setOprateDay(operationTime);
|
docLog.setTerminalIp(terminalIp);
|
docLog.setOprateMsg(operationMsg);
|
docLog.setOperationDetail(operationDetail);
|
mapper.insert(docLog);
|
}
|
//下载专属日志记录
|
public void recordOperationLogDownLoad(Long uId,String name, Integer operationType, Date operationTime, String terminalIp
|
, String operationMsg, String operationDetail,String oprateReason,String oprateInfo,String oprateVersion) {
|
DocLog docLog=new DocLog();
|
docLog.setId(uId.intValue());
|
docLog.setName(name);
|
docLog.setOprateType(operationType);
|
docLog.setOprateDay(operationTime);
|
docLog.setTerminalIp(terminalIp);
|
docLog.setOprateMsg(operationMsg);
|
docLog.setOperationDetail(operationDetail);
|
docLog.setOprateReason(oprateReason);
|
docLog.setOprateInfo(oprateInfo);
|
docLog.setOprateVersion(oprateVersion);
|
mapper.insert(docLog);
|
}
|
public PageInfo<DocLog> getPage(int pageNum, int pageSize, DocLog docLog) {
|
PageHelper.startPage(pageNum,pageSize,true);
|
//这个接口要兼容新老审计日志记录的查询
|
List<DocLog> userLogList = mapper.getList(docLog);
|
userLogList.stream().forEach(docLog1-> {
|
switch (docLog1.getOprateType()){
|
case 1: docLog1.setOperationTypeStr(UserOperation.TYPE_LOGIN.getTypeName());break;
|
case 2: docLog1.setOperationTypeStr(UserOperation.TYPE_LOGOUT.getTypeName());break;
|
case 3: docLog1.setOperationTypeStr(UserOperation.TYPE_ADD.getTypeName());break;
|
case 4: docLog1.setOperationTypeStr(UserOperation.TYPE_UPDATE.getTypeName());break;
|
case 5: docLog1.setOperationTypeStr(UserOperation.TYPE_DELETE.getTypeName());break;
|
case 20:docLog1.setOperationTypeStr(UserOperation.TYPE_UNAUTHORIZED_ACCESS.getTypeName());break;
|
case 21:docLog1.setOperationTypeStr(UserOperation.TYPE_EXCEPTION.getTypeName());break;
|
case 31:docLog1.setOperationTypeStr(UserOperation.TYPE_LOGIN_FAIL.getTypeName());break;
|
case 32:docLog1.setOperationTypeStr(UserOperation.TYPE_PARAM_CHANGE.getTypeName());break;
|
case 33:docLog1.setOperationTypeStr(UserOperation.TYPE_PASSWORD_CHANGE.getTypeName());break;
|
case 34:docLog1.setOperationTypeStr(UserOperation.TYPE_LOGIN_TIMEOUT.getTypeName());break;
|
default:docLog1.setOperationTypeStr(UserOperation.TYPE_UNRECOGNIZED.getTypeName());
|
}
|
});
|
PageInfo<DocLog> 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);
|
}
|
|
public void record(long uId,String name, int operationType, String msg) {
|
DocLog docLog = new DocLog();
|
docLog.setTerminalIp(ActionUtil.getRequest().getRemoteAddr());
|
docLog.setOprateDay(new Date());
|
docLog.setId((int)(uId));
|
docLog.setName(name);
|
docLog.setOprateType(operationType);
|
docLog.setOprateMsg(msg);
|
mapper.insert(docLog);
|
}
|
|
public void record(long uId,String name, int operationType, String msg,String msgDetail) {
|
DocLog docLog = new DocLog();
|
HttpServletRequest request = ActionUtil.getRequest();
|
String remoteAddr;
|
if(request!=null) {
|
remoteAddr = request.getRemoteAddr();
|
}else{
|
remoteAddr = "127.0.0.1";
|
}
|
docLog.setTerminalIp(remoteAddr);
|
docLog.setOprateDay(new Date());
|
docLog.setId((int)(uId));
|
docLog.setName(name);
|
docLog.setOprateType(operationType);
|
docLog.setOprateMsg(msg);
|
docLog.setOperationDetail(msgDetail);
|
mapper.insert(docLog);
|
}
|
|
public void record2(HttpServletRequest request,long uId, String name, int operationType, String msg, String msgDetail) {
|
DocLog docLog = new DocLog();
|
docLog.setTerminalIp(request.getRemoteAddr());
|
//userLog.setTerminalIp(request.getRemoteAddr());
|
docLog.setOprateDay(new Date());
|
docLog.setId((int)(uId));
|
docLog.setName(name);
|
docLog.setOprateType(operationType);
|
docLog.setOprateMsg(msg);
|
docLog.setOperationDetail(msgDetail);
|
mapper.insert(docLog);
|
}
|
//日志查询
|
public Response searchLog(DocLog docLog,int pageCurr, int pageSize) {
|
PageHelper.startPage(pageCurr,pageSize);
|
QueryWrapper wrapper=new QueryWrapper();
|
if(docLog!=null){
|
if(docLog.getName()!=null&&docLog.getName()!=""){
|
wrapper.like("name",docLog.getName());
|
}
|
if(docLog.getOprateType()!=null){
|
wrapper.eq("oprate_type",docLog.getOprateType());
|
}
|
if(docLog.getOprateDay()!=null){
|
wrapper.ge("oprate_day",docLog.getOprateDay());
|
}
|
if(docLog.getOprateDay2()!=null){
|
wrapper.le("oprate_day",docLog.getOprateDay2());
|
}
|
}
|
wrapper.ne("id", 0);
|
wrapper.ne("oprate_type",UserOperation.TYPE_EXCEPTION.getType());
|
wrapper.orderByDesc("oprate_day");
|
List<DocLog> list=mapper.selectList(wrapper);
|
list.stream().forEach(dlog->{
|
dlog.setOperationTypeStr(UserOperation.getNameByType(dlog.getOprateType()));
|
});
|
PageInfo pageInfo=new PageInfo(list);
|
return new Response().setII(1,list.size()>0,pageInfo,"数据返回");
|
}
|
//操作对应关系
|
public Response getOperate() {
|
return new Response().setII(1,true,UserOperation.values(),"数据返回");
|
}
|
//查询下载日志(DownLoadNew)
|
public Response getDownLoadNew(int type, String oprateInfo) {
|
QueryWrapper wrapper=new QueryWrapper();
|
wrapper.ne("id", 0);
|
wrapper.eq("oprate_type", type);
|
wrapper.eq("oprate_info", oprateInfo);
|
wrapper.orderByDesc("oprate_day");
|
List<DocLog> list=mapper.selectList(wrapper);
|
list.stream().forEach(dlog->{
|
dlog.setOperationTypeStr(UserOperation.getNameByType(dlog.getOprateType()));
|
});
|
return new Response().setII(1,list.size()>0,list,"数据返回");
|
}
|
|
public List<DocLog> getListOfToday() {
|
Calendar startTime = Calendar.getInstance();
|
|
startTime.set(Calendar.HOUR_OF_DAY,0);
|
startTime.set(Calendar.MINUTE,0);
|
startTime.set(Calendar.SECOND,0);
|
|
Calendar endTime = Calendar.getInstance();
|
endTime.set(Calendar.HOUR_OF_DAY,23);
|
endTime.set(Calendar.MINUTE,59);
|
endTime.set(Calendar.SECOND,59);
|
|
QueryWrapper<DocLog> query = Wrappers.query();
|
query.ge("oprate_day",startTime.getTime());
|
query.le("oprate_day",endTime.getTime());
|
query.ne("oprate_type",10);
|
query.orderByDesc("num");
|
|
List<DocLog> logList = mapper.selectList(query);
|
logList.forEach(log->{
|
Integer operateType = log.getOprateType();
|
switch (operateType){
|
case 1: log.setOperateTypeName(UserOperation.TYPE_LOGIN.getTypeName());break;
|
case 2: log.setOperateTypeName(UserOperation.TYPE_LOGOUT.getTypeName());break;
|
case 3: log.setOperateTypeName(UserOperation.TYPE_ADD.getTypeName());break;
|
case 4: log.setOperateTypeName(UserOperation.TYPE_UPDATE.getTypeName());break;
|
case 5: log.setOperateTypeName(UserOperation.TYPE_DELETE.getTypeName());break;
|
case 7: log.setOperateTypeName(UserOperation.TYPE_CANCEL.getTypeName());break;
|
case 9: log.setOperateTypeName(UserOperation.TYPE_STOP.getTypeName());break;
|
case 11: log.setOperateTypeName(UserOperation.TYPE_DOWNLOAD.getTypeName());break;
|
case 12: log.setOperateTypeName(UserOperation.TYPE_DOWNLOAD_PRODUCT.getTypeName());break;
|
case 13: log.setOperateTypeName(UserOperation.TYPE_DOWNLOAD_MATERIAL.getTypeName());break;
|
case 14: log.setOperateTypeName(UserOperation.TYPE_DOWNLOAD_SOFWARE.getTypeName());break;
|
case -1: log.setOperateTypeName(UserOperation.TYPE_UNRECOGNIZED.getTypeName());break;
|
case 20: log.setOperateTypeName(UserOperation.TYPE_UNAUTHORIZED_ACCESS.getTypeName());break;
|
case 21: log.setOperateTypeName(UserOperation.TYPE_EXCEPTION.getTypeName());break;
|
case 31: log.setOperateTypeName(UserOperation.TYPE_LOGIN_FAIL.getTypeName());break;
|
case 32: log.setOperateTypeName(UserOperation.TYPE_PARAM_CHANGE.getTypeName());break;
|
case 33: log.setOperateTypeName(UserOperation.TYPE_PASSWORD_CHANGE.getTypeName());break;
|
case 34: log.setOperateTypeName(UserOperation.TYPE_LOGIN_TIMEOUT.getTypeName());break;
|
case 35: log.setOperateTypeName(UserOperation.TYPE_LOGIN_NO_PASS.getTypeName());break;
|
case 41: log.setOperateTypeName(UserOperation.TYPE_SEND_MAIL.getTypeName());break;
|
default: log.setOperateTypeName(UserOperation.TYPE_UNRECOGNIZED.getTypeName());break;
|
}
|
});
|
|
return logList;
|
|
}
|
}
|
