我的收藏后端实现

深碍√TFBOYSˉ_ 2021-07-24 20:40 439阅读 0赞

# 一 展示页面 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

# 二 判断是否收藏 #

## 1 web层 ##

@CrossOrigin
    @RestController
    @RequestMapping("/api/edu/course-collect")
    @Slf4j
    public class ApiCourseCollectController {
        @Autowired
        private CourseCollectService courseCollectService;
    
        @ApiOperation(value = "判断是否收藏")
        @GetMapping("auth/is-collect/{courseId}")
        public R isCollect(
                @ApiParam(name = "courseId", value = "课程id", required = true)
                @PathVariable String courseId,
                HttpServletRequest request) {
            JwtInfo jwtInfo = JwtUtils.getMemberIdByJwtToken(request);
            boolean isCollect = courseCollectService.isCollect(courseId, jwtInfo.getId());
            return R.ok().data("isCollect", isCollect);
        }
    }

## 2 Service层 ##

接口

boolean isCollect(String courseId, String memberId);

实现

/**
    * 判断用户是否收藏
    */
    @Override
    public boolean isCollect(String courseId, String memberId) {
        QueryWrapper<CourseCollect> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("course_id", courseId).eq("member_id", memberId);
        Integer count = baseMapper.selectCount(queryWrapper);
        return count > 0;
    }

# 三 收藏课程 #

## 1 web 层 ##

@ApiOperation(value = "收藏课程")
    @PostMapping("auth/save/{courseId}")
    public R save(
            @ApiParam(name = "courseId", value = "课程id", required = true)
            @PathVariable String courseId,
            HttpServletRequest request) {
        JwtInfo jwtInfo = JwtUtils.getMemberIdByJwtToken(request);
        courseCollectService.saveCourseCollect(courseId, jwtInfo.getId());
        return R.ok();
    }

## 2 service层 ##

接口

void saveCourseCollect(String courseId, String memberId);

实现

@Override
    public void saveCourseCollect(String courseId, String memberId) {
        // 未收藏则收藏
        if (!this.isCollect(courseId, memberId)) {
            CourseCollect courseCollect = new CourseCollect();
            courseCollect.setCourseId(courseId);
            courseCollect.setMemberId(memberId);
            this.save(courseCollect);
        }
    }

# 四 获取课程收藏列表 #

## 1 定义vo ##

@Data
    public class CourseCollectVo implements Serializable {
        private static final long serialVersionUID = 1L;
        private String id;
        private String courseId; // 课程id
        private String title; // 标题
        private BigDecimal price; // 价格
        private Integer lessonNum; // 课时数
        private String cover; // 封面
        private String gmtCreate; // 收藏时间
        private String teacherName; // 讲师
    }

## 2 web层 ##

@ApiOperation(value = "获取课程收藏列表")
    @GetMapping("auth/list")
    public R collectList(HttpServletRequest request) {
        JwtInfo jwtInfo = JwtUtils.getMemberIdByJwtToken(request);
        List<CourseCollectVo> list = courseCollectService.selectListByMemberId(jwtInfo.getId());
        return R.ok().data("items", list);
    }

## 3 service层 ##

接口

List<CourseCollectVo> selectListByMemberId(String memberId);

实现

@Override
    public List<CourseCollectVo> selectListByMemberId(String memberId) {
        return baseMapper.selectPageByMemberId(memberId);
    }

## 4 mapper层 ##

接口

List<CourseCollectVo> selectPageByMemberId(String memberId);

实现

<mapper namespace="com.atguigu.guli.service.edu.mapper.CourseCollectMapper">
        <select id="selectPageByMemberId" resultType="com.atguigu.guli.service.edu.entity.vo.CourseCollectVo">
            select
            cl.id,
            cl.gmt_create as gmtCreate,
            c.id as courseId,
            c.title,
            c.cover,
            CONVERT(c.price, DECIMAL(8,2)) AS price,
            c.lesson_num as lessonNum,
            t.name as teacherName
            from edu_course_collect cl
            left join edu_course c on c.id = cl.course_id
            left join edu_teacher t on t.id = c.teacher_id
            where member_id = #{memberId}
            order by cl.gmt_create desc
        </select>
    </mapper>

# 五 取消收藏 #

## 1 web层 ##

@ApiOperation(value = "取消收藏课程")
    @DeleteMapping("auth/remove/{courseId}")
    public R remove(
            @ApiParam(name = "courseId", value = "课程id", required = true)
            @PathVariable String courseId,
            HttpServletRequest request) {
        JwtInfo jwtInfo = JwtUtils.getMemberIdByJwtToken(request);
        boolean result = courseCollectService.removeCourseCollect(courseId, jwtInfo.getId());
        if (result) {
            return R.ok().message("已取消");
        } else {
            return R.error().message("取消失败");
        }
    }

## 2 service层 ##

接口

boolean removeCourseCollect(String courseId, String memberId);

实现

@Override
    public boolean removeCourseCollect(String courseId, String memberId) {
        // 已收藏则删除
        if (this.isCollect(courseId, memberId)) {
            QueryWrapper<CourseCollect> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("course_id", courseId).eq("member_id", memberId);
            return this.remove(queryWrapper);
        }
        return false;
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/61382bebf35348119995b77e35137efc.png