| | |
| | | |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.util.ArrayList; |
| | | import java.util.LinkedList; |
| | | import java.util.List; |
| | | import java.util.Queue; |
| | |
| | | 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; |
| | | } |
| | |
| | | * 查询库位订单信息 |
| | | * |
| | | */ |
| | | 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){ |
| | | if(orders!=null && orders.size()>0){ |
| | | List<OrderDTO> dtos = new ArrayList<>(); |
| | | for (Order order : orders) { |
| | | OrderDTO dto = new OrderDTO(); |
| | | BeanUtils.copyProperties(order, dto); |
| | | return dto; |
| | | dto.setItems(orderService.getPtCuOrderItems(dto.getId())); |
| | | dtos.add(dto); |
| | | } |
| | | return dtos; |
| | | } |
| | | return null; |
| | | } |