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> page = new PageFactory>().defaultPage(); List> 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> page = new PageFactory>().defaultPage(); times = times.split(" ")[0]; 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> page = new PageFactory>().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> list = tIncomeService.getExcelList(id); // 表格数据【封装】 List> dataList = new ArrayList<>(); // 表头行 List shellList = new ArrayList(); shellList.add("日期"); shellList.add("活动收入"); shellList.add("在线支付收入"); shellList.add("现金支付收入"); dataList.add(shellList); for (Map map : list) { //数据行 shellList = new ArrayList(); //下单时间 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("onlineMoney"))){ shellList.add(map.get("onlineMoney").toString()); }else{ shellList.add("-"); } if(SinataUtil.isNotEmpty(map.get("cashMoney"))){ shellList.add(map.get("cashMoney").toString()); }else{ shellList.add("-"); } dataList.add(shellList); } try { // 调用工具类进行导出 ExcelExportUtil.easySheet("收入明细数据"+ DateUtil.formatDate(new Date(), "YYYYMMddHHmmss"), "收入明细数据", dataList,request, response); } catch (Exception e) { e.printStackTrace(); } } }