修改【导办人员管理】新增的一个用户擅长办理没有数据 bug
| | |
| | | //提示用户名或密码错误 |
| | | return ResultData.error("该手机号已注册账户!请更换"); |
| | | } |
| | | |
| | | config.setRoleIds(2+""); |
| | | config.setCreateTime(LocalDateTime.now()); |
| | | config.setUpdateTime(LocalDateTime.now()); |
| | | config.setUserId(Snowflake.getId()); |
| | |
| | | ) AS department_area, |
| | | leisure_state, |
| | | master_ids, |
| | | master_names, |
| | | (SELECT GROUP_CONCAT(classify_name) FROM automessage_classify_administration WHERE id in (SELECT |
| | | substring_index(substring_index(master_ids,',', b.help_topic_id + 1), ',', -1) result |
| | | FROM |
| | | mysql.help_topic b |
| | | where |
| | | b.help_topic_id < (LENGTH(master_ids) - LENGTH(REPLACE(master_ids, ',', '')) + 1))) as master_names, |
| | | |
| | | transaction_ids, |
| | | transaction_names, |
| | | openid, |