| | |
| | | @ApiModelProperty("办理事项名称") |
| | | private String mattersNames; |
| | | |
| | | |
| | | |
| | | @TableField(exist = false) |
| | | @ApiModelProperty("办结事项数目") |
| | | private String transactionEndNum; |
| | | |
| | | } |
| | |
| | | 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 |