zc-saas-project/zhichen-admin/src/main/java/com/zhichen/controller/course/CourseController.java

package com.zhichen.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.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.zhichen.common.exception.CustomException;
import com.zhichen.common.type.EncryptHandler;
import com.zhichen.common.utils.ServletUtils;
import com.zhichen.common.utils.poi.EasyPoiUtil;
import com.zhichen.framework.web.service.WxTokenService;
import com.zhichen.modules.bank.vo.QuestionImageVo;
import com.zhichen.modules.course.bo.*;
import com.zhichen.modules.course.service.ICourseService;
import com.zhichen.modules.course.vo.CourseVo;
import com.zhichen.modules.course.vo.GoodsBatchListVo;
import com.zhichen.modules.goods.bo.GoodsBatchDelBo;
import com.zhichen.modules.goods.vo.ExportLiveGoodsVo;
import com.zhichen.modules.goods.vo.GoodsUserVo;
import com.zhichen.modules.order.vo.OrderGoodsLiveExportVo;
import com.zhichen.modules.order.vo.OrderGoodsVo;
import com.zhichen.modules.user.domain.User;
import com.zhichen.modules.user.entity.ClientLoginUser;
import com.zhichen.modules.user.service.IUserService;
import com.zhichen.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.zhichen.common.annotation.Log;
import com.zhichen.common.core.controller.BaseController;
import com.zhichen.common.core.domain.AjaxResult;
import com.zhichen.common.enums.BusinessType;
import com.zhichen.common.utils.poi.ExcelUtil;
import com.zhichen.common.core.page.TableDataInfo;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.multipart.MultipartFile;

