Decoration plane material customized processing and order placing management system and method based on digital technology

Abstract

The invention belongs to the technical field of order management, and particularly relates to a decoration plane material customized processing and order placing management system and method.The method comprises the steps that firstly, requirements and design drawings are collected to establish an initial database, and plane material sizes and types are matched and stored as intermediate files; adding processing technology information to form a detailed processing guide, and numbering the surface materials to generate a preliminary material list; calculating the material consumption of each item, converting the item into an electronic layout map, and marking a node bulk sample; and generating a final material list after the verification is correct, and completing online ordering. According to the system, full-process automatic and digital management from demand to ordering is realized, the working efficiency is remarkably improved, material waste caused by human errors is reduced, the material consumption is accurately calculated, and the project period is effectively shortened. Through the comprehensive digitization mode, the execution efficiency of the project is improved, the cost is reduced, and the management of the decoration plane materials is more scientific and accurate.

Description

Technical Field

[0001] The present invention belongs to the technical field of order management, and in particular relates to a management system and method for customized processing and order placement of decorative surface materials based on digital technology. Background Art

[0002] In the current field of finishing material processing and management, traditional methods often rely on hand-drawn design drawings and manual calculations of material quantities. These methods are not only inefficient but also prone to errors, especially when dealing with complex renovation projects. Existing technical solutions often include the following steps:

[0003] Requirements gathering: Collect customer requirements through face-to-face communication or email, and record them manually.

[0004] Design and Planning: Designers manually draw design drawings based on the collected requirements and preliminarily determine the required material types and sizes.

[0005] Processing guide development: Based on the design drawings, manually write the processing guide to detail the processing requirements of each surface material.

[0006] Material procurement: Based on the information in the processing guide, manually calculate the required material quantity and purchase it.

[0007] Construction preparation: transport the processed surface materials to the construction site and start installation.

[0008] However, this approach has a significant technical problem: due to the lack of support from digital tools, information inconsistencies and errors are prone to occur throughout the entire process, leading to material waste and construction delays. Without precise processing guidelines and material usage calculations, unnecessary material loss may occur, increasing costs. Summary of the Invention

[0009] The purpose of the present invention is to provide a customized processing and order management system and method for decorative surface materials based on digital technology, which improves work efficiency, reduces human errors, and can accurately calculate material usage, effectively reducing material waste, so as to solve the problems raised in the above background technology.

[0010] To achieve the above-mentioned purpose, the present invention adopts the following technical solution: a method for customized processing and order management of decorative surface materials based on digital technology, comprising the following steps:

[0011] Collecting decoration surface material requirements and design drawings, establishing an initial database, matching surface material sizes and types based on the data in the initial database, and storing the results as an intermediate file;

[0012] Add processing information of the corresponding surface material to the intermediate file to form a detailed processing guide, use the detailed processing guide to number the surface material, and generate a preliminary material list including numbers and dimensions;

[0013] Calculating the required material quantity for each surface material item in the preliminary material list and adding it to the corresponding item; converting the preliminary material list with the added material quantity into an electronic layout drawing, and marking the node sample of each surface material;

[0014] Review all information in the electronic layout drawing, generate the final bill of materials after ensuring that it is correct, and complete the online ordering process based on the final bill of materials.

[0015] Preferably, the collecting of decoration surface material requirements and design drawings and establishing an initial database includes:

[0016] Receive requirement documents and design drawings from customers, and convert the information in the requirement documents and design drawings into structured data format;

[0017] According to the structured data format, each type of decorative surface material is classified by name Y and specification size S. The quantity Na of each type of surface material is calculated using the formula Na = (Aa / (La*Wa)), where Aa is the total area required; La and Wa are the length and width of the surface material, i.e., the specification size S.

[0018] Create an association table to match the classified surface materials with the corresponding quantity Na and record it in the initial database;

[0019] Verify each record in the initial database to ensure the accuracy of the surface material name Y, specification size S and quantity Na, and complete the final confirmation by comparing the original requirement document and design drawings.

[0020] Preferably, matching the surface material size and type is performed based on the data in the initial database, and the result is stored as an intermediate file, including:

[0021] Extracting association table information from the initial database, including surface material name Y, specification size S and quantity Na;

[0022] Use the formula Ma = Na * (La * Wa) to calculate the total area Ma of the surface material required. Based on the total area Ma and the specification size S, find the stock material panels that meet the requirements and determine the minimum cutting quantity Q to meet the requirements. Calculate it using the formula Q = cei l (Ma / (Ls * Ws)), where Ls and Ws are the standard length and width of the stock panels, and cei l represents rounding up.

[0023] The name Y of the surface material, the original specification size S, the required quantity Na, the calculated total area Ma and the determined minimum cutting quantity Q are recorded in the intermediate file.

[0024] Preferably, processing information of the corresponding surface material is added to the intermediate file to form a detailed processing guide, including:

[0025] Extracting information of the surface material name Y, specification size S, quantity Na and minimum cutting quantity Q from the intermediate file;

[0026] According to the surface material name Y and specification size S, find the matching processing parameter set P, and use the formula Sp = SUM(Pi) to calculate the total working time Sp corresponding to each process parameter set, where Pi is the i-th parameter value in the process parameter set;

[0027] Append the detailed information in the processing parameter set P to the relevant entries in the intermediate file and update the material entries;

