Business document generation method, system, device and storage medium

Abstract

The present invention provides a business file generation method, system, device and storage medium, and relates to the field of computer application technology. The business file generation method comprises: obtaining business initial files from multiple data sources; obtaining business scenarios corresponding to the business initial files and target file processing rules in the business scenarios; obtaining the content of the field to be processed according to the target file processing rules; obtaining the target field content in the business initial file according to the content of the field to be processed, and storing the target field position corresponding to the target field content; generating a business result file according to the business initial file, the target file processing rules and the stored target field position. The present invention can automatically generate business data in batches according to designated fields and personalized rules, thereby improving file processing efficiency and accuracy.

Description

Technical Field

[0001] The present invention relates to the field of computer application technology, and more specifically, to a business document generation method, system, device and storage medium. Background Art

[0002] Most modifications to business files involve adding custom text content to a specified location, or modifying a keyword location to a custom text content. The traditional method for modifying business files is to select one or more files, enter the content that needs to be replaced in batches, and then enter the new content to replace the old content with the new content, thereby completing the purpose of batch modification of the content. However, traditional methods for modifying business files mostly modify Chinese articles, etc., and cannot modify the business file data in the consumer finance industry. Specifically, in actual testing work, when it comes to modifying data and creating test scenario files, it is necessary to manually query the data content in the dependent service library, and after manually calculating and adding the data, it is necessary to manually modify the content value of the specified field of the batch file to obtain the business file for testing the corresponding business scenario. The above manual data modification operations are cumbersome, low in accuracy and cannot be reused. There are many files and fields associated in the processing process, and it takes a lot of time to calculate and modify the files.

[0003] Therefore, there is an urgent need for a technical solution that can automatically generate business data in batches according to specified fields and personalized rules to solve the problems of low efficiency and low accuracy of the current manual number-generating method.

[0004] In addition, the current manual number-generating method cannot save personalized historical modification rules for subsequent file modification, nor can it classify and manage business file generation rules. Summary of the invention

[0005] In order to solve the problems existing in the above-mentioned prior art or at least part of the problems, the embodiments of the present invention provide a business file generation method, system, storage medium, device and computer program product, which automatically generates a business result file according to the business initial file, the target file processing rules and the stored target field position, thereby improving the file processing efficiency and accuracy.

[0006] According to the first aspect of the present invention, an embodiment of the present invention provides a business file generation method, which includes: obtaining business initial files from multiple data sources; obtaining business scenarios corresponding to the business initial files and target file processing rules in the business scenarios; obtaining the content of the field to be processed according to the target file processing rules; obtaining the target field content in the business initial file according to the content of the field to be processed, and storing the target field position corresponding to the target field content; generating a business result file according to the business initial file, the target file processing rules and the stored target field position.

[0007] According to the above-mentioned embodiment of the present invention, the target field position of the target field content in the business initial file is obtained and stored based on the target file processing rules corresponding to the business initial file, and then the business result file is automatically generated directly according to the business initial file, the target file processing rules and the stored target field position. It is possible to automatically generate business data in batches according to specified fields and personalized rules, thereby improving file processing efficiency and accuracy and avoiding the tedious work of manually modifying data.

[0008] In some embodiments of the present invention, obtaining the target file processing rule includes: querying whether the existing file processing rules stored in the database include the target file processing rule; if the existing file processing rules include the target file processing rule, obtaining the target file processing rule from the database; if the existing file processing rules do not include the target file processing rule, storing the target file processing rule in the database.

[0009] According to the above-mentioned embodiment of the present invention, by storing various file processing rules in a database, it is possible to save personalized rules, thereby facilitating rule management and reuse. Furthermore, when generating business result files for business initial files from different data sources, the corresponding target file processing rules can be directly obtained from the database, thereby improving the work efficiency of generating data.

[0010] In some implementations of the present invention, the existing file processing rules in the database are classified and stored according to data sources and product categories.

[0011] According to the above-mentioned embodiment of the present invention, by classifying and storing the file processing rules according to the data source and the product category, it is not only convenient for displaying and actually using the rules, but also convenient for maintaining the rules.

