@RequestMapping("/exportStudyInfoDetail")
public void exportStudyInfoDetail(HttpServletResponse response,String siteId,Long mapId,String orgCode,String realName,String certificateNo,String orgName, String batchName,
String projectName,String subjectName,Long batchId,String teacherNo,String state,String otherOrgName,String ic,String trainYears){
SiteInfo site = SiteInfo.get(SiteInfo.class, Long.parseLong(siteId));
Long serviceId = ServiceHolder.getServiceId();
Map<String, Object> paramMap = new HashMap<String, Object>();
ReportStatisticsVO reportStatistics = new ReportStatisticsVO();
if (realName != null && !("".equals(realName))) {
realName = setByte(realName);
reportStatistics.setRealName(realName);
}
paramMap.put("reportStatistics", reportStatistics);
String[] str =new String[]{};
str =new String[]{"序号","市","区县","单位名称","科室名称","人员学期表","姓名","专业","教师证号","身份证号","联系电话","账号","项目名称",
"项目总学时","达标学时","已学学时","未学学时","学习状态","学习进度","结业考试成绩","是否达标"};
List<ReportStatisticsVO> userList=iReportStatisticsService.getStudyInfoDetailList(site.getId(), serviceId, orgCode ,paramMap);
int i;
int k;
/**
* k表示sheet工作表的张数
*/
int dataSizeNum=userList.size(); //减去表头
if (dataSizeNum%EXCEL_EXPORT_PARAM==0){
k=userList.size()/EXCEL_EXPORT_PARAM;
}else {
k=userList.size()/EXCEL_EXPORT_PARAM+1;
}
HSSFWorkbook book = new HSSFWorkbook();
HSSFCellStyle sheetStyle = setSheetStyle(book);
for (int t=0; t<k; t++){
int titleNum=t+1;
// HSSFSheet sheet = setSheetStyle(book,sheetStyle,"人员信息",str);
HSSFSheet sheet = setSheetStyle(book,sheetStyle,"人员信息"+titleNum,str);
for(i=0;i<EXCEL_EXPORT_PARAM;i++){
int j = 0;
HSSFRow r = sheet.createRow(i+1);
j=j++;
int num=(t*EXCEL_EXPORT_PARAM)+i;
if (num>=userList.size()){
break;
}
ReportStatisticsVO user = userList.get(num);
r.createCell(j++).setCellValue(i+1);
r.createCell(j++).setCellValue(user.getCityName());//市
r.createCell(j++).setCellValue(user.getAreaName());//区县
r.createCell(j++).setCellValue(user.getOrgName());//单位名称
r.createCell(j++).setCellValue(user.getProjectName());//项目名称
r.createCell(j++).setCellValue(user.getZongclasshour().toString());//总学时
r.createCell(j++).setCellValue(user.getDabiao().toString());//达标学时
r.createCell(j++).setCellValue(user.getYixue().toString());//已学
r.createCell(j++).setCellValue(user.getWeixue().toString());//未学
r.createCell(j++).setCellValue(user.getState());//学习状态
r.createCell(j++).setCellValue(user.getFinishper().toString()+"%");//学习进度
r.createCell(j++).setCellValue(user.getScore());//成绩
r.createCell(j++).setCellValue(user.getIsDabiao());//是否达标
}
}
response.setContentType("application/vnd.ms-excel");
response.addHeader("Content-Disposition", "attachment;filename=\"export_studyInfoDetail.xls\"");
try {
book.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}