Raw material replacement method, device, apparatus, and storage medium

Abstract

Provided are a raw material replacement method, device, equipment and storage medium. The method comprises: obtaining order information, identifying the raw materials and splicing times required by product components in the order information; obtaining raw material attribute information of the raw materials and candidate material attribute information of candidate materials; combining the candidate materials according to the splicing times in the raw material attribute information to obtain a replaceable material set; calculating the splicing sizes of each material combination in the replaceable material set; based on the splicing sizes of each material combination in the replaceable material set and the component size of the product component, screening out material combinations with splicing sizes greater than or equal to the component size to obtain a candidate material set; and determining the replacement materials of the product component according to each material combination in the candidate material set. The implementation of the raw material replacement method, device, equipment and storage medium can more effectively utilize the materials in the inventory and reduce waste.

Description

TECHNICAL FIELD

[0001] The present application belongs to the technical field of computer application, and particularly relates to a raw material replacement method and device, equipment and a storage medium. BACKGROUND

[0002] In the wood pallet production industry, enterprises evaluate the carrying capacity of the required pallets according to the characteristics of the goods to be transported, and accordingly select appropriate raw materials for production. However, when certain raw materials are in short supply, raw material replacement is required. In this case, a large amount of manual calculation is usually required to determine the best solution for replacing the raw materials. This process not only involves a huge amount of calculation, but also the utilization rate of the manually calculated replacement raw materials is often low, which can easily result in material waste. SUMMARY

[0003] In view of the above problems of the prior art, the purpose of the present application 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 the present application are as follows:

[0005] On the one hand, the present application provides a raw material replacement method, which comprises:

[0006] Obtaining order information, identifying the raw materials required by the product components in the order information and the number of splices;

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

[0008] According to the raw material attribute information and the material attribute mapping table, screening out the candidate materials of the replaceable raw materials from the spare parts library, and obtaining the candidate material attribute information of the candidate materials; the candidate material attribute information includes the size information of the candidate materials;

[0009] According to the number of splices in the raw material attribute information, combining the candidate materials according to the number of splices to obtain a replaceable material set;

[0010] According to the candidate material attribute information of the candidate materials in each material combination in the replaceable material set, calculating the splice size of each material combination in the replaceable material set;

[0011] Based on the splice size of each material combination in the replaceable material set and the component size of the product components, screening out the material combinations with splice size greater than or equal to the component size to obtain a candidate material set;

[0012] According to each material combination in the candidate material set, determining the replacement materials of the product components.

[0013] Optionally, the replacement material of the product component is determined according to each material combination in the candidate material set, including:

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

[0015] According to the size information of the combination pattern and the size information of the product component, an overlapping area corresponding to each combination pattern is obtained;

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

[0017] According to the utilization rate, the replacement material of the product component is determined.

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

[0019] According to the size information of each candidate material in each combination pattern, the area of each candidate material in each combination pattern is calculated;

[0020] The areas of the candidate materials in the combination pattern are added and subtracted from the overlapping area corresponding to the combination pattern to obtain the utilization rate of the material combination corresponding to the combination pattern.

[0021] Optionally, the unit price is also included in the candidate material attribute information, and the replacement material of the product component is determined according to the utilization rate of each material combination corresponding to different combination patterns, including:

[0022] The combination patterns with a utilization rate greater than a preset threshold value are screened out as candidate combination patterns;

[0023] The use area of each candidate material in the candidate combination pattern is obtained;

[0024] According to the unit price and the use area of the candidate material, the combination cost of each candidate combination pattern is calculated;

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

[0026] Optionally, the overlapping area corresponding to each combination pattern is obtained according to the size information of the combination pattern and the size information of the product component, including:

[0027] According to the size information of the combination pattern and the size information of the product component, it is determined whether the combination pattern can cover the product component completely, if not, the combination pattern is deleted, and if yes, the overlapping area corresponding to the combination pattern is calculated.

[0028] Optionally, the method further comprises:

[0029] Based on the splicing combination pattern of the determined product component replacement material corresponding material combination, the splicing mode of the replacement material is obtained.

