service/test/product.go
@@ -95,8 +95,8 @@ db = db.Where("product_type LIKE ?", "%"+info.ProductType+"%") } if info.SupplierName != "" { db = db.Joins("Supplier").Where("Supplier.name LIKE ?", "%"+info.SupplierName+"%") if info.SupplierNumber != "" { db = db.Joins("Supplier").Where("Supplier.number LIKE ?", "%"+info.SupplierNumber+"%") } err = db.Count(&total).Error