Methods, systems, and media for generating design final documents with signatures and seals in the engineering industry

By identifying and extracting the signature area of ​​engineering design documents, generating a signature location index, and combining professional qualification verification and electronic seals, the problem of unified standardization of signing and sealing of engineering design documents is solved, achieving efficient and compliant signature and sealing processing.

CN123070864APending Publication Date: 2026-11-10SINOPEC NINGBO ENG +2
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202611091054.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2026-07-22
Publication Date
2026-11-10

AI Technical Summary

Technical Problem

The existing methods for signing and stamping engineering design documents are difficult to standardize, resulting in low efficiency, high risk of errors, and failure to meet the legal compliance requirements of the engineering industry.

Method used

By receiving project approval tasks, identifying design document formats, detecting drawing signature areas, extracting structured information from drawing signatures, generating a signature location index, and signing and stamping according to preset workflow rules, the system achieves accurate positioning using adaptive coordinate algorithms and drawing signature template libraries. Combined with professional qualification verification and electronic seals, it generates visual signatures and tamper-proof marks.

Benefits of technology

It enables automated signing of documents in different formats, improves the efficiency and accuracy of signing and stamping, ensures the compliance and legal validity of the signing process, and supports automated processing of large batches of documents.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN123070864A_ABST
    Figure CN123070864A_ABST
Patent Text Reader

Abstract

This invention relates to a method, system, and medium for generating signed and stamped design documents in the engineering industry. It involves acquiring the set of design documents to be processed corresponding to the project's review and approval tasks, along with the configuration information of the reviewers. The method identifies the format type of the design documents, detects the signature area of ​​the design documents, extracts the structured information and signature position of the signatures, generates a signature position index, and uniformly converts the design documents to PDF format. It then sequentially triggers the signing task for each reviewer's corresponding role. When the professional qualification certificate is valid and matches the current signing role, a visual signature is generated at the corresponding coordinates of the design document's signature field, and the digital signature is embedded into the design document. After all reviewers have completed their signatures, an electronic seal of the organization's qualification is generated at the preset coordinates of the design document's stamp field, outputting a signed and stamped design document. This satisfies the signing requirements of different document formats and achieves accurate positioning of the signature area.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of engineering design, and in particular to a method, system, and medium for generating signed and stamped design finished documents in the engineering industry. Background Technology

[0002] In the engineering industry, the signing and stamping of finished design drawings is a crucial step in ensuring the authority and legal validity of documents. Traditional signing and stamping methods rely primarily on offline operations using paper documents. This method is not only time-consuming and labor-intensive, but also prone to problems such as document loss, damage, or alteration, seriously affecting the security and reliability of business processes.

[0003] With the popularization of digital technology, more and more engineering companies are starting to use electronic means for signing and stamping to improve work efficiency, reduce operating costs, and enhance the security of document management.

[0004] However, the existing methods for signing and stamping finished design drawings have shortcomings: Firstly, due to the diverse formats of engineering design documents (such as PDF, DWG, WORD, EXCEL, etc.), the layout and content of different document formats vary significantly, making it difficult to standardize the signature and seal placement on engineering design documents. In practice, the industry generally relies on designers manually defining the signature and seal placement and using methods such as Ukey for system signing. However, this method is inefficient and costly. Although some companies use online systems for signing, the significant differences in document formats and versions often result in inaccurate signature and seal placement, increasing the risk of signing and sealing errors. Secondly, the inability to accurately locate the signature and seal positions can easily lead to misalignment or omissions, increasing the risk of errors in the design and review process. Summary of the Invention

[0005] The first technical problem to be solved by the present invention is to provide a method for generating finished design documents for engineering industry signature and seal that is accurate and secure in terms of positioning, in contrast to the above-mentioned prior art.

[0006] The second technical problem to be solved by the present invention is to provide an engineering industry signature and seal design final document generation system that can realize the above-mentioned engineering industry signature and seal design final document generation method.

[0007] The third technical problem to be solved by the present invention is to provide a readable storage medium that can realize the above-mentioned method for generating design finished documents with signatures and seals in the engineering industry.

