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

参考资料：

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

http://blog.csdn.net/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.csdn.net/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 endend

index.html.erb

<h1>Listing products</h1><table> <tr> <!--<th>Title</th> <th>Description</th> <th>Image url</th> <th>Price</th>--><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 %>

重新启动服务即可访问。