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);
|
}
|
}
|
}
|