Rails2中实现表格排序(整合sortable_column_headers和will_paginate)

最新推荐文章于 2019-11-25 15:10:52 发布

昆山人在上海

最新推荐文章于 2019-11-25 15:10:52 发布

阅读量866

点赞数

CC 4.0 BY-SA版权

分类专栏： Ruby探秘文章标签： rails redirect image delete attributes xml

本文链接：https://blog.youkuaiyun.com/kunshan_shenbin/article/details/4188738

Ruby探秘专栏收录该内容

80 篇文章

订阅专栏

本文介绍如何使用sortablecolumnheaders插件为Rails应用中的产品列表实现排序功能。通过配置控制器和视图，使得用户可以方便地按标题、描述、图片链接及价格等字段对产品进行排序。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

参考资料：

http://qbar.qq.com/pd4b5b1t/85.htm

http://blog.youkuaiyun.com/xieqibao/archive/2007/09/12/1782533.aspx

未完，待续......

======================================================================

sortable column headers插件下载地址：https://svn.elctech.com/svn/public/sortable_column_headers/

他的一个Demo参考地址：https://svn.elctech.com/svn/public/demo/sortable_column_headers/

接上例继续写：http://blog.youkuaiyun.com/kunshan_shenbin/archive/2009/05/14/4183892.aspx

下载插件后放入工程指定位置，修改sortable_column_headers.rb文件的部分代码（如上图）。

参考资料：http://www.javaeye.com/topic/217159

修改代码：

products_controller.rb

class ProductsController < ApplicationController # GET /products # GET /products.xml def index #@products = Product.all add_to_sortable_columns("listing", Product, "title", "title") add_to_sortable_columns("listing", Product, "description", "description") add_to_sortable_columns("listing", Product, "image_url", "image_url") add_to_sortable_columns("listing", Product, "price", "price") @products = Product.find(:all, :order => sortable_order('listing',Product,'title')).paginate :page => params[:page] || 1, :per_page => 2 respond_to do |format| format.html # index.html.erb format.xml { render :xml => @products } end end # def order # @products = Product.find(:all, :order => 'price asc').paginate :page => params[:page] || 1, :per_page => 1 # # redirect_to(:action => 'index') # end # GET /products/1 # GET /products/1.xml def show @product = Product.find(params[:id]) respond_to do |format| #format.html # show.html.erb format.xml { render :xml => @product } end end # GET /products/new # GET /products/new.xml def new @product = Product.new respond_to do |format| format.html # new.html.erb format.xml { render :xml => @product } end end # GET /products/1/edit def edit @product = Product.find(params[:id]) end # POST /products # POST /products.xml def create @product = Product.new(params[:product]) respond_to do |format| if @product.save flash[:notice] = 'Product was successfully created.' format.html { redirect_to(@product) } format.xml { render :xml => @product, :status => :created, :location => @product } else format.html { render :action => "new" } format.xml { render :xml => @product.errors, :status => :unprocessable_entity } end end end # PUT /products/1 # PUT /products/1.xml def update @product = Product.find(params[:id]) respond_to do |format| if @product.update_attributes(params[:product]) flash[:notice] = 'Product was successfully updated.' format.html { redirect_to(@product) } format.xml { head :ok } else format.html { render :action => "edit" } format.xml { render :xml => @product.errors, :status => :unprocessable_entity } end end end # DELETE /products/1 # DELETE /products/1.xml def destroy @product = Product.find(params[:id]) @product.destroy respond_to do |format| format.html { redirect_to(products_url) } format.xml { head :ok } end end end

index.html.erb

<h1>Listing products</h1> <table> <tr>  <th><%= link_to 'Title', sort_param('listing', Product, 'title', 'title') %></th> <th><%= link_to 'Description', sort_param('listing', Product, 'description', 'description') %></th> <th><%= link_to 'Image url', sort_param('listing', Product, 'image_url', 'image_url') %></th> <th><%= link_to 'Price', sort_param('listing', Product, 'price', 'price') %></th> </tr> <% @products.each do |product| %> <tr> <td><%=h product.title %></td> <td><%=h product.description %></td> <td><%=h product.image_url %></td> <td><%=h product.price %></td> <td><%= link_to 'Show', product %></td> <td><%= link_to 'Edit', edit_product_path(product) %></td> <td><%= link_to 'Destroy', product, :confirm => 'Are you sure?', :method => :delete %></td> </tr> <% end %> </table> <hr> <div class="digg_pagination"> <div clas="page_info"> <%= page_entries_info @products %> </div> <%= will_paginate @products, :prev_label => '上一页', :next_label => '下一页', :container => false %> </div> <hr> <br/> <%= link_to 'New product', new_product_path %>

重新启动服务即可访问。