#新增生产日期和到期日期，和超期检索

lty

2025-06-13 d599942e79ea0198898bdfde049b908418debf54

 src/main/java/com/zy/asrs/controller/AgvLocDetlController.java

@@ -20,6 +20,7 @@
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.time.LocalDate;
import java.util.List;
import java.util.Map;

@@ -40,14 +41,23 @@
                  @RequestParam(required = false)String orderByType,
                  @RequestParam(required = false)String condition,
                  @RequestParam Map<String, Object> param,
                  @RequestParam(required = false)Boolean unreason){
                  @RequestParam(required = false)Boolean unreason,
                  @RequestParam(required = false)Boolean expired){
        if (!Cools.isEmpty(unreason) && unreason) {

            return R.ok(agvLocDetlService.selectPage(new Page<>(curr, limit), new EntityWrapper<AgvLocDetl>()
                    .where(" DATALENGTH( batch ) != 11 or\n" +
                            "            batch LIKE '%[a-z]%'")));
        }
        if (!Cools.isEmpty(expired) && expired) {
            return R.ok(agvLocDetlService.selectPage(
                    new Page<>(curr, limit),
                    new EntityWrapper<AgvLocDetl>()
                            .where("deadline < {0}", LocalDate.now())  // 新增的过期判断
            ));
        }
        param.remove("unreason");
        param.remove("expired");
        String row = "";
        EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>();
        if (param.get("row") != null) {