Deep nested formula analysis method and device and medium

Abstract

The invention discloses a deep nested formula analysis method and device and a medium, belongs to the technical field of algorithms and information systems, and is used for solving the technical problems that in formula definition and analysis in an existing information system, general compatibility between other information systems is difficult to achieve, the development period is long, follow-up maintenance investment is large, and research and development cost is large. The method comprises the following steps: configuring a device mounting function in an information system to obtain first configuration information; performing multi-form configuration on the formula analysis data source to obtain second configuration information; performing classification configuration on the input formula content information, and determining third configuration information; performing output configuration on the formula calculation result to obtain fourth configuration information; performing content processing configuration on the formula content information to determine fifth configuration information; and completing general system operation configuration of the information system based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information and the fifth configuration information.

Description

Technical Field

[0001] The present application relates to the field of algorithms and information systems, and in particular to a method, device and medium for analyzing deep nested formulas. Background Art

[0002] Formula definition and parsing are common in existing information systems, and the existing solutions are almost all hard-coded, that is, writing a set of formula definition and parsing components that are highly coupled with the information system. This component is almost incompatible with other information systems and cannot be used universally. This means that for every information system involving formula processing, a set of formula definition and parsing components must be developed for it. Moreover, due to the uneven coding ability of developers, the formula parsing capabilities of different information systems developed are also uneven, and even have serious performance problems. Summary of the invention

[0003] The embodiments of the present application provide a deeply nested formula parsing method, device and medium for solving the following technical problems: in the definition and parsing of formulas in existing information systems, it is difficult to achieve universal compatibility between other information systems, and the development cycle is long, the subsequent maintenance investment is large, and the R&D cost is high.

[0004] The present application embodiment adopts the following technical solutions:

[0005] On the one hand, an embodiment of the present application provides a deeply nested formula parsing method, including: based on preset control mounting information and API interface mounting information, configuring the device mounting function in the information system to obtain first configuration information; according to the first configuration information, configuring the formula parsing data source in multiple forms to obtain second configuration information; according to the second configuration information and the first configuration information, classifying and configuring the input formula content information to determine third configuration information; based on the third configuration information, outputting the formula calculation result to obtain fourth configuration information; through the third configuration information, content processing configuration of the formula content information to determine fifth configuration information; based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information and the fifth configuration information, completing the general system operation configuration of the information system.

[0006] The embodiments of the present application use the formula definition and parsing components corresponding to the present application, so that information systems with formula processing needs no longer need to invest a lot of resources in the development of customized formula definition and formula parsing components. Only a few easy configuration steps are needed to achieve formula definition and parsing, which will effectively save development resource investment and reduce development costs. At the same time, it will also promote faster online delivery of the system. At the same time, it also supports independent server or cloud server deployment. When there are complex formula parsing scenarios, the capabilities of independent servers or cloud servers can be used to effectively improve the formula parsing capabilities. It is also conducive to standardizing the formula processing logic.

[0007] In a feasible implementation manner, based on preset control mounting information and API interface mounting information, the device mounting function in the information system is configured to obtain the first configuration information, which specifically includes: mounting the formula processing component in the preloaded control mounting information into the metadata in the form of a control, and triggering the mounted formula processing component to obtain the control mounting configuration information; mounting the formula processing component in the API interface mounting information to the script end of the code through the API interface in the API interface mounting information, and completing the configuration support of the API interface with the local deployment interface and the server-side deployment interface to obtain the API interface mounting configuration information; determining the first configuration information based on the control mounting configuration information and the API interface mounting configuration information.

[0008] In a feasible implementation, according to the first configuration information, the formula parsing data source is configured in multiple forms to obtain second configuration information, specifically including: after determining the first configuration information, the formula parsing data source associated with the formula processing component is configured to support the direct-connected database in the information system to obtain database configuration information; the formula parsing data source is configured to support data with a JSON-formatted data set to obtain data set configuration information; the formula parsing data source is configured to support interface data with an extended API interface to obtain extended interface configuration information; the formula parsing data source is configured to support table data with an EXCEL file to obtain table file configuration information; based on the database configuration information, the data set configuration information, the extended interface configuration information and the table file configuration information, the second configuration information is determined.