[0008] The technical solution adopted by this invention to solve the first technical problem is: a method for generating finished design documents with signatures and seals in the engineering industry, characterized by including the following steps: Step 1: Receive the project approval task and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the project approval task; the configuration information of the approval personnel includes the role type, identity identifier and professional qualification certificate information of each approval personnel. Step 2: Perform file format identification on each design file in the set of design files to be processed to obtain the file format type of each design file to be processed; Step 3: Based on the identified file format type of each design file to be processed, perform the file processing operation corresponding to the file format type. Step 4: Detect the title block area of ​​each design file in the set of design files to be processed, and obtain the title block area of ​​each design file; Step 5: Based on the standard signature templates in the pre-built signature template library, perform signature template matching on the signature area of ​​each design file to extract the signature structure information of each design file; wherein, the signature structure information includes the coordinate range of each signature field, the signer role type corresponding to each signature field, and the drawing size specification of each signature field; Step 6: Based on the file format type of each identified design file, extract the signature position in each design file using an adaptive coordinate method; Step 7: Based on the structured information of the title block of each design document and the obtained configuration information of the signatory personnel, establish a coordinate mapping relationship between the signatory personnel and the signature column position in the design document, and generate a signature position index containing the signature coordinates and stamp coordinates of each signatory personnel. Step 8: Convert all the finished design files in the set of design files to be processed into PDF format and upload them to the document server. Step 9: Based on the preset project signing workflow rules, trigger the signing tasks of each signatory's corresponding role in sequence; Step 10: For each task to be signed, verify the validity of the professional qualification certificate of the current signatory and perform matching processing between the professional qualification certificate and the current signing role. If the professional qualification certificate is valid and matches the current signing role, the professional qualification verification is deemed successful, and the process proceeds to step 11; otherwise, the corresponding handling measures for unverified professional qualifications are implemented. Step 11: Construct a signature data package and generate a digital signature containing the professional qualification information of the signatory and reviewer, and generate a visual signature identifier at the coordinates of the signature column of the corresponding design document according to the signature position index. Step 12: Embed the generated digital signature into the corresponding design file as an annotation object, and set an anti-tampering protection flag for the annotation object; Step 13: After all reviewers have completed their digital signatures on the design documents, generate an electronic seal of the organization's qualification at the preset seal column coordinates of the design documents, associate the electronic seal of the organization's qualification with the signature dictionary, and output the finished design document with the signature and seal.

[0009] Improvedly, in the method for generating finished design documents with signatures and seals in the engineering industry, in step 2, the file format type is one of PDF, DWG, WORD, and EXCEL.

[0010] Furthermore, in the method for generating finished design documents with signatures and seals in the engineering industry, in step 3, the file processing operation settings corresponding to the file format type are as follows: For DWG format files, perform drawing frame recognition and standardization processing: identify the drawing frame size in the design file to be processed and determine whether the drawing frame size is a standard A-series drawing frame; for non-standard extended drawing frames, determine whether they conform to the standard according to preset extension rules; The lengthening rules are set as follows: The length of the extended drawing frame = the original standard length of the drawing frame + n × the incremental length, where n is a non-negative integer; the length of the extended drawing frame is 841mm + n × 210mm for A1, 594mm + n × 105mm for A2, and 420mm + n × 210mm for A3.

[0011] Further improvements are made to the method for generating finished design documents with signatures and seals in the engineering industry. In step 6, for WORD documents, signature coordinates are extracted using predefined tags; for EXCEL files, a name manager is used to preset names in specific cells of the design file to obtain coordinate information; for DWG files, the lower right corner of the design file is used as the reference point, and the final position of the signature is calculated based on the relative position offset.

[0012] Improvedly, in the method for generating finished design documents with signatures and seals in the engineering industry, in step 9, the preset engineering signing workflow sets the signing order as: designer → checker → reviewer → approver; in step 11, the signature data packet is set to include a hash digest of the design document to be signed, the professional qualification certificate serial number of the signer and reviewer, the signing timestamp, and the engineering project number corresponding to the engineering project signing and review task.

[0013] Further improvements are made to the method for generating signed and stamped design finished documents in the engineering industry, which, after step 13, further includes: generating a signature and review record for each signed and stamped design finished document; wherein the signature and review record includes the role type, professional qualification certificate number, signing timestamp, and hash digest of the signing behavior of each signatory.

