Method, device, storage medium and terminal for dynamically obtaining report form field configuration

Abstract

The present invention relates to the technical field of information processing, and provides a method, apparatus, storage medium, and terminal for dynamically obtaining report fields through configuration. The method includes: obtaining a preset target bill template report according to a target user code; obtaining a target user bill report; determining target fields, where the target fields are common fields between the target user bill report and the target bill template report; and extracting data corresponding to the target fields in the target user bill report to obtain a target report pointed to by the target user code. The method of the present invention can quickly and specifically download the report content required by the user, avoiding the export of some irrelevant fields that interfere with the user's viewing.

Description

Technical Field

[0001] The present invention relates to the technical field of information processing, and particularly to a method, device, storage medium, and terminal for dynamically obtaining report fields through configuration. Background Art

[0002] In traditional technologies, report systems or download functions only provide fixed download templates and fixed table downloads, and cannot download data of different fields according to user needs. Business travel platforms are connected to different external enterprise customers, and these external enterprise customers have different requirements for the content of report data to be viewed. They may only need to view the content of certain fields. If reports are downloaded according to fixed templates, the data will inevitably be comprehensive. Therefore, it is necessarily cumbersome for enterprises to find the data they need to view among many fields. Summary of the Invention

[0003] In order to solve at least the above technical problem, the present invention proposes a method for dynamically obtaining report fields through configuration, and the present invention is specifically implemented by the following technical solutions:

[0004] A first aspect of the present invention proposes a method for dynamically obtaining report fields through configuration, and the method includes:

[0005] Obtain a preset target bill template report according to a target user code;

[0006] Obtain a target user's bill report;

[0007] Determine target fields, where the target fields are common fields between the target user's bill report and the target bill template report;

[0008] Extract data corresponding to the target fields in the target user's bill report to obtain a target report pointed to by the target user code.

[0009] In some possible implementation manners, the obtaining a preset target bill template report according to a target user code includes:

[0010] Query a bill template data table according to the target user code to obtain a query result, where the bill template data table records the correspondence between the target user code and the target bill template report;

[0011] In the case where the query result includes a single target bill template report, determine the single target bill template report as the target bill template report;

[0012] In the case where the query result includes multiple target bill template reports, display the query result;

[0013] In response to a selection instruction for a target bill template report in the query results, determine the target bill template report.

[0014] In some possible implementation manners, the method further includes at least one of the following operations:

[0015] In response to a data record addition instruction, based on the target user code and the target bill template report in the data record addition instruction, add corresponding data records to the bill template data table;

[0016] In response to a data record deletion instruction, based on the target user code and the target bill template report in the data record addition instruction, delete corresponding data records from the bill template data table;

[0017] In response to a data record modification instruction, based on the target user code, the first report, and the second report in the data record modification instruction, modify the target bill template report in the target record in the bill template data table to the second report, where the target record is the data record determined according to the target user code and the first report in the bill template database.

[0018] In some possible implementation manners, the method further includes:

[0019] Construct an alternative field set corresponding to the target user code;

[0020] Store the target field as an element in the alternative field set.

[0021] In some possible implementation manners, the method further includes:

[0022] In response to a selection instruction for an element in the alternative field set, determine a target element;

[0023] Based on the target element, generate a target bill template report or a target report corresponding to the target user code.

[0024] In some possible implementation manners, the method further includes:

[0025] In response to a target report download instruction, download the target report.

[0026] In some possible implementation manners, the method further includes:

[0027] Generate a target report printing instruction according to the target user code;

[0028] Transmit the target report printing instruction to the compound machine, trigger the compound machine to verify the download permission corresponding to the target user code, and download and print the target report when the download permission meets the preset requirements.

[0029] The second aspect of the present invention proposes a device for dynamically obtaining report field configuration, and the device includes:

[0030] A target bill template report acquisition module, configured to acquire a preset target bill template report according to the target user code;

[0031] A target user bill report acquisition module, configured to acquire a target user bill report;

[0032] A target field determination module, configured to determine a target field, where the target field is a common field between the target user bill report and the target bill template report;

[0033] A target report acquisition module, configured to extract data corresponding to the target field in the target user bill report to obtain a target report pointed to by the target user code.

[0034] The present invention also provides a storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the method for dynamically obtaining report field configuration as described above is implemented.

