jQuery columnManager Plugin and Rails-settings-cached

原文参见我另一个博客：http://caok.github.com/blog/2012/08/07/jquery-columnmanager-plugin-and-rails-settings-cached/

在平时页面显示表格时，容易出现要显示的字段过多，而在一页的范围内无法完全显示的困境。通过juery columnanager可以实现显示和隐藏的效果，再通过rails-settings-cached将其与个人偏好设置相关联，使得更加人性化。

安装rails-settings-cached

Edit your Gemfile:

gem "rails-settings-cached"

Generate your settings:

$ rails g settings <settings_name>

Now just put that migration in the database with:

rake db:migrate

Settings may be bound to any existing ActiveRecord object. Define this association like this: Notice! is not do caching in this version.

class User < ActiveRecord::Base
  include RailsSettings::Extend
end

安装jQuery columnManager plugin

下载地址：jquery.columnmanager.zip 我这使用的是里面的jquery.columnmanager.pack,添加至项目的application.js中

//= require jquery.columnmanager.pack

两者的配合使用

页面上调用

div id="targetcol">
</div>

<table id="tableall">
  .....
</table>

<script type="text/javascript">
  $('#tableall').columnManager({
    listTargetID:'targetcol',
    onClass: 'simpleon',
    offClass: 'simpleoff',
    colsHidden: <%= current_user.hide_columns(request.url) %>,
    onToggle: function(index, state){
      $.ajax({
        url: 'users/hide',
        type: 'post',
        data: "index=" + index + ";state=" + state + ";url=" + "<%= request.url %>"
        })
    }
  });
</script>

这里将点击后的效果通过ajax保存到用户的settings中，其中保存了url、index、state这几个属性值, 并在下次打开页面时通过hide_cloumns取出原先保存的值,起到一个人性化的效果。

编辑routes

resources :users do
    post :hide, :on => :collection
  end

在users_controller中增加hide处理，提供给ajax调用

def hide
  p = current_user.settings.pagesetups
  p = {} unless p
  if p[params[:url]]
    p[params[:url]][params[:index].to_i] = params[:state]
  else
    p[params[:url]] = {params[:index].to_i => params[:state]}
  end
  current_user.settings.pagesetups = p
  render :nothing => true
end

取出用户对于table中字段隐藏显示的偏好设置

def hide_columns(url)
  if settings.pagesetups and settings.pagesetups[url]
    p = self.settings.pagesetups[url]
  else
    return "[]"
  end
  lists = p.delete_if {|k,v| v != "false" }.keys
  "[" + lists * "," + "]"
end

参考

jQuery columnManager plugin http://p.sohei.org/stuff/jquery/columnmanager/demo/demo.html

rails-settings-cached： https://github.com/huacnlee/rails-settings-cached