帆软报表-蒲公英云

帆软报表

下载软件

最新版本10
https://www.finereport.com/product/download

版本9要到百度搜索下载

教程

https://bbs.fanruan.com/edu/guide/finereport/3.html

自定义函数

1.把finereport的WEB-INF内的lib拷贝到本项目中
C:\FineReport_10.0\webapps\webroot\WEB-INF\lib

2.lib添加到library

3.写自定义函数，继承AbstractFunction
接受字符串最好用{}括起来，然后传递进来。可能是finereport的bug

4.编辑后，.class文件复制到WEB-INF\classes目录
C:\FineReport_10.0\webapps\webroot\WEB-INF\classes\com\fr\function

例如

package com.fr.function;
import com.fr.script.AbstractFunction;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
/**
 * 计算日期差多少天
 * @author lipo
 * @date 2020/9/29 15:56
 */
public class UsedDays extends AbstractFunction {
    @Override
    public Object run(Object[] args) {
        String str = args[0].toString();
        str = str.replace("{", "");
        str = str.replace("}", "");
        String[] split = str.split(",");
        int length = split.length;
        if (length < 2) {
            return "";
        }
        for (String s : split) {
            if ("".equals(s)) {
                return "";
            }
        }
        LocalDate beginDate = parseDate(split[0]);
        LocalDate endDate = parseDate(split[1]);
        return endDate.toEpochDay() - beginDate.toEpochDay();
    }
    private LocalDate parseDate(String text) {
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        return LocalDate.parse(text, dateTimeFormatter);
    }
    public static void main(String[] args) {
        UsedDays remark = new UsedDays();
        System.out.println(remark.run(new Object[]{12}));
        System.out.println(remark.run(new String[]{"2020-04-27,"}));
        System.out.println(remark.run(new String[]{"2020-04-27,2020-04-27"}));
        System.out.println(remark.run(new String[]{"2020-04-27,2020-04-28"}));
        System.out.println(remark.run(new String[]{"2020-04-27,2020-05-28"}));
        System.out.println(remark.run(new String[]{"2020-04-27,2021-05-28"}));
    }
}