[0012] In some implementations of the present invention, the business file generation method further includes: when the field position in the business initial file changes, changing the stored target field position.

[0013] According to the above-mentioned embodiment of the present invention, when the field position in the business initial file changes, only by storing the corresponding target field position of the change, the business initial file and its corresponding file processing rules can be continued to automatically generate the business result file, thereby achieving the effect of reusable file processing rules.

[0014] According to the second aspect of the present invention, an embodiment of the present invention provides a business file generation system, which includes: an initial file acquisition module, used to acquire business initial files from multiple data sources; a rule acquisition module, used to acquire the business scenario corresponding to the business initial file and the target file processing rule in the business scenario; a field position storage module, used to acquire the content of the field to be processed according to the target file processing rule, acquire the target field content in the business initial file according to the content of the field to be processed, and store the target field position corresponding to the target field content; a file generation module, used to generate a business result file according to the business initial file, the target file processing rule and the stored target field position.

[0015] According to the above-mentioned embodiment of the present invention, the target field position of the target field content in the business initial file is obtained and stored based on the target file processing rules corresponding to the business initial file, and then the business result file is automatically generated directly according to the business initial file, the target file processing rules and the stored target field position. It is possible to automatically generate business data in batches according to specified fields and personalized rules, thereby improving file processing efficiency and accuracy and avoiding the tedious work of manually modifying data.

[0016] In some embodiments of the present invention, obtaining the target file processing rule includes: querying whether the existing file processing rules stored in the database include the target file processing rule; if the existing file processing rules include the target file processing rule, obtaining the target file processing rule from the database; if the existing file processing rules do not include the target file processing rule, storing the target file processing rule in the database.

[0017] According to the above-mentioned embodiment of the present invention, by storing various file processing rules in a database, it is possible to save personalized rules, thereby facilitating rule management and reuse. Furthermore, when generating business result files for business initial files from different data sources, the corresponding target file processing rules can be directly obtained from the database, thereby improving the work efficiency of generating data.

[0018] In some implementations of the present invention, the existing file processing rules in the database are classified and stored according to data sources and product categories.

[0019] According to the above-mentioned embodiment of the present invention, by classifying and storing the file processing rules according to the data source and the product category, it is not only convenient for displaying and actually using the rules, but also convenient for maintaining the rules.

[0020] In some implementations of the present invention, the field position storage module is further configured to change the stored target field position when the field position in the business initial file changes.

[0021] According to the above-mentioned embodiment of the present invention, when the field position in the business initial file changes, only by storing the corresponding target field position of the change, the business initial file and its corresponding file processing rules can be continued to automatically generate the business result file, thereby achieving the effect of reusable file processing rules.

[0022] According to the third aspect of the present invention, an embodiment of the present invention provides a computer-readable storage medium having computer-readable instructions stored thereon. When the computer-readable instructions are executed by a processor, the computer performs the following operations: the operations include the steps included in the business document generation method described in any one of the above embodiments.

[0023] According to the fourth aspect of the present invention, an embodiment of the present invention provides a computer device including a memory and a processor, wherein the memory is used to store one or more computer-readable instructions, wherein the one or more computer-readable instructions, when executed by the processor, can implement the business document generation method described in any one of the above embodiments.

[0024] According to a fifth aspect of the present invention, an embodiment of the present invention provides a computer program product including a computer program, and when the computer program is executed by a processor, the business document generation method as described in any one of the above embodiments is implemented.

[0025] From the above, it can be seen that the business file generation method, system, storage medium, device and computer program product provided in the embodiments of the present invention obtain the target field position of the target field content in the business initial file based on the target file processing rules corresponding to the business initial file and store it, and then automatically generate the business result file directly according to the business initial file, the target file processing rules and the stored target field position, and can realize the automatic generation of business data in batches according to specified fields and personalized rules, thereby improving file processing efficiency and accuracy, and avoiding the tedious work of manually modifying data. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 is a flow chart of a method for generating a business document according to Embodiment 1 of the present invention;

[0027] Figure 2 is a schematic diagram of a storage structure for storing a target field position according to an embodiment of the present invention;

