Disclosure of Invention
In view of the foregoing, it is desirable to provide a business account table generation method, apparatus, computer device, and storage medium that can improve the business account table generation efficiency.
A method of generating a business account table, the method comprising:
acquiring newly-added report business object information input by a user, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
constructing corresponding menu items according to the tree-shaped report node information in a menu interface corresponding to the tree-shaped report node information;
sending a service account table data acquisition request corresponding to the menu item to a server;
Receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server through configuration files corresponding to the menu items;
And assigning the account table data to the general account table object to generate a business report corresponding to the menu item.
In one embodiment, the obtaining the newly added report business object information input by the user includes:
The method comprises the steps of obtaining report service identifiers input by a user on a first interface and tree-shaped report node information input by a second interface, wherein the tree-shaped report node information comprises report configuration parameter information, and the report configuration parameter information is used for indicating the server to utilize report configuration parameter information corresponding to menu items to obtain configuration files corresponding to the report configuration parameter information.
In one embodiment, after the generating the service report corresponding to the menu item, the method further includes:
Displaying the configured service report tree menu list in the dynamic form display view corresponding to the general account object;
Acquiring a menu item selected from the service report tree menu list;
And displaying the business report corresponding to the menu item in the business report interface corresponding to the selected menu item.
In one embodiment, the displaying, in the service report interface corresponding to the selected menu item, the service report corresponding to the menu item includes:
generating corresponding form data according to the selected menu items;
The searching mode of the account table data comprises the following steps:
Reading configuration item information in a configuration file corresponding to the selected menu item according to the form data;
And searching account table data corresponding to the report service identifier from a database according to the mapping relation between the configuration item information and the access SQL statement.
In one embodiment, the searching, according to the mapping relationship between the configuration item information and the access SQL statement, account table data corresponding to the report service identifier from the database includes:
Acquiring a field of a filtering service object form in the configuration item information;
And taking the fields of the filtered service object form as processing logic of an access SQL statement, and acquiring an account table data source corresponding to the report service identifier from a database.
A business account table generation apparatus, the apparatus comprising:
The system comprises an acquisition module, a general account table object acquisition module, a user input module and a user input module, wherein the report business object information comprises a report business identifier and tree-shaped report node information;
The construction module is used for constructing corresponding menu items according to the tree-shaped report node information in a menu interface corresponding to the tree-shaped report node information;
the sending module is used for sending a service account table data acquisition request corresponding to the menu item to a server;
the receiving module is used for receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server through a configuration file corresponding to the menu item;
And the generation module is used for assigning the account table data to the general account table object and generating a business report corresponding to the menu item.
A computer device comprising a memory storing a computer program and a processor which when executing the computer program performs the steps of:
acquiring newly-added report business object information input by a user, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
constructing corresponding menu items according to the tree-shaped report node information in a menu interface corresponding to the tree-shaped report node information;
sending a service account table data acquisition request corresponding to the menu item to a server;
Receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server through configuration files corresponding to the menu items;
And assigning the account table data to the general account table object to generate a business report corresponding to the menu item.
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
acquiring newly-added report business object information input by a user, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
constructing corresponding menu items according to the tree-shaped report node information in a menu interface corresponding to the tree-shaped report node information;
sending a service account table data acquisition request corresponding to the menu item to a server;
Receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server through configuration files corresponding to the menu items;
And assigning the account table data to the general account table object to generate a business report corresponding to the menu item.
A business account table generation method comprises the following steps:
Receiving newly-added report business object information uploaded by a terminal, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
transmitting the general account table object to the terminal;
receiving a service account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree report node information;
acquiring a configuration file corresponding to the menu item, and searching account table data corresponding to the report service identifier from a database according to the configuration file;
And sending the account table data to the terminal, wherein the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
A business account table generation apparatus, the apparatus comprising:
The receiving module is used for receiving newly-added report business object information uploaded by the terminal, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
The acquisition module is used for acquiring a corresponding general account table object according to the report business identifier;
The receiving module is also used for receiving a service account table data acquisition request which is sent by the terminal and corresponds to a menu item, wherein the menu item is constructed according to the tree report node information;
The searching module is used for acquiring a configuration file corresponding to the menu item, and searching account table data corresponding to the report business identifier from a database according to the configuration file;
And the sending module is used for sending the account table data to the terminal, and the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
A computer device comprising a memory storing a computer program and a processor which when executing the computer program performs the steps of:
Receiving newly-added report business object information uploaded by a terminal, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
transmitting the general account table object to the terminal;
receiving a service account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree report node information;
acquiring a configuration file corresponding to the menu item, and searching account table data corresponding to the report service identifier from a database according to the configuration file;
And sending the account table data to the terminal, wherein the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
Receiving newly-added report business object information uploaded by a terminal, wherein the report business object information comprises report business identifiers and tree-shaped report node information;
Acquiring a corresponding general account table object according to the report business identifier;
transmitting the general account table object to the terminal;
receiving a service account table data acquisition request corresponding to a menu item sent by a terminal, wherein the menu item is constructed according to the tree report node information;
acquiring a configuration file corresponding to the menu item, and searching account table data corresponding to the report service identifier from a database according to the configuration file;
And sending the account table data to the terminal, wherein the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
The method, the device, the computer equipment and the storage medium for generating the business account table acquire the newly added report business object information input by the user, wherein the report business object information comprises report business identifiers and tree-shaped report node information. And compared with the traditional business account table generation mode, the method acquires the corresponding general account table object according to the report business identifier, and constructs the corresponding menu item according to the tree-form report node information in the menu interface corresponding to the tree-form report node information. And sending a service account table data acquisition request corresponding to the menu item to the server, and receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server by utilizing a configuration file corresponding to the menu item. And assigning the account table data to the general account table object to generate a business report corresponding to the menu item. Therefore, when a plurality of business account tables of different types are required to be created at the same time, the terminal acquires the corresponding general account table object according to the report business identifier in the report business object information by acquiring the newly-added report business object information input by the user, and simultaneously, in a menu interface corresponding to the tree-shaped report node information, a corresponding menu item is constructed according to the tree-shaped report node information. The terminal sends a service account table data acquisition request corresponding to menu items to the server, the server rapidly acquires account table data sources by configuring an SQL statement, and returns corresponding account table data to the terminal according to the service account table data acquisition request, the terminal assigns the account table data to a general account table object to generate a service report corresponding to the menu items, a full-function simple account table can be rapidly built, a BOS designer is not required to be installed, a great number of repeated operations are not required to be carried out on attribute configuration of each service account table, the rapid release and merging of tree menus and independent homepage menus can be realized by taking field information in a configuration file as the access logic of SQL statements, and all account tables can be concentrated in one interface for display operation, so that the generation efficiency of the service account table is effectively improved.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The method for generating the business account table provided by the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may acquire corresponding data from the server 104 by sending a data acquisition request to the server 104. The terminal 102 obtains newly added report business object information input by a user, wherein the report business object information comprises report business identifiers and tree report node information. The terminal 102 obtains the corresponding general account table object from the server 104 according to the report service identifier. In the menu interface corresponding to the tree report node information, the terminal 102 constructs a corresponding menu item according to the tree report node information. The terminal 102 transmits a service account table data acquisition request corresponding to the menu item to the server 104. The terminal 102 receives account table data returned by the server 104 according to the service account table data acquisition request, where the account table data is obtained by searching by the server 104 using a configuration file corresponding to the menu item. The terminal 102 assigns the account table data to the general account table object to generate a business report corresponding to the menu item. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smartphones, tablet computers, and portable wearable devices, and the server 104 may be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a method for generating a service account table is provided, and the method is applied to the terminal in fig. 1 for illustration, and includes the following steps:
Step 202, obtaining newly added report business object information input by a user, wherein the report business object information comprises report business identifiers and tree-shaped report node information.
The terminal may communicate with the server via a network, maintaining an online state via a network communication connection. For example, different types of terminal devices may be transported using an operator-stabilized network after connection to a wireless network or a local area network. In the current medical field, due to the specificity of medical institutions, multiple types of business report objects need to be established according to the function characteristics of different departments, each business report object can correspond to multiple different types of business reports, for example, a income class business report can be subdivided into an outpatient department income report, an outpatient department doctor income report, an inpatient department doctor income report and the like. The staff can input the object information of different report businesses by logging in the medical system interface, and the electronic report information of different business objects can be stored in the system. The report business object refers to an object needing to report data, and the report business object can comprise multiple types of report objects created by a user, for example, in a test system, the user can take student course achievements as report objects according to different business requirements. In the medical system, the user can also receive income of a doctor in a department as a report object. The terminal can form a dynamic data set by inquiring, screening or connecting data in the database so as to enable a user to conduct data review, grouping, statistical calculation or modification. Most of the data in a report is obtained from a base table, query, or SQL statement, and thus they are the data sources for the report objects. Other data in the report, such as various calculated data, is stored in the relevant control corresponding to the report.
The terminal can screen the corresponding data sources from the database by using the report objects, and summarize and count the data sources to generate the corresponding report. Specifically, the terminal may obtain newly added report business object information input by the user, where the report business object information includes a report business identifier and tree report node information. The report service identifier refers to a form identifier corresponding to the report service object, such as a form ID or a form code. The tree report node information refers to tree-level menu information constructed by tree controls in a dynamic form, and is generally subdivided service nodes under service objects. The tree report node information may include a corresponding tree report name, node report information, configuration parameters, hierarchy information, and the like. For example, the terminal may obtain the newly added report business object information input by the user as the newly added clinic income, the form ID corresponding to the newly added clinic income is kdy_bi_ SummaryAnalysis, and the node report information corresponding to the tree-form report node information is kdy_fin_ ITEMCHARGE _ ACCOUNTCAT.
And 204, acquiring a corresponding general account table object according to the report business identifier.
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. The general account table object refers to a preset bearing view of the general account table, namely a preset 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 may send a data acquisition request to the server according to the report business identifier in the newly added report business object information, and the server searches 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 searched 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 service identifier in the newly added report service object information input by the user is kdy_bi_ SummaryAnalysis, the terminal may send a data acquisition request to the server according to the report service identifier, and the server searches the corresponding general account table object data from the database according to the report service identifier kdy_bi_ SummaryAnalysis in the received data acquisition request, and returns the searched corresponding general account table object data to the terminal.
And 206, constructing corresponding menu items according to the tree report node information in a menu interface corresponding to the tree report node information.
After the terminal acquires the newly added report business object information input by the user, the terminal constructs a corresponding menu item according to the tree report node information in a menu interface corresponding to the tree report node information. The menu items refer to tree-level menu item columns constructed by tree controls in the dynamic form, and the tree controls can construct different menu items according to different tree report node information. Specifically, the terminal may generate a corresponding menu interface according to the configured tree structure information, and after the terminal obtains the newly added report business object information input by the user, the terminal may add a corresponding tree level menu entry column according to the newly added tree report node information by using the tree control in the menu interface corresponding to the existing tree report node information. For example, the terminal may generate a corresponding tree-shaped comprehensive query statistics analysis menu interface according to the configured tree-shaped structure information, and after the terminal obtains the new report business object information input by the user as income of the emergency doctor, in the existing tree-shaped comprehensive query statistics analysis menu interface, the terminal may add a corresponding tree-shaped hierarchical menu entry column according to the income of the emergency doctor of the new tree-shaped report node information by using the tree control, that is, create an emergency doctor income menu item into the corresponding tree-shaped hierarchical menu in the tree-shaped comprehensive query statistics analysis menu interface.
Step 208, a service account table data acquisition request corresponding to the menu item is sent to the server.
Step 210, receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching configuration files corresponding to menu items by the server.
After the terminal constructs the corresponding menu item according to the tree report node information, the terminal can send a service account table data acquisition request corresponding to the menu item to the server, the server searches the corresponding account table data from the database according to the configuration file corresponding to the menu item in the received service account table data acquisition request, and returns the searched corresponding account table data to the terminal, namely the terminal receives the account table data corresponding to the menu item returned by the server. The configuration file refers to a plurality of configuration item information configured in advance, and the configuration item information can include account table names, table header definition (including double table headers), data column value types and display formatting, whether column values are displayed in total (including grouping summary), data source SQL script, data result ordering, field definition and assignment of filtering service objects (including custom service parameter field constants), and the like. The menu item is corresponding menu item information generated according to the tree report node information, when the user creates the tree report node information in a self-defined way, the user can also set the report configuration parameter information corresponding to the menu item in a self-defined way, and the corresponding XML configuration file information is recorded in the report configuration parameter information, so that the mapping relation between the menu item report and the XML configuration file is formed. For example, the terminal may send a service account table data acquisition request corresponding to the menu item emergency doctor income to the server, the server uses field information in the XML configuration file information as the access logic of the SQL statement according to the XML configuration file information corresponding to the menu item emergency doctor income in the received service account table data acquisition request, searches the corresponding account table data from the database, and returns the searched 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.
And 212, assigning the account table data to the general account table object to generate a business report corresponding to the menu item.
After the terminal receives the account data returned by the server according to the service account data acquisition request, the terminal assigns the account data to the corresponding general account object to generate a service report corresponding to the menu item. The business report refers to a statistical analysis table for summarizing business content and data corresponding to the business object. Business properties of each unit in each industry are different from business contents, so that various business reports of different types can be generated. The business report is a self-made report in a unit, and can be customized according to the management needs of enterprises. For example, after receiving account data returned by the server according to the request for acquiring the account data of the emergency doctor, the terminal assigns the account data to a corresponding general account object to generate a business report corresponding to the income of the emergency doctor, wherein the business report can display the income corresponding amount data of the emergency doctor.
In this embodiment, the report business object information includes a report business identifier and tree-shaped report node information by acquiring newly added report business object information input by a user. And compared with the traditional business account table generation mode, the method acquires the corresponding general account table object according to the report business identifier, and constructs the corresponding menu item according to the tree-form report node information in the menu interface corresponding to the tree-form report node information. And sending a service account table data acquisition request corresponding to the menu item to the server, and receiving account table data returned by the server according to the service account table data acquisition request, wherein the account table data is obtained by searching by the server by utilizing a configuration file corresponding to the menu item. And assigning the account table data to the general account table object to generate a business report corresponding to the menu item. Therefore, when a plurality of business account tables of different types are required to be created at the same time, the terminal acquires the corresponding general account table object according to the report business identifier in the report business object information by acquiring the newly-added report business object information input by the user, and simultaneously, in a menu interface corresponding to the tree-shaped report node information, a corresponding menu item is constructed according to the tree-shaped report node information. The terminal sends a service account table data acquisition request corresponding to menu items to the server, the server rapidly acquires account table data sources by configuring an SQL statement, and returns corresponding account table data to the terminal according to the service account table data acquisition request, the terminal assigns the account table data to a general account table object to generate a service report corresponding to the menu items, a full-function simple account table can be rapidly built, a BOS designer is not required to be installed, a great number of repeated operations are not required to be carried out on attribute configuration of each service account table, the rapid release and merging of tree menus and independent homepage menus can be realized by taking field information in a configuration file as the access logic of SQL statements, and all account tables can be concentrated in one interface for display operation, so that the generation efficiency of the service account table is effectively improved.
In one embodiment, the terminal may obtain the report service identifier input by the user at the first interface and the tree-shaped report node information input by the user at the second interface, where the tree-shaped report node information includes report configuration parameter information. The report configuration parameter information is used for indicating the server to acquire a configuration file corresponding to the report configuration parameter information by utilizing the report configuration parameter information corresponding to the menu item. Specifically, the user can log in the business system corresponding to the enterprise in a user name and password mode, the user enters the tree report business object control interface through triggering operation, and the user can create corresponding newly added report business object information by clicking a newly added button. For example, as shown in fig. 2A, a user may input a service object name, coding information and a report service identifier to be created in a first interface of the newly added tree report service object. As shown in fig. 2B, the user may further input the tree report node information set by user in the second interface corresponding to the newly added tree report service object. The tree report node information input by the user can comprise node report ID, node name, node code, ranking number, superior information, hierarchical information, tree report information and report configuration parameter information. The terminal can acquire the report business identifier input by the user on the first interface and the tree-shaped report node information input by the user on the second interface. Therefore, a user can self-define and create corresponding tree-shaped menus and independent homepage menu reports according to different service demands, and can rapidly release and merge the tree-shaped menus and the independent homepage menus by taking field information in the configuration file as the fetch logic of the SQL statement, and can concentrate all account forms in one interface for display operation, so that the generation efficiency of the service account forms is effectively improved.
In one embodiment, before obtaining the newly added report business object information input by the user, the method further includes a step of uploading a dynamic form display view corresponding to the general account table to the server, and specifically includes:
and creating basic information of the tree report business object.
And creating corresponding tree report node information according to the basic information.
And creating a dynamic form display view corresponding to the general account table according to the tree form report node information.
And uploading the dynamic form display view corresponding to the general account table to a server.
Before the terminal obtains the newly added report business object information input by the user, the staff can create the basic information of the tree report business object in advance. And the terminal creates corresponding tree report node information according to the created basic information. And the terminal creates a dynamic form display view corresponding to the general account table according to the created tree report node information, and uploads the dynamic form display view corresponding to the created general account table to the server. The basic information for creating the tree report business object can comprise various types of business content information corresponding to the business object, and the terminal can create corresponding tree report node information according to the business information in the created basic information. For example, as shown in fig. 2C, a dynamic form presentation view corresponding to a certain hospital tree menu. The staff can pre-create the basic information of the corresponding tree-shaped report business object of the month income of a certain hospital, and the basic information of the tree-shaped report business object in the hospital business system can comprise the information of different departments corresponding to the hospital organization, the personnel information corresponding to each department and the like. The terminal can create corresponding tree report node information according to the created basic information, for example, the corresponding tree report node information under the hospital organization can comprise whole hospital income construction, clinic income distribution, doctor income construction, bill detail statistics, department income construction, toll collector collection statistics, specific clinic income divided according to different standards and the like. For example, the terminal may classify a plurality of outpatient departments according to the invoice, create a dynamic form presentation view corresponding to the corresponding general ledger sheet, and upload the dynamic form presentation view corresponding to the created general ledger sheet to the server. Therefore, the combined tree menu and independent homepage menu can be issued through interface configuration, custom parameter configuration is not needed, the operation flow of business account table generation is greatly simplified, and the business account table generation efficiency is effectively improved.
In one embodiment, after generating the service report corresponding to the menu item, the method further includes a step of displaying the service report corresponding to the menu item, and specifically includes:
and displaying the configured service report tree menu list in the dynamic form display view.
And acquiring a menu item selected from the service report tree menu list.
And displaying the business report corresponding to the menu item in the business report interface corresponding to the selected menu item.
The terminal assigns the account table data to the corresponding general account table object, and after generating 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. And the user can select the service report data corresponding to the menu item to be checked from the displayed service report tree menu list in the dynamic form display view corresponding to the service system, the terminal can acquire the menu item selected by the user from the service report tree menu list, and the terminal displays the service report corresponding to the menu item in the service report interface corresponding to the selected menu item. For example, after the terminal receives the account data returned by the server according to the emergency doctor income account data acquisition request, the terminal assigns the account data to the corresponding general account object to generate a business report corresponding to the income of the menu item emergency doctor. The terminal can display the configured service report tree menu list in the dynamic form display view corresponding to the hospital service system. In the dynamic form display view corresponding to the service system, the user can select service report data corresponding to the emergency doctor income menu item from the displayed service report tree menu list, the terminal can acquire the emergency doctor income menu item selected by the user from the service report tree menu list, the terminal displays a service report corresponding to emergency doctor income in a service report interface corresponding to the emergency doctor income menu item, and the service report can display monetary data corresponding to emergency doctor income. Therefore, under one business module, all the reports can be concentrated in one interface to be displayed, one report is not needed to generate one window interface, the layout and operation of the interface are greatly simplified, the attribute configuration of each business account table in the traditional mode is prevented from being subjected to a large number of repeated operations, and the combined tree menu and independent homepage menu can be rapidly issued by taking field information in the configuration file as the fetch logic of the SQL statement, so that the generation efficiency of the business account table is effectively improved.
In one embodiment, as shown in fig. 3, in the service report interface corresponding to the selected menu item, the step of displaying the service report corresponding to the menu item includes:
step 302, corresponding form data is generated according to the selected menu item.
And step 304, reading configuration item information in the configuration file corresponding to the selected menu item according to the form data.
And step 306, searching account table data corresponding to the report service identifier from the database according to the mapping relation between the configuration item information and the access SQL statement.
The terminal assigns the account table data to the corresponding general account table object, and after generating 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. And the user can select the service report data corresponding to the menu item to be checked from the displayed service report tree menu list in the dynamic form display view corresponding to the service system, the terminal can acquire the menu item selected by the user from the service report tree menu list, and the terminal displays the service report corresponding to the menu item in the service report interface corresponding to the selected menu item. Specifically, the terminal may generate 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 according to the form data, and the user can set the report configuration parameter information corresponding to the menu item in a self-defined manner, wherein the corresponding XML configuration file information is recorded in the report configuration parameter information, so that the mapping relation between the menu item report and the XML configuration file is formed. For example, the terminal may read a plurality of configuration item information in an XML configuration file corresponding to the selected menu item, the terminal may send a service account table data acquisition request corresponding to the income of the menu item emergency doctor to the server, the server uses the configuration item field information in the XML configuration file information as the fetch logic of the SQL statement, i.e. according to the mapping relationship between the configuration item information and the fetch SQL statement, the server searches the corresponding account table data from the database, and returns the searched corresponding account table data to the terminal, i.e. the terminal receives the account table data corresponding to the income of the menu item emergency doctor returned by the server. Therefore, a full-function simple account table can be quickly built, a BOS designer is not required to be installed, a great number of repeated operations are not required to be carried out on attribute configuration of each business account table, and the quick release and modification of the account table are facilitated by taking field information in a configuration file as the fetch logic of an SQL statement, so that project construction efficiency is greatly improved, and maintenance cost of the business account table is reduced.
In one embodiment, as shown in fig. 4, according to the mapping relationship between the configuration item information and the access SQL statement, the step of searching the database for the account table data corresponding to the report service identifier includes:
step 402, obtaining a field of a filtered service object form in the configuration item information.
And step 404, taking the fields of the filtered service object form as processing logic of the access SQL statement, and acquiring an account table data source corresponding to the report service identifier from the database.
The terminal can send a service account table data acquisition request corresponding to the menu item to the server, the server can acquire field information of a filtering service object table in the configuration item information according to XML configuration file information corresponding to the menu item in the received service account table data acquisition request, the server can take the field information of the filtering service object table in the XML configuration item information as the fetch logic of the SQL statement, namely according to the mapping relation between the configuration item information and the fetch SQL statement, the server searches account table data corresponding to the report service identifier from the database, and returns the searched corresponding account table data to the terminal, namely the terminal receives the account table data corresponding to the menu item returned by the server. Therefore, when a plurality of business account tables of different types are required to be created at the same time, a BOS designer is not required to be installed, and a user is not required to know logic and rules of attribute configuration of different business account tables, the attribute configuration of the account tables can be easily set by taking field information in a configuration file as the fetch logic of SQL sentences, so that a combined tree menu and an independent homepage menu can be quickly issued, and all the account tables can be concentrated in one interface to be displayed, thereby effectively improving the generation efficiency of the business account tables.
In one embodiment, as shown in fig. 5, a method for generating a service account table is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
Step 502, receiving newly added report business object information uploaded by a terminal, wherein the report business object information comprises report business identifiers and tree-shaped report node information.
And step 504, acquiring a corresponding general account table object according to the report business identifier.
And step 506, transmitting the general account table object to the terminal.
Step 508, receiving a service account table data acquisition request corresponding to a menu item sent by the terminal, wherein the menu item is constructed according to the tree report node information.
Step 510, obtaining a configuration file corresponding to the menu item, and searching account table data corresponding to the report business identifier from the database according to the configuration file.
And step 512, the account table data is sent to the terminal, and the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
The terminal may communicate with the server via a network, maintaining an online state via a network communication connection. For example, different types of terminal devices may be transported using an operator-stabilized network after connection to a wireless network or a local area network. The server can receive newly-increased report business object information uploaded by different terminals, wherein the report business object information comprises report business identifiers and tree-shaped report node information. The server can search the corresponding general account table object from the database according to the report business identifier in the newly added report business object information. And the server sends the searched general account table object to the corresponding terminal. The server receives service account table data acquisition requests which are sent by different terminals and correspond to menu items, wherein the menu items are constructed by the terminals according to tree report node information. The server can acquire the configuration file corresponding to the menu item, and the server searches account table data corresponding to the report business identifier from the database according to the configuration file. And the server sends the searched account table data to the corresponding terminal, wherein the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item.
In this embodiment, the report service object information includes a report service identifier and tree report node information by receiving newly added report service object information uploaded by the terminal. And compared with the traditional business account table generation mode, the method acquires the corresponding general account table object according to the report business identifier and sends the general account table object to the terminal. And receiving a service account table data acquisition request which is sent by the terminal and corresponds to a menu item, wherein the menu item is constructed according to the tree form report node information. And acquiring a configuration file corresponding to the menu item, and searching account table data corresponding to the report business identifier from the database according to the configuration file. And sending account table data to the terminal, wherein the account table data is used for indicating the terminal to assign the account table data to the general account table object and generating a business report corresponding to the menu item. Therefore, when a plurality of business account tables of different types are required to be simultaneously created, the server acquires 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. Meanwhile, the server obtains the request according to the business account table data corresponding to the menu item, which is sent by the terminal, the server utilizes the field information in the configuration file to configure the access logic of the SQL statement by obtaining the configuration file corresponding to the menu item, rapidly obtains the account table data source, sends the obtained account table data to the terminal, assigns the account table data to the general account table object, generates the business report corresponding to the menu item, rapidly builds a full-function simple account table, does not need to install a BOS designer, does not need to perform a great deal of repetitive operation on the attribute configuration of each business account table, can rapidly release the combined tree menu and independent homepage menu by taking the field information in the configuration file as the access logic of the SQL statement, and can centralize all the account tables in one interface for display operation, thereby effectively improving the generation efficiency of the business account table.
It should be understood that, although the steps in the flowcharts of fig. 1-5 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 1-5 may include multiple steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the steps or stages in other steps or other steps.
In one embodiment, as shown in fig. 6, there is provided a device for generating a service account table, including an acquisition module 602, a construction module 604, a sending module 606, a receiving module 608, and a generating module 610, where:
The obtaining module 602 is configured to obtain newly added report business object information input by a user, where the report business object information includes a report business identifier and tree-shaped report node information, and obtain a corresponding general account table object according to the report business identifier.
And the construction module 604 is used for constructing corresponding menu items according to the tree report node information in the menu interface corresponding to the tree report node information.
A sending module 606, configured to send a service account table data acquisition request corresponding to the menu item to the server.
And the receiving module 608 is configured to receive account table data returned by the server according to the service account table data acquisition request, where the account table data is obtained by searching a configuration file corresponding to the menu item by the server.
And the generating module 610 is configured to assign the account table data to the general account table object and generate a business report corresponding to the menu item.
In one embodiment, the obtaining module is further configured to obtain a report service identifier input by the user at the first interface, and tree-shaped report node information input by the user at the second interface, where the tree-shaped report node information includes report configuration parameter information. The report configuration parameter information is used for indicating the server to acquire a configuration file corresponding to the report configuration parameter information by utilizing the report configuration parameter information corresponding to the menu item.
In one embodiment, the apparatus further comprises a creation module and an upload module.
The creation module is used for creating basic information of the tree report business object, creating corresponding tree report node information according to the basic information, and creating a dynamic form display view corresponding to the general account table according to the tree report node information. And the uploading module is used for uploading the dynamic form display view corresponding to the general account table to the server.
In one embodiment, the apparatus further comprises a display module.
The display module is used for displaying the configured service report tree menu list in the dynamic form display view, acquiring menu items selected from the service report tree menu list, and displaying service reports corresponding to the menu items in a service report interface corresponding to the selected menu items.
In one embodiment, the apparatus further comprises a reading module and a searching module.
The generation module is also used for generating corresponding form data according to the selected menu items. The reading module is used for reading configuration item information in the configuration file corresponding to the selected menu item according to the form data. The searching module is used for searching account table data corresponding to the report service identifier from the database according to the mapping relation between the configuration item information and the access SQL statement.
In one embodiment, the obtaining module is further configured to obtain a field of the filtered service object form in the configuration item information, and obtain, from the database, an account table data source corresponding to the report service identifier with the field of the filtered service object form as processing logic of the access SQL statement.
In one embodiment, as shown in fig. 7, there is provided a device for generating a service account table, including a receiving module 702, an obtaining module 704, a searching module 706, and a sending module 708, where:
The receiving module 702 is configured to receive newly added report service object information uploaded by the terminal, where the report service object information includes a report service identifier and tree report node information.
And the obtaining module 704 is configured to obtain a corresponding general account table object according to the report service identifier.
The receiving module 702 is further configured to receive a service account table data acquisition request sent by the terminal and corresponding to a menu item, where the menu item is constructed according to the tree report node information.
And the searching module 706 is configured to obtain a configuration file corresponding to the menu item, and find out account table data corresponding to the report service identifier from the database according to the configuration file.
And the sending module 708 is configured to send account table data to the terminal, where the account table data is used to instruct the terminal to assign the account table data to a general account table object, and generate a business report corresponding to the menu item.
For specific limitations regarding the generation means of the service ledger sheet, reference may be made to the above limitation of the generation method of the service ledger sheet, and no further description is given here. The modules in the service account table generating device may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured 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 computer programs in the non-volatile storage media. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, an operator network, NFC (near field communication) or other technologies. The computer program, when executed by a processor, implements a method of generating a business ledger. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in FIG. 8 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided that includes a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the various method embodiments described above when the computer program is executed.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, or the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory. By way of illustration, and not limitation, RAM can be in various forms such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), etc.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.