/**
 * 课程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;
    private final WxTokenService wxTokenService;

    /**
     * 查询课程列表
     */
    @ApiOperation("查询课程列表")
    @PreAuthorize("@ss.hasPermi('system:course:list')")
    @GetMapping("/list")
    public TableDataInfo<CourseVo> list(CourseQueryBo bo) {
        startPage();
        List<CourseVo> list = iCourseService.selectList(bo);
        return getDataTable(list);
    }

    /**
     * 课程批量删除
     */
    @ApiOperation("课程批量删除")
    @PostMapping("/batch/del")
    public AjaxResult<Void> 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<CourseVo> export(CourseQueryBo bo) {
        List<CourseVo> list = iCourseService.queryList(bo);
        ExcelUtil<CourseVo> util = new ExcelUtil<CourseVo>(CourseVo.class);
        return util.exportExcel(list, "课程");
    }*/

    /**
     * 获取课程详细信息
     */
    @ApiOperation("获取课程详细信息")
    @PreAuthorize("@ss.hasPermi('system:course:query')")
    @GetMapping("/{courseId}")
    public AjaxResult<CourseVo> 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<Long> 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<Void> edit(@RequestBody CourseEditBo bo) {
        return toAjax(iCourseService.updateByEditBo(bo) ? 1 : 0);
    }

    /**
     * 课程统计报表
     */
    @ApiOperation("课程统计报表")
    @GetMapping("/statement")
    public TableDataInfo<CourseStatementVo> getCourseStatement(CourseStatementBo bo) {
        startPage();
        List<CourseStatementVo> list = iUserStudyRecordService.getCourseStatement(bo);
        return getDataTable(list);
    }

    /**
     * 课程统计报表导出
     */
    @ApiOperation("课程统计报表导出")
    @GetMapping("/statement/export")
    public AjaxResult<CourseStatementVo> exportCourseStatement(CourseStatementBo bo) {
        List<CourseStatementVo> list = iUserStudyRecordService.getCourseStatement(bo);
        if (CollectionUtils.isNotEmpty(list)){
            list = list.stream().map(item -> CourseStatementVo.createExportVo(item)).collect(Collectors.toList());
        }
        ExcelUtil<CourseStatementVo> util = new ExcelUtil<>(CourseStatementVo.class);
        return util.exportExcel(list,"课程学习统计");
    }

    /**
     * 课程详情统计
     */
    @ApiOperation("课程详情统计")
    @GetMapping("/detail/statistics")
    public TableDataInfo<CourseSectionDetailVo> getCourseDetailStatistics(CourseSectionDetailBo bo) {
        startPage();
        List<CourseSectionDetailVo> list = iUserStudyRecordService.getCourseDetailStatistics(bo);
        return getDataTable(list);
    }

    /**
     * 课程详情统计导出
     */
    @ApiOperation("课程详情统计导出")
    @GetMapping("/detail/statistics/export")
    public AjaxResult<CourseSectionDetailVo> exportCourseDetailStatistics(CourseSectionDetailBo bo) {
        List<CourseSectionDetailVo> list = iUserStudyRecordService.getCourseDetailStatistics(bo);
        if (CollectionUtils.isNotEmpty(list)){
            list.forEach(item -> {
                item.setPurchaseStatusStr(ObjectUtils.isNotNull(item.getPurchaseStatus()) && item.getPurchaseStatus() == 1?"已开课":"未开课");
            });
        }
        ExcelUtil<CourseSectionDetailVo> util = new ExcelUtil<>(CourseSectionDetailVo.class);
        return util.exportExcel(list,"课程学员学习统计");
    }

    /**
     * 学员观看记录
     */
    @ApiOperation("学员观看记录")
    @GetMapping("/user/watch")
    public AjaxResult<List<UserWatchStatisticsVo>> getUserWatchStatistics(CourseSectionDetailBo bo) {
        List<UserWatchStatisticsVo> list = iUserStudyRecordService.getUserWatchStatistics(bo);
        return AjaxResult.success(list);
    }

    /**
     * 删除课程
     */
   /* @ApiOperation("删除课程")
    @PreAuthorize("@ss.hasPermi('system:course:remove')")
    @Log(title = "课程" , businessType = BusinessType.DELETE)
    @DeleteMapping("/{courseIds}")
    public AjaxResult<Void> remove(@PathVariable Long[] courseIds) {
        return toAjax(iCourseService.deleteWithValidByIds(Arrays.asList(courseIds), true) ? 1 : 0);
    }*/

    /**
     * 查询课程列表
     */
    @ApiOperation("查询用户拥有的商品")
    @GetMapping("/goodsList")
    public TableDataInfo<GoodsUserVo> goodsList(CourseQueryBo bo) {
        User user = iUserService.getOne(new LambdaQueryWrapper<User>()
                .eq(User::getTelphone, EncryptHandler.encrypt(bo.getTelphone())).last("limit 1"));
        if(Validator.isEmpty(user)){
            throw new CustomException("该用户不存在");
        }
        startPage();
        bo.setUserId(user.getUserId());
        List<GoodsUserVo> list = iCourseService.goodsList(bo);
        return getDataTable(list);
    }

    @ApiOperation("旧系统查询用户学习进度列表")
    @GetMapping("/goodsStudyProgress")
    public TableDataInfo<GoodsUserVo> goodsStudyProgressList(CourseQueryBo bo) {
        startPage();
        List<GoodsUserVo> list = iCourseService.goodsStudyProgressList(bo);
        return getDataTable(list);
    }

    @ApiOperation("批量查询用户拥有的商品进度")
    @PostMapping("/goodsBatchList")
    public AjaxResult<List<GoodsBatchListVo>> goodsBatchList(@RequestBody CourseQueryBo bo) {
        List<GoodsBatchListVo> listVos = new ArrayList<>();
        if (CollectionUtils.isEmpty(bo.getTelphoneList())){
            return  AjaxResult.success(listVos);
        }
        for(CourseProgressQueryBo queryBo : bo.getTelphoneList()){
            User user = null;
            if (ObjectUtils.isNotNull(queryBo.getIdCard())){
                user = iUserService.getOne(new LambdaQueryWrapper<User>()
                        .eq(User::getIdCard,EncryptHandler.encrypt(queryBo.getIdCard()))
                        .last("limit 1"));
            }else if (ObjectUtils.isNotNull(queryBo.getTelphone())){
                user = iUserService.getOne(new LambdaQueryWrapper<User>()
                        .eq(User::getTelphone,EncryptHandler.encrypt(queryBo.getTelphone()))
                        .last("limit 1"));
            }
            if(Validator.isEmpty(user)){
                continue;
            }
            bo.setUserId(user.getUserId());
            bo.setGoodsId(queryBo.getGoodsId());
            List<GoodsUserVo> list = iCourseService.goodsProgressList(bo);
            if (CollectionUtils.isNotEmpty(list)){
                GoodsBatchListVo vo = new GoodsBatchListVo();
                vo.setUserId(user.getUserId());
                vo.setGoodsId(queryBo.getGoodsId());
                vo.setTelphone(queryBo.getTelphone());
                vo.setIdCard(queryBo.getIdCard());
                if (StringUtils.isNotBlank(user.getPasswordAes())){
                    vo.setPasswordAes(EncryptHandler.decrypt(user.getPasswordAes()));
                }
                vo.setList(list);
                listVos.add(vo);
            }
        }
        if (CollectionUtils.isEmpty(listVos)){
            return AjaxResult.success(listVos);
        }
        return AjaxResult.success(listVos);
    }


    @ApiOperation("二建视频导入")
    @PostMapping("/importEJ")
    public AjaxResult<Map<String,Object>> importEJ(MultipartFile file,String param) throws Exception
    {
        List<CourseEJVo> questionList2 = EasyPoiUtil.importExcel(file,0,1,CourseEJVo.class);
        Map<String,Object> result = iCourseService.importEJ(questionList2,param);
        return AjaxResult.success(result);
    }

    @ApiOperation("七大员视频导入")
    @PostMapping("/importQDY")
    public AjaxResult<Map<String,Object>> importQDY(MultipartFile file,String param) throws Exception
    {
        List<CourseEJVo> questionList2 = EasyPoiUtil.importExcel(file,0,1,CourseEJVo.class);
        Map<String,Object> result = iCourseService.importQDY(questionList2,param);
        return AjaxResult.success(result);
    }

}