自定义报表函数问题描述

数据库保存的是阳历日期，在报表展示时希望把阴历转换成阴历，方便查询各种阴历节日的功能，如下图把阳历转换成阴历的效果:

自定义报表函数解决方案

首先定义一个可以将阳历转为阴历的类，然后自定义FineReport函数，在run方法中获取年月日参数并调用之前的类将阳历转为阴历，最终返回给报表。

自定义报表实现步骤

阳历转阴历的类

FineReport提供一个现成的农历日历工具类SolarToLunar，该类中通过today(int year, int month, int day)方法可将输入的年、月、日对应的阳历转为阴历日期，完整代码如下：
package com.fr.function;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.Locale;
public class SolarToLunar {
final private static long[] lunarInfo = new long[] { 0x04bd8, 0x04ae0,
0x0a570, 0x054d5, 0x0d260, 0x0d950, 0x16554, 0x056a0, 0x09ad0,
0x055d2, 0x04ae0, 0x0a5b6, 0x0a4d0, 0x0d250, 0x1d255, 0x0b540,
0x0d6a0, 0x0ada2, 0x095b0, 0x14977, 0x04970, 0x0a4b0, 0x0b4b5,
0x06a50, 0x06d40, 0x1ab54, 0x02b60, 0x09570, 0x052f2, 0x04970,
0x06566, 0x0d4a0, 0x0ea50, 0x06e95, 0x05ad0, 0x02b60, 0x186e3,
0x092e0, 0x1c8d7, 0x0c950, 0x0d4a0, 0x1d8a6, 0x0b550, 0x056a0,
0x1a5b4, 0x025d0, 0x092d0, 0x0d2b2, 0x0a950, 0x0b557, 0x06ca0,
0x0b550, 0x15355, 0x04da0, 0x0a5d0, 0x14573, 0x052d0, 0x0a9a8,
0x0e950, 0x06aa0, 0x0aea6, 0x0ab50, 0x04b60, 0x0aae4, 0x0a570,
0x05260, 0x0f263, 0x0d950, 0x05b57, 0x056a0, 0x096d0, 0x04dd5,
0x04ad0, 0x0a4d0, 0x0d4d4, 0x0d250, 0x0d558, 0x0b540, 0x0b5a0,
0x195a6, 0x095b0, 0x049b0, 0x0a974, 0x0a4b0, 0x0b27a, 0x06a50,
0x06d40, 0x0af46, 0x0ab60, 0x09570, 0x04af5, 0x04970, 0x064b0,
0x074a3, 0x0ea50, 0x06b58, 0x055c0, 0x0ab60, 0x096d5, 0x092e0,
0x0c960, 0x0d954, 0x0d4a0, 0x0da50, 0x07552, 0x056a0, 0x0abb7,
0x025d0, 0x092d0, 0x0cab5, 0x0a950, 0x0b4a0, 0x0baa4, 0x0ad50,
0x055d9, 0x04ba0, 0x0a5b0, 0x15176, 0x052b0, 0x0a930, 0x07954,
0x06aa0, 0x0ad50, 0x05b52, 0x04b60, 0x0a6e6, 0x0a4e0, 0x0d260,
0x0ea65, 0x0d530, 0x05aa0, 0x076a3, 0x096d0, 0x04bd7, 0x04ad0,
0x0a4d0, 0x1d0b6, 0x0d250, 0x0d520, 0x0dd45, 0x0b5a0, 0x056d0,
0x055b2, 0x049b0, 0x0a577, 0x0a4b0, 0x0aa50, 0x1b255, 0x06d20,
0x0ada0 };

final private static int[] year20 = new int[] { 1, 4, 1, 2, 1, 2, 1, 1, 2,
1, 2, 1 };

final private static int[] year19 = new int[] { 0, 3, 0, 1, 0, 1, 0, 0, 1,
0, 1, 0 };

final private static int[] year2000 = new int[] { 0, 3, 1, 2, 1, 2, 1, 1,
2, 1, 2, 1 };

public final static String[] nStr1 = new String[] { "", "正", "二", "三", "四",
"五", "六", "七", "八", "九", "十", "十一", "十二" };

private final static String[] Gan = new String[] { "甲", "乙", "丙", "丁", "戊",
"己", "庚", "辛", "壬", "癸" };

private final static String[] Zhi = new String[] { "子", "丑", "寅", "卯", "辰",
"巳", "午", "未", "申", "酉", "戌", "亥" };

private final static String[] Animals = new String[] { "鼠", "牛", "虎", "兔",
"龙", "蛇", "马", "羊", "猴", "鸡", "狗", "猪" };

private final static String[] solarTerm = new String[] { "小寒", "大寒", "立春",
"雨水", "惊蛰", "春分", "清明", "谷雨", "立夏", "小满", "芒种", "夏至", "小暑", "大暑",
"立秋", "处暑", "白露", "秋分", "寒露", "霜降", "立冬", "小雪", "大雪", "冬至" };

private final static String[] sFtv = new String[] { "0101*元旦", "0214 情人节",
"0308 妇女节", "0312 植树节", "0315 消费者权益日", "0401 愚人节", "0501 劳动节",
"0504 青年节", "0512 护士节", "0601 儿童节", "0701 建党节", "0801 建军节",
"0808 父亲节", "0909 毛泽东逝世纪念", "0910 教师节", "0928 孔子诞辰", "1001*国庆节",
"1006 老人节", "1024 联合国日", "1112 孙中山诞辰", "1220 澳门回归", "1225 圣诞节",
"1226 毛泽东诞辰" };

private final static String[] lFtv = new String[] { "0101*农历春节",
"0115 元宵节", "0505 端午节", "0707 七夕情人节", "0815 中秋节", "0909 重阳节",
"1208 腊八节", "1224 小年", "0100*除夕" };

/**
* 传回农历 y年的总天数
*
* @param y
* @return
*/
final private static int lYearDays(int y) {
int i, sum = 348;
for (i = 0x8000; i > 0x8; i >>= 1) {
if ((lunarInfo[y - 1900] & i) != 0)
sum += 1;
}
return (sum + leapDays(y));
}

/**
* 传回农历 y年闰月的天数
*
* @param y
* @return
*/
final private static int leapDays(int y) {
if (leapMonth(y) != 0) {
if ((lunarInfo[y - 1900] & 0x10000) != 0)
return 30;
else
return 29;
} else
return 0;
}

/**
* 传回农历 y年闰哪个月 1-12 , 没闰传回 0
*
* @param y
* @return
*/
final private static int leapMonth(int y) {
return (int) (lunarInfo[y - 1900] & 0xf);
}

/**
* 传回农历 y年m月的总天数
*
* @param y
* @param m
* @return
*/
final private static int monthDays(int y, int m) {
if ((lunarInfo[y - 1900] & (0x10000 >> m)) == 0)
return 29;
else
return 30;
}

/**
* 传回农历 y年的生肖
*
* @param y
* @return
*/
final public static String AnimalsYear(int y) {
return Animals[(y - 4) % 12];
}

/**
* 传入 月日的offset 传回干支,0=甲子
*
* @param num
* @return
*/
final private static String cyclicalm(int num) {
return (Gan[num % 10] + Zhi[num % 12]);
}

/**
* 传入 offset 传回干支, 0=甲子
*
* @param y
* @return
*/
final public static String cyclical(int y) {
int num = y - 1900 + 36;
return (cyclicalm(num));
}

/**
* 传出农历.year0 .month1 .day2 .yearCyl3 .monCyl4 .dayCyl5 .isLeap6
*
* @param y
* @param m
* @return
*/
final private long[] Lunar(int y, int m) {
long[] nongDate = new long[7];
int i = 0, temp = 0, leap = 0;
Date baseDate = new GregorianCalendar(1900 + 1900, 1, 31).getTime();
Date objDate = new GregorianCalendar(y + 1900, m, 1).getTime();
long offset = (objDate.getTime() - baseDate.getTime()) / 86400000L;
if (y < 2000) offset += year19[m - 1]; if (y > 2000)
offset += year20[m - 1];
if (y == 2000)
offset += year2000[m - 1];
nongDate[5] = offset + 40;
nongDate[4] = 14;

for (i = 1900; i < 2050 && offset > 0; i++) {
temp = lYearDays(i);
offset -= temp;
nongDate[4] += 12;
}
if (offset < 0) { offset += temp; i--; nongDate[4] -= 12; } nongDate[0] = i; nongDate[3] = i - 1864; leap = leapMonth(i); // 闰哪个月 nongDate[6] = 0; for (i = 1; i < 13 && offset > 0; i++) {
// 闰月
if (leap > 0 && i == (leap + 1) && nongDate[6] == 0) {
--i;
nongDate[6] = 1;
temp = leapDays((int) nongDate[0]);
} else {
temp = monthDays((int) nongDate[0], i);
}

// 解除闰月
if (nongDate[6] == 1 && i == (leap + 1))
nongDate[6] = 0;
offset -= temp;
if (nongDate[6] == 0)
nongDate[4]++;
}

if (offset == 0 && leap > 0 && i == leap + 1) {
if (nongDate[6] == 1) {
nongDate[6] = 0;
} else {
nongDate[6] = 1;
--i;
--nongDate[4];
}
}
if (offset < 0) { offset += temp; --i; --nongDate[4]; } nongDate[1] = i; nongDate[2] = offset + 1; return nongDate; } /** * 传出y年m月d日对应的农历.year0 .month1 .day2 .yearCyl3 .monCyl4 .dayCyl5 .isLeap6 * * @param y * @param m * @param d * @return */ final public static long[] calElement(int y, int m, int d) { long[] nongDate = new long[7]; int i = 0, temp = 0, leap = 0; Date baseDate = new GregorianCalendar(0 + 1900, 0, 31).getTime(); Date objDate = new GregorianCalendar(y, m - 1, d).getTime(); long offset = (objDate.getTime() - baseDate.getTime()) / 86400000L; nongDate[5] = offset + 40; nongDate[4] = 14; for (i = 1900; i < 2050 && offset > 0; i++) {
temp = lYearDays(i);
offset -= temp;
nongDate[4] += 12;
}
if (offset < 0) { offset += temp; i--; nongDate[4] -= 12; } nongDate[0] = i; nongDate[3] = i - 1864; leap = leapMonth(i); // 闰哪个月 nongDate[6] = 0; for (i = 1; i < 13 && offset > 0; i++) {
// 闰月
if (leap > 0 && i == (leap + 1) && nongDate[6] == 0) {
--i;
nongDate[6] = 1;
temp = leapDays((int) nongDate[0]);
} else {
temp = monthDays((int) nongDate[0], i);
}

// 解除闰月
if (nongDate[6] == 1 && i == (leap + 1))
nongDate[6] = 0;
offset -= temp;
if (nongDate[6] == 0)
nongDate[4]++;
}

