苍穹外卖学习笔记(十四)

3. 根据分类ID查询套餐

SetmealController

package com.sky.controller.user;import com.sky.constant.StatusConstant;
import com.sky.entity.Setmeal;
import com.sky.result.Result;
import com.sky.service.SetmealService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;/*** @author Jie.* @description: TODO* @date 2024/9/25* @version: 1.0*/
@RestController("userSetmealController")
@RequestMapping("/user/setmeal")
@Api(tags = "套餐管理")
@Slf4j
public class SetmealController {@Autowiredprivate SetmealService setmealService;/** 根据分类id查询套餐*/@GetMapping("/list")@ApiOperation("套餐列表")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);}
}

Service

 /*** 查询套餐列表*/
List<Setmeal> list(Setmeal setmeal);

Impl

   /*** 查询套餐列表*/@Overridepublic List<Setmeal> list(Setmeal setmeal) {LambdaQueryWrapper<Setmeal> lambdaQueryWrapper = new LambdaQueryWrapper<>();lambdaQueryWrapper.eq(setmeal.getCategoryId() != null, Setmeal::getCategoryId, setmeal.getCategoryId());lambdaQueryWrapper.eq(setmeal.getStatus() != null, Setmeal::getStatus, setmeal.getStatus());return setmealMapper.selectList(lambdaQueryWrapper);}

4. 根据套餐ID查询菜品

controller

    /*** 根据套餐id查询包含的菜品*/@GetMapping("/dish/{id}")@ApiOperation("根据套餐id查询包含的菜品")public Result<List<DishItemVO>> dishList(@PathVariable Long id) {List<DishItemVO> list = setmealService.getDishItemById(id);return Result.success(list);}

service

/*** 根据套餐id查询包含的菜品*/List<DishItemVO> getDishItemById(Long id);

impl

    /*** 根据套餐id查询包含的菜品列表*/@Overridepublic List<DishItemVO> getDishItemById(Long id) {return setmealMapper.getDishItemBySetmealId(id);}

mapper

    /*** 根据id查询菜品选项*/@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 id);