CN116354018B

CN116354018B - Automatic medicine warehouse-in detection method, device and equipment

Info

Publication number: CN116354018B
Application number: CN202310628865.1A
Authority: CN
Inventors: 颜燕敏; 张亮; 尹文雨
Original assignee: Sph Sine Pharmaceutical Laboratories Co ltd
Current assignee: Sph Sine Pharmaceutical Laboratories Co ltd
Priority date: 2023-05-31
Filing date: 2023-05-31
Publication date: 2023-08-08
Anticipated expiration: 2043-05-31
Also published as: CN116354018A

Abstract

The invention discloses an automatic medicine warehouse-in detection method, device and equipment, which comprises the following steps: acquiring interaction data among a supervision code database, a stacking database and a warehouse management database based on a cross-system; responding to the stacking request, and detecting the current stacking state in real time based on the interaction data to obtain stacking state data after stacking is completed; the stacking state data are sent to a warehouse management system from a stacking system, the warehouse management system is updated to generate a corresponding target order state, and the target order state is detected in real time to obtain updated target order data; when the detection mode is started, the balance among the current stacking state, the target order state and the interactive data is detected in real time, whether the task is abnormal in the running process is judged, and an abnormal prompt is output. Based on the cross-system connection of the databases, the data balance among the databases is ensured, the manual detection can be replaced, the abnormality can be positioned and warned in time, and the automation of medicine warehouse-in detection is realized.

Description

Automatic medicine warehouse-in detection method, device and equipment

Technical Field

The invention relates to the technical field of medicine management, in particular to an automatic medicine warehouse-in detection method, device and equipment.

Background

Along with the acceleration of life pace, the demands of people on logistics efficiency are also continuously improved. Robots are commonly used to transport containers in order to increase the warehouse entry efficiency of pharmaceutical products in workshops. The warehouse-in stacking of workshop medicine is changed from manual work to machine, and data accuracy and data balance among the real-time verification systems are required. The defects of the prior art are that: 1. the medicine production workshop and the warehouse are in different spaces, and the workshop can not see the warehouse stacking condition and can not find problems in time. 2. The data interaction between the pipeline hardware equipment and the warehouse management software lacks the monitoring of an auxiliary program, so that the problem of incapability of timely positioning and incapability of early warning of false instructions of the equipment occur. 3. Data transmission among the systems is unequal, and abnormality is easy to occur. In summary, since the warehousing links are more, the abnormal conditions are not handled in time, so that the warehousing efficiency is lower.

Disclosure of Invention

The invention aims to provide an automatic medicine warehousing detection method, device, equipment and storage medium, which are used for establishing connection to databases based on a cross system, changing warehouse-in stacking of workshop finished products from manual work into machine, checking data accuracy and data balance among the databases in real time, replacing manual detection, positioning in time and warning abnormality, and realizing automation of warehouse-in detection.

The invention provides an automatic medicine warehouse-in detection method, which is characterized by comprising the following steps:

based on cross-system acquisition of interaction data among a corresponding supervision code database, a stacking database and a warehouse management database, wherein the interaction data comprises information for establishing connection with the supervision code database, information for establishing connection with the stacking database and information for establishing connection with the warehouse management database;

responding to a stacking request sent from a warehouse management database to a stacking system, and detecting the current stacking state in real time based on the interaction data to obtain stacking state data after stacking is completed;

the stacking state data are sent to the warehouse management system from the stacking system, connection between the stacking system and the warehouse management system is established, the warehouse management system is updated to generate a corresponding target order state, and the target order state is detected in real time to obtain updated target order data;

when a detection mode is started, the balance among the current stacking state, the target order state and the interaction data is detected in real time, whether an abnormality exists in the running process of tasks related to automatic medicine warehousing is judged, and if the abnormality occurs, an abnormality prompt is output on a user interface.

Preferably, the method further comprises:

under a normal working and running state, acquiring target medicine information according to a warehouse-in request, transmitting the target medicine information from the supervision code system to the stacking system, and establishing connection between the stacking system and the supervision code system, wherein the target medicine information at least comprises a production batch number of a target medicine, a medicine sub-class code and corresponding medicine supervision code information;

acquiring a target production task ID from the supervision code system, and acquiring corresponding medicine supervision code information according to the target production ID, wherein the target production task ID and a target stacking task are bound one by one;

under the detection mode running state, whether the interactive data transmission between the supervision code system and the stacking system is successful or not is detected, namely, the target production task ID in production is acquired according to the production batch of the target medicine, the corresponding medicine supervision code information generated by the supervision code system is positioned according to the corresponding medicine supervision code information received by the stacking system, and whether the target production task ID in production is accurate or not is confirmed;

wherein one production lot of the target medicine includes a plurality of target production tasks, and the same lot performs only one of the target production tasks.

Preferably, the method for starting the detection mode includes:

acquiring a finished product planning work order generated by the warehouse management system according to the warehouse entry request;

sending a palletizing position request from the warehouse management system to the palletizing system according to the finished product planning work order;

acquiring a binding instruction to a target stacking position sent by the stacking system according to the stacking position request so as to execute distribution to the target stacking position, and controlling external equipment to sort the distributed stacking position to obtain first comparison information after stacking is completed, wherein the first comparison information at least comprises the stacking total number of target medicines and corresponding medicine supervision code information;

