Vehicle material purchasing management system, terminal and method

Abstract

The invention relates to the technical field of vehicle material purchasing, and provides a vehicle material purchasing management system, terminal and method, and the system comprises a purchasing data processing module which is used for receiving and converting purchasing data under different business types; the purchasing demand identification module is used for identifying purchasing demand data of foreign shopping materials in the purchasing data; the purchase demand statistics module is used for performing classified statistics on the purchase demand data based on the business process decomposition structures corresponding to different business types to obtain a bill of materials; and the purchase demand summarization module is used for summarizing the bills of materials based on a pre-configured statistical dimension to obtain summarized demand analysis reports of the out-of-service materials under different service types, so that the purchase cycle can be shortened, the operation cost can be reduced, and the service quality can be improved.

Description

Technical Field

[0001] The present invention relates to the technical field of vehicle material procurement, and provides a vehicle material procurement management system, a terminal and a method. Background Art

[0002] Rail vehicles have many structural parts, and in the planning of rail vehicle production, sales and after-sales, it is necessary to purchase parts in a planned manner. For the planning of rail vehicle production, sales and after-sales, it can be divided into production business, sales business, after-sales business, maintenance business, etc. Different businesses may need to purchase parts (also called materials) during normal operation.

[0003] The existing parts procurement mainly focuses on the control of the procurement process, without focusing on the classification, statistics and summary analysis of procurement data, which leads to confusion in the procurement list and increases the procurement cycle. At the same time, it also fails to provide transparency on the procurement situation and has low data service quality. Summary of the invention

[0004] In order to solve the above problems, the present invention provides a vehicle material procurement management system, terminal and method.

[0005] The present invention provides a vehicle material procurement management system, comprising: The procurement data processing module is used to receive and transform procurement data under different business types; A purchasing demand identification module is used to identify the purchasing demand data of outsourced materials in each purchasing data; The procurement demand statistics module is used to classify and count procurement demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials; The procurement demand summary module is used to summarize the material list based on preconfigured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0006] According to one embodiment of the present invention, the procurement data processing module includes: Data access unit, used to capture procurement data under different business types; A data conversion unit, used to parse the purchase data and map it into purchase data in a specified data format; The data cleaning unit is used to clean up abnormal data in the mapped procurement data; The data verification unit is used to verify the data security of the cleaned procurement data.

[0007] According to an embodiment of the present invention, the data conversion unit is specifically used for: Based on the data type of the procurement data, a conversion strategy corresponding to the data type is called, and the procurement data is converted using the conversion strategy to obtain the procurement data in a specified data format.

[0008] According to an embodiment of the present invention, the procurement demand identification module is specifically used for: Identify the outsourcing field in the procurement data, and extract the procurement identifier in the procurement data, wherein the procurement identifier represents the procurement requirement item under the business type; Identify the purchased materials based on the purchased fields, and configure the purchased material categories of the purchased materials; Based on the procurement identifier and the purchased material category, procurement demand data of the purchased materials under the corresponding business type is generated.

[0009] According to one embodiment of the present invention, the procurement demand statistics module is specifically used for: Construct the WBS tree structure table and table element coding of the business of the corresponding business type based on the procurement demand data; Add extended fields associated with materials to each table element in the WBS tree structure table; Based on the extended fields associated with materials on each table element in the WBS tree structure table, a bill of materials is constructed, and the bill of materials is associated with the table element code of the WBS tree structure table.

[0010] According to one embodiment of the present invention, the procurement demand summary module includes: A summarizing unit, used for obtaining the categories and names of materials to be summarized, summarizing the bill of materials based on the categories and names of materials to be summarized, and obtaining the summary demand data of the materials to be summarized; The analysis unit is used to analyze the summary demand data based on pre-configured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0011] According to one embodiment of the present invention, the analysis unit is specifically used for: Based on different statistical dimensions, obtain the analysis strategies corresponding to different statistical dimensions; Based on the analysis strategy, the aggregated demand data is analyzed to obtain an aggregated demand analysis report for purchased materials under different business types.

[0012] According to one embodiment of the present invention, the procurement demand identification module is further used to: Within a preset time period, after it is determined that the procurement data is updated, a processing flow for reconstructing procurement demand data for the updated procurement data is triggered.

