query.go 670 B

12345678910111213141516171819
  1. package predict_edb_rule_data
  2. import "hongze/hongze_yb/global"
  3. // GetPredictEdbRuleDataList 根据基础预测指标id集合 获取 所有的普通指标列表数据
  4. func GetPredictEdbRuleDataList(edbInfoId, configId int, startDate, endDate string) (list []*PredictEdbRuleData, err error) {
  5. var whereStr string
  6. var pars []interface{}
  7. if startDate != "" {
  8. whereStr += ` AND data_time>=? `
  9. pars = append(pars, startDate)
  10. }
  11. if endDate != "" {
  12. whereStr += ` AND data_time<=? `
  13. pars = append(pars, endDate)
  14. }
  15. err = global.MYSQL["data"].Where("edb_info_id = ? AND config_id = ? ", edbInfoId, configId, pars).Order("data_time ASC").Find(&list).Error
  16. return
  17. }