eta_task/models/data_manage/meeting_probabilities.go

package data_manage

import (
	sql2 "database/sql"
	"eta/eta_task/global"
	"eta/eta_task/utils"
	"gorm.io/gorm"
	"time"
)

// MeetingProbabilities excel表格详情表
type MeetingProbabilities struct {
	MeetingInfoId int       `gorm:"primaryKey"`
	Content       string    `description:"表格内容"`
	ExcelImage    string    `description:"表格图片"`
	DateTime      string    `description:"数据日期"`
	IsDelete      int       `description:"是否删除，0：未删除，1：已删除"`
	ModifyTime    time.Time `description:"最近修改日期"`
	CreateTime    time.Time `description:"创建日期"`
}

func (m *MeetingProbabilities) AfterFind(db *gorm.DB) (err error) {
	m.DateTime = utils.GormDateStrToDateStr(m.DateTime)
	return
}

type MeetingProbabilitiesResp struct {
	Ret     int
	Msg     string
	ErrMsg  string
	ErrCode string
	Data    []*MeetingProbabilities
}

// AddMeetingProbabilities 新增表格
func AddMeetingProbabilities(meetingInfo *MeetingProbabilities) (newId int, err error) {
	o := global.DbMap[utils.DbNameIndex]
	// 表格信息入库
	err = o.Create(meetingInfo).Error
	if err != nil {
		return
	}
	newId = meetingInfo.MeetingInfoId
	return
}

func GetMeetingProbabilitiesAll(dateStr string) (list []*MeetingProbabilities, err error) {
	o := global.DbMap[utils.DbNameIndex]
	sql := `SELECT * FROM meeting_probabilities WHERE date_time>=?`
	err = o.Raw(sql, dateStr).Find(&list).Error
	return
}

type ISheet struct {
	ScrollTop            int             `json:"scrollTop"`
	ScrollLeft           int             `json:"scrollLeft"`
	Index                string          `json:"index"`
	Status               int             `json:"status"`
	JfGirdSelectSave     []struct{}      `json:"jfgird_select_save"`
	LuckySheetSelectSave []struct{}      `json:"luckysheet_select_save"`
	Data                 [][]interface{} `json:"data"`
	Config               map[string]struct {
	} `json:"config"`
	VisibleDataRow           []int            `json:"visibledatarow"`
	VisibleDataColumn        []int            `json:"visibledatacolumn"`
	ChWidth                  int              `json:"ch_width"`
	RhHeight                 int              `json:"rh_height"`
	LuckySheetSelectionRange []int            `json:"luckysheet_selection_range"`
	ZoomRatio                int              `json:"zoomRatio"`
	CellData                 []ISheetCellData `json:"celldata"`
}
type ISheetData struct {
	M  string       `json:"m"`
	Ct ISheetDataCt `json:"ct"`
	V  string       `json:"v"`
}

type ISheetDataCt struct {
	Fa string `json:"fa"`
	T  string `json:"t"`
}

type ISheetCellData struct {
	R int        `json:"r"`
	C int        `json:"c"`
	V ISheetData `json:"v"`
}

type SheetData struct {
	Data [][]*struct {
		Ct struct {
			Fa string `json:"fa"`
			T  string `json:"t"`
		} `json:"ct"`
		M string  `json:"m"`
		V float64 `json:"v"`
	} `json:"data"`
}

// AddExcelInfoReq 新增表格请求
type AddExcelInfoReq struct {
	ExcelName       string      `description:"表格名称"`
	Source          int         `description:"表格来源，1：excel插件的表格，2：自定义表格，默认：1"`
	ExcelType       int         `description:"表格类型，1：指标列，2：日期列，默认：1"`
	ExcelImage      string      `description:"表格截图"`
	ExcelClassifyId int         `description:"分类id"`
	Content         string      `description:"Excel表格内容"`
	TableData       interface{} `description:"自定义表格的数据内容"`
}

func GetMeetingProbabilitiesMaxDate() (maxDate time.Time, err error) {
	o := global.DbMap[utils.DbNameIndex]
	sql := ` SELECT max(a.date_time) AS max_date FROM meeting_probabilities as a `
	var timeNull sql2.NullTime
	err = o.Raw(sql).Scan(&timeNull).Error
	if err != nil {
		return
	}
	if timeNull.Valid {
		maxDate = timeNull.Time
	}
	return
}