基于javaweb的校园外卖管理系统源码+数据库（95分以上大作业项目）.zip

package com.jld.reggie_take_out.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.jld.reggie_take_out.common.R; import com.jld.reggie_take_out.dto.DishDto; import com.jld.reggie_take_out.entity.Category; import com.jld.reggie_take_out.entity.Dish; import com.jld.reggie_take_out.entity.DishFlavor; import com.jld.reggie_take_out.service.CategoryService; import com.jld.reggie_take_out.service.DishFlavorService; import com.jld.reggie_take_out.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 @RequestMapping("/dish") @Slf4j 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) { log.info(dishDto.toString()); dishService.saveWithFlavor(dishDto); String key="dish_"+dishDto.getCategoryId()+"_"+dishDto.getStatus(); redisTemplate.delete(key); return R.success("新增菜品成功！"); } /** * 菜品信息分页查询 * * @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 -> dish.getName(), name); //添加排序条件 queryWrapper.orderByDesc(Dish::getUpdateTime); //进行分页查询 dishService.page(pageInfo, queryWrapper); //对象拷贝，将pageInfo中属性拷贝到dishDtoPage,忽略records属性 BeanUtils.copyProperties(pageInfo, dishDtoPage, "records"); List<Dish> records = pageInfo.getRecords(); List<DishDto> list = records.stream().map(item -> { DishDto dishDto = new DishDto(); BeanUtils.copyProperties(item, dishDto); Long categoryId = item.getCategoryId();//分类id //根据id查询分类对象 Category category = categoryService.getById(categoryId); if (category != null) { //获取菜品分类对象的名字 String categoryName = category.getName(); dishDto.setCategoryName(categoryName); } return dishDto; }).collect(Collectors.toList()); dishDtoPage.setRecords(list); return R.success(dishDtoPage); } /** * 根据id查询菜品信息和对应的口味信息 * * @param id * @return */ @GetMapping("/{id}") public R<DishDto> get(@PathVariable Long id) { DishDto dishDto = dishService.getByIdWithFlavor(id); return R.success(dishDto); } /** * 修改菜品 * * @param dishDto * @return */ @PutMapping public R<String> update(@RequestBody DishDto dishDto) { log.info(dishDto.toString()); dishService.updateWithFlavor(dishDto); //清理所有菜品的缓存数据 //Set keys = redisTemplate.keys("dish_*"); //redisTemplate.delete(keys); //精确清理，清理某个分类下面的菜品缓存数据 String key="dish_"+dishDto.getCategoryId()+"_"+dishDto.getStatus(); redisTemplate.delete(key); return R.success("修改菜品成功！"); } /** * 根据条件查询对应的菜品数据 * 菜品分类id * <p> * SELECT id,name,category_id,price,code,image,description,status,sort,create_time,update_time,create_user,update_user,is_deleted * FROM dish * WHERE (category_id = ? AND status = ?) ORDER BY sort ASC,update_time DESC * * @param dish * @return */ /* @GetMapping("/list") public R<List<Dish>> list(Dish dish) { //构造查询条件 LambdaQueryWrapper<Dish> queryWrapper = new LambdaQueryWrapper<>(); 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; //动态构造Key String key = "dish" + dish.getCategoryId() + "_" + dish.getStatus(); //先从Redis中获取菜品数据 dishDtoList = (List<DishDto>) redisTemplate.opsForValue().get(key); // 如果有则直接返回，无需查询数据库; if(dishDtoList!=null){ return R.success(dishDtoList); } //构造查询条件 LambdaQueryWrapper<Dish> lambdaQueryWrapper = new LambdaQueryWrapper<>(); //添加条件，查询状态为1的（起售状态） lambdaQueryWrapper.eq(Dish::getStatus, 1); lambdaQueryWrapper.eq(dish.getCategoryId() != null, Dish::getCategoryId, dish.getCategoryId()); //条件排序条件 lambdaQueryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime); List<Dish> list = dishService.list(lambdaQueryWrapper); dishDtoList = list.stream().map((item) -> { DishDto dishDto = new DishDto(); BeanUtils.copyProperties(item, dishDto); Long categoryId = item.getCategoryId(); //根据id查分类对象 Category category = categoryService.getById(categoryId); if (category != null) { String categoryName = category.getName(); dishDto.setCategoryName(categoryName); } //当前菜品id Long dishId = item.getId(); LambdaQueryWrapper<DishFlavor> queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(DishFlavor::getDishId, dishId); //SQL: select* from dishflavor where dish_id=?; List<DishFlavor> dishFlavorlist = dishFlavorService.list(queryWrapper); dishDto.setFlavors(dishFlavorlist); return dishDto; }).collect(Collectors.toList()); // 如果没有则查询数据库，并将查询到的菜品数据放入Redis。 redisTemplate.opsForValue().set(key,dishDtoList,60, TimeUnit.MINUTES); return R.success(dishDtoList); } /** * 停售、启售菜品 * * @param status * @param ids * @return */ @PostMapping("/status/{status}") public R<String> sale(@PathVariable int status, String[] ids) { for (String id : ids) { //通过id获取菜品对象 Dish dish = dishService.getById(id); dish.setStatus(status); dishService.updateById(dish); } return R.success("成功修改状态！"); } /** * 删除菜品 * * @param ids * @return */ @DeleteMapping public R<String> delete(String[] ids) { for (String id : ids) {