表单中的更改不会保存到数据库中 [英] Changes in the form are not saved to database

问题描述

我正在尝试向表单中添加日期字段.

I'm trying to add a date field to my form.

我添加了 bootstrap-datepicker-rails gem，所有需要的 css 和 javascript.

I added bootstrap-datepicker-rails gem, all required css and javascript.

当我在日历中选择日期并单击保存时，它不会在数据库中更新.

When I choose the date in the calendar and click Save, it's not updated in the database.

表格代码如下:

= simple_form_for @model
  = f.input :date_last, :required => true, 
            :input_html => { data: {behaviour: "datepicker"}}, 
            :as => :string
  = f.button :submit, 'Save', :class => 'btn btn-primary'

我认为这可能与格式有关，但不确定在哪里查看.

I think this might have to do with formats, but not sure where to look at.

更新

当我将默认格式更改为 yyyy-mm-dd(默认为 mm/dd/yyyy)时它有效:

It works when I change default format to yyyy-mm-dd (default is mm/dd/yyyy):

$('[data-behaviour~=datepicker]').datepicker({"format": "yyyy-mm-dd", "weekStart": 1, "autoclose": true});

推荐答案

我刚刚在这里回答了一个类似的问题并且有包括我的回答如下:

I just answered a similar question here and have included my answer below:

我还需要让它工作并支持多个不使用以美国为中心的日期格式的语言环境，例如:en-AU(澳大利亚)，其日期格式为 dd/mm/yyyy.

I also needed to get this working and support multiple locales that do not use US centric date formats, eg: en-AU (Australia) which has the date format dd/mm/yyyy.

Rails 期望浏览器的日期格式为 yyyy-mm-dd，但您希望以用户的语言环境显示日期.虽然日期控件允许您指定显示格式，但它不允许您单独指定要发送回服务器的格式.

Rails expects the date format to be yyyy-mm-dd from the browser, yet you want to display the date in the user's locale. Whilst the date control allows you to specify the format for display it does NOT allow you to separately specify the format to be sent back to the server.

构建一个隐藏的输入字段，将正确的格式发送回您的 rails 服务器.我使用一个自定义 simple_form 输入控件来完成此操作，该控件构建了日期选择器输入字段和一个隐藏字段，并在输入控件更改时使用一些 javascript 转换为 rails 日期.

Build a hidden input field that sends the correct format back to your rails server. I do this with with a custom simple_form input control that builds both the date-picker input field and a hidden field, and use some javascript to convert to the rails date when the input control changes.

结果是你可以在 rails 中使用一个很好的引导日期选择器，并将它与 simple_form 一起使用，如下所示:

The upshot is you can have a nice bootstrap date-picker in rails and use it with simple_form as follows:

<%= f.input :date, as: :bootstrap_datepicker %>

或者使用长日期格式:

<%= f.input :date, as: :bootstrap_datepicker, input_html: { format: :long } %>

实施

创建或编辑以下文件:

Implementation

Create or edit the following files:

Gemfile

gem 'bootstrap-sass'
gem 'bootstrap-datepicker-rails'

config/locales/en-AU.yml

en-AU:
  date:
    datepicker:
      default: "dd/mm/yyyy"
      long: "dd MM, yyyy"
    formats:
      default: ! '%d/%m/%Y'
      long: ! '%d %B, %Y'

config/locales/en-US.yml

en-US:
  date:
    datepicker:
      default: "mm/dd/yyyy"
      long: "MM dd, yyyy"
    formats:
      default: "%m/%d/%Y"
      long: ! '%B %d, %Y'

app/assets/stylesheets/application.css.scss

@import "bootstrap-responsive";
@import "bootstrap-datepicker";

app/assets/javascripts/application.js.coffee

#= require bootstrap
#= require bootstrap-datepicker
#= require bootstrap-datepicker-rails

或者，app/assets/javascripts/application.js

//= require bootstrap
//= require bootstrap-datepicker
//= require bootstrap-datepicker-rails

app/assets/javascripts/bootstrap-datepicker-rails.js.coffee

$ ->
  # convert bootstrap-datepicker value to rails date format (yyyy-mm-dd) on our hidden field
  $(document).on 'changeDate', '.bootstrap-datepicker', (evt) ->
    rails_date = evt.date.getFullYear() + '-' + ('0' + (evt.date.getMonth() + 1)).slice(-2) + '-' + ('0' + evt.date.getDate()).slice(-2)
    $(this).next("input[type=hidden]").val(rails_date)

app/inputs/bootstrap_datepicker_input.rb

class BootstrapDatepickerInput < SimpleForm::Inputs::Base
  def input
    text_field_options = input_html_options.with_indifferent_access
    format =  text_field_options.delete(:format)
    hidden_field_options = text_field_options.dup
    hidden_field_options[:class] = text_field_options[:class].dup # so they won't work with same array object
    hidden_field_options[:id] = "#{attribute_name}_hidden"
    text_field_options[:class] << 'bootstrap-datepicker'
    text_field_options[:type] = 'text'
    text_field_options[:value] ||= format_date(value(object), format)
    set_data_option text_field_options, 'date-format', I18n.t(format, scope: [:date, :datepicker], default: :default)
    default_data_option text_field_options, 'provide', 'datepicker'

    return_string =
      "#{@builder.text_field(attribute_name, text_field_options.to_hash)}
" +
      "#{@builder.hidden_field(attribute_name, hidden_field_options.to_hash)}
"
    return return_string.html_safe
  end

protected

  def default_data_option(hash, key, value)
    set_data_option(hash,key,value) unless data_option(hash, key)
  end

  def data_option(hash, key)
    hash[:data].try(:[],key) || hash["data-#{key}"]
  end

  def set_data_option(hash, key, value)
    hash[:data].try(:[]=,key,value) || (hash["data-#{key}"] = value)
  end

  def value(object)
    object.send @attribute_name if object
  end

  def format_date(value, format=nil)
    value.try(:strftime, I18n.t(format, scope: [ :date, :formats ], default: :default))
  end
end

这篇关于表单中的更改不会保存到数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！