Raw material replacement method and device, equipment and storage medium

Abstract

The invention provides a raw material replacement method and device, equipment and a storage medium, and the method comprises the steps: obtaining order information, and recognizing raw materials and splicing times required by product parts in the order information; obtaining raw material attribute information of the raw materials, and obtaining alternative material attribute information of the alternative materials; according to the splicing times in the raw material attribute information, the alternative materials are combined according to the splicing times, and a replaceable material set is obtained; calculating the splicing size of each material combination in the replaceable material set; based on the splicing size of each material combination in the replaceable material set and the component size of the product component, screening out the material combination with the splicing size greater than or equal to the component size, and obtaining a candidate material set; and according to each material combination in the candidate material set, determining a replacement material of the product part. By implementing the raw material replacement method, device and equipment and the storage medium, materials in stock can be utilized more effectively, and waste is reduced.

Description

Technical Field

[0001] The present application belongs to the field of computer application technology, and in particular, relates to a raw material replacement method, device, equipment and storage medium. Background Art

[0002] In the wooden pallet production industry, companies evaluate the carrying capacity of the required pallets based on the characteristics of the goods being transported, and select appropriate raw materials for production accordingly. However, when there is a shortage of certain raw materials, raw material substitution is required. In this case, a large amount of manual calculations are usually required to determine the best solution for replacing raw materials. This process not only requires a huge amount of calculations, but the utilization rate of the alternative raw materials calculated manually is often low, which easily leads to material waste. Summary of the invention

[0003] In view of the above problems in the prior art, the purpose of this article is to provide a raw material replacement method, device, equipment and storage medium to solve the problems in the prior art.

[0004] In order to solve the above technical problems, the specific technical solutions of this article are as follows:

[0005] In one aspect, the present invention provides a raw material replacement method, comprising:

[0006] Obtain order information and identify the raw materials and number of splicing times required for product components in the order information;

[0007] Based on the material attribute mapping table corresponding to each material in the pre-established spare parts library, the raw material attribute information of the raw materials is obtained;

[0008] According to the raw material attribute information and the material attribute mapping table, select alternative materials that can replace the raw materials from the spare parts library, and obtain the alternative material attribute information of the alternative materials; the alternative material attribute information includes the size information of the alternative materials;

[0009] According to the splicing times in the raw material attribute information, the candidate materials are combined according to the splicing times to obtain a set of replaceable materials;

[0010] Calculate the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials;

[0011] Based on the splicing size of each material combination in the substitutable material set and the component size of the product component, the material combination whose splicing size is greater than or equal to the component size is screened out to obtain a candidate material set;

[0012] Based on the material combinations in the candidate material set, the replacement materials for product components are determined.

[0013] Optionally, based on the material combinations in the candidate material set, replacement materials for product components are determined, including:

[0014] Each material combination in the candidate material set is combined in different ways to obtain a combination graph corresponding to each material combination;

[0015] According to the size information of the spliced ​​combination graphics and the size information of the product components, the overlapping areas corresponding to the spliced ​​combination graphics are obtained;

[0016] According to the overlapping area, the utilization rate of the material combination corresponding to the corresponding splicing combination graphic is calculated;

[0017] Based on utilization, determine replacement materials for product components.

[0018] Optionally, the utilization rate of the material combination corresponding to the corresponding splicing combination graphic is calculated according to the overlapping area, including:

[0019] Calculate the area of ​​the candidate materials in each splicing combination graphic according to the size information of each candidate material in each splicing combination graphic;

[0020] The utilization rate of the material combination corresponding to the spliced ​​combination pattern is obtained by adding the areas of the candidate materials in the spliced ​​combination pattern and subtracting the overlapping area corresponding to the corresponding spliced ​​combination pattern.

[0021] Optionally, the alternative material attribute information also includes a unit price, and the replacement material of the product component is determined according to the utilization rate corresponding to different splicing combination graphics of each material combination, including:

[0022] Screening out the splicing combination graphics whose utilization rate is greater than a preset threshold as candidate splicing combination graphics;

[0023] Obtain the usage area of ​​each candidate material in the candidate splicing combination graph;

[0024] According to the unit price and usage area of ​​the candidate materials, the splicing combination cost corresponding to each candidate splicing combination pattern is calculated;

[0025] The material combination corresponding to the candidate splicing combination pattern with the lowest splicing combination cost is used as the replacement material of the product component.

[0026] Optionally, obtaining the overlapping areas corresponding to the spliced ​​combined graphics according to the size information of the spliced ​​combined graphics and the size information of the product components includes:

[0027] According to the size information of the spliced ​​combination graphics and the size information of the product parts, it is determined whether the spliced ​​combination graphics can completely cover the product parts. If not, the spliced ​​combination graphics are deleted. If so, the overlapping area corresponding to the spliced ​​graphics is calculated.

[0028] Optionally, the method further includes:

[0029] Based on the splicing combination graph of the material combination corresponding to the determined replacement material of the product component, a splicing method of the replacement material is obtained.

[0030] Optionally, the raw material attribute information includes the size information of the raw material, the material attribute information of the raw material, and the allowable error range of the material attribute. The material attribute mapping table includes the size information and the material attribute information of each material. According to the raw material attribute information and the material attribute mapping table, the candidate materials that can replace the raw materials are screened out from the spare parts library, including:

[0031] According to the material property information of the raw materials and the allowable error range of the material properties, determine the allowable range of the material properties corresponding to the raw materials;

[0032] According to the material attribute permission range corresponding to the raw materials and the material attribute information of each material in the material attribute mapping table, materials whose material attribute information is within the material attribute permission range are screened out in the candidate library as candidate materials.

[0033] On the other hand, the present invention provides a raw material replacement device, comprising:

[0034] An order information module is configured to obtain order information and identify raw materials and splicing times required for product components in the order information;

[0035] A raw material attribute information acquisition module is configured to acquire raw material attribute information of the raw material based on a pre-established material attribute mapping table corresponding to each material in the spare parts library;

[0036] The candidate material attribute information acquisition module is configured to screen out candidate materials that can replace the raw materials from the spare parts library according to the raw material attribute information and the material attribute mapping table, and acquire the candidate material attribute information of the candidate materials; the candidate material attribute information includes the size information of the candidate materials;

[0037] The substitutable material set determination module is configured to combine the candidate materials according to the splicing times in the raw material attribute information to obtain a substitutable material set;

[0038] A splicing size calculation module is configured to calculate the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials;

[0039] A candidate material set determination module is configured to screen out material combinations whose splicing size is greater than or equal to the component size based on the splicing size of each material combination in the replaceable material set and the component size of the product component, so as to obtain a candidate material set;

[0040] The replacement material determination module is configured to determine replacement materials for product components based on various material combinations in the candidate material set.

[0041] On the other hand, the present invention provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the following method is implemented when the processor executes the computer program.

[0042] On the other hand, the present invention provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the following method is implemented.

[0043] By adopting the above technical scheme, the raw material replacement method, device, equipment and storage medium of this article can more effectively utilize the materials in stock and reduce waste by intelligently screening and combining alternative materials. In particular, when the original specified materials are in short supply, suitable alternatives can be found quickly. At the same time, more cost-effective materials can be found as substitutes, or material consumption can be reduced by optimizing the splicing method, thereby reducing production costs. In addition, in the face of unstable raw material supply, enterprises can adjust production plans more flexibly to ensure the continuity and stability of production.

[0044] In order to make the above and other purposes, features and advantages of this article more obvious and easy to understand, the following specifically cites preferred embodiments and describes them in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0046] Figure 1 A schematic flow chart of a raw material replacement method according to an embodiment of the present invention is shown;

[0047] Figure 2 A schematic flow chart of another raw material replacement method of the embodiments of this invention is shown;

[0048] Figure 3 A schematic diagram of horizontal splicing and vertical splicing of materials in an embodiment of this invention is shown;

[0049] Figure 4 A schematic diagram of replacing materials for cutting in the embodiment of this invention is shown;

[0050] Figure 5 A schematic structural diagram of a raw material replacement device according to an embodiment of the present invention is shown;

[0051] Figure 6 A schematic diagram showing a computer configuration according to an embodiment of the present invention is shown; DETAILED DESCRIPTION

[0052] The following will be combined with the drawings in the embodiments of this article to clearly and completely describe the technical solutions in the embodiments of this article. Obviously, the described embodiments are only part of the embodiments of this article, not all of the embodiments. Based on the embodiments of this article, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this article.

[0053] It should be noted that the terms "first", "second", etc. in the specification and claims of this article and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of this article described here can be implemented in an order other than those illustrated or described here. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, device, product or equipment that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0054] In order to solve the above problems, the embodiments of this article provide a raw material replacement method, which can improve flexibility, cost control ability and resource utilization in the production process. At the same time, it can also ensure product quality and high efficiency of supply chain management. Figure 1 This is a schematic diagram of the steps of a raw material replacement method provided in the embodiments of this article. This specification provides method operation steps such as the embodiments or flow charts, but more or fewer operation steps may be included based on conventional or non-creative labor. The order of steps listed in the embodiments is only one way of executing the steps among many orders, and does not represent the only order of execution. When the actual system or device product is executed, it can be executed in the order of the methods shown in the embodiments or the drawings or in parallel. Specifically, Figure 1 and Figure 2 As shown, the method may include:

[0055] S102, obtaining order information, and identifying the raw materials and splicing times required for product components in the order information;

[0056] Specifically, order information is used to indicate the production requirements of product components, and product components are parts that have been processed and meet actual needs.

