A cable construction cable intelligent warehouse-out management method

Abstract

The application belongs to the field of intelligent management systems, and mainly relates to a cable construction cable intelligent warehouse-out management method, characterized in that the method comprises the following steps: S1, constructing a multi-state constraint inventory data model, and establishing an inventory account record; S2, sending a warehouse-out request to the model, including data information of required cables; S3, screening specification information of the required cables to obtain a list of available inventory cable rolls conforming to the specification and model, and further executing a two-stage intelligent roll selection algorithm to calculate a combination mode of the required cable length L and find an optimal warehouse-out scheme; S4, outputting the optimal warehouse-out scheme, and executing inventory warehouse-out pre-locking and warehouse-out single generation; and S5, executing on-site acceptance and final warehouse-out confirmation. The application can realize accurate cable inventory management, and intelligently and efficiently solve the warehouse-out roll selection optimization problem, so as to reduce material waste and improve management efficiency.

Description

Technical Field

[0001] This invention relates to the field of intelligent management systems, and in particular to an intelligent outbound management method for cable construction. Background Technology

[0002] In the process of cable construction management, cable outbound management is one of the core links, and its decisions are directly related to project costs and material utilization.

[0003] Currently, the following technical problems commonly exist in the cable outbound process: (1) Manual selection of cable rolls is inefficient and wasteful: Construction workers often rely on experience to select cable rolls from inventory. The decision-making process is arbitrary and lacks scientific and quantitative calculation basis. This often results in too much leftover material after cutting or requires multiple cuts to reach the required length. This not only increases the workload of construction, but also causes serious waste of cable leftover material and increases the cost of engineering materials.

[0004] (2) Discrepancy between inventory records and actual inventory: Traditional inventory management relies on paper ledgers or simple spreadsheets. Outbound information is not updated in a timely and accurate manner, resulting in discrepancies between inventory data (such as total length, available length, and locked length) and actual physical inventory. Managers find it difficult to grasp the real-time and accurate inventory status, which in turn affects procurement and construction plans. Summary of the Invention

[0005] Therefore, this invention proposes a method that enables precise management of cable inventory and intelligently and efficiently solves the problem of optimizing the selection of cable rolls for outbound shipment, thereby reducing material waste and improving management efficiency.

[0006] A method for intelligent outbound management of cables used in cable construction includes the following steps: S1. Construct a multi-state constrained inventory data model and establish inventory ledger records; S2. Send an outbound request to the model, including the data information of the required cables; S3. The model filters and obtains a list of available stock cable rolls that meet the required cable specifications based on the required cable specifications. It then executes a two-stage intelligent roll selection algorithm to calculate the combination of required cable lengths L and find the optimal outbound solution. The two-stage intelligent test paper selection algorithm includes: In the first stage, dynamic programming is used to determine whether there exists a set of cable rolls in the inventory such that the sum of the lengths of all elements Sum is equal to the required cable length L. If such a set exists, a backtracking algorithm is used to reconstruct the specific cable roll combination selected in the set as the optimal outbound plan. If such a set does not exist, the second stage is performed. In the second stage, we find an optimal set of cable rolls, where the sum of the lengths of all elements in the set is Sum, the remaining usable length is LC, and the length of the remaining material after cutting the cable rolls into the set is the minimum length of rem. We obtain the scheme with rem ≥ 0. At this point, we use a backtracking algorithm to reconstruct the specific cable roll combination selected in the set as the optimal outbound scheme. S4. Output the optimal outbound plan, execute inventory outbound pre-locking and outbound order generation; S5. Conduct on-site inspection and final outbound confirmation.

[0007] Furthermore, the inventory database model includes: cable product table, inventory ledger table, purchase order table, receiving order table, cable roll information table, outgoing order table, outgoing roll association table, and inventory flow table.

[0008] Furthermore, multi-state constraints include: The inventory ledger has three numerical constraints. For each cable specification, the total inventory length (Total) is equal to the sum of the currently available length (Available) and the locked length (Locked). The inbound, outbound pre-locking, outbound confirmation, and outbound cancellation operations all need to maintain this equation in the transaction and prevent concurrent corruption through row-level locks. State constraints: The states in the cable product table, purchase order table, warehouse receipt table, and warehouse delivery table can only flow according to the predetermined state and direction, and reverse or skipping flow is prohibited; Cross-entity state consistency constraint: After the cable roll is confirmed to be "outbound" or "inbound", the corresponding outbound and inbound order forms should be in the "completed" state; the change length in the inventory flow table corresponds to the inventory length before and after the change and the historical records of the inventory ledger.

