订单中判断课时是否购买前后端实现

男娘i 2021-07-24 12:48 382阅读 0赞

# 一 后端接口 #

判断数据库中是否存在已支付订单

## 1 Controller ##

ApiOrderController

/**
    * 功能描述：判断课程是否购买
    *
    * @param courseId 课时id
    * @param request http请求
    * @return R 返回给前端的数据
    * @author cakin
    * @date 2021/1/3
    */
    @ApiOperation("判断课程是否购买")
    @GetMapping("auth/is-buy/{courseId}")
    public R isBuyByCourseId(@PathVariable String courseId, HttpServletRequest request) {
        JwtInfo jwtInfo = JwtUtils.getMemberIdByJwtToken(request);
        Boolean isBuy = orderService.isBuyByCourseId(courseId, jwtInfo.getId());
        return R.ok().data("isBuy", isBuy);
    }

## 2 Service ##

接口

/**
    * 功能描述：判断课程是否购买
    *
    * @author cakin
    * @date 2021/1/3
    * @param courseId  课程Id
    * @param memberId 会员id
    * @return Boolean 课程是否购买
    */
    Boolean isBuyByCourseId(String courseId, String memberId);

实现

/**
    * 功能描述：判断课程是否购买
    *
    * @author cakin
    * @date 2021/1/3
    * @param courseId  课程Id
    * @param memberId 会员id
    * @return Boolean 课程是否购买
    */
    @Override
    public Boolean isBuyByCourseId(String courseId, String memberId) {
        QueryWrapper<Order> queryWrapper = new QueryWrapper<>();
        queryWrapper
                .eq("course_id", courseId)
                .eq("member_id", memberId)
                .eq("status", 1); // 1:代表已购买
        Integer count = baseMapper.selectCount(queryWrapper);
        return count.intValue() > 0;
    }

# 二 前端实现 #

## 1  api ##

isBuy(courseId) {
        return request({
          baseURL: 'http://localhost:8170',
          url: `/api/trade/order/auth/is-buy/${courseId}`,
          method: 'get'
        })
      },

## 2 课程页面 ##

data() {
        return {
          isBuy: false // 是否购买
        }
      },
    
      created() {
        // 如果未登录，则isBuy是默认值false
        // 如果已登录，则判断是否已购买
        const token = cookie.get('guli_jwt_token')
        if (token) {
          orderApi.isBuy(this.course.id).then(response => {
            this.isBuy = response.data.isBuy
          })
        }
      },

## 3 购买和观看按钮 ##

## 4 课时节点 ##

<li v-for="video in chapter.children" :key="video.id" class="lh-menu-second ml30">
                                    <a
                                      v-if="isBuy || course.price === 0"
                                      :href="'/player/'+video.videoSourceId"
                                      :title="video.title"
                                      target="_blank">
                                      <span v-if="Number(course.price) !== 0 && video.free===true" class="fr">
                                        <i class="free-icon vam mr10">免费试听</i>
                                      </span>
                                      <em class="lh-menu-i-2 icon16 mr5"> </em>{
       { video.title }}
                                    </a>
                                    <a
                                      v-else-if="video.free === true"
                                      :href="'/player/'+video.videoSourceId"
                                      :title="video.title"
                                      target="_blank">
                                      <span v-if="Number(course.price) !== 0 && video.free===true" class="fr">
                                        <i class="free-icon vam mr10">免费试听</i>
                                      </span>
                                      <em class="lh-menu-i-2 icon16 mr5"> </em>{
       { video.title }}
                                    </a>
                                    <a
                                      v-else
                                      :title="video.title">
                                      <span v-if="Number(course.price) !== 0 && video.free===true" class="fr">
                                        <i class="free-icon vam mr10">免费试听</i>
                                      </span>
                                      <em class="lh-menu-i-2 icon16 mr5"> </em>{
       { video.title }}
                                    </a>
                                  </li>

# 三 测试 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/6b9267395f164ae288d58bb035e2bec4.png