Civil aircraft supplier product delivery specification generation method and system and medium

Abstract

The invention discloses a civil aircraft supplier product delivery specification generation method and system and a medium, and the method comprises the steps: constructing a professional female parent and a quality female parent according to different professional attributes corresponding to civil aircraft products, authorizing the professional female parent and the quality female parent to a professional with the professional attributes, and compiling the professional female parent and storing the compiled professional female parent in a database; creating a new delivery specification document, determining an effective serial number of the delivery specification document, and screening out corresponding professional female parents and quality female parents from the database according to the effective serial number for content filling to obtain a delivery specification with complete content; and carrying out content replacement on the delivery instruction book with complete content through a preset delivery instruction book template to form a PDF formatted delivery instruction book document. According to the method, the contents required by the scattered documents of different professions are subjected to structured collaborative compilation and are stored in the professional female parents and the quality female parents, so that the document generation efficiency and accuracy in a main manufacturer-supplier mode are improved, and document generation errors and repeated labor are reduced.

Description

Technical Field

[0001] The present invention relates to the field of civil aircraft flight technology, and in particular to a method and system for generating a product delivery manual of a civil aircraft supplier, and a medium. Background Art

[0002] The civil aircraft supplier product delivery specification SPS is used to describe the final delivery status of aircraft components and is the basis for the body supplier to manufacture and finally deliver the product. The document generally includes four parts: the attributes of the required delivered product, the information that the supplier needs to use or refer to in producing the product, the requirements that the main manufacturer should meet during production and delivery, and the attributes of the supplier's delivery product specification itself. At present, in the process of civil aircraft SPS compilation, the information that the supplier needs to use or refer to in producing the product and the requirements that the main manufacturer should meet during production and delivery need to be integrated by the relevant professional process compilers and quality assurance compilers and then fill in the relevant content in the compilation link. In the actual application scenarios of civil aircraft, professional requirements often have a strong professional description. Non-professional compilers need to spend a lot of manpower to integrate, check, and compile during the integration and compilation process, which leads to low efficiency in the compilation of civil aircraft SPS and poor readability of the final civil aircraft SPS document.

[0003] Based on the above problems, the applicant proposed the technical solution of this application. Summary of the invention

[0004] In view of the above-mentioned defects of the prior art, the present invention provides a method, system and medium for generating product delivery instructions for civil aircraft suppliers. By structured collaborative compilation of the required contents of scattered and different professional documents and storing them in professional master copies and quality master copies, the document generation efficiency and accuracy in the main manufacturer-supplier model are improved, and document generation errors and repetitive labor are reduced.

[0005] In order to achieve the above object, the present invention discloses a method for generating a product delivery instruction sheet of a civil aircraft supplier, comprising the following steps:

[0006] According to different professional attributes corresponding to civil aircraft products, professional master copies corresponding to the professional attributes are constructed, the professional master copies are authorized to professionals with the professional attributes for compilation, and the compiled professional master copies are stored in a database;

[0007] Constructing a quality master copy, authorizing the quality master copy to be compiled by a quality assurance personnel, and storing the compiled quality master copy in a database;

[0008] A new delivery instruction document is created based on the work package of the civil aircraft supplier's product, and basic information of the delivery instruction document is generated, and a valid serial number of the delivery instruction document is determined. According to the valid serial number, a corresponding professional master copy and a quality master copy are screened out from a database, and the delivery instruction document is filled with content based on the screened professional master copy and the quality master copy to obtain a delivery instruction document with complete content;

[0009] Use the preset delivery instruction template to fill in the template of the delivery instruction with complete content to form a PDF formatted delivery instruction document.

[0010] Preferably, when constructing the professional master copy corresponding to the professional attribute, the professional master copy is divided into five components: required engineering documents, replacement parts list, delivery status, tooling requirements and process measurement, each component including a number of structured fields;

[0011] When constructing the quality master, the quality master is divided into two components: quality measurement requirements and acquisition measurement requirements, each of which includes a number of structured fields;

[0012] The structured fields of each component in the professional master and the quality master are provided with validity fields, and the validity fields correspond to the valid serial numbers.