[0009] Furthermore, obtaining a list of available stock cable reels that meet the specifications includes: determining that the cable specifications match the specified cable specifications, the status is "in stock", and the remaining length is greater than 0.

[0010] According to claim 4, the intelligent cable outbound management method for cable construction is characterized in that, before executing the two-stage intelligent roll selection algorithm, it further includes: determining whether the total length Sum of the existing stock of cable rolls is greater than or equal to the required cable length L; if so, proceeding to the first stage; if not, indicating insufficient stock.

[0011] Furthermore, the optimal outbound plan is output, and the processes of pre-locking inventory outbound and generating outbound orders include the following steps: Based on the optimal outbound plan, generate an outbound order, set the status of the stock cable rolls in the optimal outbound plan to "pending outbound", and record the ID and length of each cable roll. Update the inventory ledger. For each cable roll in the outbound plan, reduce the corresponding outbound length in the Available inventory record and increase the corresponding outbound length in the Locked inventory record. Record this in the inventory flow table. Generate a QR code for each selected cable reel. The QR code contains information such as cable ID, specifications, model, voltage rating, core material, and cable length.

[0012] Furthermore, the on-site acceptance and final outbound confirmation process includes the following steps: Construction workers scan the QR code on the cable reel with a mobile terminal to obtain the cable reel information and verify it with the actual cable on site; Determine whether the acceptance results are consistent with the outbound results; If the acceptance result is "consistent", the server performs the final outbound confirmation operation, reduces the length Locked corresponding to the cable roll, reduces the total inventory length Total by the same amount, and keeps the current available length Available unchanged, ultimately balancing the three fields. Simultaneously update the cable reel status. If the remaining length rem of the cable reel is 0, the status changes to "Out of Stock"; if the remaining length rem of the cable reel is greater than 0, the status reverts to "In Stock"; when all cable reels under the outbound order are confirmed as completed, update the outbound order status to "Completed". If the acceptance result is "inconsistent", record the exception and handle the error or reconfirm.

[0013] Furthermore, the method also includes full-process status tracking and synchronously updating the acceptance records into the information of the inventory data model to form a complete, traceable, and easily inspectable lifecycle archive.

[0014] A smart cable outbound management system for cable construction includes an inventory data model, a multi-constraint module, and a two-stage intelligent algorithm module. The inventory data model is used to manage cable inventory, inbound, and outbound information; The multi-constraint module is used for constraint management of the data in the inventory data model; The dual-stage intelligent algorithm module is used to match and calculate the input outbound request with the data in the inventory data model to generate the optimal outbound plan.

[0015] Furthermore, the system is equipped with a mobile terminal and a PC terminal, and operators can input data into the inventory data model and confirm cable information and status on both the mobile terminal and the PC terminal.

[0016] The beneficial effects of this application are as follows: (1) High accuracy of outbound decision-making and reduction of waste material to the theoretical minimum. Based on the two-stage intelligent roll selection algorithm, the first stage achieves zero cutting by searching for a completely matching whole roll combination through subset and dynamic programming. The second stage enumerates potential cut rolls and seeks the solution to minimize waste material. Mathematical optimization replaces manual experience judgment, which completely solves the problem of waste material caused by traditional “using large materials for small purposes” and multiple cutting. The cable waste material rate can be reduced to the theoretical minimum, which significantly saves engineering material costs.

[0017] (2) Strong consistency of inventory data to prevent discrepancies between records and actual inventory. An inventory ledger model with mutual constraints of three fields, namely “total inventory length”, “current available length” and “locked length”, and combined with database row-level locking and atomic transaction mechanism, is used to physically isolate “planned to be issued but not actually used” inventory from actual available inventory. This effectively avoids the overselling and data inconsistency problems common in traditional paper ledgers or simple tables, and provides a reliable data foundation for management decisions.

[0018] (3) Full-process closed-loop management and control to achieve traceable dynamic tracking. By defining the multi-level state machine linkage of cable rolls, purchase orders, warehouse entry orders and warehouse exit orders, and using QR codes to bind the physical objects with the system records in an immutable manner, the state changes of the cables are fully recorded; managers can trace the complete circulation history of any cable roll at any time, realizing a two-way closed loop between warehouse exit and the field.

