| | |
| | | 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:"-"` |
| | | } |
| | |
| | | } |
| | | 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 { |