这铝框查询改为只查近两天数据

ZengTao

2025-04-21 492ea67c59e9b82115c4a8b7817ccb3242a15bc1

这铝框查询改为只查近两天数据

 hangzhoumesParent/moduleService/hollowGlassModule/src/main/java/com/mes/hollowqueue/service/impl/HollowGlassQueueInfoServiceImpl.java

@@ -16,6 +16,8 @@
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Optional;

@@ -46,6 +48,7 @@

    @Override
    public List<HollowGlassQueueInfo> queryHollowGlassQueueInfoByLine(int cell) {
        LocalDateTime twoDaysAgo = LocalDate.now().atStartOfDay().minusDays(1);
        List<String> relationIds = this.listObjs(
                new LambdaQueryWrapper<HollowGlassQueueInfo>()
                        .lt(HollowGlassQueueInfo::getState, 1)
@@ -59,6 +62,7 @@
                        .in("relation_id", relationIds)
                        .eq("cell", cell)
                        .eq("is_pair", 1)
                        .ge("create_time", twoDaysAgo)
                        .select("width","height","flow_card_id","relation_id", "hollow_sequence", "cell", "MAX(state) as state", "MAX(layer) as layer")
                        .groupBy("relation_id", "hollow_sequence")
                        .orderByAsc("relation_id", "hollow_sequence")