[0028] The number of tools T required for the surface material is calculated using the formula Tn=ceil(Q / J), where J represents the number of panels that each tool can process. The required number of tools T is added to the intermediate file.

[0029] Preferably, the face materials are numbered using the detailed processing guide to generate a preliminary bill of materials including numbers and sizes, including:

[0030] Extract the surface material name Y, specification size S, quantity Na and processing parameter set P from the intermediate file, and assign a number Z to each surface material entry;

[0031] According to the number Z and the processing parameter set P, all surface material items are sorted by processing complexity, the processing complexity of each surface material item is calculated using the formula O=SUM(Pi), and the sorting result is updated to the preliminary material list;

[0032] For each surface material item, add the corresponding specification size S information in the preliminary material list according to the number Z;

[0033] Calculate the total area requirement for all surface material items in the preliminary bill of materials using the formula Aa = SUM(Na*La*Wa) and append the total area Aa to the preliminary bill of materials.

[0034] Preferably, the required material amount is calculated for each surface material item in the preliminary material list and added to the corresponding item, including:

[0035] Extract the number Z, specification size S and quantity Na of each surface material item, calculate the required material quantity Mm using the formula Mm=Na*La*Wa, and add the material quantity Mm to the corresponding surface material item;

[0036] According to the number Z, search for the processing parameter set P of the surface material entry, and evaluate the material loss rate Dm caused by processing. The loss rate is calculated using the formula Dm=SUM(Pi*Ki), and the loss rate Dm is added to the surface material entry, where Ki is the loss coefficient corresponding to the i-th processing parameter;

[0037] Using the material usage Mm and loss rate Dm, the total demand Ta of each surface material item is updated using the formula Ta=Mm*(1+Dm), and the total demand Ta is added to the corresponding surface material item.

[0038] Preferably, the preliminary bill of materials with the material quantities added is converted into an electronic layout drawing, and the node samples of each surface material are marked, including:

[0039] Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, and loss rate Dm;

[0040] Arrange and combine the materials, calculate the best layout to minimize waste, calculate the efficiency ratio E using the formula E = SUM (Tai / Ai), and select the layout with the highest efficiency ratio E as the basis for the electronic layout diagram;

[0041] On the electronic layout diagram, place all surface material items according to the layout plan and mark the node sample of each surface material item;

[0042] For each surface material item's joint sample, calculate the required additional material quantity X, which is determined by the formula X=SUM(Nj*Lj*Wj). Add the additional material quantity X to the corresponding surface material item details, where Nj is the number of joint samples, Lj and Wj are the length and width of the joint samples, respectively.

[0043] Preferably, all information in the electronic layout is reviewed to ensure that it is correct before generating a final bill of materials, including:

[0044] Check the number Z, specification size S, quantity Na, and additional material amount X of each surface material item in the electronic layout drawing one by one to verify their consistency with the preliminary material list, and use the formula Mm = SUM(Nai*Lai*Wai) to confirm the total material requirement Mm, where Nai is the quantity of the i-th surface material item, Lai and Wai represent the length and width of the i-th surface material item respectively;

[0045] Based on the total material demand Mm, calculate the actual demand Ya after loss adjustment using the formula Ya=Mm*(1+Dm), and compare the actual demand Ya with the total demand Ta marked in the electronic layout diagram;

[0046] Check whether each node sample on the electronic layout drawing complies with the standard specification. If not, update the details of the node sample and recalculate the associated additional material quantity X;

[0047] After confirming that all the information of the electronic layout drawing is accurate, the number Z, specification size S, quantity Na, total demand Ta, loss rate Dm and adjusted actual demand Ya of each surface material item are summarized to form the final material list.

[0048] Preferably, completing the online ordering process according to the final material list includes:

[0049] Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, loss rate Dm, and adjusted actual demand Ya. Calculate the total cost Cc using the formula Cc = SUM(Yai * Ci), where Yai is the adjusted actual demand for the i-th surface material item and Ci is the unit price of the i-th surface material.

[0050] Generate an order summary based on the total cost Cc and the surface material item information, and send the order summary to the procurement platform for preliminary review;

[0051] Check the lead time Ti provided by the procurement platform and determine the expected delivery date Dd using the formula Dd = MAX(Ti) + L, where MAX(Ti) represents the maximum lead time and L is the fixed logistics time.

[0052] Submit the order request online and arrange the subsequent construction plan based on the expected delivery date Dd.

[0053] On the other hand, the present invention proposes a customized processing and order management system for decorative surface materials based on digital technology, comprising:

[0054] A database establishment module is used to collect decoration surface material requirements and design drawings, establish an initial database, match surface material sizes and types based on the data in the initial database, and store the results as an intermediate file;

[0055] A bill of materials preparation module is used to add processing information of the corresponding surface materials to the intermediate file to form a detailed processing guide, and use the detailed processing guide to number the surface materials to generate a preliminary bill of materials including numbers and dimensions;

[0056] an electronic layout drawing generation module, configured to calculate the required material quantity for each surface material item in the preliminary material list, append the required material quantity to the corresponding item, convert the preliminary material list with the appended material quantity into an electronic layout drawing, and mark the node pattern of each surface material;

[0057] The online ordering module is used to review all the information in the electronic layout drawing, generate the final material list after ensuring that it is correct, and complete the online ordering process based on the final material list.

[0058] Technical effects and advantages of the present invention: The digital technology-based customized processing and order management system and method for decorative surface materials proposed in the present invention have the following advantages over the existing technology:

