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);
}