一、简介
最近,产品那边出一个贼讨厌的需求,要做目前支付平台的数据统计;之前有跟运营讨论过这个问题,按照他们想法真是天马行空,我一听,太复杂了做不了;后来又找到产品提需求;虽然比之前的需求要好点,但是还是觉得复杂;根本不想做;后来实在没办法;只要在网上找好一点的解决办法;老大推荐的阿里巴巴的EasyExcel还蛮符合当前需求的;于是看了文档,参考了下别人的案列就开始开干了;耗时两周的时间终于完成了,今天总结下记录下。
二、当前项目需求
1.统计支付汇总数据的日报表,周报表,月报表
2.统计区域的日报表,周报表,日报表
3.统计机构的日报表、周报表、月报表
三、参考文章
https://blog.csdn.net/jianggujin/article/details/80200400
四、依赖引入
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>1.0.1</version>
</dependency>
五、代码案例
5.1 日报汇总统计
public void dayReportTotal(HttpServletResponse response, HttpServletRequest request) throws IOException, IllegalAccessException, NoSuchMethodException, InvocationTargetException {
try {
String year = request.getParameter("year");
String month = request.getParameter("month");
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(year + "年" + month + "月" + "支付业务数据统计日报表", "utf-8") + ".xlsx");
OutputStream out = response.getOutputStream();
ExtZfReportDayMedicalStatQuery query = new ExtZfReportDayMedicalStatQuery();
query.setGroupYear(year);
query.setGroupMonth(month);
List<ExtZfReportDayMedicalStatDO> extZfReportDayMedicalStatDOS = medicalStatMapper.dayReportTotal(query);
//计算合计
//获取总数据的表头和数据
List<List<String>> list = EasyExcelUtils.getHeadAndDataTotal("day", extZfReportDayMedicalStatDOS, year, month);
//获取日报模板并下载
EasyExcelUtils.getDayReportTemplate(request, out, list);
System.out.println("ok");
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
public static List<List<String>> getHeadAndDataTotal(String type, List<ExtZfReportDayMedicalStatDO> medicalStatDOList, String year, String month) {
List<List<String>> list = new ArrayList<List<String>>();
List<String> row1 = new ArrayList<String>();
List<String> row2 = new ArrayList<String>();
List<String> row3 = new ArrayList<String>();
List<String> row4 = new ArrayList<String>();
List<String> row5 = new ArrayList<String>();
List<String> row6 = new ArrayList<String>();
List<String> row7 = new ArrayList<String>();
List<String> row8 = new ArrayList<String>();
List<String> row9 = new ArrayList<String>();
List<String> row10 = new ArrayList<String>();
List<String> row11 = new ArrayList<String>();
List<String> row12 = new ArrayList<String>();
List<String> row13 = new ArrayList<String>();
List<String> row14 = new ArrayList<String>();
List<String> row15 = new ArrayList<String>();
List<String> row16 = new ArrayList<String>();
List<String> row17 = new ArrayList<String>();
List<String> row18 = new ArrayList<String>();
List<String> row19 = new ArrayList<String>();
List<String> row20 = new ArrayList<String>();
List<String> row21 = new ArrayList<String>();
List<String> row22 = new ArrayList<String>();
List<String> row23 = new ArrayList<String>();
List<String> row24 = new ArrayList<String>();
List<String> row25 = new ArrayList<String>();
List<String> row26 = new ArrayList<String>();
List<String> row27 = new ArrayList<String>();
List<String> row28 = new ArrayList<String>();
List<String> row29 = new ArrayList<String>();
row1.add("总支付笔数");
row2.add("总支付金额");
row3.add("扫码付总笔数");
row4.add("扫码付总金额");
row5.add("当面付总笔数");
row6.add("当面付总金额");
row7.add("在线支付总笔数");
row8.add("在线支付总金额");
row9.add("扫码付占比");
row10.add("当面付占比");
row11.add("在线支付占比");
row12.add("扫码付(自费)笔数");
row13.add("扫码付(自费)金额");
row14.add("扫码付(医保)笔数");
row15.add("扫码付(医保)金额");
row16.add("当面付(自费)笔数");
row17.add("当面付(自费)金额");
row18.add("当面付(医保)笔数");
row19.add("当面付(医保)金额");
row20.add("在线支付(自费)笔数");
row21.add("在线支付(自费)金额");
row22.add("在线支付(医保)笔数");
row23.add("在线支付(医保)金额");
row24.add("扫码付(自费)占比");
row25.add("扫码付(医保)占比");
row26.add("当面付(自费)占比");
row27.add("当面付(医保)占比");
row28.add("在线支付(自费)占比");
row29.add("在线支付(医保)占比");
//合计列设置
setTotalData(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, medicalStatDOList);
String flag = "";//用来标记下次循环的位置
//日报
if ("day".equals(type)) {
//计算当前月有多少天
int dayNum = getDaysOfMonth(DateUtils.format(year + month, "yyyyMM"));
String[] arrayDay = getArray(dayNum);//获取天的数组
for (ExtZfReportDayMedicalStatDO data : medicalStatDOList) {
flag = getExeceData(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, arrayDay, flag, data, type);
}
}
//周报
if ("week".endsWith(type)) {
//获取周的数组
String[] arrayDay = getArray(52);//获取周的数组,默认52周
for (ExtZfReportDayMedicalStatDO data : medicalStatDOList) {
flag = getExeceData(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, arrayDay, flag, data, type);
}
}
//月报
if ("month".endsWith(type)) {
//获取月的数组
String[] arrayDay = getArray(12);//获取周的数组,默认12周
for (ExtZfReportDayMedicalStatDO data : medicalStatDOList) {
flag = getExeceData(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, arrayDay, flag, data, type);
}
}
list.add(row1);
list.add(row2);
list.add(row3);
list.add(row4);
list.add(row5);
list.add(row6);
list.add(row7);
list.add(row8);
list.add(row9);
list.add(row10);
list.add(row11);
list.add(row12);
list.add(row13);
list.add(row14);
list.add(row15);
list.add(row16);
list.add(row17);
list.add(row18);
list.add(row19);
list.add(row20);
list.add(row21);
list.add(row22);
list.add(row23);
list.add(row24);
list.add(row25);
list.add(row26);
list.add(row27);
list.add(row28);
list.add(row29);
return list;
}
private static void setTotalData(List<String> row1, List<String> row2, List<String> row3, List<String> row4, List<String> row5, List<String> row6, List<String> row7, List<String> row8, List<String> row9, List<String> row10, List<String> row11, List<String> row12, List<String> row13, List<String> row14, List<String> row15, List<String> row16, List<String> row17, List<String> row18, List<String> row19, List<String> row20, List<String> row21, List<String> row22, List<String> row23, List<String> row24, List<String> row25, List<String> row26, List<String> row27, List<String> row28, List<String> row29, List<ExtZfReportDayMedicalStatDO> medicalStatDOList) {
/**总支付笔数*/
Integer payNumTotal = 0;
/**总支付金额*/
BigDecimal payAmtTotal = new BigDecimal("0.00");
/**扫码自费笔数*/
Integer qrSelfPayNumTotal = 0;
/**扫码自费金额*/
BigDecimal qrSelfPayAmtTotal = new BigDecimal("0.00");
/**扫码医保笔数*/
Integer qrSiPayNumTotal = 0;
/**医保总支付金额*/
BigDecimal qrSiPayAmtTotal = new BigDecimal("0.00");
/**扫码自费占比*/
BigDecimal qrSelfPercentTotal = new BigDecimal("0.00");
/**扫码医保占比*/
BigDecimal qrSiPercentTotal = new BigDecimal("0.00");
/**扫码付总比数*/
Integer qrPayNumTotal = 0;
/**扫码付总金额*/
BigDecimal qrPayAmtTotal = new BigDecimal("0.00");
/**扫码付占比*/
BigDecimal qrPayPercentTotal = new BigDecimal("0.00");
/**当面付自费笔数*/
Integer f2fSelfPayNumTotal = 0;
/**当面付自费金额*/
BigDecimal f2fSelfPayAmtTotal = new BigDecimal("0.00");
/**当面付医保笔数*/
Integer f2fSiPayNumTotal = 0;
/**当面付医保金额*/
BigDecimal f2fSiPayAmtTotal = new BigDecimal("0.00");
/**当面付自费占比*/
BigDecimal f2fSelfPercentTotal = new BigDecimal("0.00");
/**当面付以保占比*/
BigDecimal f2fSiPercentTotal = new BigDecimal("0.00");
/**当面付总比数*/
Integer f2fPayNumTotal = 0;
/**当面付总金额*/
BigDecimal f2fPayAmtTotal = new BigDecimal("0.00");
/**当面付占比*/
BigDecimal f2fPayPercentTotal = new BigDecimal("0.00");
/**其他方式自费笔数*/
Integer otherSelfPayNumTotal = 0;
/**其他方式自费金额*/
BigDecimal otherSelfPayAmtTotal = new BigDecimal("0.00");
/**其他方式医保笔数*/
Integer otherSiPayNumTotal = 0;
/**其他方式医保金额*/
BigDecimal otherSiPayAmtTotal = new BigDecimal("0.00");
/**其他方式自费占比*/
BigDecimal otherSelfPercentTotal = new BigDecimal("0.00");
/**其他方式医保占比*/
BigDecimal otherSiPercentTotal = new BigDecimal("0.00");
/**其他方式总笔数*/
Integer otherPayNumTotal = 0;
/**其他方式总金额*/
BigDecimal otherPayAmtToTal = new BigDecimal("0.00");
/**其他方式占比*/
BigDecimal otherPayPercentTotal = new BigDecimal("0.00");
for (ExtZfReportDayMedicalStatDO data : medicalStatDOList) {
payNumTotal = payNumTotal + data.getPayNum();//总支付笔数
payAmtTotal = payAmtTotal.add(data.getPayAmt());//总支付金额
qrPayNumTotal = qrPayNumTotal + data.getQrPayNum();//扫码付总笔数
qrPayAmtTotal = qrPayAmtTotal.add(data.getQrPayAmt());//扫码付总金额
f2fPayNumTotal = f2fPayNumTotal + data.getF2fPayNum(); //当面付总笔数
f2fPayAmtTotal = f2fPayAmtTotal.add(data.getF2fPayAmt());//当面付总金额
otherPayNumTotal = otherPayNumTotal + data.getOtherPayNum();//在线支付总笔数
otherPayAmtToTal = otherPayAmtToTal.add(data.getOtherPayAmt());//在线支付总金额
qrSelfPayNumTotal = qrSelfPayNumTotal + data.getQrSelfPayNum();//扫码付(自费)笔数
qrSelfPayAmtTotal = qrSelfPayAmtTotal.add(data.getQrSelfPayAmt());//扫码付(自费)金额
qrSiPayNumTotal = qrSiPayNumTotal + data.getQrSiPayNum();//扫码付(医保)笔数
qrSiPayAmtTotal = qrSiPayAmtTotal.add(data.getQrSiPayAmt());//扫码付(医保)金额
f2fSelfPayNumTotal = f2fSelfPayNumTotal + data.getF2fSelfPayNum();//当面付(自费)笔数
f2fSelfPayAmtTotal = f2fSelfPayAmtTotal.add(data.getF2fSelfPayAmt());//当面付(自费)金额
f2fSiPayNumTotal = f2fSiPayNumTotal + data.getF2fSiPayNum();//当面付(医保)笔数
f2fSiPayAmtTotal = f2fSiPayAmtTotal.add(data.getF2fSiPayAmt());//当面付(医保)金额
otherSelfPayNumTotal = otherSelfPayNumTotal + data.getOtherSelfPayNum();//在线支付(自费)笔数
otherSelfPayAmtTotal = otherSelfPayAmtTotal.add(data.getOtherSelfPayAmt());//在线支付(自费)金额
otherSiPayNumTotal = otherSiPayNumTotal + data.getOtherSiPayNum();//在线支付(医保)笔数
otherSiPayAmtTotal = otherSiPayAmtTotal.add(data.getOtherSiPayAmt());//在线支付(医保)金额
}
qrPayPercentTotal = qrPayAmtTotal.divide(payAmtTotal, 2, BigDecimal.ROUND_HALF_DOWN);//扫码付占比
f2fPayPercentTotal = f2fPayAmtTotal.divide(payAmtTotal, 2, BigDecimal.ROUND_HALF_DOWN);//当面付占比
otherPayPercentTotal = otherPayAmtToTal.divide(payAmtTotal, 2, BigDecimal.ROUND_HALF_DOWN);//在线支付占比
qrSelfPercentTotal = new BigDecimal(Double.valueOf(qrSelfPayNumTotal / payNumTotal));//扫码付(自费)占比
qrSiPercentTotal = new BigDecimal(qrSiPayNumTotal).divide(new BigDecimal(payNumTotal), 2, BigDecimal.ROUND_HALF_DOWN);//扫码付(医保)占比
f2fSelfPercentTotal = new BigDecimal(f2fSelfPayNumTotal).divide(new BigDecimal(payNumTotal), 2, BigDecimal.ROUND_HALF_DOWN);//当面付(自费)占比
f2fSiPercentTotal = new BigDecimal(f2fSiPayNumTotal).divide(new BigDecimal(payNumTotal), 2, BigDecimal.ROUND_HALF_DOWN);//当面付(医保)占比
otherSelfPercentTotal = new BigDecimal(otherSelfPayNumTotal).divide(new BigDecimal(payNumTotal), 2, BigDecimal.ROUND_HALF_DOWN);//在线支付(自费)占比
otherSiPercentTotal = new BigDecimal(otherSiPayNumTotal).divide(new BigDecimal(payNumTotal), 2, BigDecimal.ROUND_HALF_DOWN);//在线支付(医保)占比
row1.add(payNumTotal.toString());//支付总笔数
row2.add(payAmtTotal.toString());//支付总金额
row3.add(qrPayNumTotal.toString());//扫码付总笔数
row4.add(qrPayAmtTotal.toString());//扫码付总金额
row5.add(f2fPayNumTotal.toString());//当面付总笔数
row6.add(f2fPayAmtTotal.toString());//当面付总金额
row7.add(otherPayNumTotal.toString());//在线支付总笔数
row8.add(otherPayAmtToTal.toString());//在线支付总金额
row9.add(qrPayPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//扫码付占比
row10.add(f2fPayPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//当面付占比
row11.add(otherPayPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//在线支付占比
row12.add(qrSelfPayNumTotal.toString());//扫码付(自费)笔数
row13.add(qrSelfPayAmtTotal.toString());//扫码自费金额
row14.add(qrSiPayNumTotal.toString());//扫码医保笔数
row15.add(qrSiPayAmtTotal.toString());//扫码付(医保)金额
row16.add(f2fSelfPayNumTotal.toString());//当面付(自费)笔数
row17.add(f2fSelfPayAmtTotal.toString());//当面付(自费)金额
row18.add(f2fSiPayNumTotal.toString());//当面付(医保)笔数
row19.add(f2fSiPayAmtTotal.toString());//当面付(医保)金额
row20.add(otherSelfPayNumTotal.toString());//在线支付(自费)笔数
row21.add(otherSelfPayAmtTotal.toString());//在线支付(自费)金额
row22.add(otherSiPayNumTotal.toString());//在线支付(医保)笔数
row23.add(otherSiPayAmtTotal.toString());//在线支付(医保)金额
row24.add(qrSelfPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//扫码付(自费)占比
row25.add(qrSiPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//扫码付(医保)占比
row26.add(f2fSelfPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//当面付(自费)占比
row27.add(f2fSiPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//当面付(医保)占比
row28.add(otherSelfPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//在线支付(自费)占比
row29.add(otherSiPercentTotal.multiply(new BigDecimal("100")).toString()+"%");//在线支付(医保)占比
}
private static String getExeceData(List<String> row1, List<String> row2, List<String> row3, List<String> row4, List<String> row5, List<String> row6, List<String> row7, List<String> row8, List<String> row9, List<String> row10, List<String> row11, List<String> row12, List<String> row13, List<String> row14, List<String> row15, List<String> row16, List<String> row17, List<String> row18, List<String> row19, List<String> row20, List<String> row21, List<String> row22, List<String> row23, List<String> row24, List<String> row25, List<String> row26, List<String> row27, List<String> row28, List<String> row29, String[] arrayDay, String flag, ExtZfReportDayMedicalStatDO data, String type) {
for (int i = 1; i < arrayDay.length; i++) {
//第一次进来
if (StringUtils.isBlank(flag)) {
if ("day".equals(type)) {
//若果相等,设置数据
if (data.getAcctDay().endsWith(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getAcctDay().endsWith(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
}
}
if ("week".equals(type)) {
//若果相等,设置数据
if (data.getGroupWeek().equals(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getGroupWeek().equals(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
}
}
if ("month".equals(type)) {
//若果相等,设置数据
if (data.getGroupMonth().equals(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getGroupMonth().equals(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
}
}
}
if (StringUtils.isNotBlank(flag)) {
if ("day".equals(type)) {
if (flag == arrayDay[i]) {
//若果相等,设置数据
if (data.getAcctDay().endsWith(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getAcctDay().endsWith(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
flag = arrayDay[i + 1];
}
}
}
if ("week".equals(type)) {
if (flag == arrayDay[i]) {
//若果相等,设置数据
if (data.getGroupWeek().equals(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getGroupWeek().equals(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
flag = arrayDay[i + 1];
}
}
}
if ("month".equals(type)) {
if (flag == arrayDay[i]) {
//若果相等,设置数据
if (data.getGroupMonth().equals(arrayDay[i])) {
setDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29, data);
flag = arrayDay[i + 1];
break;
}
//若果不等,设置空数据
if (!(data.getGroupMonth().equals(arrayDay[i]))) {
setBlankDataTotal(row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20, row21, row22, row23, row24, row25, row26, row27, row28, row29);
flag = arrayDay[i + 1];
}
}
}
}
}
return flag;
}
public static void getDayReportTemplate(HttpServletRequest request, OutputStream out, List<List<String>> list) {
ExcelWriter excelWriter = new ExcelWriter(out, ExcelTypeEnum.XLSX);
// 表单
Sheet sheet = new Sheet(1, 0);
sheet.setSheetName("sheet1");
// 创建一个表格
Table table = new Table(1);
// 动态添加 表头 headList --> 所有表头行集合
List<List<String>> headList = new ArrayList<List<String>>();
// 第 n 行 的表头
List<String> headTitle0 = new ArrayList<String>();
List<String> headTitle1 = new ArrayList<String>();
List<String> headTitle2 = new ArrayList<String>();
List<String> headTitle3 = new ArrayList<String>();
List<String> headTitle4 = new ArrayList<String>();
List<String> headTitle5 = new ArrayList<String>();
List<String> headTitle6 = new ArrayList<String>();
List<String> headTitle7 = new ArrayList<String>();
List<String> headTitle8 = new ArrayList<String>();
List<String> headTitle9 = new ArrayList<String>();
List<String> headTitle10 = new ArrayList<String>();
List<String> headTitle11 = new ArrayList<String>();
List<String> headTitle12 = new ArrayList<String>();
List<String> headTitle13 = new ArrayList<String>();
List<String> headTitle14 = new ArrayList<String>();
List<String> headTitle15 = new ArrayList<String>();
List<String> headTitle16 = new ArrayList<String>();
List<String> headTitle17 = new ArrayList<String>();
List<String> headTitle18 = new ArrayList<String>();
List<String> headTitle19 = new ArrayList<String>();
List<String> headTitle20 = new ArrayList<String>();
List<String> headTitle21 = new ArrayList<String>();
List<String> headTitle22 = new ArrayList<String>();
List<String> headTitle23 = new ArrayList<String>();
List<String> headTitle24 = new ArrayList<String>();
List<String> headTitle25 = new ArrayList<String>();
List<String> headTitle26 = new ArrayList<String>();
List<String> headTitle27 = new ArrayList<String>();
List<String> headTitle28 = new ArrayList<String>();
List<String> headTitle29 = new ArrayList<String>();
List<String> headTitle30 = new ArrayList<String>();
List<String> headTitle31 = new ArrayList<String>();
List<String> headTitle32 = new ArrayList<String>();
String year = request.getParameter("year");
String month = request.getParameter("month");
StringBuffer sb = new StringBuffer();
sb.append(year).append("年").append(month).append("月").append("支付业务数据统计日报表");
headTitle0.add(sb.toString());
headTitle0.add("");
headTitle1.add(sb.toString());
headTitle1.add("合计");
headTitle2.add(sb.toString());
headTitle2.add(month + "月01日");
headTitle3.add(sb.toString());
headTitle3.add(month + "月02日");
headTitle4.add(sb.toString());
headTitle4.add(month + "月03日");
headTitle5.add(sb.toString());
headTitle5.add(month + "月04日");
headTitle6.add(sb.toString());
headTitle6.add(month + "月05日");
headTitle7.add(sb.toString());
headTitle7.add(month + "月06日");
headTitle8.add(sb.toString());
headTitle8.add(month + "月07日");
headTitle9.add(sb.toString());
headTitle9.add(month + "月08日");
headTitle10.add(sb.toString());
headTitle10.add(month + "月09日");
headTitle11.add(sb.toString());
headTitle11.add(month + "月10日");
headTitle12.add(sb.toString());
headTitle12.add(month + "月11日");
headTitle13.add(sb.toString());
headTitle13.add(month + "月12日");
headTitle14.add(sb.toString());
headTitle14.add(month + "月13日");
headTitle15.add(sb.toString());
headTitle15.add(month + "月14日");
headTitle16.add(sb.toString());
headTitle16.add(month + "月15日");
headTitle17.add(sb.toString());
headTitle17.add(month + "月16日");
headTitle18.add(sb.toString());
headTitle18.add(month + "月17日");
headTitle19.add(sb.toString());
headTitle19.add(month + "月18日");
headTitle20.add(sb.toString());
headTitle20.add(month + "月19日");
headTitle21.add(sb.toString());
headTitle21.add(month + "月20日");
headTitle22.add(sb.toString());
headTitle22.add(month + "月21日");
headTitle23.add(sb.toString());
headTitle23.add(month + "月22日");
headTitle24.add(sb.toString());
headTitle24.add(month + "月23日");
headTitle25.add(sb.toString());
headTitle25.add(month + "月24日");
headTitle26.add(sb.toString());
headTitle26.add(month + "月25日");
headTitle27.add(sb.toString());
headTitle27.add(month + "月26日");
headTitle28.add(sb.toString());
headTitle28.add(month + "月27日");
headTitle29.add(sb.toString());
headTitle29.add(month + "月28日");
headTitle30.add(sb.toString());
headTitle30.add(month + "月29日");
headTitle31.add(sb.toString());
headTitle31.add(month + "月30日");
headTitle32.add(sb.toString());
headTitle32.add(month + "月31日");
headList.add(headTitle0);
headList.add(headTitle1);
headList.add(headTitle2);
headList.add(headTitle3);
headList.add(headTitle4);
headList.add(headTitle5);
headList.add(headTitle6);
headList.add(headTitle7);
headList.add(headTitle8);
headList.add(headTitle9);
headList.add(headTitle10);
headList.add(headTitle11);
headList.add(headTitle12);
headList.add(headTitle13);
headList.add(headTitle14);
headList.add(headTitle15);
headList.add(headTitle16);
headList.add(headTitle17);
headList.add(headTitle18);
headList.add(headTitle19);
headList.add(headTitle20);
headList.add(headTitle21);
headList.add(headTitle22);
headList.add(headTitle23);
headList.add(headTitle24);
headList.add(headTitle25);
headList.add(headTitle26);
headList.add(headTitle27);
headList.add(headTitle28);
headList.add(headTitle29);
int dayNum = getDaysOfMonth(DateUtils.format(year + month, "yyyyMM"));
if (dayNum - 28 == 1) {
headList.add(headTitle30);
}
if (dayNum - 28 == 2) {
headList.add(headTitle30);
headList.add(headTitle31);
}
if (dayNum - 28 == 3) {
headList.add(headTitle30);
headList.add(headTitle31);
headList.add(headTitle32);
}
table.setHead(headList);
excelWriter.write0(list, sheet, table);
// 记得 释放资源
excelWriter.finish();
}
5.2、生成的Excel样例
5.3 机构区域日报统计报表(这比较复杂,合并列这一块还没处理好,有些代码写的比较死板,后续有时间再优化吧,哈哈)
5.3.1 代码示例
/**
* 机构日报数据汇总
* @param request
* @param response
* @throws IOException
*/
@RequestMapping("/mechanDayReportTotal")
public void mechanDayReportTotal(HttpServletRequest request, HttpServletResponse response) throws IOException {
String year = request.getParameter("year");
String month = request.getParameter("month");
String area = request.getParameter("area");
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(year + "年" + "区域机构支付数据统计日报表", "utf-8") + ".xlsx");
OutputStream out = response.getOutputStream();
//获取数据
ExtZfReportDayMedicalStatQuery query = new ExtZfReportDayMedicalStatQuery();
query.setGroupYear(year);
query.setGroupMonth(month);
if (StringUtils.isNotBlank(area)) {
query.setArea(area);
}
List<ExtMedicalStatDO> medicalStatDOS = medicalStatMapper.mechanDayReportTotal(query);
List<Object[]> dbRecs = new ArrayList<Object[]>();
//1.按区域拆分数据
//1.1遍历区域数组,与数据中的区域对比
for (int i = 0; i < areaArray.length; i++) {
//1.2统计当前区域有多少家医院
Set<String> hosSet = new HashSet<String>();
for (ExtMedicalStatDO data : medicalStatDOS) {
if (areaArray[i].equals(data.getArea())) {
hosSet.add(data.getParentMerId());
}
}
if (hosSet != null && hosSet.size() > 0) {
for (String hosStr : hosSet) {
//1.3统计当前区域,当前医院有多少家社康
Set<String> comSet = new HashSet<String>();
for (ExtMedicalStatDO data : medicalStatDOS) {
if (areaArray[i].equals(data.getArea())) {
if (hosStr.equals(data.getParentMerId())) {
comSet.add(data.getMerId());
}
}
}
List<ExtMedicalStatDO> medicalList = new ArrayList<ExtMedicalStatDO>();
//1.4 当前区域,当前医院,当前社康数据处理(当前区域,第一家医院,第一家社康数据处理)
for (ExtMedicalStatDO data : medicalStatDOS) {
if (areaArray[i].equals(data.getArea())) {
//当前医院
if (hosStr.equals(data.getParentMerId())) {
if (comSet != null && comSet.size() > 0) {
//当前社康(追个遍历)
for (String comStr : comSet) {
if (comStr.equals(data.getMerId())) {
logger.info("医院id:{},社康id:{},社康数据:{}", hosStr, comStr, JSON.toJSON(data));
medicalList.add(data);
}
}
}
}
}
}
logger.info("总数据:{}", JSON.toJSONString(medicalList));
//填充数据
for (int j = 0; j < statisticArray.length; j++) {
List<ExtMechanDayReportStatDO> mechanDataList = new ArrayList<ExtMechanDayReportStatDO>();
ExtMechanDayReportStatDO statDO1 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO2 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO3 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO4 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO5 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO6 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO7 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO8 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO9 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO10 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO11 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO12 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO13 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO14 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO15 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO16 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO17 = new ExtMechanDayReportStatDO();
ExtMechanDayReportStatDO statDO18 = new ExtMechanDayReportStatDO();
//计算当前月有多少天
int dayNum = EasyExcelUtils.getDaysOfMonth(DateUtils.format(year + month, "yyyyMM"));
String[] arrayDay = EasyExcelUtils.getArray(dayNum);//获取天的数组
String flag = "";
for (ExtMedicalStatDO medicalData : medicalList) {
//设置区域、设置医院名称、设置社康名称、设置开通时间
EasyExcelUtils.setMechanDayReportHead(statDO1, statDO2, statDO3, statDO4, statDO5, statDO6, statDO7, statDO8, statDO9, statDO10, statDO11, statDO12, statDO13, statDO14, statDO15, statDO16, statDO17, statDO18, medicalData,tyPubSysCodeService);
//设置数据
EasyExcelUtils.setmerchanDayData(statDO1, statDO2, statDO3, statDO4, statDO5, statDO6, statDO7, statDO8, statDO9, statDO10, statDO11, statDO12, statDO13, statDO14, statDO15, statDO16, statDO17, statDO18, medicalData);
}
//计算合计列
Integer qrPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO1);//扫码付(总)笔数
BigDecimal qrPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO2);//扫码付(总)金额
Integer f2fPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO3);//当面付(总)笔数
BigDecimal f2fPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO4);//当面付(总)金额
Integer otherPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO5);//在线付(总)笔数
BigDecimal otherPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO6);//在线付(总)金额
Integer qrSelfPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO7);//扫码付(自费)笔数
BigDecimal qrSelfPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO8);//扫码付(自费)金额
Integer qrSiPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO9);//扫码付(医保)笔数
BigDecimal qrSiPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO10);//扫码付(医保)金额
Integer f2fSelfPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO11);//当面付(自费)笔数
BigDecimal f2fSelfPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO12);//当面付(自费)金额
Integer f2fSiPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO13);//当面付(医保)笔数
BigDecimal f2fSiPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO14);//当面付(医保)金额
Integer otherSelfPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO15);//在线支付(自费)笔数
BigDecimal otherSelfPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO16);//在线支付(自费)金额
Integer otherSiPayNumTotal = EasyExcelUtils.getpayNumTotal(statDO17);//在线支付(自费)笔数
BigDecimal otherSiPayAmtTotal= EasyExcelUtils.getPayAmtTotal(statDO18);//在线支付(自费)金额
statDO1.setTotal(String.valueOf(qrPayNumTotal));
statDO2.setTotal(qrPayAmtTotal.toString());
statDO3.setTotal(String.valueOf(f2fPayNumTotal));
statDO4.setTotal(f2fPayAmtTotal.toString());
statDO5.setTotal(String.valueOf(otherPayNumTotal));
statDO6.setTotal(otherPayAmtTotal.toString());
statDO7.setTotal(String.valueOf(qrSelfPayNumTotal));
statDO8.setTotal(qrSelfPayAmtTotal.toString());
statDO9.setTotal(String.valueOf(qrSiPayNumTotal));
statDO10.setTotal(qrSiPayAmtTotal.toString());
statDO11.setTotal(String.valueOf(f2fSelfPayNumTotal));
statDO12.setTotal(f2fSelfPayAmtTotal.toString());
statDO13.setTotal(String.valueOf(f2fSiPayNumTotal));
statDO14.setTotal(f2fSiPayAmtTotal.toString());
statDO15.setTotal(String.valueOf(otherSelfPayNumTotal));
statDO16.setTotal(otherSelfPayAmtTotal.toString());
statDO17.setTotal(String.valueOf(otherSiPayNumTotal));
statDO18.setTotal(otherSiPayAmtTotal.toString());
mechanDataList.add(statDO1);
mechanDataList.add(statDO2);
mechanDataList.add(statDO3);
mechanDataList.add(statDO4);
mechanDataList.add(statDO5);
mechanDataList.add(statDO6);
mechanDataList.add(statDO7);
mechanDataList.add(statDO8);
mechanDataList.add(statDO9);
mechanDataList.add(statDO10);
mechanDataList.add(statDO11);
mechanDataList.add(statDO12);
mechanDataList.add(statDO13);
mechanDataList.add(statDO14);
mechanDataList.add(statDO15);
mechanDataList.add(statDO16);
mechanDataList.add(statDO17);
mechanDataList.add(statDO18);
if (mechanDataList != null && mechanDataList.size()>0){
ExtMechanDayReportStatDO dayReportStatDO = mechanDataList.get(j);
Object[] dbRec = new Object[]{
dayReportStatDO.getArea(),dayReportStatDO.getParentName() , dayReportStatDO.getSubName(), dayReportStatDO.getOpenTime(), statisticArray[j], dayReportStatDO.getTotal(), dayReportStatDO.getOneDay(), dayReportStatDO.getTwoDay(), dayReportStatDO.getThreeDay(), dayReportStatDO.getFourDay(),
dayReportStatDO.getFiveDay(), dayReportStatDO.getSixDay(),dayReportStatDO.getSevenDay(), dayReportStatDO.getEightDay(), dayReportStatDO.getNineDay(), dayReportStatDO.getTenDay(),dayReportStatDO.getElevenDay(), dayReportStatDO.getTwelveDay(),dayReportStatDO.getThirteenDay(),dayReportStatDO.getFourteenDay(),
dayReportStatDO.getFifteenDay(),dayReportStatDO.getSixteenDay(),dayReportStatDO.getSeventeenDay(),dayReportStatDO.getEighteenDay(),dayReportStatDO.getNineteenDay(),dayReportStatDO.getTwentyDay(),dayReportStatDO.getTwentyOneDay(),dayReportStatDO.getTwentyTwoDay(),dayReportStatDO.getTwentyThreeDay(),dayReportStatDO.getTwentyFourDay(),
dayReportStatDO.getTwentyFiveDay(),dayReportStatDO.getTwentySixDay(),dayReportStatDO.getTwentySevenDay(),dayReportStatDO.getTwentyEigntDay(),dayReportStatDO.getTwentyNineDay(),dayReportStatDO.getThirtyDay(),dayReportStatDO.getThirtyOneDay()
};
dbRecs.add(dbRec);
}
}
}
}
}
String topTitles = year+"年"+month+"月区机构付数据统计日报表";
List<String> titles = new ArrayList<String>();
titles.add("区域");
titles.add("所属医院");
titles.add("社康名称");
titles.add("开通时间");
titles.add("支付类型");
titles.add("合计");
titles.add("1日");
titles.add("2日");
titles.add("3日");
titles.add("4日");
titles.add("5日");
titles.add("6日");
titles.add("7日");
titles.add("8日");
titles.add("9日");
titles.add("10日");
titles.add("11日");
titles.add("12日");
titles.add("13日");
titles.add("14日");
titles.add("15日");
titles.add("16日");
titles.add("17日");
titles.add("18日");
titles.add("19日");
titles.add("20日");
titles.add("21日");
titles.add("22日");
titles.add("23日");
titles.add("24日");
titles.add("25日");
titles.add("26日");
titles.add("27日");
titles.add("28日");
int dayNum = EasyExcelUtils.getDaysOfMonth(DateUtils.format(year + month, "yyyyMM"));
if (dayNum - 28 == 1) {
titles.add("29日");
}
if (dayNum - 28 == 2) {
titles.add("29日");
titles.add("30日");
}
if (dayNum - 28 == 3) {
titles.add("29日");
titles.add("30日");
titles.add("31日");
}
//数据集合
List<List<Object>> rowData = new ArrayList<List<Object>>();
for (int i=0;i<dbRecs.size();i++) {
List<Object> _row = new ArrayList<Object>();
Object[] row = dbRecs.get(i);
for (Object cell : row) {
_row.add(cell);
}
rowData.add(_row);
}
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFCellStyle style = workbook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
DataFormat format = workbook.createDataFormat();
HSSFSheet sheet = workbook.createSheet("统计报表");
HSSFFont font = workbook.createFont();
font.setFontHeightInPoints((short) 20); //字体高度
font.setColor(HSSFFont.COLOR_NORMAL); //字体颜色
font.setFontName("黑体"); //字体
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //宽度
font.setItalic(false); //是否使用斜体
//top标题
HSSFRow row0 = sheet.createRow(0);
HSSFCell cell_00 = row0.createCell(0);
cell_00.setCellStyle(style);
cell_00.setCellValue(topTitles);
//子标题
HSSFRow row1 = sheet.createRow(1);
for (int i = 0;i<titles.size();i++) {
HSSFCell cell = row1.createCell(i);
cell.setCellStyle(style);
cell.setCellValue(titles.get(i));
}
//合并top标题单元格
CellRangeAddress region1 = new CellRangeAddress(0, 0, 0, dayNum+6);
sheet.addMergedRegion(region1);
//数据区
for (int i = 0;i<rowData.size();i++) {
HSSFRow row = sheet.createRow(2+i);
for (int j=0;j<rowData.get(i).size();j++) {
HSSFCell cell = row.createCell(j);
cell.setCellStyle(style);
if (rowData.get(i).get(j) instanceof String) {
String v = (String)rowData.get(i).get(j);
cell.setCellValue(v);
} else if (rowData.get(i).get(j) instanceof Date) {
style.setDataFormat(format.getFormat("yyyy年m月d日"));
Date v = (Date)rowData.get(i).get(j);
cell.setCellStyle(style);
cell.setCellValue(v);
} else if (rowData.get(i).get(j) instanceof BigDecimal) {
style.setDataFormat(format.getFormat("0.00"));
BigDecimal v = (BigDecimal)rowData.get(i).get(j);
cell.setCellStyle(style);
cell.setCellValue(v.doubleValue());
}
}
}
/* //合并数据区-地区
CellRangeAddress region2 = new CellRangeAddress(2, 19, 0, 0);
sheet.addMergedRegion(region2);
//合并数据区-医院
CellRangeAddress region3 = new CellRangeAddress(2, 19, 1, 1);
sheet.addMergedRegion(region3);
//合并数据区-社康
CellRangeAddress region4 = new CellRangeAddress(2, 19, 2, 2);
sheet.addMergedRegion(region4);
//合并数据区-时间
CellRangeAddress region5 = new CellRangeAddress(2, 19, 3, 3);
sheet.addMergedRegion(region5);*/
workbook.write(out);
out.close();
}
public static void setMechanDayReportHead(ExtMechanDayReportStatDO statDO1, ExtMechanDayReportStatDO statDO2, ExtMechanDayReportStatDO statDO3, ExtMechanDayReportStatDO statDO4, ExtMechanDayReportStatDO statDO5, ExtMechanDayReportStatDO statDO6, ExtMechanDayReportStatDO statDO7, ExtMechanDayReportStatDO statDO8, ExtMechanDayReportStatDO statDO9, ExtMechanDayReportStatDO statDO10, ExtMechanDayReportStatDO statDO11, ExtMechanDayReportStatDO statDO12, ExtMechanDayReportStatDO statDO13, ExtMechanDayReportStatDO statDO14, ExtMechanDayReportStatDO statDO15, ExtMechanDayReportStatDO statDO16, ExtMechanDayReportStatDO statDO17, ExtMechanDayReportStatDO statDO18, ExtMedicalStatDO medicalData,TyPubSysCodeService tyPubSysCodeService) {
//设置区域
String area = tyPubSysCodeService.getCodeName("ZF_REPORT_DAY_MEDICAL_STAT_AREA",medicalData.getArea());;
statDO1.setArea(area);
statDO2.setArea(area);
statDO3.setArea(area);
statDO4.setArea(area);
statDO5.setArea(area);
statDO6.setArea(area);
statDO7.setArea(area);
statDO8.setArea(area);
statDO9.setArea(area);
statDO10.setArea(area);
statDO11.setArea(area);
statDO12.setArea(area);
statDO13.setArea(area);
statDO14.setArea(area);
statDO15.setArea(area);
statDO16.setArea(area);
statDO17.setArea(area);
statDO18.setArea(area);
//设置医院名称
statDO1.setParentName(medicalData.getParentName());
statDO2.setParentName(medicalData.getParentName());
statDO3.setParentName(medicalData.getParentName());
statDO4.setParentName(medicalData.getParentName());
statDO5.setParentName(medicalData.getParentName());
statDO6.setParentName(medicalData.getParentName());
statDO7.setParentName(medicalData.getParentName());
statDO8.setParentName(medicalData.getParentName());
statDO9.setParentName(medicalData.getParentName());
statDO10.setParentName(medicalData.getParentName());
statDO11.setParentName(medicalData.getParentName());
statDO12.setParentName(medicalData.getParentName());
statDO13.setParentName(medicalData.getParentName());
statDO14.setParentName(medicalData.getParentName());
statDO15.setParentName(medicalData.getParentName());
statDO16.setParentName(medicalData.getParentName());
statDO17.setParentName(medicalData.getParentName());
statDO18.setParentName(medicalData.getParentName());
//设置社康名称
statDO1.setSubName(medicalData.getSubName());
statDO2.setSubName(medicalData.getSubName());
statDO3.setSubName(medicalData.getSubName());
statDO4.setSubName(medicalData.getSubName());
statDO5.setSubName(medicalData.getSubName());
statDO6.setSubName(medicalData.getSubName());
statDO7.setSubName(medicalData.getSubName());
statDO8.setSubName(medicalData.getSubName());
statDO9.setSubName(medicalData.getSubName());
statDO10.setSubName(medicalData.getSubName());
statDO11.setSubName(medicalData.getSubName());
statDO12.setSubName(medicalData.getSubName());
statDO13.setSubName(medicalData.getSubName());
statDO14.setSubName(medicalData.getSubName());
statDO15.setSubName(medicalData.getSubName());
statDO16.setSubName(medicalData.getSubName());
statDO17.setSubName(medicalData.getSubName());
statDO18.setSubName(medicalData.getSubName());
//设置开通时间
statDO1.setOpenTime(medicalData.getOpenTime());
statDO2.setOpenTime(medicalData.getOpenTime());
statDO3.setOpenTime(medicalData.getOpenTime());
statDO4.setOpenTime(medicalData.getOpenTime());
statDO5.setOpenTime(medicalData.getOpenTime());
statDO6.setOpenTime(medicalData.getOpenTime());
statDO7.setOpenTime(medicalData.getOpenTime());
statDO8.setOpenTime(medicalData.getOpenTime());
statDO9.setOpenTime(medicalData.getOpenTime());
statDO10.setOpenTime(medicalData.getOpenTime());
statDO11.setOpenTime(medicalData.getOpenTime());
statDO12.setOpenTime(medicalData.getOpenTime());
statDO13.setOpenTime(medicalData.getOpenTime());
statDO14.setOpenTime(medicalData.getOpenTime());
statDO15.setOpenTime(medicalData.getOpenTime());
statDO16.setOpenTime(medicalData.getOpenTime());
statDO17.setOpenTime(medicalData.getOpenTime());
statDO18.setOpenTime(medicalData.getOpenTime());
}
//设置机构部日报数据
public static void setmerchanDayData(ExtMechanDayReportStatDO statDO1, ExtMechanDayReportStatDO statDO2, ExtMechanDayReportStatDO statDO3, ExtMechanDayReportStatDO statDO4, ExtMechanDayReportStatDO statDO5, ExtMechanDayReportStatDO statDO6, ExtMechanDayReportStatDO statDO7, ExtMechanDayReportStatDO statDO8, ExtMechanDayReportStatDO statDO9, ExtMechanDayReportStatDO statDO10, ExtMechanDayReportStatDO statDO11, ExtMechanDayReportStatDO statDO12, ExtMechanDayReportStatDO statDO13, ExtMechanDayReportStatDO statDO14, ExtMechanDayReportStatDO statDO15, ExtMechanDayReportStatDO statDO16, ExtMechanDayReportStatDO statDO17, ExtMechanDayReportStatDO statDO18, ExtMedicalStatDO medicalData) {
if (medicalData.getAcctDay().endsWith("01")){
statDO1.setOneDay(medicalData.getQrPayNum().toString());
statDO2.setOneDay(medicalData.getQrPayAmt().toString());
statDO3.setOneDay(medicalData.getF2fPayNum().toString());
statDO4.setOneDay(medicalData.getF2fPayAmt().toString());
statDO5.setOneDay(medicalData.getOtherPayNum().toString());
statDO6.setOneDay(medicalData.getOtherPayAmt().toString());
statDO7.setOneDay(medicalData.getQrSelfPayNum().toString());
statDO8.setOneDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setOneDay(medicalData.getQrSiPayNum().toString());
statDO10.setOneDay(medicalData.getQrSiPayAmt().toString());
statDO11.setOneDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setOneDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setOneDay(medicalData.getF2fSiPayNum().toString());
statDO14.setOneDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setOneDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setOneDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setOneDay(medicalData.getOtherSiPayNum().toString());
statDO18.setOneDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("02")){
statDO1.setTwoDay(medicalData.getQrPayNum().toString());
statDO2.setTwoDay(medicalData.getQrPayAmt().toString());
statDO3.setTwoDay(medicalData.getF2fPayNum().toString());
statDO4.setTwoDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwoDay(medicalData.getOtherPayNum().toString());
statDO6.setTwoDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwoDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwoDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwoDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwoDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwoDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwoDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwoDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwoDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwoDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwoDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwoDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwoDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("03")){
statDO1.setThreeDay(medicalData.getQrPayNum().toString());
statDO2.setThreeDay(medicalData.getQrPayAmt().toString());
statDO3.setThreeDay(medicalData.getF2fPayNum().toString());
statDO4.setThreeDay(medicalData.getF2fPayAmt().toString());
statDO5.setThreeDay(medicalData.getOtherPayNum().toString());
statDO6.setThreeDay(medicalData.getOtherPayAmt().toString());
statDO7.setThreeDay(medicalData.getQrSelfPayNum().toString());
statDO8.setThreeDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setThreeDay(medicalData.getQrSiPayNum().toString());
statDO10.setThreeDay(medicalData.getQrSiPayAmt().toString());
statDO11.setThreeDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setThreeDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setThreeDay(medicalData.getF2fSiPayNum().toString());
statDO14.setThreeDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setThreeDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setThreeDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setThreeDay(medicalData.getOtherSiPayNum().toString());
statDO18.setThreeDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("04")){
statDO1.setFourDay(medicalData.getQrPayNum().toString());
statDO2.setFourDay(medicalData.getQrPayAmt().toString());
statDO3.setFourDay(medicalData.getF2fPayNum().toString());
statDO4.setFourDay(medicalData.getF2fPayAmt().toString());
statDO5.setFourDay(medicalData.getOtherPayNum().toString());
statDO6.setFourDay(medicalData.getOtherPayAmt().toString());
statDO7.setFourDay(medicalData.getQrSelfPayNum().toString());
statDO8.setFourDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setFourDay(medicalData.getQrSiPayNum().toString());
statDO10.setFourDay(medicalData.getQrSiPayAmt().toString());
statDO11.setFourDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setFourDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setFourDay(medicalData.getF2fSiPayNum().toString());
statDO14.setFourDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setFourDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setFourDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setFourDay(medicalData.getOtherSiPayNum().toString());
statDO18.setFourDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("05")){
statDO1.setFiveDay(medicalData.getQrPayNum().toString());
statDO2.setFiveDay(medicalData.getQrPayAmt().toString());
statDO3.setFiveDay(medicalData.getF2fPayNum().toString());
statDO4.setFiveDay(medicalData.getF2fPayAmt().toString());
statDO5.setFiveDay(medicalData.getOtherPayNum().toString());
statDO6.setFiveDay(medicalData.getOtherPayAmt().toString());
statDO7.setFiveDay(medicalData.getQrSelfPayNum().toString());
statDO8.setFiveDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setFiveDay(medicalData.getQrSiPayNum().toString());
statDO10.setFiveDay(medicalData.getQrSiPayAmt().toString());
statDO11.setFiveDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setFiveDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setFiveDay(medicalData.getF2fSiPayNum().toString());
statDO14.setFiveDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setFiveDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setFiveDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setFiveDay(medicalData.getOtherSiPayNum().toString());
statDO18.setFiveDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("06")){
statDO1.setSixDay(medicalData.getQrPayNum().toString());
statDO2.setSixDay(medicalData.getQrPayAmt().toString());
statDO3.setSixDay(medicalData.getF2fPayNum().toString());
statDO4.setSixDay(medicalData.getF2fPayAmt().toString());
statDO5.setSixDay(medicalData.getOtherPayNum().toString());
statDO6.setSixDay(medicalData.getOtherPayAmt().toString());
statDO7.setSixDay(medicalData.getQrSelfPayNum().toString());
statDO8.setSixDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setSixDay(medicalData.getQrSiPayNum().toString());
statDO10.setSixDay(medicalData.getQrSiPayAmt().toString());
statDO11.setSixDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setSixDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setSixDay(medicalData.getF2fSiPayNum().toString());
statDO14.setSixDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setSixDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setSixDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setSixDay(medicalData.getOtherSiPayNum().toString());
statDO18.setSixDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("07")){
statDO1.setSevenDay(medicalData.getQrPayNum().toString());
statDO2.setSevenDay(medicalData.getQrPayAmt().toString());
statDO3.setSevenDay(medicalData.getF2fPayNum().toString());
statDO4.setSevenDay(medicalData.getF2fPayAmt().toString());
statDO5.setSevenDay(medicalData.getOtherPayNum().toString());
statDO6.setSevenDay(medicalData.getOtherPayAmt().toString());
statDO7.setSevenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setSevenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setSevenDay(medicalData.getQrSiPayNum().toString());
statDO10.setSevenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setSevenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setSevenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setSevenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setSevenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setSevenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setSevenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setSevenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setSevenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("08")){
statDO1.setEightDay(medicalData.getQrPayNum().toString());
statDO2.setEightDay(medicalData.getQrPayAmt().toString());
statDO3.setEightDay(medicalData.getF2fPayNum().toString());
statDO4.setEightDay(medicalData.getF2fPayAmt().toString());
statDO5.setEightDay(medicalData.getOtherPayNum().toString());
statDO6.setEightDay(medicalData.getOtherPayAmt().toString());
statDO7.setEightDay(medicalData.getQrSelfPayNum().toString());
statDO8.setEightDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setEightDay(medicalData.getQrSiPayNum().toString());
statDO10.setEightDay(medicalData.getQrSiPayAmt().toString());
statDO11.setEightDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setEightDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setEightDay(medicalData.getF2fSiPayNum().toString());
statDO14.setEightDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setEightDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setEightDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setEightDay(medicalData.getOtherSiPayNum().toString());
statDO18.setEightDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("09")){
statDO1.setNineDay(medicalData.getQrPayNum().toString());
statDO2.setNineDay(medicalData.getQrPayAmt().toString());
statDO3.setNineDay(medicalData.getF2fPayNum().toString());
statDO4.setNineDay(medicalData.getF2fPayAmt().toString());
statDO5.setNineDay(medicalData.getOtherPayNum().toString());
statDO6.setNineDay(medicalData.getOtherPayAmt().toString());
statDO7.setNineDay(medicalData.getQrSelfPayNum().toString());
statDO8.setNineDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setNineDay(medicalData.getQrSiPayNum().toString());
statDO10.setNineDay(medicalData.getQrSiPayAmt().toString());
statDO11.setNineDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setNineDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setNineDay(medicalData.getF2fSiPayNum().toString());
statDO14.setNineDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setNineDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setNineDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setNineDay(medicalData.getOtherSiPayNum().toString());
statDO18.setNineDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("10")){
statDO1.setTenDay(medicalData.getQrPayNum().toString());
statDO2.setTenDay(medicalData.getQrPayAmt().toString());
statDO3.setTenDay(medicalData.getF2fPayNum().toString());
statDO4.setTenDay(medicalData.getF2fPayAmt().toString());
statDO5.setTenDay(medicalData.getOtherPayNum().toString());
statDO6.setTenDay(medicalData.getOtherPayAmt().toString());
statDO7.setTenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTenDay(medicalData.getQrSiPayNum().toString());
statDO10.setTenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("11")){
statDO1.setElevenDay(medicalData.getQrPayNum().toString());
statDO2.setElevenDay(medicalData.getQrPayAmt().toString());
statDO3.setElevenDay(medicalData.getF2fPayNum().toString());
statDO4.setElevenDay(medicalData.getF2fPayAmt().toString());
statDO5.setElevenDay(medicalData.getOtherPayNum().toString());
statDO6.setElevenDay(medicalData.getOtherPayAmt().toString());
statDO7.setElevenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setElevenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setElevenDay(medicalData.getQrSiPayNum().toString());
statDO10.setElevenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setElevenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setElevenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setElevenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setElevenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setElevenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setElevenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setElevenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setElevenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("12")){
statDO1.setTwelveDay(medicalData.getQrPayNum().toString());
statDO2.setTwelveDay(medicalData.getQrPayAmt().toString());
statDO3.setTwelveDay(medicalData.getF2fPayNum().toString());
statDO4.setTwelveDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwelveDay(medicalData.getOtherPayNum().toString());
statDO6.setTwelveDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwelveDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwelveDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwelveDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwelveDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwelveDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwelveDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwelveDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwelveDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwelveDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwelveDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwelveDay(medicalData.getOtherSiPayNum().toString());
}
if (medicalData.getAcctDay().endsWith("13")){
statDO1.setThirteenDay(medicalData.getQrPayNum().toString());
statDO2.setThirteenDay(medicalData.getQrPayAmt().toString());
statDO3.setThirteenDay(medicalData.getF2fPayNum().toString());
statDO4.setThirteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setThirteenDay(medicalData.getOtherPayNum().toString());
statDO6.setThirteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setThirteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setThirteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setThirteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setThirteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setThirteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setThirteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setThirteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setThirteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setThirteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setThirteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setThirteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setThirteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("14")){
statDO1.setFourteenDay(medicalData.getQrPayNum().toString());
statDO2.setFourteenDay(medicalData.getQrPayAmt().toString());
statDO3.setFourteenDay(medicalData.getF2fPayNum().toString());
statDO4.setFourteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setFourteenDay(medicalData.getOtherPayNum().toString());
statDO6.setFourteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setFourteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setFourteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setFourteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setFourteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setFourteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setFourteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setFourteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setFourteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setFourteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setFourteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setFourteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setFourteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("15")){
statDO1.setFifteenDay(medicalData.getQrPayNum().toString());
statDO2.setFifteenDay(medicalData.getQrPayAmt().toString());
statDO3.setFifteenDay(medicalData.getF2fPayNum().toString());
statDO4.setFifteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setFifteenDay(medicalData.getOtherPayNum().toString());
statDO6.setFifteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setFifteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setFifteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setFifteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setFifteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setFifteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setFifteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setFifteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setFifteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setFifteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setFifteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setFifteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setFifteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("16")){
statDO1.setSixteenDay(medicalData.getQrPayNum().toString());
statDO2.setSixteenDay(medicalData.getQrPayAmt().toString());
statDO3.setSixteenDay(medicalData.getF2fPayNum().toString());
statDO4.setSixteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setSixteenDay(medicalData.getOtherPayNum().toString());
statDO6.setSixteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setSixteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setSixteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setSixteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setSixteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setSixteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setSixteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setSixteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setSixteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setSixteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setSixteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setSixteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setSixteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("17")){
statDO1.setSeventeenDay(medicalData.getQrPayNum().toString());
statDO2.setSeventeenDay(medicalData.getQrPayAmt().toString());
statDO3.setSeventeenDay(medicalData.getF2fPayNum().toString());
statDO4.setSeventeenDay(medicalData.getF2fPayAmt().toString());
statDO5.setSeventeenDay(medicalData.getOtherPayNum().toString());
statDO6.setSeventeenDay(medicalData.getOtherPayAmt().toString());
statDO7.setSeventeenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setSeventeenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setSeventeenDay(medicalData.getQrSiPayNum().toString());
statDO10.setSeventeenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setSeventeenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setSeventeenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setSeventeenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setSeventeenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setSeventeenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setSeventeenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setSeventeenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setSeventeenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("18")){
statDO1.setEighteenDay(medicalData.getQrPayNum().toString());
statDO2.setEighteenDay(medicalData.getQrPayAmt().toString());
statDO3.setEighteenDay(medicalData.getF2fPayNum().toString());
statDO4.setEighteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setEighteenDay(medicalData.getOtherPayNum().toString());
statDO6.setEighteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setEighteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setEighteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setEighteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setEighteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setEighteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setEighteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setEighteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setEighteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setEighteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setEighteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setEighteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setEighteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("19")){
statDO1.setNineteenDay(medicalData.getQrPayNum().toString());
statDO2.setNineteenDay(medicalData.getQrPayAmt().toString());
statDO3.setNineteenDay(medicalData.getF2fPayNum().toString());
statDO4.setNineteenDay(medicalData.getF2fPayAmt().toString());
statDO5.setNineteenDay(medicalData.getOtherPayNum().toString());
statDO6.setNineteenDay(medicalData.getOtherPayAmt().toString());
statDO7.setNineteenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setNineteenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setNineteenDay(medicalData.getQrSiPayNum().toString());
statDO10.setNineteenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setNineteenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setNineteenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setNineteenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setNineteenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setNineteenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setNineteenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setNineteenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setNineteenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("20")){
statDO1.setTwentyDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("21")){
statDO1.setTwentyOneDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyOneDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyOneDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyOneDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyOneDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyOneDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyOneDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyOneDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyOneDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyOneDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyOneDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyOneDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyOneDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyOneDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyOneDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyOneDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyOneDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyOneDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("22")){
statDO1.setTwentyTwoDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyTwoDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyTwoDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyTwoDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyTwoDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyTwoDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyTwoDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyTwoDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyTwoDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyTwoDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyTwoDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyTwoDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyTwoDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyTwoDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyTwoDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyTwoDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyTwoDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyTwoDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("23")){
statDO1.setTwentyThreeDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyThreeDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyThreeDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyThreeDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyThreeDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyThreeDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyThreeDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyThreeDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyThreeDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyThreeDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyThreeDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyThreeDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyThreeDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyThreeDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyThreeDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyThreeDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyThreeDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyThreeDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("24")){
statDO1.setTwentyFourDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyFourDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyFourDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyFourDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyFourDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyFourDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyFourDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyFourDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyFourDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyFourDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyFourDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyFourDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyFourDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyFourDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyFourDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyFourDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyFourDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyFourDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("25")){
statDO1.setTwentyFiveDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyFiveDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyFiveDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyFiveDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyFiveDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyFiveDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyFiveDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyFiveDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyFiveDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyFiveDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyFiveDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyFiveDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyFiveDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyFiveDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyFiveDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyFiveDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyFiveDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyFiveDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("26")){
statDO1.setTwentySixDay(medicalData.getQrPayNum().toString());
statDO2.setTwentySixDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentySixDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentySixDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentySixDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentySixDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentySixDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentySixDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentySixDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentySixDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentySixDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentySixDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentySixDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentySixDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentySixDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentySixDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentySixDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentySixDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("27")){
statDO1.setTwentySevenDay(medicalData.getQrPayNum().toString());
statDO2.setTwentySevenDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentySevenDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentySevenDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentySevenDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentySevenDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentySevenDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentySevenDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentySevenDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentySevenDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentySevenDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentySevenDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentySevenDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentySevenDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentySevenDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentySevenDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentySevenDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentySevenDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("28")){
statDO1.setTwentyEigntDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyEigntDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyEigntDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyEigntDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyEigntDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyEigntDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyEigntDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyEigntDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyEigntDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyEigntDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyEigntDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyEigntDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyEigntDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyEigntDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyEigntDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyEigntDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyEigntDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyEigntDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("29")){
statDO1.setTwentyNineDay(medicalData.getQrPayNum().toString());
statDO2.setTwentyNineDay(medicalData.getQrPayAmt().toString());
statDO3.setTwentyNineDay(medicalData.getF2fPayNum().toString());
statDO4.setTwentyNineDay(medicalData.getF2fPayAmt().toString());
statDO5.setTwentyNineDay(medicalData.getOtherPayNum().toString());
statDO6.setTwentyNineDay(medicalData.getOtherPayAmt().toString());
statDO7.setTwentyNineDay(medicalData.getQrSelfPayNum().toString());
statDO8.setTwentyNineDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setTwentyNineDay(medicalData.getQrSiPayNum().toString());
statDO10.setTwentyNineDay(medicalData.getQrSiPayAmt().toString());
statDO11.setTwentyNineDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setTwentyNineDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setTwentyNineDay(medicalData.getF2fSiPayNum().toString());
statDO14.setTwentyNineDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setTwentyNineDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setTwentyNineDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setTwentyNineDay(medicalData.getOtherSiPayNum().toString());
statDO18.setTwentyNineDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("30")){
statDO1.setThirtyDay(medicalData.getQrPayNum().toString());
statDO2.setThirtyDay(medicalData.getQrPayAmt().toString());
statDO3.setThirtyDay(medicalData.getF2fPayNum().toString());
statDO4.setThirtyDay(medicalData.getF2fPayAmt().toString());
statDO5.setThirtyDay(medicalData.getOtherPayNum().toString());
statDO6.setThirtyDay(medicalData.getOtherPayAmt().toString());
statDO7.setThirtyDay(medicalData.getQrSelfPayNum().toString());
statDO8.setThirtyDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setThirtyDay(medicalData.getQrSiPayNum().toString());
statDO10.setThirtyDay(medicalData.getQrSiPayAmt().toString());
statDO11.setThirtyDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setThirtyDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setThirtyDay(medicalData.getF2fSiPayNum().toString());
statDO14.setThirtyDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setThirtyDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setThirtyDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setThirtyDay(medicalData.getOtherSiPayNum().toString());
statDO18.setThirtyDay(medicalData.getOtherSiPayAmt().toString());
}
if (medicalData.getAcctDay().endsWith("31")){
statDO1.setThirtyOneDay(medicalData.getQrPayNum().toString());
statDO2.setThirtyOneDay(medicalData.getQrPayAmt().toString());
statDO3.setThirtyOneDay(medicalData.getF2fPayNum().toString());
statDO4.setThirtyOneDay(medicalData.getF2fPayAmt().toString());
statDO5.setThirtyOneDay(medicalData.getOtherPayNum().toString());
statDO6.setThirtyOneDay(medicalData.getOtherPayAmt().toString());
statDO7.setThirtyOneDay(medicalData.getQrSelfPayNum().toString());
statDO8.setThirtyOneDay(medicalData.getQrSelfPayAmt().toString());
statDO9.setThirtyOneDay(medicalData.getQrSiPayNum().toString());
statDO10.setThirtyOneDay(medicalData.getQrSiPayAmt().toString());
statDO11.setThirtyOneDay(medicalData.getF2fSelfPayNum().toString());
statDO12.setThirtyOneDay(medicalData.getF2fSelfPayAmt().toString());
statDO13.setThirtyOneDay(medicalData.getF2fSiPayNum().toString());
statDO14.setThirtyOneDay(medicalData.getF2fSiPayAmt().toString());
statDO15.setThirtyOneDay(medicalData.getOtherSelfPayNum().toString());
statDO16.setThirtyOneDay(medicalData.getOtherSelfPayAmt().toString());
statDO17.setThirtyOneDay(medicalData.getOtherSiPayNum().toString());
statDO18.setThirtyOneDay(medicalData.getOtherSiPayAmt().toString());
}
}
5.3.2 生成Excel样例