[0057] As an example, the order information shows that the raw material of the wooden pallet to be produced is radiata pine and the size of the wooden pallet.

[0058] It is understandable that the raw materials may be the raw materials currently needed to make product components. During the enterprise's production process, there may be a shortage of raw materials, and alternative materials may be needed for production. In this scenario, the order information may be an order provided by the production direction to the warehouse management party, so that the warehouse management party can provide alternative materials to replace the raw materials based on the order information to ensure smooth production of the product.

[0059] It is understood that the number of splicing times can be the number of times that multiple smaller material units need to be spliced ​​together to meet the size requirements of the product component. Each splicing operation involves connecting two or more material units together to form a larger whole.

[0060] S104, acquiring raw material attribute information of the raw materials based on the material attribute mapping table corresponding to each material in the pre-established spare parts library;

[0061] Specifically, the spare parts library is a database containing all available materials and their related information. Each material in the spare parts library has a unique identifier (such as a material number) and various attribute information related to it.

[0062] A material attribute mapping table corresponding to different materials can be established in the spare parts library. The material attribute mapping table is a structured table used to store detailed attribute information of each material. In other words, each material attribute mapping table can contain the material attribute information of the corresponding material. The material attribute information refers to the basic characteristics or properties that can be identified, such as the shape, size, quality, color, quantity, strength, etc. of an object.

[0063] In practical applications, the unique identifier of the raw material (such as the material number) can be used to query in the spare parts library to find the corresponding material record. According to the associated information in the material record, all relevant attribute information of the raw material can be obtained from the material attribute mapping table.

[0064] For example, search for records with material number M001 in the spare parts library. Assume that the records found are as follows: Material number: M001, attribute mapping table ID: A001; according to the attribute mapping table ID: A001, obtain the detailed attribute information of M001 from the material attribute mapping table. The attribute information found is as follows: Density: 2.7g / cm 3, Strength: 200MPa, Hardness: 60HB.

[0065] For example, a single material property mapping table may be as follows:

[0066] Property Name Attribute Encoding Data Types Example Value Unit Standard Error value long Long Decimal 1200 mm ±4 Width Width Decimal 1200 mm ±4 high Height Decimal 10 mm ±2 hardness Handiness Decimal 3.3 KNseasoned ±0.1 humidity Humidity Decimal 122 % RN ±5 density Density Decimal 443 g / cm3 ±25 Unit load capacity UnitBearingCapacity Decimal 1000 KN ±34 Unit Price UnitPrice Decimal 20 Yuan ±5 Can be spliced Spliceable Tinyint 1 / 0 whether ...

[0067] S106. According to the raw material attribute information and the material attribute mapping table, select alternative materials that can replace the raw materials from the spare parts library, and obtain the alternative material attribute information of the alternative materials; the alternative material attribute information includes the size information of the alternative materials;

[0068] Specifically, the screening condition for selecting candidate materials that can replace raw materials from the spare parts library can be to compare the physical property information of the raw materials with the physical property information of all materials, and select materials whose physical property information is close to or greater than that of the raw materials as candidate materials. The physical property information can be non-dimensional information such as hardness, humidity, density, and unit bearing capacity. In actual applications, the comparison can be performed in a predetermined order of each physical property information, and materials whose physical property information is all greater than that of the raw materials can be selected as candidate materials, and the size information of each candidate material can be obtained at the same time.

[0069] For example, from the material property mapping table, firstly, other raw material data with an error value within the range of ±0.1 with respect to radiata pine are screened out according to their hardness. After obtaining the data, a secondary screening is performed based on the current data to obtain data with a moisture error value within the range of ±5. Finally, data with a density error value within the range of ±25 is screened out based on the current result set. Finally, a set of material property mapping tables that can replace radiata pine are obtained, as shown in the following table.

[0070] Alternative raw material name Specifications (length*width*height) hardness humidity density Pinus sylvestris 1 1300*800*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 2 800*210*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 3 1000*1200*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 4 500*1200*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 5 300*1200*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 6 700*1000*10 3.2KNseasoned 118%RH 422kg / m3 Pinus sylvestris 7 1400*1200*10 3.2KNseasoned 118%RH 422kg / m3

[0071] S108, combining the candidate materials according to the number of splicing times to obtain a set of replaceable materials;

[0072] Specifically, the number of splicing times can be the number of times that multiple smaller material units need to be spliced ​​together in order to achieve the total length (or other dimensions) required for the product component. For example, if the length of the product component is 3000 mm and the length of a single material unit is 1000 mm, three material units need to be spliced ​​twice.

[0073] For example, three candidate materials A, B, and C are selected from the spare parts library, and their detailed attribute information, including size information, is obtained. In the scenario where the number of splicing times is 2, the following alternative material sets can be obtained: material combination AB, material combination AC, and material combination BC.

[0074] For example, the set of alternative materials is shown in the following table:

[0075]

