Method, device, computer equipment and storage medium for generating business account table

Abstract

The present application relates to a method, device, computer equipment and storage medium for generating a business account table. The method comprises: obtaining the newly added report business object information input by the user, wherein the report business object information includes a report business identifier and tree-shaped report node information; obtaining the corresponding general account table object according to the report business identifier; in the menu interface corresponding to the tree-shaped report node information, constructing a corresponding menu item according to the tree-shaped report node information; sending a business account table data acquisition request corresponding to the menu item to the server; receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item; assigning the account table data to the general account table object, and generating the business report corresponding to the menu item. The use of this method can effectively improve the generation efficiency of business account tables.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method, device, computer equipment and storage medium for generating a business account table. Background Art

[0002] With the development of computer technology and the advent of the 5G era, the emergence of the Internet has brought great convenience to modern life. More and more companies can use the Internet platform to uniformly manage various business information online. In the traditional medical field, when creating and publishing business accounts and tables, it is necessary to create a new business account table object in the business system, select the corresponding filter window business object, and obtain the corresponding data source by configuring SQL scripts or server plug-ins. At the same time, it is necessary to create or register the corresponding form plug-in to configure the account table feature options, and finally publish the newly added account table menu information in the business system menu.

[0003] However, in the current business account table creation method, if multiple business account tables are involved, corresponding views and forms need to be created for data acquisition, and the creation of new account tables requires the installation of an account table designer. At the same time, due to the wide variety of business reports in medical institutions, if all business reports are developed according to conventional operations, a large number of repetitive operations and multiple plug-in definitions will occur, especially when the configuration process for data acquisition from multiple tables is complicated, which easily leads to low efficiency in generating business account tables. Summary of the invention

[0004] Based on this, it is necessary to provide a method, device, computer equipment and storage medium for generating a business account table that can improve the efficiency of generating business account tables in response to the above technical problems.

[0005] A method for generating a business account table, the method comprising:

[0006] Acquire the newly added report business object information input by the user, wherein the report business object information includes a report business identifier and tree-shaped report node information;

[0007] Obtain the corresponding general account table object according to the report business identifier;

[0008] In a menu interface corresponding to the tree-shaped report node information, construct corresponding menu items according to the tree-shaped report node information;

[0009] Sending a request for obtaining business account table data corresponding to the menu item to the server;

[0010] Receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item;

[0011] The account table data is assigned to the general account table object, and a business report corresponding to the menu item is generated.

[0012] In one embodiment, the acquiring of the newly added report business object information input by the user includes:

[0013] Obtain a report business identifier input by a user in a first interface and tree-shaped report node information input in a second interface, wherein the tree-shaped report node information includes report configuration parameter information; wherein the report configuration parameter information is used to instruct the server to utilize the report configuration parameter information corresponding to the menu item to obtain a configuration file corresponding to the report configuration parameter information.

[0014] In one embodiment, after generating the business report corresponding to the menu item, the method further includes:

[0015] In the dynamic form display view corresponding to the general account table object, a configured business report tree menu list is displayed;

[0016] Obtaining the menu item selected from the business report tree menu list;

[0017] In the business report interface corresponding to the selected menu item, the business report corresponding to the menu item is displayed.

[0018] In one embodiment, displaying the business report corresponding to the menu item in the business report interface corresponding to the selected menu item includes:

[0019] Generate corresponding form data according to the selected menu item;

[0020] The method for searching the account table data includes:

[0021] Reading configuration item information in a configuration file corresponding to the selected menu item according to the form data;

[0022] According to the mapping relationship between the configuration item information and the data retrieval SQL statement, the account table data corresponding to the report business identifier is searched from the database.

[0023] In one embodiment, searching the database for account table data corresponding to the report service identifier according to the mapping relationship between the configuration item information and the data retrieval SQL statement includes:

[0024] Obtaining fields for filtering business object forms in the configuration item information;

[0025] The fields of the filtering business object form are used as the processing logic of the data acquisition SQL statement to obtain the account table data source corresponding to the report business identifier from the database.

[0026] A device for generating a business account table, the device comprising:

[0027] An acquisition module is used to acquire the newly added report business object information input by the user, wherein the report business object information includes a report business identifier and tree report node information; and acquire the corresponding general account table object according to the report business identifier;

[0028] A construction module, used to construct corresponding menu items according to the tree-shaped report node information in a menu interface corresponding to the tree-shaped report node information;

[0029] A sending module, used for sending a request for obtaining business account table data corresponding to the menu item to a server;

[0030] A receiving module, used for receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item;

[0031] A generating module is used to assign the account table data to the general account table object and generate a business report corresponding to the menu item.

[0032] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0033] Acquire the newly added report business object information input by the user, wherein the report business object information includes a report business identifier and tree-shaped report node information;

[0034] Obtain the corresponding general account table object according to the report business identifier;

[0035] In a menu interface corresponding to the tree-shaped report node information, construct corresponding menu items according to the tree-shaped report node information;

[0036] Sending a request for obtaining business account table data corresponding to the menu item to the server;

[0037] Receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item;

[0038] The account table data is assigned to the general account table object, and a business report corresponding to the menu item is generated.

