1
0
forked from lxh/go-wxhelper
go-wxhelper/tasks/water_group.go

88 lines
2.2 KiB
Go
Raw Permalink Normal View History

2023-09-21 17:33:59 +08:00
package tasks
import (
2023-09-25 14:16:59 +08:00
"fmt"
2023-09-21 17:33:59 +08:00
"go-wechat/client"
2023-10-11 09:21:07 +08:00
"go-wechat/config"
2023-09-21 17:33:59 +08:00
"go-wechat/entity"
2023-10-11 09:51:33 +08:00
"go-wechat/utils"
2023-09-21 17:33:59 +08:00
"log"
2023-09-25 14:16:59 +08:00
"strings"
2023-09-21 17:33:59 +08:00
)
// 水群排行榜
// yesterday
// @description: 昨日排行榜
func yesterday() {
2023-10-11 09:21:07 +08:00
for _, id := range config.Conf.Task.WaterGroup.Groups {
2023-09-25 14:16:59 +08:00
dealYesterday(id)
}
}
// dealYesterday
// @description: 处理请求
// @param gid
func dealYesterday(gid string) {
notifyMsgs := []string{"#昨日水群排行榜"}
2023-09-21 17:33:59 +08:00
// 获取昨日消息总数
var yesterdayMsgCount int64
2023-10-11 09:21:07 +08:00
err := client.MySQL.Model(&entity.Message{}).
2023-09-25 14:16:59 +08:00
Where("from_user = ?", gid).
2023-09-21 17:33:59 +08:00
Where("DATEDIFF(create_at,NOW()) = -1").
Count(&yesterdayMsgCount).Error
if err != nil {
log.Printf("获取昨日消息总数失败, 错误信息: %v", err)
return
}
log.Printf("昨日消息总数: %d", yesterdayMsgCount)
2023-09-25 14:16:59 +08:00
if yesterdayMsgCount == 0 {
return
}
notifyMsgs = append(notifyMsgs, " ")
notifyMsgs = append(notifyMsgs, fmt.Sprintf("昨日消息总数: %d", yesterdayMsgCount))
2023-09-21 17:33:59 +08:00
// 返回数据
type record struct {
GroupUser string
2023-09-25 14:16:59 +08:00
Nickname string
2023-09-21 17:33:59 +08:00
Count int64
}
var records []record
tx := client.MySQL.Table("t_message AS tm").
2023-09-26 15:01:44 +08:00
Joins("LEFT JOIN t_group_user AS tgu ON tgu.wxid = tm.group_user AND tm.from_user = tgu.group_id").
2023-09-25 14:16:59 +08:00
Select("tm.group_user", "tgu.nickname", "count( 1 ) AS `count`").
Where("tm.from_user = ?", gid).
2023-10-07 09:41:40 +08:00
Where("tm.type < 10000").
2023-09-25 14:16:59 +08:00
Where("DATEDIFF(tm.create_at,NOW()) = -1").
Group("tm.group_user, tgu.nickname").Order("`count` DESC").
Limit(10)
2023-10-11 09:21:07 +08:00
// 黑名单
blacklist := config.Conf.Task.WaterGroup.Blacklist
// 如果有黑名单,过滤掉
if len(blacklist) > 0 {
tx.Where("tm.group_user NOT IN (?)", blacklist)
}
err = tx.Find(&records).Error
2023-09-21 17:33:59 +08:00
if err != nil {
log.Printf("获取昨日消息失败, 错误信息: %v", err)
return
}
2023-09-25 14:16:59 +08:00
notifyMsgs = append(notifyMsgs, " ")
for i, r := range records {
log.Printf("账号: %s[%s] -> %d", r.Nickname, r.GroupUser, r.Count)
notifyMsgs = append(notifyMsgs, fmt.Sprintf("#%d: %s -> %d条", i+1, r.Nickname, r.Count))
2023-09-21 17:33:59 +08:00
}
2023-09-25 14:16:59 +08:00
notifyMsgs = append(notifyMsgs, " \n请未上榜的群友多多反思。")
log.Printf("排行榜: \n%s", strings.Join(notifyMsgs, "\n"))
2023-10-11 09:51:33 +08:00
go utils.SendMessage(gid, "", strings.Join(notifyMsgs, "\n"), 0)
2023-09-21 17:33:59 +08:00
}