the first comparison information after stacking is completed is sent to the warehouse management system to obtain second comparison information after closing of a target order, and the second comparison information at least comprises the total number of target medicines and corresponding medicine supervision code information, which are transmitted to the warehouse management system by the stacking system;

the method comprises the steps of obtaining target medicine information generated by the supervision code system, and sending the target medicine information to the stacking system to obtain third comparison information after production is completed, wherein the target medicine information at least comprises a target production lot number and target medicine supervision code information, and the third comparison information at least comprises the total number of target medicines transmitted to the stacking system by the supervision code system and corresponding medicine supervision code information;

Judging whether abnormality occurs in an automatic warehousing process, comparing the first comparison information, the second comparison information and the third comparison information, checking whether the interactive data output among the system databases are consistent in real time, and outputting a detection result related to system stability.

Preferably, the method for starting the detection mode further comprises:

acquiring bill information and supervision code information of the target stacking task in the stacking system;

detecting whether the stacking system receives the supervision code information sent by the supervision code system or not in a first step, and acquiring the supervision code information corresponding to the target medicine from the supervision code system again under the condition of abnormal transmission;

performing second-step detection on workshop production line equipment, the supervision code system and the interactive network and ports in the stacking system;

the interactive data balance obtained in each system database by the acquired state of the stacking task corresponding to the target order and the corresponding drug monitoring code information in the monitoring code system, the stacking system and the warehouse management system is detected in the third step, so that compensation checking of an ongoing or unsuccessful task is realized; and/or the number of the groups of groups,

And if the hardware fails, acquiring hardware error information, and sending out fault prompt according to the hardware error information, wherein the hardware error information comprises alarm information generated by related equipment in the automatic medicine warehousing process and abnormal information of the warehouse on-shelf task state.

Preferably, the real-time detection of the target palletizing state based on the interaction data includes:

acquiring the interactive data in the process of stacking tasks, wherein the interactive data at least comprises bill information transmitted to the stacking database by the warehouse management database, the total number of orders acquired from the warehouse management database, the number of current shelved objects and the number of current tray objects acquired from the stacking database;

checking whether each bill information accords with a preset stacking rule;

confirming whether the interactive data generated between the palletizing database and the warehouse management database are balanced or not through a formula of a target order total number = tray number + shelf number;

when one or more bill information does not accord with a preset stacking rule, marking the current stacking position;

when all bill information generated in the whole course detection process accords with a preset stacking rule, directly ending the instruction operation of the current stacking state detection to finish the whole course detection operation in the current state.

Preferably, determining whether the palletizing system receives the batching instruction issued from the supervisory code system further comprises:

when a tray is fully stacked, a full-tray instruction is sent to the stacking system, and an xml file is generated, wherein the xml file comprises an order number of a finished product planning work order corresponding to a current stacking task, a medicine production batch number, a tray number, supervision code information on the current tray and stacking time;

and receiving the xml file from the warehouse management system, analyzing the xml file, obtaining analyzed information, and storing the analyzed information into a database corresponding to the warehouse management system so as to display that the real object is in a warehouse-in state.

Preferably, the verifying whether each document information accords with a preset stacking rule includes:

judging whether a target stacking task acquired from the warehouse management system is legal or not;

applying a stacking position from the warehouse management system to the stacking system according to the production lot number, judging whether the current stacking position is applied successfully, and if the current stacking position is applied unsuccessfully, placing the target medicine after the packing operation on a lifting machine by a workshop, obtaining supervision code information corresponding to the target medicine after the grabbing position operation and the photoelectric scanning operation, and recognizing that the supervision code information is not matched with the current stacking task, and eliminating from a fault port;

If the current stacking bit has completed the operation of the allocation instruction, a rejection signal for allocating the new stacking bit is sent out and fed back to the warehouse management system, and a prompt is sent out to a user;

if the current stacking position is allocated to the current production batch number, a rejection signal for allocating a new stacking position is sent out and fed back to the warehouse management system, and a prompt is sent out to a user;

judging whether the stacking system receives a batch forming instruction sent by the supervision code system, entering a corresponding warehouse-in task if the batch forming instruction is received, outputting the total number and the total number of the current stacking boxes, comparing the total number and the total number of the current stacking boxes with the total number of the actual stacking boxes, judging whether the number is equal, and continuing to operate the target stacking task if the batch forming instruction is not received.

Preferably, the acquiring the finished product planning worksheet generated by the warehouse management system according to the warehouse entry request further includes:

checking the finished product planning work order;

wherein the checked content comprises: judging whether a medicine sub-class code obtained from the finished product planning work order is matched with a sub-class code in a finished product sub-class code table generated from the stacking system, wherein the finished product sub-class code table comprises a target medicine name, the sub-class code and a box type number after being packaged into a box;

And binding the production lot number corresponding to the target stacking position, and judging whether the bound production lot number exists in the target order acquired from the warehouse management system.

The invention also provides an automatic medicine warehouse-in detection device, which comprises:

the data acquisition module is used for acquiring interaction data among the corresponding supervision code database, the stacking database and the warehouse management database based on a cross system, wherein the interaction data comprises information for establishing connection with the supervision code database, information for establishing connection with the stacking database and information for establishing connection with the warehouse management database;

the first detection module is used for responding to a stacking request sent from the warehouse management system to the stacking system, detecting the current stacking state in real time based on the interaction data, and obtaining stacking state data after stacking is completed;

