CN114637778A

CN114637778A - Visual data acceptance method and system

Info

Publication number: CN114637778A
Application number: CN202210152557.1A
Authority: CN
Inventors: 李望
Original assignee: Shanghai Shanshu Network Technology Co ltd; Shanshu Science And Technology Suzhou Co ltd; Shanshu Science And Technology Beijing Co ltd; Shenzhen Shanzhi Technology Co Ltd
Current assignee: Shanghai Shanshu Network Technology Co ltd; Shanshu Science And Technology Suzhou Co ltd; Shanshu Science And Technology Beijing Co ltd; Shenzhen Shanzhi Technology Co Ltd
Priority date: 2022-02-18
Filing date: 2022-02-18
Publication date: 2022-06-17

Abstract

The invention discloses a visual data acceptance method and a visual data acceptance system, wherein the method comprises the following steps: calling form data in a database through operation controls configured in the form operation object; generating a report to be checked according to the form data; integrating the report to be checked and the system report to the same form page; the system report is used for checking and accepting the report to be checked; and in the same form page, checking and accepting the item to be checked and accepted of the report to be checked and accepted by using the checking and accepting item of the system report, and visually marking the checking and accepting result.

Description

Visual data acceptance method and system

Technical Field

The application relates to the field of intelligent office, in particular to a visual data acceptance method and system.

Background

Reports are a visual form of data reporting, and data is typically displayed dynamically using a table, chart, or other format.

In order to check and accept the correctness of the report data, the SQL statements for verification are written aiming at the report data, and the SQL statements are executed to check the report data during checking and accepting.

Because the SQL sentences for verification are complex and extra debugging is needed during verification to deal with various variables, the current report data acceptance mode is too complex and is inconvenient to popularize.

Disclosure of Invention

The invention provides a visual data acceptance method and a visual data acceptance system, which aim to solve or partially solve the technical problem that the current report data acceptance mode is too complex.

In order to solve the technical problem, the invention provides a visual data acceptance method, which comprises the following steps:

calling form data in a database through an operation control configured in a form operation object;

generating a report to be checked according to the form data;

integrating the report to be checked and the system report to the same form page; the system report is used for checking and accepting the report to be checked;

and in the same form page, checking and accepting the item to be checked and accepted of the report to be checked and accepted by using the checking and accepting item of the system report, and visually marking the checking and accepting result.

Preferably, the invoking of the form data in the database through the operation control configured in the form operation object specifically includes:

acquiring an operation instruction through the operation control; the operation instruction is obtained by triggering the operation control by a user;

and calling the form data according to the operation instruction.

Preferably, before generating the report to be checked according to the form data, the method further includes:

and configuring the form data into a form page according to the form structure.

Preferably, the form operation object comprises N form pages, each form page is configured with respective form data, and N is greater than or equal to 1 and is a positive integer;

the generating of the report to be checked according to the form data specifically includes:

fusing the associated form data in the associated form page into the report to be checked according to a preset rule; wherein the associated form page belongs to the N form pages.

Preferably, in the same form page, the acceptance item of the report to be accepted is accepted by using the acceptance item of the system report, and the acceptance result is visually marked, specifically including:

comparing the acceptance items with the items to be accepted one by one in the same form page to obtain acceptance results;

and if the acceptance results are inconsistent, carrying out visual marking on the acceptance results.

Preferably, before comparing the acceptance items with the items to be accepted one by one to obtain an acceptance result, the method further includes:

and configuring an acceptance result column in the same form page, wherein the acceptance result column is used for filling in the acceptance result.

Preferably, after visually marking the acceptance result, the method further comprises:

and if the form data is updated, updating the report to be checked and accepted based on the updated form data, and correspondingly updating the checking and accepting result.

The invention discloses a visual data acceptance system, which comprises:

the calling module is used for calling form data in the database through operation controls configured in the form operation object;

the generating module is used for generating a report to be checked according to the form data;

the integration module is used for integrating the report to be checked and accepted and the system report to the same form page; the system report is used for checking and accepting the report to be checked and accepted;

and the acceptance check module is used for checking and accepting the items to be accepted of the report to be accepted by using the acceptance items of the system report in the same form page and visually marking the acceptance check result.

Preferably, the invoking module is specifically configured to:

and calling the form data according to the operation instruction.

Preferably, the system further comprises:

and the first configuration module is used for configuring the form data into a form page according to a form structure.

the generation module is specifically used for fusing the associated form data in the associated form page into the report to be checked according to a preset rule; wherein the associated form page belongs to the N form pages.

Preferably, the acceptance module is specifically configured to:

Preferably, the system further comprises:

and the second configuration module is used for configuring an acceptance result column in the same form page, and the acceptance result column is used for filling in the acceptance result.

Preferably, the system further comprises:

and the updating module is used for updating the report to be checked based on the updated form data and correspondingly updating the checking result if the form data is updated.

The invention discloses a computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.

The invention discloses a computer device, comprising a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the steps of the method when executing the program.

Through one or more technical schemes of the invention, the invention has the following beneficial effects or advantages:

when the report is generated, the operation control configured in the form operation object directly calls the form data in the database to generate the report to be checked and accepted without additionally compiling SQL sentences, and the mode of obtaining the report to be checked and accepted is simple and easy to operate. In addition, the report to be checked and the system report are integrated into the same form page, visual comparison and display can be carried out in the same form page, in addition, in the same form page, the check item of the report to be checked and accepted is used for checking and accepting the check and accept item of the report to be checked and accepted, the check and accept result is visually marked, and the SQL sentence does not need to be written again for operation and check and acceptance. The scheme is used for checking and accepting the report to be checked and accepted in the same form page, and is simpler and easier to operate compared with a mode of checking and accepting by utilizing SQL (structured query language) statements to query independent data, and the checking and accepting result can be visually displayed in the same form page, so that the checking and accepting time can be obviously shortened and the checking and accepting result can be more visually represented for report data with complex logic.

The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

FIG. 1 shows a flow diagram of a visualization data acceptance method according to one embodiment of the invention;

FIG. 2 is a diagram illustrating a form page having operational controls therein according to one embodiment of the present invention;

FIG. 3 illustrates a schematic diagram of a composite form page in accordance with one embodiment of the present invention;

FIG. 4 is a diagram illustrating an integration of a report to be checked and a system report into a same form page according to an embodiment of the present invention

Fig. 5 shows a schematic diagram of a visual data acceptance system according to an embodiment of the invention.

Detailed Description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

Because the target report data acceptance mode is too complex, in order to solve the problem, the embodiment of the invention provides a visual data acceptance method and a visual data acceptance system. In addition, the report to be checked and the system report are integrated into the same form page to be visually contrasted and displayed, in the same form page, the check item of the report to be checked and accepted is checked and accepted by utilizing the check item of the system report, the check and acceptance result is visually marked, and the SQL sentence is not required to be written for operation and check and acceptance. The scheme is used for checking and accepting the report to be checked and accepted in the same form page, and is simpler and easier to operate compared with a mode of checking and accepting by utilizing SQL (structured query language) statements to query independent data, and the checking and accepting result can be visually displayed in the same form page, so that the checking and accepting time can be obviously shortened and the checking and accepting result can be more visually represented for report data with complex logic.

The technical scheme is improved on the basis of the form operation object, is simple and easy to operate, can verify form data in large batch, and can obtain the acceptance result only by operating the user personnel with the form making basis according to the scheme.

Referring to fig. 1, a flow chart of a visual data acceptance method disclosed in an embodiment of the present invention is shown, where the method can be used for predicting an industrial production report. The method comprises the following steps:

step 101, calling form data in a database through an operation control configured in a form operation object.

The form operation object is specifically a functional component capable of generating a form, such as EXCEL. And the form operation object can display a form page after being started and is used for filling form data.

In this embodiment, in order to facilitate the operation, an operation control is built in the form operation object, and the database stores data and integrates a VBA function module (a class module written using a VBA programming language) for calling the database. Therefore, after the form operation object is started, the display interface corresponding to the operation control is inserted into the form page so as to call the form data in the database. Specifically, when the user triggers the operation control to obtain the operation instruction, the form operation object obtains the operation instruction through the operation control, and calls the form data from the database according to the operation instruction. Further, after the operation control obtains the operation instruction, the VBA function module is called according to the operation instruction to obtain the configured database data.

In a specific implementation process, the specific code for calling the database by using the VBA function module is as follows:

the display interface corresponding to the operation control is shown in fig. 2, but is not limited thereto. In fig. 2, the display interface corresponding to the operation control is provided with the following buttons: the table structure/data is acquired, the data is emptied, and the DB (database) is imported to generate the data. The different buttons correspond to different functions, for example, "obtain table structure/data" corresponds to a function of deriving form data from the database. The "clear data" corresponds to a function of clearing form data in a form page. When the user triggers (e.g. clicks) the corresponding button, the operation control is triggered to generate different operation instructions.

In this embodiment, since the form operation object includes N form pages, N is greater than or equal to 1 and is a positive integer. And the form data for each form page is different. Therefore, in order to avoid data errors caused by confusion of form data in each form page, in this embodiment, each form page displays an operation control, and by triggering the operation control in each form page, the form data corresponding to each form page can be obtained from the database. By the operation, the form data of each form page can be obtained in a standard mode, and data errors are avoided. Of course, in order to save processing time and simplify operations, when the form operation object has N form pages, the operation control can be displayed in any form page, and form data corresponding to the N form pages is obtained by triggering the operation control, so that the form data can be conveniently and quickly obtained. The form data may be obtained according to actual conditions, which is not limited in this embodiment.