[0030] Optionally, the raw material attribute information includes size information of the raw material and material property information of the raw material and an error range allowed by the material property, and the material property mapping table includes size information and material property information of each material, and the candidate material that can replace the raw material is screened out from the spare parts library according to the raw material attribute information and the material property mapping table, including:

[0031] According to the material property information of the raw material and the error range allowed by the material property, the material property permission range corresponding to the raw material is determined;

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

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

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

[0035] A raw material attribute information acquisition module configured to obtain raw material attribute information of the raw material based on a material property mapping table corresponding to each material in a previously established spare parts library;

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

[0037] A replaceable material set determination module configured to combine the candidate materials according to the splicing times in the raw material attribute information, and obtain a replaceable material set;

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

[0039] The candidate material set determination module is configured to filter out material combinations with a splicing size greater than or equal to the component size of the product component based on the splicing sizes of the material combinations in the alternative material set and the component sizes of the product components, and obtain a candidate material set.

[0040] The replacement material determination module is configured to determine a replacement material for the product component according to each material combination in the candidate material set.

[0041] In another aspect, the present document provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the following method when executing the computer program.

[0042] In another aspect, the present document provides a computer readable storage medium, which stores a computer program, and the computer program is executable on a processor to implement the following method.

[0043] By using the above technical solutions, the raw material replacement method, device, equipment and storage medium provided by the present document can more effectively utilize the materials in the inventory and reduce waste by intelligently screening and combining alternative materials. In particular, when the originally specified materials are in short supply, suitable replacement solutions can be quickly found. At the same time, materials with higher cost-effectiveness can be found as substitutes, or the consumption of materials can be reduced by optimizing the splicing method, thereby reducing production costs. In addition, in the face of unstable raw material supply, enterprises can more flexibly adjust production plans to ensure the continuity and stability of production.

[0044] In order to make the above and other purposes, features and advantages of the present document more obvious and easy to understand, the following describes a preferred embodiment, and the accompanying drawings are described in detail as follows. BRIEF DESCRIPTION OF DRAWINGS

[0045] In order to more clearly illustrate the technical solutions in the embodiments or the prior art, the following will briefly introduce the drawings needed to be used in the embodiment or prior art description. Obviously, the drawings in the following description are only some embodiments of the present document, and for those skilled in the art, other drawings can also be obtained without creative labor.

[0046] Figure 1 A flowchart of a raw material replacement method according to an embodiment of the present document is shown;

[0047] Figure 2 A flowchart of another raw material replacement method according to an embodiment of the present document is shown;

[0048] Figure 3 A schematic diagram of material horizontal splicing and vertical splicing according to an embodiment of the present document is shown;

[0049] Figure 4 Fig. 1 shows a schematic diagram of cutting a replacement material according to an embodiment of the present application;

[0050] Figure 5 Fig. 2 shows a schematic diagram of a raw material replacement device according to an embodiment of the present application;

[0051] Figure 6 Fig. 3 shows a schematic diagram of a computer setup according to an embodiment of the present application; DETAILED DESCRIPTION

[0052] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments herein, all other embodiments obtained by a person of ordinary skill in the art without creative work fall within the scope of the present application.

[0053] It should be noted that the terms "first", "second", and the like in the specification and claims of the present application and the above-described drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or a chronological sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, device, product, or apparatus that includes a series of steps or units does not have to be limited to only those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to the process, method, product, or apparatus.

[0054] To solve the above problems, the embodiments of the present application provide a raw material replacement method, which can improve flexibility, cost control ability and resource utilization rate in the production process. At the same time, it can also ensure the efficiency of product quality and supply chain management. Figure 1 Fig. 1 shows a schematic diagram of a raw material replacement method according to an embodiment of the present application. The present specification provides method operation steps as embodiments or flowcharts, but more or fewer operation steps can be included based on conventional or non-creative work. The order of steps listed in the embodiments is only one of the many execution orders, and does not represent the only execution order. In actual system or device product execution, the method order shown in the embodiments or the drawings can be executed in sequence or in parallel. Specifically, as shown in Figure 1 and Figure 2 The method can include:

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

[0056] Specifically, the order information is used to indicate the manufacturing requirements of product components, which are parts that need to be completed and meet actual needs.

