基于SpringBoot+Redis的前后端分离外卖项目-苍穹外卖微信小程序端(十)

àì夳堔傛蜴生んèń 2024-04-17 06:46 0阅读 0赞

#### 商品浏览功能代码 ####

*   *   *  1.1 需求分析和设计
         *   *  1.1.1 产品原型
             *  1.1.2 接口设计
         *  1.2代码开发
         *   *  1.2.1 Mapper层
             *  1.2.2 Service层
             *  1.2.3 Controller层
         *  1.3 功能测试

#### 1.1 需求分析和设计 ####

##### 1.1.1 产品原型 #####

用户登录成功后跳转到系统首页，在首页需要根据分类来展示菜品和套餐。如果菜品设置了口味信息，需要展示**选择规格**按钮，否则显示+按钮。

**菜品列表效果图** **菜品口味效果图**

![在这里插入图片描述][4777148374ea40cf9bcbbd1f347b685b.png]

##### 1.1.2 接口设计 #####

根据上述原型图先**粗粒度**设计接口，共包含4个接口。

**接口设计：**

*  查询分类
 *  根据分类id查询菜品
 *  根据分类id查询套餐
 *  根据套餐id查询包含的菜品

接下来**细粒度**分析每个接口，明确每个接口的请求方式、请求路径、传入参数和返回值。

**1). 查询分类**

![在这里插入图片描述][fcc7bbe652eb4fb388cd9cc7147857ae.png]  
![在这里插入图片描述][ddc40d76f8d14a40bb3c6d3c0247a780.png]

**2). 根据分类id查询菜品**

![在这里插入图片描述][b02bb017753e4e6581d999ec706946fb.png]  
![在这里插入图片描述][cb2960cab88c4ee182b6b4ee5fc0d800.png]

**3). 根据分类id查询套餐**

![在这里插入图片描述][530e6a5f681e49a999d6aebd071a4674.png]  
![在这里插入图片描述][aebd1e2625054ec897a3355d5404e05e.png]

**4). 根据套餐id查询包含的菜品**

![在这里插入图片描述][a75f1014349246f9b0ea9327eefdd95f.png]

#### 1.2代码开发 ####

##### 1.2.1 Mapper层 #####

**在SetmealMapper.java中添加list和getDishItemBySetmealId两个方法**

/**
         * 动态条件查询套餐
         * @param setmeal
         * @return
         */
        List<Setmeal> list(Setmeal setmeal);
    
        /**
         * 根据套餐id查询菜品选项
         * @param setmealId
         * @return
         */
        @Select("select sd.name, sd.copies, d.image, d.description " +
                "from setmeal_dish sd left join dish d on sd.dish_id = d.id " +
                "where sd.setmeal_id = #{setmealId}")
        List<DishItemVO> getDishItemBySetmealId(Long setmealId);

