前台:
function queryByProvince() {
//判断是否选择开始日期和结束日期
var begindate = $("#startdate_province").val();
var enddate = $("#enddate_province").val();
if (!checkIsNull(begindate) && !checkIsNull(enddate)) {
var province = $("#province").val();
$.ajax({
type: "post",
url: '',
dataType: 'json',
contentType: "application/json; charset=utf-8",
async: false,
//contentType: "application/json",
data: "{'province': '" + province + "','begindate':'" + begindate + "','enddate':'" + enddate + "'}",
success: function (res) {
var jsondata = res.d;
var workTaskDataJson = JSON.parse(jsondata); ----一定要在前台再转一次json,否则table会报异常
//设置 按区域统计-表格
layui.use('table', function () {
var table = layui.table;
//展示已知数据
table.render({
elem: '#province' -------- 网页中 div 的id
, cols: [
[ //标题栏
{ field: 'COMPANY', title: '公司', width: 100, sort: true }
, { field: 'INCNT', title: '进入', width: 80 ,sort: true}
, { field: 'OUTCNT', title: '离职', width: 80, sort: true }
]
]
, data: workTaskDataJson --------将json赋值给table
//将获取的json赋值给table
//,skin: 'line' //表格风格
, even: true
, page: true //是否显示分页
,limits: [5, 7]
, limit: 5 //每页默认显示的数量
});
});
}, error: function () {
}
});
}
else {
layer.msg("请选择开始日期和结束日期");
}
}
后台:
json格式:
[{"COMPANY":"华为公司","INCNT":"5","OUTCNT":"8"},
{"COMPANY":"中兴","INCNT":"14","OUTCNT":"11"},
{"COMPANY":"格力","INCNT":"0","OUTCNT":"0"}
]