zhangqian
2023-08-11 ae6883ce426727efca4facab973d814ae66c69c2
model/followRecord.go
@@ -3,7 +3,6 @@
import (
   "aps_crm/pkg/mysqlx"
   "gorm.io/gorm"
   "time"
)
type (
@@ -20,8 +19,8 @@
      SaleChanceId         int       `json:"sale_chance_id" gorm:"column:sale_chance_id;type:int(11);comment:销售机会id"`
      SalesLeadsId         int       `json:"sales_leads_id" gorm:"column:sales_leads_id;type:int(11);comment:销售线索id"`
      ContactInformationId int       `json:"contact_information_id" gorm:"column:contact_information_id;type:int(11);comment:联系方式id"`
      FollowTime           time.Time `json:"follow_time" gorm:"column:follow_time;type:datetime;comment:跟进时间"`
      NextFollowTime       time.Time `json:"next_follow_time" gorm:"column:next_follow_time;type:datetime;comment:下次跟进时间"`
      FollowTime           *CustomTime `json:"follow_time" gorm:"column:follow_time;type:datetime;comment:跟进时间"`
      NextFollowTime       *CustomTime `json:"next_follow_time" gorm:"column:next_follow_time;type:datetime;comment:下次跟进时间"`
      Purpose              string    `json:"purpose" gorm:"column:purpose;type:varchar(255);comment:跟进目的"`
      Content              string    `json:"content" gorm:"column:content;type:MEDIUMTEXT;comment:跟进内容"`
      Client               Client    `json:"client" gorm:"foreignKey:ClientId"`
@@ -94,6 +93,12 @@
            if key == "client_status" {
               db = db.Joins("Client").Joins("Client.ClientStatus").Where("Client__ClientStatus.name LIKE ?", "%"+v+"%")
            }
         case int:
         case int64:
         case float64:
            if key == "client_id" || key == "contact_id" || key == "sales_leads_id" || key == "sale_chance_id" {
               db = db.Where(key+" = ?", v)
            }
         }
      }
   }