[0019] (4) High degree of automation, significantly reducing human error. The system connects a series of operations such as outbound application, inventory verification, intelligent roll selection, pre-locking, QR code generation, on-site acceptance, final deduction, and status update into an automated pipeline. It minimizes manual intervention and manual data entry, fundamentally avoiding human errors caused by misremembering, miscalculating, or misfilling.

[0020] (5) The level of intelligent operation and maintenance has been significantly improved, supporting the transformation to digital management. The system supports the collaboration between the PC-based management platform and the mobile terminal on-site operation, promoting the transformation of cable construction material management from traditional manual ledgers and experience-based decision-making to digitalization, intelligence, and closed-loop management, providing a powerful tool for the refined management and control of electrical construction. Attached Figure Description

[0021] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0022] Figure 1 This is a schematic diagram illustrating the implementation process of an intelligent outbound management method for cable construction. Figure 2 This is a flowchart illustrating a smart cable outbound management system for cable construction. Figure 3 This is a diagram illustrating the relationships within the inventory data model. Figure 4 This is a schematic diagram illustrating the constraints of the inventory data model. Figure 5 This is a flowchart illustrating the first stage of the algorithm; Figure 6 This is a flowchart illustrating the second-stage algorithm. Figure 7 A detailed flowchart illustrating the process of outputting the optimal solution for step S4; Figure 8 This is a schematic diagram illustrating the specific process of performing on-site acceptance and final outbound confirmation in step S5. Detailed Implementation

[0023] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application. All other implementations obtained by those skilled in the art based on the embodiments of this application without inventive effort are within the scope of protection of this application. In the various drawings, the same elements are represented by the same or similar reference numerals, and for clarity, the various parts in the drawings are not drawn to scale.

[0024] See Figure 1-4 As shown, this application proposes an intelligent cable outbound management system for cable construction, characterized by including an inventory data model, a multi-constraint module, and a two-stage intelligent algorithm module. The inventory data model is used to manage cable inventory, inbound, and outbound information; The multi-constraint module is used for constraint management of the data in the inventory data model; The dual-stage intelligent algorithm module is used to match and calculate the input outbound request with the data in the inventory data model to generate the optimal outbound plan.

[0025] Specifically, the system has a mobile terminal and a PC terminal, and operators can input data into the inventory data model and confirm cable information and status on both the mobile terminal and the PC terminal.

[0026] This invention proposes an implementation example of an intelligent cable outbound management method for cable construction. Figure 1-8 As shown, it includes the following steps: S1. Construct a multi-state constrained inventory data model and establish inventory ledger records.

[0027] See Figure 2 As shown, specifically, the inventory database model includes: The cable product table stores the master data for cable specifications and models. Fields include cable ID, specifications, model, voltage rating, and core material. The inventory ledger records real-time inventory summary information by cable product, with fields including cable ID, total inventory length, currently available length, and locked length. The purchase order table is used to record cable purchase orders. Fields include purchase order ID, cable ID, purchase order number, purchase quantity, quantity to be received, and purchase status. The Inbound Order table is used to record inbound operations. Fields include Inbound Order ID, Inbound Order Number, Cable ID, Inbound Length, Inbound Roll Count, Associated Purchase Order Number, and Inbound Order Status. The cable reel information table records detailed information about each physical cable reel, with fields including cable reel ID, cable ID, RFID / SN code, current remaining length, cable reel status, and project tracking information. The outbound order table records outbound operations. Fields include outbound order ID, outbound order number, cable ID, outbound length, usage project and section, and outbound order status. The outbound roll association table enables a many-to-many relationship between outbound orders and cable rolls, recording the length used for each roll in this outbound process and the remaining length after use. The inventory log records the audit trail of each inventory change, including document type, change length, and inventory length before and after the change.

[0028] Specifically, multi-state constraints include: (1) Three-field numerical constraints of inventory ledger: For each cable specification, the total inventory length Total is equal to the sum of the currently available length Available and the locked length Locked. Any inbound, outbound pre-locking, outbound confirmation, and outbound cancellation operations must maintain this equation in the transaction and prevent concurrent destruction through row-level locks.

