From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master
---
jnpf-dms/jnpf-dms-biz/src/main/java/jnpf/dmsMapper/DmsPermissionUsageMapper.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/jnpf-dms/jnpf-dms-biz/src/main/java/jnpf/dmsMapper/DmsPermissionUsageMapper.java b/jnpf-dms/jnpf-dms-biz/src/main/java/jnpf/dmsMapper/DmsPermissionUsageMapper.java
new file mode 100644
index 0000000..1927a77
--- /dev/null
+++ b/jnpf-dms/jnpf-dms-biz/src/main/java/jnpf/dmsMapper/DmsPermissionUsageMapper.java
@@ -0,0 +1,29 @@
+package jnpf.dmsMapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import jnpf.dmsEntity.permission.entity.DmsPermissionUsageEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+import java.util.UUID;
+
+@Mapper
+public interface DmsPermissionUsageMapper extends BaseMapper<DmsPermissionUsageEntity> {
+ String COLUMNS = "id, tenant_id, permission_id, user_id, action_code, actual_resource_type, "
+ + "actual_resource_id, operation_id, session_expires_at, used_at";
+
+ @Select("SELECT " + COLUMNS + " FROM public.dms_permission_usages "
+ + "WHERE tenant_id = #{tenantId} AND user_id = #{userId} AND operation_id = #{operationId}")
+ DmsPermissionUsageEntity selectByOperation(@Param("tenantId") String tenantId,
+ @Param("userId") String userId,
+ @Param("operationId") UUID operationId);
+
+ @Select("SELECT " + COLUMNS + " FROM public.dms_permission_usages "
+ + "WHERE tenant_id = #{tenantId} AND permission_id = #{permissionId} "
+ + "ORDER BY used_at DESC, id DESC LIMIT #{limit}")
+ List<DmsPermissionUsageEntity> selectByPermission(@Param("tenantId") String tenantId,
+ @Param("permissionId") UUID permissionId,
+ @Param("limit") int limit);
+}
--
Gitblit v1.8.0