Online report generation method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention provides an online report generation method and device, electronic equipment and a storage medium, belongs to the technical field of computers, and is applied to the field of financial science and technology and the field of digital medical treatment. The method comprises the steps that a service table file is acquired, the service table file comprises service cells, and the service cells have target cell identifiers; cell style parameters of the service cells are obtained according to the target cell identifiers, a front-end webpage is generated according to the cell style parameters, and the front-end webpage comprises page grids of the service cells; obtaining target business data from the page grid according to the cell style parameter; target service parameters are determined according to the cell style parameters or reference service parameters, and the reference service parameters are data obtained by combining the cell style parameters and target service data; and performing page rendering on the page grid according to the target business parameter to obtain the target business report, thereby improving the efficiency of online report generation.

Description

Technical Field

[0001] The present application relates to the field of computer technology and is applied to the fields of financial technology and digital medicine, and in particular to an online report generation method, device, electronic device and storage medium. Background Art

[0002] Local spreadsheet files can be lost due to disk failure or misoperation. In order to improve the security of local spreadsheet files, the files can be stored on cloud servers in the form of online web pages. For example, in a fintech scenario, financial data can be stored in the form of online web pages. In a digital healthcare scenario, medical data can be stored in the form of online web pages. Even if the local device fails, the financial data and medical data will not be lost. In related technologies, professional tools can be used to implement online editing operations of local spreadsheet files, but professional tools need to be deployed separately, and various dependencies need to be installed and configured during deployment. Dependencies refer to software, libraries, frameworks, environments or other resources installed and configured for the normal operation of professional tools, which leads to low efficiency in online report generation. Summary of the Invention

[0003] The main purpose of the embodiments of the present application is to provide an online report generation method, device, electronic device and storage medium, aiming to improve the efficiency of online report generation.

[0004] To achieve the above objectives, a first aspect of an embodiment of the present application provides an online report generation method, the online report generation method comprising:

[0005] Acquire a business table file; wherein the business table file includes a business cell, and the business cell has a target cell identifier;

[0006] Acquire cell style parameters of the business cell according to the target cell identifier, and generate a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell;

[0007] Acquire target business data from the page grid according to the cell style parameters;

[0008] Determining target service parameters according to the cell style parameters or reference service parameters; wherein the reference service parameters are data obtained by merging the cell style parameters and the target service data;

[0009] The page grid is rendered according to the target business parameters to obtain a target business report.

[0010] In some embodiments, acquiring the cell style parameters of the business cell according to the target cell identifier includes:

[0011] Acquire the style version number of the business cell and the number of versions of the style version number according to the target cell identifier;

[0012] Obtain version selection prompt information according to the number of versions;

[0013] Filter the style version number according to the version selection prompt information to obtain the target version number;

[0014] The cell style parameters are obtained according to the target version number.

[0015] In some embodiments, obtaining version selection prompt information according to the number of versions includes:

[0016] Obtain browser type, device type, and object operation behavior based on the number of versions described;

[0017] Predicting a style version satisfaction score of the style version number based on the browser type, the device type, and the object operation behavior;

[0018] The version selection prompt information is generated according to the style version satisfaction score.

[0019] In some embodiments, rendering the page grid according to the target business parameter to obtain a target business report includes:

[0020] Acquire grid filling data according to the target service parameters;

[0021] Filling the grid filling data into the page grid to obtain a target grid;

[0022] The target grid is adjusted according to the target business parameters to obtain the target business report.

[0023] In some embodiments, obtaining grid filling data according to the target service parameter includes:

[0024] If the target business parameter is the cell style parameter, extracting a cell type attribute and a business attribute parameter of the cell type attribute from the cell style parameter, and acquiring the grid filling data according to the cell type attribute and the business attribute parameter;

[0025] If the target service parameter is the reference service parameter, the target service data is used as the grid filling data.

[0026] In some embodiments, the cell type attribute is used to indicate a cell type of the business cell, where the cell type includes a fixed value type, a calculation formula type, a verification formula type, or an input value type. Acquiring the grid filling data according to the cell type attribute and the business attribute parameter includes:

[0027] If the cell type attribute indicates that the cell type of the business cell is the fixed value type, then using the business attribute parameter of the fixed value type as the grid filling data;

[0028] If the cell type attribute indicates that the cell type of the business cell is the calculation formula type, performing parameter calculation according to the business attribute parameter to obtain the grid filling data;

