Drug addressing and positioning method based on WMS system

Abstract

The invention belongs to the technical field of medicine addressing and positioning, and particularly relates to a medicine addressing and positioning method based on a WMS system. The method comprises the steps that drug request information is acquired, the drug request information comprises drug shelving request information and drug picking request information, the request information comprises codes and the number of drugs to be addressed, and the drug codes comprise drug brands, drug categories and drug batch number information; a shelf area code corresponding to the medicine code is determined through a preset shelf list, the preset shelf list comprises the medicine code and a shelf area code mapped with the medicine code, and the shelf area code comprises preset shelf area information; and based on the drug request information, judging whether the drug code of the to-be-addressed drug has a corresponding shelf area code, and addressing the position of the to-be-addressed drug based on the shelf area code corresponding to the obtained drug code. According to the invention, the warehouse management efficiency is improved, and the risk of human errors is reduced.

Description

Technical Field

[0001] The present invention belongs to the technical field of medicine addressing and positioning, and in particular relates to a medicine addressing and positioning method based on a WMS (Warehouse Management System) system. Background Art

[0002] In the pharmaceutical warehousing industry, the daily process of putting medicines on the shelves and picking goods in the warehouses of enterprises involves putting medicines and equipment from different suppliers on the shelves and picking goods according to the types, brands, batches, etc. of medicines and equipment. Usually, warehouse personnel put medicines on the shelves and pick goods through experience, memory, Excel, etc., put medicines and equipment of different types, brands, batches, etc. on the corresponding shelves, and find medicines that meet the type, brand, and batch from the shelves.

[0003] However, when pharmaceutical companies had not yet adopted informatization or had a low level of informatization, the records of these drugs were basically recorded and identified manually offline, or warehouse staff were added and the warehouse staff relied on their familiarity with the warehouse layout to find the approximate location. Within the approximate range, they would then specifically search for the exact location. This resulted in a waste of time for shelving and picking, low efficiency, and proneness to errors. In addition, new employees needed a long time to familiarize themselves with the warehouse layout, and even after becoming familiar with it, the above problems would still exist when shelving and picking.

[0004] The reason for this problem is that the warehouses of pharmaceutical retail companies are generally large, with an area of ​​several thousand square meters or even tens of thousands of square meters. There are many categories of drugs, many brands, and many batches. The number of drugs combined together is huge. The warehousing, outbound delivery, and returns of drugs all involve the shelving and picking operations of drugs. How to quickly and accurately locate the specific location of specific drugs on the warehouse shelves for shelving and picking has become a huge challenge faced by warehouse staff in their daily work. Therefore, how to solve the problem of how to quickly and accurately locate the specific location of specific drugs on warehouse shelves for drug shelving and picking in the face of multiple drug categories, brands, and batches has become an urgent problem to be solved. Summary of the invention

[0005] As a core component of modern logistics technology, WMS is applied in the field of pharmaceutical storage and provides an effective technical means to solve the above problems. The present invention proposes a drug addressing and positioning method based on the WMS system.

[0006] The technical solution of the present invention to solve the above technical problems is as follows: The present invention provides a method for addressing and locating medicines based on a WMS system, comprising the following steps: Obtaining drug request information, obtaining drug request information, the drug request information includes drug shelf request information and drug picking request information, the drug shelf request information and drug picking request information both include the code and quantity of the drug to be addressed, the drug code includes drug brand, drug category and drug batch number information; the drug batch number information includes drug batch and date; Determine the shelf area code corresponding to the drug code using a preset shelf list, wherein the preset shelf list includes the drug code and the shelf area code mapped to the drug code, and the shelf area code includes preset shelf area information; Based on the drug request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, and based on the acquired drug code corresponding to the shelf area code, address the location of the drug to be addressed.

[0007] Furthermore, if it is a drug picking request information, determining whether the drug code of the drug to be addressed has a corresponding shelf area code includes: If the drug code of the drug to be addressed has a corresponding shelf area code, the inventory quantity of the drug to be addressed is obtained, and it is determined whether the obtained inventory quantity of the drug to be addressed meets the quantity of drugs required for addressing; If the stock quantity of the medicine to be addressed is greater than or equal to the quantity of medicine required for addressing, the shelf area code is returned; If the acquired inventory quantity of the drugs to be addressed is less than the quantity of the drugs to be addressed, check whether there are drugs with the same drug brand, same drug category and different batch numbers in the preset shelf list; if there are drugs with the same drug brand, same drug category and different batch numbers, determine the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers; if the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers is not empty, use the shelf area code of the latest date as the surveillance post position to determine whether the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers meets the quantity of drugs to be addressed; if the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers is greater than or equal to the quantity of drugs to be addressed, return the shelf area code.

