5 新增课程

5.1 需求分析

5.1.1 业务流程

5.1.2 数据模型

5.2 接口定义

5.3 接口开发

根据需求分析，新增课程表单中包括了课程基本信息、课程营销信息，需要分别向课程基本信息表、课程营销表保证数据。

5.3.1 保存课程基本信息

编写service接口实现类，实现向课程基本信息表保存数据

 @Overridepublic CourseBaseInfoDto creatCourseBase(Long companyID, AddCourseDto addCourseDto) {//参数的合法性校验//合法性校验if (StringUtils.isBlank(dto.getName())) {throw new RuntimeException("课程名称为空");}if (StringUtils.isBlank(dto.getMt())) {throw new RuntimeException("课程分类为空");}if (StringUtils.isBlank(dto.getSt())) {throw new RuntimeException("课程分类为空");}if (StringUtils.isBlank(dto.getGrade())) {throw new RuntimeException("课程等级为空");}if (StringUtils.isBlank(dto.getTeachmode())) {throw new RuntimeException("教育模式为空");}if (StringUtils.isBlank(dto.getUsers())) {throw new RuntimeException("适应人群为空");}if (StringUtils.isBlank(dto.getCharge())) {//向课程基本信息表course_base写入数据
//向课程基本信息表course_base写入数据CourseBase courseBaseNew = new CourseBase();//将传入的页面参数dto放到courseBaseNew这个对象中
//        courseBaseNew.setName(dto.getName());
//        courseBaseNew.setMt(dto.getMt());
//        ......//上边的从原始对象中get拿数据向新对象set,属性比较多，麻烦BeanUtils.copyProperties(dto,courseBaseNew); //将前者dto的属性值拷贝给courseBaseNew,拷贝属性名一致的courseBaseNew.setCompanyId(companyID); //不是dto传来的值courseBaseNew.setCreateDate(LocalDateTime.now()); //创建时间//审核状态默认为未提交courseBaseNew.setAuditStatus("202002"); //查看dictionary表未提交对应的码//发布状态为未发布courseBaseNew.setStatus("203001");  //同上//插入数据库int insert = courseBaseMapper.insert(courseBaseNew);if(insert<0){throw new RuntimeException("添加课程失败");}//向课程营销表course_market写入数据//--to doreturn null;}

5.3.2 保存营销信息

 @Overridepublic CourseBaseInfoDto creatCourseBase(Long companyID, AddCourseDto addCourseDto) {
//--------------
//向课程营销表保存课程营销信息//课程营销信息CourseMarket courseMarketNew = new CourseMarket();Long courseId = courseBaseNew.getId();BeanUtils.copyProperties(dto,courseMarketNew);courseMarketNew.setId(courseId);int i = saveCourseMarket(courseMarketNew); //保存课堂营销信息if(i<=0){throw new RuntimeException("保存课堂营销信息失败");}//查询课程基本信息及营销信息并返回return getCourseBaseInfo(courseId);}//保存课堂营销信息private int saveCourseMarket(CourseMarket courseMarketNew){//收费规则String charge = courseMarketNew.getCharge();if(StringUtils.isBlank(charge)){throw new RuntimeException("收费规则没有选择");}//收费规则为收费if(charge.equals("201001")){if(courseMarketNew.getPrice()==null || courseMarketNew.getPrice().floatValue()<=0){throw new RuntimeException("课程收费价格不能为空且必须大于0");}}//根据id从课堂营销查询CourseMarket courseMarketObj = courseMarketMapper.selectById(courseMarketNew.getId());if(courseMarketObj == null){return  courseMarketMapper.insert(courseMarketNew); //插入courseMarketNew的数据}else{BeanUtils.copyProperties(courseMarketNew,courseMarketObj);courseMarketObj.setId(courseMarketNew.getId());return courseMarketMapper.updateById(courseMarketObj);}}//根据课程id查询课程基本信息，包括基本信息和营销信息private CourseBaseInfoDto getCourseBaseInfo(Long courseId){CourseBaseInfoDto courseBaseInfoDto = new CourseBaseInfoDto();CourseBase courseBase = courseBaseMapper.selectById(courseId);if(courseBase == null){return null;}CourseMarket courseMarket = courseMarketMapper.selectById(courseId);BeanUtils.copyProperties(courseBase,courseBaseInfoDto);if(courseMarket !=null){BeanUtils.copyProperties(courseMarket,courseBaseInfoDto);}//查询分类名称并设置CourseCategory courseCategoryBySt = courseCategoryMapper.selectById(courseBase.getSt());courseBaseInfoDto.setStName(courseCategoryBySt.getName());CourseCategory courseCategoryByMt = courseCategoryMapper.selectById(courseBase.getMt());courseBaseInfoDto.setMtName(courseCategoryByMt.getName());return courseBaseInfoDto;}
}

5.4 接口测试

访问：http://localhost:63040/content/swagger-ui.html

或者xc-content-api.http添加下面的内容

### 新增课程
POST {{content_host}}/content/content/course
Content-Type: application/json{"charge": "201000","description": "冲冲冲","grade": "204001","mt": "1-1","name": "java网络编程高级","originalPrice": 0,"phone": "18888888","pic": "暂无","price": 0,"qq": "22333","st": "1-1-1","tags": "","teachmode": "200002","users": "初级人员","validDays": 365,"wechat": "223344"
}

2024-05-08T190437.200.json
{
“id”: 125,
“companyId”: 12345678,
“companyName”: null,
“name”: “java网络编程高级”,
“users”: “初级人员”,
“tags”: “”,
“mt”: “1-1”,
“st”: “1-1-1”,
“grade”: “204001”,
“teachmode”: “200002”,
“description”: “冲冲冲”,
“pic”: “暂无”,
“createDate”: “2024-05-08 19:04:37”,
“changeDate”: null,
“createPeople”: null,
“changePeople”: null,
“auditStatus”: “202002”,
“status”: “203001”,
“charge”: “201000”,
“price”: 0.0,
“originalPrice”: 0.0,
“qq”: “22333”,
“wechat”: “223344”,
“phone”: “18888888”,
“validDays”: 365,
“mtName”: “前端开发”,
“stName”: “HTML/CSS”
}

---