the second detection module is used for sending the stacking state data from the stacking system to the warehouse management system, establishing connection between the stacking system and the warehouse management system, updating the warehouse management system to generate a corresponding target order state, and detecting the target order state in real time to obtain updated target order data;

And the abnormal output module is used for detecting the balance among the current stacking state, the target order state and the interactive data in real time when the detection mode is started, judging whether the task operation process related to the automatic medicine warehousing is abnormal or not, and outputting an abnormal prompt on a user interface if the abnormal condition exists.

The present invention also provides a control apparatus including:

a memory for storing a processing program;

and the processor is used for realizing the automatic medicine warehousing detection method according to the embodiment of the invention when executing the processing program.

Aiming at the prior art, the invention has the following beneficial effects:

according to the automatic medicine warehousing detection method provided by the invention, connection is established for each database based on a cross system, warehousing stacking of workshop finished products is changed from manual work to machine, data accuracy and data balance among the databases are checked in real time, manual detection can be replaced, abnormality is positioned and warned in time, and automation and intellectualization of warehousing detection are realized.

The invention realizes the function of checking and monitoring the whole flow data based on a AC, WCS, WMS cross-system; as auxiliary instruction operation in the production and manufacturing industry, the data acquisition and early warning functions of pipeline hardware equipment and warehouse management software are realized.

The invention opens barriers among all systems on the production line, checks interactive data among AC, WCS and WMS programs in real time, and monitors the stacking state and data balance; the equipment state inspection is realized, and comprises the inspection of network, port and bill states; and a data checking function is realized, and the data balance of the stacking order is checked.

Drawings

FIG. 1 is a schematic diagram illustrating steps of an automated drug warehousing inspection method according to one embodiment of the present invention;

FIG. 2 is a schematic diagram of database interactions in accordance with an embodiment of the present invention;

FIG. 3 is a diagram illustrating detection of the palletizing status of the WCS according to an embodiment of the present invention;

FIG. 4 is a diagram illustrating a palletizing bit status interface in accordance with one embodiment of the present invention;

FIG. 5 is a flowchart of automated drug warehousing detection according to one embodiment of the invention;

FIG. 6 is a diagram illustrating an exemplary stability check of an automated drug warehousing detection method according to one embodiment of the invention;

FIG. 7 is a diagram showing a conventional inspection example of an automated drug warehousing inspection method according to one embodiment of the invention;

fig. 8 is a diagram illustrating a fault detection example of the automated drug warehousing detection method according to an embodiment of the invention.

Detailed Description

For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

The term "including" and variations thereof as used herein are intended to be open-ended, i.e., including, but not limited to. The term "based on" is based at least in part on. The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments. Related definitions of other terms will be given in the description below.

It should be noted that the terms "once," "second," and the like, as referred to in this disclosure, are used solely to distinguish one from another device, module, or unit, and are not intended to limit the order or interdependence of functions performed by such devices, modules, or units.

It should be noted that the references to "one" or "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be construed as "one or more" unless the context clearly indicates otherwise.

Example 1

As shown in fig. 1, the present invention provides an automated drug warehousing detection method, which is characterized by comprising:

s1, acquiring interaction data among a corresponding supervision code database, a stacking database and a warehouse management database based on a cross system, wherein the interaction data comprises information for establishing connection with the supervision code database, information for establishing connection with the stacking database and information for establishing connection with the warehouse management database; referring to fig. 2, the user-friendly cross-system adopted in the embodiment is an interactive platform implemented by an XZRobot program, and required information is obtained from each system database, namely, supervision code database data is obtained from a supervision code system AC, palletizing database data is obtained from a palletizing system WCS, warehouse management database data is obtained from a warehouse management system WMS, and a real-time monitoring interface is used for warning as long as abnormality is detected, so that the information can be processed in time.

S2, responding to a stacking request sent from the warehouse management system to the stacking system, and detecting the current stacking state in real time based on the interaction data to obtain stacking state data after stacking is completed;

in order to break through barriers among systems on a production line, interactive data among the AC, WCS and WMS programs are checked in real time, the stacking state and data balance are monitored, and the real-time detection of the target stacking state based on the interactive data in the step S2 comprises the following steps:

s210: acquiring the interactive data in the process of the current palletizing task, wherein the interactive data at least comprises bill information transmitted to the palletizing database by the warehouse management database, the total number of target orders acquired from the warehouse management database, the number of current palletized objects and the number of current pallet objects acquired from the palletizing database; when stacking, the stacking is firstly carried out, then the stacking is carried out, and the bill information comprises: and according to the WCS stacking position, the WMS order number, the medicine name, the order number, the medicine subclass code and the medicine production lot number of the WMS finished product planning work order application.

S211: checking whether each bill information accords with a preset stacking rule; the preset stacking rule in this embodiment includes: 1. the WCS has a drug information table containing drug names, subclass codes, and bin numbers. Boxes with different sizes have different stacking modes, and the boxes are numbered 4 in total. Whether the subclass code is in the WCS drug information table. 2. A production lot of medication is not allowed to have two palletizing tasks at the same time.

