| | |
| | | queryWrapper.select(Orders::getClient_name) // 只查询客户名称字段 |
| | | .eq(Orders::getDel_flag, 0) // 只查询未删除的订单 |
| | | .groupBy(Orders::getClient_name); // 按客户名称分组去重 |
| | | |
| | | if (clientName != null && !clientName.isEmpty()) { |
| | | queryWrapper.like(Orders::getClient_name, clientName); |
| | | } |
| | | |
| | | // 执行分页查询 |
| | | IPage<Orders> orderPage = orderMapper.selectPage(page, queryWrapper); |
| | | List<Orders> orders = orderMapper.selectList(queryWrapper); |
| | | // 执行分页查询 |
| | | // IPage<Orders> orderPage = orderMapper.selectPage(page, queryWrapper); |
| | | |
| | | // 转换为客户选项列表(统计每个客户的订单数量) |
| | | List<String> clientOptions = orderPage.getRecords().stream() |
| | | .map(order -> { |
| | | |
| | | |
| | | return order.getClient_name(); |
| | | }) |
| | | List<String> clientOptions = orders.stream() |
| | | .map(Orders::getClient_name) |
| | | .collect(Collectors.toList()); |
| | | |
| | | // 构建结果分页对象 |
| | | Page<String> resultPage = new Page<>(); |
| | | resultPage.setCurrent(orderPage.getCurrent()); |
| | | resultPage.setSize(orderPage.getSize()); |
| | | resultPage.setTotal(orderPage.getTotal()); |
| | | // resultPage.setCurrent(orderPage.getCurrent()); |
| | | // resultPage.setSize(orderPage.getSize()); |
| | | // resultPage.setTotal(orderPage.getTotal()); |
| | | resultPage.setRecords(clientOptions); |
| | | |
| | | return resultPage; |