[0029] (2) Status constraints: The status in the cable product table, purchase order table, warehouse receipt table and warehouse delivery table can only flow in the predetermined status and direction. Reverse or skipping flow is prohibited, including the following; Cable reel state machine constraints: The state of each cable reel can only flow between "In Stock", "Outgoing", and "Outgoing" in a predetermined direction. Upon entering the warehouse, it initially enters as "In Stock". After being selected by an outgoing order and pre-locked, it changes to "Outgoing". Finally, upon confirmation of outgoing, if the remaining length is used up, it changes to "Outgoing"; if there is remaining material, it returns to "In Stock". Reverse or skipping flow is prohibited. Purchase order status flow constraints: Status includes purchased, partially received, received, and cancelled. Only the "purchased" status allows cancellation or receipt. After deducting the quantity to be received during the receipt operation, it will automatically determine whether to change to partial receipt or receipt. Inbound order status flow constraints: Status includes pending inbound, completed, and canceled. Only the pending inbound status can perform the confirmation inbound or cancellation operation. After confirming inbound, it is necessary to trigger the inventory increase, cable roll creation, and purchase order pending inbound quantity update. Outbound order status flow constraints: Status includes pending outbound, confirmed, completed, cancelled, and error. In the pending outbound status, pre-locking and QR code generation can be performed. After the outbound is confirmed, it changes to confirmed and awaits mobile terminal acceptance. After all acceptances are passed, it is aggregated into completed. If any acceptance is inconsistent, it changes to error, and it supports reconfirmation from the error status to overwrite the exception.

[0030] (3) Consistency constraints across entities: After the cable rolls are confirmed as "outbound" or "inbound", the corresponding outbound and inbound order forms should be in the "completed" state; the change length in the inventory flow table corresponds to the inventory length before and after the change and the historical records in the inventory ledger. When the cable roll status is "outbound", there are associated outbound roll records and the corresponding outbound order status is "pending outbound" or "confirmed"; when the outbound order status is "completed", all associated cable rolls have been confirmed as "outbound" or there are surplus materials returned to "in stock"; the change length in the inventory flow table corresponds to the inventory length before and after the change and the historical records in the inventory ledger.

[0031] If the above consistency constraint verification fails, the system will immediately roll back the current transaction and throw a state inconsistency exception, prompting the operator to check the data and re-operate. This avoids state fragmentation and data mismatch between different entities, ensuring data consistency across all nodes in the entire outbound process from a rule-based perspective. Multi-level, cross-table states and their linkage rules together constitute the multi-state constraint mechanism of this invention, ensuring the correctness of business semantics and data consistency throughout the entire lifecycle of cable management.

[0032] S2. Send an outbound request to the model, including the data information of the required cables.

[0033] Specifically, step S2 includes the following sub-steps; S21. The user inputs the correct cable specifications and the required length information (non-zero).

[0034] S22. The system obtains a list of available cable reels that meet the requirements, which includes the following sub-steps: S221. First, query the list of available cable rolls corresponding to the cable specifications included in the outbound request. The query conditions include cable specifications, status of "in stock" and remaining length greater than 0. S222. The system further filters out cable reels with error confirmation records to ensure that only cable reels that can be shipped out normally are retained in the list. S223. Verify whether the current available total length corresponding to this specification is greater than the required length. If yes, proceed to step S3; otherwise, return the information that the inventory is insufficient.

[0035] S23. Reorder the obtained list of available cable rolls according to the user-specified roll selection rule sortPreference.

[0036] Specifically, the sortPreference rule is the selection of whether to prioritize taking cable rolls that were put into storage earlier or later when the cable rolls are taken out of storage, including: When sortPreference is 0 or null, it sorts in ascending order by entry time, making index 0 the earliest entry volume. In this mode, subsequent algorithms will prioritize the volume that was entered later while ensuring the minimum amount of remaining material, thus achieving the effect of prioritizing the acquisition of cable volumes that were entered later. When sortPreference is 1, the data is sorted in descending order by entry time, so that index 0 is the most recently entered volume. In this mode, the subsequent algorithm will prioritize the volume that was entered earlier while ensuring that the remaining data is minimized, thus achieving the effect of prioritizing the acquisition of cable volumes that were entered earlier.

[0037] S3. Filter the required cable specifications to obtain a list of available stock cable reels that meet the specifications and models. Then, execute a two-stage intelligent reel selection algorithm to calculate the combination of required cable lengths L and find the optimal outbound solution.

