eta_api/models/report_approve/report_approve_node.go

package report_approve

import (
	"eta/eta_api/utils"
	"fmt"
	"github.com/beego/beego/v2/client/orm"
	"strings"
	"time"
)

const (
	NodeApproveTypeRoll = iota + 1
	NodeApproveTypeAll
	NodeApproveTypeAny
)

// ReportApproveNode 报告审批节点表
type ReportApproveNode struct {
	ReportApproveNodeId int       `orm:"column(report_approve_node_id);pk" description:"报告审批节点ID"`
	ReportApproveFlowId int       `description:"报告审批流ID"`
	PrevNodeId          int       `description:"上一个节点ID（0为开始节点）"`
	NextNodeId          int       `description:"下一个节点ID（0为结束节点）"`
	NodeType            int       `description:"节点类型：0-审批；1-抄送"`
	ApproveType         int       `description:"审批类型：1-依次审批；2-会签；3-或签"`
	users               string    `description:"审批人信息-JSON，user_type：user-用户；role-角色，user_id：用户/角色ID"`
	CurrVersion         int       `description:"当前版本号"`
	CreateTime          time.Time `description:"创建时间"`
}

func (m *ReportApproveNode) TableName() string {
	return "report_approve_node"
}

func (m *ReportApproveNode) PrimaryId() string {
	return "report_approve_node_id"
}

func (m *ReportApproveNode) Create() (err error) {
	o := orm.NewOrmUsingDB("rddp")
	id, err := o.Insert(m)
	if err != nil {
		return
	}
	m.ReportApproveNodeId = int(id)
	return
}

func (m *ReportApproveNode) CreateMulti(items []*ReportApproveNode) (err error) {
	if len(items) == 0 {
		return
	}
	o := orm.NewOrmUsingDB("rddp")
	_, err = o.InsertMulti(len(items), items)
	return
}

func (m *ReportApproveNode) Update(cols []string) (err error) {
	o := orm.NewOrmUsingDB("rddp")
	_, err = o.Update(m, cols...)
	return
}

func (m *ReportApproveNode) Del() (err error) {
	o := orm.NewOrmUsingDB("rddp")
	sql := fmt.Sprintf(`DELETE FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.PrimaryId())
	_, err = o.Raw(sql, m.ReportApproveNodeId).Exec()
	return
}

func (m *ReportApproveNode) MultiDel(menuIds []int) (err error) {
	if len(menuIds) == 0 {
		return
	}
	o := orm.NewOrmUsingDB("rddp")
	sql := fmt.Sprintf(`DELETE FROM %s WHERE %s IN (%s)`, m.TableName(), m.PrimaryId(), utils.GetOrmInReplace(len(menuIds)))
	_, err = o.Raw(sql, menuIds).Exec()
	return
}

func (m *ReportApproveNode) GetItemById(id int) (item *ReportApproveNode, err error) {
	o := orm.NewOrmUsingDB("rddp")
	sql := fmt.Sprintf(`SELECT * FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.PrimaryId())
	err = o.Raw(sql, id).QueryRow(&item)
	return
}

func (m *ReportApproveNode) GetItemByCondition(condition string, pars []interface{}, orderRule string) (item *ReportApproveNode, err error) {
	o := orm.NewOrmUsingDB("rddp")
	order := ``
	if orderRule != "" {
		order = ` ORDER BY ` + orderRule
	}
	sql := fmt.Sprintf(`SELECT * FROM %s WHERE 1=1 %s %s LIMIT 1`, m.TableName(), condition, order)
	err = o.Raw(sql, pars).QueryRow(&item)
	return
}

func (m *ReportApproveNode) GetCountByCondition(condition string, pars []interface{}) (count int, err error) {
	o := orm.NewOrmUsingDB("rddp")
	sql := fmt.Sprintf(`SELECT COUNT(1) FROM %s WHERE 1=1 %s`, m.TableName(), condition)
	err = o.Raw(sql, pars).QueryRow(&count)
	return
}

func (m *ReportApproveNode) GetItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string) (items []*ReportApproveNode, err error) {
	o := orm.NewOrmUsingDB("rddp")
	fields := strings.Join(fieldArr, ",")
	if len(fieldArr) == 0 {
		fields = `*`
	}
	order := `ORDER BY create_time DESC`
	if orderRule != "" {
		order = ` ORDER BY ` + orderRule
	}
	sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s`, fields, m.TableName(), condition, order)
	_, err = o.Raw(sql, pars).QueryRows(&items)
	return
}

func (m *ReportApproveNode) GetPageItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string, startSize, pageSize int) (items []*ReportApproveNode, err error) {
	o := orm.NewOrmUsingDB("rddp")
	fields := strings.Join(fieldArr, ",")
	if len(fieldArr) == 0 {
		fields = `*`
	}
	order := `ORDER BY create_time DESC`
	if orderRule != "" {
		order = ` ORDER BY ` + orderRule
	}
	sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s LIMIT ?,?`, fields, m.TableName(), condition, order)
	_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
	return
}

