feat(dry): 添加获取所有机台接口并优化缓存

baoshiwei

6 天以前 4374d41d1fcf28cbff21bc8b31efbbdbc30a893a

feat(dry): 添加获取所有机台接口并优化缓存

- 新增 queryAllEqps 接口，通过租户ID获取所有机台数据
- 添加 DRY_CACHE_TENANT_EQUS_LIST缓存常量
- 实现 queryEqusByTenantId 方法，使用缓存优化查询性能

 jeecg-boot-base-core/src/main/java/org/jeecg/common/constant/CommonCacheConstant.java

@@ -5,4 +5,7 @@
    String SYS_CACHE_TENANT = "sys:cache:tenant";
    //redis缓存各租户下设备信息
    String DRY_CACHE_TENANT_EQUS = "dry:cache:tenant::equs";

    // redis缓存各租户下设备信息列表
    String DRY_CACHE_TENANT_EQUS_LIST = "dry:cache:tenant:equsList";
}

 jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/controller/DryRealTimeDataController.java

@@ -142,6 +142,14 @@
    }


    @ApiOperation(value="获取所有机台", notes="通过租户ID获取所有机台数据")
    @GetMapping("/queryAllEqps")
    public Result<?> queryAllEqps(DryEquipment equipment) {
        List<DryEquipment> dryEquipments = dryEquipmentService.queryEqusByTenantId(equipment);
        return  Result.OK(dryEquipments);
    }


    /**
     * 1001 风箱升     1002 风箱降
     * 1003 滚筒升     1004 滚筒降

 jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/IDryEquipmentService.java

@@ -1,5 +1,6 @@
package org.jeecg.modules.dry.service;

import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.dry.entity.DryEquipment;
import com.baomidou.mybatisplus.extension.service.IService;

@@ -24,4 +25,5 @@
     */
    Map<String,DryEquipment>  queryEquByTenantId(Integer tenantId);

    List<DryEquipment> queryEqusByTenantId(DryEquipment dryEquipment);
}

 jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryEquipmentServiceImpl.java

@@ -1,6 +1,7 @@
package org.jeecg.modules.dry.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.config.TenantContext;
import org.jeecg.common.constant.CommonCacheConstant;
import org.jeecg.common.util.RedisUtil;
@@ -63,4 +64,17 @@
                ));
        return userMap;
    }

    @Override
    @Cacheable(cacheNames = CommonCacheConstant.DRY_CACHE_TENANT_EQUS_LIST, key = "#dryEquipment.tenantId+':'+#dryEquipment.enable" , unless = "#result == null " )
    public List<DryEquipment> queryEqusByTenantId(DryEquipment dryEquipment) {
        TenantContext.setTenant(dryEquipment.getTenantId() +"");
        QueryWrapper<DryEquipment> queryWrapper  = new QueryWrapper<>();
        queryWrapper.lambda().eq(DryEquipment::getTenantId,dryEquipment.getTenantId());
        if (dryEquipment.getEnable()!=null){
            queryWrapper.lambda().eq(DryEquipment::getEnable,dryEquipment.getEnable());
        }
        List<DryEquipment> equipmentList = this.list(queryWrapper);
        return equipmentList;
    }
}