package com.web.lytreport.controller; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Sort; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.ControllerAdvice; import org.springframework.web.bind.annotation.CrossOrigin; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.servlet.ModelAndView; import com.app.base.control.WebController; import com.app.base.data.ApiResponseResult; import com.web.lytreport.service.LytReportService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @Api(description = "lyt报表") @CrossOrigin @ControllerAdvice //@RestController @Controller @RequestMapping(value = "/lyt_report") public class LytReportController extends WebController { @Autowired private LytReportService lytReportService; @RequestMapping(value = "/toPage", method = RequestMethod.GET) @ResponseBody public ModelAndView toPage(String pageId) { String method = "/lyt_report/toPage"+pageId; String methodName ="报表页"; ModelAndView mav=new ModelAndView(); try { ApiResponseResult procList = lytReportService.getProdDailyByTaskReport("","","",0);//生产日报-按工单,取工序 ApiResponseResult taskNoList = lytReportService.getTaskNo("");//取工单 mav.addObject("procList",procList); mav.addObject("taskNoList",taskNoList); mav.setViewName("/lyt/"+pageId+".html");//返回路径-报表文件名设置为ID,从数据获取的内容 } catch (Exception e) { e.printStackTrace(); logger.error("获取报表页"+pageId+".html 异常!", e); } return mav; } /** * 44386.html * **/ @ApiOperation(value = "获取电芯测试结果报表", notes = "获取电芯测试结果报表", hidden = true) @RequestMapping(value = "/getDXTestReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getDXTestReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getDXTestReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取电芯测试结果报表=getDXTestReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取电芯测试结果报表失败!", e); return ApiResponseResult.failure("获取电芯测试结果报表失败!"); } } @ApiOperation(value = "导出电芯测试结果报表", notes = "导出电芯测试结果报表", hidden = true) @RequestMapping(value = "/getDXTestPrint", method = RequestMethod.GET) @ResponseBody public void getDXTestPrint(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getDXTestExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出电芯测试结果报表=getDXTestPrint:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出电芯测试结果报表失败!", e); } } /** * 45112.html * **/ @ApiOperation(value = "获取模组测试结果报表", notes = "获取模组测试结果报表", hidden = true) @RequestMapping(value = "/getMZTestReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getMZTestReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getMZTestReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取模组测试结果报表=getMZTestReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取模组测试结果报表失败!", e); return ApiResponseResult.failure("获取模组测试结果报表失败!"); } } @ApiOperation(value = "导出模组测试结果报表", notes = "导出模组测试结果报表", hidden = true) @RequestMapping(value = "/getMZTestExport", method = RequestMethod.GET) @ResponseBody public void getMZTestExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getMZTestExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出模组测试结果报表=getMZTestExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出模组测试结果报表失败!", e); } } /** * 44962.html * **/ @ApiOperation(value = "获取气密性测试结果报表", notes = "获取气密性测试结果报表", hidden = true) @RequestMapping(value = "/getQMXTestReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getQMXTestReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getQMXTestReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取气密性测试结果报表=getQMXTestReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取气密性测试结果报表失败!", e); return ApiResponseResult.failure("获取气密性测试结果报表失败!"); } } @ApiOperation(value = "导出气密性测试结果报表", notes = "导出气密性测试结果报表", hidden = true) @RequestMapping(value = "/getQMXTestExport", method = RequestMethod.GET) @ResponseBody public void getQMXTestExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getQMXTestExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出气密性测试结果报表=getQMXTestExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出气密性测试结果报表失败!", e); } } /** * 44939.html * **/ @ApiOperation(value = "获取整机测试结果报表", notes = "获取整机测试结果报表", hidden = true) @RequestMapping(value = "/getZJTestReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getZJTestReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getZJTestReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取整机测试结果报表=getZJTestReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取整机测试结果报表失败!", e); return ApiResponseResult.failure("获取整机测试结果报表失败!"); } } @ApiOperation(value = "导出整机测试结果报表", notes = "导出整机测试结果报表", hidden = true) @RequestMapping(value = "/getZJTestExport", method = RequestMethod.GET) @ResponseBody public void getZJTestExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getZJTestExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出整机测试结果报表=getZJTestExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出整机测试结果报表失败!", e); } } /** * 45119.html(1) * **/ @ApiOperation(value = "获取电芯配对测试结果报表", notes = "获取电芯配对测试结果报表", hidden = true) @RequestMapping(value = "/getPDTestReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getPDTestReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getPDTestReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取电芯配对测试结果报表=getPDTestReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取电芯配对测试结果报表失败!", e); return ApiResponseResult.failure("获取电芯配对测试结果报表失败!"); } } @ApiOperation(value = "导出电芯配对测试结果报表", notes = "导出电芯配对测试结果报表", hidden = true) @RequestMapping(value = "/getPDTestExport", method = RequestMethod.GET) @ResponseBody public void getPDTestExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getPDTestExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出电芯配对测试结果报表=getPDTestExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出电芯配对测试结果报表失败!", e); } } /** * 45119.html(2) * **/ @ApiOperation(value = "获取电芯配对统计报表", notes = "获取电芯配对统计报表", hidden = true) @RequestMapping(value = "/getPDSumReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getPDSumReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getPDSumReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取电芯配对统计报表=getPDSumReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取电芯配对统计报表失败!", e); return ApiResponseResult.failure("获取电芯配对统计报表失败!"); } } @ApiOperation(value = "导出电芯配对统计报表", notes = "导出电芯配对统计报表", hidden = true) @RequestMapping(value = "/getPDSumExport", method = RequestMethod.GET) @ResponseBody public void getPDSumExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getPDSumExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出电芯配对统计报表=getPDSumExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出电芯配对统计报表失败!", e); } } @ApiOperation(value = "获取工单信息", notes = "获取工单信息", hidden = true) @RequestMapping(value = "/getTaskNo", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getTaskNo(String keyword) { try { ApiResponseResult result = lytReportService.getTaskNo(keyword); logger.debug("获取工单信息=lyt/getTaskNo:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取工单信息失败!", e); return ApiResponseResult.failure("获取工单信息失败!"); } } /** * 43789.html 取两次 * **/ @ApiOperation(value = "获取质量IQC来料检验台账", notes = "获取质量IQC来料检验台账", hidden = true) @RequestMapping(value = "/getQualCheckReport1", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getQualCheckReport1(String year,String month, String target,Integer dataType) { try { ApiResponseResult result = lytReportService.getQualCheckReport1(year,month,target,dataType); logger.debug("获取质量IQC来料检验台账=getQualCheckReport1:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取质量IQC来料检验台账失败!", e); return ApiResponseResult.failure("获取质量IQC来料检验台账失败!"); } } @ApiOperation(value = "导出质量IQC来料检验台账-汇总", notes = "导出质量IQC来料检验台账-汇总", hidden = true) @RequestMapping(value = "/getQualCheckExport1", method = RequestMethod.GET) @ResponseBody public void getQualCheckExport1(HttpServletResponse response,String year,String month, String target,Integer dataType) { try { lytReportService.getQualCheckExport1(response,year,month,target,dataType); logger.debug("导出质量IQC来料检验台账=getQualCheckExport1:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出质量IQC来料检验台账失败!", e); } } @ApiOperation(value = "获取质量IQC来料检验台账", notes = "获取质量IQC来料检验台账", hidden = true) @RequestMapping(value = "/getQualCheckReport2", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getQualCheckReport2(String year,String month, String target,Integer dataType) { try { ApiResponseResult result = lytReportService.getQualCheckReport2(year,month,target,dataType); logger.debug("获取质量IQC来料检验台账=getQualCheckReport2:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取质量IQC来料检验台账失败!", e); return ApiResponseResult.failure("获取质量IQC来料检验台账失败!"); } } @ApiOperation(value = "导出质量IQC来料检验台账-明细", notes = "导出质量IQC来料检验台账-明细", hidden = true) @RequestMapping(value = "/getQualCheckExport2", method = RequestMethod.GET) @ResponseBody public void getQualCheckExport2(HttpServletResponse response,String year,String month, String target,Integer dataType) { try { lytReportService.getQualCheckExport2(response,year,month,target,dataType); logger.debug("导出质量IQC来料检验台账-明细=getQualCheckExport2:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出质量IQC来料检验台账-明细失败!", e); } } /** * 43840.html * **/ @ApiOperation(value = "获取生产日报-按工单报表", notes = "获取生产日报-按工单报表", hidden = true) @RequestMapping(value = "/getProdDailyByTaskReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getProdDailyByTaskReport(String proc,String begTime, String endTime, Integer dataType) { try { ApiResponseResult result = lytReportService.getProdDailyByTaskReport(proc, begTime,endTime,dataType); logger.debug("获取生产日报-按工单报表=getProdDailyByTaskReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取生产日报-按工单报表失败!", e); return ApiResponseResult.failure("获取生产日报-按工单报表失败!"); } } @ApiOperation(value = "导出生产日报-按工单报表", notes = "导出生产日报-按工单报表", hidden = true) @RequestMapping(value = "/getProdDailyByTaskExport", method = RequestMethod.GET) @ResponseBody public void getProdDailyByTaskExport(HttpServletResponse response,String proc,String begTime, String endTime) { try { lytReportService.getProdDailyByTaskExport(response,proc, begTime,endTime, 1); logger.debug("导出生产日报-按工单报表=getProdDailyByTaskExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出生产日报-按工单报表失败!", e); } } /** * 46248.html * **/ @ApiOperation(value = "获取包装记录结果报表-汇总", notes = "获取包装记录结果报表-汇总", hidden = true) @RequestMapping(value = "/getPackRecordSumReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getPackRecordSumReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getPackRecordSumReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取包装记录结果报表-汇总=getPackRecordSumReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取包装记录结果报表-汇总失败!", e); return ApiResponseResult.failure("获取包装记录结果报表失败!"); } } @ApiOperation(value = "获取包装记录结果-详细报表", notes = "获取包装记录结果-详细报表", hidden = true) @RequestMapping(value = "/getPackRecordReport", method = RequestMethod.GET) @ResponseBody public ApiResponseResult getPackRecordReport(String taskNo,String batNo,String begTime,String endTime) { try { Sort sort = Sort.unsorted(); ApiResponseResult result = lytReportService.getPackRecordReport(taskNo,batNo,begTime,endTime,super.getPageRequest(sort)); logger.debug("获取包装记录结果-详细报表=getPackRecordReport:" + result); return result; } catch (Exception e) { e.printStackTrace(); logger.error("获取包装记录-详细结果报表失败!", e); return ApiResponseResult.failure("获取包装记录-详细结果报表失败!"); } } @ApiOperation(value = "导出包装记录-详细结果报表", notes = "导出包装记录-详细结果报表", hidden = true) @RequestMapping(value = "/getPackRecordExport", method = RequestMethod.GET) @ResponseBody public void getPackRecordExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getPackRecordExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出电包装记录-详细结果报表=getPackRecordExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出包装记录-详细结果报表失败!", e); } } @ApiOperation(value = "导出包装记录-汇总结果报表", notes = "导出包装记录-汇总结果报表", hidden = true) @RequestMapping(value = "/getPackRecordSumExport", method = RequestMethod.GET) @ResponseBody public void getPackRecordSumExport(HttpServletResponse response,String taskNo,String batNo,String begTime,String endTime) { try { lytReportService.getPackRecordSumExport(response,taskNo,batNo,begTime,endTime); logger.debug("导出电包装记录-汇总结果报表=getPackRecordSumExport:"); } catch (Exception e) { e.printStackTrace(); logger.error("导出包装记录-汇总结果报表失败!", e); } } }