| | |
|---|
| | | var ids []uint |
|---|
| | | var purchaseList = make([]*purchase.Purchase, 0) |
|---|
| | | if info.Keyword != "" { |
|---|
| | | kw := "%" + info.Keyword + "%" |
|---|
| | | db.Distinct("srm_purchase.id").Joins("left join srm_purchase_products on srm_purchase_products.purchase_id = srm_purchase.id"). |
|---|
| | | Joins("left join srm_supplier_material on srm_supplier_material.supplier_id = srm_purchase.id"). |
|---|
| | | Joins("left join srm_supplier on srm_supplier.Id = srm_purchase.supplier_id"). |
|---|
| | | Where("srm_purchase.name like ?", "%"+info.Keyword+"%"). |
|---|
| | | Or("srm_supplier_material.name like ?", "%"+info.Keyword+"%"). |
|---|
| | | Or("srm_supplier.name like ?", "%"+info.Keyword+"%") |
|---|
| | | Where("srm_purchase.name like ? or srm_purchase.source_order like ? or srm_purchase.number like ?", kw, kw, kw). |
|---|
| | | Or("srm_supplier_material.name like ?", kw). |
|---|
| | | Or("srm_supplier.name like ?", kw) |
|---|
| | | err = db.Limit(limit).Offset(offset).Find(&ids).Error |
|---|
| | | if err != nil { |
|---|
| | | return purchaseList, total, err |
|---|
