package jnpf.dmsMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.dmsEntity.watermark.DmsWatermarkConfigEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Param;
|
import java.util.List;
|
import java.util.UUID;
|
|
@Mapper
|
public interface DmsWatermarkConfigMapper extends BaseMapper<DmsWatermarkConfigEntity> {
|
@Select("SELECT uuidv7()")
|
UUID nextId();
|
|
@Select("SELECT business_type_code FROM dms_watermark_business_types WHERE tenant_id = #{tenantId} AND config_id = #{configId} ORDER BY business_type_code")
|
List<String> selectBusinessTypes(@Param("tenantId") String tenantId, @Param("configId") UUID configId);
|
|
@Insert("INSERT INTO dms_watermark_business_types (tenant_id, config_id, business_type_code) VALUES (#{tenantId}, #{configId}, #{code})")
|
int insertBusinessType(@Param("tenantId") String tenantId, @Param("configId") UUID configId, @Param("code") String code);
|
|
@Delete("DELETE FROM dms_watermark_business_types WHERE tenant_id = #{tenantId} AND config_id = #{configId}")
|
int deleteBusinessTypes(@Param("tenantId") String tenantId, @Param("configId") UUID configId);
|
|
@Select({"<script>",
|
"SELECT DISTINCT config_id FROM dms_watermark_business_types",
|
"WHERE tenant_id = #{tenantId}",
|
"AND config_id IN <foreach collection='configIds' item='id' open='(' separator=',' close=')'>#{id}</foreach>",
|
"AND business_type_code IN <foreach collection='codes' item='code' open='(' separator=',' close=')'>#{code}</foreach>",
|
"</script>"})
|
List<UUID> selectMatchingConfigIds(@Param("tenantId") String tenantId,
|
@Param("configIds") List<UUID> configIds, @Param("codes") List<String> codes);
|
}
|
