/****************jqGrid分页显示用法****************/
//jsp页面
<div id="userTableDiv">
<!--分页功能-->
<div class="tableDiv">
<table id='userTable'></table>
<div id='userPager'></div>
</div>
function loadUsertable(colName, colModel)
{
$("#data-source").jqGrid({
datatype: "json",
mtype:'post',
postData:{},
url: basePath +'/hr/firstSelect?random=' + Math.random(),
height:true,
autowidth:true,
colNames: colName,
colModel: colModel,
sortable:true,
sortname:'create_time',
sortorder:'desc',
multiselect:true,
multiboxonly:true,
viewrecords:true,
rowNum:25,
rowList:[25,100,200,500],
pager:'#dataSourcePager', //分页渲染对象
pgbuttons: true,
pginput:true,
//无数据时列表显示
loadComplete: function(){
var re_records = $("#userTable").getGridParam('records');
if(num_status == 1&&(re_records == 0 || re_records == null)){
if($("#norecords12").html() == null){
$("#userTable").parent().append("</pre><div id=\"norecords12\" style='text-align:center;color:red;font-size: 14px;height: 80px;background: #fff;line-height:100px'>抱歉,没有查到符合你条件的数据,请重新输入条件查询!</div><pre>");
}
$("#norecords12").show();
num_status = 0;
}
},
// caption: "用户管理信息",
altRows:false,
jsonReader: {
root: "rows",//记录列表
records: "records",//总记录数
page: "page", //当前页码
total: "total", //总页数
repeatitems: false
}
});
function reloadTable(postData){
$("#userTable").jqGrid('clearGridData'); //清空表格
$("#userTable").jqGrid('setGridParam',{ // 重新加载数据
postData: postData,
datatype:"json",
mtype:"post",
}).trigger("reloadGrid");
var colName = ['账号','用户名称','用户类型','手机号码','状态','数据更新时间','操作'];
var colModel = [
{name:'account',index:'account',width:"280",align:"center"},
{name:'name',index:'name',width:"280",align:"center"},
flag = "应聘者";
}else if(cellvalue ==3){
flag = "院校";
}else if(cellvalue ==4){
flag = "管理员";
}else if(cellvalue ==5){
flag = "admin管理员";
}
return flag;
}
},
{name:'phone',index:'phone',width:"280",align:"center"},
{name:'isUsed',index:'isUsed',width:"280",align:"center",
formatter: function (cellvalue) {
var flag = "";
if(cellvalue ==1)
{
flag = "启用";
}
else if(cellvalue ==0)
{
flag = "禁用";
}
return flag;
}
},
{name:'lastUpdateTime',index:'lastUpdateTime',width:"280",align:"center"},
{name:"id",index:"id",width:"280",align:"center",key:true,sortable: false,
//
formatter: function (cellvalue, options, rowObject) {
var html = "";
if(user != null && user != undefined){
if(user.id==rowObject.id || user.accountType == 5 || (user.accountType == 4 && rowObject.accountType ==2)){
html += "<span title='编辑' οnclick='updateUserInfo(" + cellvalue +"\)'><i class='fa fa-pencil tableIcon p1'></i></span>";
}
if(user.accountType == 5){
html += "<span title='删除' οnclick='deleteRowById(" + cellvalue +"\)'><i class='fa fa-times tableIcon d1'></i></span>";
}
//html += "<span title='初级筛选' οnclick='updateStatus(" + JSON.stringify(rowObject) +"\)'><i class='fa fa-check-circle tableIcon t1'></i></span>";
}
// if(user != null && user != undefined){
// if(user.id==rowObject.id || user.accountType == 5 || (user.accountType == 4 && (rowObject.accountType ==2 || rowObject.accountType ==3))){
// html += "<span title='编辑' οnclick='updateUserInfo(" + cellvalue +"\)'><i class='fa fa-pencil tableIcon p1'></i></span>";
// }
// if(user.accountType == 5){
// html += "<span title='删除' οnclick='deleteRowById(" + cellvalue +"\)'><i class='fa fa-times tableIcon d1'></i></span>";
// }
// }
return html;
}
}
];
//jsp页面
<div id="userTableDiv">
<!--分页功能-->
<div class="tableDiv">
<table id='userTable'></table>
<div id='userPager'></div>
</div>
</div>
function loadUsertable(colName, colModel)
{
$("#data-source").jqGrid({
datatype: "json",
mtype:'post',
postData:{},
url: basePath +'/hr/firstSelect?random=' + Math.random(),
height:true,
autowidth:true,
colNames: colName,
colModel: colModel,
sortable:true,
sortname:'create_time',
sortorder:'desc',
multiselect:true,
multiboxonly:true,
viewrecords:true,
rowNum:25,
rowList:[25,100,200,500],
pager:'#dataSourcePager', //分页渲染对象
pgbuttons: true,
pginput:true,
//无数据时列表显示
loadComplete: function(){
var re_records = $("#userTable").getGridParam('records');
if(num_status == 1&&(re_records == 0 || re_records == null)){
if($("#norecords12").html() == null){
$("#userTable").parent().append("</pre><div id=\"norecords12\" style='text-align:center;color:red;font-size: 14px;height: 80px;background: #fff;line-height:100px'>抱歉,没有查到符合你条件的数据,请重新输入条件查询!</div><pre>");
}
$("#norecords12").show();
num_status = 0;
}else{
//如果存在记录,则隐藏提示信息。
$("#norecords12").hide();}
},
// caption: "用户管理信息",
altRows:false,
jsonReader: {
root: "rows",//记录列表
records: "records",//总记录数
page: "page", //当前页码
total: "total", //总页数
repeatitems: false
}
});
}
function reloadTable(postData){
$("#userTable").jqGrid('clearGridData'); //清空表格
$("#userTable").jqGrid('setGridParam',{ // 重新加载数据
postData: postData,
datatype:"json",
mtype:"post",
}).trigger("reloadGrid");
}
var colName = ['账号','用户名称','用户类型','手机号码','状态','数据更新时间','操作'];
var colModel = [
{name:'account',index:'account',width:"280",align:"center"},
{name:'name',index:'name',width:"280",align:"center"},
{name:'accountType',index:'accountType',width:"280",align:"center",
formatter: function (cellvalue) {
var flag = "";
if(cellvalue ==1){flag = "应聘者";
}else if(cellvalue ==2){
flag = "HR";}else if(cellvalue ==3){
flag = "院校";
}else if(cellvalue ==4){
flag = "管理员";
}else if(cellvalue ==5){
flag = "admin管理员";
}
return flag;
}
},
{name:'phone',index:'phone',width:"280",align:"center"},
{name:'isUsed',index:'isUsed',width:"280",align:"center",
formatter: function (cellvalue) {
var flag = "";
if(cellvalue ==1)
{
flag = "启用";
}
else if(cellvalue ==0)
{
flag = "禁用";
}
return flag;
}
},
{name:'lastUpdateTime',index:'lastUpdateTime',width:"280",align:"center"},
{name:"id",index:"id",width:"280",align:"center",key:true,sortable: false,
//
formatter: function (cellvalue, options, rowObject) {
var html = "";
if(user != null && user != undefined){
if(user.id==rowObject.id || user.accountType == 5 || (user.accountType == 4 && rowObject.accountType ==2)){
html += "<span title='编辑' οnclick='updateUserInfo(" + cellvalue +"\)'><i class='fa fa-pencil tableIcon p1'></i></span>";
}
if(user.accountType == 5){
html += "<span title='删除' οnclick='deleteRowById(" + cellvalue +"\)'><i class='fa fa-times tableIcon d1'></i></span>";
}
//html += "<span title='初级筛选' οnclick='updateStatus(" + JSON.stringify(rowObject) +"\)'><i class='fa fa-check-circle tableIcon t1'></i></span>";
}
// if(user != null && user != undefined){
// if(user.id==rowObject.id || user.accountType == 5 || (user.accountType == 4 && (rowObject.accountType ==2 || rowObject.accountType ==3))){
// html += "<span title='编辑' οnclick='updateUserInfo(" + cellvalue +"\)'><i class='fa fa-pencil tableIcon p1'></i></span>";
// }
// if(user.accountType == 5){
// html += "<span title='删除' οnclick='deleteRowById(" + cellvalue +"\)'><i class='fa fa-times tableIcon d1'></i></span>";
// }
// }
return html;
}
}
];