[0013] The present invention also provides a vehicle material management terminal, comprising the above-mentioned vehicle material procurement management system.

[0014] The present invention also provides a vehicle material procurement management method based on the above-mentioned vehicle material procurement management system, comprising: Receive and convert procurement data under different business types; Identify the purchase demand data of outsourced materials in each purchase data; Based on the business process decomposition structure corresponding to different business types, the procurement demand data is classified and counted to obtain the bill of materials; The bill of materials is summarized based on preconfigured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0015] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the vehicle material procurement management method as described above is implemented.

[0016] The present invention also provides a non-transitory computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the vehicle material procurement management method as described above is implemented.

[0017] The present invention also provides a computer program product, including a computer program, and when the computer program is executed by a processor, the vehicle material procurement management method as described above is implemented.

[0018] The above one or more technical solutions in the embodiments of the present invention have at least one of the following technical effects: The present invention configures different modules to identify the procurement demand data of outsourced materials from procurement data under different business types, and classifies and counts the procurement demand data based on the business process decomposition structure to obtain a material list. At the same time, the material list is summarized based on pre-configured statistical dimensions to obtain a summary demand analysis report, which can shorten the procurement cycle, reduce operating costs, and improve service quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0020] Figure 1 It is a structural schematic diagram of the vehicle material procurement management system provided by the present invention; Figure 2It is a structural schematic diagram of the vehicle material procurement management method provided by the present invention; Figure 3 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0021] The following embodiments of the present invention are described in further detail in conjunction with the accompanying drawings and examples. The following examples are used to illustrate the present invention, but are not intended to limit the scope of the present invention.

[0022] Combine the following Figure 1-Figure 3 The vehicle material procurement management system, terminal and method of the present invention are described.

[0023] Figure 1 The structural diagram of the vehicle material procurement management system provided by the present invention is shown in FIG. Figure 1 The system includes a purchase data processing module 11, a purchase demand identification module 12, a purchase demand statistics module 13 and a purchase demand summary module 14, wherein: The purchase data processing module 11 is used to receive and convert purchase data under different business types; A purchase demand identification module 12 is used to identify the purchase demand data of outsourced materials in each purchase data; The purchasing demand statistics module 13 is used to classify and count the purchasing demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials; The purchase demand summary module 14 is used to summarize the material list based on pre-configured statistical dimensions to obtain a summary demand analysis report of purchased materials under different business types.

[0024] In this regard, it should be noted that rail vehicles have many structural parts, and in the plans for rail vehicle production, sales and after-sales, it is necessary to purchase parts in a planned manner. For the plans for rail vehicle production, sales and after-sales, if they can be divided according to business types, they can be called production business, sales business, after-sales business, maintenance business, etc. Different businesses may need to purchase parts (also called materials) during normal operations. Therefore, it is necessary to collect procurement data for vehicle materials under different business types.

[0025] In the present invention, the procurement data of different businesses are heterogeneous data. Therefore, the present invention can integrate and standardize multi-source heterogeneous data, that is, the procurement data processing module receives and converts procurement data under different business types, so that multi-source data is converted into internal data in the vehicle material procurement management system, thereby realizing data unification.

[0026] In the present invention, the structural parts of the rail vehicle include self-made parts and purchased parts. Self-made parts can be self-sufficient and can be purchased directly from the enterprise inventory. Therefore, the materials targeted by the present invention are purchased parts. Therefore, a procurement demand identification module is required to identify the purchased materials in each procurement data, and the demand information of the identified purchased materials is used as procurement demand data.

[0027] In the present invention, it is necessary to classify and count the purchased materials under different business types to generate a bill of materials, which is convenient for physical procurement based on the physical list. Under different business processes, the business will be hierarchically decomposed into project tasks, which decomposes the project goals into smaller and more specific work tasks. Different work contents require different materials. For this reason, a procurement demand statistics module is required to classify and count the procurement demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials.

[0028] In the present invention, after the material list under different business types, the material demand needs to be analyzed. The demand situation of vehicle material procurement can be clearly displayed from different statistical dimensions. Therefore, a procurement demand summary module is required to summarize the material list based on the pre-configured statistical dimensions to obtain a summary demand analysis report of purchased materials under different business types.