[0038] Let S = {s1, s2, ..., si, ..., sn} be a set of positive integers, where i is the index of the inventory rolls sorted according to the roll selection rules, n is the total number of inventory rolls, si is the remaining length of the i-th roll, and the required cable length is L. Determine if the total length of the existing cable rolls in stock (Sum) is greater than or equal to the required cable length (L). If yes, proceed to the first stage; otherwise, report an error and output "Insufficient stock".

[0039] See Figure 5 As shown, in the first stage, dynamic programming is used to determine whether there exists a set of cable rolls in the inventory such that the sum of the lengths of all elements Sum is equal to the required cable length L. If it exists, a backtracking algorithm is used to reconstruct the specific cable roll combination selected in the set as the optimal outbound plan. If it does not exist, the second stage is performed. Define a Boolean state array dp, where dp[x] represents the number of cable rolls selected from the inventory, the sum of which is x. Initialize dp[0]=true, indicating that the length is 0 and reachable; otherwise, dp[x]=false, and the actual record is dp={0}. Iterate through each cable roll in turn. Let the remaining length of the currently traversed cable roll be si. For the current length x, decrease from L down to si. If dp[x - si] is true, then set dp[x] to true. In practice, this is recorded as adding element x to the dp set.

[0040] Example 1: The number of cable reels is 10, and the set of reel lengths (in cm) is {300, 500, 200, 700, 400, 600, 100, 800, 300, 500}, with a required length of 1500cm.

[0041] Dynamic programming: Initialize dp={0}. Handle roll[0]=300, traverse the first volume in the forward direction, and traverse the state in the reverse direction when s=1500→300. The complete traversal process is as follows:

[0042] The complete traversal process when rolling[1] = 500 (forward traversal of the second volume, reverse traversal of state s=1500→500) is shown in the table below:

[0043] The complete traversal process when rolling[2] = 200 (forward traversal of the 3rd volume, reverse traversal of state s=1500→200) is shown in the table below: s checks the result of dp[s-200].

[0044] Similarly, the cable roll is traversed in the forward traversal order, the state is traversed in reverse traversal s, and dp is updated; the specific process is omitted until the traversal is completed roll[9]=500.

[0045] The dp array is checked to see if it contains the element 1500. The result is that it does, i.e., dp

[1500] = true, indicating that there exists a whole volume combination that exactly equals the required length. The backtracking algorithm is then used to determine which volumes were selected.

[0046] Backtracking algorithm: Set rem=15, the specific traversal process is as follows:

[0047] When rem=0, the backtracking ends.

[0048] Backtrack the selected volume index (in the order of discovery): [9,8,6,5].

[0049] In the second stage, an optimal set of cable rolls is found, where the sum of the lengths of all elements in the set is Sum, the remaining usable length is LC, and the remaining length after cutting the cable roll set into the required cable is rem = LC - (L - Sum). The scheme with the minimum rem is obtained, and rem ≥ 0. At this time, the backtracking algorithm is used to restore the specific cable roll combination selected in the set as the optimal outbound scheme.

[0050] See Figure 6 As shown, specifically, the second stage includes the following steps: Iterate through each stock cable roll in turn and treat it as a candidate roll C for cutting. Let the remaining usable length of C be LC. For each candidate split volume C, there exists a set as the optimal whole volume combination, where the sum of the lengths of all elements in this set is maximized and satisfies Sum ≤ L, and L - Sum <LC; The optimal outbound solution is to select the set of cable reels with the smallest remaining length (rem) after cutting the required cables.

[0051] Example 2: The number of cable reels is 5, and the set of reel lengths (in cm) is {80, 120, 60, 150, 100}. The required length L is 285cm. Phase one has no feasible solution, so the specific process is omitted here. Phase two begins by enumerating each reel as a cutting reel.

[0052] Initialize the optimal scheme: Remnant is L, the optimal split volume index is -1, the optimal whole volume and Sum are -1, the minimum index of the optimal whole volume is initialized to the maximum integer, and the optimal whole volume index list is initialized to null.

[0053] Take the first volume as the cutting volume (length LC=roll[0]=80): exclude volume 0, the remaining volumes others=[120,60,150,100], the search range of s: minTargetSum=max(0,L-LC) =205, maxTargetSum=L=285. Perform subset and DP on others, enumerate s from 285 down to 205, find the largest s that makes dp[s]=true, that is, the largest feasible whole volume sum s, and get the largest s, that is, Sum=270. Calculate that the cutting volume cutting length at this time =L-Sum=15, Remnant=roll[0], cutting length=65.