[0057] As an example, through the order information, it is known that the raw materials for producing wooden pallets are radiata pine and the size of the wooden pallets.

[0058] It can be understood that the raw materials can be the raw materials needed for the current production of product components. In the enterprise generation process, there may be a situation where the raw materials are insufficient, and alternative materials need to be used for generation. In this scenario, the order information can be an order provided by the warehouse management party in the production direction, so that the warehouse management party can provide alternative materials for the alternative raw materials based on the order information to ensure smooth production of products.

[0059] It can be 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 product components. Each splicing operation involves connecting two or more material units together to form a larger whole.

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

[0061] Specifically, the spare parts library is a database that contains 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] The spare parts library can have a material attribute mapping table corresponding to different materials. The material attribute mapping table is a structured table used to store detailed attribute information of each material. That is, each material attribute mapping table can have material attribute information of the corresponding material. Material attribute information refers to identifiable basic characteristics or properties, such as the shape, size, mass, color, quantity, strength, etc. of an object.

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

[0064] For example, the record with material number M001 is found in the spare parts library. Assuming the found record is as follows: material number: M001, attribute mapping table ID: A001; according to the attribute mapping table ID: A001, the detailed attribute information of M001 is obtained from the material attribute mapping table. The found attribute information is as follows: density: 2.7 g / cm 3, strength: 200 MPa, hardness: 60 HB.

[0065] For example, the single material attribute mapping table can be as shown in the following table:

[0066] Attribute 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 Handness Decimal 3.3 KNseasoned ±0.1 humidity Humidity Decimal 122 %RN ±5 density Density Decimal 443 g / cm3 ±25 Unit bearing capacity Unit Bearing Capacity 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, screening the alternative material of the replaceable raw material from the spare parts library, and obtaining the alternative material attribute information of the alternative material; the alternative material attribute information includes the size information of the alternative material;

[0068] Specifically, the screening condition for screening the alternative material of the replaceable raw material from the spare parts library can be to compare the physical attribute information of the raw material with the physical attribute information of all materials, and to take the material close to or greater than the physical attribute information of the raw material as the alternative material. Wherein, the physical attribute information can be hardness, humidity, density, unit bearing capacity and other non-size information. In actual application, comparison can be made in a predetermined order of each physical attribute information, and the material with all physical attribute information greater than that of the raw material is taken as the alternative material, and the size information of each alternative material is obtained.

[0069] For example, first, according to the hardness, the other raw material data within the error value of ±0.1 of the radiata pine is screened from the material attribute mapping table, after the data is obtained, the current data is further screened to obtain the data within the error value of ±5 of the humidity, finally, the data within the error value of ±25 of the density is screened according to the current result set, and finally a set of material attribute mapping table set meeting the current replaceable radiata pine is obtained, as shown in the following table.

[0070] Alternative raw material names 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 3 Pinus sylvestris var. mongolica 1000*1200*10 3.2KNseasoned 118% RH 422kg / m3 4 Pinus sylvestris var. mongolica 500*1200*10 3.2KNseasoned 118% RH 422kg / m3 5 Pinus sylvestris var. mongolica 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, according to the splicing times, combining the alternative materials according to the splicing times to obtain a replaceable material set;

[0072] Specifically, the splicing times can be the number of times of splicing multiple smaller material units to achieve the total length (or other size) required by the product component. For example, if the length of the product component is 3000mm, and the length of a single material unit is 1000mm, then 3 material units are needed for twice splicing.

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

[0074] Exemplarily, the alternative material set can be as shown in the following table:

[0075]

[0076]

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

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

[0079] S112, based on the splicing size of each material combination in the alternative material set and the component size of the product component, screening out the material combination whose splicing size is greater than or equal to the component size, and obtaining a candidate material set;

[0080] Specifically, referring to Figure 3 , the candidate material set is the combination whose splicing size is greater than the component size after the material combination is spliced in the horizontal direction or the vertical direction.

[0081] Exemplarily, horizontal splicing (width direction):

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

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

[0084] Vertical splicing (length direction):

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

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

[0087] Therefore, it can be determined that the candidate material set is: Scotch pine 1+Scotch pine 2, Scotch pine 6+Scotch pine 4, Scotch pine 6+Scotch pine 5.