[0029] The vehicle material procurement management system provided by the present invention identifies the procurement demand data of outsourced materials from the procurement data under different business types by configuring different modules, and classifies and counts the procurement demand data based on the business process decomposition structure to obtain a material list. At the same time, the material list is summarized based on pre-configured statistical dimensions to obtain a summary demand analysis report, which can shorten the procurement cycle, reduce operating costs, and improve service quality.

[0030] In the further system of the above system, the purchase data processing module is mainly explained, and the purchase data processing module includes: Data access unit, used to capture procurement data under different business types; A data conversion unit is used to parse the procurement data and map it to procurement data in a specified data format; The data cleaning unit is used to clean up abnormal data in the mapped procurement data; The data verification unit is used to verify the data security of the cleaned procurement data.

[0031] The data conversion unit is specifically used for: Based on the data type of the procurement data, a conversion strategy corresponding to the data type is called, and the procurement data is converted using the conversion strategy to obtain the procurement data in a specified data format.

[0032] In this regard, it should be noted that, in the present invention, multiple systems such as ERP, MES, and CRM are connected to achieve seamless data integration. For API interface data, a RESTful API data capture function is provided to receive procurement data from sources such as new projects, maintenance projects, spare parts sales, and online orders to ensure real-time and accuracy.

[0033] Based on the data type of the procurement data, a conversion strategy corresponding to the data type is called, and the procurement data is converted using the conversion strategy to obtain the procurement data in a specified data format.

[0034] For XLS and XLSX files, parse Excel through Apache POI and extract the content.

[0035] For text and CSV files, use the opencsv java library to parse.

[0036] Supports floating point rounding, date format unification, and encoding conversion.

[0037] For structured data such as XML and JSON, use libraries such as Jackson or Gson for efficient parsing.

[0038] Build a generic data adapter to support mapping external data sources to internal data models.

[0039] Introduce a data cleaning mechanism to detect, correct or eliminate abnormal data to ensure data quality.

[0040] Design data verification rules to verify the integrity and legality of the received procurement data to prevent erroneous data from flowing into subsequent processes.

[0041] In the further system of the above system, the procurement demand identification module is mainly explained as follows: The procurement demand identification module is specifically used for: Identify the outsourcing field in the procurement data, and extract the procurement identifier in the procurement data, wherein the procurement identifier represents the procurement requirement item under the business type; Identify purchased materials based on the purchased fields and configure the purchased material categories of the purchased materials; Generate procurement demand data for purchased materials under the corresponding business type based on the procurement ID and purchased material category.

[0042] In this regard, it should be noted that the self-made parts and purchased parts can be distinguished by parsing the purchased fields in the procurement data.

[0043] Use java.util.regex to parse the text content and extract the purchase ID.

[0044] Add fields to the Hibernate entity material object to mark the purchased material category.

[0045] In order to enhance the accuracy and intelligence of procurement demand identification, the model is trained with machine learning algorithms to automatically identify and classify procurement demand data and improve identification accuracy.

[0046] In addition, a material knowledge graph is established, combining semantic understanding and natural language processing technology to intelligently analyze unstructured procurement information.

[0047] Within a preset time period, after it is determined that the procurement data is updated, a processing flow for reconstructing procurement demand data for the updated procurement data is triggered.

[0048] In the further system of the above system, the purchase demand statistics module is mainly explained as follows: The procurement demand statistics module is specifically used for: Construct the WBS tree structure table and table element coding of the business of the corresponding business type based on the procurement demand data; Add extended fields associated with materials to each table element in the WBS tree structure table; Based on the extended fields associated with materials on each table element in the WBS tree structure table, a bill of materials is constructed, and the bill of materials is associated with the table element code of the WBS tree structure table.

[0049] In this regard, it should be noted that the third-party component fastWBS is used to build the WBS tree structure table and table element code (i.e. WBS code) of the business project of the corresponding business type. The WBS tree structure is a hierarchical project task decomposition method that decomposes project goals into smaller and more specific work tasks.

[0050] Add extended fields for material association in the WBS tree structure table.

[0051] Based on the extended fields associated with materials on each table element in the WBS tree structure table, Oracle recursive query is used to build the BOM (Bill of Materials) structure and associate the WBS code.