[0008] Furthermore, if it is a drug picking request information, it is determined whether there is a corresponding shelf area code for the drug code of the drug to be addressed, and it also includes: if there is no corresponding shelf area code for the drug code of the drug to be addressed, returning information that the drug does not exist.

[0009] Furthermore, if it is a drug shelf request message, it is determined whether the drug code of the drug to be addressed has a corresponding shelf area code, including: If the drug code of the drug to be addressed has a corresponding shelf area code, the shelf area code with the latest update date is used as the surveillance post position to obtain the empty shelf position of the drug to be addressed, and determine whether the obtained empty shelf position of the drug to be addressed meets the quantity of the drug to be addressed; If the empty shelves of the drugs to be addressed are greater than or equal to the quantity of drugs required for addressing, the shelf area code is returned; If the number of empty storage locations for drugs to be addressed is less than the number of drugs to be addressed, check whether drugs of the same drug brand, same drug category and different batch numbers exist in the preset shelf list; if drugs of the same drug brand, same drug category and different batch numbers exist, determine whether there are empty storage locations for drugs of the same drug brand, same drug category and different batch numbers; if there are empty storage locations for drugs of the same drug brand, same drug category and different batch numbers, use it as a surveillance post location to determine whether the empty storage locations for drugs of the same drug brand, same drug category and different batch numbers meet the number of drugs required to be addressed; if the number of empty storage locations for drugs of the same drug brand, same drug category and different batch numbers is greater than or equal to the number of drugs required to be addressed, return the shelf area code.

[0010] Furthermore, if it is a drug shelf request message, it is determined whether there is a corresponding shelf area code for the drug code to be addressed, and it also includes: if it is a drug shelf request message, and there is no corresponding shelf area code for the drug code to be addressed, adding a drug code, and assigning a shelf area code to the added drug code.

[0011] Furthermore, if it is a drug shelf request message, and the drug code of the drug to be addressed does not have a corresponding shelf area code, a drug code is added, and a shelf area code is allocated to the added drug code, including: Confirm whether the drug code is correct and check whether the drug code information exists; If the drug code is correct but there is no corresponding shelf area code, determine whether it is a new drug in the warehouse; Check the remaining space on all shelves and assess whether new shelves need to be added or the existing shelf layout needs to be adjusted to accommodate new drugs; Re-plan the cargo location of new drugs according to the properties of the drugs and the actual situation of the shelves; assign a unique shelf area code to the newly planned cargo location, wherein the shelf area code includes a shelf number, a layer number and a position number; Update the shelf area code information of the newly planned drugs; modify the shelf area code in the warehousing request message; place the drugs on the newly allocated storage location according to the updated warehousing request.

[0012] Furthermore, after returning the shelf area code, it also includes: determining an alternative route with a preset drug entrance as the starting point and a preset checkout position as the end point, the alternative route including the distance from the starting point to the shelf to be selected and the distance from the shelf to be selected to the end point; calculating the total time of the alternative route, the total time being the sum of the time of each section of the alternative route; screening and determining the alternative route with the smallest total time value from all alternative routes as the addressing route; and sending the addressing route to the mobile terminal.

[0013] Furthermore, after the step of determining the shelf position of the drug to be addressed according to the drug code, the step also includes: sending the addressing route to the mobile terminal, specifically: sending the addressing route to the mobile terminal, the addressing route includes a starting point, the shelf positions to be reached in sequence, shelf area information associated with the shelf positions, and an end point.

[0014] Compared with the prior art, the present invention has the following technical effects: The present invention realizes the rapid addressing and positioning of drugs in the warehouse through digital and automated means. It not only improves the efficiency of warehouse management, but also reduces the risk of human error, providing strong support for drug management and logistics distribution of pharmaceutical companies. At the same time, the method also has certain scalability and flexibility, and can be customized and optimized according to the specific needs of the enterprise. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] In order to more clearly illustrate the technical solutions and advantages in the embodiments of the present invention or the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0016] Figure 1 It is a schematic diagram of the method flow of the present invention. DETAILED DESCRIPTION

