CN114416832A - Method for configuring formula field and report and computer storage medium - Google Patents
Method for configuring formula field and report and computer storage medium Download PDFInfo
- Publication number
- CN114416832A CN114416832A CN202210093555.XA CN202210093555A CN114416832A CN 114416832 A CN114416832 A CN 114416832A CN 202210093555 A CN202210093555 A CN 202210093555A CN 114416832 A CN114416832 A CN 114416832A
- Authority
- CN
- China
- Prior art keywords
- function
- parameter
- field
- built
- source data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a configuration method of a formula field and a report and a computer storage medium, which comprises the steps of obtaining a source data field based on a field list and obtaining a built-in function based on a function list; configuring corresponding calculation rules for the obtained source data fields based on the built-in functions to form an agreed function, and configuring corresponding formula field names; carrying out validity check on the agreed function and the formula field name, wherein the validity of the agreed function comprises the validity of a built-in function and the validity of a calculation rule; the formula field name passing the validity check is associated with the appointed function to generate a formula field, the formula field is updated to the field list, the formula field with the user characteristics can be configured, so that a user can obtain expected data display, a cloud database can be enriched, and the method is high in universality and flexibility.
Description
Technical Field
The invention relates to the technical field of industrial internet platforms, in particular to a configuration method of formula fields and reports and a computer storage medium.
Background
In the field of industrial internet platforms, based on company services, basic data generated by daily work and production of each user can be sorted and stored in a cloud database. When the user needs to check the data, the industrial Internet platform can call the corresponding data based on the request of the user and display the data to the user in a report form; however, since the data generated by different users in daily life may be different, report configuration needs to be performed for different clients based on the existing fields of the source data.
Because most of source data in the existing cloud-end database is uploaded by monitoring equipment or users arranged on each service site, when report configuration is carried out, users can only select source data fields to carry out report configuration, and the problem that the users check results after operation is carried out on the basis of a plurality of source data fields cannot be met, namely, what is shown in the source data is solved, the platform only has a simple data calling and transmitting function, and does not have a data operation function, and the data display effect is single and the universality is poor. When a user needs to check the result of the operation of the multiple groups of data, additional operation is usually required on the basis of the source data to obtain ideal data, and the flexibility is poor.
Disclosure of Invention
In view of the above, the present invention provides a method for configuring a formula field and a report, and a computer storage medium, so as to solve the problems of single report configuration effect, and poor versatility and flexibility in the prior art.
In order to achieve the above object, a first aspect of the present invention provides a method for configuring a formula field, which specifically includes the following steps:
s1: acquiring a source data field based on a field list and acquiring a built-in function based on a function list;
s2: configuring corresponding calculation rules for the obtained source data fields based on the built-in functions to form an agreed function, and configuring corresponding formula field names;
s3: carrying out validity check on the agreed function and the formula field name, wherein the validity of the agreed function comprises the validity of a built-in function and the validity of a calculation rule;
s4: and associating the formula field name passing the validity check with the appointed function to generate a formula field, and updating the formula field into a field list.
Further, the step S2 specifically includes the following steps:
s201: selecting an obtained built-in function, and screening out source data fields which accord with a parameter configuration rule from obtained source data fields according to the parameter configuration rule of the built-in function to form a parameter field list;
s202: selecting a source data field from the parameter field list to be configured as a parameter of the built-in function;
s203: respectively preprocessing the source data fields based on the parameters of the built-in functions and the processing rules of the built-in functions, and then respectively configuring calculation rules among the built-in functions to form appointed functions;
s204: and configuring the corresponding formula field name based on the appointed function.
Further, the step S3 specifically includes the following steps:
s301: splitting the appointed function to obtain a plurality of built-in functions and acquiring function information of the built-in functions, wherein the function information comprises function names, parameters, parameter numbers and parameter types of the built-in functions;
s302: checking the legality of the built-in functions one by one according to the function information, if the check is passed, continuing to execute the step S303, otherwise, skipping to execute the step S307;
s303: executing operation on the appointed function based on the calculation rule to obtain an operation result;
s304: checking the validity of the calculation rule according to the calculation result of the built-in function after calculation, if the validity passes the check, continuing to execute the step S305, otherwise, skipping to execute the step S307;
s305: traversing each source data field in the field list, and comparing the name of the formula field with the name of each source data field;
s306: checking the legality of the formula field name according to the comparison result of the formula field name and each source data field name, if the formula field name passes the checking, finishing the checking, and otherwise, skipping to execute the step S307;
s307: and reporting errors to the names of the built-in functions, the calculation rules or the formula fields which fail to pass the verification, generating prompt information, returning to execute the step S2, and modifying the built-in functions, the calculation rules or the formula fields which fail to pass the verification.
Further, the step S301 of splitting the contract function specifically includes:
s3011: assigning a first parameter identifier to each built-in function in the appointed function, and assigning a corresponding second parameter identifier to each parameter in each built-in function according to the parameter type, so as to obtain a corresponding third parameter identifier assigned to non-Chinese and non-numeric characters in each parameter;
s3012: traversing values corresponding to the second parameter identifications and the third parameter identifications, extracting the second parameter identifications and the third parameter identifications which are equal to the value of the first parameter identification, and replacing the extracted values of the second parameter identifications and the third parameter identifications;
s3013: splitting the agreed function into a plurality of built-in function character string lists by using the first parameter identifier, and acquiring function information of each built-in function based on the built-in function character string lists;
s3014: and acquiring the second parameter identifier and the third parameter identifier after replacement in the step S3012, and replacing the second parameter identifier and the third parameter identifier with the corresponding original values.
Further, in step S3012, a regular matching rule is used to replace the values of the second parameter identifier and the third parameter identifier, and the specific method includes:
a. respectively determining a replacement character string based on the extracted second parameter identification and the extracted third parameter identification, wherein the replacement character strings corresponding to the values of the second parameter identification or the third parameter identification with the same value are the same;
b. respectively determining regular matching rules of each second parameter identifier and each third parameter identifier, wherein the regular matching rules of the second parameter identifiers or the third parameter identifiers with the same value are the same;
c. and acquiring a second parameter identifier and a third parameter identifier corresponding to matching in an appointed function according to the regular matching rule, and replacing the value of the second parameter identifier or the third parameter identifier by using a corresponding replacement character string after the matching is successful.
Further, the specific method for performing validity verification on the built-in function in step S302 is as follows:
s3021: matching the function names of the internal functions obtained by splitting with the function names of the internal functions in the function list one by one, if the matching is successful, continuing to execute the step S3022, otherwise, skipping to execute the step S307;
s3022: matching the number of the parameters in each built-in function obtained by splitting with the parameter configuration rule of the built-in function, if the matching is successful, continuing to execute the step S3023, otherwise, skipping to execute the step S307;
s3023: matching the parameter names of the parameters obtained by splitting with the field names of the source data fields in the field list one by one, if the matching is successful, continuing to execute the step S3034, otherwise, skipping to execute the step S307;
s3024: and matching the parameter types of the parameters obtained by splitting with the corresponding second parameter identifications, if the matching is successful, continuing to execute the step S303, otherwise, skipping to execute the step S307.
Further, the specific method for performing the operation on the commitment function in step S303 is as follows:
and based on each built-in function obtained by splitting, integrally replacing each built-in function with a non-zero random number carrying a fourth parameter identifier to obtain an equation comprising a calculation rule and a numerical value, and executing operation on the equation based on the calculation rule to obtain an operation result of the equation.
The second aspect of the present invention provides a report configuration method based on formula fields, which specifically includes the following steps:
p1: configuring report statistics dimensions, and loading optional fields based on a database, wherein the optional fields comprise a source data field carrying a first field identifier and a formula field carrying a second field identifier to form a field list, and the formula fields are configured by adopting the configuration method of the formula fields;
p2: and selecting corresponding optional fields from the field list based on a request of a user, acquiring corresponding data from the database based on the statistical dimension and the optional fields, and integrating to obtain a statistical report.
Further, the specific step of integrating the statistical form in step P2 includes:
p201: judging whether the optional field is a formula field or not according to the first field identification and the second field identification, if so, continuing to execute the step P202, otherwise, skipping to execute the step P203;
p202: acquiring the appointed function configured in the formula field, acquiring corresponding built-in functions and parameter values of parameters corresponding to the built-in functions in a function list based on the appointed function, calculating the built-in functions respectively, then calculating the appointed function by using a calculation rule, returning the calculation result as the value of the formula field, and skipping to execute the step P204;
p203: obtaining source data corresponding to the source data field from a database, returning the source data as a value of the source data field, and skipping to execute the step P204;
p204: and integrating the statistical dimension, the formula field and/or the source data field and the corresponding values thereof to form a corresponding statistical report.
A third aspect of the present invention provides a computer storage medium having stored thereon a computer program which, when executed by a processor, implements the method for configuring a formula field as described above and implements the method for configuring a report based on a formula field as described above.
According to the scheme, various appointed functions which are operated and output by a plurality of source data fields can be configured on the basis of the source data fields by utilizing the built-in function to form formula fields, so that data in a cloud database can be enriched, and more field selections during report configuration are provided for a user; meanwhile, in the process of configuring the formula field, the method of function splitting, regular expression matching and the like is comprehensively utilized to carry out legality verification on the built-in function, the calculation rule and the formula field name in the appointed function one by one so as to ensure the accuracy of the configured formula field, and further the configured statistical form can accurately and visually display the production and business data of the user.
Drawings
Fig. 1 is a flowchart of a method for configuring a formula field according to embodiment 1 of the present invention.
Fig. 2 is a flowchart of step S2 in fig. 1.
Fig. 3 is a flowchart of step S3 in fig. 1.
Fig. 4 is a flowchart of step S301 in fig. 3.
Fig. 5 is a flowchart of step S302 in fig. 3.
Fig. 6 is a flowchart of a report configuration method based on formula fields in embodiment 2 of the present invention.
Fig. 7 is a flowchart of step P2 in fig. 6.
Detailed Description
The following is further detailed by way of specific embodiments:
according to the method, source data uploaded by a user and built-in functions preset by the user are acquired from a cloud database, various appointed functions capable of performing calculation processing on a plurality of data are configured based on various combinations of the built-in functions and source data fields, and then a formula field is formed, so that the user can obtain expected data; the method comprises the steps of splitting a convention function, configuring a specific parameter identifier, verifying the legality of each built-in function in the convention function by using a regular expression, verifying the legality of a calculation rule by using an integral substitution method, and verifying the legality of a formula field name by using an iterative comparison method, so that the accuracy of the configured formula field is ensured, and the production and business data of a user can be accurately displayed.
Example 1
Fig. 1 is a flowchart of a method for configuring a formula field according to this embodiment. The configuration of the formula field in this embodiment is implemented based on an industrial internet platform, the cloud database of the industrial internet platform stores the source data field uploaded by each user and the corresponding source data according to the user, and the cloud database is configured to enable the source data field and the corresponding source data to be called based on a request of the user. The embodiment specifically comprises the following steps:
s1: and acquiring a source data field and a built-in function.
The method includes obtaining a source data field based on a field list and obtaining a built-in function based on a function list. And source data fields corresponding to all source data uploaded in the cloud database by the user are displayed in the field list. In this embodiment, in order to facilitate the selection of the user, the source data field may include a text field (such as a raw material, a product name, a production process, and the like), a numerical field (such as a processing quantity, a qualified quantity, a total number of scrappings, and the like), a time field (processing time, and the like), a personnel field (such as an operator, and the like), a department field (such as a department to which a submitter belongs), and the like according to the type of the source data field, so that the user may quickly select the source data field according to the type of the source data field, thereby effectively saving the configuration time of the formula field and improving the configuration efficiency, and all the text field, the numerical field, the time field, the personnel field, and the department field may participate in the operation corresponding to the built-in function.
In some other embodiments, the field list may also simultaneously display a formula field configured by the user based on the source data field, and the configured formula field may also be selected to operate as a parameter of the built-in function, that is, in this case, the formula field may be regarded as the source data field to be used.
The function list shows built-in functions which can be used for operation and are configured in advance by a user. In this embodiment, the built-in functions include SUM, SUMIF, SUNIFS, COUNT, MAX, and the like, and in order to facilitate a user to quickly select the built-in functions, the built-in functions may be divided into a numerical function, a text function, and the like according to the type of the source data field, the data function is mainly used for processing source data corresponding to the numerical field, the time field, and the like, and the text function is mainly used for processing source data corresponding to the text field, the personnel field, the department field, and the like. And configuring a corresponding built-in function use instruction for each built-in function, wherein the built-in function use instruction comprises function meaning, basic usage, use examples, whether function nesting is supported, parameter types and the like, so that when a user configures a formula field, the user can configure the formula field by referring to the built-in function use instruction, the probability of errors during configuration is reduced, and the configuration efficiency is further improved. In a specific implementation, the built-in function "SUM" is taken as an example for further explanation, and after the user selects the "SUM" function, a built-in function usage diagram of the "SUM" function shown in table 1 below can be correspondingly presented in a display interface configured at the user:
TABLE 1
S2: and configuring a calculation rule for the source data field based on the built-in function to obtain a convention function and a formula field name.
Based on the obtained source data fields in the field list and the built-in functions in the formula list, the user can select the required source data fields and the built-in functions, and configure corresponding calculation rules for the source data fields required to be calculated by using the selected built-in functions to form an agreed function. For example: the formula field is 1-SUM ([ source data field 1])/SUM ([ source data field 2]) + MAX ([ source data field 3]) + 20%.
As shown in fig. 2, the step S2 specifically includes the following steps:
s201: and selecting a built-in function, and determining a parameter field list based on a parameter configuration rule of the built-in function.
Specifically, based on the configuration requirement of a formula field, an obtained built-in function is selected from the function list, and a source data field conforming to a parameter configuration rule is screened out from obtained source data fields according to the parameter configuration rule of the built-in function to form a parameter field list; that is, for each built-in function, a corresponding parameter type (i.e., parameter configuration rule) that can support participation in operation is configured. In other embodiments, the user may manually input the function name of the built-in function to select the desired built-in function, but when inputting, it is ensured that the built-in function exists in the function list.
In a specific implementation, a formula field named "yield" is configured as an example, and the yield is calculated based on the production quantity and the qualified quantity, that is, the yield is qualified quantity/production quantity 100% (the following steps are all described in this example). Firstly, all qualified quantity and production quantity are calculated, namely a SUM function is selected, wherein the parameter type of the SUM function is a numerical field, at the moment, other source data fields except the numerical field in the obtained source data fields can be removed to form a parameter field list only containing the numerical field, and a user can select a required source data field in the parameter field list to be configured into a parameter of the SUM function, so that the probability of configuration errors of the formula field is reduced.
S202: and selecting the source data fields which can participate in the calculation of the built-in function and configuring the source data fields as parameters of the built-in function.
Specifically, referring to the use instruction of the built-in function of the selected built-in function, the source data field required to perform the calculation is selected from the parameter field list, and the selected source data field is configured as the parameter of the built-in function. In other embodiments, the required source data field may also be selected by manual input, and similarly, in order to avoid an error during input, it is necessary to ensure that the input source data field exists in the parameter field list.
In specific implementation, first, the "qualified quantity" and the "production quantity" of the source data field are selected from the parameter field list, and then, the "qualified quantity" and the "production quantity" are respectively configured as parameters of a "SUM" function, namely SUM ([ qualified quantity ]) and SUM ([ production quantity ]).
In some other embodiments, when configuring the parameters of the built-in function, the source data corresponding to the source data field in the parameter field list may be further selected to participate in the operation of the built-in function. Such as the multi-conditional sum function SUMIFS ([ source data field 1], "filter condition 1", [ source data field 2], "filter condition 2", [ source data field 3]), and the source data field and the filter condition are parameters of the built-in function. Specific examples are: SUMIFS ([ spare part replacement record (yuan) ], "10", [ equipment annual inspection period (year) ], "(2016)", [ outside commission maintenance cost ]), which is expressed as: first, all source data with the amount of "10" are screened out under the source data field "spare part replacement record (element)", then all source data with the annual inspection period of "2016" are screened out under the source data field "equipment annual inspection period (year)" in the selected source data with the amount of "10", and the selected spare part replacement record (element) and the outsourcing maintenance cost are summed up.
S203: and configuring corresponding calculation rules after preprocessing the built-in function.
Specifically, first, the source data field is preprocessed based on the parameters of the built-in function and the processing rules of the built-in function, that is, the source data corresponding to the source data field configured by the source data field is calculated based on the built-in function. Then, the calculation rules are respectively configured among the built-in functions to form the appointed functions. In this embodiment, the calculation rule mainly includes an addition, subtraction, multiplication, and division four operation rules, and of course, in other embodiments, the calculation rule may also be configured into other calculation rules according to the requirement of the user. And then configuring the corresponding formula field name according to the appointed function and the data property obtained after executing the calculation rule. In this embodiment, besides the configuration of the default function, the number may also participate in the configuration, such as: 1 function name ([ parameter 1])/SUM ([ parameter 2 ]).
In specific implementation, each built-in function is first calculated, i.e. SUM ([ qualified quantity ]) and SUM ([ production quantity ]) are calculated, so as to SUM up the qualified quantity and the production quantity to obtain the respective total number. Then, the calculation rules of the SUM ([ qualified quantity ]) and the SUM ([ production quantity ]) are configured, since the yield needs to be obtained in this embodiment, the calculation rules here are "/" and "+", that is, the agreed function obtained by the configuration is: SUM ([ acceptable quantity ])/SUM ([ production quantity ]) 100%.
S204: and configuring the corresponding formula field name based on the appointed function.
And configuring the corresponding formula field name according to the calculation result of the agreed function. If the data calculated by the agreed function SUM ([ qualification quantity ])/SUM ([ production quantity ]) 100% is the qualification rate of the product, the "qualification rate" can be configured as the formula field name.
S3: and checking the legality of the appointed function and the name of the formula field.
And respectively carrying out legality verification on the agreed function and the formula field name, executing a subsequent configuration step of the formula field after the verification is passed, otherwise, reporting an error and prompting the agreed function or the formula field name which is not passed, returning to the execution step S2 to modify the agreed function or the formula field name and then carrying out verification again until the verification is passed so as to ensure the accuracy of the formula field and the feasibility of the agreed function. In this embodiment, the legality of the provisioning function includes the legality of a built-in function configured in the provisioning function and the legality of a calculation rule.
As shown in fig. 3, the step S3 specifically includes the following steps:
s301: and splitting the appointed function to obtain a plurality of built-in functions and function information thereof.
Specifically, after the agreed function is configured, the output content of the agreed function is a character string, so that before the agreed function is checked, the agreed function needs to be split by adopting a regular expression, the agreed function is split into a plurality of built-in functions, and the function information of the built-in functions is acquired one by one. In this embodiment, the function information includes a function name, a parameter number, and a parameter type of the built-in function.
As shown in fig. 4, the specific step of splitting the contract function in step S301 includes:
s3011: and giving corresponding parameter identifications to the built-in functions and the corresponding parameters.
The parameter identification may be used to identify the corresponding built-in function and parameter, and the value of the parameter identification may be different based on the built-in function or parameter. The specific settings are as follows:
first, a first parameter identifier is assigned to each built-in function in the agreed function, and the first parameter identifier is used for identifying the built-in function and assigning a value to the first parameter identifier of the built-in function. In this embodiment, the value of the first parameter identifier of the built-in function is an english parenthesis "()"; such as SUM (), SUMIFS (), wherein "()" is the value of the first parameter identifier of the built-in function; and the values of the first parameter identifiers of all built-in functions in this embodiment are the same, i.e., are all english brackets "()".
And then, respectively endowing each parameter in each built-in function with a corresponding second parameter identifier according to the parameter type, wherein the second parameter identifiers are used for identifying the parameters of the built-in functions, and respectively assigning values to the second parameter identifiers of the parameters, and the values of the second parameter identifiers are different according to different parameter types. In this embodiment, the value of the second parameter identifier may include an english middle bracket "[ ]" and an english double quotation mark "" "", and the like, and the english middle bracket "[ ]" is configured as a value of the parameter identifier of the source data field to be used for identifying the source data field, and the english double quotation mark "" "is configured as a value of the parameter identifier of the screening condition to be used for identifying the screening condition; such as the built-in functions SUMIFS ([ source data field 1], "filter condition 1", [ source data field 2], "filter condition 2", [ source data field ]).
And finally, acquiring non-Chinese and non-numeric characters in each parameter and endowing the non-Chinese and non-numeric characters with corresponding third parameter identifications, wherein the third parameter identifications are used for identifying the non-Chinese and non-numeric characters in the parameters and respectively assigning values to the non-Chinese and non-numeric characters in the parameters, and similarly, the third parameter identifications can have different values according to the non-Chinese and non-numeric characters. In the present embodiment, as an example: the parameters (i.e., source data field) "replacement record" (meta) "and" equipment annual check period (year) "," (2016) ", [ outsourcing maintenance cost)", in which there are chinese brackets "()" and english brackets "()" of non-chinese and non-numeric characters, and "screening condition" parameters, in which there are english brackets "()" that are the values of the third parameter identifiers corresponding to the inside of the respective parameters.
In this embodiment, the chinese parentheses "()", the english chinese parentheses "[ ]" and the english double-quotation mark "" "are customized by the user, and in other embodiments, the built-in function and its parameters may be identified by other symbols.
S3012: and replacing the second parameter identifier and the third parameter identifier and the values thereof according to the parameter identifiers and the values thereof.
Because some parameters (i.e. source data fields) are already configured from the beginning, the value of the second parameter identifier corresponding to the parameter and the value of the third parameter identifier inside the parameter (i.e. non-chinese and non-numeric characters contained inside the parameter) cannot be changed, so that the values of the second parameter identifier and the third parameter identifier may be the same as the value of the first parameter identifier, and when splitting the agreed function, the built-in function needs to be extracted through the value of the corresponding first parameter identifier.
Specifically, values corresponding to the second parameter identifiers and the third parameter identifiers are traversed, the values of the second parameter identifiers and the third parameter identifiers are compared with the value of the first parameter identifier (namely, an English bracket "()") one by one, the second parameter identifiers and the third parameter identifiers which are equal to the value of the first parameter identifier are extracted, and the extracted values of the second parameter identifiers and the third parameter identifiers are replaced, namely, the values of the second parameter identifiers and the third parameter identifiers, the values of which are English brackets "()" in the median of the second parameter identifiers and the third parameter identifiers, are replaced.
More specifically, in this embodiment, a regular matching rule is used to replace the values of the second parameter identifier and the third parameter identifier (that is, the english parenthesis "()" in the values of the second parameter identifier and the third parameter identifier), and the specific method is as follows:
a. and respectively determining a replacement character string based on the extracted second parameter identification and the extracted third parameter identification, wherein the replacement character strings corresponding to the values of the second parameter identification or the third parameter identification with the same value are the same.
In the present embodiment, since the value of the first parameter identifier of the built-in function is an english parenthesis "()", and the english parenthesis is composed of a left english parenthesis "(" and a right english parenthesis ")". At this time, the replacement character strings of the left english parentheses "(" and right english parentheses ")" are determined respectively:
const right closestring ═ ceshiright'; v/right English brackets replace character strings
const leftCloseString ═ ceshireft'; v/left English brackets replace character strings
That is, the right English bracket in the second parameter identification and the third parameter identification is replaced with the replacement character string "ceshiright" ", and the left English bracket in the second parameter identification and the third parameter identification is replaced with the replacement character string" ceshireft "(").
b. And respectively determining the regular matching rules of the second parameter identifications and the third parameter identifications, wherein the regular matching rules of the second parameter identifications or the third parameter identifications with the same value are the same.
In this embodiment, the "source data field" and the "screening condition" are both parameters of a built-in function, and taking the source data field and the screening condition as examples, the regular matching rule of the left english bracket "(" and right english bracket ")" in the source data field and the screening condition is determined respectively:
const right closereg (? (ii) [ ^ \ [ ] \ g))/g; regular matching rules for right English brackets in source data field
const leftCloseReg ═ (
const doublquetresregight ═/(? ([ \\\\\\ \) \/g) \/g)); regular matching rule of right and left English brackets in screening condition
const doublquetresregleft ═/(
It will be appreciated that in other embodiments, corresponding regular matching rules may be determined for different values of the second parameter identification and the third parameter identification, respectively.
c. And acquiring a second parameter identifier and a third parameter identifier corresponding to matching in an appointed function according to the regular matching rule, and replacing the value of the second parameter identifier or the third parameter identifier by using a corresponding replacement character string after the matching is successful.
Specifically, the regular matching rules in the source data field and the screening condition are used to match corresponding left english brackets "(" and right english brackets ")" in the source data field and the screening condition, and the matched left english brackets "(" and right english brackets ")" are replaced with the determined replacement character string:
Let param_new＝(param||”).replace(rightCloseReg,rightCloseString).
replace (double quotesRegright, rightCloseString)// replace the right English bracket
replace(leftCloseReg,rightCloseString).
replace (double quotesregleft, rightCloseString)// replace left English bracket
In a specific implementation, taking the convention function SUMIFS ([ spare part replacement record (element) ], "10", [ equipment annual inspection period (year) ], "(2016)", [ outside maintenance cost ]) SUM ([ maintenance frequency ]) as an example, the source data field [ spare part replacement record (element) ] and the screening condition "(2016)" both have the english bracket "()", and after the replacement in this step is performed, the aforementioned convention function can be expressed as:
SUMIFS ([ spare part replacement record processleft element processright ], "10", [ equipment annual inspection period (year) ], "processleft 2016 processright", [ outsourced maintenance cost ]) SUM ([ maintenance times ]).
Since the parenthesis in the source data field annual check period (year) is chinese parenthesis, no replacement is required.
S3013: and splitting the replaced appointed function by using the first parameter identifier to obtain the built-in function and the function information thereof.
Specifically, a regular expression is adopted, and the first parameter identifier (i.e., an english bracket "()") is used to split the convention function into a plurality of built-in function character string lists:
fucReg＝new RegExp(`\(\(${fucList.join('|')}\)\\\([^\\\)]*\\\)\)$
{replaceList&&replaceList.length&&`|\(${replaceList.join('|')}\)`||”}`,'gi')；
Let paramList＝lower_param_new.match(fucReg)；
and then splitting the function name and the parameters of the single built-in function based on the split built-in function character string list, and obtaining the parameter number and the parameter type of each built-in function. The parameter number is determined by the separated separators between the parameters, and the parameter type is determined by the value of the second parameter identifier of the corresponding parameter.
In a specific implementation, the regular expression for splitting the agreed function may be represented as:
/((SUM|SUMIF|SUMIFS|COUNT|COUNTIF|COUNIFS|AVERAGE|MIN|MAX|DISTINCTCOUNT|DATEDIF|DATESORT)\([^\)]*\))|(ceshiSum)/gi。
in this embodiment, the function name and the function parameter in the convention function are split by using the left english parentheses as the splitting point:
Let index＝ele.indexOf('(')；
Let new_ele＝[]；
new_ele[0]＝ele.slice(0,index)；
new_ele[1]＝ele.slice(index+1,ele.leghth-1)；
the above process is executed, and the convention function is split by using a left English bracket in the first parameter representation in the convention function (the' is a separator).
S3014: and replacing the replaced values of the second parameter identification and the third parameter identification back to the original values.
After the contract function is split, in order to enable the contract function to operate normally, the English brackets "()" which are replaced in the second parameter identifier and the third parameter identifier before need to be replaced. Specifically, the second parameter identifier and the third parameter identifier replaced in step S3012 are obtained, and replaced with the corresponding original values:
fuc:new_ele[0].replace(/\s+/g,”).toUpperCase()；
param:new_ele[1].replace(new RegExp(rightCloseString,'g'),')').replace(new RegExp(leftCloseString,'g'),'(')；
in a specific implementation, splitting is performed on the contract function SUMIFS ([ spare part replacement record (element) ], "10", [ equipment annual inspection period (year) ], "(2016)", [ outside commission maintenance cost ]) SUM ([ maintenance times ]) and then can be expressed as:
0: // built-in function SUMIFS
fuc: "SUMIFS"; // function name
param: "[ spare part replacement record (element) ], \\ 10\", "[ equipment annual check period (year) ]," (2016) \\\\, [ outsourcing repair costs ] "; // parameter
1: // built-in function SUM
fuc, "SUM"; // function name
param: "[ maintenance times ]"; // parameter
In this embodiment, if there are a plurality of parameters after splitting, the middle of the parameters is separated by "english commas", and the number of parameters arranged in each built-in function can be determined according to the number of english commas during recognition. It will be appreciated that in other embodiments, the parameters may be separated by other symbols to determine the final number of parameters.
S302: and checking the legality of each built-in function.
After the splitting of the appointed function is completed, the legality of a single built-in function can be checked one by one according to the function information of each built-in function. In this embodiment, the checking the validity of the built-in function mainly includes checking the function name, the parameters, the number of the parameters, and the type of the parameters of the built-in function, if the function information corresponding to each built-in function passes the checking, it indicates that the configuration of the built-in function is valid, and then continues to execute step S303, otherwise, it indicates that the configuration of the built-in function is not valid, and then jumps to execute step S307.
Specifically, as shown in fig. 5, the specific method for performing validity verification on the built-in function in step S302 is as follows:
s3021: and checking whether the function name of the built-in function is legal or not.
Specifically, the function names of the internal functions obtained by splitting are matched with the function names of the internal functions in the function list one by one, and whether the corresponding function names exist in the function list or not is judged one by one. If the matching is successful, the function name of the built-in function is legal, then the step S3022 is continuously executed, otherwise, the step S307 is executed.
S3022: and checking whether the parameter quantity of the built-in function is legal or not.
For some parameters, there is a requirement for the number of the parameters during calculation, so that the validity of the number of the parameters needs to be checked, specifically, the number of the parameters in each internal function obtained by splitting is matched with the parameter configuration rule of the internal function, and whether the number of the parameters of the internal function after splitting meets the requirement for the number of the parameters specified in the parameter configuration rule of the internal function is judged. If the matching is successful, it indicates that the parameter number of the built-in function is legal, and then the step S3023 is continuously executed, otherwise, the step S307 is executed.
S3023: and checking whether the parameter names of the built-in functions are legal or not.
Specifically, the parameter names of the parameters obtained by splitting are matched with the field names of the source data fields in the field list one by one. Of course, as in the SUMIFS () function, the parameter name (i.e., the filtering condition) needs to be matched with the source data corresponding to the source data field. If the matching is successful, the parameter name of the built-in function is legal, and then the step S3034 is continuously executed, otherwise, the step S307 is executed.
S3024: and checking whether each parameter type of the built-in function is legal or not.
Since the data processed by each built-in function is different, the parameter type of each built-in function needs to be checked. Specifically, the parameter type of each parameter obtained by splitting is matched with the corresponding second parameter identifier, if the parameter type of a built-in function is a source data field, the parameter type determined by the second parameter identifier can be matched with the split parameter type, if the matching is successful, the parameter type configured by the built-in function is legal, and then step S303 is continuously executed, otherwise step S307 is executed.
In this embodiment, the execution sequence of the steps S3021 to S3024 is only a preferred embodiment of checking the function name, the parameter, the number of parameters, and the type of parameter, and in other embodiments, the steps S3021 to S3024 may be executed in any conversion sequence as required.
S303: and executing operation on the appointed function based on the calculation rule to obtain an operation result.
Specifically, the agreed function after the verification of the built-in function is verified to determine whether the configured calculation rule is legal, that is, whether the configured four operation rules are legal is verified.
Firstly, based on each built-in function obtained by splitting, each built-in function is integrally replaced by a non-zero random number carrying a fourth parameter identifier, so that a formula comprising a calculation rule and a numerical value is obtained:
Let computedString＝param_new.replace(fucReg,()＝>{
return' ($ {1+ Math. random () }); v/replacement of all weight functions by different non-zero random numbers
In this embodiment, the fourth parameter is identified as an english bracket "()", that is, the SUM () function and the SUM () function in the agreed function SUM ([ spare part replacement record (element) ], "10", [ equipment annual inspection period (year) ], "(2016)", [ maintenance cost for outsiders ]) SUM ([ maintenance times ]) are collectively replaced with (1) and (2), respectively, and equation 1 × 2 can be obtained.
Then, an operation is performed on the equation based on the calculation rule:
let result ═ eval (computedstring); v/performing four arithmetic operations
And obtaining the operation result of the formula.
In this embodiment, the operation is specifically performed on the formula 1 × 2 based on a calculation rule, so as to obtain an operation result 2 of the formula.
S304: and checking the legality of the calculation rule.
Specifically, the validity of the calculation rule is checked according to the operation result after the operation is performed by the built-in function, if the operation result is a number, the calculation rule is verified to be valid, and then the step S305 is continuously performed, otherwise, the step S307 is executed.
S305: the name of the source data field is matched against the formula field name line based on the field list.
In order to distinguish the source data fields from the formula fields, the field names in the field list need to be unique. Specifically, the source data fields in the field list are traversed (or the source data fields configured by the user may be included), and the names of the formula fields are compared with the names of the source data fields and the names of the configured formula fields one by one.
S306: the validity of the formula field name is checked.
Specifically, the validity of the formula field name is checked according to the comparison result between the formula field name and each source data field name, if the comparison result passes the check, it indicates that the formula field name does not exist, then the check is completed, otherwise, it indicates that the formula field name already exists in the field list, and then step S307 is executed.
S307: and reporting errors to the appointed function and the formula field name which fail to pass the verification and prompting.
And reporting errors to the names of the built-in functions, the calculation rules or the formula fields which fail to pass the verification, generating prompt information, returning to execute the step S2, and modifying the built-in functions, the calculation rules or the formula fields which fail to pass the verification.
S4: and associating the convention function with the formula field name to obtain a formula field, and updating the field list.
Specifically, the formula field name passing the validity check is associated with the agreed function to generate a formula field, and the formula field is stored and then added to the field list to update the field list, so that a user can directly select a source data field or a configured formula field from the field list.
In the method for configuring a formula field in this embodiment, a plurality of formula fields based on a source data field can be configured on the basis of the source data field and a built-in function, so as to enrich a database; meanwhile, in the configuration process of the formula field, the formula field can be split and then the legality of the configuration of the built-in function, the calculation rule and the formula field name can be checked one by one, so that the configured formula field can accurately execute calculation, and the method is strong in universality and high in flexibility.
Example 2
Fig. 6 is a flowchart of a report configuration method based on formula fields according to embodiment 2 of the present invention. The formula field in the report configuration method based on the formula field according to this embodiment can be implemented based on the formula field configuration method according to embodiment 1. Specifically, the present embodiment includes the following steps:
p1: and configuring the report statistic dimension and loading the optional fields.
Firstly, configuring report form statistical dimensions; in this embodiment, the statistical dimensions include product names, person names, and the like.
And then loading optional fields corresponding to the data in the cloud database based on the cloud database. In this embodiment, the optional fields include a source data field carrying a first field identifier and a formula field carrying a second field identifier, where the first field identifier and the second field identifier may be used to distinguish the source data field from the formula field, and then the loaded source data field carrying the first field identifier and the loaded formula field carrying the second field identifier are integrated to form a field list.
The formula field in this embodiment can be configured based on the configuration method of the formula field described in embodiment 1, and for a specific configuration process, refer to embodiment 1, which is not described herein again.
P2: and selecting optional fields based on the request, and integrating to obtain the statistical report.
Firstly, selecting a corresponding optional field from the field list based on a request of a user, judging whether the selected field is a source data field or a formula field through a first field identifier and a second field identifier, respectively executing corresponding data calling or calculation, and then integrating the statistical dimensions to obtain a statistical report.
As shown in fig. 7, the specific step of integrating the statistical form in step P2 includes:
p201: the field type of the optional field is determined.
Based on the request of the user, the field identifier of the selected optional field to be calculated is obtained, if the field identifier is the first field identifier, the optional field is indicated as the source data field, then step P203 is executed, if the field identifier is the second field identifier, the optional field is indicated as the formula field, and then step P202 is executed.
P202: obtaining a contract function associated with the formula field based on the formula field, and performing a calculation on the contract function to return the value of the formula field.
First, according to the formula field name, the convention function associated with the formula field is obtained.
Then, based on the agreed function, each built-in function in the agreed function is determined, and each built-in function is obtained in a function list and a parameter value (mainly source data corresponding to a source data field configured in the built-in function) of a parameter corresponding to each built-in function is obtained in a cloud database.
And finally, calculating each built-in function respectively, then calculating the appointed function by using a configured calculation rule, returning the calculation result as the value of the formula field, and skipping to execute the step P204.
P203: the source data is obtained based on the source data field and the value of the source data field is returned.
And obtaining source data corresponding to the source data field in a cloud database according to the name of the source data field, returning the source data as the value of the source data field, and skipping to execute the step P204.
P204: and integrating the formula field, the source data field and the values thereof to obtain a statistical report.
Specifically, the formula field and its value returned in step P202 and the source data field and its value returned in step P203 are integrated by combining the statistical dimensions, so as to obtain a statistical report form in which the field name of the formula field and/or the source data field is used as the header, and the value of the formula field and/or the source data field is used as the content, for the user to view.
The report matching method based on the formula field can configure the report based on the source data field and the configured formula field, can improve the capability of the report for computing, outputting and displaying a plurality of index data, enriches the displayed data, enables a user to visually and conveniently check the production and management conditions, and improves the efficiency of report configuration.
As another embodiment of the present invention, there is also provided a computer storage medium having a computer program stored thereon, which, when executed by a computer, can perform part or all of the operations of the formula field configuring method of embodiment 1 and the formula field based report configuring method of embodiment 2 described above, thereby implementing the functions of the above embodiments.
The foregoing is merely an example of the present invention and common general knowledge of known specific structures and features of the embodiments is not described herein in any greater detail. It should be noted that, for those skilled in the art, without departing from the structure of the present invention, several changes and modifications can be made, which should also be regarded as the protection scope of the present invention, and these will not affect the effect of the implementation of the present invention and the practicability of the present invention.
Claims (10)
1. A method for configuring formula fields is characterized by comprising the following steps:
s1: acquiring a source data field based on a field list and acquiring a built-in function based on a function list;
s2: configuring corresponding calculation rules for the obtained source data fields based on the built-in functions to form an agreed function, and configuring corresponding formula field names;
s3: carrying out validity check on the agreed function and the formula field name, wherein the validity of the agreed function comprises the validity of a built-in function and the validity of a calculation rule;
s4: and associating the formula field name passing the validity check with the appointed function to generate a formula field, and updating the formula field into a field list.
2. The method according to claim 1, wherein the step S2 specifically includes the following steps:
s201: selecting an obtained built-in function, and screening out source data fields which accord with a parameter configuration rule from obtained source data fields according to the parameter configuration rule of the built-in function to form a parameter field list;
s202: selecting a source data field from the parameter field list to be configured as a parameter of the built-in function;
s203: respectively preprocessing the source data fields based on the parameters of the built-in functions and the processing rules of the built-in functions, and then respectively configuring calculation rules among the built-in functions to form appointed functions;
s204: and configuring the corresponding formula field name based on the appointed function.
3. The method according to claim 1, wherein the step S3 specifically includes the following steps:
s301: splitting the appointed function to obtain a plurality of built-in functions and acquiring function information of the built-in functions, wherein the function information comprises function names, parameters, parameter numbers and parameter types of the built-in functions;
s302: checking the legality of the built-in functions one by one according to the function information, if the check is passed, continuing to execute the step S303, otherwise, skipping to execute the step S307;
s303: executing operation on the appointed function based on the calculation rule to obtain an operation result;
s304: checking the validity of the calculation rule according to the calculation result of the built-in function after calculation, if the validity passes the check, continuing to execute the step S305, otherwise, skipping to execute the step S307;
s305: traversing each source data field in the field list, and comparing the name of the formula field with the name of each source data field;
s306: checking the legality of the formula field name according to the comparison result of the formula field name and each source data field name, if the formula field name passes the checking, finishing the checking, and otherwise, skipping to execute the step S307;
s307: and reporting errors to the names of the built-in functions, the calculation rules or the formula fields which fail to pass the verification, generating prompt information, returning to execute the step S2, and modifying the built-in functions, the calculation rules or the formula fields which fail to pass the verification.
4. The method according to claim 3, wherein the step S301 of splitting the contract function specifically comprises:
s3011: assigning a first parameter identifier to each built-in function in the appointed function, and assigning a corresponding second parameter identifier to each parameter in each built-in function according to the parameter type, so as to obtain a corresponding third parameter identifier assigned to non-Chinese and non-numeric characters in each parameter;
s3012: traversing values corresponding to the second parameter identifications and the third parameter identifications, extracting the second parameter identifications and the third parameter identifications which are equal to the value of the first parameter identification, and replacing the extracted values of the second parameter identifications and the third parameter identifications;
s3013: splitting the agreed function into a plurality of built-in function character string lists by using the first parameter identifier, and acquiring function information of each built-in function based on the built-in function character string lists;
s3014: and acquiring the second parameter identifier and the third parameter identifier after replacement in the step S3012, and replacing the second parameter identifier and the third parameter identifier with the corresponding original values.
5. The method according to claim 4, wherein in step S3012, the values of the second parameter identifier and the third parameter identifier are replaced by a regular matching rule, and the specific method is as follows:
a. respectively determining a replacement character string based on the extracted second parameter identification and the extracted third parameter identification, wherein the replacement character strings corresponding to the values of the second parameter identification or the third parameter identification with the same value are the same;
b. respectively determining regular matching rules of each second parameter identifier and each third parameter identifier, wherein the regular matching rules of the second parameter identifiers or the third parameter identifiers with the same value are the same;
c. and acquiring a second parameter identifier and a third parameter identifier corresponding to matching in an appointed function according to the regular matching rule, and replacing the value of the second parameter identifier or the third parameter identifier by using a corresponding replacement character string after the matching is successful.
6. The method according to claim 4, wherein the specific method for performing the validity verification on the built-in function in the step S302 is as follows:
s3021: matching the function names of the internal functions obtained by splitting with the function names of the internal functions in the function list one by one, if the matching is successful, continuing to execute the step S3022, otherwise, skipping to execute the step S307;
s3022: matching the number of the parameters in each built-in function obtained by splitting with the parameter configuration rule of the built-in function, if the matching is successful, continuing to execute the step S3023, otherwise, skipping to execute the step S307;
s3023: matching the parameter names of the parameters obtained by splitting with the field names of the source data fields in the field list one by one, if the matching is successful, continuing to execute the step S3034, otherwise, skipping to execute the step S307;
s3024: and matching the parameter types of the parameters obtained by splitting with the corresponding second parameter identifications, if the matching is successful, continuing to execute the step S303, otherwise, skipping to execute the step S307.
7. The method as claimed in claim 3, wherein the specific method for performing the operation on the contract function in step S303 is as follows:
and based on each built-in function obtained by splitting, integrally replacing each built-in function with a non-zero random number carrying a fourth parameter identifier to obtain an equation comprising a calculation rule and a numerical value, and executing operation on the equation based on the calculation rule to obtain an operation result of the equation.
8. A report configuration method based on formula fields is characterized by comprising the following steps:
p1: configuring report statistics dimensions, and loading optional fields based on a database, wherein the optional fields comprise a source data field carrying a first field identifier and a formula field carrying a second field identifier to form a field list, and the formula fields are configured by adopting the formula field configuration method according to any one of claims 1 to 7;
p2: and selecting corresponding optional fields from the field list based on a request of a user, acquiring corresponding data from the database based on the statistical dimension and the optional fields, and integrating to obtain a statistical report.
9. The method according to claim 8, wherein the step P2 of integrating the statistical report comprises the following steps:
p201: judging whether the optional field is a formula field or not according to the first field identification and the second field identification, if so, continuing to execute the step P202, otherwise, skipping to execute the step P203;
p202: acquiring the appointed function configured in the formula field, acquiring corresponding built-in functions and parameter values of parameters corresponding to the built-in functions in a function list based on the appointed function, calculating the built-in functions respectively, then calculating the appointed function by using a calculation rule, returning the calculation result as the value of the formula field, and skipping to execute the step P204;
p203: obtaining source data corresponding to the source data field from a database, returning the source data as a value of the source data field, and skipping to execute the step P204;
p204: and integrating the statistical dimension, the formula field and/or the source data field and the corresponding values thereof to form a corresponding statistical report.
10. A computer storage medium having stored thereon a computer program, wherein the computer program, when executed by a processor, implements a method of configuring a formula field according to any one of claims 1-7 and implements a method of configuring a report based on a formula field according to any one of claims 8-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210093555.XA CN114416832B (en) | 2022-01-26 | 2022-01-26 | Method for configuring formula field and report and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210093555.XA CN114416832B (en) | 2022-01-26 | 2022-01-26 | Method for configuring formula field and report and computer storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114416832A true CN114416832A (en) | 2022-04-29 |
| CN114416832B CN114416832B (en) | 2022-11-15 |
Family
ID=81277803
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210093555.XA Active CN114416832B (en) | 2022-01-26 | 2022-01-26 | Method for configuring formula field and report and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114416832B (en) |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100325173A1 (en) * | 2009-06-23 | 2010-12-23 | The Board Of Regents Of The The University Of Texas System | Rapid development of informatics systems for collaborative data management |
| CN103019728A (en) * | 2012-12-20 | 2013-04-03 | 厦门亿力吉奥信息科技有限公司 | Effective complex report parsing engine and parsing method thereof |
| CN108197207A (en) * | 2017-12-28 | 2018-06-22 | 南京涵韬信息科技有限公司 | Batch data matches introduction method |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| CN109684616A (en) * | 2018-12-13 | 2019-04-26 | 山东浪潮通软信息科技有限公司 | Dynamic statement formula assembles the method and system made a report on |
| CN110147402A (en) * | 2019-05-22 | 2019-08-20 | 北大方正集团有限公司 | Excel file introduction method and equipment, deriving method and equipment |
| KR102067504B1 (en) * | 2018-10-02 | 2020-01-17 | 주식회사 한글과컴퓨터 | Spreadsheet document editing apparatus for performing an automatic filter function through the creation of a temporary header and operating method thereof |
| CN111626028A (en) * | 2020-05-29 | 2020-09-04 | 深圳前海微众银行股份有限公司 | Report generation method, device and equipment based on function analysis and computer medium |
| CN111897470A (en) * | 2020-07-06 | 2020-11-06 | 上海泛微网络科技股份有限公司 | Method and device for dynamically setting form calculation logic |
| CN111897469A (en) * | 2020-07-06 | 2020-11-06 | 上海泛微网络科技股份有限公司 | Real-time data processing method, device, equipment and storage medium |
| CN112256948A (en) * | 2020-10-13 | 2021-01-22 | 北京字跳网络技术有限公司 | Data processing method and device and electronic equipment |
| CN112560413A (en) * | 2020-12-15 | 2021-03-26 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113761858A (en) * | 2021-09-07 | 2021-12-07 | 平安国际智慧城市科技股份有限公司 | Form data processing method and device, computer equipment and storage medium |
| CN113822028A (en) * | 2021-09-28 | 2021-12-21 | 重庆允成互联网科技有限公司 | Report for realizing aggregation of multiple discrete indexes and report configuration method |
-
2022
- 2022-01-26 CN CN202210093555.XA patent/CN114416832B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100325173A1 (en) * | 2009-06-23 | 2010-12-23 | The Board Of Regents Of The The University Of Texas System | Rapid development of informatics systems for collaborative data management |
| CN103019728A (en) * | 2012-12-20 | 2013-04-03 | 厦门亿力吉奥信息科技有限公司 | Effective complex report parsing engine and parsing method thereof |
| CN108197207A (en) * | 2017-12-28 | 2018-06-22 | 南京涵韬信息科技有限公司 | Batch data matches introduction method |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| KR102067504B1 (en) * | 2018-10-02 | 2020-01-17 | 주식회사 한글과컴퓨터 | Spreadsheet document editing apparatus for performing an automatic filter function through the creation of a temporary header and operating method thereof |
| CN109684616A (en) * | 2018-12-13 | 2019-04-26 | 山东浪潮通软信息科技有限公司 | Dynamic statement formula assembles the method and system made a report on |
| CN110147402A (en) * | 2019-05-22 | 2019-08-20 | 北大方正集团有限公司 | Excel file introduction method and equipment, deriving method and equipment |
| CN111626028A (en) * | 2020-05-29 | 2020-09-04 | 深圳前海微众银行股份有限公司 | Report generation method, device and equipment based on function analysis and computer medium |
| CN111897470A (en) * | 2020-07-06 | 2020-11-06 | 上海泛微网络科技股份有限公司 | Method and device for dynamically setting form calculation logic |
| CN111897469A (en) * | 2020-07-06 | 2020-11-06 | 上海泛微网络科技股份有限公司 | Real-time data processing method, device, equipment and storage medium |
| CN112256948A (en) * | 2020-10-13 | 2021-01-22 | 北京字跳网络技术有限公司 | Data processing method and device and electronic equipment |
| CN112560413A (en) * | 2020-12-15 | 2021-03-26 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113761858A (en) * | 2021-09-07 | 2021-12-07 | 平安国际智慧城市科技股份有限公司 | Form data processing method and device, computer equipment and storage medium |
| CN113822028A (en) * | 2021-09-28 | 2021-12-21 | 重庆允成互联网科技有限公司 | Report for realizing aggregation of multiple discrete indexes and report configuration method |
Non-Patent Citations (1)
| Title |
|---|
| 陈新林 等: "管理报表系统用户自定义函数解析器算法实现", 《武汉理工大学学报(信息与管理工程版)》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114416832B (en) | 2022-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2017255561B2 (en) | Learning from historical logs and recommending database operations on a data-asset in an ETL tool | |
| US20140344271A1 (en) | Requirements characterisation | |
| US20130218620A1 (en) | Method and system for skill extraction, analysis and recommendation in competency management | |
| Nakazawa et al. | Visualization tool for designing microservices with the monolith-first approach | |
| CN108564255B (en) | Matching model construction method, orphan allocation method, device, medium and terminal | |
| US11068758B1 (en) | Polarity semantics engine analytics platform | |
| CN105844422A (en) | Business flow execution method and device | |
| US20170372389A1 (en) | Adaptive and tunable risk processing system and method | |
| Kim et al. | Constructing decision trees from process logs for performer recommendation | |
| CN109558384A (en) | Log classification method, device, electronic equipment and storage medium | |
| Urrea-Contreras et al. | Process mining perspectives in software engineering: A systematic literature review | |
| CN114416832B (en) | Method for configuring formula field and report and computer storage medium | |
| Izquierdo-Cortazar et al. | Towards automated quality models for software development communities: The QualOSS and FLOSSMetrics case | |
| CN115018106A (en) | Anomaly analysis method, device, equipment and computer-readable storage medium | |
| US20090150205A1 (en) | Capital allocation systems and methods | |
| CN109902196B (en) | Trademark category recommendation method and device, computer equipment and storage medium | |
| CN116823059A (en) | Index evaluation method and device, electronic equipment and storage medium | |
| Ceravolo et al. | Knowledge acquisition in process intelligence | |
| CN111145053A (en) | Enterprise law consultant management system and method based on artificial intelligence | |
| JPWO2020085114A1 (en) | Information processing equipment, information processing methods, and programs | |
| CN112668842A (en) | Vehicle insurance claim settlement risk factor evaluation method and device, electronic equipment and medium | |
| CN112000887A (en) | Business rewarding system and method applied to intermediary service selection | |
| US8321458B2 (en) | Related contact and record recommendation for product design | |
| US20190258565A1 (en) | Multiple ruleset version scanning, warning and correction tool | |
| CN115048284B (en) | Method, computing device and storage medium for testing applications of a system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |