Rails：多步形式的动态选择不保持选中状态 [英] Rails: dynamic select on multistep form not keeping selected

问题描述

我正在为Ryan Bates的撰写订单处理流程的多步表单使用会话的多步骤教程＃217 。在第一步，我有两个选择字段：一个用于国家（陆地），一个用于运输服务。选择土地后，运输服务通过javascript / jQuery加载到第二个选择字段，总价格通过JS计算。

I am working on a multistep form for an order placement process following Ryan Bates's Multistep Tutorial #217 which uses a session. On the first step I have two select fields: one for countries (land) and a dynamic one for shipping services. After a land has been selected the shipping services are loaded into the second select field through javascript/jQuery and the total price is calculated through JS.

app / views / orders / _shipping_step.html.erb

app/views/orders/_shipping_step.html.erb

<%= f.collection_select(:land_id, Land.all, :id, :name, {:prompt => "select a country"}, {:id => 'lands_select'}) %>
<%= f.select(:shippingservice_id, options_for_select(@shippingservices.collect { |s| [s.name.titleize, s.id, {'data-price' => s.price}] }, :selected => f.object.shippingservice_id), {:prompt => "select a carrier"}, {:id => "shippingservices_select"}) %>

ajax script

ajax script

$(document).on("change", "#lands_select", function(event){
  $.ajax({
    url: "/carts/update_shipping/" + event.target.value,
    type: "GET",
  })
});

在多步骤表格的运费详情步骤中，我可以选择土地，相应的装运选项是加载，我可以选择一个。在进入付款步骤时，我可以下订单并且一切正常，但是如果我想从付款步骤返回到订单步骤以更改某些内容，则送货服务选择器显示land_id = 1的选项，而土地选择显示选择国家/地区，例如ID 85。

On the shipping details step of the multistep form I can choose a land, the corresponding options for shipment are loaded and I can choose one. When progressing to the payment step, I can place the order and everything works, but in case I want to return from the payment step to the order step to change something, the shipping services selector displays options for land_id = 1, while the land select displays the choose country, for example id 85.

我添加：selected =>会话[：cart_params] 到送货服务选择，但它似乎没有工作。 ：selected => f.object.shippingservice_id 保留优先或标准送货选项，但对于Land_id 1。

I added :selected => session[:cart_params] to the shipping service select, but it does not appear to be working. :selected => f.object.shippingservice_id keeps priority or standard shipping options, but for Land_id 1.

我如何才能使这个工作？是选择领域还是JS？为什么第二个选择不将选定的土地保留在内存中？

How can I get this working? Is it the select field or the JS? Why doesn't the second select keep the chosen land in memory?

提前谢谢！

LOG ：

Started GET "/orders/new" for 127.0.0.1 at Thu Dec 27 22:08:52 +0100 2018
Processing by OrdersController#new as HTML
  Cart Load (0.3ms)  SELECT `carts`.* FROM `carts` WHERE `carts`.`id` = ? LIMIT 1  [["id", 1]]
  Land Load (1.4ms)  SELECT `lands`.* FROM `lands` 
  CartItem Load (0.3ms)  SELECT `cart_items`.* FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`length`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`width`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
  CACHE (0.0ms)  SELECT `lands`.* FROM `lands` 
  Shippingservice Load (0.6ms)  SELECT `shippingservices`.* FROM `shippingservices` INNER JOIN `zones` ON `zones`.`id` = `shippingservices`.`zone_id` INNER JOIN `lands_zones` ON `lands_zones`.`zone_id` = `zones`.`id` INNER JOIN `lands` ON `lands`.`id` = `lands_zones`.`land_id` WHERE `lands`.`id` = 1 AND (weightmin <= 50 AND weightmax >= 50 AND heightmin <= 3 AND heightmax >= 3 AND shippingservices.shippingcarrier = ‘1’) AND (lengthmax >= 210 AND widthmax >= 149)
  Product Load (0.3ms)  SELECT `products`.* FROM `products` WHERE `products`.`id` = 3 LIMIT 1
  Hero Load (0.2ms)  SELECT `heros`.* FROM `heros` WHERE `heros`.`id` = 18 LIMIT 1
  Rendered orders/_shipping_step.html.erb (13.7ms)
  Rendered orders/new.html.erb within layouts/application (16.2ms)
  Rendered layouts/_header.html.erb (0.1ms)
  Rendered layouts/_footer.html.erb (0.1ms)
Completed 200 OK in 44ms (Views: 23.0ms | ActiveRecord: 3.9ms)

选择送货国家：