[0039] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0040] Acquire the newly added report business object information input by the user, wherein the report business object information includes a report business identifier and tree-shaped report node information;

[0041] Obtain the corresponding general account table object according to the report business identifier;

[0042] In a menu interface corresponding to the tree-shaped report node information, construct corresponding menu items according to the tree-shaped report node information;

[0043] Sending a request for obtaining business account table data corresponding to the menu item to the server;

[0044] Receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item;

[0045] The account table data is assigned to the general account table object, and a business report corresponding to the menu item is generated.

[0046] A method for generating a business account table, comprising:

[0047] Receiving newly added report service object information uploaded by the terminal, wherein the report service object information includes a report service identifier and tree-shaped report node information;

[0048] Obtain the corresponding general account table object according to the report business identifier;

[0049] Sending the general account table object to the terminal;

[0050] Receiving a business account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree-shaped report node information;

[0051] Obtaining a configuration file corresponding to the menu item, and searching for account table data corresponding to the report service identifier from a database according to the configuration file;

[0052] The account table data is sent to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0053] A device for generating a business account table, the device comprising:

[0054] A receiving module, used to receive the newly added report service object information uploaded by the terminal, wherein the report service object information includes a report service identifier and tree-shaped report node information;

[0055] An acquisition module, used to acquire a corresponding general account table object according to the report business identifier;

[0056] The receiving module is also used to receive a business account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree-shaped report node information;

[0057] A search module, used to obtain a configuration file corresponding to the menu item, and search the account table data corresponding to the report service identifier from a database according to the configuration file;

[0058] The sending module is used to send the account table data to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0059] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0060] Receiving newly added report service object information uploaded by the terminal, wherein the report service object information includes a report service identifier and tree-shaped report node information;

[0061] Obtain the corresponding general account table object according to the report business identifier;

[0062] Sending the general account table object to the terminal;

[0063] Receiving a business account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree-shaped report node information;

[0064] Obtaining a configuration file corresponding to the menu item, and searching for account table data corresponding to the report service identifier from a database according to the configuration file;

[0065] The account table data is sent to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0066] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0067] Receiving newly added report service object information uploaded by the terminal, wherein the report service object information includes a report service identifier and tree-shaped report node information;

[0068] Obtain the corresponding general account table object according to the report business identifier;

[0069] Sending the general account table object to the terminal;

[0070] Receiving a business account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree-shaped report node information;

[0071] Obtaining a configuration file corresponding to the menu item, and searching for account table data corresponding to the report service identifier from a database according to the configuration file;

[0072] The account table data is sent to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0073] The above-mentioned method, device, computer equipment and storage medium for generating business account tables obtain the newly added report business object information input by the user, and the report business object information includes the report business identifier and the tree report node information. Compared with the traditional business account table generation method, the corresponding general account table object is obtained according to the report business identifier, and the corresponding menu item is constructed according to the tree report node information in the menu interface corresponding to the tree report node information. A business account table data acquisition request corresponding to the menu item is sent to the server, and the account table data returned by the server according to the business account table data acquisition request is received. The account table data is obtained by the server by searching the configuration file corresponding to the menu item. The account table data is assigned to the general account table object, and the business report corresponding to the menu item is generated. As a result, when it is necessary to create multiple different types of business account tables at the same time, the terminal obtains the newly added report business object information input by the user, obtains the corresponding general account table object according to the report business identifier in the report business object information, and at the same time, in the menu interface corresponding to the tree report node information, the corresponding menu item is constructed according to the tree report node information. The terminal sends a request to obtain the business account table data corresponding to the menu item to the server. The server quickly obtains the account table data source by configuring the data retrieval SQL statement, and returns the corresponding account table data to the terminal according to the business account table data retrieval request. The terminal assigns the account table data to the general account table object and generates the business report corresponding to the menu item. It can quickly create a simple account table with full functions without installing the BOS designer or performing a large number of repetitive operations on the attribute configuration of each business account table. By using the field information in the configuration file as the data retrieval logic of the SQL statement, it can quickly publish the merged tree menu and the independent homepage menu, and can display all the accounts and tables in one interface, thereby effectively improving the generation efficiency of the business account table. BRIEF DESCRIPTION OF THE DRAWINGS

[0074] Figure 1 The following is an application environment diagram of a method for generating a business account table in one embodiment;

[0075] Figure 2 A schematic diagram of a flow chart of a method for generating a business account table in an embodiment;

[0076] Figure 2A This is a first interface display diagram of newly adding report business object information in an embodiment;

[0077] Figure 2B This is a second interface display diagram for adding report business object information in an embodiment;

[0078] Figure 2C A dynamic form display view corresponding to a tree menu in an embodiment;

[0079] Figure 3 A flowchart showing the steps of a business report corresponding to a menu item in a business report interface corresponding to a selected menu item in one embodiment;

[0080] Figure 4 The flowchart of the step of searching the account table data corresponding to the report business identifier from the database according to the mapping relationship between the configuration item information and the data retrieval SQL statement in one embodiment is as follows;

[0081] Figure 5 is a flow chart of a method for generating a business account table in another embodiment;