[0014] In a further improvement, the method for generating design final documents with signatures and seals in the engineering industry includes the following steps in constructing the signature template library: Collect standard drawing templates for the engineering industry; among them, the drawing templates cover the specifications of various engineering drawing frames as stipulated in GB / T 51027 "Standard for General Layout Drawing of Petrochemical Enterprises" and relevant industry specifications. For each image sample, corner points are detected and key lines are extracted to construct an image skeleton model; The relative coordinates of each signature field and the corresponding role type in the signature skeleton model are labeled to form a structured signature template; The title templates are categorized and stored according to project type and drawing size, resulting in a title template library with a multi-dimensional template retrieval mechanism.

[0015] Furthermore, in the method for generating finished design documents with signatures and seals in the engineering industry, the process of matching the signature template for the signature area of ​​each design document based on the standard signature template in the pre-built signature template library is as follows: The detected image of the tag area is preprocessed to identify horizontal and vertical line segments on the page and locate candidate tag areas. The candidate tag region images are normalized to a uniform size to obtain normalized tag images, and the visual features of each normalized tag image are extracted. Calculate the feature similarity between the normalized image and each template in the image template library, and select the one with the highest feature similarity among all feature similarities; The system determines whether the highest similarity of the selected feature exceeds a preset similarity threshold. If a title template exceeds a preset similarity threshold, it is used as the matching template; otherwise, a manual coordinate annotation process is triggered. Based on the field coordinate information in the matching template, the template coordinates are mapped to the physical coordinates of the original design file through affine transformation, thus obtaining the absolute coordinate range of each signature field in the original design file.

[0016] The technical solution adopted by this invention to solve the second technical problem is: a system for generating finished design documents with signatures and seals in the engineering industry, which implements the method for generating finished design documents with signatures and seals in the engineering industry, characterized in that it includes: The task receiving and processing module is used to receive engineering project approval tasks and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the engineering project approval task. The file format recognition module is used to recognize the file format of each design file in the set of design files to be processed, obtain the file format type of each design file to be processed, and perform file processing operations corresponding to the file format type respectively; The label parsing module is used to detect the label area of ​​each design file in the set of design files to be processed, obtain the label area of ​​each design file, and perform label template matching on the label area of ​​each design file based on the standard label template in the pre-built label template library, and extract the label structure information of each design file respectively. The coordinate mapping module is used to extract the signature position in each design file according to the file format type of each design file using an adaptive coordinate method; and to establish a coordinate mapping relationship between the signer and the signature column position in the design file based on the structured information of the signature in each design file and the obtained configuration information of the signers and reviewers, and to generate a signature position index containing the signature coordinates and stamp coordinates of each signer and reviewer. The file conversion module is used to convert the various design files in the set of design files to PDF format and upload them to the document server. The workflow engine module is used to trigger the signing tasks of each signer's corresponding role in sequence according to the preset engineering signing workflow rules, and to monitor the completion status of each signing task in the engineering signing workflow. The qualification verification module is used to verify the validity of the professional qualification certificate of the current signatory for each task to be signed, and to match the professional qualification certificate with the current signing role. The signature generation module is used to construct a signature data package and generate a digital signature containing the professional qualification information of the signer and reviewer, and generate a visual signature identifier at the coordinates of the signature field in the corresponding design document according to the signature position index; and to embed the generated digital signature into the corresponding design document in the form of an annotation object, and set an anti-tamper protection flag for the annotation object. The seal management module is used to generate an electronic seal of the organization's qualification at the preset seal column coordinates in the design document, and to associate the electronic seal of the organization's qualification with the signature dictionary. The document output module is used to output the final design document with signature and seal.

[0017] The third technical problem to be solved by the present invention is: a readable storage medium having a computer program stored thereon, characterized in that, when the computer program is executed by a processor, it implements the method for generating engineering industry signed and stamped design finished documents as described in any one of the claims.

