model/serviceContract.go
@@ -35,6 +35,7 @@
      AmountReceivable        decimal.Decimal       `gorm:"amount_receivable" json:"amountReceivable"` // 应收金额
      AmountReceived          decimal.Decimal       `gorm:"amount_received" json:"amountReceived"`     // 已收金额
      AmountInvoiced          decimal.Decimal       `gorm:"amount_invoiced" json:"amountInvoiced"`     // 已开票金额
      AmountUnInvoiced        decimal.Decimal       `gorm:"-" json:"amountUnInvoiced"`                 // 未开票金额
      Products                []Product             `json:"products" gorm:"many2many:service_contract_product;"`
      gorm.Model              `json:"-"`
   }
@@ -70,13 +71,13 @@
   }
   switch slf.QueryClass {
   case constvar.ServiceContractQueryClassExpireAfter30Day:
      db = db.Where("end_time > ?", time.Now(), time.Now().AddDate(0, 0, 30))
      db = db.Where("end_time > ?", time.Now().AddDate(0, 0, 30).Format("2006-01-02"))
   case constvar.ServiceContractQueryClassExpireAfter60Day:
      db = db.Where("end_time > ?", time.Now(), time.Now().AddDate(0, 0, 60))
      db = db.Where("end_time > ?", time.Now().AddDate(0, 0, 60).Format("2006-01-02"))
   case constvar.ServiceContractQueryClassExpiredBefore15Day:
      db = db.Where("end_time < ?", time.Now().AddDate(0, 0, -15))
      db = db.Where("end_time < ?", time.Now().AddDate(0, 0, -15).Format("2006-01-02"))
   case constvar.ServiceContractQueryClassExpiredBefore60Day:
      db = db.Where("end_time < ?", time.Now().AddDate(0, 0, -60))
      db = db.Where("end_time < ?", time.Now().AddDate(0, 0, -60).Format("2006-01-02"))
   }
   switch slf.KeywordType {