From 115bd9b51f5d8eade4658f844de37516486c60e7 Mon Sep 17 00:00:00 2001
From: liujiandao <274878379@qq.com>
Date: 星期六, 18 十一月 2023 17:25:25 +0800
Subject: [PATCH] crm获取aps项目模块信息
---
model/customerServiceSheet.go | 73 ++++++++++++++++++++++++++++++++----
1 files changed, 65 insertions(+), 8 deletions(-)
diff --git a/model/customerServiceSheet.go b/model/customerServiceSheet.go
index 1fb8026..7d759c5 100644
--- a/model/customerServiceSheet.go
+++ b/model/customerServiceSheet.go
@@ -1,16 +1,20 @@
package model
-import "gorm.io/gorm"
+import (
+ "aps_crm/pkg/mysqlx"
+ "gorm.io/gorm"
+)
type (
CustomerServiceSheet struct {
- Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
- MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:鏈嶅姟浜哄憳id"`
- Number string `json:"number" gorm:"column:number;type:varchar(255);comment:鏈嶅姟鍗曞彿"`
- ServiceMode int `json:"serviceMode" gorm:"column:service_mode;type:int;comment:鏈嶅姟鏂瑰紡"`
- Priority int `json:"priority" gorm:"column:priority;type:int;comment:浼樺厛绾�"`
- HandleStatus int `json:"handleStatus" gorm:"column:handle_status;type:int;comment:澶勭悊鐘舵��"`
- gorm.Model `json:"-"`
+ Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
+ MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:鏈嶅姟浜哄憳id"`
+ Number string `json:"number" gorm:"column:number;type:varchar(255);comment:鏈嶅姟鍗曞彿"`
+ ServiceMode int `json:"serviceMode" gorm:"column:service_mode;type:int;comment:鏈嶅姟鏂瑰紡"`
+ Priority int `json:"priority" gorm:"column:priority;type:int;comment:浼樺厛绾�"`
+ HandleStatus int `json:"handleStatus" gorm:"column:handle_status;type:int;comment:澶勭悊鐘舵��"`
+ ServiceFollowupId int `json:"serviceFollowupId" gorm:"column:service_followup_id;type:int;comment:鏈嶅姟璺熻繘id"`
+ gorm.Model `json:"-"`
}
CustomerServiceSheetSearch struct {
@@ -18,3 +22,56 @@
Orm *gorm.DB
}
)
+
+func (CustomerServiceSheet) TableName() string {
+ return "customer_service_sheet"
+}
+
+func NewCustomerServiceSheetSearch() *CustomerServiceSheetSearch {
+ return &CustomerServiceSheetSearch{
+ Orm: mysqlx.GetDB(),
+ }
+}
+
+func (css *CustomerServiceSheetSearch) build() *gorm.DB {
+ var db = css.Orm.Model(&CustomerServiceSheet{})
+ if css.Id != 0 {
+ db = db.Where("id = ?", css.Id)
+ }
+
+ return db
+}
+
+func (css *CustomerServiceSheetSearch) Create(record *CustomerServiceSheet) error {
+ var db = css.build()
+ return db.Create(record).Error
+}
+
+func (css *CustomerServiceSheetSearch) Update(record *CustomerServiceSheet) error {
+ var db = css.build()
+ return db.Updates(record).Error
+}
+
+func (css *CustomerServiceSheetSearch) Delete() error {
+ var db = css.build()
+ return db.Delete(&CustomerServiceSheet{}).Error
+}
+
+func (css *CustomerServiceSheetSearch) Find() (*CustomerServiceSheet, error) {
+ var db = css.build()
+ var record = &CustomerServiceSheet{}
+ err := db.First(record).Error
+ return record, err
+}
+
+func (css *CustomerServiceSheetSearch) FindAll() ([]*CustomerServiceSheet, error) {
+ var db = css.build()
+ var records = make([]*CustomerServiceSheet, 0)
+ err := db.Find(&records).Error
+ return records, err
+}
+
+func (css *CustomerServiceSheetSearch) SetId(id int) *CustomerServiceSheetSearch {
+ css.Id = id
+ return css
+}
--
Gitblit v1.8.0