[0018] Compared with the prior art, the advantages of the present invention are as follows: First, the method for generating finished design documents with signatures and seals in the engineering industry, as described in this invention, obtains the set of design documents to be processed and the configuration information of the signatories corresponding to the project's signing and review tasks. Then, it identifies the file format type of each design document and performs file processing operations corresponding to that file format type. It detects the signature area of ​​each design document and extracts the structured information of the signature for each document. Based on the identified design file format type, it extracts the signature position in each design document, generates a signature position index containing the coordinates of each signatory's signature and seal, and uniformly converts all finished design documents in the set of design documents to PDF format. The document, following pre-defined engineering signing workflow rules, sequentially triggers the signing tasks of each signatory's corresponding role. When the signatory's professional qualification certificate is valid and matches the current signing role, a visual signature identifier is generated at the coordinates of the signature field in the corresponding design document based on the signature location index. The digital signature is then embedded into the corresponding design document as an annotation object, with an anti-tampering protection flag set for the annotation object. After all signatories have completed their digital signatures, an electronic seal of the organization's qualification is generated at the pre-defined seal field coordinates in the design document. This electronic seal is then associated with the signature dictionary, and the final design document with the signature and seal is output. This approach not only satisfies the signing needs of different document formats but also achieves accurate positioning of the signature area, improving signing and sealing efficiency. Secondly, the method for generating design finished documents with signatures and seals in the engineering industry can effectively support the automated signing and sealing of large batches of documents. Furthermore, through the DWG drawing frame standardization recognition and lengthening rule algorithm, it provides a mathematical standard definition for non-standard drawing frames in the engineering field, ensuring the consistency and traceability of drawing frame processing. Furthermore, the invention's method for generating finished design documents for engineering industry signatures and seals utilizes a format-specific adaptive coordinate extraction algorithm to automatically and accurately extract the coordinates for signing drawings of multiple drawing sizes, engineering types, and document formats, completely solving the problem of difficult coordinate acquisition. Through a built-in engineering approval workflow, it achieves orderly multi-role signing process control, eliminating the uncertainty of manual coordination and ensuring the compliance of the signing process. Furthermore, through professional qualification verification and signature binding mechanisms, it ensures that signed documents meet the engineering industry's compliance requirements for certified personnel's signatures, enhancing the legal validity and regulatory adaptability of the signatures. Attached Figure Description

[0019] Figure 1 This is a flowchart illustrating the method for generating finished design documents with signatures and seals in the engineering industry, as described in this embodiment of the invention. Detailed Implementation

[0020] The present invention will be further described in detail below with reference to the accompanying drawings and embodiments.

[0021] This embodiment provides a method for generating signed and stamped design finalization documents in the engineering industry. See also... Figure 1 As shown, the method for generating finished design documents with signatures and seals in the engineering industry according to this embodiment includes the following steps: Step 1: Receive the project approval task and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the project approval task; the configuration information of the approval personnel includes the role type, identity identifier and professional qualification certificate information of each approval personnel. Step 2: Identify the file format of each design file in the set of design files to be processed to obtain the file format type of each design file; for example, in this embodiment, the file format type of each design file is one of PDF, DWG, WORD and EXCEL. Step 3: Based on the identified file format type of each design file to be processed, perform the file processing operation corresponding to the file format type. Step 4: Detect the title block area of ​​each design file in the set of design files to be processed, and obtain the title block area of ​​each design file; Step 5: Based on the standard signature templates in the pre-built signature template library, perform signature template matching on the signature area of ​​each design file to extract the signature structure information of each design file; wherein, the signature structure information includes the coordinate range of each signature field, the signer role type corresponding to each signature field, and the drawing size specification of each signature field; Step 6: Based on the file format type of each identified design file, extract the signature position in each design file using an adaptive coordinate method. For example, for a Word document, extract the signature coordinates using predefined tags; for an Excel file, use the name manager to preset names in specific cells of the design file to obtain coordinate information; for a DWG file, use the lower right corner reference point of the design file as the reference and calculate the final signature position based on the relative position offset. For example, for a DWG file, the final signature position is calculated as: SignaturePosition = BasePoint + Δx + Δy, where BasePoint is the coordinate of the lower right corner of the drawing frame, and Δx and Δy are the relative position offsets.

