fix: 操作日志根据操作时间倒序

gongchunyi

9 小时以前 280261219bafff383fe37dfc24f148baca4672e1

fix: 操作日志根据操作时间倒序

 src/main/resources/mapper/monitor/SysOperLogMapper.xml

@@ -28,12 +28,12 @@
        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, cost_time
        from sys_oper_log
    </sql>
    

    <insert id="insertOperlog" parameterType="com.ruoyi.project.monitor.domain.SysOperLog">
        insert into sys_oper_log(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, cost_time, oper_time)
        values (#{title}, #{businessType}, #{method}, #{requestMethod}, #{operatorType}, #{operName}, #{deptName}, #{operUrl}, #{operIp}, #{operLocation}, #{operParam}, #{jsonResult}, #{status}, #{errorMsg}, #{costTime}, sysdate())
    </insert>
	

    <select id="selectOperLogList" parameterType="com.ruoyi.project.monitor.domain.SysOperLog" resultMap="SysOperLogResult">
        <include refid="selectOperLogVo"/>
        <where>
@@ -50,7 +50,7 @@
                AND business_type in
                <foreach collection="businessTypes" item="businessType" open="(" separator="," close=")">
                     #{businessType}
                </foreach> 
                </foreach>
            </if>
            <if test="status != null">
                AND status = #{status}
@@ -65,23 +65,23 @@
                AND oper_time &lt;= #{params.endTime}
            </if>
        </where>
        order by oper_id desc
        order by oper_time desc
    </select>
	

    <delete id="deleteOperLogByIds" parameterType="Long">
         delete from sys_oper_log where oper_id in
         <foreach collection="array" item="operId" open="(" separator="," close=")">
             #{operId}
        </foreach> 
        </foreach>
     </delete>
 	

     <select id="selectOperLogById" parameterType="Long" resultMap="SysOperLogResult">
        <include refid="selectOperLogVo"/>
        where oper_id = #{operId}
    </select>
	

    <update id="cleanOperLog">
        truncate table sys_oper_log
    </update>

</mapper> 
</mapper>