Folks,
I'm building a complex data entry / edit screen (to a customer spec) and am
having problems with part of it.
I render a partial for line items in an order -
<%= render :partial => 'order_product', :collection =>
@order.order_products %>
This partial contains a text box to enter a product code. When a code is
entered and you tab away from it (onblur) then it has to look up the database
for the product text. Here's the partial code which does this -
<td class="orders_code" width="30">
<% if order_product.new_record? %>
<%= f.text_field :product_code,
:size => 10,
:value => '',
:onblur => 'setProductRowID(this);RecalculateOrder();' %>
<% else %>
<%= f.text_field :product_code,
:size => 10,
:onblur => 'RecalculateOrder();' %>
<% end %>
</td>
<%
product_code_field = numprefix + 'product_code'
if order_product.new_record?
opid = ''
else
opid = order_product.id.to_s
end
%>
<%= observe_field product_code_field,
:update => 'product_details',
:url => {:controller => 'orders',
:action => 'find_base_product' },
:with
=> "'product_code='+encodeURIComponent(value)+'&noe=#{new_or_existing}&pid=#{opid}'" %>
<% if params[:action] == 'new'
p_c = ''
p_id = ''
else
if new_or_existing == 'new'
p_c = ''
p_id = ''
else
p_c = order_product.product_code
p_id = order_product.id.to_s
end
end
%>
<td class="order_product_details" id="product_details">
<%=
render :partial => "product_details",
:locals => {:product_code => p_c,
:noe => new_or_existing,
:pid => p_id
}
%>
</td>
The "product_details" partial is actually more complex than just a simple
description field, but that will suffice for the explanation. The problem is
(and thanks if you are still will be at this point) that sometimes the
description gets updated on the right "row" and other times the first line
item row (or the bottom row if the row being entered isn't the last one) in
the table gets updated.
The find_base_product method in the controller is quite simple -
def find_base_product
local_pc = params[:product_code]
local_noe = params[:noe]
local_pid = params[:pid]
render :partial => 'product_details',
:layout => false,
:locals => { :product_code => local_pc,
:noe => local_noe,
:pid => local_pid}
end
Here's what I have observed. It seems to occur on "edit" not on "new". It
happens with the first row added after the existing rows retrieved from the
DB only. If it is the last row in the line item list, then it will update
the text on the first row. If you add other line items and fill in the
product code from them it works. If you then go back to the "bad" row and
try again, then it will update the last row in the list. Additionally if
you add multiple rows without entering product codes all off then are bad.
I'm totally confused !!!
Oh, we add new rows using the following in the main partial -
<%= add_order_product_link "Add an Item (F1)" %>
This is a helper method using pretty standard RJS -
def add_order_product_link(name)
link_to_function(name, nil, :id => 'f1_link') do |page|
page.insert_html :bottom, :order_products, :partial
=> 'order_product', :object => OrderProduct.new
end
end
All help gladly received !!!
Phil