[0054] Using a backtracking algorithm, we backtrack to the other volumes at this point and find the volume with index [1,3]. Comparison shows that the current Remnant is less than the Remnant of the optimal solution. Therefore, we update the optimal solution to the volume combination at this point, record Remnant=65, the optimal split volume index as 0, the optimal whole volume sum as 270, the optimal whole volume minimum index as 1, and the optimal whole volume index list as [1,3].

[0055] Take the second volume as the cutting volume (length LC=roll[1]=120): exclude volume 1, the remaining volumes others=[80,60,150,100], the search range of s: minTargetSum=max(0,L-LC)=165, maxTargetSum=L=285. Perform subset and DP on others, enumerate s from 285 down to 165, find the largest s that makes dp[s]=true, that is, the largest feasible whole volume and s, and get the largest s, that is, Sum=250. Calculate that the cutting volume cutting length at this time =L-Sum=35, Remnant=roll[0], cutting length=85. Use the backtracking algorithm to backtrack the other volumes at this time, and find that the selected volume is the volume with index [3,4]. Compare and find that the Remnant at this time is greater than the Remnant of the optimal solution, so do not update.

[0056] Take the third volume as the cutting volume (length LC=roll[2]=60): exclude volume 2, the remaining volumes others=[80,120,150,100], the search range of s: minTargetSum=max(0,L-LC)=225, maxTargetSum=L=285. Perform subset and DP on others, enumerate s from 285 down to 225, find the largest s that makes dp[s]=true, that is, the largest feasible whole volume sum s, and get the largest s, that is, Sum=270. Calculate that the cutting volume cutting length at this time =L-Sum=15, Remnant=roll[0], cutting length=45. Use the backtracking algorithm to backtrack the other volumes at this time, and find that the selected volume is the volume with index [1,3]. Compare and find that the Remnant at this time is less than the Remnant of the optimal solution, update the optimal solution.

[0057] The subsequent enumeration follows the same process as above until all cable rolls have been enumerated. The optimal solution, i.e., the final result, is output: Remnant=45, the optimal cut roll index is 2, the optimal whole roll sum is 270, and the optimal whole roll index list is [1,3].

[0058] S4. Output the optimal outbound plan, execute inventory outbound pre-locking and outbound order generation.

[0059] See Figure 7As shown, specifically, outputting the optimal outbound plan and executing inventory outbound pre-locking and outbound order generation includes the following steps: S41. Based on the optimal outbound plan, generate an outbound order, set the status of the stock cable rolls in the optimal outbound plan to "pending outbound", and record the ID and length of each cable roll. S42. Update the inventory ledger. For each cable roll in the outbound plan, reduce the corresponding outbound length in Available and increase the corresponding outbound length in Locked in the corresponding inventory record, and record it in the inventory flow table. S43. Generate a QR code for each selected cable reel. The QR code contains cable ID, specifications, model, voltage rating, core material, and cable length information. If multiple reels are shipped, package them into a ZIP file for download.

[0060] S5. Conduct on-site inspection and final outbound confirmation.

[0061] See Figure 8 As shown, the on-site acceptance and final outbound confirmation process specifically includes the following sub-steps: S51. Construction personnel scan the QR code on the cable reel with a mobile terminal to obtain the cable reel information and verify it with the actual cable on site. S52. The mobile terminal sends the acceptance result to the server to determine whether the acceptance result is consistent with the outbound result. S53. If the acceptance result is "consistent", the server performs the final outbound confirmation operation, reduces the length Locked corresponding to the cable roll, reduces the total inventory length Total by the same amount, and keeps the current available length Available unchanged, ultimately balancing the three fields. S54. Update cable reel status. If the remaining length rem of the cable reel is 0, the status changes to "Out of Stock"; if the remaining length rem of the cable reel is greater than 0, the status returns to "In Stock"; when all cable reels under the outbound order are confirmed as completed, the outbound order status is updated to "Completed". If the acceptance result is "inconsistent", an anomaly will be recorded, and administrators will be allowed to process the error or reconfirm it on the PC.

[0062] Specifically, the method further includes: S6. Full-process status tracking: Based on the operations in the above steps, the system synchronously updates the status of the cable reel and the status of the delivery note, and adds the acceptance record to the project tracking information of the cable reel, forming a complete, traceable, and easily inspectable lifecycle file. Specifically, this includes updating the status of the cable reel from "in stock" to "outbound," "outbound," or "in stock"; and updating the status of the delivery note from "pending outbound" to "completed" or "error reported."

