MessageCenter/rpc/internal/common/getBuoyMsg.go

package common

import (
	"app.yhyue.com/moapp/MessageCenter/entity"
	"app.yhyue.com/moapp/MessageCenter/rpc/type/message"
	"app.yhyue.com/moapp/MessageCenter/util"
	"fmt"
	"log"
	"strconv"
	"strings"
)

func FindUserBuoyMsg(this *message.FindUserBuoyMsgReq) *message.FindUserBuoyMsgRes {
	var err error
	data := message.FindUserBuoyMsgRes{}
	res := entity.Mysql.SelectBySql(fmt.Sprintf(`SELECT * FROM message WHERE receive_userid = "%s" and isdel = 1 and appid = %s and isRead =0 and show_buoy = 1 and show_content != "" ORDER BY createtime DESC  LIMIT 0,%d`, this.UserId, this.Appid, int(this.PageSize)))
	//log.Println("数据：", res)
	if res != nil && len(*res) > 0 {
		for _, v := range *res {
			_id := util.Int64All(v["id"])
			id := strconv.FormatInt(_id, 10)
			links2 := util.ObjToString((v["link"]))
			link2, androidUrl2, iosUrl2, weChatUrl2 := LinkSplit(links2)

			data.Data = append(data.Data, &message.BuoyMessages{
				Id:         id,
				BuoyDetail: util.ObjToString(v["show_content"]),
				PcUrl:      link2,
				AndroidUrl: androidUrl2,
				IosUrl:     iosUrl2,
				WeChatUrl:  weChatUrl2,
			})
		}
	}
	if err == nil {
		data.Code = 0
		data.Message = "查询成功"
	} else {
		data.Code = 1
		data.Message = "查询失败"
	}
	return &data
}
func LinkSplit(url string) (link, androidUrl, iosUrl, weChatUrl string) {

	if url != "" {
		arr := strings.Split(url, ",")
		if len(arr) == 4 {
			link = arr[0]
			androidUrl = arr[1]
			iosUrl = arr[2]
			weChatUrl = arr[3]
		} else {
			if len(arr) > 0 {
				link = arr[0]
			} else {
				link = ""
			}
			androidUrl = ""
			iosUrl = ""
			weChatUrl = ""
		}
	}
	return link, androidUrl, iosUrl, weChatUrl
}

func ClearUnreadMsg(in *message.ClearUnreadMsgReq) error {
	if in.Userid != "" {
		query := map[string]interface{}{
			"receive_userid": in.Userid,
			"appid":          in.AppId,
			"isdel":          1,
			"isRead":         0,
		}

		//更新服务未读数
		if !entity.Mysql.Update("message", query, map[string]interface{}{"isRead": 1}) {
			log.Println("更新服务未读数失败")
		}
	}

	//更新私信未读数
	if in.PositionId > 0 {
		sQuery := map[string]interface{}{
			"my_position_id": in.PositionId,
			"ent_id":         in.EntId,
		}
		if !entity.Mysql.Update("socialize_summary", sQuery, map[string]interface{}{"unread": 0}) {
			log.Println("更新私信未读数失败")
		}
	}

	return nil
}