From 78d7911139088c285abbddcb4746f3ea10a94f23 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期三, 04 九月 2024 10:45:05 +0800 Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/mx_charging_pile --- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/TOrderInvoiceController.java | 83 ++++++++++++++++++++++++++++++++++++++++- 1 files changed, 81 insertions(+), 2 deletions(-) diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/TOrderInvoiceController.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/TOrderInvoiceController.java index 8e2cd80..5bbdf95 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/TOrderInvoiceController.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/TOrderInvoiceController.java @@ -1,18 +1,37 @@ package com.ruoyi.order.controller; +import cn.afterturn.easypoi.excel.ExcelExportUtil; +import cn.afterturn.easypoi.excel.entity.ExportParams; +import com.ruoyi.common.core.utils.DateUtils; +import com.ruoyi.common.core.utils.WebUtils; import com.ruoyi.common.core.web.domain.AjaxResult; +import com.ruoyi.common.core.web.page.PageInfo; +import com.ruoyi.common.log.annotation.Log; +import com.ruoyi.common.log.enums.BusinessType; +import com.ruoyi.order.api.model.TOrderInvoice; +import com.ruoyi.order.api.query.TOrderInvoiceQuery; +import com.ruoyi.order.api.vo.TOrderInvoiceVO; import com.ruoyi.order.dto.AddOrderInvoice; import com.ruoyi.order.dto.GetOrderInvoiceList; import com.ruoyi.order.dto.MyOrderInvoiceInfo; import com.ruoyi.order.dto.OrderInvoiceList; +import com.ruoyi.order.export.OrderInvoiceExport; import com.ruoyi.order.service.TOrderInvoiceService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import org.apache.poi.ss.usermodel.Workbook; +import org.springframework.beans.BeanUtils; 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.util.ArrayList; import java.util.List; +import java.util.Map; /** * <p> @@ -39,8 +58,68 @@ public AjaxResult addOrderInvoice(@RequestBody AddOrderInvoice addOrderInvoice){ return orderInvoiceService.addOrderInvoice(addOrderInvoice); } - - + + @PostMapping("/pageList") + @ApiOperation(value = "查询开票分页列表", tags = {"管理后台-发票管理"}) + public AjaxResult<PageInfo<TOrderInvoiceVO>> pageList(@RequestBody TOrderInvoiceQuery query){ + return AjaxResult.success(orderInvoiceService.pageList(query)); + } + + @GetMapping("/uploadPdf") + @ApiOperation(value = "上传发票", tags = {"管理后台-发票管理"}) + public AjaxResult<String> uploadPdf(@RequestParam("id") Long id, + @RequestParam("invoiceUrl") String invoiceUrl){ + TOrderInvoice orderInvoice = orderInvoiceService.getById(id); + orderInvoice.setInvoiceUrl(invoiceUrl); + orderInvoiceService.updateById(orderInvoice); + return AjaxResult.success(); + } + + @PostMapping("/statusCount") + @ApiOperation(value = "查询开票状态数量", tags = {"管理后台-发票管理"}) + public AjaxResult<Map<String,Integer>> statusCount(@RequestBody TOrderInvoiceQuery query){ + return AjaxResult.success(orderInvoiceService.statusCount(query)); + } + + /** + * 发票管理导出 + */ + @ApiOperation(value = "发票管理导出") + @Log(title = "发票管理导出", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(@RequestBody TOrderInvoiceQuery query) + { + List<TOrderInvoiceVO> list = orderInvoiceService.export(query); + List<OrderInvoiceExport> orderInvoiceExports = new ArrayList<>(); + for (TOrderInvoiceVO orderInvoiceVO : list) { + OrderInvoiceExport orderInvoiceExport = new OrderInvoiceExport(); + BeanUtils.copyProperties(orderInvoiceVO,orderInvoiceExport); + orderInvoiceExport.setBillingTime(DateUtils.localDateTimeToString(orderInvoiceVO.getBillingTime())); + orderInvoiceExports.add(orderInvoiceExport); + } + Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), OrderInvoiceExport.class, orderInvoiceExports); + 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(); + } + } + } @ResponseBody @GetMapping("/getMyOrderInvoiceList") -- Gitblit v1.7.1