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)"` }