java-excel下载

package com.ihrm.employee.controller; import com.alibaba.fastjson.JSON; import com.ihrm.common.controller.BaseController; import com.ihrm.common.entity.PageResult; import com.ihrm.common.entity.Result; import com.ihrm.common.entity.ResultCode; import com.ihrm.common.utils.BeanMapUtils; import com.ihrm.common.utils.DownloadUtils; import com.ihrm.domain.employee.*; import com.ihrm.domain.employee.response.EmployeeReportResult; import com.ihrm.employee.service.*; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.streaming.SXSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.Resource; import org.springframework.data.domain.Page; import org.springframework.web.bind.annotation.*; import java.io.ByteArrayOutputStream; import java.io.FileInputStream; import java.util.*; @RestController @CrossOrigin @RequestMapping("/employees") public class EmployeeController extends BaseController { @Autowired private UserCompanyPersonalService userCompanyPersonalService; @Autowired private UserCompanyJobsService userCompanyJobsService; @Autowired private ResignationService resignationService; @Autowired private TransferPositionService transferPositionService; @Autowired private PositiveService positiveService; @Autowired private ArchiveService archiveService; /** * 员工个人信息保存 */ @RequestMapping(value = "/{id}/personalInfo", method = RequestMethod.PUT) public Result savePersonalInfo(@PathVariable(name = "id") String uid, @RequestBody Map map) throws Exception { UserCompanyPersonal sourceInfo = BeanMapUtils.mapToBean(map, UserCompanyPersonal.class); if (sourceInfo == null) { sourceInfo = new UserCompanyPersonal(); } sourceInfo.setUserId(uid); sourceInfo.setCompanyId(super.companyId); userCompanyPersonalService.save(sourceInfo); return new Result(ResultCode.SUCCESS); } /** * 员工个人信息读取 */ @RequestMapping(value = "/{id}/personalInfo", method = RequestMethod.GET) public Result findPersonalInfo(@PathVariable(name = "id") String uid) throws Exception { UserCompanyPersonal info = userCompanyPersonalService.findById(uid); if (info == null) { info = new UserCompanyPersonal(); info.setUserId(uid); } return new Result(ResultCode.SUCCESS, info); } /** * 员工岗位信息保存 */ @RequestMapping(value = "/{id}/jobs", method = RequestMethod.PUT) public Result saveJobsInfo(@PathVariable(name = "id") String uid, @RequestBody UserCompanyJobs sourceInfo) throws Exception { //更新员工岗位信息 if (sourceInfo == null) { sourceInfo = new UserCompanyJobs(); sourceInfo.setUserId(uid); sourceInfo.setCompanyId(super.companyId); } userCompanyJobsService.save(sourceInfo); return new Result(ResultCode.SUCCESS); } /** * 员工岗位信息读取 */ @RequestMapping(value = "/{id}/jobs", method = RequestMethod.GET) public Result findJobsInfo(@PathVariable(name = "id") String uid) throws Exception { UserCompanyJobs info = userCompanyJobsService.findById(uid); if (info == null) { info = new UserCompanyJobs(); info.setUserId(uid); info.setCompanyId(companyId); } return new Result(ResultCode.SUCCESS, info); } /** * 离职表单保存 */ @RequestMapping(value = "/{id}/leave", method = RequestMethod.PUT) public Result saveLeave(@PathVariable(name = "id") String uid, @RequestBody EmployeeResignation resignation) throws Exception { resignation.setUserId(uid); resignationService.save(resignation); return new Result(ResultCode.SUCCESS); } /** * 离职表单读取 */ @RequestMapping(value = "/{id}/leave", method = RequestMethod.GET) public Result findLeave(@PathVariable(name = "id") String uid) throws Exception { EmployeeResignation resignation = resignationService.findById(uid); if (resignation == null) { resignation = new EmployeeResignation(); resignation.setUserId(uid); } return new Result(ResultCode.SUCCESS, resignation); } /** * 调岗表单保存 */ @RequestMapping(value = "/{id}/transferPosition", method = RequestMethod.PUT) public Result saveTransferPosition(@PathVariable(name = "id") String uid, @RequestBody EmployeeTransferPosition transferPosition) throws Exception { transferPosition.setUserId(uid); transferPositionService.save(transferPosition); return new Result(ResultCode.SUCCESS); } /** * 调岗表单读取 */ @RequestMapping(value = "/{id}/transferPosition", method = RequestMethod.GET) public Result findTransferPosition(@PathVariable(name = "id") String uid) throws Exception { UserCompanyJobs jobsInfo = userCompanyJobsService.findById(uid); if (jobsInfo == null) { jobsInfo = new UserCompanyJobs(); jobsInfo.setUserId(uid); } return new Result(ResultCode.SUCCESS, jobsInfo); } /** * 转正表单保存 */ @RequestMapping(value = "/{id}/positive", method = RequestMethod.PUT) public Result savePositive(@PathVariable(name = "id") String uid, @RequestBody EmployeePositive positive) throws Exception { positiveService.save(positive); return new Result(ResultCode.SUCCESS); } /** * 转正表单读取 */ @RequestMapping(value = "/{id}/positive", method = RequestMethod.GET) public Result findPositive(@PathVariable(name = "id") String uid) throws Exception { EmployeePositive positive = positiveService.findById(uid); if (positive == null) { positive = new EmployeePositive(); positive.setUserId(uid); } return new Result(ResultCode.SUCCESS, positive); } /** * 历史归档详情列表 */ @RequestMapping(value = "/archives/{month}", method = RequestMethod.GET) public Result archives(@PathVariable(name = "month") String month, @RequestParam(name = "type") Integer type) throws Exception { return new Result(ResultCode.SUCCESS); } /** * 归档更新 */ @RequestMapping(value = "/archives/{month}", method = RequestMethod.PUT) public Result saveArchives(@PathVariable(name = "month") String month) throws Exception { return new Result(ResultCode.SUCCESS); } /** * 历史归档列表 */ @RequestMapping(value = "/archives", method = RequestMethod.GET) public Result findArchives(@RequestParam(name = "pagesize") Integer pagesize, @RequestParam(name = "page") Integer page, @RequestParam(name = "year") String year) throws Exception { Map map = new HashMap(); map.put("year", year); map.put("companyId", companyId); Page<EmployeeArchive> searchPage = archiveService.findSearch(map, page, pagesize); PageResult<EmployeeArchive> pr = new PageResult(searchPage.getTotalElements(), searchPage.getContent()); return new Result(ResultCode.SUCCESS, pr); } /** * 当月人事报表导出 * 参数： * 年月-月（2018-02%） */ @RequestMapping(value = "/export/{month}", method = RequestMethod.GET) public void export(@PathVariable String month) throws Exception { companyId = "1"; //1.获取报表数据 List<EmployeeReportResult> list = userCompanyPersonalService.findByReport(companyId, month); //2.构造Excel //创建工作簿 //SXSSFWorkbook : 百万数据报表 //Workbook wb = new XSSFWorkbook();