将单独查询的sql 统一

zhaowenxuan

2024-05-28 f6aa75199f79c3fbe74de4c72c3271234e781341

将单独查询的sql 统一

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java

@@ -159,7 +159,7 @@
            "(select pro_id from tj_project where pro_parent_id=#{proParentId})")
    public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId);


    public List<TjOrderDetail> getDetailByOrderIdAndParIds(@Param("orderId")Long orderId,@Param("proParentIds")List<Long> proParentIds);

    @Select("call pro_lis_sqdbgd(1,#{tjnumber,mode=IN})")
//    @Select("select * from test_detail")

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java

@@ -101,6 +101,8 @@

    public List<TjOrderDetail> getDetailByOrderIdAndParId(Long orderId,Long proParentId);

    public List<TjOrderDetail> getDetailByOrderIdAndParIds(Long orderId,List<Long> proParentIds);


    List<TjOrderDetail> addHuaYanTable(String tjnumber);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java

@@ -160,6 +160,11 @@
    }

    @Override
    public List<TjOrderDetail> getDetailByOrderIdAndParIds(Long orderId, List<Long> proParentIds) {
        return tjOrderDetailMapper.getDetailByOrderIdAndParIds(orderId,proParentIds);
    }

    @Override
    public List<TjOrderDetail> addHuaYanTable(String tjnumber) {
        return tjOrderDetailMapper.addHuaYanTable(tjnumber);
    }

 ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml

@@ -64,6 +64,21 @@
        <include refid="selectTjOrderDetailVo"/>
        where order_detail_id = #{orderDetailId}
    </select>
    <select id="getDetailByOrderIdAndParIds" resultType="com.ltkj.hosp.domain.TjOrderDetail">
        SELECT CONCAT(t.update_by,',',p.pro_parent_id) AS update_by,
               t.order_detail_id,t.order_id,t.pro_id,t.pro_type,t.stan_id,t.pro_result,t.pro_advice,t.tj_status,t.create_time,t.create_by,t.update_time,t.exception_desc,t.is_addition,t.is_return,t.flowing_water_id,t.is_sampling,t.result_type,t.yq_deadline,t.create_id,t.update_id,t.conclusion,t.advice,t.is_positive
        FROM tj_order_detail t
            JOIN(
                SELECT pro_id,pro_parent_id
                FROM tj_project
                WHERE pro_parent_id IN
                    <foreach collection="proParentIds" item="proParentId" open="(" separator="," close=")">
                        #{proParentId}
                    </foreach>
                ) p
                ON t.pro_id = p.pro_id
        WHERE t.order_id = #{orderId}
    </select>

    <insert id="insertTjOrderDetail" parameterType="TjOrderDetail">
        insert into tj_order_detail