lxw
2023-09-21 69e77606e9921b8865ca16508b54e39983ec5c35
历史版本可用性设定解锁逻辑修改
1个文件已修改
4 ■■■■ 已修改文件
src/main/resources/mapper/ProductBomMapper.xml 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/ProductBomMapper.xml
@@ -238,7 +238,7 @@
        select h.id,m.* from tb_product_bom h,tb_material m where h.material_id = m.id;
    </select>
    <insert id="insertBomSelectBomH">
        insert into tb_product_bom(product_id,material_id,sub_version,quantity)
        select product_id,material_id,#{subVersionMax},quantity from tb_product_bom_history where tb_product_bom_history.product_id=#{id}
        insert into tb_product_bom(product_id,material_id,sub_version,quantity,category,producer,producer_specification,material,thickness,surface_detail,notes)
                         select product_id,material_id,#{subVersionMax},quantity,category,producer,producer_specification,material,thickness,surface_detail,notes from tb_product_bom_history where tb_product_bom_history.product_id=#{id}
    </insert>
</mapper>