CN116796713A - System and method for automatically generating forms and outputting multiple forms through forms set-typing - Google Patents

Abstract

The application discloses a system and a method for automatically generating a form set and a report and outputting multiple formats, wherein the system comprises the following steps: the model definition module is used for defining a plurality of report components and describing and storing the report components in the same description language; a report designer for generating a corresponding report model in response to a drag operation; the jacking and report analysis engine is used for analyzing a report model, and performing format assembly according to the data read by the assembly data source to form jacking format output and report visual display; the visual framework is used for accessing a menu of the front-end Web application, an interface framework for front-end rendering and visual rendering of a form set or a report form to form front-end query of the report form; and the report format generating and outputting engine is used for analyzing the report model and outputting the target file in the specified format. The application solves the problem of multi-format output of complex reports and realizes the integration of report design, display, and output of various format files and documents.

Description

System and method for automatically generating forms and outputting multiple forms through forms set-typing

Technical Field

The application relates to the technical field of computers, in particular to a system and a method for automatically generating a form set and a report and outputting multiple formats.

Background

Management software often requires a large amount of Form data (forms) for layout output and report generation and printing of comprehensive query data. Along with the development of digitization, format files (such as PDF and OFD) required to be archivized are printed out, the docking with an electronic archive system is realized, and data are often required to be exported as EXCEL files or format files to be exported as WORD files for processing and utilization aiming at report files, so that various reports are written.

Conventionally, a programmer is required to write program codes by using a computer software programming language to realize data query and acquisition, report format generation and format file generation, and the functions of the computer program can be completed only by analyzing or compiling compiler (or analyzer) software of the language to translate the compiler software into running machine codes of a target computer.

Therefore, computer programming is a highly skilled capability and has relatively low programming efficiency.

However, the data items and formats of the forms (such as a cash flow sheet, a reimbursement sheet, a purchase application sheet and the like) and the report are often changed, and once the data items and the formats are changed, program codes need to be modified again, and the program codes are compiled, constructed and released again, so that the workload is huge and the efficiency is low.

Disclosure of Invention

In view of the technical problems, the application provides a system and a method for automatically generating a form set and a report and outputting multiple formats.

Other features and advantages of the present disclosure will be apparent from the following detailed description, or may be learned in part by the practice of the disclosure.

According to one aspect of the present application, a system for automatic generation and multi-format output of forms set and report is provided, the system comprising:

the model definition module is used for defining element types, layout, data sources and reading paths of a plurality of report components, describing the elements in the same description language and storing the elements, and the report components are used for combining the report components into different report models;

a report designer for generating the corresponding report model in response to the dragging operation when a plurality of the report components of a front canvas thereof are dragged;

the jacking and report analysis engine is used for analyzing the report model, outputting format definition according to the format of the report model, assembling data read by a data source, and assembling the format to form jacking format output and visual report display;

the visual framework is used for accessing a menu of the front-end Web application, an interface framework for front-end rendering and visual rendering of a form set or a report form to form front-end query of the report form;

and the report format generation and output engine is used for analyzing the report model and outputting a target file in a specified format.

Further, the description language at least includes one of the following description parameters:

different preset component types;

rendering effects;

verifying operation legality;

event response of the operation;

layout of different preset components.

Further, the description language is JSON.

Further, the element type at least comprises one of text display, data, a chart, a two-dimensional code and a table grid line.

Further, the layout includes one of partition, segment, and page.

Further, the report designer is connected to the data source, directly defines the reading rule of the data item, and binds with the data item of the report or the data item sleeved with the report.

Further, the data reading of the data source is based on one of a local file or an SQL database or a Web service.

Further, the visualization framework is an HTML 5-based Web framework.

Further, the target file comprises one of a layout PDF file, a data EXCEL table and a WORD document of report content.

According to a second aspect of the present disclosure, there is provided a method for automatic generation and multi-format output of forms set and report, the method comprising:

forming the report model based on the report designer by online designing report style, output format and definition of data source;

publishing the report model, connecting with an application system frame, a menu and a call URL to form application publishing;

based on the visual framework, loading the report model, calling the typing and report analysis engine, and performing style, data loading and visual rendering of a form typing or report;

and when the visual framework is interactively operated, calling the report format generation and output engine to perform form typing or specified format output of the report.

The technical scheme of the present disclosure has the following beneficial effects:

the application can realize code-free development for the development scene of complex overprinting and report output, and can design the components and layout of the final running form of the software to realize the software function by adopting a nonprofessional overprinting or report design tool, thus, the application can greatly improve the efficiency of software design without writing the code by using a complex computer programming language, obtain the final experience of software running, and enable people who do not know the programming language and have special capability of software programming to quickly carry out the software design, thereby reducing the capability requirement of software development.