[0009] In a feasible implementation manner, the input formula content information is classified and configured according to the second configuration information and the first configuration information to determine the third configuration information, which specifically includes: after completing the second configuration information, if the input formula content information adopts the control mounting configuration information in the first configuration information, then the formula function in the formula content information is customized through the control mounting method and based on the visual configuration interface to determine the formula function configuration information; if the input formula content information adopts the control mounting configuration information in the first configuration information, then the formula function format in the formula content information is customized through the control mounting method and based on the visual configuration interface to make multiple formula functions support the configuration of the formula function format and determine the formula function format configuration. configuration information; if the input formula content information adopts the control mounting configuration information in the first configuration information, then the formula function parameters in the formula content information are customized through the control mounting method and based on the visual configuration interface, so that multiple formula functions support the configuration of the formula function parameters, and the formula function parameter configuration information is determined; if the input formula content information adopts the API interface mounting configuration information in the first configuration information, the formula content information is data formatted to transfer the formula content information after data formatting to the code interface, and obtain the formula function interface configuration information; based on the formula function configuration information, the formula function format configuration information, the formula function parameter configuration information and the formula function interface configuration information, the third configuration information is determined.

[0010] In a feasible implementation, based on the third configuration information, the formula calculation result is output configured to obtain the fourth configuration information, which specifically includes: after the third configuration information is completed, the formula calculation result is output classified and judged; if the formula calculation result is configured as a control output, the output end of the information system is determined as a control output configuration; wherein the control output configuration includes at least: a text input control configuration, a text display control configuration and an amount input control configuration; if the formula calculation result is configured as a variable output, the output end of the information system is determined as a variable output configuration; the variable output configuration includes at least: a character configuration and an amount configuration; based on the control output configuration and the variable output configuration, the fourth configuration information is determined.

[0011] In a feasible implementation manner, the formula content information is content processed and configured through the third configuration information to determine the fifth configuration information, which specifically includes: initializing the formula content information in the third configuration information through a preset breadth-first search algorithm so that the formula content information is added to the queue of the breadth-first search algorithm; extracting any one node in the queue; parsing the node through the formula function format configuration information in the third configuration information, and creating a child node corresponding to the node based on the nested nodes of the parsed node; adding the child node to the queue; performing node calculation on the child node to obtain child node formula content data, and replacing the child node formula content data with the child node formula content information; performing logical operations on the child node formula content information and the formula content information to obtain a final calculation result; based on the final calculation result, completing and obtaining the fifth configuration information.

[0012] In a feasible implementation, after the formula content information is content processed and configured through the third configuration information to determine the fifth configuration information, the method further includes: performing node tracing processing on each node used for node calculation in the fifth configuration information to obtain tracing detailed information; wherein the tracing detailed information includes at least the calculation result of each node and the corresponding formula content information.

[0013] In a feasible implementation manner, based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information and the fifth configuration information, the general system operation configuration of the information system is completed, specifically including: based on the first configuration information, completing the configuration of the device mounting unit in the information system; based on the second configuration information, completing the configuration of the data source configuration unit in the information system; based on the third configuration information, completing the configuration of the formula input unit in the information system; based on the fourth configuration information, completing the configuration of the result output unit in the information system; based on the fifth configuration information, completing the configuration of the formula calculation unit in the information system; based on the traceability details information, completing the configuration of the result tracing unit in the information system.

[0014] In a second aspect, an embodiment of the present application also provides a deeply nested formula parsing device, the device comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor so that the at least one processor can execute a deeply nested formula parsing method described in any of the above-mentioned embodiments.

[0015] In the third aspect, an embodiment of the present application also provides a non-volatile computer storage medium, characterized in that the storage medium is a non-volatile computer-readable storage medium, and the non-volatile computer-readable storage medium stores at least one program, each of which includes instructions, and when the instructions are executed by a terminal, the terminal executes a deep nested formula parsing method described in any of the above-mentioned embodiments.

[0016] The present application provides a deep nested formula parsing method, device and medium. Compared with the prior art, the embodiments of the present application have the following beneficial technical effects:

[0017] 1. Based on the formula definition and parsing components corresponding to this application, information systems with formula processing requirements no longer need to invest a lot of resources in the development of customized formula definition and formula parsing components. Formula definition and parsing can be achieved with just a few easy configuration steps, which will effectively save development resource investment and reduce development costs. At the same time, it will also promote faster online delivery of the system.

[0018] 2. The formula definition and parsing component supports deployment on independent servers or cloud servers. When there are complex formula parsing scenarios, the capabilities of independent servers or cloud servers can be used to effectively improve the formula parsing capabilities.

[0019] 3. Based on common formula definitions and analytical components, it is more conducive to standardizing formula processing logic. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. In the drawings:

[0021] Figure 1 A flow chart of a deep nested formula parsing method provided in an embodiment of the present application;

[0022] Figure 2 A schematic diagram of a formula function configuration list provided in an embodiment of the present application;

[0023] Figure 3 A schematic diagram of a formula function configuration under a control output provided in an embodiment of the present application;

[0024] Figure 4 A schematic diagram of formula content configuration provided in an embodiment of the present application;

[0025] Figure 5A schematic diagram of node information tracing based on a formula provided in an embodiment of the present application;

[0026] Figure 6 A schematic diagram of the structure of a deep nested formula parsing device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0027] In order to enable those skilled in the art to better understand the technical solutions in this application, the technical solutions in the embodiments of this application will be clearly and completely described below in conjunction with the drawings in the embodiments of this application. Obviously, the described embodiments are only part of the embodiments of this application, not all of them. Based on the embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this application.

[0028] The present application embodiment provides a method for parsing a deeply nested formula, such as Figure 1 As shown, the deep nested formula parsing method specifically includes steps S101-S106:

[0029] S101. Based on preset control mounting information and API interface mounting information, a device mounting function in an information system is configured to obtain first configuration information.

[0030] Specifically, it is necessary to first mount the formula processing component in the preloaded control mounting information into the metadata in the form of a control, and then trigger the mounted formula processing component to obtain the control mounting configuration information.

[0031] Furthermore, through the API interface in the API interface mounting information, the formula processing component in the API interface mounting information is mounted to the script end of the code, and the API interface completes the configuration support with the local deployment interface and the server deployment interface to obtain the API interface mounting configuration information.

[0032] Furthermore, based on the control mounting configuration information and the API interface mounting configuration information, the first configuration information is determined.

[0033] In one embodiment, Figure 2 A schematic diagram of a formula function configuration list provided in an embodiment of the present application, such as Figure 2As shown, the API interface mounting method is adopted. The formula definition and parsing components of this application are first installed on an independent virtual machine server. After the installation is completed, the API interface is accessed and tested. This embodiment uses Postman for testing. The API interface is divided into: formula definition API, formula parsing data source configuration API and formula calculation API. Then the formula definition API and formula calculation API are called at the corresponding places in the script respectively. After that, the HTML content returned by the formula definition API is loaded into the visual interface in the script. The HTML content returned by the formula parsing data source configuration API is loaded into the visual interface in the script. Finally, when the formula calculation API is called in the script, parameter information such as the transmission of formula content and parsing of formula data source can be supported, so that the first configuration information about the formula definition and parsing components based on the API interface mounting configuration information can be obtained.

[0034] S102. According to the first configuration information, the formula parsing data source is configured in multiple forms to obtain second configuration information.

[0035] Specifically, after the first configuration information is determined, the formula parsing data source associated with the formula processing component is supported and configured with a direct-connection database in the information system to obtain database configuration information.

[0036] Furthermore, the formula parsing data source and the JSON format data set are configured to support data, and the data set configuration information is obtained.

[0037] Furthermore, interface data support configuration is performed between the formula parsing data source and the extended API interface to obtain extended interface configuration information.

[0038] Furthermore, support configuration of table data is performed between the formula parsing data source and the EXCEL file to obtain table file configuration information.

[0039] Further, based on the database configuration information, the data set configuration information, the extended interface configuration information and the table file configuration information, the second configuration information is determined.

[0040] As a feasible implementation method, regarding the formula parsing data source configuration, four data source modes are supported: database: directly connected to the database; data set: data set in JSON format; API: extended API interface; file: Excel file.

[0041] S103. Classify and configure the input formula content information according to the second configuration information and the first configuration information to determine third configuration information.

[0042] Specifically, after completing the second configuration information, if the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function in the formula content information is customized through the control mounting method and based on the visual configuration interface to determine the formula function configuration information.

[0043] If the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function format in the formula content information is customized through the control mounting method and based on the visual configuration interface, so that multiple formula functions support the configuration of the formula function format and determine the formula function format configuration information.

[0044] If the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function parameters in the formula content information are customized through the control mounting method and based on the visual configuration interface, so that multiple formula functions support the configuration of formula function parameters and determine the formula function parameter configuration information.

[0045] If the input formula content information adopts the API interface mounting configuration information in the first configuration information, the formula content information is formatted to transmit the formatted formula content information to the code interface and obtain the formula function interface configuration information.