[0035] The present invention also provides a terminal, including one or more processors and a memory. The memory is coupled to the processor and is configured to store one or more programs; when the one or more programs are executed by the one or more processors, the one or more processors implement the method for dynamically obtaining report field configuration as described above.

[0036] Adopting the above technical solutions, the method and device for dynamically obtaining report field configuration according to the present invention have the following beneficial effects:

[0037] Operators now set the bill template in the background according to the needs of the enterprise. When downloading the bill report data of enterprise users, it is downloaded according to the set bill template, and only the fields set in the template will be displayed in the downloaded form, and there will be no redundant data that the enterprise does not need, thus simplifying the field structure of the enterprise bill report. Description of the Drawings

[0038] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for use in the description of the embodiments or the prior art. Obviously, the following drawings are only some embodiments of the present invention, and those of ordinary skill in the art can obtain other drawings based on these drawings without creative efforts.

[0039] Figure 1 It is a flowchart of the method for dynamically obtaining report form field configuration provided by an embodiment of the present invention;

[0040] Figure 2 It is a structural diagram of the device for dynamically obtaining report form field configuration provided by an embodiment of the present invention;

[0041] Figure 3 It is a schematic structural diagram of a computer terminal device provided by an embodiment of the present invention. Detailed implementation manners

[0042] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0043] In several embodiments provided in the present application, the described system embodiments are only illustrative. For example, the division of the modules is only a logical function division. In actual implementation, there may be other division methods. For example, multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the displayed or discussed mutual coupling or direct coupling or communication connection may be through some interfaces, and the indirect coupling or communication connection of modules or units may be in an electrical or other form.

[0044] The modules described as separate components may or may not be physically separated. The components displayed as modules may or may not be physical modules, that is, they may be located in one place, or may be distributed to multiple network modules. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0045] In addition, each functional unit in various embodiments of the present invention may be integrated in a processing module, or each unit may exist physically alone, or two or more units may be integrated in a module. The above integrated units can be implemented in the form of hardware or in the form of software functional units.

[0046] The first aspect of the present invention proposes a method for dynamically obtaining report form field configuration, as Figure 1 shown, the method includes:

[0047] S101. Obtain a preset target bill template report according to the target user code;

[0048] S102. Obtain the bill statement of the target user;

[0049] S103. Determine the target fields, where the target fields are the common fields between the target user bill statement and the target bill template statement;

[0050] S104. Extract the data corresponding to the target fields in the target user bill statement to obtain the target statement pointed to by the target user code

[0051] Specifically, an enterprise user logs in to the enterprise management platform. The user login information includes the username and user password. After successful login, the enterprise user will be bound to a dedicated target user code. When the enterprise user clicks to download the bill data, the system will obtain the target user code of the enterprise user according to the enterprise, and query the target bill template statement preset for the enterprise user in the system database. The target bill template statement is a report template uploaded in advance by the administrator after understanding the enterprise requirements. The administrator logs in to the system, selects the enterprise user, determines the business type of the enterprise user (such as air ticket / hotel / train ticket), obtains the most complete data fields corresponding to the business type of the enterprise user, and selects the field content of the bill template according to the enterprise requirements, confirms the target bill template statement corresponding to the enterprise user, binds it to the code of the enterprise user, and stores it in the system database. The field content of the target bill template statement is all the content required by the enterprise user; then obtain the target user bill statement from the system, traverse all the fields of the target user bill statement on the system according to the content of the target bill template statement, find the target fields that are the same as those in the target bill template statement in the target user bill statement, then render the data corresponding to the target fields in the target user bill statement into the target statement, and export the target statement to the enterprise user. The enterprise user can then intuitively view the required data. The data in the target user bill statement in the system will inevitably be large and comprehensive. It is inevitably a bit cumbersome for the enterprise to find the data it needs to view among many fields. By downloading according to the set bill template, only the fields set in the template will be displayed in the downloaded form, and there will be no redundant data that the enterprise does not need, thus simplifying the field structure of the enterprise bill statement.

[0052] In one embodiment, the obtaining the preset target bill template statement according to the target user code includes:

[0053] Query the bill template data table according to the target user code to obtain a query result. The bill template data table records the corresponding relationship between the target user code and the target bill template statement;

[0054] In the case where the query result includes a single target bill template statement, determine the single target bill template statement as the target bill template statement;

[0055] In the case where a plurality of target bill template reports are included in the query result, display the query result;

[0056] In response to a selection instruction for the target bill template report in the query result, determine the target bill template report.