[0029] If the cell type attribute indicates that the cell type of the business cell is the verification formula type, parameter verification is performed according to the business attribute parameters to obtain the parameter verification result, the verification level of the business cell is obtained, and the grid filling data is obtained according to the parameter verification result and the verification level.

[0030] In some embodiments, if the target service parameter is the reference service parameter, using the target service data as the grid filling data includes:

[0031] If the target service parameter is the reference service parameter, storing the target service data in a database according to a preset table structure to obtain a data table;

[0032] The data table is queried according to a preset time window to obtain the grid filling data.

[0033] To achieve the above-mentioned purpose, a second aspect of an embodiment of the present application provides an online report generation device, the online report generation device comprising:

[0034] A file acquisition module, configured to acquire a business table file; wherein the business table file includes a business cell, and the business cell has a target cell identifier;

[0035] a webpage generation module, configured to obtain cell style parameters of the business cell according to the target cell identifier, and generate a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell;

[0036] A data acquisition module, configured to acquire target business data from the page grid according to the cell style parameters;

[0037] a determination module, configured to determine target service parameters according to the cell style parameters or reference service parameters; wherein the reference service parameters are data obtained by combining the cell style parameters and the target service data;

[0038] A rendering module is used to render the page grid according to the target business parameters to obtain a target business report.

[0039] To achieve the above-mentioned purpose, the third aspect of an embodiment of the present application proposes an electronic device, which includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the method described in the first aspect when executing the computer program.

[0040] To achieve the above-mentioned purpose, the fourth aspect of the embodiments of the present application proposes a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the method described in the first aspect.

[0041] The online report generation method, online report generation device, electronic device, and computer-readable storage medium proposed in the embodiments of the present application generate an online report based on the data fields of a business table file by acquiring a business table file. The business table file includes business cells, each of which has a target cell identifier. A cell is the smallest storage unit of table data. To improve the flexibility and scalability of online report generation, online report generation is performed on a cell-by-cell basis. Cell style parameters of the business cell are acquired based on the target cell identifier, and the webpage layout and visual style are determined based on the cell style parameters. A front-end webpage is then generated based on the cell style parameters. The front-end webpage includes a page grid for the business cells. To ensure the data integrity of the online business report, target business data is acquired from the page grid based on the cell style parameters. Target business parameters are determined based on the cell style parameters or reference business parameters. The reference business parameters are data obtained by merging the cell style parameters and the target business data to determine the data displayed on the front-end webpage. To obtain a visual online report interface, the page grid is rendered based on the target business parameters to obtain the target business report. The entire report generation process relies on an automated process, eliminating the need to install and configure various dependencies of specialized tools, thereby improving the efficiency of online report generation. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 This is a flow chart of the online report generation method provided by an embodiment of the present application;

[0043] Figure 2 yes Figure 1 Flowchart of step S120 in FIG.

[0044] Figure 3 yes Figure 2 Flowchart of step S220 in FIG.

[0045] Figure 4 yes Figure 1 Flowchart of step S150 in FIG.

[0046] Figure 5 yes Figure 4 Flowchart of step S410 in FIG.

[0047] Figure 6 yes Figure 5 Flowchart of step S510 in FIG.

[0048] Figure 7 yes Figure 5 Flowchart of step S520 in FIG.

[0049] Figure 8 This is a schematic diagram of the structure of the online report generation device provided in an embodiment of the present application;

[0050] Figure 9 This is a schematic diagram of the hardware structure of the electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solutions and advantages of this application more clear, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain this application and are not intended to limit this application.

[0052] It should be noted that although the device schematics illustrate functional module divisions and the flowcharts illustrate logical sequences, in certain circumstances, the steps shown or described may be performed in a sequence that differs from the module divisions in the device or the sequence in the flowcharts. The terms "first," "second," and so on, in the specification, claims, and drawings, are used to distinguish similar items and are not necessarily used to describe a specific sequence or precedence.

[0053] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this application pertains. The terms used herein are for the purpose of describing the embodiments of this application only and are not intended to limit this application.

