销售发票管理

zhangqian

2023-08-07 78b49f03c4dc2e5b6b00d99475e582834e4b5238

 model/serviceContract.go

@@ -3,29 +3,34 @@
import (
   "aps_crm/constvar"
   "aps_crm/pkg/mysqlx"
   "fmt"
   "github.com/shopspring/decimal"
   "gorm.io/gorm"
   "time"
)

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:备注"`
      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"`
      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;"`
      gorm.Model              `json:"-"`
   }

@@ -166,3 +171,28 @@
   slf.OrderBy = order
   return slf
}

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

   if err := db.Updates(upMap).Error; err != nil {
      return fmt.Errorf("update by map err: %v, upMap: %+v", err, upMap)
   }

   return nil
}

func (slf *ServiceContractSearch) First() (*ServiceContract, error) {
   var (
      record = new(ServiceContract)
      db     = slf.build()
   )

   if err := db.First(record).Error; err != nil {
      return record, err
   }

   return record, nil
}