| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | if slf.Keyword != "" { |
|---|
| | | db = db.Where("product_name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)) |
|---|
| | | //db = db.Where("Product.name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)) |
|---|
| | | db.Joins("left join wms_location on wms_location_product.location_id = wms_location.id"). |
|---|
| | | Joins("left join material on wms_location_product.product_id = material.id"). |
|---|
| | | Joins("left join wms_product_category on wms_location_product.product_category_id = wms_product_category.id"). |
|---|
| | | Where("wms_location.name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)). |
|---|
| | | Or("material.name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)). |
|---|
| | | Or("wms_product_category.name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)) |
|---|
| | | } |
|---|
| | | |
|---|
| | | if slf.Preload { |
|---|