[0082] Figure 6 is a structural block diagram of a device for generating a business account table in one embodiment;

[0083] Figure 7 is a structural block diagram of a device for generating a business account table in another embodiment;

[0084] Figure 8 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0085] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0086] The method for generating a business account table provided in this application can be applied to Figure 1In the application environment shown in the figure, the terminal 102 communicates with the server 104 through the network. The terminal 102 can obtain the corresponding data from the server 104 by sending a data acquisition request to the server 104. The terminal 102 obtains the newly added report business object information input by the user, and the report business object information includes the report business identifier and the tree report node information. The terminal 102 obtains the corresponding general account table object from the server 104 according to the report business identifier. In the menu interface corresponding to the tree report node information, the terminal 102 constructs the corresponding menu item according to the tree report node information. The terminal 102 sends a business account table data acquisition request corresponding to the menu item to the server 104. The terminal 102 receives the account table data returned by the server 104 according to the business account table data acquisition request, and the account table data is obtained by the server 104 by searching the configuration file corresponding to the menu item. The terminal 102 assigns the account table data to the general account table object to generate the business report corresponding to the menu item. The terminal 102 may be, but is not limited to, various personal computers, laptop computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.

[0087] In one embodiment, Figure 2 As shown, a method for generating a business account table is provided, and the method is applied to Figure 1 The terminal in is used as an example to illustrate, including the following steps:

[0088] Step 202: Acquire the newly added report business object information input by the user, wherein the report business object information includes the report business identifier and tree-shaped report node information.

[0089] The terminal can communicate with the server through the network and stay online through the network communication connection. For example, different types of terminal devices can use the stable network transmission of the operator after connecting to the wireless network or local area network. In the current medical field, due to the particularity of medical institutions, it is necessary to establish various types of business report objects according to the functional characteristics of different departments. Each business report object can correspond to multiple different types of business reports. For example, the income business report can be subdivided into outpatient department income report, outpatient department doctor income report, inpatient department income report, and inpatient department doctor income report. The staff can log in to the medical system interface and enter the object information of different report businesses. The system can store electronic report information of different business objects. Among them, the report business object refers to the object that needs to report data. The report business object can include various types of report objects created by the user. For example, in the examination system, the user can use the student course grades as the report object according to different business needs. In the medical system, the user can also use the income of a doctor in a certain department as the report object. The terminal can form a dynamic data set by querying, filtering by form or connecting the data in the database for users to view, group, calculate statistics or modify the data. Most of the data in a report is obtained from base tables, queries or SQL statements, so they are the data sources of the report object. Other data in the report, such as data obtained from various calculations, will be stored in related controls corresponding to the report.

[0090] The terminal can use the report object to filter the corresponding data source from the database, summarize and count the data source, and generate the corresponding report. Specifically, the terminal can obtain the newly added report business object information input by the user, and the report business object information includes the report business identifier and the tree report node information. Among them, the report business identifier refers to the form identifier corresponding to the report business object, such as the form ID or form code. The tree report node information refers to the tree hierarchical menu information constructed by the tree control in the dynamic form, which is generally the various subdivided business nodes under the business object. The tree report node information can include the corresponding tree report name, node report information, configuration parameters, hierarchical information, etc. For example, the terminal can obtain the newly added report business object information input by the user as the newly added outpatient department income, the form ID corresponding to the newly added outpatient department income is KDY_BI_SummaryAnalysis, and the node report information corresponding to the tree report node information is KDY_FIN_ITEMCHARGE_ACCOUNTCAT.

[0091] Step 204: Obtain the corresponding general account table object according to the report business identifier.

[0092] After the terminal obtains the newly added report business object information input by the user, the terminal can obtain the corresponding general account table object according to the report business identifier in the newly added report business object information. Among them, the general account table object refers to the bearer view of the pre-set general account table, that is, a pre-configured general account table view, and the data content in the general account table view is empty. Specifically, after the terminal obtains the newly added report business object information input by the user, the terminal can send a data acquisition request to the server according to the report business identifier in the newly added report business object information. The server searches for the corresponding general account table object data from the database according to the report business identifier in the received data acquisition request, and returns the corresponding general account table object data to the terminal, that is, the terminal receives the general account table object data corresponding to the report business identifier returned by the server. For example, if the report business identifier in the newly added report business object information input by the terminal is KDY_BI_SummaryAnalysis, the terminal can send a data acquisition request to the server according to the above report business identifier. The server searches for the corresponding general account table object data from the database according to the report business identifier KDY_BI_SummaryAnalysis in the received data acquisition request, and returns the corresponding general account table object data to the terminal.

[0093] Step 206: In the menu interface corresponding to the tree-shaped report node information, corresponding menu items are constructed according to the tree-shaped report node information.

