| | |
|---|
| | | IPage<ComActDiscussVO> pageDiscussApplets(Page page, |
|---|
| | | @Param("pageComActDiscussDTO") PageComActDiscussDTO pageComActDiscussDTO); |
|---|
| | | |
|---|
| | | @Select("<script> " + "select * from (" + "SELECT " + "u.`name` userName, " + "u.nick_name userNickName, " |
|---|
| | | @Select("<script> " + "select * from (" + "SELECT " + "u.`name` userName, " + "IFNULL(u.`nick_name`,'社区管理员') as userNickName, " |
|---|
| | | + "u.`image_url`, " + "u.phone, " + "u.type as userType, " + "c.`comment`, " + "c.`parent_id`, " |
|---|
| | | + "c.`is_author`, " + "c.`is_topping`, " + "COUNT( cu.id ) num, " + "c.create_at, " + "c.id " + "FROM " |
|---|
| | | + "com_act_discuss_comment c " + "JOIN sys_user u ON c.user_id = u.user_id " |
|---|
