supplier_system/src/dashoo.cn/backend/api/business/oilsupplier/suppliercertsub/oilsuppliercertsub.go

package suppliercertsub

import (
	"time"
)

type OilSupplierCertSub struct {
	Id                   int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId           int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId       int       `xorm:"not null comment('供方准入证书信息表主键') INT(10)"`
	SupplierCertAppendId int       `xorm:"not null comment('增项信息表ID') INT(10)"`
	GoodsLevel           string    `xorm:"not null default '' comment('级别')"`
	IsManufacturer       int       `xorm:"not null comment('是否为供应商') INT(11)"`
	SupplierTypeCode     string    `xorm:"not null default '' comment('准入类别代码') VARCHAR(5)"`
	SubClassId           int       `xorm:"not null comment('分类表主键（物资类或基建类或技术服务类）') INT(10)"`
	Code                 string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	AppendStatus         string    `xorm:"not null default '' comment('增项审核状态') VARCHAR(10)"`
	Type                 string    `xorm:"not null default '' comment('类型') VARCHAR(10)"`
	Name                 string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	CertSubStatus        string    `xorm:"null default '1' comment('1：正常2：不良记录暂停') VARCHAR(10)"`
	Remark               string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete             int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn             time.Time `xorm:"DATETIME created"`
	CreateUserId         int       `xorm:"INT(10)"`
	CreateBy             string    `xorm:"VARCHAR(50)"`
	ModifiedOn           time.Time `xorm:"DATETIME"`
	ModifiedUserId       int       `xorm:"INT(10)"`
	ModifiedBy           string    `xorm:"VARCHAR(50)"`
	DueTime           	 string    `xorm:"VARCHAR(50)"`
	IsQuestion           int       `xorm:"default 0 comment('问题状态，0正常，1有问题') INT(10)"`
}
type OilSupplierCertSub1 struct {
	Id                   int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId           int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId       int       `xorm:"not null comment('供方准入证书信息表主键') INT(10)"`
	SupplierCertAppendId int       `xorm:"not null comment('增项信息表ID') INT(10)"`
	GoodsLevel           string    `xorm:"not null default '' comment('级别')"`
	IsManufacturer       int       `xorm:"not null comment('是否为供应商') INT(11)"`
	SupplierTypeCode     string    `xorm:"not null default '' comment('准入类别代码') VARCHAR(5)"`
	SubClassId           int       `xorm:"not null comment('分类表主键（物资类或基建类或技术服务类）') INT(10)"`
	Code                 string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	AppendStatus         string    `xorm:"not null default '' comment('增项审核状态') VARCHAR(10)"`
	Type                 string    `xorm:"not null default '' comment('类型') VARCHAR(10)"`
	Name                 string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	CertSubStatus        string    `xorm:"null default '1' comment('1：正常2：不良记录暂停') VARCHAR(10)"`
	Remark               string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete             int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn             time.Time `xorm:"DATETIME created"`
	CreateUserId         int       `xorm:"INT(10)"`
	CreateBy             string    `xorm:"VARCHAR(50)"`
	ModifiedOn           time.Time `xorm:"DATETIME"`
	ModifiedUserId       int       `xorm:"INT(10)"`
	ModifiedBy           string    `xorm:"VARCHAR(50)"`
	DueTime           	 string    `xorm:"VARCHAR(50)"`
	HeaderCodes           string
	Checked           int
	HeaderName           string
	MinClassId           string
	IsQuestion		     string
}

