Examples with TGExcelModel com.kendy.entity.TGExcelModel used on opensource projects

Example 1 with TGExcelModel

use of com.kendy.entity.TGExcelModel in project financial by greatkendy123.

the class TGExportExcelService method getPlayerCommentExcelModel.

/**
 * 玩家备注ExcelModel
 * @time 2018年3月18日
 * @return
 */
private TGExcelModel getPlayerCommentExcelModel() {
    TGExcelModel excelModel = new TGExcelModel();
    List<String> titleList = new LinkedList<>();
    List<Object[]> data = new LinkedList<>();
    List<String> titleSumList = new LinkedList<>();
    List<Object[]> dataSum = new LinkedList<>();
    titleList = new LinkedList<>(Arrays.asList("日期", "玩家ID", "玩家名称", "项目类型", "ID", "名称", "备注", "托管公司"));
    ObservableList<TGCommentInfo> items = tgController.tableTGComment.getItems();
    if (CollectUtil.isHaveValue(items)) {
        data = items.stream().map(info -> {
            Object[] obj = new Object[8];
            obj[0] = info.getTgCommentDate();
            obj[1] = info.getTgCommentPlayerId();
            obj[2] = info.getTgCommentPlayerName();
            obj[3] = info.getTgCommentType();
            obj[4] = info.getTgCommentId();
            obj[5] = info.getTgCommentName();
            obj[6] = info.getTgCommentBeizhu();
            obj[7] = info.getTgCommentCompany();
            return obj;
        }).collect(Collectors.toList());
    }
    ObservableList<String> sumItems = tgController.tgCommentSumView.getItems();
    if (CollectUtil.isHaveValue(sumItems)) {
        dataSum = sumItems.stream().map(info -> {
            Object[] obj = new Object[2];
            obj[0] = info.split(":")[0];
            obj[1] = info.split(":")[1];
            return obj;
        }).collect(Collectors.toList());
    }
    excelModel.setColumnList(titleList);
    excelModel.setData(data);
    excelModel.setColumnSumList(titleSumList);
    excelModel.setDataSum(dataSum);
    excelModel.setSheetName("玩家备注");
    return excelModel;
}

Example 2 with TGExcelModel

use of com.kendy.entity.TGExcelModel in project financial by greatkendy123.

the class TGExportExcelService method getFwfExcelModel.

/**
 * 导出服务费明细
 * @return
 */
private TGExcelModel getFwfExcelModel() {
    TGExcelModel excelModel = new TGExcelModel();
    List<String> titleList = new LinkedList<>();
    List<Object[]> data = new LinkedList<>();
    List<String> titleSumList = new LinkedList<>();
    List<Object[]> dataSum = new LinkedList<>();
    titleList = new LinkedList<>(Arrays.asList("托管公司", "托管团队", "回水", "回保", "总利润合计", "返水", "返保", "全水", "全保", "合计"));
    ObservableList<TGFwfinfo> items = tgController.tableTGFwf.getItems();
    if (CollectUtil.isHaveValue(items)) {
        data = items.stream().map(info -> {
            Object[] obj = new Object[10];
            obj[0] = info.getTgFwfCompany();
            obj[1] = info.getTgFwfTeamId();
            obj[2] = info.getTgFwfHuishui();
            obj[3] = info.getTgFwfHuiBao();
            obj[4] = info.getTgFwfProfit();
            obj[5] = info.getTgFwfFanshui();
            obj[6] = info.getTgFwfFanbao();
            obj[7] = info.getTgFwfQuanshui();
            obj[8] = info.getTgFwfQuanbao();
            obj[9] = info.getTgFwfHeji();
            return obj;
        }).collect(Collectors.toList());
    }
    ObservableList<TypeValueInfo> sumItems = tgController.tableTGFwfSum.getItems();
    if (CollectUtil.isHaveValue(sumItems)) {
        dataSum = sumItems.stream().map(info -> {
            Object[] obj = new Object[2];
            obj[0] = info.getType();
            obj[1] = info.getValue();
            return obj;
        }).collect(Collectors.toList());
    }
    excelModel.setColumnList(titleList);
    excelModel.setData(data);
    excelModel.setColumnSumList(titleSumList);
    excelModel.setDataSum(dataSum);
    excelModel.setSheetName("服务费");
    return excelModel;
}

Example 3 with TGExcelModel

use of com.kendy.entity.TGExcelModel in project financial by greatkendy123.

the class ExportTGExcel method main.

/**
 * 程序测试入口
 *
 * @time 2018年3月18日
 * @param strings
 * @throws Exception
 */
