lidongdong
2022-10-26 78173e8d7bda1d11d443743bd7c5705a02dccd50
修改办理事项办结数量显示错误  bug
2个文件已修改
8 ■■■■■ 已修改文件
flower_city/src/main/java/com/dg/core/db/gen/entity/SysUser.java 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/resources/mapper/SysUserMapper.xml 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/gen/entity/SysUser.java
@@ -268,4 +268,10 @@
    @ApiModelProperty("办理事项名称")
    private String mattersNames;
    @TableField(exist = false)
    @ApiModelProperty("办结事项数目")
    private String transactionEndNum;
}
flower_city/src/main/resources/mapper/SysUserMapper.xml
@@ -97,6 +97,8 @@
            openid,
            (select user_name from automessage_sys_user where automessage_sys_user.user_id=create_by) as createName,
            transaction_num,
            (select count(id) from automessage_guide_repair_order where automessage_guide_repair_order.state='3'
             and automessage_guide_repair_order.guide_user_id=user_id) as transactionEndNum,
            (select role_name from automessage_role_management where automessage_role_management.id=role_ids) as roleName,
            (select permission from automessage_role_management where automessage_role_management.id=role_ids) as permission,
            (select organization_name from automessage_organization_chart where automessage_sys_user.department_id=automessage_organization_chart.id) as department_name