服务合同列表增加关联内容返回

zhangqian

2023-08-09 090680391d6c9d51e31d30319ab6d35cc937aaf3

 model/serviceContract.go

@@ -11,26 +11,31 @@

type (
   ServiceContract struct {
      Id                      int             `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
      ClientId                int             `json:"clientId" gorm:"column:client_id;type:int;comment:客户id"`
      Number                  string          `json:"number" gorm:"column:number;type:varchar(255);comment:合同编号"`
      MemberId                int             `json:"memberId" gorm:"column:member_id;type:int;comment:负责人id"`
      ContactId               int             `json:"contactId" gorm:"column:contact_id;type:int;comment:联系人id"`
      SaleChanceId            int             `json:"saleChanceId" gorm:"column:sale_chance_id;type:int;comment:销售机会id"`
      ContractId              int             `json:"contractId" gorm:"column:contract_id;type:int;comment:合同id"`
      QuotationId             int             `json:"quotationId" gorm:"column:quotation_id;type:int;comment:报价单id"`
      ServiceContractTypeId   int             `json:"serviceContractTypeId" gorm:"column:service_contract_type_id;type:int;comment:合同类型id"`
      SignTime                time.Time       `json:"signTime" gorm:"column:sign_time;type:datetime;comment:签约时间"`
      StartTime               time.Time       `json:"startTime" gorm:"column:start_time;type:datetime;comment:开始时间"`
      EndTime                 time.Time       `json:"endTime" gorm:"column:end_time;type:datetime;comment:结束时间"`
      ServiceContractStatusId int             `json:"serviceContractStatusId" gorm:"column:service_contract_status_id;type:int;comment:合同状态id"`
      ServiceTimes            int             `json:"serviceTimes" gorm:"column:service_times;type:int;comment:服务次数"`
      Terms                   string          `json:"terms" gorm:"column:terms;type:text;comment:条款"`
      Remark                  string          `json:"remark" gorm:"column:remark;type:text;comment:备注"`
      AmountReceivable        decimal.Decimal `gorm:"amount_receivable" json:"amountReceivable"` // 应收金额
      AmountReceived          decimal.Decimal `gorm:"amount_received" json:"amountReceived"`     // 已收金额
      AmountInvoiced          decimal.Decimal `gorm:"amount_invoiced" json:"amountInvoiced"`     // 已开票金额
      Products                []Product       `json:"products" gorm:"many2many:serviceContract_product;"`
      Id                      int                   `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
      ClientId                int                   `json:"clientId" gorm:"column:client_id;type:int;comment:客户id"`
      Number                  string                `json:"number" gorm:"column:number;type:varchar(255);comment:合同编号"`
      MemberId                int                   `json:"memberId" gorm:"column:member_id;type:int;comment:负责人id"`
      ContactId               int                   `json:"contactId" gorm:"column:contact_id;type:int;comment:联系人id"`
      SaleChanceId            int                   `json:"saleChanceId" gorm:"column:sale_chance_id;type:int;comment:销售机会id"`
      SaleChance              SaleChance            `json:"SaleChance" gorm:"foreignKey:SaleChanceId"`
      SalesDetailsId          int                   `json:"salesDetailsId" gorm:"column:sales_details_id;type:int;comment:合同订单id"`
      SalesDetails            SalesDetails          `json:"salesDetails" gorm:"foreignKey:SalesDetailsId"`
      QuotationId             int                   `json:"quotationId" gorm:"column:quotation_id;type:int;comment:报价单id"`
      Quotation               Quotation             `json:"quotation" gorm:"foreignKey:QuotationId"`
      ServiceContractTypeId   int                   `json:"serviceContractTypeId" gorm:"column:service_contract_type_id;type:int;comment:合同类型id"`
      ServiceContractType     ServiceContractType   `json:"serviceContractType" gorm:"foreignKey:ServiceContractTypeId"`
      SignTime                time.Time             `json:"signTime" gorm:"column:sign_time;type:datetime;comment:签约时间"`
      StartTime               time.Time             `json:"startTime" gorm:"column:start_time;type:datetime;comment:开始时间"`
      EndTime                 time.Time             `json:"endTime" gorm:"column:end_time;type:datetime;comment:结束时间"`
      ServiceContractStatusId int                   `json:"serviceContractStatusId" gorm:"column:service_contract_status_id;type:int;comment:合同状态id"`
      ServiceContractStatus   ServiceContractStatus `json:"serviceContractStatus" gorm:"foreignKey:ServiceContractStatusId"`
      ServiceTimes            int                   `json:"serviceTimes" gorm:"column:service_times;type:int;comment:服务次数"`
      Terms                   string                `json:"terms" gorm:"column:terms;type:text;comment:条款"`
      Remark                  string                `json:"remark" gorm:"column:remark;type:text;comment:备注"`
      AmountReceivable        decimal.Decimal       `gorm:"amount_receivable" json:"amountReceivable"` // 应收金额
      AmountReceived          decimal.Decimal       `gorm:"amount_received" json:"amountReceived"`     // 已收金额
      AmountInvoiced          decimal.Decimal       `gorm:"amount_invoiced" json:"amountInvoiced"`     // 已开票金额
      Products                []Product             `json:"products" gorm:"many2many:service_contract_product;"`
      gorm.Model              `json:"-"`
   }

@@ -44,6 +49,7 @@
      OrderBy     string
      PageNum     int
      PageSize    int
      Preload     bool
   }
)

@@ -97,6 +103,15 @@
      //todo

   }
   if slf.Preload {
      db = db.
         Preload("SaleChance").
         Preload("SalesDetails").
         Preload("Quotation").
         Preload("ServiceContractType").
         Preload("ServiceContractStatus").
         Preload("Products")
   }

   return db
}
@@ -116,14 +131,7 @@
   return db.Delete(&ServiceContract{}).Error
}

func (slf *ServiceContractSearch) Find() (*ServiceContract, error) {
   var db = slf.build()
   var record = &ServiceContract{}
   err := db.First(record).Error
   return record, err
}

func (slf *ServiceContractSearch) FindAll() ([]*ServiceContract, int64, error) {
func (slf *ServiceContractSearch) Find() ([]*ServiceContract, int64, error) {
   var db = slf.build()
   var records = make([]*ServiceContract, 0)
   var total int64
@@ -134,11 +142,7 @@
      db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
   }

   if slf.PageNum > 0 && slf.PageSize > 0 {
      db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
   }

   err := db.Preload("Products").Find(&records).Error
   err := db.Find(&records).Error
   return records, total, err
}

@@ -176,6 +180,11 @@
   return slf
}

func (slf *ServiceContractSearch) SetPreload(preload bool) *ServiceContractSearch {
   slf.Preload = preload
   return slf
}

func (slf *ServiceContractSearch) UpdateByMap(upMap map[string]interface{}) error {
   var (
      db = slf.build()