[0022] This method, which uses adaptive coordinates to extract the signature position from each design file, provides a flexible yet consistent signature positioning solution tailored to different file formats. It adapts to content changes while ensuring high accuracy and predictability of the position. The relevant signature and stamp coordinate information is stored in JSON format. Step 7: Based on the structured information of the title block of each design document and the obtained configuration information of the signatory personnel, establish a coordinate mapping relationship between the signatory personnel and the signature column position in the design document, and generate a signature position index containing the signature coordinates and stamp coordinates of each signatory personnel. Step 8: Convert all the finished design files in the set of design files to be processed into PDF format and upload them to the document server. Step 9: Based on the preset project signing workflow rules, trigger the signing tasks of each signatory's corresponding role in sequence; Step 10: For each task to be signed, verify the validity of the professional qualification certificate of the current signatory and perform matching processing between the professional qualification certificate and the current signing role. If the professional qualification certificate is valid and matches the current signing role, the professional qualification verification is deemed successful, and the process proceeds to step 11; otherwise, the corresponding handling measures for unverified professional qualifications are implemented. Step 11: Construct a signature data packet and generate a digital signature containing the professional qualification information of the signer and reviewer, and generate a visual signature identifier at the coordinates of the signature field of the corresponding design document according to the signature position index; wherein, the signature data packet here is set to include the hash digest of the design document to be signed, the professional qualification certificate serial number of the signer and reviewer, the signature timestamp, and the project number of the project corresponding to the project signing and review task. Step 12: Embed the generated digital signature into the corresponding design file as an annotation object, and set an anti-tampering protection flag for the annotation object; Step 13: After all reviewers have completed their digital signatures on the design documents, generate an electronic seal of the organization's qualification at the preset seal column coordinates of the design documents, associate the electronic seal of the organization's qualification with the signature dictionary, and output the finished design document with the signature and seal.

[0023] Specifically, in step 3 above, the file processing operation settings corresponding to the file format type are as follows: For DWG format files, perform drawing frame recognition and standardization processing: identify the drawing frame size in the design file to be processed and determine whether the drawing frame size is a standard A-series drawing frame; for non-standard extended drawing frames, determine whether they conform to the standard according to preset extension rules; The lengthening rules are set as follows: Length of the extended drawing frame = Original standard length of the drawing frame + n × Incremental length, where n is a non-negative integer. For an A1 drawing frame, the length after extension is 841mm + n × 210mm; for an A2 drawing frame, it is 594mm + n × 105mm; and for an A3 drawing frame, it is 420mm + n × 210mm. Through these lengthening rules, the engineering industry signature and stamp design final document generation method of this embodiment can accurately identify and process the drawing frame size in DWG format files. Whether it is a standard drawing frame or a compliant extended drawing frame, it can be processed in a standardized manner, ensuring the accuracy and consistency of signature and stamp positions, and significantly improving the efficiency and reliability of the engineering design final drawing signature and stamping process.

[0024] It should be noted that in step 9 of this embodiment, the preset engineering signing workflow sets the signing order as follows: designer → checker → reviewer → approver.

[0025] Regarding step 5 above, the construction method of the title tag template library includes the following steps: Collect standard drawing templates for the engineering industry; among them, the drawing templates cover the specifications of various engineering drawing frames as stipulated in GB / T 51027 "Standard for General Layout Drawing of Petrochemical Enterprises" and relevant industry specifications. For each image sample, corner points are detected and key lines are extracted to construct an image skeleton model; The relative coordinates of each signature field and the corresponding role type in the signature skeleton model are labeled to form a structured signature template; The title templates are categorized and stored according to project type and drawing size, resulting in a title template library with a multi-dimensional template retrieval mechanism.

[0026] In addition, the process of matching the signature template for the signature area of ​​each design file based on the standard signature template in the pre-built signature template library is as follows: The detected image of the tag area is preprocessed to identify horizontal and vertical line segments on the page and locate candidate tag areas. The candidate tag region images are normalized to a uniform size to obtain normalized tag images, and the visual features of each normalized tag image are extracted. Calculate the feature similarity between the normalized image and each template in the image template library, and select the one with the highest feature similarity among all feature similarities; The system determines whether the highest similarity of the selected feature exceeds a preset similarity threshold. If a title template exceeds a preset similarity threshold, it is used as the matching template; otherwise, a manual coordinate annotation process is triggered. Based on the field coordinate information in the matching template, the template coordinates are mapped to the physical coordinates of the original design file through affine transformation, thus obtaining the absolute coordinate range of each signature field in the original design file.

[0027] To facilitate project archiving and regulatory review, the method for generating signed and stamped design finalization documents in this embodiment, after step 13, further includes generating a signature and review record for each signed and stamped design finalization document. The signature and review record includes the role type, professional qualification certificate number, signing timestamp, and hash digest of the signing action for each signatory / reviewer.

