A method and apparatus for generating a letter of confirmation, an electronic device, and a computer readable medium
Patent Information
- Application Number
- CN202410538796.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-04-30
- Publication Date
- 2026-10-23
AI Technical Summary
[0003]传统的方法通常采用手动输入、格式化和组织数据，这不仅效率低，而且容易出错
[0010]本公开的上述各个实施例中的一个实施例具有如下有益效果：利用数据库的数据流设计和模板技术，利用关系数据库存储方案，采用数据kv模式统一存储数据，可以将关系数据库中的数据和/或Excel表格来源的数据，快速准确地生成所需的制式文件，动态生成和处理包含各种信息的制式文件模板。另外，采用关联、校验的技术，实现跨表、跨系统、跨数据源的数据整合和处理，从业务系统、网页数据、财务系统、合同系统等来源获取的数据，通过数据映射关系，整合到制式文件中。能够批量生成函证，实现数据的快速处理和制式文件的自动生成。
Smart Images
Figure CN122965451A_ABST
Abstract
Description
Technical Field
[0001] The embodiments of this disclosure relate to the field of computer technology, and more specifically to a method, apparatus, electronic device, and computer-readable medium for generating confirmation documents. Background Technology
[0002] In the legal, business, and many other industries, the creation and management of standard documents, especially confirmations, is a common but time-consuming task.
[0003] Traditional methods typically involve manually entering, formatting, and organizing data, which is not only inefficient but also prone to errors. Summary of the Invention
[0004] The summary portion of this disclosure is intended to provide a brief overview of the concepts, which will be described in detail in the detailed description portion. This summary portion is not intended to identify key or essential features of the claimed technical solutions, nor is it intended to limit the scope of the claimed technical solutions.
[0005] Some embodiments of this disclosure provide a method, apparatus, electronic device, and computer-readable medium for generating confirmation documents to address the technical problems mentioned in the background section above.
[0006] In a first aspect, some embodiments of this disclosure provide a method for generating confirmation documents. The method includes: obtaining a target confirmation template and configuration information corresponding to the target confirmation template from a confirmation template table; determining a set of template files associated with the target confirmation template based on the configuration information; for each template file in the template file set, determining associated field comparison information of the template file based on the configuration information; in response to receiving a target file corresponding to the template file set, determining associated data from the target file based on the associated field comparison information; and filling the associated data into the target confirmation template to obtain a confirmation document.
[0007] Secondly, some embodiments of this disclosure provide a confirmation document generation apparatus, the apparatus comprising: an acquisition unit configured to acquire a target confirmation template and configuration information corresponding to the target confirmation template from a confirmation template table; a first determination unit configured to determine a set of template files associated with the target confirmation template based on the configuration information; a second determination unit configured to determine, for each template file in the template file set, association field comparison information of the template file based on the configuration information; a third determination unit configured to, in response to receiving a target file corresponding to the template file set, determine associated data from the target file based on the association field comparison information; and a generation unit configured to fill the associated data into the target confirmation template to obtain a confirmation document.
[0008] Thirdly, embodiments of this application provide an electronic device, which includes: one or more processors; a storage device for storing one or more programs; and when the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any implementation of the first aspect.
[0009] Fourthly, embodiments of this application provide a computer-readable medium having a computer program stored thereon, which, when executed by a processor, implements the method as described in any of the implementations of the first aspect.
[0010] One embodiment of the above-described embodiments of this disclosure has the following beneficial effects: Utilizing database data flow design and template technology, employing a relational database storage scheme, and adopting a unified key-value data model for data storage, it can quickly and accurately generate the required standardized documents from data in relational databases and / or data from Excel spreadsheets, dynamically generating and processing standardized document templates containing various information. Furthermore, by employing association and validation technologies, it achieves data integration and processing across tables, systems, and data sources. Data obtained from business systems, web pages, financial systems, contract systems, etc., is integrated into the standardized documents through data mapping relationships. It can generate confirmations in batches, enabling rapid data processing and automatic generation of standardized documents. Attached Figure Description
[0011] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and elements are not necessarily drawn to scale.
[0012] Figure 1 This is a schematic diagram illustrating an application scenario of a confirmation document generation method according to some embodiments of the present disclosure;
[0013] Figure 2 This is a flowchart of some embodiments of the confirmation document generation method according to this disclosure;
[0014] Figure 3 This is a schematic diagram of the structure of some embodiments of the confirmation document generation apparatus according to the present disclosure;
[0015] Figure 4 This is a schematic diagram of the structure of an electronic device suitable for implementing some embodiments of the present disclosure. Detailed Implementation
[0016] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.
[0017] It should also be noted that, for ease of description, only the parts relevant to the invention are shown in the accompanying drawings. Unless otherwise specified, the embodiments and features described in this disclosure can be combined with each other.
[0018] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.
[0019] It should be noted that the terms "a" and "a plurality of" used in this disclosure are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".
[0020] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
[0021] This disclosure will now be described in detail with reference to the accompanying drawings and embodiments.
[0022] Figure 1 This is a schematic diagram illustrating an application scenario of a confirmation document generation method according to some embodiments of the present disclosure.
[0023] like Figure 1 As shown, server 101 can obtain target confirmation template 102 and configuration information 103 corresponding to the target confirmation template from the confirmation template table; determine the template file set associated with the target confirmation template 102 based on the configuration information 103; for each template file 104 in the template file set, determine the associated field comparison information 105 of the template file 104 based on the configuration information 103; in response to receiving the target file corresponding to the template file set, determine the associated data 106 from the target file based on the associated field comparison information 105; and fill the associated data into the confirmation template 102 to obtain confirmation file 107.
[0024] It is understood that the confirmation document generation method can be executed by a terminal device or by server 101. The executing entity of the above method can also include a device formed by integrating the terminal device and server 101 through a network, or it can be executed by various software programs. The terminal device can be various electronic devices with information processing capabilities, including but not limited to smartphones, tablets, e-book readers, laptops, and desktop computers. The executing entity can also be server 101, software, etc. When the executing entity is software, it can be installed on the electronic devices listed above. It can be implemented as, for example, multiple software programs or software modules used to provide distributed services, or as a single software program or software module. No specific limitations are made here.
[0025] It should be understood that Figure 1 The number of servers shown is merely illustrative. Depending on implementation needs, any number of servers can be used.
[0026] Continue to refer to Figure 2 The diagram illustrates a flow 200 of some embodiments of a confirmation document generation method according to the present disclosure. This confirmation document generation method includes the following steps:
[0027] Step 201: Obtain the target confirmation template and the corresponding configuration information from the confirmation template table.
[0028] In some embodiments, the execution body of the confirmation file generation method (e.g.) Figure 1 The server shown can obtain the target confirmation template and its corresponding configuration information from the confirmation template table via wired or wireless connection. It should be noted that the wireless connection methods mentioned above may include, but are not limited to, 3G / 4G, WiFi, Bluetooth, WiMAX, Zigbee, UWB (ultra-wideband), and other currently known or future wireless connection methods.
[0029] Here, the above confirmation template table is used to store basic information about confirmation templates, including template number, project number, template name, etc.
[0030] As an example, the above lanxum_scs_temp [confirmation template table] can be in the following form:
[0031] Primary key: scs_temp_no.
[0032] The configuration information mentioned above typically refers to the information in the confirmation template. As an example, the configuration information could be the data type required by the confirmation template. As yet another example, the configuration information could also be the data source corresponding to the confirmation template.
[0033] 10. Specifically, the above configuration information typically includes a confirmation source sub-file template table, a confirmation template...
[0034] The table includes a field lookup table and a key-value (kv) pattern extended field table. Here, the aforementioned confirmation source sub-file template table stores information about the sub-file templates, including the template file number, confirmation template number, and file number. The aforementioned confirmation template table field lookup table is used for mapping fields.
[0035] This includes the reference number, template file number, and tag characters. The aforementioned key-value pattern extended field table 15 stores extended field information, including the extended field number, the name of the associated data table, and the relationship...
[0036] Data from linked tables, etc.
[0037] lanxum_scs_temp_file [Confirmation Source Subfile Template Table]:
[0038]
[0039] Primary keys: scs_temp_file_no; scs_temp_no.
[0040] lanxum_scs_temp_contrast [Confirmation Template Table Field Mapping Table] (used for mapping field mapping):
[0041]
[0042]
[0043] Primary key:
[0044] contrast_no; scs_temp_file_no.
[0045] lanxum_extend_data[kv schema extended field table]:
[0046]
[0047] Primary key: column_code, table_name, related_data;
[0048] index:
[0049] Unique index: related_data.
[0050] Ordinary index: query_id:column_code, table_name, related_data.
[0051] Step 202: Determine the set of template files associated with the above target confirmation template based on the above configuration information.
[0052] In some embodiments, the aforementioned execution entity (e.g. Figure 1 The server shown can determine the set of template files associated with the target confirmation template based on the above configuration information.
[0053] Specifically, the aforementioned executing entity can use the template number (scs_temp_no) to query the lanxum_scs_temp_file confirmation source sub-file template table to obtain all associated template files as a template file set, such as file number (scs_file_no), file name (scs_file_name), etc.
[0054] Step 203: For each template file in the above template file set, determine the associated field comparison information of the above template file based on the above configuration information.
[0055] In some embodiments, for each template file in the template file set, the execution entity can determine the associated field comparison information of the template file based on the configuration information.
[0056] Specifically, the aforementioned execution entity can query the lanxum_scs_temp_contrast confirmation template table field comparison table based on the template file's file number (scs_temp_file_no). It then reads an Excel spreadsheet with a specified name and format from a specified path to obtain the associated field comparison information of the template file. This associated field comparison information includes which fields will be included in the template, their specific locations in the Excel spreadsheet (scs_temp_data_sheet & scs_temp_data_position), and their related processing rules (scs_temp_data_rule) and format (scs_temp_format). This extracted data is then uniformly stored in the lanxum_extend_data [kv pattern extended field table].
[0057] If additional extended fields or data are needed, such as project name, project start time, etc., the required KV data can be obtained by querying the table_name and related_data fields of lanxum_extend_data[kv pattern extended field table].
[0058] Step 204: In response to receiving the target file corresponding to the above template file set, determine the associated data from the above target file according to the above associated field comparison information.
[0059] In some embodiments, in response to receiving the target file corresponding to the template file set, the execution entity can determine the associated data from the target file based on the associated field comparison information.
[0060] Step 205: Fill in the above-mentioned related data into the above-mentioned target confirmation template to obtain the confirmation document.
[0061] In some embodiments, the executing entity may fill the aforementioned associated data into the aforementioned target confirmation template to obtain a confirmation file.
[0062] Using file template technology, the template file is updated with field alignment and table filling processes based on the data in lanxum_extend_data[kv pattern extended field table] in the above confirmation template.
[0063] In some optional implementations of certain embodiments, the execution entity may generate the hash value of the confirmation file and the associated data in the confirmation file using a hash algorithm and save the hash value.
[0064] As an example, the aforementioned execution entity can use a hash algorithm (such as MD5) to generate a hash value for the filled confirmation content and save it.
[0065] In some optional implementations of some embodiments, the execution entity may display a first display interface, wherein the first display interface includes the configuration information and a configuration information editing control; in response to detecting that a user performs an editing operation on the configuration information through the configuration information editing control on the first display interface, the configuration information is edited according to the editing operation to obtain target configuration information; and a second display interface is displayed, wherein the second display interface includes the target configuration information.
[0066] Specifically, users can use the above configuration information to edit the control and customize how data is organized and displayed.
[0067] One embodiment of the above-described embodiments of this disclosure has the following beneficial effects: Utilizing database data flow design and template technology, employing a relational database storage scheme, and adopting a unified key-value data model for data storage, it can quickly and accurately generate the required standardized documents from data in relational databases and / or data from Excel spreadsheets, dynamically generating and processing standardized document templates containing various information. Furthermore, by employing association and validation technologies, it achieves data integration and processing across tables, systems, and data sources. Data obtained from business systems, web pages, financial systems, contract systems, etc., is integrated into the standardized documents through data mapping relationships. It can generate confirmations in batches, enabling rapid data processing and automatic generation of standardized documents.
[0068] Further reference Figure 3 As an implementation of the methods shown in the above figures, this disclosure provides some embodiments of a confirmation document generation apparatus, which are similar to... Figure 2 Corresponding to the method embodiments shown, the device can be specifically applied to various electronic devices.
[0069] like Figure 3 As shown, a confirmation document generation apparatus 300 in some embodiments includes: an acquisition unit 301, a first determination unit 302, a second determination unit 303, a third determination unit 304, and a generation unit 305. The acquisition unit 301 is configured to acquire a target confirmation template and corresponding configuration information from a confirmation template table; the first determination unit 302 is configured to determine a set of template files associated with the target confirmation template based on the configuration information; the second determination unit 303 is configured to determine, for each template file in the template file set, associated field comparison information based on the configuration information; the third determination unit 304 is configured to, in response to receiving a target file corresponding to the template file set, determine associated data from the target file based on the associated field comparison information; and the generation unit 305 is configured to fill the associated data into the target confirmation template to obtain a confirmation document.
[0070] It is understandable that the units described in the device 300 are related to the reference. Figure 2 The steps in the described method correspond accordingly. Therefore, the operations, features, and beneficial effects described above for the method also apply to the device 300 and the units contained therein, and will not be repeated here.
[0071] One embodiment of the above-described embodiments of this disclosure has the following beneficial effects: Utilizing database data flow design and template technology, employing a relational database storage scheme, and adopting a unified key-value data model for data storage, it can quickly and accurately generate the required standardized documents from data in relational databases and / or data from Excel spreadsheets, dynamically generating and processing standardized document templates containing various information. Furthermore, by employing association and validation technologies, it achieves data integration and processing across tables, systems, and data sources. Data obtained from business systems, web pages, financial systems, contract systems, etc., is integrated into the standardized documents through data mapping relationships. It can generate confirmations in batches, enabling rapid data processing and automatic generation of standardized documents.
[0072] The following is for reference. Figure 4 It illustrates electronic devices suitable for implementing some embodiments of this disclosure (e.g., Figure 1 The structural diagram of the server (400) in the middle. Figure 4 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments of this disclosure.
[0073] like Figure 4 As shown, electronic device 400 may include a processing device (e.g., a central processing unit, a graphics processor, etc.) 401, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 402 or a program loaded from storage device 408 into random access memory (RAM) 403. RAM 403 also stores various programs and data required for the operation of electronic device 400. Processing device 401, ROM 402, and RAM 403 are interconnected via bus 404. Input / output (I / O) interface 405 is also connected to bus 404.
[0074] Typically, the following devices can be connected to I / O interface 405: input devices 406 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 407 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 408 including, for example, magnetic tapes, hard disks, etc.; and communication devices 409. Communication device 409 allows electronic device 400 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 4 An electronic device 400 with various devices is shown; however, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively. Figure 4 Each box shown can represent a device or multiple devices as needed.
[0075] In particular, according to some embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, some embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication device 409, or installed from storage device 408, or installed from ROM 402. When the computer program is executed by processing device 401, it performs the functions defined above in the methods of some embodiments of this disclosure.
[0076] It should be noted that, in some embodiments of this disclosure, the computer-readable medium described above may be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium may be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof.
[0077] In some embodiments of this disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used or combined with an instruction execution system, apparatus, or device. In other embodiments of this disclosure, the computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof.
[0078] A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.
[0079] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.
[0080] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device. The aforementioned computer-readable medium carries one or more programs that, when executed by the electronic device, cause the electronic device to: obtain a target confirmation template and corresponding configuration information from a confirmation template table; determine a set of template files associated with the target confirmation template based on the configuration information; for each template file in the template file set, determine associated field mapping information for the template file based on the configuration information; in response to receiving a target file corresponding to the template file set, determine associated data from the target file based on the associated field mapping information; and populate the associated data into the target confirmation template to obtain a confirmation file.
[0081] Computer program code for performing operations of some embodiments of this disclosure can be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, and C++, and conventional procedural programming languages such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0082] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.
[0083] The units described in some embodiments of this disclosure can be implemented in software or hardware. The described units can also be housed in a processor; for example, a processor may be described as including an acquisition unit, a first determination unit, a second determination unit, a third determination unit, and a generation unit. The names of these units do not necessarily limit the specific unit; for example, the acquisition unit may also be described as "a unit that acquires a target confirmation template and corresponding configuration information from a confirmation template table."
[0084] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: Field Programmable Gate Arrays (FPGAs), Application-Specific Integrated Circuits (ASICs), Application Standard Products (ASSPs), System-on-Chip (SoCs), Complex Programmable Logic Devices (CPLDs), and so on.
[0085] The above description is merely a selection of preferred embodiments of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of the invention involved in the embodiments of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described inventive concept. For example, technical solutions formed by substituting the above-described features with (but not limited to) technical features with similar functions disclosed in the embodiments of this disclosure.
Claims
1. A method for generating confirmation documents, comprising: Retrieve the target confirmation template and its corresponding configuration information from the confirmation template table; The set of template files associated with the target confirmation template is determined based on the configuration information; For each template file in the template file set, the associated field mapping information of the template file is determined according to the configuration information; In response to receiving the target file corresponding to the template file set, the associated data is determined from the target file according to the associated field comparison information; The associated data is filled into the target confirmation template to obtain the confirmation file.
2. The method according to claim 1, wherein, The method further includes: The hash value of the confirmation file and the associated data in the confirmation file is generated by a hash algorithm and then saved.
3. The method according to claim 1, wherein, The method further includes: Display a first display interface, wherein the first display interface includes the configuration information and configuration information editing controls; In response to detecting that a user performs an editing operation on the configuration information through the configuration information editing control on the first display interface, the configuration information is edited according to the editing operation to obtain the target configuration information; A second display interface is displayed, which includes the target configuration information.
4. An apparatus for generating confirmation documents, comprising: The acquisition unit is configured to acquire a target confirmation template and the corresponding configuration information from the confirmation template table; The first determining unit is configured to determine the set of template files associated with the target confirmation template based on the configuration information; The second determining unit is configured to determine the associated field comparison information of each template file in the template file set according to the configuration information. The third determining unit is configured to, in response to receiving a target file corresponding to the template file set, determine associated data from the target file based on the associated field comparison information; The generation unit is configured to fill the associated data into the target confirmation template to obtain a confirmation file.
5. The apparatus according to claim 4, wherein, The device further includes a storage unit configured for: The hash value of the confirmation file and the associated data in the confirmation file is generated by a hash algorithm and then saved.
6. The apparatus according to claim 4, wherein, The device further includes a display unit configured for: Display a first display interface, wherein the first display interface includes the configuration information and configuration information editing controls; In response to detecting that a user performs an editing operation on the configuration information through the configuration information editing control on the first display interface, the configuration information is edited according to the editing operation to obtain the target configuration information; A second display interface is displayed, which includes the target configuration information.
7. An electronic device, comprising: One or more processors; Storage device, on which one or more programs are stored, When the one or more programs are executed by the one or more processors, the one or more processors implement the method as described in any one of claims 1-3.
8. A computer-readable medium having a computer program stored thereon, wherein, When the program is executed by the processor, it implements the method as described in any one of claims 1-3.