[0013] Preferably, the professional master copy and the quality master copy are structured item by item in an itemized form during compilation.

[0014] Preferably, the professional master copy and the quality master copy are signed, reviewed and released through Windchill software after being compiled.

[0015] Preferably, after the key parameter fields are input during the preparation of the professional master copy, the key parameter fields are used to perform a fuzzy search from the files pre-delivered to the supplier using the JqGrid component and the AutoComplete plug-in, and other structured fields are automatically filled in based on the content obtained from the fuzzy search.

[0016] Preferably, the basic information of the delivery specification document includes at least the supplier name, valid serial number, SPS number, and work package name of the civil aircraft supplier's product.

[0017] Preferably, if a file pre-delivered to a supplier is changed, the changed content is obtained and then parsed through XML, the parsed changed content is updated in the complete delivery instructions, and a change description is generated, which includes at least the changed version number, valid serial number and information of the changer.

[0018] Preferably, in addition to the basic information, the delivery instruction document also includes general instructions, engineering documents, delivery status, coordination / interchange requirements, tooling requirements, quality inspection and testing requirements, finishing requirements, labeling requirements, packing / transportation requirements and a catalog of loose parts, wherein the general instructions, finishing requirements, labeling requirements, packing / transportation requirements and a catalog of loose parts are generated through the delivery instruction template, the engineering documents, delivery status, coordination / interchange requirements and tooling requirements are generated through the professional master copy, and the quality inspection and testing requirements are generated through the quality master copy.

[0019] The present invention also discloses a system for generating product delivery instructions for civil aircraft suppliers, comprising the following modules:

[0020] The professional master copy module is used to construct a professional master copy corresponding to the professional attributes of civil aircraft products according to the different professional attributes corresponding to the professional attributes, authorize the professional master copy to be compiled by professionals with the professional attributes, and store the compiled professional master copy in the database;

[0021] The quality master copy module is used to construct the quality master copy, authorize the quality master copy to the quality assurance personnel for compilation, and store the compiled quality master copy in the database;

[0022] A new text module is created, which is used to create a new delivery specification document based on the work package of the civil aircraft supplier's product, generate basic information of the delivery specification document, determine the valid serial number of the delivery specification document, select the corresponding professional master copy and quality master copy from the database according to the valid serial number, and fill the delivery specification document with content based on the selected professional master copy and quality master copy to obtain a delivery specification with complete content;

[0023] The template output module is used to replace the content of the complete delivery instruction with the preset delivery instruction template to form a PDF formatted delivery instruction document.

[0024] The present invention also discloses a computer-readable storage medium, on which a computer program is stored. When the computer program is processed and executed, the method for generating a product delivery manual of a civil aircraft supplier as described above is implemented.

[0025] Compared with the prior art, the present invention has the following beneficial effects:

[0026] 1. The present invention improves the efficiency and accuracy of document generation in the main manufacturer-supplier model and reduces document generation errors and repetitive work by structured collaborative compilation of the required contents of scattered and different professional documents and storing them in professional master copies and quality master copies.

[0027] 2. The present invention matches the content of the newly created document with the quality master and the professional master through validity matching, and generates the content of the SPS document in combination with the SPS template, uses the template to realize content customization and replacement, and finally outputs the SPS document in PDF format, thereby improving the efficiency and accuracy of product delivery instructions.

[0028] The concept, specific structure and technical effects of the present invention will be further described below in conjunction with the accompanying drawings to fully understand the purpose, characteristics and effects of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 It is a flow chart of a method for generating a product delivery manual for a civil aircraft supplier of the present invention.

[0030] Figure 2 It is a schematic diagram of an application scenario of the method for generating a product delivery manual for a civil aircraft supplier of the present invention. DETAILED DESCRIPTION

[0031] In order to make the technical means, creative features, objectives and effects of the invention easier to understand, the invention is further described below with reference to specific diagrams. However, the invention is not limited to the following implementation cases.

