/**
 * @author BNTang
 * @version S2.3.2Dev
 * @program video_parent
 * @date Created in 2021/4/11 12:50
 * @description 预览数据模型 VO
 **/
@Data
public class ContentPreviewVO {
    private String title;
    private String cover;
    private Integer contentNum;
    private String oneCategory;
    private String twoCategory;
    private String author;

    /**
     * 价格只用于显示所以为String
     */
    private String price;
}

/**
 * <b>
 * 获取作品的预览信息
 * </b>
 */
@ApiOperation(value = "获取作品的预览信息")
@GetMapping("/getContentPreView/{id}")
public ResponseResult getContentPreView(@PathVariable String id) {
    return ResponseResult.ok().data("item", contentService.getContentPreView(id));
}

/**
 * <b>
 * 获取作品的预览信息
 * </b>
 *
 * @param id 作品ID
 * @return 预览信息
 */
ContentPreviewVO getContentPreView(String id);

@Override
public ContentPreviewVO getContentPreView(String id) {
    return baseMapper.getContentPreviewVoById(id);
}

/**
 * <b>
 * 获取作品的预览信息
 * </b>
 *
 * @param id 作品ID
 * @return 预览信息
 */
ContentPreviewVO getContentPreviewVoById(String id);

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "http:///dtd/mybatis-3-mapper.dtd">
<mapper namespace="top.it6666.service_video.mapper.ContentMapper">
    <select id="getContentPreviewVoById" resultType="top.it6666.service_video.entity.vo.ContentPreviewVO">
        SELECT c.title,
               c.cover,
               c.content_num                   AS contentNum,
               CONVERT(c.price, DECIMAL(8, 2)) AS price,
               c1.title                        AS oneCategory,
               c2.title                        AS twoCategory,
                                         AS author
        FROM video_content c
                     LEFT JOIN video_author a ON c.author_id = a.id
                     LEFT JOIN video_category c1 ON c.category_parent_id = c1.id
                     LEFT JOIN video_category c2 ON c.category_id = c2.id
        WHERE c.id = #{id}
    </select>
</mapper>

mapper-locations: top/it6666/service_video/mapper/xml/*.xml

<resources>
    <resource>
        <directory>src/main/java</directory>
        <includes>
            <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
    </resource>
</resources>

/**
 * <b>
 * 发布作品
 * </b>
 */
@ApiOperation(value = "发布作品")
@PostMapping("/sendContent/{id}")
public ResponseResult sendContent(@PathVariable String id) {
    contentService.sendContentWithId(id);
    return ResponseResult.ok();
}

/**
 * <b>
 * 发布作品
 * </b>
 *
 * @param id 作品ID
 */
void sendContentWithId(String id);

@Override
public void sendContentWithId(String id) {
    Content content = new Content();
    content.setId(id);
    content.setStatus("Normal");
    baseMapper.updateById(content);
}

// 获取课程预览信息
getContentPreview(id) {
  return request({
    url: `/service_video/content/getContentPreView/${id}`,
    method: 'get'
  });
},
// 发布作品
sendContent(id) {
  return request({
    url: `/service_video/content/sendContent/${id}`,
    method: 'post'
  });
}

data() {
  return {
    // 所属作品
    contentId: '',
    // 预览信息实体
    contentSendObj: {}
  };
},

import content from "@/api/video/content/content";

created() {
  if (this.$route.params && this.$route.params.id) {
    this.contentId = this.$route.params.id;
    // 根据id获取作品基本信息
    this.getPreviewInfo();
  }
}

// 根据id获取作品基本信息
getPreviewInfo() {
  content.getContentPreview(this.contentId).then(res => {
    this.contentSendObj = res.data.item;
  }).catch(error => {
    this.$message.error(error.message);
  });
}

<div class="contentInfo">
  <img :src="contentSendObj.cover">
  <div class="main">
    <h2>{{ contentSendObj.title }}</h2>
    <p class="gray"><span>共{{ contentSendObj.contentNum }}总数</span></p>
    <p><span>所属分类：{{ contentSendObj.oneCategory }} — {{ contentSendObj.twoCategory }}</span></p>
    <p>作者：{{ contentSendObj.author }}</p>
    <h3 class="red">￥{{ contentSendObj.price }}</h3>
  </div>
</div>

<style scoped>
.contentInfo {
  background: #f5f5f5;
  padding: 20px;
  overflow: hidden;
  border: 1px dashed #DDD;
  margin-bottom: 40px;
  position: relative;
}

.contentInfo img {
  background: #d6d6d6;
  width: 500px;
  height: 278px;
  display: block;
  float: left;
  border: none;
}

.contentInfo .main {
  margin-left: 520px;
}

.contentInfo .main h2 {
  font-size: 28px;
  margin-bottom: 30px;
  line-height: 1;
  font-weight: normal;
}

.contentInfo .main p {
  margin-bottom: 10px;
  word-wrap: break-word;
  line-height: 24px;
  max-height: 48px;
  overflow: hidden;
}

.contentInfo .main p {
  margin-bottom: 10px;
  word-wrap: break-word;
  line-height: 24px;
  max-height: 48px;
  overflow: hidden;
}

.contentInfo .main h3 {
  left: 540px;
  bottom: 20px;
  line-height: 1;
  font-size: 28px;
  color: #d32f24;
  font-weight: normal;
  position: absolute;
}
</style>