service/test/product.go
@@ -99,6 +99,14 @@ db = db.Joins("Supplier").Where("Supplier.number LIKE ?", "%"+info.SupplierNumber+"%") } if info.DeliveryTime != 0 { db = db.Where("delivery_time = ?", info.DeliveryTime) } if info.ShippingDuration != 0 { db = db.Where("shipping_duration = ?", info.ShippingDuration) } err = db.Count(&total).Error if err != nil { return