[0028] Figure 3 is a flow chart of a method for generating a business document according to Embodiment 2 of the present invention;

[0029] Figure 4 is a schematic diagram of field definition content provided by a third party according to an embodiment of the present invention;

[0030] Figure 5 is a schematic diagram of the definition of the fields in the repayment details table according to an embodiment of the present invention;

[0031] Figure 6 2 is a schematic diagram of the architecture of a business document generation system according to Embodiment 3 of the present invention. DETAILED DESCRIPTION

[0032] The various aspects of the present invention are described in detail below in conjunction with the accompanying drawings and specific embodiments. Among them, well-known modules, units and their connections, links, communications or operations are not shown or described in detail. In addition, the described features, architectures or functions can be combined in any way in one or more embodiments. It should be understood by those skilled in the art that the various embodiments described below are only used for illustration and are not intended to limit the scope of protection of the present invention. It can also be easily understood that the modules or units or processing methods in each embodiment described herein and shown in the accompanying drawings can be combined and designed in various different configurations.

[0033] The following is a brief description of the terms used in this article.

[0034] txt file: plain text file.

[0035] sql: Structured Query Language, structured query language.

[0036] FileSaver.js: A JavaScript library that implements file saving functionality in a browser environment.

[0037] saveAs: Method in the FileSaver.js library used to trigger a file save operation.

[0038] [Example 1]

[0039] Figure 1 4 is a flow chart of a method for generating a business document according to Embodiment 1 of the present invention.

[0040] like Figure 1 As shown, in Embodiment 1 of the present invention, the business document generation method may include: step S11, step S12, step S13, step S14 and step S15, and the above steps are described in detail below.

[0041] In step S11, business initial files from multiple data sources are obtained, wherein the business initial files include but are not limited to: repayment plan files, loan information files, repayment details files, repayment reconciliation files, loan reconciliation files, etc.

[0042] In some embodiments, the Python language + Django framework development system is used to provide a front-end page accessed by a browser, and a business data file function is imported into the page to obtain business initial files / basic business files from multiple data sources. The business initial files / basic business files are used to batch generate corresponding business result files.

[0043] In some implementations, the business initialization file is, for example, a txt file, and the txt file is read line by line and each field is split according to a delimiter (eg, “|”) of the txt file to read the content of the business initialization file.

[0044] In step S12, the business scenario corresponding to the business initial file and the target file processing rule in the business scenario are obtained.

[0045] In some embodiments, obtaining the target file processing rule includes: querying whether the existing file processing rules stored in the database include the target file processing rule; if the existing file processing rules include the target file processing rule, obtaining the target file processing rule from the database; if the existing file processing rules do not include the target file processing rule, storing the target file processing rule in the database.

[0046] In a further embodiment, the existing file processing rules in the database are classified and stored according to data sources and product categories. For example, the existing file processing rules in the database are classified and stored according to third-party company classifications and product lists under the corresponding companies.

[0047] In an exemplary embodiment, the business scenarios include, but are not limited to: normal repayment, early settlement, etc.

[0048] In step S13, the content of the field to be processed is obtained according to the target file processing rule.

[0049] In step S14, the target field content in the business initial file is obtained according to the to-be-processed field content, and the target field position corresponding to the target field content is stored.

[0050] In step S15, a business result file is generated according to the business initial file, the target file processing rule and the stored target field position.

[0051] The above-mentioned business file generation method of Example 1 of the present invention is adopted to obtain the target field position of the target field content in the business initial file based on the target file processing rule corresponding to the business initial file and store it, and then automatically generate the business result file directly according to the business initial file, the target file processing rule and the stored target field position. It can realize the automatic generation of business data in batches according to the specified fields and personalized rules, thereby improving the file processing efficiency and accuracy, and avoiding the tedious work of manually modifying data.

[0052] In a further embodiment, the business file generation method further includes: when the field position in the business initial file changes, the stored target field position is changed. When the field position in the business initial file changes, only by correspondingly changing the stored target field position (i.e., the mapping relationship), the business initial file and its corresponding file processing rules can be continued to be followed up to automatically generate a business result file, thereby achieving the effect of reusable file processing rules.

