金蝶二开 导出xlsx 表格, 自定义字段

模板

代码

	public void exportExcelAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap)
			throws ShrWebBizException {
   
		Context context = SHRContext.getInstance().getContext();
		String selectedIds = request.getParameter("selectedIds");
		List<Map<String, String>> list = new ArrayList<Map<String, String>>();
		System.out.println("selectedIds:" + selectedIds);
		String[] split = selectedIds.split(",");
		StringBuffer ids = new StringBuffer();
		for (int i = 0; i < split.length; i++) {
   
			if (i + 1 == split.length) {
   
				ids.append("'" + split[i] + "'");
				continue;
			}
			ids.append("'" + split[i] + "'" + ",");
		}
		StringBuffer sql = new StringBuffer();
		sql.append(
				"SELECT dir.FNUMBER num ,dir.CFNAME name , dir.CFYEAR year , dir.CFCYCLE cycle , dir.CFISDIRECTOR isdirector , \r\n");
		sql.append(
				"unit.fid adminid , unit.FNAME_L2  admin , dir.CFSTATUS status , person.fid personid , person.FNAME_L2 personName , \r\n");
		sql.append(
				"position.fid positionid , position.FNAME_L2 position , rperson.fid rpersonid , rperson.FNAME_L2 rpersonname , raters.CFTYPE rtype , raters.CFSTATUS rstatus \r\n");
		sql.append("FROM CT_PF_DirectorAssessment dir\r\n");
		sql.append("LEFT OUTER JOIN CT_PF_DirectorAssessmentEntry dirEntry on dir.fid = dirEntry.FPARENTID \r\n");
		sql.append("LEFT OUTER JOIN CT_PF_Raters raters on dirEntry.fid = raters.CFPROCESSSHEETID \r\n");
		sql.append("LEFT OUTER JOIN T_BD_Person person on person.fid = dirEntry.CFPERSONID \r\n");
		sql.append("LEFT OUTER JOIN T_ORG_BaseUnit unit on unit.fid = dirEntry.CFADMINORGUNITID \r\n");
		sql.append("LEFT OUTER JOIN T_ORG_Position position on position.fid = dirEntry.CFPOSITIONID \r\n");
		sql.<