**创建SetmealMapper.xml文件**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.sky.mapper.SetmealMapper">
    
        <select id="list" parameterType="Setmeal" resultType="Setmeal">
            select * from setmeal
            <where>
                <if test="name != null">
                    and name like concat('%',#{name},'%')
                </if>
                <if test="categoryId != null">
                    and category_id = #{categoryId}
                </if>
                <if test="status != null">
                    and status = #{status}
                </if>
            </where>
        </select>
    </mapper>

##### 1.2.2 Service层 #####

**创建SetmealService.java**

package com.sky.service;
    public interface SetmealService {
        
    
        /**
         * 条件查询
         * @param setmeal
         * @return
         */
        List<Setmeal> list(Setmeal setmeal);
    
        /**
         * 根据id查询菜品选项
         * @param id
         * @return
         */
        List<DishItemVO> getDishItemById(Long id);
    
    }

**创建SetmealServiceImpl.java**

package com.sky.service.impl;
    /**
     * 套餐业务实现
     */
    @Service
    @Slf4j
    public class SetmealServiceImpl implements SetmealService {
        
    
        @Autowired
        private SetmealMapper setmealMapper;
        @Autowired
        private SetmealDishMapper setmealDishMapper;
        @Autowired
        private DishMapper dishMapper;
    
        /**
         * 条件查询
         * @param setmeal
         * @return
         */
        public List<Setmeal> list(Setmeal setmeal) {
        
            List<Setmeal> list = setmealMapper.list(setmeal);
            return list;
        }
    
        /**
         * 根据id查询菜品选项
         * @param id
         * @return
         */
        public List<DishItemVO> getDishItemById(Long id) {
        
            return setmealMapper.getDishItemBySetmealId(id);
        }
    }

**在DishService.java中添加listWithFlavor方法定义**

/**
         * 条件查询菜品和口味
         * @param dish
         * @return
         */
        List<DishVO> listWithFlavor(Dish dish);

**在DishServiceImpl.java中实现listWithFlavor方法**

/**
         * 条件查询菜品和口味
         * @param dish
         * @return
         */
        public List<DishVO> listWithFlavor(Dish dish) {
        
            List<Dish> dishList = dishMapper.list(dish);
    
            List<DishVO> dishVOList = new ArrayList<>();
    
            for (Dish d : dishList) {
        
                DishVO dishVO = new DishVO();
                BeanUtils.copyProperties(d,dishVO);
    
                //根据菜品id查询对应的口味
                List<DishFlavor> flavors = dishFlavorMapper.getByDishId(d.getId());
    
                dishVO.setFlavors(flavors);
                dishVOList.add(dishVO);
            }
    
            return dishVOList;
        }

##### 1.2.3 Controller层 #####

**创建DishController.java**

package com.sky.controller.user;
    
    @RestController("userDishController")
    @RequestMapping("/user/dish")
    @Slf4j
    @Api(tags = "C端-菜品浏览接口")
    public class DishController {
        
        @Autowired
        private DishService dishService;
    
        /**
         * 根据分类id查询菜品
         *
         * @param categoryId
         * @return
         */
        @GetMapping("/list")
        @ApiOperation("根据分类id查询菜品")
        public Result<List<DishVO>> list(Long categoryId) {
        
            Dish dish = new Dish();
            dish.setCategoryId(categoryId);
            dish.setStatus(StatusConstant.ENABLE);//查询起售中的菜品
    
            List<DishVO> list = dishService.listWithFlavor(dish);
    
            return Result.success(list);
        }
    
    }

**创建CategoryController.java**

package com.sky.controller.user;
    
    @RestController("userCategoryController")
    @RequestMapping("/user/category")
    @Api(tags = "C端-分类接口")
    public class CategoryController {
        
    
        @Autowired
        private CategoryService categoryService;
    
        /**
         * 查询分类
         * @param type
         * @return
         */
        @GetMapping("/list")
        @ApiOperation("查询分类")
        public Result<List<Category>> list(Integer type) {
        
            List<Category> list = categoryService.list(type);
            return Result.success(list);
        }
    }

**创建SetmealController.java**

package com.sky.controller.user;
    
    @RestController("userSetmealController")
    @RequestMapping("/user/setmeal")
    @Api(tags = "C端-套餐浏览接口")
    public class SetmealController {
        
        @Autowired
        private SetmealService setmealService;
    
        /**
         * 条件查询
         *
         * @param categoryId
         * @return
         */
        @GetMapping("/list")
        @ApiOperation("根据分类id查询套餐")
        public Result<List<Setmeal>> list(Long categoryId) {
        
            Setmeal setmeal = new Setmeal();
            setmeal.setCategoryId(categoryId);
            setmeal.setStatus(StatusConstant.ENABLE);
    
            List<Setmeal> list = setmealService.list(setmeal);
            return Result.success(list);
        }
    
        /**
         * 根据套餐id查询包含的菜品列表
         *
         * @param id
         * @return
         */
        @GetMapping("/dish/{id}")
        @ApiOperation("根据套餐id查询包含的菜品列表")
        public Result<List<DishItemVO>> dishList(@PathVariable("id") Long id) {
        
            List<DishItemVO> list = setmealService.getDishItemById(id);
            return Result.success(list);
        }
    }

#### 1.3 功能测试 ####

重启服务器、重新编译小程序

微信登录进入首页

**菜品和套餐分类查询：**

![在这里插入图片描述][b9d03a961a0948e3a13249684ef55bfb.png]

**具体分类下的菜品查询：**

![在这里插入图片描述][49b33bf9cf774a04a2ff4f03bd2c5267.png]

**菜品口味查询：**

![在这里插入图片描述][8787c24f57894eb6ad43978fe1d98a8b.png]

**后记  
👉👉💕💕美好的一天，到此结束，下次继续努力！欲知后续，请看下回分解，写作不易，感谢大家的支持！！ 🌹🌹🌹**

[4777148374ea40cf9bcbbd1f347b685b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/c3fac18220e74cae8fd645388f297c80.png
[fcc7bbe652eb4fb388cd9cc7147857ae.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/995066122c1d4768965b0fc894df2887.png
[ddc40d76f8d14a40bb3c6d3c0247a780.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/5eb09d0c797742ce9141dd11b8d7f5c0.png
[b02bb017753e4e6581d999ec706946fb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/99f45fef065c4e94931a11dab4434131.png
[cb2960cab88c4ee182b6b4ee5fc0d800.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/a264ab9ccc1f47fc95ca22cff84dda5e.png
[530e6a5f681e49a999d6aebd071a4674.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/221e14e5e0db46af94bd2dbadc3fcd66.png
[aebd1e2625054ec897a3355d5404e05e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/6f856140fb7b404b9696fedd934407cd.png
[a75f1014349246f9b0ea9327eefdd95f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/261cab5ddc354d29befacbe6918e3ce8.png
[b9d03a961a0948e3a13249684ef55bfb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/0e068e700e7b47af93f6e7261991bfd4.png
[49b33bf9cf774a04a2ff4f03bd2c5267.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/0fd18a21eee94e548604cbba66ac9c62.png
[8787c24f57894eb6ad43978fe1d98a8b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/c6e1befc24fa4d9b992b5f8111c8a663.png