[0053] The present invention provides an example of storing the target field position, such as Figure 2 As shown, product a of company A includes a normal repayment scenario. According to the target file processing rules in the normal repayment scenario, the contents of the fields to be processed include the principal to be repaid, the interest to be repaid, the penalty interest to be repaid, etc. Then, the fields required by the formula, such as the principal to be repaid, the interest to be repaid, the penalty interest to be repaid, etc., are mapped to the target field positions corresponding to the target field contents in the business initial file (for example, field mappings 1, 4, and 5 for product a) and stored. When the fields of the business initial file are added and / or modified, the stored target field positions (mapping position information) are changed accordingly.

[0054] [Example 2]

[0055] Figure 3 4 is a flow chart of a method for generating a business document according to Embodiment 2 of the present invention.

[0056] like Figure 3 As shown, in Embodiment 2 of the present invention, the business file generation method may include the following steps:

[0057] (1) Use Python language + Django framework to develop the system to provide a front-end page (i.e., a business file generation system web page) for browser access, and import the business data file function into the front-end page to obtain the business initial files / basic business files of multiple data sources. Furthermore, read the file content line by line through the open method in Python language, and then split the fields by delimiters to obtain the content of each field.

[0058] (2) Obtaining the business file rules of the products of the third-party companies to be connected. The business file rules include, but are not limited to: generating equal principal and interest repayment data according to the serial number increment rule, repayment date generation rule, column increase rule, row increase rule, etc.; generating early settlement data according to the amount increment rule, loan date generation rule, column increase rule, row increase rule, etc.

[0059] In an exemplary embodiment, the third-party company products have scenarios such as early settlement and repayment, early repayment of the current period, etc. According to the meaning of the other party's batch business file fields, the corresponding business file rules (file processing rules) are personalized and stored in the database. Subsequently, the data source / third-party company (third-party company A, third-party company B...third-party company N), product category (product 1, product 2...), and file processing rules corresponding to the business scenarios of the third-party company products are confirmed through the front-end page. For example, when the web page is loaded, the third-party company classification is read from the database, and the product list under the corresponding company and the rule list corresponding to each product are read in association, and the categories are displayed on the front-end page for users to select to generate the corresponding batch business file data.

[0060] When connecting with different third-party companies, each company has personalized business rules and data in different formats. In the research and development testing work, it is necessary to test the data of different companies, and the data of different business scenarios are required for testing. The present invention stores the business file rules (file processing rules) corresponding to different third-party companies and different products in the database, and automatically generates a specified number of data based on the acquired business file rules during the subsequent testing process, thereby avoiding the problems of low efficiency and low accuracy caused by manually creating test scenario data. At the same time, the present invention classifies and stores the file processing rules according to the data source and product category, which is not only convenient for rule display and actual use, but also convenient for maintaining the rules.

[0061] Although the batch files corresponding to different third-party companies are not exactly the same, the scenario rules and field contents of the third-party companies can be reused. Therefore, the present invention stores the scenario rules in a database and stores the field number of the corresponding fields in the batch files of different companies, so that when batch files of different third-party companies are selected later, the system can generate corresponding scenario data.

[0062] (3) Read the condition information (file processing rules, number of business data generated) obtained by the front end, process the imported basic business file data line by line, and echo the processed batch business file data to the front end page.

[0063] In some implementations, the front end uses the open method of Python to read the data line by line through the txt batch file uploaded by the user, and splits the data based on the delimiter to obtain the content of each field; then, according to the business scenario selected by the front end, the position of each business field corresponding to the product stored in the database in the corresponding batch file is queried in the database, and then the specific content of each field in the formula is obtained by summing the formula, or using sql to query the corresponding table of the dependent service library. Further, the batch-generated business data is exported to a file for subsequent development and testing. Optionally, the saveAs method in FileSaver.js is used to export the generated data file to a txt file according to the delimiter for business scenario testing.

