package models import "rdluck_tools/orm" type AdminItem struct { AdminId int `description:"系统用户id"` RealName string `description:"系统用户姓名"` Mobile string `description:"手机号"` RoleType int `description:"角色类型:1需要录入指标,0:不需要"` RoleId int `description:"角色id"` RoleName string `description:"角色名称"` RoleTypeCode string `description:"角色编码"` DepartmentId int `description:"部门id"` DepartmentName string `json:"-" description:"部门名称"` GroupId int `description:"分组id"` GroupName string `json:"-" description:"分组名称"` Authority int `description:"管理权限,0:无,1:部门负责人,2:小组负责人"` } func GetSellerByCompanyId(companyId int) (item *AdminItem, err error) { o := orm.NewOrm() sql := ` SELECT b.* FROM company_product AS a INNER JOIN admin AS b ON a.seller_id=b.admin_id WHERE a.company_id=? AND a.product_id=2 ` err = o.Raw(sql, companyId).QueryRow(&item) return }