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('类型 1准入,2增项,3增项通过') 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 time.Time `xorm:"DATETIME"` IsQuestion int `xorm:"default 0 comment('问题状态,0正常,1有问题') INT(10)"` LackFile string `xorm:"default 0 comment('缺少资质') VARCHAR(500)"` IsQuestion1 int `xorm:"default 0 comment('问题状态,0正常,1有问题') INT(10)"` LackFile1 string `xorm:"default 0 comment('缺少资质') VARCHAR(500)"` } type OilSupplierCertSubSelect struct { GoodsLevel string `xorm:"not null default '' comment('级别')"` IsManufacturer int `xorm:"not null comment('是否为供应商') INT(11)"` Code string `xorm:"not null default '' comment('分类编码') VARCHAR(8)"` 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)"` } 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 time.Time `xorm:"DATETIME"` 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 //是否为比对出的不同项 } type Ids struct { Id string }