package cn.iocoder.yudao.module.mdm.dal.mysql.item;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemTechnicalFileDO;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MdmItemTechnicalFileMapper extends BaseMapperX<MdmItemTechnicalFileDO> {

    default List<MdmItemTechnicalFileDO> selectListByItemId(Long itemId) {
        return selectList(new LambdaQueryWrapper<MdmItemTechnicalFileDO>()
                .eq(MdmItemTechnicalFileDO::getItemId, itemId)
                .orderByDesc(MdmItemTechnicalFileDO::getVersionNo));
    }

    // 包含已移除记录，避免后续上传复用已有工单显示过的序号。
    @Select("SELECT COALESCE(MAX(version_no), 0) FROM mdm_item_technical_file WHERE item_id = #{itemId}")
    Integer selectMaxVersionNo(@Param("itemId") Long itemId);
}