[0064] In an exemplary implementation, the normal repayment business scenario is satisfied with "repayment date, amount to be repaid = actual amount to be repaid". Based on this formula, by linking to the database, the corresponding content is queried based on SQL and a business result file is generated. Specifically, the business result file of the normal repayment test scenario is generated through the following steps, thereby realizing the number-making work of the normal repayment test scenario: First, according to Figure 4 The field definition content provided by the third party shown in the figure obtains the IOU number content in the third-party batch file. By assembling SQL, the IOU number is used as the query condition to query the data id corresponding to the IOU number in the IOU table in the system library, and then the repayment plan subtable is obtained through the remainder operation (for example, the data id corresponding to the IOU number % 16). Secondly, in the corresponding repayment plan subtable, the fields such as the principal to be repaid, the interest to be repaid, the penalty interest to be repaid, and the interest and penalty interest to be repaid corresponding to this IOU are queried according to the IOU number, and the total amount to be repaid for this IOU is obtained after adding them up. Then, according to the following Figure 5 The shown repayment details table field definition content modifies the actual repayment amount field in the repayment details file to the aforementioned sum value, that is, when the repayment date arrives, the amount to be repaid is equal to the actual repayment amount. At this time, the business scenario corresponds to normal repayment.

[0065] By adopting the above-mentioned business file generation method of Example 2 of the present invention, business data can be automatically generated in batches according to designated fields and personalized rules, and the automatically generated business data can be applied to the research and development and testing process, which can avoid the tedious work of manually modifying data and improve the efficiency of corresponding work. Specifically, the user selects the corresponding rules and fields to be processed in the front-end page, and enters the number of data to be generated, and the specified number of data can be automatically generated according to the selected rules. For example, according to the business serial number field, new business data is automatically generated; according to the repayment date, a repayment data file for N periods is automatically generated, etc.

[0066] [Example 3]

[0067] Figure 6 2 is a schematic diagram of the architecture of a business document generation system according to Embodiment 3 of the present invention.

[0068] like Figure 6 As shown, the business file generation system includes: an initial file acquisition module 610, a rule acquisition module 620, a field position storage module 630, and a file generation module 640.

[0069] The initial file acquisition module 610 is used to acquire business initial files from multiple data sources, including but not limited to: repayment plan files, loan information files, repayment details files, repayment reconciliation files, loan reconciliation files, etc.

[0070] In some implementations, the business initial file is, for example, a txt file, and the initial file acquisition module reads the txt file line by line and splits each field according to a separator (eg, “|”) of the txt file to read the content of the business initial file.

[0071] The rule acquisition module 620 is used to acquire the business scenario corresponding to the business initial file and the target file processing rule in the business scenario.

[0072] In some embodiments, obtaining the target file processing rule includes: querying whether the existing file processing rules stored in the database include the target file processing rule; if the existing file processing rules include the target file processing rule, obtaining the target file processing rule from the database; if the existing file processing rules do not include the target file processing rule, storing the target file processing rule in the database.

[0073] In a further embodiment, the existing file processing rules in the database are classified and stored according to data sources and product categories. For example, the existing file processing rules in the database are classified and stored according to third-party company classifications and product lists under the corresponding companies.

[0074] In an exemplary embodiment, the business scenarios include, but are not limited to: normal repayment, early settlement, etc.

[0075] The field position storage module 630 is used to obtain the content of the field to be processed according to the target file processing rule, obtain the target field content in the business initial file according to the content of the field to be processed, and store the target field position corresponding to the target field content.

[0076] In some implementations, the field position storage module is further configured to change the stored target field position when the field position in the business initial file changes.

[0077] The file generation module 640 is used to generate a business result file according to the business initial file, the target file processing rule and the stored target field position.

[0078] The above-mentioned business file generation system of Example 3 of the present invention is adopted to obtain and store the target field position of the target field content in the business initial file based on the target file processing rule corresponding to the business initial file, and then automatically generate the business result file directly according to the business initial file, the target file processing rule and the stored target field position. It can realize batch automatic generation of business data according to specified fields and personalized rules, thereby improving file processing efficiency and accuracy, and avoiding the tedious work of manual data modification.