if (offset == 0 && leap > 0 && i == leap + 1) {
if (nongDate[6] == 1) {
nongDate[6] = 0;
} else {
nongDate[6] = 1;
--i;
--nongDate[4];
}
}
if (offset < 0) { offset += temp; --i; --nongDate[4]; } nongDate[1] = i; nongDate[2] = offset + 1; return nongDate; } public final static String getChinaDate(int day) { String a = ""; if (day == 10) return "初十"; if (day == 20) return "二十"; if (day == 30) return "三十"; int two = (int) ((day) / 10); if (two == 0) a = "初"; if (two == 1) a = "十"; if (two == 2) a = "廿"; if (two == 3) a = "三"; int one = (int) (day % 10); switch (one) { case 1: a += "一"; break; case 2: a += "二"; break; case 3: a += "三"; break; case 4: a += "四"; break; case 5: a += "五"; break; case 6: a += "六"; break; case 7: a += "七"; break; case 8: a += "八"; break; case 9: a += "九"; break; } return a; } public static String today(int y, int m, int d) { int year = y; int month = m; int date = d; long[] l = calElement(year, month, date); StringBuffer sToday = new StringBuffer(); try { sToday.append(" 农历"); sToday.append(cyclical(year)); sToday.append('('); sToday.append(AnimalsYear(year)); sToday.append(")年"); sToday.append(nStr1[(int) l[1]]); sToday.append("月"); sToday.append(getChinaDate((int) (l[2]))); return sToday.toString(); } finally { sToday = null; } } private static SimpleDateFormat sdf = new SimpleDateFormat( "yyyy年M月d日 EEEEE"); /** * 农历日历工具使用演示 * * @param args */ public static void main(String[] args) { System.out.println(today(1988, 10, 27)); } } 3.2 自定义FineReport函数 自定义函数Lunar扩展于AbstractFunction，并重写run方法，获得年月日参数值，调用农历日历工具类SolarToLunar的today方法，求得农历日期并返回，代码如下： package com.fr.function; import com.fr.script.AbstractFunction; public class Lunar extends AbstractFunction { public Object run(Object[] args) { String result = ""; int y = Integer.parseInt(args[0].toString()); int m = Integer.parseInt(args[1].toString()); int d = Integer.parseInt(args[2].toString()); result = SolarToLunar.today(y, m, d); return result; } }

自定义函数编译并运行

编译自定义函数

编译Lunar.java和SolarToLunar.java类生成Lunar.class和SolarToLunar.class文件拷贝至报表应用所在目录/WEB-INF/classes/com/fr/function下。

注册自定义函数

启动设计器，点击服务器|函数管理器，新增函数取名为Lunar，选择Lunar.class类，如下图：

此时自定义函数便定义好了，您可以在设计器中使用该函数。

使用自定义函数

在单元格中写入公式=Lunar(2011,7,11)，预览模板便可以看到把日期2011年7月11日阳历转换成阴历了。

若数据库日期类型字段如图：拖到模板设计界面，设置高级属性，在自定义显示值里面输入公式

Lunar(year($$$),month($$$),day($$$))，如下图设置，则可把保存在数据库里面的阳历日期转换成阴历了。

注：该自定义函数的日期类型参数只能是(2011,7,11)这个格式的日期，如果不相符合，则需要通过自定义显示将格式进行转换，如上所述。

报表工具产品更多介绍：www.finereport.com

免费下载 体验Demo