| | |
|---|
| | | @Select("select type,name,phone,image_url,nick_name from sys_user where user_id=#{userId}") |
|---|
| | | LoginUserInfoVO selectUserByUserId(Long userId); |
|---|
| | | |
|---|
| | | @Select("<script> " + "select t.* from (" + "SELECT " + "d.id, " + "d.`discuss_subject`, " + "d.type, " |
|---|
| | | + "COUNT( DISTINCT c.id ) commentNum, " + "u.name userName, " + "u.nick_name userNickName, " + "d.create_at " |
|---|
| | | + "FROM " + "com_act_discuss d " + "JOIN sys_user u ON d.user_id = u.user_id " |
|---|
| | | + "LEFT JOIN com_act_discuss_comment c ON d.id = c.discuss_id " |
|---|
| | | + " where d.community_id=#{pageComActDiscussDTO.communityId}" |
|---|
| | | + "<if test='pageComActDiscussDTO.subject != null and pageComActDiscussDTO.subject.trim() != ""'>" |
|---|
| | | + " and d.`discuss_subject` LIKE concat( #{pageComActDiscussDTO.subject}, '%' ) " + " </if> " |
|---|
| | | + "<if test='pageComActDiscussDTO.begin != null '>" + "AND d.create_at BETWEEN #{pageComActDiscussDTO.begin} " |
|---|
| | | + "AND #{pageComActDiscussDTO.end} " + " </if> " + "GROUP BY " + "d.id" + ")t order by t.create_at desc " |
|---|
| | | + "</script>") |
|---|
| | | // @Select("<script> " + "select t.* from (" + "SELECT " + "d.id, " + "d.`discuss_subject`, " + "d.type, " |
|---|
| | | // + "COUNT( DISTINCT c.id ) commentNum, " + "u.name userName, " + "u.nick_name userNickName, " + "d.create_at " |
|---|
| | | // + "FROM " + "com_act_discuss d " + "JOIN sys_user u ON d.user_id = u.user_id " |
|---|
| | | // + "LEFT JOIN com_act_discuss_comment c ON d.id = c.discuss_id " |
|---|
| | | // + " where d.community_id=#{pageComActDiscussDTO.communityId}" |
|---|
| | | // + "<if test='pageComActDiscussDTO.subject != null and pageComActDiscussDTO.subject.trim() != ""'>" |
|---|
| | | // + " and d.`discuss_subject` LIKE concat( #{pageComActDiscussDTO.subject}, '%' ) " + " </if> " |
|---|
| | | // + "<if test='pageComActDiscussDTO.begin != null '>" + "AND d.create_at BETWEEN #{pageComActDiscussDTO.begin} " |
|---|
| | | // + "AND #{pageComActDiscussDTO.end} " + " </if> " + "GROUP BY " + "d.id" + ")t order by t.create_at desc " |
|---|
| | | // + "</script>") |
|---|
| | | IPage<ComActDiscussVO> pageDiscuss(Page page, |
|---|
| | | @Param("pageComActDiscussDTO") PageComActDiscussDTO pageComActDiscussDTO); |
|---|
| | | |
|---|
| | | IPage<ComActDiscussVO> pageDiscussAdmin(Page page, |
|---|
| | | @Param("pageComActDiscussDTO") PageComActDiscussDTO pageComActDiscussDTO); |
|---|
| | | |
|---|
| | | @Select("<script> " + "select * from (" + "SELECT " + "u.`name` userName, " + "u.nick_name userNickName, " |
|---|
| | | + "u.phone, " + "c.`comment`, " + "c.`parent_id`, " + "COUNT(DISTINCT 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 " |
|---|
