A method, device, electronic device and storage medium for generating a replenishment order
By receiving and verifying sub-order information, determining the target sub-order and generating replenishment orders, the unreasonable inventory problem caused by changes in part consumption rate in the intelligent warehousing system is solved, and the flexibility of replenishment of parts and efficient utilization of warehouse space is achieved.
Patent Information
- Application Number
- CN202510621710.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-05-14
- Publication Date
- 2025-08-01
- Estimated Expiration
- 2045-05-14
AI Technical Summary
When existing intelligent warehousing systems face changes in part consumption rate caused by changes in consumer demand, it is difficult to achieve flexible replenishment, resulting in excessive storage area of the warehouse or insufficient parts.
By receiving and storing sub-order information sent by preset terminals, target sub-orders are determined in order from first to later, and continuity and repetition verification are performed to generate replenishment orders to ensure the timeliness and rationality of part inventory.
It realizes flexibility in replenishing parts, reduces the number of parts stored in the warehouse, improves the utilization rate of warehouse space, and avoids production stagnation caused by insufficient parts inventory.
Smart Images

Figure CN120125148B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of logistics in flexible manufacturing enterprises, and particularly to a replenishment order generation method, device, electronic device, and storage medium. 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 inventory levels. 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 varies, resulting in different consumption rates 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 replenishment order generation method, device, electronic device, and storage medium 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 replenishment order generation method, and the method includes:
[0006] Receiving and storing in the 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; where 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; where 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 among the target sub-orders, and 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 sequences of the target sub-orders from first to last;
[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 among the target sub-orders, and / or, at least one of the target sub-orders is repeated, then send a message indicating that the target sub-orders are in error 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; where the third target sub-order is the sub-order with the last sequence among 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 among the target sub-orders; where the fourth target sub-order is the sub-order whose sequence is not the last among 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 among 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, then 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, then 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 the preset terminal, the method further includes:
[0022] In response to the non-verification instruction, determine the sub-order indicated by the non-verification instruction as the 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, then 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, then 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 shelved, 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 respective sequence numbers, order identifiers, part identifiers, and part quantities 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 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, for each second target sub-order, judge whether a sub-order whose sequence is one 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 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 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 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 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 as the third target sub-order is queried in the database, for each of the first sub-orders with the same order, determine whether the order identifier of the first sub-order with the same order is the same as the order identifier of the third target sub-order;
[0053] For each fourth target sub-order, determine whether a second sub-order with the same order 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 is not the last;
[0054] For each of the fourth target sub-orders, if a second sub-order with the same order as the fourth target sub-order is queried in the target sub-orders, for each of the second sub-orders with the same order, determine whether the order identifier of the second sub-order with the same order is the same as the order identifier of the fourth target sub-order;
[0055] If the order identifiers of the first sub-orders with 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 with the same order are the same as the order identifier of the fourth target sub-order, determine 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 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 is not the same as the order identifier of the fourth target sub-order, determine 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, order identifier, part identifier, and part quantity of each sub-order sent by the preset terminal, the apparatus further includes:
[0058] 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;
[0059] A non-verification continuity flag setting module, configured to set a non-verification continuity flag for the non-verification sub-order;
[0060] The determination of whether a sub-order with an order one before the first target sub-order is queried in the database includes:
[0061] If the first target sub-order is not set with the non-verification continuity flag, determine whether a sub-order with an order one before the first target sub-order is queried in the database;
[0062] Determining whether a sub-order ranked one position before the second target sub-order is queried among the target sub-orders includes:
[0063] If the non-checking continuity flag is not set for the second target sub-order, determining whether a sub-order ranked one position 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, where 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 further 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] Determining the storage quantity of the part represented by the part identifier of the target sub-order;
[0068] Determining 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] Determining 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] 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;
[0071] Generating a replenishment order for the part identifier of the target sub-order includes:
[0072] Generating a replenishment order with the part identifier of the target sub-order, and setting 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, modifying 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, modifying 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 when the computer program is executed by a processor, the replenishment order generation method described in any one of the above is implemented.
[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, device, electronic device, and storage medium provided by an embodiment of the present application can receive and store in a database the respective ranks, 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 rank, 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 rank, therefore, for the sub-order with the earliest rank among the target sub-orders, that is, the first target sub-order, there is no sub-order with a rank 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 rank 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 rank 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 rank 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 rank 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 in order from first to last according to their respective ranks. 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 rank 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 rank 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 in order from first to last according to their respective ranks, 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 rank have been replenished while the inventory of the parts required by the sub-orders with an earlier rank is 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 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.
[0084] Of course, it is not necessary for any product or method implementing the present 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 the present 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 the present 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 the present application;
[0087] Figure 2 A flowchart of a repetitive verification method provided by the embodiment of the present application;
[0088] Figure 3 The second flowchart of the replenishment order generation method provided by the embodiment of the present application;
[0089] Figure 4 The third flowchart of the replenishment order generation method provided by the embodiment of the present application;
[0090] Figure 5 A flowchart of a method for determining inventory quantity provided by the embodiment of the present application;
[0091] Figure 6 A flowchart of a continuity verification method provided by the embodiment of the present application;
[0092] Figure 7 Another flowchart of the repetitive verification method provided by the embodiment of the present application;
[0093] Figure 8 A structural diagram of a replenishment order generation device provided by the embodiment of the present application;
[0094] Figure 9 A structural diagram of an electronic device provided by the embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0095] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments of the present application, all other embodiments obtained by those of ordinary skill in the art based on the present application belong to the scope of protection of the present 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, intelligent warehousing systems generally judge 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. 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, as consumer demand changes, the production ratios of different products change, and the consumption rates of each part also change. Since the inventory levels of each part need to be set in advance, if the inventory levels of the parts are 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 levels of the parts relatively high will result in a relatively large number of parts piling up in the warehouse, and the area required for the warehouse to store a relatively large number of parts is also large. If the inventory levels of the parts are 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 part inventory in the warehouse.
[0099] Since problems such as excessive part piling and a large warehouse occupancy area occur when the inventory levels of the parts are set relatively high, and the situation of production stoppage due to insufficient part inventory occurs when the inventory levels of the parts are set relatively low, it is necessary to set reasonable inventory levels for each part according to the consumption rate of each part. However, the changes in consumer demand are difficult to predict, making it difficult to predict the changes in the production ratios of different products, and thus making it difficult to predict the changes in the consumption rates of each part, and it is also difficult to accurately and flexibly adjust the inventory levels of each part reasonably. Therefore, Method 1 is difficult to achieve flexible replenishment of parts.
[0100] 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 there is an error in the order of product production orders, 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, resulting in production stagnation. Moreover, an error in the order of product production orders will also cause replenishment orders to be generated in advance for the parts required by product production orders with a later order, that is, there is an early replenishment situation. This early replenishment situation will cause the parts required by the product production order with a later order 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 relatively low. That is to say, the absence of a product production order or an error in the order of product production orders may both lead to a shortage of parts in stock, resulting in production stagnation, and an error in the order of product production orders will also lead to a relatively 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 sequence number, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal.
[0105] S102, when arranging each sub-order in ascending order of their respective sequence numbers, determine the sub-orders in the first preset number of positions as target sub-orders.
[0106] S103, determine whether a sub-order with a sequence number one position 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 sequence number among all target sub-orders.
[0108] S104, for each second target sub-order, determine whether a sub-order with a sequence number one position before the second target sub-order is queried among all target sub-orders.
[0109] Wherein, the second target sub-order is a sub-order among the target sub-orders whose sequence number is not the earliest.
[0110] S105. Determine whether each target sub-order is duplicate according to the respective ranks and order identifiers of each target sub-order.
[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 part quantity 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 as target sub-orders when arranging the sub-orders in order from the earliest to the latest according to their respective priorities, 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 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 queried 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 queried 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 queried 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 queried 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 the priorities of the target sub-orders from the earliest to the latest. 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 queried 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 queried 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 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 the priorities of the target sub-orders from the earliest to the latest, which can ensure the timeliness of replenishment for each target sub-order, avoid the situation where the parts required by the sub-orders with a later priority have been replenished while there is a shortage of the parts in stock required by the sub-orders with an earlier priority, and avoid the situation where production stagnates due to insufficient part inventory. It can be seen that the embodiments 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 the area occupied by storing the 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 among all sub-orders should have been received by the intelligent warehousing system. If the sub-orders are arranged in order of their rankings from the earliest to the latest at this time, and the sub-orders in the first preset number of positions are determined as target sub-orders, and the continuity of the sub-orders is judged for each target sub-order, 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 of their rankings from the earliest to the latest 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 parts 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 generated uniformly 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 of their rankings from the earliest to the latest and determining the sub-orders in the first preset number of positions as target sub-orders, it is possible to first perform continuity verification only on the sub-orders in the first preset number of positions with higher rankings (i.e., target sub-orders), so that when performing continuity verification on 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, it can be a server, a laptop computer, etc. Among them, the execution entity is any electronic device used to execute the replenishment order generation method provided in this application. For example, it can be a server, a laptop computer, etc. Specifically, the preset terminal can be the aforementioned material pulling system, and the execution entity can be the aforementioned intelligent warehousing system. In the following, an example will be given with the preset terminal being the aforementioned material pulling system and the execution entity being the aforementioned intelligent warehousing system to exemplarily illustrate the replenishment order generation method provided in this application.
[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, then the sequence number of the sub-order generated for this product is earlier; similarly, if the production sequence of a certain product is later, then 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 among the multiple production processes required for producing this product, the sequence numbers between these multiple sub-orders can be set arbitrarily.
[0122] Exemplarily, the parts required for producing product A are 1 part 1, the parts required for producing product B are 2 part 2s and 3 part 3s, and the parts required for producing 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 the sub-orders 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 the sub-orders 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 the sub-orders 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 of Sub-order Information I
[0124]
[0125] 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.
[0126] In S102, the sequence numbers of the sub-orders 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 rule form such as 1, 2, 4, 7, …… Among them, the rule 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, ……
[0127] If the sub-orders in the first preset number of positions are determined as target sub-orders according to the order of the time when the intelligent warehousing system receives each sub-order, and the continuity of the sub-orders is judged for each target sub-order through the following S103 - S104, then when there is a discontinuous situation among the target sub-orders, it will be considered that there is a situation of missing sub-orders, that is, it is considered that the sub-orders are in error. However, as described above, there may be a problem of delay in the information transmission process. Therefore, in the above method of determining target sub-orders, the reason for the discontinuous situation among the target sub-orders may be that due to the information transmission delay, the intelligent warehousing system has just received the missing sub-orders among the target sub-orders.
[0128] Exemplarily, assume that the material pulling system sequentially sends sub-orders 1 - 100 to the intelligent warehousing system in the order of sub-order 1 - sub-order 100. The intelligent warehousing system first receives sub-orders 1 - 8 and sub-orders 10 - 2 are received, and then sub-order 9 and sub-orders 21 - 100 are received. And assume that the preset number is 10. Then in the above method of determining target sub-orders, sub-orders 1 - 8 and sub-orders 10 - 11 are taken as target sub-orders. When judging the continuity of each target sub-order, it will be considered that there is a discontinuous situation in the target sub-orders and sub-order 9 is missing. However, the intelligent warehousing system has already received and stored the information of sub-order 9. Therefore, if the sub-orders in the first preset number of positions are determined as target sub-orders according to the order of the time when the intelligent warehousing system receives each sub-order, there will be a situation of incorrect judgment of the continuity of the sub-orders.
[0129] Based on this, in order to ensure the accuracy of subsequent judgment on the continuity of sub-orders, when arranging each sub-order in order of their respective priorities from first to last, the sub-orders in the first preset number of positions are determined as target sub-orders. It can be understood that the delay is generally limited. Assume that it can be considered that the delay time of information transmission does not exceed △t1, the difference between the time when the material pulling system sends a certain sub-order and the current moment is △t2, and the intelligent warehousing system has not received this sub-order at the current moment. Then, when △t2 ≤ △t1, that is, when △t2 does not exceed the maximum delay time, it can be considered that the intelligent warehousing system has not received this sub-order due to the delay. And when △t2 > △t1, that is, when △t2 exceeds the maximum delay time, it cannot be considered that the intelligent warehousing system has not received this sub-order due to the delay. At this time, it can be considered that there is a packet loss in information transmission, resulting in the absence of this sub-order. Based on the above description, when the intelligent warehousing system receives a large number of sub-orders, even if there is a delay problem, but 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 priorities. Therefore, without considering packet loss, it can still be considered that the sub-orders with higher priorities among all sub-orders should have been received by the intelligent warehousing system. If at this time each sub-order is arranged in order of their respective priorities from first to last, 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 through the following S103 - S104, then when there is a discontinuous situation among the target sub-orders, it can be considered that there is a packet loss in information transmission, that is, there is a situation of missing sub-orders. Therefore, by determining the sub-orders in the first preset number of positions as target sub-orders when arranging each sub-order in order of their respective priorities from first to last, the accuracy of subsequent judgment on the continuity of sub-orders can be ensured.
[0130] The preset number can be set according to user requirements or actual experience. Exemplarily, the preset number can be set to 10, 15, 20, etc.
[0131] In S103, since when each sub-order is arranged in order of their respective priorities from first to last, the sub-orders in the first preset number of positions are determined as target sub-orders, and the first target sub-order is the sub-order with the earliest priority among all target sub-orders, therefore, there is no sub-order in the target sub-orders whose priority is one position before the first target sub-order.
[0132] In order to determine whether the received sub-orders in the intelligent warehousing system are consecutive, it is necessary to determine whether there is a sub-order in the database whose sequence is one position before the first target sub-order. If a sub-order whose sequence is one position before the first target sub-order is queried in the database, it indicates that the first target sub-order is consecutive; if a sub-order whose sequence is one position before the first target sub-order is not queried in the database, it indicates that the first target sub-order is not consecutive.
[0133] Specifically, if the sequences of the sub-orders are represented in the form of increasing by 1 successively, such as 1, 2, 3, ……, then the following method can be used to determine whether a sub-order whose sequence is one position before the first target sub-order is queried in the database: determine whether a sub-order whose sequence is less than that of the first target sub-order and the difference between the sequences is 1 is queried in the database. If the sequences of the sub-orders are represented in the form of increasing by 2 successively, such as 1, 3, 5, 7, ……, or 2, 4, 6, 8, ……, then the following method can be used to determine whether a sub-order whose sequence is one position before the first target sub-order is queried in the database: determine whether a sub-order whose sequence is less than that of the first target sub-order and the difference between the sequences is 2 is queried in the database. If the sequences of the sub-orders are represented in any fixed pattern form, such as 1, 2, 4, 7, ……, then the following method can be used to determine whether a sub-order whose sequence is one position before the first target sub-order is queried in the database: determine whether a sub-order whose sequence is less than that of the first target sub-order and the sequences satisfy a fixed pattern is queried in the database.
[0134] In S104, since the sub-orders are arranged from first to last according to their respective sequences, and the sub-orders in the first preset number of positions are determined as target sub-orders, and the second target sub-order is a sub-order whose sequence is not the first among the target sub-orders, therefore, there should be a sub-order in the target sub-orders whose sequence is one position before the second target sub-order. Then, for each second target sub-order, it can be determined whether each second target sub-order is consecutive by judging whether a sub-order whose sequence is one position before the second target sub-order is queried among the target sub-orders.
[0135] For a certain second target sub-order, if a sub-order whose sequence is one position before the second target sub-order is queried among the target sub-orders, it indicates that the second target sub-order is consecutive; if a sub-order whose sequence is one position before the second target sub-order is not queried among the target sub-orders, it indicates that the second target sub-order is not consecutive. S103 - S104 are the continuity checks for each target sub-order.
[0136] Specifically, for each second target sub - order, if the sequence numbers of the sub - orders are represented in the form of increasing by 1 successively, such as 1, 2, 3, ……, then the following method can be used to determine whether a sub - order with a sequence number one before the second target sub - order is found among the target sub - orders: Determine whether a sub - order with a sequence number less than that of the second target sub - order and a difference of 1 between the sequence numbers is found among the target sub - orders. If the sequence numbers of the sub - orders are represented in the form of increasing by 2 successively, such as 1, 3, 5, 7, …… or 2, 4, 6, 8, ……, then the following method can be used to determine whether a sub - order with a sequence number one before the second target sub - order is found among the target sub - orders: Determine whether a sub - order with a sequence number less than that of the second target sub - order and a difference of 2 between the sequence numbers is found among the target sub - orders. If the sequence numbers of the sub - orders are represented in any fixed - pattern form, such as 1, 2, 4, 7, ……, then the following method can be used to determine whether a sub - order with a sequence number one before the second target sub - order is found among the target sub - orders: Determine whether a sub - order with a sequence number less than that of the second target sub - order and a sequence number that satisfies the fixed pattern is found among the target sub - orders.
[0140] In S105, for a certain target sub - order, the sequence number and order identifier of the target sub - order are compared with the sequence numbers and order identifiers of each sub - order in the database. Since the order identifiers of each sub - order are different, if there is only one sub - order with the same sequence number and the same order identifier as the target sub - order among the sub - orders, then the sub - order with the same sequence number and the same order identifier as the target sub - order is the target sub - order itself, and there is no sub - order with a duplicate sequence number of the target sub - order in the database, that is, it is considered that the target sub - order is not repeated. If there is a sub - order with the same sequence number but different order identifier as the target sub - order among the sub - orders, it means that there is a sub - order with a duplicate sequence number of the target sub - order in the database, that is, it is considered that the target sub - order is repeated. S105 is the repeatability verification for each target sub - order.
[0141] It can be understood that is only a possible process schematic diagram,
[0142] The execution order between S103 - S105 shown is: S103 → S104 → S105. In other possible embodiments, S103 and S105 can also be executed simultaneously, S104 can be executed after S103, and S103 - S105 can also be executed simultaneously.
[0143] In S106, as described in S103 above, if a sub-order whose sequence is one position before the first target sub-order is found in the database, it indicates that the first target sub-order is consecutive. As described in S104 above, if for each second target sub-order, a sub-order whose sequence is one position before the second target sub-order is found among the target sub-orders, it indicates that each second target sub-order is consecutive. The first target sub-order being consecutive and each second target sub-order being consecutive means that all target sub-orders are consecutive. Therefore, S106 - S107 are executed when all target sub-orders are consecutive and all target sub-orders are non-repetitive.
[0140] By determining 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 first to last for each target sub-order, it can ensure that the processing order for each target sub-order conforms to the product production order, avoiding the situation where when the production line produces a product according to a certain sub-order, it has not yet been determined whether a replenishment order needs to be generated for the parts represented by the part identifier of that sub-order, thus avoiding the situation where production stagnates due to insufficient part inventory.
[0141] In S107, for ease of description, the parts represented by the part identifiers of the target sub-orders are referred to as target parts. For each target sub-order, if the inventory quantity of the target part is less than the quantity of parts in the target sub-order, it indicates that the target parts stored in the warehouse are insufficient, and thus a replenishment order needs to be generated for the part identifier of the target sub-order. If the inventory quantity of the target part is not less than the quantity of parts in the target sub-order, it indicates that the target parts stored in the warehouse are sufficient, and thus no replenishment order needs to be generated.
[0142] In S108, it can be understood that the non-consecutiveness of the first target sub-order and / or the non-consecutiveness of at least one second target sub-order can be regarded as the non-consecutiveness of at least one target sub-order. Therefore, for ease of description in the following text, the non-consecutiveness of the first target sub-order and / or the non-consecutiveness of at least one second target sub-order is referred to as the non-consecutiveness of at least one target sub-order.
[0143] If at least one target sub-order is non-consecutive and / or at least one target sub-order is repetitive, it indicates that there is a situation of packet loss and / or incorrect sub-order sequence among the target sub-orders, that is, the target sub-orders are in error. Therefore, in the case where the target sub-orders are in error, a message indicating that the target sub-orders are in error needs to be sent to the material pull system (i.e., the preset terminal). When the material pull system receives the message indicating that the target sub-orders are in error, it can verify the accuracy of the target sub-orders through manual verification or machine verification. If it is considered that the target sub-orders are accurate after verification, a message indicating that the target sub-orders are verified accurately is sent to the intelligent warehousing system so that the intelligent warehousing system can execute the aforementioned S106 - S107.
[0144] If it is determined after verification that each target sub-order is in error, and the reason for the error of each target sub-order is that the target sub-order is repeated, then the repeated target sub-orders can be directly deleted so that the intelligent warehousing system re-executes the foregoing S101-S105. If it is determined after verification that each target sub-order is in error, and the reason for the error of each target sub-order is that the target sub-orders are discontinuous, that is, there are missing target sub-orders, then only the missing target sub-orders can be re-sent to the intelligent warehousing system so that the intelligent warehousing system re-executes the foregoing S101-S105 after receiving the missing target sub-orders.
[0145] Alternatively, it can be understood that there may be a situation of interrupted sequence when setting the sequence of each sub-order. Exemplarily, assume that the sub-orders sent by the material pulling system to the intelligent warehousing system are sub-order 1 - sub-order 10, sub-order 12 - sub-order 20, and there is no sub-order 11 itself. In the above example, assume that the target sub-orders are sub-order 1 - sub-order 20. The intelligent warehousing system will detect that each target sub-order is discontinuous, consider each target sub-order to be in error, and send a message indicating that each target sub-order is in error to the material pulling system. Since the missing sub-order does not exist itself, therefore, when manual verification or machine verification discovers this situation, a non-verification continuity flag can be set for the target sub-order (i.e., sub-order 12) whose sequence is one position after the missing target sub-order, so that when re-performing the continuity verification, the continuity verification is not performed on sub-order 12, thereby enabling the missing target sub-order (i.e., sub-order 11) that has been determined previously to be ignored during the re-performed continuity verification, making the result of the continuity verification that each target sub-order is continuous, that is, enabling each target sub-order to pass the continuity verification, and generating a replenishment order after passing the continuity verification and the repeatability verification.
[0146] An exemplary description of the foregoing S101-S108 has been given above. Referring to the foregoing description, the replenishment order generation method provided by this application relies on the continuity verification and repeatability verification of each target sub-order. An exemplary description of the method for performing continuity verification on each target sub-order has been given in S103-S104. Below, an exemplary description of the method for performing repeatability verification on each target sub-order in S105 will be given. Referring to Figure 2 , the repeatability verification method provided by this application includes:
[0147] S1051, determine whether a first same-sequence sub-order with the same sequence as the third target sub-order is queried in the database.
[0148] Among them, the third target sub-order is the sub-order with the last sequence among each target sub-order.
[0149] 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 the order identifier of the third target sub-order.
[0150] 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.
[0151] Among them, the fourth target sub-order is a sub-order whose sequence number is not the last among all target sub-orders.
[0152] 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 the order identifier of the fourth target sub-order.
[0153] S1055, if the order identifiers of all first sub-orders with the same sequence number 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 sub-orders with the same sequence number are the same as the order identifier of the fourth target sub-order, then determine that all target sub-orders are non-duplicate.
[0154] S1056, if the order identifier of at least one first sub-order with the same sequence number is not the same as 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 with the same sequence number is not the same as the order identifier of the fourth target sub-order, then determine that at least one target sub-order is duplicate.
[0155] 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 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 compared with each sub-order in the database to determine whether the sequence numbers are the same, and the fourth target sub-order is compared with each target sub-order to determine whether the sequence numbers are the same. 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.
[0156] The following provides an exemplary description of the aforementioned S1051 - S1056:
[0157] In S1051, since the target sub - orders are determined by arranging each sub - order in order of its respective rank 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 rank among the target sub - orders, that is, for the third target sub - order, there may be sub - orders with the same rank as the third target sub - order among the sub - orders in the database other than the target sub - orders. If it is only judged whether there is a first same - rank sub - order with the same rank as the third target sub - order among the target sub - orders, it is impossible to judge whether there is a first same - rank sub - order with the same rank as the third target sub - order among the sub - orders in the database other than the target sub - orders, resulting in relatively low accuracy of the duplicate check. Therefore, in order to determine the accuracy of the duplicate check, it is necessary to judge whether a first same - rank sub - order with the same rank as the third target sub - order is found in the database.
[0158] In S1052, since the order identifiers of each sub - order are different, for each first same - rank sub - order, if the order identifier of this first same - rank sub - order is the same as that of the third target sub - order, it means that this first same - rank 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 same - rank sub - order is different from that of the third target sub - order, it means that the third target sub - order and this first same - rank sub - order are different sub - orders and the ranks are duplicated, that is, the third target sub - order is duplicated.
[0159] In S1053, since the target sub - orders are determined by arranging each sub - order in order of its respective rank 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 rank 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 rank as the first target sub - order among the sub - orders in the database other than the target sub - orders, then this sub - order with the same rank as the first target sub - order (referred to as sub - order A below) must be the sub - order with the last rank among the target sub - orders in the previous batch.
[0160] However, only after S106 - S107 have been executed for each target sub - order of the previous batch, will S102 be re - executed 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. Moreover, 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 that of 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 that of the fourth target sub - order.
[0161] 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 that of the fourth target sub - order.
[0162] 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.
[0163] 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 those 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 those 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.
[0164] 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 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 same-sequence sub-order is different from that 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.
[0165] The method of duplicate check has been exemplarily described above. As described above, the replenishment order generation method provided by this application relies on the continuity check and duplicate check 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 check, 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 check. 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 more troublesome.
[0166] 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 both the continuous verification and the repetitive verification are passed. As a result, in the case of missing sub-orders, it takes a 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 identifiers of the missing sub-orders are manually delivered to the production line. At this time, the intelligent warehousing system still considers that the sub-orders are missing, so the continuous verification of each sub-order received by the intelligent warehousing system cannot pass, resulting in the inability to carry out the subsequent part replenishment and the process of delivering parts to the production line for each sub-order, leading to production stagnation.
[0167] 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:
[0168] S101, receive and store in the database the sequence number, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal.
[0169] An exemplary description of S101 has been given in the foregoing text. You can refer to the relevant description of S101 in the foregoing text and will not be elaborated here.
[0170] S109, in response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as a non-verification sub-order.
[0171] 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.
[0172] The sub-orders that do not need to be verified can be determined by means of user input. In this embodiment, in response to the non-verification instruction input by the user, the sub-orders indicated by the non-verification instruction are determined as the sub-orders that do not need to be verified. Exemplarily, assume that the target sub-orders are sub-order 1 - sub-order 5 and sub-order 7 - sub-order 11, and there is a situation where sub-order 6 is missing. The intelligent warehousing system needs to send a message indicating that there is an error in each target sub-order to the material pulling system. The operator determines in the material pulling system that sub-order 6 is indeed missing, and the parts represented by the part identifier of sub-order 6 are delivered to the production line by the operator. At this time, in order to ensure that each target sub-order can pass the continuity verification, so as to ensure that the subsequent process of replenishing parts for each target sub-order and delivering the parts to the production line can be carried out normally, and to avoid the situation of production stagnation caused by the inability to replenish parts in time, sub-order 7 can be used as the sub-order that does not need to be verified, and the continuity verification of sub-order 7 is not performed.
[0173] In another possible embodiment, the intelligent warehousing system can determine different production batches by receiving the time interval, and determine the sub-order with the earliest sequence among the sub-orders of the same production batch, and generate a non-verification instruction for this sub-order, that is, use this sub-order as the sub-order that does not need to be verified. In this embodiment, the difference between the time when the current sub-order is received and the time when the previous sub-order was received can be calculated. If the difference is greater than the preset time threshold, it is considered that the currently received sub-order is a sub-order of a new batch, and the sub-order with the earliest sequence among the currently received sub-orders is used as the sub-order that does not need to be verified.
[0174] S110, set a non-verification continuity flag for the sub-orders that do not need to be verified.
[0175] Corresponding to the example shown in Table 1 above, in Figure 3 the embodiment shown, if sub-order 1 is the sub-order that does not need to be verified, the information of each sub-order stored in the database of the intelligent warehousing system can be as shown in Table 2:
[0176] Table 2 Example of Sub-order Information II
[0177]
[0178] S102, when arranging each sub-order in order from the earliest to the latest, the sub-orders in the first preset number of positions are determined as the target sub-orders.
[0179] S1031, if the first target sub-order does not have a non-verification continuity flag set, then determine whether a sub-order with a sequence before the first target sub-order can be queried in the database.
[0180] Among them, the first target sub-order is the sub-order with the earliest sequence among the target sub-orders.
[0181] If the first target sub - order does not have the non - verification - of - continuity flag set, then continuity verification needs to be performed on the first target sub - order, that is, it is necessary to determine whether a sub - order with a sequence number preceding the first target sub - order can be found in the database; if the first target sub - order has the non - verification - of - continuity flag set, then continuity verification does not need to be performed on the first target sub - order, and S1041 is directly executed.
[0182] S1041. For each second target sub - order, if the second target sub - order does not have the non - verification - of - continuity flag set, then determine whether a sub - order with a sequence number preceding the second target sub - order can be found among the target sub - orders.
[0183] Among them, the second target sub - order is a sub - order among the target sub - orders whose sequence number is not the earliest.
[0184] For a certain second target sub - order, determine whether the second target sub - order has the non - verification - of - continuity flag set. If the second target sub - order does not have the non - verification - of - continuity flag set, then continuity verification needs to be performed on the second target sub - order, that is, it is necessary to determine whether a sub - order with a sequence number preceding the second target sub - order can be found among the target sub - orders; if the second target sub - order has the non - verification - of - continuity flag set, then continuity verification does not need to be performed on the second target sub - order, and the second target sub - order can be skipped.
[0185] After that, the above process is sequentially executed for other second target sub - orders until the above process has been executed for all second target sub - orders.
[0186] S105. According to the respective sequence numbers and order identifiers of the target sub - orders, determine whether the target sub - orders are repeated.
[0187] S106. If a sub - order with a sequence number preceding the first target sub - order is found in the database, and for each second target sub - order, a sub - order with a sequence number preceding the second target sub - order is found among the target sub - orders, and the target sub - orders are not repeated, then for each target sub - order, determine the inventory quantity of the parts represented by the part identifier of the target sub - order in the order from the earliest to the latest according to their respective sequence numbers.
[0188] S107. For each target sub - order, 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.
[0189] S108. If a sub-order with a sequence number immediately preceding the first target sub-order cannot be found in the database, and / or for at least one second target sub-order, a sub-order with a sequence number immediately preceding the second target sub-order cannot be found among the target sub-orders, and / or at least one target sub-order is repeated, then a message indicating that there is an error with each target sub-order is sent to a preset terminal.
[0190] Exemplary descriptions of S105 - S108 have been provided above. For the relevant descriptions of S105 - S108, please refer to the above content and will not be elaborated here.
[0191] By selecting this embodiment, sub-orders of different production batches can be separated by not verifying the setting of the continuity identifier. When the intelligent warehousing system receives multiple sub-orders in two time periods with a relatively long interval, the multiple sub-orders received in different time periods are regarded as sub-orders of different production batches. The sub-order with the earliest sequence number among the sub-orders of the same production batch is set with the non-verification of the continuity identifier, so that it is not necessary to perform continuity verification on the sub-order with the earliest sequence number among the sub-orders of the same production batch. Thus, it can be avoided that when the user sets the first sub-order of the next production batch through the material pulling system, the sequence number of the first sub-order needs to be set to be consecutive with the sequence number of the last sub-order of the previous production batch, so that the user does not need to record the sequence number of the last sub-order of the previous production batch, improving the operation convenience of the user. Moreover, when the missing sub-orders have been processed manually, through the setting of the non-verification of the continuity identifier, the sub-orders received by the intelligent warehousing system can pass the continuity verification normally, so that the subsequent processes of replenishing parts for each sub-order and delivering parts to the production line can be carried out normally, avoiding the situation of production stagnation.
[0192] Exemplary descriptions of the setting of the non-verification of the continuity identifier have been provided above. It can be understood that in addition to storing the newly received sub-orders, the database of the intelligent warehousing system may also store sub-orders that are in production or have been 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: new, in execution, and completed. See Figure 4 , the replenishment order generation method provided in this application includes:
[0193] S101. Receive and store in the database the sequence number, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal.
[0194] Exemplary descriptions of S101 have been provided above. For the relevant descriptions of S101, please refer to the above content and will not be elaborated here.
[0195] S111. Set the order status of each sub - order to "New".
[0196] When the intelligent warehousing system receives a 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". Corresponding to the example shown in Table 1 above, in Figure 4 the embodiment shown, the information of each sub - order stored in the database of the intelligent warehousing system can be as shown in Table 3:
[0197] Table 3 Example of Sub - order Information III
[0198]
[0199] S1021. When arranging each candidate sub - order in order from first to last according to their respective ranks, the candidate sub - orders in the first preset number of positions are determined as target sub - orders.
[0200] Among them, the candidate sub - orders are the sub - orders in the database with the order status of "New".
[0201] When arranging the sub - orders in the database with the order status of "New" in order from first to last according to their respective ranks, the sub - orders in the first preset number of positions are determined as target sub - orders.
[0202] S103. Determine whether a sub - order whose rank is one position before the first target sub - order can be found in the database.
[0203] Among them, the first target sub - order is the sub - order with the earliest rank among all target sub - orders.
[0204] S104. For each second target sub - order, determine whether a sub - order whose rank is one position before the second target sub - order can be found among all target sub - orders.
[0205] Among them, the second target sub - orders are the target sub - orders whose ranks are not the earliest.
[0206] S105. According to the respective ranks and order identifiers of each target sub - order, determine whether each target sub - order is duplicate.
[0207] S106. If a sub - order whose rank is one position 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 position before the second target sub - order is found among all target sub - orders, and all 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 from first to last according to their respective ranks.
[0208] S107. For each target sub-order, if the inventory quantity is less than the quantity of parts in the target sub-order, then generate a replenishment order for the part identifier of the target sub-order.
[0209] S108. If a sub-order ranked one position before the first target sub-order cannot be queried in the database, and / or, for at least one second target sub-order, a sub-order ranked one position before the second target sub-order cannot be queried among the target sub-orders, and / or, at least one target sub-order is repeated, then send a message indicating an error in each target sub-order to a preset terminal.
[0210] Exemplary descriptions of S103 - S108 have been given above. For the relevant descriptions of S103 - S108, refer to the above content and will not be elaborated here.
[0211] S112. In response to receiving a message indicating the execution of the outbound of the part represented by the part identifier of the target sub-order, modify the order status of the target sub-order to "in execution".
[0212] Executing the outbound of the part represented by the part identifier of the target sub-order may mean that the robot is transporting the part represented by the part identifier of the target sub-order to the workstation at the production line, or it may mean that the robot is going to the warehouse to transport the part represented by the part identifier of the target sub-order to the workstation at the production line after arriving at the warehouse. In the case of executing the outbound of the part represented by the part identifier of the target sub-order, the production line may send a message indicating the execution of the outbound of the part represented by the part identifier of the target sub-order to the intelligent warehousing system, so that the intelligent warehousing system modifies the order status of the target sub-order to "in execution".
[0213] Exemplarily, corresponding to the example shown in Table 3 above, if the part 1 required for sub-order 1 and the part 2 required for sub-order 2 are being transported to the workstation at 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:
[0214] Table 4 Example of Sub-order Information IV
[0215]
[0216] In another possible embodiment, it is also possible to directly delete the target sub-order from the sub-order information table when receiving a message indicating the completion of the outbound of the part represented by the part identifier of the target sub-order.
[0217] S113. In response to receiving a message indicating the completion of the outbound of the part represented by the part identifier of the target sub-order, modify the order status of the target sub-order to "completed".
[0218] If the robot transports the part represented by the part identifier of the target sub-order from the work station at the production line to the production line, the production line may send a message indicating the completion of the outbound of the part represented by the part identifier of the target sub-order to the intelligent warehousing system, so that the intelligent warehousing system can modify the order status of the target sub-order to completed.
[0219] Exemplarily, 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 work station at 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:
[0220] Table 5 Example of Sub-order Information V
[0221]
[0222] In another possible embodiment, when receiving a message indicating the completion of the outbound of the part represented by the part identifier of the target sub-order, the target sub-order may be directly deleted from the sub-order information table.
[0223] The method for distinguishing sub-orders in different states in the database has been exemplarily described above. As described in S101 above, there may be multiple parts required to produce a certain product. Therefore, for this product, multiple sub-orders need to be generated. In practical applications, all the parts required to produce this product are usually placed in the same order. Based on this, in one possible embodiment, the material pull system may send multiple orders to the intelligent warehousing system. One order includes one or more sub-orders. To facilitate the distinction of each sub-order included in the order, the order identifier includes: order number and 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.
[0224] Corresponding to the example shown in Table 1 above, the part required to produce product A is 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 may be as shown in Table 6:
[0225] Table 6 Example of Sub-order Information VI
[0226]
[0227] Referring to Table 6, Order 1 is an order generated for Product A. Only 1 part of a different type is required to produce Product A. Therefore, Order 1 includes only one sub - order. The order line number of this sub - order is 1, and the order number of this sub - order is the order to which this sub - order belongs, that is, Order 1. Order 2 is an order generated for Product B. 2 parts of different types are required 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 this first sub - order belongs, that is, Order 2; the order line number of the second sub - order is 2, and the order number is the order to which this second sub - order belongs, that is, Order 2. Order 3 is an order generated for Product C. Only 1 part of a different type is required to produce Product C. Therefore, Order 3 includes only one sub - order. The order line number of this sub - order is 1, and the order number of this sub - order is the order to which this sub - order belongs, that is, Order 3.
[0228] An exemplary description of the order identifier has been given above. Refer to Figure 1 In the embodiment shown, after generating the replenishment order in S107, the intelligent warehousing system can send the replenishment order to the warehousing management system. The warehousing management system shelves the parts represented by the part identifier of the replenishment order according to the received replenishment order, and controls the mobile robot to transport the shelved parts to the warehouse. To facilitate distinguishing 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 respectively; the order status of the replenishment order includes: newly created, in execution, completed; Refer to 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 method, including:
[0229] S501, determine the storage quantity of the part represented by the part identifier of the target sub - order.
[0230] The database of the intelligent warehousing system records the part identifier 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 identifier of the target sub - order can be determined.
[0231] S502, determine the first quantity of the part represented by the part identifier of the target sub - order in the replenishment order with the order status of newly created.
[0232] The database of the intelligent warehousing system records the part identifier, replenishment quantity, and order status of each generated replenishment order respectively. By searching in the database, the first quantity can be determined.
[0233] Specifically, identify the replenishment orders with the order status of "newly created" among all replenishment orders as the first candidate replenishment orders. Then, among all the first candidate replenishment orders, identify the replenishment orders with the part identifier being the part identifier of the target sub-order as the first target replenishment orders. Take the sum of the replenishment quantities of all the first target replenishment orders as the first quantity.
[0234] S503. Determine the second quantity of the part represented by the part identifier of the target sub-order among the replenishment orders with the order status of "executing".
[0235] Specifically, identify the replenishment orders with the order status of "executing" among all replenishment orders as the second candidate replenishment orders. Then, among all the second candidate replenishment orders, identify the replenishment orders with the part identifier being the part identifier of the target sub-order as the second target replenishment orders. Take the sum of the replenishment quantities of all the second target replenishment orders as the second quantity.
[0236] S504. Take the sum of the stored 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.
[0237] The stored quantity is the quantity of parts already stored in the warehouse. The first quantity is the quantity of parts to be replenished in the warehouse. The second quantity is the quantity of parts being transported to the warehouse. The sum of the stored quantity, the first quantity, and the second quantity is the total quantity of parts available for use in the warehouse. By comparing the total quantity of parts available for use in the warehouse with the quantity of parts of the target sub-order, it is possible to more accurately determine whether the quantity of parts available in the warehouse can support the production of the product corresponding to the target sub-order.
[0238] In Figure 5 the illustrated embodiment, replenishment orders can be generated and the order status of the replenishment orders can be set in the following manner: For each target sub-order, if the inventory quantity is less than the quantity of parts of the target sub-order, generate a replenishment order with the part identifier being the part identifier of the target sub-order and set the order status of the replenishment order to "newly created"; for each replenishment order, 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 "executing"; for each replenishment order, 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".
[0239] In this embodiment, for a certain target sub-order, if the inventory quantity is less than the part quantity of the target sub-order, it means that the quantity of parts available in the warehouse cannot support the production of the product corresponding to the target sub-order, and replenishment is required. Therefore, a replenishment order needs to be generated. The part identifier of the replenishment order is the part identifier of the target sub-order, and the replenishment quantity of the replenishment order is the difference between the inventory quantity and the part quantity of the target sub-order, so as to avoid the situation where a large replenishment quantity leads to a large occupied area in the warehouse.
[0240] After the intelligent warehousing system generates a replenishment order, it sets the order status of the replenishment order to new and sends the replenishment order to the warehousing management system. The warehousing management system shelves the parts represented by the part identifier of the replenishment order according to the received replenishment order and sends a message indicating that the parts represented by the part identifier of the replenishment order are shelved to the intelligent warehousing system. After receiving the message indicating that the parts represented by the part identifier of the replenishment order are shelved, the intelligent warehousing system modifies the order status of the replenishment order to in execution.
[0241] After that, the warehousing management system controls the mobile robot to transport the shelved parts to the warehouse. When the mobile robot finishes transporting the shelved parts to the warehouse, the warehousing management system sends a message indicating that the parts represented by the part identifier of the replenishment order are transported to the warehouse to the intelligent warehousing system. After receiving the message indicating that the parts represented by the part identifier of the replenishment order are transported to the warehouse, the intelligent warehousing system modifies the order status of the replenishment order to completed.
[0242] In addition, the database also stores the respective priorities of each replenishment order, so that the warehousing management system can execute each replenishment order according to the respective priorities of each replenishment order. The way for the warehousing management system to execute a replenishment order is: to shelf the parts represented by the part identifier of the replenishment order and control the mobile robot to transport the shelved parts to the warehouse.
[0243] The order status of the replenishment order has been exemplarily described above. Next, the replenishment order generation method provided by the present application will be exemplarily described in combination with specific application scenarios.
[0244] The material pull system sends the respective information of each sub-order to the intelligent warehousing system. The respective information of each sub-order includes: priority, document type, order number, order line number, part identifier, and part quantity. The respective information of each sub-order can be as shown in Table 7:
[0245] Table 7 Sub-order information sent by the material pull system
[0246]
[0247] In Table 7, the document type is used to distinguish the types of orders, and the types of orders include sorting orders and replenishment orders. The sorting order is the aforementioned order and sub-order. 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 identifier, and the sequence number is the aforementioned sequence.
[0248] 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 as shown in Table 8:
[0249] Table 8 Information of Sub-orders Stored in the Database of the Intelligent Warehousing System
[0250] Compared with Table 7, two pieces of information, namely the document line status of each sub-order and the non-check continuity flag, are newly added in Table 8. Among them, the document line status is the aforementioned order status. The user sets the non-check continuity flag for the sub-order with the smallest sequence among the sub-orders of the same batch on 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 the document number SOD0013 and the document line number 1, so the non-check continuity flag needs to be set for this sub-order.
[0251] After setting the non-check continuity flag, when the intelligent warehousing system arranges the sub-orders in order of their respective sequences from first to last, the sub-orders in the first preset number of positions are determined as target sub-orders. Assuming the preset number is 10, the determined target sub-orders can be as shown in Table 9:
[0252] Table 9 Replenishment Order Line Pool of the Intelligent Warehousing System
[0253]
[0254] In Table 9, the replenishment order line pool is a set composed of the information of each target sub-order.
[0255] According to the continuity check and repeatability check methods shown in the foregoing S103 - S105, perform continuity check and repeatability check on each target sub - order in Table 9. 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. Also, the sequence numbers of 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, that is, the two sub - orders, namely 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. Then the intelligent warehousing system sends a message indicating that each target sub - order is in error to the material pulling system.
[0256] 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 as shown in Table 10:
[0257] Table 10 Information of each sub - order updated by the intelligent warehousing system
[0258]
[0259] The intelligent warehousing system re - determines the target sub - orders, and obtains the updated information of each target sub - order. The updated information of each sub - order can be as shown in Table 11:
[0260] Table 11 Information of each target sub - order updated by the intelligent warehousing system
[0261]
[0262] In Table 11, each target sub - order is continuous and each target sub - order is not repeated, then the foregoing S106 - S107 can be executed to generate replenishment orders for each target sub - order.
[0263] Specifically, assume that the information of each part stored in the database of the intelligent warehousing system is as shown in Table 12:
[0264] Table 12 Information of each part stored in the database of the intelligent warehousing system
[0265]
[0266] In Table 12, the part number is the foregoing part identifier, the available inventory is the foregoing stored quantity, the newly created replenishment order inventory is the foregoing first quantity, the in - execution replenishment order inventory is the foregoing second quantity, and the part package specification refers to the full - package rated quantity of the part.
[0267] The information of each replenishment order generated by the intelligent warehousing system can be as shown in Table 13:
[0268] Table 13 Information of each replenishment order generated by the intelligent warehousing system
[0269]
[0270] In Table 13, the document type is used to distinguish the types of orders. The types of orders include sorting orders and replenishment orders. The sorting order is the aforementioned order and sub-orders. The part number is the aforementioned part identifier, the sequence number is the sequence of the aforementioned replenishment order, and the document line status is the aforementioned order status.
[0271] After generating the replenishment orders as shown in Table 13, the information of each part stored in the intelligent warehousing system database needs to be updated correspondingly. The updated information of each part stored in the intelligent warehousing system database can be as shown in Table 14:
[0272] Table 14 Updated information of each part stored in the intelligent warehousing system database
[0273]
[0274] The replenishment order generation method provided in the present application has been exemplarily described above. Next, the continuity check and repeatability check methods for each target sub-order will be exemplarily described respectively.
[0275] Taking the form of representing the sequence numbers of each sub-order as 1, 2, 3,... increasing by 1 in turn as an example, the continuity check method provided in the present application is as Figure 6 shown and includes:
[0276] S601, sort the order lines in the new status in the database sorting order table from smallest to largest.
[0277] The order line is the aforementioned sub-order.
[0278] S602, take out the corresponding number of order lines from the smallest sequence number according to the set number of order line pools. If the quantity is insufficient, take out all.
[0279] The number of order line pools is the aforementioned preset number. S601 - S602 is equivalent to S111 - S1021 in the aforementioned Figure 4 embodiment. For the relevant description of S111 - S1021, reference can be made to the aforementioned description of S111 - S1021, and details will not be repeated here.
[0280] S603, obtain the order line with the smallest sequence number in the order line pool.
[0281] The order line pool is a set 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.
[0282] S604, check whether it is marked as not verifying continuity.
[0283] If so, execute S605; if not, execute S606. S604 is to determine whether there is an identifier for not verifying continuity.
[0284] S605, skip the continuity check.
[0285] After S605, execute S609.
[0286] S606, check whether there is an order table with the smallest sequence number - 1 in the database sorting.
[0287] If so, execute S607; if not, execute S608. S606 is to determine whether a sub-order whose position is one before the first target sub-order is queried in the database. S603 - S606 is equivalent to the aforementioned S1031. For the relevant description of S1031, please refer to the foregoing and will not be elaborated here.
[0288] S607, the order lines are continuous.
[0289] S608, the order lines are not continuous.
[0290] S609, obtain the next order line in the order line pool.
[0291] S610, check whether it is marked as not verifying continuity.
[0292] If so, execute S611; if not, execute S612.
[0293] S611, skip the continuity check.
[0294] After that, execute S615.
[0295] S612, check whether there is an order table with the smallest sequence number - 1 in the database sorting.
[0296] If so, execute S613; if not, execute S614.
[0297] S613, the order lines are continuous.
[0298] S614, the order lines are not continuous.
[0299] S615, continue to judge the next order line.
[0300] S616, check whether it is the last order line in the order line pool.
[0301] If so, end the process; if not, execute S609.
[0302] S609 - S616 is equivalent to the aforementioned S1041. For the relevant description of S1041, please refer to the above and will not be elaborated here.
[0303] The repeatability verification method provided by this application is as Figure 7 shown and includes:
[0304] S701: Sort the order lines in the new status in the database sorting order table from smallest to largest.
[0305] The order line is the aforementioned sub - order.
[0306] S702: Take out the corresponding number of order lines in ascending order according to the set number of the order line pool. If the quantity is insufficient, take out all.
[0307] The number of the order line pool is the aforementioned preset number. S701 - S702 is equivalent to S111 - S1021 in the aforementioned Figure 4 embodiment. For the relevant description of S111 - S1021, please refer to the above and will not be elaborated here.
[0308] S703: Obtain the order line with the smallest sequence number in the order line pool.
[0309] The order line pool is the set of target sub - orders. The order line with the smallest sequence number in the order line pool is the aforementioned first target sub - order.
[0310] S704: Check whether there are order lines with different order numbers and order line numbers in the order line pool.
[0311] If so, execute S705; if not, execute S706. S704 is equivalent to determining whether a sub - order with the same sequence as the first target sub - order and different order number and / or order line number from the first target sub - order is found in the target sub - orders. Among them, different order number and / or order line number from the first target sub - order means different order identification from the first target sub - order.
[0312] S705: The order line is repeated.
[0313] S706: The order line is not repeated.
[0314] S707: Continue to judge the next order line.
[0315] S708: Whether it is the last order line in the order line pool.
[0316] If so, execute S709; if not, execute S704. The last order line in the order line pool is the aforementioned third target sub - order.
[0317] S709, Check whether there are order lines with different order numbers and order line numbers in the database sorting order table.
[0318] If so, execute S710; if not, execute S711. 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 queried in the database. Among them, a different order number and / or order line number from the third target sub-order means that the order identifier is different from the third target sub-order.
[0319] S710, Order line is repeated.
[0320] S711, Order line is not repeated.
[0321] After S705, S710 - S711, the process ends. S703 - S711 is equivalent to the aforementioned S1051 - S1056, and the relevant descriptions of S1051 - S1056 can be referred to, which will not be elaborated here.
[0322] Corresponding to the aforementioned replenishment order generation method, the present application also provides a replenishment order generation device, as Figure 8 shown, the device includes:
[0323] A receiving module 801, configured to receive and store in the database the sequence, order identifier, part identifier, and part quantity of each sub-order sent by a preset terminal;
[0324] A target sub-order determination module 802, configured to determine the sub-orders in the first preset number of positions as target sub-orders when arranging each sub-order in sequence from first to last;
[0325] A first judgment module 803, configured to judge whether a sub-order with a sequence 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 each target sub-order;
[0326] A second judgment module 804, configured to judge, for each second target sub-order, whether a sub-order with a sequence one position before the second target sub-order is queried among each target sub-order; wherein, the second target sub-order is a sub-order with a sequence that is not the earliest among the target sub-orders;
[0327] A third judgment module 805, configured to judge whether each target sub-order is repeated according to the respective sequences and order identifiers of each target sub-order;
[0328] An inventory quantity determination module 806, configured to, if a sub-order that is one position before the first target sub-order is queried in a database, and for each second target sub-order, a sub-order that is one position before the second target sub-order is queried among the target sub-orders, and the target sub-orders are not repeated, 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 positions of the target sub-orders arranged from first to last;
[0329] A replenishment order generation module 807, configured to, for each target sub-order, 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;
[0330] A message sending module 808, configured to, if a sub-order that 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 that is one position before the second target sub-order is not queried among the target sub-orders, and / or, at least one target sub-order is repeated, then send a message indicating an error in each target sub-order to a preset terminal.
[0331] In a possible embodiment, determining whether the target sub-orders are repeated according to the positions of the respective target sub-orders and the order identifiers includes:
[0332] Determining whether a first same-position sub-order with the same position as the third target sub-order is queried in the database; wherein, the third target sub-order is the sub-order with the last position among the target sub-orders;
[0333] If a first same-position sub-order with the same position as the third target sub-order is queried in the database, then for each first same-position sub-order, determining whether the order identifier of the first same-position sub-order is the same as the order identifier of the third target sub-order;
[0334] For each fourth target sub-order, determining whether a second same-position sub-order with the same position as the fourth target sub-order is queried among the target sub-orders; wherein, the fourth target sub-order is a sub-order among the target sub-orders whose position is not the last;
[0335] For each fourth target sub-order, if a second same-position sub-order with the same position as the fourth target sub-order is queried among the target sub-orders, then for each second same-position sub-order, determining whether the order identifier of the second same-position sub-order is the same as the order identifier of the fourth target sub-order;
[0336] If the order identifiers of the first same-position 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 the second same-position sub-orders are the same as the order identifier of the fourth target sub-order, then determine that the target sub-orders are not repeated;
[0337] 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, then it is determined that at least one target sub-order is repeated.
[0338] 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 apparatus further includes:
[0339] 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 the non-verification sub-order;
[0340] A non-verification continuity flag setting module, configured to set a non-verification continuity flag for the non-verification sub-order;
[0341] Determining whether a sub-order whose sequence number is one before the first target sub-order is queried in the database includes:
[0342] If the first target sub-order is not set with a non-verification continuity flag, then determine whether a sub-order whose sequence number is one before the first target sub-order is queried in the database;
[0343] Determining whether a sub-order whose sequence number is one before the second target sub-order is queried among the target sub-orders includes:
[0344] If the second target sub-order is not set with a non-verification continuity flag, then determine whether a sub-order whose sequence number is one before the second target sub-order is queried among the target sub-orders.
[0345] In a possible embodiment, the order identifier includes: an order number and an order line number, where 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.
[0346] 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;
[0347] Determining the inventory quantity of the part represented by the part identifier of the target sub-order includes:
[0348] Determining the storage quantity of the part represented by the part identifier of the target sub-order;
[0349] 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 of new;
[0350] Determine the second quantity of the part represented by the part identifier of the target sub-order among the replenishment orders with the order status being executed;
[0351] Take the sum of the stored 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;
[0352] Generate a replenishment order for the part identifier of the target sub-order, including:
[0353] Generate a replenishment order with the part identifier being the part identifier of the target sub-order, and set the order status of the replenishment order to new;
[0354] 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;
[0355] 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.
[0356] In a possible embodiment, generating a replenishment order with the part identifier being the part identifier of the target sub-order includes:
[0357] Generate 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.
[0358] The embodiment of the present application also provides an electronic device, as Figure 9 shown, including:
[0359] A memory 901 for storing a computer program;
[0360] A processor 902, when executing the program stored on the memory 901, implements the following steps:
[0361] Receive and store in the database the respective rankings, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal;
[0362] When arranging each sub-order in order from first to last according to their respective rankings, determine the sub-orders in the first preset number of positions as target sub-orders;
[0363] Determine whether a sub-order with a ranking 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 ranking among all target sub-orders;
[0364] For each second target sub-order, determine whether a sub-order with a ranking one position before the second target sub-order is queried among all target sub-orders; wherein, the second target sub-order is a target sub-order whose ranking is not the earliest among the target sub-orders;
[0365] Judge whether each target sub - order is repeated according to the respective ranks of each target sub - order and the order identifier.
[0366] 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 repeated, then for each target sub - order, determine the inventory quantity of the parts represented by the part identifier of the target sub - order in the order from the earliest to the latest rank.
[0367] For each target sub - order, if the inventory quantity is less than the quantity of parts of the target sub - order, then generate a replenishment order for the part identifier of the target sub - order.
[0368] 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 repeated, then send a message indicating an error in each target sub - order to a preset terminal.
[0369] And the above - mentioned electronic device may further include a communication bus and / or a communication interface, and the processor 902, the communication interface, and the memory 901 complete communication with each other through the communication bus.
[0370] The communication bus mentioned in the above - mentioned electronic device may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. This communication bus can be divided into an address bus, a data bus, a control bus, etc. For the sake of representation, only a thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.
[0371] The communication interface is used for communication between the above - mentioned electronic device and other devices.
[0372] The memory may include a Random Access Memory (RAM), and may also include a Non - Volatile Memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located far from the aforementioned processor.
[0373] The above-mentioned processor may be a general-purpose processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc.; it may 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.
[0374] In another embodiment provided by the present application, there is also provided a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the steps of any of the above replenishment order generation methods are implemented.
[0375] In another embodiment provided by the present application, there is also provided a computer program product containing instructions, which when run on a computer, causes the computer to execute any of the replenishment order generation methods in the above embodiments.
[0376] 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 processes or functions described in the embodiments of the present application are generated in whole or in part. The computer may be a general-purpose computer, a dedicated computer, a computer network, or other programmable devices. 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 one website, computer, server, or data center to another website, computer, server, or data center by wire (such as coaxial cable, optical fiber, Digital Subscriber Line (DSL)) or wireless (such as infrared, wireless, microwave, etc.). The computer-readable storage medium may be any available medium that the computer can access, or a data storage device such as a server or data center that includes one or more integrated available media. The available medium may be a magnetic medium (for example, a floppy disk, a hard disk, a magnetic tape), an optical medium (for example, a DVD), or a Solid State Disk (SSD), etc.
[0377] It should be noted that in this text, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the terms "comprising", "including" or any other variant thereof are intended to cover non-exclusive inclusion, such that a process, method, article or device comprising a series of elements not only includes those elements, but also includes other elements not expressly listed, or elements inherent to such process, method, article or device. Without further limitation, an element defined by the statement "comprising an..." does not exclude the presence of additional identical elements in the process, method, article or device comprising the element.
[0378] Each embodiment in this specification is described in a related manner. For the same or similar parts among the embodiments, reference can be made to each other. 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 description of the method embodiments.
[0379] 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 all included in the protection scope of the present application.
Claims
1. A method for generating a replenishment order, characterized in that, The method includes: Receiving and storing in a database the respective ranks, order identifiers, part identifiers, and part quantities of each sub-order sent by a preset terminal; When arranging each of the sub-orders in order from the earliest to the latest according to their respective ranks, the sub-orders in the first preset number of positions are determined as target sub-orders; Judging whether a sub-order whose rank 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 rank among all the target sub-orders; For each second target sub-order, judging whether a sub-order whose rank 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 rank is not the earliest; Judging whether each of the target sub-orders is repeated according to the respective ranks and order identifiers of each of the target sub-orders; If a sub-order whose rank 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 rank is one position before the second target sub-order is queried among all the target sub-orders, and each of the target sub-orders is not repeated, then for each of the target sub-orders, according to the order of arranging from the earliest to the latest according to their respective ranks, determine the inventory quantity of the parts represented by the part identifiers of the target sub-orders; 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; If a sub-order whose rank 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 rank is one position before the second target sub-order is not queried among all the target sub-orders, and / or, at least one of the target sub-orders is repeated, then send a message indicating that each of the target sub-orders is in error to the preset terminal.
2. The method according to claim 1, wherein The judging whether each of the target sub-orders is repeated according to the respective ranks and order identifiers of each of the target sub-orders includes: Judging whether a first same-rank sub-order whose rank is the same as that of the third target sub-order is queried in the database; wherein, the third target sub-order is the sub-order with the latest rank among all the target sub-orders; If a first same-rank sub-order whose rank is the same as that of the third target sub-order is queried in the database, then for each of the first same-rank sub-orders, judge whether the order identifier of the first same-rank sub-order is the same as the order identifier of the third target sub-order; For each fourth target sub-order, judge whether a second same-rank sub-order whose rank is the same as that of the fourth target sub-order is queried among the target sub-orders; wherein, the fourth target sub-order is a sub-order among the target sub-orders whose rank is not the latest; 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-order, then for each of the second sub-orders with the same sequence, determine 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; If the order identifiers of each of the first sub-orders with the same sequence 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 each of the second sub-orders with the same sequence are the same as the order identifier of the fourth target sub-order, then determine that each of the target sub-orders is not repeated; If the order identifier of at least one of the first sub-orders with the same sequence 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 sequence is not the same as the order identifier of the fourth target sub-order, then determine that at least one of the target sub-orders is repeated.
3. The method according to claim 1, wherein After the step of receiving and storing in the database the respective sequences, order identifiers, part identifiers, and part quantities of each sub-order sent by the preset terminal, the method further includes: In response to a non-verification instruction, determine the sub-order indicated by the non-verification instruction as the non-verification sub-order; Set a non-verification continuity flag for the non-verification sub-order; The determination of whether a sub-order with a sequence one before the first target sub-order is queried in the database includes: If the first target sub-order is not set with the non-verification continuity flag, then determine whether a sub-order with a sequence one before the first target sub-order is queried in the database; The determination of whether a sub-order with a sequence one before the second target sub-order is queried in each of the target sub-orders includes: If the second target sub-order is not set with the non-verification continuity flag, then determine whether a sub-order with a sequence one before the second target sub-order is queried in each of the target sub-orders.
4. The method according to claim 1, wherein The order identifier includes: an order number and an order line number, where 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, wherein The database also stores the respective part identifiers and order statuses of each of the replenishment orders; The order status of the replenishment order includes: new, in execution, and completed; The determination of the inventory quantity of the part represented by the part identifier of the target sub-order includes: Determine the storage quantity of the part represented by the part identifier of the target sub-order; Determine the first quantity of the part represented by the part identifier of the target sub-order in the replenishment order with the order status of new; Determine the second quantity of the part represented by the part identifier of the target sub-order in the replenishment order with the order status of in execution; 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; The generation of a replenishment order for the part identifier of the target sub-order includes: Generate a replenishment order with the part identifier for the target sub - order, and set the order status of the replenishment order to new; 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; 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.
6. The method according to claim 5, wherein The generating a replenishment order with the part identifier for the target sub - order includes: Generate a replenishment order with the part identifier for the target sub - order, and the replenishment quantity is the difference between the inventory quantity and the part quantity of the target sub - order.
7. A replenishment order generation device, characterized in that, The device includes: A receiving module, configured 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; A target sub - order determination module, configured to determine the sub - orders in the first preset number of positions as target sub - orders when arranging the sub - orders in descending order of their respective priorities; A first judgment module, configured to judge whether a sub - order with a priority 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; A second judgment module, configured to, for each second target sub - order, judge whether a sub - order with a priority one position before the second target sub - order is queried among all the target sub - orders; wherein, the second target sub - order is a non - earliest - priority sub - order among the target sub - orders; A third judgment module, configured to judge whether the target sub - orders are repeated according to the respective priorities and order identifiers of the target sub - orders; An inventory quantity determination module, configured to, if a sub - order with a priority one position before the first target sub - order is queried 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 queried among all the target sub - orders, and the target sub - orders are not repeated, then determine the inventory quantity of the parts represented by the part identifiers of the target sub - orders in the order of arranging the target sub - orders in descending order of their respective priorities; A replenishment order generation module, configured to, for each target sub - order, if the inventory quantity is less than the part quantity of the target sub - order, generate a replenishment order for the part identifier of the target sub - order; A message sending module, configured to, if a sub - order with a priority 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 with a priority one position before the second target sub - order is not queried among all the target sub - orders, and / or, at least one of the target sub - orders is repeated, send a message indicating an error in the target sub - orders to the preset terminal.
8. The device according to claim 7, characterized in that, The judging whether the target sub - orders are repeated according to the respective priorities and order identifiers of the target sub - orders includes: Determine whether a first same-position sub-order with the same position as the third target sub-order is queried in the database; wherein, the third target sub-order is the sub-order with the last position among all the target sub-orders; If a first same-position sub-order with the same position as the third target sub-order is queried in the database, then for each of the first same-position sub-orders, determine whether the order identifier of the first same-position sub-order is the same as the order identifier of the third target sub-order; For each fourth target sub-order, determine whether a second same-position sub-order with the same position as the fourth target sub-order is queried in the target sub-orders; wherein, the fourth target sub-order is a sub-order among all the target sub-orders whose position is not the last; For each of the fourth target sub-orders, if a second same-position sub-order with the same position as the fourth target sub-order is queried in the target sub-orders, then for each of the second same-position sub-orders, determine whether the order identifier of the second same-position sub-order is the same as the order identifier of the fourth target sub-order; If the order identifiers of all the first same-position sub-orders 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 same-position sub-orders are the same as the order identifier of the fourth target sub-order, then determine that all the target sub-orders are not repeated; If the order identifier of at least one of the first same-position 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-position sub-orders is not the same as the order identifier of the fourth target sub-order, then determine that at least one of the target sub-orders is repeated; and / or, After the step of receiving and storing in the database the position, order identifier, part identifier, and part quantity of each sub-order sent by the preset terminal, the device further includes: An un-verification sub-order determination module, configured to determine, in response to an un-verification instruction, the sub-order indicated by the un-verification instruction as an un-verification sub-order; An un-verification continuity flag setting module, configured to set an un-verification continuity flag for the un-verification sub-order; The determination of whether a sub-order with a position one before the first target sub-order is queried in the database includes: If the first target sub-order is not set with the un-verification continuity flag, then determine whether a sub-order with a position one before the first target sub-order is queried in the database; The determination of whether a sub-order with a position one before the second target sub-order is queried in each of the target sub-orders includes: If the second target sub-order is not set with the un-verification continuity flag, then determine whether a sub-order with a position one before the second target sub-order is queried in each of the target sub-orders; and / or, 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; and / or, The database also stores the part identifier and order status of each of the replenishment orders; the order status of the replenishment order includes: newly created, in execution, and completed; The determining the inventory quantity of the part represented by the part identifier of the target sub-order includes: Determining the storage quantity of the part represented by the part identifier of the target sub-order; 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 of newly created; 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 of in execution; 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; The generating a replenishment order for the part identifier of the target sub-order includes: 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; In response to receiving a message indicating that the part represented by the part identifier of the replenishment order is shelved, modifying the order status of the replenishment order to in execution; 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; and / or The generating a replenishment order with the part identifier being the part identifier of the target sub-order includes: 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.
9. An electronic device, characterized in that, including: A memory for storing a computer program; A processor for implementing the method according to any one of claims 1-6 when executing the program stored on the memory.
10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program, and the computer program implements the method according to any one of claims 1-6 when executed by a processor.
Citation Information
Patent Citations
Replenishment task generation method and device, equipment, medium and program product
CN118211905A
Order whole-process management method and system, computer device, and storage medium
WO2025001397A1