[0046] Based on the formula function configuration information, the formula function format configuration information, the formula function parameter configuration information and the formula function interface configuration information, the third configuration information is determined.

[0047] In one embodiment, Figure 3 A schematic diagram of formula function configuration under a control output provided in an embodiment of the present application is shown as follows: Figure 3 As shown, the formula function needs to be configured, and the configuration of this embodiment is: CSQS. Then configure the formula function format, and the configuration of this embodiment is: CSQS ([indicator number | indicator name], [data source], [offset], [data type number | data type name]). It is also necessary to configure the formula function parameters, and the configuration of this embodiment is: indicator, data source, offset, data type. Based on the above formula function configuration information, the configuration of the third configuration information is finally completed.

[0048] S104. Based on the third configuration information, output configuration is performed on the formula calculation result to obtain fourth configuration information.

[0049] Specifically, after the third configuration information is completed, the formula calculation result is output for classification judgment:

[0050] If the formula calculation result is configured as a control output, the output end of the information system is determined as the control output configuration. The control output configuration at least includes: text input control configuration, text display control configuration and amount input control configuration.

[0051] If the formula calculation result is configured as a variable output, the output end of the information system is determined as a variable output configuration. The variable output configuration at least includes: character configuration and amount configuration; finally, based on the control output configuration and the variable output configuration, the fourth configuration information is determined.

[0052] In one embodiment, Figure 2 as well as Figure 3 As shown, this embodiment adopts the method of outputting to a multi-line text control, and through the completed first configuration information, second configuration information and third configuration information, the output of the formula function is configured, that is, the fourth configuration information.

[0053] S105. Perform content processing configuration on the formula content information through the third configuration information to determine fifth configuration information.

[0054] Specifically, the formula content information in the third configuration information is initialized through a preset breadth-first search algorithm, so that the formula content information is added to a queue of the breadth-first search algorithm.

[0055] Further, any one node in the queue is extracted. The node is parsed through the formula function format configuration information in the third configuration information, and a child node corresponding to the node is created based on the nested nodes of the parsed node.

[0056] Further, the child node is added to the queue; node calculation is performed on the child node to obtain the child node formula content data, and the child node formula content data is replaced with the child node formula content information. Logical operations are performed on the child node formula content information and the formula content information to obtain the final calculation result.

[0057] Further, based on the final calculation result, the fifth configuration information is completed and obtained.

[0058] In one embodiment, Figure 4 A schematic diagram of formula content configuration provided in an embodiment of the present application is shown as follows: Figure 4 As shown, it is necessary to first define a formula, the formula content is: CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QMJE | Ending amount) + 1000 + CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QCJE | Beginning amount), and then parse the formula content, and the final result is: 15000.00. Thus, the formula definition and parsing components of this application complete the content processing configuration of the fifth configuration information.

[0059] Among them, the algorithm used for calculating the formula content information is the breadth-first search algorithm:

[0060] Formula content calculation supports breadth-first search algorithm, and its basic steps are: Initialize the queue: add the formula content to the queue. Then loop through: a) take a node from the queue; b) parse the node based on the configured formula function format, extract the sub-nested part and create a child node; c) add the created child node to the queue. Then perform node calculation based on the child nodes in the queue, and replace the calculated child node formula content data with the formula content information in the child node. Then perform logical operations on the child node formula content information and the formula content information to obtain the final calculation result.

[0061] In addition, the formula definition and analysis components corresponding to this application also support the calculation of deeply nested formulas.

[0062] As a feasible implementation, after the fifth configuration information is determined, node tracing is performed on each node used for node calculation in the fifth configuration information to obtain tracing detailed information, wherein the tracing detailed information at least includes the calculation result of each node and the corresponding formula content information.

[0063] In one embodiment, Figure 5 A schematic diagram of node information tracing based on a formula provided in an embodiment of the present application is as follows: Figure 5 As shown, each node in the fifth configuration information can also be traced back in detail, and the formula content is: CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QMJE | Ending amount) + 1000 + CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QCJE | Beginning amount), and then the formula content is parsed, and the final result is calculated as: 15000.00. Node 1: CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QMJE | Ending amount), the calculation result is 5000; Node 3: CSQS (YSPJ | Notes receivable, 1 | Investee, 0, QCJE | Beginning amount). The calculation result is 9000.

[0064] S106. Complete general system operation configuration of the information system based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information, and the fifth configuration information.

