如何在实现 friendly_id slug 后更改 rails 应用程序上的现有搜索查询?

Question

我有一个现有的方法来查询某些模型，它们根据category_id和sub_category进行查询。在着陆页上，它曾经生成类似localhost:3000/search?category_id=208的网址，并且它曾经包含基于该类别的结果。现在我实现了friendly_idgem，我能够生成 url，如下所示localhost:3000/search?category_id=metal-processing-machine-tool.但看起来这影响了现有的搜索功能，因为尽管它根据所选category_id显示正确的 URL，但它根本不显示结果。其他单词查询未发生。

以下是我现有的搜索功能：搜索

def search_equipments
begin
if (params.keys & ['category_id', 'sub_category', 'manufacturer', 'country', 'state', 'keyword']).present?
if params[:category_id].present?
@category = Category.active.find params[:category_id]
else
@category = Category.active.find params[:sub_category] if params[:sub_category].present?
end
@root_categories = Category.active.roots
@sub_categories = @category.children.active if params[:category_id].present?
@sub_categories ||= {}
@countries = Country.active.all
@manufacturers = Manufacturer.active.all
@states = State.active.where("country_id = ?", params[:country]) if params[:country].present?
@states ||= {}
@equipments = Equipment.active.filter(params.slice(:manufacturer, :country, :state, :category_id, :sub_category, :keyword))
else
redirect_to root_path
end
rescue Exception => e
redirect_to root_path, :notice => "Something went wrong!"
end
end

这就是我目前生成网址的方式。

<%= search_equipments_path(:category_id => category.slug ) %>

这曾经是这样的。而不是category.slug它被category.id并正确使用查询。

<%= search_equipments_path(:category_id => category.id ) %>

我很迷路，因为我在实施friendly_id后无法获得预期的搜索结果。有人可以告诉我如何解决这个问题吗？

使用category.rb进行更新

class Category < ActiveRecord::Base
extend FriendlyId
friendly_id :name, use: [:slugged, :finders]
enum status: { inactive: 0, active: 1}
acts_as_nested_set
has_many :equipments, dependent: :destroy
has_many :subs_equipments, :foreign_key => "sub_category_id", :class_name => "Equipment"
has_many :wanted_equipments, dependent: :destroy
has_many :services, dependent: :destroy
validates :name, presence: true
validates_uniqueness_of  :name,message: "Category with this name already exists", scope: :parent_id
scope :active, -> { where(status: 1) }
def sub_categories
Category.where(:parent_id=>self.id)
end
def should_generate_new_friendly_id?
true
end
end

类别表

create_table "categories", force: :cascade do |t|
t.string   "name",           limit: 255
t.integer  "parent_id",      limit: 4
t.integer  "status",         limit: 4,   default: 1
t.integer  "lft",            limit: 4,               null: false
t.integer  "rgt",            limit: 4,               null: false
t.integer  "depth",          limit: 4,   default: 0, null: false
t.integer  "children_count", limit: 4,   default: 0, null: false
t.datetime "created_at",                             null: false
t.datetime "updated_at",                             null: false
t.string   "slug",           limit: 255
end

Category.new会给

<Category id: nil, name: nil, parent_id: nil, status: 1, lft: nil, rgt: nil, depth: 0, children_count: 0, created_at: nil, updated_at: nil, slug: nil>

Answer 1

问题源于@category = Category.active.find params[:category_id]。#find希望传递 id，但是当前您正在传递params[:category_id]的 slug 。

尝试使用Category.active.friendly.find params[:category_id].这将按 slug 检索类别。

本文将有所帮助。