[0059] The present invention directly attaches various types of decorative surface materials and corresponding processing technology information to the layout diagram, and generates a detailed material list containing material numbers, dimensions, processing technology and node samples, thereby realizing the automation and digital management of the entire process from demand collection to online ordering; this not only improves work efficiency and reduces human errors, but also can accurately calculate material usage, effectively reduce material waste, and shorten the project cycle. BRIEF DESCRIPTION OF THE DRAWINGS

[0060] Figure 1 This is a flow chart of the method for customized processing and order management of decorative surface materials based on digital technology of the present invention;

[0061] Figure 2 This is a block diagram of the digital technology-based customized processing and order management system for decorative surface materials of the present invention. DETAILED DESCRIPTION

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

[0063] The present invention provides Figure 1 The following is a method for customized processing and order management of decorative surface materials based on digital technology. This method improves work efficiency, reduces human errors, accurately calculates material usage, and effectively reduces material waste.

[0064] In this embodiment, the method for customized processing and order management of decorative surface materials based on digital technology includes the following steps:

[0065] Step 1: Collect decoration surface material requirements and design drawings and establish an initial database; specifically including:

[0066] Receive requirement documents and design drawings from customers, convert the information in the requirement documents and design drawings into structured data format; process customer requirements and design drawings through digital means to facilitate subsequent data analysis and management.

[0067] According to the structured data format, each type of decorative surface material is classified by name Y and specification size S, and the quantity Na of each type of surface material is calculated using the formula Na = (Aa / (La*Wa)), where Aa is the total area requirement; La and Wa are the length and width of the surface material, that is, the specification size S; through this formula, the specific quantity Na of surface materials required to meet the total area requirement Aa can be determined.

[0068] Create an association table to match the classified surface materials with the corresponding quantity Na and record it in the initial database; build a clear association table to facilitate the management and query of different surface materials and their demand, providing reliable data support for subsequent steps.

[0069] Verify each record in the initial database to ensure the accuracy of the surface material name Y, specification size S and quantity Na, complete the final confirmation by comparing the original requirement document and design drawings, and ensure the accuracy and consistency of the data through comparison and verification.

[0070] Example 1

[0071] Suppose a client needs to renovate a space with a total area of 50 square meters and plans to use two sizes of tiles: Size A (60 cm long, 60 cm wide) and Size B (80 cm long, 80 cm wide). The total area required for Size A is 30 square meters, and the total area required for Size B is 20 square meters.

[0072] Receive requirement documents and design drawings: Obtain documents and design drawings containing the above requirements from the customer and convert them into structured data format.

[0073] Calculate the number of surface materials:

[0074] For specification A (La = 0.6m, Wa = 0.6m), use the formula Na = Aa / (La * Wa):

[0075] Na=30 / (0.6*0.6)=83.33, which is approximately 84 yuan after rounding.

[0076] For specification B (La = 0.8m, Wa = 0.8m), the same formula is used: Nb = Ab / (Lb * Wb):

[0077] Nb=20 / (0.8*0.8)=31.25, which is approximately 32 pieces after rounding.

[0078] Create an association table and record: enter the surface materials of specification A and specification B and their corresponding quantities (84 pieces and 32 pieces) into the initial database to form an association table.

[0079] Verify data: Compare the original requirements document with the design drawings to confirm that all records are correct and ensure data accuracy. This not only improves efficiency but also reduces the possibility of human error and ensures a smooth project.

[0080] Step 2: Match the surface material size and type according to the data in the initial database, and store the result as an intermediate file; specifically including:

[0081] Extracting association table information from the initial database, including surface material name Y, specification size S and quantity Na;

[0082] Use the formula Ma = Na*(La*Wa) to calculate the total area Ma of the surface material required. Based on the total area Ma and the specification size S, find the stock material panels that meet the requirements and determine the minimum cutting quantity Q to meet the demand. Calculate using the formula Q = cei l(Ma / (Ls*Ws)), where Ls and Ws are the standard length and width of the stock panels, and cei l represents rounding up. Accurately calculate the total area requirement and the required number of stock panels to optimize inventory utilization efficiency and reduce waste.

[0083] The name Y of the surface material, the original specification size S, the required quantity Na, the calculated total area Ma and the determined minimum cutting quantity Q are recorded in the intermediate file.

[0084] Example 2

[0085] Assume that the surface material to be processed is a tile with a size of 60cmx60cm (i.e. La=0.6m, Wa=0.6m). The customer needs a total of 100 tiles of this type, and the total area required Aa is 36 square meters.

[0086] Extract related table information:

[0087] Relevant information of the ceramic tile surface material is extracted from the initial database, including the name Y (ceramic tile), specification size S (60cmx60cm) and quantity Na (100 pieces).

[0088] Calculate the total area Ma: Ma = 100 * (0.6 * 0.6) = 36 square meters.

[0089] Find the stock material blocks that meet the requirements and determine the minimum cutting quantity Q:

[0090] Assume that the standard size of the stock panels is 80cmx80cm (i.e. Ls=0.8m, Ws=0.8m).

[0091] Q = ceil(36 / (0.8*0.8)) = ceil(56.25) = 57 blocks.

[0092] Record to the intermediate file: record the name of the surface material Y (ceramic tiles), the original specification size S (60cmx60cm), the required quantity Na (100 pieces), the calculated total area Ma (36 square meters) and the determined minimum cutting quantity Q (57 pieces) in the intermediate file.