[0088] S114, according to each material combination in the candidate material set, determining the replacement material of the product component.

[0089] Specifically, one of the combinations can be selected as the replacement material, or the combination with the size closest to the size of the product component can be selected as the replacement material.

[0090] For example: Pinus sylvestris 1 + Pinus sylvestris 2, Pinus sylvestris 6 + Pinus sylvestris 4, or Pinus sylvestris 6 + Pinus sylvestris 5.

[0091] The raw material replacement method provided by the embodiments of the present specification can more effectively utilize the materials in the inventory and reduce waste by intelligently screening and combining candidate materials. In particular, when the originally specified materials are in short supply, suitable replacement solutions can be quickly found. At the same time, materials with higher cost-effectiveness 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 more flexibly adjust production plans to ensure the continuity and stability of production.

[0092] In the above embodiments, in an embodiment of the present specification, the replacement material of the product component is determined according to each material combination in the candidate material set, comprising:

[0093] S1142, each material combination in the candidate material set is combined in different ways to obtain a splicing combination pattern corresponding to each material combination;

[0094] Specifically, the splicing combination can be horizontal splicing (width direction) or vertical splicing (length direction). In actual schemes, the material combination can be spliced in advance according to the horizontal splicing (width direction) mode, and then spliced vertically (length direction).

[0095] S1144, obtaining the overlapping area corresponding to each splicing combination pattern according to the size information of the splicing combination pattern and the size information of the product component;

[0096] Specifically, the overlapping area can be based on the size of the material, and the computer software is used to draw the pattern of each material in the coordinate system, and then the patterns are combined in different ways. Based on the coordinates of the patterns in the intersection, the overlapping area is calculated. When multiple boards are spliced into a larger component (such as a wooden tray), the overlapping parts between different boards or between the boards and the size of the final product are calculated, which helps to evaluate the material utilization rate and determine the optimal splicing scheme.

[0097] Specifically, the product component (tray) size is 1200mmx1000mm, and the following two boards are used for splicing: two materials are Pinus sylvestris 6 and Pinus sylvestris 4, and the splicing is 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 Pinus sylvestris 6 and another board of the same size are used for splicing: total length = 700mm+700mm = 1400mm, overlapping length = 1400mm-1200mm = 200mm, overlapping area = 200mm*1000mm = 200000 square millimeters.

[0098] S1146、According to the overlapping area, the utilization rate of the corresponding material combination corresponding to the splicing combination pattern is calculated.

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

[0100] It can be understood that the utilization rate result calculation is performed for different permutation and combination modes, and if the current utilization rate is higher than the last time, the replacement is performed, until all results are traversed, and the optimal solution is obtained.

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

[0102] According to the size information of each alternative material in each splicing combination pattern, the area of the alternative material in each splicing combination pattern is calculated.

[0103] The area of the alternative material in the splicing combination pattern is added and subtracted from the corresponding overlapping area of the splicing combination pattern to obtain the utilization rate of the material combination corresponding to the splicing combination pattern.

[0104] For example, two boards of the same size (700mm x 1000mm) are used for splicing to form a 1200mm x 1000mm tray, and the two boards have an overlap in the length direction: 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; effective material area = 1200000 square millimeters-200000 square millimeters = 1000000 square millimeters.

[0105] S1148, according to the utilization rate, the replacement material of the product component is determined.

[0106] Specifically, the utilization rates corresponding to different combinations can be compared, and the comparison can be performed in a traversal manner to find the combination with the highest utilization rate, and the combination with the highest utilization rate is taken as the replacement material of the product component.

[0107] Specifically, if there are x material combinations, the first material combination is obtained first, the first material combination includes two raw material data, the two raw materials are combined in different angles, after rotation, the overlapping area of the original material A and the result of the current combination is calculated, and the formula can 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, the remaining part of the current raw material is obtained, the utilization rate is calculated, the formula is: utilization rate = (replacement material 1 area + replacement material 2 area) - overlapping area P, the current utilization rate result is saved, and the current utilization rate percentage is calculated, the formula is: percentage = (overlapping area P / total area)*100; the utilization rate result of different arrangement combinations is calculated, if the current utilization rate is higher than the last time, the replacement is performed, until all results are traversed, and the optimal solution is obtained.

