如果Excel的导出是从后台查询的,并且用了关键字搜索,需要注意编码问题,encodeURI(encodeURI(name)) URLDecoder.decode(name, "UTF-8");
//页面方法,导出为Excel
function exporttoexcel(){
var name=$("#name").val();
ctype=$("#ctype").val();
/* var a = $('#exampleTableEvents').bootstrapTable('getSelections');
var arr = new Array();
for(var i=0;i<a.length;i++){
arr.push(a[i].w_id);
}
alert(arr)
*/
window.location.href="${pageContext.request.contextPath }/admin/chuhuoToExcel?name="+encodeURI(encodeURI(name))+"&ctype="+ctype;
}
/**
* 后台,出货记录 导出
* @param response
* @param name 商品名称
* @param ctype 客户类型1客户2代理
*/
@RequestMapping(value="/chuhuoToExcel")
public void chuhuoToExcel(HttpServletResponse response,
@RequestParam(value="name",required=false)String name,
@RequestParam(required=false)String ctype){
List<Map<String,Object>> models = null;
Admin admin = adminService.getCurrent();
if(admin==null){
return;
}
String where = " 1=1 and sl_status=1 and sl_delete=1 ";
where += " and sl_mid="+admin.getMemberId();
if (name != null && !"".equals(name)) {
try {
name = URLDecoder.decode(name, "UTF-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
//String kw = Common.containsDanyin(name);
where += " and (c_name like '%"+name+"%' or sd_gname like '%"+name+"%') ";
}
if(StringUtils.isNotBlank(ctype)) {
//Integer type = Integer.parseInt(ctype);
where += " and c_type="+ctype;
}
where += " group by sl_id ";
where += " order by sl_id desc ";
models = shipmentService.jinhuoToExcel(where);
String exportData = "[{\"colkey\":\"sl_sn\",\"name\":\"编号\",\"hide\":false},"+
"{\"colkey\":\"c_name\",\"name\":\"客户姓名\",\"hide\":false},"+
"{\"colkey\":\"c_phone\",\"name\":\"客户手机号\",\"hide\":false},"+
"{\"colkey\":\"leixing\",\"name\":\"客户类型\",\"hide\":false},"+
"{\"colkey\":\"sl_discount\",\"name\":\"折扣(几折)\",\"hide\":false},"+
"{\"colkey\":\"sl_cmoney\",\"name\":\"预存金额(元)\",\"hide\":false},"+
"{\"colkey\":\"sl_paymoney\",\"name\":\"线下支付(元)\",\"hide\":false},"+
"{\"colkey\":\"sl_money\",\"name\":\"应收金额(元)\",\"hide\":false},"+
"{\"colkey\":\"creatdate\",\"name\":\"添加时间\",\"hide\":false},"+
"]";
List<Map<String, Object>> lis = JsonUtils.parseJSONList(exportData);
POIUtils.exportToExcel(response, models, lis, "出货记录");
}