S212: confirming whether the interactive data between the stacking database and the warehouse management database are balanced or not through a formula of total number of orders = number of trays + number of shelves; the number of shelves loaded in this embodiment refers to the number of shelves that the WMS has received. After the tray is fully stacked, the WCS can generate an xml file, namely, an order number, a medicine production batch number, a tray number, supervision code information on the tray and stacking time of the WMS finished product planning work order corresponding to the current stacking task are contained. WMS will parse xml file and record the above information into database, representing that the object has been put in storage. And inquiring the number of the supervision codes in storage, namely the number of the received goods, according to the WMS order number.

S213: when one or more bill information does not accord with a preset stacking rule, marking the current stacking position; the bill information in this embodiment may be update information generated by performing WCS tasks or update information generated by WMS performing tasks, and if the above information does not meet a preset rule, the XZRobot program in the automated drug warehousing detection system turns red and an alarm sound is played to warn.

S214: when all bill information generated in the whole course detection process accords with a preset stacking rule, directly ending the instruction operation of the current stacking state detection to finish the whole course detection operation in the current state. The embodiment is to complete the whole inspection of the automatic medicine warehouse entry after about 30 s. If all the data to be checked are in accordance with the rule, the green color is displayed normally, and the color turns red once an abnormality is detected on the way.

Referring to fig. 3, in this embodiment, checking the stacking status focuses on the task in progress, acquires the expected bill of goods and the production task of AC, which are transmitted from WMS to WCS, from AC, WCS, WMS database, checks whether each bill meets the stacking rule, and determines whether WCS and WMS data are balanced in real time by the formula "total number of orders=number of trays+number of shelves", and if an error bill is found, it turns red on the interface, so as to remind service personnel of finding the error in time. In this embodiment, the error document mainly prevents some errors, such as sub-class coding errors, warehouse errors, quantity errors, simultaneous application of stacking bits by multiple tasks in the same batch, and the like, when the work order is artificially created.

In an embodiment, the step of verifying whether each piece of document information conforms to the preset stacking rule in step S211 includes:

s2110: judging whether a target stacking task acquired from the warehouse management system is legal or not;

s2111: applying a stacking position from the warehouse management system to the stacking system according to the production lot number, judging whether the current stacking position is applied successfully, and if the current stacking position is applied unsuccessfully, placing the target medicine after the packing operation on a lifting machine by a workshop, obtaining supervision code information corresponding to the target medicine after the grabbing position operation and the photoelectric scanning operation, and recognizing that the supervision code information is not matched with the current stacking task, and eliminating from a fault port;

S2112: if the current stacking bit has completed the operation of the allocation instruction, a rejection signal for allocating the new stacking bit is sent out and fed back to the warehouse management system, and a prompt is sent out to a user;

s2113: if the current stacking position is allocated to the current production batch number, a rejection signal for allocating a new stacking position is sent out and fed back to the warehouse management system, and a prompt is sent out to a user;

s2114: judging whether the stacking system receives a batch forming instruction sent by the supervision code system, entering a corresponding warehouse-in task if the batch forming instruction is received, outputting the total number and the total number of the current stacking boxes, comparing the total number and the total number of the current stacking boxes with the total number of the actual stacking boxes, judging whether the number is equal, and continuing to operate the target stacking task if the batch forming instruction is not received.

As will be appreciated by those skilled in the art, the present embodiment performs a correlation check on a preset palletizing rule: whether the palletizing task of the WCS is legal or not: 1) Judging whether the WMS applies for a stacking position, if not, if the workshop places the packaged whole box of medicines on the lifting machine, and after the mechanical arm grabbing position is reached, photoelectrically scanning, the batch of supervision codes are found to have no stacking task and are removed, and the batch of supervision codes are discharged from a fault port; 2) And judging whether the same batch number repeatedly applies for the stacking position, and the repeated application for the stacking position cannot occur.

Further, the determining in step S2114 whether the palletizing system receives the batching instruction sent from the supervision code system further includes:

S3, sending the stacking state data from the stacking system to the warehouse management system, establishing connection between the stacking system and the warehouse management system, updating the warehouse management system to generate a corresponding target order state, and detecting the target order state in real time to obtain updated target order data;

and S4, when a detection mode is started, the balance among the current stacking state, the target order state and the interactive data is detected in real time, whether the task operation process related to automatic medicine warehousing is abnormal or not is judged, and if the abnormal condition exists, an abnormal prompt is output at a user interface. When the stacking device runs, if the stacking task is in a normal state, the interface is green; if an error occurs, the interface turns red, an alarm prompt tone is sent out, the workshop pauses stacking until the error is recovered, and the stacking can be continued. The data checking function may be implemented by checking the data balance of the palletized order.

As shown in fig. 4, acquiring the status of the stacking bits and information, and displaying the content in real time includes: stacking the channel number and the current task state, if the channel number is not batched, continuously producing; WMS worksheet number, product name specification, production lot number, time to obtain palletized location; the WCS total number of stacked pieces, AC production task ID, whether AC production task ID is confirmed, AC produced number of pieces, WMS received number of pieces, current number of pieces on stacking trays, WMS job order status, etc.

