CN110765750A - Report data entry method and terminal equipment - Google Patents
Report data entry method and terminal equipment Download PDFInfo
- Publication number
- CN110765750A CN110765750A CN201910871485.4A CN201910871485A CN110765750A CN 110765750 A CN110765750 A CN 110765750A CN 201910871485 A CN201910871485 A CN 201910871485A CN 110765750 A CN110765750 A CN 110765750A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- report
- business
- configuration information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000013479 data entry Methods 0.000 title claims abstract description 21
- 238000012216 screening Methods 0.000 claims description 20
- 238000004590 computer program Methods 0.000 claims description 14
- 238000004883 computer application Methods 0.000 abstract description 2
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 8
- 244000046052 Phaseolus vulgaris Species 0.000 description 8
- 230000006870 function Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention is suitable for the technical field of computer application, and provides a report data entry method, a terminal device and a computer readable storage medium, wherein the report data entry method comprises the following steps: acquiring the business data of a report to be recorded and the data identification of the business data; searching a data reading template corresponding to the data identification from a preset template library; if the data reading template corresponding to the data identifier is not found, determining the data attribute corresponding to the data identifier according to the corresponding relation between the preset data identifier and the data attribute of the preset service component model, generating an annotation configuration and a form data reading template according to the data attribute, and finally inputting form data according to the data reading template, so that the intermediate link of data inputting is simplified, and the efficiency and the accuracy of data inputting are improved.
Description
Technical Field
The invention belongs to the technical field of computer application, and particularly relates to a report data entry method, a terminal device and a computer readable storage medium.
Background
The report forms are used for dynamically displaying data in forms such as tables and diagrams and are composed of various forms and dynamic data. The report contents are displayed in a tiled mode according to the sequence of the head of the report, and detailed information can be conveniently checked. The general basic information table may be embodied in a tabular form. The display system is mainly used for displaying documents such as a customer list, a product list, an article list, an order, an invoice and the like or data with a small number of records such as a daily sales record and the like. In a reporting system, each report often means that a set of things is defined.
In the prior art, a service component model bean is defined through an Excel reading module, and the read data is mapped to the service bean, so that the data is read through a storage reading module of the service bean. The defects of the mode are that the definition of the data is too much, the expansion is troublesome, meanwhile, the later maintenance is not friendly, the number of intermediate links is large, and the problem of low efficiency is easy to occur.
Disclosure of Invention
In view of this, embodiments of the present invention provide a report data entry method, a terminal device, and a computer-readable storage medium, so as to solve the problem in the prior art that low efficiency is likely to occur when entering report data.
A first aspect of an embodiment of the present invention provides a report data entry method, including:
acquiring business data of a report to be input and a data identifier of the business data;
searching a data reading template corresponding to the data identification from a preset template library;
if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model;
generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and inputting the business data according to the data reading template to generate a report of the business data.
A second aspect of the embodiments of the present invention provides a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the following steps when executing the computer program:
acquiring business data of a report to be input and a data identifier of the business data;
searching a data reading template corresponding to the data identification from a preset template library;
if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model;
generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and inputting the business data according to the data reading template to generate a report of the business data.
A third aspect of an embodiment of the present invention provides a terminal device, including:
the acquisition unit is used for acquiring the service data of the report to be input and the data identification of the service data;
the searching unit is used for searching a data reading template corresponding to the data identification from a preset template library;
the attribute unit is used for determining the data attribute corresponding to the data identifier according to the corresponding relation between the preset data identifier and the data attribute of the preset service component model if the data reading template corresponding to the data identifier is not found;
the template unit is used for generating annotation configuration information according to the data attribute corresponding to the data identifier and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and the report unit is used for inputting the business data according to the data reading template and generating a report of the business data.
A fourth aspect of embodiments of the present invention provides a computer-readable storage medium having stored thereon a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the method of the first aspect described above.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
the embodiment of the invention obtains the business data of the report to be input and the data identification of the business data; searching a data reading template corresponding to the data identification from a preset template library; if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model; generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the form is generated; and inputting the business data according to the data reading template to generate a report of the business data. According to the corresponding relation between the preset data identification and the data attribute of the preset business component model, the data attribute corresponding to the data identification is determined, the annotation configuration and the form data reading template are generated according to the data attribute, and finally the form data is input according to the data reading template, so that the intermediate link of data input is simplified, and the efficiency and the accuracy of data input are improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only 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 inventive exercise.
Fig. 1 is a flowchart of a report data entry method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a report data entry method according to a second embodiment of the present invention;
fig. 3 is a schematic diagram of a terminal device according to a third embodiment of the present invention;
fig. 4 is a schematic diagram of a terminal device according to a fourth embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to explain the technical means of the present invention, the following description will be given by way of specific examples.
Referring to fig. 1, fig. 1 is a flowchart of a report data entry method according to an embodiment of the present invention. The execution main body of the report data entry method in the embodiment is a terminal. The terminal includes but is not limited to mobile terminals such as smart phones, tablet computers, wearable devices and the like, and can also be desktop computers and the like. The report data entry method as shown in the figure can comprise the following steps:
s101: and acquiring the business data of the report to be recorded and the data identification of the business data.
The report forms dynamically display data in forms such as tables and diagrams, and are composed of various forms and dynamic data. The report contents are displayed in a tiled mode according to the sequence of the head of the report, and detailed information can be conveniently checked. The general basic information table may be embodied in a tabular form. The display system is mainly used for displaying documents such as a customer list, a product list, an article list, an order, an invoice and the like or data with a small number of records such as a daily sales record and the like. In a reporting system, each report often means that a set of things is defined.
In practical applications, various application systems include various system services, each of which has a corresponding different function, and in the process of implementing the functions according to the system services, a lot of service data are generated. However, these service data are all scattered and out-of-order data, and therefore, before the data are analyzed and mined, the data need to be normalized to obtain a report which contains complete service data and represents clear service data.
When a business system is developed, due to the fact that business data in the business system are numerous and complicated, the business data of a report to be recorded are obtained before the business data are processed. The service data in this embodiment may be result data that is obtained and generated by the service system and used for representing a data processing result, and may also include intermediate data generated in real time in the data processing process. In addition, the application system may be running data generated by testing a development object of the application system, may be data run by a computer device, and may also be user application data of an application program or a network, which is not limited herein. The form of the service data acquired in this embodiment may be an Extensible Markup Language (XML) or a Structured Query Language (SQL) file, which is not limited herein. Each service data has a corresponding data identifier, the data identifier in this embodiment is used to indicate a data name of the service data, and in addition, data information that each service data may also carry includes data generation time, a data type, and a normal numerical range corresponding to the service data.
Meanwhile, the manner of acquiring the service data in this embodiment may be a manner of acquiring data in the service system in real time, and the manner of acquiring the service data in real time may be implemented by burying points in the service system, or may be crawled by using a web crawler, which is not limited herein, or may be a manner of manually acquiring the service data, and after the service data is acquired, the corresponding service data may be screened out from all the service data according to conditions such as data identification and generation time of the service data according to a requirement of a user.
S102: and searching a data reading template corresponding to the data identification from a preset template library.
In this embodiment, a template library is preset, which includes data reading templates corresponding to various data identifiers. Meanwhile, each data reading template in the template library corresponds to the data identification. The data reading template can include data corresponding to various data types or data identifications, and the corresponding service data includes a plurality of types. Therefore, in order to more accurately represent the association correspondence between one data reading template and the service data, in this embodiment, one data reading template corresponds to a plurality of data identifiers, and the correspondence is determined according to the data identifiers included in the data reading template, that is, the plurality of data identifiers correspond to one data reading template.
When the data reading template corresponding to the data identifier is searched from the preset template library, the data reading template corresponding to all the data identifiers can be searched in the template library according to all the data identifiers in the service data, so that the accuracy of querying the data reading template is ensured. In addition, in order to improve the success rate of querying the data reading template, a preset number of important data identifiers in the service data can be determined, the corresponding data reading template is searched in the template library according to the important data identifiers, the corresponding data reading template is searched according to the important data identifiers, so that the success rate of querying the data reading template is improved, the important data identifiers are ensured to have the corresponding data reading template, and a report containing the important data can be generated. Specifically, in this embodiment, when determining the important data identifier, the importance degree of one data identifier may be measured according to a preset weight value of the service data, and then a preset number of important data identifiers are determined, so as to determine the data reading template corresponding to the important data identifier.
S103: and if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model.
If the data reading template corresponding to the data identifier is not found in the template library, it indicates that the data reading template is not provided for the service data corresponding to the current data identifier in the current template library, and therefore, the data reading template needs to be constructed according to the data identifier.
The service component model in this embodiment may be a service Bean model, the service Bean in the service Bean model includes information to be displayed in each report, the relationships between the service Bean and each report are in one-to-one correspondence, and one report corresponds to a worksheet label Sheet of an Excel and also corresponds to one service Bean. The data attribute of the preset service component model in this embodiment is used to represent a data type, a data form, and the like, and is not limited herein.
In this embodiment, a corresponding relationship between the data identifier and the data attribute is pre-established according to the data attribute of the preset service component model and all the data identifiers generated in the service system. The corresponding relation is used for representing the data attribute corresponding to each data identifier, so that the data attribute corresponding to the data identifier is determined through the preset corresponding relation.
S104: generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information includes configuration information of the business data when the table is generated.
And after the data attribute corresponding to the data identifier is determined, generating annotation configuration information according to the data attribute corresponding to the data identifier. The specific generation process is to analyze the data attributes to obtain corresponding logics between the data attributes and the report forms, and generate annotation configuration information of the business data reading template according to the corresponding logics between the data attributes and the report forms. The annotation configuration information in this embodiment is used to determine a display attribute of the business data in the report, where the display attribute may include a display position, a display style, or a table identifier of the business data corresponding to the table, and the like, which is not limited herein.
When the business data reading template is generated, the annotation configuration information is imported into a preset template engine, and an XML file in the form of a report generation tool JXLS of the business data is generated, where the XML file is the business data reading template of the embodiment. The template engine of this embodiment is used to generate an output text based on the data reading template and the service data to be entered, that is, the data reading template corresponding to the service data, and the template engine of this embodiment may be a Freemarker template engine, which is not limited herein.
S105: and inputting the business data according to the data reading template to generate a report of the business data.
And after the data reading template is generated, recording the business data into the data reading template to generate a report of the business data. Specifically, the data reading template in this embodiment already includes data attributes or data logics, that is, annotation configuration information, corresponding to each template position, and after the data reading template is obtained, the information is configured according to the host of the data reading template, and the service data is entered into the corresponding position in the data reading template, so as to obtain a report of the service data.
According to the scheme, the business data of the report to be recorded and the data identification of the business data are acquired; searching a data reading template corresponding to the data identification from a preset template library; if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model; generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the form is generated; and inputting the business data according to the data reading template to generate a report of the business data. According to the corresponding relation between the preset data identification and the data attribute of the preset business component model, the data attribute corresponding to the data identification is determined, the annotation configuration and the form data reading template are generated according to the data attribute, and finally the form data is input according to the data reading template, so that the intermediate link of data input is simplified, and the efficiency and the accuracy of data input are improved.
Referring to fig. 2, fig. 2 is a flowchart of a report data entry method according to a second embodiment of the present invention. The execution main body of the report data entry method in the embodiment is a terminal. The terminal includes but is not limited to mobile terminals such as smart phones, tablet computers, wearable devices and the like, and can also be desktop computers and the like. The report data entry method as shown in the figure can comprise the following steps:
s201: and acquiring the business data of the report to be recorded and the data identification of the business data.
In this embodiment, the implementation manner of S201 is completely the same as that of S101 in the embodiment corresponding to fig. 1, and reference may be specifically made to the related description of S101 in the embodiment corresponding to fig. 1, which is not repeated herein.
S202: and searching a data reading template corresponding to the data identification from a preset template library.
In addition, when the report of the historical service data is generated, a data reading template generated according to the historical service data may be stored in a preset template library, and a specific storage manner may be stored according to a data identifier of the historical service data, for example, a storage identifier is generated according to the historical service data, and then the data reading template and the storage identifier corresponding to the historical service data are stored in the template library in an associated manner.
When a report is generated according to the business data, firstly, the query is carried out in a template library. And inquiring whether a data reading template corresponding to the data identification of the service data is stored in the template library. The query mode can be that a search identifier corresponding to the storage identifier is generated according to the data identifier, and then whether a data reading template corresponding to the search identifier exists or not is searched in the template library. The generation mode of the search identifier is the same as that of the storage identifier.
S203: and if the template base stores the data reading template corresponding to the data identification, the business data is input according to the data reading template corresponding to the data identification.
When the data reading template corresponding to the data identifier is searched from the template library, if the data reading template corresponding to the data identifier is stored in the template library, it is indicated that the data reading template corresponding to the current data identifier exists in the template library, and the business data is recorded according to the data reading template corresponding to the data identifier.
Specifically, the data reading template in this embodiment already includes data attributes or data logics, that is, annotation configuration information, corresponding to each template position, and after the data reading template is obtained, the information is configured according to the host of the data reading template, and the service data is entered into the corresponding position in the data reading template, so as to obtain a report of the service data.
S204: and if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model.
In this embodiment, step S204 is parallel to step S203, and is alternatively executed, in this embodiment, the implementation manner of step S204 is completely the same as that of step S103 in the embodiment corresponding to fig. 1, and reference may be specifically made to the related description of step S103 in the embodiment corresponding to fig. 1, and details are not repeated here.
S205: generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated.
And after the data attribute corresponding to the business data is determined, extracting the corresponding relation between the data attribute and the report as annotation configuration information. And embedding the annotation configuration information into a preset empty template to generate a data reading template.
Further, step S205 may specifically include:
s2051: and converting the data attribute corresponding to the data identifier into the annotation configuration information according to a preset data attribute configuration strategy.
In this embodiment, a data attribute configuration policy is preset and is used to generate annotation configuration information according to the data attribute corresponding to the data identifier. The data attribute configuration strategy comprises a method or a corresponding relation for generating annotation configuration information according to the style corresponding to each data attribute and the logic association relation among all the data attributes.
And after the data attribute corresponding to the data identifier is determined, generating annotation configuration information according to the data attribute corresponding to the data identifier. The specific generation process is to analyze the data attributes to obtain corresponding logics between the data attributes and the report forms, and generate annotation configuration information of the business data reading template according to the corresponding logics between the data attributes and the report forms. The annotation configuration information in this embodiment is used to determine a display attribute of the business data in the report, where the display attribute may include a display position, a display style, or a table identifier of the business data corresponding to the table, and the like, which is not limited herein.
S2052: and importing the annotation configuration information into a preset template engine to generate a data reading template of the business data.
When the business data reading template is generated, the annotation configuration information is imported into a preset template engine, and an XML file in the form of JXLS of the business data is generated, where the XML file is the business data reading template of this embodiment. The template engine of this embodiment is configured to generate an output text based on the data reading template and the service data of the report to be entered, that is, the data reading template corresponding to the service data.
Specifically, when generating the XML of the JXLS of the service ═ data, the JXLS is used to create all data reading templates with correct formats, and then the place where the table data corresponding to each data identifier should be placed is specified, so that the JXLS can create an extremely complex Excel report form with only a few lines of codes compared with other modes. Only specific tags are needed to create an xls template file with all required rules for format, formula, macro, etc., specify where the data is to be placed, and then write several lines of code to call the JXLS engine to pass the xls template and the derived data as parameters. In addition to the Excel reporting function, JXLS provides a JXLS-reader module for parsing and inserting data into an Excel file of a predefined format if necessary. The report parsing tool JXLS-reader can describe the parsing rule by a simple XML file, and all other work of reading Excel files and various JAVA objects can be automatically completed.
The template engine of this embodiment may be a freemaker template engine, where freemaker is a template engine: namely, a data reading template is generated and output based on the template and the business data of the report to be input. It is not end-user oriented, but a Java class library, a component that programmers can embed into the products they develop. When the data is processed according to the Freemarker template engine, annotation configuration information is firstly led into the Freemarker template engine and used for determining the display mode of each service data in the Freemarker template engine.
Further, after step S205, the method may further include:
s2053: and determining a storage identifier corresponding to the service data according to all the data identifiers in the service data.
And after the data reading template of the service data is generated, generating a storage identifier according to the data identifier of the service data so as to store the data reading template according to the storage identifier. Specifically, when the storage identifier is generated, all the data identifiers may be combined in a certain order to obtain the storage identifier; or selecting important marks with a certain data size from the important marks to be combined to obtain a storage mark; in addition, the combined identifiers can be further thinned to obtain storage identifiers with smaller data, so that the data comparison time cost in the query process is reduced, and the query efficiency of the data reading template is improved.
It should be noted that the combination method in the above scheme may be a method of directly connecting characters of all data identifiers. The more important data identifier may be selected by determining a weight corresponding to each data identifier according to a preset weight of each service data, and identifying the data identifier with a higher weight as the important identifier.
S2054: and storing the data reading template into the template library according to the storage identification.
After the storage identifier is obtained, the data reading template and the storage identifier are stored in the template library in an associated manner, so that when the service data is processed later, the corresponding data reading template can be directly determined in the template library according to the data identifier of the service data.
When a report is generated according to the business data, firstly, the query is carried out in a template library. And inquiring whether a data reading template corresponding to the data identification of the service data is stored in the template library. The query mode can be that a search identifier corresponding to the storage identifier is generated according to the data identifier, and then whether a data reading template corresponding to the search identifier exists or not is searched in the template library. The generation mode of the search identifier is the same as that of the storage identifier.
S206: and inputting the business data according to the data reading template to generate a report of the business data.
And after the data reading template is generated, recording the business data into the data reading template to generate a report of the business data. Specifically, the data reading template in this embodiment already includes data attributes or data logics, that is, annotation configuration information, corresponding to each template position, and after the data reading template is obtained, the information is configured according to the host of the data reading template, and the service data is entered into the corresponding position in the data reading template, so as to obtain a report of the service data.
Further, step S206 may specifically include:
s2061: and acquiring a preset screening condition aiming at the service data.
Further, considering that the data processing efficiency is affected when the data in the table is large, the management of the table data can be performed through the filter, and the condition for screening the table data is set automatically when the report is set. The system may provide two different filter management for query scope reduction. Specifically, when the report is customized, the filter is set through the conditions of being equal to, not equal to, being contained in a list customized by a certain user. When the report is generated, a user fills in a filtering range on the spot, so that the flexibility of the report is improved.
In consideration of the situation, the present embodiment presets a screening condition for screening the service data to obtain target data with low redundancy. The screening condition may be a data identifier, a data threshold, data generation time, or a data merging condition, where the data merging condition is used to indicate that service data meeting the conditions are merged, and is not limited here.
S2062: and selecting target data to be input into the report form in the business data according to the screening condition.
And after the screening conditions are obtained, selecting target data of the report to be input in the business data according to the screening conditions. Illustratively, when the screening condition is some data identifications, screening the service data corresponding to the data identifications as target data; when the screening condition is a data threshold, screening the service data with the data size meeting the data threshold as target data; when the screening condition is data generation time, screening the service data generated in the data generation time as target data; when the screening condition is a data merging condition, the service data meeting the data merging condition is screened, and then the data merging is performed according to a preset merging mode, where the merging mode may be addition or multiplication of data values, or a mode of merging and placing corresponding service data in the same report unit, and this is not limited here.
S2063: and inputting the target data according to the data reading template to generate the report.
After the target data are determined, the target data are recorded into the data reading template, and a report of the target data is generated. It should be noted that, in this embodiment, after the business data is screened to obtain the target data, the target data may not correspond to the data reading template, in this case, the target data may be first input into the data reading template, and the final report may be obtained by manually adjusting the non-corresponding place.
According to the scheme, the business data of the report to be recorded and the data identification of the business data are acquired; searching a data reading template corresponding to the data identification from a preset template library; and if the template base stores the data reading template corresponding to the data identification, the business data is input according to the data reading template corresponding to the data identification. If the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model; generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated; and inputting the business data according to the data reading template to generate a report of the business data. According to the corresponding relation between the preset data identification and the data attribute of the preset business component model, the data attribute corresponding to the data identification is determined, the annotation configuration and the form data reading template are generated according to the data attribute, and finally the form data is input according to the data reading template, so that the intermediate link of data input is simplified, and the efficiency and the accuracy of data input are improved.
Referring to fig. 3, fig. 3 is a schematic diagram of a terminal device according to a third embodiment of the present invention. The terminal device includes units for executing the steps in the embodiments corresponding to fig. 1 to fig. 2. Please refer to the related description of the embodiments in fig. 1-2. For convenience of explanation, only the portions related to the present embodiment are shown. The terminal device 300 of the present embodiment includes:
an obtaining unit 301, configured to obtain service data of a report to be entered and a data identifier of the service data;
a searching unit 302, configured to search a data reading template corresponding to the data identifier from a preset template library;
an attribute unit 303, configured to determine, if a data reading template corresponding to the data identifier is not found, a data attribute corresponding to the data identifier according to a correspondence between a preset data identifier and a data attribute of a preset service component model;
the template unit 304 is configured to generate annotation configuration information according to the data attribute corresponding to the data identifier, and generate a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
a report unit 305, configured to enter the service data according to the data reading template, and generate a report of the service data.
Further, the template unit 304 specifically includes:
the configuration unit is used for configuring a strategy according to a preset data attribute and converting the data attribute corresponding to the data identifier into the annotation configuration information;
and the importing unit is used for importing the annotation configuration information into a preset template engine to generate a data reading template of the business data.
Further, the terminal device 300 further includes:
the identification unit is used for determining a storage identification corresponding to the service data according to all the data identifications in the service data;
and the storage unit is used for storing the data reading template into the template library according to the storage identifier.
Further, the terminal device 300 further includes:
and if the template base stores the data reading template corresponding to the data identification, the business data is input according to the data reading template corresponding to the data identification.
Further, the reporting unit 305 includes:
a condition obtaining unit, configured to obtain a preset screening condition for the service data;
the target screening unit is used for selecting target data to be input into the report form in the business data according to the screening condition;
and the report generation unit is used for inputting the target data according to the data reading template and generating the report.
According to the scheme, the business data of the report to be recorded and the data identification of the business data are acquired; searching a data reading template corresponding to the data identification from a preset template library; if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model; generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the form is generated; and inputting the business data according to the data reading template to generate a report of the business data. According to the corresponding relation between the preset data identification and the data attribute of the preset business component model, the data attribute corresponding to the data identification is determined, the annotation configuration and the form data reading template are generated according to the data attribute, and finally the form data is input according to the data reading template, so that the intermediate link of data input is simplified, and the efficiency and the accuracy of data input are improved.
Fig. 4 is a schematic diagram of a terminal device according to a fourth embodiment of the present invention. As shown in fig. 4, the terminal device 4 of this embodiment includes: a processor 40, a memory 41 and a computer program 42 stored in said memory 41 and executable on said processor 40. The processor 40, when executing the computer program 42, implements the steps in the various report data entry method embodiments described above, such as the steps 101-105 shown in fig. 1. Alternatively, the processor 40, when executing the computer program 42, implements the functions of the modules/units in the above-mentioned device embodiments, such as the functions of the units 301 to 305 shown in fig. 3.
Illustratively, the computer program 42 may be partitioned into one or more modules/units that are stored in the memory 41 and executed by the processor 40 to implement the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution process of the computer program 42 in the terminal device 4.
The terminal device 4 may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The terminal device may include, but is not limited to, a processor 40, a memory 41. Those skilled in the art will appreciate that fig. 4 is merely an example of a terminal device 4 and does not constitute a limitation of terminal device 4 and may include more or fewer components than shown, or some components may be combined, or different components, e.g., the terminal device may also include input-output devices, network access devices, buses, etc.
The Processor 40 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 41 may be an internal storage unit of the terminal device 4, such as a hard disk or a memory of the terminal device 4. The memory 41 may also be an external storage device of the terminal device 4, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card, FC), and the like provided on the terminal device 4. Further, the memory 41 may also include both an internal storage unit and an external storage device of the terminal device 4. The memory 41 is used for storing the computer program and other programs and data required by the terminal device. The memory 41 may also be used to temporarily store data that has been output or is to be output.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
The integrated modules/units, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow of the method according to the above embodiments may be implemented by a computer program, which may be stored in a computer-readable storage medium, to instruct related hardware.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. A report data entry method is characterized by comprising the following steps:
acquiring business data of a report to be input and a data identifier of the business data;
searching a data reading template corresponding to the data identification from a preset template library;
if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model;
generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and inputting the business data according to the data reading template to generate a report of the business data.
2. The report data entry method of claim 1, wherein the generating annotation configuration information according to the data attributes corresponding to the data identifiers and generating a business data reading template according to the annotation configuration information comprises:
converting the data attribute corresponding to the data identifier into the annotation configuration information according to a preset data attribute configuration strategy;
and importing the annotation configuration information into a preset template engine to generate a data reading template of the business data.
3. A report data entry method as claimed in claim 1, wherein after generating annotation configuration information according to the data attribute corresponding to the data identifier and generating a business data reading template according to the annotation configuration information, further comprising:
determining a storage identifier corresponding to the service data according to all the data identifiers in the service data;
and storing the data reading template into the template library according to the storage identification.
4. The report data entry method according to claim 1, wherein after searching for the data reading template corresponding to the data identifier from the preset template library, further comprising:
and if the template base stores the data reading template corresponding to the data identification, the business data is input according to the data reading template corresponding to the data identification.
5. A report data entry method according to any of claims 1-4, wherein said entering said business data according to said data reading template, generating a report of said business data, comprises:
acquiring a preset screening condition aiming at the service data;
selecting target data to be input into the report form in the business data according to the screening condition;
and inputting the target data according to the data reading template to generate the report.
6. A terminal device, comprising a memory and a processor, wherein the memory stores a computer program operable on the processor, and wherein the processor executes the computer program to perform the steps of:
acquiring business data of a report to be input and a data identifier of the business data;
searching a data reading template corresponding to the data identification from a preset template library;
if the data reading template corresponding to the data identification is not found, determining the data attribute corresponding to the data identification according to the corresponding relation between the preset data identification and the data attribute of the preset service component model;
generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and inputting the business data according to the data reading template to generate a report of the business data.
7. The terminal device of claim 6, wherein the template unit specifically includes:
the configuration unit is used for configuring a strategy according to a preset data attribute and converting the data attribute corresponding to the data identifier into the annotation configuration information;
and the importing unit is used for importing the annotation configuration information into a preset template engine to generate a data reading template of the business data.
8. The terminal device of claim 6, wherein the terminal device further comprises:
the identification unit is used for determining a storage identification corresponding to the service data according to all the data identifications in the service data;
and the storage unit is used for storing the data reading template into the template library according to the storage identifier.
9. A terminal device, comprising:
the acquisition unit is used for acquiring the service data of the report to be input and the data identification of the service data;
the searching unit is used for searching a data reading template corresponding to the data identification from a preset template library;
the attribute unit is used for determining the data attribute corresponding to the data identifier according to the corresponding relation between the preset data identifier and the data attribute of the preset service component model if the data reading template corresponding to the data identifier is not found;
the template unit is used for generating annotation configuration information according to the data attribute corresponding to the data identifier and generating a business data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when the report is generated;
and the report unit is used for inputting the business data according to the data reading template and generating a report of the business data.
10. A computer-readable storage medium, in 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 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910871485.4A CN110765750B (en) | 2019-09-16 | 2019-09-16 | Report data input method and terminal equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910871485.4A CN110765750B (en) | 2019-09-16 | 2019-09-16 | Report data input method and terminal equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110765750A true CN110765750A (en) | 2020-02-07 |
| CN110765750B CN110765750B (en) | 2024-03-15 |
Family
ID=69329928
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910871485.4A Active CN110765750B (en) | 2019-09-16 | 2019-09-16 | Report data input method and terminal equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110765750B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111581066A (en) * | 2020-04-21 | 2020-08-25 | 北京龙云科技有限公司 | Real-time report statistical analysis method and device |
| CN113213206A (en) * | 2021-04-07 | 2021-08-06 | 生态环境部华南环境科学研究所 | Data intercepting device convenient for data integration |
| CN115130440A (en) * | 2022-08-23 | 2022-09-30 | 湖南科德信息咨询集团有限公司 | Business data entry processing system suitable for equipment financing |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130091413A1 (en) * | 2011-10-10 | 2013-04-11 | Microsoft Corporation | Rich Data Label Formatting |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN105868196A (en) * | 2015-01-21 | 2016-08-17 | 张家口沪东电子科技有限公司 | Method for generating industrial data report in server |
| CN108062367A (en) * | 2017-12-08 | 2018-05-22 | 平安科技（深圳）有限公司 | The method for uploading and its terminal of a kind of data list |
| CN108664574A (en) * | 2018-04-27 | 2018-10-16 | 平安科技（深圳）有限公司 | Input method, terminal device and the medium of information |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110209714A (en) * | 2019-04-19 | 2019-09-06 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and computer readable storage medium |
-
2019
- 2019-09-16 CN CN201910871485.4A patent/CN110765750B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130091413A1 (en) * | 2011-10-10 | 2013-04-11 | Microsoft Corporation | Rich Data Label Formatting |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN105868196A (en) * | 2015-01-21 | 2016-08-17 | 张家口沪东电子科技有限公司 | Method for generating industrial data report in server |
| CN108062367A (en) * | 2017-12-08 | 2018-05-22 | 平安科技（深圳）有限公司 | The method for uploading and its terminal of a kind of data list |
| CN108664574A (en) * | 2018-04-27 | 2018-10-16 | 平安科技（深圳）有限公司 | Input method, terminal device and the medium of information |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110209714A (en) * | 2019-04-19 | 2019-09-06 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and computer readable storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111581066A (en) * | 2020-04-21 | 2020-08-25 | 北京龙云科技有限公司 | Real-time report statistical analysis method and device |
| CN113213206A (en) * | 2021-04-07 | 2021-08-06 | 生态环境部华南环境科学研究所 | Data intercepting device convenient for data integration |
| CN113213206B (en) * | 2021-04-07 | 2022-02-08 | 生态环境部华南环境科学研究所 | Data intercepting device convenient for data integration |
| CN115130440A (en) * | 2022-08-23 | 2022-09-30 | 湖南科德信息咨询集团有限公司 | Business data entry processing system suitable for equipment financing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110765750B (en) | 2024-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110765750B (en) | Report data input method and terminal equipment | |
| CN111078702B (en) | SQL sentence classification management and unified query method and device | |
| CN107291745B (en) | Data index management method and device | |
| CN107798030B (en) | Splitting method and device of data table | |
| CN109299074B (en) | Data verification method and system based on templated database view | |
| CN110019116B (en) | Data tracing method, device, data processing equipment and computer storage medium | |
| CN110675238A (en) | Client label configuration method, system, readable storage medium and electronic equipment | |
| CN112732763A (en) | Data aggregation method and device, electronic equipment and medium | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN109002425B (en) | Method for acquiring upstream and downstream relations of enterprise, terminal device and medium | |
| CN109947797B (en) | Data inspection device and method | |
| US11055477B2 (en) | Evaluation device, evaluation method, and recording medium evaluating a line as a start line of a table | |
| CN108108444B (en) | Enterprise business unit self-adaptive system and implementation method thereof | |
| CN115757174A (en) | Database difference detection method and device | |
| CN111553133B (en) | Report generation method and device, electronic equipment and storage medium | |
| CN111159204B (en) | Method and system for generating label in configuration mode | |
| CN110008264B (en) | Data acquisition method and device of cost accounting system | |
| CN111475505A (en) | Data acquisition method and equipment | |
| CN111324792A (en) | Big data platform | |
| CN112836924B (en) | Method, device, electronic equipment and storage medium for resource allocation audit | |
| CN109902067A (en) | Document handling method, device, storage medium and computer equipment | |
| CN113434365B (en) | Data characteristic monitoring method and device, electronic equipment and storage medium | |
| CN111581207B (en) | File generation method and device of Azkaban project and terminal equipment | |
| CN115374384B (en) | Information publishing method and device based on big data analysis | |
| CN113626388A (en) | Method and device for displaying topological relation of project file |
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 |