[0054] Local spreadsheet files can be lost due to disk failure or misoperation. In order to improve the security of local spreadsheet files, the files can be stored on cloud servers in the form of online web pages. For example, in a fintech scenario, financial data can be stored in the form of online web pages. In a digital healthcare scenario, medical data can be stored in the form of online web pages. Even if the local device fails, the financial data and medical data will not be lost. In related technologies, professional tools can be used to implement online editing operations of local spreadsheet files, but professional tools need to be deployed separately, and various dependencies need to be installed and configured during deployment. Dependencies refer to software, libraries, frameworks, environments or other resources installed and configured for the normal operation of professional tools, which leads to low efficiency in online report generation.

[0055] Based on this, embodiments of the present application provide an online report generation method, an online report generation device, an electronic device, and a computer-readable storage medium, aiming to improve the efficiency of online report generation.

[0056] The online report generation method, online report generation device, electronic device, and computer-readable storage medium provided in the embodiments of the present application are specifically described through the following embodiments. First, the online report generation method in the embodiments of the present application is described.

[0057] The online report generation method provided in the embodiment of the present application relates to the field of computer technology. The online report generation method provided in the embodiment of the present application can be applied to a terminal, can be applied to a server side, or can be software running in a terminal or a server side. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server side can be configured as an independent physical server, or as a server cluster or distributed system composed of multiple physical servers, or as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements the online report generation method, etc., but is not limited to the above forms.

[0058] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, and the like. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, and the like that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments in which tasks are performed by remote processing devices connected via a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media, including storage devices.

[0059] Figure 1 This is an optional flowchart of the online report generation method provided in the embodiment of the present application. Figure 1 The method may include but is not limited to steps S110 to S150.

[0060] Step S110, obtaining a business table file; wherein the business table file includes business cells, and the business cells have target cell identifiers;

[0061] Step S120, obtaining cell style parameters of the business cell according to the target cell identifier, and generating a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell;

[0062] Step S130, obtaining target business data from the page grid according to the cell style parameters;

[0063] Step S140, determining target business parameters according to the cell style parameters or the reference business parameters; wherein the reference business parameters are data obtained by combining the cell style parameters and the target business data;

[0064] Step S150 , rendering the page grid according to the target business parameters to obtain a target business report.

[0065] Steps S110 to S150, as illustrated in the embodiments of this application, generate online reports on a cell-by-cell basis. The report layout can be dynamically adjusted based on the flexibility of the cells, and multiple report formats can be supported, thereby improving the flexibility and scalability of online report generation. The entire report generation process relies on automated processes, requiring no additional specialized tools or the installation and configuration of the various dependencies required for specialized tools to operate, thereby improving the efficiency of online report generation.

[0066] In step S110 of some embodiments, a business table file is obtained. The business table file is a business table template. The business table template defines the table structure of the table, such as the table layout, column headers, etc., but the business table template does not have specific data content. The business table file is an Excel table file. The cells of the Excel table file are used as business cells. The business cells have target cell identifiers, and the target cell identifiers are used to uniquely identify the business cells. The target cell identifier can be defined using the page position, module position, row position, and column position of the business cell. The business table file supports multiple forms (sheets), and each form can be divided into multiple modules. The page position can be represented by the page number of the form, such as 1. The module position can be represented by the module code of the module, such as M01001, which represents the first module of the first form. The row position can be represented by the row number of the cell in the form, such as 1. The column position can be represented by the column number of the cell in the form, such as 1.

[0067] Based on the diversity of business data, business table files for different businesses usually contain different fields. For example, the object information management table for object management business contains fields such as object ID, name, gender and contact information; the financial information table for financial transaction business contains fields such as account balance, credit score, risk level, annual income, total assets; and the medical record table for digital medical business contains fields such as consultation date, consultation department, treatment items, and treatment results. Based on the complexity of business data, different business cells in the same business table file have different data business requirements. For example, the business cell used to indicate the transaction amount needs to be displayed in currency format, the business cell used to indicate the transaction status has a transaction status verification requirement, and the business cell used to indicate the consultation date needs to be displayed in date format. In view of the diversity and complexity of business data, the embodiment of the present application uses cells as the basic unit for online report generation to adapt to diverse data fields and meet different data business requirements, thereby improving the flexibility of online report generation.

