package com.stylefeng.guns.modular.system.service.impl;
|
|
import com.baomidou.mybatisplus.plugins.Page;
|
import com.stylefeng.guns.modular.system.dao.TCompanyMapper;
|
import com.stylefeng.guns.modular.system.model.TTaxiCard;
|
import com.stylefeng.guns.modular.system.dao.TTaxiCardMapper;
|
import com.stylefeng.guns.modular.system.service.ITTaxiCardService;
|
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
|
import org.apache.poi.hssf.usermodel.*;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 打车卡 服务实现类
|
* </p>
|
*
|
* @author stylefeng
|
* @since 2022-02-14
|
*/
|
@Service
|
public class TTaxiCardServiceImpl extends ServiceImpl<TTaxiCardMapper, TTaxiCard> implements ITTaxiCardService {
|
|
@Resource
|
private TTaxiCardMapper taxiCardMapper;
|
|
|
@Override
|
public List<Map<String, Object>> tTaxiCardPaymentList(Integer cardId, Page<Map<String,Object>> page, String startTime, String endTime, String name) {
|
return this.baseMapper.tTaxiCardPaymentList(cardId,page,startTime,endTime,name);
|
}
|
|
@Override
|
public List<Map<String, Object>> tTaxiCardPaymentLists(Integer cardId, String startTime, String endTime, String name) {
|
return this.baseMapper.tTaxiCardPaymentLists(cardId, startTime, endTime, name);
|
}
|
|
@Override
|
public Map<String, Object> searchRecordDetail(Integer paymentId) {
|
return this.baseMapper.searchRecordDetail(paymentId);
|
}
|
|
@Override
|
public Double AllCardMoney(Integer companyId) {
|
return this.baseMapper.AllCardMoney(companyId);
|
}
|
|
|
/**
|
* 下载运营汇总数据
|
* @return
|
* @throws Exception
|
*/
|
// @Override
|
// public HSSFWorkbook downloadOperationalData(Integer takeCardId, String startTime, String endTime, String name) throws Exception {
|
// List<Map<String, Object>> list = taxiCardMapper.tTaxiCardPaymentLists(takeCardId,startTime,endTime,name);
|
//
|
// List<List<String>> lists = new ArrayList<>();
|
// List<String> list1 = new ArrayList<>();
|
// list1.add("购买时间");
|
// list1.add("用户名称");
|
// list1.add("用户手机号");
|
// list1.add("打车卡名称");
|
// list1.add("金额");
|
// lists.add(list1);
|
//
|
// List<List<List<String>>> lists1 = new ArrayList<>();
|
// List<List<String>> lists2 = new ArrayList<>();
|
// for(Map<String, Object> map : list){
|
// List<String> list2 = new ArrayList<>();
|
// list2.add(null != map.get("createTime") ? map.get("createTime").toString() : "");
|
// list2.add(null != map.get("nickName") ? map.get("nickName").toString() : "");
|
// list2.add(null != map.get("phone") ? map.get("phone").toString() : "");
|
// list2.add(null != map.get("cardName") ? map.get("cardName").toString() : "");
|
// list2.add(null != map.get("payMoney") ? map.get("payMoney").toString() : "");
|
// lists2.add(list2);
|
// }
|
// lists1.add(lists2);
|
// HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
|
// HSSFSheet hssfSheet = hssfWorkbook.createSheet();
|
// hssfSheet.setColumnWidth(0, 6 * 256);
|
// hssfSheet.setDefaultRowHeightInPoints(20f);
|
// for(int i = 0; i < lists.size(); i++){
|
// HSSFRow hssfRow = hssfSheet.createRow(i);//设置第一行数据（标题）
|
// HSSFCellStyle style = hssfWorkbook.createCellStyle();
|
// HSSFFont font = hssfWorkbook.createFont();
|
// font.setFontName("bold");
|
// style.setFont(font);
|
// style.setAlignment(HorizontalAlignment.CENTER);
|
// for (int l = 0; l < lists.get(i).size(); l++) {
|
// HSSFCell hssfCell = hssfRow.createCell(l);
|
// hssfCell.setCellType(CellType.STRING);//设置表格类型
|
// hssfCell.setCellValue(lists.get(i).get(l));
|
// hssfCell.setCellStyle(style);
|
// if(l > 0) {
|
// hssfSheet.setColumnWidth(l , 20 * 256);
|
// }
|
//
|
// }
|
// }
|
//这个就是合并单元格
|
//参数说明：1：开始行 2：结束行 3：开始列 4：结束列
|
//比如我要合并 第二行到第四行的 第六列到第八列 sheet.addMergedRegion(new CellRangeAddress(1,3,5,7));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(0,0,1,3));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(0,0,5,7));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(0,0,9,10));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,2,0,0));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,2,1,1));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,2,2,2));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,1,3,5));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,1,6,10));
|
// hssfSheet.addMergedRegion(new CellRangeAddress(1,2,11,11));
|
|
|
// for(int i = 0; i < lists1.size(); i++){
|
// //将数据添加到表格中
|
// List<String> data = null;
|
// for (int l = 0; l < lists1.get(i).size(); l++) {
|
// HSSFRow row = hssfSheet.createRow(l + 3);
|
// data = lists1.get(i).get(l);
|
// for (int j = 0; j < data.size(); j++) {
|
// HSSFCell hssfCell = row.createCell(j);
|
// hssfCell.setCellType(CellType.STRING);//设置表格类型
|
// hssfCell.setCellValue(data.get(j));
|
// }
|
// }
|
// }
|
// return hssfWorkbook;
|
// }
|
}
|
