seal.go 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. package seal
  2. import (
  3. "fmt"
  4. "hongze/hongze_mobile_admin/utils"
  5. "rdluck_tools/orm"
  6. "time"
  7. )
  8. //Seal 用印结构体
  9. type Seal struct {
  10. SealId int `orm:"column(seal_id);pk"`
  11. Code string `description:"用印编号,长度32位"`
  12. UserId int `description:"申请人id"`
  13. UserName string `description:"申请人名称"`
  14. Use string `description:"用印用途,枚举值:'销售合同', '渠道合同', '付款通知函', '招投标', '战略合作协议';默认:销售合同"`
  15. CompanyName string `description:"客户名称,甲方名称,长度32位"`
  16. UseCompanyName string `description:"实际使用方客户名称,长度32位"`
  17. CreditCode string `description:"社会统一信用代码,长度64位"`
  18. ServiceType string `description:"业务类型,枚举值:'新签合同','续约合同','补充协议';默认:新签合同"`
  19. SealType string `description:"加盖印章类型,枚举值:'合同章', '公章', '法人章';默认:合同章"`
  20. Status string `description:"合同状态,枚举值:'待提交','待审批','已撤回','已审批','已驳回','已作废','已签回'"`
  21. Remark string `description:"补充内容,长度255位"`
  22. ApprovalRemark string `description:"审核备注"`
  23. FileUrl string `description:"文件附件地址"`
  24. CheckBackFileUrl string `description:"已签回的文件地址"`
  25. FileNum int `description:"文件附件份数"`
  26. ContractId int `description:"系统合同id"`
  27. IsDelete int `json:"-" description:"是否已经删除,0:未删除,1:已删除"`
  28. ApproveTime time.Time `description:"审批时间"`
  29. InvalidTime time.Time `description:"作废时间"`
  30. ModifyTime time.Time `description:"最近一次修改时间"`
  31. CreateTime time.Time `description:"添加时间"`
  32. CheckBackFileTime time.Time `description:"签回用印附件时间"`
  33. }
  34. //GetSealInfoById 根据用印id获取合同信息
  35. func GetSealInfoById(sealId int) (sealInfo *Seal, err error) {
  36. o := orm.NewOrm()
  37. sql := `select * from seal where seal_id = ? `
  38. err = o.Raw(sql, sealId).QueryRow(&sealInfo)
  39. return
  40. }
  41. //GetSealInfoByContractId 根据合同id获取合同信息
  42. func GetSealInfoByContractId(sealId int) (sealInfo *Seal, err error) {
  43. o := orm.NewOrm()
  44. sql := `select * from seal where contract_id = ? and status in ("已审批","已签回") order by seal_id asc limit 1`
  45. err = o.Raw(sql, sealId).QueryRow(&sealInfo)
  46. return
  47. }
  48. //AddSeal 用印添加
  49. func AddSeal(sealInfo *Seal) (err error) {
  50. o := orm.NewOrm()
  51. //用印数据入库
  52. sealId, err := o.Insert(sealInfo)
  53. if err != nil {
  54. return
  55. }
  56. sealInfo.SealId = int(sealId)
  57. return
  58. }
  59. //Update 更新用印信息
  60. func (seal *Seal) Update(cols []string) (err error) {
  61. o := orm.NewOrm()
  62. _, err = o.Update(seal, cols...)
  63. return
  64. }
  65. //DeleteSeal 删除用印
  66. func DeleteSeal(sealInfo *Seal) (err error) {
  67. sealInfo.IsDelete = 1
  68. sealInfo.ModifyTime = time.Now()
  69. sealInfo.InvalidTime = time.Now()
  70. err = sealInfo.Update([]string{"IsDelete", "ModifyTime", "InvalidTime"})
  71. return
  72. }
  73. //Invalid 作废用印
  74. func Invalid(sealInfo *Seal) (err error) {
  75. sealInfo.Status = "已作废"
  76. sealInfo.ModifyTime = time.Now()
  77. sealInfo.InvalidTime = time.Now()
  78. //修改用印数据入库
  79. err = sealInfo.Update([]string{"Status", "ModifyTime", "InvalidTime"})
  80. return
  81. }
  82. //GetSealCode 生成合同编号
  83. func GetSealCode() (code string, err error) {
  84. var num int
  85. o := orm.NewOrm()
  86. today := utils.GetToday(utils.FormatDate)
  87. sql := `SELECT COUNT(1) AS num FROM seal where create_time>=?`
  88. err = o.Raw(sql, today).QueryRow(&num)
  89. if err != nil {
  90. return
  91. }
  92. code = "HZ" + time.Now().Format("20060102") + fmt.Sprintf("%03d", num)
  93. return
  94. }
  95. type CompanyNameList struct {
  96. CompanyName string `description:"客户名称,甲方名称,长度32位"`
  97. }
  98. //GetCompanyNameList 获取客户名称列表数据
  99. func GetCompanyNameList(name string) (list []*CompanyNameList, err error) {
  100. o := orm.NewOrm()
  101. sql := `select * from seal where company_name like '%` + name + `%' group by company_name order by modify_time desc `
  102. _, err = o.Raw(sql).QueryRows(&list)
  103. return
  104. }
  105. //GetCompanyNameListV2 获取客户名称列表数据V2版本
  106. func GetCompanyNameListV2(childCondition, condition string, childPars, pars []interface{}) (list []*CompanyNameList, err error) {
  107. o := orm.NewOrm()
  108. sql := `SELECT c.company_name,a.modify_time from contract_approval a
  109. join
  110. ( SELECT max( contract_approval_id ) max_id,contract_id FROM contract_approval where 1=1 `
  111. sql += childCondition
  112. sql += ` GROUP BY contract_id ) b on a.contract_approval_id=b.max_id
  113. JOIN seal c ON c.seal_id = a.contract_id
  114. JOIN contract_approval_record d on a.contract_approval_id=d.contract_approval_id
  115. WHERE c.is_delete = 0 AND a.approval_type="seal" `
  116. sql += condition
  117. sql += ` group by company_name order by modify_time desc`
  118. _, err = o.Raw(sql, childPars, pars).QueryRows(&list)
  119. return
  120. }
  121. //GetListCount 获取用印列表数据数量
  122. func GetListCount(condition string, pars []interface{}) (count int, err error) {
  123. o := orm.NewOrm()
  124. sql := "select count(*) AS COUNT from seal where 1=1 AND is_delete = 0 "
  125. sql += condition
  126. err = o.Raw(sql, pars).QueryRow(&count)
  127. return
  128. }
  129. //GetList 获取用印列表
  130. func GetList(condition string, pars []interface{}, startSize, pageSize int) (list []*Seal, err error) {
  131. o := orm.NewOrm()
  132. sql := "select * from seal where 1=1 AND is_delete = 0 "
  133. sql += condition
  134. sql += ` order by modify_time desc LIMIT ?,? `
  135. _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&list)
  136. return
  137. }