日志管理

操作日志

前端调用后台接口

/** 查询登录日志 */
getList() {
  this.loading = true;
  list(this.addDateRange(this.queryParams, this.dateRange)).then( response => {
      this.list = response.rows;
      this.total = response.total;
      this.loading = false;
    }
  );
}

@PreAuthorize("@ss.hasPermi('monitor:operlog:list')")
@GetMapping("/list")
public TableDataInfo list(SysOperLog operLog)
{
    startPage();
    List<SysOperLog> list = operLogService.selectOperLogList(operLog);
    return getDataTable(list);
}

List<SysOperLog> list = operLogService.selectOperLogList(operLog);

/**
 * 查询系统操作日志集合
 * 
 * @param operLog 操作日志对象
 * @return 操作日志集合
 */
@Override
public List<SysOperLog> selectOperLogList(SysOperLog operLog)
{
    return operLogMapper.selectOperLogList(operLog);
}

operLogMapper.selectOperLogList(operLog);

执行sql

select oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time
from sys_oper_log

created() {
  this.getList();
  this.getDicts("sys_oper_type").then(response => {
    this.typeOptions = response.data;
  });
  this.getDicts("sys_common_status").then(response => {
    this.statusOptions = response.data;
  });
}

获取类型字典

获取状态字典

登录日志

created() {
  this.getList();
  this.getDicts("sys_common_status").then(response => {
    this.statusOptions = response.data;
  });
}

@PreAuthorize("@ss.hasPermi('monitor:logininfor:list')")
@GetMapping("/list")
public TableDataInfo list(SysLogininfor logininfor)
{
    startPage();
    List<SysLogininfor> list = logininforService.selectLogininforList(logininfor);
    return getDataTable(list);
}

List<SysLogininfor> list = logininforService.selectLogininforList(logininfor);

/**
 * 查询系统登录日志集合
 * 
 * @param logininfor 访问日志对象
 * @return 登录记录集合
 */
@Override
public List<SysLogininfor> selectLogininforList(SysLogininfor logininfor)
{
    return logininforMapper.selectLogininforList(logininfor);
}

执行sql

select info_id, user_name, ipaddr, login_location, browser, os, status, msg, login_time from sys_logininfor

获取状态字典