package com.zhongzheng.controller.course; import java.util.*; import java.util.stream.Collectors; import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.lang.Validator; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.zhongzheng.common.exception.CustomException; import com.zhongzheng.common.utils.ServletUtils; import com.zhongzheng.modules.course.bo.*; import com.zhongzheng.modules.course.service.ICourseService; import com.zhongzheng.modules.course.vo.CourseVo; import com.zhongzheng.modules.course.vo.GoodsBatchListVo; import com.zhongzheng.modules.goods.bo.GoodsBatchDelBo; import com.zhongzheng.modules.goods.vo.ExportLiveGoodsVo; import com.zhongzheng.modules.goods.vo.GoodsUserVo; import com.zhongzheng.modules.order.vo.OrderGoodsLiveExportVo; import com.zhongzheng.modules.order.vo.OrderGoodsVo; import com.zhongzheng.modules.user.domain.User; import com.zhongzheng.modules.user.entity.ClientLoginUser; import com.zhongzheng.modules.user.service.IUserService; import com.zhongzheng.modules.user.service.IUserStudyRecordService; import lombok.RequiredArgsConstructor; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.zhongzheng.common.annotation.Log; import com.zhongzheng.common.core.controller.BaseController; import com.zhongzheng.common.core.domain.AjaxResult; import com.zhongzheng.common.enums.BusinessType; import com.zhongzheng.common.utils.poi.ExcelUtil; import com.zhongzheng.common.core.page.TableDataInfo; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; /** * 课程Controller * * @author hjl * @date 2021-10-09 */ @Api(value = "课程控制器", tags = {"课程管理"}) @RequiredArgsConstructor(onConstructor_ = @Autowired) @RestController @RequestMapping("/course") public class CourseController extends BaseController { private final ICourseService iCourseService; private final IUserStudyRecordService iUserStudyRecordService; private final IUserService iUserService; /** * 查询课程列表 */ @ApiOperation("查询课程列表") @PreAuthorize("@ss.hasPermi('system:course:list')") @GetMapping("/list") public TableDataInfo list(CourseQueryBo bo) { startPage(); List list = iCourseService.selectList(bo); return getDataTable(list); } /** * 课程批量删除 */ @ApiOperation("课程批量删除") @PostMapping("/batch/del") public AjaxResult batchDelCourse(@RequestBody GoodsBatchDelBo bo) { return toAjax(iCourseService.batchDelCourse(bo) ? 1 : 0); } /** * 导出课程列表 */ /* @ApiOperation("导出课程列表") @PreAuthorize("@ss.hasPermi('system:course:export')") @Log(title = "课程", businessType = BusinessType.EXPORT) @GetMapping("/export") public AjaxResult export(CourseQueryBo bo) { List list = iCourseService.queryList(bo); ExcelUtil util = new ExcelUtil(CourseVo.class); return util.exportExcel(list, "课程"); }*/ /** * 获取课程详细信息 */ @ApiOperation("获取课程详细信息") @PreAuthorize("@ss.hasPermi('system:course:query')") @GetMapping("/{courseId}") public AjaxResult getInfo(@PathVariable("courseId" ) Long courseId) { return AjaxResult.success(iCourseService.selectById(courseId)); } /** * 新增课程 */ @ApiOperation("新增课程") @PreAuthorize("@ss.hasPermi('system:course:add')") @Log(title = "课程", businessType = BusinessType.INSERT) @PostMapping() public AjaxResult add(@RequestBody CourseAddBo bo) { return AjaxResult.success(iCourseService.insertByAddBo(bo)); } /** * 修改课程 */ @ApiOperation("修改课程") @PreAuthorize("@ss.hasPermi('system:course:edit')") @Log(title = "课程", businessType = BusinessType.UPDATE) @PostMapping("/edit") public AjaxResult edit(@RequestBody CourseEditBo bo) { return toAjax(iCourseService.updateByEditBo(bo) ? 1 : 0); } /** * 课程统计报表 */ @ApiOperation("课程统计报表") @GetMapping("/statement") public TableDataInfo getCourseStatement(CourseStatementBo bo) { startPage(); List list = iUserStudyRecordService.getCourseStatement(bo); return getDataTable(list); } /** * 课程统计报表导出 */ @ApiOperation("课程统计报表导出") @GetMapping("/statement/export") public AjaxResult exportCourseStatement(CourseStatementBo bo) { List list = iUserStudyRecordService.getCourseStatement(bo); if (CollectionUtils.isNotEmpty(list)){ list = list.stream().map(item -> CourseStatementVo.createExportVo(item)).collect(Collectors.toList()); } ExcelUtil util = new ExcelUtil<>(CourseStatementVo.class); return util.exportExcel(list,"课程学习统计"); } /** * 课程详情统计 */ @ApiOperation("课程详情统计") @GetMapping("/detail/statistics") public TableDataInfo getCourseDetailStatistics(CourseSectionDetailBo bo) { startPage(); List list = iUserStudyRecordService.getCourseDetailStatistics(bo); return getDataTable(list); } /** * 课程详情统计导出 */ @ApiOperation("课程详情统计导出") @GetMapping("/detail/statistics/export") public AjaxResult exportCourseDetailStatistics(CourseSectionDetailBo bo) { List list = iUserStudyRecordService.getCourseDetailStatistics(bo); if (CollectionUtils.isNotEmpty(list)){ list.forEach(item -> { item.setPurchaseStatusStr(ObjectUtils.isNotNull(item.getPurchaseStatus()) && item.getPurchaseStatus() == 1?"已开课":"未开课"); }); } ExcelUtil util = new ExcelUtil<>(CourseSectionDetailVo.class); return util.exportExcel(list,"课程学员学习统计"); } /** * 学员观看记录 */ @ApiOperation("学员观看记录") @GetMapping("/user/watch") public AjaxResult> getUserWatchStatistics(CourseSectionDetailBo bo) { List list = iUserStudyRecordService.getUserWatchStatistics(bo); return AjaxResult.success(list); } /** * 删除课程 */ /* @ApiOperation("删除课程") @PreAuthorize("@ss.hasPermi('system:course:remove')") @Log(title = "课程" , businessType = BusinessType.DELETE) @DeleteMapping("/{courseIds}") public AjaxResult remove(@PathVariable Long[] courseIds) { return toAjax(iCourseService.deleteWithValidByIds(Arrays.asList(courseIds), true) ? 1 : 0); }*/ /** * 查询课程列表 */ @ApiOperation("查询用户拥有的商品") @GetMapping("/goodsList") public TableDataInfo goodsList(CourseQueryBo bo) { User user = iUserService.getOne(new LambdaQueryWrapper() .eq(User::getTelphone, bo.getTelphone()).last("limit 1")); if(Validator.isEmpty(user)){ throw new CustomException("该用户不存在"); } startPage(); bo.setUserId(user.getUserId()); List list = iCourseService.goodsList(bo); return getDataTable(list); } @ApiOperation("批量查询用户拥有的商品进度") @GetMapping("/goodsBatchList") public AjaxResult> goodsBatchList(CourseQueryBo bo) { List listVos = new ArrayList<>(); if (CollectionUtils.isEmpty(bo.getTelphoneList())){ return null; } for(CourseProgressQueryBo queryBo : bo.getTelphoneList()){ User user = iUserService.getOne(new LambdaQueryWrapper() .eq(User::getTelphone, queryBo.getTelphone()).last("limit 1")); if(Validator.isEmpty(user)){ continue; } GoodsBatchListVo vo = new GoodsBatchListVo(); vo.setUserId(user.getUserId()); vo.setGoodsId(queryBo.getGoodsId()); vo.setTelphone(queryBo.getTelphone()); List list = iCourseService.goodsProgressList(bo); vo.setList(list); } if (CollectionUtils.isEmpty(listVos)){ return null; } return AjaxResult.success(listVos); } }