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