[0076]

[0077] S110, calculating the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials;

[0078] Specifically, the splicing size is used to indicate the size of the material combination after splicing, such as the size of the splicing in the length direction and the size of the splicing in the width direction.

[0079] S112, based on the splicing size of each material combination in the set of replaceable materials and the component size of the product component, screen out material combinations whose splicing size is greater than or equal to the component size to obtain a set of candidate materials;

[0080] For details, see Figure 3 ,The candidate material set is a combination of materials whose splicing size after horizontal or vertical splicing is larger than the component size.

[0081] For example, horizontal splicing (width direction):

[0082] Scotch pine 1 + Scotch pine 2: total width is 1010mm, length is 1300mm. The size of the raw materials that can be covered: length (L) width (W) height (H) is 1200*1200*10mm.

[0083] Larix gmelinii 4 + Larix gmelinii 5: The total width is 800mm, which cannot cover the size of the raw materials and needs to be spliced ​​with another board of at least 400mm wide to meet the width requirement.

[0084] Longitudinal splicing (length direction):

[0085] Scotch pine 6 + Scotch pine 4: total length is 1200mm, width is 1000mm. Can cover the size of the raw materials.

[0086] Scotch pine 6 + Scotch pine 5: total length is 1000mm, width is 1000mm. Can cover the size of the raw materials.

[0087] Therefore, the candidate material set can be determined as: Larix gmelinii 1+L. gmelinii 2, Larix gmelinii 6+L. gmelinii 4, Larix gmelinii 6+L. gmelinii 5.

[0088] S114. Determine replacement materials for product components based on the material combinations in the candidate material set.

[0089] Specifically, any one combination may be selected as the replacement material, or the material whose splicing size is closest to the size of the product component may be selected as the replacement material.

[0090] For example: Larix gmelinii 1+L. gmelinii 2, Larix gmelinii 6+L. gmelinii 4 or Larix gmelinii 6+L. gmelinii 5.

[0091] The implementation of the raw material replacement method provided in the embodiments of this specification can more effectively utilize the materials in stock and reduce waste by intelligently screening and combining alternative materials. In particular, when the original specified materials are in short supply, suitable alternatives can be found quickly. At the same time, more cost-effective materials can be found as substitutes, or material consumption can be reduced by optimizing the splicing method, thereby reducing production costs. In addition, in the face of unstable raw material supply, enterprises can adjust production plans more flexibly to ensure the continuity and stability of production.

[0092] Based on the above embodiment, in one embodiment of the present specification, according to each material combination in the candidate material set, a replacement material for a product component is determined, including:

[0093] S1142, combining various material combinations in the candidate material set in different ways to obtain a combination graph corresponding to each material combination;

[0094] Specifically, the splicing combination can be horizontal splicing (width direction) or vertical splicing (length direction). In an actual solution, the material combination can be pre-spliced ​​in a horizontal splicing (width direction) manner and then vertical spliced ​​(length direction).

[0095] S1144, obtaining overlapping areas corresponding to the spliced ​​combined graphics according to the size information of the spliced ​​combined graphics and the size information of the product components;

[0096] Specifically, the overlapping area can be calculated based on the size of the material. Computer software can be used to draw the graphics of each material in a coordinate system, and then the graphics can be combined in different ways. Based on the coordinates of the graphics in the handover, the overlapping area can be calculated. When multiple boards are spliced ​​into a larger component (such as a wooden pallet), calculating the overlap between different boards or between the board and the final product size helps to evaluate material utilization and determine the optimal splicing solution.

[0097] Specifically, the product component (pallet) size is 1200mmx1000mm, and the following two boards are used for splicing: the two materials are Scots Pine 6 and Scots Pine 4, spliced ​​in the length direction: total length = 700mm+500mm=1200mm, width = 1000mm; in this case, there is no overlapping area because the total length is exactly equal to the target length. But if Scots Pine 6 is spliced ​​with another board of the same size: total length = 700mm+700mm=1400mm, overlapping length = 1400mm-1200mm=200mm, overlapping area = 200mm*1000mm=200000 square millimeters.

[0098] S1146. Calculate the utilization rate of the material combination corresponding to the corresponding splicing combination graphic according to the overlapping area;

[0099] Specifically, the utilization rate of the material combination may be the overlapping area P / total area.

[0100] It can be understood that the utilization results are calculated for different permutations and combinations, and if the current utilization is higher than the previous one, it is replaced until all results are traversed and the optimal solution is obtained.

[0101] Based on the above embodiment, in one embodiment of the present specification, the utilization rate of the material combination corresponding to the corresponding splicing combination pattern is calculated according to the overlapping area, including:

[0102] Calculate the area of ​​the candidate materials in each splicing combination graphic according to the size information of each candidate material in each splicing combination graphic;