[0028] To meet the need for signing multiple documents, the engineering industry signature and stamp design final document generation method of this embodiment also includes a step of performing batch signing processing on all design documents in the design document set. Specifically, the steps of the batch signing processing are set as follows: The design file set is grouped according to the similarity of the label structure of the design files; For design files within the same group, the signature position index of the first file is reused, and the actual signature coordinates of each file are calculated by coordinate offset to avoid repeated template matching calculations; Concurrent batch signing operations are performed to optimize processing efficiency, and the integrity and legality of the signature of each design file are verified one by one after each signing operation is completed.

[0029] The verification process, designed to validate the professional qualification certificates of the currently signing personnel, is as follows: Extract the certificate number, certificate validity period, and issuing authority information from the professional qualification certificate information; Send an online verification request to the professional qualification certificate management system to obtain the current status of the certificate; the current status includes valid, expired, and cancelled. Verify that the certificate type matches the current signed role and engineering specialty; When the certificate status is valid and the certificate type matches the current signing role, the professional qualification verification is deemed successful; if the verification fails, the current signing task is suspended and an alarm notification is sent to the task initiator to prevent invalid signatures from entering the final deliverables.

[0030] In addition, the generation method of digital signatures containing professional qualification binding information includes the following steps: Construct a signature data packet; wherein, the signature data packet here contains the hash digest (SHA-256) of the current byte range of the document to be signed, the professional qualification certificate serial number of the signer, the signing timestamp (UTC, accurate to milliseconds) and the project number; The signature value is generated by performing a digital signature operation (RSA-2048 or SM2) on the signed data packet using the signer's private key (stored in the HSM hardware security module or a password-protected PKCS#12 keystore); The signature value, the public key of the professional qualification certificate, and the certificate chain information are encapsulated together in the / Contents attribute of the signature dictionary to achieve a tight binding between signature data and certificate information.

[0031] In addition, in this embodiment, the method for setting the anti-tamper protection flag is as follows: Create a PDF annotation object in the target page of the design document, and set its subtype key value to a custom signature annotation type identifier to distinguish it from standard annotation types such as ordinary annotations; Set a visual signature for the appearance of the annotation object, and simultaneously set two protective flags: ReadOnly and Invisible. The ReadOnly flag prevents users from moving, scaling, editing or deleting the annotation through a PDF reader; the Invisible flag makes the signature unmanageable by ordinary users through the regular view when the document is rendered, thus physically blocking unauthorized interactive operations. Construct a signature dictionary that records byte ranges in the format of quadruples [offset1, length1, offset2, length2], and divide the document into a header data area and a footer data area to ensure the accuracy of signature calculation; By associating the signature dictionary with the / V attribute of the annotation object through indirect object references, the logical binding between signature data and visual signature annotations is achieved.

[0032] This embodiment also provides a system for generating finished design documents with signatures and seals in the engineering industry, to implement the aforementioned method for generating finished design documents with signatures and seals in the engineering industry. The system includes: The task receiving and processing module is used to receive engineering project approval tasks and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the engineering project approval task. The file format recognition module is used to recognize the file format of each design file in the set of design files to be processed, obtain the file format type of each design file to be processed, and perform file processing operations corresponding to the file format type respectively; The label parsing module is used to detect the label area of ​​each design file in the set of design files to be processed, obtain the label area of ​​each design file, and perform label template matching on the label area of ​​each design file based on the standard label template in the pre-built label template library, and extract the label structure information of each design file respectively. The coordinate mapping module is used to extract the signature position in each design file according to the file format type of each design file using an adaptive coordinate method; and to establish a coordinate mapping relationship between the signer and the signature column position in the design file based on the structured information of the signature in each design file and the obtained configuration information of the signers and reviewers, and to generate a signature position index containing the signature coordinates and stamp coordinates of each signer and reviewer. The file conversion module is used to convert the various design files in the set of design files to PDF format and upload them to the document server. The workflow engine module is used to trigger the signing tasks of each signer's corresponding role in sequence according to the preset engineering signing workflow rules, and to monitor the completion status of each signing task in the engineering signing workflow. The qualification verification module is used to verify the validity of the professional qualification certificate of the current signatory for each task to be signed, and to match the professional qualification certificate with the current signing role. The signature generation module is used to construct a signature data package and generate a digital signature containing the professional qualification information of the signer and reviewer, and generate a visual signature identifier at the coordinates of the signature field in the corresponding design document according to the signature position index; and to embed the generated digital signature into the corresponding design document in the form of an annotation object, and set an anti-tamper protection flag for the annotation object. The seal management module is used to generate an electronic seal of the organization's qualification at the preset seal column coordinates in the design document, and to associate the electronic seal of the organization's qualification with the signature dictionary. The document output module is used to output the final design document with signature and seal.

