package jnpf.dmsMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.dmsEntity.permission.entity.DmsDocumentEntity;
|
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 DmsDocumentMapper extends BaseMapper<DmsDocumentEntity> {
|
@Select("SELECT id, tenant_id, folder_id, document_no, name, document_type, responsible_dept_id, "
|
+ "created_by, created_at "
|
+ "FROM public.dms_documents WHERE tenant_id = #{tenantId} AND id = #{id}")
|
DmsDocumentEntity selectByTenantAndId(@Param("tenantId") String tenantId, @Param("id") UUID id);
|
|
@Select("SELECT id, tenant_id, folder_id, document_no, name, document_type, responsible_dept_id, "
|
+ "created_by, created_at FROM public.dms_documents "
|
+ "WHERE tenant_id = #{tenantId} AND id = #{id} FOR UPDATE")
|
DmsDocumentEntity selectByTenantAndIdForUpdate(@Param("tenantId") String tenantId,
|
@Param("id") UUID id);
|
|
@Select({"<script>",
|
"SELECT id, tenant_id, folder_id, document_no, name, document_type, responsible_dept_id,",
|
"created_by, created_at",
|
"FROM public.dms_documents WHERE tenant_id = #{tenantId} AND id IN",
|
"<foreach collection='ids' item='id' open='(' separator=',' close=')'>#{id}</foreach>",
|
"</script>"})
|
List<DmsDocumentEntity> selectByTenantAndIds(@Param("tenantId") String tenantId,
|
@Param("ids") List<UUID> ids);
|
}
|
