CN113312889A - Report processing method, device, terminal and storage medium - Google Patents
Report processing method, device, terminal and storage medium Download PDFInfo
- Publication number
- CN113312889A CN113312889A CN202110612150.8A CN202110612150A CN113312889A CN 113312889 A CN113312889 A CN 113312889A CN 202110612150 A CN202110612150 A CN 202110612150A CN 113312889 A CN113312889 A CN 113312889A
- Authority
- CN
- China
- Prior art keywords
- report
- target
- historical
- database
- option
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 16
- 238000000034 method Methods 0.000 claims abstract description 47
- 238000012545 processing Methods 0.000 claims abstract description 38
- 238000012216 screening Methods 0.000 claims abstract description 20
- 238000004590 computer program Methods 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 6
- 238000012856 packing Methods 0.000 claims description 4
- 238000012163 sequencing technique Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 230000004044 response Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 2
- 238000012549 training Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000000873 masking effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/22—Matching criteria, e.g. proximity measures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Artificial Intelligence (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Evolutionary Computation (AREA)
- Evolutionary Biology (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Bioinformatics & Computational Biology (AREA)
- Life Sciences & Earth Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application discloses a report processing method, a report processing device, a terminal and a storage medium, which belong to the technical field of data processing, wherein the method comprises the following steps: acquiring a target report, and calculating the similarity between the target report and each historical report in the database; screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database; the method comprises the steps of obtaining a historical operation set input aiming at a target historical report form from a database, generating an operation option set based on the historical operation set, responding to a target operation option triggering instruction aiming at the operation option set, and applying operation corresponding to a target operation option to the target report form. By implementing the method, the report can be processed by combining historical operation, and the processing efficiency in the report processing process is improved.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a method, an apparatus, a terminal, and a storage medium for processing a report.
Background
The report forms dynamically display data in forms, diagrams and other formats, can clearly display the data to users, facilitates communication among users, can be used for editing the report forms to process the data in the report forms, and with the increase of the use of the report forms, a large number of report forms need to be processed by the users, such as counting the data in the report forms, checking whether the data in the report forms are matched or not, changing the format of the report forms and the like.
Currently, in the process of processing the report forms, a user needs to browse each report form in detail, and a large amount of editing operations are performed on each report form, and the report forms can be processed if corresponding data is selected, a corresponding formula is input, drawing is performed, and the like. Obviously, the processing method has low processing efficiency on the report.
Disclosure of Invention
The embodiment of the application provides a report processing method, a report processing device, a terminal and a storage medium, which can process a report by combining historical operations and improve the processing efficiency in the report processing process.
In one aspect, an embodiment of the present application provides a report processing method, where the method includes:
acquiring a target report and calculating the similarity between the target report and each historical report in a database;
screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database;
acquiring a historical operation set input aiming at the target historical report form from the database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form;
generating an operation option set based on the historical operation set, wherein the operation option set comprises a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
and responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report.
In one aspect, an embodiment of the present application provides a report processing apparatus, where the apparatus includes:
the acquisition module is used for acquiring a target report;
the calculation module is used for calculating the similarity between the target report and each historical report in the database;
the screening module is used for screening the target historical report form from the database based on the similarity between the target report form and each historical report form in the database;
the acquisition module is further used for acquiring a historical operation set input aiming at the target historical report form from the database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form;
a generating module, configured to generate an operation option set based on the historical operation set, where the operation option set includes a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
and the application module is used for responding to a target operation option triggering instruction in the operation option set and applying the operation corresponding to the target operation option to the target report.
In one aspect, an embodiment of the present application provides a terminal, including a processor and a memory, where the memory is used to store a computer program, and the computer program includes program instructions, and is characterized in that the processor is configured to call the program instructions to execute the report processing method.
In one aspect, an embodiment of the present application provides a computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, where the computer program includes program instructions, and the program instructions, when executed by a processor, cause the processor to execute a report processing method.
In the embodiment of the application, the terminal acquires a target report and calculates the similarity between the target report and each historical report in the database; screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database; the method comprises the steps of obtaining a historical operation set input aiming at a target historical report form from a database, generating an operation option set based on the historical operation set, responding to a target operation option triggering instruction aiming at the operation option set, and applying operation corresponding to a target operation option to the target report form. By implementing the method, the similar report forms of the report forms to be processed can be found, and the report forms to be processed are processed by combining the historical operations aiming at the similar report forms, so that a user can quickly edit the report forms, and the processing efficiency in the report form processing process is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flowchart of a report processing method according to an embodiment of the present application;
FIG. 2 is a flowchart illustrating another report processing method according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a report processing apparatus according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a terminal according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The report processing method provided by the embodiment of the application is realized on a terminal, and the terminal comprises electronic equipment such as a smart phone, a tablet computer, a digital audio and video player, an electronic reader, a handheld game machine or vehicle-mounted electronic equipment.
Fig. 1 is a schematic flow chart of a report processing method in an embodiment of the present application, and as shown in fig. 1, the flow of the report processing method in the embodiment may include:
s101, acquiring a target report, and calculating the similarity between the target report and each historical report in the database.
In the implementation of the application, the target report may specifically include multiple rows and multiple columns of data, for example, if the target report is an excel-form data table, the terminal may obtain the target report input by the user, or obtain the target report sent by other devices, or obtain the target report from the database. Optionally, the target report may include one excel data table, or may also include a plurality of excel data tables. Further, after the terminal acquires the target report, the terminal calculates the similarity between the target report and each historical report in the database, wherein the database includes a plurality of historical reports, the historical report can be a report acquired historically, and for the historical reports, each user can also input operation to process the historical reports, such as inputting operation to calculate sum values, difference values and the like of some data in the report, or different data in the report is compared to verify whether the data table is accurate, or corresponding graphs are drawn based on the data in the report, and the historical reports and the operation input by the user can be correspondingly stored in the database.
In an implementation manner, the terminal may calculate the similarity between the target report and each historical report in the database by extracting data item fields under the target report to obtain a target data item field set, extracting data item fields under the historical report to obtain a historical data item field set, determining an intersection between the target data item field set and the historical data item field set, and determining a first number of the data item fields contained in the intersection; determining a union between the set of target data item fields and the set of historical data item fields, and determining a second number of data item fields contained in the union; and determining the ratio of the first quantity to the second quantity as the similarity between the target report and the historical report. The data item field under the target report comprises a table name, a row name and a column name of the target report; the data item fields under the historical report comprise the table name, the row name and the column name of the historical report; the row name may specifically be data in the first data column of each row in the table, the column name may specifically be data in the first data column of each column in the table, the intersection between the target data item field set and the historical data item field set, that is, the set of data item fields in the target data item field set and the historical data item field set, the union between the target data item field set and the historical data item field set, that is, the set of all data item fields in the target data item field set and the historical data item field set, for example, the table name in the target report is referred to as an XX table, the row name includes scores and ranks, the column name includes a language and a math, the table name in the historical report is referred to as an XX table, the row name includes scores and ranks, the column name includes a language and an english, and the intersection is determined as { XX score table, score, rank, and language }, and if the union set is { XX score table, score, ranking, Chinese, mathematics and English }, determining that the first quantity is 4, the second quantity is 6, and the similarity between the target report and the historical report is 66.7%. Optionally, the table names, the row names and the column names have different weights during calculation, and the method for calculating the similarity between the target report and each historical report in the database by the terminal may also be that a first similarity between the table name of the target report and the table name of the historical report, a second similarity between the row name of the target report and the row name of the historical report, and a third similarity between the column name of the target report and the column name of the historical report are calculated, the first similarity is weighted by the first weight to obtain the first weighted similarity, the second similarity is weighted by the second weight to obtain the second weighted similarity, the third similarity is weighted by the third weight to obtain the third weighted similarity, the first weighted similarity, the second weighted similarity and the third weighted similarity are summed to obtain the similarity between the target report and the historical report, the first weight, the second weight and the third weight can be preset by research personnel, the first similarity is the ratio between the intersection and the union of the names of the tables, the second similarity is the ratio between the intersection and the union of the names of the rows, and the third similarity is the ratio between the intersection and the union of the names of the columns.
In an implementation mode, the terminal calculates the similarity between the target report and the historical report by calling a comparison model to process the target report and the historical report to obtain a first report similarity between the target report and the historical report; performing mask processing on the digital data items in the target report to obtain a target mask report, and performing mask processing on the digital data items in the historical report to obtain a historical mask report; calling the comparison model to process the target mask report and the historical mask report to obtain a second report similarity between the target mask report and the historical mask report; and calculating the similarity of the first report and the second report to obtain the similarity between the target report and the historical report. The masking process is to blank the digital data in the tables, and the similarity between the mask reports is compared, namely the similarity of the names and the similarity of the structures between the reports are compared. The comparison model is specifically used for comparing the similarity between reports, the specific training mode of the comparison model may be to obtain a sample report set, the sample report set includes a plurality of sample report combinations, each sample report combination includes two sample reports and a preset similarity, and the preset similarity is the similarity between reports in a preset combination. Training the initial comparison model based on the sample report set so as to update parameters in the initial comparison model, and determining the initial comparison model after parameter update as the comparison model if the initial comparison model after parameter update meets preset conditions, wherein the preset conditions can be that the prediction success rate of the initial comparison model on the similarity of the sample report set is higher than the preset success rate, and the prediction success is determined when the prediction similarity of the initial comparison model on the sample combination output is matched with the preset similarity.
S102, screening the target historical report form from the database based on the similarity between the target report form and each historical report form in the database.
In the embodiment of the application, after the terminal determines the similarity between the target report and each historical report in the database, the target historical report is screened from the database based on the similarity between the target report and each historical report in the database, the target historical report can be a report with the highest similarity with the target report, or a plurality of reports with N bits before the similarity ranking with the target report, and N is a positive integer.
In one implementation mode, the specific mode of screening the target historical report form from the database by the terminal is that the terminal sorts all the historical report forms in the database according to the sequence of similarity between the terminal and the target report form from high to low; and if the similarity between the first-ranked historical report and the target report is greater than the preset similarity, determining the first-ranked historical report as the target historical report. Optionally, if the similarity between the first-ranked historical report and the target report is smaller than the preset similarity, the terminal determines that there is no target historical report in the database, and ends the process, or, when there are N historical reports whose similarities with the target report are larger than the preset similarity in the database, the N historical reports are all used as the target historical reports.
S103, acquiring a historical operation set input aiming at the target historical report form from the database.
In the embodiment of the application, after the terminal determines the target historical report, a historical operation set input for the target historical report is acquired from a database, wherein the historical operation set comprises a plurality of operations input for the target historical report, the operations can be specifically input by a user using the terminal and comprise selection operations of data in a table, table scaling operations, operation operations of data in the table and the like, each report displayed in the terminal can record the operations input by the user on the report to obtain an operation set, and the operation set and the report are correspondingly stored in the database.
It should be noted that the target history report may be a history report, and the terminal may obtain a plurality of operations input by the user for the history report, and obtain the history operation set based on the plurality of operations. Or the target historical report may also be a set of N historical reports, and the terminal may acquire an operation input for each historical report in the N historical reports, construct an operation group based on the operation input for a single historical report, obtain N operation groups, and construct a historical operation set input for the target historical report based on the N operation groups. Specifically, the history operation set may record a position corresponding to an operation in the target history report, for example, a selection operation is input to data in the 5 th to 8 th columns of the 3 rd row, or an operation type and an operation position corresponding to an operation input to data in the target history report are recorded in the history operation set, for example, a summation operation is input to data in the 5 th to 10 th columns of the 5 th row, that is, the operation position is data in the 5 th to 10 th columns of the 5 th row, and the operation type is a summation operation, or the operation type may also be a multiplication operation, a division operation, a comparison size operation, a drawing operation, or the like.
And S104, generating an operation option set based on the historical operation set.
In the embodiment of the application, after the terminal acquires the historical operation set, an operation option set is generated based on the historical operation set, the operation option set includes a plurality of operation options, each operation option corresponds to an operation in the historical operation set and is used for realizing a corresponding operation, for example, if the historical operation set includes a selection operation for inputting data in rows 5, columns 3 to 10 in the target historical report, an operation option may be generated and used for selecting data in rows 5, columns 3 to 10 in the target report. Optionally, the target historical report may be a set of N historical reports, and the terminal may acquire an operation input for each report in the set, construct a historical operation set, and further generate a corresponding operation option based on each operation in the historical operation set. Each operation option can realize the same operation in the target report as in the historical report.
In one implementation manner, the history operation set comprises data selection operation and data operation input for the target history report, and the specific manner of generating the operation option set by the terminal based on the history operation set may be that a target position of the selected data in the data selection operation in the target history report is obtained, where the target position includes the number of rows and the number of columns of the selected data; generating a first operation option according to the target position, wherein the first operation option is used for selecting data at the target position in the target report; acquiring an operation type corresponding to the data operation, and generating a second operation option according to the operation type, wherein the second operation option is used for executing the operation corresponding to the operation type on the data at the target position in the target report; and constructing an operation option set based on the first operation option and the second operation option. For example, if the target position of the data selection operation in the target historical report is row 3, column 5 to column 8, the first operation option is used to select the data in row 3, column 5 to column 8 in the target report. The data operation is to perform summation operation on data in the 5 th row to the 5 th column in the target historical report, and the second operation option is used to perform summation operation on data in the 5 th row to the 10 th column in the target report. The operation type specifically includes at least one of a summation operation, a multiplication operation, a division operation, a subtraction operation, a calculus operation, and a drawing operation. Optionally, the history operation set further includes a data comparison operation input for the target history report, where the data comparison operation is used to compare data at a first position in the target history data table with data at a second position, and compare whether the data are consistent, for example, if the history operation is used to compare whether data at a 3 rd row and a 4 th column in the target history report are the same as data at a 5 th row and a 6 th column in the target history report, the terminal may generate a third operation option based on the above operation, and the third operation option is used to compare data at a 3 rd row and a 4 th column in the target report with data at a 5 th row and a 6 th column.
In one implementation manner, the history operation set comprises data selection operation, data operation and data comparison operation input aiming at the target history report, and the specific manner of generating the operation option set by the terminal based on the history operation set can be that a keyword corresponding to selected data in the data selection operation is acquired, wherein the keyword comprises at least one of a row name of a row where the selected data is located, a column name of a column where the selected data is located, and a data name of a data item where the selected data is located; generating a fourth operation option according to the keywords, wherein the fourth operation option is used for selecting data with the same keywords in the target report; acquiring an operation type corresponding to the data operation, and generating a fifth operation option according to the operation type, wherein the fifth operation option is used for executing the operation corresponding to the operation type on the data with the same keyword in the target report; for example, data in the 3 rd row is summed, or data in the 5 th column is plotted, or the terminal obtains a keyword corresponding to the compared data in the data comparison operation, and generates a sixth operation option according to the keyword in the comparison operation, where the sixth operation option is used to compare data in the target report with the same keyword. For example, if the history operation set includes an operation of comparing data in the target history report with the line name of 3-month sales and the line name of 4-month sales, the terminal may generate an operation option for comparing data in the target report with the line name of 3-month sales and the line name of 4-month sales.
Further, after the terminal generates the operation option set based on the historical operation set, the operation options may be directly displayed at a designated position on the display interface for the user to select, or the terminal may also display the operation options after detecting a designated operation input by the user, and after detecting the click operation by the terminal if the designated operation is a click operation for a preset button, the terminal displays the generated operation option set, and in the display process, functions corresponding to each option may be specifically described in the options, such as displaying data for selecting a third row, or displaying that data in the third row is compared with data in a fourth row. After the user selects the operation options, the function corresponding to the operation options can be realized in the target report.
And S105, responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report.
In the embodiment of the application, after the terminal generates the operation option set, the terminal can respond to a target operation option triggering instruction in the operation option set, and apply the operation corresponding to the target operation option to the target report.
In an implementation manner, the target operation option is an option selected by a user in the operation option set, that is, after the terminal generates the operation option set, the operation option set is displayed in the display interface, and a selection operation for any operation option in the operation option set is detected, when a corresponding operation is detected, a trigger instruction for the target operation option is generated, and in response to the trigger instruction, an operation corresponding to the target operation option is applied to the target report, for example, the target operation option is that third row data is compared with fourth row data, and then the terminal compares the third row data with the fourth row data in the target report, and displays the comparison result after the comparison result is obtained. Optionally, the target operation option includes a first operation option, where the first operation option is used to select data at a target position in the target report; after the terminal generates a trigger instruction for the target operation option, responding to the trigger instruction, acquiring a target position indicated by the target operation option, and determining data at the target position in the target report; and selecting the data at the target position in the target report. Or the target operation options comprise second operation options, and the second operation options are used for executing the operation corresponding to the operation type on the data at the target position in the target report; the terminal responds to the trigger instruction, obtains the target position indicated by the target operation option and determines the data at the target position in the target report; and executing the operation corresponding to the operation type on the data at the target position in the target report, and displaying the operation result after obtaining the operation result. Or the target operation options comprise third operation options which are used for comparing the data at the first position with the data at the second position in the target historical data table, and the terminal responds to the trigger instruction, acquires the first position and the second position indicated by the target operation options and determines the data at the first position and the second position in the target report; and comparing the data at the first position and the data at the second position in the target report to obtain a comparison result, and displaying the comparison result.
In an implementation manner, target operation options are all options in an operation option set, a target operation option trigger instruction in the operation option set may specifically be a quick editing mode start instruction, the quick editing mode start instruction is used for quickly editing a table, specifically, a quick editing mode may be started after a user inputs an execution operation, in the quick editing mode, a terminal may automatically trigger all operations in the operation option set, that is, operations corresponding to each option in the operation option set are applied to a target report, and an operation result corresponding to each operation is displayed in a display interface in a thumbnail form, and a user may click any one thumbnail to obtain a result corresponding to the corresponding operation, so that convenience in report processing in a process of editing a report is improved by the above manner.
Further, after the terminal applies the operation corresponding to the target operation option to the target report, a specified operation set input for the target report can be received; processing the target report based on the designated operation set, and correspondingly storing the target report and the designated operation set in a database; and the terminal checks whether the memory occupancy rate in the database is higher than the preset occupancy rate, and if the memory occupancy rate in the database is higher than the preset occupancy rate, the target historical report and the historical operation set are cleared from the database so as to update the data stored in the database. The terminal can correspondingly store the target report and the designated operation set in the database, so that the contents stored in the database can be automatically updated, whether the load of the database is high is further checked, if yes, part of data is removed, the target historical report and the historical operation set can be removed, and the data updating efficiency is improved.
In the embodiment of the application, the terminal acquires a target report and calculates the similarity between the target report and each historical report in the database; screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database; acquiring a historical operation set input aiming at a target historical report form from a database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form; generating an operation option set based on the historical operation set, wherein the operation option set comprises a plurality of operation options, and each operation option corresponds to an operation in the historical operation set; and responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report. By the method, the efficiency of report processing can be improved.
Fig. 2 is a schematic flow chart of another report processing method in the embodiment of the present application, and as shown in fig. 2, the flow of the report processing method in the embodiment may include:
s201, acquiring a target report, and calculating the similarity between the target report and each historical report in the database.
In the implementation of the application, the target report may specifically include multiple rows and multiple columns of data, for example, if the target report is a data table in an excel form, the terminal may obtain the target report input by the user, or receive the target report sent by other devices, and optionally, the target report may include one excel data table, or may also include multiple excel data tables. Further, after the terminal acquires the target report, similarity between the target report and each historical report in the database is calculated, wherein the database includes a plurality of historical reports, the historical report can be a report acquired by history, and for the historical reports, each user can also input operation to process the historical reports, such as input operation to calculate sum, difference and the like of some data in the report, or different data in the report are compared, whether the data table is accurate or not is verified, and the historical reports and the operation input by the user can be correspondingly stored in the database; or reports from the same batch as the target report, reports with the same name, etc. Through the screening process, the calculated amount of the similarity can be reduced, and the calculation efficiency is improved.
S202, screening the target historical report form from the database based on the similarity between the target report form and each historical report form in the database.
In the embodiment of the application, after the terminal determines the similarity between the target report and each historical report in the database, the target historical report is screened from the database based on the similarity between the target report and each historical report in the database, the target historical report can be the report with the highest similarity with the target report, or the report with the highest similarity in the reports having an association relationship with the target report, or a plurality of reports with N bits before the similarity ranking with the target report, and N is a positive integer.
S203, acquiring a history operation set input aiming at the target history report form from the database.
In the embodiment of the application, after the terminal determines the target historical report, a historical operation set input for the target historical report is acquired from a database, wherein the historical operation set comprises a plurality of operations input for the target historical report, the operations can be specifically input by a user using the terminal and comprise selection operations of data in a table, table scaling operations, operation operations of data in the table, drawing operations and the like, each report displayed in the terminal can record the operations input by the user on the report to obtain an operation set, and the operation set and the report are correspondingly stored in the database.
And S204, generating an operation option set based on the historical operation set.
In the embodiment of the application, after the terminal acquires the historical operation set, the operation option set is generated based on the historical operation set, the operation option set comprises a plurality of operation options, each operation option corresponds to an operation in the historical operation set and is used for realizing corresponding operation, if a user inputs a 3 rd row data-based histogram drawing operation in the historical report, the terminal can generate a histogram drawing option which is used for drawing a histogram based on the data in the third row in the target report, and the terminal can display the option in a display page where the target report is located. Or the history operation set comprises a chart amplifying operation input aiming at the target history report, and the operation amplifies the target history report to a display ratio of 200%, the terminal can generate a report amplifying operation option based on the operation, wherein the report amplifying operation option is used for amplifying the target report to a ratio of 200%, and the terminal constructs an operation option set based on the operation option.
S205, responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report.
In the embodiment of the application, after the terminal generates the operation option set, the terminal can respond to a target operation option triggering instruction in the operation option set, and apply the operation corresponding to the target operation option to the target report. The trigger instruction may be generated by an operation input by a user, and if the user clicks a target operation option in the display page, the trigger instruction for the target operation option is generated, or the target operation option is all operation options in the operation option set, and the trigger instruction may be automatically generated in a fast editing mode, so as to implement automatic processing of the report.
And S206, receiving feedback information input aiming at the operation option set.
In the embodiment of the application, after the terminal applies the operation corresponding to the target operation option to the target report, feedback information input for the operation option set may also be obtained, where the feedback information may be feedback score, and the feedback score may be input by the target user, or the scoring device determines, based on the use information of the target user for the operation option set, that the use information includes comprehensive determinations such as use frequency and use success rate, and if the use frequency is higher and the use success rate is higher, the feedback score is higher. Or the feedback information is evaluation and suggestion and the like of the operation option set input by the user.
And S207, if the feedback information indicates that the operation option set meets the preset conditions, broadcasting the target report and the operation option set in the block chain, so that each node in the block chain performs consensus check on the target report and the operation option set.
In the embodiment of the application, after the terminal receives the feedback information, whether the operation option set in the feedback information meets the preset condition is detected, wherein if the feedback score is larger than the preset score, it is determined that the user is satisfied with the operation option set, or when the feedback information is detected to contain the preset keyword (if satisfied), it is determined that the operation option set meets the preset condition. The terminal can broadcast the target report and the operation option set in the block chain, so that each node in the block chain performs consensus check on the target report and the operation option set. The consensus number may be preset, and when the number of nodes passing the consensus check is greater than the consensus number, it is determined that the consensus check passes. Or, a consensus weight may be preset, and each node may have a different weight, and when the weight of the result of the consensus check is greater than the preset consensus weight, it is determined that the check passes.
And S208, if the result that the consensus check returned by each node in the block chain passes is received, packing the target report and the operation option set into a block, and uploading the block to the block chain.
In the embodiment of the application, if the terminal determines that the consensus verification result indicates that the verification passes, it is determined that the process of interacting with the user is successful, the terminal can pack the target report and the operation option set into a block, upload the block into a block chain, store the target report and the operation option set, and subsequently, when a reference report which is the same as or similar to the target report needs to be processed, directly acquire the operation option set corresponding to the target report from the block chain, and apply the operation corresponding to the operation option set to the reference report.
In the embodiment of the application, the terminal acquires a target report and calculates the similarity between the target report and each historical report in the database; screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database; the method comprises the steps of obtaining a historical operation set input aiming at a target historical report form from a database, generating an operation option set based on the historical operation set, responding to a target operation option triggering instruction aiming at the operation option set, and applying operation corresponding to a target operation option to the target report form. By implementing the method, the similar report forms of the report forms to be processed can be found, and the report forms to be processed are processed by combining the historical operations aiming at the similar report forms, so that a user can quickly edit the report forms, and the processing efficiency in the report form processing process is improved. Furthermore, the target report and the operation option set are stored in the block chain, so that the safe storage of the target report and the operation option set can be ensured, and the operation option set in the block chain is called to realize convenient processing when a reference report which is the same as or similar to the target report is processed subsequently.
The report processing apparatus provided in the embodiment of the present application will be described in detail below with reference to fig. 3. It should be noted that the report processing apparatus shown in fig. 3 is used for executing the method according to the embodiment shown in fig. 1-2 of the present invention, and for convenience of description, only the portion related to the embodiment of the present application is shown, and specific technical details are not disclosed, and reference is made to the embodiment shown in fig. 1-2 of the present invention.
Referring to fig. 3, which is a schematic structural diagram of a report processing apparatus provided by the present invention, the report processing apparatus 30 may include: the system comprises an acquisition module 301, a calculation module 302, a screening module 303, a generation module 304 and an application module 305.
The acquisition module 301 is used for acquiring a target report;
a calculating module 302, configured to calculate similarity between the target report and each historical report in the database;
the screening module 303 is configured to screen a target historical report from the database based on the similarity between the target report and each historical report in the database;
an obtaining module 301, configured to obtain, from the database, a historical operation set input for the target historical report, where the historical operation set includes a plurality of operations input for the target historical report;
a generating module 304, configured to generate an operation option set based on the historical operation set, where the operation option set includes a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
the application module 305 is configured to, in response to a target operation option triggering instruction in the operation option set, apply an operation corresponding to the target operation option to the target report.
In one implementation, the calculating module 302 is specifically configured to:
extracting data item fields under the target report to obtain a target data item field set, wherein the data item fields under the target report comprise a table name, a row name and a column name of the target report;
extracting data item fields under the historical report to obtain a historical data item field set, wherein the data item fields under the historical report comprise the table name, the row name and the column name of the historical report;
determining an intersection between the set of target data item fields and the set of historical data item fields, and determining a first number of data item fields contained in the intersection;
determining a union between the set of target data item fields and the set of historical data item fields, and determining a second number of data item fields contained in the union;
determining a ratio between the first quantity and the second quantity as a similarity between the target report and the historical report.
In one implementation, the screening module 303 is specifically configured to:
sequencing each historical report in the database according to the sequence of the similarity between the historical report and the target report from high to low;
and acquiring a first-order historical report, and determining the first-order historical report as a target historical report if the similarity between the first-order historical report and the target report is greater than a preset similarity.
In an implementation manner, the history operation set includes a data selection operation and a data operation input for the target history report, and the generating module 304 is specifically configured to:
acquiring a target position of the selected data in the data selection operation in the target historical report, wherein the target position comprises the row number and the column number of the selected data;
generating a first operation option according to the target position, wherein the first operation option is used for selecting data at the target position in the target report;
acquiring an operation type corresponding to the data operation, and generating a second operation option according to the operation type, wherein the second operation option is used for executing the operation corresponding to the operation type on the data at the target position in the target report;
constructing a set of operational options based on the first operational option and the second operational option.
In one implementation, the application module 305 is specifically configured to:
acquiring a target position indicated by the target operation option, and determining data at the target position in the target report;
and selecting the data at the target position in the target report.
In one implementation, the application module 305 is further configured to:
receiving a specified operation set input aiming at the target report;
processing the target report based on the designated operation set, and correspondingly storing the target report and the designated operation in the database;
and if the memory occupancy rate in the database is higher than the preset occupancy rate, clearing the target historical report and the historical operation set from the database so as to update the data stored in the database.
In one implementation, the application module 305 is further configured to:
receiving feedback information input for the operation option set;
if the feedback information indicates that the operation option set meets a preset condition, broadcasting the target report and the operation option set in a block chain, so that each node in the block chain performs consensus check on the target report and the operation option set;
and if the result that the consensus check returned by each node in the block chain passes is received, packing the target report and the operation option set into a block, and uploading the block to the block chain.
In the embodiment of the application, the obtaining module 301 obtains a target report, and the calculating module 302 calculates the similarity between the target report and each historical report in the database; the screening module 303 screens out a target historical report from the database based on the similarity between the target report and each historical report in the database; the obtaining module 301 obtains a historical operation set input for the target historical report from the database, where the historical operation set includes a plurality of operations input for the target historical report; the generation module 304 generates an operation option set based on the historical operation set, and the application module 305 applies an operation corresponding to a target operation option in the target report in response to a target operation option trigger instruction in the operation option set. By implementing the method, the report can be processed by combining historical operation, and the processing efficiency in the report processing process is improved.
Please refer to fig. 4, which provides a schematic structural diagram of a terminal according to an embodiment of the present application. As shown in fig. 4, the terminal includes: at least one processor 401, input devices 403, output devices 404, memory 405, at least one communication bus 402. Wherein a communication bus 402 is used to enable connective communication between these components. The input device 403 may be a control panel or a microphone, and the output device 404 may be a display screen. The memory 405 may be a high-speed RAM memory or a non-volatile memory (non-volatile memory), such as at least one disk memory. The memory 405 may alternatively be at least one storage device located remotely from the aforementioned processor 401. Wherein the processor 401 may be combined with the apparatus described in fig. 3, the memory 405 stores a set of program codes, and the processor 401, the input device 403, and the output device 404 call the program codes stored in the memory 405 to perform the following operations:
the processor 401 is configured to obtain a target report and calculate similarity between the target report and each historical report in the database;
the processor 401 is configured to screen out a target historical report from the database based on the similarity between the target report and each historical report in the database;
a processor 401, configured to obtain, from the database, a historical operation set input for the target historical report, where the historical operation set includes a plurality of operations input for the target historical report;
a processor 401, configured to generate an operation option set based on the historical operation set, where the operation option set includes a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
the processor 401 is configured to apply, in response to a target operation option triggering instruction in the operation option set, an operation corresponding to the target operation option to the target report.
In one implementation, the processor 401 is specifically configured to:
extracting data item fields under the target report to obtain a target data item field set, wherein the data item fields under the target report comprise a table name, a row name and a column name of the target report;
extracting data item fields under the historical report to obtain a historical data item field set, wherein the data item fields under the historical report comprise the table name, the row name and the column name of the historical report;
determining an intersection between the set of target data item fields and the set of historical data item fields, and determining a first number of data item fields contained in the intersection;
determining a union between the set of target data item fields and the set of historical data item fields, and determining a second number of data item fields contained in the union;
determining a ratio between the first quantity and the second quantity as a similarity between the target report and the historical report.
In one implementation, the processor 401 is specifically configured to:
sequencing each historical report in the database according to the sequence of the similarity between the historical report and the target report from high to low;
and acquiring a first-order historical report, and determining the first-order historical report as a target historical report if the similarity between the first-order historical report and the target report is greater than a preset similarity.
In one implementation, the processor 401 is specifically configured to:
acquiring a target position of the selected data in the data selection operation in the target historical report, wherein the target position comprises the row number and the column number of the selected data;
generating a first operation option according to the target position, wherein the first operation option is used for selecting data at the target position in the target report;
acquiring an operation type corresponding to the data operation, and generating a second operation option according to the operation type, wherein the second operation option is used for executing the operation corresponding to the operation type on the data at the target position in the target report;
constructing a set of operational options based on the first operational option and the second operational option.
In one implementation, the processor 401 is specifically configured to:
acquiring a target position indicated by the target operation option, and determining data at the target position in the target report;
and selecting the data at the target position in the target report.
In one implementation, the processor 401 is specifically configured to:
receiving a specified operation set input aiming at the target report;
processing the target report based on the specified operation set, and correspondingly storing the target report and the specified operation set in the database;
and if the memory occupancy rate in the database is higher than the preset occupancy rate, clearing the target historical report and the historical operation set from the database so as to update the data stored in the database.
In one implementation, the processor 401 is specifically configured to:
receiving feedback information input for the operation option set;
if the feedback information indicates that the operation option set meets a preset condition, broadcasting the target report and the operation option set in a block chain, so that each node in the block chain performs consensus check on the target report and the operation option set;
and if the result that the consensus check returned by each node in the block chain passes is received, packing the target report and the operation option set into a block, and uploading the block to the block chain.
In the embodiment of the application, the processor 401 obtains a target report and calculates the similarity between the target report and each historical report in the database; screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database; acquiring a historical operation set input aiming at the target historical report form from the database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form; generating an operation option set based on the historical operation set, wherein the operation option set comprises a plurality of operation options, and each operation option corresponds to an operation in the historical operation set; and responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report. By implementing the method, the report can be processed by combining historical operation, and the processing efficiency in the report processing process is improved.
The modules described in the embodiments of the present application may be implemented by a general-purpose Integrated Circuit, such as a CPU (central Processing Unit), or an ASIC (application Specific Integrated Circuit).
It should be understood that, in the embodiment of the present application, the Processor 401 may be a Central Processing Unit (CPU), and the Processor may also be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The bus 402 may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended ISA (EISA) bus, or the like, and the bus 402 may be divided into an address bus, a data bus, a control bus, and the like, where fig. 4 only shows one thick line for convenience of illustration, but does not show only one bus or one type of bus.
It will be understood by those skilled in the art that all or part of the processes of the methods of the above embodiments may be implemented by a computer program, which may be stored in a computer storage medium and may include the processes of the embodiments of the methods described above when executed. The computer storage medium may be a magnetic disk, an optical disk, a Read-only Memory (ROM), a Random Access Memory (RAM), or the like.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (10)
1. A report processing method is characterized by comprising the following steps:
acquiring a target report and calculating the similarity between the target report and each historical report in a database;
screening a target historical report form from the database based on the similarity between the target report form and each historical report form in the database;
acquiring a historical operation set input aiming at the target historical report form from the database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form;
generating an operation option set based on the historical operation set, wherein the operation option set comprises a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
and responding to a target operation option triggering instruction in the operation option set, and applying the operation corresponding to the target operation option to the target report.
2. The method of claim 1, wherein the calculating the similarity between the target report and any historical report in the database comprises:
extracting data item fields under the target report to obtain a target data item field set, wherein the data item fields under the target report comprise a table name, a row name and a column name of the target report;
extracting data item fields under the historical report to obtain a historical data item field set, wherein the data item fields under the historical report comprise the table name, the row name and the column name of the historical report;
determining an intersection between the set of target data item fields and the set of historical data item fields, and determining a first number of data item fields contained in the intersection;
determining a union between the set of target data item fields and the set of historical data item fields, and determining a second number of data item fields contained in the union;
determining a ratio between the first quantity and the second quantity as a similarity between the target report and the historical report.
3. The method of claim 1, wherein the screening out the target historical report from the database based on the similarity between the target report and each historical report in the database comprises:
sequencing each historical report in the database according to the sequence of the similarity between the historical report and the target report from high to low;
and acquiring a first-order historical report, and determining the first-order historical report as a target historical report if the similarity between the first-order historical report and the target report is greater than a preset similarity.
4. The method of claim 1, wherein the set of historical operations includes data selection operations and data calculation operations entered for the target historical report, and wherein generating the set of operation options based on the set of historical operations comprises:
acquiring a target position of the selected data in the data selection operation in the target historical report, wherein the target position comprises the row number and the column number of the selected data;
generating a first operation option according to the target position, wherein the first operation option is used for selecting data at the target position in the target report;
acquiring an operation type corresponding to the data operation, and generating a second operation option according to the operation type, wherein the second operation option is used for executing the operation corresponding to the operation type on the data at the target position in the target report;
constructing a set of operational options based on the first operational option and the second operational option.
5. The method according to claim 4, wherein the target operation option comprises the first operation option, and the applying the operation corresponding to the target operation option to the target report comprises:
acquiring a target position indicated by the target operation option, and determining data at the target position in the target report;
and selecting the data at the target position in the target report.
6. The method according to claim 1, wherein after the operation corresponding to the target operation option is applied to the target report, the method further comprises:
receiving a specified operation set input aiming at the target report;
processing the target report based on the specified operation set, and correspondingly storing the target report and the specified operation set in the database;
and if the memory occupancy rate in the database is higher than the preset occupancy rate, clearing the target historical report and the historical operation set from the database so as to update the data stored in the database.
7. The method of claim 1, wherein after generating the set of operation options based on the set of historical operations, the method further comprises:
receiving feedback information input for the operation option set;
if the feedback information indicates that the operation option set meets a preset condition, broadcasting the target report and the operation option set in a block chain, so that each node in the block chain performs consensus check on the target report and the operation option set;
and if the result that the consensus check returned by each node in the block chain passes is received, packing the target report and the operation option set into a block, and uploading the block to the block chain.
8. A report processing apparatus, characterized in that the apparatus comprises:
the acquisition module is used for acquiring a target report;
the calculation module is used for calculating the similarity between the target report and each historical report in the database;
the screening module is used for screening the target historical report form from the database based on the similarity between the target report form and each historical report form in the database;
the acquisition module is further used for acquiring a historical operation set input aiming at the target historical report form from the database, wherein the historical operation set comprises a plurality of operations input aiming at the target historical report form;
a generating module, configured to generate an operation option set based on the historical operation set, where the operation option set includes a plurality of operation options, and each operation option corresponds to an operation in the historical operation set;
and the application module is used for responding to a target operation option triggering instruction in the operation option set and applying the operation corresponding to the target operation option to the target report.
9. A terminal, comprising a processor and a memory, wherein the memory is configured to store a computer program comprising program instructions, wherein the processor is configured to invoke the program instructions to perform the method of any of claims 1-7.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program comprising program instructions that, when executed by a processor, cause the processor to carry out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110612150.8A CN113312889B (en) | 2021-06-01 | 2021-06-01 | Report processing method, device, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110612150.8A CN113312889B (en) | 2021-06-01 | 2021-06-01 | Report processing method, device, terminal and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113312889A true CN113312889A (en) | 2021-08-27 |
| CN113312889B CN113312889B (en) | 2023-11-03 |
Family
ID=77377129
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110612150.8A Active CN113312889B (en) | 2021-06-01 | 2021-06-01 | Report processing method, device, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113312889B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117216146A (en) * | 2023-10-10 | 2023-12-12 | 广州红海云计算股份有限公司 | Data analysis and display system based on artificial intelligence |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017201976A1 (en) * | 2016-05-24 | 2017-11-30 | 华为技术有限公司 | Topic recommending method and device |
| CN108921975A (en) * | 2018-07-05 | 2018-11-30 | 北京智行者科技有限公司 | Logistic car running data classification processing method |
| CN109597974A (en) * | 2017-09-30 | 2019-04-09 | 北京国双科技有限公司 | Report generation method and device |
| CN109597734A (en) * | 2017-09-30 | 2019-04-09 | 北京国双科技有限公司 | The monitoring method and device of report operation duration |
| WO2020065032A1 (en) * | 2018-09-29 | 2020-04-02 | Siemens Aktiengesellschaft | Information providing method and system |
-
2021
- 2021-06-01 CN CN202110612150.8A patent/CN113312889B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017201976A1 (en) * | 2016-05-24 | 2017-11-30 | 华为技术有限公司 | Topic recommending method and device |
| CN109597974A (en) * | 2017-09-30 | 2019-04-09 | 北京国双科技有限公司 | Report generation method and device |
| CN109597734A (en) * | 2017-09-30 | 2019-04-09 | 北京国双科技有限公司 | The monitoring method and device of report operation duration |
| CN108921975A (en) * | 2018-07-05 | 2018-11-30 | 北京智行者科技有限公司 | Logistic car running data classification processing method |
| WO2020065032A1 (en) * | 2018-09-29 | 2020-04-02 | Siemens Aktiengesellschaft | Information providing method and system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117216146A (en) * | 2023-10-10 | 2023-12-12 | 广州红海云计算股份有限公司 | Data analysis and display system based on artificial intelligence |
| CN117216146B (en) * | 2023-10-10 | 2024-05-14 | 广州红海云计算股份有限公司 | Data analysis and display system based on artificial intelligence |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113312889B (en) | 2023-11-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105893390B (en) | Application processing method and electronic equipment | |
| CN107526846B (en) | Method, device, server and medium for generating and sorting channel sorting model | |
| CN109597874B (en) | Information recommendation method, device and server | |
| CN109359188B (en) | Component arranging method and system | |
| CN112434188B (en) | Data integration method, device and storage medium of heterogeneous database | |
| CN112650921B (en) | Object recommendation method, device, equipment and storage medium | |
| CN112632257A (en) | Question processing method and device based on semantic matching, terminal and storage medium | |
| CN112307365A (en) | Information display method and device, electronic equipment and storage medium | |
| CN113127621A (en) | Dialogue module pushing method, device, equipment and storage medium | |
| CN113312889A (en) | Report processing method, device, terminal and storage medium | |
| CN109726826B (en) | Training method and device for random forest, storage medium and electronic equipment | |
| CN112487159B (en) | Search method, search device, and computer-readable storage medium | |
| CN108959237B (en) | Text classification method, device, medium and equipment | |
| CN110796178A (en) | Decision model training method, sample feature selection method, device and electronic equipment | |
| CN108170664B (en) | Key word expansion method and device based on key words | |
| CN110019750A (en) | The method and apparatus that more than two received text problems are presented | |
| CN109213937B (en) | Intelligent search method and device | |
| CN113515701A (en) | Information recommendation method and device | |
| CN109101485B (en) | Information processing method and device, electronic equipment and computer storage medium | |
| CN111753183A (en) | Search result processing method and device | |
| CN114610793B (en) | Interaction method, system and storage medium based on big data statistical analysis | |
| CN110807118A (en) | Image comment generation method and device and electronic equipment | |
| CN111491198A (en) | Small video searching method and device | |
| CN115334362B (en) | Barrage problem processing method, barrage problem processing device, barrage problem storage medium, barrage problem service equipment and barrage problem service system | |
| CN112148941B (en) | Information prompting method, device and terminal equipment |
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 |