Replenishment order generation method and device, electronic equipment and storage medium
By receiving and storing sub-order information, determining the target sub-order and generating replenishment orders, the problem of the intelligent warehousing system being difficult to cope with changes in part consumption rate is solved, and flexible replenishment of parts and efficient utilization of warehouse space is achieved.
Patent Information
- Application Number
- CN202510621710.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-05-14
- Publication Date
- 2025-06-10
- Estimated Expiration
- 2045-05-14
AI Technical Summary
When judging the water level of parts inventory, existing intelligent warehousing systems are difficult to cope with changes in parts consumption rates caused by changes in production proportions of different products, resulting in excessive warehouse area or insufficient parts, resulting in production stagnation.
By receiving and storing sub-order information sent by preset terminals, determining the target sub-order, and determining whether to generate replenishment orders based on the order and inventory of the target sub-orders, we can achieve flexible replenishment of parts.
It realizes flexible replenishment of parts, reduces the area demand for storage parts in warehouses, avoids production stagnation caused by insufficient parts inventory, and improves the utilization rate of storage space in warehouses.
Smart Images

Figure CN120125148A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of logistics in flexible manufacturing enterprises, and particularly to a method, device, electronic device and storage medium for generating replenishment orders. Background Art
[0002] With the development of automation technology, more and more enterprise warehouses use intelligent warehousing systems to control mobile robots to move parts out of the warehouse and transport them to the production workstations that need to use these parts, improving the automation level of part handling in the warehouse.
[0003] Currently, intelligent warehousing systems generally determine whether the parts stored in the warehouse need to be replenished based on the inventory level. Specifically, an inventory level is set for each type of part. When the inventory of a certain part is lower than the inventory level, the intelligent warehousing system generates a replenishment order. However, with the change of consumer demand, the production ratio of different products changes, resulting in a change in the consumption rate of each part. Since the inventory level of each part is set in advance, in order to cope with the change of the consumption rate of each part, the inventory level of parts is usually set relatively high, so that a large number of parts need to be stored in the warehouse, resulting in a large area required for the warehouse. Summary of the Invention
[0004] The purpose of the embodiments of the present application is to provide a method, device, electronic device and storage medium for generating replenishment orders, so as to achieve flexible replenishment of parts and reduce the area occupied by storing parts in the warehouse. The specific technical solutions are as follows:
[0005] The embodiments of the present application provide a method for generating replenishment orders, the method comprising:
[0006] Receiving and storing in a database the respective priorities, order identifiers, part identifiers and part quantities of each sub-order sent by a preset terminal;
[0007] When arranging the sub-orders in order from first to last according to their respective priorities, the sub-orders in the first preset number of positions are determined as target sub-orders;
[0008] Judging whether a sub-order whose priority is one position before the first target sub-order is queried in the database; wherein, the first target sub-order is the sub-order with the earliest priority among all the target sub-orders;
[0009] For each second target sub-order, judging whether a sub-order whose priority is one position before the second target sub-order is queried among all the target sub-orders; wherein, the second target sub-order is a sub-order among the target sub-orders whose priority is not the earliest;
[0010] Judge whether each of the target sub-orders is repeated according to the sequence of each of the target sub-orders and the order identifier;
[0011] If a sub-order whose sequence is one position before the first target sub-order is queried in the database, and for each second target sub-order, a sub-order whose sequence is one position before the second target sub-order is queried in each of the target sub-orders, and each of the target sub-orders is not repeated, then for each of the target sub-orders, determine the inventory quantity of the parts represented by the part identifier of the target sub-order in the order of the sequences of each of the target sub-orders from the earliest to the latest;
[0012] For each of the target sub-orders, if the inventory quantity is less than the quantity of the parts of the target sub-order, then generate a replenishment order for the part identifier of the target sub-order;
[0013] If a sub-order whose sequence is one position before the first target sub-order is not queried in the database, and / or, for at least one second target sub-order, a sub-order whose sequence is one position before the second target sub-order is not queried in each of the target sub-orders, and / or, at least one of the target sub-orders is repeated, then send a message indicating an error in each of the target sub-orders to the preset terminal.
[0014] In a possible embodiment, the judging whether each of the target sub-orders is repeated according to the sequence of each of the target sub-orders and the order identifier includes:
[0015] Judge whether a first sub-order with the same sequence as the third target sub-order is queried in the database; wherein, the third target sub-order is the sub-order with the last sequence among each of the target sub-orders;
[0016] If a first sub-order with the same sequence as the third target sub-order is queried in the database, then for each of the first sub-orders with the same sequence, judge whether the order identifier of the first sub-order with the same sequence is the same as the order identifier of the third target sub-order;
[0017] For each fourth target sub-order, judge whether a second sub-order with the same sequence as the fourth target sub-order is queried in the target sub-orders; wherein, the fourth target sub-order is the sub-order whose sequence is not the last among each of the target sub-orders;
[0018] For each of the fourth target sub-orders, if a second sub-order with the same sequence as the fourth target sub-order is queried in the target sub-orders, then for each of the second sub-orders with the same sequence, judge whether the order identifier of the second sub-order with the same sequence is the same as the order identifier of the fourth target sub-order;
[0019] If the order identifier of each of the first same-sequence sub-orders is the same as the order identifier of the third target sub-order, and for each of the fourth target sub-orders, the order identifier of each of the second same-sequence sub-orders is the same as the order identifier of the fourth target sub-order, it is determined that each of the target sub-orders is not repeated;
[0020] If the order identifier of at least one of the first same-sequence sub-orders is not the same as the order identifier of the third target sub-order, and / or, for at least one of the fourth target sub-orders, the order identifier of at least one of the second same-sequence sub-orders is not the same as the order identifier of the fourth target sub-order, it is determined that at least one of the target sub-orders is repeated.
[0021] In a possible embodiment, after the step of receiving and storing in the database the respective sequence numbers, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal, the method further includes:
[0022] In response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as a non-verification sub-order;
[0023] Set a non-verification continuity identifier for the non-verification sub-order;
[0024] The determination of whether a sub-order whose sequence number is one before the first target sub-order is queried in the database includes:
[0025] If the first target sub-order is not set with the non-verification continuity identifier, determine whether a sub-order whose sequence number is one before the first target sub-order is queried in the database;
[0026] The determination of whether a sub-order whose sequence number is one before the second target sub-order is queried among the target sub-orders includes:
[0027] If the second target sub-order is not set with the non-verification continuity identifier, determine whether a sub-order whose sequence number is one before the second target sub-order is queried among the target sub-orders.
[0028] In a possible embodiment, the order identifier includes: an order number and an order line number, the order number is used to identify the order to which the sub-order belongs, and the order line number is used to identify the sub-order in the order.
[0029] In a possible embodiment, the database also stores the respective part identifiers and order statuses of each replenishment order; the order status of the replenishment order includes: new, in execution, and completed;
[0030] Determining the inventory quantity of the part represented by the part identifier of the target sub-order includes:
[0031] Determining the storage quantity of the part represented by the part identifier of the target sub-order;
[0032] Determining the first quantity of the part represented by the part identifier of the target sub-order in the replenishment order with the order status being newly created;
[0033] Determining the second quantity of the part represented by the part identifier of the target sub-order in the replenishment order with the order status being in execution;
[0034] Taking the sum of the storage quantity, the first quantity, and the second quantity as the inventory quantity of the part represented by the part identifier of the target sub-order;
[0035] Generating a replenishment order for the part identifier of the target sub-order includes:
[0036] Generating a replenishment order with the part identifier being the part identifier of the target sub-order, and setting the order status of the replenishment order to newly created;
[0037] In response to receiving a message indicating that the part represented by the part identifier of the replenishment order is put on the shelf, modifying the order status of the replenishment order to in execution;
[0038] In response to receiving a message indicating that the part represented by the part identifier of the replenishment order is transported to the warehouse, modifying the order status of the replenishment order to completed.
[0039] In a possible embodiment, generating a replenishment order with the part identifier being the part identifier of the target sub-order includes:
[0040] Generating a replenishment order with the part identifier being the part identifier of the target sub-order, and the replenishment quantity being the difference between the inventory quantity and the part quantity of the target sub-order.
[0041] An embodiment of the present application further provides a replenishment order generation device, and the device includes:
[0042] A receiving module, configured to receive and store in a database the sequence number, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal;
[0043] A target sub-order determination module, configured to determine, when arranging each of the sub-orders in order from first to last according to their respective sequence numbers, the sub-orders located in the first preset number of positions as target sub-orders;
[0044] The first judgment module is used to judge whether a sub-order whose sequence is one position before the first target sub-order is queried in the database; wherein, the first target sub-order is the sub-order with the earliest sequence among all the target sub-orders;
[0045] The second judgment module is used to judge, for each second target sub-order, whether a sub-order whose sequence is one position before the second target sub-order is queried in all the target sub-orders; wherein, the second target sub-order is a sub-order whose sequence is not the earliest among the target sub-orders;
[0046] The third judgment module is used to judge whether all the target sub-orders are repeated according to the respective sequences and order identifiers of all the target sub-orders;
[0047] The inventory quantity determination module is used to, if a sub-order whose sequence is one position before the first target sub-order is queried in the database, and for each second target sub-order, a sub-order whose sequence is one position before the second target sub-order is queried in all the target sub-orders, and all the target sub-orders are not repeated, then for each of the target sub-orders, determine the inventory quantity of the parts represented by the part identifiers of the target sub-orders in the order of the respective sequences of the target sub-orders from the earliest to the latest;
[0048] The replenishment order generation module is used to, for each of the target sub-orders, if the inventory quantity is less than the part quantity of the target sub-order, then generate a replenishment order for the part identifier of the target sub-order;
[0049] The message sending module is used to, if a sub-order whose sequence is one position before the first target sub-order is not queried in the database, and / or, for at least one second target sub-order, a sub-order whose sequence is one position before the second target sub-order is not queried in all the target sub-orders, and / or, at least one of the target sub-orders is repeated, then send a message indicating that an error has occurred in each of the target sub-orders to the preset terminal.
[0050] In a possible embodiment, the judging whether all the target sub-orders are repeated according to the respective sequences and order identifiers of all the target sub-orders includes:
[0051] Judging whether a first sub-order with the same sequence as the third target sub-order is queried in the database; wherein, the third target sub-order is the sub-order with the latest sequence among all the target sub-orders;
[0052] If a first sub-order with the same order rank as the third target sub-order is queried in the database, then for each of the first sub-orders with the same order rank, it is determined whether the order identifier of the first sub-order with the same order rank is the same as the order identifier of the third target sub-order;
[0053] For each fourth target sub-order, it is determined whether a second sub-order with the same order rank as the fourth target sub-order is queried in the target sub-orders; wherein, the fourth target sub-order is a sub-order among the target sub-orders whose order rank is not the last one;
[0054] For each of the fourth target sub-orders, if a second sub-order with the same order rank as the fourth target sub-order is queried in the target sub-orders, then for each of the second sub-orders with the same order rank, it is determined whether the order identifier of the second sub-order with the same order rank is the same as the order identifier of the fourth target sub-order;
[0055] If the order identifiers of all the first sub-orders with the same order rank are the same as the order identifier of the third target sub-order, and for each of the fourth target sub-orders, the order identifiers of all the second sub-orders with the same order rank are the same as the order identifier of the fourth target sub-order, then it is determined that the target sub-orders are not repeated;
[0056] If the order identifier of at least one of the first sub-orders with the same order rank is not the same as the order identifier of the third target sub-order, and / or, for at least one of the fourth target sub-orders, the order identifier of at least one of the second sub-orders with the same order rank is not the same as the order identifier of the fourth target sub-order, then it is determined that at least one of the target sub-orders is repeated.
[0057] In a possible implementation, after the step of receiving and storing in the database the order rank, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal, the apparatus further includes:
[0058] An un-verification sub-order determination module, configured to, in response to an un-verification instruction, determine the sub-order indicated by the un-verification instruction as an un-verification sub-order;
[0059] An un-verification continuity flag setting module, configured to set an un-verification continuity flag for the un-verification sub-order;
[0060] The determination of whether a sub-order with an order rank preceding the first target sub-order is queried in the database includes:
[0061] If the un-verification continuity flag is not set for the first target sub-order, then it is determined whether a sub-order with an order rank preceding the first target sub-order is queried in the database;
[0062] Determining whether a sub - order whose rank is one before the second target sub - order is queried among the target sub - orders includes:
[0063] If the non - verification of continuity flag is not set for the second target sub - order, determine whether a sub - order whose rank is one before the second target sub - order is queried among the target sub - orders.
[0064] In a possible embodiment, the order identifier includes: an order number and an order line number. The order number is used to identify the order to which the sub - order belongs, and the order line number is used to identify the sub - order in the order.
[0065] In a possible embodiment, the database also stores the part identifier and order status of each replenishment order; the order status of the replenishment order includes: new, in execution, and completed;
[0066] Determining the inventory quantity of the part represented by the part identifier of the target sub - order includes:
[0067] Determine the storage quantity of the part represented by the part identifier of the target sub - order;
[0068] Determine the first quantity of the part represented by the part identifier of the target sub - order in the replenishment orders with the order status of new;
[0069] Determine the second quantity of the part represented by the part identifier of the target sub - order in the replenishment orders with the order status of in execution;
[0070] Take the sum of the storage quantity, the first quantity, and the second quantity as the inventory quantity of the part represented by the part identifier of the target sub - order;
[0071] Generating a replenishment order for the part identifier of the target sub - order includes:
[0072] Generate a replenishment order with the part identifier of the target sub - order, and set the order status of the replenishment order to new;
[0073] In response to receiving a message indicating that the part represented by the part identifier of the replenishment order is shelved, modify the order status of the replenishment order to in execution;
[0074] In response to receiving a message indicating that the part represented by the part identifier of the replenishment order is transported to the warehouse, modify the order status of the replenishment order to completed.
[0075] In a possible embodiment, generating a replenishment order with the part identifier of the target sub - order includes:
[0076] Generate a replenishment order with the part identifier of the target sub-order as the part identifier of the replenishment order, and the replenishment quantity is the difference between the inventory quantity and the part quantity of the target sub-order.
[0077] An embodiment of the present application also provides an electronic device, including:
[0078] A memory for storing a computer program;
[0079] A processor for implementing the replenishment order generation method described in any one of the above when executing the program stored on the memory.
[0080] An embodiment of the present application also provides a computer-readable storage medium, in which a computer program is stored, and the computer program implements the replenishment order generation method described in any one of the above when executed by a processor.
[0081] An embodiment of the present application also provides a computer program product containing instructions, which when running on a computer, causes the computer to execute the replenishment order generation method described in any one of the above.
[0082] Advantages of the embodiments of the present application:
[0083] A replenishment order generation method, apparatus, electronic device, and storage medium provided by an embodiment of the present application can receive and store in a database the respective priorities, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal; when arranging each sub-order in order from first to last according to its respective priority, the sub-orders in the first preset number of positions are determined as target sub-orders. Since the target sub-orders are obtained by determining the sub-orders in the first preset number of positions when arranging each sub-order in order from first to last according to its respective priority, therefore, for the sub-order with the earliest priority among the target sub-orders, that is, the first target sub-order, there is no sub-order with a priority one position before the first target sub-order in the target sub-orders. It is necessary to determine whether the first target sub-order is continuous by judging whether a sub-order with a priority one position before the first target sub-order can be found in the database. For the second target sub-orders, it can be directly determined whether each second target sub-order is continuous by judging whether a sub-order with a priority one position before the second target sub-order can be found among the target sub-orders for each second target sub-order. If a sub-order with a priority one position before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority one position before the second target sub-order is found among the target sub-orders, it indicates that all the target sub-orders are continuous. When all the target sub-orders are continuous and non-repetitive, the inventory quantity of the parts represented by the part identifiers of the target sub-orders can be determined in the order of arranging the target sub-orders from first to last according to their respective priorities. If the inventory quantity is less than the part quantity corresponding to the target sub-order, a replenishment order can be generated by generating a replenishment order for the part identifier corresponding to the target sub-order, thereby realizing the generation of the replenishment order. If a sub-order with a priority one position before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order with a priority one position before the second target sub-order is not found among the target sub-orders, it indicates that there is a discontinuous situation among the target sub-orders. A message indicating that each target sub-order is in error can be sent to the preset terminal when there is a discontinuity among the target sub-orders and / or at least one target sub-order is repeated. In the above process, it is determined whether part replenishment is required based on the comparison between the actual required part quantity and the stored quantity of the parts, and the replenishment order is generated in the order of arranging the target sub-orders from first to last according to their respective priorities, which can ensure the timeliness of replenishing parts for each target sub-order, avoid the situation where the parts required by the sub-orders with a later priority have been replenished while the parts in stock for the sub-orders with an earlier priority are insufficient, and avoid the situation where production stagnates due to insufficient part inventory. It can be seen that the embodiment of the present application can make the part replenishment method more flexible, thereby reducing the number of parts that need to be stored in the warehouse and reducing the area occupied by storing parts in the warehouse.
[0084] Of course, it is not necessary for any product or method implementing this application to achieve all of the above advantages simultaneously. BRIEF DESCRIPTION OF THE DRAWINGS
[0085] In order to more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the following will briefly introduce the drawings required for use in the description of the embodiments or the prior art. Obviously, the drawings in the following description are only some embodiments of this application, and those of ordinary skill in the art can also obtain other embodiments based on these drawings.
[0086] Figure 1 The first flowchart of the replenishment order generation method provided by the embodiment of this application;
[0087] Figure 2 A flowchart of a repetitive verification method provided by the embodiment of this application;
[0088] Figure 3 The second flowchart of the replenishment order generation method provided by the embodiment of this application;
[0089] Figure 4 The third flowchart of the replenishment order generation method provided by the embodiment of this application;
[0090] Figure 5 A flowchart of a method for determining inventory quantity provided by the embodiment of this application;
[0091] Figure 6 A flowchart of a continuity verification method provided by the embodiment of this application;
[0092] Figure 7 Another flowchart of the repetitive verification method provided by the embodiment of this application;
[0093] Figure 8 A structural diagram of a replenishment order generation device provided by the embodiment of this application;
[0094] Figure 9 A structural diagram of an electronic device provided by the embodiment of this application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0095] The following will clearly and completely describe the technical solutions in the embodiments of this application in conjunction with the drawings in the embodiments of this application. Obviously, the described embodiments are only some embodiments of this application, rather than all embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art based on this application belong to the scope of protection of this application.
[0096] To more clearly illustrate the replenishment order generation method provided in this application, the following will provide an exemplary description of possible application scenarios of the replenishment order generation method provided in this application. It can be understood that the following examples are only possible application scenarios of the replenishment order generation method provided in this application. In other possible embodiments, the replenishment order generation method provided in this application can be applied to other possible application scenarios, and the following examples do not impose any restrictions on this.
[0097] With the development of automation technology, more and more enterprise warehouses use intelligent warehousing systems to control mobile robots to move parts out of the warehouse and transport them to the production workstations that need to use these parts, improving the automation level of part handling in the warehouse. Currently, general intelligent warehousing systems usually judge whether the parts stored in the warehouse need to be replenished based on the inventory water level. Specifically, an inventory water level is set for each type of part. When the inventory of a certain part is lower than the inventory water level, the intelligent warehousing system generates a replenishment order. In the following text, this way of generating a replenishment order will be referred to as Method 1.
[0098] However, in flexible production and manufacturing enterprises, there are situations where multiple different products are produced using the same production line. In this case, with the change of consumer demand, the production ratios of different products change, and the consumption rate of each part also changes. Since the inventory water level of each part needs to be set in advance, if the inventory water level of the part is set relatively high, the number of parts stored in the warehouse can always be relatively large, avoiding the situation of insufficient parts caused by a relatively fast consumption rate of parts. However, setting the inventory water level of the part relatively high will result in a relatively large number of parts being piled up in the warehouse, and in order to store a relatively large number of parts, the area required for the warehouse is relatively large. If the inventory water level of the part is set relatively low, the number of parts stored in the warehouse can be relatively small, avoiding the situation of parts piling up caused by a relatively low consumption rate of parts, and also reducing the area required for the warehouse. However, when the consumption rate of parts is relatively high, since the number of parts stored in the warehouse is relatively small, there may be a situation where the production stops due to insufficient inventory of parts in the warehouse.
[0099] Since there will be problems of excessive part piling and relatively large warehouse occupancy area when the inventory water level of the part is set relatively high, and there will be a situation where production stops due to insufficient part inventory when the inventory water level of the part is set relatively low, it is necessary to set a reasonable inventory water level for each part according to the consumption rate of each part. However, the change of consumer demand is difficult to predict, making it difficult to predict the change of the production ratio of different products, and thus making it difficult to predict the change of the consumption rate of each part, and it is also difficult to accurately and flexibly adjust the inventory water level of each part reasonably. Therefore, Method 1 is difficult to achieve flexible replenishment of parts.
[0100] In order to achieve flexible replenishment of parts, the intelligent warehousing system can generate replenishment orders through the following Method 2: Based on the parts required for product production and the quantity of parts demanded included in the product production order sent by the material pull system received, as well as the parts stored in the warehouse and the quantity of parts stored, it is determined whether the parts stored in the warehouse can be used to complete product production. Specifically, for a certain part, if the quantity of parts demanded is less than the quantity of parts stored, then the part stored in the warehouse can be used to complete product production, and there is no need to generate a replenishment order for this part; if for a certain part, the quantity of parts demanded is greater than the quantity of parts stored, then the parts stored in the warehouse cannot be used to complete product production, and a replenishment order needs to be generated for this part. Method 2 can directly determine whether a replenishment order needs to be generated for a part based on the quantity of parts demanded and the quantity of parts stored, without the problem of production stagnation caused by insufficient part inventory due to a relatively low inventory level setting, nor the problem of excessive part accumulation and a relatively large warehouse occupancy area caused by a relatively high inventory level setting.
[0101] It can be understood that problems such as packet loss and delay may occur during the information transmission process. In Method 2, the process of the intelligent warehousing system receiving the product production order sent by the material pull system is a process of information transmission. Therefore, the product production order received by the intelligent warehousing system may be missing the product production order, or the order sequence of the product production order may be incorrect. For example, the material pull system sends orders 1 - 10 to the intelligent warehousing system in the order of order 1 - order 10, and the orders received by the intelligent warehousing system are: order 2 - order 5, order 1, order 7 - order 10. In this information transmission process, there are situations where order 6 is missing and the order sequence is incorrect.
[0102] Since the production line generates products according to the order of pre-set product production orders, if a product production order is missing, it is impossible to determine whether a replenishment order needs to be generated for the parts required by the missing product production order. When the production line produces products according to this product production order, there may be a shortage of parts required by this product production order, resulting in production stagnation. If the product production order sequence is incorrect, when the production line produces products according to this product production order, it may not have been determined whether a replenishment order needs to be generated for the parts required by this product production order, resulting in a possible shortage of parts required by this product production order and production stagnation. Moreover, an incorrect product production order sequence will also cause replenishment orders to be generated in advance for the parts required by product production orders with a later sequence, that is, early replenishment occurs. This early replenishment situation will cause the parts required by the product production order with a later sequence to be stored in the warehouse for a long time, occupying the warehouse storage space for a long time, that is, the utilization rate of the warehouse storage space is low. That is to say, the absence of a product production order or an incorrect product production order sequence may both lead to a shortage of parts in stock, resulting in production stagnation, and an incorrect product production order sequence will also lead to a low utilization rate of the warehouse storage space.
[0103] Based on this, in order to achieve flexible replenishment of parts, reduce the area occupied by storing parts in the warehouse, avoid production stagnation caused by insufficient parts in stock, and improve the utilization rate of the warehouse storage space, the present application provides a replenishment order generation method, as Figure 1 shown, the method includes:
[0104] S101, receive and store in the database the respective positions, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal.
[0105] S102, when arranging each sub-order in order from first to last according to its respective position, determine the sub-orders in the first preset number of positions as target sub-orders.
[0106] S103, determine whether a sub-order with a position one before the first target sub-order is queried in the database.
[0107] Wherein, the first target sub-order is the sub-order with the earliest position among all target sub-orders.
[0108] S104, for each second target sub-order, determine whether a sub-order with a position one before the second target sub-order is queried among all target sub-orders.
[0109] Wherein, the second target sub-order is a sub-order with a position that is not the earliest among the target sub-orders.
[0110] S105. Determine whether each target sub - order is duplicate according to the rank of each target sub - order and the order identifier.
[0111] S106. If a sub - order whose rank is one before the first target sub - order is found in the database, and for each second target sub - order, a sub - order whose rank is one before the second target sub - order is found among the target sub - orders, and the target sub - orders are not duplicate, then for each target sub - order, determine the inventory quantity of the part represented by the part identifier of the target sub - order in the order of the ranks of the target sub - orders from the earliest to the latest.
[0112] S107. For each target sub - order, if the inventory quantity is less than the quantity of the part of the target sub - order, then generate a replenishment order for the part identifier of the target sub - order.
[0113] S108. If a sub - order whose rank is one before the first target sub - order is not found in the database, and / or for at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders, and / or at least one target sub - order is duplicate, then send a message indicating an error in each target sub - order to a preset terminal.
[0114] Among them, that a sub - order whose rank is one before the first target sub - order is not found in the database, and / or for at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders, and / or at least one target sub - order is duplicate includes any one of the following situations: 1. A sub - order whose rank is one before the first target sub - order is not found in the database; 2. For at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders; 3. At least one target sub - order is duplicate; 4. A sub - order whose rank is one before the first target sub - order is not found in the database, and for at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders; 5. A sub - order whose rank is one before the first target sub - order is not found in the database, and at least one target sub - order is duplicate; 6. For at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders, and at least one target sub - order is duplicate; 7. A sub - order whose rank is one before the first target sub - order is not found in the database, and for at least one second target sub - order, a sub - order whose rank is one before the second target sub - order is not found among the target sub - orders, and at least one target sub - order is duplicate.
[0115] Applying the embodiments of the present application, on the one hand, it is possible to receive and store in a database the respective priorities, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal; when arranging the sub-orders in order from the earliest to the latest according to their respective priorities, the sub-orders in the first preset number of positions are determined as target sub-orders. Since the target sub-orders are obtained by determining the sub-orders in the first preset number of positions when arranging the sub-orders in order from the earliest to the latest according to their respective priorities, for the sub-order with the earliest priority among the target sub-orders, that is, the first target sub-order, there is no sub-order with a priority one position before the first target sub-order among the target sub-orders. It is necessary to determine whether the first target sub-order is continuous by judging whether a sub-order with a priority one position before the first target sub-order can be found in the database. For the second target sub-orders, it is possible to directly determine whether each second target sub-order is continuous by judging whether a sub-order with a priority one position before the second target sub-order can be found among the target sub-orders for each second target sub-order. If a sub-order with a priority one position before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority one position before the second target sub-order is found among the target sub-orders, it indicates that all the target sub-orders are continuous. When all the target sub-orders are continuous and non-repetitive, the inventory quantity of the parts represented by the part identifiers of the target sub-orders can be determined in the order of arranging the target sub-orders from the earliest to the latest according to their respective priorities. If the inventory quantity is less than the part quantity corresponding to the target sub-order, a replenishment order can be generated by generating a replenishment order for the part identifier corresponding to the target sub-order. If a sub-order with a priority one position before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order with a priority one position before the second target sub-order is not found among the target sub-orders, it indicates that there is a discontinuous situation among the target sub-orders. When there is a discontinuity among the target sub-orders and / or at least one target sub-order is repeated, a message indicating that each target sub-order is in error can be sent to the preset terminal. In the above process, it is determined whether parts replenishment is required based on the comparison between the actual required part quantity and the stored quantity of the parts, and the replenishment order is generated in the order of arranging the target sub-orders from the earliest to the latest according to their respective priorities, which can ensure the timeliness of replenishing parts for each target sub-order, avoid the situation where the parts required by the sub-orders with a later priority have been replenished while the parts inventory of the sub-orders with an earlier priority is insufficient, and avoid the situation where production stagnates due to insufficient parts inventory. It can be seen that the embodiments of the present application can make the parts replenishment method more flexible, thereby reducing the number of parts that need to be stored in the warehouse and reducing the area occupied by storing parts in the warehouse.
[0116] On the other hand, in the case where the intelligent warehousing system receives a large number of sub-orders, even if there is a delay problem, since the intelligent warehousing system has received a large number of sub-orders, that is, the intelligent warehousing system has received sub-orders with relatively lower rankings, it can still be considered that the sub-orders with higher rankings in each sub-order should have been received by the intelligent warehousing system. If at this time the sub-orders are arranged in order from the earliest to the latest according to their respective rankings, and the sub-orders in the first preset number of positions are determined as target sub-orders, and the continuity of each target sub-order is judged, then when there is a discontinuous situation among the target sub-orders, it can be considered that there is a packet loss in the information transmission, that is, there is a situation of missing sub-orders. Therefore, by arranging the sub-orders in order from the earliest to the latest according to their respective rankings and determining the sub-orders in the first preset number of positions as target sub-orders, the accuracy of the subsequent judgment of the continuity of the sub-orders can be ensured, so as to more accurately ensure the continuity and integrity of the target sub-orders, and further avoid the situation where the parts required for the sub-orders with lower rankings have been replenished while the inventory of the parts required for the sub-orders with higher rankings is insufficient, and avoid the situation where the production is stagnated due to insufficient part inventory. At the same time, it can also avoid the situation where the parts required for the sub-orders with lower rankings are replenished in advance, and avoid the situation where the warehouse storage space is occupied for a long time due to early replenishment, thereby improving the utilization rate of the warehouse storage space.
[0117] Moreover, it can be understood that if replenishment orders are uniformly generated for all sub-orders, a large number of replenishment orders will be generated. In the embodiment of the present application, the sub-orders can be divided into multiple batches of target sub-orders through the setting of the preset number, and replenishment orders are generated for each different batch of target sub-orders in turn, avoiding the generation of a large number of replenishment orders. And by arranging the sub-orders in order from the earliest to the latest according to their respective rankings and determining the sub-orders in the first preset number of positions as target sub-orders, it can be ensured that only the sub-orders in the first preset number of positions with higher rankings (i.e., target sub-orders) are continuously verified first. When continuously verifying the target sub-orders, the discontinuous situation among the target sub-orders is caused by packet loss rather than delay, reducing the discontinuous situation among the target sub-orders caused by delay.
[0118] The foregoing S101-S108 will be exemplarily described below:
[0119] In S101, the preset terminal is any electronic device capable of sending the sequence number, order identifier, part identifier, and part quantity of each sub-order to the execution entity. For example, a server, a laptop computer, etc. The execution entity is any electronic device for executing the replenishment order generation method provided in this application. For example, a server, a laptop computer, etc. Specifically, the preset terminal may be the aforementioned material pulling system, and the execution entity may be the aforementioned intelligent warehousing system. In the following, the replenishment order generation method provided in this application will be exemplarily described by taking the preset terminal as the aforementioned material pulling system and the execution entity as the aforementioned intelligent warehousing system as an example.
[0120] Each sub-order is generated according to the product production requirements. One sub-order corresponds to one type of part required during product production, that is, one sub-order only includes one part identifier and one part quantity. The sequence number of each sub-order is set according to the product production sequence. If the production sequence of a certain product is earlier, the sequence number of the sub-order generated for this product is earlier; similarly, if the production sequence of a certain product is later, the sequence number of the sub-order generated for this product is later. The sequence number of each sub-order also needs to be set according to the sequence between the production processes used during product production. Exemplarily, assume that a certain product needs to be produced through Process 1, Process 2, and Process 3 in sequence. Process 1 requires Part 1, Process 2 requires Part 2, and Process 3 requires Part 3. Then, for this product, three sub-orders need to be generated: Sub-order 1 with part identifier Part 1, Sub-order 2 with part identifier Part 2, and Sub-order 3 with part identifier Part 3. And the order between the three sub-orders is the same as the order between the three processes, that is, the order between the three sub-orders from front to back is: Sub-order 1, Sub-order 2, Sub-order 3.
[0121] It can be understood that there may be multiple types of parts required for producing a certain product or a certain production process in that product. Then, multiple sub-orders need to be generated for this product. In the case where only one production process is required for producing this product, or there is no fixed order for the multiple production processes required for producing this product, the sequence numbers between the multiple sub-orders can be set arbitrarily.
[0122] Exemplarily, the parts required to produce product A are 1 part 1, the parts required to produce product B are 2 part 2s and 3 part 3s, and the parts required to produce product C are 3 part 4s. If the production order of the three products is product A, product B, and product C, then for product A, a sub-order 1 needs to be generated. The part identifier of sub-order 1 is part 1, and the number of parts is 1. For product B, a sub-order 2 is generated. The part identifier of sub-order 2 is part 2, and the number of parts is 2, and a sub-order 3 is generated. The part identifier of sub-order 3 is part 3, and the number of parts is 3. For product C, a sub-order 4 is generated. The part identifier of sub-order 4 is part 4, and the number of parts is 3. Since the production order of the three products is product A, product B, and product C, the sequence numbers of each sub-order can be: sub-order 1, sub-order 2, sub-order 3, sub-order 4. Since both sub-order 2 and sub-order 3 are sub-orders generated for product B, the order between sub-order 2 and sub-order 3 can be set arbitrarily. That is, the sequence numbers of each sub-order can also be: sub-order 1, sub-order 3, sub-order 2, sub-order 4. To facilitate the understanding of the above example, assume that the sequence numbers of each sub-order are represented by 1, 2, 3, …… The sequence number, order identifier, part identifier, and number of parts of each sub-order, that is, the information of each sub-order can be displayed in the form of a table, as shown in Table 1:
[0123] Table 1 Example 1 of Sub-order Information
[0124] The intelligent warehousing system can store the information of each sub-order in the form of the table shown in Table 1, or can also store the information of each sub-order in other non-table forms such as arrays.
[0125] In S102, the sequence numbers of each sub-order can be represented in the form of adding 1 successively to the aforementioned 1, 2, 3, ……, or can also be represented in the form of adding 2 successively to 1, 3, 5, 7, ……, or 2, 4, 6, 8, ……, or can also be represented in any fixed pattern form such as 1, 2, 4, 7, …… Among them, the pattern of 1, 2, 4, 7, …… is that the difference between adjacent sequence numbers is 1, 2, 3, …… successively. That is, the difference between sequence number 1 and sequence number 2 is 1, the difference between sequence number 2 and sequence number 3 is 2, the difference between sequence number 3 and sequence number 4 is 3, ……
[0126] If the sub-orders at the first preset number are determined as the target sub-orders according to the order of the time when the intelligent warehousing system receives each sub-order, and the sub-order continuity of each target sub-order is determined through the following S103-S104, then when there is a discontinuity in each target sub-order, it will be considered that there is a missing sub-order, that is, it is considered that the sub-order is wrong. However, as described above, there may be a delay in the information transmission process. Therefore, in the above method of determining the target sub-order, the reason for the discontinuity in each target sub-order may be: due to the delay in information transmission, the intelligent warehousing system has just received the missing sub-order in each target sub-order.
[0127] For example, assuming that the material pulling system sends sub-orders 1 to 100 to the intelligent warehousing system in the order of sub-orders 1 to 100, the intelligent warehousing system first receives sub-orders 1 to 8 and sub-orders 10 to 20, and then receives sub-orders 9 and 21 to 100, and assuming that the preset number is 10, in the above method of determining the target sub-order, sub-orders 1 to 8 and sub-orders 10 to 11 are used as target sub-orders. When judging the continuity of each target sub-order, it is considered that there is a discontinuity in the target sub-order, and sub-order 9 is missing. However, the intelligent warehousing system has received and stored the information of sub-order 9. Therefore, if the sub-order located in the first preset number is determined as the target sub-order according to the order of the time when the intelligent warehousing system receives each sub-order, the continuity judgment of the sub-order will be wrong.
[0128] Based on this, in order to ensure the accuracy of subsequent judgments on the continuity of sub-orders, it is necessary to determine the sub-orders at the first preset number of positions when the sub-orders are arranged from first to last according to their respective orders. It can be understood that the delay is generally limited. Assuming that the delay time of information transmission does not exceed △t1, the difference between the time when the material pulling system sends a sub-order and the current time is △t2, and the intelligent warehousing system has not received the sub-order at the current time, then in the case of △t2≤△t1, that is, when △t2 does not exceed the maximum delay time, it can be considered that the intelligent warehousing system did not receive the sub-order due to the delay, and in the case of △t2>△t1, that is, when △t2 exceeds the maximum delay time, it cannot be considered that the intelligent warehousing system did not receive the sub-order due to the delay. At this time, it can be considered that packet loss occurred in the information transmission, resulting in the loss of the sub-order. Based on the above description, when the intelligent warehousing system receives more sub-orders, even if there is a delay problem, since the intelligent warehousing system has received more sub-orders, that is, the intelligent warehousing system has received sub-orders with a relatively low priority, therefore, without considering the loss of packets, it can still be considered that the sub-orders with a high priority among the sub-orders should have been received by the intelligent warehousing system. If at this time, when the sub-orders are arranged from first to last according to their respective priorities, the sub-orders located in the first preset number of positions are determined as the target sub-orders, and the sub-order continuity of each target sub-order is judged through the following S103-S104, then when there is a discontinuity in each target sub-order, it can be considered that packet loss has occurred in the information transmission, that is, there is a situation of missing sub-orders. Therefore, by determining the sub-orders located in the first preset number of positions as the target sub-orders when the sub-orders are arranged from first to last according to their respective priorities, the accuracy of the subsequent judgment of the continuity of the sub-orders can be ensured.
[0129] The preset number can be set according to user needs or actual experience. For example, the preset number can be set to 10, 15, 20, etc.
[0130] In S103, since the sub-orders are arranged from first to last according to their respective priorities, the sub-orders located in the first preset number positions are determined as target sub-orders, and the first target sub-order is the sub-order with the highest priority among all target sub-orders. Therefore, there is no sub-order in the target sub-orders that is ranked before the first target sub-order.
[0131] In order to determine whether the sub-orders received by the intelligent warehousing system are continuous, it is necessary to determine whether there is a sub-order in the database that is ranked before the first target sub-order. If a sub-order that is ranked before the first target sub-order is found in the database, it means that the first target sub-order is continuous; if a sub-order that is ranked before the first target sub-order is not found in the database, it means that the first target sub-order is not continuous.
[0132] Specifically, if the priority of each sub-order is represented by 1, 2, 3, ..., plus 1 in sequence, it is possible to determine whether a sub-order with a priority that is one position before the first target sub-order is found in the database by the following method: determine whether a sub-order with a priority that is less than the priority of the first target sub-order is found in the database, and the difference between the priority of the sub-order and the priority of the first target sub-order is 1. If the priority of each sub-order is represented by 1, 3, 5, 7, ..., or 2, 4, 6, 8, ..., plus 2 in sequence, it is possible to determine whether a sub-order with a priority that is one position before the first target sub-order is found in the database by the following method: determine whether a sub-order with a priority that is less than the priority of the first target sub-order is found in the database, and the difference between the priority of the sub-order and the priority of the first target sub-order is 2. If the priority of each sub-order is represented by any fixed-rule form such as 1, 2, 4, 7, ..., then it can be determined whether a sub-order whose priority is before the first target sub-order is found in the database in the following way: determine whether a sub-order whose priority is less than the priority of the first target sub-order is found in the database, and whose priority satisfies a fixed rule with the priority of the first target sub-order.
[0133] In S104, when the sub-orders are arranged from first to last according to their respective orders, the sub-orders at the first preset number of positions are determined as the target sub-orders, and the second target sub-order is the sub-order that is not the first in the order of the target sub-orders, therefore, there should be a sub-order at the first position of the second target sub-order in the target sub-orders. Then, it can be determined whether the second target sub-orders are continuous by determining whether the sub-order at the first position of the second target sub-order is found in each target sub-order.
[0134] For a second target sub-order, if a sub-order with a sequence that is one place before the second target sub-order is found in each target sub-order, it means that the second target sub-order is continuous; if a sub-order with a sequence that is one place before the second target sub-order is not found in each target sub-order, it means that the second target sub-order is discontinuous. S103-S104 is the continuity check of each target sub-order.
[0135] Specifically, for each second target sub-order, if the priority of each sub-order is represented by 1, 2, 3, ..., plus 1 in sequence, it is possible to determine whether a sub-order with a priority that is one place before the second target sub-order is found in each target sub-order by: determining whether a sub-order with a priority that is less than the priority of the second target sub-order is found in each target sub-order, and the difference between the priority and the priority of the second target sub-order is 1. If the priority of each sub-order is represented by 1, 3, 5, 7, ..., or 2, 4, 6, 8, ..., plus 2 in sequence, it is possible to determine whether a sub-order with a priority that is one place before the second target sub-order is found in each target sub-order by: determining whether a sub-order with a priority that is less than the priority of the second target sub-order is found in each target sub-order, and the difference between the priority and the priority of the second target sub-order is 2. If the priority of each sub-order is expressed in any form with a fixed rule such as 1, 2, 4, 7, ..., then it can be determined in the following way whether a sub-order with a priority before the second target sub-order is found in each target sub-order: determine whether a sub-order with a priority less than the second target sub-order is found in each target sub-order, and whose priority satisfies a fixed rule with the priority of the second target sub-order.
[0136] In S105, for a certain target sub-order, the priority and order identifier of the target sub-order are compared with the priority and order identifier of each sub-order in the database. Since the order identifiers of each sub-order are different, if there is only one sub-order in each sub-order that has the same priority and order identifier as the target sub-order, then the sub-order with the same priority and order identifier as the target sub-order is the target sub-order itself, and there is no sub-order in the database that has the same priority as the target sub-order, which means that the target sub-order is considered to be non-repeating. If there is a sub-order in each sub-order that has the same priority as the target sub-order but a different order identifier, it means that there is a sub-order in the database that has the same priority as the target sub-order, which means that the target sub-order is considered to be repeated. S105 is a repeatability check for each target sub-order.
[0137] Understandably, Figure 1 This is just a possible flow chart. Figure 1 The execution order between S103 and S105 shown in the figure is: S103→S104→S105. In other possible embodiments, S103 and S105 may be executed simultaneously, S104 may be executed after S103 is executed, or S103-S105 may be executed simultaneously.
[0138] In S106, as described in S103 above, if a sub-order that ranks before the first target sub-order is found in the database, it means that the first target sub-order is continuous. As described in S104 above, if a sub-order that ranks before the second target sub-order is found in each target sub-order, it means that each second target sub-order is continuous. The first target sub-order is continuous and each second target sub-order is continuous, which means that each target sub-order is continuous. Therefore, S106-S107 are executed when each target sub-order is continuous and each target sub-order is not repeated.
[0139] By determining the inventory quantity of the parts represented by the part identifier of the target sub-order according to the order of their respective priorities from first to last, it can be ensured that the processing order of each target sub-order complies with the product production order, thereby avoiding the situation where, when the production line produces products according to a sub-order, it has not yet been determined whether a replenishment order is required for the parts represented by the part identifier of the sub-order, thereby avoiding the situation where production is stagnates due to insufficient parts inventory.
[0140] In S107, for ease of description, the part indicated by the part identifier of the target sub-order is referred to as the target part. For each target sub-order, if the inventory quantity of the target part is less than the part quantity of the target sub-order, it means that the target part stored in the warehouse is insufficient, and it is necessary to generate a replenishment order for the part identifier of the target sub-order. If the inventory quantity of the target part is not less than the part quantity of the target sub-order, it means that the target part stored in the warehouse is sufficient, and it is not necessary to generate a replenishment order.
[0141] In S108, it can be understood that the discontinuity of the first target sub-order and / or the discontinuity of at least one second target sub-order can be regarded as the discontinuity of at least one target sub-order. Therefore, for the convenience of description below, the discontinuity of the first target sub-order and / or the discontinuity of at least one second target sub-order are referred to as the discontinuity of at least one target sub-order.
[0142] If at least one target sub-order is discontinuous, and / or at least one target sub-order is repeated, it means that there is a packet loss and / or a sub-order sequence error in each target sub-order, that is, each target sub-order is wrong. Therefore, in the case of an error in each target sub-order, it is necessary to send a message indicating that each target sub-order is wrong to the material pulling system (i.e., the preset terminal). When the material pulling system receives the message indicating that each target sub-order is wrong, it can verify the accuracy of each target sub-order by manual verification or machine verification. If each target sub-order is considered accurate after verification, a message indicating that each target sub-order is verified accurately is sent to the intelligent warehousing system, so that the intelligent warehousing system can execute the aforementioned S106-S107.
[0143] If after verification, it is considered that each target sub-order is wrong, and the reason for the error of each target sub-order is that the target sub-order is repeated, the repeated target sub-order can be directly deleted, so that the intelligent warehousing system re-executes the above S101-S105. If after verification, it is considered that each target sub-order is wrong, and the reason for the error of each target sub-order is that the target sub-order is not continuous, that is, there are missing target sub-orders, then only the missing target sub-orders can be resent to the intelligent warehousing system, so that the intelligent warehousing system re-executes the above S101-S105 after receiving the missing target sub-orders.
[0144] Alternatively, it is understandable that when setting the order of each sub-order, there may be a situation where the order is interrupted. For example, assume that the sub-orders sent by the material pulling system to the intelligent warehousing system are sub-orders 1-sub-order 10, sub-order 12-sub-order 20, and sub-order 11 itself does not exist. In the above example, assuming that the target sub-orders are sub-orders 1-sub-order 20, the intelligent warehousing system will detect that the target sub-orders are discontinuous, and believe that the target sub-orders are wrong, and send a message to the material pulling system to indicate that the target sub-orders are wrong. Since the missing sub-order itself does not exist, when manual verification or machine verification finds this situation, it can set a non-verification continuity flag for the target sub-order (i.e., sub-order 12) that is ranked one after the missing target sub-order, so that when the continuity check is re-performed, the continuity check is not performed on sub-order 12, so that when the continuity check is re-performed, the target sub-order (i.e., sub-order 11) that has been determined to be missing before can be ignored, so that the result of the continuity check is that each target sub-order is continuous, that is, each target sub-order can pass the continuity check, and a replenishment order can be generated after passing the continuity check and repeatability check.
[0145] The above S101-S108 have been described as an example. Referring to the above description, the replenishment order generation method provided by the present application relies on the continuity check and repeatability check of each target sub-order. The manner of performing the continuity check on each target sub-order has been described as an example in S103-S104. The manner of performing the repeatability check on each target sub-order in S105 will be described as an example below. Figure 2 , the repeatability verification methods provided in this application include:
[0146] S1051, determine whether a first sub-order with the same priority as the third target sub-order is found in the database.
[0147] Among them, the third target sub-order is the sub-order with the last sequence among all target sub-orders.
[0148] S1052, if a first sub-order with the same sequence number as the third target sub-order is found in the database, then for each first sub-order with the same sequence number, determine whether the order identifier of the first sub-order with the same sequence number is the same as that of the third target sub-order.
[0149] S1053, for each fourth target sub-order, determine whether a second sub-order with the same sequence number as the fourth target sub-order is found among the target sub-orders.
[0150] Among them, the fourth target sub-order is a sub-order whose sequence number is not the last among all target sub-orders.
[0151] S1054, for each fourth target sub-order, if a second sub-order with the same sequence number as the fourth target sub-order is found among the target sub-orders, then for each second sub-order with the same sequence number, determine whether the order identifier of the second sub-order with the same sequence number is the same as that of the fourth target sub-order.
[0152] S1055, if the order identifiers of all first sub-orders with the same sequence number are the same as that of the third target sub-order, and for each fourth target sub-order, the order identifiers of all second sub-orders with the same sequence number are the same as that of the fourth target sub-order, then determine that all target sub-orders are non-duplicate.
[0153] S1056, if the order identifier of at least one first sub-order with the same sequence number is not the same as that of the third target sub-order, and / or, for at least one fourth target sub-order, the order identifier of at least one second sub-order with the same sequence number is not the same as that of the fourth target sub-order, then determine that at least one target sub-order is duplicate.
[0154] Selecting this embodiment, for the third target sub-order and the fourth target sub-order, first determine whether the sequence numbers are the same to identify the sub-orders with the same sequence number, and then determine whether the order identifiers of the sub-orders with the same sequence number and the target sub-orders are the same. Compared with the repetitive verification method of comparing the sequence number and order identifier of a certain target sub-order with those of each sub-order in the database, the number of sub-orders with the same sequence number is less than the number of sub-orders in the database. Therefore, the repetitive verification method provided by this embodiment requires fewer judgments on whether the order identifiers are the same. Moreover, the third target sub-order is judged whether the sequence numbers are the same with each sub-order in the database, and the fourth target sub-order is judged whether the sequence numbers are the same with each target sub-order. The number of target sub-orders is less than the number of sub-orders in the database. Therefore, the repetitive verification method provided by this embodiment also requires fewer judgments on whether the sequence numbers are the same, enabling the repetitive verification method provided by this embodiment to reduce the number of judgments required for repetitive verification of each target sub-order and reduce resource consumption.
[0155] The following provides an exemplary description of the aforementioned S1051 - S1056:
[0156] In S1051, since the target sub - orders are determined by arranging each sub - order in order of their respective priorities from first to last and designating the sub - orders in the first preset number of positions as the target sub - orders, for the sub - order with the last priority among the target sub - orders, that is, for the third target sub - order, there may also be sub - orders with the same priority as the third target sub - order among the sub - orders other than the target sub - orders in the database. If it is only judged whether there is a first co - priority sub - order with the same priority as the third target sub - order among the target sub - orders, it is impossible to judge whether there is a first co - priority sub - order with the same priority as the third target sub - order among the sub - orders other than the target sub - orders in the database, resulting in a relatively low accuracy of the duplicate check. Therefore, to determine the accuracy of the duplicate check, it is necessary to judge whether a first co - priority sub - order with the same priority as the third target sub - order is found in the database.
[0157] In S1052, since the order identifiers of each sub - order are different, for each first co - priority sub - order, if the order identifier of this first co - priority sub - order is the same as that of the third target sub - order, it means that this first co - priority sub - order is the third target sub - order itself and the third target sub - order is not duplicated; if the order identifier of this first co - priority sub - order is different from that of the third target sub - order, it means that the third target sub - order and this first co - priority sub - order are different sub - orders and the priorities are duplicated, that is, the third target sub - order is duplicated.
[0158] In S1053, since the target sub - orders are determined by arranging each sub - order in order of their respective priorities from first to last and designating the sub - orders in the first preset number of positions as the target sub - orders, for the sub - order with the first priority among the target sub - orders in the current batch, that is, for the first target sub - order in the current batch, if there is a sub - order with the same priority as the first target sub - order among the sub - orders other than the target sub - orders in the database, then this sub - order with the same priority as the first target sub - order (referred to as sub - order A below) must be the sub - order with the last priority among the target sub - orders in the previous batch.
[0159] However, only after S106 - S107 have been executed for each target sub - order of the previous batch, will S102 be executed again to determine the target sub - orders of the current batch. Therefore, the target sub - orders of the previous batch must be consecutive and non - repeating in order to execute S106 - S107. Also, when performing a repeatability check on the target sub - orders of the previous batch, S1051 has been executed for sub - order A, that is, it is judged in the database whether there is a sub - order with the same sequence number as sub - order A. Since the target sub - orders of the previous batch must be consecutive and non - repeating, there is no sub - order in the database other than the target sub - orders that is repeated with sub - order A, that is, there is no sub - order in the database other than the target sub - orders that is repeated with the first target sub - order of the current batch. Therefore, for the first target sub - order of the current batch, that is, for the sub - order with the earliest sequence number among the target sub - orders of the current batch, it is only necessary to judge in the target sub - orders whether there is a second sub - order with the same sequence number as the fourth target sub - order.
[0160] For the sub - orders (hereinafter referred to as the fifth target sub - orders) among the target sub - orders whose sorting is neither the earliest nor the last, there will be no sub - order in the database other than the target sub - orders with the same sequence number as the fifth target sub - order. Therefore, for the fifth target sub - order, it is also only necessary to judge in the target sub - orders whether there is a second sub - order with the same sequence number as the fourth target sub - order.
[0161] In S1054, for a certain fourth target sub - order, since the order identifiers of each sub - order are different, for each second sub - order with the same sequence number, if the order identifier of this second sub - order with the same sequence number is the same as that of the fourth target sub - order, it means that this second sub - order with the same sequence number is the fourth target sub - order itself, and the fourth target sub - order is not repeated; if the order identifier of this second sub - order with the same sequence number is different from that of the fourth target sub - order, it means that the fourth target sub - order and this second sub - order with the same sequence number are different sub - orders and the sequence numbers are repeated, that is, the fourth target sub - order is repeated.
[0162] In S1055, as described in S1052 above, for each first same-sequence sub-order, if the order identifier of the first same-sequence sub-order is the same as that of the third target sub-order, it indicates that the third target sub-order is not repeated; and as described in S1054 above, for a certain fourth target sub-order, for each second same-sequence sub-order, if the order identifier of the second same-sequence sub-order is the same as that of the fourth target sub-order, it indicates that the fourth target sub-order is not repeated. Therefore, if the order identifiers of all first same-sequence sub-orders are the same as the order identifier of the third target sub-order, and for each fourth target sub-order, the order identifiers of all second same-sequence sub-orders are the same as the order identifier of the fourth target sub-order, it indicates that the third target sub-order is not repeated and all fourth target sub-orders are not repeated, that is, all target sub-orders are not repeated.
[0163] In S1056, as described in S1052 above, for each first same-sequence sub-order, if the order identifier of the first same-sequence sub-order is different from that of the third target sub-order, it indicates that the third target sub-order is repeated; and as described in S1054 above, for a certain fourth target sub-order, for each second same-sequence sub-order, if the order identifier of the second same-sequence sub-order is different from that of the fourth target sub-order, it indicates that the fourth target sub-order is repeated. Therefore, if the order identifier of at least one first same-sequence sub-order is different from the order identifier of the third target sub-order, and / or, for at least one fourth target sub-order, the order identifier of at least one second same-sequence sub-order is different from the order identifier of the fourth target sub-order, it indicates that the third target sub-order is repeated and / or at least one fourth target sub-order is repeated, that is, at least one target sub-order is repeated.
[0164] An exemplary description of the method for repeatability verification has been given above. As described above, the replenishment order generation method provided in this application relies on the continuity verification and repeatability verification of each target sub-order. It can be understood that the intelligent warehousing system may receive multiple sub-orders at different time periods. If the sub-orders in different time periods are placed together for continuity verification, the sequence number of the last sub-order in the previous time period should be continuous with the sequence number of the first sub-order in the next time period, so as to pass the continuity verification. If the interval between different time periods is relatively long, for example, the interval time is one day, two days, etc., the user needs to record the sequence number of the last sub-order in the previous time period, so that when setting the first sub-order through the material pulling system in the next time period, the sequence number of the first sub-order is set to a sequence number that is continuous with the sequence number of the last sub-order in the previous time period, making the user operation relatively troublesome.
[0165] In addition, in the process that the intelligent warehousing system discovers the missing sub-orders in each target sub-order through continuous verification and sends a message indicating the missing sub-orders to the material pulling system, and the process that the material pulling system receives the message indicating the missing sub-orders and processes the situation of the missing sub-orders after manual verification or machine verification, the time consumed is relatively long, and the process of replenishing parts and delivering parts to the production line can only be carried out when the continuous verification and repetitive verification are passed. As a result, in the case of missing sub-orders, it takes a relatively long time to realize the process of delivering the parts required for the missing sub-orders to the production line. However, there may be a situation where the production line urgently needs to produce the production products corresponding to the missing sub-orders. In this case, in order to save time and ensure the normal production of the production line, usually, the parts indicated by the part identification of the missing sub-orders are manually delivered to the production line. At this time, the intelligent warehousing system still considers that the sub-order is missing, so the continuous verification of each sub-order received by the intelligent warehousing system cannot pass all the time, resulting in the inability to carry out the subsequent processes of replenishing parts for each sub-order and delivering parts to the production line, leading to production stagnation.
[0166] Based on this, in order to improve the operation convenience of users and avoid the situation of production stagnation, in a possible embodiment, refer to Figure 3 , the replenishment order generation method provided in this application includes:
[0167] S101, receive and store in the database the sequence number, order identification, part identification, and part quantity of each sub-order sent by a preset terminal.
[0168] The above has given an exemplary description of S101. For the relevant description of S101, reference can be made to the previous description, and details will not be elaborated here.
[0169] S109, in response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as a non-verification sub-order.
[0170] The sub-order indicated by the non-verification instruction can be the sub-order with the earliest sequence number among the sub-orders of the same production batch, or can also be the sub-order with a sequence number that is not the earliest among the sub-orders of the same production batch.
[0171] The non-verified sub-order can be determined by user input. In this embodiment, in response to the non-verification instruction input by the user, the sub-order indicated by the non-verification instruction is determined as a non-verified sub-order. Exemplarily, assuming that the target sub-orders are sub-orders 1-sub-order 5 and sub-orders 7-sub-order 11, and sub-order 6 is missing, the intelligent warehousing system needs to send a message to the material pull system to indicate that each target sub-order has an error, and manually determine in the material pull system that sub-order 6 is indeed missing, and manually deliver the parts indicated by the part identification of sub-order 6 to the production line. At this time, in order to ensure that each target sub-order can pass the continuity check, thereby ensuring that the subsequent process of replenishing parts for each target sub-order and delivering parts to the production line can be normal, so as to avoid production stagnation due to failure to replenish in time, sub-order 7 can be treated as a non-verified sub-order, and no continuity check is performed on sub-order 7.
[0172] In another possible embodiment, the intelligent warehousing system can determine different production batches by receiving time intervals, and determine the sub-order with the first priority among the sub-orders of the same production batch, and generate a non-verification instruction for the sub-order, that is, the sub-order is used as a non-verification sub-order. In this embodiment, the difference between the time when the current sub-order is received and the time when the last sub-order was received can be calculated. If the difference is greater than a preset time threshold, the sub-order currently received is considered to be a sub-order of a new batch, and the sub-order with the first priority among the sub-orders currently received is used as a non-verification sub-order.
[0173] S110, setting a non-verification continuity flag for the non-verification sub-order.
[0174] Corresponding to the example shown in Table 1 above, Figure 3 In the illustrated embodiment, if sub-order 1 is a non-verified sub-order, the information of each sub-order stored in the database of the intelligent warehousing system may be as shown in Table 2:
[0175] Table 2 Sub-order information example 2
[0176] S102, when the sub-orders are arranged from first to last according to their respective orders, the sub-orders located in the first preset number of places are determined as target sub-orders.
[0177] S1031: If the first target sub-order is not set with a non-continuity verification flag, determine whether a sub-order that is ranked before the first target sub-order is found in the database.
[0178] The first target sub-order is the sub-order with the highest priority among all target sub-orders.
[0179] If the first target sub-order is not set with a non-continuity verification flag, it is necessary to perform a continuity check on the first target sub-order, that is, it is necessary to determine whether a sub-order that is ranked before the first target sub-order is found in the database; if the first target sub-order is set with a non-continuity verification flag, it is not necessary to perform a continuity check on the first target sub-order, and S1041 is executed directly.
[0180] S1041, for each second target sub-order, if the second target sub-order is not set with a non-verification continuity flag, determine whether a sub-order that ranks before the second target sub-order is found in each target sub-order.
[0181] The second target sub-order is a sub-order that is not the first in the target sub-order sequence.
[0182] For a second target sub-order, determine whether the second target sub-order is set with a non-verification continuity flag. If the second target sub-order is not set with a non-verification continuity flag, it is necessary to perform a continuity check on the second target sub-order, that is, it is necessary to determine whether a sub-order that is ranked before the second target sub-order is found in each target sub-order; if the second target sub-order is set with a non-verification continuity flag, it is not necessary to perform a continuity check on the second target sub-order and the second target sub-order can be skipped.
[0183] Afterwards, the above process is executed for other second target sub-orders in sequence until the above process is completed for all second target sub-orders.
[0184] S105: Determine whether the target sub-orders are repeated according to the respective sequences and order identifiers of the target sub-orders.
[0185] S106, if a sub-order with a priority before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority before the second target sub-order is found in each target sub-order, and the target sub-orders are not repeated, then for each target sub-order, the inventory quantity of the part represented by the part identifier of the target sub-order is determined in the order in which the target sub-orders are arranged from first to last.
[0186] S107, for each target sub-order, if the inventory quantity is less than the part quantity of the target sub-order, a replenishment order is generated according to the part identifier of the target sub-order.
[0187] S108: If a sub-order that is ranked before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order that is ranked before the second target sub-order is not found in each target sub-order, and / or, at least one target sub-order is repeated, a message indicating that each target sub-order is wrong is sent to the preset terminal.
[0188] S105 - S108 have been exemplarily described in the foregoing text. Please refer to the relevant description of S105 - S108 in the foregoing text, and will not be repeated here.
[0189] By selecting this embodiment, the sub-orders of different production batches can be separated by not checking the continuity mark. When the intelligent warehousing system receives multiple sub-orders in two time periods with a long interval, the multiple sub-orders received in different time periods are regarded as sub-orders of different production batches, and the sub-order with the first priority among the sub-orders of the same production batch is set with a non-checked continuity mark, so that there is no need to perform continuity check on the sub-order with the first priority among the sub-orders of the same production batch, thereby avoiding the situation where the user needs to set the priority of the first sub-order to a priority that is continuous with the priority of the last sub-order of the previous production batch when setting the first sub-order of the next production batch through the material pulling system, so that the user does not need to record the priority of the last sub-order of the previous production batch, thereby improving the user's operation convenience. In addition, in the case where the missing sub-orders have been manually processed, the non-checked continuity mark setting allows each sub-order received by the intelligent warehousing system to pass the continuity check normally, so that the subsequent parts replenishment and parts distribution to the production line can be carried out normally for each sub-order, avoiding the situation of production stagnation.
[0190] The above has provided an exemplary description of the setting of the non-verification continuity flag. It is understandable that, in addition to storing the sub-orders that have just been received, the database of the intelligent warehousing system may also store sub-orders that are in production or completed. In order to distinguish sub-orders in different states, in a possible embodiment, the database also stores the order status of each sub-order; the order status includes: newly created, in progress, and completed. Figure 4 , the replenishment order generation method provided in this application includes:
[0191] S101, receiving and storing in a database the order, order identification, part identification and part quantity of each sub-order sent by a preset terminal.
[0192] S101 has been exemplarily described in the foregoing text, and reference may be made to the related description of S101 in the foregoing text, which will not be repeated here.
[0193] S111, setting the order status of each sub-order to new.
[0194] When the intelligent warehousing system receives the sub-order sent by the material pulling system, it stores the received sub-order in the database and sets the order status of the received sub-order to new. Figure 4 In the illustrated embodiment, the information of each sub-order stored in the database of the intelligent warehousing system may be as shown in Table 3:
[0195] Table 3 Sub-order information example 3
[0196] S1021, when the candidate sub-orders are arranged from first to last according to their respective ranks, the candidate sub-orders located in the first preset number of places are determined as target sub-orders.
[0197] The candidate sub-order is a sub-order with a newly created order status in the database.
[0198] When all sub-orders in the database with the order status of being newly created are arranged from first to last according to their respective orders, the sub-orders located in the first preset number of places are determined as target sub-orders.
[0199] S103, determining whether a sub-order that is ranked one before the first target sub-order is found in the database.
[0200] The first target sub-order is the sub-order with the highest priority among all target sub-orders.
[0201] S104: for each second target sub-order, determine whether a sub-order that ranks before the second target sub-order is found in each target sub-order.
[0202] The second target sub-order is a sub-order that is not the first in the target sub-order sequence.
[0203] S105: Determine whether the target sub-orders are repeated according to the respective sequences and order identifiers of the target sub-orders.
[0204] S106, if a sub-order with a priority before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority before the second target sub-order is found in each target sub-order, and the target sub-orders are not repeated, then for each target sub-order, the inventory quantity of the part represented by the part identifier of the target sub-order is determined in the order in which the target sub-orders are arranged from first to last.
[0205] S107, for each target sub-order, if the inventory quantity is less than the part quantity of the target sub-order, a replenishment order is generated according to the part identifier of the target sub-order.
[0206] S108: If a sub-order that is ranked before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order that is ranked before the second target sub-order is not found in each target sub-order, and / or, at least one target sub-order is repeated, a message indicating that each target sub-order is wrong is sent to the preset terminal.
[0207] S103 - S108 have been exemplarily described in the foregoing text. Please refer to the relevant description of S103 - S108 in the foregoing text, and will not be repeated here.
[0208] S112, in response to receiving a message indicating that the part indicated by the part identifier of the target sub-order has been shipped out, modifying the order status of the target sub-order to being executed.
[0209] The execution of outbound delivery of the part indicated by the part identification of the target sub-order may refer to that the robot is carrying the part indicated by the part identification of the target sub-order to the workstation at the production line, or may refer to that the robot is heading to the warehouse to carry the part indicated by the part identification of the target sub-order to the workstation at the production line after arriving at the warehouse. In the case of executing outbound delivery of the part indicated by the part identification of the target sub-order, the production line may send a message to the intelligent warehousing system indicating that the outbound delivery of the part indicated by the part identification of the target sub-order is executed, so that the intelligent warehousing system changes the order status of the target sub-order to being executed.
[0210] For example, corresponding to the example shown in Table 3 above, if part 1 required by sub-order 1 and part 2 required by sub-order 2 are being transported to the workstations on the production line, the information of each sub-order stored in the database of the intelligent warehousing system may be as shown in Table 4:
[0211] Table 4 Sub-order information example 4
[0212] In another possible embodiment, when a message indicating that the parts indicated by the part identifier of the target sub-order have been shipped out is received, the target sub-order may be directly deleted from the sub-order information table.
[0213] S113, in response to receiving a message indicating that the delivery of the part indicated by the part identifier of the target sub-order is completed, modifying the order status of the target sub-order to completed.
[0214] If the robot transports the part represented by the part identifier of the target sub-order from the workstation on the production line to the production line, the production line can send a message to the intelligent warehousing system indicating that the part represented by the part identifier of the target sub-order has been shipped out of the warehouse, so that the intelligent warehousing system will change the order status of the target sub-order to completed.
[0215] For example, corresponding to the example shown in Table 4 above, if the production line is transporting part 1 required for sub-order 1 and part 2 required for sub-order 2 from the workstations on the production line to the production line, the information of each sub-order stored in the database of the intelligent warehousing system may be as shown in Table 5:
[0216] Table 5 Sub-order information example 5
[0217] In another possible embodiment, when a message indicating that the delivery of the parts indicated by the part identifier of the target sub-order is completed is received, the target sub-order can be directly deleted from the sub-order information table.
[0218] The above has provided an exemplary description of the method of distinguishing sub-orders of different states in the database. As described in the aforementioned S101, there may be multiple parts required to produce a certain product, so it is necessary to generate multiple sub-orders for the product, and in actual applications, all the parts required to produce the product are usually placed in the same order. Based on this, in a possible embodiment, the material pulling system can send multiple orders to the intelligent warehousing system, and an order includes one or more sub-orders. In order to facilitate the distinction between the sub-orders included in the order, the order identifier includes: an order number and an order line number. The order number is used to identify the order to which the sub-order belongs, and the order line number is used to identify the sub-order in the order.
[0219] Corresponding to the example shown in Table 1 above, the parts required to produce product A are 1 part 1, the parts required to produce product B are 2 parts 2 and 3 parts 3, and the parts required to produce product C are 3 parts 4. In this embodiment, the information of each sub-order stored in the database of the intelligent warehousing system can be shown in Table 6:
[0220] Table 6 Sub-order information example 6
[0221] As shown in Table 6, Order 1 is an order generated for product A. Only one different type of parts is needed to produce product A. Therefore, Order 1 includes only one sub-order, the order line number of which is 1, and the order number of which is the order to which the sub-order belongs, i.e., Order 1. Order 2 is an order generated for product B. Two different types of parts are needed to produce product B. Therefore, Order 2 includes two sub-orders. The order line number of the first sub-order is 1, and the order number is the order to which the first sub-order belongs, i.e., Order 2; the order line number of the second sub-order is 2, and the order number is the order to which the second sub-order belongs, i.e., Order 2. Order 3 is an order generated for product C. Only one different type of parts is needed to produce product C. Therefore, Order 3 includes only one sub-order, the order line number of which is 1, and the order number of which is the order to which the sub-order belongs, i.e., Order 3.
[0222] The order identifiers are described above by way of example. Figure 1 In the illustrated embodiment, after the replenishment order is generated in S107, the intelligent warehousing system can send the replenishment order to the warehouse management system. The warehouse management system puts the parts indicated by the part identifier of the replenishment order on the shelf according to the received replenishment order, and controls the mobile robot to move the put-on parts to the warehouse. In order to distinguish the execution status of the replenishment order, in a possible embodiment, the database also stores the part identifier and order status of each replenishment order; the order status of the replenishment order includes: new, executing, and completed; see Figure 5 , for each target sub-order, the inventory quantity of the part represented by the part identifier of the target sub-order is determined by the following methods, including:
[0223] S501, determine the storage quantity of the part indicated by the part identifier of the target sub-order.
[0224] The database of the intelligent warehousing system records the part identification and storage quantity of each part stored in the warehouse. By searching in the database, the storage quantity of the part represented by the part identification of the target sub-order can be determined.
[0225] S502, determining a first quantity of a part indicated by a part identifier of a target sub-order in a newly created replenishment order with an order status of "a".
[0226] The database of the intelligent warehousing system records the part identification, replenishment quantity, and order status of each replenishment order generated. The first quantity can be determined by searching in the database.
[0227] Specifically, a replenishment order with an order status of "Newly Created" is determined among each replenishment order as the first candidate replenishment order, a replenishment order with a part identifier of the target sub-order is determined among each first candidate replenishment order as the first target replenishment order, and the sum of the replenishment quantities of all the first target replenishment orders is determined as the first quantity.
[0228] S503: Determine the second quantity of the part indicated by the part identifier of the target sub-order in the replenishment order whose order status is being executed.
[0229] Specifically, a replenishment order with an order status of being executed is determined among each replenishment order as the second candidate replenishment order, and a replenishment order with a part identifier as the part identifier of the target sub-order is determined among each second candidate replenishment order as the second target replenishment order, and the sum of the replenishment quantities of all the second target replenishment orders is used as the second quantity.
[0230] S504: The sum of the stored quantity, the first quantity and the second quantity is used as the inventory quantity of the part represented by the part identifier of the target sub-order.
[0231] The storage quantity is the number of parts already stored in the warehouse, the first quantity is the number of parts to be replenished in the warehouse, and the second quantity is the number of parts being transported to the warehouse. The sum of the storage quantity, the first quantity and the second quantity is the total number of parts that can be used in the warehouse. Only by comparing the total number of parts that can be used in the warehouse with the number of parts of the target sub-order can we more accurately determine whether the number of parts that can be used in the warehouse can support the production of the products corresponding to the target sub-order.
[0232] exist Figure 5 In the illustrated embodiment, a replenishment order may be generated and the order status of the replenishment order may be set in the following manner: for each target sub-order, if the inventory quantity is less than the part quantity of the target sub-order, a replenishment order with a part identifier being the part identifier of the target sub-order is generated, and the order status of the replenishment order is set to New; for each replenishment order, in response to receiving a message that a part indicated by the part identifier used to represent the replenishment order is put on the shelf, the order status of the replenishment order is modified to Being Executed; for each replenishment order, in response to receiving a message that a part indicated by the part identifier used to represent the replenishment order is transported to the warehouse, the order status of the replenishment order is modified to Completed.
[0233] In this embodiment, for a certain target sub-order, if the inventory quantity is less than the number of parts of the target sub-order, it means that the number of parts available in the warehouse cannot support the production of the products corresponding to the target sub-order, and replenishment is required, which means that a replenishment order needs to be generated. The part ID of the replenishment order is the part ID of the target sub-order, and the replenishment quantity of the replenishment order is the difference between the inventory quantity and the number of parts of the target sub-order, so as to avoid the situation where a large replenishment quantity causes a large warehouse area to be occupied.
[0234] After generating a replenishment order, the intelligent warehousing system sets the order status of the replenishment order to New, and sends the replenishment order to the warehouse management system. The warehouse management system puts the parts represented by the part identifier of the replenishment order on the shelves according to the received replenishment order, and sends a message to the intelligent warehousing system indicating that the parts represented by the part identifier of the replenishment order have been put on the shelves. After receiving the message indicating that the parts represented by the part identifier of the replenishment order have been put on the shelves, the intelligent warehousing system modifies the order status of the replenishment order to Being Executed.
[0235] Afterwards, the warehouse management system controls the mobile robot to move the parts on the shelves to the warehouse. When the mobile robot completes moving the parts on the shelves to the warehouse, the warehouse management system sends a message to the intelligent warehousing system indicating that the parts represented by the part identifier used to represent the replenishment order have been moved to the warehouse. After receiving the message that the parts represented by the part identifier used to represent the replenishment order have been moved to the warehouse, the intelligent warehousing system modifies the order status of the replenishment order to completed.
[0236] In addition, the database also stores the order of each replenishment order, so that the warehouse management system can execute each replenishment order according to the order of each replenishment order. The warehouse management system executes the replenishment order by putting the parts indicated by the part identifier of the replenishment order on the shelf and controlling the mobile robot to move the put-on parts to the warehouse.
[0237] The above has been described in an exemplary manner for the order status of a replenishment order. The following will be described in an exemplary manner for the replenishment order generation method provided by the present application in combination with a specific application scenario.
[0238] The material pulling system sends the information of each sub-order to the intelligent warehousing system. The information of each sub-order includes: sequence, document type, order number, order line number, part ID and part quantity. The information of each sub-order can be shown in Table 7:
[0239] Table 7 Sub-order information sent by the material pull system
[0240] In Table 7, the document type is used to distinguish the type of order. The order types include sequencing orders and replenishment orders. Sequencing orders are the aforementioned orders and sub-orders. The document number is the aforementioned order number, the document line number is the aforementioned order line number, the part number is the aforementioned part ID, and the sequence number is the aforementioned sequence.
[0241] The intelligent warehousing system receives the information of each sub-order sent by the material pulling system, and stores the information of each sub-order in the database. The information of each sub-order stored in the database of the intelligent warehousing system can be shown in Table 8:
[0242] Table 8 Sub-order information stored in the intelligent warehousing system database
[0243] Compared with Table 7, Table 8 adds two new information: the document line status of each sub-order and the non-verification continuity flag. The document line status is the aforementioned order status. The user sets the non-verification continuity flag for the sub-order with the smallest sequence among the sub-orders of the same batch in the intelligent warehousing system. Referring to Table 8, the sub-order with the smallest sequence among the sub-orders of this batch is the sub-order with document number SOD0013 and document line number 1, so the non-verification continuity flag needs to be set for this sub-order.
[0244] After the continuity flag is set, when the intelligent warehousing system arranges the sub-orders from first to last according to their respective orders, the sub-orders located in the first preset number are determined as target sub-orders. Assuming that the preset number is 10, the determined target sub-orders can be shown in Table 9:
[0245] Table 9 Replenishment order line pool of intelligent warehousing system
[0246] In Table 9, the replenishment order line pool is a collection of information about each target sub-order.
[0247] According to the continuity check and repeatability check methods shown in the above S103-S105, each target sub-order in Table 9 is subjected to continuity check and repeatability check. In Table 9, the sub-order with document number SOD0015 and document line number 1 is not continuous; the sub-order with document number SOD0017 and document line number 2 is not continuous. In addition, the sub-order with document number SOD0016 and document line number 1 and the sub-order with document number SOD0017 and document line number 1 have the same sequence number, that is, the sub-order with document number SOD0016 and document line number 1 and the sub-order with document number SOD0017 and document line number 1 are repeated. If these two sub-orders are repeated, the intelligent warehousing system sends a message to the material pulling system to indicate that each target sub-order has an error.
[0248] The material pulling system resends the information of each sub-order to the intelligent warehousing system, and the intelligent warehousing system updates the information of each sub-order. The updated information of each sub-order can be shown in Table 10:
[0249] Table 10 Information of each sub-order after the intelligent warehousing system is updated
[0250] The intelligent warehousing system re-determines the target sub-orders and obtains updated information about each target sub-order. The updated information about each sub-order can be shown in Table 11:
[0251] Table 11 Information of each target sub-order after the intelligent warehousing system is updated
[0252] In Table 11, each target sub-order is continuous and non-repetitive, so the aforementioned S106-S107 can be executed to generate a replenishment order for each target sub-order.
[0253] Specifically, it is assumed that the information of each part stored in the database of the intelligent warehousing system is as shown in Table 12:
[0254] Table 12 Information of each part stored in the intelligent storage system database
[0255] In Table 12, the part number is the aforementioned part identification, the available inventory is the aforementioned storage quantity, the newly created replenishment order inventory is the aforementioned first quantity, the ongoing replenishment order inventory is the aforementioned second quantity, and the part package specification refers to the full packaging rated quantity of the part.
[0256] The information of each replenishment order generated by the intelligent warehousing system can be shown in Table 13:
[0257] Table 13 Information of each replenishment order generated by the intelligent warehousing system
[0258] In Table 13, the document type is used to distinguish the type of order, which includes a sequencing order and a replenishment order. The sequencing order is the aforementioned order and its sub-orders. The part number is the aforementioned part ID, the sequence number is the sequence of the aforementioned replenishment order, and the document line status is the aforementioned order status.
[0259] After the replenishment order shown in Table 13 is generated, the information of each part stored in the intelligent warehousing system database needs to be updated accordingly. The updated information of each part stored in the intelligent warehousing system database may be as shown in Table 14:
[0260] Table 14 Updated information of each part stored in the intelligent storage system database
[0261] The replenishment order generation method provided in the present application has been exemplarily described above. The continuity check and repeatability check methods for each target sub-order will be exemplarily described below.
[0262] Taking the order of each sub-order as 1, 2, 3, ..., plus 1 in sequence as an example, the continuity verification method provided by this application is as follows: Figure 6 As shown, including:
[0263] S601, sorting the newly created status order rows in the database sorting order table from small to large.
[0264] The order line is the aforementioned sub-order.
[0265] S602, taking out a corresponding number of order lines from the smallest sequence number according to the set number of order line pools. If the number is insufficient, take out all of them.
[0266] The number of order line pools is the preset number mentioned above. S601-S602 is equivalent to the above Figure 4 For S111 - S1021 in the embodiment, reference may be made to the aforementioned related descriptions of S111 - S1021, which will not be repeated here.
[0267] S603, obtaining the order line with the smallest sequence number in the order line pool.
[0268] The order line pool is a collection of target sub-orders. The order line with the smallest sequence number in the order line pool in S603 is the aforementioned first target sub-order.
[0269] S604: Whether to mark as not to check continuity.
[0270] If yes, then S605 is executed, if no, then S606 is executed. S604 is to determine whether a non-check continuity flag is set.
[0271] S605, skip continuity check.
[0272] After S605, S609 is executed.
[0273] S606, whether the minimum sequence number -1 in the database sorting order table exists.
[0274] If yes, then S607 is executed, if no, then S608 is executed. S606 is to determine whether a sub-order that is ranked one before the first target sub-order is found in the database. S603-S606 are equivalent to the aforementioned S1031, and the relevant description of S1031 can be referred to above, which will not be repeated here.
[0275] S607, order lines are continuous.
[0276] S608, order lines are not continuous.
[0277] S609, obtaining the next order line in the order line pool.
[0278] S610: Whether to mark as not to check continuity.
[0279] If yes, execute S611, if no, execute S612.
[0280] S611, skip continuity check.
[0281] Afterwards, execute S615.
[0282] S612, whether the minimum sequence number -1 in the database sorting order table exists.
[0283] If yes, execute S613, if no, execute S614.
[0284] S613, order lines are continuous.
[0285] S614, order lines are not continuous.
[0286] S615, continue to determine the next order line.
[0287] S616, whether it is the last order line in the order line pool.
[0288] If yes, the process ends; if no, S609 is executed.
[0289] S609-S616 are equivalent to the aforementioned S1041. Please refer to the aforementioned related description of S1041 and will not be repeated here.
[0290] The repeatability verification method provided in this application is as follows Figure 7 As shown, including:
[0291] S701, sort the newly created status order rows in the database sorting order table from small to large.
[0292] The order line is the aforementioned sub-order.
[0293] S702, taking out a corresponding number of order lines from the smallest sequence number according to the set number of order line pools. If the number is insufficient, take out all of them.
[0294] The number of order line pools is the preset number mentioned above. S701-S702 is equivalent to the above Figure 4 For S111 - S1021 in the embodiment, reference may be made to the aforementioned related descriptions of S111 - S1021, which will not be repeated here.
[0295] S703, obtaining the order line with the smallest sequence number in the order line pool.
[0296] The order line pool is a collection of target sub-orders. The order line with the smallest sequence number in the order line pool is the first target sub-order mentioned above.
[0297] S704, whether there are order lines with different order numbers and order line numbers in the order line pool.
[0298] If yes, execute S705, if no, execute S706. S704 is equivalent to determining whether a sub-order with the same sequence as the first target sub-order and a different order number and / or order line number from the first target sub-order is found in the target sub-order. The order number and / or order line number being different from the first target sub-order means that the order identifier is different from the first target sub-order.
[0299] S705, order line is duplicated.
[0300] S706, order lines are not duplicated.
[0301] S707, continue to determine the next order line.
[0302] S708: Is it the last order line in the order line pool?
[0303] If yes, then execute S709, if no, then execute S704. The last order line in the order line pool is the aforementioned third target sub-order.
[0304] S709, whether there are order lines with different order numbers and order line numbers in the database sorting order table.
[0305] If yes, then S710 is executed, if no, then S711 is executed. S709 is equivalent to determining whether a sub-order with the same sequence as the third target sub-order and a different order number and / or order line number from the third target sub-order is found in the database. The order number and / or order line number being different from the third target sub-order means that the order identifier is different from the third target sub-order.
[0306] S710, Duplicate order line.
[0307] S711, order lines are not duplicated.
[0308] After S705, S710-S711, the process ends. S703-S711 is equivalent to the aforementioned S1051-S1056, and the relevant description of S1051-S1056 can be referred to above, which will not be repeated here.
[0309] Corresponding to the aforementioned replenishment order generation method, the present application also provides a replenishment order generation device, such as Figure 8 As shown, the device comprises:
[0310] The receiving module 801 is used to receive and store in a database the order, order identifier, part identifier and part quantity of each sub-order sent by a preset terminal;
[0311] A target sub-order determining module 802 is used to determine the sub-orders located in the first preset number of places as the target sub-orders when the sub-orders are arranged from the first to the last according to their respective orders;
[0312] The first judgment module 803 is used to judge whether a sub-order whose priority is one before the first target sub-order is found in the database; wherein the first target sub-order is the sub-order with the first priority among all target sub-orders;
[0313] The second judgment module 804 is used to judge, for each second target sub-order, whether a sub-order whose sequence is one order before the second target sub-order is found in each target sub-order; wherein the second target sub-order is a sub-order whose sequence is not the first in the target sub-order;
[0314] The third judgment module 805 is used to judge whether each target sub-order is repeated according to the order and order identifier of each target sub-order;
[0315] The inventory quantity determination module 806 is used to determine the inventory quantity of the part indicated by the part identifier of the target suborder according to the order of the respective target suborders from first to last, if a suborder with a priority one before the first target suborder is found in the database, and for each second target suborder, a suborder with a priority one before the second target suborder is found in each target suborder, and the target suborders are not repeated;
[0316] A replenishment order generating module 807 is used to generate a replenishment order for each target sub-order according to the part identifier of the target sub-order if the inventory quantity is less than the part quantity of the target sub-order;
[0317] The message sending module 808 is used to send a message indicating that each target sub-order has an error to a preset terminal if a sub-order that is ranked before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order that is ranked before the second target sub-order is not found in each target sub-order, and / or at least one target sub-order is repeated.
[0318] In a possible embodiment, judging whether each target sub-order is repeated according to the respective order and order identifier of each target sub-order includes:
[0319] Determine whether a first sub-order with the same priority as the third target sub-order is found in the database; wherein the third target sub-order is the last sub-order in the priority of each target sub-order;
[0320] If a first sub-order with the same priority as the third target sub-order is found in the database, then for each first sub-order with the same priority, it is determined whether the order identifier of the first sub-order with the same priority is the same as the order identifier of the third target sub-order;
[0321] For each fourth target sub-order, determine whether a second sub-order with the same priority as the fourth target sub-order is found in the target sub-orders; wherein the fourth target sub-order is a sub-order whose priority is not the last in each target sub-order;
[0322] For each fourth target sub-order, if a second sub-order with the same priority as the fourth target sub-order is found in the target sub-orders, then for each second sub-order with the same priority, determine whether the order identifier of the second sub-order with the same priority is the same as the order identifier of the fourth target sub-order;
[0323] If the order ID of each first sub-order of the same order is the same as the order ID of the third target sub-order, and for each fourth target sub-order, the order ID of each second sub-order of the same order is the same as the order ID of the fourth target sub-order, then it is determined that the target sub-orders are not repeated;
[0324] If the order identifier of at least one first sub-order of the same order is different from the order identifier of the third target sub-order, and / or, for at least one fourth target sub-order, the order identifier of at least one second sub-order of the same order is different from the order identifier of the fourth target sub-order, then at least one target sub-order is determined to be duplicated.
[0325] In a possible embodiment, after receiving and storing in a database the sequence, order identifier, part identifier, and part quantity of each sub-order sent by the preset terminal, the device further includes:
[0326] a non-verification sub-order determination module, configured to, in response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as a non-verification sub-order;
[0327] The non-verification continuity flag setting module is used to set the non-verification continuity flag for the non-verification sub-order;
[0328] Determining whether a sub-order that is ranked one order before the first target sub-order is found in the database includes:
[0329] If the first target sub-order is not set with a non-verification continuity flag, determine whether a sub-order that is ranked one position before the first target sub-order is found in the database;
[0330] Determining whether a sub-order that is ranked one order before the second target sub-order is found in each target sub-order includes:
[0331] If the second target sub-order is not provided with a non-continuity verification flag, it is determined whether a sub-order ranking one before the second target sub-order is found in each target sub-order.
[0332] In a possible embodiment, the order identifier includes: an order number and an order line number, the order number is used to identify the order to which the sub-order belongs, and the order line number is used to identify the sub-order in the order.
[0333] In a possible embodiment, the database also stores the part identification and order status of each replenishment order; the order status of the replenishment order includes: newly created, in progress, and completed;
[0334] Determine the inventory quantity of the part indicated by the part ID of the target child order, including:
[0335] Determine the storage quantity of the part indicated by the part identifier of the target sub-order;
[0336] Determine a first quantity of a part indicated by a part identifier of a target sub-order in a replenishment order with an order status of newly created;
[0337] Determine a second quantity of the part indicated by the part identifier of the target sub-order in the replenishment order with an order status of being executed;
[0338] The sum of the storage quantity, the first quantity and the second quantity is used as the inventory quantity of the part represented by the part identifier of the target sub-order;
[0339] Generate a replenishment order for the part ID of the target sub-order, including:
[0340] Generate a replenishment order with the part ID of the target sub-order, and set the order status of the replenishment order to New;
[0341] In response to receiving a message indicating that a part indicated by a part identifier used to indicate a replenishment order is put on the shelf, modifying the order status of the replenishment order to being executed;
[0342] In response to receiving a message that the part indicated by the part identifier used to indicate the replenishment order is transported to the warehouse, the order status of the replenishment order is modified to completed.
[0343] In a possible embodiment, generating a replenishment order whose part identification is the part identification of the target sub-order includes:
[0344] A replenishment order is generated whose part ID is the part ID of the target sub-order and whose replenishment quantity is the difference between the inventory quantity and the part quantity of the target sub-order.
[0345] The present application also provides an electronic device, such as Figure 9 As shown, including:
[0346] Memory 901, used for storing computer programs;
[0347] The processor 902 is used to execute the program stored in the memory 901, and implements the following steps:
[0348] Receiving and storing in a database the respective order, order ID, part ID and part quantity of each sub-order sent by a preset terminal;
[0349] When the sub-orders are arranged from first to last according to their respective orders, the sub-orders at the first preset number are determined as the target sub-orders;
[0350] Determine whether a sub-order that is ranked one order before the first target sub-order is found in the database; wherein the first target sub-order is the sub-order that is ranked first among all target sub-orders;
[0351] For each second target sub-order, determine whether a sub-order whose sequence is one order before the second target sub-order is found in each target sub-order; wherein the second target sub-order is a sub-order whose sequence is not the first in the target sub-order;
[0352] According to the respective order rankings and order identifiers of the target sub-orders, determine whether the target sub-orders are repeated;
[0353] If a sub-order with a priority that is one place before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority that is one place before the second target sub-order is found in each target sub-order, and the target sub-orders are not repeated, then for each target sub-order, the inventory quantity of the part represented by the part identifier of the target sub-order is determined in the order in which the respective priorities of the target sub-orders are arranged from first to last;
[0354] For each target sub-order, if the inventory quantity is less than the part quantity of the target sub-order, a replenishment order is generated for the part ID of the target sub-order;
[0355] If a sub-order that is ranked before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order that is ranked before the second target sub-order is not found in each target sub-order, and / or at least one target sub-order is repeated, a message indicating that each target sub-order is wrong is sent to the preset terminal.
[0356] Furthermore, the electronic device may further include a communication bus and / or a communication interface, and the processor 902, the communication interface, and the memory 901 communicate with each other via the communication bus.
[0357] The communication bus mentioned in the above electronic device can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.
[0358] The communication interface is used for communication between the above electronic device and other devices.
[0359] The memory may include a random access memory (RAM) or a non-volatile memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.
[0360] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
[0361] In another embodiment provided in the present application, a computer-readable storage medium is provided, in which a computer program is stored. When the computer program is executed by a processor, the steps of any of the above replenishment order generation methods are implemented.
[0362] In another embodiment provided by the present application, a computer program product including instructions is also provided, which, when executed on a computer, enables the computer to execute any replenishment order generation method in the above embodiments.
[0363] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from a website site, computer, server or data center to another website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that includes one or more available media integrated. The available medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a solid-state hard disk (SSD), etc.
[0364] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.
[0365] Each embodiment in this specification is described in a related manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the embodiments of the device, electronic device, computer-readable storage medium, and computer program product containing instructions, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.
[0366] The above description is only a preferred embodiment of the present application and is not intended to limit the protection scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims
1. A replenishment order generation method, characterized in that: The method comprises: Receiving and storing in a database the respective order, order ID, part ID and part quantity of each sub-order sent by a preset terminal; When the sub-orders are arranged from first to last according to their respective orders, the sub-orders located in the first preset number of positions are determined as target sub-orders; Determine whether a sub-order that is ranked one before the first target sub-order is found in the database; wherein the first target sub-order is the sub-order that is ranked first among the target sub-orders; For each second target sub-order, determine whether a sub-order whose sequence is one order before the second target sub-order is found in each target sub-order; wherein the second target sub-order is a sub-order whose sequence is not the first in the target sub-order; Determining whether each of the target sub-orders is repeated according to the respective order sequence and order identifier of each of the target sub-orders; If a sub-order with a priority one before the first target sub-order is found in the database, and for each second target sub-order, a sub-order with a priority one before the second target sub-order is found in each target sub-order, and the target sub-orders are not repeated, then for each target sub-order, the inventory quantity of the part represented by the part identifier of the target sub-order is determined in the order in which the priority of each target sub-order is arranged from first to last; For each of the target sub-orders, if the inventory quantity is less than the part quantity of the target sub-order, a replenishment order is generated for the part identifier of the target sub-order; If a sub-order that is ranked before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order that is ranked before the second target sub-order is not found in each of the target sub-orders, and / or at least one of the target sub-orders is repeated, a message indicating that each of the target sub-orders is wrong is sent to the preset terminal.
2. The method according to claim 1, characterized in that The determining whether each of the target sub-orders is repeated according to the respective order and order identifier of each of the target sub-orders includes: Determine whether a first sub-order with the same priority as the third target sub-order is found in the database; wherein the third target sub-order is the last sub-order in the priority of each target sub-order; If a first sub-order with the same priority as the third target sub-order is found in the database, determining, for each of the first sub-orders with the same priority, whether the order identifier of the first sub-order with the same priority is the same as the order identifier of the third target sub-order; For each fourth target sub-order, determine whether a second sub-order with the same priority as the fourth target sub-order is found in the target sub-order; wherein the fourth target sub-order is a sub-order whose priority is not the last in each of the target sub-orders; For each of the fourth target sub-orders, if a second sub-order with the same priority as the fourth target sub-order is found in the target sub-orders, then for each of the second sub-orders with the same priority, determining whether the order identifier of the second sub-order with the same priority is the same as the order identifier of the fourth target sub-order; If the order identifiers of the first sub-orders of the same order are the same as the order identifier of the third target sub-order, and for each of the fourth target sub-orders, the order identifiers of the second sub-orders of the same order are the same as the order identifier of the fourth target sub-order, then it is determined that the target sub-orders are not repeated; If the order identifier of at least one of the first sub-orders of the same rank is different from the order identifier of the third target sub-order, and / or, for at least one of the fourth target sub-orders, the order identifier of at least one of the second sub-orders of the same rank is different from the order identifier of the fourth target sub-order, then it is determined that at least one of the target sub-orders is repeated.
3. The method according to claim 1, characterized in that After the step of receiving and storing in the database the respective order, order identification, part identification and part quantity of each sub-order sent by the preset terminal, the method further includes: In response to a no-verification instruction, determining the sub-order indicated by the no-verification instruction as a no-verification sub-order; Setting a non-verification continuity flag for the non-verification sub-order; The determining whether a sub-order that is ranked one before the first target sub-order is found in the database includes: If the first target sub-order is not set with the non-verification continuity flag, determining whether a sub-order that is ranked one before the first target sub-order is found in the database; The determining whether a sub-order that is ranked one before the second target sub-order is found in each of the target sub-orders includes: If the second target sub-order is not provided with the non-verification continuity flag, it is determined whether a sub-order ranking one before the second target sub-order is found in each of the target sub-orders.
4. The method according to claim 1, characterized in that: The order identification includes: an order number and an order line number, the order number is used to identify the order to which the sub-order belongs, and the order line number is used to identify the sub-order in the order.
5. The method according to claim 1, characterized in that The database also stores the parts identification and order status of each replenishment order; The order status of the replenishment order includes: new, executing and completed; Determining the inventory quantity of the part indicated by the part identifier of the target sub-order includes: Determining the storage quantity of the part indicated by the part identifier of the target sub-order; Determine a first quantity of the part indicated by the part identifier of the target sub-order in the replenishment order with an order status of newly created; Determine a second quantity of the part indicated by the part identifier of the target sub-order in the replenishment order with an order status of being executed; The sum of the stored quantity, the first quantity and the second quantity is used as the inventory quantity of the part represented by the part identifier of the target sub-order; The step of generating a replenishment order for the part identification of the target sub-order includes: Generate a replenishment order whose part ID is the part ID of the target sub-order, and set the order status of the replenishment order to new; In response to receiving a message indicating that a part indicated by a part identifier of the replenishment order has been put on the shelf, modifying the order status of the replenishment order to being executed; In response to receiving a message that the part indicated by the part identifier used to indicate the replenishment order is transported to the warehouse, the order status of the replenishment order is modified to completed.
6. The method according to claim 5, characterized in that The step of generating a replenishment order with a part identifier being the part identifier of the target sub-order includes: A replenishment order is generated whose part identifier is the part identifier of the target sub-order and whose replenishment quantity is the difference between the inventory quantity and the part quantity of the target sub-order.
7. A replenishment order generating device, characterized in that: The device comprises: A receiving module, used for receiving and storing in a database the respective order, order identification, part identification and part quantity of each sub-order sent by a preset terminal; A target sub-order determination module, configured to determine the sub-orders located in the first preset number of places as target sub-orders when the sub-orders are arranged from first to last according to their respective orders; A first judgment module is used to judge whether a sub-order whose priority is one before the first target sub-order is found in the database; wherein the first target sub-order is the sub-order with the first priority among all the target sub-orders; A second judgment module is used to judge, for each second target sub-order, whether a sub-order whose sequence is one order before the second target sub-order is found in each target sub-order; wherein the second target sub-order is a sub-order whose sequence is not the first in the target sub-order; A third judgment module is used to judge whether each of the target sub-orders is repeated according to the respective order and order identifier of each of the target sub-orders; an inventory quantity determination module, for determining the inventory quantity of the part represented by the part identifier of the target suborder according to the order of the respective priorities of the target suborders, if a suborder with a priority one before the first target suborder is found in the database, and for each second target suborder, a suborder with a priority one before the second target suborder is found in each target suborder, and the target suborders are not repeated; A replenishment order generation module, for each of the target sub-orders, if the inventory quantity is less than the part quantity of the target sub-order, then generating a replenishment order for the part identifier of the target sub-order; A message sending module is used to send a message indicating that each target sub-order is wrong to the preset terminal if a sub-order ranking one before the first target sub-order is not found in the database, and / or, for at least one second target sub-order, a sub-order ranking one before the second target sub-order is not found in each of the target sub-orders, and / or at least one of the target sub-orders is repeated.
8. The device according to claim 7, characterized in that The determining whether each of the target sub-orders is repeated according to the respective order and order identifier of each of the target sub-orders includes: Determine whether a first sub-order with the same priority as the third target sub-order is found in the database; wherein the third target sub-order is the last sub-order in the priority of each target sub-order; If a first sub-order with the same priority as the third target sub-order is found in the database, determining, for each of the first sub-orders with the same priority, whether the order identifier of the first sub-order with the same priority is the same as the order identifier of the third target sub-order; For each fourth target sub-order, determine whether a second sub-order with the same priority as the fourth target sub-order is found in the target sub-order; wherein the fourth target sub-order is a sub-order whose priority is not the last in each of the target sub-orders; For each of the fourth target sub-orders, if a second sub-order with the same priority as the fourth target sub-order is found in the target sub-orders, then for each of the second sub-orders with the same priority, determining whether the order identifier of the second sub-order with the same priority is the same as the order identifier of the fourth target sub-order; If the order identifiers of the first sub-orders of the same order are the same as the order identifier of the third target sub-order, and for each of the fourth target sub-orders, the order identifiers of the second sub-orders of the same order are the same as the order identifier of the fourth target sub-order, then it is determined that the target sub-orders are not repeated; If the order identifier of at least one of the first sub-orders of the same order is different from the order identifier of the third target sub-order, and / or, for at least one of the fourth target sub-orders, the order identifier of at least one of the second sub-orders of the same order is different from the order identifier of the fourth target sub-order, then it is determined that at least one of the target sub-orders is duplicated; and / or, After the step of receiving and storing in the database the respective order, order identification, part identification and part quantity of each sub-order sent by the preset terminal, the device further comprises: a non-verification sub-order determination module, configured to, in response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as a non-verification sub-order; A non-verification continuity flag setting module, used for setting a non-verification continuity flag for the non-verification sub-order; The determining whether a sub-order that is ranked one before the first target sub-order is found in the database includes: If the first target sub-order is not set with the non-verification continuity flag, determining whether a sub-order that is ranked one before the first target sub-order is found in the database; The determining whether a sub-order that is ranked one before the second target sub-order is found in each of the target sub-orders includes: If the second target sub-order is not provided with the non-verification continuity flag, determining whether a sub-order that is ranked one before the second target sub-order is found in each of the target sub-orders; and / or, The order identification includes: an order number and an order line number, wherein the order number is used to identify the order to which the sub-order belongs, and the order line number is used to identify the sub-order in the order; and / or, The database also stores the parts identification and order status of each replenishment order; the order status of the replenishment order includes: newly created, in progress and completed; Determining the inventory quantity of the part indicated by the part identifier of the target sub-order includes: Determining the storage quantity of the part indicated by the part identifier of the target sub-order; Determine a first quantity of the part indicated by the part identifier of the target sub-order in the replenishment order with an order status of newly created; Determine a second quantity of the part indicated by the part identifier of the target sub-order in the replenishment order with an order status of being executed; The sum of the stored quantity, the first quantity and the second quantity is used as the inventory quantity of the part represented by the part identifier of the target sub-order; The step of generating a replenishment order for the part identification of the target sub-order includes: Generate a replenishment order whose part ID is the part ID of the target sub-order, and set the order status of the replenishment order to new; In response to receiving a message indicating that a part indicated by a part identifier of the replenishment order has been put on the shelf, modifying the order status of the replenishment order to being executed; In response to receiving a message that the part indicated by the part identifier used to indicate the replenishment order is transported to the warehouse, modifying the order status of the replenishment order to completed; and / or, The step of generating a replenishment order with a part identifier being the part identifier of the target sub-order includes: A replenishment order is generated whose part identifier is the part identifier of the target sub-order and whose replenishment quantity is the difference between the inventory quantity and the part quantity of the target sub-order.
9. An electronic device, characterized in that: include: Memory, used to store computer programs; A processor, for implementing any of the methods described in claims 1-6 when executing a program stored in a memory.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.
Citation Information
Patent Citations
Replenishment task generation method and device, equipment, medium and program product
CN118211905A
Distribution control system and method, and server apparatus and its control method
US20020147667A1
System and method for replenishment by purchase with attribute based planning
US20030126024A1
Universal Ordering for Manufacturing Customized Print Products
US20140108188A1
Order whole-process management method and system, computer device, and storage medium
WO2025001397A1