[0032] It should be noted that the structures, proportions, sizes, etc. illustrated in the drawings in this specification are only used to match the contents disclosed in the specification so as to facilitate understanding and reading by persons familiar with this technology. They are not used to limit the conditions under which the present invention can be implemented, and therefore have no substantive technical significance. Any structural modification, change in proportion or adjustment of size, without affecting the effects and purposes that can be achieved by the present invention, should still fall within the scope of the technical contents disclosed by the present invention.

[0033] The product delivery manual for civil aircraft suppliers is a delivery specification manual submitted by the main manufacturer to the supplier, that is, the product delivery specification SPS of the supplier supplying products to the main manufacturer of civil aircraft. There are many defects in the existing main manufacturers of civil aircraft when generating the product delivery manual for civil aircraft suppliers. Due to the low degree of structuring of SPS documents, the data sources in SPS documents are relatively complex, including multi-level mapping between data based on XML and database, interface acquisition, manual filling, and relatively scattered content. The multi-source data is concentrated in the SPS document preparation stage, making the final SPS document less readable. Moreover, data is obtained from different data sources, and these data are stored in a scattered manner. When generating SPS documents for different aircraft sorties, all data need to be obtained again, which makes the acquisition cost and calculation cost high, especially in the application scenario of civil aircraft batch production, which will cause the calculation cost to double and the logic to be complex and error-prone. In addition, when compiling the technical documents, tooling, delivery status and other contents in the SPS document, it is necessary to collect the requirements of different professions. Such requirements are highly professional. It takes a lot of manpower and is prone to errors when non-professionals collect and compile, proofread and sign in the SPS document.

[0034] like Figure 1 As shown, this embodiment discloses a method for generating a product delivery instruction sheet of a civil aircraft supplier, comprising the following steps:

[0035] Step S1, construct a professional master copy corresponding to the professional attributes of civil aircraft products, authorize the professional master copy to be compiled by professionals with the professional attributes, and store the compiled professional master copy in a database.

[0036] Specifically, the civil aircraft SPS document must include information that suppliers need to use or refer to when producing the product, such as product 3D models, technical documents, tooling, etc. Since these contents come from different professions, professional process compilers of related professions are required to integrate professional information. By targeting professional attributes, the professional content compiled by professional process compilers in the SPS document is abstracted into structured items and managed through Windchill objects.

[0037] When constructing a professional master copy corresponding to the professional attributes, the professional master copy is divided into five components: required engineering documents, replacement parts list, delivery status, tooling requirements and process measurement, and each component includes several structured fields. The structured fields of the required engineering documents include file number, file name, and validity. The structured fields of the replacement parts list include interchangeable parts number, interchangeable parts name, interchange requirements, and validity. The structured fields of the delivery status include delivery content, delivery category, engineering details, drawings, and validity, where the engineering details and drawings are stored as attachments. The structured fields of tooling requirements include tooling drawing number, tooling name, tooling version, and validity. The structured fields of process measurement include measurement content, measurement category, validity, and drawings, where the drawings are stored as attachments.

[0038] After the professional master is built, the professional master is authorized to the corresponding professional process personnel for compilation through Windchill's permission management. During compilation, each part is presented in the form of entries, and the process personnel can add or delete entries. The content is automatically filled in during compilation. Specifically, after the key parameter field is entered in the professional master during compilation, the JqGrid component and the AutoComplete plug-in are used to perform fuzzy search using the key parameter field from the file pre-delivered to the supplier, and other structured fields are automatically filled according to the content obtained from the fuzzy search.

[0039] After the process personnel complete the preparation of the professional master copy, the professional master copy will be reviewed and released through the Windchill software.

[0040] Step S2, constructing a quality master copy, authorizing the quality master copy to be compiled by quality assurance personnel, and storing the compiled quality master copy in a database.

[0041] Specifically, the quality master is divided into two components: quality measurement requirements and collection measurement requirements. Each component includes several structured fields. The structured fields of quality measurement requirements and collection measurement requirements include content, title, theoretical value, tolerance value, measurement method, validity, and drawings. The drawings are stored as attachments. These structured fields are all managed in a tabular manner when displayed on the front page. After compilation, they are signed, reviewed, and released through Windchill software.