// ReportApproveNodeItem 报告审批节点信息
type ReportApproveNodeItem struct {
	ReportApproveNodeId int    `orm:"column(report_approve_node_id);pk" description:"报告审批节点ID"`
	ReportApproveFlowId int    `description:"报告审批流ID"`
	PrevNodeId          int    `description:"上一个节点ID（0为开始节点）"`
	NextNodeId          int    `description:"下一个节点ID（0为结束节点）"`
	NodeType            int    `description:"节点类型：0-审批；1-抄送"`
	ApproveType         int    `description:"审批类型：1-依次审批；2-会签；3-或签"`
	users               string `description:"审批人信息-JSON，user_type：user-用户；role-角色，user_id：用户/角色ID"`
	CurrVersion         int    `description:"当前版本号"`
	CreateTime          string `description:"创建时间"`
}

// FormatReportApproveNode2Item 格式化报告审批节点
func FormatReportApproveNode2Item(origin *ReportApproveNode) (item *ReportApproveNodeItem) {
	item = new(ReportApproveNodeItem)
	if origin == nil {
		return
	}
	item.ReportApproveNodeId = origin.ReportApproveNodeId
	item.CreateTime = utils.TimeTransferString(utils.FormatDateTime, origin.CreateTime)
	return
}

// ReportApproveNodeAddReq 新增报告审批节点请求体
type ReportApproveNodeAddReq struct {
	FlowName         string `description:"审批流名称"`
	ReportType       int    `description:"报告类型：1-中文研报；2-英文研报；3-智能研报"`
	ClassifyFirstId  int    `description:"一级分类ID"`
	ClassifySecondId int    `description:"二级分类ID"`
}

//
//// ReportApproveNodeEditReq 编辑报告审批节点请求体
//type ReportApproveNodeEditReq struct {
//	ReportApproveNodeAddReq
//	ReportApproveNodeId int    `description:"报告审批节点ID"`
//	Content             string `description:"内容"`
//	ContentStruct       string `description:"内容结构"`
//}
//
//// ReportApproveNodeRemoveReq 删除报告审批节点请求体
//type ReportApproveNodeRemoveReq struct {
//	ReportApproveNodeId int `description:"报告审批节点ID"`
//}
//
//// ReportApproveNodePublishReq 发布报告审批节点请求体
//type ReportApproveNodePublishReq struct {
//	ReportApproveNodeId int `description:"报告审批节点ID"`
//	PublishState        int `description:"1-取消发布; 2-发布"`
//}
//
//// ReportApproveNodePrePublishReq 预发布报告审批节点请求体
//type ReportApproveNodePrePublishReq struct {
//	ReportApproveNodeId int    `description:"报告审批节点ID"`
//	PrePublishTime      string `description:"预发布时间"`
//	PreMsgSend          int    `description:"定时发布成功后是否立即推送模版消息：0否，1是"`
//}
//
//// ReportApproveNodeSaveContentReq 保存草稿请求体
//type ReportApproveNodeSaveContentReq struct {
//	ReportApproveNodeId int    `description:"报告审批节点ID"`
//	Content             string `description:"内容"`
//	ContentStruct       string `description:"内容结构"`
//	NoChange            int    `description:"内容是否未改变：1：内容未改变"`
//}
//
//// ReportApproveNodeSaveContentResp 保存草稿响应体
//type ReportApproveNodeSaveContentResp struct {
//	ReportApproveNodeId int `description:"报告审批节点ID"`
//}
//
//// ReportApproveNodeSendMsgReq 消息推送请求体
//type ReportApproveNodeSendMsgReq struct {
//	ReportApproveNodeId int `description:"报告审批节点ID"`
//}
//
//// ReportApproveNodeMarkEditReq 标记编辑英文研报的请求数据
//type ReportApproveNodeMarkEditReq struct {
//	ReportApproveNodeId int `description:"报告审批节点ID"`
//	Status              int `description:"标记状态: 1-编辑中; 2-编辑完成"`
//}
//
//// ReportApproveNodeListResp 报告审批节点
//type ReportApproveNodeListResp struct {
//	List   []*ReportApproveNodeItem
//	Paging *paging.PagingItem `description:"分页数据"`
//}
//
//// ElasticReportApproveNode 报告审批节点es
//type ElasticReportApproveNode struct {
//	ReportApproveNodeId int    `description:"报告审批节点ID"`
//	Title               string `description:"标题"`
//	Abstract            string `description:"摘要"`
//	BodyContent         string `description:"内容"`
//	PublishTime         string `description:"发布时间"`
//	PublishState        int    `description:"发布状态 1-未发布 2-已发布"`
//	Author              string `description:"作者"`
//	ClassifyIdFirst     int    `description:"一级分类ID"`
//	ClassifyNameFirst   string `description:"一级分类名称"`
//	ClassifyIdSecond    int    `description:"二级分类ID"`
//	ClassifyNameSecond  string `description:"二级分类名称"`
//	StageStr            string `description:"报告期数"`
//	Frequency           string `description:"频度"`
//}
//
//// Report2ImgQueueReq 报告详情生成长图队列请求体
//type Report2ImgQueueReq struct {
//	ReportType int    `description:"报告类型: 1-研报; 2-报告审批节点"`
//	ReportCode string `description:"报告唯一编码"`
//}