| | |
| | | import javax.annotation.Resource; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.Collections; |
| | | import java.util.List; |
| | | import java.util.stream.Collectors; |
| | | |
| | |
| | | queryWrapper.eq("ems.standard_status", eamMaintenanceStandard.getStandardStatus()); |
| | | } |
| | | //设备编码 |
| | | if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentCode())) { |
| | | queryWrapper.like("e.equipment_code", eamMaintenanceStandard.getEquipmentCode()); |
| | | } |
| | | //设备名称 |
| | | if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentName())) { |
| | | queryWrapper.like("e.equipment_name", eamMaintenanceStandard.getEquipmentName()); |
| | | if(StringUtils.isNotBlank(eamMaintenanceStandard.getKeyword())) { |
| | | queryWrapper.and(wrapper -> wrapper.like("e.equipment_name", eamMaintenanceStandard.getKeyword()) |
| | | .or() |
| | | .like("e.equipment_code", eamMaintenanceStandard.getKeyword())); |
| | | } |
| | | } |
| | | queryWrapper.orderByDesc("ems.create_time"); |
| | |
| | | Page<EamMaintenanceStandard> page = new Page<EamMaintenanceStandard>(1, pageSize); |
| | | EamMaintenanceStandard query = new EamMaintenanceStandard(); |
| | | query.setEquipmentId(equipmentId); |
| | | query.setEquipmentCode(keyword); |
| | | query.setEquipmentName(keyword); |
| | | query.setKeyword(keyword); |
| | | query.setMaintenanceCategory(maintenanceCategory); |
| | | query.setStandardStatus(MaintenanceStandardStatusEnum.NORMAL.name()); |
| | | IPage<EamMaintenanceStandard> pageData = this.queryPageList(page, query); |
| | | return pageData.getRecords(); |
| | | } |
| | | |
| | | @Override |
| | | public List<EamMaintenanceStandard> queryListByCategory(String maintenanceCategory) { |
| | | LambdaQueryWrapper<EamMaintenanceStandard> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0); |
| | | queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory); |
| | | queryWrapper.eq(EamMaintenanceStandard::getStandardStatus, MaintenanceStandardStatusEnum.NORMAL.name()); |
| | | return eamMaintenanceStandardMapper.selectList(queryWrapper); |
| | | } |
| | | } |