easyui合并列中相同的单元格
$(function(){
/**
* Name 载入数据
*/
//不显示 显示正常用户按钮
//控制页面大小
var h;
h = $(window).height()-20;
$(window).resize(function(){
h = $(window).height()-20;
$('#wu-datagrid-2').datagrid('resize',{height:h});
});
$('#wu-datagrid-2').datagrid({
url:'../requisitionAction!getRequisitions.action',
loadFilter:pagerFilter, //过滤
rownumbers:true,
singleSelect:true,
height:h,
pageSize:20,
pagination:true,
fitColumns:true,
striped: true,
loadMsg:"正在努力加载数据,请等待...",
remoteSort:true,
collapsible:false,//是否可折叠的
frozenColumns:[[
{ field:'ck', checkbox:'true'},
{ field:'RLydh',title:'领用单号',sortable:true},
{ field:'RLydzt',title:'申请单状态',sortable:true,
formatter:function(value,row,index){
if(value=="0"){
return '<span style="color:orange">未处理</span>';
}else if(value=="2"){
return '<span style="color:green">已处理</span>';
}else if(value=="1"){
return '<span style="color:red">被驳回</span>';
}
}
}
]],
onLoadSuccess: function (data) {
if (data.rows.length > 0) {
//调用mergeCellsByField()合并单元格
alert("1111111");
mergeCellsByField("wu-datagrid-2", "RSscp,RKhmc,RShr,RLxdh,RShdz");
}
},
columns:[[
{ field:'RSscp',title:'所属产品',sortable:true},
{ field:'RKhmc',title:'客户名称',sortable:true},
{ field:'RShr',title:'收货人',sortable:true},
{ field:'RLxdh',title:'联系电话',sortable:true},
{ field:'RShdz',title:'收货地址',sortable:true},
{ field:'RJhfs',title:'交货方式',sortable:true},
{ field:'RFhrq',title:'发货日期',sortable:true,
//格式化时间
formatter : function(value){
if (value == null || value == '') {
return '';
}
var date = new Date(value);
var y = date.getFullYear();
var m = date.getMonth() + 1;
var d = date.getDate();
return y + '-' +m + '-' + d;
}
},
{ field:'RGzlb',title:'故障类别',sortable:true},
{ field:'RFwlb',title:'服务类别',sortable:true},
{ field:'RFylb',title:'费用类别',sortable:true},
{ field:'RSsxs',title:'所属销售',sortable:true},
{ field:'RLrry',title:'经办人',sortable:true,
formatter:function(value,row,index){
if (value == null || value == '') {
return '';
}else{
return '<a href="#" onclick="getUserInfo('+index+')" style="color:blue">'+value+'</a>';
}
}
},
{ field:'RSqr',title:'申请人',sortable:true},
{ field:'RLrsj',title:'申请单录入时间',sortable:true},
{ field:'RClry',title:'处理人员',sortable:true},
{ field:'RClsj',title:'处理时间',sortable:true},
{ field:'RClbz',title:'处理备注',sortable:true},
{ field:'RFcdh',title:'返厂单号',sortable:true,
formatter:function(value,row,index){
if(value=="null"||value==""||value==null){
return '<span></span>';
}else{
return '<span>'+value+'</span>';
}
}
},
{ field:'RChdh',title:'出货单号',sortable:true}
]]
});
});
function mergeCellsByField(tableID, colList) {
alert("tableID--"+tableID+"---colList--"+colList);
var ColArray = colList.split(",");
var tTable = $("#" + tableID);
var TableRowCnts = tTable.datagrid("getRows").length;
var tmpA;
var tmpB;
var PerTxt = "";
var CurTxt = "";
var alertStr = "";
for (j = ColArray.length - 1; j >= 0; j--) {
PerTxt = ""; tmpA = 1; tmpB = 0;
for (i = 0; i <= TableRowCnts; i++) {
if (i == TableRowCnts) {
CurTxt = "";
} else { CurTxt = tTable.datagrid("getRows")[i][ColArray[j]];
}
if (PerTxt == CurTxt) {
tmpA += 1;
} else {
tmpB += tmpA;
tTable.datagrid("mergeCells", {
index: i - tmpA,
field: ColArray[j],
//合并字段
rowspan: tmpA,
colspan: null
});
tTable.datagrid("mergeCells", {
//根据ColArray[j]进行合并
index: i - tmpA,
field: "Ideparture",
rowspan: tmpA,
colspan: null
});
tmpA = 1;
}
PerTxt = CurTxt;
}
}
}