[0033] In addition, this embodiment also provides a readable storage medium. Specifically, the readable storage medium stores a computer program, which, when executed by a processor, implements the above-described method for generating signed and stamped documents of engineering industry design products.

[0034] Although preferred embodiments of the present invention have been described in detail above, it should be clearly understood that various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for generating finished design documents with signatures and seals in the engineering industry, characterized in that: Includes the following steps: Step 1: Receive the project approval task and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the project approval task; the configuration information of the approval personnel includes the role type, identity identifier and professional qualification certificate information of each approval personnel. Step 2: Perform file format identification on each design file in the set of design files to be processed to obtain the file format type of each design file to be processed; Step 3: Based on the identified file format type of each design file to be processed, perform the file processing operation corresponding to the file format type. Step 4: Detect the title block area of ​​each design file in the set of design files to be processed, and obtain the title block area of ​​each design file; Step 5: Based on the standard signature templates in the pre-built signature template library, perform signature template matching on the signature area of ​​each design file to extract the signature structure information of each design file; wherein, the signature structure information includes the coordinate range of each signature field, the signer role type corresponding to each signature field, and the drawing size specification of each signature field; Step 6: Based on the file format type of each identified design file, extract the signature position in each design file using an adaptive coordinate method; Step 7: Based on the structured information of the title block of each design document and the obtained configuration information of the signatory personnel, establish a coordinate mapping relationship between the signatory personnel and the signature column position in the design document, and generate a signature position index containing the signature coordinates and stamp coordinates of each signatory personnel. Step 8: Convert all the finished design files in the set of design files to be processed into PDF format and upload them to the document server. Step 9: Based on the preset project signing workflow rules, trigger the signing tasks of each signatory's corresponding role in sequence; Step 10: For each task to be signed, verify the validity of the professional qualification certificate of the current signatory and perform matching processing between the professional qualification certificate and the current signing role. If the professional qualification certificate is valid and matches the current signing role, the professional qualification verification is deemed successful, and the process proceeds to step 11; otherwise, the corresponding handling measures for unverified professional qualifications are implemented. Step 11: Construct a signature data package and generate a digital signature containing the professional qualification information of the signatory and reviewer, and generate a visual signature identifier at the coordinates of the signature column of the corresponding design document according to the signature position index. Step 12: Embed the generated digital signature into the corresponding design file as an annotation object, and set an anti-tampering protection flag for the annotation object; Step 13: After all reviewers have completed their digital signatures on the design documents, generate an electronic seal of the organization's qualification at the preset seal column coordinates of the design documents, associate the electronic seal of the organization's qualification with the signature dictionary, and output the finished design document with the signature and seal.

2. The method for generating finished design documents with signatures and seals in the engineering industry according to claim 1, characterized in that, In step 2, the file format type is one of PDF, DWG, WORD, and EXCEL.

3. The method for generating finished design documents with signatures and seals in the engineering industry according to claim 2, characterized in that, In step 3, the file processing operations corresponding to the file format type are set as follows: For DWG format files, perform drawing frame recognition and standardization processing: identify the drawing frame size in the design file to be processed and determine whether the drawing frame size is a standard A-series drawing frame; for non-standard extended drawing frames, determine whether they conform to the standard according to preset extension rules; The lengthening rules are set as follows: The length of the extended drawing frame = the original standard length of the drawing frame + n × the incremental length, where n is a non-negative integer; the length of the extended drawing frame is 841mm + n × 210mm for A1, 594mm + n × 105mm for A2, and 420mm + n × 210mm for A3.

4. The method for generating finished design documents with signatures and seals in the engineering industry according to claim 1, characterized in that, In step 6, for WORD documents, the signature coordinates are extracted using predefined tags; for EXCEL files, the name manager is used to preset names in specific cells of the design file to obtain coordinate information. For DWG files, the bottom right corner of the design file is used as the reference point, and the final signature position is calculated based on the relative position offset.

5. The method for generating finished design documents with signatures and seals in the engineering industry according to claim 1, characterized in that, In step 9, the preset engineering signing workflow sets the signing order as follows: designer → checker → reviewer → approver; in step 11, the signature data packet is set to include the hash digest of the design document to be signed, the professional qualification certificate serial number of the signer and reviewer, the signing timestamp, and the project number of the project corresponding to the project signing and review task.

