Giter Club home page Giter Club logo

xianrendzw / easyreport Goto Github PK

View Code? Open in Web Editor NEW
1.7K 182.0 780.0 35.72 MB

A simple and easy to use Web Report System for java.EasyReport是一个简单易用的Web报表工具(支持Hadoop,HBase及各种关系型数据库),它的主要功能是把SQL语句查询出的行列结构转换成HTML表格(Table),并支持表格的跨行(RowSpan)与跨列(ColSpan)。同时它还支持报表Excel导出、图表显示及固定表头与左边列的功能。

License: Apache License 2.0

Java 72.09% CSS 1.50% JavaScript 20.12% HTML 6.15% Dockerfile 0.14%

easyreport's Issues

AbstractQueryer为什么不直接实现Queryer

MySqlQueryer等全部使用extends AbstractQueryer implements Queryer。
而AbstractQueryer 实际上实现了所有Queryer接口。为什么AbstractQueryer 不直接实现Queryer?

工程报错

将代码导入IDEA中,发现domain中的实体都缺少getter和setter方法,另外,AppEnvConsts中缺少ENV和ENV_ITEM。

编译通过,运行时报错

build成功了,但运行时抛出了
java.lang.NoClassDefFoundError: org/apache/commons/collections4/MapUtils
的错误

master分之代码无法编译

部分class中有错误,比如DataSourceService,PreviewController中的log对象不能识别。
com.easytoolsoft.easyreport.data.membership.po.Module的builder()方法未定义等问题。

需求补充

目前报表预览的时候,是直接的展示所有的数据记录,当数据量比较大的时候加载的速度会很慢,什么时候把分页给做了。

数据库连接报错以及解决办法

第一次用,采用从发布包安装,在增加数据源的时候报错:

Could not get JDBC Connection; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool

解决办法:修改 app-config.xml 第29行

<property name="breakAfterAcquireFailure" value="true" />

改为

<property name="breakAfterAcquireFailure" value="false" />

小的需求点

如果有时间,作者可以拓展一些功能:
1)报表展示的图形种类。目前仅支持折现和柱状图,可以多些支持,如:饼状图。
2)下载方式支持pdf等格式。

数据量统计

有人统计过这个平台支持多大的数据量吗?

导出excel中文乱码

修改application.properties文件

增加如下配置:
spring.http.encoding.force=true
spring.http.encoding.charset=UTF-8
spring.http.encoding.enabled=true
server.tomcat.uri-encoding=UTF-8

HTTP API访问: 如何提交认证

easyreport-web

首先,我开启了认证

image

接着,通过curl访问服务

curl -i -X POST \
    --header "Accept: application/json" \
    --header "Authorization: Basic YWRtaW46MTIzNDU2" \
    -d uid=3b6d84ef-e6d7-4644-a145-e99b578426bf \
    -d area=北京市 \
    -d isMergeRow=on \
    -d isRowSpan=true \
    http://localhost:8080/report/table/getData.json

提示

image

那么,怎么开启Basic Auth认证呢?

时分秒

请问作者支持时间精度到时分秒的条件查询吗?

warlauncher

大神,我生了easyreport.jar后,看到一个warlauncher.这个怎么运行的?

图表预览失败

获取的是最新代码,在本地进行编译,预览默认天气数据时,图表不能正常预览

image

直接mvn Build会遇到找不到artifact失败

[ERROR] Failed to execute goal on project easyreport-engine: Could not resolve dependencies for project com.easytoolsoft:easyreport-engine:jar:2.1-SNAPSHOT: The following artifacts could not be resolved: com.microsoft.sqlserver:sqljdbc4:jar:4.0, com.oracle:ojdbc6:jar:11.2.0.3: Failure to find com.microsoft.sqlserver:sqljdbc4:jar:4.0 in http://repo1.maven.org/maven2/ was cached in the local repository, resolution will not be reattempted until the update interval of repo1 has elapsed or updates are forced -> [Help 1]

查了一下stackoverflow是这样说的,不知道你们是怎么build成功的?
http://stackoverflow.com/questions/19537396/missing-artifact-com-microsoft-sqlserversqljdbc4jar4-0

数据源设置时出现找不到模板

Oops!
There seems to be a problem with the page you requested (/views/metadata/ds).

Details: Error resolving template "metadata/ds", template might not exist or might not be accessible by any of the configured Template Resolvers

Status: 500

父表与子表能否实现跳转

如:父表统计北京市一个月晴天10天,阴天10天,能否实现点击10天跳转到子表,北京市一个月的晴天记录等等

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

I have changed the setting below,and I am sure that the password id true ,but I also get the connection time out finally.
server.port=8088 easytoolsoft.easyreport.meta.datasource.url=jdbc:mysql://localhost:3306/easyreport2?characterEncoding=UTF-8 easytoolsoft.easyreport.meta.datasource.username=root easytoolsoft.easyreport.meta.datasource.password=XXXX
I can connect to the easyreport2 database ,but fail to connect china_weather_air,and I can't find the place to set up the china_weather_air datasource.

2018-04-16 09:58:17.673 ERROR 7140 --- [nio-8088-exec-2] com.alibaba.druid.pool.DruidDataSource : init datasource error, url: jdbc:mysql://localhost:3306/china_weather_air?characterEncoding=UTF-8

whether I missed something?
Thanks!

列的排列顺序 可否根据配置里的排列?

_20171219113514
_20171219154103
_20171219153734
第一张图是我想要达到的效果。
第二张图是我的配置。
第三张图是做出来的效果。
现在的情况是,布局列都在左侧,统计列和维度列都在右侧。
这个列的顺序就不能按照配置的来吗?

导出Excel的中查询条件为undefined

您好我在导出报表的时候发现所设置的查询条件都为undefined(见下图)
image
另外导出Excel后遮罩层的进度条一直显示不消失(见下图),请问有什么解决方式吗?
image

谢谢!

图表不能正常显示

你好,我使用的是源码安装方式,环境搭起来了,安装教程的步骤进行操作,登录进去后,表格能够正常显示,但是图表显示不出来,后台也没报错,会是什么原因呢?

v2.0数据源连接池保存后再修改也不生效

数据源定义时, 我的连接串填写有误,但是一旦保存后,我再次打开数据源定义界面,即使修改连接串为正确值,也不能生效了。

不使用连接池没有问题。

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.