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:

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

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

  2. JIMMIE Says:

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

    Buywithout prescription…

  3. DARRELL Says:

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

    Buygeneric meds…

  4. MARK Says:

    tylenol zyrtec recall

    Buyno prescription…

  5. CARLTON Says:

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

    Buygeneric drugs…

  6. KIRK Says:

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

    Buygeneric drugs…

  7. ALVIN Says:

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

    Buyno prescription…

  8. COREY Says:

    diovan

    Buyit now…

  9. DARRYL Says:

    zyrtec benadryl

    Buyit now…

  10. REX Says:

    Zoloft

    Buygeneric drugs…

  11. MAURICE Says:

    asperger zoloft 100

    Buydrugs without prescription…

  12. DONNIE Says:

    purim wiki

    Buydrugs without prescription…

  13. CLINTON Says:

    Purim

    Buyno prescription…

  14. JULIO Says:

    depo provera shot how young can you be to take it

    Buyno prescription…

  15. DANIEL Says:

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

    Buyno prescription…

  16. EDDIE Says:

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

    Buynow it…

  17. MANUEL Says:

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

    Buygeneric drugs…

  18. LOUIS Says:

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

    Buyit now…

  19. MATTHEW Says:

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

    Buyno prescription…

  20. TREVOR Says:

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

    Buygeneric drugs…

  21. MELVIN Says:

    ..

    Buywithout prescription…

  22. ANTONIO Says:

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

    Buygeneric meds…

  23. DENNIS Says:

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

    Buyit now…

  24. MELVIN Says:

    Buydrugs without prescription…

  25. SALVADOR Says:

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

    Buygeneric pills…

  26. ROBERTO Says:

    .

    Buynow…

Leave a Comment