[0042] Step S3, create a new delivery instruction document based on the work package of the civil aircraft supplier's product, generate basic information of the delivery instruction document, determine the valid serial number of the delivery instruction document, screen out the corresponding professional master copy and quality master copy from the database according to the valid serial number, fill in the content of the delivery instruction document based on the screened professional master copy and the quality master copy, and obtain a delivery instruction document with complete content.

[0043] Specifically, after professionals have completed the preparation of the quality master copy and the professional master copy, the document writer or process personnel can create a new delivery specification document based on the product work package. The delivery specification document includes basic information, change information, master copy items, general instructions, finishing requirements, labeling requirements, transportation / packing requirements, and parts catalog. Among them, the basic information, general instructions, finishing requirements, labeling requirements, and transportation / packing requirements all have fixed styles, and the parts catalog is also generated based on the SPS template.

[0044] When creating a new delivery specification document, the process personnel determine the work package name, work package number, valid serial number and supplier code of the delivery specification document, and then automatically generate basic information in the compilation page according to the SPS document template. The structured fields in each component of the professional master and quality master are provided with validity fields, which correspond to the valid serial number, and the valid serial number is used to reflect the effective flight of the aircraft parts.

[0045] The general description is automatically generated according to the style template, and the content of the general description can be adjusted and modified item by item by the compiler.

[0046] The finishing requirements are automatically generated according to the style template, and its content can be adjusted and modified item by item by the compiler.

[0047] The logo is required to be automatically generated according to the style template, and its content can be adjusted and modified item by item by the compiler.

[0048] The transport / packing requirements are automatically generated according to the style template, and the content can be adjusted and modified item by item by the compiler.

[0049] The top-level engineering files involved in the master items in the delivery specification document are the top-level engineering files of the SPS document and the professional master items in the database. If there is an intersection between the SPS document validity and the item validity, the top-level engineering files of the SPS are generated.

[0050] The delivery status is calculated by matching the validity of the SPS document with the delivery status items of the professional master copy in the database. If there is an intersection between the SPS document validity and the item validity, the delivery status of the SPS is generated.

[0051] It should be noted that in the scenario of multiple SPS flights, different delivery statuses may be defined in the professional master document according to different validity. If the delivery status in the SPS document is not applicable to all validity defined in the document, the system will add the applicable validity after the content.

[0052] like Figure 2As shown, the professional master copy and the quality master copy are created and compiled by different professionals, so as to achieve the purpose of collaborative compilation by different personnel. When compiling the professional master copy, the compiled content is obtained from the database or from the peripheral system. The compiled content is input as text or uploaded as an attachment. The compiled professional master copy and the quality master copy are both entered into the database. When creating the SPS document, the corresponding content in the professional master copy and the quality master copy is obtained through validity matching and filled into the SPS document, and the template is used to assist in outputting it as a PDF formatted document.

[0053] The replacement parts list is calculated based on the effectiveness matching between the SPS document and the coordination / interchange requirements of the professional master in the database or the effectiveness of the replacement parts list items. If there is an intersection between the SPS document validity and the item validity, the SPS coordination / interchange requirements are generated.

[0054] The tooling requirements are calculated by matching the validity of the SPS document with the tooling requirements items in the professional master copy in the database. If there is an intersection between the SPS document validity and the item validity, the tooling requirements of the SPS are generated.

[0055] The quality inspection and testing requirements are calculated based on the effectiveness matching between the SPS document and the product quality measurement requirements, data collection measurement requirements, and process measurement items in the database quality master. If there is an intersection between the SPS document validity and the item validity, the quality inspection and testing requirements of the SPS are generated.

[0056] Because the existing product specification delivery cannot meet the requirements of multiple items, multiple professions, high requirements and high standards in the field of civil aircraft manufacturing. In the process of abstracting the required content of the SPS document, it is necessary to conduct in-depth business research on the existing civil aircraft delivery specification requirements and integrate the existing civil aircraft specification requirements. In the process of abstracting structured items, the civil aircraft specifications themselves are complex. In the process of matching the validity of the document and the master, in the batch production scenario, both the document and the master have scope validity, and there will be a situation where part of the document content is only applicable to some flights. In this embodiment, the following situations will occur for validity matching. When the validity of the master item completely includes the document validity, the validity of the master item content displayed in the document completely covers the document validity, and can be manufactured according to the master requirements. When the validity of the master item does not completely include the document validity, the validity of the master item content displayed in the document does not completely include the document validity, and there is an intersection with the document validity. Partial validity is manufactured according to the master requirements, and the items need to clarify the scope of use. When the validity of the master condition does not include the document validity at all, the master item content is not displayed in the document.

