| | |
|---|
| | | 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+"%") |
|---|
| | |
|---|
| | | db = db.Where("number LIKE ?", "%"+info.Number+"%") |
|---|
| | | } |
|---|
| | | |
|---|
| | | supplierIds := []uint{0} |
|---|
| | | if info.SupplierId != 0 { |
|---|
| | | db = db.Where("supplier_id = ?", info.SupplierId) |
|---|
| | | supplierIds = append(supplierIds, info.SupplierId) |
|---|
| | | } |
|---|
| | | db = db.Where("supplier_id in (?)", supplierIds) |
|---|
| | | |
|---|
| | | err = db.Count(&total).Error |
|---|
| | | if err != nil { |
|---|
