修改导办人员添加办理事项选择部门问题

lidongdong

2022-11-16 ca5aca50ba5729f347af37df3975e90cdf482a8d

修改导办人员添加办理事项选择部门问题

 flower_city/src/main/java/com/dg/core/db/gen/entity/SysUser.java

@@ -264,6 +264,10 @@
    private String mattersIds;


    @ApiModelProperty("部门ids")
    private String departmentIds;


    @TableField(exist = false)
    @ApiModelProperty("办理事项名称")
    private String mattersNames;

 flower_city/src/main/resources/mapper/SysUserMapper.xml

@@ -38,6 +38,7 @@
        <result property="transactionNum"      column="transaction_num"      />
        <result property="isDivisionHead"      column="is_division_head"      />
        <result property="mattersIds"      column="matters_ids"      />
        <result property="departmentIds"      column="department_ids"      />
    </resultMap>

    <sql id="selectSysUserVo">
@@ -68,6 +69,7 @@
            stair_id,
            second_level_id,
            matters_ids,
            department_ids,
            (SELECT GROUP_CONCAT(matter_name) FROM automessage_transaction_event WHERE id in (SELECT
              substring_index(substring_index(matters_ids,',', b.help_topic_id + 1), ',', -1) result
          FROM
@@ -252,6 +254,7 @@
        <if test="openid != null and openid != '' ">,openid</if>
        <if test="isDivisionHead != null and isDivisionHead != '' ">,is_division_head</if>
        <if test="mattersIds != null  ">,matters_ids</if>
        <if test="departmentIds != null  ">,department_ids</if>
        )values(
        sysdate()
        <if test="userId != null and userId != '' ">,#{userId}</if>
@@ -287,6 +290,7 @@
        <if test="openid != null and openid != '' ">,#{openid}</if>
        <if test="isDivisionHead != null and isDivisionHead != '' ">,#{isDivisionHead}</if>
        <if test="mattersIds != null">,#{mattersIds}</if>
        <if test="departmentIds != null  ">,#{departmentIds}</if>
        )
    </insert>

@@ -326,6 +330,7 @@
            <if test="openid != null and openid != '' ">,openid=#{openid}</if>
            <if test="isDivisionHead != null and isDivisionHead != '' ">,is_division_head=#{isDivisionHead}</if>
            <if test="mattersIds != null">,matters_ids=#{mattersIds}</if>
            <if test="departmentIds != null  ">,department_ids=#{departmentIds}</if>
            ,update_time=sysdate()
        </set>
        where user_id= #{userId}