[0057] In one example, if a file pre-delivered to a supplier is changed, the changed content is obtained and then parsed through XML, the parsed changed content is updated in the complete delivery instructions, and a change description is generated, which includes at least the changed version number, valid serial number, and information about the person who made the change.

[0058] Specifically, when an SPS document is changed, a new SPS change order will be created based on the SPS document to notify the corresponding supplier of the corresponding changes. The new SPS change order based on the SPS document will establish a corresponding link relationship. The changes exist in the form of document objects, and the change descriptions and the number of changes that take effect are stored in the form of XML. When the SPS document obtains the changes, the link association of the SPS document is obtained to obtain the document object of the SPS change order, and then the XML file storing the information is obtained based on the document object of the SPS change order, and then the XML file is parsed and filled into the changes in the SPS document.

[0059] Step S4, fill in the template of the delivery instruction with complete content through the preset delivery instruction template to form a PDF formatted delivery instruction document.

[0060] After matching the content of the instruction document with each parent document by validity matching, the content of the SPS document is generated by combining the basic information filled in during creation and the preset delivery instruction template, and each part of the complete delivery instruction is filled in according to the format of the delivery instruction template. The FreeMarker template engine is combined with ITextPDF to realize the generation and processing of PDF such as dynamic creation and content customization replacement, and finally the SPS document is output in PDF format.

[0061] This embodiment aims at the complexity of civil aircraft manufacturers in preparing product delivery instructions. By compiling the required contents of scattered and different professional documents in a structured and collaborative manner and storing them in professional master copies and quality master copies, the efficiency and accuracy of document generation in the main manufacturer-supplier model is improved, and document generation errors and repetitive work are reduced.

[0062] The second embodiment of the present invention discloses a system for generating product delivery instructions for civil aircraft suppliers, including a professional master copy module, a quality master copy module, a new text module and a template output module.

[0063] The professional master template module is used to construct a professional master template corresponding to the different professional attributes corresponding to civil aircraft products, authorize the professional master template to be compiled by professionals with the professional attributes, and store the compiled professional master template in the database.

[0064] The quality master template module is used to construct the quality master template, authorize the quality master template to the quality assurance personnel for compilation, and store the compiled quality master template in the database.

[0065] A new text module is created to create a new delivery instruction document based on the work package of the civil aircraft supplier's products, generate basic information of the delivery instruction document, determine the valid serial number of the delivery instruction document, screen out the corresponding professional master copy and quality master copy from the database according to the valid serial number, and fill in the content of the delivery instruction document based on the screened professional master copy and the quality master copy to obtain a delivery instruction document with complete content.

[0066] The template output module is used to fill in the template of the delivery instruction with complete content through the preset delivery instruction template to form a PDF formatted delivery instruction document.

[0067] Since the first embodiment corresponds to this embodiment, this embodiment can be implemented in conjunction with the first embodiment. The relevant technical details mentioned in the first embodiment are still valid in this embodiment, and the technical effects that can be achieved in the first embodiment can also be achieved in this embodiment. In order to reduce repetition, they are not repeated here. Accordingly, the relevant technical details mentioned in this embodiment can also be applied in the first embodiment.

[0068] The third embodiment of the present invention relates to a computer-readable storage medium having a computer program / instruction stored thereon, wherein the computer program / instruction implements the steps of the method in the first embodiment when executed by a processor.

[0069] The preferred specific embodiments of the present invention are described in detail above. It should be understood that ordinary technicians in the field can make many modifications and changes based on the concept of the present invention without creative work. Therefore, all technical solutions that can be obtained by technicians in the technical field based on the concept of the present invention through logical analysis, reasoning or limited experiments on the basis of the prior art should be within the scope of protection determined by the claims.

