CN113591446B - Configurational account checking file generating device - Google Patents
Configurational account checking file generating device Download PDFInfo
- Publication number
- CN113591446B CN113591446B CN202110726121.4A CN202110726121A CN113591446B CN 113591446 B CN113591446 B CN 113591446B CN 202110726121 A CN202110726121 A CN 202110726121A CN 113591446 B CN113591446 B CN 113591446B
- Authority
- CN
- China
- Prior art keywords
- data
- configuration
- function
- file
- data source
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the technical field of computers, in particular to a configuration account checking file generating device, which aims to solve the problems that the prior art mentioned in the background art only can process the differences of simple data column formats and the like, and the configuration is complex and the learning cost is high; the main editing area of the target file content is displayed by adopting a graphical form, and field cells of the editing area are directly dragged to the editing area from a data source or edited by a function editor; the data area is used for configuring the value of each column of data, a part of columns are acquired through a data source, and the part of columns are subjected to function calculation and conversion based on actual conditions; the configuration of the account checking file is simplified, the configuration mode is obtained immediately, an operator can complete the configuration through dragging and editing the interface, meanwhile, an example of the account checking file is generated, the final file effect can be seen clearly through the interface, the probability of configuration errors is reduced, the complexity of the configuration is reduced, and the operator can quickly get on hand both by a technician and a business operator.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to a configurable account checking file generation device.
Background
Currently, in the field of internet finance, a reconciliation document is a general reconciliation method, and when a large number of third parties are docked, the complexity is increased continuously due to the diversification of the reconciliation document. The file interaction between systems needs to process file format, data column field difference and the like, if the file interaction is oriented to accounting operators, the data file at the moment is very unfriendly, and under the condition, the functions of summarizing and counting data headers, data rows and data columns and the like are very necessary, so that related operators can quickly analyze and decide, and the data processing is not needed.
The traditional account checking file generation is to write different processing logic units according to different special requirements of a third party, the scheme has poor expansibility, recoding, testing and publishing are needed for each time of third party requirement change, and a large amount of manpower and material resources are consumed; at present, some technical schemes realize partial configuration, but only can process differences such as simple data column formats, and the like, and the summarizing and counting functions are single, and the configuration is complex and the learning cost is high.
Disclosure of Invention
The invention provides a configuration account checking file generation device, which aims to solve the problem that coding, testing and release are needed again after the third party changes in the background technology, and a large amount of manpower and material resources are consumed.
In order to achieve the above purpose, the present invention provides the following technical solutions:
a configurable account checking file generation device comprises a configuration editing module, a data reading module and a file generation module;
the configuration module is used for locally configuring information, and the configuration information comprises a configuration data source, a target file attribute, target file content and a data area;
the configuration data source is a data query range of each data source defining each target file, each target file is provided with a plurality of data sources, and associated data between a main data source of the target file and other data sources of the target file are defined; the target file is the data information which the requester (the third place) needs to request to acquire;
the main editing area of the target file content is displayed by adopting a graphical form, and field cells of the editing area are directly dragged to the editing area from a data source or edited by a function editor;
configuring the data area as the value of each column of data, wherein part of columns are directly acquired through a local data source, and part of columns are converted through function calculation based on actual conditions according to the data of the local data source;
the data reading module assembles a related data source group based on the related data;
the file generation module is used for generating data and generating summary statistics;
the generated data are line-by-line read data source groups, the configuration of data columns is carried out based on the value of each column of data of the data area, if the data are directly obtained through the data sources, the values of the data sources are directly obtained according to paths, and if the data are converted through function calculation, the values are analyzed through corresponding function expressions;
and the generation summary statistics is to add a function expression according to the actual conditions of each column or row of the data source for summary statistics.
Compared with the prior art, the invention has the beneficial effects that:
1. the configuration of the account checking file is simplified, the configuration mode is obtained immediately, an operator can complete the configuration through dragging and editing the interface, meanwhile, an example of the account checking file is generated, the final file effect can be seen clearly through the interface, the probability of configuration errors is reduced, the complexity of the configuration is reduced, and the operator can quickly get on hand both by a technician and a business operator.
2. Based on the function, the conversion and statistics of various data can be flexibly and variously configured, the application range of reconciliation documents is enriched, and under the condition of no need of coding test and application release, the data file transfer between systems can be responded quickly, and the data statistics total collection capability can be provided for operation business personnel, so that the operation business personnel can be helped to analyze and decide quickly.
Drawings
FIG. 1 is a schematic diagram of an AST tree diagram structure according to the present invention;
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
A preferred embodiment of the present invention will be described in detail with reference to fig. 1;
a configurable account checking file generation device comprises a configuration editing module, a data reading module and a file generation module;
the configuration module is used for locally configuring information, and the configuration information comprises a configuration data source, a target file attribute, target file content and a data area;
the configuration data source is used for defining a data query range of each data source of each target file, wherein each target file is provided with a plurality of data sources, and associated data between a main data source and other data sources is defined;
configuring the data area to configure the value of each column of data, wherein part of columns are acquired through a data source, and part of columns are subjected to function calculation conversion based on actual conditions;
the file generation module is used for generating data and generating summary statistics;
the generated data are line-by-line read data source groups, the configuration of data columns is carried out based on the value of each column of data of the data area, if the data are directly obtained through the data sources, the values of the data sources are directly obtained according to paths, and if the data are converted through function calculation, the values are analyzed through corresponding function expressions;
and the generation summary statistics is to add a function expression according to the actual conditions of each column or row of the data source for summary statistics.
As a preferred technical solution of this embodiment, the target file attribute includes defining a target file format, encoding, file name, and file storage information. The main editing area of the target file content is displayed by adopting a graphical table, and the field cells of the editing area are directly dragged to the editing area from a data source or edited by a function editor.
As a preferable technical scheme of the embodiment, the main editing area is divided into three areas, and the three areas are respectively edited by a local data source, a target file attribute and target file content. By setting three editing areas, the difference between the local data and the target file request data can be visually seen, quick dragging can be realized, the relevant difference can be visually seen, a relevant function expression is configured, and corresponding request data is calculated.
As a further technical solution of this embodiment, the configuration module is further configured to configure a header area, where the header area is configured as one or more rows of headers, and the header columns are in parallel or specify a sorting rule. The ordering rules may be ordering according to the first letter of the name, ordering according to the second letter if the first letters are the same, and so on.
As a further technical solution of this embodiment, the configuration module is further configured to configure a summary statistics area, where the summary statistics area is located after the header or after the data area.
As a further technical solution of this embodiment, the file generating module further includes a header generating module configured to generate header data according to the header area configured by the configuration module.
As shown in fig. 1, as a preferred technical solution of this embodiment, when the data is generated, a function expression is adopted for parsing, an AST abstract syntax tree is used to implement parsing of the function expression, leaf nodes of the tree are data source values or constants, and a depth-first traversal algorithm is adopted to parse the leaf nodes upwards at a time.
As a preferred technical solution of this embodiment, the configuration information is added to version control.
The function expression is defined as a format of funcName ([ arg1, arg2,.,. ArgN ]), the function comprises a function name and optional 0-N parameters, special symbols "," () "need to be translated, the function can be used in a nested manner, the function comprises constants, reference values, code table conversion, mathematical operation, summary statistics, financial formulas, logical operation, text time digital formatting, method call, and the function supports dynamic expansion and loading.
For example, two existing cooperations a and B need a student score table, and the student score table needs to be configured with two data sources, and one student information S1, S1 includes a student number id, a name, and an age; one personal score S2 includes a number id, a chinese score a, a mathematical score b, and an english score c; two data sources S1 and S2 are defined to be related to each other by a number id.
The partner A has simple requirements, the required target file only needs no header, gathers information and only needs original data, as shown in the following table 1-1:
TABLE 1-1
| s1.id | s1.name | s1.age | s2.a | s2.b | s2.c |
When the partner only needs the original data, the staff can directly drag the data in the data source to the target file content editing area; thereby the generation of the account checking file is realized rapidly.
The requirements of the partner B are complex, and the wanted information includes the total number of people in the summarized class, the average value of the performance of each class, the number of people in each performance interval, etc., so the target file needs the information such as header, data, statistics of data lines, statistics of data columns, etc., as shown in the following tables 1-2:
TABLE 1-2
Line 1 is header information configuration
Row 2 is a data row configuration in which:
column 1 function sn () represents a growing sequence starting from 1, i.e., a line number;
columns 2 through 7 represent values from a certain attribute of the data source;
column 8 represents the sum of columns a, b, c in data source s 2;
column 9 shows the average of the three columns a, b, c in the data source s 2;
column 10 indicates that the corresponding value t2 is returned by the value matching index interval i1 of column 9;
i1 is an index range section defined for this time for the secondary file, as shown in the following tables 1-2:
tables 1 to 3
If column 9 is 81, then final column 10 is "good";
lines 3 and 4 are summary statistical configurations:
ct () represents the total number of bars;
avg () represents the average value of this column;
ctif (fv (9), ons (excellent)) means that the count is incremented by 1 if column 9 is excellent and is otherwise incremented by 0.
If the data required by the partner is shown in table 1-2, the content of average score, total score, good evaluation and the like is related, and the local data only contains the original data, so that if the partner needs data which needs processing except the original data, the staff can directly edit the function expression in the editing area of the content of the target file according to the actual situation to generate the corresponding data.
As a preferred technical solution of this embodiment, when generating data, the function expression is resolved by using an AST abstract syntax tree, where the tree leaf node is a data source value or constant, and a depth-first traversal algorithm is used to resolve the leaf node upward at a time, for example: the function if (add (s 2.A, s2.B, s2. C), con (500)), con (encouragement), con (maintenance)) expresses that if the classmates with a three family score sum of less than 500 score need to pay attention to encouragement, other maintenance, AST dendrogram is shown in fig. 1.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Furthermore, it should be understood that although the present disclosure describes embodiments, not every embodiment is provided with a separate embodiment, and that this description is provided for clarity only, and that the disclosure is not limited to the embodiments described in detail below, and that the embodiments described in the examples may be combined as appropriate to form other embodiments that will be apparent to those skilled in the art.
Claims (7)
1. A configurable reconciliation document generation device, characterized in that: the system comprises a configuration editing module, a data reading module and a file generating module;
the configuration editing module is used for configuring information, and the configuration information comprises a configuration data source, a target file attribute, target file content and a data area;
the configuration data source is used for defining a data query range of each data source of each target file, wherein each target file is provided with a plurality of data sources, and associated data between a main data source and other data sources is defined;
the main editing area is divided into three areas, wherein the three areas are respectively used for editing a data source, a target file attribute and target file content, the main editing area of the target file content is displayed by adopting a graphical form, and field cells of the editing area are directly dragged from the data source to the editing area or are edited by a function editor;
configuring the data area to configure the value of each column of data, wherein part of columns are acquired through a data source, and part of columns are subjected to function calculation conversion based on actual conditions;
the data reading module assembles a related data source group based on the related data;
the file generation module is used for generating data and generating summary statistics;
the generated data are line-by-line read data source groups, the configuration of data columns is carried out based on the value of each column of data of the data area, if the data are directly obtained through the data sources, the values of the data sources are directly obtained according to paths, and if the data are converted through function calculation, the values are analyzed through corresponding function expressions;
when the data is generated, the function expression is adopted for analysis, AST abstract syntax tree is used for realizing the analysis of the function expression, the leaf nodes of the tree are data source values or constants, and a depth-first traversal algorithm is adopted for analyzing the leaf nodes upwards at one time;
and the generation summary statistics is to add a function expression according to the actual conditions of each column or row of the data source for summary statistics.
2. The configurable reconciliation document generation apparatus of claim 1, wherein: the object file attributes include defining an object file format, encoding, file name, and file storage information.
3. The configurable reconciliation document generation apparatus of claim 1, wherein: the configuration editing module is further used for configuring a header area, wherein the header area is configured into one or more rows of headers, and the header columns are in parallel or are assigned with a sequencing rule.
4. The configurable reconciliation document generation apparatus of claim 1, wherein: the configuration editing module is also used for configuring an summarized statistical region, and the summarized statistical region is positioned behind the header or behind the data region.
5. A configurable reconciliation document generation apparatus of claim 3, wherein: the file generation module is also used for generating a header, and generating header data according to the header area configured by the configuration editing module.
6. The configurable reconciliation document generation apparatus of claim 1, wherein: the configuration information is added into version control.
7. The configurable reconciliation document generation apparatus of claim 1, wherein: the function expression is defined as a format of funcName ([ arg1, arg2,.,. ArgN ]), the function comprises a function name and optional 0-N parameters, special symbols "," () "need to be translated, the function can be used in a nested manner, the function comprises constants, reference values, code table conversion, mathematical operation, summary statistics, financial formulas, logical operation, text time digital formatting, method call, and the function supports dynamic expansion and loading.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110726121.4A CN113591446B (en) | 2021-06-29 | 2021-06-29 | Configurational account checking file generating device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110726121.4A CN113591446B (en) | 2021-06-29 | 2021-06-29 | Configurational account checking file generating device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113591446A CN113591446A (en) | 2021-11-02 |
| CN113591446B true CN113591446B (en) | 2023-11-03 |
Family
ID=78245005
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110726121.4A Active CN113591446B (en) | 2021-06-29 | 2021-06-29 | Configurational account checking file generating device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113591446B (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243528A (en) * | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN105354236A (en) * | 2015-10-09 | 2016-02-24 | 上海瀚之友信息技术服务有限公司 | Reconciliation information generation method and system |
| CN108509392A (en) * | 2018-02-24 | 2018-09-07 | 深圳壹账通智能科技有限公司 | Multimachine structure account checking method, system, computer equipment and storage medium |
| CN109816501A (en) * | 2018-12-26 | 2019-05-28 | 天翼电子商务有限公司 | Intelligent reconciliation system, method and server |
| CN110245116A (en) * | 2019-06-06 | 2019-09-17 | 深圳前海微众银行股份有限公司 | Reconciliation data processing method, device, equipment and computer-readable storage medium |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN111143434A (en) * | 2019-12-19 | 2020-05-12 | 深圳壹账通智能科技有限公司 | Data intelligent verification method, device, equipment and storage medium |
| US10719492B1 (en) * | 2016-12-07 | 2020-07-21 | GrayMeta, Inc. | Automatic reconciliation and consolidation of disparate repositories |
| CN112035665A (en) * | 2020-08-31 | 2020-12-04 | 京东数字科技控股股份有限公司 | Account checking file generating and acquiring method, device, system and server |
| CN112269902A (en) * | 2020-11-10 | 2021-01-26 | 珠海市新德汇信息技术有限公司 | A data collection method for big data |
| CN112506493A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Table configuration method, device, equipment and medium based on vue |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
| CN112799671A (en) * | 2019-11-13 | 2021-05-14 | 北京配天技术有限公司 | Function analysis method and computer equipment thereof |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140351103A1 (en) * | 2013-05-22 | 2014-11-27 | Blackbaud Incorporated | Reconciliation system in managerial subsidiaries |
-
2021
- 2021-06-29 CN CN202110726121.4A patent/CN113591446B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243528A (en) * | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN105354236A (en) * | 2015-10-09 | 2016-02-24 | 上海瀚之友信息技术服务有限公司 | Reconciliation information generation method and system |
| US10719492B1 (en) * | 2016-12-07 | 2020-07-21 | GrayMeta, Inc. | Automatic reconciliation and consolidation of disparate repositories |
| CN108509392A (en) * | 2018-02-24 | 2018-09-07 | 深圳壹账通智能科技有限公司 | Multimachine structure account checking method, system, computer equipment and storage medium |
| CN109816501A (en) * | 2018-12-26 | 2019-05-28 | 天翼电子商务有限公司 | Intelligent reconciliation system, method and server |
| CN110245116A (en) * | 2019-06-06 | 2019-09-17 | 深圳前海微众银行股份有限公司 | Reconciliation data processing method, device, equipment and computer-readable storage medium |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN112799671A (en) * | 2019-11-13 | 2021-05-14 | 北京配天技术有限公司 | Function analysis method and computer equipment thereof |
| CN111143434A (en) * | 2019-12-19 | 2020-05-12 | 深圳壹账通智能科技有限公司 | Data intelligent verification method, device, equipment and storage medium |
| CN112035665A (en) * | 2020-08-31 | 2020-12-04 | 京东数字科技控股股份有限公司 | Account checking file generating and acquiring method, device, system and server |
| CN112506493A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Table configuration method, device, equipment and medium based on vue |
| CN112269902A (en) * | 2020-11-10 | 2021-01-26 | 珠海市新德汇信息技术有限公司 | A data collection method for big data |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113591446A (en) | 2021-11-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11714841B2 (en) | Systems and methods for processing a natural language query in data tables | |
| CN111209472B (en) | Method and system for railway accident fault correlation and accident fault cause analysis | |
| CN111144089B (en) | Method and equipment for checking difference between part list and model file of design software | |
| WO2003067471A1 (en) | Document knowledge management apparatus and method | |
| CN113761334A (en) | Visual recommendation method, device, equipment and storage medium | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN102890702A (en) | Internet forum-oriented opinion leader mining method | |
| US8321469B2 (en) | Systems and methods of profiling data for integration | |
| CN108280051A (en) | Detection method, device and the equipment of error character in a kind of text data | |
| CN111177227A (en) | A self-service analysis system for power data and a migration method for decision-making applications | |
| CN112101007A (en) | A method and system for extracting structured data from unstructured text data | |
| Zhu et al. | Chat2query: A zero-shot automatic exploratory data analysis system with large language models | |
| Alokla et al. | Customer relationship management: A review and classification | |
| CN111291547B (en) | Template generation method, device, equipment and medium | |
| Chen et al. | An intelligent government complaint prediction approach | |
| CN113591446B (en) | Configurational account checking file generating device | |
| Lin et al. | Twix: Automatically reconstructing structured data from templatized documents | |
| CN116126873B (en) | Data summarization method and device based on nonstandard data table and storage medium | |
| CN117611071A (en) | Data processing system and method | |
| Pena et al. | Finding polarized communities and tracking information diffusion on Twitter: a network approach on the Irish Abortion Referendum | |
| CN116796707A (en) | Document multi-format data filling and modularized automatic generation method | |
| Bednar et al. | Ontologies and knowledge graphs: A new way to represent and communicate values in technology design | |
| CN112214983A (en) | Data record duplicate checking method and system | |
| CN119150825B (en) | A method and system for constructing and displaying end-to-end report lineage in the entire data chain | |
| Gusić et al. | Using Text Mining to Extract Information from Students' Lab Assignments |
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 |