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;
//    }
}