In this embodiment, since the form page has a form structure, the form data and the form structure must be matched to fill in the form page. Therefore, in the process of obtaining the form data, the form data matched with the form structure is obtained according to the form structure of the form page. Taking the form page in fig. 2 as an example for explanation, the form structure of the form page in fig. 2 has 8 rows of data, and each row of data has a respective field name and type, so after the operation control is triggered, the form data matched with the form structure can be obtained from the database according to the form structure of the form page in fig. 2 and the operation instruction obtained by triggering the operation control.

After the form data is obtained, the form data needs to be configured into a form page. Specifically, since the form page has a form structure, form data is arranged in the form page in accordance with the form structure at the time of arrangement. In this embodiment, if the form operation object includes N form pages, the above operation is performed on all the N form pages, so as to configure the form data into the corresponding form page. After configuring the form data, each form page has respective form data. It can be seen that, in the embodiment, form data is configured into a form page according to form structure configuration, and the form data can be configured into a corresponding form page in a targeted manner to form report data, and compared with a manner of configuring data by executing an SQL statement, the manner of the embodiment is simpler and faster to operate, and can realize one-click operation, and only by triggering an operation control by a user, the form data can be obtained and configured into the form page, and data errors cannot be caused, and the correctness of data configuration can be ensured.

And 102, generating a report to be checked according to the form data.

The form operation object comprises N form pages, N is more than or equal to 1 and is a positive integer, and each form page is configured with respective form data, so that when the to-be-checked report is generated, the associated form pages need to be determined from the N form pages, and the associated form data in the associated form pages are fused into the to-be-checked report according to a preset rule.

Specifically, the associated form page represents the form page associated with the to-be-checked statement. The associated form data in the associated form page is used for calculating the form data in the report to be checked, namely: and the form data in the report to be checked is obtained by processing the associated form data in the associated form page. The associated form pages comprise a plurality of form pages, and the form pages are located on different sheet pages. Further, some form pages in the associated form page may include an original form page, where the original form page is a form page obtained by configuring form data according to a form structure. In addition, a composite form page may also be included, where the composite form page is a form page formed by combining different form pages, and form data in the composite form page is obtained by combining form data of different form pages, for example, in fig. 3, data in the "alg _ inventoryy" form page is obtained by associating the form pages: the "inventory _ input" and the "app _ data _ detail" are combined according to a preset rule. Further, if the correlation form pages need to be compared, the system report can also be fused into the correlation form pages for comparison, see fig. 3.

In this embodiment, function rules such as "VLOOKUP", "MID", "LEFT", "RIGHT", "IF", "SUMIF", and the like are set to fuse the associated form data in the associated form pages belonging to different sheet pages, so as to obtain the final required acceptance and report table to be checked. Therefore, the embodiment can fuse the associated form data of a plurality of different sheet pages into the to-be-checked and accepted form, and is not limited to the operation of the form data in the same form page. It should be noted that the preset rule depends on the calculation rule of the form data in the system report. For example, the preset rule is the same as the calculation rule, so that the report to be checked and the data calculation mode of the system report are the same, and the data reliability and the correctness of the report to be checked and accepted are further improved.

And 103, integrating the report to be checked and the system report into the same form page.

The system report is report data obtained by calculating the form data by using the system and is used for checking and accepting the report to be checked and accepted.

For more intuitive comparison, the report to be checked and the system report are integrated into the same form page, see fig. 4, and the report to be checked and the system report are integrated into the same sheet page, in the same sheet page, the data in the 47 th to 61 th lines are the form data in the report to be checked, and the data in the 467 th to 470 th lines are the form data in the system report.

Further, the acceptance table includes the items to be accepted, for example, the items to be accepted in the row 50, column W to column AQ in fig. 4. The system report has acceptance items, for example, acceptance items in the W column to the AQ column in the 467 th row. The number of the items to be checked and the number of the items to be checked are consistent.

And integrating the report to be checked and the system report into the same form page in the implementation process, and integrating the checking items in the system report into the form page where the report to be checked and received is located based on the items to be checked and received in the report to be checked and received. Of course, the items to be checked in the report to be checked and the items to be checked in the system report can be integrated into a new form page, and only the items to be checked and the system report need to be guaranteed to be on the same form page.

And 104, checking and accepting the to-be-checked and accepted item of the to-be-checked and accepted report by using the to-be-checked and accepted item of the system report in the same form page, and visually marking the checking and accepting result.