[0094] After the terminal obtains the newly added report business object information input by the user, in the menu interface corresponding to the tree report node information, the terminal constructs the corresponding menu items according to the tree report node information. Among them, the menu item refers to the tree-level menu entry bar constructed by the tree control in the dynamic form, and the tree control can construct different menu items according to different tree report node information. Specifically, the terminal can generate the corresponding menu interface according to the configured tree structure information. After the terminal obtains the newly added report business object information input by the user, in the menu interface corresponding to the existing tree report node information, the terminal can use the tree control to add the corresponding tree-level menu entry bar according to the newly added tree report node information. For example, the terminal can generate a corresponding tree-shaped comprehensive query statistical analysis menu interface based on the configured tree structure information. After the terminal obtains the newly added report business object information input by the user, which is the emergency doctor's income, in the existing tree-shaped comprehensive query statistical analysis menu interface, the terminal can use the tree control to add the corresponding tree-shaped hierarchical menu item bar according to the newly added tree report node information emergency doctor's income, that is, in the tree-shaped comprehensive query statistical analysis menu interface, create an emergency doctor's income menu item in the corresponding tree-shaped hierarchical menu.

[0095] Step 208: Send a request to the server for obtaining the business account table data corresponding to the menu item.

[0096] Step 210: receiving the account table data returned by the server according to the business account table data acquisition request. The account table data is obtained by searching the configuration file corresponding to the menu item by the server.

[0097] After the terminal constructs the corresponding menu item according to the tree-shaped report node information, the terminal can send a business account table data acquisition request corresponding to the menu item to the server. The server searches for the corresponding account table data from the database according to the configuration file corresponding to the menu item in the received business account table data acquisition request, and returns the corresponding account table data to the terminal, that is, the terminal receives the account table data corresponding to the menu item returned by the server. Among them, the configuration file refers to a plurality of pre-configured configuration item information, and the configuration item information may include the account table name, the header column definition (including double headers), the data column value type and display format, whether the column value displays the total (including group summary), the data source SQL script, the data result sorting, the field definition and assignment of the filtering business object (including the customized business parameter field constant), etc. The menu item is the corresponding menu item information generated according to the tree-shaped report node information. When the user customizes the tree-shaped report node information, the user can also customize the "report configuration parameter" information corresponding to the menu item. The "report configuration parameter" information records the corresponding XML configuration file information, thereby forming a mapping relationship between the menu item report and the XML configuration file. For example, the terminal can send a request to the server to obtain the business account table data corresponding to the menu item "emergency doctor's income". The server obtains the XML configuration file information corresponding to the menu item "emergency doctor's income" in the received business account table data acquisition request. The server uses the field information in the XML configuration file information as the data retrieval logic of the SQL statement, searches for the corresponding account table data from the database, and returns the corresponding account table data to the terminal, that is, the terminal receives the account table data corresponding to the menu item "emergency doctor's income" returned by the server.

[0098] Step 212, assign the account table data to the general account table object, and generate a business report corresponding to the menu item.

[0099] After the terminal receives the account table data returned by the server according to the business account table data acquisition request, the terminal assigns the account table data to the corresponding general account table object and generates a business report corresponding to the menu item. Among them, the business report refers to a statistical analysis table that summarizes the business content and data corresponding to the business object. The business nature and business content of each industry and unit are different, so many different types of business reports will be generated. Business reports are self-made reports within the unit, which can be customized according to the company's own management needs. For example, after the terminal receives the account table data returned by the server according to the emergency doctor income account table data acquisition request, the terminal assigns the account table data to the corresponding general account table object and generates a business report corresponding to the menu item emergency doctor income. The business report can display the amount data corresponding to the emergency doctor income.

[0100] In this embodiment, by obtaining the newly added report business object information input by the user, the report business object information includes the report business identifier and the tree report node information. Compared with the traditional business account table generation method, the corresponding general account table object is obtained according to the report business identifier, and the corresponding menu item is constructed according to the tree report node information in the menu interface corresponding to the tree report node information. A business account table data acquisition request corresponding to the menu item is sent to the server, and the account table data returned by the server according to the business account table data acquisition request is received. The account table data is obtained by the server by searching the configuration file corresponding to the menu item. The account table data is assigned to the general account table object, and the business report corresponding to the menu item is generated. As a result, when it is necessary to create multiple different types of business accounts and tables at the same time, the terminal obtains the corresponding general account table object according to the report business identifier in the report business object information by obtaining the newly added report business object information input by the user, and at the same time, in the menu interface corresponding to the tree report node information, the corresponding menu item is constructed according to the tree report node information. The terminal sends a request to obtain the business account table data corresponding to the menu item to the server. The server quickly obtains the account table data source by configuring the data retrieval SQL statement, and returns the corresponding account table data to the terminal according to the business account table data retrieval request. The terminal assigns the account table data to the general account table object and generates the business report corresponding to the menu item. It can quickly create a simple account table with full functions without installing the BOS designer or performing a large number of repetitive operations on the attribute configuration of each business account table. By using the field information in the configuration file as the data retrieval logic of the SQL statement, it can quickly publish the merged tree menu and the independent homepage menu, and can display all the accounts and tables in one interface, thereby effectively improving the generation efficiency of the business account table.

