jqgrid: subgrid toolbar does not display -

-

i'm using jqgrid 4.8.2. i'm trying follow along examples on demo site. i've created parent grid , need show subgrid (as grid). reason, toolbar pager subgrid won't display. rownum, width , height options working, though. i've looked @ demo , can't see i'm doing wrong. take @ following code, please?

var lastselection;  $(document).ready(function () {      $("#jqgrid").jqgrid({     url: 'servlet/getdata',     datatype: "json",     editurl: "servlet/updateproduct",     page: 1,       colmodel: [         { label: 'id', name: 'productid', width: 75, key: true },         { label: 'category', name: 'categoryname', width: 90 },         { label: 'name', name: 'productname', width: 100 },         { label: 'country', name: 'country', width: 80 },         { label: 'price', name: 'price', width: 80 },         { label: 'qty', name: 'quantity', width: 80 },         { label: 'included?', name: 'included', width: 80,                 editable: true,                  edittype: "checkbox",                  editoptions: {value:"yes:no"} }     ],     viewrecords: true, // show current page, data range , total records on toolbar     onselectrow: function (rowid) {         var grid = $('#jqgrid');         if (rowid && rowid !== lastselection) {             grid.jqgrid('restorerow', lastselection);             lastselection = rowid;         }         grid.jqgrid('editrow', lastselection, {keys: true,              extraparam : {                 home: "livonia",                  productname: function(){                     var row = grid.getrowdata(lastselection);                      // both of these work:                     var temp = row.productname;                     var temp1 = row['productname'];                      return row.productname;                 }             }         }          );      },     width: 780,     height: 200,     rownum: 10,     pager: "#jqgridpager",      subgrid: true,     subgridrowexpanded: function(subgrid_id, row_id) {         var lastsubgridselection;          var grid = $('#jqgrid');         var row = grid.getrowdata(row_id);           var productid = row.productid;             var subgrid_table_id;            subgrid_table_id = subgrid_id + "_t";            jquery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");            jquery("#"+subgrid_table_id).jqgrid({               url: 'servlet/getproductwarehouses?q=2&id=' + row_id + '&productid=' + productid,               datatype: "json",                 page: 1,                  colmodel: [                     { label: 'product id', name: 'productid', width: 75, key: false, hidden: true },                     { label: 'whse id', name: 'whseid', width: 90, key: true },                     { label: 'whse name', name: 'whsename', width: 90 },                     { label: 'qty', name: 'quantity', width: 80 },                     { label: 'included?', name: 'included', width: 80,                     editable: true,                      edittype: "checkbox",                      editoptions: {value:"yes:no"} }                 ],             viewrecords: true,             height: '100%',             width: 400,             rownum: 5,             pager: "#jqgridpager" + "_" + subgrid_id            });        }  });   });

you mean the pager (not toolbar) not displayed in subgrids.

the reason easy if understand how grid subgrid feature works in jqgrid. if add subgrid: true grid (to main grid) jqgrid insert additional column in colmodel name "subgrid". column have + icons can used "expand" subgrid. if user clicks on + icon new row added under row + icon. row contains <td> icon , <td> span on whole grid. last <td> contains subdrid. before call of subgridrowexpanded jqgrid creates empty <div> in cell id constructed grid id, "_" , rowid (of expanding row). first parameter of subgridrowexpanded callback (subgrid_id in code) contains id of empty <div>. picture below shows described above

enter image description here

i marked in red color subgrid row. id of empty div jqgrid_10 in above example because rowid 10 , grid id jqgrid.

it's important understand have create <table> element subgrid dynamically inside of subgridrowexpanded callback. if want subgrid have pager have create <div> pager too. the problem in code: use pager: "#jqgridpager" + "_" + subgrid_id option subgrid, don't created <div> corresponding id.

the next problem: every row (<tr>) of subgrid have id attribute (rowid). 1 have assign it. user can open multiple subgrids @ same time. the problem it's possible have id duplicates because of usage same id in 2 different subgrids or between subgrid , main grid. fix problem id conflicts it's strictly recommended use idprefix parameter subgrid value different every subgrid.

a possible fixed implementation of subgridrowexpanded following:

subgridrowexpanded: function (subgriddivid, rowid) {     var $subgrid = $("<table id='" + subgriddivid + "_t'></table>"),         subgridpagerid = subgriddivid + "_p";     $("#" + subgriddivid)         .append($subgrid)         .append("<div id='" +subgridpagerid + "'></div>");      $subgrid.jqgrid({         url: 'servlet/getproductwarehouses',         postdata: {             q: 2,             id: rowid,             productid: rowid         },         datatype: "local",         colmodel: [             { label: 'product id', name: 'productid', width: 75, hidden: true },             { label: 'whse id', name: 'whseid', width: 90, key: true },             { label: 'whse name', name: 'whsename', width: 90 },             { label: 'qty', name: 'quantity', width: 80 },             { label: 'included?', name: 'included', width: 80,                 editable: true,                 edittype: "checkbox",                 editoptions: {value:"yes:no"} }         ],         viewrecords: true,         height: '100%',         width: 400,         rownum: 5,         //idprefix: subgriddivid + "_",         idprefix: rowid + "_",         pager: "#" + subgridpagerid     }); }

by way use key: true property column productid of main grid. rowid of main grid same productid. because of used productid: rowid in above code. 1 more remark. used idprefix: rowid + "_" subgrid. 1 can use other values in same way, example idprefix: subgriddivid + "_".


Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more