初始化

刘光辉

昨天 bb638871a7fb692d80f1b7a758f991dc0879002c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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);
}