add

wangpengfei

2023-08-03 fe3906038b25efaf0983a7cf5fede29e26d35093

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
package model
 
import (
    "aps_crm/pkg/mysqlx"
    "gorm.io/gorm"
)
 
type (
    ServiceFollowup 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:合同编号"`
        ContactId            int                  `json:"contactId" gorm:"column:contact_id;type:int;comment:联系人id"`
        ServiceId            int                  `json:"serviceId" gorm:"column:service_id;type:int;comment:客户服务单id"`
        CustomerServiceSheet CustomerServiceSheet `json:"customerServiceSheet" gorm:"foreignKey:ServiceId"`
        MemberId             int                  `json:"memberId" gorm:"column:member_id;type:int;comment:服务人员id"`
        PlanId               int                  `json:"planId" gorm:"column:plan_id;type:int;comment:服务计划id"`
        SatisfactionId       int                  `json:"satisfactionId" gorm:"column:satisfaction_id;type:int;comment:满意度id"`
        TimelyRateId         int                  `json:"timelyRateId" gorm:"column:timely_rate_id;type:int;comment:及时率id"`
        SolveRateId          int                  `json:"solveRateId" gorm:"column:solve_rate_id;type:int;comment:解决率id"`
        IsVisitId            int                  `json:"isVisitId" gorm:"column:is_visit_id;type:int;comment:服务人员是否来过id"`
        OldMemberId          int                  `json:"oldMemberId" gorm:"column:old_member_id;type:int;comment:原服务人员"`
        Remark               string               `json:"remark" gorm:"column:remark;type:text;comment:备注"`
        File                 string               `json:"file" gorm:"column:file;type:varchar(255);comment:附件"`
 
        gorm.Model `json:"-"`
    }
 
    ServiceFollowupSearch struct {
        ServiceFollowup
 
                Orm      *gorm.DB
        Keyword  string
        OrderBy  string
        PageNum  int
        PageSize int
 
    }
)
 
func (ServiceFollowup) TableName() string {
    return "service_followup"
}
 
func NewServiceFollowupSearch() *ServiceFollowupSearch {
    return &ServiceFollowupSearch{
        Orm: mysqlx.GetDB(),
    }
}
 
func (slf *ServiceFollowupSearch) build() *gorm.DB {
    var db = slf.Orm.Model(&ServiceFollowup{})
    if slf.Keyword != "" {
        db = db.Where("name LIKE ?", "%"+slf.Keyword+"%")
    }
    if slf.Id != 0 {
        db = db.Where("id = ?", slf.Id)
    }
 
    return db
}
 
func (slf *ServiceFollowupSearch) Create(record *ServiceFollowup) error {
    var db = slf.build()
    return db.Create(record).Error
}
 
func (slf *ServiceFollowupSearch) Update(record *ServiceFollowup) error {
    var db = slf.build()
    return db.Updates(record).Error
}
 
func (slf *ServiceFollowupSearch) Delete() error {
    var db = slf.build()
    return db.Delete(&ServiceFollowup{}).Error
}
 
func (slf *ServiceFollowupSearch) Find() (*ServiceFollowup, error) {
    var db = slf.build()
    var record = &ServiceFollowup{}
    err := db.First(record).Error
    return record, err
}
 
func (slf *ServiceFollowupSearch) FindAll() ([]*ServiceFollowup, int64, error) {
    var db = slf.build()
    var records = make([]*ServiceFollowup, 0)
    var total int64
    if err := db.Count(&total).Error; err != nil {
        return records, total, err
    }
    if slf.PageNum > 0 && slf.PageSize > 0 {
        db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
    }
 
    if slf.PageNum > 0 && slf.PageSize > 0 {
        db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
    }
 
    err := db.Preload("CustomerServiceSheet").Find(&records).Error
    return records, total, err
}
 
func (slf *ServiceFollowupSearch) SetId(id int) *ServiceFollowupSearch {
    slf.Id = id
    return slf
}
 
// 可能性 币种 当前状态（销售机会）
 
func (slf *ServiceFollowupSearch) SetKeyword(keyword string) *ServiceFollowupSearch {
    slf.Keyword = keyword
    return slf
}
 
func (slf *ServiceFollowupSearch) SetPage(page, size int) *ServiceFollowupSearch {
    slf.PageNum, slf.PageSize = page, size
    return slf
}
 
func (slf *ServiceFollowupSearch) SetOrder(order string) *ServiceFollowupSearch {
    slf.OrderBy = order
    return slf
}
func (slf *ServiceFollowupSearch) SetIds(ids []int) *ServiceFollowupSearch {
    slf.Orm = slf.Orm.Where("id in (?)", ids)
    return slf
}