CN110765750B - Report data input method and terminal equipment - Google Patents
Report data input method and terminal equipment Download PDFInfo
- Publication number
- CN110765750B CN110765750B CN201910871485.4A CN201910871485A CN110765750B CN 110765750 B CN110765750 B CN 110765750B CN 201910871485 A CN201910871485 A CN 201910871485A CN 110765750 B CN110765750 B CN 110765750B
- Authority
- CN
- China
- Prior art keywords
- data
- template
- report
- identifier
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000012216 screening Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 16
- 238000013479 data entry Methods 0.000 claims description 13
- 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 7
- 238000012545 processing Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000001914 filtration Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development 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
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 applicable to the technical field of computer application, and provides a report data input method, terminal equipment and a computer readable storage medium, comprising the following steps: acquiring business data of a report to be recorded and a data identifier of the business data; searching a data reading template corresponding to the data identifier 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 business component model, generating annotation configuration and a form data reading template according to the data attribute, and finally inputting form data according to the data reading template, thereby simplifying the intermediate links of data inputting and improving the efficiency and accuracy of data inputting.
Description
Technical Field
The invention belongs to the technical field of computer application, and particularly relates to a report data input method, terminal equipment and a computer readable storage medium.
Background
The report forms dynamically display data in forms such as tables, charts and the like, and consist of various formats and dynamic data. The report content is displayed in a tiled mode according to the sequence of the table heads, so that detailed information can be conveniently checked. The general underlying information table may be embodied in tabular form. The system is used for displaying documents such as customer lists, product lists, object lists, orders, invoice and the like or working records of the same day, and data with a relatively small number of records such as sales records of the same day. In a reporting system, each report often means a set of things to be 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 as to read the data through a storage reading module of the service bean. The method has the defects that the definition of data is excessive, the expansion is troublesome, the later maintenance is not friendly, the intermediate links are more, and the problem of low efficiency is easy to occur.
Disclosure of Invention
In view of the above, the embodiment of the invention provides a report data input method, terminal equipment and a computer readable storage medium, so as to solve the problem that the prior art is easy to have low efficiency when inputting report data.
A first aspect of the embodiment of the invention provides a report data input method, which comprises 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 identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated;
and recording the business data according to the data reading template, and generating a report of the business data.
A second aspect of an embodiment of the present invention provides a terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing 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 identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated;
and recording the business data according to the data reading template, and generating 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 business data of the report to be recorded and a data identifier of the business data;
the searching unit is used for searching the data reading template corresponding to the data identifier 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 service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated;
and the report unit is used for inputting the service data according to the data reading template and generating a report of the service data.
A fourth aspect of an embodiment of the invention provides a computer readable storage medium storing 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 beneficial effects that:
according to the embodiment of the invention, the business data of the report to be recorded and the data identification of the business data are obtained; searching a data reading template corresponding to the data identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a table is generated; and recording the business data according to the data reading template, and generating a report of the business data. According to the method, the corresponding data attribute of the data identifier is determined according to the corresponding relation between the preset data identifier and the data attribute of the preset business component model, annotation configuration and a form data reading template are generated according to the data attribute, and finally form data is recorded according to the data reading template, so that the intermediate link of data recording is simplified, and the efficiency and the accuracy of data recording are improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
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 the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present 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 illustrate the technical scheme of the invention, the following description is made by 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. In this embodiment, the execution body of the report data entry method is a terminal. The terminal comprises, but is not limited to, a mobile terminal such as a smart phone, a tablet computer, a wearable device and the like, and can also be a desktop computer and the like. The report data entry method as shown in the figure can include the following steps:
s101: and acquiring service data of the report to be recorded and a data identifier of the service data.
The report forms dynamically display data in forms such as tables, charts and the like, and consist of various formats and dynamic data. The report content is displayed in a tiled mode according to the sequence of the table heads, so that detailed information can be conveniently checked. The general underlying information table may be embodied in tabular form. The system is used for displaying documents such as customer lists, product lists, object lists, orders, invoice and the like or working records of the same day, and data with a relatively small number of records such as sales records of the same day. In a reporting system, each report often means a set of things to be defined.
Various application systems in practical application comprise various system services, wherein each system service corresponds to different functions, and in the process of realizing the functions according to the system services, a lot of service data can be generated. However, these business data are scattered and disordered data, so before the data are analyzed, mined and the like, the data need to be normalized, that is, a report containing complete business data and representing clear business data is obtained.
When the service system is developed, the service data of the report to be recorded is acquired before the service data is processed because the service data in the service system is numerous and miscellaneous. The service data in this embodiment may be result data 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 data may be operation data generated by testing a development object of the application system, may be data of a computer device operation, or may be user application data of an application program or a network, which is not limited herein. The form of the service data obtained in this embodiment may be in the form of an extensible markup language (Extensible Markup Language, XML) or a structured query language (Structured Query Language, SQL) file, which is not limited herein. In addition to the data identifier in this embodiment being used to represent the data name of the service data, the data information that may be carried by each service data includes the data generation time, the data type, and the normal numerical range corresponding to the service data, where the data identifier of the table data in this embodiment may be in the form of a data name or a data number, which is not limited herein.
Meanwhile, the mode of acquiring the service data in the embodiment may be a mode of acquiring the data in the service system in real time, the mode of acquiring the data in real time may be realized by burying points in the service system, or the data may be crawled by a web crawler, which is not limited herein, or the mode of acquiring the service data manually may be adopted, and after the service data is acquired, the corresponding service data may be screened out from all the service data according to the conditions of data identification, generation time and the like of the service data according to the requirement of a user.
S102: searching a data reading template corresponding to the data identifier from a preset template library.
In this embodiment, a template library is preset, which includes data reading templates corresponding to various data identifiers. And each data reading template in the template library corresponds to the data identification. Since the data reading template can comprise various data types or data corresponding to the data identification, the corresponding business data comprises various data. Therefore, in order to more accurately represent the association correspondence between one data reading template and service data, in this embodiment, a plurality of data identifiers are corresponding to one data reading template, 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 searching the data reading templates corresponding to the data identifiers from the preset template library, searching the data reading templates corresponding to all the data identifiers from the template library according to all the data identifiers in the service data so as to ensure the accuracy of the query of the data reading templates. In addition, in order to improve the success rate of the query of the data reading templates, a preset number of important data identifiers in the service data can be determined, the corresponding data reading templates are searched in the template library according to the important data identifiers, the corresponding data reading templates are searched according to the important data identifiers, so that the success rate of the query of the data reading templates is improved, the important data identifiers are ensured to have the corresponding data reading templates, and a report containing important data can be generated. Specifically, when determining the important data identifiers in this embodiment, the importance degree of one data identifier may be measured according to a preset weight value of service data, so as to determine a preset number of important data identifiers, so as to determine a data reading template corresponding to the important data identifiers.
S103: 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.
If the data reading template corresponding to the data identifier is not found in the template library, the fact that the data reading template is not provided for the service data corresponding to the current data identifier in the current template library is indicated, and therefore the data reading template needs to be built according to the data identifier.
The business component model in this embodiment may be a business Bean model, where a business Bean in the business Bean model includes information to be displayed by each report, the relationship between the business Bean and each report is in one-to-one correspondence, and one report corresponds to a worksheet label Sheet of Excel and also corresponds to one business 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, which is not limited herein.
In this embodiment, according to the data attribute of the preset service component model and all the data identifiers generated in the service system, the corresponding relationship between the data identifiers and the data attributes is pre-constructed. 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 service 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 determining the data attribute corresponding to the data identifier, 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 the corresponding logic between the data attributes and the report, and generate annotation configuration information of the business data reading template according to the corresponding logic between each data attribute and the report. The annotation configuration information in this embodiment is used to determine the display attribute of the business data in the report, which may include a display position, a display style, or a table identifier corresponding to the business data in the table, which is not limited herein.
When the service data reading template is generated, the annotation configuration information is imported into a preset template engine to generate an XML file in the form of a report generation tool JXLS of the service data, and the XML file is the service data reading template of the embodiment. The template engine of this embodiment is based on a data reading template and service data to be entered, and is used to generate an output text, that is, a data reading template corresponding to the service data, and the template engine of this embodiment may be a freemaker template engine, which is not limited herein.
S105: and recording the business data according to the data reading template, and generating a report of the business data.
After the data reading template is generated, the business data is input into the data reading template, and a report of the business data is generated. Specifically, the data reading template in this embodiment already includes data attributes or data logic corresponding to each template position, that is, annotating configuration information, and after obtaining the data reading template, according to the configuration information of the host computer of the data reading template, inputting the service data to 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 obtained; searching a data reading template corresponding to the data identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a table is generated; and recording the business data according to the data reading template, and generating a report of the business data. According to the method, the corresponding data attribute of the data identifier is determined according to the corresponding relation between the preset data identifier and the data attribute of the preset business component model, annotation configuration and a form data reading template are generated according to the data attribute, and finally form data is recorded according to the data reading template, so that the intermediate link of data recording is simplified, and the efficiency and the accuracy of data recording 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. In this embodiment, the execution body of the report data entry method is a terminal. The terminal comprises, but is not limited to, a mobile terminal such as a smart phone, a tablet computer, a wearable device and the like, and can also be a desktop computer and the like. The report data entry method as shown in the figure can include the following steps:
s201: and acquiring service data of the report to be recorded and a data identifier of the service data.
In this embodiment, the implementation manner of S201 is identical to that of S101 in the embodiment corresponding to fig. 1, and specific reference may be made to the description related to S101 in the embodiment corresponding to fig. 1, which is not repeated here.
S202: searching a data reading template corresponding to the data identifier from a preset template library.
Before generating the report of the service data, the report of the history service data is generated first, and the method for generating the report of the history service data is the same as the method in the first embodiment, except that when generating the report of the history service data, a data reading template generated according to the history service data may be stored in a preset template library, and a specific storage mode may be stored according to a data identifier of the history service data, for example, a storage identifier is generated according to the history service data, and then the data reading template corresponding to the history service data and the storage identifier are stored in the template library in an associated manner.
When generating a report according to the business data, firstly, inquiring in a template library. And inquiring whether a data reading template corresponding to the data identifier of the service data is stored in the template library. The query mode can be that a search identifier corresponding to a storage identifier is generated according to the data identifier, and then whether a data reading template corresponding to the search identifier exists is searched in a template library. The generation mode of the search identifier is the same as that of the storage identifier.
S203: and if the data reading templates corresponding to the data identifiers are stored in the template library, recording the service data according to the data reading templates corresponding to the data identifiers.
When searching the data reading template corresponding to the data identifier from the template library, if the data reading template corresponding to the data identifier is stored in the template library, the data reading template corresponding to the current data identifier is indicated to exist in the template library, and the service 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 logic corresponding to each template position, that is, annotating configuration information, and after obtaining the data reading template, according to the configuration information of the host computer of the data reading template, inputting the service data to the corresponding position in the data reading template, so as to obtain a report of the service data.
S204: 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.
In this embodiment, step S204 and step S203 are executed in parallel, alternatively, in this embodiment, the implementation manner of S204 is identical to that of S103 in the embodiment corresponding to fig. 1, and specific reference may be made to the description related to S103 in the embodiment corresponding to fig. 1, which is not repeated here.
S205: generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating 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.
After the data attribute corresponding to the business data is determined, the corresponding relation between the data attribute and the report is extracted to be used as annotation configuration information. And embedding the annotation configuration information into a preset blank 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, which 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 corresponding style of each data attribute and the logic association relation among the data attributes.
And after determining the data attribute corresponding to the data identifier, 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 the corresponding logic between the data attributes and the report, and generate annotation configuration information of the business data reading template according to the corresponding logic between each data attribute and the report. The annotation configuration information in this embodiment is used to determine the display attribute of the business data in the report, which may include a display position, a display style, or a table identifier corresponding to the business data in the table, 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 service data.
When the service data reading template is generated, the annotation configuration information is imported into a preset template engine to generate an XML file in a JXLS form of the service data, and the XML file is the service data reading template of the embodiment. The template engine of the embodiment is used for generating an output text based on the data reading template and the business data of the report to be recorded, namely the data reading template corresponding to the business data.
Specifically, when generating XML of JXLS of the service=data, JXLS is used to create all data reading templates with correct formats, and then places where table data corresponding to each data identifier should be placed are specified, so that JXLS can create extremely complex Excel report forms by using only a few lines of codes compared with other modes. Only a specific tag is needed to create an xls template file with all required rules of format, formula, macro, etc., and specify the location where the data is placed, and then write lines of code to call the JXLS engine to pass the xls template and the exported data as parameters. In addition to generating Excel report functions, JXLS also provides a JXLS-reader module if it is necessary to parse an Excel file in a predefined format and insert data therein. The report parsing tool JXLS-reader can describe parsing rules 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, which is a type of template engine: and generating and outputting a data reading template based on the template and the business data of the report to be recorded. It is not end user oriented, but rather a Java class library, a component that programmers can embed in their developed products. When processing data according to the Freemarker template engine, the annotation configuration information is firstly imported 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.
After the data reading template of the service data is generated, a storage identifier is generated according to the data identifier of the service data, so that the data reading template is stored according to the storage identifier. Specifically, when the storage identifier is generated, all the data identifiers can be combined according to a certain sequence to obtain the storage identifier; the important identification with a certain data volume can be selected from the data volume to be combined to obtain a storage identification; in addition, the combined mark can be further thinned to obtain a storage mark with smaller data, so that the data comparison time cost in the query process is reduced, and the data reading template query efficiency is improved.
It should be noted that, the combination in the above scheme may be performed by directly connecting the characters of all the data identifiers. The selecting the important data identifier may be determining the weight corresponding to each data identifier according to the preset weight of each service data, and identifying the data identifier with 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 identification is obtained, the data reading template and the storage identification are stored in a template library in an associated mode, so that when business data are processed later, the corresponding data reading template can be determined in the template library directly according to the data identification of the business data.
When generating a report according to the business data, firstly, inquiring in a template library. And inquiring whether a data reading template corresponding to the data identifier of the service data is stored in the template library. The query mode can be that a search identifier corresponding to a storage identifier is generated according to the data identifier, and then whether a data reading template corresponding to the search identifier exists is searched in a template library. The generation mode of the search identifier is the same as that of the storage identifier.
S206: and recording the business data according to the data reading template, and generating a report of the business data.
After the data reading template is generated, the business data is input into the data reading template, and a report of the business data is generated. Specifically, the data reading template in this embodiment already includes data attributes or data logic corresponding to each template position, that is, annotating configuration information, and after obtaining the data reading template, according to the configuration information of the host computer of the data reading template, inputting the service data to 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 screening conditions preset for the service data.
Furthermore, considering that the data processing efficiency is affected when more data in the table is provided, the management of the table data can be performed through the filter, and the condition for screening the table data is set when the report is set. The system may provide two different filter management for query scope reduction. Specifically, when customizing a report, the filter is set by conditions equal to, unequal to, including, and within a list customized by a user. When the report is generated, the user fills in the filtering range on site, so that the elasticity of the report is improved.
In practical application, the service system generates various types of service data at various moments, so that redundant data, repeated data or unimportant data inevitably occur, and in consideration of the situation, the embodiment presets screening conditions for screening the service data to obtain target data with smaller redundancy. The filtering condition may be a data identifier, a data threshold, a data generation time, a data merging condition, or the like, and the data merging condition is used to indicate that the service data meeting the conditions is merged, which is not limited herein.
S2062: and selecting target data to be input into the report form from the service data according to the screening conditions.
After the screening conditions are obtained, selecting target data of the report to be recorded in the service data according to the screening conditions. For example, when the screening condition is certain data identifications, screening service data corresponding to the data identifications as target data; when the screening condition is a data threshold, screening service data with the data size meeting the data threshold as target data; when the screening condition is the 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, service data meeting the data merging condition is screened out, and then data merging is performed according to a preset merging mode, wherein the merging mode can be addition or multiplication of data values, or can be a mode of merging corresponding service data and placing the same report unit, and the method is not limited herein.
S2063: and inputting the target data according to the data reading template, and generating the report.
After the target data is determined, the target data is input into a data reading template, and a report of the target data is generated. In this embodiment, after the service 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 input into the data reading template first, and then manually adjusted at a place where the target data does not correspond to the data reading template, so as to obtain the final report.
According to the scheme, the business data of the report to be recorded and the data identification of the business data are obtained; searching a data reading template corresponding to the data identifier from a preset template library; and if the data reading templates corresponding to the data identifiers are stored in the template library, recording the service data according to the data reading templates corresponding to the data identifiers. 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated; and recording the business data according to the data reading template, and generating a report of the business data. According to the method, the corresponding data attribute of the data identifier is determined according to the corresponding relation between the preset data identifier and the data attribute of the preset business component model, annotation configuration and a form data reading template are generated according to the data attribute, and finally form data is recorded according to the data reading template, so that the intermediate link of data recording is simplified, and the efficiency and the accuracy of data recording 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 2. Refer specifically to the related descriptions in the respective embodiments of 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 recorded, and a data identifier of the service data;
the searching unit 302 is configured to search a data reading template corresponding to the data identifier from a preset template library;
the attribute unit 303 is configured to determine, if the 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 a report is generated;
and the report unit 305 is used for inputting the service data according to the data reading template and generating a report of the service data.
Further, the template unit 304 specifically includes:
the configuration unit is used for converting the data attribute corresponding to the data identifier into the annotation configuration information according to a preset data attribute configuration strategy;
and the importing unit is used for importing the annotation configuration information into a preset template engine and generating a data reading template of the service 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 identification.
Further, the terminal device 300 further includes:
and if the data reading templates corresponding to the data identifiers are stored in the template library, recording the service data according to the data reading templates corresponding to the data identifiers.
Further, the report unit 305 includes:
a condition acquisition unit, configured to acquire a screening condition preset for the service data;
the target screening unit is used for selecting target data to be input into the report form from the service data according to the screening conditions;
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 obtained; searching a data reading template corresponding to the data identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a table is generated; and recording the business data according to the data reading template, and generating a report of the business data. According to the method, the corresponding data attribute of the data identifier is determined according to the corresponding relation between the preset data identifier and the data attribute of the preset business component model, annotation configuration and a form data reading template are generated according to the data attribute, and finally form data is recorded according to the data reading template, so that the intermediate link of data recording is simplified, and the efficiency and the accuracy of data recording 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 the memory 41 and executable on the processor 40. The processor 40, when executing the computer program 42, implements the steps of the various report data entry method embodiments described above, such as steps 101 through 105 shown in fig. 1. Alternatively, the processor 40 may perform the functions of the modules/units of the apparatus embodiments described above, such as the functions of the units 301 to 305 shown in fig. 3, when executing the computer program 42.
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 complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions for describing the execution of the computer program 42 in the terminal device 4.
The terminal device 4 may be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server, etc. The terminal device may include, but is not limited to, a processor 40, a memory 41. It will be appreciated by those skilled in the art that fig. 4 is merely an example of the terminal device 4 and does not constitute a limitation of the terminal device 4, and may include more or less components than illustrated, or may combine certain components, or different components, e.g., the terminal device may further include an input-output device, a network access device, a bus, etc.
The processor 40 may be a central processing unit (Central Processing Unit, CPU), other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. 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 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), or the like, which are 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 as well as other programs and data required by the terminal device. The memory 41 may also be used for temporarily storing 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-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions. The functional units and modules in the embodiment may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit, where the integrated units may be implemented in a form of hardware or a form of a 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 process of the units and modules in the above system may refer to the corresponding process in the foregoing method embodiment, which is not described herein again.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and in part, not described or illustrated in any particular embodiment, reference is made to the related descriptions of other embodiments.
The units described as separate units may or may not be physically separate, and units shown 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 may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
The integrated modules/units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the present invention may implement all or part of the flow of the method of the above embodiment, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. A report data entry method, comprising:
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 identifier 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 annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated, and the annotation configuration information is used for determining display attributes of the business data in the report;
recording the business data according to the data reading template, and generating a report of the business data;
generating annotation configuration information according to the data attribute corresponding to the data identifier, and generating a service data reading template according to the annotation configuration information, wherein the method comprises the following steps:
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 service data.
2. The report data entry method of claim 1, wherein after generating annotation configuration information according to the data attribute corresponding to the data identifier and generating a service 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.
3. The report data entry method of claim 1, wherein after searching the data reading template corresponding to the data identifier from the preset template library, the method further comprises:
and if the data reading templates corresponding to the data identifiers are stored in the template library, recording the service data according to the data reading templates corresponding to the data identifiers.
4. A report data entry method as claimed in any one of claims 1 to 3, wherein said entering said business data from said data reading template to generate a report of said business data comprises:
acquiring screening conditions preset for the service data;
selecting target data to be input into the report form from the service data according to the screening conditions;
and inputting the target data according to the data reading template, and generating the report.
5. Terminal device comprising a memory and a processor, the memory storing a computer program executable on the processor, characterized in that the processor, when executing the computer program, implements the steps of the method according to any of claims 1-4.
6. A terminal device, comprising:
the acquisition unit is used for acquiring business data of the report to be recorded and a data identifier of the business data;
the searching unit is used for searching the data reading template corresponding to the data identifier 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 service data reading template according to the annotation configuration information; the annotation configuration information comprises configuration information of the business data when a report is generated, and the annotation configuration information is used for determining display attributes of the business data in the report;
the report unit is used for inputting the service data according to the data reading template and generating a report of the service data;
the template unit specifically comprises:
the configuration unit is used for converting the data attribute corresponding to the data identifier into the annotation configuration information according to a preset data attribute configuration strategy;
and the importing unit is used for importing the annotation configuration information into a preset template engine and generating a data reading template of the service data.
7. 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 identification.
8. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1 to 4.
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 CN110765750A (en) | 2020-02-07 |
| CN110765750B true 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) |
Families Citing this family (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 |
| CN113213206B (en) * | 2021-04-07 | 2022-02-08 | 生态环境部华南环境科学研究所 | Data intercepting device convenient for data integration |
| CN115130440B (en) * | 2022-08-23 | 2023-04-07 | 三一融资租赁有限公司 | Business data entry processing system suitable for equipment financing |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9122665B2 (en) * | 2011-10-10 | 2015-09-01 | Microsoft Technology Licensing, Llc | Rich formatting for a data label associated with a data point |
-
2019
- 2019-09-16 CN CN201910871485.4A patent/CN110765750B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110765750A (en) | 2020-02-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110765750B (en) | Report data input method and terminal equipment | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN107798030B (en) | Splitting method and device of data table | |
| CN110795524B (en) | Main data mapping processing method and device, computer equipment and storage medium | |
| CN109542966B (en) | Data fusion method and device, electronic equipment and computer readable medium | |
| CN110675238A (en) | Client label configuration method, system, readable storage medium and electronic equipment | |
| US20180121526A1 (en) | Method, apparatus, and computer-readable medium for non-structured data profiling | |
| CN109002425B (en) | Method for acquiring upstream and downstream relations of enterprise, terminal device and medium | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| US11055477B2 (en) | Evaluation device, evaluation method, and recording medium evaluating a line as a start line of a table | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN107368500B (en) | Data extraction method and system | |
| US20150169515A1 (en) | Data driven synthesizer | |
| CN114722789B (en) | Data report integrating method, device, electronic equipment and storage medium | |
| CN111553133B (en) | Report generation method and device, electronic equipment and storage medium | |
| CN112560416B (en) | Page chart generation method and device, electronic equipment and storage medium | |
| WO2018206819A1 (en) | Data storage method and apparatus | |
| CN113722296A (en) | Agricultural information processing method and device, electronic equipment and storage medium | |
| CN113434734A (en) | Method, device, equipment and storage medium for generating file and reading file | |
| CN113687827A (en) | Data list generation method, device and equipment based on widget and storage medium | |
| US9471569B1 (en) | Integrating information sources to create context-specific documents | |
| CN113434365B (en) | Data characteristic monitoring method and device, electronic equipment and storage medium | |
| US20070226042A1 (en) | Apparatus and method for improved forecasting | |
| CN117827902A (en) | Service data processing method, device, computer equipment and storage medium | |
| 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 |