[0101] In one embodiment, the terminal can obtain the report business identifier entered by the user in the first interface and the tree-shaped report node information entered in the second interface, and the tree-shaped report node information includes report configuration parameter information. The report configuration parameter information is used to instruct the server to use the report configuration parameter information corresponding to the menu item to obtain the configuration file corresponding to the report configuration parameter information. Specifically, the user can log in to the business system corresponding to the enterprise by using the user name and password, and the user enters the tree-shaped report business object control interface through a trigger operation. The user can create the corresponding new report business object information by clicking the Add button. For example, Figure 2A As shown, the user can enter the name of the business object to be created, the coding information and the report business identifier in the first interface of adding a tree-shaped report business object. Figure 2B As shown, the user can also enter the customized tree report node information in the second interface corresponding to the newly added tree report business object. The tree report node information entered by the user may include the node report ID, node name, node code, sort number, parent information, level information, tree report information and report configuration parameter information. The terminal can obtain the report business identifier entered by the user in the first interface, and the tree report node information entered in the second interface. This allows users to customize the creation of corresponding tree menus and independent home page menu reports according to different business needs. By using the field information in the configuration file as the data retrieval logic of the SQL statement, the merged tree menu and independent home page menu can be quickly published, and all accounts and tables can be concentrated in one interface for display operations, thereby effectively improving the generation efficiency of business accounts and tables.

[0102] In one embodiment, before obtaining the newly added report business object information input by the user, the method further includes the step of uploading the dynamic form display view corresponding to the general account table to the server, specifically including:

[0103] Create basic information of tree report business objects.

[0104] Create corresponding tree report node information based on the basic information.

[0105] Create a dynamic form display view corresponding to the general account table based on the tree report node information.

[0106] Upload the dynamic form display view corresponding to the general account table to the server.

[0107] Before the terminal obtains the new report business object information input by the user, the staff can pre-create the basic information of the tree-shaped report business object. The terminal creates the corresponding tree-shaped report node information based on the created basic information. The terminal creates a dynamic form display view corresponding to the general account table based on the created tree-shaped report node information, and uploads the dynamic form display view corresponding to the created general account table to the server. Among them, the basic information for creating a tree-shaped report business object can include various types of business content information corresponding to the business object. The terminal can create the corresponding tree-shaped report node information based on the business information in the created basic information. For example, Figure 2C As shown, the dynamic form display view corresponding to a hospital tree menu. The staff can pre-create the basic information of the tree report business object corresponding to the monthly income of a hospital. The basic information of the tree report business object in the hospital business system may include the information of different departments corresponding to the hospital organization and the personnel information corresponding to each department. The terminal can create the corresponding tree report node information according to the above-mentioned basic information that has been created. For example, the tree report node information corresponding to the hospital organization may include the composition of the total hospital income, the distribution of outpatient income and expenditure, the composition of doctor income, the detailed statistics of the bill, the composition of department income, the collection statistics of the cashier, and the specific outpatient department income divided by different standards. For example, the terminal can classify multiple outpatient departments according to the invoice, create the dynamic form display view corresponding to the corresponding general account table, and upload the dynamic form display view corresponding to the created general account table to the server. As a result, the merged tree menu and the independent homepage menu can be published through the interface configuration without the need for custom parameter configuration, which greatly simplifies the operation process of business account table generation, thereby effectively improving the generation efficiency of business account tables.

[0108] In one embodiment, after generating the business report corresponding to the menu item, the method further includes the step of displaying the business report corresponding to the menu item, specifically including:

[0109] In the dynamic form display view, the configured business report tree menu list is displayed.

[0110] Gets the menu item selected from the business report tree menu list.

[0111] In the business report interface corresponding to the selected menu item, the business report corresponding to the menu item is displayed.

[0112] After the terminal assigns the account table data to the corresponding general account table object and generates the business report corresponding to the menu item, the terminal can display the configured business report tree menu list in the dynamic form display view corresponding to the business system. The user can select the business report data corresponding to the menu item he wants to view from the displayed business report tree menu list in the dynamic form display view corresponding to the business system, and the terminal can obtain the menu item selected by the above user from the business report tree menu list, and the terminal displays the business report corresponding to the menu item in the business report interface corresponding to the selected menu item. For example, after the terminal receives the account table data returned by the server according to the emergency doctor income account table data acquisition request, the terminal assigns the account table data to the corresponding general account table object and generates a business report corresponding to the menu item emergency doctor income. The terminal can display the configured business report tree menu list in the dynamic form display view corresponding to the hospital business system. The user can select the business report data corresponding to the emergency doctor income menu item from the displayed business report tree menu list in the dynamic form display view corresponding to the business system, and the terminal can obtain the emergency doctor income menu item selected by the user from the business report tree menu list, and the terminal displays the business report corresponding to the emergency doctor income in the business report interface corresponding to the emergency doctor income menu item, and the business report can display the amount data corresponding to the emergency doctor income. As a result, under a business module, all reports can be concentrated in one interface for display operations, and there is no need to generate a window interface for each report, which greatly simplifies the interface layout and operation, and avoids a large number of repetitive operations on the attribute configuration of each business account table in the traditional way. By using the field information in the configuration file as the data retrieval logic of the SQL statement, it is possible to quickly publish the merged tree menu and the independent homepage menu, thereby effectively improving the generation efficiency of the business account table.

[0113] In one embodiment, Figure 3 As shown, in the business report interface corresponding to the selected menu item, the steps of displaying the business report corresponding to the menu item include:

[0114] Step 302: Generate corresponding form data according to the selected menu item.

[0115] Step 304: Read the configuration item information in the configuration file corresponding to the selected menu item according to the form data.

[0116] Step 306: According to the mapping relationship between the configuration item information and the data retrieval SQL statement, the account table data corresponding to the report business identifier is searched from the database.

[0117] After the terminal assigns the account table data to the corresponding general account table object and generates the business report corresponding to the menu item, the terminal can display the configured business report tree menu list in the dynamic form display view corresponding to the business system. The user can select the business report data corresponding to the menu item he wants to view from the displayed business report tree menu list in the dynamic form display view corresponding to the business system, and the terminal can obtain the menu item selected by the user from the business report tree menu list, and the terminal displays the business report corresponding to the menu item in the business report interface corresponding to the selected menu item. Specifically, the terminal can generate the corresponding form data according to the menu item selected by the user. The terminal can read the "report configuration parameter" information corresponding to the selected menu item based on the form data. The user can customize the "report configuration parameter" information corresponding to the menu item. The "report configuration parameter" information records the corresponding XML configuration file information, thereby forming a mapping relationship between the menu item report and the XML configuration file. For example, the terminal can read multiple configuration item information in the XML configuration file corresponding to the selected menu item, and the terminal can send a business account table data acquisition request corresponding to the menu item emergency doctor income to the server. The server obtains the XML configuration file information corresponding to the menu item emergency doctor income in the received business account table data acquisition request, and uses the configuration item field information in the XML configuration file information as the data acquisition logic of the SQL statement, that is, according to the mapping relationship between the configuration item information and the data acquisition SQL statement, the server searches for the corresponding account table data from the database, and returns the corresponding account table data to the terminal, that is, the terminal receives the account table data corresponding to the menu item emergency doctor income returned by the server. This makes it possible to quickly create a simple account table with full functions without installing the BOS designer, and without a large number of repetitive operations on the attribute configuration of each business account table. By using the field information in the configuration file as the data acquisition logic of the SQL statement, it is convenient to quickly publish and modify the account table, which greatly improves the project construction efficiency and reduces the maintenance cost of the business account table.

[0118] In one embodiment, if Figure 4 As shown, according to the mapping relationship between the configuration item information and the data retrieval SQL statement, the steps of searching the account table data corresponding to the report business identifier from the database include:

[0119] Step 402: Obtain fields for filtering a business object form in the configuration item information.

[0120] Step 404: Use the fields of the filtered business object form as the processing logic of the data retrieval SQL statement to obtain the account table data source corresponding to the report business identifier from the database.

[0121] The terminal can send a business account table data acquisition request corresponding to the menu item to the server. The server can obtain the field information of the business object form filtered in the configuration item information according to the XML configuration file information corresponding to the menu item in the received business account table data acquisition request. The server can use the field information of the business object form filtered in the XML configuration item information as the data acquisition logic of the SQL statement, that is, according to the mapping relationship between the configuration item information and the data acquisition SQL statement, the server searches for the account table data corresponding to the report business identifier from the database, and returns the corresponding account table data found to the terminal, that is, the terminal receives the account table data corresponding to the menu item returned by the server. As a result, when it is necessary to create multiple different types of business accounts and tables at the same time, it is not necessary to install the BOS designer, nor is it necessary for the user to understand the logic and rules of different business account table attribute configurations. By using the field information in the configuration file as the data acquisition logic of the SQL statement, the attribute configuration of the account table can be easily set, and the merged tree menu and independent homepage menu can be quickly released, and all accounts and tables can be concentrated in one interface for display operations, thereby effectively improving the generation efficiency of business accounts and tables.

[0122] In one embodiment, Figure 5 As shown, a method for generating a business account table is provided, and the method is applied to Figure 1 The server in the example is used to illustrate the following steps:

[0123] Step 502: receiving the newly added report service object information uploaded by the terminal, wherein the report service object information includes the report service identifier and tree-shaped report node information.

[0124] Step 504: Obtain the corresponding general account table object according to the report business identifier.

[0125] Step 506: Send the general account table object to the terminal.

[0126] Step 508: receiving a request for obtaining business account table data corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to tree-shaped report node information.

[0127] Step 510, obtaining a configuration file corresponding to the menu item, and searching the database for account table data corresponding to the report service identifier according to the configuration file.

[0128] Step 512: Send the account table data to the terminal. The account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0129] The terminal can communicate with the server through the network and maintain an online state through the network communication connection. For example, different types of terminal devices can use the stable network transmission of the operator after connecting to a wireless network or a local area network. The server can receive the newly added report business object information uploaded by different terminals, and the report business object information includes the report business identifier and the tree report node information. The server can search for the corresponding general account table object from the database according to the report business identifier in the newly added report business object information. The server sends the found general account table object to the corresponding terminal. The server receives the business account table data acquisition request corresponding to the menu item sent by different terminals, and the menu item is constructed by the terminal according to the tree report node information. The server can obtain the configuration file corresponding to the menu item, and the server searches for the account table data corresponding to the report business identifier from the database according to the configuration file. The server sends the found account table data to the corresponding terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate the business report corresponding to the menu item.

