| | |
| | | ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); |
| | | List<MdcPartProcessInfo> mdcPartProcessInfos = this.baseMapper.selectList(queryWrapper); |
| | | // 导出文件名称 |
| | | mv.addObject(NormalExcelConstants.FILE_NAME, "零件加工数据列表"); |
| | | mv.addObject(NormalExcelConstants.FILE_NAME, "零件加工数据列表"); |
| | | mv.addObject(NormalExcelConstants.CLASS, MdcPartProcessInfo.class); |
| | | LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); |
| | | mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("零件加工数据列表数据", "导出人:" + user.getRealname(), "零件加工数据")); |
| | |
| | | mv.addObject(NormalExcelConstants.DATA_LIST, mdcPartProcessInfos); |
| | | return mv; |
| | | } |
| | | |
| | | /** |
| | | * 查询设备某天总加工时间 |
| | | * |
| | | * @param equipmentId |
| | | * @param validDate |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Integer selectTotalProcessLong(String equipmentId, String validDate) { |
| | | Integer totalProcessLong = this.baseMapper.selectTotalProcessLong(equipmentId, validDate); |
| | | if (totalProcessLong == null) { |
| | | return 0; |
| | | } else { |
| | | return totalProcessLong; |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询设备某天总加工数量 |
| | | * |
| | | * @param equipmentId |
| | | * @param validDate |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Integer selectTotalProcessCount(String equipmentId, String validDate) { |
| | | Integer totalProcessCount = this.baseMapper.selectTotalProcessCount(equipmentId, validDate); |
| | | if (totalProcessCount == null) { |
| | | return 0; |
| | | } else { |
| | | return totalProcessCount; |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询设备某天总加工合格数量 |
| | | * |
| | | * @param equipmentId |
| | | * @param validDate |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Integer selectTotalPassCount(String equipmentId, String validDate) { |
| | | Integer totalPassCount = this.baseMapper.selectTotalPassCount(equipmentId, validDate); |
| | | if (totalPassCount == null) { |
| | | return 0; |
| | | } else { |
| | | return totalPassCount; |
| | | } |
| | | } |
| | | } |