The problem of multi-format output of complicated report is solved, a large number of forms need multiple formats to be printed and output, such as format file output is PDF electronic archive file, excel data export is reprocessed, WORD text manuscript format is formally reported and written, and the design, display and output integration of multiple format files and documents of the report are realized, so that the method is a unique advantage of the patent.

According to the application, the software modeling and running are carried out through the program running time, the complex process of compiling, constructing and packaging the software into related running codes after the traditional software programming is not needed, and then the deployment and running are carried out on the server, so that the instant deployment and instant running can be developed in real time, and the system management efficiency is greatly improved.

Drawings

FIG. 1 is a schematic diagram of a system for automatic generation and multi-format output of forms set up and report in an embodiment of the present disclosure;

FIG. 2 is a flow chart of a method for automatic generation and multi-format output of forms set and report in an embodiment of the present disclosure;

FIG. 3 is a terminal device of a system for implementing forms set typing and automatic report generation and multi-format output in an embodiment of the present disclosure;

FIG. 4 is a computer readable storage medium storing a system for automatic generation and multi-format output of forms set and report in an embodiment of the present disclosure.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. However, the exemplary embodiments may be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the present disclosure. One skilled in the relevant art will recognize, however, that the aspects of the disclosure may be practiced without one or more of the specific details, or with other methods, components, steps, etc. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present disclosure.

Furthermore, the drawings are only schematic illustrations of the present disclosure. The same reference numerals in the drawings denote the same or similar parts, and thus a repetitive description thereof will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in software or in one or more hardware modules or integrated circuits or in different networks and/or processor devices and/or microcontroller devices.

As shown in fig. 1, the embodiment of the present disclosure provides a system for automatic generation and multi-format output of forms set and report, and as shown in fig. 1, the system includes several parts including a model definition module 101, a report designer 102, a set and report parsing engine 103, a visualization framework 104, a report format generation and output engine 105, and the like.

Aiming at the form typing and report generation, the embodiment of the specification forms a report model by defining the final form of the form typing and report editing by using the format file obtained immediately after the reading, and defines the data source and the data display format, and acquires the data by a background engine, and assembles the data into the final typing format and report format, thereby realizing code-free development and completing the function of software. If the data item or layout of the overprinting and report output is to be changed, the report model can be modified again in a visible and instant mode through the report designer 102. The application can greatly improve the software design efficiency and reduce the skill requirement of software development.

Specifically, the system includes:

the model definition module 101 is used for defining element types, layouts, data sources and reading paths of a plurality of report components, describing the elements in the same description language and storing the elements, wherein the report components are used for combining into different report models.

Through abstraction and definition of report components in Web front-end application, including element types of the report components such as text display, data, charts, two-dimensional codes, table grid lines and the like, layout of the components such as partition, segmentation, paging and the like, source definition and reading paths of the component data, and dragging of the components to a design canvas, a final form set of software or description of a report is formed, and the description of a report model adopts a unified description language JSON and can be stored.

The description language may include various parameters such as the type of different preset components, rendering effects, operational validity checks, event responses of operations, layout of different preset components, and so forth.

A report designer 102, wherein the report designer 102 is configured to generate the report model corresponding to the dragging operation when a plurality of report components of a front canvas of the report designer are dragged.

The report designer 102 may specifically be a Web program, that is, a program that pulls report components onto a canvas to generate a report model in a what you see is what you get manner. Report designer 102 may connect to the data sources, directly define the reading rules for the data items, and bind to the data items of the report or the data items that are nested.

And the jacking and report analysis engine 103 is used for analyzing the report model, and assembling data read by a data source according to the format output format definition of the report model, and performing format assembly to form jacking format output and report visual display.

The data reading of the data source can be a data set which supports a local file or SQL database or Web service and is returned from other application service API interfaces, and various data reading, format conversion and assembly are carried out.

The visualization framework 104, wherein the visualization framework 104 is used for accessing a menu of a front-end Web application, an interface framework of front-end rendering and a visual rendering of a form set or a report, so as to form a front-end query of the report.

The visual rendering can be rendering by a Web frame of HTML5, so that the visual rendering can adapt to the screen sizes, styles and resolutions of different terminals, and the self-adaptation of the PC and the mobile intelligent terminal is realized.

And the report format generating and outputting engine 105 is used for analyzing the report model by the report format generating and outputting engine 105 and outputting the target file in the specified format.