Claims

1. A method for generating a product delivery manual for a civil aircraft supplier, characterized in that: The following steps are involved: According to different professional attributes corresponding to civil aircraft products, professional master copies corresponding to the professional attributes are constructed, the professional master copies are authorized to professionals with the professional attributes for compilation, and the compiled professional master copies are stored in a database; Constructing a quality master copy, authorizing the quality master copy to be compiled by a quality assurance personnel, and storing the compiled quality master copy in a database; A new delivery instruction document is created based on the work package of the civil aircraft supplier's product, and basic information of the delivery instruction document is generated, and a valid serial number of the delivery instruction document is determined. According to the valid serial number, a corresponding professional master copy and a quality master copy are screened out from a database, and the delivery instruction document is filled with content based on the screened professional master copy and the quality master copy to obtain a delivery instruction document with complete content; Use the preset delivery instruction template to fill in the template of the delivery instruction with complete content to form a PDF formatted delivery instruction document.

2. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: When constructing the professional master copy corresponding to the professional attribute, the professional master copy is divided into five components: required engineering documents, replacement parts list, delivery status, tooling requirements and process measurement, each component including a number of structured fields; When constructing the quality master, the quality master is divided into two components: quality measurement requirements and acquisition measurement requirements, each of which includes a number of structured fields; The structured fields of each component in the professional master and the quality master are provided with validity fields, and the validity fields correspond to the valid serial numbers.

3. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: The professional master copy and the quality master copy are structured item by item in an itemized form during compilation.

4. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: After being compiled, the professional master copy and the quality master copy are signed, reviewed and released through Windchill software.

5. The method for generating a product delivery manual for a civil aircraft supplier according to claim 2, characterized in that: After the key parameter fields are input when compiling the professional master copy, the key parameter fields are used to perform a fuzzy search from the files pre-delivered to the supplier using the JqGrid component and the AutoComplete plug-in, and other structured fields are automatically filled in based on the content obtained from the fuzzy search.

6. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: The basic information of the delivery instruction document shall at least include the supplier name, valid serial number, SPS number, and work package name of the civil aircraft supplier's product.

7. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: If there is any change in the file pre-delivered to the supplier, the changed content is obtained and then parsed through XML, and the parsed changed content is updated in the complete delivery instructions, and a change description is generated, which at least includes the changed version number, valid serial number and information of the person who made the change.

8. The method for generating a product delivery manual for a civil aircraft supplier according to claim 1, characterized in that: In addition to the basic information, the delivery instruction document also includes general instructions, engineering documents, delivery status, coordination / interchange requirements, tooling requirements, quality inspection and testing requirements, finishing requirements, labeling requirements, packing / transportation requirements and a catalog of loose parts, among which the general instructions, finishing requirements, labeling requirements, packing / transportation requirements and a catalog of loose parts are generated through the delivery instruction template, the engineering documents, delivery status, coordination / interchange requirements and tooling requirements are generated through the professional master copy, and the quality inspection and testing requirements are generated through the quality master copy.

9. A system for generating product delivery instructions for civil aircraft suppliers, characterized in that: Includes the following modules: The professional master copy module is used to construct a professional master copy corresponding to the professional attributes of civil aircraft products according to the different professional attributes corresponding to the professional attributes, authorize the professional master copy to be compiled by professionals with the professional attributes, and store the compiled professional master copy in the database; The quality master copy module is used to construct the quality master copy, authorize the quality master copy to the quality assurance personnel for compilation, and store the compiled quality master copy in the database; A new text module is created, which is used to create a new delivery specification document based on the work package of the civil aircraft supplier's product, generate basic information of the delivery specification document, determine the valid serial number of the delivery specification document, select the corresponding professional master copy and quality master copy from the database according to the valid serial number, and fill the delivery specification document with content based on the selected professional master copy and quality master copy to obtain a delivery specification with complete content; The template output module is used to replace the content of the complete delivery instruction with the preset delivery instruction template to form a PDF formatted delivery instruction document.

10. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, which, when processed and executed, implements the method for generating a civil aircraft supplier product delivery manual as described in any one of claims 1 to 8.

Images