解决mqtt会话无租户信息时数据查询问题

baoshiwei

2024-11-08 c97a9cd2fc453fcf3b7e7bc1f24e45fa318040a1

解决mqtt会话无租户信息时数据查询问题

 jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/mqtt/MqttSampleCallback.java

@@ -273,17 +273,18 @@
          String clientId = mqttUtil.getMqttClient().getClientId();
          String tenant = clientId.substring(clientId.lastIndexOf("_")+1);
          if (tenantId!=null && tenantId.equals(tenant)) {
            TenantContext.setTenant(tenantId);
            // 根据设备编码查询设备信息
            String code = messageJson.getString("code");
            DryEquipment equipmentVo = equipmentService.selectByTenantIdEquipmentId(tenantId,code);
            // 根据设备车间id查询车间信息
            DryShop shop = dryShopService.selectByTenantIdShopId(tenantId, equipmentVo.getShopId());
            DryShop shop = dryShopService.getById(equipmentVo.getShopId());
            // 根据设备类型ID查询设备类型信息
            DryEqpType eqpType = eqpTypeService.selectByTenantIdTypeId(tenantId, equipmentVo.getType());
            DryEqpType eqpType = eqpTypeService.getById(equipmentVo.getType());

            JSONObject res = new JSONObject();

            res.put("tenant", clientId);
            res.put("tenant", tenantId);
            res.put("equipment", equipmentVo);
            res.put("shop", shop);
            res.put("eqpType", eqpType);

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

@@ -11,5 +11,4 @@
 */
public interface IDryEqpTypeService extends IService<DryEqpType> {

    DryEqpType selectByTenantIdTypeId(String type, String equipmentVoType);
}

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

@@ -11,5 +11,4 @@
 */
public interface IDryShopService extends IService<DryShop> {

    DryShop selectByTenantIdShopId(String tenantId, String shopId);
}

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

@@ -17,11 +17,4 @@
@Service
public class DryEqpTypeServiceImpl extends ServiceImpl<DryEqpTypeMapper, DryEqpType> implements IDryEqpTypeService {

    @Override
    public DryEqpType selectByTenantIdTypeId(String tenantId, String id) {
        LambdaQueryWrapper<DryEqpType> query = new LambdaQueryWrapper<>();
        query.eq(DryEqpType::getTenantId, tenantId);
        query.eq(DryEqpType::getId, id);
        return this.getOne(query);
    }
}

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

@@ -17,11 +17,4 @@
@Service
public class DryShopServiceImpl extends ServiceImpl<DryShopMapper, DryShop> implements IDryShopService {

    @Override
    public DryShop selectByTenantIdShopId(String tenantId, String shopId) {
        LambdaQueryWrapper<DryShop> query = new LambdaQueryWrapper<>();
        query.eq(DryShop::getTenantId, tenantId);
        query.eq(DryShop::getId, shopId);
        return this.getOne(query);
    }
}