hongze_yb/models/tables/my_chart/query.go

package my_chart

import (
	"hongze/hongze_yb/global"
	"time"
)

type MyChartList struct {
	MyChartId           int		`description:"我的图表主键"`
	ChartInfoId         int
	ChartName           string	`description:"来源名称"`
	ChartClassifyId     int		`description:"图表分类id"`
	SysUserId           int
	SysUserRealName     string
	UniqueCode          string	`description:"图表唯一编码"`
	CreateTime          time.Time
	ModifyTime          time.Time
	DateType            int		`description:"日期类型:1:00年至今,2:10年至今,3:15年至今，4：年初至今，5:自定义时间"`
	StartDate           string	`description:"自定义开始日期"`
	EndDate             string	`description:"自定义结束日期"`
	IsSetName           int		`description:"设置名称"`
	EdbInfoIds          string	`description:"指标id"`
	ChartType           int		`description:"生成样式:1:曲线图,2:季节性图"`
	Calendar            string	`description:"公历/农历"`
	SeasonStartDate     string	`description:"季节性图开始日期"`
	SeasonEndDate       string	`description:"季节性图开始日期"`
	ChartImage          string	`description:"图表图片"`
	Sort                int		`description:"排序字段，数字越小越排前面"`
	IsAdd               bool	`description:"true:已加入我的图库,false:未加入我的图库"`
	MyChartClassifyName string	`description:"分类名称，多个用英文逗号分割"`
	MyChartClassifyId   string	`description:"分类id，多个用英文逗号分割"`
	EdbEndDate          string	`description:"指标最新更新日期"`
}

// GetMyChartListByCondition 条件获取图库列表
func GetMyChartListByCondition(condition string, pars []interface{}, page, limit int) (list []*MyChartList, err error) {
	sql := ` SELECT a.my_chart_id,c.sort,b.* FROM my_chart AS a
			INNER JOIN chart_info AS b ON a.chart_info_id=b.chart_info_id
			INNER JOIN my_chart_classify_mapping AS c ON a.my_chart_id=c.my_chart_id
			INNER JOIN my_chart_classify AS d ON c.my_chart_classify_id=d.my_chart_classify_id
			WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	sql += " GROUP BY a.chart_info_id ORDER BY c.sort ASC LIMIT ?,? "
	offset := (page - 1) * limit
	pars = append(pars, offset, limit)
	err = global.MYSQL["data"].Raw(sql, pars).Scan(&list).Error

	return
}