[0130] In this embodiment, the newly added report business object information uploaded by the receiving terminal includes the report business identifier and the tree-shaped report node information. Compared with the traditional business account table generation method, the corresponding general account table object is obtained according to the report business identifier, and the general account table object is sent to the terminal. The business account table data acquisition request corresponding to the menu item sent by the receiving terminal is constructed according to the tree-shaped report node information. The configuration file corresponding to the menu item is obtained, and the account table data corresponding to the report business identifier is found from the database according to the configuration file. The account table data is sent to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate the business report corresponding to the menu item. As a result, when it is necessary to create multiple different types of business accounts and tables at the same time, the server obtains the corresponding general account table object according to the report business identifier in the report business object information by receiving the newly added report business object information uploaded by the terminal, and sends the general account table object to the terminal. At the same time, according to the business account table data acquisition request corresponding to the menu item sent by the terminal, the server obtains the configuration file corresponding to the menu item, configures the data acquisition logic of the SQL statement using the field information in the configuration file, quickly obtains the account table data source, and sends the acquired account table data to the terminal. The terminal assigns the account table data to the general account table object and generates the business report corresponding to the menu item, thereby realizing the rapid creation of a simple account table with full functions. There is no need to install the BOS designer, nor to perform a large number of repetitive operations on the attribute configuration of each business account table. By using the field information in the configuration file as the data acquisition logic of the SQL statement, the merged tree menu and the independent homepage menu can be quickly released, and all the accounts and tables can be displayed and operated in one interface, thereby effectively improving the generation efficiency of the business account tables.

[0131] It should be understood that although Figure 1-5 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 1-5 At least part of the steps may include multiple steps or multiple stages. These steps or stages are not necessarily performed at the same time, but can be performed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed in turn or alternately with other steps or at least part of the steps or stages in other steps.

[0132] In one embodiment, Figure 6 As shown, a device for generating a business account table is provided, comprising: an acquisition module 602, a construction module 604, a sending module 606, a receiving module 608 and a generating module 610, wherein:

[0133] The acquisition module 602 is used to acquire the newly added report business object information input by the user, the report business object information includes the report business identifier and tree report node information; and acquire the corresponding general account table object according to the report business identifier.

[0134] The construction module 604 is used to construct corresponding menu items according to the tree-shaped report node information in the menu interface corresponding to the tree-shaped report node information.

[0135] The sending module 606 is used to send a request for obtaining the business account table data corresponding to the menu item to the server.

[0136] The receiving module 608 is used to receive the account table data returned by the server according to the business account table data acquisition request. The account table data is obtained by searching the configuration file corresponding to the menu item by the server.

[0137] The generating module 610 is used to assign the account table data to the general account table object and generate a business report corresponding to the menu item.

[0138] In one embodiment, the acquisition module is further used to acquire the report service identifier input by the user in the first interface and the tree-shaped report node information input in the second interface, wherein the tree-shaped report node information includes report configuration parameter information. The report configuration parameter information is used to instruct the server to use the report configuration parameter information corresponding to the menu item to acquire a configuration file corresponding to the report configuration parameter information.

[0139] In one embodiment, the device further includes: a creation module and an upload module.

[0140] The creation module is used to create the basic information of the tree report business object; based on the basic information, create the corresponding tree report node information; based on the tree report node information, create the dynamic form display view corresponding to the general account table. The upload module is used to upload the dynamic form display view corresponding to the general account table to the server.

[0141] In one embodiment, the device further includes: a display module.

[0142] The display module is used to display the configured business report tree menu list in the dynamic form display view, obtain the menu item selected from the business report tree menu list, and display the business report corresponding to the menu item in the business report interface corresponding to the selected menu item.

[0143] In one embodiment, the device further includes: a reading module and a searching module.

[0144] The generation module is also used to generate corresponding form data according to the selected menu item. The reading module is used to read the configuration item information in the configuration file corresponding to the selected menu item according to the form data. The search module is used to search the account table data corresponding to the report business identifier from the database according to the mapping relationship between the configuration item information and the data retrieval SQL statement.

[0145] In one embodiment, the acquisition module is further used to obtain fields of the filtering business object form in the configuration item information, use the fields of the filtering business object form as the processing logic of the data acquisition SQL statement, and obtain the account table data source corresponding to the report business identifier from the database.

[0146] In one embodiment, Figure 7 As shown, a device for generating a business account table is provided, comprising: a receiving module 702, an acquiring module 704, a searching module 706 and a sending module 708, wherein:

[0147] The receiving module 702 is used to receive the newly added report business object information uploaded by the terminal, and the report business object information includes the report business identifier and tree-shaped report node information.

[0148] The acquisition module 704 is used to acquire the corresponding general account table object according to the report business identifier.

[0149] The receiving module 702 is further used to receive a request for obtaining business account table data corresponding to a menu item sent by a terminal, and the menu item is constructed according to the tree-shaped report node information.

[0150] The search module 706 is used to obtain a configuration file corresponding to the menu item, and search the account table data corresponding to the report business identifier from the database according to the configuration file.

[0151] The sending module 708 is used to send the account table data to the terminal. The account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item.

