更新工作流

whycxzp

2022-07-23 209063b32eb3ff24938194c22225d02892d4b213

更新工作流

 src/main/java/com/whyc/pojo/WorksheetMain.java

@@ -47,7 +47,7 @@
    private String dealDesc;

    @TableField(exist = false)
    private String createUser;
    private DocUser createUser;

    @ApiModelProperty("待审批产品bom")
    @TableField(exist = false)
@@ -152,11 +152,11 @@
        this.status = status;
    }

    public String getCreateUser() {
    public DocUser getCreateUser() {
        return createUser;
    }

    public void setCreateUser(String createUser) {
    public void setCreateUser(DocUser createUser) {
        this.createUser = createUser;
    }


 src/main/resources/mapper/WorksheetLinkMapper.xml

@@ -17,12 +17,15 @@
            <result column="title" property="title"/>
            <result column="description" property="description"/>
            <result column="file" property="file"/>
            <result column="createUserName" property="createUser"/>
            <result column="begin_time" property="beginTime"/>
            <result column="end_time" property="endTime"/>
            <result column="level" property="level"/>
            <result column="status" property="status"/>
            <result column="end_reason" property="endReason"/>
            <result column="create_user_id" property="createUserId"/>
            <association property="createUser" column="create_user_id" javaType="com.whyc.pojo.DocUser" select="getUser">
                <result column="name" property="name"/>
            </association>
        </association>
    </resultMap>
    <select id="getInfoList" resultMap="Map_WorksheetLink">
@@ -36,4 +39,8 @@
            l.main_id = m.id
        AND deal_user_id = #{id}
    </select>

    <select id="getUser" resultType="com.whyc.pojo.DocUser">
        select name from db_doc.tb_doc_user where id =#{create_user_id}
    </select>
</mapper>

 src/main/resources/mapper/WorksheetMainMapper.xml

@@ -7,12 +7,14 @@
        <result column="title" property="title"/>
        <result column="description" property="description"/>
        <result column="file" property="file"/>
        <result column="createUserName" property="createUser"/>
        <result column="begin_time" property="beginTime"/>
        <result column="end_time" property="endTime"/>
        <result column="level" property="level"/>
        <result column="status" property="status"/>
        <result column="end_reason" property="endReason"/>
        <association column="create_user_id" property="createUser" javaType="com.whyc.pojo.DocUser" select="getUser">
            <result column="name" property="name"/>
        </association>
        <collection property="links" ofType="com.whyc.pojo.WorksheetLink">
            <id column="lid" property="id"/>
            <result column="deal_user_id" property="dealUserId"/>
@@ -70,6 +72,6 @@
    </select>
    
    <select id="getUser" resultType="com.whyc.pojo.DocUser">
        select name from db_doc.tb_doc_user where id =#{deal_user_id}
        select name from db_doc.tb_doc_user where id =#{user_id}
    </select>
</mapper>