[0103] The utilization rate of the material combination corresponding to the splicing combination figure is obtained by adding the areas of the candidate materials in the splicing combination figure and subtracting the overlapping area corresponding to the splicing combination figure.

[0104] For example, two identical sheets (700mm x 1000mm) are used to form a 1200mm x 1000mm pallet, and they overlap in length: total material area = 2*(700mm x 1000mm) = 1400000 square millimeters; actual required area = 1200mm x 1000mm = 1200000 square millimeters; overlapping length = 2*700mm-1200mm = 200mm; overlapping area = 200mm x 1000mm = 200,000 square millimeters; effectively utilized material area = 1200000 square millimeters - 200000 square millimeters = 1000000 square millimeters.

[0105] S1148. Determine replacement materials for product components based on utilization rates.

[0106] Specifically, the utilization rates corresponding to different combinations may be compared, and the comparison method may be performed in a traversal manner, so as to find out the combination with the highest utilization rate, and use the combination with the highest utilization rate as a replacement material for product components.

[0107] Specifically, if there are x material combinations in total, first obtain the first material combination, which contains 2 raw material data. The two raw materials are rotated and combined at different angles. After the rotation is completed, the overlapping area of ​​the original material A and the result of the current combination is calculated. The formula may be: overlapping area P = (min(x coordinate of the upper right corner) - max(x coordinate of the lower left corner)) * (min(y coordinate of the upper right corner) - max(y coordinate of the lower left corner)), then according to the calculated overlapping area P, obtain the remaining part of the current raw material, calculate the utilization rate, the formula is: utilization rate = (area of ​​replacement material 1 + area of ​​replacement material 2) - overlapping area P, save the current utilization rate result, and calculate the current utilization rate percentage, the formula is: percentage = (overlapping area P / total area) * 100; calculate the utilization rate results for different permutations and combinations. If the current utilization rate is higher than the previous one, replace it until all results are traversed and the optimal solution is obtained.

[0108] The implementation of the embodiments of this specification can accurately calculate the overlapping area and utilization rate under each splicing scheme, so that enterprises can choose the most effective way to utilize materials and reduce waste. This not only saves costs, but also improves the efficiency of resource use. At the same time, choosing a material combination with high utilization rate helps to reduce the cost of raw materials. In addition, reducing material waste can also reduce the cost of handling waste, thereby further optimizing the overall production cost.

[0109] Based on the above embodiment, in one embodiment of the specification, the candidate material attribute information also includes a unit price, and the replacement material of the product component is determined according to the utilization rate corresponding to different splicing combination patterns of each material combination, including:

[0110] Screening out the splicing combination graphics whose utilization rate is greater than a preset threshold as candidate splicing combination graphics;

[0111] Specifically, the preset threshold is the minimum standard of utilization rate, and the specific preset threshold can be set as needed, such as 80%, so as to ensure that the selected solution has a higher material utilization rate.

[0112] In practical applications, from all possible splicing combinations, those combinations whose utilization rate exceeds a preset threshold can be screened out, and these combinations will be used as candidate splicing combination graphs.

[0113] Specifically, the optimal utilization array of each material combination can be obtained [{Utilization rate: 88%, Larix gmelinii 1: {Unit price: g, Usage area: n, Remaining material area: m}, Larix gmelinii 4: {Unit price: g, Usage area: n, Remaining material area: m}}, {Utilization rate: 64%, Larix gmelinii 1: {Unit price: g, Usage area: n, Remaining material area: m}, Larix gmelinii 3: {Unit price: g, Usage area: n, Remaining material area: m}}, {Utilization rate: 83%, Larix gmelinii 1: {Unit price: g, Usage area: n, Remaining material area: m}, Larix gmelinii 6: {Unit price: g, Usage area: n, Remaining material area: m}}, {Utilization rate: 53%, Larix gmelinii 1: {Unit price: g, Usage area: n, Remaining material area: m}, Larix gmelinii 7: {Unit price: g, Usage area: n, Remaining material area: m}}.......].

[0114] Obtain the usage area of ​​each candidate material in the candidate splicing combination graph;

[0115] Specifically, for each candidate splicing combination pattern, the actual usage area of ​​each candidate material is calculated, which includes the effectively utilized area minus the area of ​​any overlapping parts.

[0116] According to the unit price and usage area of ​​the candidate materials, the splicing combination cost corresponding to each candidate splicing combination pattern is calculated;

[0117] Specifically, the unit price of the candidate materials may be pre-stored in the material attribute mapping table. The unit price may be that each candidate material has a unit price (eg, price per square meter). The splicing combination cost may be the sum of the product of the material's usage area and the corresponding unit price.

[0118] The material combination corresponding to the candidate splicing combination pattern with the lowest splicing combination cost is used as the replacement material of the product component.

[0119] In practical applications, the combination with the lowest cost can be found among all candidate splicing combination graphics, and the material combination corresponding to the splicing combination graphics with the lowest cost and a utilization rate higher than a preset threshold will be determined as the replacement material for the product component.