[0093] Step 3: Add the processing information of the corresponding surface material to the intermediate file to form a detailed processing guide; specifically including:

[0094] Extracting information of the surface material name Y, specification size S, quantity Na and minimum cutting quantity Q from the intermediate file;

[0095] According to the surface material name Y and specification size S, find the matching processing parameter set P, and use the formula Sp = SUM(Pi) to calculate the total working time Sp corresponding to each process parameter set, where Pi is the i-th parameter value in the process parameter set; this formula helps to understand the total working time required to complete all processing steps for a specific type of surface material.

[0096] The detailed information in the processing parameter set P is appended to the relevant entries in the intermediate file, and the surface material entries are updated; ensuring that each surface material entry contains detailed processing information for reference in subsequent operations.

[0097] The number of tools T required for each surface material is calculated using the formula Tn = cei l(Q / J), where J represents the number of panels each tool can process. The required number of tools T is added to the intermediate file. This formula helps determine how many tools are needed to complete all surface material processing tasks. Considering the possibility of waste or incomplete utilization in actual operations, rounding up is used to ensure sufficient coverage.

[0098] Example 3

[0099] Assume that the surface material to be processed is 60cm x 60cm (i.e., La = 0.6m, Wa = 0.6m). The customer requires 100 tiles of this type, with a total area requirement Aa of 36 square meters. The minimum cutting quantity Q is 57 tiles.

[0100] Extracting intermediate file information: Extracting relevant information of the tile surface material from the intermediate file, including name Y (tile), specification size S (60cmx60cm), quantity Na (100 pieces), and minimum cutting quantity Q (57 pieces).

[0101] Find the matching processing parameter set P and calculate the total working time Sp: Assume that the processing parameter set of tiles contains the following three parameters: cutting time (Pi 1 = 0.5 hours / piece), grinding time (Pi2 = 0.3 hours / piece), and polishing time (Pi3 = 0.2 hours / piece).

[0102] Using the formula Sp = SUM (Pi): Sp = 0.5 + 0.3 + 0.2 = 1.0 hours per tile. For 57 tiles, the total working time is 57 * 1.0 = 57 hours.

[0103] Attach processing information and update the intermediate file: Attach the above processing parameter set P (including cutting time, grinding time and polishing time) and its corresponding total working time Sp (1.0 hour / piece) to the relevant entries in the intermediate file, and update the material entry.

[0104] Calculate the number of tools T required: Assume each tool can process J = 10 plates. Use the formula Tn = ceil(Q / J): Tn = ceil(57 / 10) = ceil(5.7) = 6 tools. Add the number of tools T required (6) to the intermediate file.

[0105] Step 4: Use the detailed processing guide to number the face materials and generate a preliminary bill of materials including numbers and sizes; specifically including:

[0106] Extract the surface material name Y, specification size S, quantity Na and processing parameter set P from the intermediate file, and assign a number Z to each surface material entry;

[0107] According to the number Z and the processing parameter set P, all surface material items are sorted by processing complexity, and the processing complexity of each surface material item is calculated using the formula O=SUM(Pi), and the sorting result is updated to the preliminary material list; this formula helps to understand the total working time or complexity required to complete all processing steps of a specific type of surface material, so as to sort it.

[0108] For each surface material item according to the number Z, add the corresponding specification size S information in the preliminary material list; ensure that each surface material item contains detailed specification size information.

[0109] Calculate the total area requirement for all surface material items in the preliminary bill of materials using the formula Aa = SUM(Na*La*Wa) and append the total area Aa to the preliminary bill of materials. This formula helps understand the total area required to cover a specific number of surface materials.

[0110] Example 4

[0111] Suppose you need to process a tile surface material with dimensions of 60 cm x 60 cm (i.e., La = 0.6 m, Wa = 0.6 m). The customer requires a total of 100 tiles of this type, with a total area requirement Aa of 36 square meters. The known processing parameters include cutting time (Pi 1 = 0.5 hours per tile), grinding time (Pi 2 = 0.3 hours per tile), and polishing time (Pi 3 = 0.2 hours per tile).

[0112] Extract intermediate file information and assign a number Z: Extract tile surface material information from the intermediate file, including name Y (tile), size S (60cmx60cm), quantity Na (100 pieces), and processing parameter set P (cutting time, grinding time, and polishing time). Assign a unique number Z (for example, Z1, Z2, ...) to each surface material entry.

[0113] Calculate and sort the processing complexity: Use the formula O = SUM(Pi) to calculate the processing complexity of each surface material item: O = 0.5 + 0.3 + 0.2 = 1.0 hours / piece. Sort all surface material items by processing complexity O (assuming all surface material items have the same processing complexity, there is no need to adjust the order). Update the sorting results to the preliminary material list.

[0114] Add specification and size information: In the preliminary material list, for each surface material item according to the number Z (such as Z1, Z2, ...), add the corresponding specification and size S (60cmx60cm) information.

[0115] Calculate the total area requirement and append it to the preliminary bill of materials: Use the formula Aa = SUM(Na*La*Wa) to calculate the total area requirement: Aa = 100*(0.6*0.6) = 36 square meters. Append the total area requirement Aa (36 square meters) to the preliminary bill of materials.

[0116] Step 5: Calculate the required material quantity for each surface material item in the preliminary material list and add it to the corresponding item; specifically including:

[0117] Extract the number Z, specification size S and quantity Na of each surface material item, use the formula Mm=Na*La*Wa to calculate the required material quantity Mm, and add the material quantity Mm to the corresponding surface material item; this formula helps to understand the total area or volume required to meet a specific number of surface materials.

[0118] According to the number Z, find the processing parameter set P of the surface material entry, and evaluate the material loss rate Dm caused by processing. Calculate the loss rate using the formula Dm = SUM(Pi*Ki), and add the loss rate Dm to the surface material entry. Ki is the loss coefficient corresponding to the i-th processing parameter. This formula helps understand the proportion of material loss caused by operations such as cutting and grinding during the processing process.

[0119] Using the material usage Mm and loss rate Dm, update the total demand Ta of each surface material item using the formula Ta=Mm*(1+Dm), and add the total demand Ta to the corresponding surface material item. This formula helps understand the total material required to meet actual demand, including the expected loss part.

[0120] Example 5

[0121] Assume that the tile surface material to be processed has a specification size of 60cmx60cm (ie La=0.6m, Wa=0.6m), and the customer needs a total of 100 pieces of this tile.

[0122] Extract information and calculate material consumption Mm: Extract relevant information of tile surface materials from the preliminary material list, including number Z (for example, Z1), specification size S (60cmx60cm), and quantity Na (100 pieces).

[0123] Use the formula Mm = Na * La * Wa to calculate the required material quantity: Mm = 100 * 0.6 * 0.6 = 36 square meters. Add the material quantity Mm (36 square meters) to the corresponding surface material entry.

[0124] Calculation of material loss rate Dm: Assume that the processing parameter set of tiles includes the following three parameters and their corresponding loss coefficients: cutting time (Pi 1 = 0.5 hours / piece, K1 = 0.05), grinding time (Pi2 = 0.3 hours / piece, K2 = 0.03), and polishing time (Pi 3 = 0.2 hours / piece, K3 = 0.02).

[0125] Use the formula Dm = SUM (Pi * Ki) to calculate the loss rate:

[0126] Dm = (0.5*0.05) + (0.3*0.03) + (0.2*0.02) = 0.025 + 0.009 + 0.004 = 0.038 or 3.8%. The loss rate Dm (3.8%) is added to the surface material entry.

[0127] Update the total demand Ta: Use the formula Ta = Mm * (1 + Dm) to update the total demand: Ta = 36 * (1 + 0.038) = 36 * 1.038 = 37.368 square meters. Add the total demand Ta (37.368 square meters) to the corresponding surface material entry.

[0128] Step 6: Convert the preliminary bill of materials with the material quantities attached into an electronic layout drawing and mark the node samples of each surface material; specifically include:

[0129] Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, and loss rate Dm;

[0130] Arrange and combine the materials, calculate the best layout plan to minimize waste, use the formula E=SUM(Tai / Ai) to calculate the efficiency ratio E, and select the layout plan with the highest efficiency ratio E as the basis for the electronic layout diagram; this formula helps evaluate the utilization rate of different layout plans and select the best plan that can maximize the use of area and reduce waste.

[0131] On the electronic layout drawing, all surface material items are placed according to the layout plan, and the node samples of each surface material item are marked; ensure that each surface material item is placed according to the optimal layout plan, and the node samples are marked in detail to facilitate the reference of construction personnel and improve installation accuracy and efficiency.

[0132] For each surface material item's node sample, calculate the required additional material quantity X, which is determined by the formula X=SUM(Nj*Lj*Wj). Add the additional material quantity X to the corresponding surface material item details, where Nj is the number of node samples, Lj and Wj are the length and width of the node samples, respectively. Accurately calculate the material requirements for the node samples to ensure that the materials are prepared in sufficient quantities and not in excess, reduce waste, and ensure construction quality.

[0133] Example 6

[0134] Assume that the tile surface material needs to be processed, and its specification size is 60cmx60cm (ie La=0.6m, Wa=0.6m). The customer needs a total of 100 pieces of this tile, the total demand Ta is 37.368 square meters, and the loss rate is 3.8%.

[0135] Extract information: Extract relevant information of ceramic tile surface materials from the preliminary material list, including number Z (for example, Z1), specification size S (60cmx60cm), quantity Na (100 pieces), total demand Ta (37.368 square meters) and loss rate Dm (3.8%).

[0136] Calculate the optimal layout: Assume there are three different layout options to choose from, and the available area under each option is:

[0137] Plan A: The usable area is 40 square meters.

[0138] Option B: The usable area is 38 square meters.

[0139] Option C: The usable area is 35 square meters.

[0140] Use the formula E = SUM (Tai / Ai) to calculate the efficiency ratio:

[0141] Solution A: E = 37.368 / 40 = 0.9342

[0142] Solution B: E = 37.368 / 38 = 0.9834

[0143] Solution C: E = 37.368 / 35 = 1.0676

[0144] Scheme C with the highest efficiency ratio E is selected as the basis for the electronic typesetting diagram.

[0145] Generate an electronic layout drawing and mark the joint samples: On the electronic layout drawing, place all tile items according to the layout plan of Plan C. Mark the joint samples of each surface material item, such as cutting points, splicing positions, etc.

[0146] Calculate the amount of additional material for the node sample: Assume that a node sample requires 5 tiles of special size, each with a size of 30cmx30cm (i.e. Lj=0.3m, Wj=0.3m).

