| | |
|---|
| | | queryWrapper.eq("ems.equipment_id", query.getEquipmentId()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //保养分类 |
|---|
| | | //规范状态 |
|---|
| | | if (StringUtils.isNotBlank(query.getStandardStatus())) { |
|---|
| | | queryWrapper.eq("ems.standard_status", query.getStandardStatus()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //设备编码 |
|---|
| | | if (StringUtils.isNotBlank(query.getKeyword())) { |
|---|
| | | queryWrapper.and(wrapper -> wrapper.like("e.equipment_name", query.getKeyword()) |
|---|
| | | .or() |
|---|
| | | .like("e.equipment_code", query.getKeyword())); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | queryWrapper.orderByDesc("ems.create_time"); |
|---|
| | |
|---|
| | | return Result.OK(fileName + ":导入成功！"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<EamTechnicalStatusEvaluationStandard> queryListByKeyword(String keyword, String equipmentId, Integer pageSize) { |
|---|
| | | Page<EamTechnicalStatusEvaluationStandard> page = new Page<>(1, pageSize); |
|---|
| | | EamTechnicalStatusEvaluationStandard query = new EamTechnicalStatusEvaluationStandard(); |
|---|
| | | query.setEquipmentId(equipmentId); |
|---|
| | | query.setKeyword(keyword); |
|---|
| | | query.setStandardStatus(TechnicalStatusEvaluationStandardEnum.ENABLE.name()); |
|---|
| | | IPage<EamTechnicalStatusEvaluationStandard> pageData = this.queryPageList(page, query); |
|---|
| | | return pageData.getRecords(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 检查导入文件分类是否匹配 |
|---|
| | | * @param title 标题段落字符串 |
|---|
