package com.dsh.course.controller; import cn.mb.cloud.common.data.controller.BaseController; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.dsh.course.entity.*; import com.dsh.course.feignclient.model.ExerciseVideo; import com.dsh.course.model.*; import com.dsh.course.model.dto.CourseChangeStateDTO; import com.dsh.course.model.dto.TQueryBenefitsVideosDTO; import com.dsh.course.model.vo.TQueryBenefitsVideosVO; import com.dsh.course.service.*; import com.dsh.course.util.*; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.PrintWriter; import java.math.BigDecimal; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; @Api @CrossOrigin @RestController @RequestMapping("") public class CourseController extends BaseController { private Logger logger = LoggerFactory.getLogger("business-log"); @Autowired private TCourseService courseService; @Autowired private TCoursePackageService coursePackageService; @Autowired private TokenUtil tokenUtil; @Autowired private TCoursePackageTypeService coursePackageTypeService; @Autowired private PayMoneyUtil payMoneyUtil; @Autowired private TCoursePackagePaymentService coursePackagePaymentService; @Autowired private TCoursePackageDiscountService discountService; /** * 上/下架 1为上架 2为下架 3为删除 * * @return */ @RequestMapping("/base/course/changeState") @ResponseBody public Object changeState(@RequestBody CourseChangeStateDTO dto){ return courseService.changeState(dto); } /** * 通过课程ids获取课程 * @return */ @RequestMapping("/base/course/getCourseByCourseIds") public List getCourseByCourseIds(@RequestBody TQueryBenefitsVideosDTO query){ return courseService.getCourseByCourseIds(query); } @PostMapping("/base/course/queryList") public List queryStuCourseAfterVideos(@RequestBody List courseIds){ List videos = new ArrayList<>(); List list = courseService.list(new QueryWrapper() .in("id", courseIds) .eq("state",1)); if (list.size() > 0){ list.forEach( vs ->{ ExerciseVideo video = new ExerciseVideo(); video.setVideoUrl(vs.getCourseVideo()); video.setVideoName(vs.getName()); video.setVideoCoverImgUrl(vs.getCoverDrawing()); videos.add(video); }); } return videos; } @ResponseBody @PostMapping("/api/course/queryCoursePackageType") @ApiOperation(value = "获取课程类型列表", tags = {"APP-课程列表"}) @ApiImplicitParams({ }) public ResultUtil> queryCoursePackageType(){ try { List coursePackageTypes = coursePackageTypeService.list(new QueryWrapper().eq("state", 1)); List list = new ArrayList<>(); coursePackageTypes.forEach(c -> { BaseVo baseVo = new BaseVo(); BeanUtils.copyProperties(c, baseVo); list.add(baseVo); }); return ResultUtil.success(list); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } @ResponseBody @PostMapping("/api/course/queryCourseList") @ApiOperation(value = "获取课程列表", tags = {"APP-课程列表"}) @ApiImplicitParams({ @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....") }) public ResultUtil> queryCourseList(CoursePackageList coursePackageList){ try { Integer uid = tokenUtil.getUserIdFormRedis(); if(null == uid){ return ResultUtil.tokenErr(); } List coursePackageListVos = coursePackageService.queryCourseList(uid, coursePackageList); return ResultUtil.success(coursePackageListVos); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } @ResponseBody @PostMapping("/base/course/queryCourseListOne") @ApiOperation(value = "获取课程列表", tags = {"APP-课程列表"}) @ApiImplicitParams({ @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....") }) public ResultUtil> queryCourseListOne(CoursePackageList coursePackageList){ try { List coursePackageListVos = coursePackageService.queryCourseListOne( coursePackageList); return ResultUtil.success(coursePackageListVos); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } @ResponseBody @PostMapping("/api/course/queryCourseInfo") @ApiOperation(value = "获取课程详情", tags = {"APP-课程列表"}) @ApiImplicitParams({ @ApiImplicitParam(value = "课包id", name = "id", dataType = "int", required = true), @ApiImplicitParam(value = "经度", name = "lon", dataType = "string", required = false), @ApiImplicitParam(value = "纬度", name = "lat", dataType = "string", required = false), @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....") }) public ResultUtil queryCourseInfo(Integer id, String lon, String lat){ try { Integer uid = tokenUtil.getUserIdFormRedis(); if(null == uid){ return ResultUtil.tokenErr(); } CoursePackageInfo coursePackageInfo = coursePackageService.queryCourseInfo(uid, id, lon, lat); return ResultUtil.success(coursePackageInfo); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } @ResponseBody @PostMapping("/api/course/paymentCourse") @ApiOperation(value = "支付课程", tags = {"APP-课程列表"}) @ApiImplicitParams({ @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....") }) public ResultUtil paymentCourse(PaymentCourseVo paymentCourseVo){ try { Integer uid = tokenUtil.getUserIdFormRedis(); if(null == uid){ return ResultUtil.tokenErr(); } Long couponId = paymentCourseVo.getCouponId(); if(couponId==null || couponId==0){ paymentCourseVo.setCouponId(null); } return coursePackageService.paymentCourse(uid, paymentCourseVo); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } // 2.0 @ResponseBody @PostMapping("/api/course/paymentCourseCouponList") @ApiOperation(value = "支付课程--完成后优惠券列表", tags = {"APP-课程列表"}) @ApiImplicitParams({ @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....") }) public ResultUtil paymentCourseCouponList(Integer coursePackagePaymentConfigId){ try { Integer uid = tokenUtil.getUserIdFormRedis(); if(null == uid){ return ResultUtil.tokenErr(); } return coursePackageService.paymentCourseCouponList(uid, coursePackagePaymentConfigId); }catch (Exception e){ e.printStackTrace(); return ResultUtil.runErr(); } } /** * 购买课程微信支付回调 * @param request * @param response */ @ResponseBody @PostMapping("/base/course/weChatPaymentCourseCallback") public void weChatPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response){ try { Map map = payMoneyUtil.weixinpayCallback(request); if(null != map){ String code = map.get("out_trade_no"); String transaction_id = map.get("transaction_id"); String result = map.get("result"); List list = coursePackagePaymentService.list(new QueryWrapper().eq("state", 1).eq("code", code).eq("payType", 1)); TCoursePackagePayment one = list.get(0); if(one.getPayStatus() == 1){ for (TCoursePackagePayment coursePackagePayment : list) { coursePackagePayment.setPayStatus(2); coursePackagePayment.setOrderNumber(transaction_id); } coursePackagePaymentService.updateBatchById(list); } PrintWriter out = response.getWriter(); out.write(result); out.flush(); out.close(); } }catch (Exception e){ e.printStackTrace(); } } /** * 购买课程支付宝回调 * @param request * @param response */ @ResponseBody @PostMapping("/base/course/aliPaymentCourseCallback") public void aliPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response){ try { Map map = payMoneyUtil.alipayCallback(request); if(null != map){ String code = map.get("out_trade_no"); String trade_no = map.get("trade_no"); List list = coursePackagePaymentService.list(new QueryWrapper().eq("state", 1).eq("code", code).eq("payType", 2)); TCoursePackagePayment one = list.get(0); if(one.getPayStatus() == 1){ for (TCoursePackagePayment coursePackagePayment : list) { coursePackagePayment.setPayStatus(2); coursePackagePayment.setOrderNumber(trade_no); } coursePackagePaymentService.updateBatchById(list); } PrintWriter out = response.getWriter(); out.write("success"); out.flush(); out.close(); } }catch (Exception e){ e.printStackTrace(); } } /** * 根据id获取课程数据 * @param id * @return */ @ResponseBody @PostMapping("/course/queryCourseById") public TCourse queryCourseById(@RequestBody Integer id){ try { return courseService.getById(id); }catch (Exception e){ e.printStackTrace(); return null; } } /** * 根据名称获取数据 * @param name * @return */ @ResponseBody @PostMapping("/course/queryCourseByName") public List queryCourseByName(@RequestBody String name){ try { return courseService.list(new QueryWrapper().like("name", name).eq("state", 1)); }catch (Exception e){ e.printStackTrace(); return null; } } @PostMapping("/course/getPageageType") public List> getPageageType(){ List list = coursePackageTypeService.list(new LambdaQueryWrapper().eq(TCoursePackageType::getState, 1)); ArrayList> objects = new ArrayList<>(); for (TCoursePackageType tCoursePackageType : list) { HashMap map = new HashMap<>(); map.put("id",tCoursePackageType.getId()); map.put("name",tCoursePackageType.getName()); objects.add(map); } return objects; } /** * 获取课程管理列表数据 * @param queryCourseList * @return */ @ResponseBody @PostMapping("/course/queryCourseLists") public Page> queryCourseLists(@RequestBody QueryCourseList queryCourseList){ Page> page = new PageFactory>().defaultPage(queryCourseList.getLimit(), queryCourseList.getOffset(), queryCourseList.getSort(), queryCourseList.getOrder()); Page> mapPage = page.setRecords(courseService.queryCourseList(page, queryCourseList)); return mapPage; } /** * 添加课程 * @param course */ @ResponseBody @PostMapping("/course/addCourse") public void addCourse(@RequestBody TCourse course){ courseService.save(course); } /** * 编辑数据 * @param course */ @ResponseBody @PostMapping("/course/editCourse") public void editCourse(@RequestBody TCourse course){ courseService.updateById(course); } /** * 删除数据 * @param id */ @ResponseBody @PostMapping("/course/delCourseById") public void delCourseById(@RequestBody Integer id){ TCourse course = courseService.getById(id); if(null != course){ course.setState(3); courseService.updateById(course); } } /** * 编辑数据状态 * @param editCourseState */ @ResponseBody @PostMapping("/course/editCourseState") public void editCourseState(@RequestBody EditCourseState editCourseState){ TCourse course = courseService.getById(editCourseState.getId()); if(null != course){ course.setState(editCourseState.getState()); courseService.updateById(course); } } /** * 根据类型获取数据 * @param type * @return */ @ResponseBody @PostMapping("/course/queryCourseByType") public List queryCourseByType(@RequestBody Integer type){ return courseService.list(new QueryWrapper().eq("type", type).eq("state", 1)); } @PostMapping("/course/queryPackageById") public List queryPackageById(@RequestBody Integer coursePackageId){ ArrayList strings = new ArrayList<>(); TCoursePackage byId = coursePackageService.getById(coursePackageId); Integer coursePackageTypeId = byId.getCoursePackageTypeId(); strings.add(coursePackageTypeService.getById(coursePackageTypeId).getName()); strings.add(byId.getName()); return strings; } @PostMapping("/course/getHours") public String getHours(@RequestBody Integer coursePackageId1){ return coursePackageService.getHours(coursePackageId1); } @PostMapping("/course/queryByDiscountId") public TCoursePackage queryByDiscountId(@RequestBody Integer id){ TCoursePackageDiscount byId = discountService.getById(id); TCoursePackage byId1 = coursePackageService.getById(byId.getCoursePackageId()); return byId1; } @ResponseBody @PostMapping("/course/queryByDiscountId1") public TCoursePackage queryByDiscountId1(@RequestBody Integer id){ TCoursePackageDiscount byId = discountService.getById(id); TCoursePackage byId1 = coursePackageService.getById(byId.getCoursePackageId()); return byId1; } @PostMapping("/course/queryDiscountById") public Integer queryDiscountById(@RequestBody Integer id){ TCoursePackageDiscount byId = discountService.getById(id); return byId.getAuditStatus(); } @PostMapping("/course/queryDiscountList") public List queryDiscountList(@RequestBody QueryDiscountList queryDiscountList){ return discountService.queryDiscountList(queryDiscountList); } @PostMapping("/course/queryDiscountListAudit") public List queryDiscountListAudit(@RequestBody QueryDiscountList queryDiscountList){ return discountService.queryDiscountListAudit(queryDiscountList); } @PostMapping("/course/updateState") public Boolean updateState( @RequestBody DiscountUpdateState discountUpdateState){ TCoursePackageDiscount byId = discountService.getById(discountUpdateState.getId()); List list = discountService.list(new LambdaQueryWrapper().eq(TCoursePackageDiscount::getCoursePackageId, byId.getCoursePackageId())); list.forEach(e->e.setStatus(discountUpdateState.getStatus())); return discountService.updateBatchById(list); } @PostMapping("/course/auditDiscount") public Boolean auditDiscount( @RequestBody AuditDiscount auditDiscount){ TCoursePackageDiscount byId = discountService.getById(auditDiscount.getId()); List list = discountService.list(new LambdaQueryWrapper().eq(TCoursePackageDiscount::getCoursePackageId, byId.getCoursePackageId())); for (TCoursePackageDiscount tCoursePackageDiscount : list) { tCoursePackageDiscount.setAuditStatus(auditDiscount.getType()); tCoursePackageDiscount.setAuditRemark(auditDiscount.getText()); } return discountService.updateBatchById(list); } @PostMapping("/course/queryFee") public HashMap queryFee(@RequestBody QueryDataFee queryDataFee){ HashMap map = new HashMap<>(); String data = queryDataFee.getData(); List ids = queryDataFee.getIds(); if(ids.size()==0){ ids.add(-1); } LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if(ToolUtil.isNotEmpty(data)){ String stime = data.split(" - ")[0]+" 00:00:00"; String etime = data.split(" - ")[1]+" 23:59:59"; wrapper.between(TCoursePackagePayment::getInsertTime,stime,etime); } wrapper.in(TCoursePackagePayment::getAppUserId,ids); wrapper.eq(TCoursePackagePayment::getPayStatus,2); ArrayList objects = new ArrayList<>(); objects.add(1); objects.add(2); objects.add(5); objects.add(6); wrapper.in(TCoursePackagePayment::getPayType,objects); List list = coursePackagePaymentService.list(wrapper); double v = list.stream().map(TCoursePackagePayment::getCashPayment).reduce(BigDecimal.ZERO, BigDecimal::add).doubleValue(); List collect = list.stream().map(TCoursePackagePayment::getCoursePackageId).collect(Collectors.toList()); if(collect.size()==0){ collect.add(-1); } // List list2 = coursePackageService.list(new LambdaQueryWrapper().in(TCoursePackage::getId, collect)); // 课类型 List list1 = coursePackageTypeService.list(); for (TCoursePackagePayment tCoursePackagePayment : list) { for (TCoursePackage tCoursePackage : list2) { if(tCoursePackagePayment.getCoursePackageId().equals(tCoursePackage.getId())){ tCoursePackagePayment.setType(tCoursePackage.getCoursePackageTypeId()); } } } ArrayList> hashMaps = new ArrayList<>(); for (TCoursePackageType tCoursePackageType : list1) { HashMap objectObjectHashMap = new HashMap<>(); objectObjectHashMap.put("name",tCoursePackageType.getName()); double a= 0; for (TCoursePackagePayment tCoursePackagePayment : list) { if(tCoursePackagePayment.getType().equals(tCoursePackageType.getId())){ a += tCoursePackagePayment.getCashPayment().doubleValue(); } } objectObjectHashMap.put("value",a); hashMaps.add(objectObjectHashMap); } HashMap map1 = new HashMap<>(); map1.put("fee",v); map1.put("data",hashMaps); return map1; } }