[0108] The implementation of the embodiments of the present specification can select the most effective material utilization method by accurately calculating the overlapping area and utilization rate under each splicing scheme, and reduce waste. This not only saves costs, but also improves the efficiency of resource use. At the same time, selecting a material combination with high utilization rate helps to reduce raw material costs. In addition, reducing material waste can also reduce the cost of processing waste, thereby further optimizing the overall production cost.

[0109] On the basis of the above embodiments, in an embodiment of the present specification, the alternative material attribute information further includes a unit price, and the replacement material of the product component is determined according to the utilization rate corresponding to the different splicing combination patterns of each material combination, comprising:

[0110] The splicing combination patterns with utilization rates greater than a preset threshold value are screened out as candidate splicing combination patterns.

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

[0112] In actual application, from all possible splicing combinations, those combinations with utilization rates exceeding the preset threshold value are screened out. These combinations will be used as candidate splicing combination patterns.

[0113] Specifically, the optimal utilization rate array of each material combination can be obtained as [{utilization rate: 88%, scotch pine 1: {unit price: g, use area: n, remaining material area: m}, scotch pine 4: {unit price: g, use area: n, remaining material area: m}}, {utilization rate: 64%, scotch pine 1: {unit price: g, use area: n, remaining material area: m}, scotch pine 3: {unit price: g, use area: n, remaining material area: m}}, {utilization rate: 83%, scotch pine 1: {unit price: g, use area: n, remaining material area: m}, scotch pine 6: {unit price: g, use area: n, remaining material area: m}}, {utilization rate: 53%, scotch pine 1: {unit price: g, use area: n, remaining material area: m}, scotch pine 7: {unit price: g, use area: n, remaining material area: m}}……].

[0114] Obtaining the use area of each candidate material in the candidate splicing combination pattern;

[0115] Specifically, for each candidate splicing combination pattern, the actual use area of each candidate material is calculated. This includes the area of effective utilization minus the area of any overlapping part.

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

[0117] Specifically, the unit price of the candidate material can be pre-stored in the material attribute mapping table. The unit price can be a unit price (e.g. price per square meter) for each candidate material. The splicing combination cost can be the sum of the product of the use area of the material and the corresponding unit price.

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

[0119] In actual application, the combination with the lowest cost can be found in all candidate splicing combination patterns, and the material combination corresponding to the splicing combination pattern with the lowest cost and higher than the preset threshold utilization rate will be determined as the replacement material of the product component.

[0120] Wherein, the price calculation example of a single material combination is that the candidate materials are scotch pine 6 and scotch pine 4, the total material area is 1200000 square millimeters, the effective utilization material area is 1200000 square millimeters, and the utilization rate is 100%; the cost is that the unit price of scotch pine 6 is 10 yuan / square meter, and the use area is 0.7 square meters; the unit price of scotch pine 4 is 12 yuan / square meter, and the use area is 0.6 square meters, therefore, the total cost is (0.7*10)+(0.6*12)=7+7.2=14.2 yuan.

[0121] Specifically, the calculation of the splicing combination cost corresponding to each candidate splicing combination pattern can be evaluated by a dynamic programming algorithm:

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

[0123] Where k[i] represents the current result value, k[j] represents the data to be compared, and g represents the unit price of the current material. The first group of Scots pine 1 remaining area * its unit price + Scots pine 4 remaining area * unit price is obtained, and the current cutting residual price is obtained. After the calculation of all the group prices is completed, the final price comparison is performed on the two groups, until all the conditions are traversed, the most economical solution is calculated, and plist represents the optimal solution of 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, the maximum value of the current value and the last value is compared, and k[i] is updated until all the arrays are traversed, and the optimal solution k[i] of the current result is obtained.

[0125] The implementation of the embodiments of the present specification can realize more economical material use and reduce production cost by comprehensively considering the utilization rate and cost. At the same time, unnecessary material waste is reduced, and production efficiency is improved.

[0126] On the basis of the above embodiment, in an embodiment of the present specification, the overlapping area corresponding to each splicing combination pattern is obtained according to the size information of the splicing combination pattern and the size information of the product part, including:

[0127] According to the size information of the splicing combination pattern and the size information of the product part, it is determined whether the splicing combination pattern can cover the product part completely. If not, the splicing combination pattern is deleted. If yes, the overlapping area corresponding to the splicing pattern is calculated.

[0128] Specifically, the product part can be determined from two dimensions. Length direction: ensure that the total length of the splicing combination pattern is greater than or equal to the length of the product part. Width direction: ensure that the total width of the splicing combination pattern is greater than or equal to the width of the product part. If a certain splicing combination pattern is less than the corresponding size of the product part in any dimension, the combination cannot cover the product part, and it should be deleted. Thus, the combination mode that cannot cover the product completely is avoided.

[0129] For example, the length of the splicing combination pattern can be compared with the length of the product component. After the length of the splicing combination pattern is greater than the length of the product component, the width of the splicing combination pattern can be compared with the width of the product component. When the width of the splicing combination pattern is greater than the width of the product component, it can be determined that the splicing combination pattern can completely cover the product component. If one of the above comparisons does not meet the condition, it means that the splicing combination pattern cannot completely cover the product component, and the splicing combination pattern is deleted.

[0130] The embodiment of the present specification can reduce unnecessary material waste by screening out splicing combinations that can completely cover the product component and calculating the overlapping area. Meanwhile, selecting the splicing combination with the smallest overlapping area and the highest utilization rate can help reduce production costs.

[0131] Based on the above embodiment, in an embodiment of the present specification, the method further comprises: obtaining a splicing manner of the replacement material based on the splicing combination pattern of the material combination corresponding to the replacement material of the determined product component.

[0132] Specifically, the splicing combination pattern can be a pattern formed by the above-mentioned horizontal splicing or vertical splicing, so as to determine whether the plate material is spliced in the length direction or the width direction.

[0133] For example, a 1200mm x 1000mm wooden tray is made of pine 6 and pine 4. The splicing direction is along the length direction, that is, the long edges of pine 6 and pine 4 are butt jointed.

[0134] Specifically, after obtaining the optimal material combination of the raw material, the raw material to be replaced is replaced, and the cutting is performed according to the splicing manner of the replaced material combination, so as to improve the utilization rate of the raw material and reduce the production cost. Referring to Figure 4 The dark regions of pine 1 and pine 4 are cut, and the spliced material can be obtained.

[0135] The embodiment of the present specification can directly determine the specific splicing manner of the replacement material, ensure the quality and performance of the final product component, not only improve the production efficiency, but also ensure the consistency and reliability of the product quality.

[0136] Based on the above embodiment, in an embodiment of the present specification, the raw material attribute information includes size information of the raw material and material property information of the raw material and an error range allowed by the material property, the material attribute mapping table includes size information and material property information of each material, and the replacement raw material is screened out from the spare part library according to the raw material attribute information and the material attribute mapping table, including:

[0137] According to the material property information of the raw material and the error range allowed by the material property, a material property permission range corresponding to the raw material is determined;

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

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

[0140] Specifically, when determining the first candidate material, the material property information in the candidate library can be compared in order according to the material property corresponding to the raw material, and when all the material property information meets the requirements, the material that meets the requirements is selected as the candidate material.

[0141] For example, according to the current required production of the original component A, it is associated to obtain the production raw material as radiata pine (i.e., the main material), according to the material attribute mapping table of radiata pine, the hardness of the current radiata pine is obtained as 3.3KN seasoned, the hardness error value is ±0.1, the humidity is 122%RH, the humidity error value is ±5, the density is 443g / cm3, and the density error value is ±25. The error value represents the maximum error value of the current raw material when matching the replaceable raw material, and if the error value exceeds the error value range, it means that the replacement condition is not met. According to the hardness, the material attribute mapping table of other raw materials within the error value range of ±0.1 of radiata pine is screened out from the candidate library, and then the humidity of other materials is used for secondary screening to obtain data with a humidity error value within ±5, and finally the density error value within ±25 is screened out from the current result set to obtain a list of candidate materials that can replace radiata pine.

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

