## mark a section (Learn more)

#Problem: I'm using a form to generate a csv for booking periods, #the form is populated from the pricing table which includes booking #periods and prices -- but the table is updated via csv import, so #the users can edit prices and periods separately. #When I render back to the form on failure, I'm getting the existing #values used to populate the 'edit' form and not the user's changes. LINK: http://tinyurl.com/35r8qa #controller. def csv is the method that re-renders form on failure: class BookingPeriodsController < ApplicationController def edit prices = Price.find(:all, :conditions => {:band => 1}) populate_dates(prices) end def validate_date start_date = 'invalid';end_date = 'invalid' notice = 'you have an invalid date' #bah! queries = [params[:date_0], params[:date_1]] dates = [start_date, end_date] queries.each_with_index do |string,i| dates[i] = parse_date(string) end if dates[0].class == Date && dates[1].class == Date if dates[0] > dates[1] notice = '<em>start date after end date...</em>' else notice = 'looks good.' end end dates.map! {|x| x.strftime("%A %d %B %Y") if x.class == Date} response = {:start_date => dates[0], :end_date => dates[1], :notice => notice} render :json => response.to_json end def find_days string = params[:period] query = string.gsub(/in/){}.split(/\s+/) if query.size > 2 year = query[2] else year = Date.today.year end month = query[1] day = query[0].singularize.titleize start_date = Date.parse("#{month} #{year}") end_date = start_date.end_of_month dates0 = DateRanger::Dates.new({:start => start_date, :end => end_date}) dates1 = DateRanger::Dates.new({:start => start_date.advance(:months => 1), :end => end_date.advance(:months => 1)}) @search_month = dates0.every(day) @next_month = dates1.every(day) render :layout => false end def csv errors = [] csv = File.new("#{RAILS_ROOT}/lib/csv/periods.csv","w+") params[:dates].each {|dates| s = dates[1][:date_0] e = dates[1][:date_1] unless s.size < 1 || e.size < 1 start_date = parse_date(s) end_date = parse_date(e) error = dates[0].to_i errors << error if start_date.nil? errors << error if end_date.nil? begin;errors << error if start_date > end_date;rescue;end csv.puts "#{start_date},#{end_date}" end } csv.close #Rake::Task["bookings:bookables"].invoke if errors.any? prices = Price.find(:all, :conditions => {:band => 1}) populate_dates(prices) flash[:errors] = errors flash[:notice] = 'There are problems with some of your dates...' render :action => 'edit' else render :text => errors end end private private def parse_date(string) begin if (string =~ /first|second|third|fourth|last/) == 0 query = string.gsub(/in/){}.downcase.split(/\s+/) if query[0] == 'last' week = -1 else week = DateRanger::ORDINALS.index(query[0]) end day = query[1].titleize begin month = Date.parse("#{query[3]}/#{query[2]}") range = DateRanger::Dates.new({:start => month, :end => month.end_of_month}) date = range.every(day,week).first rescue end else date = Date.parse(string) end rescue end date end def populate_dates(values) @dates = [] year = Date.today.year values.each do |value| date = [] if value.start_date.year > year date << value.start_date.strftime("%d %b %Y") else date << value.start_date.strftime("%d %b") end if value.end_date.year > year date << value.end_date.strftime("%d %b %Y") else date << value.end_date.strftime("%d %b") end @dates << date end end end #view form partial #errors =flash[:notice] -form_tag({:action => :csv}, :id => 'booking_periods_form') do %p =label("start_date","Start date") %p =label("end_date","End date") %p =submit_tag 'save', :class => 'submit' -@dates.each_with_index do |date,i| %span{:class => "#{date_errors(i)} #{cycle('','even')}"} %p.clear =text_field_tag("dates[#{i}_range][date_0]", date[0], {:maxlength => 50, :size => 22, :class => 'start'}) %p =text_field_tag("dates[#{i}_range][date_1]", date[1], {:maxlength => 50, :size => 22, :class => 'end'}) -10.times do |i| %span{:class => "#{date_errors(i+@dates.size)} #{cycle('','even')}"} %p.clear =text_field_tag("dates[#{i+@dates.size}_range][date_0]",nil, {:maxlength => 50, :size => 22, :class => 'start'}) %p =text_field_tag("dates[#{i+@dates.size}_range][date_1]",nil, {:maxlength => 50, :size => 22, :class => 'end'})

This paste will be private.