6. The method for generating engineering industry signed and stamped design finished product documents according to any one of claims 1 to 5, characterized in that, After step 13, the process also includes: generating a signature and approval record for each finished design document with a signature and seal; wherein, the signature and approval record includes the role type, professional qualification certificate number, signing timestamp, and hash digest of the signing behavior of each signatory.

7. The method for generating engineering industry signed and stamped design finished product documents according to any one of claims 1 to 5, characterized in that, The construction method of the title template library includes the following steps: Collect standard drawing templates for the engineering industry; among them, the drawing templates cover the specifications of various engineering drawing frames as stipulated in GB / T 51027 "Standard for General Layout Drawing of Petrochemical Enterprises" and relevant industry specifications. For each image sample, corner points are detected and key lines are extracted to construct an image skeleton model; The relative coordinates of each signature field and the corresponding role type in the signature skeleton model are labeled to form a structured signature template; The title templates are categorized and stored according to project type and drawing size, resulting in a title template library with a multi-dimensional template retrieval mechanism.

8. The method for generating finished design documents with signatures and seals in the engineering industry according to claim 7, characterized in that, The process of matching the signature template for the signature area of ​​each design file based on the standard signature templates in the pre-built signature template library is as follows: The detected image of the tag area is preprocessed to identify horizontal and vertical line segments on the page and locate candidate tag areas. The candidate tag region images are normalized to a uniform size to obtain normalized tag images, and the visual features of each normalized tag image are extracted. Calculate the feature similarity between the normalized image and each template in the image template library, and select the one with the highest feature similarity among all feature similarities; The system determines whether the highest similarity of the selected feature exceeds a preset similarity threshold. When a signature template exceeds a preset similarity threshold, it is used as the matching template; Otherwise, trigger the manual coordinate annotation process; Based on the field coordinate information in the matching template, the template coordinates are mapped to the physical coordinates of the original design file through affine transformation, thus obtaining the absolute coordinate range of each signature field in the original design file.

9. A system for generating finished design documents with signatures and seals in the engineering industry, implementing the method for generating finished design documents with signatures and seals in the engineering industry as described in claim 1, characterized in that it includes: The task receiving and processing module is used to receive engineering project approval tasks and obtain the set of design documents to be processed and the configuration information of the approval personnel corresponding to the engineering project approval task. The file format recognition module is used to recognize the file format of each design file in the set of design files to be processed, obtain the file format type of each design file to be processed, and perform file processing operations corresponding to the file format type respectively; The label parsing module is used to detect the label area of ​​each design file in the set of design files to be processed, obtain the label area of ​​each design file, and perform label template matching on the label area of ​​each design file based on the standard label template in the pre-built label template library, and extract the label structure information of each design file respectively. The coordinate mapping module is used to extract the signature position in each design file according to the file format type of each design file using an adaptive coordinate method; and to establish a coordinate mapping relationship between the signer and the signature column position in the design file based on the structured information of the signature in each design file and the obtained configuration information of the signers and reviewers, and to generate a signature position index containing the signature coordinates and stamp coordinates of each signer and reviewer. The file conversion module is used to convert the various design files in the set of design files to PDF format and upload them to the document server. The workflow engine module is used to trigger the signing tasks of each signer's corresponding role in sequence according to the preset engineering signing workflow rules, and to monitor the completion status of each signing task in the engineering signing workflow. The qualification verification module is used to verify the validity of the professional qualification certificate of the current signatory for each task to be signed, and to match the professional qualification certificate with the current signing role. The signature generation module is used to construct a signature data package and generate a digital signature containing the professional qualification information of the signer and reviewer, and generate a visual signature identifier at the coordinates of the signature field in the corresponding design document according to the signature position index; and to embed the generated digital signature into the corresponding design document in the form of an annotation object, and set an anti-tamper protection flag for the annotation object. The seal management module is used to generate an electronic seal of the organization's qualification at the preset seal column coordinates in the design document, and to associate the electronic seal of the organization's qualification with the signature dictionary. The document output module is used to output the final design document with signature and seal.

10. A readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the method for generating signed and stamped engineering industry design finished product documents as described in any one of claims 1 to 8.