From e338de93e52c51d42606e5413cd768a4324f12f7 Mon Sep 17 00:00:00 2001
From: wangpengfei <274878379@qq.com>
Date: 星期三, 02 八月 2023 19:39:39 +0800
Subject: [PATCH] fix
---
model/client.go | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/model/client.go b/model/client.go
index a026006..7aa3e28 100644
--- a/model/client.go
+++ b/model/client.go
@@ -70,11 +70,23 @@
for key, value := range slf.SearchMap {
switch v := value.(type) {
case string:
- if key == "name" || key == "number" || key == "phone" || key == "detail_address" {
+ if key == "name" || key == "number" || key == "detail_address" {
db = db.Where(key+" LIKE ?", "%"+v+"%")
}
+
+ if key == "phone" {
+ db = db.Joins("Contacts").Where("Contacts.phone LIKE ?", "%"+v+"%")
+ }
+
+ if key == "contact_name" {
+ db = db.Joins("Contacts").Where("Contacts.name LIKE ?", "%"+v+"%")
+ }
+
+ if key == "next_visit_time" {
+ db = db.Where(key+" = ?", v)
+ }
case int:
- if key == "id" || key == "client_type_id" || key == "client_status_id" {
+ if key == "id" || key == "client_type_id" || key == "client_status_id" || key == "member_id" {
db = db.Where(key+" = ?", v)
}
}
--
Gitblit v1.8.0