[0065] Specifically, based on the first configuration information, the configuration of the device mounting unit in the information system is completed; based on the second configuration information, the configuration of the data source configuration unit in the information system is completed. Based on the third configuration information, the configuration of the formula input unit in the information system is completed. Based on the fourth configuration information, the configuration of the result output unit in the information system is completed. Based on the fifth configuration information, the configuration of the formula calculation unit in the information system is completed. Based on the traceability detail information, the configuration of the result tracing unit in the information system is completed.

[0066] As a feasible implementation method, by using the formula definition and parsing components in this application, based on an information system with formula processing requirements, it is only necessary to complete the device mounting, formula parsing data source configuration, formula content input configuration, and calculation result output configuration, and the corresponding results can be calculated based on the formula content during the operation phase of the information system. At the same time, it has the ability to trace the calculation process based on the calculation results. A deep nested formula parsing method proposed in this application can effectively save the development workload of information system formula definition and formula parsing components, reduce R&D costs, shorten delivery time, and reduce maintenance investment. At the same time, based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information, and the fifth configuration information, there are corresponding device units to realize the configuration of the general device for formula definition and parsing, so as to use the general deep nested formula parsing method and device to support mounting to various information systems with formula parsing scenarios, and accurately and quickly realize the definition and parsing operation of formulas in the information system.

[0067] In addition, the present application embodiment also provides a deep nested formula parsing device, such as Figure 6 As shown, the deep nested formula parsing device 600 specifically includes:

[0068] At least one processor 601. And a memory 602 in communication with the at least one processor 601. The memory 602 stores instructions that can be executed by the at least one processor 601, so that the at least one processor 601 can execute:

[0069] Based on the preset control mounting information and API interface mounting information, the device mounting function in the information system is configured to obtain first configuration information;

[0070] According to the first configuration information, the formula parsing data source is configured in multiple forms to obtain second configuration information;

[0071] According to the second configuration information and the first configuration information, the input formula content information is classified and configured to determine the third configuration information;

[0072] Based on the third configuration information, output configuration is performed on the formula calculation result to obtain fourth configuration information;

[0073] The formula content information is subjected to content processing configuration by the third configuration information to determine fifth configuration information;

[0074] Based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information and the fifth configuration information, a general system operation configuration of the information system is completed.

[0075] The embodiments of the present application use the formula definition and parsing components corresponding to the present application, so that information systems with formula processing needs no longer need to invest a lot of resources in the development of customized formula definition and formula parsing components. Only a few easy configuration steps are needed to achieve formula definition and parsing, which will effectively save development resource investment and reduce development costs. At the same time, it will also promote faster online delivery of the system. At the same time, it also supports independent server or cloud server deployment. When there are complex formula parsing scenarios, the capabilities of independent servers or cloud servers can be used to effectively improve the formula parsing capabilities. It is also conducive to standardizing the formula processing logic.

[0076] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device and medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.

[0077] The devices and media provided in the embodiments of the present application correspond one-to-one to the methods. Therefore, the devices and media also have similar beneficial technical effects as the corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0078] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0079] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0080] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0081] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0082] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0083] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0084] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0085] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0086] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A deep nested formula parsing method, characterized in that: The method comprises: Based on the preset control mounting information and API interface mounting information, the device mounting function in the information system is configured to obtain first configuration information; According to the first configuration information, the formula parsing data source is configured in multiple forms to obtain second configuration information; According to the second configuration information and the first configuration information, the input formula content information is classified and configured to determine third configuration information; Based on the third configuration information, output configuration is performed on the formula calculation result to obtain fourth configuration information; Performing content processing configuration on the formula content information through the third configuration information to determine fifth configuration information; Based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information and the fifth configuration information, a general system operation configuration of the information system is completed.

2. A deep nested formula parsing method according to claim 1, characterized in that: Based on the preset control mounting information and API interface mounting information, the device mounting function in the information system is configured to obtain the first configuration information, which specifically includes: Mounting the formula processing component in the preloaded control mounting information into the metadata in the form of a control, and triggering and configuring the mounted formula processing component to obtain control mounting configuration information; Through the API interface in the API interface mounting information, the formula processing component in the API interface mounting information is mounted to the script end of the code, and the API interface is completed with the configuration support of the local deployment interface and the server deployment interface to obtain the API interface mounting configuration information; The first configuration information is determined based on the control mounting configuration information and the API interface mounting configuration information.

