SCRUM

任务总览

前端

• 昨日安排

• 明日安排

后端

• 昨日安排

• 明日安排

成员描述

内容展示

• 语涵104
• 完成issue

  afterRead: function (event) 
    const that = this;
    console.log(event.detail.file.url);
    this.setData(
      fileList: [event.detail.file],
    );
    console.log(this.data.fileList)

    this.submitImage();
  ,

  submitImage:function (e) 
    let that=this;
    const file = that.data.fileList;
    let promiseArr=[];
    let imgServerUrls=new Array();
    console.log(that.data.fileList);
    file.forEach(function (e) 
      var FSM = wx.getFileSystemManager();
      let imageType=getApp().getImageType(e.url);
      promiseArr.push(
          new Promise(function (resolve,reject) 
            FSM.readFile(
              filePath: e.url,
              encoding: "base64",
              success: function (data) 
                wx.request(
                 //获取图片信息
                  
                )
              
            );
          )
      )
    )

• 炜华230

• 完成issue1

• 完成issue2

getPostList()
    let that = this;
    let baseUrl = app.globalData.baseUrl;
    request(                                           //调用接口获取个人帖子列表
      url: baseUrl + \'/api/user/post/list\',
      method:\'GET\',
      success(res)
        console.log(res);
        if(res.data.code === 200)
          let tempData = res.data.data.reverse();              //获取逆序列表
          if(tempData!= null) 
            for (let i = 0; i < tempData.length; i++)         //时间转换
              tempData[i].gmtCreate = timeago.format(new Date(tempData[i].gmtCreate), \'zh_CN\');
            
          
          that.setData(
            postList:tempData,
          )
        
      
    )
  ,

• 伟峰432

• 完成issue1

• 完成issue2

• 完成issue3

• 完成issue4

• 完成issue5

• 完成issue6

//处理组局成员
if (i < partyMemmberCntNow) 
        // 判断是否是局长，如果是就赋值组长的配置
        if (partyParticipantsId[i] == partyPublisherID) 
          member.url = baseUrl + \'/static/\' + partyPublisherMsg.iconUrl;
          member.isPublisher = true;
          member.text = \'局长\';
          //如果是自己，就赋值相应的配置
          if (partyParticipantsId[i] == userId) 
            member.myself = true;
            member.text = \'自己\'
          

//不是组长，是组员的情况
else 
        member = 
                index: i,
                url: this.data.memberIconUrl,
                userId: participantsId[i],
                isOccupied: true,
                ifShow: false,
                isPublisher: false,
                myself: false,
                text: \'成员\'
        
        //如果当前用户已经是组员，赋值相应的配置
        if (partyParticipantsId[i] == userId) 
          member.myself = true;
          member.text = \'自己\'
        
      

• 亮亮215

完成issue1

完成issue2

完成issue3

优化十大热帖热搜

 -- 核心SQL语句，查询出点赞数前十的待连接的帖子信息,按点赞数降序，时间倒序排列，已连接发帖人昵称，帖子类名，需要继续连接其他相关信息
SELECT
   post.id AS id,
   post.publisher_id AS publisher_id,
   post.`status` AS `status`,
   post.post_type_id AS post_type_id,
   post.message AS message,
   post.image_urls AS image_urls,
   post.gmt_create AS gmt_create,
   post.gmt_modified AS gmt_modified,
   post.deleted AS deleted,
   `user`.username AS username,
   post_type.`name` AS post_type_name,
   #currentUserId AS currentUserId
FROM
   post,
   `user`,
   post_type,
   -- 查询点赞数最多的十个帖子的id和点赞数（用于排序）
   (select  
    	post_like.post_id,count(distinct post_like.id) as cnt
    from post_like,post
    where post_like.deleted = 0 and  post_like.post_id = post.id and post.deleted = 0 and post.status=0
    group by post_like.post_id
    order by count(distinct post_like.id) desc
    limit 0,10
    ) as top
WHERE
   top.post_id = post.id AND
   post.publisher_id = `user`.id AND
   post.post_type_id = post_type.id
ORDER BY
   top.cnt DESC,
   gmt_create DESC,
   id DESC

优化按类别查询

 -- 核心SQL语句，查询指定类别的待连接的帖子信息,按时间倒序排列，已连接发帖人昵称，帖子类名，需要继续连接其他相关信息
SELECT
    post.id AS id,
    post.publisher_id AS publisher_id,
    post.`status` AS `status`,
    post.post_type_id AS post_type_id,
    post.message AS message,
    post.image_urls AS image_urls,
    post.gmt_create AS gmt_create,
    post.gmt_modified AS gmt_modified,
    post.deleted AS deleted,
    `user`.username AS username,
    post_type.`name` AS post_type_name,
    #queryMap.currentUserId AS currentUserId
FROM
    post,
    `user`,
    post_type
WHERE
    post.deleted = 0 AND
    post.`status` = 0 AND
    -- 指定帖子类别id
    post.post_type_id = #queryMap.typeId  AND
    post.publisher_id = `user`.id AND
    post.post_type_id = post_type.id
ORDER BY
    gmt_create DESC,
    id DESC

十大热帖与当前用户信息不符

if (user != null) 
          Long id = user.getId();//获取当前用户id

• 海翔321
• 完成issue

@SpringBootTest

public class PrivateChatServiceImplTest 



  @Autowired

  PrivateChatServiceImpl privateChatService;



  @Test

  void listChatTest()



    Result<List<Map<String, Object>>> result = privateChatService.listChat(123456L);

    System.out.println(result);

  



  @Test

  void clearListTest()

    Result<Integer> result = new Result<>();



    result.setCode(ExceptionInfo.valueOf("OK").getCode());

    result.setMessage(ExceptionInfo.valueOf("OK").getMessage());

    result.setData(3);

    Assertions.assertEquals(result,privateChatService.clearList(123456L));

  



  @Test

  void deleteOneTest()



    Result<Integer> result = new Result<>();



    result.setCode(ExceptionInfo.valueOf("USER_DIALOG_ID_NULL").getCode());

    result.setMessage(ExceptionInfo.valueOf("USER_DIALOG_ID_NULL").getMessage());



    Assertions.assertEquals(result,privateChatService.deleteOne(123456L,null));



    result.setCode(ExceptionInfo.valueOf("OK").getCode());

    result.setMessage(ExceptionInfo.valueOf("OK").getMessage());

    result.setData(1);

    Assertions.assertEquals(result,privateChatService.deleteOne(123456L,3L));

  

• 小螃蟹411

完成issue

//组局评论分级展示
for (PartyComment partyComment : partyComments) 
  // 当前评论为父评论
  if (partyComment.getId().equals(partyComment.getPreId())) 
    Map<String, Object> map = new HashMap<>();
    map.put("commentId", partyComment.getId());
    map.put("commentUserId", partyComment.getIdFrom());
    User user = userMapper.selectById(partyComment.getIdFrom());
    map.put("commentUsername", user.getUsername());
    map.put("images", user.getUserIconUrl());
    List<Map<String, Object>> childrenList = new LinkedList<>();
    for (PartyComment comment : partyComments) 
      // 当前评论不为父评论，且为当前父评论的子评论
      if (!comment.getId().equals(partyComment.getId()) && comment.getPreId()
          .equals(partyComment.getId())) 
        Map<String, Object> childrenMap = new HashMap<>();
        childrenMap.put("commentId", comment.getId());
        childrenMap.put("commentUserId", comment.getIdFrom());
        User user1 = userMapper.selectById(comment.getIdFrom());
        childrenMap.put("commentUsername", user1.getUsername());
        childrenMap.put("images", user1.getUserIconUrl());
        childrenMap.put("message", comment.getInformation());
        childrenMap.put("preId", comment.getPreId());
        map.put("gmtCreate", comment.getGmtCreate());
        childrenMap.put("replyId", partyComment.getIdFrom());
        childrenList.add(childrenMap);
      
    
    map.put("childrenComments", childrenList);
    map.put("message", partyComment.getInformation());
    map.put("preId", partyComment.getPreId());
    map.put("gmtCreate", partyComment.getGmtCreate());
    mapList.add(map);
  

会议图片

PM报告

工作总结

• 预期工作量：47 /68issue

• 目前已完成工作量：47 issue

• 今日完成工作量： 20 issu

• 前端

• 完成issue1

• 完成issue2

• 完成issue3

• 完成issue4

• 完成issue5

• 完成issue6

• 完成issue7

• 完成issue8

• 完成issue9

• 完成issue10

• 完成issue11

• 完成issue12

• 完成issue13

• 完成issue14

• 完成issue15

• 后端

• 完成issue1

• 完成issue2

• 完成issue3

• 完成issue4

• 完成issue5

• 剩余共工作量 21 issue

项目燃尽图

（由于一个仓库里的燃尽图在导入时候必须放到同一个milestone当中，所以是α和β冲刺的结合燃尽图，请从Jun六月开始查看）

任务总量变化

最新项目截图

头像私聊框

组局详情

组员移除

加入组局

评论组局

嵌套评论