puzhibing
2023-05-18 53562814add61acfdc02d6b25dae6324f6fd5f92
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
package com.stylefeng.guns.modular.system.controller;
 
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.stylefeng.guns.core.base.controller.BaseController;
import com.stylefeng.guns.core.common.constant.factory.PageFactory;
import com.stylefeng.guns.core.shiro.ShiroKit;
import com.stylefeng.guns.core.util.DateUtil;
import com.stylefeng.guns.core.util.ExcelExportUtil;
import com.stylefeng.guns.core.util.SinataUtil;
import com.stylefeng.guns.modular.system.model.Income;
import com.stylefeng.guns.modular.system.service.IIncomeService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.beans.factory.annotation.Autowired;
import com.stylefeng.guns.core.log.LogObjectHolder;
import org.springframework.web.bind.annotation.RequestParam;
 
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
 
/**
 * 控制器
 *
 * @author fengshuonan
 * @Date 2021-04-22 10:53:34
 */
@Controller
@RequestMapping("/tIncome")
public class TIncomeController extends BaseController {
 
    private String PREFIX = "/system/tIncome/";
 
    @Autowired
    private IIncomeService tIncomeService;
 
    /**
     * 跳转到首页
     */
    @RequestMapping("")
    public String index(Integer id, Model model) {
        model.addAttribute("id", id);
        return PREFIX + "tIncome.html";
    }
 
    @RequestMapping("driverWork")
    public String driverWork(Model model) {
        return PREFIX + "driverWork.html";
    }
 
    @RequestMapping(value = "/driverWorkList")
    @ResponseBody
    public Object driverWorkList() {
        Page<Map<String,Object>> page = new PageFactory<Map<String,Object>>().defaultPage();
        List<Map<String,Object>> list = tIncomeService.getList1(page);
        page.setRecords(list);
        return super.packForBT(page);
    }
 
    @RequestMapping("driverWorkDetail")
    public String driverWorkDetail(String times, Model model) {
        model.addAttribute("times", times);
        return PREFIX + "driverWorkDetail.html";
    }
 
    @RequestMapping(value = "/driverWorkDetailList")
    @ResponseBody
    public Object driverWorkDetailList(String times) {
        Page<Map<String,Object>> page = new PageFactory<Map<String,Object>>().defaultPage();
        page.setRecords(tIncomeService.getList2(page,times));
        return super.packForBT(page);
    }
    /**
     * 跳转到添加
     */
    @RequestMapping("/tIncome_add")
    public String tIncomeAdd() {
        return PREFIX + "tIncome_add.html";
    }
 
 
    /**
     * 获取列表
     */
    @RequestMapping(value = "/list")
    @ResponseBody
    public Object list(Integer id) {
        Page<Map<String,Object>> page = new PageFactory<Map<String,Object>>().defaultPage();
        page.setRecords(tIncomeService.getList(page,id));
        return super.packForBT(page);
    }
    @RequestMapping("/getExcel")
    @ResponseBody
    public void getExcel(
                         Integer id,
                         HttpServletRequest request,
                         HttpServletResponse response) {
        String beginTime = null;
        String endTime = null;
        List<Map<String, Object>> list = tIncomeService.getExcelList(id);
        // 表格数据【封装】
        List<List<String>> dataList = new ArrayList<>();
        // 表头行
        List<String> shellList = new ArrayList<String>();
        shellList.add("日期");
        shellList.add("活动收入");
        shellList.add("业务收入");
 
        dataList.add(shellList);
        for (Map<String, Object> map : list) {
            //数据行
            shellList = new ArrayList<String>();
            //下单时间
            if(SinataUtil.isNotEmpty(map.get("times"))){
                shellList.add(String.valueOf(map.get("times")));
            }else{
                shellList.add("-");
            }
            //订单编号
            if(SinataUtil.isNotEmpty(map.get("activityMoney"))){
                shellList.add(map.get("activityMoney").toString());
            }else{
                shellList.add("-");
            }
            if(SinataUtil.isNotEmpty(map.get("orderMoney"))){
                shellList.add(map.get("orderMoney").toString());
            }else{
                shellList.add("-");
            }
 
            dataList.add(shellList);
        }
        try {
            // 调用工具类进行导出
            ExcelExportUtil.easySheet("收入明细数据"+ DateUtil.formatDate(new Date(), "YYYYMMddHHmmss"), "收入明细数据", dataList,request, response);
 
        } catch (Exception e) {
            e.printStackTrace();
        }
 
    }
}