| | |
| | | package model |
| | | |
| | | import ( |
| | | "aps_crm/constvar" |
| | | "aps_crm/pkg/mysqlx" |
| | | "gorm.io/gorm" |
| | | "time" |
| | |
| | | if key == "next_visit_time" { |
| | | db = db.Where(key+" = ?", v) |
| | | } |
| | | |
| | | // 查询超出15天未联系的客户 |
| | | if key == "not_contact" { |
| | | db = db.Joins("FollowRecord").Where("FollowRecord.follow_time < ?", time.Now().AddDate(0, 0, -15)).Group("clients.id") |
| | | } |
| | | |
| | | // 查询公海客户 |
| | | if key == "public_sea" { |
| | | db = db.Where("member_id = ?", constvar.UserTypeSuper) |
| | | } |
| | | |
| | | case int: |
| | | if key == "id" || key == "client_type_id" || key == "client_status_id" || key == "member_id" { |
| | | db = db.Where(key+" = ?", v) |