oilsuppliercert.go 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. package suppliercert
  2. import (
  3. "time"
  4. )
  5. type OilSupplierCert struct {
  6. Id int `xorm:"not null pk autoincr INT(10)"`
  7. SupplierId int `xorm:"not null comment('供方基本信息表主键') INT(10)"`
  8. AccessCardNo string `xorm:"comment('准入证号') VARCHAR(20)"`
  9. SupplierTypeCode string `xorm:"comment('准入类别代码(1 物资类,2 基建类,3 技术服务类)') VARCHAR(5)"`
  10. SupplierTypeName string `xorm:"comment('准入类别名称(1 物资类,2 基建类,3 技术服务类)') VARCHAR(50)"`
  11. RecUnitReason string `xorm:"comment('推荐单位的推荐意见') VARCHAR(800)"`
  12. RecUnitPerson string `xorm:"comment('推荐单位负责人') VARCHAR(20)"`
  13. RecDate time.Time `xorm:"comment('推荐日期') DATETIME"`
  14. RecUnitId string `xorm:"comment('推荐单位编码') VARCHAR(10)"`
  15. RecUnitName string `xorm:"comment('推荐单位名称') VARCHAR(50)"`
  16. Status string `xorm:"not null default '0' comment('状态标识(0未申请,1办理完毕)') VARCHAR(10)"`
  17. BackReason string `xorm:"comment('退回原因') VARCHAR(50)"`
  18. InFlag string `xorm:"default '0' comment('准入标识') VARCHAR(10)"`
  19. EffectStartTime time.Time `xorm:"comment('有效期起') DATETIME"`
  20. EffectEndTime time.Time `xorm:"comment('有效期止') DATETIME"`
  21. AuditProcessNote string `xorm:"comment('办理过程备注') VARCHAR(100)"`
  22. AuditDate time.Time `xorm:"comment('审核日期') DATETIME"`
  23. PayNotice string `xorm:"default '0' comment('交费通知') VARCHAR(2)"`
  24. SupplierStatus string `xorm:"comment('供应商状态(null:正常,1中止,2终止)') VARCHAR(255)"`
  25. MgrType string `xorm:"comment('供应商管理类型') VARCHAR(255)"`
  26. Type string `xorm:"comment('供应商类型') VARCHAR(255)"`
  27. MgrUnit string `xorm:"comment('管理单位') VARCHAR(255)"`
  28. AddinTime string `xorm:"comment('准入日期') VARCHAR(255)"`
  29. EffectTime string `xorm:"comment('生效日期') VARCHAR(255)"`
  30. ApplyTime string `xorm:"comment('年审到期日期') VARCHAR(255)"`
  31. SupplierNo string `xorm:"comment('供应商准入证编号') VARCHAR(255)"`
  32. MdmFlag string `xorm:"default '0' comment('MDM标志') VARCHAR(2)"`
  33. InternalFlag string `xorm:"comment('国内采购') VARCHAR(255)"`
  34. ImportFlag string `xorm:"comment('进口采购') VARCHAR(255)"`
  35. OutsideFlog string `xorm:"comment('境外项目') VARCHAR(255)"`
  36. Step int `xorm:"comment('页面上第几步') INT(10)"`
  37. Remark string `xorm:"comment('备注') VARCHAR(500)"`
  38. IsDelete int `xorm:"default 0 comment('删除状态,0正常,1已删除') INT(10)"`
  39. WorkerTotal int `xorm:"default 0 comment('企业员工总数') INT(10)"`
  40. ContractNum int `xorm:"default 0 comment('合同化用工数量') INT(10)"`
  41. UniversityNum int `xorm:"default 0 comment('大学及以上学历人员数量') INT(10)"`
  42. TechnicalNum int `xorm:"default 0 comment('技术、管理人员数量') INT(10)"`
  43. AboveProfNum int `xorm:"default 0 comment('高级及以上职称人员数量') INT(10)"`
  44. MiddleProfNum int `xorm:"default 0 comment('中级职称人员数量') INT(10)"`
  45. NationalRegNum int `xorm:"default 0 comment('具有国家注册执业资格人员数量') INT(10)"`
  46. NationalCertTotal int `xorm:"default 0 comment('具有国家注册执业资格证书总数') INT(10)"`
  47. DesignerTotal int `xorm:"default 0 comment('设计人员总数') INT(10)"`
  48. SkillerTotal int `xorm:"default 0 comment('技术工人总数') INT(10)"`
  49. WorkflowId string `xorm:"default '0' comment('工作流的ID') VARCHAR(255)"`
  50. FirstAudit int `xorm:"default 0 comment('初审') INT(10)"`
  51. SecondAudit int `xorm:"default 0 comment('复审') INT(10)"`
  52. ThirdAudit int `xorm:"default 0 comment('专业科室审批') INT(10)"`
  53. FourthAudit int `xorm:"default 0 comment('集中审批') INT(10)"`
  54. CreateOn time.Time `xorm:"DATETIME"`
  55. CreateUserId int `xorm:"INT(10)"`
  56. CreateBy string `xorm:"VARCHAR(50)"`
  57. ModifiedOn time.Time `xorm:"DATETIME"`
  58. ModifiedUserId int `xorm:"INT(10)"`
  59. ModifiedBy string `xorm:"VARCHAR(50)"`
  60. }
  61. type OilSupplierVM struct {
  62. AccessCardNo string
  63. SupplierTypeCode string
  64. SupplierTypeName string
  65. }
  66. type UserList struct {
  67. UserId int64 `json:"userid"`
  68. UserName string `json:"username"`
  69. }
  70. const (
  71. DRAFT_STATUS string = "0" //草稿状态
  72. FIRST_TRIAL_STATUS string = "1" //二级单位初审
  73. SECOND_TRIAL_STATUS string = "2" //二级单位复审
  74. THIRD_TRIAL_STATUS string = "3" //专业处接收
  75. PROF_AUDIT_STATUS string = "4" //专业科室审核
  76. CENT_AUDIT_STATUS string = "5" // 集中审批
  77. PAYING_AUDIT_STATUS string = "6" //待缴费
  78. )