supplier_system/src/dashoo.cn/backend/api/business/oilsupplier/qualchange/qualchange.go

package qualchange

import (
	"dashoo.cn/backend/api/business/oilsupplier/supplier"
	"time"
)

type OilQualChangeDetail struct {
	Id                int       `xorm:"not null default 0 INT(10)"`
	SupplierId        int       `xorm:"INT(10)"`
	SupplierCertId    int       `xorm:"not null comment('准入子表Id') INT(10)"`
	FileId            int       `xorm:"not null comment('资质文件Id') INT(10)"`
	ParentId          int       `xorm:"not null default 0 comment('主表Id') INT(10)"`
	SupplierTypeCode  string    `xorm:"not null default '0' comment('准入类别代码（01 物资类，02 基建类，03 技术服务类）') VARCHAR(5)"`
	SupplierCertSubId int       `xorm:"not null default 0 comment('供方对应准入子分类表') INT(10)"`
	CertSubName       string    `xorm:"default '' comment('分类名称') VARCHAR(50)"`
	NeedFileType      string    `xorm:"not null default '' comment('文件分类') VARCHAR(50)"`
	NeedFileCode      string    `xorm:"not null default '' comment('文件分类编码') VARCHAR(20)"`
	OldFileName       string    `xorm:"not null default '' comment('原文件名称') VARCHAR(2000)"`
	FileName          string    `xorm:"not null default '' comment('文件名称') VARCHAR(2000)"`
	FileExt           string    `xorm:"VARCHAR(10)"`
	FileType          int       `xorm:"default 0 comment('0：不必要文件；1:必上传文件；') INT(10)"`
	OldEffectDate     time.Time `xorm:"comment('原有效期') DATETIME"`
	EffectDate        time.Time `xorm:"comment('有效期') DATETIME"`
	OldFileUrl        string    `xorm:"VARCHAR(2000)"`
	FileUrl           string    `xorm:"VARCHAR(2000)"`
	OtherRemark       string    `xorm:"VARCHAR(500)"`
	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 OilQualChangeMain struct {
	Id             int       `xorm:"not null pk autoincr INT(10)"`
	SupplierId     int       `xorm:"not null comment('供方基本信息表主键') INT(10)"`
	SupplierCertId int       `xorm:"not null comment('准入子表Id') INT(10)"`
	SupplierName   string    `xorm:"comment('企业名称') VARCHAR(255)"`
	AccesscardNo   string    `xorm:"comment('准入证号') VARCHAR(20)"`
	CommercialNo   string    `xorm:"comment('工商注册号') VARCHAR(20)"`
	Step           int       `xorm:"comment('页面上第几步') INT(10)"`
	AuditIndex     int       `xorm:"default 0 comment('审批次数') INT(11)"`
	FirstAudit     int       `xorm:"default 0 comment('初审') INT(11)"`
	SecondAudit    int       `xorm:"default 0 comment('复审') INT(11)"`
	BusinessKey    string    `xorm:"VARCHAR(255)"`
	Status         string    `xorm:"comment('状态标识') VARCHAR(10)"`
	WorkFlowId     string    `xorm:"comment('工作流的ID') VARCHAR(50)"`
	Remark         string    `xorm:"comment('备注') VARCHAR(500)"`
	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 QualChangeModel struct {
	OilQualChangeMain `xorm:"extends"`
	DetailId          int       `xorm:"not null default 0 INT(10)"`
	FileId            int       `xorm:"not null comment('资质文件Id') INT(10)"`
	SupplierTypeCode  string    `xorm:"not null default '0' comment('准入类别代码（01 物资类，02 基建类，03 技术服务类）') VARCHAR(5)"`
	SupplierCertSubId int       `xorm:"not null default 0 comment('供方对应准入子分类表') INT(10)"`
	CertSubName       string    `xorm:"default '' comment('分类名称') VARCHAR(50)"`
	NeedFileType      string    `xorm:"not null default '' comment('文件分类') VARCHAR(50)"`
	NeedFileCode      string    `xorm:"not null default '' comment('文件分类编码') VARCHAR(20)"`
	OldFileName       string    `xorm:"not null default '' comment('原文件名称') VARCHAR(50)"`
	FileName          string    `xorm:"not null default '' comment('文件名称') VARCHAR(50)"`
	FileExt           string    `xorm:"VARCHAR(10)"`
	FileType          int       `xorm:"default 0 comment('0：不必要文件；1:必上传文件；') INT(10)"`
	OldEffectDate     time.Time `xorm:"comment('原有效期') DATETIME"`
	EffectDate        time.Time `xorm:"comment('有效期') DATETIME"`
	OldFileUrl        string    `xorm:"VARCHAR(100)"`
	FileUrl           string    `xorm:"VARCHAR(100)"`
	OtherRemark       string    `xorm:"VARCHAR(500)"`
	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 OilSupplierQual struct {
	supplier.OilSupplier `xorm:"extends"`
	CertId               string
	AccessCardNo         string
	SupplierTypeCode     string
	SupplierTypeName     string
	QualId               int
	ConmmitTime          time.Time
	Step                 int       `xorm:"comment('页面上第几步') INT(10)"`
	WorkFlowId           string    `xorm:"comment('工作流的ID') VARCHAR(50)"`
	WorkerTotal          int       `xorm:"default 0 comment('企业员工总数') INT(10)"`
	ContractNum          int       `xorm:"default 0 comment('合同化用工数量') INT(10)"`
	UniversityNum        int       `xorm:"default 0 comment('大学及以上学历人员数量') INT(10)"`
	TechnicalNum         int       `xorm:"default 0 comment('技术、管理人员数量') INT(10)"`
	AboveProfNum         int       `xorm:"default 0 comment('高级及以上职称人员数量') INT(10)"`
	MiddleProfNum        int       `xorm:"default 0 comment('中级职称人员数量') INT(10)"`
	NationalRegNum       int       `xorm:"default 0 comment('具有国家注册执业资格人员数量') INT(10)"`
	NationalCertTotal    int       `xorm:"default 0 comment('具有国家注册执业资格证书总数') INT(10)"`
	DesignerTotal        int       `xorm:"default 0 comment('设计人员总数') INT(10)"`
	SkillerTotal         int       `xorm:"default 0 comment('技术工人总数') INT(10)"`
	Status               string    `xorm:"not null default '0' comment('状态标识(0未申请，1办理完毕)') VARCHAR(10)"`
	RecUnitReason        string    `xorm:"comment('推荐单位的推荐意见') VARCHAR(800)"`
	RecUnitPerson        string    `xorm:"comment('推荐单位负责人') VARCHAR(20)"`
	RecDate              time.Time `xorm:"comment('推荐日期') DATETIME"`
	RecUnitId            string    `xorm:"comment('推荐单位编码') VARCHAR(10)"`
	RecUnitName          string    `xorm:"comment('推荐单位名称') VARCHAR(50)"`
	BackReason           string    `xorm:"comment('退回原因') VARCHAR(50)"`
	InFlag               string    `xorm:"default '0' comment('准入标识') VARCHAR(10)"`
	EffectStartTime      time.Time `xorm:"comment('有效期起') DATETIME"`
	EffectEndTime        time.Time `xorm:"comment('有效期止') DATETIME"`
	AuditProcessNote     string    `xorm:"comment('办理过程备注') VARCHAR(100)"`
	AuditDate            time.Time `xorm:"comment('审核日期') DATETIME"`
	PayNotice            string    `xorm:"default '0' comment('交费通知') VARCHAR(2)"`
	SupplierStatus       string    `xorm:"comment('供应商状态（null:正常，1中止，2终止）') VARCHAR(255)"`
	MgrType              string    `xorm:"comment('供应商管理类型') VARCHAR(255)"`
	Type                 string    `xorm:"comment('供应商类型') VARCHAR(255)"`
	MgrUnit              string    `xorm:"comment('管理单位') VARCHAR(255)"`
	AddinTime            string    `xorm:"comment('准入日期') VARCHAR(255)"`
	EffectTime           string    `xorm:"comment('生效日期') VARCHAR(255)"`
	ApplyTime            time.Time `xorm:"comment('年审日期') DATETIME"`
	SupplierNo           string    `xorm:"comment('供应商准入证编号') VARCHAR(255)"`
	MdmFlag              string    `xorm:"default '0' comment('MDM标志') VARCHAR(2)"`
	InternalFlag         string    `xorm:"comment('国内采购') VARCHAR(255)"`
	ImportFlag           string    `xorm:"comment('进口采购') VARCHAR(255)"`
	OutsideFlog          string    `xorm:"comment('境外项目') VARCHAR(255)"`
	Remark               string    `xorm:"comment('备注') VARCHAR(500)"`
	ThirdAudit           string    `xorm:"comment('备注') VARCHAR(500)"`
	IsDelete             int       `xorm:"default 0 comment('删除状态，0正常，1已删除') INT(10)"`
}