瑞吉外卖项目完整篇（vue+springboot+redis+mybatis-plus）

package com.study.reggie.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.study.reggie.common.R; import com.study.reggie.dto.DishDto; import com.study.reggie.entity.Category; import com.study.reggie.entity.Dish; import com.study.reggie.entity.DishFlavor; import com.study.reggie.service.CategoryService; import com.study.reggie.service.DishFlavorService; import com.study.reggie.service.DishService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.web.bind.annotation.*; import java.util.List; import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; @RestController @Slf4j @RequestMapping("/dish") public class DishController { @Autowired private DishService dishService; @Autowired private DishFlavorService dishFlavorService; @Autowired private CategoryService categoryService; @Autowired private RedisTemplate redisTemplate; /** * 新增菜品功能 * @param dishDto * @return */ @PostMapping public R<String> save(@RequestBody DishDto dishDto){ dishService.saveWithFlavor(dishDto); //清理redis中所有的菜品数据 //String keys="dish_*"; //redisTemplate.delete(keys); //局部清理，只清理该分类下的菜品数据 String key="dish_"+dishDto.getCategoryId()+"_1"; redisTemplate.delete(key); return R.success("新增成功"); } /** * 分页查询展示菜品 * * 因为要查询分类名称，但dish表关联的是categoryId，所以经过两次sql执行。 * @param page * @param pageSize * @param name * @return */ @GetMapping("/page") public R<Page> page(int page,int pageSize,String name){ //创建分页构造器 Page<Dish> pageInfo=new Page<>(page,pageSize); Page<DishDto> dishDtoPage=new Page<>(); //创建条件构造器 LambdaQueryWrapper<Dish> queryWrapper=new LambdaQueryWrapper<>(); //模糊查询 queryWrapper.like(name!=null,Dish::getName,name); //排序 queryWrapper.orderByDesc(Dish::getUpdateTime); //执行菜品查询 dishService.page(pageInfo,queryWrapper); //对象拷贝 BeanUtils.copyProperties(pageInfo,dishDtoPage,"records"); // 菜品表的数据 List<Dish> records = pageInfo.getRecords(); //流拷贝records数据 List<DishDto> list=records.stream().map((item)->{ DishDto dishDto=new DishDto(); //每条数据拷贝到dishDto中 BeanUtils.copyProperties(item,dishDto); //1.要通过id查询出分类名称， Long categoryId = item.getCategoryId(); Category category = categoryService.getById(categoryId); //2.然后赋值给dishDto对象 String categoryName = category.getName(); dishDto.setCategoryName(categoryName); //返回 return dishDto; }).collect(Collectors.toList());//封装成list集合 //将封装好的list集合赋值给分页中records dishDtoPage.setRecords(list); //最后返回分页查询信息 return R.success(dishDtoPage); } /** * 根据id查询菜品信息和口味信息 * @param id * @return */ @GetMapping("/{id}") public R<DishDto> getByIdWithFlavor(@PathVariable Long id){ DishDto dishDto = dishService.getByIdWithFlavor(id); return R.success(dishDto); } /** * 新增菜品功能 * @param dishDto * @return */ @PutMapping public R<String> update(@RequestBody DishDto dishDto){ dishService.updateWithFlavor(dishDto); //清理redis中所有的菜品数据 //String keys="dish_*"; //redisTemplate.delete(keys); //局部清理，只清理该分类下的菜品数据 String key="dish_"+dishDto.getCategoryId()+"_1"; redisTemplate.delete(key); return R.success("修改成功"); } /** * 删除菜品、批量删除 * @param ids * @return */ @DeleteMapping() public R<String> delete(@RequestParam List<Long> ids){ dishService.removeWithFlavor(ids); return R.success("删除成功"); } /** * 批量起售、停售，单个起售、停售 * @param status * @param ids * @return */ @PostMapping("/status/{status}") public R<String> update(@PathVariable int status,@RequestParam List<Long> ids){ LambdaQueryWrapper<Dish> queryWrapper=new LambdaQueryWrapper<>(); queryWrapper.in(Dish::getId,ids); //将id在这里的数据查询出来 List<Dish> list = dishService.list(queryWrapper); //修改每一个状态位 for (Dish dish : list) { dish.setStatus(status); } //执行修改 dishService.updateBatchById(list); return R.success("修改成功"); } /** * 回显菜品分类数据 * @param dish * @return */ /*@GetMapping("/list") public R<List<Dish>> list(Dish dish){ LambdaQueryWrapper<Dish> queryWrapper=new LambdaQueryWrapper<>(); //查询该分类id下的菜品 queryWrapper.eq(dish.getCategoryId()!=null,Dish::getCategoryId,dish.getCategoryId()); //状态为1（起售状态）的菜品 queryWrapper.eq(Dish::getStatus,1); //排序显示 queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime); List<Dish> list = dishService.list(queryWrapper); return R.success(list); }*/ @GetMapping("/list") public R<List<DishDto>> list(Dish dish){ // 声明返回的结果 List<DishDto> dishDtoList=null; //拼接一个redis中存储的key String key="dish_"+dish.getCategoryId()+"_"+dish.getStatus(); dishDtoList = (List<DishDto>) redisTemplate.opsForValue().get(key); //存在值，则直接返回redis中的数据 if(dishDtoList !=null){ return R.success(dishDtoList); } LambdaQueryWrapper<Dish> queryWrapper=new LambdaQueryWrapper<>(); //查询该分类id下的菜品 queryWrapper.eq(dish.getCategoryId()!=null,Dish::getCategoryId,dish.getCategoryId()); //状态为1（起售状态）的菜品 queryWrapper.eq(Dish::getStatus,1); //排序显示 queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime); List<Dish> list = dishService.list(queryWrapper); //流拷贝records数据 dishDtoList=list.stream().map((item)->{ DishDto dishDto=new DishDto(); //每条数据拷贝到dishDto中 BeanUtils.copyProperties(item,dishDto); //1.要通过id查询出分类名称， Long categoryId = item.getCategoryId(); Category category = categoryService.getById(categoryId); //2.然后赋值给dishDto对象 String categoryName = category.getName(); dishDto.setCategoryName(categoryName); //3.获取菜品id Long dishId = item.getId(); //3-1 查询每个菜品的口味信息 LambdaQueryWrapper<DishFlavor> lambdaQueryWrapper=new LambdaQueryWrapper<>(); lambdaQueryWrapper.eq(DishFlavor::getDishId,dishId); List<DishFlavor> di