public static void main(String... strings) throws Exception {
    List<TGExcelModel> exportList = new ArrayList<>();
    TGExcelModel excelModel = new TGExcelModel();
    List<String> sumTitleList = new ArrayList<>();
    sumTitleList.add("类型");
    sumTitleList.add("值");
    List<Object[]> sumDataList = new ArrayList<>();
    Object[] sumDataObj = new Object[2];
    sumDataObj[0] = "类型1";
    sumDataObj[1] = "值1";
    sumDataList.add(sumDataObj);
    Object[] sumDataObj2 = new Object[2];
    sumDataObj2[0] = "类型2";
    sumDataObj2[1] = "值2";
    sumDataList.add(sumDataObj2);
    excelModel.setColumnSumList(sumTitleList);
    excelModel.setDataSum(sumDataList);
    List<String> columnList = new ArrayList<>();
    columnList.add("列标题 ");
    List<Object[]> dataList = new ArrayList<>();
    Object[] obj = new Object[1];
    obj[0] = "1";
    dataList.add(obj);
    excelModel.setSheetName("测试");
    excelModel.setColumnList(columnList);
    excelModel.setData(dataList);
    exportList.add(excelModel);
    excelModel = new TGExcelModel();
    columnList = new ArrayList<>();
    columnList.add("列标题2 ");
    dataList = new ArrayList<>();
    obj = new Object[1];
    obj[0] = "1";
    dataList.add(obj);
    excelModel.setSheetName("测试2");
    excelModel.setColumnList(columnList);
    excelModel.setData(dataList);
    exportList.add(excelModel);
    ExportTGExcel excelCreator = new ExportTGExcel(exportList);
    excelCreator.export();
}

Example 4 with TGExcelModel

use of com.kendy.entity.TGExcelModel in project financial by greatkendy123.

the class TGExportExcelService method getKaixiaoExcelModel.

/**
 * 开销ExcelModel
 * @time 2018年3月18日
 * @return
 */
private TGExcelModel getKaixiaoExcelModel() {
    TGExcelModel excelModel = new TGExcelModel();
    List<String> titleList = new LinkedList<>();
    List<Object[]> data = new LinkedList<>();
    List<String> titleSumList = new LinkedList<>();
    List<Object[]> dataSum = new LinkedList<>();
    titleList = new LinkedList<>(Arrays.asList("日期", "玩家名称", "支出项目", "开销金额", "托管公司"));
    ObservableList<TGKaixiaoInfo> items = tgController.tableTGKaixiao.getItems();
    if (CollectUtil.isHaveValue(items)) {
        data = items.stream().map(info -> {
            Object[] obj = new Object[5];
            obj[0] = info.getTgKaixiaoDate();
            obj[1] = info.getTgKaixiaoPlayerName();
            obj[2] = info.getTgKaixiaoPayItem();
            obj[3] = info.getTgKaixiaoMoney();
            obj[4] = info.getTgKaixiaoCompany();
            return obj;
        }).collect(Collectors.toList());
    }
    ObservableList<String> sumItems = tgController.tgKaixiaoSumView.getItems();
    if (CollectUtil.isHaveValue(sumItems)) {
        dataSum = sumItems.stream().map(info -> {
            Object[] obj = new Object[2];
            obj[0] = info.split(":")[0];
            obj[1] = info.split(":")[1];
            return obj;
        }).collect(Collectors.toList());
    }
    excelModel.setColumnList(titleList);
    excelModel.setData(data);
    excelModel.setColumnSumList(titleSumList);
    excelModel.setDataSum(dataSum);
    excelModel.setSheetName("开销");
    return excelModel;
}

Example 5 with TGExcelModel

use of com.kendy.entity.TGExcelModel in project financial by greatkendy123.

the class TGExportExcelService method getTeamZJExcelModel.

/**
 * 导出战绩明细
 * @return
 */
private TGExcelModel getTeamZJExcelModel(String teamId, String hsRate) {
    TGExcelModel excelModel = new TGExcelModel();
    List<String> titleList = new LinkedList<>();
    List<Object[]> data = new LinkedList<>();
    List<String> titleSumList = new LinkedList<>();
    List<Object[]> dataSum = new LinkedList<>();
    titleList = new LinkedList<>(Arrays.asList("玩家ID", "玩家名称", "原始战绩", "保险", "战绩2.5%", "战绩" + hsRate, "回保", "利润", "场次"));
    ObservableList<TGTeamInfo> items = tgController.tableTGZhanji.getItems();
    if (CollectUtil.isHaveValue(items)) {
        data = items.stream().map(info -> {
            Object[] obj = new Object[9];
            obj[0] = info.getTgPlayerId();
            obj[1] = info.getTgPlayerName();
            obj[2] = info.getTgYSZJ();
            obj[3] = info.getTgBaoxian();
            obj[4] = info.getTgZJ25();
            obj[5] = info.getTgZJUnknow();
            obj[6] = info.getTgHuiBao();
            obj[7] = info.getTgProfit();
            obj[8] = info.getTgChangci();
            return obj;
        }).collect(Collectors.toList());
    }
    ObservableList<TypeValueInfo> sumItems = tgController.tableZJSum.getItems();
    if (CollectUtil.isHaveValue(sumItems)) {
        dataSum = sumItems.stream().map(info -> {
            Object[] obj = new Object[2];
            obj[0] = info.getType();
            obj[1] = info.getValue();
            return obj;
        }).collect(Collectors.toList());
    }
    excelModel.setColumnList(titleList);
    excelModel.setData(data);
    excelModel.setColumnSumList(titleSumList);
    excelModel.setDataSum(dataSum);
    excelModel.setSheetName(teamId);
    return excelModel;
}