[0017] In order to further explain the technical means and effects taken by the present invention to achieve the predetermined invention purpose, the specific implementation methods, structures, features and effects of the technical solutions proposed by the present invention are described in detail below in conjunction with the accompanying drawings and preferred embodiments. The specific features, structures or characteristics in one or more embodiments may be combined in any suitable form. Unless otherwise defined, all technical and scientific terms used in the present invention have the same meaning as those commonly understood by technicians in the technical field of the present invention.

[0018] WMS system, that is, warehouse management system, is a software system that combines modern logistics management concepts and technologies. Figure 1 , provides a drug addressing and positioning method based on a WMS system, comprising the following steps: Step 100: Obtaining drug request information, obtaining drug request information, the drug request information includes drug shelf request information and drug picking request information, the drug shelf request information and drug picking request information both include the code and quantity of the drug to be addressed, the drug code includes drug brand, drug category and drug batch number information; the drug batch number information includes drug batch and date; Step 200: Determine the shelf area code corresponding to the drug code using a preset shelf list, wherein the preset shelf list includes the drug code and the shelf area code mapped to the drug code, and the shelf area code includes preset shelf area information; Step 300: Based on the drug request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, and address the location of the drug to be addressed based on the acquired drug code corresponding to the shelf area code.

[0019] The following is a detailed explanation of each of the above steps: In this embodiment, step 100: obtain drug request information, obtain drug request information, the drug request information includes drug shelving request information and drug picking request information, the drug shelving request information and drug picking request information both include the code and quantity of the drug to be addressed, and the drug code includes drug brand, drug category and drug batch number information.

[0020] Obtaining drug request information includes establishing a communication connection with a mobile terminal, obtaining drug request information from the mobile terminal, the drug request information including drug shelf request information and drug picking request information, the drug shelf request information and drug picking request information both including the code and quantity of the drug to be addressed, the drug code including drug brand, drug category and drug batch number information. The above information can be stored in a database.

[0021] A drug shelf request refers to drugs being sent from suppliers or manufacturers to warehouses or pharmacies. The request can be received directly from suppliers through the electronic order system, or pharmacy or warehouse managers can manually enter or scan the information on the entry document. A drug picking request refers to drugs being issued from warehouses or pharmacies to patients or other departments of medical institutions. It can be a doctor or nurse submitting a request for outbound delivery through the electronic prescription system, and the pharmacy manager enters the outbound delivery information based on the paper prescription or verbal instructions.

[0022] The methods of drug coding may include: preliminarily classifying drugs to ensure that drugs of the same brand are classified into one category; based on brand classification, further subdividing the drugs into specific categories according to their functions, uses or characteristics; assigning a unique drug code to each drug, which may include drug brand, drug category and drug batch number information for easy management and query.

[0023] In this embodiment, step 200: determine the shelf area code corresponding to the drug code using a preset shelf list, the preset shelf list includes the drug code and the shelf area code mapped to the drug code, and the shelf area code includes preset shelf area information.

[0024] Among them, the preset listing list includes: Create database tables, including supplier file table, drug file table, document type data table, and shelf data table; The supplier profile table includes supplier code, supplier attributes, and supplier basic information. The supplier basic information includes contact information, address, remarks, etc. The supplier attributes include supplier name and supplier type. The drug archive table includes drug code, drug attributes, and basic drug information. The drug code includes drug brand, drug category, and drug batch number information. The drug attributes include size, weight, and fragility. The basic drug information includes expiration date, inventory, sales price, etc. The document type data table includes document attributes and document basic information. The document basic information includes inbound order, outbound order, transfer order, etc. The document attributes include creation time, modification time, etc. The shelf data table includes basic information such as warehouse shelf code, the basic information includes warehouse shelf code, number of positions per layer, shelf type, size, load-bearing capacity, remarks, etc. The warehouse shelf code includes aisle, shelf number, layer number and position number; Plan shelf layout and determine shelf type and size based on sales and drug properties; Allocate drugs to different shelf areas according to their brand, category and sales volume; Follow the "golden display line" principle and place hot-selling drugs or high-profit drugs in prominent locations; Each shelf location is assigned a unique warehouse shelf code, and the shelf area code includes preset shelf area information, including aisle, shelf number, layer number and position number; wherein the aisle is the main path connecting different areas in the warehouse to ensure smooth movement of personnel or other logistics equipment; the shelf number is a code or number used to uniquely identify each shelf in the warehouse or store; the layer number refers to the number of different storage levels on the shelf; the position number is a number that further subdivides the storage location on the same shelf level; Determine the mapping relationship between drug codes and warehouse shelf codes to confirm the preset shelf list.

