基于算法库的自定义水情报表功能设计与实现

Design and implementation of customized hydro-regime reports function based on algorithm library

摘要:

为实现高效配置各种阶段性分析报表或文档，研发一种基于算法库的自定义报表系统。自定义报表系统采用 B/S 模式，用户界面使用 MiniUI 前端集成框架，利用 HTML + CSS + JavaScript 语言技术，服务端以 Tomcat 为基础，采用 Java 技术构建服务器应用程序，通过 Spring 框架程序实现与数据库通信，同时扩展一个开源的 Web 编辑器 CKEditor，在此基础上实现算法模板、方法属性、参数设置、站群管理等插件，开发出模板设计器；数据实现通过构建算法库，基于实时库和特征值库表结构创建上百种统计分析函数，存储在数据库中。 用户通过模板设计器设计好表格或文档模板，数据通过调用算法库函数获取，报表配置好后根据查询参数一键生成导出 Word，PDF，Excel 格式文件，大大提高服务效率。

Abstract:

In order to effificiently confifigure various phased analysis reports or documents, a customized report system is developed based on algorithms library. Customized report system uses the B/S mode. MiniUI front-end integration framework is used for user interface development. The server is based on Tomcat, Java technology is used to construct a server application, and communication between application and database is realized through the Spring framework application by using HTML + CSS + JavaScript language technology. Also, an open source Web editor CKEditor is extended, on this basis, algorithm template, method attribute, parameter setting, station group management and other plug-ins are implemented, and template designer is developed. By constructing algorithm library, hundreds of statistical analysis functions are created based on the real-time database table structure and the eigenvalue database table structure, and the functions are stored in the database. Users can design tables or document templates by template designer, obtain data by invoking algorithm library functions. After the report is configured, it is generated and exported in Word, PDF, and Excel format according to query parameters, which greatly improves service effificiency.