[0120] Among them, the price calculation example of a single material combination is: alternative materials: Larix gmelinii 6 and Larix gmelinii 4, total material area = 1,200,000 square millimeters, effectively utilized material area = 1,200,000 square millimeters, utilization rate = 100%; cost: Larix gmelinii 6 unit price 10 yuan / square meter, usable area 0.7 square meters; Larix gmelinii 4 unit price 12 yuan / square meter, usable area 0.6 square meters, therefore, total cost = (0.7*10)+(0.6*12)=7+7.2=14.2 yuan.

[0121] Specifically, the splicing combination cost corresponding to each candidate splicing combination graph can be calculated by a dynamic programming algorithm:

[0122] k[i]=max((k[j]*g)+(k[j]*g)...)+1,for all j

[0123] Among them, k[i] represents the current result value, k[j] represents the data that needs to be compared, g represents the unit price of the current material, and the remaining area of ​​Larix gmelinii 1 in the first group * its unit price + the remaining area of ​​Larix gmelinii 4 * unit price is obtained to get the price of the remaining material after cutting. After calculating all the group prices, they are grouped two by two for the final price comparison until all conditions are traversed and the most economical solution is calculated. plist represents the optimal solution for each item in the above two-dimensional array.

[0124] It should be noted that the initial value k[i] of the current optimal solution is increased by 1 each time it rises, and the maximum value of the current value and the previous value is compared, and k[i] is updated until we have traversed all the arrays and can get the optimal solution k[i] of the current result.

[0125] By comprehensively considering the utilization rate and cost, the implementation of the embodiments of this specification can enable enterprises to achieve more economical material use and reduce production costs. At the same time, it reduces unnecessary material waste and improves production efficiency.

[0126] Based on the above embodiments, in one embodiment of the present specification, the overlapping area corresponding to each spliced ​​combination graphic is obtained according to the size information of the spliced ​​combination graphic and the size information of the product component, including:

[0127] According to the size information of the spliced ​​combination graphics and the size information of the product parts, it is determined whether the spliced ​​combination graphics can completely cover the product parts. If not, the spliced ​​combination graphics are deleted. If so, the overlapping area corresponding to the spliced ​​graphics is calculated.

[0128] Specifically, the covered product department can be determined from two dimensions: length direction: ensure that the total length of the spliced ​​combination graphics is greater than or equal to the length of the product component. Width direction: ensure that the total width of the spliced ​​combination graphics is greater than or equal to the width of the product component. If a spliced ​​combination graphics is smaller than the corresponding size of the product component in any dimension, the combination cannot cover the product component and should be deleted. This avoids screening out combinations that cannot fully cover the product.

[0129] ​For example, the length of the spliced ​​combination graphic can be compared with the length of the product component. After the length of the spliced ​​combination graphic is greater than the length of the product component, the width of the spliced ​​combination graphic can be compared with the width of the product component. When the width of the spliced ​​combination graphic is greater than the width of the product component, it can be confirmed that the spliced ​​combination graphic can fully cover the product component. If one of the above two comparisons does not meet the requirements, it means that the spliced ​​combination graphic cannot fully cover the product component, and the spliced ​​combination graphic will be deleted.

[0130] The implementation of the embodiments of this specification can reduce unnecessary material waste by selecting the splicing combination that can completely cover the product components and calculating the overlapping area. At the same time, selecting the splicing combination with the smallest overlapping area and the highest utilization rate helps to reduce production costs.

[0131] Based on the above embodiments, in one embodiment of the present specification, the method further includes: obtaining a splicing method of the replacement material based on a splicing combination graph of a material combination corresponding to the determined replacement material of the product component.

[0132] Specifically, the splicing combination pattern may be the pattern formed by the above-mentioned transverse splicing or longitudinal splicing, thereby determining whether the plate is spliced ​​along the length direction or the width direction.

[0133] For example, if a 1200mm x 1000mm wooden pallet is made of Scots pine 6 and Scots pine 4, the splicing direction is along the length direction, that is, the long sides of Scots pine 6 and Scots pine 4 are butt-jointed.

[0134] Specifically, after obtaining the optimal material combination of raw materials, the raw materials to be replaced are replaced, and the materials are cut according to the splicing method of the replaced material combination, so as to achieve the purpose of improving the utilization rate of raw materials and reducing their production costs. Figure 4 , cut out the dark areas of Pinus sylvestris 1 and Pinus sylvestris 4 to obtain the spliced ​​material.

[0135] The implementation of the embodiments of this specification can directly determine the specific splicing method of the replacement materials, ensure the quality and performance of the final product components, and not only improve production efficiency but also ensure the consistency and reliability of product quality.