[0025] Step 300: Based on the drug request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, and address the location of the drug to be addressed based on the acquired drug code corresponding to the shelf area code.

[0026] As an example, this step may include: Step 310: If it is a drug picking request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code; if the drug code of the drug to be addressed has a corresponding shelf area code, execute step 3101; if the drug code of the drug to be addressed does not have a corresponding shelf area code, execute step 3102: Step 3101: If it is a drug picking request information, the drug code of the drug to be addressed has a corresponding shelf area code, the inventory quantity of the drug to be addressed is obtained, and it is determined whether the obtained inventory quantity of the drug to be addressed meets the required quantity of the drug to be addressed; If the stock quantity of the medicine to be addressed is greater than or equal to the quantity of medicine required for addressing, the shelf area code is returned; If the acquired inventory quantity of the to-be-addressed drugs is less than the quantity of the to-be-addressed drugs, check whether there are drugs of the same drug brand, same drug category and different batch numbers in the preset shelf list; if there are drugs of the same drug brand, same drug category and different batch numbers, determine the inventory quantity of the drugs of the same drug brand, same drug category and different batch numbers; if the inventory quantity of the drugs of the same drug brand, same drug category and different batch numbers is not empty, use the shelf area code of the latest date as the surveillance post position to determine whether the inventory quantity of the drugs of the same drug brand, same drug category and different batch numbers meets the quantity of drugs required for addressing; if the inventory quantity of the drugs of the same drug brand, same drug category and different batch numbers is greater than or equal to the quantity of drugs required for addressing, return the shelf area code; After returning the shelf area code, it also includes: determining an alternative route with a preset medicine entrance as the starting point and a preset checkout position as the end point, the alternative route including the distance from the starting point to the shelf to be selected and the distance from the shelf to be selected to the end point; calculating the total time of the alternative route, the total time being the sum of the time of each section of the alternative route; screening and determining the alternative route with the smallest total time value from all alternative routes as the addressing route; and sending the addressing route to the mobile terminal.

[0027] After the step of determining the shelf position of the drug to be addressed according to the drug code, the step also includes: sending the addressing route to the mobile terminal, specifically: sending the addressing route to the mobile terminal, the addressing route includes a starting point, the shelf positions to be reached in sequence, shelf area information associated with the shelf positions, and an end point.

[0028] Step 3102: If it is a drug picking request information, and the drug code of the drug to be addressed does not have a corresponding shelf area code, a non-existent information is returned.

[0029] Step 320: If it is a drug shelf request message, determine whether the drug code of the drug to be addressed has a corresponding shelf area code; if the drug code of the drug to be addressed has a corresponding shelf area code, execute step 3201; if the drug code of the drug to be addressed does not have a corresponding shelf area code, execute step 3202: Step 3201: If it is a drug shelf request message, and the drug code of the drug to be addressed has a corresponding shelf area code, the shelf area code with the latest update date is used as the surveillance post position, and the empty positions of the drug to be addressed are obtained, and it is determined whether the obtained empty positions of the drug to be addressed meet the quantity of the drug to be addressed; If the number of empty shelves of the drugs to be addressed is greater than or equal to the number of drugs required to be addressed, the shelf area code is returned. Specifically, the shelf area code with the latest update date is used as the surveillance post shelf to determine whether there are empty shelves on the same shelf and the same floor. If there are empty shelves on the same floor, the nearest shelf other than the adjacent shelves is selected; if there are no empty shelves on the same floor, the nearest empty shelves are found on the same shelf; if no empty shelves are found on the same shelf, the nearest empty shelves are found in the same aisle.

[0030] If the number of empty storage locations of the drugs to be addressed is less than the number of drugs to be addressed, check whether there are drugs of the same drug brand, same drug category and different batch numbers in the preset shelf list; if there are drugs of the same drug brand, same drug category and different batch numbers, determine whether there are empty storage locations of drugs of the same drug brand, same drug category and different batch numbers; if there are empty storage locations of drugs of the same drug brand, same drug category and different batch numbers, use the shelf area code with the latest update date as the surveillance post location to determine whether the empty storage locations of drugs of the same drug brand, same drug category and different batch numbers meet the number of drugs required to be addressed; if the number of empty storage locations of drugs of the same drug brand, same drug category and different batch numbers is greater than or equal to the number of drugs required to be addressed, return the shelf area code.

