MessageCenter/rpc/internal/common/messageService.go

package common

import (
	"app.yhyue.com/moapp/MessageCenter/entity"
	"app.yhyue.com/moapp/MessageCenter/rpc/type/message"
	qutil "app.yhyue.com/moapp/jybase/common"
	"app.yhyue.com/moapp/jybase/redis"
	"errors"
	"fmt"
	"log"
	"time"
)

type MessageService struct{}

// 修改消息阅读状态
func (service *MessageService) ChangeReadStatus(data *message.ChangeReadStatusReq) (int64, string) {
	msg := entity.Mysql.FindOne("message", map[string]interface{}{"id": data.Id, "isdel": 1, "appid": data.Appid}, "", "")
	//log.Println("查询到消息：", msg)
	if msg == nil {
		return 0, "该消息不存在"
	}
	b := entity.Mysql.Update("message", map[string]interface{}{"id": data.Id, "isdel": 1}, map[string]interface{}{"isRead": int(data.ReadStatus)})
	if !b {
		return 0, "修改消息阅读状态失败"
	}
	MsgCountMinusOne(qutil.ObjToString((*msg)["receive_userid"]), data.Appid, qutil.Int64All((*msg)["msg_type"]))
	return 1, "修改消息阅读状态成功"
}

// 删除消息
func (service *MessageService) DeleteMessage(id []string, appId string) (int64, string) {
	orm := entity.Engine.NewSession()
	defer orm.Close()
	msg := entity.Mysql.FindOne("message", map[string]interface{}{"id": id, "appid": appId}, "", "")
	if msg == nil {
		return 0, "该消息不存在"
	}
	m := entity.Message{}
	m.Isdel = -1
	count, err := orm.Where("appid=?", appId).In("id", id).Cols("isdel").Update(&m)
	if err != nil || count == 0 {
		log.Println(err)
		orm.Rollback()
		return 0, "删除消息失败"
	}
	err2 := orm.Commit()
	if err2 != nil {
		return 0, "删除消息失败"
	}
	FindUserMsg(message.FindUserMsgReq{
		UserId:   qutil.ObjToString((*msg)["receive_userid"]),
		Appid:    appId,
		OffSet:   1,
		PageSize: 5,
		MsgType:  -1,
		Read:     0,
	}, true)
	return 1, "删除消息成功"
}

// 未读消息合计
func (service *MessageService) CountUnread(userId string, appId string) (int64, string, int) {
	count := 0
	types := entity.Mysql.Find("message_column", map[string]interface{}{}, `"msg_type"`, "", -1, -1)
	if types != nil && len(*types) > 0 {
		for _, v := range *types {
			key := fmt.Sprintf(MsgCountKey, userId, qutil.IntAll(v["msg_type"]))
			if exists, _ := redis.Exists(redisModule, key); exists {
				count += redis.GetInt(redisModule, key)
			}
		}
	}

	return 1, "查询未读消息成功", count
}

// 查询消息详情
func FindMessageDetail(id, msgLogId int64, userId string) (msg *map[string]interface{}, err error) {
	if id > 0 {
		msg = entity.Mysql.FindOne("message", map[string]interface{}{"id": id}, "", "")
	} else {
		msg = entity.Mysql.FindOne("message", map[string]interface{}{"receive_userid": userId, "msg_log_id": msgLogId}, "", "")
	}
	if msg != nil && len(*msg) > 0 {
		return msg, nil
	}
	return nil, errors.New("没有查询到消息")
}

// GetMsgType 消息的分类
func (service *MessageService) GetMsgType() (data []*message.MsgTypes, err error) {
	types := entity.Mysql.SelectBySql("SELECT * FROM `message_column` WHERE msg_type > 0 ORDER BY sequence ASC")
	if types != nil && len(*types) > 0 {
		for _, val := range *types {
			data = append(data, &message.MsgTypes{
				MsgType:         qutil.Int64All(val["msg_type"]),
				Name:            qutil.ObjToString(val["name"]),
				Img:             qutil.ObjToString(val["img"]),
				Code:            qutil.ObjToString(val["switch"]),
				DisplayPlatform: qutil.ObjToString(val["display_platform"]),
			})
		}
		return data, nil
	}
	return nil, nil
}

func (service *MessageService) MsgOpenLog(platFrom, msgLogId int64, userId string) int64 {
	//判断用户是否已经在pc端打开过
	count := entity.Mysql.CountBySql("SELECT COUNT(*) FROM message_open_log WHERE msg_log_id = ? and platform = ? and userid = ?", msgLogId, platFrom, userId)
	if count <= 0 {
		tmp := map[string]interface{}{
			"msg_log_id": msgLogId,
			"platform":   platFrom,
			"userid":     userId,
			"createtime": time.Now().Format("2006-01-02 15:04:05"),
		}
		SaveCache <- tmp
	}
	return 0
}