[0136] Based on the above embodiments, in one embodiment of the present specification, the raw material attribute information includes the size information of the raw material, the material attribute information of the raw material, and the allowable error range of the material attribute. The material attribute mapping table includes the size information and the material attribute information of each material. According to the raw material attribute information and the material attribute mapping table, the candidate materials that can replace the raw materials are screened out from the spare parts library, including:

[0137] According to the material property information of the raw materials and the allowable error range of the material properties, determine the allowable range of the material properties corresponding to the raw materials;

[0138] Specifically, the error range can be set according to actual needs, and different material attribute information can correspond to different error ranges. There can be multiple material attribute information of raw materials, such as hardness, humidity, density, unit bearing capacity, etc.

[0139] According to the material attribute permission range corresponding to the raw materials and the material attribute information of each material in the material attribute mapping table, the materials whose material attribute information is within the material attribute permission range are screened out in the candidate library as candidate materials;

[0140] Specifically, when determining the first candidate material, the material attribute information in the candidate library may be compared in order according to the material attributes corresponding to the raw materials. When all the material attribute information is satisfied, the satisfied material is used as the candidate material.

[0141] For example, according to the original component A that needs to be produced at present, it is associated to obtain that the production raw material is radiata pine (i.e., the main material). According to the material property mapping table of radiata pine, the hardness of the current radiata pine is 3.3KNseasoned, and its hardness allowable error value is ±0.1, the humidity is 122%RH, the humidity allowable error value is ±5, and the density is 443g / cm3, and the density allowable error value is ±25. The error value represents the maximum error value of the current raw material when matching the replaceable raw material. If the error value range is exceeded, it means that the replacement condition is not met. From the alternative library, the material property mapping table of other raw materials with an error value within the range of ±0.1 with the radiata pine is selected according to its hardness, and the humidity of other materials is further selected to obtain data with a humidity error value within ±5. Finally, according to the current result set, the data with a density error value within the range of ±25 is selected, and finally a set of alternative material list information that can replace the radiata pine is obtained.

[0142] For example, the material property information of the raw materials includes hardness, humidity, density, and unit bearing capacity. The hardness, humidity, density, and unit bearing capacity of the raw materials can be compared with the corresponding material property information of the materials in the alternative library in turn. The material whose hardness, humidity, density, and unit bearing capacity are all greater than the raw materials can be selected as the first alternative material.

[0143] The implementation of the embodiments of this specification can improve the accuracy of the selection of replacement materials, and ensure that the selected alternative materials are highly consistent with the original design requirements by strictly comparing the material properties and their allowable error ranges, thereby improving the quality of the final product. At the same time, it avoids the selection of unsuitable materials due to human judgment errors and reduces the possibility of rework.

[0144] This embodiment provides a raw material replacement device, which includes:

[0145] An order information module is configured to obtain order information and identify raw materials and splicing times required for product components in the order information;

[0146] A raw material attribute information acquisition module is configured to acquire raw material attribute information of the raw material based on a pre-established material attribute mapping table corresponding to each material in the spare parts library;

[0147] The candidate material attribute information acquisition module is configured to screen out candidate materials that can replace the raw materials from the spare parts library according to the raw material attribute information and the material attribute mapping table, and acquire the candidate material attribute information of the candidate materials; the candidate material attribute information includes the size information of the candidate materials;

[0148] The substitutable material set determination module is configured to combine the candidate materials according to the splicing times in the raw material attribute information to obtain a substitutable material set;

[0149] A splicing size calculation module is configured to calculate the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials;

[0150] A candidate material set determination module is configured to screen out material combinations whose splicing size is greater than or equal to the component size based on the splicing size of each material combination in the replaceable material set and the component size of the product component, so as to obtain a candidate material set;

[0151] The replacement material determination module is configured to determine replacement materials for product components based on various material combinations in the candidate material set.

[0152] The technical effect of the device is the same as that of the above method and will not be repeated.

[0153] This embodiment provides a computer device, whose internal structure diagram can be shown as follows: Figure 6 As shown. The computer device includes a processor, a memory and a network interface connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal through a network connection.

[0154] Those skilled in the art will understand that Figure 6The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0155] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above-mentioned method embodiments when executing the computer program.

[0156] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0157] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0158] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0159] It should also be understood that in the embodiments of this article, the term "and / or" is only a description of the association relationship of the associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship.

[0160] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this article.

[0161] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0162] In the several embodiments provided herein, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, or can be electrical, mechanical or other forms of connection.

[0163] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiments of this article.

[0164] Specific embodiments are used in this article to illustrate the principles and implementation methods of this article. The description of the above embodiments is only used to help understand the methods and core ideas of this article. At the same time, for general technicians in this field, according to the ideas of this article, there will be changes in the specific implementation methods and application scopes. In summary, the content of this specification should not be understood as a limitation on this article.

Claims