[0031] Specifically, if the empty storage space of the drugs to be addressed is less than the number of drugs to be addressed, the addressing method is: Based on the selected surveillance post storage location, traverse the current layer of the current shelf to determine whether there are any empty storage locations on the same layer of the current shelf. If there are empty storage locations on the same layer, select the nearest storage location other than the adjacent storage locations; if there are no empty storage locations on the same layer, find the nearest empty storage location on the same shelf on a different layer; if no empty storage locations are found on the same shelf, find the nearest empty storage location in the same aisle; if there are no empty storage locations in the same aisle, find the latest historical storage location number for the same drug brand, the same drug category, and the same batch number, and the storage location is a valid storage location, that is, an empty storage location. If it exists, return it directly; it is worth mentioning that the reason why the nearest storage location other than the adjacent storage locations is preferred is to prevent a series of problems such as incorrect delivery batch numbers when different batches of the same product are shipped out, which may lead to inaccurate inventory.

[0032] If no empty storage location is found, then search for the latest historical storage location number of the same drug brand, same drug category, and same batch number, and the storage location number is a valid storage location and is not occupied, and return the result; otherwise, search for the latest historical storage location number of the same drug brand, same drug category, but different batch numbers. If such a storage location is found, the nearest storage location on the same floor excluding the adjacent storage location of the found storage location number, if there is no empty storage location on the same floor, then search for the nearest storage location on the same shelf. If there is no empty storage location on the same shelf, then search for the nearest storage location in the same aisle.

[0033] After the shelf area code is returned, the same drug to be addressed has two or more shelf area codes to be selected for selection, and also includes: determining an alternative route with a preset drug entrance as the starting point and a preset checkout position as the end point, the alternative route includes the distance from the starting point to the shelf to be selected, and the distance from the shelf to be selected to the end point; calculating the total time of the alternative route, the total time is the sum of the time of each section of the alternative route; selecting and determining the alternative route with the smallest total time value from all alternative routes as the addressing route; and sending the addressing route to the mobile terminal.

[0034] After the step of determining the shelf position of the drug to be addressed according to the drug code, the step also includes: sending the addressing route to the mobile terminal, specifically: sending the addressing route to the mobile terminal, the addressing route includes a starting point, the shelf positions to be reached in sequence, shelf area information associated with the shelf positions, and an end point.

[0035] Step 3202: If it is a drug shelf request message, and the drug code of the drug to be addressed does not have a corresponding shelf area code, a drug code is added and a shelf area code is assigned to the added drug code.

[0036] Confirm whether the drug code is correct and check whether the drug code information exists in the database; if the drug code is correct but the corresponding shelf area code does not exist, confirm whether it is a newly entered drug; check the remaining space on all shelves, especially the shelf areas where the new drug may be suitable; evaluate whether it is necessary to add new shelves or adjust the existing shelf layout to accommodate the new drug; re-plan the storage location of the new drug according to the properties of the drug and the actual situation of the warehouse; assign a unique shelf area code to the newly planned storage location, including the shelf number, layer number and position number; update the shelf area code information of the drug in the database; modify the shelf area code in the warehousing request message to reflect the newly allocated storage location information; place the drug on the newly allocated storage location according to the updated warehousing request.

[0037] The following is a further detailed description of the drug picking request processing process through a specific implementation method: Assume the coordinates of the channel, shelf number, layer number and position number in the shelf area code are (r, z, x, y); Get the picking drug code, among the drug codes to be picked, itemid (drug brand, drug category) = 100007, batchNo (batch) = 20131108; Based on the code of the drug to be picked, query the preset shelf list t_item_stall to obtain all the empty shelves where the drugs to be picked are located. Specifically, first find out which shelves have shelves, and then find out which shelves do not have drugs to be picked. If an empty cargo location satllId is found, the medicine to be picked is stored in that location; select stallId from t_item_stall; where itemid='100007' and batchNo='20131108'; Alternatively, if there is an empty storage location, find the code of the drug to be picked up with the latest update date, use the shelf area code of the drug to be picked up with the latest update date as the surveillance location, and calculate the position between the coordinates of the surveillance location and the coordinates of the empty storage location through Euclidean distance; for example, the coordinates of the surveillance location: (x, y) = (3, 2); the coordinates of the empty storage location: (1, 1) (1, 4) (2, 4) (3, 5) (4, 4) (5, 1) (5, 2) (5, 4) (5, 5); select the empty storage location closest to the shelf area code with the latest update date, and store the drug in this location; Table 1 Euclidean distance between the coordinates of the surveillance post cargo position and the coordinates of the empty cargo position