[0063] The beneficial effects of this application are as follows: (1) High accuracy of outbound decision-making and reduction of waste material to the theoretical minimum. Based on the two-stage intelligent roll selection algorithm, the first stage achieves zero cutting by searching for a completely matching whole roll combination through subset and dynamic programming. The second stage enumerates potential cut rolls and seeks the solution to minimize waste material. Mathematical optimization replaces manual experience judgment, which completely solves the problem of waste material caused by traditional “using large materials for small purposes” and multiple cutting. The cable waste material rate can be reduced to the theoretical minimum, which significantly saves engineering material costs.

[0064] (2) Strong consistency of inventory data to prevent discrepancies between records and actual inventory. An inventory ledger model with mutual constraints of three fields, namely “total inventory length”, “current available length” and “locked length”, and combined with database row-level locking and atomic transaction mechanism, is used to physically isolate “planned to be issued but not actually used” inventory from actual available inventory. This effectively avoids the overselling and data inconsistency problems common in traditional paper ledgers or simple tables, and provides a reliable data foundation for management decisions.

[0065] (3) Full-process closed-loop management and control to achieve traceable dynamic tracking. By defining the multi-level state machine linkage of cable rolls, purchase orders, warehouse entry orders and warehouse exit orders, and using QR codes to bind the physical objects with the system records in an immutable manner, the state changes of the cables are fully recorded; managers can trace the complete circulation history of any cable roll at any time, realizing a two-way closed loop between warehouse exit and the field.

[0066] (4) High degree of automation, significantly reducing human error. The system connects a series of operations such as outbound application, inventory verification, intelligent roll selection, pre-locking, QR code generation, on-site acceptance, final deduction, and status update into an automated pipeline. It minimizes manual intervention and manual data entry, fundamentally avoiding human errors caused by misremembering, miscalculating, or misfilling.

[0067] (5) The level of intelligent operation and maintenance has been significantly improved, supporting the transformation to digital management. The system supports the collaboration between the PC-based management platform and the mobile terminal on-site operation, promoting the transformation of cable construction material management from traditional manual ledgers and experience-based decision-making to digitalization, intelligence, and closed-loop management, providing a powerful tool for the refined management and control of electrical construction.

[0068] In the accompanying drawings of this embodiment, the same or similar reference numerals correspond to the same or similar components. In the description of this application, it should be noted that if terms such as "upper," "lower," "left," and "right" indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings, they are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, the terms used to describe positional relationships in the accompanying drawings are only for illustrative purposes and should not be construed as limiting this patent. For those skilled in the art, the specific meaning of the above terms can be understood according to the specific circumstances.

[0069] In this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, without necessarily requiring or implying any actual relationship or order between these entities or operations. Finally, it should be noted that the above embodiments are clearly illustrative of the invention and not intended to limit the implementation. Those skilled in the art will recognize that various variations and modifications can be made based on the above description. It is neither necessary nor possible to exhaustively describe all possible implementations. However, obvious variations and modifications derived therefrom remain within the scope of this invention.

Claims

1. A method for intelligent warehousing management of cables used in cable construction, characterized in that, Includes the following steps: S1. Construct a multi-state constrained inventory data model and establish inventory ledger records; S2. Send an outbound request to the model, including the data information of the required cables; S3. Based on the specifications of the required cables, filter to obtain a list of available stock cable reels that meet the specifications and models, and further execute a two-stage intelligent reel selection algorithm to calculate the combination of the required cable length L and find the optimal outbound solution. The two-stage intelligent test paper selection algorithm includes: In the first stage, dynamic programming is used to determine whether there exists a set of cable rolls in the inventory such that the sum of the lengths of all elements Sum is equal to the required cable length L. If such a set exists, a backtracking algorithm is used to reconstruct the specific cable roll combination selected in the set as the optimal outbound plan. If such a set does not exist, the second stage is performed. The second stage involves finding an optimal set of cable rolls, where the sum of the lengths of all elements in the set is Sum, and the remaining usable length is L. C The length of cable reel after cutting required for the cable. If the minimum rem is obtained and rem≥0, then the backtracking algorithm is used to restore the specific cable roll combination selected in the set as the optimal outbound plan. S4. Output the optimal outbound plan, execute inventory outbound pre-locking and outbound order generation; S5. Conduct on-site inspection and final outbound confirmation.

