fms_api/models/fms/contract_service.go

package fms

import (
	"hongze/fms_api/global"
	"hongze/fms_api/models/base"
)

// ContractService 合同服务套餐
type ContractService struct {
	ContractServiceId  int    `gorm:"primaryKey;column:contract_service_id" json:"contract_service_id"`
	ContractRegisterId int    `gorm:"column:contract_register_id" json:"contract_register_id" description:"登记ID"`
	ProductId          int    `gorm:"column:product_id" json:"product_id" description:"产品ID"`
	ServiceTemplateId  int    `gorm:"column:service_template_id" json:"service_template_id" description:"合同服务模板ID"`
	Title              string `gorm:"column:title" json:"title" description:"套餐名称"`
	Value              string `gorm:"column:value" json:"value" description:"套餐的值"`
	TableValue         string `gorm:"column:table_value" json:"table_value" description:"表格数据，用于word生成时的json数据"`
	HasDetail          string `gorm:"column:has_detail" json:"has_detail" description:"是否有详情: 无; 有"`
	ChartPermissionId  int    `gorm:"column:chart_permission_id" json:"chart_permission_id" description:"权限ID"`
	ChartPermissionIds string `gorm:"column:chart_permission_ids" json:"chart_permission_ids" description:"权限IDs-小套餐"`
	base.TimeBase
}

func (c *ContractService) TableName() string {
	return "contract_service"
}

func (c *ContractService) List(condition string, pars []interface{}) (list []*ContractService, err error) {
	list = make([]*ContractService, 0)
	err = global.DEFAULT_MYSQL.Model(c).
		Where(condition, pars...).
		Find(&list).Error
	return
}

// ContractServiceAddReq 新增合同套餐请求体
type ContractServiceAddReq struct {
	ServiceTemplateId  int                             `json:"service_template_id" description:"服务套餐id"`
	Title              string                          `json:"title" description:"服务套餐名称"`
	Value              string                          `json:"value" description:"服务套餐内容"`
	Detail             [][]ContractServiceDetailAddReq `json:"detail" description:"详情数据"`
	ChartPermissionIds string                          `json:"chart_permission_ids" description:"品种权限"`
}

// ContractServiceAndDetail 合同的服务内容
type ContractServiceAndDetail struct {
	ContractServiceId  int                      `json:"contract_service_id" description:"合同服务ID"`
	ContractRegisterId int                      `json:"contract_register_id" description:"合同登记ID"`
	ProductId          int                      `json:"product_id" description:"产品id，1：ficc；2：权益"`
	ServiceTemplateId  int                      `json:"service_template_id" description:"合同服务模板id"`
	Title              string                   `json:"title" description:"套餐标题"`
	Value              string                   `json:"value" description:"套餐的值"`
	HasDetail          string                   `json:"has_detail" description:"是否有详情，枚举值：是、否；默认：否"`
	TableValue         string                   `json:"table_value" description:"表格数据，用于word生成时的json数据"`
	ChartPermissionId  int                      `json:"chart_permission_id" description:"权限id"`
	ChartPermissionIds string                   `json:"chart_permission_ids" description:"品种权限-小套餐"`
	DetailList         []*ContractServiceDetail `json:"detail_list"`
}

// GetContractServiceAndDetailList 根据id获取合同列表数据
func GetContractServiceAndDetailList(contractRegisterId int) (list []*ContractServiceAndDetail, err error) {
	err = global.DEFAULT_MYSQL.Model(ContractService{}).
		Where("contract_register_id = ?", contractRegisterId).
		Find(&list).Error
	return
}

// GetContractRegisterIdsByTempId 套餐模板ID获取关联的合同登记ID
func GetContractRegisterIdsByTempId(tempId int) (registerIds []int, err error) {
	err = global.DEFAULT_MYSQL.Model(ContractService{}).
		Select("DISTINCT contract_register_id").
		Where("service_template_id = ?", tempId).
		Find(&registerIds).Error
	return
}

// ContractRegisterServicesName 合同登记套餐信息
type ContractRegisterServicesName struct {
	ContractRegisterId int    `json:"contract_register_id" description:"登记ID"`
	ServicesName       string `json:"services_name" description:"套餐信息, 英文逗号拼接"`
}

// GetContractRegisterServicesNameByRegisterIds 合同登记IDs获取套餐拼接字符串
func GetContractRegisterServicesNameByRegisterIds(registerIds []int) (list []*ContractRegisterServicesName, err error) {
	list = make([]*ContractRegisterServicesName, 0)
	err = global.DEFAULT_MYSQL.Model(ContractService{}).
		Select("contract_register_id, GROUP_CONCAT(title) AS services_name").
		Where("contract_register_id IN ?", registerIds).
		Group("contract_register_id").
		Find(&list).Error
	return
}