[0143] The implementation of the embodiments of the present specification can improve the accuracy of the selection of the replacement material. By strictly comparing the material property and the error range allowed by the material property, it is ensured that the selected candidate material is highly consistent with the original design requirements, thereby improving the quality of the final product. At the same time, the selection of unsuitable materials caused by human judgment errors is avoided, and the possibility of rework is reduced.

[0144] The embodiment provides a raw material replacement device, and the device comprises:

[0145] An order information module is configured to acquire order information, and identify raw materials and splicing times required by 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 materials based on a material attribute mapping table corresponding to each material in a spare parts library;

[0147] An alternative material attribute information acquisition module is configured to filter out alternative materials of 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 comprises size information of the alternative materials;

[0148] A replaceable material set determination module is configured to combine the alternative materials according to the splicing times in the raw material attribute information, and obtain a replaceable material set;

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

[0150] A candidate material set determination module is configured to filter out material combinations with splicing sizes greater than or equal to component sizes according to the splicing sizes of each material combination in the replaceable material set and the component sizes of the product components, and obtain a candidate material set;

[0151] A replacement material determination module is configured to determine replacement materials of the product components according to each material combination in the candidate material set.

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

[0153] The embodiment provides a computer device, and an internal structure diagram of the computer device can be as shown in the figure. Figure 6 The computer device comprises a processor, a memory and a network interface connected through a system bus. The processor of the computer device is used for providing computing and control capabilities. The memory of the computer device comprises 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 running of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through network connection.

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

[0155] In an embodiment, a computer device is provided, comprising a memory and a processor, the memory storing a computer program, and the processor implementing the steps in the above method embodiments when executing the computer program.

[0156] In an embodiment, a computer readable storage medium is provided, storing a computer program, and the computer program implementing the steps in the above method embodiments when executed by a processor.

[0157] In an embodiment, a computer program product is provided, comprising a computer program, and the computer program implementing 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. The computer program can be stored in a non-volatile computer readable storage medium, and when executed, can include the processes of the above-mentioned embodiment methods. Any reference to 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 storage, high-density embedded non-volatile memory, resistive memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric 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 but not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc. The database involved in the embodiments provided in the present application can include at least one of a relational database and a non-relational database. The non-relational database can include a distributed database based on a block chain, etc., without being limited thereto. The processor involved in the embodiments provided in the present application can be a general-purpose processor, a central processing unit, a graphics processing unit, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., without being limited thereto.

[0159] It should also be understood that in the embodiments herein, the term "and / or" merely describes an association relationship of associated objects, which means that there can be three relationships. For example, A and / or B can represent three cases of A existing alone, A and B existing together, and B existing alone. In addition, the character " / " herein generally represents that the front and rear associated objects are in an "or" relationship.

[0160] Those skilled in the art can clearly understand that the units and algorithm steps of each example described in combination with the embodiments disclosed herein can be realized in electronic hardware, computer software or a combination of both. In order to clearly illustrate the interchangeability of hardware and software, the components and steps of each example have been described in the foregoing description in a general manner. Whether the functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. A person skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the present disclosure.

[0161] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described system, device and unit can refer to the corresponding processes in the foregoing method embodiments, which will not be repeated here.

[0162] In several embodiments provided herein, it should be understood that the disclosed system, device and method can be implemented in other ways. For example, the above-described device embodiments are only schematic, for example, the division of units is only a logical function division, and actual implementation can have another division manner, for example, a plurality of units or components can be combined or integrated into another system, or some features can be omitted or not executed. In addition, the coupling or direct coupling or communication connection between the displayed or discussed units can be indirect coupling or communication connection through some interfaces, devices or units, and can also be electrical, mechanical or other forms of connection.

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

[0164] The principles and implementation manners of the present disclosure are described herein by using specific embodiments, and the above embodiment descriptions are only used to help understand the method and its core idea; at the same time, for those skilled in the art, according to the idea of the present disclosure, the specific implementation manner and application range will have changes, and in view of the above, the content of the specification should not be understood as limiting the present disclosure.

Claims