type Del_OilSupplierCertSub struct {
	Id                   int       `xorm:<- not null pk autoincr INT(10)"`
	SupplierId           int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId       int       `xorm:"not null comment('供方准入证书信息表主键') INT(10)"`
	SupplierCertAppendId int       `xorm:"not null comment('增项信息表ID') INT(10)"`
	SupplierTypeCode     string    `xorm:"not null default '' comment('准入类别代码') VARCHAR(5)"`
	SubClassId           int       `xorm:"not null comment('分类表主键（物资类或基建类或技术服务类）') INT(10)"`
	Code                 string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	AppendStatus         string    `xorm:"not null default '' comment('增项审核状态') VARCHAR(10)"`
	Type                 string    `xorm:"not null default '' comment('类型') VARCHAR(10)"`
	Name                 string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	CertSubStatus        string    `xorm:"null default '1' comment('1：正常2：不良记录暂停') VARCHAR(10)"`
	Remark               string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete             int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn             time.Time `xorm:"DATETIME created"`
	CreateUserId         int       `xorm:"INT(10)"`
	CreateBy             string    `xorm:"VARCHAR(50)"`
	ModifiedOn           time.Time `xorm:"DATETIME"`
	ModifiedUserId       int       `xorm:"INT(10)"`
	ModifiedBy           string    `xorm:"VARCHAR(50)"`
	DeleteDate           time.Time `xorm:"DATETIME"`
}

type Tmp_OilSupplierCertSub struct {
	Id                   int       `xorm:<- not null pk autoincr INT(10)"`
	SupplierId           int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId       int       `xorm:"not null comment('供方准入证书信息表主键') INT(10)"`
	SupplierCertAppendId int       `xorm:"not null comment('增项信息表ID') INT(10)"`
	GoodsLevel           string    `xorm:"not null default '' comment('级别')"`
	IsManufacturer       int       `xorm:"not null comment('是否为供应商') INT(11)"`
	SupplierTypeCode     string    `xorm:"not null default '' comment('准入类别代码') VARCHAR(5)"`
	SubClassId           int       `xorm:"not null comment('分类表主键（物资类或基建类或技术服务类）') INT(10)"`
	Code                 string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	AppendStatus         string    `xorm:"not null default '' comment('增项审核状态') VARCHAR(10)"`
	Type                 string    `xorm:"not null default '' comment('类型') VARCHAR(10)"`
	Name                 string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	CertSubStatus        string    `xorm:"null default '1' comment('1：正常2：不良记录暂停') VARCHAR(10)"`
	Remark               string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete             int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn             time.Time `xorm:"DATETIME created"`
	CreateUserId         int       `xorm:"INT(10)"`
	CreateBy             string    `xorm:"VARCHAR(50)"`
	ModifiedOn           time.Time `xorm:"DATETIME"`
	ModifiedUserId       int       `xorm:"INT(10)"`
	ModifiedBy           string    `xorm:"VARCHAR(50)"`
}

type goodsChecked struct {
	Id         string `json:"id"`
	Code       string
	Name       string
	CodeName   string
	GoodsLevel string
}
type SupplierCertSubModel struct {
	CheckList        []goodsChecked //批量添加准入范围
	Id               int `xorm:"<- not null pk autoincr INT(10)"`
	SupplierId       int
	SupplierCertId   int
	SupplierTypeCode string
	SubClassId       int
	Code             string
	Name             string
	Remark           string
	IsDelete         int
}

type SupplierCertSubLostModel struct {
	CheckGoods       goodsChecked
	Id               int `xorm:"<- not null pk autoincr INT(10)"`
	SupplierId       int
	SupplierCertId   int
	SupplierTypeCode string
	SubClassId       int
	Code             string
	Name             string
	Remark           string
	IsDelete         int
}

type techChecked struct {
	Id       int `json:"id"`
	Code     string
	Name     string
	CodeName string
}
type TechnologySubModel struct {
	CheckList        []techChecked //批量添加准入范围
	Id               int `xorm:"<- not null pk autoincr INT(10)"`
	SupplierId       int
	SupplierCertId   int
	SupplierTypeCode string
	SubClassId       int
	Code             string
	Name             string
	Remark           string
	IsDelete         int
}

type OilSupplierCertAppendSub struct {
	Id             int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId     int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId int       `xorm:"not null comment('供方准入证书信息表主键') INT(10)"`
	SubClassId     int       `xorm:"not null comment('分类表主键（物资类或基建类或技术服务类）') INT(10)"`
	Code           string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	Name           string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	Remark         string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete       int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn       time.Time `xorm:"DATETIME created"`
	CreateUserId   int       `xorm:"INT(10)"`
	CreateBy       string    `xorm:"VARCHAR(50)"`
	ModifiedOn     time.Time `xorm:"DATETIME"`
	ModifiedUserId int       `xorm:"INT(10)"`
	ModifiedBy     string    `xorm:"VARCHAR(50)"`
}

