contract_service.go 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. package contract
  2. import (
  3. "hongze/hongze_mobile_admin/models/tables/contract_service_detail"
  4. "rdluck_tools/orm"
  5. "time"
  6. )
  7. //合同的服务内容
  8. type ContractService struct {
  9. ContractServiceId int `orm:"column(contract_service_id);pk"`
  10. ContractId int `description:"合同id"`
  11. ProductId int `description:"产品id,1:ficc;2:权益"`
  12. ServiceTemplateId int `description:"合同服务模板id"`
  13. Title string `description:"套餐名称"`
  14. Value string `description:"套餐的值"`
  15. HasDetail string `description:"是否有详情,枚举值:是、否;默认:否"`
  16. CreateTime time.Time `description:"合同添加时间"`
  17. }
  18. //合同的服务内容
  19. type ContractServiceAndDetail struct {
  20. ContractServiceId int `orm:"column(contract_service_id);pk"`
  21. ContractId int `description:"合同id"`
  22. ProductId int `description:"产品id,1:ficc;2:权益"`
  23. ServiceTemplateId int `description:"合同服务模板id"`
  24. Title string `description:"套餐标题"`
  25. Value string `description:"套餐的值"`
  26. HasDetail string `description:"是否有详情,枚举值:是、否;默认:否"`
  27. ChartPermissionId int `description:"权限id"`
  28. DetailList []*contract_service_detail.ContractServiceDetail
  29. }
  30. //获取合同列表数据
  31. func GetContractServiceAndDetailList(contractId int) (list []*ContractServiceAndDetail, err error) {
  32. o := orm.NewOrm()
  33. sql := "select * from contract_service where contract_id = ? "
  34. _, err = o.Raw(sql, contractId).QueryRows(&list)
  35. return
  36. }