123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157 |
- package MessageHandlers
- import (
- "context"
- "encoding/json"
- "entgo.io/ent/dialect/sql"
- "fmt"
- "github.com/zeromicro/go-zero/core/logx"
- "strconv"
- "time"
- "wechat-api/ent"
- "wechat-api/ent/label"
- "wechat-api/ent/labellog"
- "wechat-api/ent/wx"
- "wechat-api/internal/pkg/wechat_ws"
- "wechat-api/internal/svc"
- "wechat-api/workphone"
- )
- type ContactLabelInfoNotice struct {
- svcCtx *svc.ServiceContext
- }
- func NewContactLabelInfoNotice(svcCtx *svc.ServiceContext) *ContactLabelInfoNotice {
- return &ContactLabelInfoNotice{
- svcCtx: svcCtx,
- }
- }
- // Handle 实现 MessageHandlerStrategy 接口
- func (f *ContactLabelInfoNotice) Handle(ctx context.Context, msg *wechat_ws.MsgJsonObject, svcCtx *svc.ServiceContext) error {
- var message workphone.ContactLabelInfoNoticeMessage
- logx.Infof("msg.Message 的内容是:%s", msg.Message)
- if err := json.Unmarshal([]byte(msg.Message), &message); err != nil {
- return err
- }
- wxInfo, err := svcCtx.DB.Wx.Query().
- Where(wx.WxidEQ(message.WeChatId)).
- Only(ctx)
- if err != nil {
- return err
- }
- // 整理标签ID和名称列表
- labelIDs := make([]int, 0, len(message.Labels))
- labelNameSet := make(map[string]struct{}) // 用于去重
- for _, labelInfoMessage := range message.Labels {
- labelIDs = append(labelIDs, int(labelInfoMessage.LabelId))
- labelNameSet[labelInfoMessage.LabelName] = struct{}{}
- }
- // 提前查询现有 LabelLog 和 Label
- existingLabelLogs, err := svcCtx.DB.LabelLog.Query().
- Where(
- labellog.LabelIDIn(labelIDs...),
- labellog.OrganizationID(wxInfo.OrganizationID),
- labellog.WxID(message.WeChatId),
- ).
- Select(labellog.FieldLabelID).
- All(ctx)
- if err != nil {
- return fmt.Errorf("查询 LabelLog 失败: %w", err)
- }
- existingLabels, err := svcCtx.DB.Label.Query().
- Where(
- label.NameIn(keysFromMap(labelNameSet)...),
- label.OrganizationID(wxInfo.OrganizationID),
- ).
- Select(label.FieldName).
- All(ctx)
- if err != nil {
- return fmt.Errorf("查询 Label 失败: %w", err)
- }
- existingLabelLogMap := make(map[int]struct{})
- for _, log := range existingLabelLogs {
- existingLabelLogMap[log.LabelID] = struct{}{}
- }
- existingLabelMap := make(map[string]struct{})
- for _, lab := range existingLabels {
- existingLabelMap[lab.Name] = struct{}{}
- }
- var bulkLabelLogs []*ent.LabelLogCreate
- var bulkLabels []*ent.LabelCreate
- for _, labelWx := range message.Labels {
- // 时间戳处理
- tsInt, err := strconv.ParseInt(labelWx.CreateTime, 10, 64)
- if err != nil {
- logx.Errorf("时间戳转换失败: %v (Label ID: %d)", err, labelWx.LabelId)
- continue
- }
- // 插入 LabelLog
- if _, exists := existingLabelLogMap[int(labelWx.LabelId)]; !exists {
- bulkLabelLogs = append(bulkLabelLogs,
- svcCtx.DB.LabelLog.Create().
- SetLabelName(labelWx.LabelName).
- SetLabelID(int(labelWx.LabelId)).
- SetOrganizationID(wxInfo.OrganizationID).
- SetWxID(message.WeChatId).
- SetCreatedAt(time.Unix(tsInt/1000, 0)),
- )
- }
- // 插入 Label
- if _, exists := existingLabelMap[labelWx.LabelName]; !exists {
- bulkLabels = append(bulkLabels,
- svcCtx.DB.Label.Create().
- SetName(labelWx.LabelName).
- SetType(1).
- SetStatus(1).
- SetOrganizationID(wxInfo.OrganizationID).
- SetFrom(2).
- SetMode(1).
- SetConditions(`{}`).
- SetCreatedAt(time.Now()).
- SetUpdatedAt(time.Now()),
- )
- }
- }
- // 批量插入 LabelLog
- if len(bulkLabelLogs) > 0 {
- err := svcCtx.DB.LabelLog.CreateBulk(bulkLabelLogs...).
- OnConflict(sql.ConflictColumns(labellog.FieldLabelID, labellog.FieldWxID, labellog.FieldOrganizationID)).
- DoNothing().
- Exec(ctx)
- if err != nil {
- logx.Error("labelLog 批量插入失败", bulkLabelLogs)
- }
- }
- // 批量插入 Label
- if len(bulkLabels) > 0 {
- err := svcCtx.DB.Label.CreateBulk(bulkLabels...).
- OnConflict(sql.ConflictColumns(label.FieldName, label.FieldOrganizationID)).
- DoNothing().
- Exec(ctx)
- if err != nil {
- logx.Error("label 批量插入失败", bulkLabels)
- return err
- }
- }
- return nil
- }
- func keysFromMap(m map[string]struct{}) []string {
- keys := make([]string, 0, len(m))
- for k := range m {
- keys = append(keys, k)
- }
- return keys
- }
|