[0057] After an enterprise user logs in to the system, obtain a target user code, and then obtain a pre-established target bill template report according to the target user. The target user code is recorded on the target bill template report so that the system can find the corresponding target bill template report according to the target user code. If only one target bill template report is queried, select this unique target bill template; if multiple target bill template reports are queried, the enterprise user selects a suitable target bill template according to needs; the multiple target bill template reports are different target bill template reports established by the administrator according to different needs of the enterprise user.

[0058] In one embodiment, the method further includes at least one of the following operations:

[0059] In response to a data record addition instruction, based on the target user code and the target bill template report in the data record addition instruction, add corresponding data records to the bill template data table;

[0060] In response to a data record deletion instruction, based on the target user code and the target bill template report in the data record addition instruction, delete corresponding data records from the bill template data table;

[0061] In response to a data record modification instruction, based on the target user code, the first report, and the second report in the data record modification instruction, modify the target bill template report in the target record in the bill template data table to the second report, where the target record is the data record determined according to the target user code and the first report in the bill template database.

[0062] According to the target user code, query and select a target bill template report. For the selected target bill template report, the enterprise user can, according to actual needs, perform an editing operation on the target bill template report. If there are data records in the target bill template report that the enterprise user does not need, to prevent interference with the enterprise user's reading, a data record deletion operation can be performed. If the target bill template report does not contain the data records required by the enterprise user, a data record addition operation is performed; if the enterprise user, after selecting a target bill template report, finds that another target bill template report needs to be reselected, the target bill template can be modified.

[0063] In one embodiment, the method further includes:

[0064] Construct a set of alternative fields corresponding to the target user code;

[0065] Store the target field as an element in the set of alternative fields.

[0066] Construct a set of alternative fields in the system database. The set of alternative fields is used to store the target user codes of all users, and each target user code is bound to a user name. In this way, after the user logs in, the exclusive target user code can be obtained according to the user name.

[0067] In one embodiment, the method further includes:

[0068] Respond to a selection instruction for an element in the set of alternative fields to determine a target element;

[0069] Generate a target bill template report or a target report corresponding to the target user code based on the target element.

[0070] Determine the proprietary target user code of the enterprise user according to the user name, query the system database according to the target user code, and determine the target bill template report.

[0071] In one embodiment, the method further includes:

[0072] Respond to a target report download instruction to download the target report.

[0073] After determining the final target report and selecting to download, the system can download the final target report after determining that the enterprise user has the download qualification according to the target user code of the enterprise user.

[0074] In one embodiment, the method further includes:

[0075] Generate a target report printing instruction according to the target user code;

[0076] Transmit the target report printing instruction to the multifunction machine, trigger the multifunction machine to verify the download permission corresponding to the target user code, and download and print the target report when the download permission meets the preset requirements.

[0077] Determine the final target report. If the enterprise user needs to print the enterprise report, select to print. The multifunction machine determines whether the enterprise user has the corresponding download permission according to the target user code of the enterprise user. If so, print the target report. If not, prompt that there is no printing permission.

[0078] Please refer to Figure 2 , a report field configuration-based dynamic acquisition device is proposed in the second aspect of the present invention. The device includes:

[0079] The target bill template report acquisition module 10 is used to acquire a preset target bill template report according to a target user code;

[0080] The target user bill report acquisition module 20 is used to acquire a target user bill report;

[0081] The target field determination module 30 is used to determine a target field, and the target field is a common field between the target user bill report and the target bill template report;

[0082] The target report acquisition module 40 is used to extract data corresponding to the target field in the target user bill report to obtain a target report pointed to by the target user code.

[0083] For the specific definition of the report field configuration-based dynamic acquisition device, reference can be made to the definition in the above text, which will not be elaborated here.

[0084] Each module in the above report field configuration-based dynamic acquisition device can be implemented in whole or in part by software, hardware, and their combination. Each of the above modules can be embedded in the processor in the computer device in the form of hardware or be independent of the processor, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0085] Please refer to Figure 3 , an embodiment of the present invention provides a terminal, including one or more processors and a memory. The memory is coupled to the processor and is used to store one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors implement the report field configuration-based dynamic acquisition method in any one of the above embodiments.

[0086] The processor is used to control the overall operation of the computer terminal device to complete all or part of the steps of the above-mentioned method for dynamically obtaining report form field configuration. The memory is used to store various types of data to support the operation of the computer terminal device. These data may include, for example, instructions for any application or method operating on the computer terminal device, as well as application-related data. The memory can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk.