3. A deep nested formula parsing method according to claim 1, characterized in that: According to the first configuration information, the formula parsing data source is configured in multiple forms to obtain second configuration information, which specifically includes: After determining the first configuration information, the formula parsing data source associated with the formula processing component is configured to support the direct connection database in the information system to obtain database configuration information; Perform data support configuration between the formula parsing data source and the JSON format data set to obtain data set configuration information; Perform interface data support configuration between the formula parsing data source and the extended API interface to obtain extended interface configuration information; Perform support configuration of table data between the formula parsing data source and the EXCEL file to obtain table file configuration information; The second configuration information is determined based on the database configuration information, the data set configuration information, the extended interface configuration information, and the table file configuration information.

4. A deep nested formula parsing method according to claim 1, characterized in that: According to the second configuration information and the first configuration information, the input formula content information is classified and configured to determine the third configuration information, which specifically includes: After completing the second configuration information, if the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function in the formula content information is customized through the control mounting method and based on the visual configuration interface to determine the formula function configuration information; If the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function format in the formula content information is customized through the control mounting method and based on the visual configuration interface, so that multiple formula functions support the configuration of the formula function format, and the formula function format configuration information is determined; If the input formula content information adopts the control mounting configuration information in the first configuration information, the formula function parameters in the formula content information are customized through the control mounting method and based on the visual configuration interface, so that multiple formula functions support the configuration of the formula function parameters, and the formula function parameter configuration information is determined; If the input formula content information adopts the API interface mounting configuration information in the first configuration information, the formula content information is data formatted to transmit the formula content information after data formatting to the code interface, and the formula function interface configuration information is obtained; The third configuration information is determined based on the formula function configuration information, the formula function format configuration information, the formula function parameter configuration information and the formula function interface configuration information.

5. A deep nested formula parsing method according to claim 1, characterized in that: Based on the third configuration information, the formula calculation result is output configured to obtain fourth configuration information, which specifically includes: After the third configuration information is completed, the calculation result of the formula is output for classification judgment; If the formula calculation result is configured as a control output, the output end of the information system is determined as a control output configuration; wherein the control output configuration at least includes: a text input control configuration, a text display control configuration, and an amount input control configuration; If the calculation result of the formula is configured as a variable output, the output end of the information system is determined as a variable output configuration; the variable output configuration at least includes: character configuration and amount configuration; The fourth configuration information is determined based on the control output configuration and the variable output configuration.

6. A deep nested formula parsing method according to claim 1, characterized in that: The formula content information is subjected to content processing configuration through the third configuration information to determine fifth configuration information, specifically including: Initializing the formula content information in the third configuration information by using a preset breadth-first search algorithm, so that the formula content information is added to a queue of the breadth-first search algorithm; Extract any one node in the queue; parse the node using the formula function format configuration information in the third configuration information, and create a child node corresponding to the node based on the nested nodes of the parsed node; Adding the child node to the queue; Perform node calculation on the subnode to obtain subnode formula content data, and replace the subnode formula content data with subnode formula content information; Performing logical operations on the sub-node formula content information and the formula content information to obtain a final calculation result; Based on the final calculation result, the fifth configuration information is completed and obtained.

7. A deep nested formula parsing method according to claim 1, characterized in that: After performing content processing configuration on the formula content information through the third configuration information and determining fifth configuration information, the method further includes: Perform node tracing processing on each node used for node calculation in the fifth configuration information to obtain tracing detail information; wherein the tracing detail information at least includes the calculation result of each node and the corresponding formula content information.

8. A deep nested formula parsing method according to claim 1, characterized in that: Based on the first configuration information, the second configuration information, the third configuration information, the fourth configuration information, and the fifth configuration information, completing the general system operation configuration of the information system specifically includes: Based on the first configuration information, completing the configuration of the device mounting unit in the information system; Based on the second configuration information, completing the configuration of the data source configuration unit in the information system; Based on the third configuration information, completing the configuration of the formula input unit in the information system; Based on the fourth configuration information, completing the configuration of the result output unit in the information system; Based on the fifth configuration information, completing the configuration of the formula calculation unit in the information system; Based on the traceability detail information, the configuration of the result traceability unit in the information system is completed.

9. A deeply nested formula parsing device, characterized in that: The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, so that the at least one processor can execute the deep nested formula parsing method according to any one of claims 1-8.

10. A non-volatile computer storage medium, characterized in that: The storage medium is a non-volatile computer-readable storage medium, and the non-volatile computer-readable storage medium stores at least one program, each of which includes instructions, and when the instructions are executed by the terminal, the terminal executes a deep nested formula parsing method according to any one of claims 1-8.

Images