Started GET "/carts/update_shipping/85" for 127.0.0.1 at Thu Dec 27 22:09:27 +0100 2018
Processing by CartsController#update_shipping as */*
  Parameters: {"id"=>"85"}
  Cart Load (0.2ms)  SELECT `carts`.* FROM `carts` WHERE `carts`.`id` = ? LIMIT 1  [["id", 1]]
  Land Load (66.9ms)  SELECT `lands`.* FROM `lands` 
  CartItem Load (0.4ms)  SELECT `cart_items`.* FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`length`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`width`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
  Shippingservice Load (0.6ms)  SELECT `shippingservices`.* FROM `shippingservices` INNER JOIN `zones` ON `zones`.`id` = `shippingservices`.`zone_id` INNER JOIN `lands_zones` ON `lands_zones`.`zone_id` = `zones`.`id` INNER JOIN `lands` ON `lands`.`id` = `lands_zones`.`land_id` WHERE `lands`.`id` = 85 AND (weightmin <= 50 AND weightmax >= 50 AND heightmin <= 3 AND heightmax >= 3 AND shippingservices.shippingcarrier = ‘1’) AND (lengthmax >= 210 AND widthmax >= 149)
  Rendered carts/_shippingservice.html.erb (0.2ms)
  Rendered carts/update_shipping.js.erb (2.9ms)
Completed 200 OK in 87ms (Views: 7.8ms | ActiveRecord: 68.6ms)

进展到下一步：

