服务单管理故障类别增删改查,服务单管理花费时间增删改查,增加服务方式、花费时间、严重程度、优先级别初始化数据

zhangqian

2023-08-05 663db1dd160e759c9401289554543b1d1ea1e5cb

 model/serviceOrder.go

@@ -12,26 +12,28 @@
   // ServiceOrder 服务单
   ServiceOrder struct {
      Id              int           `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
      ServiceNumber   string        `gorm:"service_number" json:"service_number"` // 服务单编号
      ClientId        int           `gorm:"client_id" json:"client_id"`           // 客户id
      ServiceNumber   string        `gorm:"service_number" json:"serviceNumber"` // 服务单编号
      ClientId        int           `gorm:"client_id" json:"clientId"`           // 客户id
      Client          Client        `gorm:"foreignKey:ClientId"`
      ContractId      int           `gorm:"contract_id" json:"contract_id"` // 合同id
      ContractId      int           `gorm:"contract_id" json:"contractId"` // 合同id
      Contract        Contract      `gorm:"foreignKey:ContractId"`
      OrderId         int           `gorm:"order_id" json:"order_id"` // 销售订单id
      Order           OrderManage   `gorm:"foreignKey:OrderId"`
      Subject         string        `gorm:"subject" json:"subject"`       // 主题
      ProductId       int           `gorm:"product_id" json:"product_id"` // 产品id
      OrderId         int           `gorm:"order_id" json:"orderId"` // 销售订单id
      OrderManage     OrderManage   `gorm:"foreignKey:OrderId"`
      Subject         string        `gorm:"subject" json:"subject"`      // 主题
      ProductId       int           `gorm:"product_id" json:"productId"` // 产品id
      Product         Product       `gorm:"foreignKey:ProductId"`
      ServiceTypeId   int           `gorm:"service_type_id" json:"service_type_id"` // 服务方式
      ServiceTypeId   int           `gorm:"service_type_id" json:"serviceTypeId"` // 服务方式
      ServiceType     ServiceType   `gorm:"foreignKey:ServiceTypeId"`
      ServiceManId    int           `gorm:"service_man_id" json:"service_man_id"`       // 服务人员
      LinkmanId       int           `gorm:"linkman_id" json:"linkman_id"`               // 联系人id
      ServiceManId    int           `gorm:"service_man_id" json:"serviceManId"` // 服务人员
      ContactId       int           `gorm:"linkman_id" json:"contact_id"`       // 联系人id
      Contact         Contact       `gorm:"foreignKey:ContactId"`
      Address         string        `gorm:"address" json:"address"`                     // 上门地址
      PriorityLevelId int           `gorm:"priority_level_id" json:"priority_level_id"` // 优先级别
      PriorityLevel   PriorityLevel `gorm:"foreignKey:PriorityLevelId"`
      AppointmentTime string        `gorm:"appointment_time" json:"appointment_time"` // 预约上门时间
      SaleLeads       int           `gorm:"sale_leads" json:"sale_leads"`             // 销售机会id
      SeverityId      int           `gorm:"severity_id" json:"severity"`              // 严重程度
      SaleChanceId    int           `gorm:"sale_leads" json:"saleChanceId"`           // 销售机会id
      SaleChance      SaleChance    `gorm:"foreignKey:SaleChanceId"`
      SeverityId      int           `gorm:"severity_id" json:"severity"` // 严重程度
      Severity        Severity      `gorm:"foreignKey:SeverityId"`
      Status          int           `gorm:"status" json:"status"`               // 处理状态
      ExpectTime      string        `gorm:"expect_time" json:"expect_time"`     // 希望处理时间
@@ -76,12 +78,14 @@
      db = db.Where("id = ?", slf.Id)
   }
   if slf.Preload {
      db = db.Model(&ServiceOrder{}).
      db = db.
         Preload("Client").
         Preload("Contract").
         Preload("OrderManage").
         Preload("Product").
         Preload("ServiceType").
         Preload("Contact").
         Preload("SaleChance").
         Preload("PriorityLevel").
         Preload("Severity").
         Preload("Faq")