lxw
2023-09-21 c0f194e692337993a996baf6a153598a21876ee1
src/main/java/com/whyc/service/DocLogService.java
@@ -13,9 +13,11 @@
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RequestParam;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.lang.reflect.Type;
import java.util.Date;
import java.util.List;
@@ -33,6 +35,22 @@
        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) {
@@ -67,33 +85,36 @@
        ExcelUtil.exportExcel("UserLog-"+now,"测试sheet1",columnTitleArr,value,new HSSFWorkbook(),response);
    }
    public void record(long uId, int operationType, String msg) {
    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, int operationType, String msg,String msgDetail) {
    public void record(long uId,String name, int operationType, String msg,String msgDetail) {
        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);
        docLog.setOperationDetail(msgDetail);
        mapper.insert(docLog);
    }
    public void record2(HttpServletRequest request, long uId, int operationType, String msg, String msgDetail) {
    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);
@@ -118,16 +139,30 @@
            }
        }
        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?true:false,pageInfo,"数据返回");
        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,"数据返回");
    }
}