package jnpf.dmsMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.dmsEntity.operationlog.entity.DmsFileOperationLogEntity;
import org.apache.ibatis.annotations.Insert;
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 DmsFileOperationLogMapper extends BaseMapper<DmsFileOperationLogEntity> {
    String COLUMNS = "id, tenant_id, document_id, file_version_id, operation_code, operation_key, "
            + "operator_user_id, operator_name, file_name, operation_content, occurred_at";

    @Insert("INSERT INTO public.dms_file_operation_logs "
            + "(tenant_id, document_id, file_version_id, operation_code, operation_key, "
            + "operator_user_id, operator_name, file_name, operation_content) VALUES "
            + "(#{value.tenantId}, #{value.documentId}, #{value.fileVersionId}, "
            + "#{value.operationCode}, #{value.operationKey}, #{value.operatorUserId}, "
            + "#{value.operatorName}, #{value.fileName}, #{value.operationContent}) "
            + "ON CONFLICT (tenant_id, operation_key) DO NOTHING")
    int insertIgnore(@Param("value") DmsFileOperationLogEntity value);

    @Select({"<script>",
            "SELECT COUNT(*) FROM public.dms_file_operation_logs",
            "WHERE tenant_id = #{tenantId} AND document_id = #{documentId}",
            "<if test='keyword != null'>AND operation_content ILIKE '%' || #{keyword} || '%'</if>",
            "</script>"})
    long countByDocument(@Param("tenantId") String tenantId,
                         @Param("documentId") UUID documentId,
                         @Param("keyword") String keyword);

    @Select({"<script>",
            "SELECT " + COLUMNS + " FROM public.dms_file_operation_logs",
            "WHERE tenant_id = #{tenantId} AND document_id = #{documentId}",
            "<if test='keyword != null'>AND operation_content ILIKE '%' || #{keyword} || '%'</if>",
            "ORDER BY occurred_at DESC, id DESC LIMIT #{limit} OFFSET #{offset}",
            "</script>"})
    List<DmsFileOperationLogEntity> selectByDocument(
            @Param("tenantId") String tenantId,
            @Param("documentId") UUID documentId,
            @Param("keyword") String keyword,
            @Param("limit") int limit,
            @Param("offset") long offset);
}