| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 |
- package qualchange
- import (
- "dashoo.cn/backend/api/business/oilsupplier/supplier"
- "time"
- )
- type OilQualChangeDetail struct {
- Id int `xorm:"not null default 0 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(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 OilQualChangeMain struct {
- Id int `xorm:"not null pk autoincr INT(10)"`
- SupplierId int `xorm:"not null comment('供方基本信息表主键') 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)"`
- Status string `xorm:"comment('状态标识') VARCHAR(10)"`
- WorkFlowId string `xorm:"comment('工作流的ID') VARCHAR(50)"`
- 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)"`
- }
|