[0052] In addition, listeners are used to track the change events of the WBS tree table.

[0053] Use index optimization technology to improve Oracle database query performance and reduce the response time of complex statistical queries.

[0054] Use the cache mechanism to store commonly used statistical data, reduce database pressure, and improve system response speed.

[0055] In the further system of the above system, the purchase demand summary module is mainly explained as follows: The procurement demand summary module includes: A summarizing unit is used to obtain the categories and names of materials to be summarized, summarize the bill of materials based on the categories and names of materials to be summarized, and obtain the summary demand data of the materials to be summarized; The analysis unit is used to analyze the summary demand data based on pre-configured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0056] The analysis unit is specifically used for: Based on different statistical dimensions, obtain the analysis strategies corresponding to different statistical dimensions; Based on the analysis strategy, the aggregated demand data is analyzed to obtain a summary demand analysis report for purchased materials under different business types.

[0057] In this regard, it should be noted that the MapReduce framework is used to perform distributed summary statistics based on Hadoop. The parser in the Map phase is customized to extract fields as keys. The fields here are material categories and material names, and then the material list is grouped and aggregated based on the key value. In addition, a counter is added to count the progress of real-time demand summary; Flexible configuration of Hadoop clusters allows elastic expansion of resources based on actual business load to meet peak data processing needs.

[0058] The analysis strategy is as follows: Use the open source BI tool Pentaho report design.

[0059] Support pie chart to display Top-N material and department demand distribution; The histogram shows the demand change curve in the time dimension; Cross-tabs show detailed breakdowns by model and item level; One-click customized output of PDF, Excel, and CSV format reports; The present invention can provide rich visual display and interactive experience for demand analysis reports.

[0060] Introduce ECharts and Highcharts chart libraries into report design to provide more diversified data visualization styles.

[0061] Supports mobile adaptation, so that reports can be clearly displayed and easily operated on mobile phones and tablets.

[0062] Subscription service is provided, and users can set up regular report email reminders according to their needs.

[0063] In addition, a rights management system is configured to ensure the security of sensitive data and the effectiveness of access control.

[0064] In addition, the present invention also provides a vehicle material management terminal, including the above-mentioned vehicle material procurement management system.

[0065] The vehicle material procurement management method provided by the present invention is described below. The vehicle material procurement management method described below and the vehicle material procurement management system described above can be referenced to each other.

[0066] Figure 2 A schematic diagram showing a process flow of a vehicle material procurement management method provided by the present invention is shown in FIG. Figure 2 , the method comprises the following steps: Step 21: Receive and transform procurement data under different business types.

[0067] Step 22: Identify the purchase demand data of the purchased materials in each purchase data.

[0068] Step 23: Classify and count the procurement demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials.

[0069] Step 24: Summarize the bill of materials based on preconfigured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0070] Since the method of the embodiment of the present invention has the same principle as the system of the above embodiment, a more detailed explanation will not be repeated here.

[0071] The vehicle material procurement management method provided by the present invention identifies the procurement demand data of outsourced materials from the procurement data under different business types by configuring different modules, and classifies and counts the procurement demand data based on the business process decomposition structure to obtain a material list. At the same time, the material list is summarized based on pre-configured statistical dimensions to obtain a summary demand analysis report, which can shorten the procurement cycle, reduce operating costs, and improve service quality.

[0072] Figure 3 An example of a physical structure diagram of an electronic device is shown in FIG. Figure 3As shown, the electronic device may include: a processor 31 (processor), a communication interface 32 (Communications Interface), a memory 33 (memory) and a communication bus 34, wherein the processor 31, the communication interface 32, and the memory 33 communicate with each other through the communication bus 34. The processor 31 may call the logic instructions in the memory 33 to execute the vehicle material procurement management method, which includes: receiving and converting procurement data under different business types; identifying procurement demand data of purchased materials in each procurement data; classifying and counting the procurement demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials; summarizing the bill of materials based on the pre-configured statistical dimensions to obtain a summary demand analysis report of purchased materials under different business types.