[0147] Calculate the additional material amount using the formula X=SUM(Nj*Lj*Wj):

[0148] X = 5 * (0.3 * 0.3) = 5 * 0.09 = 0.45 m2. Add the additional material amount X (0.45 m2) to the corresponding surface material item details.

[0149] Step 7: Review all information in the electronic layout drawing to ensure that it is correct and generate the final bill of materials; specifically including:

[0150] The number Z, specification size S, quantity Na and additional material amount X of each surface material item in the electronic layout drawing are checked one by one to verify their consistency with the preliminary material list, and the total material requirement Mm is confirmed using the formula Mm=SUM(Nai*Lai*Wai), where Nai is the number of the i-th surface material item, Lai and Wai represent the length and width of the i-th surface material item respectively; ensure that the information of all surface material items in the electronic layout drawing is consistent with the preliminary material list to avoid errors caused by inconsistent data.

[0151] Based on the total material requirement Mm, calculate the actual demand Ya after loss adjustment, and calculate it using the formula Ya=Mm*(1+Dm). Compare the actual demand Ya with the total demand Ta marked in the electronic layout diagram; ensure that the actual demand takes into account all possible losses to avoid material shortages caused by failure to take losses into account.

[0152] Check whether each node sample on the electronic layout drawing meets the standard specifications. If not, update the details of the node sample and recalculate the associated additional material quantity X; ensure that all node samples meet the construction standards, ensure construction quality, and adjust material requirements according to actual conditions.

[0153] After confirming that all the information of the electronic layout drawing is accurate, the number Z, specification size S, quantity Na, total demand Ta, loss rate Dm and adjusted actual demand Ya of each surface material item are summarized to form the final material list.

[0154] Example 7

[0155] Assume that the tile surface material needs to be processed, and its specification size is 60cmx60cm (ie La=0.6m, Wa=0.6m). The customer needs a total of 100 pieces of this tile, the total demand Ta is 37.368 square meters, and the loss rate is 3.8%.

[0156] Verify the information and confirm the total material requirement Mm: Extract the relevant information of the tile surface material from the electronic layout drawing, including the number Z (for example, Z1), specification size S (60cmx60cm), quantity Na (100 pieces), and the additional material amount X (assuming it is 0.45 square meters).

[0157] Use the formula Mm = SUM(Nai * Lai * Wai) to calculate the total material requirement: Mm = 100 * 0.6 * 0.6 = 36 square meters. Check this information against the preliminary bill of materials to confirm that it is correct.

[0158] Calculate the actual demand after loss adjustment, Ya: Use the formula Ya = Mm * (1 + Dm) to calculate the actual demand: Ya = 36 * (1 + 0.038) = 36 * 1.038 = 37.368 square meters. Compare the actual demand Ya (37.368 square meters) with the total demand Ta (37.368 square meters) indicated on the electronic layout to confirm their consistency.

[0159] Check node samples and update details: Check whether each node sample on the electronic layout drawing complies with the standard specifications.

[0160] Assume that a certain node sample does not meet the specifications, update its details and recalculate the associated additional material quantity X.

[0161] Assume that the updated node template requires 6 tiles of special size, each with a size of 30cmx30cm (ie Lj=0.3m, Wj=0.3m).

[0162] The new additional material amount is calculated using the formula X=SUM(Nj*Lj*Wj): X=6*(0.3*0.3)=6*0.09=0.54 square meters.

[0163] Generate the final bill of materials: After confirming that all the information in the electronic layout drawing is correct, summarize the number Z (such as Z1), specification size S (60cmx60cm), quantity Na (100 pieces), total demand Ta (37.368 square meters), loss rate Dm (3.8%) and adjusted actual demand Ya (37.368 square meters) of each surface material item to form the final bill of materials.

[0164] Step 8: Complete the online ordering process based on the final material list; specifically including:

[0165] Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, loss rate Dm, and adjusted actual demand Ya, and use the formula Cc=SUM(Yai*Ci) to calculate the total cost Cc, where Yai is the adjusted actual demand of the i-th surface material item and Ci is the unit price of the i-th surface material; accurately calculate the total cost of the project and provide a basis for budget management and procurement decisions.

[0166] An order summary is generated based on the total cost Cc and the surface material item information, and the order summary is sent to the procurement platform for preliminary review; a detailed order summary is generated to facilitate the procurement platform to review and ensure that all information is accurate.

[0167] Check the lead time Ti provided by the procurement platform and determine the estimated delivery date Dd using the formula Dd = MAX(Ti) + L, where MAX(Ti) represents the maximum lead time and L is the fixed logistics time. This ensures that materials arrive on time and avoids construction delays caused by late deliveries. Submit the order request online and schedule subsequent construction based on the estimated delivery date Dd.

[0168] Example 8

[0169] Suppose a customer needs to process 60cm x 60cm ceramic tiles (La = 0.6m, Wa = 0.6m). The customer requires 100 tiles of this material, resulting in a total demand of 37.368 square meters (Ta). The loss rate is 3.8%, and the adjusted actual demand, Ya, is 37.368 square meters. The unit price of ceramic tiles is 50 yuan per square meter.

[0170] Extract information and calculate the total cost Cc: Extract relevant information of the "ceramic tile" surface material from the final material list, including the number Z (for example, Z1), specification size S (60cmx60cm), quantity Na (100 pieces), total demand Ta (37.368 square meters), loss rate Dm (3.8%), and adjusted actual demand Ya (37.368 square meters).