The data interaction between the pipeline hardware equipment and the warehouse management software lacks the monitoring of an auxiliary program, so that the problem of incapability of timely positioning and incapability of early warning of false instructions of the equipment occur. The embodiment is used as an auxiliary method of the production and manufacturing industry, and realizes the data acquisition and early warning functions of the assembly line hardware equipment and the warehouse management software. The cross-system adopted in the embodiment is based on an AC, a WCS and a WMS system, and a supervision code database, a stacking database and a warehouse management database are established, wherein the database is called an AC database, a WCS database and a WMS database for short. Fig. 5 illustrates the automated warehouse entry process of finished products from the workshops to the warehouse, and the relationship between the three systems. XZRobot is a monitoring auxiliary program developed on the basis of XZRobot and deployed on site full-flow verification data.

Specifically, the specific detection steps of the supervision code system adopted in the embodiment, which are played in the whole-flow verification, include:

s5: under a normal working and running state, acquiring target medicine information according to a warehouse-in request, transmitting the target medicine information from the supervision code system to the stacking system, and establishing connection between the stacking system and the supervision code system, wherein the target medicine information at least comprises a production batch number of a target medicine, a medicine sub-class code and corresponding medicine supervision code information;

s6: acquiring a target production task ID from the supervision code system, and acquiring corresponding medicine supervision code information according to the target production ID, wherein the target production task ID is bound with the target stacking task one by one;

s7: under the detection mode running state, whether the interactive data transmission between the supervision code system and the stacking system is successful or not is detected, namely, the target production task ID in production is acquired according to the production batch of the target medicine, the corresponding supervision code information generated by the supervision code system is positioned according to the corresponding medicine supervision code information received by the stacking system, and whether the target production task ID in production is accurate or not is confirmed;

Wherein one production lot of the target medicine includes a plurality of target production tasks, and the same lot performs only one of the target production tasks. In this embodiment, the AC is checked, for example, whether the AC successfully transmits the supervision code to the WCS; whether the correct task ID is obtained or not is determined, in order to ensure that the whole flow data is accurate, the AC task ID in production is obtained in batches, and then the supervision code in the AC system is positioned by the supervision code information received by the WCS, so that whether the obtained task ID is correct or not is determined. An AC will have multiple tasks for a lot, and other systems will not need to use the AC task ID, so there is no function to pass the AC task ID to other systems. There is only one AC task in progress for the same batch, but the workshops are in rare cases: in the case of suspending the task a and performing the task B during the operation, the ID of the task B may be acquired in real time, and thus it is necessary to confirm whether the task ID is correct or not and record the correct ID.

In order to perform stability inspection on the automated drug warehousing detection system, referring to fig. 6, all anomalies detected in the automated warehousing process are traced and positioned by combining an operation log. The method for starting the detection mode in the step S4 includes:

S410: acquiring a finished product planning work order generated by the warehouse management database according to the warehouse entry request;

s411: sending a palletizing bit request from the warehouse management database to the palletizing bit database according to the finished product planning worksheet; information used in the automatic warehousing process of the finished product planning work orders: target order number, warehouse information, target medicine name, target medicine material code, target medicine production lot number, target order number, receiving number, unit, tray number, tray position number, boxing number and subclass code.

S412: acquiring a binding instruction to a target stacking position sent by the stacking system according to the stacking position request so as to execute distribution to the target stacking position, and controlling external equipment to sort the distributed stacking position to obtain first comparison information after stacking is completed, wherein the first comparison information at least comprises the stacking total number of target medicines and corresponding medicine supervision code information; the control external device employed in the present embodiment may be an automatic sorter or other automatic sorting device.

S413: the first comparison information after stacking is completed is sent to the warehouse management system to obtain second comparison information after closing of a target order, and the second comparison information at least comprises the total number of target medicines and corresponding medicine supervision code information, which are transmitted to the warehouse management system by the stacking system;

S414: the method comprises the steps of obtaining target medicine information generated by the supervision code system, and sending the target medicine information to the stacking system to obtain third comparison information after production is completed, wherein the medicine information at least comprises a target production lot number and target medicine supervision code information, and the third comparison information at least comprises the total number of target medicines transmitted to the stacking system by the supervision code system and corresponding medicine supervision code information;

s415: judging whether abnormality occurs in the automatic warehousing process, comparing the first comparison information, the second comparison information and the third comparison information, checking whether the interactive data output among the system databases are consistent in real time, and outputting a detection result related to the system stability, wherein the first comparison information, the second comparison information and the third comparison information can also comprise other needed information, updated goods receiving information, stacking information, warehouse management information, order information and the like.

It can be understood by those skilled in the art that after the WCS stacking task is finished, the documents and data of the stacking task in the AC, WCS and WMS databases are acquired, and the total number and the supervision code information of the WCS transferred to the WCS by the AC, the total number and the supervision code information of the WCS stacking total number and the supervision code information of the WCS transferred to the WMS, and the total number and the supervision code information of the WMS receiving total number and the supervision code information are compared, and if the corresponding WMS order is not closed for a long time, a warning is given, and at this time, the manual intervention is performed. The checking method for the WCS further comprises the following steps: 1) Checking the current pallet number of the WCS = the total stacking number of the WCS-the receiving number of the WMS; 2) Whether the palletizing task of the WCS is legal or not: i) Whether the WMS applies for a stacking position or not; if the stacking position is not applied, if the workshop places the packaged whole box of medicines on the lifting machine, the whole box of medicines reaches the manipulator grabbing position, and after photoelectric scanning, the batch of supervision codes are found to have no stacking task and are removed from a fault port. ii) whether the same batch applies for stacking positions repeatedly; 3) Whether the stacking task is batched or not, namely whether the AC system sends an order ending instruction or not; 4) The acquisition of real-time hardware alert information is detailed below.