[0068] The style information for different business cells varies. Style information is set for each business cell in the business spreadsheet file and stored in the database. Based on the target cell identifier, the business cell style information is retrieved from the database to obtain cell style parameters. Cell style parameters include style attribute fields and field values. Style attribute fields are properties that affect the report style, and field values ​​are the specific values ​​of the style attribute fields. Style attribute fields include cell type, text indentation, prompt, and the number of merged columns. The cell type attribute indicates the cell type of the business cell. Cell types can be fixed value, input value, calculation formula, or validation formula. Fixed value fields have fixed values, such as the table header or title in the business spreadsheet file. Input value fields have user-entered data, such as name, contact information, or medical results. Calculation formula fields have custom formula values, such as [1R1 C2]+[1R1C3], which performs an addition operation on the business cell in the first row, second column of page 1 and the business cell in the first row, third column of page 1. The field value of the verification formula type is a custom verification formula, such as (Math.round([1R1C2]) == Math.round([1R1C3]), ok, wrong). This verification formula is used to determine whether the values ​​of the business cell in the first row, second column of the first page and the business cell in the first row, third column of the first page are equal. If they are equal, the online report displays ok; otherwise, it displays wrong.

[0069] Build Cascading Style Sheets (CSS) based on cell style parameters, obtain the Hypertext Markup Language (HTML) structure and CSS for each business cell in the business spreadsheet file, and use the HTML structure and CSS to define how the business cell is displayed on the front-end interface. Generate a front-end webpage based on the HTML structure and CSS for each business cell, including a page grid for the business cell. The page grid represents the display format of the business cell on the front-end webpage.

[0070] See also Figure 2 In some embodiments, step S120 may include but is not limited to steps S210 to S240:

[0071] Step S210: obtaining the style version number and the number of versions of the style version number of the business cell according to the target cell identifier;

[0072] Step S220, obtaining version selection prompt information according to the number of versions;

[0073] Step S230, filtering the style version number according to the version selection prompt information to obtain the target version number;

[0074] Step S240: Obtain cell style parameters according to the target version number.

[0075] In step S210 of some embodiments, different users have different preferences or requirements for the visual effects of the table. For example, when ordinary users view information on financial products, they hope that the table can simply and clearly display key information such as the product name, expected rate of return, and risk level of the financial product, and mark the risk level with different colors. Professional users need to fully understand the various detailed information such as the product name, expected rate of return, term, risk level, underlying assets, liquidity, etc. of the financial product. The table needs to support sorting and filtering functions for multiple columns of data to facilitate quick finding of products that meet specific conditions. In order to meet the diverse business needs of different users, different versions of cell style parameters need to be set. In order to quickly locate the style information of different versions of the business cell, the style version number of the business cell is obtained according to the target cell identifier, and the number of style version numbers is counted to obtain the number of versions. The style version number is used to identify different versions of the cell style parameters. The number of versions is an integer greater than or equal to 1.

[0076] In step S220 of some embodiments, if the version number is equal to 1, the style version number is used as the target version number, which is the version number of the cell style parameters used to generate the front-end webpage. If the version number is greater than 1, it indicates that multiple different versions of style information exist. To help the user quickly select the appropriate style information, version selection prompt information is obtained. The version selection prompt information is used to prompt the version selection of the cell style parameters.

[0077] In step S230 of some embodiments, in order to obtain a suitable style version, a target version number is filtered out from multiple style version numbers according to the version number indicated by the version selection prompt information.

[0078] In step S240 of some embodiments, different version numbers correspond to different style information. In order to obtain the style information corresponding to the target version number, the cell style parameters are obtained according to the target version number.

[0079] Through the above steps S210 to S240, users can quickly find a style version that suits their business needs, thereby meeting the diverse business needs of different users.

[0080] See also Figure 3 In some embodiments, step S220 may include but is not limited to steps S310 to S330:

[0081] Step S310, obtaining the browser type, device type and object operation behavior according to the version number;

[0082] Step S320 , predicting a style version satisfaction score of the style version number based on the browser type, device type, and object operation behavior;

[0083] Step S330: Generate version selection prompt information based on the style version satisfaction score.

[0084] In step S310 of some embodiments, different browsers differ in rendering web pages, processing style information, etc., and different devices have differences in screen size, resolution, etc. In order to ensure the system compatibility of style information, the browser type and device type need to be considered when selecting a style version. The browser type is used to indicate the browser software used when accessing a web page, and the device type is used to indicate the hardware device used when accessing a web page, such as a mobile phone, tablet computer, desktop computer, etc. In addition, object operation behaviors such as frequently used business functions and preference settings will also affect the selection of style versions. If the number of versions is greater than 1, the browser type, device type, and object operation behavior are obtained. Object operation behaviors include various operations performed by users on web pages, such as clicking, inputting, scrolling, hovering, etc., which can reflect the user's behavior patterns and usage habits, thereby recommending personalized style versions to users.