2. The intelligent cable outbound management system for cable construction according to claim 1, characterized in that, The inventory database model includes: cable product table, inventory ledger table, purchase order table, receiving order table, cable roll information table, outgoing order table, outgoing roll association table, and inventory flow table.

3. The intelligent warehousing management method for cable construction cables according to claim 2, characterized in that, Multi-state constraints include: The inventory ledger has three numerical constraints. For each cable specification, the total inventory length (Total) is equal to the sum of the currently available length (Available) and the locked length (Locked). The inbound, outbound pre-locking, outbound confirmation, and outbound cancellation operations all need to maintain this equation in the transaction and prevent concurrent corruption through row-level locks. State constraints: The states in the cable product table, purchase order table, warehouse receipt table, and warehouse delivery table can only flow according to the predetermined state and direction, and reverse or skipping flow is prohibited; For cross-entity state consistency constraints, after the cable rolls are confirmed as "outbound" or "inbound", the corresponding outbound and inbound order forms should be in the "completed" state; the changed length in the inventory flow table corresponds to the inventory length before and after the change and the historical records in the inventory ledger.

4. The intelligent warehousing management method for cable construction cables according to claim 3, characterized in that, Obtaining a list of available stock cable reels that meet the specifications includes: determining that the cable specifications match the specified cable specifications, the status is "in stock", and the remaining length is greater than 0.

5. The intelligent warehousing management method for cable construction cables according to claim 4, characterized in that, Before executing the two-stage intelligent cable selection algorithm, the following step is also included: determining whether the total length of the existing stock cable reels is Sum. 总 If the cable length is greater than or equal to the required cable length L, proceed to the first stage; otherwise, indicate insufficient stock.

6. The intelligent warehousing management method for cable construction cables according to claim 3, characterized in that, Outputting the optimal outbound plan and executing inventory outbound pre-locking and outbound order generation includes the following steps: Based on the optimal outbound plan, generate an outbound order, set the status of the stock cable rolls in the optimal outbound plan to "pending outbound", and record the ID and length of each cable roll. Update the inventory ledger. For each cable roll in the outbound plan, reduce the corresponding outbound length in the Available inventory record and increase the corresponding outbound length in the Locked inventory record. Record this in the inventory flow table. Generate a QR code for each selected cable reel. The QR code contains information such as cable ID, specifications, model, voltage rating, core material, and cable length.

7. The intelligent warehousing management method for cable construction cables according to claim 8, characterized in that, The on-site acceptance and final outbound confirmation process includes the following steps: Construction workers scan the QR code on the cable reel with a mobile terminal to obtain the cable reel information and verify it with the actual cable on site; Determine whether the acceptance results are consistent with the outbound results; If the acceptance result is "consistent", the server performs the final outbound confirmation operation, reduces the length Locked corresponding to the cable roll, reduces the total inventory length Total by the same amount, and keeps the current available length Available unchanged, ultimately balancing the three fields; Simultaneously update the cable reel status. If the remaining length rem of the cable reel is 0, the status changes to "Out of Stock"; if the remaining length rem of the cable reel is greater than 0, the status reverts to "In Stock"; when all cable reels under the outbound order are confirmed as completed, update the outbound order status to "Completed". If the acceptance result is "inconsistent", record the exception and handle the error or reconfirm.

8. The intelligent warehousing management method for cable construction cables according to claim 1, characterized in that, The method also includes full-process status tracking and synchronously updating the acceptance records into the information of the inventory data model to form a complete, traceable, and easily inspectable lifecycle archive.

9. A smart warehousing and management system for cable construction, characterized in that, Includes inventory data models, multi-constraint modules, and two-stage intelligent algorithm modules. The inventory data model is used to manage cable inventory, inbound, and outbound information; The multi-constraint module is used for constraint management of the data in the inventory data model; The dual-stage intelligent algorithm module is used to match and calculate the input outbound request with the data in the inventory data model to generate the optimal outbound plan.

10. The intelligent cable outbound management system for cable construction according to claim 9, characterized in that, The system is equipped with a mobile terminal and a PC terminal. Operators can input data into the inventory data model and confirm cable information and status on both the mobile terminal and the PC terminal.

Images