datatools/telemarketingEtl/entity/entity.go

package entity

import (
	"telemarketingEtl/config"

	"github.com/gogf/gf/v2/util/gconv"
)

// 平台
const (
	APP = iota + 1
	PC
	WX
	//
	DWD_F_USERBASE_EVENT_INFO = "dwd_f_userbase_event_info"
	DWD_F_USERBASE_VISIT_INFO = "dwd_f_userbase_visit_info"

	BUYPORTRAIT     = "采购单位画像"
	INFO            = "标讯三级页"
	ENTPORTRAIT     = "企业画像"
	LOGIN           = "登录"
	COLLECTION      = "标讯收藏"
	PRODUCTINDEX    = "会员介绍页面"
	CLIENT          = "客户监控"
	PROJECTPROGRESS = "项目进度监控"
	ENTFOLLOW       = "企业情报监控"
	FORECAST        = "潜在项目预测"
	ENTSEARCH       = "企业搜索"
)

// 根据职位id获取mongodb userid
func GetUserIdByPositionId(positionId string) (userId, uid string) {
	if positionId == "" || positionId == "0" {
		return
	}
	i_positionId := gconv.Int(positionId)
	if i_positionId == 0 {
		return
	}
	data := config.JianyuSubjectdb.SelectBySql(`select userid,uid from dwd_f_userbase_id_mapping where position_id =? limit 1`, i_positionId)
	if data == nil || len(*data) <= 0 {
		return
	}
	userId = gconv.String((*data)[0]["userid"])
	uid = gconv.String((*data)[0]["uid"])
	return
}