package roadshow import ( "eta/eta_api/global" "eta/eta_api/utils" ) type Researcher struct { AdminId int `description:"研究员id"` RealName string `description:"研究员名称"` GroupId int `description:"分组id"` GroupName string `description:"分组名称"` RoleTypeCode string `description:"角色编码"` } type ResearcherGroup struct { GroupId int `description:"分组id"` GroupName string `description:"分组名称"` ResearcherList []*Researcher } func GetResearcherGroup() (list []*ResearcherGroup, err error) { o := global.DbMap[utils.DbNameMaster] sql := ` SELECT group_id,group_name FROM admin AS a WHERE a.role_type_code IN('researcher','ficc_researcher','ficc_admin') AND a.enabled=1 AND a.group_id>0 AND a.group_name<>'无' GROUP BY a.group_id ORDER BY a.group_id ASC ` sql = utils.ReplaceDriverKeywords("", sql) err = o.Raw(sql).Find(&list).Error return } func GetResearcher() (list []*Researcher, err error) { o := global.DbMap[utils.DbNameMaster] //sql := ` SELECT * FROM admin AS a // WHERE a.role_type_code IN('researcher','rai_researcher','ficc_researcher','ficc_admin') // AND a.enabled=1 AND a.real_name<>'于菲' ` sql := ` SELECT * FROM admin AS a WHERE a.enabled=1 ` sql = utils.ReplaceDriverKeywords("", sql) err = o.Raw(sql).Find(&list).Error return }