And when the file is output, the file is assembled into a target file according to the format output format and the format, wherein the target file comprises format file PDF generation, data EXCEL export, WORD format export of report content and the like, and is used for forming an archive file or report material.

Based on the system, the development scene of complex overprinting and report output can be realized without code development, and the software function is realized by designing the components of the final running form of the software and the layout thereof through a non-professional overprinting or report design tool, so that the code writing in a complex computer programming language is not needed, the efficiency of software design is greatly improved, the final experience of software running is obtained, and people who do not know the programming language and do not have special capability of software programming can quickly perform the software design, thereby reducing the capability requirement of software development.

The problem of multi-format output of complicated report is solved, a large number of forms need multiple formats to be printed and output, such as format file output is PDF electronic archive file, excel data export is reprocessed, WORD text manuscript format is formally reported and written, and the design, display and output integration of multiple format files and documents of the report are realized, so that the method is a unique advantage of the patent.

The system of the embodiment of the specification performs software modeling and running through program running time, does not need to compile, construct and package software into related running codes after traditional software programming, and then performs complex processes of deployment and running on a server, so that instant deployment and instant running can be developed in instant, and the system management efficiency is greatly improved

Based on the system for automatically generating and outputting the forms through the forms and the reports, as shown in fig. 2, a method for automatically generating and outputting the forms and the reports is provided, and the method comprises the following steps of S201 to S204:

in step S201, the report model is formed based on the report designer, on-line design report style, output layout, and definition of data source.

Specifically, the report designer designs the report model in a what you see is what you get manner by dragging the component to the design canvas.

In step S202, the report model is published, and is connected with an application system framework, a menu and a call URL to form application publishing.

In step S203, based on the visualization framework, loading the report model, and calling the typing and report parsing engine to perform style, data loading and visualization rendering of a form typing or report;

in step S204, when the visualization framework is interoperated, the report format generating and outputting engine is invoked to perform a form click or a specified format output of a report.

The method for automatically generating the form set and the report and outputting the multiple forms can solve the problems of automatic generation of the form set and the report, the format of the report model and the data reading of a data source are analyzed by an engine through the definition of the report model, the automatic code-free development of the form set and the report is realized, and the software system function of the report output driven by the model is realized by a software program through a preset algorithm and codes in the report model and a report component;

the problems of complex and diversified form typing and report development are solved, and the report is designed by dragging the components to canvas, so that the professional capability requirement problem of report development is greatly reduced;

the problem of multi-format output of a complex report is solved, a large number of forms are printed and the report output needs multiple formats, for example, format file output is PDF electronic archive file, excel data is exported and reprocessed, WORD text manuscript format is formally reported and written, and the output engine can realize the file output of multiple formats;

the method solves the problem of quick response when the data, format or format of the form is changed, and when the form is changed frequently, the program code and complex compiling, constructing, deploying and other works are not needed to be modified, and the model designer is directly utilized to modify the report model to release by one key

Based on the same thought, the embodiment of the present disclosure further provides a device for automatic generation and multi-format output of forms and forms set, as shown in fig. 3.

The device for automatically generating the form set and the report and outputting the multiple formats can be the terminal device or the server provided by the embodiment.

The devices for automatic generation of forms and reports and multi-format output can generate relatively large differences due to different configurations or performances, and can comprise one or more processors 301 and a memory 302, wherein the memory 302 can store one or more storage application programs or data. The memory 302 may include readable media in the form of volatile memory units, such as Random Access Memory (RAM) units and/or cache memory units, and may further include read-only memory units. The application programs stored in memory 302 may include one or more program modules (not shown), including but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment. Still further, the processor 301 may be configured to communicate with the memory 302 to execute a series of computer executable instructions in the memory 302 on a form jacking and report automatic generation and multi-format output device. The devices for automatic generation and multi-format output of forms and statements may also include one or more power supplies 303, one or more wired or wireless network interfaces 304, one or more I/O interfaces (input output interfaces) 305, one or more external devices 306 (e.g., keyboard, mouse, etc.), one or more devices that enable a user to interact with the device, and/or any device (e.g., router, network switch, etc.) that enables the device to communicate with one or more other computing devices. Such communication may occur through the I/O interface 305. Also, the device may communicate with one or more networks, such as a Local Area Network (LAN), via a wired or wireless interface 304.

In particular, in this embodiment, the apparatus for automatic generation and multi-format output of forms and reports includes a memory, and one or more programs, where the one or more programs are stored in the memory, and the one or more programs may include one or more modules, and each module may include a series of computer executable instructions in the apparatus for automatic generation and multi-format output of forms and reports, and the one or more programs configured to be executed by the one or more processors include computer executable instructions for:

forming the report model based on the report designer by online designing report style, output format and definition of data source;

publishing the report model, connecting with an application system frame, a menu and a call URL to form application publishing;

based on the visual framework, loading the report model, calling the typing and report analysis engine, and performing style, data loading and visual rendering of a form typing or report;

and when the visual framework is interactively operated, calling the report format generation and output engine to perform form typing or specified format output of the report.

Based on the same idea, exemplary embodiments of the present disclosure further provide a computer readable storage medium having stored thereon a program product capable of implementing the method described in the present specification. In some possible implementations, various aspects of the disclosure may also be implemented in the form of a program product comprising program code for causing a terminal device to carry out the steps according to the various exemplary embodiments of the disclosure as described in the "exemplary methods" section of this specification, when the program product is run on the terminal device.

Referring to fig. 4, a program product 700 for implementing the above-described method according to an exemplary embodiment of the present disclosure is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present disclosure is not limited thereto, and in this document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium can be, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium would include the following: an electrical connection having one or more wires, a portable disk, a hard disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

The computer readable signal medium may include a data signal propagated in baseband or as part of a carrier wave with readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A readable signal medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out operations of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, CSS, HTML and the like and conventional procedural programming languages, such as the "JavaScript" language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Thus, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.) or on a network, including several instructions to cause a computing device (may be a personal computer, a server, a terminal, or a network device, etc.) to perform the method according to the exemplary embodiments of the present disclosure.

Furthermore, the above-described figures are only schematic illustrations of processes included in the method according to the exemplary embodiments of the present disclosure, and are not intended to be limiting. It will be readily appreciated that the processes shown in the above figures do not indicate or limit the temporal order of these processes. In addition, it is also readily understood that these processes may be performed synchronously or asynchronously, for example, among a plurality of modules.

It should be noted that although in the above detailed description several modules or units of a device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit in accordance with exemplary embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into a plurality of modules or units to be embodied.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims (10)

1. A system for automatic generation and multi-format output of forms set and report forms, the system comprising:

the model definition module is used for defining element types, layout, data sources and reading paths of a plurality of report components, describing the elements in the same description language and storing the elements, and the report components are used for combining the report components into different report models;

a report designer for generating the corresponding report model in response to the dragging operation when a plurality of the report components of a front canvas thereof are dragged;

the jacking and report analysis engine is used for analyzing the report model, outputting format definition according to the format of the report model, assembling data read by a data source, and assembling the format to form jacking format output and visual report display;

the visual framework is used for accessing a menu of the front-end Web application, an interface framework for front-end rendering and visual rendering of a form set or a report form to form front-end query of the report form;

and the report format generation and output engine is used for analyzing the report model and outputting a target file in a specified format.

2. The system for automatic generation and multi-format output of form typing and reporting of claim 1, wherein the description language includes at least one of the following description parameters:

different preset component types;

rendering effects;

verifying operation legality;

event response of the operation;

layout of different preset components.

3. The system for automatic generation and multi-format output of forms suite and report of claim 1, wherein the descriptive language is JSON.

4. The system for automatic generation and multi-format output of forms and reports according to claim 1, wherein the element types comprise at least one of text display, data, charts, two-dimensional codes and grid lines.

5. The system for automatic generation and multi-format output of form typing and reporting of claim 1, wherein the layout comprises one of zoning, segmentation, paging.

6. The system for automatic generation and multi-format output of forms and reports according to claim 1, wherein said report designer is connected to said data source for directly defining the reading rules of the data items and binding with the data items of the report or the data items of the forms.

7. The system for automatic generation and multi-format output of forms suite and report of claim 1 or 6, wherein the data reading of the data source is based on one of a local file or an SQL database or a Web service.

8. The system for automatic generation and multi-format output of forms suite and report of claim 1, wherein the visualization framework is an HTML5 based Web framework.

9. The system for automatic generation and multi-format output of forms suite and report of claim 1, wherein the target file comprises one of a format PDF file, a data EXCEL table, and a WORD document of report content.

10. A method for automatically generating and outputting a plurality of forms by form typing and report forms, comprising the system as claimed in any one of claims 1 to 9, the method comprising:

forming the report model based on the report designer by online designing report style, output format and definition of data source;

publishing the report model, connecting with an application system frame, a menu and a call URL to form application publishing;

based on the visual framework, loading the report model, calling the typing and report analysis engine, and performing style, data loading and visual rendering of a form typing or report;

and when the visual framework is interactively operated, calling the report format generation and output engine to perform form typing or specified format output of the report.