type OilSupplierOpinion struct {
	Id                int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId        int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierTypeCode  string    `xorm:"not null default '' comment('准入类别代码') VARCHAR(5)"`
	SupplierCertSubId int       `xorm:"not null comment('供方对应准入子分类表') INT(10)"`
	CertSubName       string    `xorm:"VARCHAR(50)"`
	Opinion           string    `xorm:"not null default '' comment('分类编码') VARCHAR(500)"`
	Status            string    `xorm:"comment('状态标识( 0 初始 - 1待二级初审 - 2待二级复审 - 3-专业科室接收 4 待专业科室审核 - 5 待集中评审 - 6 待交费 - 7 待入库 - 8 完成)') VARCHAR(5)"`
	Remark            string    `xorm:"comment('备注') VARCHAR(500)"`
	AuditStatus       int       `xorm:"TINYINT(4)"`
	AuditorId         int       `xorm:"INT(10)"`
	AuditorName       string    `xorm:"VARCHAR(50)"`
	IsDelete          int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn          time.Time `xorm:"DATETIME created"`
	CreateUserId      int       `xorm:"INT(10)"`
	CreateBy          string    `xorm:"VARCHAR(50)"`
	ModifiedOn        time.Time `xorm:"DATETIME"`
	ModifiedUserId    int       `xorm:"INT(10)"`
	ModifiedBy        string    `xorm:"VARCHAR(50)"`
}

// TODO: 删除准入范围和资质对应关系表
/* type OilSupplierCert2File struct {
	Id               int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId       int       `xorm:"not null default 0 comment('供方基本信息表主键') INT(10)"`
	SupplierCertId   int       `xorm:"not null default 0 comment('供方准入证书信息表主键') INT(10)"`
	SupplierCertSubId   int    `xorm:"not null default 0 comment('供方准入范围表ID') INT(10)"`
	SupplierTypeCode string    `xorm:"not null default '0' comment('准入类别代码（1 物资类，2 基建类，3 技术服务类）') VARCHAR(5)"`
	IsManuf          string    `xorm:"VARCHAR(5)"`
	SubClassId       int       `xorm:"not null default 0 comment('分类表ID') INT(10)"`
	Code             string    `xorm:"not null default '' comment('分类编码') VARCHAR(8)"`
	Name             string    `xorm:"not null default '' comment('分类名称') VARCHAR(50)"`
	NeedFileType     string    `xorm:"not null default '' comment('文件分类（资质名称）') VARCHAR(50)"`
	Remark           string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete         int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
	CreateOn         time.Time `xorm:"DATETIME"`
	CreateUserId     int       `xorm:"INT(10)"`
	CreateBy         string    `xorm:"VARCHAR(50)"`
	ModifiedOn       time.Time `xorm:"DATETIME"`
	ModifiedUserId   int       `xorm:"INT(10)"`
	ModifiedBy       string    `xorm:"VARCHAR(50)"`
}*/

//对比分析差异表
type OilCompare struct {
	SortCoding         string //分类编码
	SortName           string //分类名称
	Level              string //级别
	SupplierCode       string //供应商编码
	SupplierName       string //供应商名称
	SurplusCount       string //管理单位类型
	ManagementUnitType string //产品变更类型
	EliminationCause   string //剔除原因
	AccessList         string //准入单位
	SupplierSubTime    string //供应商提交时间
	ProductType        string //产品类型
	Editor             string //编辑人
	EditingTime        string //编辑时间
	FlowState          string //流程状态
	ProcessNotes       string //流程备注
	Reviewime          string //复核时间
	Brand              string //品牌
	WorkCode           string //工作单编码
	WorkType           string //工作单类型
	ProductScope       string //产品服务范围
	IsBid              string //是否公开中标
	MoreInfo           string //备注
	ManufacturerCode   string //代理的制造商编码
	ManufacturerName   string //代理的制造商名称
	Diff			   string //是否为比对出的不同项
}