1. A method for replacing raw materials, characterized in that, The method includes: Obtain order information and identify the raw materials and assembly count required for the product components in the order information; Based on the pre-established material attribute mapping table corresponding to each material in the spare parts library, the raw material attribute information of the raw material is obtained; Based on the raw material attribute information and the material attribute mapping table, alternative materials that can replace the raw materials are selected from the spare parts library, and the alternative material attribute information of the alternative materials is obtained; the alternative material attribute information includes the size information of the alternative materials; Based on the number of splicing in the raw material attribute information, the candidate materials are combined according to the number of splicing to obtain a set of substitute materials; Based on the candidate material attribute information of each material combination in the set of alternative materials, calculate the splicing size of 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, material combinations with splicing sizes greater than or equal to the component size are selected to obtain a candidate material set; The replacement material for the product component is determined based on the various combinations of materials in the candidate material set.

2. The method according to claim 1, characterized in that, The step of determining the replacement material for the product component based on the various material combinations in the candidate material set includes: The material combinations in the candidate material set are spliced ​​and combined in different ways to obtain the spliced ​​combination graphics corresponding to each material combination; Based on the size information of the assembled graphic and the size information of the product component, the overlapping area corresponding to each assembled graphic is obtained; Based on the overlapping area, calculate the utilization rate of the material combination corresponding to the spliced ​​combination graphic; Based on the utilization rate, the replacement material for the product component is determined.

3. The method according to claim 2, characterized in that, The step of calculating the utilization rate of the material combination corresponding to the spliced ​​combination graphic based on the overlapping area includes: Calculate the area of ​​each candidate material in each splicing combination graphic based on 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 area of ​​the corresponding spliced ​​combination pattern.

4. The method according to claim 2, characterized in that, The step of determining the replacement material for the product component based on the utilization rate includes: Select spliced ​​combination graphics with a utilization rate greater than a preset threshold as candidate spliced ​​combination graphics; Obtain the usage area of ​​each candidate material in the candidate splicing combination graphic; Based on the unit price of the candidate materials and the area used, calculate the splicing combination cost corresponding to each candidate splicing combination graphic; The material combination corresponding to the candidate splicing combination pattern with the lowest splicing combination cost is used as the replacement material for the product component.

5. The method according to claim 2, characterized in that, The step of obtaining the overlapping area corresponding to each spliced ​​composite graphic based on the size information of the spliced ​​composite graphic and the size information of the product component includes: Based on the size information of the spliced ​​graphic and the size information of the product component, determine whether the spliced ​​graphic can completely cover the product component. If not, delete the spliced ​​graphic. If it can, calculate the overlapping area corresponding to the spliced ​​graphic.

6. The method according to claim 2, characterized in that, The method further includes: Based on the splicing combination diagram of the material combination corresponding to the determined product component replacement material, the 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 and material attribute information of the raw material, as well as the allowable error range of the material attribute. The material attribute mapping table includes the size information and material attribute information of each material. Based on the raw material attribute information and the material attribute mapping table, alternative materials that can replace the raw material are selected from the spare parts library, including: Based on the material property information and the allowable error range of the material properties, the permissible range of the material properties corresponding to the raw materials is determined. Based on the permissible range of material properties corresponding to the raw materials and the material property information of each material in the material property mapping table, materials whose material property information is within the permissible range of material properties are selected from the spare parts library as candidate materials.

8. A raw material replacement device, characterized in that, The device includes: The order information module is configured to acquire order information and identify the raw materials and assembly count required for the product components in the order information; The raw material attribute information acquisition module is configured to acquire the raw material attribute information of the raw material based on the material attribute mapping table corresponding to each material in the pre-established spare parts library. The alternative material attribute information acquisition module is configured to filter alternative materials that can replace the raw materials from the spare parts library based on the raw material attribute information and the material attribute mapping table, and acquire the alternative material attribute information of the alternative materials; the alternative material attribute information includes the size information of the alternative materials; The alternative material set determination module is configured to combine the candidate materials according to the splicing number in the raw material attribute information to obtain an alternative material set; The splicing size calculation module is configured to calculate the splicing size of each material combination in the set of alternative materials based on the candidate material attribute information of each candidate material combination in the set of alternative materials. The candidate material set determination module is configured to filter 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, thereby obtaining a candidate material set; The replacement material determination module is configured to determine the replacement material for the product component based on the various material combinations 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, it implements the method as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method as described in any one of claims 1-7.

Images