[0152] The specific definition of the business account table generation device can refer to the definition of the business account table generation method above, which will not be repeated here. Each module in the above-mentioned business account table generation device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0153] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as follows: Figure 8 As shown. The computer device includes a processor, a memory, a communication interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a method for generating a business account table is implemented. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covered on the display screen, or a key, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.

[0154] Those skilled in the art will understand that Figure 8 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0155] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the steps of the above-mentioned method embodiments when executing the computer program.

[0156] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0157] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0158] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A method for generating a business account table, the method comprising: Acquire the newly added report business object information input by the user, wherein the newly added report business object information includes the report business identifier and the newly added tree-shaped report node information; Obtaining a corresponding general account table object according to the report business identifier; the general account table object refers to a pre-set general account table bearer view, and the data content in the general account table view is empty; In the menu interface corresponding to the existing tree-shaped report node information, construct corresponding menu items into the corresponding tree-shaped hierarchical menu according to the newly added tree-shaped report node information; Sending a request to the server for obtaining business account table data corresponding to the menu item; Receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item; The account table data is assigned to the general account table object, and a business report corresponding to the menu item is generated.

2. The method according to claim 1, characterized in that The acquiring of the newly added report business object information input by the user includes: Obtain a report business identifier input by a user in a first interface and tree-structured report node information input in a second interface, wherein the input tree-structured report node information includes report configuration parameter information; wherein the report configuration parameter information is used to instruct the server to utilize the report configuration parameter information corresponding to the menu item to obtain a configuration file corresponding to the report configuration parameter information.

3. The method according to claim 1, characterized in that After generating the business report corresponding to the menu item, the method further includes: In the dynamic form display view corresponding to the general account table object, a configured business report tree menu list is displayed; Obtaining the menu item selected from the business report tree menu list; In the business report interface corresponding to the selected menu item, the business report corresponding to the menu item is displayed.

4. The method according to claim 3, characterized in that In the business report interface corresponding to the selected menu item, displaying the business report corresponding to the menu item includes: Generate corresponding form data according to the selected menu item; The method for searching the account table data includes: Reading configuration item information in a configuration file corresponding to the selected menu item according to the form data; According to the mapping relationship between the configuration item information and the data retrieval SQL statement, the account table data corresponding to the report business identifier is searched from the database.

5. The method according to claim 4, characterized in that The searching for the account table data corresponding to the report service identifier from the database according to the mapping relationship between the configuration item information and the data retrieval SQL statement includes: Obtaining fields for filtering business object forms in the configuration item information; The fields of the filtering business object form are used as the processing logic of the data acquisition SQL statement to obtain the account table data source corresponding to the report business identifier from the database.

6. A method for generating a business account table, characterized in that: include: Receiving newly added report service object information uploaded by the terminal, wherein the newly added report service object information includes a report service identifier and newly added tree-shaped report node information; Obtain the corresponding general account table object according to the report business identifier; Sending the general account table object to the terminal; A business account table data acquisition request corresponding to a menu item sent by a receiving terminal, wherein the menu item is constructed into a corresponding tree-shaped hierarchical menu according to the newly added tree-shaped report node information in a menu interface corresponding to the existing tree-shaped report node information; Obtaining a configuration file corresponding to the menu item, and searching for account table data corresponding to the report service identifier from a database according to the configuration file; The account table data is sent to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item; the general account table object refers to a pre-set general account table bearer view, and the data content in the general account table view is empty.

7. A device for generating a business account table, characterized in that: The device comprises: The acquisition module is used to acquire the newly added report business object information input by the user, wherein the newly added report business object information includes the report business identifier and the newly added tree-shaped report node information; and acquire the corresponding general account table object according to the report business identifier; the general account table object refers to the bearer view of the pre-set general account table, and the data content in the general account table view is empty; A construction module, used to construct corresponding menu items into corresponding tree-level menus according to the newly added tree-shaped report node information in a menu interface corresponding to the existing tree-shaped report node information; A sending module, used for sending a request for obtaining business account table data corresponding to the menu item to a server; A receiving module, used for receiving the account table data returned by the server according to the business account table data acquisition request, wherein the account table data is obtained by the server by searching the configuration file corresponding to the menu item; A generating module is used to assign the account table data to the general account table object and generate a business report corresponding to the menu item.

8. A device for generating a business account table, characterized in that: The device comprises: A receiving module, used to receive the newly added report business object information uploaded by the terminal, wherein the newly added report business object information includes the report business identifier and the newly added tree-shaped report node information; An acquisition module, used to acquire a corresponding general account table object according to the report business identifier; The receiving module is further used to receive a business account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed into a corresponding tree-shaped hierarchical menu according to the newly added tree-shaped report node information in a menu interface corresponding to the existing tree-shaped report node information; A search module, used to obtain a configuration file corresponding to the menu item, and search the account table data corresponding to the report service identifier from a database according to the configuration file; A sending module is used to send the account table data to the terminal, and the account table data is used to instruct the terminal to assign the account table data to the general account table object to generate a business report corresponding to the menu item; the general account table object refers to a pre-set general account table bearer view, and the data content in the general account table view is empty.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images