contract_service.go 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package crm
  2. import "hongze/fms_api/global"
  3. // ContractServiceAndDetail 合同的服务内容
  4. type ContractServiceAndDetail struct {
  5. ContractServiceId int `description:"套餐ID"`
  6. ContractId int `description:"合同id"`
  7. ProductId int `description:"产品id,1:ficc;2:权益"`
  8. ServiceTemplateId int `description:"合同服务模板id"`
  9. Title string `description:"套餐标题"`
  10. Value string `description:"套餐的值"`
  11. HasDetail string `description:"是否有详情,枚举值:是、否;默认:否"`
  12. TableValue string `description:"表格数据,用于word生成时的json数据"`
  13. ChartPermissionId int `description:"权限id"`
  14. ChartPermissionIds []int `description:"小套餐-权限IDs"`
  15. DetailList []*ContractServiceDetail
  16. }
  17. type ContractServiceAndDetailQueryItem struct {
  18. ContractServiceId int `description:"套餐ID"`
  19. ContractId int `description:"合同id"`
  20. ProductId int `description:"产品id,1:ficc;2:权益"`
  21. ServiceTemplateId int `description:"合同服务模板id"`
  22. Title string `description:"套餐标题"`
  23. Value string `description:"套餐的值"`
  24. HasDetail string `description:"是否有详情,枚举值:是、否;默认:否"`
  25. TableValue string `description:"表格数据,用于word生成时的json数据"`
  26. ChartPermissionId int `description:"权限id"`
  27. }
  28. func GetContractServiceAndDetailList(contractId int) (list []*ContractServiceAndDetail, err error) {
  29. results := make([]*ContractServiceAndDetailQueryItem, 0)
  30. list = make([]*ContractServiceAndDetail, 0)
  31. query := global.MYSQL["report"].
  32. Table("contract_service").
  33. Where("contract_id = ?", contractId)
  34. err = query.Find(&results).Error
  35. if err != nil {
  36. return
  37. }
  38. for i := range results {
  39. list = append(list, &ContractServiceAndDetail{
  40. ContractServiceId: results[i].ContractServiceId,
  41. ContractId: results[i].ContractId,
  42. ProductId: results[i].ProductId,
  43. ServiceTemplateId: results[i].ServiceTemplateId,
  44. Title: results[i].Title,
  45. Value: results[i].Value,
  46. HasDetail: results[i].HasDetail,
  47. TableValue: results[i].TableValue,
  48. ChartPermissionId: results[i].ChartPermissionId,
  49. })
  50. }
  51. return
  52. }