The step S410 of obtaining the finished product planning worksheet generated by the warehouse management database according to the warehouse entry request further includes:

checking the finished product planning work order; judging the data balance of the current stacking bit: WCS current pallet number = WCS total stacking number-WMS received number; after the tray is fully stacked, the WCS generates an xml file which contains an order number, a medicine production batch number, a tray number, supervision code information on the tray and stacking time of the WMS finished product planning work order corresponding to the current stacking task. The WMS analyzes the xml file, and records the information into a WMS database to represent that the real object is put in storage. And inquiring the number of the supervision codes in storage, namely the number of the received goods, according to the WMS order number.

Wherein the checked content comprises: 1. whether the medicine subclass codes obtained from the finished product planning worksheets in the warehouse management database can be found in a product subclass code table of the WCS or not; i.e. whether the drug subclass code of WMS exists in the definition of WCS. 2. Whether the loading rules of the WMS are legal or not, and the illegal situations, such as medicines which are not classified into a specified warehouse, exist: the splice box is put into a whole box warehouse; 3. and binding the production lot number corresponding to the target stacking position, and judging whether the bound production lot number exists in a target order acquired from the warehouse management database, wherein the order is a WMS expected goods notification bill and is consistent with the finished product planning work bill information.

In this embodiment, referring to fig. 7, the method for starting the detection mode in step S4 further includes:

s420: acquiring bill information of the target stacking task and corresponding medicine supervision code information in the stacking system;

s421: detecting whether the stacking system receives the medicine supervision code information sent by the supervision code system or not in a first step, and acquiring the supervision code information corresponding to the target medicine from the supervision code system again under the condition of abnormal transmission; when the stacking machine receives the stacking materials, all interfaces are green and normal, and workshops stack normally; when the network abnormality is not received, a warning prompt is given, the workshop can pause stacking, and human intervention is needed to check the network abnormality. On the premise that the stacking task is normally bound, the packaged whole box of medicines is removed, and the medicines are discharged from a fault port, which is possibly that the WCS does not receive the supervision code information transmitted by the AC. If the transfer is successful, the label is rejected, the label is possibly distorted, or the label is abnormally printed, and the information is not scanned. Unsuccessful, the AC is required to retransmit the supervisory code information.

S422: meanwhile, performing a second step of detection on workshop production line equipment, the supervision code system and the interactive network and ports in the stacking system; the method is beneficial to realizing the detection of the equipment state, including network, port and bill state inspection.

S423: and acquiring the state of the stacking task corresponding to the target order and the corresponding medicine supervision code information in the supervision code system, the stacking system and the warehouse management system, and performing third-step detection on the balance of the interactive data acquired in each system database to realize compensation checking of the ongoing or unsuccessful task.

Those skilled in the art can understand that the documents and information of the stacking task in the WCS database are obtained, and whether the supervision code information issued by the AC is received or not is inquired; checking whether a network and a port are smooth or not by using the Ping/telnet workshop production line industrial personal computer and an AC (alternating current) and WCS (wireless communication system) database; the acquire AC, WCS, WMS database acquires order palletizing status and supervisory code information, and performs a compensation check on ongoing or unsuccessful tasks. In the embodiment, whether the correct task ID is obtained is judged by comparing the information of the supervision code on the WCS tray with the information of the current AC task supervision code; the box splicing task without the correct ID can be automatically re-acquired, and the whole box task needs to be manually updated; the closed task with unequal AC, WCS, WMS data records the failure reason and finds the supervision code causing the data imbalance; and performing state updating on the record of which the correct task state is not acquired.

For further checking the fault problem, referring to fig. 8, the method for starting the detection mode in step S4 further includes:

s430: if the hardware fails, collecting hardware error information and sending out fault prompt according to the hardware error information, wherein the hardware error information comprises alarm information generated by related equipment in the automatic medicine warehousing process, such as alarm information of a palletizing robot and an overhead warehouse, non-existing information of a warehouse overhead task and unfinished state information of the warehouse overhead task, and checking whether the WMS overhead task exists or not according to a pallet number after acquiring the alarm information of the palletizing robot and the overhead warehouse, and checking the warehousing state: whether the racking task is completed or not, the tray can enter the warehouse, the fact that the racking task is not displayed is shown, and the following problems occur: trays are put into designated places or, at the time of automatic warehouse entry, are stuck somewhere due to hardware failure, etc. The alarm information of the palletizing robot, such as the abnormal bar code of the tray, cannot be identified; removing boxes; the whole tray is discharged from the fault port; the lack of trays requires replenishment of the trays; hardware failure alarms, such as first pass elevator failure; the number of bins on trays of plc is inconsistent with the WCS program count, etc. In this embodiment, the WCS fault reading module collects hardware errors of WCS in WMS and WCS interfaces, and reminds service personnel in time in the operation process. The trays which are piled up in this embodiment finally enter an overhead warehouse, namely an overhead three-dimensional warehouse.

The detection method adopted by the implementation is applied to warehousing equipment such as robots and pipeline mechanisms, and is used for checking and monitoring based on AC, WCS, WMS cross-system full-flow data. The working principle of the standard warehouse-in flow is as follows:

and the workshop selects a finished product planning work order corresponding to the material code and the production batch number in the WMS.

And secondly, the WMS initiates application of the stacking position to the WCS, and the WMS applies for the stacking position by using the production lot number.

And thirdly, the WCS judges whether the stacking position can be allocated or not, if the preset stacking position is completely allocated, the allocation of a new stacking position is refused, the new stacking position is fed back to the WMS, and the WMS reminds a user. The preset palletizing bits may be 4 or other number.

If the palletizing bit is already allocated to the current lot number, the allocation of a new palletizing bit is refused, and the WMS reminds the user. This may be the case when the user selects the wrong production planning worksheet. And stopping packaging after being refused, and prompting ' refusing to allocate the abnormal stacking position ' through a touch screen or a signal lamp '.

And if the conditions are not met, packaging the goods.

The current task in the MS is partially received and partially put on shelf alternately, and the number of put on shelf in this embodiment is the same as the number of WMS received.

Fourth, the packaged goods are sent to the WCS through the sampling device, such as a probe, according to the electronic supervision code, and the information including the name, the medicine sub-class code, the lot number, the electronic supervision code and the three-level code is sent to the WCS.

Fifthly, the WCS acquires information to verify whether the current batch number is one of four stacking positions, if yes, the goods are sent to the elevator, and the WCS stores the information acquired by the automatic warehousing detection system; otherwise, the operation is paused.

And sixthly, before the goods arrive at the palletizing robot, the WCS obtains a production lot number according to the electronic supervision code on the outer box, and then judges which stacking position the goods are placed at according to the production lot number, and the operations are completed in the WCS.

And seventhly, stacking by a stacking robot.

And eighth, stacking the complete trays of the box number according to a preset tray number by the stacking robot.

And ninth, the WCS transmits three-level code information of the electronic supervision codes of the pallet and the goods to the WMS. The XML file uploaded for the sales platform is generated by the WMS.

Tenth, WMS is put on shelf.

Eleventh, if no batch signal sent by the AC is detected, the process loops to seventh.

Twelfth, under the condition that the last tray is not full of the whole trays, the love creates a batch forming instruction, including the total number, the state and the like of the whole boxes, and indicates the batch end to the WCS. The WCS compares whether the total number of the actual stacked boxes is equal to the total number of the actual stacked boxes, if not, the flow is stopped, and the alarm is given.

Thirteenth, WMS order closes, and if AC, WCS, WMS data is consistent, the finished product planning worksheet is closed. And finishing the automatic warehousing process.

And fourteenth step, the occupation of the batch number is released by the stacking position, and the WCS deletes all electronic supervision code information obtained from the supervision code system by each box of the current finished product planning work order.

Example two

Based on the same conception, the invention also provides an automatic medicine warehouse-in detection device, which comprises:

the first detection module is used for responding to a stacking request sent from the warehouse management system to the stacking system, detecting the current stacking state in real time based on the interaction data, and obtaining stacking state data after stacking is completed; the first detection module in this embodiment is a stacking status checking module.

The third detection module is used for acquiring target medicine information according to a warehouse-in request under a normal working and running state, sending the target medicine information from the supervision code system to the stacking system, and establishing connection between the stacking system and the supervision code system, wherein the target medicine information at least comprises a production batch number of a target medicine, a medicine subclass code and corresponding medicine supervision code information;

acquiring a target production task ID from the supervision code system, and acquiring corresponding medicine supervision code information according to the target production ID, wherein the target production task ID is bound with the target stacking task one by one;

And in a detection mode running state, whether the interactive data transmission between the supervision code system and the stacking system is successful or not is detected, namely, the target production task ID in production is acquired according to the production batch of the target medicine, the corresponding supervision code information generated by the supervision code system is positioned according to the corresponding medicine supervision code information received by the stacking system, and whether the target production task ID in production is accurate or not is confirmed.

Specifically, the system stability check module includes:

acquiring a binding instruction to a target stacking position sent by the stacking position system according to the stacking position request so as to execute distribution to the target stacking position, and controlling external equipment to sort the distributed stacking position to obtain first comparison information after stacking is completed, wherein the first comparison information at least comprises the stacking total number of target medicines and corresponding medicine supervision code information;

The first comparison information after the stacking is completed is sent to the warehouse management system to obtain second comparison information after the order is closed, wherein the second comparison information at least comprises the total number of target medicines and corresponding medicine supervision code information, which are transmitted to the warehouse management system by the stacking system;

the method comprises the steps of obtaining target medicine information generated by the supervision code system, and sending the target medicine information to the stacking system to obtain third comparison information after production is completed, wherein the medicine information at least comprises a target production lot number and target medicine supervision code information, and the third comparison information at least comprises the total number of target medicines transmitted to the stacking system by the supervision code system and corresponding medicine supervision code information;

The conventional inspection module includes: acquiring bill information of the target stacking task and corresponding medicine supervision code information in the stacking system; detecting whether the stacking system receives the supervision code information sent by the supervision code system or not in a first step; meanwhile, performing a second step of detection on workshop production line equipment, the supervision code system and the interactive network and ports in the stacking system; and acquiring the state of the stacking task corresponding to the target order and the corresponding medicine supervision code information in the supervision code system, the stacking system and the warehouse management system, and performing third-step detection on the balance of the interactive data acquired in each database to realize compensation checking of the ongoing or unsuccessful task.

