管路&气柜产能负载优化，实现动态row聚合统计

hongjli

2025-05-22 bc0fdd1f0c20ca4737e8f073050f37b27a658694

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsStandardProcessRouteHeaderServiceImpl.java

@@ -1,12 +1,18 @@
package com.aps.core.service.impl;

import java.util.List;
import com.alibaba.fastjson2.JSONObject;
import com.aps.common.core.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsStandardProcessRouteHeaderMapper;
import com.aps.core.domain.ApsStandardProcessRouteHeader;
import com.aps.core.mapper.ApsStandardProcessRouteHeaderMapper;
import com.aps.core.service.IApsStandardProcessRouteHeaderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * 标准工艺路线HeaderService业务层处理
@@ -19,6 +25,9 @@
{
    @Autowired
    private ApsStandardProcessRouteHeaderMapper apsStandardProcessRouteHeaderMapper;

    @Autowired
    public RedisTemplate redisTemplate;

    /**
     * 查询标准工艺路线Header
@@ -93,4 +102,24 @@
    {
        return apsStandardProcessRouteHeaderMapper.deleteApsStandardProcessRouteHeaderById(id);
    }

    @Override
    public boolean setProcessRouteDataToRedis(String orgCode) {
        try {
            Set<String> keys = redisTemplate.keys("ROUTE:ROUTE_*");
            if (keys != null && !keys.isEmpty()) {
                redisTemplate.delete(keys);
            }
            List<JSONObject> res = apsStandardProcessRouteHeaderMapper.selectProcessRouteStandardTimeData(orgCode);
            Map<String, Object> bulkData = new HashMap<>();
            for (JSONObject jsonObject : res) {
                bulkData.put("ROUTE:ROUTE_"+jsonObject.getString("org_code")+"_"+jsonObject.getString("item_code"), jsonObject.getBigDecimal("standardtime"));
            }
            redisTemplate.opsForValue().multiSet(bulkData);
            return true;
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
    }
}