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
}