package com.ruoyi.web.controller.api;
|
|
|
import cn.afterturn.easypoi.excel.ExcelExportUtil;
|
import cn.afterturn.easypoi.excel.entity.ExportParams;
|
import com.alipay.api.AlipayApiException;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.common.basic.PageInfo;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.common.utils.WebUtils;
|
import com.ruoyi.framework.web.service.TokenService;
|
import com.ruoyi.system.domain.*;
|
import com.ruoyi.system.query.AppUserQuery;
|
import com.ruoyi.system.query.OrderQuery;
|
import com.ruoyi.system.service.*;
|
import com.ruoyi.web.controller.query.CourseQuery;
|
import com.ruoyi.web.controller.query.InformationQuery;
|
import com.ruoyi.web.controller.tool.PayMoneyUtil;
|
import io.swagger.annotations.ApiOperation;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.springframework.security.core.parameters.P;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.annotation.Resource;
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.net.URLEncoder;
|
import java.time.LocalDateTime;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 订单表 前端控制器
|
* </p>
|
*
|
* @author luodangjia
|
* @since 2024-09-19
|
*/
|
@RestController
|
@RequestMapping("/t-order")
|
public class TOrderController {
|
@Resource
|
private TOrderService orderService;
|
|
@Resource
|
private TCourseService courseService;
|
@Resource
|
private TRegionService regionService;
|
@Resource
|
private TTechnicalTitleService tTechnicalTitleService;
|
@Resource
|
private TTitleMajorService majorService;
|
@Resource
|
private TGeneratedRecordsService generatedRecordsService;
|
@Resource
|
private TInformationService informationService;
|
@Resource
|
private PayMoneyUtil payMoneyUtil;
|
@Resource
|
private TokenService tokenService;
|
@Resource
|
private TAppUserService appUserService;
|
|
|
//查询
|
@ApiOperation(value = "查询",tags = "后台-订单管理")
|
@PostMapping("/pageList")
|
public R<PageInfo<TOrder>> pageList(@RequestBody OrderQuery orderQuery){
|
return R.ok(orderService.pageList(orderQuery));
|
}
|
|
@ApiOperation(value = "删除",tags = "web-订单管理")
|
@PostMapping("/delete")
|
public R delete(@RequestParam Long orderId){
|
orderService.removeById(orderId);
|
return R.ok();
|
}
|
|
@ApiOperation(value = "订单查询",tags = "web-个人中心")
|
@PostMapping("/web/pageList")
|
public R<PageInfo<TOrder>> webpageList(@RequestBody OrderQuery orderQuery){
|
Long userId = tokenService.getLoginUser().getUserId();
|
orderQuery.setUserId(userId);
|
return R.ok(orderService.pageList(orderQuery));
|
}
|
|
|
@ApiOperation(value = "计数",tags = "后台-订单管理")
|
@PostMapping("/count")
|
public R<List<Map<String,Object>>> count(@RequestBody OrderQuery orderQuery){
|
return R.ok(orderService.totalCount(orderQuery));
|
}
|
|
|
@ApiOperation(value = "取消订单",tags = {"后台-订单管理","web-个人中心"})
|
@PostMapping("/cancel")
|
public R cancel(Long orderId){
|
TOrder order = orderService.getById(orderId);
|
if (order.getPaymentStatus()!=1){
|
return R.fail("订单状态异常");
|
}
|
order.setPaymentStatus(3);
|
order.setCancelTime(LocalDateTime.now());
|
orderService.updateById(order);
|
return R.ok();
|
}
|
|
|
@ApiOperation(value = "课程详情",tags = "后台-订单管理")
|
@PostMapping(value = "/course/detail")
|
public R<TCourse> list(Long id,Long goodId) {
|
TCourse course = courseService.getById(goodId);
|
|
|
TRegion region = regionService.getById(course.getRegionId());
|
course.setRegionName(region.getProvinceName()+"-"+region.getName());
|
TTechnicalTitle tTechnicalTitle = tTechnicalTitleService.getById(course.getTechnicalId() );
|
TTitleMajor titleMajor = majorService.getById(course.getMajorId());
|
course.setTechnicalName(tTechnicalTitle.getTitileName()+"-"+titleMajor.getMajorName());
|
|
TOrder order = orderService.getById(id);
|
TAppUser appUser = appUserService.getById(order.getUserId());
|
order.setName(appUser.getName());
|
order.setPhone(appUser.getPhone());
|
order.setAvatar(appUser.getAvatar());
|
course.setOrder(order);
|
|
Long count = orderService.lambdaQuery()
|
.eq(TOrder::getGoodId, course.getId())
|
.eq(TOrder::getGoodType, 1)
|
.eq(TOrder::getPaymentStatus, 2).count();
|
course.setBuyNum(Integer.parseInt(String.valueOf(count)));
|
|
return R.ok(course);
|
}
|
|
@ApiOperation(value = "工作总结详情",tags = "后台-订单管理")
|
@PostMapping("/generate/detail")
|
public R<TGeneratedRecords> detail(Long id){
|
TOrder order = orderService.getById(id);
|
TGeneratedRecords tGeneratedRecords = generatedRecordsService.lambdaQuery().eq(TGeneratedRecords::getUserId, order.getUserId()).orderByDesc(TGeneratedRecords::getCreateTime).last("limit 1").one();
|
if (tGeneratedRecords == null) {
|
TGeneratedRecords generatedRecords = new TGeneratedRecords();
|
generatedRecords.setOrder(order);
|
return R.ok(generatedRecords);
|
}
|
|
TOrder tOrder = orderService.getById(id);
|
TAppUser appUser = appUserService.getById(tOrder.getUserId());
|
tOrder.setName(appUser.getName());
|
tOrder.setPhone(appUser.getPhone());
|
tOrder.setAvatar(appUser.getAvatar());
|
tGeneratedRecords.setOrder(tOrder);
|
|
return R.ok(tGeneratedRecords);
|
}
|
|
|
@ApiOperation(value = "资料详情",tags = "后台-订单管理")
|
@PostMapping(value = "/order/information/detail")
|
public R<TInformation> informationR1(Long goodId,Long id) {
|
TInformation record = informationService.getById(goodId);
|
TRegion region = regionService.getById(record.getRegionId());
|
record.setRegionName(region.getProvinceName()+"-"+region.getName());
|
TTechnicalTitle technicalTitle = tTechnicalTitleService.getById(record.getTechnicalId());
|
TTitleMajor titleMajor = majorService.getById(record.getMajorId());
|
record.setTechnicalName(technicalTitle.getTitileName()+"-"+titleMajor.getMajorName());
|
|
|
TOrder order = orderService.getById(id);
|
TAppUser appUser = appUserService.getById(order.getUserId());
|
order.setName(appUser.getName());
|
order.setPhone(appUser.getPhone());
|
order.setAvatar(appUser.getAvatar());
|
record.setOrder(order);
|
|
|
return R.ok(record);
|
}
|
|
|
@ApiOperation(value = "资料详情",tags = "后台-资料管理")
|
@PostMapping(value = "/information/detail")
|
public R<TInformation> informationR(Long goodId) {
|
TInformation record = informationService.getById(goodId);
|
TRegion region = regionService.getById(record.getRegionId());
|
record.setRegionName(region.getProvinceName()+"-"+region.getName());
|
TTechnicalTitle technicalTitle = tTechnicalTitleService.getById(record.getTechnicalId());
|
TTitleMajor tTitleMajor = majorService.getById(record.getMajorId());
|
record.setTechnicalName(technicalTitle.getTitileName()+"-"+tTitleMajor.getMajorName());
|
|
|
|
return R.ok(record);
|
}
|
|
@ApiOperation(value = "退款",tags = "后台-资料管理")
|
@PostMapping(value = "/refund")
|
public R<TInformation> refund(Long orderId) throws AlipayApiException {
|
TOrder order = orderService.getById(orderId);
|
if (order.getPaymentStatus()!=2){
|
return R.fail("订单状态异常");
|
}
|
|
if (order.getPaymentType()==1){
|
payMoneyUtil.wxRefund(order.getSerialNumber(), order.getCode(),order.getPaymentAmount().toString(), order.getPaymentAmount().toString(),"/");
|
}
|
if (order.getPaymentType()==2){
|
Map<String, String> stringStringMap = payMoneyUtil.aliRefund(order.getCode(), order.getPaymentAmount().toString());
|
if ("10000".equals(stringStringMap.get("code"))){
|
order.setPaymentStatus(4);
|
orderService.updateById(order);
|
}
|
}
|
|
return R.ok();
|
}
|
|
|
@ApiOperation(value = "导出",tags = "后台-订单管理")
|
@PostMapping(value = "/export")
|
public void mealGeneratorExport(@RequestBody OrderQuery orderQuery) {
|
|
|
int pageSize = 100;
|
int currentPage = 0;
|
List<TOrder> page = new ArrayList<>();
|
|
while (true) {
|
orderQuery.setPageNum(currentPage * pageSize);
|
orderQuery.setPageSize(pageSize);
|
PageInfo<TOrder> tOrderPageInfo = orderService.pageList(orderQuery);
|
List<TOrder> records = tOrderPageInfo.getRecords();
|
if (CollectionUtils.isEmpty(records)) {
|
break; // 没有更多数据，退出循环
|
}
|
page.addAll(records); // 累加当前页数据
|
currentPage++; // 进入下一页
|
}
|
|
List<TCourse> courses = courseService.lambdaQuery().list();
|
List<TInformation> informations = informationService.lambdaQuery().list();
|
for (TOrder record : page) {
|
record.getFormattedCreateTime();
|
if (record.getGoodType()==1){
|
TCourse course = courses.stream().filter(e -> e.getId().equals(record.getGoodId())).findFirst().orElse(null);
|
record.setGoodName(course.getCourseName());
|
}else if (record.getGoodType()==2){
|
TInformation information = informations.stream().filter(e -> e.getId().equals(record.getGoodId())).findFirst().orElse(null);
|
record.setGoodName(information.getInformationName());
|
}else {
|
record.setGoodName("工作总结订单");
|
}
|
}
|
|
|
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TOrder.class,page);
|
HttpServletResponse response = WebUtils.response();
|
response.setContentType("application/vnd.ms-excel");
|
response.setCharacterEncoding("utf-8");
|
ServletOutputStream outputStream = null;
|
try {
|
String fileName = URLEncoder.encode("用户列表.xls", "utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
|
response.setContentType("application/vnd.ms-excel;charset=UTF-8");
|
response.setHeader("Pragma", "no-cache");
|
response.setHeader("Cache-Control", "no-cache");
|
outputStream = response.getOutputStream();
|
workbook.write(outputStream);
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally {
|
try {
|
outputStream.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
|
|
}
|