[0038] If no empty stall is found in the preset shelf list t_item_stall, query itemid (drug brand, drug category) = 100007: select stallId from t_item_stall; where itemid='100007'; Case 1: If the result is 010101101, then (r, z, x, y) = (1, 1, 1, 1) is used as the monitoring post coordinates; Specifically, find out all the empty storage locations in warehouse area 1, a total of 2469 empty storage locations. First find out all the coordinates of (1,1,1,y), a total of 7 sets of data, that is, there are 7 empty storage locations on the 1st floor of shelf 1 in channel 1; If there is no empty shelf on the same floor, then find out all the coordinates of (1,1,x,y), a total of 36 sets of data, that is, there are 36 empty shelves on shelf 1 in channel 1. Use Euclidean distance to calculate the distance from the monitoring post coordinate (1,1) to the 36 empty shelves. If there are no empty locations on the same shelf, then find out all the coordinates of (1,z,x,y), a total of 2220 sets of data, that is, there are 2220 empty locations on channel 1. Use the Euclidean distance to calculate the distance d from the monitoring post coordinate (1,1,1) to all the empty locations. Table 2 Distances from the monitoring post coordinates to all empty cargo spaces

[0039] Similarly, if there is no empty cargo space in aisle 1, the best empty cargo space in the entire cargo area is calculated; The second case: If there are multiple results, such as 010101101 and 110101101, the method of the first case is used to obtain the optimal empty cargo location for each of the two cargo areas.

[0040] For the selection of the two optimal empty cargo spaces, that is, the same drug to be addressed has two or more shelf area codes to be selected for selection, it also includes: determining an alternative route with a preset drug entrance as the starting point and a preset checkout position as the end point, the alternative route includes the distance from the starting point to the shelf to be selected, and the distance from the shelf to be selected to the end point; calculating the total time of the alternative route, the total time is the sum of the time of each section of the alternative route; selecting and determining the alternative route with the smallest total time value from all alternative routes as the addressing route; and sending the addressing route to the mobile terminal.

[0041] The third case: If no result is found, search for historical stalls in the stall adjustment table t_adjustment_stalls and check whether all historical stalls have vacant stalls at present; select s.stallId; from t_adjustment_stalls s; where s.itemId='100007'; and not EXISTS(select stallId from t_item_stall i where i.stallId=s.stallId); If there is one empty storage location, store the drug directly in that storage location. If there are multiple empty storage locations, such as drug No. 142393 has been stored in two storage locations, 01-01-02-3-02 (1,1,2,3,2) and 01-03-03-3-05 (1,3,3,3,5), select the storage location with the latest update date. If none of the above three situations are found, it means that the drug has never appeared in the warehouse and is a new drug. Storage locations are not recommended for new drugs and non-existence information is returned. You can evaluate whether it is necessary to add new shelves or adjust the layout of existing shelves to accommodate the new drugs.

[0042] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in the protection scope of the present invention.

Claims

1. A drug addressing and positioning method based on a WMS system, characterized in that: The following steps are involved: Obtaining drug request information, wherein the drug request information includes drug shelf request information and drug picking request information, wherein the drug shelf request information and the drug picking request information both include a code and quantity of the drug to be addressed, and the drug code includes information on the drug brand, drug category, and drug batch number; Determine the shelf area code corresponding to the drug code using a preset shelf list, wherein the preset shelf list includes the drug code and the shelf area code mapped to the drug code, and the shelf area code includes preset shelf area information; Based on the drug request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, and based on the acquired drug code corresponding to the shelf area code, address the location of the drug to be addressed.

