MessageCenter/rpc/internal/common/MaterialService.go

package common

import (
	"app.yhyue.com/moapp/MessageCenter/entity"
	"github.com/gogf/gf/v2/util/gconv"
	"strings"
)

func MaterialDetail(msgId, positionId int64) (dataMap map[string]interface{}) {
	//查询到内容
	dataMap = map[string]interface{}{}
	data := entity.Mysql.SelectBySql("SELECT a.id,a.title,a.content,a.createtime,a.id,a.group_id,a.link,a.msg_type,b.file_url,b.material_content,b.qrcode_url,b.task_description,b.task_name FROM jianyu.message_send_log a LEFT JOIN bi_service.operating_materials b ON a.id = b.msg_id WHERE a.id = ?", msgId)
	if data != nil && len(*data) > 0 {
		dataMap = (*data)[0]
		//查询图片信息
		attArr := []string{}
		res := entity.Mysql.Find("operating_materials_attachment", map[string]interface{}{"msg_id": msgId, "position_id": positionId}, "file_url", "id asc", -1, -1)
		if res != nil && len(*res) > 0 {
			for _, v := range *res {
				attArr = append(attArr, gconv.String(v["file_url"]))
			}
			dataMap["attUrl"] = strings.Join(attArr, ",")
		} else {
			dataMap["attUrl"] = ""
		}
		return dataMap
	}
	return nil

}