20231010_qiuyh_调整管片明细sql

邱宇豪

2023-10-10 22b207e59644a4f7228dbdd9c7bd2bc8428a4ec4

20231010_qiuyh_调整管片明细sql

 hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml

@@ -272,8 +272,8 @@
  </select>
    <select id="selectPipeInfo" resultType="java.util.Map" parameterType="java.util.Map">
        SELECT
                tpi.ring_num,
                tpi.pipe_num,
                tpi.ring_num ringNum,
                tpi.pipe_num pipeNum,
                sd1.dict_name turn,
                sd2.dict_name reinforcement,
                sd3.dict_name groutingHoles,
@@ -283,7 +283,7 @@
                IFNULL(tpi.pouring_time,' ') pouringTime,
                tpi.check_time checkTime,
                IFNULL(sg.group_name,'无') groupName,
                sp.pro_name,
                sp.pro_name proName,
                CASE tpi.check_result
                        WHEN  1 THEN '合格'
                        WHEN  2 THEN '不合格'