And the fault reading module is used for acquiring hardware error information and sending out fault prompts according to the hardware error information if the hardware has a fault condition, wherein the hardware error information comprises alarm information generated by related equipment in the automatic medicine warehousing process and abnormal information of a warehouse on-shelf task.

It should be noted that, the division of each module in the embodiment of the apparatus/system is merely a division of a logic function, and may be fully or partially integrated into a physical entity or may be physically separated. And these modules may all be implemented in software in the form of calls by the processing element; or can be realized in hardware; the method can also be realized in a form that a part of units are called by processing elements to be software, and the other part of units are realized in a form of hardware.

The implementation principles and methods of the above modules, such as the data acquisition module, the first detection module, the second detection module, and the abnormal output module, have been described in the foregoing embodiments, so that repeated descriptions are omitted herein.

Example III

Based on the same conception, in some embodiments of the present application, a control device is also provided. The control device comprises a memory and a processor, wherein the memory is used for storing a processing program, and the processor executes the processing program according to instructions. When the processor executes the processing program, the automatic medicine warehousing detection method in the embodiment is realized. The control device employed in the present embodiment may be a robot.

In some embodiments of the present application, a readable storage medium is also provided, which may be a non-volatile readable storage medium or a volatile readable storage medium. The readable storage medium has instructions stored therein that, when executed on a computer, cause an electronic device comprising the readable storage medium to perform the automated drug warehousing detection method described above.

It will be appreciated that for the automated drug warehousing detection methods mentioned above, if implemented as software functional modules and sold or used as separate products, they may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only memory (ROM), a random access memory (Random access memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.

The computer readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, with readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A readable storage medium may also be any readable medium that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out the subject matter disclosed herein may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C++ or the like and conventional procedural programming languages, such as the C programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. An automated drug warehousing detection method is characterized by comprising the following steps:

responding to a stacking request sent from a warehouse management system to a stacking system, and detecting the current stacking state in real time based on the interaction data to obtain stacking state data after stacking is completed;

2. The automated pharmaceutical warehousing detection method of claim 1, further comprising:

under a normal working and running state, acquiring target medicine information according to a warehouse-in request, transmitting the target medicine information from a supervision code system to the stacking system, and establishing connection between the stacking system and the supervision code system, wherein the target medicine information at least comprises a production lot number of a target medicine, a medicine subclass code and corresponding medicine supervision code information;

under the detection mode running state, whether the interactive data transmission between the supervision code system and the stacking system is successful or not is detected, namely, the target production task ID in production is acquired according to the production batch of the target medicine, the corresponding supervision code information generated by the supervision code system is positioned according to the corresponding medicine supervision code information received by the stacking system, and whether the target production task ID in production is accurate or not is confirmed;

3. The automated drug warehousing detection method of claim 2, wherein the method of initiating the detection mode comprises:

the first comparison information after stacking is completed is sent to the warehouse management system to obtain second comparison information after order closing, and the second comparison information at least comprises the total number of target medicines and corresponding medicine supervision code information, which are transmitted to the warehouse management system by the stacking system;

The method comprises the steps of obtaining target medicine information generated by a supervision code system, and sending the target medicine information to a stacking system to obtain third comparison information after production is completed, wherein the target medicine information at least comprises a target production lot number and target medicine supervision code information, and the third comparison information at least comprises the total number of target medicines transmitted to the stacking system by the supervision code system and corresponding supervision code information;

4. The automated drug warehousing detection method of claim 2, wherein the method of initiating a detection mode further comprises:

acquiring bill information of the target stacking task and corresponding medicine supervision code information in the stacking system;

the interactive data balance obtained in each system database by the acquired state of the stacking task corresponding to the target order and the corresponding information of the monitoring code in the monitoring code system, the stacking system and the warehouse management system is detected in a third step, so that compensation checking of an ongoing or unsuccessful task is realized; and/or the number of the groups of groups,

and if the hardware fails, acquiring hardware error information, and sending out fault prompt according to the hardware error information, wherein the hardware error information comprises alarm information generated by related equipment in the code automatic medicine warehousing process and abnormal information of the warehouse on-shelf task state.

5. The automated drug warehousing detection method of claim 2, wherein the real-time detection of the target palletizing status based on the interaction data comprises:

acquiring the interactive data in the process of stacking tasks, wherein the interactive data at least comprises bill information transmitted to the stacking database by the warehouse management database, the total number of target orders acquired from the warehouse management database, the number of current shelved objects and the number of current tray objects acquired from the stacking database;

Checking whether each bill information accords with a preset stacking rule;

6. The automated medicine warehousing detection method according to claim 5, wherein verifying whether each bill information accords with a preset stacking rule comprises:

7. The automated pharmaceutical warehousing detection method of claim 6, wherein determining whether the palletizing system receives the batching instruction issued from the supervisory code system further comprises:

8. The automated pharmaceutical warehousing detection method of claim 3, wherein the acquiring the finished product plan worksheet generated by the warehouse management system according to the warehousing request further comprises:

checking the finished product planning work order;

9. An automated drug warehousing inspection device, comprising:

10. A control apparatus, characterized by comprising:

a memory for storing a processing program;

a processor which, when executing the processing program, implements the automated drug warehousing detection method according to any one of claims 1 to 8.