[0087] In an exemplary embodiment, the computer terminal device can be implemented by one or more application specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, microcontrollers, microprocessors or other electronic components, and is used to execute the above-mentioned method for dynamically obtaining report form field configuration and achieve the same technical effects as the above method.

[0088] In another exemplary embodiment, a storage medium including program instructions is further provided. When the program instructions are executed by a processor, the steps of the method for dynamically obtaining report form field configuration in any one of the above embodiments are implemented. For example, the storage medium can be the above-mentioned memory including program instructions, and the above program instructions can be executed by the processor of the terminal to complete the above-mentioned method for dynamically obtaining report form field configuration and achieve the same technical effects as the above method.

[0089] The foregoing are only preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims

1. A method for dynamically obtaining report fields through configuration, characterized in that The method includes: Obtain a preset target bill template report according to the target user code, where the fields in the target bill template report are fields preset based on the user's viewing requirements; Obtain a target user bill report, where the number of fields in the target bill template report is less than the number of fields in the target user bill report; Determine target fields, where the target fields are the common fields between the target user bill report and the target bill template report; Extract the data corresponding to the target fields in the target user bill report and render it into a target report to obtain the target report pointed to by the target user code; Generate a target report printing instruction according to the target user code; Transmit the target report printing instruction to a multifunction printer, trigger the multifunction printer to verify the download permission corresponding to the target user code, and download and print the target report when the download permission meets the preset requirements; Construct an alternative field set corresponding to the target user code; Use the target fields as an element in the alternative field set and store it in the alternative field set, where the alternative field set is used to generate the target bill template report corresponding to the target user code or the target report corresponding to the target user code.

2. The method according to claim 1, wherein The step of obtaining a preset target bill template report according to the target user code includes: Query a bill template data table according to the target user code to obtain a query result, where the bill template data table records the correspondence between the target user code and the target bill template report; When the query result includes a single target bill template report, determine the single target bill template report as the target bill template report; When the query result includes multiple target bill template reports, display the query result; In response to a selection instruction for the target bill template report in the query result, determine the target bill template report.

3. The method according to claim 2, wherein The method further includes at least one of the following operations: In response to a data record addition instruction, based on the target user code and the target bill template report in the data record addition instruction, add corresponding data records to the bill template data table; In response to a data record deletion instruction, based on the target user code and the target bill template report in the data record addition instruction, delete corresponding data records from the bill template data table; In response to a data record modification instruction, based on the target user code, the first report, and the second report in the data record modification instruction, modify the target bill template report in the target record in the bill template data table to the second report, where the target record is the data record determined according to the target user code and the first report in the bill template database.

4. The method according to claim 1, wherein The method further includes: In response to a selection instruction for an element in the alternative field set, determine a target element; Based on the target element, generate the target bill template report or the target report corresponding to the target user code.

5. The method according to claim 1, characterized in that The method further includes: In response to a target report download instruction, download the target report.

6. A device for dynamically obtaining report form field configuration, characterized in that The device includes: A target bill template report acquisition module, configured to acquire a preset target bill template report according to a target user code, where the fields in the target bill template report are fields preset based on user viewing requirements; A target user bill report acquisition module, configured to acquire a target user bill report, where the number of fields in the target bill template report is less than the number of fields in the target user bill report; A target field determination module, configured to determine target fields, where the target fields are common fields between the target user bill report and the target bill template report; A target report acquisition module, configured to extract data corresponding to the target fields in the target user bill report and render the data into a target report, to obtain the target report pointed to by the target user code; A print instruction generation module, configured to generate a target report print instruction according to the target user code; A print module, configured to transmit the target report print instruction to a multifunction printer, trigger the multifunction printer to verify the download permission corresponding to the target user code, and download and print the target report when the download permission meets preset requirements; An alternative field set construction module, configured to construct an alternative field set corresponding to the target user code; A target field storage template, configured to store the target fields as an element in the alternative field set, where the alternative field set is used to generate a target bill template report corresponding to the target user code or a target report corresponding to the target user code.

7. A storage medium, characterized in that, The storage medium stores instructions, and when the instructions are executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

8. A terminal, characterized in that, Comprising a memory and a processor, the memory stores instructions, and the processor loads the instructions to execute the steps of the method according to any one of claims 1 to 5.

Images