From 3dbcda65215a960f17aed40dd514177aa546188f Mon Sep 17 00:00:00 2001
From: Étienne Loks <etienne.loks@peacefrogs.net>
Date: Fri, 23 Sep 2011 20:02:52 +0200
Subject: Manage pagination on jquery tables (closes #642)

---
 ishtar/ishtar_base/views.py   |  27 ++++-
 ishtar/ishtar_base/widgets.py | 230 +++++++++++++++++++++---------------------
 2 files changed, 138 insertions(+), 119 deletions(-)

diff --git a/ishtar/ishtar_base/views.py b/ishtar/ishtar_base/views.py
index 56860fdaf..46a1b0001 100644
--- a/ishtar/ishtar_base/views.py
+++ b/ishtar/ishtar_base/views.py
@@ -202,6 +202,7 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
                     dct.pop(k)
                 else:
                     dct[k] = dct[k] == u"2" and True or False
+
         # manage hierarchic conditions
         or_reqs = []
         for req in dct.copy():
@@ -221,6 +222,7 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
             query = query & or_req
         items = model.objects.filter(query)
         q = request_items.get('sidx')
+
         # manage sort tables
         if q and q in request_keys:
             ks = request_keys[q]
@@ -236,6 +238,25 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
                     k = k.split('__')[0]
                 orders.append(sign+k)
             items = items.order_by(*orders)
+
+        # pager management
+        start, end = 0, None
+        page_nb = 1
+        try:
+            row_nb = int(request_items.get('rows'))
+        except ValueError:
+            row_nb = None
+        if row_nb:
+            try:
+                page_nb = int(request_items.get('page'))
+                assert page_nb >= 1
+            except (ValueError, AssertionError):
+                pass
+            start = (page_nb-1)*row_nb
+            end = page_nb*row_nb
+        items_nb = items.count()
+        items = items[start:end]
+
         datas = []
         if old:
             items = [item.get_previous(old) for item in items]
@@ -279,8 +300,10 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
                         res[table_cols[idx].split('.')[-1]] = value
                 rows.append(res)
             data = json.dumps({
-                "records":len(items),
-                "rows":rows
+                "records":items_nb,
+                "rows":rows,
+                "page":page_nb,
+                "total":items_nb/row_nb + 1,
             })
             return HttpResponse(data, mimetype='text/plain')
         elif data_type == "csv":
diff --git a/ishtar/ishtar_base/widgets.py b/ishtar/ishtar_base/widgets.py
index 374fde2c5..bff9aeca6 100644
--- a/ishtar/ishtar_base/widgets.py
+++ b/ishtar/ishtar_base/widgets.py
@@ -207,10 +207,9 @@ class JQueryJqGrid(forms.RadioSelect):
     def render(self, name, value=None, attrs=None):
         t = loader.get_template('form_snippet.html')
         rendered = t.render(Context({'form':self.form}))
-        rendered += """
-</table>
-<button id='search_%s' class='submit'>%s</button>
-""" % (name, unicode(_("Search")))
+        rendered += u"\n</table>\n"\
+        u"<button id='search_%s' class='submit'>%s</button>" % (
+                                                name, unicode(_("Search")))
         if self.new:
             model_name = self.associated_model._meta.object_name.lower()
             url_new = reverse('new-' + model_name)
@@ -244,128 +243,125 @@ class JQueryJqGrid(forms.RadioSelect):
         col_names = col_names and ",\n".join(col_names) or ""
         col_idx = col_idx and ",\n".join(col_idx) or ""
         extra_cols = extra_cols and ",\n".join(extra_cols) or ""
-        rendered += """<table id="grid_%s" class='jqgrid'></table>
-<div id="pager_%s"></div>
-""" % (name, name)
+        rendered += u"<table id='grid_%s' class='jqgrid'></table>\n"\
+                    u"<div id='pager_%s'></div>\n"% (name, name)
         encoding = settings.ENCODING or 'utf-8'
-        rendered += """
-<div id="foot_%s" class="gridfooter">
-""" % name
+        rendered += u"<div id='foot_%s' class='gridfooter'>\n" % name
         if unicode(self.source_full):
-            rendered += """%s (%s) <a href="%scsv" target="_blank">%s</a> - \
-<a href="%scsv" target="_blank">%s</a>
-""" % (unicode(_("Export as CSV")), encoding, unicode(self.source),
-       unicode(_(u"simple")),  unicode(self.source_full), unicode(_(u"full")),)
+            rendered += u"%s (%s) <a href='%scsv' target='_blank'>%s</a> - "\
+                        u"<a href='%scsv' target='_blank'>%s</a>\n" % (
+                unicode(_("Export as CSV")), encoding, unicode(self.source),
+                unicode(_(u"simple")),  unicode(self.source_full),
+                unicode(_(u"full")),)
         else:
-            rendered += """<a href="%scsv" target="_blank">%s (%s)</a>
-""" % (unicode(self.source), unicode(_("Export as CSV")), encoding)
+            rendered += u'<a href="%scsv" target="_blank">%s (%s)</a>\n' % (
+                  unicode(self.source), unicode(_("Export as CSV")), encoding)
         rendered += "</div>\n"
         if self.multiple:
-            rendered += '''
-<input type="button" id="add_button_%s" value="%s"/>
-<ul id='selectmulti_%s' class='selectmulti'>
-</ul>
-''' % (name, unicode(_("Add")), name)
-        rendered += '<input type="hidden" id="hidden_%s" name="%s"/>' % (name,
-                                                                        name)
-        dct = {'name':name, 'col_names':col_names, 'extra_cols':extra_cols,
-       'source':unicode(self.source), 'col_idx':col_idx,
-       'no_result':unicode(_("No results")), 'loading':unicode(_("Loading...")),
-       'remove':unicode(_(u"Remove")), 'sname':name.replace('-', ''),
-       'multi_cols': ",".join((u'"%d"' % col for col in self.multiple_cols))}
-        rendered += """
-<script type="text/javascript">
-var query_vars = new Array(%(col_idx)s);
-var selItems_%(sname)s = new Array();
-jQuery(document).ready(function(){
-  jQuery("#search_%(name)s").click(function (){
-    var data = "";
-    for (idx in query_vars)
-    {
-        var key = query_vars[idx];
-        var val = jQuery("#id_"+key).val();
-        if (val){
-            if (data) data += "&";
-            data += key + "=" + val;
-        }
-    }
-    var mygrid = jQuery("#grid_%(name)s");
-    var url = "%(source)s?submited=1&amp;" + data;
-    mygrid.setGridParam({url:url});
-    mygrid.trigger("reloadGrid");
-    return false;
-  });
+            rendered += u'<input type="button" id="add_button_%s" value="%s"/>'\
+                    u'<ul id="selectmulti_%s" class="selectmulti">\n</ul>\n' % (
+                                                  name, unicode(_("Add")), name)
+        rendered += '<input type="hidden" id="hidden_%s" name="%s"/>\n' % (name,
+                                                                           name)
+        dct = {'name':name,
+               'col_names':col_names,
+               'extra_cols':extra_cols,
+               'source':unicode(self.source),
+               'col_idx':col_idx,
+               'no_result':unicode(_("No results")),
+               'loading':unicode(_("Loading...")),
+               'remove':unicode(_(u"Remove")),
+               'sname':name.replace('-', ''),
+               'multi_cols': ",".join((u'"%d"' % col \
+                                       for col in self.multiple_cols))
+              }
+        rendered += """<script type="text/javascript">
+        var query_vars = new Array(%(col_idx)s);
+        var selItems_%(sname)s = new Array();
+        jQuery(document).ready(function(){
+          jQuery("#search_%(name)s").click(function (){
+            var data = "";
+            for (idx in query_vars)
+            {
+                var key = query_vars[idx];
+                var val = jQuery("#id_"+key).val();
+                if (val){
+                    if (data) data += "&";
+                    data += key + "=" + val;
+                }
+            }
+            var mygrid = jQuery("#grid_%(name)s");
+            var url = "%(source)s?submited=1&amp;" + data;
+            mygrid.setGridParam({url:url});
+            mygrid.trigger("unloadGrid");
+            return false;
+          });
 
-  jQuery("#grid_%(name)s").jqGrid({
-    url:'%(source)s',
-    datatype: "json",
-    mtype: 'GET',
-    colNames:['id', '', %(col_names)s],
-    colModel:[
-      {name:'id', index:'id', hidden:true},
-      {name:'link', index:'link', width:80},
-      %(extra_cols)s
-    ],
-    sortname: 'value',
-    viewrecords: true,
-    sortorder: "asc",
-    emptyrecords: "%(no_result)s",
-    loadtext: "%(loading)s",
-    pager: '#pager_%(name)s',
-    pgbuttons: false,
-    pginput: false,
-    width:740,
-    rowNum:0,
-    jsonReader : {repeatitems: false}
-  });
-""" % dct
+          jQuery("#grid_%(name)s").jqGrid({
+            url:'%(source)s',
+            datatype: "json",
+            mtype: 'GET',
+            colNames:['id', '', %(col_names)s],
+            colModel:[
+              {name:'id', index:'id', hidden:true},
+              {name:'link', index:'link', width:80},
+              %(extra_cols)s
+            ],
+            sortname: 'value',
+            viewrecords: true,
+            sortorder: "asc",
+            emptyrecords: "%(no_result)s",
+            loadtext: "%(loading)s",
+            pager: '#pager_%(name)s',
+            width:740,
+            rowNum:20,
+            jsonReader : {repeatitems: false},
+          });
+        """ % dct
         if self.multiple:
             rendered += """
-  jQuery("#add_button_%(name)s").click(function (){
-    var mygrid = jQuery("#grid_%(name)s");
-    var idx = mygrid.getGridParam('selrow');
-    var lbl_cols = new Array(%(multi_cols)s);
-    var label = "";
-    for (var id in lbl_cols){
-        if(id == 1){
-            label += " (";
-        }else if (id > 1){
-            label += " ; ";
-        }
-        label += mygrid.getCell(idx, lbl_cols[id]);
-    }
-    if (id > 0){
-        label += ")";
-    }
-    for (id in selItems_%(sname)s){
-        if(selItems_%(sname)s[id] == idx){
-            return false;
-        }
-    }
-    selItems_%(sname)s.push(idx);
-    jQuery("#selectmulti_%(name)s").append(
-               "<li id='selected_%(name)s_"+idx+"'>\
-<a href='#' class='remove' \
-  onclick=\\"multiRemoveItem(selItems_%(sname)s, '%(name)s', "+ idx +");\
-  return false;\\" title=\\"%(remove)s\\">X</a>" + label + "</li>");
-    return true;
-  });
-  jQuery("#submit_form").click(function (){
-    jQuery("#hidden_%(name)s").val(selItems_%(sname)s);
-    return true;
-  });
-""" % dct
+          jQuery("#add_button_%(name)s").click(function (){
+            var mygrid = jQuery("#grid_%(name)s");
+            var idx = mygrid.getGridParam('selrow');
+            var lbl_cols = new Array(%(multi_cols)s);
+            var label = "";
+            for (var id in lbl_cols){
+                if(id == 1){
+                    label += " (";
+                }else if (id > 1){
+                    label += " ; ";
+                }
+                label += mygrid.getCell(idx, lbl_cols[id]);
+            }
+            if (id > 0){
+                label += ")";
+            }
+            for (id in selItems_%(sname)s){
+                if(selItems_%(sname)s[id] == idx){
+                    return false;
+                }
+            }
+            selItems_%(sname)s.push(idx);
+            jQuery("#selectmulti_%(name)s").append(
+                       "<li id='selected_%(name)s_"+idx+"'>\
+        <a href='#' class='remove' \
+          onclick=\\"multiRemoveItem(selItems_%(sname)s, '%(name)s', "+ idx +");\
+          return false;\\" title=\\"%(remove)s\\">X</a>" + label + "</li>");
+            return true;
+          });
+          jQuery("#submit_form").click(function (){
+            jQuery("#hidden_%(name)s").val(selItems_%(sname)s);
+            return true;
+          });
+        """ % dct
         else:
             rendered += """
-  jQuery("#submit_form").click(function (){
-    var mygrid = jQuery("#grid_%(name)s");
-    jQuery("#hidden_%(name)s").val(mygrid.getGridParam('selrow'));
-    return true;
-  });
-""" % dct
-        rendered += """
-});
-</script>
-"""
+          jQuery("#submit_form").click(function (){
+            var mygrid = jQuery("#grid_%(name)s");
+            jQuery("#hidden_%(name)s").val(mygrid.getGridParam('selrow'));
+            return true;
+          });
+        """ % dct
+        rendered += "});\n</script>\n"
         return mark_safe(rendered)
 
-- 
cgit v1.2.3