Started POST "/orders" for 127.0.0.1 at Thu Dec 27 22:09:33 +0100 2018
Processing by OrdersController#create as HTML
  Parameters: {"order"=>{"ship_to_last_name"=>"surname", "ship_to_address"=>"street", "ship_to_city"=>"city", "ship_to_postal_code"=>"postcode", "phone_number"=>"somenumber", "shippingservice_id"=>"27", "email"=>"[e-mail]", "land_id"=>"85", "ship_to_first_name"=>"firstname"}, "authenticity_token"=>"somestring", "utf8"=>"✓", "commit"=>"Continue"}
  Cart Load (0.2ms)  SELECT `carts`.* FROM `carts` WHERE `carts`.`id` = ? LIMIT 1  [["id", 1]]
  Land Load (1.5ms)  SELECT `lands`.* FROM `lands` 
  CartItem Load (0.4ms)  SELECT `cart_items`.* FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`length`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.2ms)  SELECT MAX(`cart_items`.`width`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
  Land Load (0.4ms)  SELECT `lands`.* FROM `lands` WHERE `lands`.`id` = 85 LIMIT 1
  Shippingservice Load (0.3ms)  SELECT `shippingservices`.* FROM `shippingservices` WHERE `shippingservices`.`id` = 27 LIMIT 1
  Product Load (0.3ms)  SELECT `products`.* FROM `products` WHERE `products`.`id` = 3 LIMIT 1
  Hero Load (0.3ms)  SELECT `heros`.* FROM `heros` WHERE `heros`.`id` = 18 LIMIT 1
  Rendered orders/_payment_step.html.erb (7.0ms)
  Rendered orders/new.html.erb within layouts/application (8.9ms)
  Rendered layouts/_header.html.erb (0.1ms)
  Rendered layouts/_footer.html.erb (0.0ms)
Completed 200 OK in 39ms (Views: 13.7ms | ActiveRecord: 4.6ms)

返回发货详情步骤：

Started POST "/orders" for 127.0.0.1 at Thu Dec 27 22:09:35 +0100 2018
Processing by OrdersController#create as HTML
  Parameters: {"authenticity_token"=>"somestring", "utf8"=>"✓", "back_button"=>"Back"}
  Cart Load (0.3ms)  SELECT `carts`.* FROM `carts` WHERE `carts`.`id` = ? LIMIT 1  [["id", 1]]
  Land Load (2.4ms)  SELECT `lands`.* FROM `lands` 
  CartItem Load (0.5ms)  SELECT `cart_items`.* FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.3ms)  SELECT MAX(`cart_items`.`length`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
   (0.4ms)  SELECT MAX(`cart_items`.`width`) AS max_id FROM `cart_items` WHERE `cart_items`.`cart_id` = 1
  CACHE (0.0ms)  SELECT `lands`.* FROM `lands` 
  Shippingservice Load (0.7ms)  SELECT `shippingservices`.* FROM `shippingservices` INNER JOIN `zones` ON `zones`.`id` = `shippingservices`.`zone_id` INNER JOIN `lands_zones` ON `lands_zones`.`zone_id` = `zones`.`id` INNER JOIN `lands` ON `lands`.`id` = `lands_zones`.`land_id` WHERE `lands`.`id` = 1 AND (weightmin <= 50 AND weightmax >= 50 AND heightmin <= 3 AND heightmax >= 3 AND shippingservices.shippingcarrier = ‘1’) AND (lengthmax >= 210 AND widthmax >= 149)
  Product Load (0.3ms)  SELECT `products`.* FROM `products` WHERE `products`.`id` = 3 LIMIT 1
  Hero Load (0.2ms)  SELECT `heros`.* FROM `heros` WHERE `heros`.`id` = 18 LIMIT 1
  Rendered orders/_shipping_step.html.erb (16.5ms)
  Rendered orders/new.html.erb within layouts/application (18.4ms)
  Rendered layouts/_header.html.erb (0.2ms)
  Rendered layouts/_footer.html.erb (0.1ms)
Completed 200 OK in 109ms (Views: 24.0ms | ActiveRecord: 5.1ms)

更新

这是我的 orders_controller.rb的一部分

before_filter :initialize_cart

def new
  session[:order_params] ||= {}
  @order = Order.new(session[:order_params])
  @order.current_step = session[:order_step]
  @shippingservices = @cart.available_shipping_services.joins(:lands).where(:lands => {:id => session[:cart_params]})
end

def create
  session[:order_params].deep_merge!(params[:order]) if params[:order]
  @order = Order.new(session[:order_params])
  @shippingservices = @cart.available_shipping_services.joins(:lands).where(:lands => {:id => session[:cart_params]})
  @order.current_step = session[:order_step]
  if @order.valid?
    if params[:back_button]
      @order.previous_step
    elsif @order.last_step? && params[:commit] == 'Option A'
      …
    elsif @order.last_step? && params[:commit] == 'Option B'
      …
    else
      @order.next_step
    end
    session[:order_step] = @order.current_step
  end
  if @order.new_record?
    render "new"
  else
    # Empty the cart
    @cart.cart_items.destroy_all
    # Reset session
    session[:order_step] = session[:order_params] = nil
  end
end

当我指定一个id时通过Land.first.id或Land.last.id，查询有效，后退步骤似乎正常工作。

When I specify an id such as through Land.first.id or Land.last.id, the query works and the back step appears to be working.

使用会话时[：order_params] 我在订单#create 中得到 ActiveRecord :: StatementInvalid但是存在正确的land_id：

When using session[:order_params] I get ActiveRecord::StatementInvalid in Orders#create but the correct land_id is present:

Mysql::Error: Unknown column 'id.ship_to_last_name' in 'where clause': SELECT `shippingservices`.* FROM `shippingservices` 
INNER JOIN `zones` ON `zones`.`id` = `shippingservices`.`zone_id` 
INNER JOIN `lands_zones` ON `lands_zones`.`zone_id` = `zones`.`id` 
INNER JOIN `lands` ON `lands`.`id` = `lands_zones`.`land_id` 
WHERE `id`.`ship_to_last_name` = 'Smith' 
AND `id`.`ship_to_address` = 'Somewherestreet' 
AND `id`.`ship_to_city` = 'Nowheretown' 
AND `id`.`ship_to_postal_code` = '99999' 
AND `id`.`phone_number` = 'some number' 
AND `id`.`shippingservice_id` = '34' 
AND `id`.`email` = '[e-mail]' 
AND `id`.`land_id` = '85' 
AND `id`.`ship_to_first_name` = 'John' 
AND (weightmin <= 200 AND weightmax >= 200 AND heightmin <= 12 AND heightmax >= 12 AND shippingservices.shippingcarrier = '1') AND (lengthmax >= 210 AND widthmax >= 149)

推荐答案

@shippingservices = @ cart.available_shipping_services.joins（：lands）.where（：lands => {：id =>会话[：cart_params]}）

这未正确使用会话[：cart_params] 获取 land_id ，以便在通过表单移回时设置订单。我们可以使用 @order = Order.new（session [：order_params]）定义上面的一行来抓取 @ order.land_id 并且不必依赖任何会话。

This was not correctly using the session[:cart_params] to get the land_id in order to set the orders land when moving back through the form. We can instead use @order = Order.new(session[:order_params]) defined one line above to grab @order.land_id and not have to rely on any of the sessions.

如果订单在没有相应的土地的情况下有可能被初始化，我还会添加存在检查。

I would also add an existence check if there is a possibility of an Order being initialized without a corresponding Land.

这篇关于Rails：多步形式的动态选择不保持选中状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！