hongze_cygxzs/models/report_mapping.go

package models

import (
	"github.com/beego/beego/v2/client/orm"
	"hongze/hongze_cygxzs/utils"
)

type ReportMappingResp struct {
	CategoryId      int    `description:"分类ID"`
	SubCategoryName string `description:"主题名称"`
	MatchTypeName   string `description:"匹配类型"`
	IsRed           bool   `description:"是否标红"`
}

// 获取策略下面的所有分类
func GetReportMappingStrategyAll() (items []*IndustrialManagementRep, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := `SELECT
			match_type_name AS industry_name,
			category_id AS industrial_management_id,
			chart_permission_id
			FROM
				cygx_report_mapping 
			WHERE
				report_type = 1 
				AND chart_permission_name IN ('策略','固收')
			ORDER BY
				sort ASC `
	_, err = o.Raw(sql).QueryRows(&items)
	return
}

// 获取策略下面的所有分类
func GetReportMappingStrategyAllGuShou() (items []*IndustrialManagementRep, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := `SELECT
			match_type_name AS industry_name,
			category_id AS industrial_management_id,
			chart_permission_id
			FROM
				cygx_report_mapping 
			WHERE
				report_type = 1 
				AND chart_permission_name = ? 
			ORDER BY
				sort ASC `
	_, err = o.Raw(sql, utils.GU_SHOU_NAME).QueryRows(&items)
	return
}