package fe_calendar
import (
"eta_gn/eta_api/global"
"eta_gn/eta_api/utils"
"fmt"
"strings"
"time"
)
const (
MatterTypeFree = 1 // 事项类型-自定义事项
MatterTypeEdb = 2 // 事项类型-基础指标
MatterTypePredict = 3 // 事项类型-预测指标
)
type FeCalendarMatter struct {
FeCalendarMatterId int `gorm:"primaryKey;column:fe_calendar_matter_id;type:int(10) unsigned;not null"` // 事项Id
ChartPermissionId int `gorm:"index:idx_chart_permission_id;column:chart_permission_id;type:int(10) unsigned;not null;default:0"` // 品种Id
ChartPermissionName string `gorm:"column:chart_permission_name;type:varchar(128);not null;default:''"` // 品种名称
MatterMonth string `gorm:"index:idx_matter_month;column:matter_month;type:varchar(16);not null;default:''"` // 事项年月：格式2006-01
MatterDate time.Time `gorm:"index:idx_matter_date;column:matter_date;type:date"` // 事项日期
Title string `gorm:"column:title;type:varchar(255);not null;default:''"` // 标题
MatterType int `gorm:"column:matter_type;type:tinyint(4) unsigned;not null;default:0"` // 事项类型：1-自定义事项；2-基础指标；3-预测指标
EdbInfoId int `gorm:"column:edb_info_id;type:int(10) unsigned;not null;default:0"` // 指标Id
EdbUniqueCode string `gorm:"column:edb_unique_code;type:varchar(128);not null;default:''"` // 指标唯一编码
EdbCode string `gorm:"column:edb_code;type:varchar(128);not null;default:''"` // 指标编码
FontColor string `gorm:"column:font_color;type:varchar(64);not null;default:''"` // 字体颜色
FillingColor string `gorm:"column:filling_color;type:varchar(64);not null;default:''"` // 填充颜色
FontBold int `gorm:"column:font_bold;type:tinyint(4) unsigned;not null;default:0"` // 字体加粗：0-否；1-是
Sort int `gorm:"column:sort;type:int(10) unsigned;not null;default:0"` // 排序
SysUserId int `gorm:"column:sys_user_id;type:int(10) unsigned;not null;default:0"` // 创建人Id
SysUserName string `gorm:"column:sys_user_name;type:varchar(128);not null;default:''"` // 创建人姓名
CreateTime time.Time `gorm:"column:create_time;type:datetime"` // 创建时间
ModifyTime time.Time `gorm:"column:modify_time;type:datetime"` // 更新时间
}
var FeCalendarMatterCols = struct {
FeCalendarMatterId string
ChartPermissionId string
ChartPermissionName string
MatterMonth string
MatterDate string
Title string
MatterType string
EdbInfoId string
EdbUniqueCode string
EdbCode string
FontColor string
FillingColor string
FontBold string
Sort string
SysUserId string
SysUserName string
CreateTime string
ModifyTime string
}{
FeCalendarMatterId: "fe_calendar_matter_id",
ChartPermissionId: "chart_permission_id",
ChartPermissionName: "chart_permission_name",
MatterMonth: "matter_month",
MatterDate: "matter_date",
Title: "title",
MatterType: "matter_type",
EdbInfoId: "edb_info_id",
EdbUniqueCode: "edb_unique_code",
EdbCode: "edb_code",
FontColor: "font_color",
FillingColor: "filling_color",
FontBold: "font_bold",
Sort: "sort",
SysUserId: "sys_user_id",
SysUserName: "sys_user_name",
CreateTime: "create_time",
ModifyTime: "modify_time",
}
func (m *FeCalendarMatter) TableName() string {
return "fe_calendar_matter"
}
func (m *FeCalendarMatter) PrimaryId() string {
return FeCalendarMatterCols.FeCalendarMatterId
}
func (m *FeCalendarMatter) GetItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string) (items []*FeCalendarMatter, err error) {
fields := strings.Join(fieldArr, ",")
if len(fieldArr) == 0 {
fields = `*`
}
order := fmt.Sprintf(`ORDER BY %s DESC`, FeCalendarMatterCols.CreateTime)
if orderRule != "" {
order = ` ORDER BY ` + orderRule
}
sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s`, fields, m.TableName(), condition, order)
err = global.DmSQL["data"].Raw(sql, pars...).Find(&items).Error
return
}
type FeCalendarMatterItem struct {
FeCalendarMatterId int `description:"事项ID"`
ChartPermissionId int `description:"品种ID"`
ChartPermissionName string `description:"品种名称"`
MatterDate string `description:"事项日期"`
Title string `description:"标题"`
MatterType int `description:"事项类型：1-自定义事项；2-基础指标；3-预测指标"`
EdbInfoId int `description:"指标ID"`
EdbUniqueCode string `description:"指标唯一编码"`
EdbCode string `description:"指标编码"`
FontColor string `description:"字体颜色"`
FillingColor string `description:"填充颜色"`
FontBold int `description:"字体加粗：0-否；1-是"`
Sort int `description:"排序"`
}
func FormatFeCalendarMatter2Item(origin *FeCalendarMatter) (item *FeCalendarMatterItem) {
if origin == nil {
return
}
item = new(FeCalendarMatterItem)
item.FeCalendarMatterId = origin.FeCalendarMatterId
item.ChartPermissionId = origin.ChartPermissionId
item.ChartPermissionName = origin.ChartPermissionName
item.MatterDate = utils.TimeTransferString(utils.FormatDate, origin.MatterDate)
item.Title = origin.Title
item.MatterType = origin.MatterType
item.EdbInfoId = origin.EdbInfoId
item.EdbUniqueCode = origin.EdbUniqueCode
item.EdbCode = origin.EdbCode
item.FontColor = origin.FontColor
item.FillingColor = origin.FillingColor
item.FontBold = origin.FontBold
item.Sort = origin.Sort
return
}
type FeCalendarMatterListReq struct {
ChartPermissionId int `form:"ChartPermissionId" description:"品种ID"`
StartDate string `form:"StartDate" description:"开始日期"`
EndDate string `form:"EndDate" description:"结束日期"`
}
type FeCalendarMatterListItem struct {
Date string `description:"日期"`
Matters []*FeCalendarMatterItem `description:"日期事项"`
}
type FeCalendarMatterSaveReq struct {
ChartPermissionId int `description:"品种ID"`
MatterDate string `description:"日期"`
Matters []*FeCalendarMatterSaveItem `description:"事项"`
}
type FeCalendarMatterSaveItem struct {
FeCalendarMatterId int `description:"事项ID"`
Title string `description:"标题"`
MatterType int `description:"事项类型：1-自定义事项；2-基础指标；3-预测指标"`
EdbInfoId int `description:"指标ID"`
EdbUniqueCode string `description:"指标唯一编码"`
EdbCode string `description:"指标编码"`
FontColor string `description:"字体颜色"`
FillingColor string `description:"填充颜色"`
FontBold int `description:"字体加粗：0-否；1-是"`
Sort int `description:"排序"`
}
func (m *FeCalendarMatter) Save(addMatters, editMatters, removeMatters []*FeCalendarMatter, updateCols []string) (err error) {
tx := global.DmSQL["data"].Begin()
defer func() {
if err != nil {
_ = tx.Rollback()
return
}
_ = tx.Commit()
}()
if len(addMatters) > 0 {
e := tx.CreateInBatches(addMatters, utils.MultiAddNum).Error
if e != nil {
err = fmt.Errorf("insert multi err: %v", e)
return
}
}
if len(editMatters) > 0 {
for _, v := range editMatters {
e := tx.Select(updateCols).Updates(v).Error
if e != nil {
err = fmt.Errorf("update err: %v", e)
return
}
}
}
if len(removeMatters) > 0 {
sql := fmt.Sprintf(`DELETE FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.PrimaryId())
for _, v := range removeMatters {
e := tx.Exec(sql, v.FeCalendarMatterId).Error
if e != nil {
err = fmt.Errorf("remove exec err: %v", e)
return
}
}
}
return
}