[0085] In step S320 of some embodiments, the browser type, device type and object operation behavior will affect the selection of the style version. In order to more comprehensively capture the user's style version selection preference, multi-dimensional information such as browser type, device type and object operation behavior is fused or merged to obtain multimodal information. Feature extraction is performed on the multimodal information to obtain multimodal features. The multimodal features are input into the scoring model to predict the satisfaction score and obtain the style version satisfaction score for each style version number. The style version satisfaction score is used to indicate the user's satisfaction with the style information corresponding to the style version number. The style version satisfaction score is proportional to the user's satisfaction. The larger the style version satisfaction score, the higher the satisfaction. The scoring model can be selected according to the actual situation, such as decision tree, random forest, gradient boosting tree, deep learning model, etc. The deep learning model can be a transformer model, convolutional neural network, recurrent neural network, etc.

[0086] In step S330 of some embodiments, in order to obtain a style version that meets the user's business needs, the style version number with the largest style version satisfaction score is selected, and the selected style version number is filled into the prompt template to obtain version selection prompt information.

[0087] Through the above steps S310 to S330, version selection prompt information can be obtained, so as to recommend a suitable style version to the user based on the version selection prompt information, thereby improving the efficiency and accuracy of style version selection.

[0088] In some embodiments, in step S130, if the cell type of the business cell indicated by the cell type attribute in the cell style parameters is an input value type, target business data is retrieved from the page grid corresponding to the business cell. The target business data is the business data obtained by the user through editing operations in the page grid. In fintech scenarios, the target business data may include the payee's name, payee account number, payment method, etc. In digital healthcare scenarios, the target business data may include the hospital, department, doctor, appointment date, etc.

[0089] In step S140 of some embodiments, if the cell type of the business cell indicated by the cell type attribute in the cell style parameter is an input value type, the cell style parameter and the target business data are merged to obtain a reference business parameter, and the reference business parameter is used as the target business parameter. The target business data is a field value of the input value type. If the cell type of the business cell indicated by the cell type attribute in the cell style parameter is a fixed value type, a calculation formula type, or a verification formula type, the cell style parameter is used as the target business parameter.

[0090] Call the front-end framework, render the page grid of each business cell according to the target business parameters, generate an online business report, and obtain the target business report.

[0091] See also Figure 4 In some embodiments, step S150 may include but is not limited to steps S410 to S430:

[0092] Step S410, obtaining grid filling data according to target business parameters;

[0093] Step S420, filling the grid filling data into the page grid to obtain the target grid;

[0094] Step S430 , adjusting the target grid according to the target business parameters to obtain a target business report.

[0095] In step S410 of some embodiments, the target business parameters trigger the interactive logic of the front-end web page, affecting the dynamic display content of the front-end web page. In order to achieve dynamic updates of the front-end web page, grid filling data is obtained according to the target business parameters, and the grid filling data is the dynamic display content of the page grid to be filled. For example, in a financial scenario, if the transfer amount entered by the user in the page grid exceeds a certain amount, the page grid needs to display additional security verification steps. For example, in a medical scenario, the user enters health data such as blood pressure, heart rate, etc. in the page grid, and the page grid will generate health suggestions based on the health data.

[0096] In step S420 of some embodiments, the grid filling data is filled into the page grid to achieve dynamic update of the page grid and obtain the target grid.

[0097] In step S430 of some embodiments, the target business parameter includes at least one of a text indentation attribute, a prompt attribute, and the number of merged columns. The target grid is adjusted based on at least one of the text indentation attribute, the prompt attribute, and the number of merged columns. Specifically, for each target grid of a business cell, the text indentation of the target grid can be controlled based on the text indentation attribute, a hanging box prompt content can be displayed on the target grid based on the prompt attribute, and the target grids can be merged based on the number of merged columns to obtain a target business report.

[0098] Through the above steps S410 to S430, online business reports can be automatically generated without the need for professional tools, thereby improving the efficiency of online business report generation.

[0099] See also Figure 5 In some embodiments, step S410 may include but is not limited to step S510 or step S520:

[0100] Step S510: If the target business parameter is a cell style parameter, extract the cell type attribute and the business attribute parameter of the cell type attribute from the cell style parameter, and obtain grid filling data according to the cell type attribute and the business attribute parameter;

[0101] Step S520: If the target service parameter is a reference service parameter, the target service data is used as grid filling data.

[0102] In step S510 of some embodiments, the cell type attribute is used to indicate the cell type of the business cell, where the cell type includes a fixed value type, a calculation formula type, a validation formula type, or an input value type, and the business attribute parameter is the field value of the cell type attribute. If the target business parameter is a cell style parameter, indicating that the cell type of the business cell is a fixed value type, a calculation formula type, or a validation formula type, and additional dynamic calculations are required for the page grid, the cell type attribute and the business attribute parameters of the cell type attribute are extracted from the cell style parameter, and the grid fill data is determined based on the cell type attribute and the business attribute parameters.

[0103] In step S520 of some embodiments, if the target business parameter is a reference business parameter, it means that the cell type attribute of the business cell is an input value type. It is only necessary to echo the target business data entered by the user in the page grid to the front-end web page. There is no need to perform additional dynamic calculations on the page grid. The target business data is used as grid fill data.

[0104] Through the above steps S510 to S520, the grid filling data of the page grid can be determined to achieve dynamic update of the front-end web page and ensure the data integrity of the online business report.

[0105] See also Figure 6 In some embodiments, step S510 may include but is not limited to step S610, step S620, or step S630:

[0106] Step S610: If the cell type attribute indicates that the cell type of the business cell is a fixed value type, the business attribute parameter of the fixed value type is used as grid filling data;

[0107] Step S620: If the cell type attribute indicates that the cell type of the business cell is a calculation formula type, parameter calculation is performed according to the business attribute parameters to obtain grid filling data;

[0108] Step S630: If the cell type attribute indicates that the cell type of the business cell is a verification formula type, parameter verification is performed according to the business attribute parameters to obtain a parameter verification result, obtain a verification level of the business cell, and obtain grid filling data according to the parameter verification result and the verification level.

[0109] In some embodiments, in step S610, if the cell type attribute indicates that the cell type of the business cell is a fixed value type, the fixed value business attribute parameter is a fixed value, and the fixed value is used as the grid fill data. Financial products typically have a fixed term, such as three months, and 3 can be used as the grid fill data for the term page grid.

[0110] In step S620 of some embodiments, if the cell type attribute indicates that the cell type of the business cell is a calculation formula type, then the business attribute parameter of the calculation formula type is a calculation formula. Parameter calculation is performed according to the calculation formula, and the result of the parameter calculation is used as the grid fill data. For example, a user transfers money to multiple payees. To determine the total transfer amount, a calculation formula of [1R1C2] + [1R1C3] is designed. According to the calculation formula, the transfer amounts in the page grid indicated by [1R1C2] and the transfer amounts in the page grid indicated by [1R1C3] are summed to obtain the total transfer amount, which is used as the grid fill data.

[0111] In step S630 of some embodiments, if the cell type attribute indicates that the cell type of the business cell is a verification formula type, then the business attribute parameter of the verification formula type is a verification formula, and parameter verification is performed according to the verification formula to obtain a parameter verification result. The parameter verification result includes whether the parameter verification passed or failed. For example, the verification formula is (Math.round([1R1C2]) == Math.round([1R1C3]), ok, wrong), and the grid value of the page grid indicated by [1R1C2] and the grid value of the page grid indicated by [1R1C3] are equal according to the verification formula. If the grid values ​​are equal, it means that the parameter verification passed, and the parameter verification result is ok; if the grid values ​​are not equal, it means that the parameter verification failed, and the parameter verification result is wrong. The verification level of the business cell is obtained, and the verification level includes an important level or an unimportant level. If the verification level is an important level and the parameter verification result indicates that the parameter verification passed, the submission operation of the page grid is allowed, and the parameter verification result is used as the grid filling data. If the verification level is important and the parameter verification result indicates that the parameter verification has failed, the submission operation of the page grid will not be allowed, and the user will be prompted to re-enter the relevant data. The parameter verification result will be used as the grid filling data. If the verification level is not important, the parameter verification result will be used as the grid filling data.

[0112] Through the above steps S610 to S630 , the grid filling data of the page grid can be determined, so as to generate an online business report according to the grid filling data.

[0113] See also Figure 7 In some embodiments, step S520 may include but is not limited to steps S710 to S720:

[0114] Step S710: If the target service parameter is a reference service parameter, the target service data is stored in the database according to the preset table structure to obtain a data table;

[0115] Step S720: query the data table according to the preset time window to obtain grid filling data.

[0116] In step S710 of some embodiments, if the target business parameter is a reference business parameter, indicating that the cell type of the business cell is an input value type, the target business data is stored in the database according to the preset table structure to obtain a data table. The preset table structure includes fields such as account set, period, indicator code, indicator name and indicator value. The account set is an accounting system for financial activities. A period is a period of time starting from a certain time point and ending at another time point. In a financial scenario, it can be used to describe the time range of financial transactions, investments, loans, etc. In a medical scenario, it can be used to describe the time range for patient treatment, medication, etc. The indicator name is the name of a specific indicator, such as the transfer amount. The indicator code is the target cell identifier of the business cell. The indicator value is the business data entered by the user on the front-end web page, such as the amount of the transfer amount.

[0117] The Account Set field supports storing user-entered reporting data, specifically target business data, in multiple sets. The Period field allows loading reporting data from different periods onto a single page for display. Report generation utilizes a lightweight, convenient, and concise approach, meeting basic reporting requirements without relying on third-party components, making it easy to expand functionality later. Separately storing style information and user-entered data facilitates interactive operations within the report generation application.

[0118] In step S720 of some embodiments, the preset time window is a predefined time range. A query is performed on the data table based on the preset time window, or based on the preset time window and account set. The target cell identifier and indicator value within the preset time window are obtained. A page grid for the business cell is determined based on the target cell identifier, and the indicator value is used as grid fill data for the page grid.

[0119] The above steps S710 to S720 save the data content of the cell of the input value type to the database, which facilitates the subsequent direct query of the required business data from the database for online report generation without the user having to re-fill the data, thereby improving the efficiency of online report generation.

[0120] See also Figure 8 The embodiment of the present application further provides an online report generation device that can implement the above-mentioned online report generation method. The online report generation device includes:

[0121] The file acquisition module 810 is used to acquire a business table file; wherein the business table file includes business cells, and the business cells have target cell identifiers;

[0122] The webpage generation module 820 is configured to obtain the cell style parameters of the business cell according to the target cell identifier, and generate a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell;

[0123] The data acquisition module 830 is used to acquire target business data from the page grid according to the cell style parameters;

[0124] Determination module 840, configured to determine target service parameters based on cell style parameters or reference service parameters; wherein the reference service parameters are data obtained by combining the cell style parameters and the target service data;

[0125] The rendering module 850 is used to render the page grid according to the target business parameters to obtain a target business report.

[0126] The specific implementation of the online report generation device is substantially the same as the specific embodiment of the online report generation method described above, and will not be described in detail here.

[0127] The present application also provides an electronic device comprising a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the online report generation method. The electronic device can be any smart terminal, such as a tablet computer or an in-vehicle computer.

[0128] See also Figure 9 , Figure 9 The hardware structure of an electronic device according to another embodiment is shown. The electronic device includes:

[0129] The processor 910 may be implemented as a general-purpose central processing unit (CPU), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is configured to execute relevant programs to implement the technical solutions provided in the embodiments of the present application.

[0130] The memory 920 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 920 can store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 920 and is called by the processor 910 to execute the online report generation method of the embodiments of this application.

[0131] Input / output interface 930, used to implement information input and output;

[0132] Communication interface 940, used to implement communication interaction between this device and other devices, which can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WiFi, Bluetooth, etc.);

[0133] bus 950 , which transmits information between various components of the device (e.g., processor 910 , memory 920 , input / output interface 930 , and communication interface 940 );

[0134] The processor 910 , the memory 920 , the input / output interface 930 , and the communication interface 940 are connected to each other in communication within the device via a bus 950 .

[0135] An embodiment of the present application further provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned online report generation method is implemented.

[0136] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0137] The online report generation method, online report generation device, electronic device, and computer storage medium provided in the embodiments of the present application generate online reports using cells as units, dynamically adjust the report layout based on the flexibility of the cells, and support the generation of multiple report formats, thereby improving the flexibility and scalability of online report generation. The entire report generation process relies on an automated process, does not require the assistance of additional professional tools, and does not require the installation and configuration of the various dependencies required for the operation of professional tools, thereby improving the efficiency of online report generation.

