//构造表头
@Override
public String getDynamicColumns(String dateTime) {
//动态设置最上表头的宽度
int colCount = 2;
//展示钢种表头
String head = "[{title:\"" +"日期:" + dateTime +"\",\"colspan\":2,\"rowspan\":1,width:100},";
List<Map<String,Object>> workingAreaList = dao.getWorkingArea();
for(int i = 0;i<workingAreaList.size();i++){
String workingAreaCode = (String) workingAreaList.get(i).get("workingAreaCode");
String workingAreaName = (String) workingAreaList.get(i).get("workingAreaName");
//获取当天工区对应的班组个数
int count = dao.getWorkingTeamCount(workingAreaCode) + 1;
colCount += count;
head += "{title:\""+workingAreaName+"\",\"colspan\":"+count+",\"rowspan\":1,width:100},";
}
head += "{title:\"\",\"colspan\":1,\"rowspan\":1,width:100}],";
//报表最上表头
String title = "[{title:\"班组日报表\",align:\"center\",\"colspan\":"+colCount+",\"rowspan\":1}],";
//构建easyui表格Columns属性
String content = "[{field : \"elmtName\",title : \"成本要素\",width : 100},";
content += "{field : \"amountMesr\",title : \"单位\",width : 100},";
for (int j = 0; j < workingAreaList.size(); j++) {
String workingAreaName = (String) workingAreaList.get(j).get("workingAreaName");
String workingAreaCode = (String) workingAreaList.get(j).get("workingAreaCode");
content += "{field : \"" + workingAreaName +"\",title : \"合计\",width : 100},";
List<Map<String,Object>> jsonList = dao.getDynamicColumns(workingAreaCode);
for(int i = 0;i<jsonList.size();i++){
String workingTeamName = (String) jsonList.get(i).get("workingTeamName");
content += "{field : \""+workingTeamName+"\",title : \""+workingTeamName+"\",width : 100},";
}
}
content += "]";
String columns = "["+title+head+content+"]";
return columns;
}
@Override
public String getDynamicColumns(String dateTime) {
//动态设置最上表头的宽度
int colCount = 2;
//展示钢种表头
String head = "[{title:\"" +"日期:" + dateTime +"\",\"colspan\":2,\"rowspan\":1,width:100},";
List<Map<String,Object>> workingAreaList = dao.getWorkingArea();
for(int i = 0;i<workingAreaList.size();i++){
String workingAreaCode = (String) workingAreaList.get(i).get("workingAreaCode");
String workingAreaName = (String) workingAreaList.get(i).get("workingAreaName");
//获取当天工区对应的班组个数
int count = dao.getWorkingTeamCount(workingAreaCode) + 1;
colCount += count;
head += "{title:\""+workingAreaName+"\",\"colspan\":"+count+",\"rowspan\":1,width:100},";
}
head += "{title:\"\",\"colspan\":1,\"rowspan\":1,width:100}],";
//报表最上表头
String title = "[{title:\"班组日报表\",align:\"center\",\"colspan\":"+colCount+",\"rowspan\":1}],";
//构建easyui表格Columns属性
String content = "[{field : \"elmtName\",title : \"成本要素\",width : 100},";
content += "{field : \"amountMesr\",title : \"单位\",width : 100},";
for (int j = 0; j < workingAreaList.size(); j++) {
String workingAreaName = (String) workingAreaList.get(j).get("workingAreaName");
String workingAreaCode = (String) workingAreaList.get(j).get("workingAreaCode");
content += "{field : \"" + workingAreaName +"\",title : \"合计\",width : 100},";
List<Map<String,Object>> jsonList = dao.getDynamicColumns(workingAreaCode);
for(int i = 0;i<jsonList.size();i++){
String workingTeamName = (String) jsonList.get(i).get("workingTeamName");
content += "{field : \""+workingTeamName+"\",title : \""+workingTeamName+"\",width : 100},";
}
}
content += "]";
String columns = "["+title+head+content+"]";
return columns;
}