eta_api/models/user_seller_relation.go

package models

import (
	"eta_gn/eta_api/global"
	"time"
)

type UserSellerRelation struct {
	RelationId int64     `gorm:"column:relation_id;primaryKey;type:bigint" orm:"column(relation_id);pk" gorm:"primaryKey"  description:"关系ID"`
	UserId     int       `gorm:"column:user_id;type:int" orm:"column(user_id)" description:"用户ID"`
	CompanyId  int       `gorm:"column:company_id;type:int" orm:"column(company_id)" description:"企业用户ID"`
	SellerId   int       `gorm:"column:seller_id;type:int" orm:"column(seller_id)" description:"销售ID"`
	Seller     string    `gorm:"column:seller;type:varchar(255)" orm:"column(seller)" description:"销售员名称"`
	ProductId  int       `gorm:"column:product_id;type:int" orm:"column(product_id)" description:"产品ID"`
	Mobile     string    `gorm:"column:mobile;type:varchar(255)" orm:"column(mobile)" description:"手机号"`
	Email      string    `gorm:"column:email;type:varchar(255)" orm:"column(email)" description:"邮箱"`
	ModifyTime time.Time `gorm:"column:modify_time;type:datetime" orm:"column(modify_time)" description:"修改时间"`
	CreateTime time.Time `gorm:"column:create_time;type:datetime" orm:"column(create_time)" description:"创建时间"`
}

// DeleteUserSellerRelationByProductId 根据产品id删除销售员与员工的关系
func DeleteUserSellerRelationByProductId(userId, productId int) (err error) {
	sql := ` DELETE FROM user_seller_relation WHERE user_id=? and product_id = ?`
	err = global.DmSQL["weekly"].Exec(sql, userId, productId).Error
	return
}