开源在线客服系统-客服系统历史消息记录功能-点击加载历史聊天记录-分页展示历史消息功能实现

        //获取信息列表
        getHistoryMessage:function(){
            let params={
                page:this.messages.page,
                pagesize: this.messages.pagesize,
                visitor_id: this.visitor.visitor_id,
            }
            let _this=this;
            $.get("/2/messagesPages",params,function(res){
                let msgList=res.result.list;
                if(msgList.length>=_this.messages.pagesize){
                    _this.showLoadMore=true;
                }else{
                    _this.showLoadMore=false;
                }
                for(let i in msgList){
                    let item = msgList[i];
                    let content = {}
                    if (item["mes_type"] == "kefu") {
                        item.is_kefu = true;
                        item.avator=item["kefu_avator"];

                    } else {
                        item.is_kefu = false;
                        item.avator=item["visitor_avator"];
                    }
                    item.time = item["create_time"];
                    _this.msgList.unshift(item);
                }
                if(_this.messages.page==1){
                    _this.scrollBottom();
                }
                _this.messages.page++;
            });
        },

func GetMessagespages(c *gin.Context) {
    visitorId := c.Query("visitor_id")
    page, _ := strconv.Atoi(c.DefaultQuery("page", "1"))
    pageSize, _ := strconv.Atoi(c.DefaultQuery("pagesize", "10"))
    if pageSize > 20 {
        pageSize = 20
    }
    count := models.CountMessage("visitor_id = ?", visitorId)
    list := models.FindMessageByPage(uint(page), uint(pageSize), "message.visitor_id = ?", visitorId)
    c.JSON(200, gin.H{
        "code": 200,
        "msg":  "ok",
        "result": gin.H{
            "count":    count,
            "page":     page,
            "list":     list,
            "pagesize": pageSize,
        },
    })
}

//查询条数
func CountMessage(query interface{}, args ...interface{}) uint {
    var count uint
    DB.Model(&Message{}).Where(query, args...).Count(&count)
    return count
}
//分页查询
func FindMessageByPage(page uint, pagesize uint, query interface{}, args ...interface{}) []*MessageKefu {
    offset := (page - 1) * pagesize
    if offset < 0 {
        offset = 0
    }
    var messages []*MessageKefu
    DB.Table("message").Select("message.*,visitor.avator visitor_avator,visitor.name visitor_name,user.avator kefu_avator,user.nickname kefu_name").Offset(offset).Joins("left join user on message.kefu_id=user.name").Joins("left join visitor on visitor.visitor_id=message.visitor_id").Where(query, args...).Limit(pagesize).Order("message.id desc").Find(&messages)
    for _, mes := range messages {
        mes.CreateTime = mes.CreatedAt.Format("2006-01-02 15:04:05")
    }
    return messages
}