2. According to the WMS system-based drug addressing and positioning method of claim 1, it is characterized in that: If it is a drug picking request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, including: If the drug code of the drug to be addressed has a corresponding shelf area code, the inventory quantity of the drug to be addressed is obtained, and it is determined whether the obtained inventory quantity of the drug to be addressed meets the quantity of drugs required for addressing; If the stock quantity of the medicine to be addressed is greater than or equal to the quantity of medicine required for addressing, the shelf area code is returned; If the acquired inventory quantity of the drugs to be addressed is less than the quantity of the drugs to be addressed, check whether there are drugs with the same drug brand, same drug category and different batch numbers in the preset shelf list; if there are drugs with the same drug brand, same drug category and different batch numbers, determine the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers; if the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers is not empty, use the shelf area code of the latest date as the surveillance post position to determine whether the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers meets the quantity of drugs to be addressed; if the inventory quantity of drugs with the same drug brand, same drug category and different batch numbers is greater than or equal to the quantity of drugs to be addressed, return the shelf area code.

3. The WMS-based drug addressing and positioning method according to claim 2, characterized in that: If it is a drug picking request information, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, and also include: if the drug code of the drug to be addressed does not have a corresponding shelf area code, return information that the drug does not exist.

4. The WMS-based drug addressing and positioning method according to claim 1, characterized in that: If it is a drug shelf request message, determine whether the drug code of the drug to be addressed has a corresponding shelf area code, including: If the drug code of the drug to be addressed has a corresponding shelf area code, the shelf area code with the latest update date is used as the surveillance post position to obtain the empty shelf position of the drug to be addressed, and determine whether the obtained empty shelf position of the drug to be addressed meets the quantity of the drug to be addressed; If the empty shelves of the drugs to be addressed are greater than or equal to the quantity of drugs required for addressing, the shelf area code is returned; If the number of empty shelves of the drugs to be addressed is less than the number of drugs to be addressed, check whether there are drugs of the same drug brand, same drug category and different batch numbers in the preset shelf list; if there are drugs of the same drug brand, same drug category and different batch numbers, determine whether there are empty shelves of the drugs of the same drug brand, same drug category and different batch numbers; if there are empty shelves of the drugs of the same drug brand, same drug category and different batch numbers, select the latest date as the surveillance post shelf to determine whether the empty shelves of the drugs of the same drug brand, same drug category and different batch numbers meet the number of drugs required to be addressed; if the number of empty shelves of the drugs of the same drug brand, same drug category and different batch numbers is greater than or equal to the number of drugs required to be addressed, return the shelf area code.

5. The WMS-based drug addressing and positioning method according to claim 4 is characterized in that: If it is a drug shelf request message, determine whether there is a corresponding shelf area code for the drug code to be addressed, and also include: if it is a drug shelf request message, and there is no corresponding shelf area code for the drug code to be addressed, add a drug code, and assign a shelf area code to the added drug code.

6. The WMS-based drug addressing and positioning method according to claim 5, characterized in that: If it is a drug shelf request message, and the drug code of the drug to be addressed does not have a corresponding shelf area code, add a drug code, and assign a shelf area code to the added drug code, including: Confirm whether the drug code is correct and check whether the drug code information exists; If the drug code is correct but there is no corresponding shelf area code, determine whether it is a new drug in the warehouse; Check the remaining space on all shelves and assess whether new shelves need to be added or the existing shelf layout needs to be adjusted to accommodate new drugs; Re-plan the cargo location of new drugs according to the properties of the drugs and the actual situation of the shelves; assign a unique shelf area code to the newly planned cargo location, wherein the shelf area code includes a shelf number, a layer number and a position number; Update the shelf area code information of the newly planned drugs; modify the shelf area code in the warehousing request message; place the drugs on the newly allocated storage location according to the updated warehousing request.

7. A WMS system-based drug addressing and positioning method according to claim 2 or 4, characterized in that: After returning the shelf area code, it also includes: determining an alternative route with a preset medicine entrance as the starting point and a preset checkout position as the end point, the alternative route includes the distance from the starting point to the shelf to be selected and the distance from the shelf to be selected to the end point; calculating the total time of the alternative route, the total time is the sum of the time of each section of the alternative route; screening and determining the alternative route with the smallest total time value from all alternative routes as the addressing route; and sending the addressing route to the mobile terminal.

8. The WMS-based drug addressing and positioning method according to claim 7, characterized in that: After the step of determining the shelf position of the drug to be addressed according to the drug code, the step also includes: sending the addressing route to the mobile terminal, specifically: sending the addressing route to the mobile terminal, the addressing route includes a starting point, the shelf positions to be reached in sequence, shelf area information associated with the shelf positions, and an end point.

Images