Development method of modularized report
Through the componentized report development method, the report is divided into multiple components and combined to generate forms, which solves the problems of long development cycle and slow iteration caused by traditional report development methods, and achieves rapid iteration and efficient data analysis.
Patent Information
- Application Number
- CN202411420891.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-12
- Publication Date
- 2025-02-14
AI Technical Summary
Traditional reporting development methods lead to long development cycles, slow iterations and high costs, which cannot meet the requirements of rapid changes in business needs and rapid data aggregation.
Using the componentized report development method, the report is divided into multiple components, and forms are generated by combining these components, and data source query data to replace form placeholders to generate reports.
It realizes rapid iterative report generation, reduces development workload and time cost, and improves data analysis efficiency and flexibility and reusability of report development.
Smart Images
Figure CN119441216A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of data analysis, and more specifically to a method for developing componentized reports. Background Art
[0002] With the rapid development of the Internet and the emergence of various data sources, the amount of data faced by enterprises and organizations continues to increase. Faced with different fields and scenarios, it is necessary to analyze the acquired data in different dimensions to organize it and finally present it to users in different reports. Due to different needs and businesses, traditional reports are often implemented with different interfaces for one report and one page, and the business and code are often very complicated. Even a simple report requires a lot of development tasks.
[0003] In this era of rapid information iteration, this traditional approach has a long development cycle and heavy tasks, and cannot meet the business requirements of rapid data aggregation and rapid task iteration. At the same time, for some reporting projects with limited budgets but tight timelines, the traditional reporting implementation method cannot meet the project requirements in terms of time or cost. In a fast-paced business environment, users need to be able to quickly generate, update, and adjust reports to meet business needs and changes. Traditional reporting methods often require writing a lot of code and performing tedious testing, resulting in a long and inefficient report generation and adjustment process. Summary of the invention
[0004] In view of the above problems, the present disclosure provides a componentized report development method for rapidly developing reports.
[0005] The present disclosure provides a componentized report development method, comprising: configuring a data source, generating configured data source information; the configured data source information at least includes a data source identifier; using preset components, configuring a form, generating configured form information; the preset components at least include one of a text box, a drop-down box, rich text, time, and an interface; the configured form information at least includes a form identifier; in response to a user configuring a report, generating report configuration information of the componentized report by using the configured form information and the configured data source information; the report configuration information at least includes one of a report name, a query field, a field description, a data source identifier, and a form identifier; in response to a user selecting a target componentized report, loading the target componentized report by using the report configuration information.
[0006] According to an embodiment of the present disclosure, configuring a data source and generating configured data source information include: in response to the data source type being a MySQL data source, saving the configured data source information of the MySQL data source; the configured data source information of the MySQL data source includes at least one of a driver, a database address, an account, a password, and a data source identifier; in response to the data source type being an interface data source, saving the configured data source information of the interface data source; the configured data source information of the interface data source includes at least one of an interface address, an interface mode, and a data source identifier.
[0007] According to an embodiment of the present disclosure, preset components are associated one-to-one with component identifiers; using the preset components, a form is configured to generate configured form information, including: generating a layout of the target component based on the selected target component and the drag operation; generating configured form information based on the component identifier and component layout of the target component; the configured form information includes at least one of the component identifier, the component layout and the form identifier.
[0008] According to an embodiment of the present disclosure, report configuration information of a componentized report is generated using configured form information and configured data source information, including: obtaining basic information of the componentized report; the basic information includes at least one of a report name, a query field, and a field description; the query field is used to extract data from a configured data source; the field description is used to explain the query field; an implementation method of configuring the configured data source; the implementation method is used to connect to the data source; and the report configuration information of the componentized report is generated using the basic information, the configured form information, the configured data source information, and the implementation method of the configured data source.
[0009] According to an embodiment of the present disclosure, using report configuration information to load a target componentized report includes: using a report name to determine the report configuration information; parsing the report configuration information to obtain a data source identifier and a form identifier for determining configured data source information and configured form information, and generating a target componentized report.
[0010] According to an embodiment of the present disclosure, parsing report configuration information to obtain a data source identifier and a form identifier for determining configured data source information and configured form information includes: using the data source identifier to determine a query header of the configured data source; using the form identifier to determine a query header of the configured form; using the query header of the configured data source and the query header of the configured form to determine the configured data source information and configured form information.
[0011] According to an embodiment of the present disclosure, generating a target componentized report includes: using a configured form to obtain components of the target componentized report and generating a component layout; using a query field to obtain target data in a configured data source; using the target data to replace placeholders in the component layout and generating the target componentized report.
[0012] A second aspect of the present disclosure provides a componentized report development system, which can be used to implement the above-mentioned componentized report development method, and the system includes: a data source management module, which is used to configure the data source and generate configured data source information; the configured data source information at least includes a data source identifier; a personalized form module, which is used to configure the form using preset components and generate configured form information; the preset components at least include one of a text box, a drop-down box, rich text, time, and an interface; the configured form information at least includes a form identifier; a report configuration module, which is used to generate report configuration information of the componentized report using the configured form information and the configured data source information in response to a user configuring the report; the report configuration information at least includes one of a report name, a query field, a field description, a data source identifier, and a form identifier; a report loading module, which is used to load the target componentized report using the report configuration information in response to a user selecting a target componentized report.
[0013] The third aspect of the present disclosure provides an electronic device, comprising: one or more processors; a memory for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors execute the above-mentioned componentized report development method.
[0014] The fourth aspect of the present disclosure further provides a computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, causes the processor to execute the above-mentioned componentized report development method.
[0015] According to the componentized report development method provided by the present disclosure, the traditional report is divided into several major components, the form is generated by combining the components, and the report is generated by replacing the form placeholders with data through data source query data. Since the report is generated by component configuration, the technical problem of long report development cycle is at least partially solved, and the technical effect of fast iterative report generation, less workload, saving time cost, and improving data analysis efficiency is achieved. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] Figure 1 A flowchart schematically illustrates a method for developing a componentized report according to an embodiment of the present disclosure;
[0017] Figure 2 Another flow chart including data rendering according to an embodiment of the present disclosure is schematically shown;
[0018] Figure 3 The structure block diagram of the componentized report development system according to the embodiment of the present disclosure is schematically shown;
[0019] Figure 4A block diagram of an electronic device suitable for implementing a componentized report development method according to an embodiment of the present disclosure is schematically shown. DETAILED DESCRIPTION
[0020] Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the present disclosure. In the following detailed description, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of the embodiments of the present disclosure. However, it is apparent that one or more embodiments may also be implemented without these specific details. In addition, in the following description, descriptions of known structures and technologies are omitted to avoid unnecessary confusion of the concepts of the present disclosure.
[0021] The terms used herein are only for describing specific embodiments and are not intended to limit the present disclosure. The terms "comprise", "include", etc. used herein indicate the existence of the features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or components.
[0022] All terms (including technical and scientific terms) used herein have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification, and should not be interpreted in an idealized or overly rigid manner.
[0023] When using expressions such as "at least one of A, B, and C, etc.", they should generally be interpreted according to the meaning of the expression commonly understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.).
[0024] In view of the limitations of traditional report development, such as long development cycle, slow iteration, high cost, and high requirements on developer quality, the present disclosure provides a componentized report development method to solve the above problems. Figure 1 The flowchart of the componentized report development method according to the embodiment of the present disclosure is schematically shown. Figure 1As shown, an embodiment of the present disclosure provides a method for developing a componentized report, including: S1, configuring a data source, and generating configured data source information; the configured data source information at least includes a data source identifier; S2, using preset components to configure a form, and generating configured form information; the preset components at least include a text box, a drop-down box, rich text, time, and an interface; the configured form information at least includes a form identifier; S3, in response to a user configuring a report, generating report configuration information of the componentized report using the configured form information and the configured data source information; the report configuration information at least includes a report name, a query field, a field description, a data source identifier, and a form identifier; S4, in response to a user selecting a target componentized report, loading the target componentized report using the report configuration information.
[0025] In this embodiment, preferably, the report configuration information completely includes the report name, query field, field description, data source identifier, and form identifier.
[0026] It should be noted that the entire process of this method implements parameter transfer through encoding and placeholders.
[0027] Through the embodiments of the present disclosure, by dividing the traditional report into several major components, componentization is achieved. Through the management and combination of each component, a one-time development is achieved, and only configuration is required later, and finally the report is quickly iterated through configuration. At the same time, due to the versatility of the components, most components can be used universally, which greatly reduces the configuration work of the components. At the same time, each component can be used alone or in combination. Users can use related components alone or in combination according to their own needs to achieve the function of rapid iteration. Therefore, the present disclosure improves the flexibility and reusability of report development. Through componentized design, reports can be quickly built and modified, reducing development costs and time, because developers can reuse existing components and data source configurations.
[0028] Furthermore, through the componentized configuration processing of reports, developers only need to configure the components they need to quickly develop the reports they need. At the same time, each module also provides extension functions, and users with different needs can also customize their own additional implementation methods according to their needs. Through modular report development, since only operations need to be performed on the page, there are not many requirements for developer skills. Only basic development knowledge is required to configure complex reports. There is no need to understand the specific front-end and back-end technology stacks, which greatly reduces the difficulty of development. Therefore, on the one hand, the requirement for rapid development is solved. Users only need simple configuration, and tasks that originally required several days of development can be quickly completed through configuration. On the one hand, it saves corporate costs. The requirements for senior employees that were originally required can now be reduced. The development that originally required a long period can now be developed quickly, which greatly reduces the human cost of the company.
[0029] On the basis of the above embodiment, the data source is configured and the configured data source information is generated, including: in response to the data source type being a MySQL data source, the configured data source information of the MySQL data source is saved; the configured data source information of the MySQL data source includes at least one of a driver, a database address, an account, a password, and a data source identifier; in response to the data source type being an interface data source, the configured data source information of the interface data source is saved; the configured data source information of the interface data source includes at least one of an interface address, an interface mode, and a data source identifier.
[0030] In this embodiment, preferably, the configured data source information of the MySQL data source completely includes the driver, database address, account number, password and data source identifier. The configured data source information of the interface data source completely includes the interface address, interface mode and data source identifier.
[0031] In this embodiment, in the data source management module, users need to configure their own data sources according to their own data sources. The present disclosure does not limit the data source, such as databases, other system interfaces, and supports expansion.
[0032] Taking MYSQL database as an example, if the data source required by the user does not exist, when the user needs to add a new data source, the data source type MYSQL data source needs to be added. When the report loading module loads data, it will select the driver, database address, account, password corresponding to MYSQL according to the MYSQL data source type, and name the data source; if the data source is the same, multiple reports can share one data source.
[0033] For example, if the data source is an interface address, you need to fill in the specific interface address, interface mode, etc. Each data source has corresponding configuration rules so that the report loading module can load the corresponding data normally.
[0034] It should be noted that for data sources that are not involved, users can add corresponding implementations according to their needs to complete the corresponding expansion. At the same time, the data source supports modification, deletion, query and other related functions, but if the data source has been used, it cannot be deleted without being released. The data source management module can not only be used as the data source of this project, but other systems can also use this module to manage their own data sources and realize data source configuration.
[0035] Through the embodiments of the present disclosure, multiple data source types are supported, which enhances the compatibility and expansion of the system; clear configuration information (such as driver, address, account number, etc.) makes the data source connection more stable and reliable; pre-configured data sources enable report developers to generate reports without secondary configuration or self-searching.
[0036] On the basis of the above embodiment, the preset components are associated one by one with the component identifiers; the preset components are used to configure the form and generate the configured form information, including: generating the layout of the target component according to the selected target component and the drag operation; generating the configured form information according to the component identifier and component layout of the target component; the configured form information includes at least one of the component identifier, the component layout and the form identifier.
[0037] In this embodiment, preferably, the configured form information completely includes a component identifier, a component layout and a form identifier.
[0038] In this embodiment, the required form is configured in the personalized form component module. The module can select different front-end components, such as text boxes, drop-down boxes, rich text, time, interface selection, etc., adjust the layout by dragging the page, set the properties of different texts (what type of text), and modify the type of the components that have been set. By dragging and clicking on the page, users can design the form they need, that is, the query conditions in the report.
[0039] In this embodiment, a code is set for each component (for use in the subsequent report parsing). After completing the page layout and code settings, name the form, click Save, generate a form message, and save the corresponding form page to the database record. Taking the common start time and end time form as an example, you need to drag two time components and set the time format yyyy-MM-dd, set the start time code beginDae, the end time code endDate, set the form name start and end time, click Save, and the form template can be generated. This form can be applied to the report module, or it can be used alone in other systems.
[0040] It should be noted that this module is not only applicable to modular reports, but also to other systems. You only need to configure the form, record the form ID, and introduce the form initialization page into other system pages to achieve form configuration management, and other systems can achieve form query configuration. For some traditional projects, it can reduce the difficulty of developing form tasks.
[0041] Through the embodiments of the present disclosure, the association between components and component identifiers enables a form to call pre-set components, thereby improving form configuration efficiency, improving the intuitiveness and ease of use of form configuration, and reducing configuration difficulty.
[0042] On the basis of the above embodiment, report configuration information of a componentized report is generated using configured form information and configured data source information, including: obtaining basic information of the componentized report; the basic information includes at least one of a report name, a query field, and a field description; the query field is used to extract data from a configured data source; the field description is used to explain the query field; an implementation method of configuring the configured data source; the implementation method is used to connect to the data source; and the report configuration information of the componentized report is generated using the basic information, the configured form information, the configured data source information, and the implementation method of the configured data source.
[0043] In this embodiment, preferably, the basic information completely includes the report name, query fields and field descriptions.
[0044] In this embodiment, in the report configuration module, click Add, and the information that needs to be filled in includes: report name, query field, field description, form (check the configured form), data source (check the configured data source), and the specific implementation corresponding to each data source. Taking MYSQL as an example, you need to fill in the corresponding query SQL. If there are no conditions, it is just a simple SQL. If there are conditions, you need to add SQL containing placeholders corresponding to the form. If there is a paging requirement, you also need to contain placeholders for the corresponding paging parameters. Click Finish to produce the corresponding report template. Taking the interface as an example, if it is an interface, it is the corresponding interface address.
[0045] It should be noted that a front-end filling page is provided for users to fill in relevant information and configure the generated report.
[0046] Through the embodiments of the present disclosure, the flexible report configuration method enables the report to meet diverse needs; ensures the integrity and accuracy of the report configuration information, and provides a reliable basis for subsequent report loading.
[0047] Based on the above embodiment, the target componentized report is loaded using report configuration information, including: using the report name to determine the report configuration information; parsing the report configuration information to obtain a data source identifier and a form identifier to determine the configured data source information and the configured form information, and generating a target componentized report.
[0048] In this embodiment, when the user clicks to view the report, the backend will load the report loading module, which is automatically processed by the backend and does not require manual configuration. The backend finds the corresponding data source information, form information, and report configuration information based on the unique ID of the report and the information saved by the report configuration module. The page will automatically generate the query header of the report based on the queried form, and generate the query header based on the configured fields and field descriptions. When the user fills in the query conditions and clicks to query or export, the backend will query all the configured component information required for the report. The backend will adapt to the corresponding data source processing interface according to the data source type and call different implementations. If it is a database, the corresponding driver will be loaded according to the corresponding database type, and then the final SQL will be generated through SQL and form parameters and placeholder conversion, and the required data will be queried and returned to the front end. The front end matches the corresponding data through the query field and renders it to the user.
[0049] According to the embodiments of the present disclosure, reports are automatically rendered and generated through report configuration information, thereby improving report development efficiency.
[0050] Based on the above embodiment, the report configuration information is parsed to obtain a data source identifier and a form identifier for determining the configured data source information and the configured form information, including: using the data source identifier to determine the query header of the configured data source; using the form identifier to determine the query header of the configured form; using the query header of the configured data source and the query header of the configured form to determine the configured data source information and the configured form information.
[0051] Through the embodiments of the present disclosure, through the one-to-one correspondence between data source identifiers and data sources, the one-to-one correspondence between form identifiers and forms, and the one-to-one correspondence between component identifiers and components, the accuracy and consistency of information during report loading is ensured, thereby improving the efficiency and accuracy of report loading.
[0052] Based on the above embodiment, a target componentized report is generated, including: using a configured form to obtain components of the target componentized report and generate a component layout; using a query field to obtain target data in a configured data source; using the target data to replace placeholders in the component layout to generate a target componentized report.
[0053] According to the embodiments of the present disclosure, by flexibly configuring the query fields, the report generation process is made flexible and efficient, and can meet the needs in different scenarios.
[0054] Figure 2 Another flowchart including data rendering according to an embodiment of the present disclosure is schematically shown, wherein the main steps take querying an employee information report in a MYSQL database as an example, and the condition is the employee name.
[0055] S101: Data source configuration, first determine whether the data source has been configured. For the same URL, account, and password, you only need to configure one data source, and you do not need to configure multiple. However, there is no limit on configuring multiple. Generally, multiple data sources are configured with different names. Configure the MYSQL database to query the employee information report data source, select the type as database, the database type as MYSQL, fill in the corresponding URL, account, and password, and name it MYSLQ-employee information data source.
[0056] S102: Configure the form. Since the form is reusable, before creating a new form, you need to determine whether the same form already exists. Especially for some common forms, such as start time and end time, you only need to create a form once. The report of the same form only needs to configure the form and can be used without adding a new form. Since there is no corresponding form for this report, click Add Form and drag and drop 2 components. The first component is the component description set to employee name, and no code is set. For the second component, select the component type as input box, and the corresponding code of the text box is NAME. The form is named employee information form.
[0057] S103: Report configuration. Since this is a new report, click Add Report. Select MYSLQ-Employee Information Data Source from the Data Source drop-down menu. Select Employee Information Form from the Form drop-down menu. Since the database is selected, the corresponding configuration of the database will appear. You need to fill in the query SQL:SELECT*FROM employees where name like'%NAME%'. If it is an interface configuration, you need to fill in the corresponding interface address. Each data source will show its own implementation below. You need to fill in the corresponding information according to the selected data source. In this configuration, the placeholder %NAME% corresponds to the form code NAME and is named Employee Information Query.
[0058] S104: The user clicks on the report to jump to the report page information. The page uses the report ID to query the form and header information and render the page. The form information calls the backend interface, and the configured form is queried through the ID and returned to the frontend. The frontend directly renders it into the query conditions based on the information returned by the backend, and renders it into the data column header based on the returned header information and instructions. At the same time, since the query button and the export button are universal, the page settings are directly set, and the paging information of the page is also realized through the public parameter configuration and placeholders. The unified page configuration is merged with the form parameters into all parameters. Whether the backend finally uses the parameters is converted to the main with the placeholder.
[0059] S105: The user clicks on the query, and the page encapsulates the form information and report ID information and passes them to the backend. The backend obtains the SQL for the report ID and encapsulates and converts the form conditions and common parameter information (paging information, etc.) through the placeholders. At the same time, the data source and database association information are used to obtain the MYSLQ-employee information data source database connection, query the data, and return it to the page.
[0060] S106: The page queries the fields through the form information and renders the corresponding report information.
[0061] Compared with traditional report development, the present invention has the following advantages: componentized configuration, simple logic, easy to implement; componentized configuration, low technical requirements, simple and easy to use; configured processing, fast iteration, less workload, saving time and cost; convenient operation, high accuracy; wide range of application without any restrictions.
[0062] Based on the above componentized report development method, the present disclosure also provides a componentized report development system. Figure 3 The device is described in detail.
[0063] like Figure 3 As shown, the componentized report development system of this embodiment includes a data source management module, a personalized form module, a report configuration module and a report loading module.
[0064] The data source management module is used to configure the data source and generate configured data source information; the configured data source information at least includes a data source identifier. In one embodiment, the data source management module can be used to perform the operation S1 described above, which will not be described in detail here.
[0065] The personalized form module is used to configure the form using preset components and generate configured form information; the preset components include at least one of a text box, a drop-down box, rich text, a time, and an interface; the configured form information includes at least a form identifier. In one embodiment, the personalized form module can be used to perform the operation S2 described above, which will not be repeated here.
[0066] The report configuration module is used to generate report configuration information of the componentized report using the configured form information and the configured data source information in response to the user configuring the report; the report configuration information includes at least one of the report name, query field, field description, data source identifier, and form identifier. In one embodiment, the report configuration module can be used to perform the operation S3 described above, which will not be repeated here.
[0067] The report loading module is used to load the target componentized report using the report configuration information in response to the user selecting the target componentized report. In one embodiment, the report loading module can be used to perform the operation S4 described above, which will not be described in detail here.
[0068] Figure 4 A block diagram of an electronic device suitable for implementing the method according to an embodiment of the present disclosure is schematically shown.
[0069] like Figure 4 As shown, the electronic device 400 according to an embodiment of the present disclosure includes a processor 401, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 402 or a program loaded from a storage part 408 to a random access memory (RAM) 403. The processor 401 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 401 may also include an onboard memory for caching purposes. The processor 401 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.
[0070] In RAM403, various programs and data required for the operation of electronic device 400 are stored. Processor 401, ROM402 and RAM403 are connected to each other via bus 404. Processor 401 performs various operations of the method flow according to the embodiment of the present disclosure by executing the program in ROM402 and / or RAM403. It should be noted that the program can also be stored in one or more memories other than ROM402 and RAM403. Processor 401 can also perform various operations of the method flow according to the embodiment of the present disclosure by executing the program stored in the one or more memories.
[0071] According to an embodiment of the present disclosure, the electronic device 400 may further include an input / output (I / O) interface 405, which is also connected to the bus 404. The electronic device 400 may further include one or more of the following components connected to the I / O interface 405: an input portion 406 including a keyboard, a mouse, etc.; an output portion 407 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 408 including a hard disk, etc.; and a communication portion 409 including a network interface card such as a LAN card, a modem, etc. The communication portion 409 performs communication processing via a network such as the Internet. A drive 410 is also connected to the I / O interface 405 as needed. A removable medium 411, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 410 as needed, so that a computer program read therefrom is installed into the storage portion 408 as needed.
[0072] The present disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present disclosure is implemented.
[0073] The embodiment of the present disclosure also includes a computer program product, which includes a computer program, and the computer program contains program code for executing the method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the method provided by the embodiment of the present disclosure.
[0074] According to an embodiment of the present disclosure, the program code for executing the computer program provided by the embodiment of the present disclosure can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, using an Internet service provider to connect through the Internet).
[0075] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0076] It will be appreciated by those skilled in the art that the features described in the various embodiments and / or claims of the present disclosure may be combined and / or combined in a variety of ways, even if such combinations and / or combinations are not explicitly described in the present disclosure. In particular, the features described in the various embodiments and / or claims of the present disclosure may be combined and / or combined in a variety of ways without departing from the spirit and teachings of the present disclosure. All of these combinations and / or combinations fall within the scope of the present disclosure.
[0077] The embodiments of the present disclosure are described above. However, these embodiments are only for illustrative purposes and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the various embodiments cannot be used in combination to advantage. The scope of the present disclosure is defined by the attached claims and their equivalents. Without departing from the scope of the present disclosure, those skilled in the art may make a variety of substitutions and modifications, which should all fall within the scope of the present disclosure.
Claims
1. A componentized report development method, characterized in that: include: Configure the data source and generate the configured data source information; The configured data source information includes at least a data source identifier; Use preset components to configure the form and generate configured form information; The preset component includes at least one of a text box, a drop-down box, rich text, time, and an interface; the configured form information includes at least a form identifier; In response to a user configuring a report, generating report configuration information of the componentized report using the configured form information and the configured data source information; the report configuration information includes at least one of a report name, a query field, a field description, a data source identifier, and a form identifier; In response to a user selecting a target componentized report, the target componentized report is loaded using the report configuration information.
2. The method according to claim 1, wherein: The configuring the data source and generating the configured data source information includes: In response to the data source type being a MySQL data source, saving the configured data source information of the MySQL data source; the configured data source information of the MySQL data source includes at least one of a driver, a database address, an account number, a password, and a data source identifier; In response to the data source type being an interface data source, the configured data source information of the interface data source is saved; the configured data source information of the interface data source includes at least one of an interface address, an interface mode, and a data source identifier.
3. The method according to claim 1, wherein: The preset components are associated with component identifiers one by one; The method of using the preset components to configure the form and generate the configured form information includes: Generate the layout of the target component according to the selected target component and drag operation; The configured form information is generated according to the component identifier and the component layout of the target component; the configured form information includes at least one of the component identifier, the component layout and the form identifier.
4. The method according to claim 1, wherein: The step of generating report configuration information of the componentized report by using the configured form information and the configured data source information includes: Obtaining basic information of the componentized report; the basic information includes at least one of a report name, a query field, and a field description; the query field is used to extract data from a configured data source; and the field description is used to explain the query field; configuring an implementation of the configured data source; the implementation is used to connect to the data source; The report configuration information of the componentized report is generated by using the basic information, the configured form information, the configured data source information and the implementation method of the configured data source.
5. The method according to claim 1, wherein: The step of loading the target componentized report using the report configuration information includes: Use the report name to determine the report configuration information; The report configuration information is parsed to obtain the data source identifier and the form identifier to determine the configured data source information and the configured form information, and to generate the target componentized report.
6. The method according to claim 5, wherein: Parsing the report configuration information to obtain the data source identifier and the form identifier for determining configured data source information and configured form information includes: determining a query header for the configured data source using the data source identifier; using the form identifier, determining a query header for the configured form; The configured data source information and the configured form information are determined by using the query header of the configured data source and the query header of the configured form.
7. The method according to claim 5, wherein: The generating of the target componentized report comprises: Using the configured form, obtaining components of the target componentized report and generating a component layout; Obtain target data from a configured data source using the query field; The target data is used to replace the placeholders in the component layout to generate the target componentized report.
8. A componentized report development system, characterized in that: The system can be used to implement the method according to any one of claims 1 to 7, and the system comprises: A data source management module, used to configure a data source and generate configured data source information; the configured data source information at least includes a data source identifier; The personalized form module is used to configure the form using preset components and generate configured form information; the preset components include at least one of a text box, a drop-down box, rich text, time, and an interface; the configured form information includes at least a form identifier; A report configuration module, configured to generate report configuration information of the componentized report in response to a user configuring a report, using the configured form information and the configured data source information; the report configuration information includes at least one of a report name, a query field, a field description, a data source identifier, and a form identifier; The report loading module is used to load the target componentized report using the report configuration information in response to the user selecting the target componentized report.
9. An electronic device, comprising: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors are caused to execute the method according to any one of claims 1 to 7.
10. A computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, causes the processor to perform the method according to any one of claims 1 to 7.