数据统计-Excel报表

工作台

今日数据接口

WorkSpaceController

java">@RestController
@RequestMapping("/admin/workspace")
@Slf4j
@Api(tags = "工作台")
public class WorkSpaceController {@Autowiredprivate WorkspaceService workspaceService;/*** 查询今日运营数据*/@GetMapping("/businessData")@ApiOperation(value = "查询今日运营数据")public Result<BusinessDataVO> businessData() {log.info("查询今日运营数据");//获得当天的开始时间LocalDateTime begin = LocalDateTime.now().with(LocalTime.MIN);//获得当天的结束时间LocalDateTime end = LocalDateTime.now().with(LocalTime.MAX);BusinessDataVO businessDataVO = workspaceService.getBusinessData(begin, end);return Result.success(businessDataVO);}
}

WorkspaceService

java">public interface WorkspaceService {/*** 查询今日运营数据*/BusinessDataVO getBusinessData(LocalDateTime begin, LocalDateTime end);
}

WorkspaceServiceImpl

java">@Service
@Slf4j
public class WorkspaceServiceImpl implements WorkspaceService {@Autowiredprivate OrderMapper orderMapper;@Autowiredprivate UserMapper userMapper;@Autowiredprivate DishMapper dishMapper;@Autowiredprivate SetmealMapper setmealMapper;/*** 查询今日运营数据*/@Overridepublic BusinessDataVO getBusinessData(LocalDateTime begin, LocalDateTime end) {/*** 营业额：当日已完成订单的总金额* 有效订单：当日已完成订单的数量* 订单完成率：有效订单数 / 总订单数* 平均客单价：营业额 / 有效订单数* 新增用户：当日新增用户的数量*/Map map = new HashMap();map.put("begin", begin);map.put("end", end);//查询总订单数Integer totalOrderCount = orderMapper.countByMap(map);map.put("status", Orders.COMPLETED);//营业额Double turnover = orderMapper.sumByMap(map);turnover = turnover == null ? 0.0 : turnover;//有效订单数Integer validOrderCount = orderMapper.countByMap(map);Double unitPrice = 0.0;Double orderCompletionRate = 0.0;if (totalOrderCount != 0 && validOrderCount != 0) {//订单完成率orderCompletionRate = validOrderCount.doubleValue() / totalOrderCount;//平均客单价unitPrice = turnover / validOrderCount;}//新增用户数Integer newUsers = userMapper.countByMap(map);return BusinessDataVO.builder().turnover(turnover).validOrderCount(validOrderCount).orderCompletionRate(orderCompletionRate).unitPrice(unitPrice).newUsers(newUsers).build();}
}

订单管理接口

WorkSpaceController

java">    /*** 查询订单管理数据*/@GetMapping("/overviewOrders")@ApiOperation(value = "查询订单管理数据")public Result<OrderOverViewVO> orderOverView() {log.info("查询订单概况");OrderOverViewVO orderOverViewVO = workspaceService.getOrderOverView();return Result.success(orderOverViewVO);}

WorkspaceService

java"> /*** 查询订单管理数据*/OrderOverViewVO getOrderOverView();

WorkspaceServiceImpl

java">/*** 查询订单管理数据*/@Overridepublic OrderOverViewVO getOrderOverView() {Map map = new HashMap();map.put("begin", LocalDateTime.now().with(LocalTime.MIN));map.put("status", Orders.TO_BE_CONFIRMED);//待接单Integer waitingOrders = orderMapper.countByMap(map);//待派送map.put("status", Orders.CONFIRMED);Integer deliveredOrders = orderMapper.countByMap(map);//已完成map.put("status", Orders.COMPLETED);Integer completedOrders = orderMapper.countByMap(map);//已取消map.put("status", Orders.CANCELLED);Integer cancelledOrders = orderMapper.countByMap(map);//全部订单map.put("status", null);Integer allOrders = orderMapper.countByMap(map);return OrderOverViewVO.builder().waitingOrders(waitingOrders).deliveredOrders(deliveredOrders).completedOrders(completedOrders).cancelledOrders(cancelledOrders).allOrders(allOrders).build();}

菜品总览接口

WorkSpaceController

java">    /*** 查询菜品总览*/@GetMapping("/overviewDishes")@ApiOperation("查询菜品总览")public Result<DishOverViewVO> dishOverView(){return Result.success(workspaceService.getDishOverView());}

WorkspaceService

java">    /*** 查询菜品管理数据*/DishOverViewVO getDishOverView();

WorkspaceServiceImpl

java">/*** 查询菜品总览*/@Overridepublic DishOverViewVO getDishOverView() {LambdaQueryWrapper<Dish> wrapper = new LambdaQueryWrapper<Dish>().eq(Dish::getStatus, StatusConstant.ENABLE);Long sold = dishMapper.selectCount(wrapper);Wrapper<Dish> wrapper1 = new LambdaQueryWrapper<Dish>().eq(Dish::getStatus, StatusConstant.DISABLE);Long discontinued = dishMapper.selectCount(wrapper1);return DishOverViewVO.builder().sold(sold.intValue()).discontinued(discontinued.intValue()).build();}

套餐总览接口

WorkSpaceController

java">    /*** 查询套餐总览*/@GetMapping("/overviewSetmeals")@ApiOperation("查询套餐总览")public Result<SetmealOverViewVO> setmealOverView(){return Result.success(workspaceService.getSetmealOverView());}

WorkspaceService

java">  /*** 查询套餐管理数据*/SetmealOverViewVO getSetmealOverView();

WorkspaceServiceImpl

java"> /*** 查询套餐总览*/@Overridepublic SetmealOverViewVO getSetmealOverView() {LambdaQueryWrapper<Setmeal> wrapper = new LambdaQueryWrapper<Setmeal>().eq(Setmeal::getStatus, StatusConstant.ENABLE);Long sold = setmealMapper.selectCount(wrapper);Wrapper<Setmeal> wrapper1 = new LambdaQueryWrapper<Setmeal>().eq(Setmeal::getStatus, StatusConstant.DISABLE);Long discontinued = setmealMapper.selectCount(wrapper1);return SetmealOverViewVO.builder().sold(sold.intValue()).discontinued(discontinued.intValue()).build();}