生产流程添加创建人名称

liuxm

2024-05-29 e0cb3db06d484e979cda82c5888a90c632af460c

生产流程添加创建人名称

 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoPr/PrProductionProcess.java

@@ -51,6 +51,8 @@
     */
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    public Long creator;
    @TableField(exist = false)
    public String creatorName;

    /**
     * 创建时间

 pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml

@@ -15,6 +15,8 @@
        <result property="remark" column="remark" jdbcType="VARCHAR"/>
        <association property="proName" column="pro_id" javaType="java.lang.Long"
                     select="selectProNameById" fetchType="eager" />
        <association property="creatorName" column="creator" javaType="java.lang.Long"
                     select="selectNameByUserId" fetchType="eager" />
        <collection property="nodes" ofType="com.dy.pmsGlobal.pojoPr.PrProductionNode"
                      select="selectByProcess" fetchType="eager" column="id" />
    </resultMap>
@@ -26,7 +28,10 @@
    </sql>

    <select id="selectProNameById" parameterType="java.lang.Long" resultType="java.lang.String">
        select name proName from plt_product where id=#{id}
        select name proName from plt_product where id=#{creator}
    </select>
    <select id="selectNameByUserId" parameterType="java.lang.Long" resultType="java.lang.String">
        select name from ba_user where id=#{id}
    </select>
    <select id="selectByProcess" resultMap="com.dy.pmsGlobal.daoPr.PrProductionNodeMapper.BaseResultMap">
        select *