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