1. A raw material replacement method, characterized in that: The method comprises: Obtain order information, and identify the raw materials and number of splicing times required for product components in the order information; Based on the material property mapping table corresponding to each material in the pre-established spare parts library, the raw material property information of the raw material is obtained; According to the raw material attribute information and the material attribute mapping table, select alternative materials that can replace the raw materials from the spare parts library, and obtain the alternative material attribute information of the alternative materials; the alternative material attribute information includes the size information of the alternative materials; According to the splicing times in the raw material attribute information, the candidate materials are combined according to the splicing times to obtain a set of alternative materials; Calculating the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials; Based on the splicing size of each material combination in the set of alternative materials and the component size of the product component, screen out material combinations whose splicing size is greater than or equal to the component size to obtain a candidate material set; According to each material combination in the candidate material set, a replacement material for the product component is determined.

2. The method according to claim 1, characterized in that: The step of determining a replacement material for the product component according to each material combination in the candidate material set includes: Combining various material combinations in the candidate material set in different ways to obtain a combination graph corresponding to each material combination; Obtaining overlapping areas corresponding to each spliced ​​combination graphic according to the size information of the spliced ​​combination graphic and the size information of the product component; Calculate the utilization rate of the material combination corresponding to the corresponding splicing combination pattern according to the overlapping area; Based on the utilization rate, a replacement material for the product component is determined.

3. The method according to claim 2, characterized in that The calculating, according to the overlapping area, the utilization rate of the material combination corresponding to the corresponding splicing combination pattern comprises: Calculate the area of ​​the candidate materials in each splicing combination graphic according to the size information of each candidate material in each splicing combination graphic; The utilization rate of the material combination corresponding to the spliced ​​combination pattern is obtained by adding the areas of the candidate materials in the spliced ​​combination pattern and subtracting the overlapping areas corresponding to the spliced ​​combination pattern.

4. The method according to claim 2, characterized in that: The candidate material attribute information also includes a unit price. The replacement material of the product component is determined according to the utilization rate corresponding to different splicing combination patterns of each material combination, including: Screening out the splicing combination graphics whose utilization rate is greater than a preset threshold as candidate splicing combination graphics; Obtaining the usage area of ​​each candidate material in the candidate splicing combination graphic; Calculating the splicing combination cost corresponding to each of the candidate splicing combination graphics according to the unit price of the candidate materials and the usage area; The material combination corresponding to the candidate splicing combination pattern with the lowest splicing combination cost is used as a replacement material for the product component.

5. The method according to claim 2, characterized in that: The obtaining, according to the size information of the spliced ​​combination graphics and the size information of the product components, the overlapping areas corresponding to the spliced ​​combination graphics include: According to the size information of the spliced ​​combination pattern and the size information of the product component, it is determined whether the spliced ​​combination pattern can completely cover the product component. If not, the spliced ​​combination pattern is deleted. If so, the overlapping area corresponding to the spliced ​​pattern is calculated.

6. The method according to claim 2, characterized in that The method further comprises: Based on the splicing combination graph of the material combination corresponding to the determined replacement material of the product component, a splicing method of the replacement material is obtained.

7. The method according to claim 1, characterized in that The raw material attribute information includes the size information of the raw material, the material attribute information of the raw material, and the allowable error range of the material attribute. The material attribute mapping table includes the size information and the material attribute information of each material. According to the raw material attribute information and the material attribute mapping table, the candidate materials that can replace the raw materials are screened out from the spare parts library, including: Determine the permissible range of the material property corresponding to the raw material according to the material property information of the raw material and the permissible error range of the material property; According to the permitted range of material attributes corresponding to the raw materials and the material attribute information of each material in the material attribute mapping table, materials with material attribute information within the permitted range of material attributes are screened out in the candidate library as candidate materials.

8. A raw material replacement device, characterized in that: The device comprises: An order information module, configured to obtain order information and identify raw materials and splicing times required for product components in the order information; A raw material attribute information acquisition module is configured to acquire the raw material attribute information of the raw material based on a pre-established material attribute mapping table corresponding to each material in the spare parts library; an alternative material attribute information acquisition module, configured to screen out alternative materials that can replace the raw materials from the spare parts library according to the raw material attribute information and the material attribute mapping table, and acquire alternative material attribute information of the alternative materials; the alternative material attribute information includes size information of the alternative materials; An alternative material set determination module is configured to combine the candidate materials according to the splicing times in the raw material attribute information to obtain an alternative material set; A splicing size calculation module is configured to calculate the splicing size of each material combination in the set of alternative materials according to the alternative material attribute information of the alternative materials in each material combination in the set of alternative materials; A candidate material set determination module is configured to screen out material combinations whose splicing size is greater than or equal to the component size based on the splicing size of each material combination in the alternative material set and the component size of the product component, to obtain a candidate material set; The replacement material determination module is configured to determine the replacement material of the product component according to each material combination in the candidate material set.

9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the method according to any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images