[0138] The embodiments described in the embodiments of this application are intended to more clearly illustrate the technical solutions of the embodiments of this application and do not constitute a limitation on the technical solutions provided by the embodiments of this application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of this application are also applicable to similar technical problems.

[0139] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0140] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, i.e., they may be located in one place or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of this embodiment.

[0141] Those skilled in the art will appreciate that all or some of the steps in the methods, systems, and functional modules / units in the devices disclosed above may be implemented as software, firmware, hardware, or appropriate combinations thereof.

[0142] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0143] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0144] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the above-mentioned units is only a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0145] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0146] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0147] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes multiple instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: various media that can store programs, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0148] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and essence of the present invention should be within the scope of the present invention.

Claims

1. An online report generation method, characterized in that: The method comprises: Acquire a business table file; wherein the business table file includes a business cell, and the business cell has a target cell identifier; Acquire cell style parameters of the business cell according to the target cell identifier, and generate a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell; Acquire target business data from the page grid according to the cell style parameters; Determining target service parameters according to the cell style parameters or reference service parameters; wherein the reference service parameters are data obtained by merging the cell style parameters and the target service data; The page grid is rendered according to the target business parameters to obtain a target business report.

2. The method according to claim 1, characterized in that The acquiring the cell style parameter of the business cell according to the target cell identifier includes: Acquire the style version number of the business cell and the number of versions of the style version number according to the target cell identifier; Obtain version selection prompt information according to the number of versions; Filter the style version number according to the version selection prompt information to obtain the target version number; The cell style parameters are obtained according to the target version number.

3. The method according to claim 2, characterized in that The obtaining of version selection prompt information according to the number of versions includes: Obtain browser type, device type, and object operation behavior based on the number of versions described; Predicting a style version satisfaction score of the style version number based on the browser type, the device type, and the object operation behavior; The version selection prompt information is generated according to the style version satisfaction score.

4. The method according to any one of claims 1 to 3, characterized in that The rendering of the page grid according to the target business parameters to obtain a target business report includes: Acquire grid filling data according to the target service parameters; Filling the grid filling data into the page grid to obtain a target grid; The target grid is adjusted according to the target business parameters to obtain the target business report.

5. The method according to claim 4, characterized in that The acquiring of grid filling data according to the target service parameters includes: If the target business parameter is the cell style parameter, extracting a cell type attribute and a business attribute parameter of the cell type attribute from the cell style parameter, and acquiring the grid filling data according to the cell type attribute and the business attribute parameter; If the target service parameter is the reference service parameter, the target service data is used as the grid filling data.

6. The method according to claim 5, characterized in that The cell type attribute is used to indicate the cell type of the business cell, and the cell type includes a fixed value type, a calculation formula type, a verification formula type, or an input value type. The acquiring the grid filling data according to the cell type attribute and the business attribute parameter includes: If the cell type attribute indicates that the cell type of the business cell is the fixed value type, then using the business attribute parameter of the fixed value type as the grid filling data; If the cell type attribute indicates that the cell type of the business cell is the calculation formula type, performing parameter calculation according to the business attribute parameter to obtain the grid filling data; If the cell type attribute indicates that the cell type of the business cell is the verification formula type, parameter verification is performed according to the business attribute parameters to obtain the parameter verification result, the verification level of the business cell is obtained, and the grid filling data is obtained according to the parameter verification result and the verification level.

7. The method according to claim 5, characterized in that If the target service parameter is the reference service parameter, using the target service data as the grid filling data includes: If the target service parameter is the reference service parameter, storing the target service data in a database according to a preset table structure to obtain a data table; The data table is queried according to a preset time window to obtain the grid filling data.

8. An online report generation device, characterized in that: The device comprises: A file acquisition module, configured to acquire a business table file; wherein the business table file includes a business cell, and the business cell has a target cell identifier; a webpage generation module, configured to obtain cell style parameters of the business cell according to the target cell identifier, and generate a front-end webpage according to the cell style parameters; wherein the front-end webpage includes a page grid of the business cell; A data acquisition module, configured to acquire target business data from the page grid according to the cell style parameters; a determination module, configured to determine target service parameters according to the cell style parameters or reference service parameters; wherein the reference service parameters are data obtained by combining the cell style parameters and the target service data; A rendering module is used to render the page grid according to the target business parameters to obtain a target business report.

9. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the method according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images