calendar.go 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. package roadshow
  2. type Researcher struct {
  3. AdminId int `description:"研究员id"`
  4. RealName string `description:"研究员名称"`
  5. GroupId int `description:"分组id"`
  6. GroupName string `description:"分组名称"`
  7. RoleTypeCode string `description:"角色编码"`
  8. }
  9. type ResearcherGroup struct {
  10. GroupId int `description:"分组id"`
  11. GroupName string `description:"分组名称"`
  12. ResearcherList []*Researcher
  13. }
  14. //func GetResearcherGroup() (list []*ResearcherGroup, err error) {
  15. // o := orm.NewOrm()
  16. // sql := ` SELECT group_id,group_name FROM admin AS a
  17. // WHERE a.role_type_code IN('researcher','ficc_researcher','ficc_admin')
  18. // AND a.enabled=1
  19. // AND a.group_id>0
  20. // AND a.group_name<>'无'
  21. // GROUP BY a.group_id
  22. // ORDER BY a.group_id ASC `
  23. // _, err = o.Raw(sql).QueryRows(&list)
  24. // return
  25. //}
  26. //func GetResearcher() (list []*Researcher, err error) {
  27. // o := orm.NewOrm()
  28. // //sql := ` SELECT * FROM admin AS a
  29. // // WHERE a.role_type_code IN('researcher','rai_researcher','ficc_researcher','ficc_admin')
  30. // // AND a.enabled=1 AND a.real_name<>'于菲' `
  31. // sql := ` SELECT * FROM admin AS a WHERE a.enabled=1 `
  32. // _, err = o.Raw(sql).QueryRows(&list)
  33. // return
  34. //}