//导出excel
function toExcel(){
var i = 0;
$('#repairForm').find("input[type='checkbox']").each(function () {
if ($(this).is(':checked')) {
i = i + 1
}
});
if (i == 0) {
swal("警告!", "亲~~~您还没有选择数据任务哦!", "warning");
} else {
swal({
title: "是否确认下载所选任务? ",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#1ab394",
confirmButtonText: "确认下载!",
closeOnConfirm: false
}, function () {
var data = $('<input>').attr({ name: "data", value: $('#repairForm').serialize() });
var $form = $("<form>");
$form.attr({ target: '_self', method: 'post', action: '/taskmanagement/excel' }).append(data);
$form.submit();
});
}
}
// 判断是否有数据
if (request.getParameterNames().toString().contains("data")){
Map<String,Object> dataMap = new HashMap<String,Object>();
List<String> titles = new ArrayList<String>();
titles.add("姓名"); //1
titles.add("身份证号码"); //2
titles.add("QQ"); //3
titles.add("手机号"); //4
titles.add("查询机构"); //5
dataMap.put("titles", titles);
List<PageData> varList = new ArrayList<PageData>();
// 取到网页数据
String originStr = request.getParameterValues("data")[0];
// 处理数据,得到col_loan的id
String[] colIds = originStr.substring(originStr.indexOf("colId")+6).split("&colId=");
//String[] colIds = request.getParameterValues("colId");
for (String colId : colIds) {
/** 需要的数据不确定,先这么写,确定后之后再写关联查询*/
ColLoan colLoan =
ComCompany company =
PageData vpd = new PageData();
vpd.put("var1", colLoan.getColBorrowername()); // 姓名
vpd.put("var2", colLoan.getColBorroweridcard()); // 身份证
vpd.put("var3", colLoan.getQq()); // QQ
vpd.put("var4", colLoan.getPhone()); // 手机号
vpd.put("var5", company.getComName()); // 机构名
varList.add(vpd);
}
dataMap.put("varList", varList);
ObjectExcelView erv = new ObjectExcelView();
mv = new ModelAndView(erv,dataMap);
return mv;
}
mv.setViewName("/ir");
return mv;
主要解决form的action和Excel下载按钮提交的不是同一个url和只下载选中的checkbox