苍穹外卖项目记录 day10 商户端（PC端）订单管理

文章目录

订单搜索
各状态订单数量统计
查询订单详情
接单
拒单
取消订单
派送订单
完成订单
校验收货地址是否超出配送范围

订单搜索

业务规则：

输入订单号/手机号进行搜索，支持模糊搜索
根据订单状态进行筛选
下单时间进行时间筛选
搜索内容为空，提示未找到相关订单
搜索结果页，展示包含搜索关键词的内容
分页展示搜索到的订单数据

/admin/order/conditionSearch GET

@Autowired
private OrderService orderService;/*** 订单搜索* @param ordersPageQueryDTO* @return*/
@GetMapping("/conditionSearch")
@ApiOperation("订单搜索")
public Result<PageResult> conditionSearch(OrdersPageQueryDTO ordersPageQueryDTO){PageResult pageResult = orderService.conditionSearch(ordersPageQueryDTO);return Result.success(pageResult);
}/*** 条件搜索订单分页查询* @param ordersPageQueryDTO* @return*/
PageResult conditionSearch(OrdersPageQueryDTO ordersPageQueryDTO);/*** 订单条件搜索* @param ordersPageQueryDTO* @return*/
@Override
public PageResult conditionSearch(OrdersPageQueryDTO ordersPageQueryDTO) {PageHelper.startPage(ordersPageQueryDTO.getPage(), ordersPageQueryDTO.getPageSize());Page<Orders> page = orderMapper.pageQuery(ordersPageQueryDTO);//部分订单状态需要返回订单菜品信息 将Orders转化为OrderVOList<OrderVO> orderVOList = getOrderVOList(page);return new PageResult(page.getTotal(),orderVOList);
}Page<Orders> pageQuery(OrdersPageQueryDTO ordersPageQueryDTO);<!-- 查询订单列表 --><select id="pageQuery" resultType="com.sky.entity.Orders">select * from orders<where><if test="number != null and number!=''">and number like concat('%',#{number},'%')</if><if test="phone != null and phone!=''">and phone like concat('%',#{phone},'%')</if><if test="userId != null">and user_id = #{userId}</if><if test="status != null">and status = #{status}</if><if test="beginTime != null">and order_time &gt;= #{beginTime}</if><if test="endTime != null">and order_time &lt;= #{endTime}</if></where>order by order_time desc</select>

各状态订单数量统计

/admin/order/statistics GET

OrderController.java

/***  统计各个状态的订单数量* @return*/
@GetMapping("/statistics")
@ApiOperation("各个状态订单数量统计")
public Result<OrderStatisticsVO> statistics(){OrderStatisticsVO orderStatisticsVO = orderService.statistics();return Result.success(orderStatisticsVO);
}

OrderService.java

/*** 各个状态的订单数量统计* @return*/
OrderStatisticsVO statistics();

OrderServiceImpl.java

/*** 各个状态订单数量统计* @return*/@Overridepublic OrderStatisticsVO statistics() {//根据状态 分别查询待接单  待派送  派送中的订单数量Integer toBeConfirmed = orderMapper.countSatus(Orders.TO_BE_CONFIRMED);Integer confirmed = orderMapper.countSatus(Orders.CONFIRMED);Integer deliveryInProgress = orderMapper.countSatus(Orders.DELIVERY_IN_PROGRESS);//将查询出的数据封装岛orderStatisticsVO对象中OrderStatisticsVO orderStatisticsVO = new OrderStatisticsVO();orderStatisticsVO.setToBeConfirmed(toBeConfirmed);orderStatisticsVO.setConfirmed(confirmed);orderStatisticsVO.setDeliveryInProgress(deliveryInProgress);return orderStatisticsVO;}

OrderMapper.java

/*** 根据状态统计订单数量* @param status* @return*/
@Select("select count(id) from orders where status = #{status}")
Integer countSatus(Integer status);

查询订单详情

业务规则：

订单详情页面需要展示订单基本信息（状态、订单号、下单时间、收货人、电话、收货地址、金额等）
订单详情页面需要展示订单明细数据（商品名称、数量、单价）

/admin/order/detail/{id} GET

/*** 查询订单详情* @param id* @return*/
@GetMapping("/details/{id}")
@ApiOperation("查询订单详情")
public Result<OrderVO> details(@PathVariable("id") Long id){OrderVO orderVO = orderService.details(id);return Result.success(orderVO);
}

OrderService.java

OrderVO details(Long id);

OrderSeviceImpl.java

/**** 查询订单详情* @param id* @return*/public OrderVO details(Long id) {//根据id查询订单Orders orders = orderMapper.getById(id);//查询该订单对应得菜品/套餐明显List<OrderDetail> orderDetailList = orderDetailMapper.getByOrderId(orders.getId());// 将该订单及其详情封装到OrderVO并返回OrderVO  orderVO = new OrderVO();BeanUtils.copyProperties(orders,orderVO);orderVO.setOrderDetailList(orderDetailList);return orderVO;
}

OrderDetailMapper.java

/*** 根据订单id查询订单明细* @param orderId* @return*/
@Select("select * from order_detail where order_id = #{orderId}")
List<OrderDetail> getByOrderId(Long orderId);

接单

商家接单其实就是将订单的状态修改为“已接单”

admin/order/confirm PUT

OrderController.java

@PutMapping("/confirm")
@ApiOperation("接单")
public Result confirm(@RequestBody OrdersConfirmDTO ordersConfirmDTO) {orderService.confirm(ordersConfirmDTO);return Result.success();
}

OrderService.java

void confirm(OrdersConfirmDTO ordersConfirmDTO);

OrderServiceImp.java

public void confirm(OrdersConfirmDTO ordersConfirmDTO) {Orders orders = Orders.builder().id(ordersConfirmDTO.getId()).status(Orders.CONFIRMED).build();orderMapper.update(orders);
}

OrderMapper.java

   /*** 修改订单信息* @param orders*/void update(Orders orders);

OrderMapper.xml

<update id="update" parameterType="com.sky.entity.Orders">update orders<set><if test="cancelReason != null and cancelReason!='' ">cancel_reason=#{cancelReason},</if><if test="rejectionReason != null and rejectionReason!='' ">rejection_reason=#{rejectionReason},</if><if test="cancelTime != null">cancel_time=#{cancelTime},</if><if test="payStatus != null">pay_status=#{payStatus},</if><if test="payMethod != null">pay_method=#{payMethod},</if><if test="checkoutTime != null">checkout_time=#{checkoutTime},</if><if test="status != null">status = #{status},</if><if test="deliveryTime != null">delivery_time = #{deliveryTime}</if></set>where id = #{id}
</update>

拒单

admin/order/rejection PUT

@PutMapping("/rejection")
@ApiOperation("拒单")
public Result rejection(@RequestBody OrdersRejectionDTO ordersRejectionDTO) throws Exception {orderService.rejection(ordersRejectionDTO);return Result.success();
}

void rejection(OrdersRejectionDTO ordersRejectionDTO) throws Exception;

@Override
public void rejection(OrdersRejectionDTO ordersRejectionDTO) throws Exception {//根据id查询订单Orders orderDB = orderMapper.getById(ordersRejectionDTO.getId());//订单只有存在且状态为2 待接单才可以拒单//处理业务异常if(orderDB == null || !orderDB.getStatus().equals(Orders.TO_BE_CONFIRMED)){throw new OrderBusinessException(MessageConstant.ORDER_STATUS_ERROR);}//支付状态Integer payStatus = orderDB.getPayStatus();if(payStatus == Orders.PAID){//用户已支付需要退款  伪造订单支付 跳过微信退款//String refund = weChatPayUtil.refund(//        orderDB.getNumber(),//        orderDB.getNumber(),//        new BigDecimal(0.01),//        new BigDecimal(0.01));Log.info("退款结果:{}",refund);//支付状态修改为 退款orderDB.setPayStatus(Orders.REFUND);}//管理端取消订单需要退款 根据订单id更新订单状态 取消原因 取消时间Orders orders = new Orders();orders.setId(orderDB.getId());orders.setStatus(Orders.CANCELLED);orders.setCancelReason(ordersRejectionDTO.getRejectionReason());orders.setCancelTime(LocalDateTime.now());orderMapper.update(orders);
}

取消订单

业务规则：

取消订单其实就是将订单状态修改为“已取消”
商家取消订单时需要指定取消原因
商家取消订单时，如果用户已经完成了支付，需要为用户退款

admin/order/cancel PUT

@PutMapping("/cancel")
@ApiOperation("取消订单")
public Result cancel(@RequestBody OrdersCancelDTO ordersCancelDTO) throws Exception{orderService.cancel(ordersCancelDTO);return Result.success();
}

void cancel(OrdersCancelDTO ordersCancelDTO) throws Exception;

public void cancel(OrdersCancelDTO ordersCancelDTO) throws Exception{//根据id查询订单Orders ordersDB = orderMapper.getById(ordersCancelDTO.getId());//支付状态Integer payStatus = ordersDB.getPayStatus();if (payStatus == 1) {//用户已支付，需要退款//String refund = weChatPayUtil.refund(//        ordersDB.getNumber(),//        ordersDB.getNumber(),//        new BigDecimal(0.01),//        new BigDecimal(0.01));//log.info("申请退款：{}", refund);ordersDB.setPayStatus(Orders.REFUND);}// 管理端取消订单需要退款，根据订单id更新订单状态、取消原因、取消时间Orders orders = new Orders();orders.setId(ordersCancelDTO.getId());orders.setStatus(Orders.CANCELLED);orders.setCancelReason(ordersCancelDTO.getCancelReason());orders.setCancelTime(LocalDateTime.now());orderMapper.update(orders);
}

派送订单

派送订单其实就是将订单状态修改为“派送中”
只有状态为“待派送”的订单可以执行派送订单操作

@PutMapping("/delivery/{id}")
@ApiOperation("派送订单")
public Result delivery(@PathVariable("id") Long id) {orderService.delivery(id);return Result.success();
}

 void delivery(Long id);

@Override
public void delivery(Long id) {// 根据id查询订单Orders ordersDB = orderMapper.getById(id);// 校验订单是否存在，并且状态为3if (ordersDB == null || !ordersDB.getStatus().equals(Orders.CONFIRMED)) {throw new OrderBusinessException(MessageConstant.ORDER_STATUS_ERROR);}Orders orders = new Orders();orders.setId(ordersDB.getId());// 更新订单状态,状态转为派送中orders.setStatus(Orders.DELIVERY_IN_PROGRESS);orderMapper.update(orders);
}

完成订单

@PutMapping("/complete/{id}")
@ApiOperation("完成订单")
public Result complete(@PathVariable("id") Long id) {orderService.complete(id);return Result.success();
}

void complete(Long id);

@Override
public void complete(Long id) {// 根据id查询订单Orders ordersDB = orderMapper.getById(id);// 校验订单是否存在，并且状态为4if (ordersDB == null || !ordersDB.getStatus().equals(Orders.DELIVERY_IN_PROGRESS)) {throw new OrderBusinessException(MessageConstant.ORDER_STATUS_ERROR);}Orders orders = new Orders();orders.setId(ordersDB.getId());// 更新订单状态,状态转为完成orders.setStatus(Orders.COMPLETED);orders.setDeliveryTime(LocalDateTime.now());orderMapper.update(orders);
}

校验收货地址是否超出配送范围

百度开放地图

登录百度地图开放平台：https://lbsyun.baidu.com/

进入控制台，创建应用，获取AK：

控制台 | 百度地图开放平台 (baidu.com)

配置application.yml

shop:
address: ${sky.shop.address}
baidu:
ak: ${sky.baidu.ak}

OrderServiceImpl，注入上面的配置项：

@Value("${sky.shop.address}")
private String shopAddress;@Value("${sky.baidu.ak}")
private String ak;

OrderServiceImpl.java

/*** 检查客户的收货地址是否超出配送范围* @param address*/
private void checkOutOfRange(String address) {Map map = new HashMap();map.put("address",shopAddress);map.put("output","json");map.put("ak",ak);//获取店铺的经纬度坐标String shopCoordinate = HttpClientUtil.doGet("https://api.map.baidu.com/geocoding/v3", map);JSONObject jsonObject = JSON.parseObject(shopCoordinate);if(!jsonObject.getString("status").equals("0")){throw new OrderBusinessException("店铺地址解析失败");}//数据解析JSONObject location = jsonObject.getJSONObject("result").getJSONObject("location");String lat = location.getString("lat");String lng = location.getString("lng");//店铺经纬度坐标String shopLngLat = lat + "," + lng;map.put("address",address);//获取用户收货地址的经纬度坐标String userCoordinate = HttpClientUtil.doGet("https://api.map.baidu.com/geocoding/v3", map);jsonObject = JSON.parseObject(userCoordinate);if(!jsonObject.getString("status").equals("0")){throw new OrderBusinessException("收货地址解析失败");}//数据解析location = jsonObject.getJSONObject("result").getJSONObject("location");lat = location.getString("lat");lng = location.getString("lng");//用户收货地址经纬度坐标String userLngLat = lat + "," + lng;map.put("origin",shopLngLat);map.put("destination",userLngLat);map.put("steps_info","0");//路线规划String json = HttpClientUtil.doGet("https://api.map.baidu.com/directionlite/v1/driving", map);jsonObject = JSON.parseObject(json);if(!jsonObject.getString("status").equals("0")){throw new OrderBusinessException("配送路线规划失败");}//数据解析JSONObject result = jsonObject.getJSONObject("result");JSONArray jsonArray = (JSONArray) result.get("routes");Integer distance = (Integer) ((JSONObject) jsonArray.get(0)).get("distance");if(distance > 5000){//配送距离超过5000米throw new OrderBusinessException("超出配送范围");}
}

//检查用户收获地址是否超出配送范围
checkOutOfRange(addressBook.getCityName() + addressBook.getDistrictName() + addressBook.getDetail());