操作日志列表新增IP地址查询

RuoYi

2023-09-27 207a9ce855452d23e81e9ca8bf253521e0e0d3f9

操作日志列表新增IP地址查询

 ruoyi-system/src/main/resources/mapper/system/SysOperLogMapper.xml

@@ -37,6 +37,9 @@
    <select id="selectOperLogList" parameterType="SysOperLog" resultMap="SysOperLogResult">

        <include refid="selectOperLogVo"/>

        <where>

            <if test="operIp != null and operIp != ''">

                AND oper_ip like concat('%', #{operIp}, '%')

            </if>

            <if test="title != null and title != ''">

                AND title like concat('%', #{title}, '%')

            </if>


 ruoyi-ui/src/views/monitor/operlog/index.vue

@@ -1,6 +1,15 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label="操作地址" prop="operIp">
        <el-input
          v-model="queryParams.operIp"
          placeholder="请输入操作地址"
          clearable
          style="width: 240px;"
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="系统模块" prop="title">
        <el-input
          v-model="queryParams.title"
@@ -229,6 +238,7 @@
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        operIp: undefined,
        title: undefined,
        operName: undefined,
        businessType: undefined,