优化

gongzuming

2024-11-12 24f7f046f8854d63839ad52d0cff34ea45a0f449

 src/main/java/com/mzl/flower/service/warehouse/WarehouseService.java

@@ -22,6 +22,7 @@

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;
import java.util.Queue;
@@ -125,15 +126,13 @@
    public List<WarehouseLocationDTO> queryWarehouseLocation(Long warehouseId, String code) {
        List<WarehouseLocationDTO> locations = warehouseLocationMapper.findAll(warehouseId, code);
        for (WarehouseLocationDTO location : locations) {
            OrderDTO orderDTO = getOrderByWarehouseLocation(location.getId());
            if(orderDTO == null){
            List<OrderDTO> orderDTOs = getOrderByWarehouseLocation(location.getId());
            if(orderDTOs == null || orderDTOs.size()==0){
                location.setUsed(false);
            }else{
                location.setItems(orderService.getPtCuOrderItems(orderDTO.getId()));
                location.setUsed(true);
            }
            location.setOrderDTO(orderDTO);

            location.setOrderDTO(orderDTOs);
        }
        return locations;
    }
@@ -142,16 +141,21 @@
     * 查询库位订单信息
     *
     */
    public OrderDTO getOrderByWarehouseLocation(Long warehouseLocationId){
    public List<OrderDTO> getOrderByWarehouseLocation(Long warehouseLocationId){
        LocalDateTime start = LocalDate.now().plusDays(-1).atTime(17, 0, 0);
        LocalDateTime end = LocalDate.now().atTime(16, 59, 59);
        Order order = orderMapper.selectOne(new QueryWrapper<Order>().eq("deleted", 0)
        List<Order> orders = orderMapper.selectList(new QueryWrapper<Order>().eq("deleted", 0)
                .eq("warehouse_location_id", warehouseLocationId)
                .gt("payment_time", start).le("payment_time", end));
        if(order!=null){
            OrderDTO dto = new OrderDTO();
            BeanUtils.copyProperties(order, dto);
            return dto;
        if(orders!=null && orders.size()>0){
            List<OrderDTO> dtos = new ArrayList<>();
            for (Order order : orders) {
                OrderDTO dto = new OrderDTO();
                BeanUtils.copyProperties(order, dto);
                dto.setItems(orderService.getPtCuOrderItems(dto.getId()));
                dtos.add(dto);
            }
            return dtos;
        }
        return null;
    }