From c92534229c83436ffe9e6752209200dd70b77808 Mon Sep 17 00:00:00 2001
From: wangpengfei <274878379@qq.com>
Date: 星期四, 17 八月 2023 19:19:44 +0800
Subject: [PATCH] add
---
model/quotation.go | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/model/quotation.go b/model/quotation.go
index 6aa4c50..99d70fe 100644
--- a/model/quotation.go
+++ b/model/quotation.go
@@ -59,20 +59,20 @@
for key, value := range slf.SearchMap {
switch v := value.(type) {
case string:
- if key == "validity_date" || key == "number" {
- db = db.Where(key+" = ?", v)
+ if key == "number" || key == "validity_date" {
+ db = db.Where(key+" LIKE ?", "%"+v+"%")
}
if key == "client_name" {
- db = db.Joins("Client").Where("client.name = ?", v)
+ db = db.Joins("Client").Where("Client.name LIKE ?", "%"+v+"%")
}
if key == "contact_name" {
- db = db.Joins("Contact").Where("contact.name = ?", v)
+ db = db.Joins("Contact").Where("Contact.name LIKE ?", "%"+v+"%")
}
- if key == "validity_date" {
- db = db.Where(key+" = ?", v)
+ if key == "member_name" {
+ db = db.Joins("Member").Where("Member.username LIKE ?", "%"+v+"%")
}
case int:
--
Gitblit v1.8.0