| | |
| | | db := global.GVA_DB.Model(&test.Supplier{}) |
| | | var ss []test.Supplier |
| | | // 如果有条件搜索 下方会自动创建搜索语句 |
| | | if info.Keyword != "" { |
| | | keyword := "%" + info.Name + "%" |
| | | db = db.Where("name LIKE ? or number LIKE ?", keyword, keyword) |
| | | } |
| | | if info.StartCreatedAt != nil && info.EndCreatedAt != nil { |
| | | db = db.Where("created_at BETWEEN ? AND ?", info.StartCreatedAt, info.EndCreatedAt) |
| | | } |
| | |
| | | if info.SupplierId > 0 { |
| | | db = db.Where("supplier_id = ?", info.SupplierId) |
| | | } |
| | | if info.Number != "" { |
| | | db = db.Where("number = ?", info.Number) |
| | | } |
| | | err := db.Count(&total).Error |
| | | if err != nil { |
| | | return ps, total, err |