| | |
| | | var ps []test.SupplierMaterial |
| | | //搜索框合一添加查询条件 |
| | | if info.Keyword != "" { |
| | | db = db.Where("`srm_supplier_material`.name LIKE ?", "%"+info.Keyword+"%").Joins("Supplier").Or("Supplier.name LIKE ?", "%"+info.Keyword+"%") |
| | | kw := "%" + info.Keyword + "%" |
| | | if info.SupplierId == 0 { |
| | | db = db.Where("`srm_supplier_material`.name LIKE ?", kw).Joins("Supplier").Or("Supplier.name LIKE ?", kw) |
| | | } else { |
| | | db = db.Where("name LIKE ? OR number LIKE ? OR specifications LIKE ?", kw, kw, kw) |
| | | } |
| | | |
| | | } |
| | | if info.Name != "" { |
| | | db = db.Where("name LIKE ?", "%"+info.Name+"%") |