puzhibing
6 小时以前 26795c6ce013bb204fa57a8324db7a7c77aea5b8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
package com.ruoyi.order.controller;
 
import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.ruoyi.common.core.domain.R;
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.common.security.annotation.Logical;
import com.ruoyi.common.security.annotation.RequiresPermissions;
import com.ruoyi.order.api.query.CardBalanceDetailQuery;
import com.ruoyi.order.api.query.CardChargingOrderQuery;
import com.ruoyi.order.api.vo.CardBalanceDetailVO;
import com.ruoyi.order.api.vo.ChargingOrderVO;
import com.ruoyi.order.export.CardBalanceDetailExport;
import com.ruoyi.order.export.CardChargingOrderExport;
import com.ruoyi.order.service.TCardChargingOrderService;
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.GetMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
 
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.Collections;
import java.util.List;
import java.util.Map;
 
@RestController
@RequestMapping("/t-card-charging-order")
@Api(tags = "管理后台-刷卡充电订单")
public class TCardChargingOrderController {
 
    @Resource
    private TCardChargingOrderService cardChargingOrderService;
 
    @GetMapping("/list")
    @ApiOperation("刷卡充电订单列表")
    public R<PageInfo<ChargingOrderVO>> list(CardChargingOrderQuery query) {
        return R.ok(cardChargingOrderService.pageList(query));
    }
 
    @RequiresPermissions(value = {"/cardChargingOrder/export", "/cardChargingOrder"}, logical = Logical.OR)
    @PutMapping("/export")
    @ApiOperation("刷卡充电订单导出")
    @Log(title = "刷卡充电订单导出", businessType = BusinessType.EXPORT)
    public void export(@RequestBody CardChargingOrderQuery query) {
        List<ChargingOrderVO> list = cardChargingOrderService.exportList(query);
        List<CardChargingOrderExport> exports = new ArrayList<>();
        for (ChargingOrderVO order : list) {
            CardChargingOrderExport export = new CardChargingOrderExport();
            BeanUtils.copyProperties(order, export);
            export.setStartTime(formatTime(order.getStartTime()));
            export.setEndTime(formatTime(order.getEndTime()));
            export.setMaxEndTime(formatTime(order.getMaxEndTime()));
            exports.add(export);
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), CardChargingOrderExport.class, exports);
        writeWorkbook(workbook, "刷卡充电订单导出.xls");
    }
 
    private String formatTime(LocalDateTime time) {
        return time == null ? "" : DateUtils.localDateTimeToString(time);
    }
 
    private void writeWorkbook(Workbook workbook, String exportFileName) {
        HttpServletResponse response = WebUtils.response();
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode(exportFileName, "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 {
                workbook.close();
                if (outputStream != null) {
                    outputStream.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
 
    @GetMapping("/summary")
    @ApiOperation("刷卡充电订单汇总")
    public R<Map<String, Object>> summary(CardChargingOrderQuery query) {
        Map<String, Object> summary = cardChargingOrderService.summary(query);
        return R.ok(summary == null ? Collections.emptyMap() : summary);
    }
 
    @GetMapping("/detail")
    @ApiOperation("刷卡充电订单详情")
    public R<Map<String, Object>> detail(@RequestParam("chargingOrderId") Long chargingOrderId) {
        return R.ok(cardChargingOrderService.detail(chargingOrderId));
    }
 
    @GetMapping("/balance-income-detail")
    @ApiOperation("刷卡充电订单余额收入明细")
    public R<List<Map<String, Object>>> balanceIncomeDetail(CardChargingOrderQuery query) {
        return R.ok(cardChargingOrderService.balanceIncomeDetail(query));
    }
 
    @GetMapping("/accounting-strategy")
    @ApiOperation("刷卡充电订单计费明细")
    public R<Map<String, Object>> accountingStrategy(@RequestParam("chargingOrderId") Long chargingOrderId) {
        List<Map<String, Object>> list = cardChargingOrderService.accountingStrategyList(chargingOrderId);
        return R.ok(Collections.singletonMap("list", list));
    }
 
    @RequiresPermissions("/chargingGun/end_charging")
    @PutMapping("/stopCharging")
    @ApiOperation("停止刷卡充电")
    @Log(title = "刷卡充电订单停止充电", businessType = BusinessType.OTHER)
    public AjaxResult stopCharging(@RequestParam("chargingOrderId") String chargingOrderId,
                                   @RequestParam("chargingGunId") Integer chargingGunId) {
        return cardChargingOrderService.stopCharging(chargingOrderId, chargingGunId);
    }
 
    @RequiresPermissions("/chargingCardBalanceDetail/list")
    @GetMapping("/balance-detail/list")
    @ApiOperation("卡片收支明细列表")
    public R<PageInfo<CardBalanceDetailVO>> balanceDetailList(CardBalanceDetailQuery query) {
        return R.ok(cardChargingOrderService.balanceDetailPage(query));
    }
 
    @RequiresPermissions("/chargingCardBalanceDetail/list")
    @GetMapping("/balance-detail/summary")
    @ApiOperation("卡片收支明细汇总")
    public R<Map<String, Object>> balanceDetailSummary(CardBalanceDetailQuery query) {
        return R.ok(cardChargingOrderService.balanceDetailSummary(query));
    }
 
    @RequiresPermissions("/chargingCardBalanceDetail/export")
    @PutMapping("/balance-detail/export")
    @ApiOperation("卡片收支明细导出")
    @Log(title = "卡片收支明细导出", businessType = BusinessType.EXPORT)
    public void balanceDetailExport(@RequestBody CardBalanceDetailQuery query) {
        List<CardBalanceDetailVO> list = cardChargingOrderService.balanceDetailExport(query);
        List<CardBalanceDetailExport> exports = new ArrayList<>();
        for (int i = 0; i < list.size(); i++) {
            CardBalanceDetailVO detail = list.get(i);
            CardBalanceDetailExport export = new CardBalanceDetailExport();
            BeanUtils.copyProperties(detail, export);
            export.setSequence(i + 1);
            export.setOperationTime(formatTime(detail.getOperationTime()));
            exports.add(export);
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), CardBalanceDetailExport.class, exports);
        writeWorkbook(workbook, "卡片收支明细导出.xls");
    }
}