[0079] Through the description of the above implementation modes, those skilled in the art can clearly understand that the present invention can be implemented by combining software with a hardware platform. Based on such an understanding, all or part of the contribution of the technical solution of the present invention to the background technology can be embodied in the form of a software product, which can be stored in a storage medium such as ROM / RAM, a magnetic disk, an optical disk, etc., and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in various implementation modes of the present invention or some parts of the implementation modes.

[0080] Correspondingly, an embodiment of the present invention further provides a computer-readable storage medium on which computer-readable instructions or programs are stored. When the computer-readable instructions or programs are executed by a processor, the computer performs the following operations: the operations include the steps included in the business file generation method described in any of the above embodiments, which are not repeated here. The storage medium may include, for example, an optical disk, a hard disk, a floppy disk, a flash memory, a magnetic tape, etc.

[0081] In addition, an embodiment of the present invention further provides a computer device including a memory and a processor, wherein the memory is used to store one or more computer-readable instructions or programs, wherein the one or more computer-readable instructions or programs, when executed by the processor, can implement the business document generation method described in any of the above embodiments. The computer device can be, for example, a server, a desktop computer, a notebook computer, a tablet computer, etc.

[0082] The embodiment of the present invention also provides a computer program product including a computer program, wherein the computer program includes a program code for executing the business file generation method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the business file generation method provided by the embodiment of the present disclosure.

[0083] According to an embodiment of the present disclosure, the program code for executing the computer program provided by the embodiment of the present disclosure can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, using an Internet service provider to connect through the Internet).

[0084] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention is described in detail with reference to the above embodiments, a person skilled in the art should understand that the technical solutions described in the above embodiments can still be modified, or some of the technical features can be replaced by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention. Therefore, the protection scope of the present invention shall be subject to the claims.

Claims

1. A method for generating a business document, characterized in that: The business file generation method comprises: Obtain business initial documents from multiple data sources; Obtaining a business scenario corresponding to the business initial file and a target file processing rule in the business scenario; Obtaining the content of the field to be processed according to the target file processing rule; Acquire the target field content in the business initial file according to the to-be-processed field content, and store the target field position corresponding to the target field content; A business result file is generated according to the business initial file, the target file processing rule and the stored target field position.

2. The method for generating a business document according to claim 1, characterized in that: The target file processing rules include: Querying whether the existing file processing rules stored in the database include the target file processing rule; If the existing file processing rules include the target file processing rules, obtaining the target file processing rules from the database; If the existing file processing rules do not include the target file processing rule, the target file processing rule is stored in a database.

3. The method for generating a business document according to claim 2, characterized in that: The existing file processing rules in the database are classified and stored according to data sources and product categories.

4. The method for generating a business document according to claim 1, characterized in that: The business file generation method further includes: when the field position in the business initial file changes, changing the stored target field position.

5. A method for generating a business document, characterized in that: The business file generation method comprises: An initial file acquisition module is used to acquire business initial files from multiple data sources; A rule acquisition module, used to acquire the business scenario corresponding to the business initial file and the target file processing rule in the business scenario; A field position storage module, used to obtain the content of the field to be processed according to the target file processing rule, obtain the target field content in the business initial file according to the content of the field to be processed, and store the target field position corresponding to the target field content; The file generation module is used to generate a business result file according to the business initial file, the target file processing rule and the stored target field position.

6. The method for generating a business document according to claim 5, characterized in that: The target file processing rules include: Querying whether the existing file processing rules stored in the database include the target file processing rule; If the existing file processing rules include the target file processing rules, obtaining the target file processing rules from the database; If the existing file processing rules do not include the target file processing rule, the target file processing rule is stored in a database.

7. The method for generating a business document according to claim 5, characterized in that: The field position storage module is also used to change the stored target field position when the field position in the business initial file changes.

8. A computer-readable storage medium storing computer-readable instructions, characterized in that: The computer-readable instructions are executed by a processor to implement the business document generation method according to any one of claims 1 to 4.

9. A computer device comprising a memory and a processor, The memory stores computer-readable instructions, characterized in that: The processor executes the computer-readable instructions to implement the business document generation method according to any one of claims 1 to 4.

10. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the business document generation method according to any one of claims 1 to 4 is implemented.

Images