Jquery 表格工具 — 2dc_jqgrid————–

Posted by wosmvp on May 24th, 2009 filed in Plugin, Rails应用, web前端技术, 敏捷开发, 测试方法

它整合了 InPlaceEdit，分页，搜索，添加,删除等功能,甚至还可以处理附属关系的表格

功能不可谓不强大，但代码却是来的简单的很！

————————–

- Ajax enabled
- Sorting
- Pagination
- Search
- CRUD operations (add, edit, delete)
- Multi-selection (checkboxes)
- Master-details
- Themes
- And more ...
--------------

The jQuery grid plugin is an amazing Javascript project providing multi-functions Ajax datagrids for your web applications.简而言之，居家旅行杀人放火逃命跳墙之必备良品！

在官方文档面前，任何其它文档都是失色的 http://www.2dconcept.com/jquery-grid-rails-plugin

在这里就不无聊的敷述一下过程了

简单的谈几其它个问题：

1，它的例子代码太“重量级”：

针对它第一个例子方法的优化：

原方法：

users = User.find(:all) do
    if params[:_search] == "true"
      pseudo    =~ "%#{params[:pseudo]}%" if params[:pseudo].present?
      firstname =~ "%#{params[:firstname]}%" if params[:firstname].present?
      lastname  =~ "%#{params[:lastname]}%" if params[:lastname].present?
      email     =~ "%#{params[:email]}%" if params[:email].present?
      role      =~ "%#{params[:role]}%" if params[:role].present?
    end
    paginate :page => params[:page], :per_page => params[:rows]
    order_by "#{params[:sidx]} #{params[:sord]}"
  end

修改后：

users = User.find(:all) do |x|
    if params[:_search] == "true"
       [:pseudo,:firstname,:lastname,:email,:role].map do |m|
           x.send(m) =~ "%#{params[m]}" if params[m].presend?
       end
    end
    paginate :page => params[:page], :per_page => params[:rows]
    order_by "#{params[:sidx]} #{params[:sord]}"
end

2, 第二个问题就是如果你上面的order_by排序排字字段使用了SQL的关键字会出现问题的！
上解决方案：
order_by “`#{params[:sidx]}` #{params[:sord]}” if
!params[:sidx].blank?

3,上我自己做的中文翻译 :) 点击下载
你需要修改javascripts/jqgrid/jquery.jqGrid.js第10行附近来使用此中文翻译

并且我还修改了源码 vendor/plugins/2dc_jqgrid/lib/2dc_jqgrid.rb第233行，将其中的caption “Search” 修改为“搜索”
（PS：我知道偷偷修改源码，这是很不好的的做法，那怕是字符串的修改，但实在没有找到更优雅一点的办法，有时间再深入它的源码看看吧 :)

收藏、分享这篇文章!

No related posts.


26 Responses to “Jquery 表格工具 — 2dc_jqgrid————–”

  1. CLINTON Says:
    December 19th, 2010 at 1:56 PM

    ████████►BUY LEVITRA◀███████…

    ▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲…

  2. JIMMIE Says:
    December 28th, 2010 at 7:35 PM

    Actos@official.site” rel=”nofollow”>..…

    Buywithout prescription…

  3. DARRELL Says:
    December 30th, 2010 at 4:54 AM

    altace@medication.now” rel=”nofollow”>……

    Buygeneric meds…

  4. MARK Says:
    December 31st, 2010 at 2:27 AM

    tylenol zyrtec recall…

    Buyno prescription…

  5. CARLTON Says:
    January 4th, 2011 at 8:47 AM

    abilify@vs.risperidone.dosage” rel=”nofollow”>.…

    Buygeneric drugs…

  6. KIRK Says:
    January 5th, 2011 at 6:28 PM

    buy@viagra.in.london.england” rel=”nofollow”>……

    Buygeneric drugs…

  7. ALVIN Says:
    January 6th, 2011 at 2:53 PM

    < a href=”http://my.gardenguides.com/members/buy-Tramadol? buy@Tramadol.now…

    Buyno prescription…

  8. COREY Says:
    February 6th, 2011 at 8:56 PM

    diovan…

    Buyit now…

  9. DARRYL Says:
    February 7th, 2011 at 7:07 AM

    zyrtec benadryl…

    Buyit now…

  10. REX Says:
    February 7th, 2011 at 9:23 AM

    Zoloft…

    Buygeneric drugs…

  11. MAURICE Says:
    February 7th, 2011 at 5:25 PM

    asperger zoloft 100…

    Buydrugs without prescription…

  12. DONNIE Says:
    March 6th, 2011 at 9:48 PM

    purim wiki…

    Buydrugs without prescription…

  13. CLINTON Says:
    March 9th, 2011 at 4:52 AM

    Purim…

    Buyno prescription…

  14. JULIO Says:
    March 10th, 2011 at 12:14 AM

    depo provera shot how young can you be to take it…

    Buyno prescription…

  15. DANIEL Says:
    March 29th, 2011 at 2:21 PM

    Purim@Purim.Purim” rel=”nofollow”>……

    Buyno prescription…

  16. EDDIE Says:
    March 29th, 2011 at 5:51 PM

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>..…

    Buynow it…

  17. MANUEL Says:
    March 30th, 2011 at 7:33 AM

    Slimfast@Slimfast.Slimfast” rel=”nofollow”>..…

    Buygeneric drugs…

  18. LOUIS Says:
    March 31st, 2011 at 6:59 AM

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>.…

    Buyit now…

  19. MATTHEW Says:
    March 31st, 2011 at 11:53 AM

    Crestor@Crestor.Crestor” rel=”nofollow”>……

    Buyno prescription…

  20. TREVOR Says:
    March 31st, 2011 at 6:11 PM

    Prozac@Prozac.Prozac” rel=”nofollow”>.…

    Buygeneric drugs…

  21. MELVIN Says:
    April 2nd, 2011 at 6:14 AM

    ..…

    Buywithout prescription…

  22. ANTONIO Says:
    April 4th, 2011 at 11:29 PM

    aleve@active.ingredient” rel=”nofollow”>.…

    Buygeneric meds…

  23. DENNIS Says:
    April 4th, 2011 at 11:29 PM

    dilantin@hypoglycemia.alcohol” rel=”nofollow”>……

    Buyit now…

  24. MELVIN Says:
    April 5th, 2011 at 3:24 PM

    ……

    Buydrugs without prescription…

  25. SALVADOR Says:
    April 6th, 2011 at 12:11 AM

    is@neem.safe.to.use.on.skin” rel=”nofollow”>……

    Buygeneric pills…

  26. ROBERTO Says:
    April 6th, 2011 at 6:41 AM

    .…

    Buynow…

Leave a Comment