📄 grid.base.js
字号:
if(isSafari || isOpera) {resizeFirstRow(t,1);}
if(!ts.p.treeGrid && !ts.p.scroll) {ts.grid.bDiv.scrollTop = 0;}
endReq();
updatepager();
};
var addJSONData = function(data,t, rcnt) {
if(data) { var fpos = ts.p.treeANode || 0; rcnt = rcnt || 0; if(fpos===0 && rcnt===0) {$("tbody tr:gt(0)", t).remove();} } else { return; }
var v,i,j,row,f=[],cur,gi=0,si=0,drows,idn,rd=[],cn=(ts.p.altRows===true) ? 'alt':'';
ts.p.page = data[ts.p.jsonReader.page];
ts.p.lastpage= data[ts.p.jsonReader.total];
ts.p.records= data[ts.p.jsonReader.records];
ts.p.userData = data[ts.p.jsonReader.userdata] || {};
if(!ts.p.jsonReader.repeatitems) {f = reader("json");}
if( ts.p.keyIndex===false ) {
idn = ts.p.jsonReader.id;
if(f.length>0 && !isNaN(idn)) {idn=f[idn];}
} else {
idn = f.length>0 ? f[ts.p.keyIndex] : ts.p.keyIndex;
}
drows = data[ts.p.jsonReader.root];
if (drows) {
for (i=0;i<drows.length;i++) {
cur = drows[i];
row = document.createElement("tr");
row.id = cur[idn] || "";
if(row.id === "") {
if(f.length===0){
if(ts.p.jsonReader.cell){
var ccur = cur[ts.p.jsonReader.cell];
row.id = ccur[idn] || i+1;
ccur=null;
} else {row.id=i+1;}
} else {
row.id=i+1;
}
}
if(ts.p.multiselect){
addMulti(t,row);
gi = 1;
}
if (ts.p.subGrid) {
try { $(ts).addSubGrid(t,row,gi,drows[i]);} catch (e){}
si= 1;
}
if (ts.p.jsonReader.repeatitems === true) {
if(ts.p.jsonReader.cell) {cur = cur[ts.p.jsonReader.cell];}
for (j=0;j<cur.length;j++) {
addCell(t,row,cur[j],j+gi+si);
rd[ts.p.colModel[j+gi+si].name] = cur[j];
}
} else {
for (j=0;j<f.length;j++) {
v=cur[f[j]];
if(v === undefined) {
try { v = eval("cur."+f[j]);}
catch (e) {}
}
addCell(t,row,v,j+gi+si);
rd[ts.p.colModel[j+gi+si].name] = cur[f[j]];
}
}
if(i%2 == 1) {row.className = cn;} $(row).addClass("jqgrow");
if( ts.p.treeGrid === true) {
try {$(ts).setTreeNode(rd,row);} catch (e) {}
ts.p.treeANode = 0;
}
$(ts.rows[i+fpos+rcnt]).after(row);
if(afterInsRow) {ts.p.afterInsertRow(row.id,rd,drows[i]);}
rd=[];
}
}
if(isSafari || isOpera) {resizeFirstRow(t,1);}
if(!ts.p.treeGrid && !ts.p.scroll) {ts.grid.bDiv.scrollTop = 0;}
endReq();
updatepager();
};
var updatepager = function() {
if(ts.p.pager) {
var cp, last,imp = ts.p.imgpath;
if (ts.p.loadonce) {
cp = last = 1;
ts.p.lastpage = ts.page =1;
$(".selbox",ts.p.pager).attr("disabled",true);
} else {
cp = IntNum(ts.p.page);
last = IntNum(ts.p.lastpage);
$(".selbox",ts.p.pager).attr("disabled",false);
}
if(ts.p.pginput===true) {
$('input.selbox',ts.p.pager).val(ts.p.page);
}
if (ts.p.viewrecords){
if(ts.p.pgtext) {
$('#sp_1',ts.p.pager).html(ts.p.pgtext+" "+ts.p.lastpage );
}
$('#sp_2',ts.p.pager).html(ts.p.records+" "+ts.p.recordtext+" ");
}
if(ts.p.pgbuttons===true) {
if(cp<=0) {cp = last = 1;}
if(cp==1) {$("#first",ts.p.pager).attr({src:imp+"off-"+ts.p.firstimg,disabled:true});} else {$("#first",ts.p.pager).attr({src:imp+ts.p.firstimg,disabled:false});}
if(cp==1) {$("#prev",ts.p.pager).attr({src:imp+"off-"+ts.p.previmg,disabled:true});} else {$("#prev",ts.p.pager).attr({src:imp+ts.p.previmg,disabled:false});}
if(cp==last) {$("#next",ts.p.pager).attr({src:imp+"off-"+ts.p.nextimg,disabled:true});} else {$("#next",ts.p.pager).attr({src:imp+ts.p.nextimg,disabled:false});}
if(cp==last) {$("#last",ts.p.pager).attr({src:imp+"off-"+ts.p.lastimg,disabled:true});} else {$("#last",ts.p.pager).attr({src:imp+ts.p.lastimg,disabled:false});}
}
}
if($.isFunction(ts.p.gridComplete)) {ts.p.gridComplete();}
};
var populate = function () {
if(!grid.hDiv.loading) {
beginReq();
var gdata, prm = {nd: (new Date().getTime()), _search:ts.p.search};
prm[ts.p.prmNames.rows]= ts.p.rowNum; prm[ts.p.prmNames.page]= ts.p.page;
prm[ts.p.prmNames.sort]= ts.p.sortname; prm[ts.p.prmNames.order]= ts.p.sortorder;
gdata = $.extend(ts.p.postData,prm);
if (ts.p.search ===true) {gdata =$.extend(gdata,ts.p.searchdata);}
if ($.isFunction(ts.p.datatype)) {ts.p.datatype(gdata);endReq();}
var rcnt = ts.p.scroll===false ? 0 : ts.rows.length-1;
switch(ts.p.datatype)
{
case "json":
$.ajax({url:ts.p.url,type:ts.p.mtype,dataType:"json",data: gdata, complete:function(JSON,st) { if(st=="success") {addJSONData(eval("("+JSON.responseText+")"),ts.grid.bDiv,rcnt); JSON=null;if(loadComplete) {loadComplete();}}}, error:function(xhr,st,err){if(loadError) {loadError(xhr,st,err);}endReq();}, beforeSend: function(xhr){if(loadBeforeSend) {loadBeforeSend(xhr);}}});
if( ts.p.loadonce || ts.p.treeGrid) {ts.p.datatype = "local";}
break;
case "xml":
$.ajax({url:ts.p.url,type:ts.p.mtype,dataType:"xml",data: gdata , complete:function(xml,st) {if(st=="success") {addXmlData(xml.responseXML,ts.grid.bDiv,rcnt); xml=null;if(loadComplete) {loadComplete();}}}, error:function(xhr,st,err){if(loadError) {loadError(xhr,st,err);}endReq();}, beforeSend: function(xhr){if(loadBeforeSend) {loadBeforeSend(xhr);}}});
if( ts.p.loadonce || ts.p.treeGrid) {ts.p.datatype = "local";}
break;
case "xmlstring":
addXmlData(stringToDoc(ts.p.datastr),ts.grid.bDiv);
ts.p.datastr = null;
ts.p.datatype = "local";
if(loadComplete) {loadComplete();}
break;
case "jsonstring":
if(typeof ts.p.datastr == 'string') { ts.p.datastr = eval("("+ts.p.datastr+")");}
addJSONData(ts.p.datastr,ts.grid.bDiv);
ts.p.datastr = null;
ts.p.datatype = "local";
if(loadComplete) {loadComplete();}
break;
case "local":
case "clientSide":
ts.p.datatype = "local";
sortArrayData();
break;
}
}
};
var beginReq = function() {
if(beReq) {ts.p.beforeRequest();}
grid.hDiv.loading = true;
switch(ts.p.loadui) {
case "disable":
break;
case "enable":
$("div.loading",grid.hDiv).fadeIn("fast");
break;
case "block":
$("#lui_"+ts.id).width($(grid.bDiv).width()).height(IntNum($(grid.bDiv).height())+IntNum(ts.p._height)).fadeIn("fast");
break;
}
};
var endReq = function() {
grid.hDiv.loading = false;
switch(ts.p.loadui) {
case "disable":
break;
case "enable":
$("div.loading",grid.hDiv).fadeOut("fast");
break;
case "block":
$("#lui_"+ts.id).fadeOut("fast");
break;
}
};
var stringToDoc = function (xmlString) {
var xmlDoc;
if(typeof xmlString !== 'string') return xmlString;
try {
var parser = new DOMParser();
xmlDoc = parser.parseFromString(xmlString,"text/xml");
}
catch(e) {
xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async=false;
xmlDoc["loadXM"+"L"](xmlString);
}
return (xmlDoc && xmlDoc.documentElement && xmlDoc.documentElement.tagName != 'parsererror') ? xmlDoc : null;
};
var sortArrayData = function() {
var stripNum = /[\$,%]/g;
var rows=[], col=0, st, sv, findSortKey,newDir = (ts.p.sortorder == "asc") ? 1 :-1;
$.each(ts.p.colModel,function(i,v){
if(this.index == ts.p.sortname || this.name == ts.p.sortname){
col = ts.p.lastsort= i;
st = this.sorttype;
return false;
}
});
if (st == 'float' || st== 'number' || st== 'currency') {
findSortKey = function($cell) {
var key = parseFloat($cell.replace(stripNum, ''));
return isNaN(key) ? 0 : key;
};
} else if (st=='int' || st=='integer') {
findSortKey = function($cell) {
return IntNum($cell.replace(stripNum, ''));
};
} else if(st == 'date') {
findSortKey = function($cell) {
var fd = ts.p.colModel[col].datefmt || "Y-m-d";
return parseDate(fd,$cell).getTime();
};
} else {
findSortKey = function($cell) {
return $.trim($cell.toUpperCase());
};
}
$.each(ts.rows, function(index, row) {
if (index > 0) {
try { sv = $.unformat($(row).children('td').eq(col),{colModel:ts.p.colModel[col]},col,true);}
catch (_) { sv = $(row).children('td').eq(col).text(); }
row.sortKey = findSortKey(sv);
rows[index-1] = this;
}
});
if(ts.p.treeGrid) {
$(ts).SortTree( newDir);
} else {
rows.sort(function(a, b) {
if (a.sortKey < b.sortKey) {return -newDir;}
if (a.sortKey > b.sortKey) {return newDir;}
return 0;
});
$.each(rows, function(index, row) {
$('tbody',ts.grid.bDiv).append(row);
row.sortKey = null;
});
}
if(isSafari || isOpera) {resizeFirstRow(ts.grid.bDiv,1);}
if(ts.p.multiselect) {
$("tbody tr:gt(0)", ts.grid.bDiv).removeClass("selected");
$("[id^=jqg_]",ts.rows).attr("checked",false);
$("#cb_jqg",ts.grid.hDiv).attr("checked",false);
ts.p.selarrrow = [];
}
if( ts.p.altRows === true ) {
$("tbody tr:gt(0)", ts.grid.bDiv).removeClass("alt");
$("tbody tr:odd", ts.grid.bDiv).addClass("alt");
}
ts.grid.bDiv.scrollTop = 0;
endReq();
};
var parseDate = function(format, date) {
var tsp = {m : 1, d : 1, y : 1970, h : 0, i : 0, s : 0};
format = format.toLowerCase();
date = date.split(/[\\\/:_;.\s-]/);
format = format.split(/[\\\/:_;.\s-]/);
for(var i=0;i<format.length;i++){
tsp[format[i]] = IntNum(date[i],tsp[format[i]]);
}
tsp.m = parseInt(tsp.m,10)-1;
var ty = tsp.y;
if (ty >= 70 && ty <= 99) {tsp.y = 1900+tsp.y;}
else if (ty >=0 && ty <=69) {tsp.y= 2000+tsp.y;}
return new Date(tsp.y, tsp.m, tsp.d, tsp.h, tsp.i, tsp.s,0);
};
var setPager = function (){
var inpt = "<img class='pgbuttons' src='"+ts.p.imgpath+"spacer.gif'",
pginp = (ts.p.pginput===true) ? "<input class='selbox' type='text' size='3' maxlength='5' value='0'/>" : "",
pgl="", pgr="", str;
if(ts.p.viewrecords===true) {pginp += "<span id='sp_1'></span> ";}
if(ts.p.pgbuttons===true) {
pgl = inpt+" id='first'/>  "+inpt+" id='prev'/> ";
pgr = inpt+" id='next' />  "+inpt+" id='last'/>";
}
$(ts.p.pager).append(pgl+pginp+pgr);
if(ts.p.rowList.length >0){
str="<SELECT class='selbox'>";
for(var i=0;i<ts.p.rowList.length;i++){
str +="<OPTION value="+ts.p.rowList[i]+((ts.p.rowNum == ts.p.rowList[i])?' selected':'')+">"+ts.p.rowList[i];
}
str +="</SELECT>";
$(ts.p.pager).append(" "+str+" <span id='sp_2'></span>");
$(ts.p.pager).find("select").bind('change',function() {
ts.p.rowNum = this.value;
if (typeof ts.p.onPaging =='function') {ts.p.onPaging('records');}
populate();
ts.p.selrow = null;
});
} else { $(ts.p.pager).append(" <span id='sp_2'></span>");}
if(ts.p.pgbuttons===true) {
$(".pgbuttons",ts.p.pager).mouseover(function(e){
if($(this).attr('disabled') == 'true') { this.style.cursor='auto';}
else {this.style.cursor= "pointer";}
return false;
}).mouseout(function(e) {
this.style.cursor= "default";
return false;
});
$("#first, #prev, #next, #last",ts.p.pager).click( function(e) {
var cp = IntNum(ts.p.page),
last = IntNum(ts.p.lastpage), selclick = false,
fp=true, pp=true, np=true,lp=true;
if(last ===0 || last===1) {fp=false;pp=false;np=false;lp=false; }
else if( last>1 && cp >=1) {
if( cp === 1) { fp=false; pp=false; }
else if( cp>1 && cp <last){ }
else if( cp===last){ np=false;lp=false; }
} else if( last>1 && cp===0 ) { np=false;lp=false; cp=last-1;}
if( this.id === 'first' && fp ) { ts.p.page=1; selclick=true;}
if( this.id === 'prev' && pp) { ts.p.page=(cp-1); selclick=true;}
if( this.id === 'next' && np) { ts.p.page=(cp+1); selclick=true;}
if( this.id === 'last' && lp) { ts.p.page=last; selclick=true;}
if(selclick) {
if (typeof ts.p.onPaging =='function') {ts.p.onPaging(this.id);}
populate();
ts.p.selrow = null;
if(ts.p.multiselect) {ts.p.selarrrow =[];$('#cb_jqg',ts.grid.hDiv).attr("checked",false);}
ts.p.savedRow = [];
}
e.stopPropagation();
return false;
});
}
if(ts.p.pginput===true) {
$('input.selbox',ts.p.pager).keypress( function(e) {
var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
if(key == 13) {
ts.p.page = ($(this).val()>0) ? $(this).val():ts.p.page;
if (typeof ts.p.onPaging =='function') {ts.p.onPaging( 'user');}
populate();
ts.p.selrow = null;
return false;
}
return this;
});
}
};
var sortData = function (index, idxcol,reload){
var imgs, so, scg, ls, iId;
if(ts.p.savedRow.length > 0) {return;}
if(!reload) {
if( ts.p.lastsort === idxcol ) {
if( ts.p.sortorder === 'asc') {
ts.p.sortorder = 'desc';
} else if(ts.p.sortorder === 'desc') { ts.p.sortorder='asc';}
} else { ts.p.sortorder='asc';}
ts.p.page = 1;
}
imgs = (ts.p.sortorder==='asc') ? ts.p.sortascimg : ts.p.sortdescimg;
imgs = "<img src='"+ts.p.imgpath+imgs+"'>";
var thd= $("thead:first",grid.hDiv).get(0);
ls = ts.p.colModel[ts.p.lastsort].name.replace('.',"\\.");
$("tr th div#jqgh_"+ls+" img",thd).remove();
$("tr th div#jqgh_"+ls,thd).parent().removeClass(ts.p.sortclass);
iId = index.replace('.',"\\.");
$("tr th div#"+iId,thd).append(imgs).parent().addClass(ts.p.sortclass);
ts.p.lastsort = idxcol;
index = index.substring(5);
ts.p.sortname = ts.p.colModel[idxcol].index || index;
so = ts.p.sortorder;
if(onSortCol) {onSortCol(index,idxcol,so);}
if(ts.p.datatype == "local") {
if(ts.p.deselectAfterSort) {$(ts).resetSelection();}
} else {
ts.p.selrow = null;
if(ts.p.multiselect){$("#cb_jqg",ts.grid.hDiv).attr("checked",false);}
ts.p.selarrrow =[];
ts.p.savedRow =[];
}
scg = ts.p.scroll; if(ts.p.scroll===true) {ts.p.scroll=false;}
populate();
if(ts.p.sortname != index && idxcol) {ts.p.lastsort = idxcol;}
setTimeout(function() {ts.p.scroll=scg;},500);
};
var setColWidth = function () {
var initwidth = 0;
for(var l=0;l<ts.p.colModel.length;l++){
if(!ts.p.colModel[l].hidden){
initwidth += IntNum(ts.p.colModel[l].width);
}
}
var tblwidth = ts.p.width ? ts.p.width : initwidth;
for(l=0;l<ts.p.colModel.length;l++) {
if(!ts.p.shrinkToFit){
ts.p.colModel[l].owidth = ts.p.colModel[l].width;
}
ts.p.colModel[l].width = Math.round(tblwidth/initwidth*ts.p.colModel[l].width);
}
};
var nextVisible= function(iCol) {
var ret = iCol, j=iCol, i;
for (i = iCol+1;i<ts.p.colModel.length;i++){
if(ts.p.colModel[i].hidden !== true ) {
j=i; break;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -