| | |
|---|
| | | lqw.eq(bo.getInspUser() != null, EimsInspectPlan::getInspUser, bo.getInspUser()); |
|---|
| | | lqw.eq(bo.getInspDept() != null, EimsInspectPlan::getInspDept, bo.getInspDept()); |
|---|
| | | lqw.eq(StringUtils.isNotBlank(bo.getStatus()), EimsInspectPlan::getStatus, bo.getStatus()); |
|---|
| | | // 按创建时间倒序 |
|---|
| | | lqw.orderByDesc(EimsInspectPlan::getCreateTime); |
|---|
| | | return lqw; |
|---|
| | | } |
|---|
| | | private QueryWrapper<EimsInspectPlan> buildWrapper(EimsInspectPlanBo bo) { |
|---|
| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public String importData(MultipartFile file, boolean updateSupport) throws IOException, IOException { |
|---|
| | | int successNum = 0; |
|---|
| | | int failureNum = 0; |
|---|
| | | StringBuilder successMsg = new StringBuilder(); |
|---|
| | | StringBuilder failureMsg = new StringBuilder(); |
|---|
| | | |
|---|
| | | // 点检项目列表（假设存在对应的点检项VO） |
|---|
| | | InspectCheckItemImportListener checkItemImportListener = new InspectCheckItemImportListener(updateSupport); |
|---|
| | | EasyExcel.read(file.getInputStream(), InspectCheckItemVo.class, checkItemImportListener).headRowNumber(3).sheet().doRead(); |
|---|
| | |
|---|
| | | .map(String::trim) |
|---|
| | | .orElseThrow(() -> new ServiceException("导入失败，无法读取固定资产编号")); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // 查询设备信息 |
|---|
| | | QueryWrapper<EimsEqu> query = new QueryWrapper<>(); |
|---|
| | | query.eq("asset_no", assetNo); |
|---|
| | | EimsEquVo equVo = equMapper.selectVoOne(query); |
|---|
| | | if (equVo == null) throw new ServiceException("设备未找到，请先在设备台帐中添加"); |
|---|
| | | |
|---|
| | | int successNum = 0; |
|---|
| | | int failureNum = 0; |
|---|
| | | StringBuilder successMsg = new StringBuilder(); |
|---|
| | | StringBuilder failureMsg = new StringBuilder(); |
|---|
| | | |
|---|
| | | for (InspectCheckItemVo itemVo : successList) { |
|---|
| | | if ("设备状态卡状态".equals(itemVo.getItemName())) break; |
|---|
| | | |
|---|
| | | // 如果允许覆盖，则删除已存在的记录 |
|---|
| | | if (updateSupport) { |
|---|
| | | LambdaQueryWrapper<EimsInspectPlan> deleteWrapper = Wrappers.lambdaQuery(); |
|---|
| | | deleteWrapper.eq(EimsInspectPlan::getEquId, equVo.getEquId()) |
|---|
| | | .eq(EimsInspectPlan::getInspName, itemVo.getItemName()) |
|---|
| | | .eq(EimsInspectPlan::getStatus, "0"); |
|---|
| | | baseMapper.delete(deleteWrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 新增点检计划 |
|---|
| | | EimsInspectPlanBo bo = new EimsInspectPlanBo(); |
|---|
| | | bo.setEquId(equVo.getEquId()); |
|---|
| | | bo.setInspName(itemVo.getItemName()); |
|---|