In this embodiment, since the report to be checked and the system report are in the same form page, when checking, the check items and the check items are compared one by one to obtain the check result, and the check result is visually marked. Specifically, in the comparison process, the acceptance item and the item to be accepted are compared by an X-Y formula, where X is the item to be accepted and Y is the acceptance item. For example, in fig. 4, when W50W 467 is used for comparison, in order to obtain the acceptance result more intuitively, an acceptance result column is arranged in the same form page, and the acceptance result column is used for filling the acceptance result.

Furthermore, when the check result is visually marked, the embodiment pays more attention to the items with inconsistent comparison. Therefore, in this embodiment, if the acceptance results are consistent, the "tune" character mark is filled to indicate the acceptance results, and if the acceptance results are inconsistent, the "FALSE" character mark is filled to indicate the acceptance results, and the acceptance results are visually marked. Such as red highlighting. For example, in fig. 4, the items to be checked on the 50 th, 51 st, 60 th and 61 st lines are checked by the items to be checked on the 467 th to 470 th lines to obtain the check results, and the check results are displayed on the 472 th to 475 th lines, respectively.

In the embodiment, the acceptance of the report to be accepted is checked in the same form page, and the acceptance result is visually marked, so that the acceptance result can be visually displayed.

In an embodiment of the invention, the form data is updated when the system is running again. In this embodiment, if the form data is updated, the to-be-checked report is updated based on the updated form data. Specifically, a preset rule in the form operation object is reserved, and when the associated form data in the associated form page is updated, the updated associated form data is fused into an updated acceptance report to be checked according to the preset rule, and the acceptance result is correspondingly updated.

Based on the same inventive concept, the following embodiments describe a visual data acceptance system, referring to fig. 5, including:

a calling module 501, configured to call form data in a database through an operation control configured in a form operation object;

a generating module 502, configured to generate a to-be-checked report according to the form data;

the integration module 503 is configured to integrate the report to be checked and the system report into the same form page; the system report is used for checking and accepting the report to be checked;

and the acceptance module 504 is configured to accept the acceptance item of the report to be accepted by using the acceptance item of the system report in the same form page, and visually mark an acceptance result.

In an embodiment of the present invention, the invoking module 501 is specifically configured to:

and calling the form data according to the operation instruction.

In an embodiment of the present invention, the system further includes:

In an embodiment of the present invention, the form operation object includes N form pages, each form page is configured with respective form data, and N is greater than or equal to 1 and is a positive integer;

the generating module 502 is specifically configured to fuse the associated form data in the associated form page into the report to be checked according to a preset rule; wherein the associated form page belongs to the N form pages.

In an embodiment of the present invention, the acceptance module 504 is specifically configured to:

In an embodiment of the present invention, the system further includes:

Based on the same inventive concept as in the previous embodiments, embodiments of the present invention further provide a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of any of the methods described above.

Based on the same inventive concept as in the foregoing embodiments, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the processor implements the steps of any one of the foregoing methods.

The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system is apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.

In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: rather, the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.

Those skilled in the art will appreciate that the modules in the devices in an embodiment may be adaptively changed and arranged in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will appreciate that while some embodiments herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.

Various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functionality of some or all of the components of a gateway, proxy server, system according to embodiments of the present invention. The present invention may also be embodied as apparatus or device programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.

Claims

1. A visual data acceptance method, the method comprising:

calling form data in a database through operation controls configured in the form operation object;

generating a report to be checked according to the form data;

integrating the report to be checked and the system report to the same form page; the system report is used for checking and accepting the report to be checked and accepted;

and in the same form page, checking and accepting the to-be-checked and accepted item of the to-be-checked and accepted report by using the to-be-checked and accepted item of the system report, and visually marking the checking and accepting result.

2. The method of claim 1, wherein the invoking of the form data in the database via the operation control configured in the form operation object specifically comprises:

acquiring an operation instruction through the operation control; the operation command is obtained by triggering the operation control by a user;

and calling the form data according to the operation instruction.

3. The method of claim 1, wherein prior to generating a statement to be approved from the form data, the method further comprises:

and configuring the form data into a form page according to a form structure.

4. The method of claim 3, wherein the form operation object comprises N form pages, each form page is configured with respective form data, N ≧ 1 and is a positive integer;

5. The method according to claim 1, wherein said checking and accepting the acceptance items of the report to be accepted by using the acceptance items of the system report in the same form page and visually marking the acceptance results specifically comprises:

6. The method of claim 5, wherein before comparing the acceptance items with the items to be accepted one by one to obtain an acceptance result, the method further comprises:

7. The method of claim 1, wherein after visually marking the acceptance results, the method further comprises:

8. A visual data acceptance system, comprising:

the integration module is used for integrating the report to be checked and the system report to the same form page; the system report is used for checking and accepting the report to be checked;

9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.

10. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any one of claims 1 to 7 when executing the program.