package com.ycl.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.api.ApiController; import com.baomidou.mybatisplus.extension.api.R; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ycl.entity.NewsChannelColumn; import com.ycl.entity.NewsColumn; import com.ycl.service.NewsChannelColumnService; import com.ycl.service.NewsColumnService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.io.Serializable; import java.util.ArrayList; import java.util.List; /** * 频道栏目中间表(NewsChannelColumn)表控制层 * * @author makejava * @since 2022-11-17 11:38:27 */ @RestController @RequestMapping("newsChannelColumn") @Api(tags = "频道栏目中间表控制层") public class NewsChannelColumnController extends ApiController { /** * 服务对象 */ @Resource private NewsChannelColumnService newsChannelColumnService; @Autowired private NewsColumnService newsColumnService; /** * 分页查询所有数据 * * @param page 分页对象 * @param newsChannelColumn 查询实体 * @return 所有数据 */ @GetMapping @ApiOperation(value = "查询所有数据") public R selectAll(Page page, NewsChannelColumn newsChannelColumn) { return success(this.newsChannelColumnService.page(page, new QueryWrapper<>(newsChannelColumn))); } /** * 通过主键查询单条数据 * * @param id 主键 * @return 单条数据 */ @GetMapping("{id}") @ApiOperation(value = "按id查询数据") public R selectOne(@PathVariable Serializable id) { return success(this.newsChannelColumnService.getById(id)); } /** * 新增数据 * * @param newsChannelColumn 实体对象 * @return 新增结果 */ @PostMapping @ApiOperation(value = "新增数据") public R insert(@RequestBody NewsChannelColumn newsChannelColumn) { return success(this.newsChannelColumnService.save(newsChannelColumn)); } /** * 修改数据 * * @param newsChannelColumn 实体对象 * @return 修改结果 */ @PutMapping @ApiOperation(value = "修改数据") public R update(@RequestBody NewsChannelColumn newsChannelColumn) { return success(this.newsChannelColumnService.updateById(newsChannelColumn)); } /** * 删除数据 * * @param idList 主键结合 * @return 删除结果 */ @DeleteMapping @ApiOperation(value = "删除数据") public R delete(@RequestParam("idList") List idList) { return success(this.newsChannelColumnService.removeByIds(idList)); } /** * 通过频道id查对应栏目 * * @param id 频道id * @return 删除结果 */ @GetMapping("channel/{id}") @ApiOperation(value = "按频道id查询栏目") public R selectColumnByChannelId(@PathVariable Serializable id) { List newsChannelColumns = newsChannelColumnService.list(new QueryWrapper().eq("channel_id", id)); List resultList=new ArrayList<>(); for (NewsChannelColumn newsChannelColumn:newsChannelColumns){ resultList.add(newsColumnService.getById(newsChannelColumn.getColumnId())); } return success(resultList); } }