CN114386374A - Method for generating odf document by using CA signature in data integration and program thereof - Google Patents

Abstract

The invention discloses a method for generating a document by dynamically synthesizing CA digital signature and data and structurally integrating the data and an implementation program thereof, which belong to the field of security processing of similar documents by computer technology. The technology can meet the safety requirement of filling and reporting the quality inspection data of the highway construction engineering, does not depend on Excel or Word and other tools, and the generated document has the advantages of friendly user interface, good typesetting effect, good platform compatibility and high safety.

Description

Method for generating odf document by using CA signature in data integration and program thereof

Technical Field

The invention relates to a method and a program for integrating data from different sources according to a certain rule, performing digital authentication through a CA technology and automatically generating a document embedded with a digital signature, belonging to the field of document processing by using a computer technology.

Background

At present, data electronization is deeply applied to various industries, one of the following application directions is visualization and security of electronic data, an online visualization WEB mode form, an offline visualization (excel non-signature mode) and the like are common, for example, in the field of a business form, some text input boxes need to be generated in a WEB page, when more data exist, the form is pulled to be longer, the form is not intuitive and complicated to operate when being filled and reported in a manual mode, the form cannot be integrally copied and pasted, and no safe digital verification exists; secondly, a static Excel template is customized (when a document contains a statistical chart, Office components such as Excel and the like are required to be combined), and the document is copied and pasted in a manual mode to generate a final document, so that the problems of low working efficiency, high error rate and complicated calculation in the EXCE are mainly existed, and structured storage cannot be realized; the third way is to use a programming interface to operate the office (including word/excel) template, and since Microsoft only opens part of the interface of the office document, the complexity of the scheme is high, the compatibility of the generated document is poor, the typesetting effect is also poor, once the format of the document is fixed, the secondary adjustment is very difficult; the fourth method adopts an excel development interface to generate a document, although pdf is a completely open standard, the difficulty of development through API is still high, and the disadvantage of this method is consistent with the third method. Aiming at the defects of the scheme, the scheme adopts the CA technology as the core, and odf document templates are processed by a program to replace the traditional form, so that the safe document which can be stored in a structured mode and has high quality is generated. odf template is a highly available and expandable template, covering characters, two-dimensional tables, mathematical formulas, static pictures, vector pictures, statistical charts and other elements, and simultaneously setting CA safety data authentication signature in the template, the CA digital authentication is integrated into odf document after digital signature by means of a digital authentication center, so as to realize exporting highly complex and highly flexible document format into corresponding document code; by using an ODF standard protocol and adopting open source software such as library, odftool and the like, the interface is completely open, the use cost is low, and the learning cost is relatively low; meanwhile, the odf document is operated by a computer program, compared with an API (application programming interface) mode, the method is simpler and is convenient for manual operation, the document format and the document structure are easier to adjust, a large-scale document can be split into a plurality of small documents to be edited respectively, and finally the small documents are assembled, so that the working efficiency can be improved; in addition, the library office has cross-platform capability, and is specifically realized on mainstream operating systems (Windows, IOS, Linux and Unix), wherein related open source software can be developed for the second time, and the high-level requirements of customization are met.

Disclosure of Invention

The technical problems to be solved by the invention include:

the CA technology is applied to engineering: dynamic synthesis of template data, a data structuring function and checking of CA signature information are carried out, and the problem of data security is solved;

odf document template definition: odf, the template contains static content and dynamic content, usually written manually, and after debugging, the variable data part is replaced by placeholder and configuration file, which relates to the problem of how to design and accurately position the placeholder, configuration file and CA signature position;

dynamic data acquisition: the data sources comprise a third-party application program which obtains data from a relational database, a manually written excel-like file, a data service center and a scientific computing and data analysis language, and a big data platform, and different data fetching programs are adapted for different data sources;

odf document template insertion: adopting placeholder analysis, generating placeholder optional parameters according to the standard of placeholder syntax, and accurately inserting odf the obtained data into the document template, thereby forming odf document example;

the efficiency is low: aiming at the problem of low efficiency, the idea of separating data and documents is mainly adopted, the data can be concurrently executed during data acquisition, and the data is firstly loaded into a memory during data integration, then placeholder analysis and data integration are uniformly carried out, and meanwhile, non-structural data backup is saved;

the maintenance difficulty and the cost are high: the unified configuration file is adopted, the format of the configuration file is simple, and the configuration items support Chinese as much as possible, so that the aims of reducing the maintenance difficulty and the cost are fulfilled;

in order to solve the above technical problems, the present invention provides a method and a program for generating a high-quality and high-security document by manipulating odf a document template through a program, which is centered on a CA technology. A set of security documents for describing and solving multi-field forms is defined, the odf template-to-placeholder grammar adopts partial ASCII punctuation marks, letters, numbers, Chinese characters, formulas and pictures, the data element format can be accurately defined, the placeholder cannot be confused with own macro commands and characters to cause parsing errors, and the placeholder mainly comprises three parts:

the placeholder type identification code and the data file identification code are adopted to identify which type of placeholder is and from which data file the placeholder is taken, wherein the placeholder type identification code is identified by letters, and the data file identification code can be identified by any combination of Chinese characters, letters and numbers;

and defining an access range, an access direction and a data format by using the selection parameters. By analyzing odf the characteristics of the template document, the two-dimensional data can specify its specific location range in the data file, such as M1 row N1 column to M2 row N2 column, M1, M2< = M, N1, N2< = N, the location start and stop range can specify positive (from front to back) or negative (from back to front), the number fetch direction is totally 8: from last to down, from left to right again, from last to down earlier, from right to left again, from down to up earlier, from left to right again, from down to up from down to left earlier, from left to right earlier, from right to down again, from right to left earlier, from down to down earlier, from down to up earlier again, from left to right again, from down to up earlier, from right to left again, can appoint between element separator, element surround, the last separator in line, the separator between the line, empty value replacement symbol. Data acquisition is completed through an independently developed access program, which is developed respectively corresponding to different data sources and can be adapted to the data sources: and various data sources such as a microsoft sql server, mysql, oracle and the like. According to the definition of a placeholder, inserting odf data elements into a template to form a odf instance, loading a data file into a memory, taking a data file identifier as a key and a two-dimensional array of M x N as a value to form a key-value mapping structure to facilitate program access, adopting a regular expression to analyze the syntax of the placeholder, and filling data completely according to the format requirement of the placeholder definition. The CA digital verification adopts an asymmetric encryption algorithm to bind a public key and an entity, a CA center makes information of the entity and the public key of the entity into a digital certificate, each document has trace information, who creates each link document, what contents are filled in each link document, and when the link document passes the auditing of departments, those persons carry out auditing, auditing opinions and other series of information, and the signature is accurately positioned in the corresponding position of the odf template. And automatically or manually compiling the generated code by using a program to form the object-class ODF document.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and the embodiments are only a part of the embodiments of the present invention, rather than all embodiments, and all other embodiments obtained by a person of ordinary skill in the art without making innovative efforts based on the embodiments of the present invention belong to the protection scope of the present invention. Referring to fig. 1, a method for generating a document by dynamically synthesizing a CA digital signature with data and integrating the data in a structured manner and an implementation procedure thereof specifically include the following steps:

independently developing a dynamic form program which can realize user-defined query and support the dynamic synthesis and the self-structuralization of data of concurrent operation, wherein the format of the generated data file can customize a character set, a separator, a formatted text or a number;

designing a placeholder to meet the requirements of elements such as a two-dimensional table, a static picture, a formula and the like in a document;

analyzing the corresponding placeholder syntax to find out the data elements, realizing CA electronic signature through a CA authentication center, and writing the data elements into odf files according to a placeholder specified format;

the generated code is automatically or manually compiled by the platform to form an object odf document, so that form filling and calculation of user visualization and electronic signature in business circulation are realized, and the manual workload is reduced. A project needs to extract data from a business system database every month to generate a large number of data documents, the related data items are thousands, the generated form documents are about hundreds, system forms are adopted for filling in the past, batch copying and pasting cannot be achieved in practical use, structured query statistics cannot be achieved, signatures cannot be visually checked, the problem that templates are low in efficiency and difficult to adjust exists, after the new scheme is adopted, the data acquisition process can be completed within 5 minutes, document signature circulation can be completed within 1-2 minutes, and after a final odf document is compiled, 1-2 persons can conduct auditing and adjusting.

Drawings

FIG. 1 is a diagram of a method for dynamically synthesizing CA digital signature and data, and integrating data structure to generate document and its implementation procedure.

Claims (2)

1. A method for generating document by dynamic synthesis and data structuring integration of CA digital signature and data and its realizing program are characterized in that:

the design of the ODF standard protocol document is mainly to embed the document into a system to replace various input boxes of the traditional form filling field;

the design of elements in the template mainly abstracts the elements in the document into zero dimension, one dimension and two dimensions according to the repetition rule of the elements, but not abstracts the elements according to the physical types of the elements;

the elements repeated in first-after-column or first-after-row correspond to two-dimensional elements, i.e. the elements in each row or each column have a similarity A, and the elements in each column or each row have a similarity B;

performing digital authentication with an electronic authentication center, adopting a UKEY signature, and positioning the electronic signature in a template;

the document template with the odf format is created to contain static characters and element placeholders, the syntactic design of the element placeholders meets the data filling requirement, the document generated by the placeholder design can realize corresponding elements in a two-dimensional table, and finally the information of the digital signature can be displayed in the document.

2. The template creation method of claim 1, wherein the data referenced by the template is loosely coupled to the s-template itself, and the data source comprises:

obtaining data from a relational database;

manually editing odf the file;

acquiring related data from a data service center;

and acquiring related data from the big data platform.

Images