[0073] In addition, the logic instructions in the above-mentioned memory 33 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0074] On the other hand, the present invention also provides a computer program product, which includes a computer program. The computer program can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the vehicle material procurement management method provided by the above-mentioned methods, which includes: receiving and converting procurement data under different business types; identifying procurement demand data of purchased materials in each procurement data; classifying and counting the procurement demand data based on the business process decomposition structure corresponding to the different business types to obtain a bill of materials; summarizing the bill of materials based on pre-configured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

[0075] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the vehicle material procurement management method provided by the above-mentioned methods, the method comprising: receiving and converting procurement data under different business types; identifying procurement demand data of purchased materials in each procurement data; classifying and counting the procurement demand data based on the business process decomposition structure corresponding to the different business types to obtain a bill of materials; summarizing the bill of materials based on pre-configured statistical dimensions to obtain a summary demand analysis report of purchased materials under different business types.

[0076] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0077] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0078] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A vehicle material procurement management system, It is characterized in that include: The procurement data processing module is used to receive and transform procurement data under different business types; A purchasing demand identification module is used to identify the purchasing demand data of outsourced materials in each purchasing data; The procurement demand statistics module is used to classify and count procurement demand data based on the business process decomposition structure corresponding to different business types to obtain a bill of materials; The procurement demand summary module is used to summarize the material list based on preconfigured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

2. The vehicle material procurement management system according to claim 1, It is characterized in that The procurement data processing module includes: Data access unit, used to capture procurement data under different business types; A data conversion unit, used to parse the purchase data and map it into purchase data in a specified data format; The data cleaning unit is used to clean up abnormal data in the mapped procurement data; The data verification unit is used to verify the data security of the cleaned procurement data.

3. The vehicle material procurement management system according to claim 2, It is characterized in that The data conversion unit is specifically used for: Based on the data type of the procurement data, a conversion strategy corresponding to the data type is called, and the procurement data is converted using the conversion strategy to obtain the procurement data in a specified data format.

4. The vehicle material procurement management system according to claim 1 or 3, It is characterized in that The procurement demand identification module is specifically used for: Identify the outsourcing field in the procurement data, and extract the procurement identifier in the procurement data, wherein the procurement identifier represents the procurement requirement item under the business type; Identify the purchased materials based on the purchased fields, and configure the purchased material categories of the purchased materials; Based on the procurement identifier and the purchased material category, procurement demand data of the purchased materials under the corresponding business type is generated.

5. The vehicle material procurement management system according to claim 4, It is characterized in that The purchasing demand statistics module is specifically used for: Construct the WBS tree structure table and table element coding of the business of the corresponding business type based on the procurement demand data; Add extended fields associated with materials to each table element in the WBS tree structure table; Based on the extended fields associated with materials on each table element in the WBS tree structure table, a bill of materials is constructed, and the bill of materials is associated with the table element code of the WBS tree structure table.

6. The vehicle material procurement management system according to claim 1 or 5, It is characterized in that The procurement demand summary module includes: A summarizing unit, used for obtaining the categories and names of materials to be summarized, summarizing the bill of materials based on the categories and names of materials to be summarized, and obtaining the summary demand data of the materials to be summarized; The analysis unit is used to analyze the summary demand data based on pre-configured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

7. The vehicle material procurement management system according to claim 6, It is characterized in that The analysis unit is specifically used for: Based on different statistical dimensions, obtain the analysis strategies corresponding to different statistical dimensions; Based on the analysis strategy, the aggregated demand data is analyzed to obtain an aggregated demand analysis report for purchased materials under different business types.

8. The vehicle material procurement management system according to claim 7, It is characterized in that The procurement demand identification module is also used for: Within a preset time period, after it is determined that the procurement data is updated, a processing flow for reconstructing procurement demand data for the updated procurement data is triggered.

9. A vehicle material management terminal, It is characterized in that A vehicle material procurement management system including any one of claims 1-8.

10. A vehicle material procurement management method based on the vehicle material procurement management system according to any one of claims 1 to 8 above, It is characterized in that include: Receive and convert procurement data under different business types; Identify the purchase demand data of outsourced materials in each purchase data; Based on the business process decomposition structure corresponding to different business types, the procurement demand data is classified and counted to obtain the bill of materials; The bill of materials is summarized based on preconfigured statistical dimensions to obtain a summary demand analysis report for purchased materials under different business types.

Images