[0171] Use the formula Cc=SUM(Yai*Ci) to calculate the total cost: Cc=37.368*50=1868.4 yuan.

[0172] Generate an order summary and send it to the procurement platform: Based on the total cost Cc (1,868.4 yuan) and the surface material information, an order summary is generated. This summary includes the order number Z, size S, quantity Na, total demand Ta, loss rate Dm, and adjusted actual demand Ya. The order summary is sent to the procurement platform for preliminary review.

[0173] Check the delivery cycle and determine the estimated delivery date Dd: Assume that the delivery cycles provided by the procurement platform are:

[0174] Supplier A: The delivery period is 10 days.

[0175] Supplier B: The delivery period is 15 days.

[0176] Supplier C: The delivery period is 12 days.

[0177] Use the formula Dd = MAX(Ti) + L to determine the estimated delivery date: Maximum lead time MAX(Ti) = 15 days. Fixed logistics time L = 5 days. Dd = 15 + 5 = 20 days. The estimated delivery date is the current date plus 20 days.

[0178] Submit order requests online and arrange construction plans: Submit order requests online and arrange subsequent construction plans based on the expected delivery date to ensure that construction progress is not affected.

[0179] On the other hand, the present invention proposes a customized processing and order management system for decoration surface materials based on digital technology, such as Figure 2 Shown, including:

[0180] A database establishment module is used to collect decoration surface material requirements and design drawings, establish an initial database, match surface material sizes and types based on the data in the initial database, and store the results as an intermediate file;

[0181] A bill of materials preparation module is used to add processing information of the corresponding surface materials to the intermediate file to form a detailed processing guide, and use the detailed processing guide to number the surface materials to generate a preliminary bill of materials including numbers and dimensions;

[0182] an electronic layout drawing generation module, configured to calculate the required material quantity for each surface material item in the preliminary material list, append the required material quantity to the corresponding item, convert the preliminary material list with the appended material quantity into an electronic layout drawing, and mark the node pattern of each surface material;

[0183] The online ordering module is used to review all the information in the electronic layout drawing, generate the final material list after ensuring that it is correct, and complete the online ordering process based on the final material list.

[0184] In addition, when executed, the above modules are also used to implement other steps of the above-mentioned method for customized processing and order management of decorative surface materials based on digital technology, which will not be described one by one here.

[0185] In summary, the present invention realizes the automation and digital management of the entire process from demand collection to online ordering by directly attaching various types of decorative surface materials and corresponding processing technology information to the layout drawing, and generating a detailed material list containing material numbers, dimensions, processing technology and node samples; this not only improves work efficiency and reduces human errors, but also can accurately calculate material usage, effectively reduce material waste and shorten the project cycle.

[0186] Finally, it should be noted that the above is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for customized processing and order management of decorative surface materials based on digital technology, characterized in that: The steps include: Collecting decoration surface material requirements and design drawings, establishing an initial database, matching surface material sizes and types based on the data in the initial database, and storing the results as an intermediate file; Add processing information of the corresponding surface material to the intermediate file to form a detailed processing guide, use the detailed processing guide to number the surface material, and generate a preliminary material list including numbers and dimensions; Calculating the required material quantity for each surface material item in the preliminary material list and adding it to the corresponding item; converting the preliminary material list with the added material quantity into an electronic layout drawing, and marking the node sample of each surface material; Review all information in the electronic layout drawing, generate the final bill of materials after ensuring that it is correct, and complete the online ordering process based on the final bill of materials.

2. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 1, characterized in that: The collection of decoration surface material requirements and design drawings and the establishment of an initial database include: Receive requirement documents and design drawings from customers, and convert the information in the requirement documents and design drawings into structured data format; According to the structured data format, each type of decorative surface material is classified by name Y and specification size S. The quantity Na of each type of surface material is calculated using the formula Na = (Aa / (La*Wa)), where Aa is the total area required; La and Wa are the length and width of the surface material, i.e., the specification size S. Create an association table to match the classified surface materials with the corresponding quantity Na and record it in the initial database; Verify each record in the initial database to ensure the accuracy of the surface material name Y, specification size S and quantity Na, and complete the final confirmation by comparing the original requirement document and design drawings.

3. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 2, characterized in that: Matching the surface material size and type is performed based on the data in the initial database, and the results are stored as an intermediate file, including: Extracting association table information from the initial database, including surface material name Y, specification size S and quantity Na; Use the formula Ma = Na * (La * Wa) to calculate the total area Ma of the surface material required. Based on the total area Ma and the specification size S, find the stock material panels that meet the requirements and determine the minimum cutting quantity Q to meet the requirements. Calculate it using the formula Q = cei l (Ma / (Ls * Ws)), where Ls and Ws are the standard length and width of the stock panels, and cei l represents rounding up. The name Y of the surface material, the original specification size S, the required quantity Na, the calculated total area Ma and the determined minimum cutting quantity Q are recorded in the intermediate file.

4. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 3 is characterized in that: Add the processing information of the corresponding surface material to the intermediate file to form a detailed processing guide, including: Extracting information of the surface material name Y, specification size S, quantity Na and minimum cutting quantity Q from the intermediate file; According to the surface material name Y and specification size S, find the matching processing parameter set P, and use the formula Sp = SUM(Pi) to calculate the total working time Sp corresponding to each process parameter set, where Pi is the i-th parameter value in the process parameter set; Append the detailed information in the processing parameter set P to the relevant entries in the intermediate file and update the material entries; The number of tools T required for the surface material is calculated using the formula Tn=ceil(Q / J), where J represents the number of panels that each tool can process. The required number of tools T is added to the intermediate file.

5. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 4 is characterized in that: Using the detailed processing instructions, number the face materials and generate a preliminary bill of materials with numbers and dimensions, including; Extract the surface material name Y, specification size S, quantity Na and processing parameter set P from the intermediate file, and assign a number Z to each surface material entry; According to the number Z and the processing parameter set P, all surface material items are sorted by processing complexity, the processing complexity of each surface material item is calculated using the formula O=SUM(Pi), and the sorting result is updated to the preliminary material list; For each surface material item, add the corresponding specification size S information in the preliminary material list according to the number Z; Calculate the total area requirement for all surface material items in the preliminary bill of materials using the formula Aa = SUM(Na*La*Wa) and append the total area Aa to the preliminary bill of materials.

6. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 5 is characterized in that: Calculate the required material quantity for each surface material item in the preliminary bill of materials and add it to the corresponding item, including: Extract the number Z, specification size S and quantity Na of each surface material item, calculate the required material quantity Mm using the formula Mm=Na*La*Wa, and add the material quantity Mm to the corresponding surface material item; According to the number Z, search for the processing parameter set P of the surface material entry, and evaluate the material loss rate Dm caused by processing. The loss rate is calculated using the formula Dm=SUM(Pi*Ki), and the loss rate Dm is added to the surface material entry, where Ki is the loss coefficient corresponding to the i-th processing parameter; Using the material usage Mm and loss rate Dm, the total demand Ta of each surface material item is updated using the formula Ta=Mm*(1+Dm), and the total demand Ta is added to the corresponding surface material item.

7. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 6, characterized in that: Convert the preliminary bill of materials with material quantities added into an electronic layout drawing and mark the node samples of each surface material, including: Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, and loss rate Dm; Arrange and combine the materials, calculate the best layout to minimize waste, calculate the efficiency ratio E using the formula E = SUM (Tai / Ai), and select the layout with the highest efficiency ratio E as the basis for the electronic layout diagram; On the electronic layout diagram, place all surface material items according to the layout plan and mark the node sample of each surface material item; For each surface material item's joint sample, calculate the required additional material quantity X, which is determined by the formula X=SUM(Nj*Lj*Wj). Add the additional material quantity X to the corresponding surface material item details, where Nj is the number of joint samples, Lj and Wj are the length and width of the joint samples, respectively.

8. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 7, characterized in that: Review all information in the electronic layout drawing and generate the final bill of materials after ensuring that it is correct, including: Check the number Z, specification size S, quantity Na, and additional material amount X of each surface material item in the electronic layout drawing one by one to verify their consistency with the preliminary material list, and use the formula Mm = SUM(Nai*Lai*Wai) to confirm the total material requirement Mm, where Nai is the quantity of the i-th surface material item, Lai and Wai represent the length and width of the i-th surface material item respectively; Based on the total material demand Mm, calculate the actual demand Ya after loss adjustment using the formula Ya=Mm*(1+Dm), and compare the actual demand Ya with the total demand Ta marked in the electronic layout diagram; Check whether each node sample on the electronic layout drawing complies with the standard specification. If not, update the details of the node sample and recalculate the associated additional material quantity X; After confirming that all the information of the electronic layout drawing is accurate, the number Z, specification size S, quantity Na, total demand Ta, loss rate Dm and adjusted actual demand Ya of each surface material item are summarized to form the final material list.

9. The method for customized processing and order management of decorative surface materials based on digital technology according to claim 8, characterized in that: Complete the online ordering process based on the final bill of materials, including: Extract the information of each surface material item's number Z, specification size S, quantity Na, total demand Ta, loss rate Dm, and adjusted actual demand Ya. Calculate the total cost Cc using the formula Cc = SUM(Yai * Ci), where Yai is the adjusted actual demand for the i-th surface material item and Ci is the unit price of the i-th surface material. Generate an order summary based on the total cost Cc and the surface material item information, and send the order summary to the procurement platform for preliminary review; Check the lead time Ti provided by the procurement platform and determine the expected delivery date Dd using the formula Dd = MAX(Ti) + L, where MAX(Ti) represents the maximum lead time and L is the fixed logistics time. Submit the order request online and arrange the subsequent construction plan based on the expected delivery date Dd.

10. A digital technology-based customized processing and order management system for decorative surface materials for implementing the method according to any one of claims 1 to 9, characterized in that: include: A database establishment module is used to collect decoration surface material requirements and design drawings, establish an initial database, match surface material sizes and types based on the data in the initial database, and store the results as an intermediate file; A bill of materials preparation module is used to add processing information of the corresponding surface materials to the intermediate file to form a detailed processing guide, and use the detailed processing guide to number the surface materials to generate a preliminary bill of materials including numbers and dimensions; an electronic layout drawing generation module, configured to calculate the required material quantity for each surface material item in the preliminary material list, append the required material quantity to the corresponding item, convert the preliminary material list with the appended material quantity into an electronic layout drawing, and mark the node pattern of each surface material; The online ordering module is used to review all the information in the electronic layout drawing, generate the final material list after ensuring that it is correct, and complete the online ordering process based on the final material list.

Images