CN116469517B - Historical information tracing method, system, equipment and medium of medicine vending machine - Google Patents
Historical information tracing method, system, equipment and medium of medicine vending machine Download PDFInfo
- Publication number
- CN116469517B CN116469517B CN202310725635.7A CN202310725635A CN116469517B CN 116469517 B CN116469517 B CN 116469517B CN 202310725635 A CN202310725635 A CN 202310725635A CN 116469517 B CN116469517 B CN 116469517B
- Authority
- CN
- China
- Prior art keywords
- medicine
- order
- information
- snapshot
- vending machine
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 239000003814 drug Substances 0.000 title claims abstract description 480
- 238000000034 method Methods 0.000 title claims abstract description 47
- 229940079593 drug Drugs 0.000 claims abstract description 66
- 230000008859 change Effects 0.000 claims abstract description 36
- 230000004044 response Effects 0.000 claims abstract description 6
- 230000004048 modification Effects 0.000 claims description 47
- 238000012986 modification Methods 0.000 claims description 47
- 238000004891 communication Methods 0.000 claims description 23
- 238000012545 processing Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 8
- 239000002552 dosage form Substances 0.000 claims description 7
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000006872 improvement Effects 0.000 description 2
- 239000002547 new drug Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H20/00—ICT specially adapted for therapies or health-improving plans, e.g. for handling prescriptions, for steering therapy or for monitoring patient compliance
- G16H20/10—ICT specially adapted for therapies or health-improving plans, e.g. for handling prescriptions, for steering therapy or for monitoring patient compliance relating to drugs or medications, e.g. for ensuring correct administration to patients
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/018—Certifying business or products
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- Epidemiology (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Entrepreneurship & Innovation (AREA)
- Chemical & Material Sciences (AREA)
- Development Economics (AREA)
- Medicinal Chemistry (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Control Of Vending Devices And Auxiliary Devices For Vending Devices (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The application discloses a historical information tracing method, a system, equipment and a medium of a medicine vending machine, wherein the method comprises the following steps: creating a medicine snapshot table corresponding to the medicine information table in the database table structure; generating a drug order in response to a user purchasing a drug in the drug vending machine; judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table; setting a traceable snapshot ID according to the medicine snapshot table and the change condition of the ordered medicine ID; recording transaction information according to the transaction medicine list, the medicine order and the traceable snapshot ID; the application can help the user or manager trace back the historical medicine purchasing information of the corresponding medicine under the condition that the medicine information is changed, ensures the traceability and the information validity of the medicine of the self-service medicine selling machine, improves the maintainability of the self-service medicine selling machine and is easy to improve the satisfaction degree of the user.
Description
Technical Field
The application relates to the technical field of self-service medicine vending machines, in particular to a historical information tracing method, a system, equipment and a medium of a medicine vending machine.
Background
When the self-service medicine vending machine is used for vending medicines, the traceability of the medicines purchased by the clients is very strict due to the specificity of the medicines, so that the validity and traceability of medicine information of the medicines purchased by the clients are required to be ensured; the administrator or the user can also query the related information of the medicine purchased by the customer at any time through the interface.
However, in the automatic medicine vending machine in the prior art, when medicine information purchased by a customer is traced, medicine information inquiry is mostly carried out by taking a medicine ID number summarized by an order as an index, and in this way, when the index of the medicine information is changed, original information at the time of customer purchase cannot be traced; in addition, when recording the medicine information in the prior art, all the detailed information of the purchased medicine is recorded in the order information, and the data is huge due to the great content of the medicine information, so that the efficiency of order information generation and processing is relatively low.
Disclosure of Invention
The application aims to solve the problems in the prior art, and provides a historical information tracing method, a system, equipment and a medium of a medicine vending machine, so as to solve the problem that historical medicine purchasing information cannot be traced when medicine information of the self-service medicine vending machine is changed in the prior art.
In order to solve the technical problems, the specific technical scheme of the application is as follows:
in one aspect, the present application provides a method for tracing historical information of a medicine vending machine, wherein a database table structure is configured in the medicine vending machine, and a medicine information table and a transaction medicine table are stored in the database table structure, and the method comprises the following steps:
creating a medicine snapshot table corresponding to the medicine information table in the database table structure;
generating a drug order in response to a user purchasing a drug in the drug vending machine;
judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table;
setting a traceable snapshot ID according to the medicine snapshot table and the change condition of the order medicine ID; and recording transaction information according to the transaction medicine table, the medicine order and the traceable snapshot ID.
As an improved scheme, the medicine information table stores medicine ID information corresponding to a medicine to be delivered and modification time corresponding to the medicine ID information;
and the medicine snapshot table stores medicine snapshot IDs corresponding to the medicine ID information and modification time corresponding to the medicine snapshot IDs.
As an improvement, said generating a drug order in response to a user purchasing a drug in said drug vending machine, comprising;
confirming a first drug to be shipped for purchase in the drug vending machine;
inquiring first medicine ID information, medicine names, medicine dosage forms, medicine specifications, medicine unit price, medicine batch numbers, medicine validity periods, medicine manufacturers, medicine quantity, medicine payable amount, medicine selling machine numbers and medicine addresses corresponding to the first to-be-shipped medicines in the medicine information table;
integrating the first medicine ID information, the medicine name, the medicine dosage form, the medicine specification, the medicine unit price, the medicine lot number, the medicine expiration date, the medicine manufacturer, the medicine quantity, the medicine payable amount, the medicine vending machine number, and the medicine address as first order information;
generating an order number and a serial number corresponding to the first order information;
integrating the first order information, the order number and the serial number as the medicine order.
As an improved solution, the determining, according to the medicine information table, the medicine order, and the medicine snapshot table, an order medicine ID change condition of the medicine order includes:
reading the medicine information table, and inquiring a first modification time matched with the first medicine ID information in the medicine order in the medicine information table;
reading the medicine snapshot table, and inquiring second modification time of a first medicine snapshot ID matched with the first medicine ID information in the medicine order in the medicine snapshot table;
setting the change condition of the order medicine ID to be consistent with the medicine ID or the medicine ID to be changed according to the time consistency between the first modification time and the second modification time.
As an improvement, the setting the condition of changing the order medicine ID to be the medicine ID coincidence or the medicine ID existence change according to the time coincidence between the first modification time and the second modification time includes:
comparing the first modification time with the second modification time;
if the first modification time is the same as the second modification time, setting the change condition of the ID of the ordered medicine as the same as the ID of the medicine;
and if the first modification time is different from the second modification time, setting the condition of changing the order medicine ID as that the medicine ID is changed.
As an improved solution, the setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition includes:
responding to the change condition of the order medicine ID to change the medicine ID, creating a second medicine snapshot ID, and taking the second medicine snapshot ID as the traceable snapshot ID; updating the traceable snapshot ID and the first drug ID information to the first drug snapshot ID in the drug snapshot table;
and responding to the condition that the order medicine ID changes to be consistent with the medicine ID, and taking the first medicine snapshot ID as the traceable snapshot ID.
As an improved solution, the transaction information recording according to the transaction medicine table, the medicine order and the traceable snapshot ID includes:
and recording the traceable snapshot ID, the first medicine ID information and the serial number in the medicine order into the transaction medicine table.
On the other hand, the application also provides a historical information tracing system of the medicine vending machine, wherein the medicine vending machine is provided with a database table structure, the database table structure stores a medicine information table and a transaction medicine table, and the system comprises:
the system comprises a snapshot table creation module, an order generation module, an ID identification processing module and a transaction recording module;
the snapshot table creating module is used for creating a medicine snapshot table corresponding to the medicine information table in the database table structure;
the order generation module is used for responding to the purchase of medicines in the medicine vending machine by a user to generate a medicine order;
the ID recognition processing module is used for judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table;
the transaction recording module is used for setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition; and the transaction recording module records transaction information according to the transaction medicine table, the medicine order and the traceable snapshot ID.
In another aspect, the present application further provides a computer readable storage medium, where a computer program is stored, where the computer program when executed by a processor implements the steps of the history information tracing method of the medicine vending machine.
In another aspect, the present application further provides a computer device, where the computer device includes a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus; wherein:
the memory is used for storing a computer program;
the processor is used for executing the steps of the historical information tracing method of the medicine vending machine by running the program stored in the memory.
The technical scheme of the application has the beneficial effects that:
the historical information tracing method of the medicine vending machine can help a user or manager trace back the historical medicine purchasing information of the corresponding medicine under the condition that the medicine information is changed, ensures the traceability and the information effectiveness of the medicine of the self-service medicine vending machine, improves the maintainability of the self-service medicine vending machine, and is easy to improve the satisfaction of the user.
The historical information tracing system of the medicine vending machine can be matched with the snapshot table creation module, the order generation module, the ID identification processing module and the transaction recording module, so that the historical information tracing method of the medicine vending machine is realized.
The computer readable storage medium can realize the coordination of the guide snapshot table creation module, the order generation module, the ID identification processing module and the transaction recording module, so as to further realize the historical information tracing method of the medicine vending machine, and the computer readable storage medium can also effectively improve the operability of the historical information tracing method of the medicine vending machine.
The computer equipment can store and execute the computer readable storage medium, so that the historical information tracing method of the medicine vending machine is realized.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present application, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flow chart of a historical information tracing method of a medicine vending machine according to embodiment 1 of the present application;
FIG. 2 is a logic flow diagram of a method for tracing historical information of a medicine vending machine according to embodiment 1 of the present application;
fig. 3 is a logic flow diagram of a user payment in the historical information tracing method of the medicine vending machine according to embodiment 1 of the present application;
fig. 4 is a logic flow diagram of order information reporting in the history information tracing method of the medicine vending machine according to embodiment 1 of the present application;
fig. 5 is a logic flow diagram of information tracing in the historical information tracing method of the medicine vending machine according to embodiment 1 of the present application;
FIG. 6 is a schematic diagram of the architecture of a history information traceability system of the medicine vending machine according to embodiment 2 of the present application;
FIG. 7 is a schematic view of a computer apparatus according to embodiment 4 of the present application;
the labels in the drawings are illustrated as follows:
1501. a processor; 1502. a communication interface; 1503. a memory; 1504. a communication bus.
Detailed Description
The preferred embodiments of the present application will be described in detail below with reference to the accompanying drawings so that the advantages and features of the present application can be more easily understood by those skilled in the art, thereby making clear and defining the scope of the present application.
In the description of the present application, it should be noted that the described embodiments of the present application are some, but not all embodiments of the present application; all other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The terms first, second and the like in the description and in the claims and in the above-described figures, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, apparatus, article, or device that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or device.
Example 1
The embodiment provides a historical information tracing method of a medicine vending machine, which comprises the following steps, as shown in fig. 1-5:
in the drug database table of the self-service drug vending machine, the following information table is stored:
first, the medicine information table is mainly used for storing the related attribute information about medicines in the self-service medicine vending machine, and is as follows:
second, the order record list is mainly used for storing and recording the detailed information of each trade order in the self-service medicine selling machine, and is specifically as follows:
thirdly, trade medicine list, concretely as follows:
in this embodiment, in order to ensure the accuracy and reliability of drug tracing, a drug snapshot table is added in the database table structure, compared with a drug information table, a field of a drug detail snapshot is newly added for each drug ID for performing secondary identification on a drug, and the drug snapshot table is mainly used for judging whether the ID of the drug is changed or not under the lapse of time, so that the drug snapshot ID is updated, each drug can be bound with the drug ID which is not changed before through a new drug ID and a new drug snapshot ID when being changed, and the drug snapshot ID is adopted as a drug ID tracing index before and after the same drug adjustment, so that the drug history data cannot be traced due to the drug ID change is prevented, and the drug snapshot table is specifically as follows:
the method comprises the following specific operation steps:
when the user selects a purchased drug for order confirmation, the front-end system of the self-service vending machine generates relevant order information regarding the order, including but not limited to: information such as the number, name, dosage form, specification, unit price, batch number, expiration date, manufacturer, quantity, amount payable, vending machine number, address, etc. of the medicine; after the front end generates the information, the information is sent to a rear end system of the self-service medicine vending machine;
the self-service medicine selling machine back-end system generates a relevant order number and serial number according to the received order information, generates relevant order information to be paid and stores the order information into an order record table; inquiring a medicine snapshot table and a medicine information table in a database table according to the ID of the medicine in the order information;
judging the latest modification time of the medicine ID in the medicine snapshot table and the latest modification time of the medicine ID in the medicine information table; at this time, whether the two modification times are the same or not is checked, if the two modification times are the same, the medicine IDs in the two tables are the same, and then the snapshot ID and the running water ID corresponding to the medicine ID in the medicine snapshot table are adopted to record into the corresponding transaction medicine table, and one medicine corresponds to one record;
if the two types of the medicine IDs are different, the representative medicine ID is possibly changed, a new snapshot ID is needed to be generated, and the newly generated snapshot ID and the medicine ID in the medicine information table are written into the position corresponding to the medicine ID in the medicine snapshot table; then, recording the new snapshot ID and the serial ID into a corresponding transaction medicine table, wherein one medicine corresponds to one record; information file record when finishing the medicine purchase;
after the subsequent user pays the order to be paid, the payment information such as the order number, the payment code, the payment state, the payment time and the like corresponding to the payment is sent to a back-end system of the self-service medicine selling machine, and the back-end system updates the received corresponding payment information record into an order record table corresponding to the database; based on the information, the self-service vending machine starts to deliver goods, and during delivery, relevant information such as a goods taking state, goods taking time, a medicine ID, a production date, a due date, a batch number and the like of a user taking the medicine is extracted again and sent to a back-end system, and the back-end system synchronously updates the goods taking information such as the goods taking state, the goods taking time and the like to an order record table to complete the record of the order information; then updating information such as medicine ID, production date, expiration date, batch number and the like to a trade medicine table, and finishing record updating of all information when the medicine is purchased;
when tracking and tracing of the information of the sold medicines are carried out later, an administrator or an operator can inquire the corresponding information of the medicines during sales from a management interface of the self-service medicine vending machine; specifically, firstly, an order record table is inquired from an order number, and corresponding running water ID and payment information can be obtained; then, the transaction medicine table can be queried through the serial ID, a corresponding medicine detail snapshot ID can be obtained, and the medicine information purchased at the moment can be obtained through the medicine detail snapshot ID; and by means of the medicine detail snapshot ID tracing mode, the problem that the medicine ID cannot be found due to modification cannot be generated.
Example 2
The present embodiment provides a history information tracing system of a medicine vending machine, based on the same inventive concept as the history information tracing method of the medicine vending machine described in embodiment 1, wherein a database table structure is configured in the medicine vending machine, and a medicine information table and a transaction medicine table are stored in the database table structure, as shown in fig. 6, and the system includes: the system comprises a snapshot table creation module, an order generation module, an ID identification processing module and a transaction recording module;
the snapshot table creating module is used for creating a medicine snapshot table corresponding to the medicine information table in the database table structure; the medicine information table stores medicine ID information corresponding to the medicine to be delivered and modification time corresponding to the medicine ID information; the medicine snapshot table stores medicine snapshot IDs corresponding to the medicine ID information and modification time corresponding to the medicine snapshot IDs;
the order generation module is used for responding to the purchase of medicines in the medicine vending machine by a user to generate a medicine order;
as one embodiment, the generating a drug order in response to a user purchasing a drug in the drug vending machine includes; the order generation module confirms a first drug to be shipped for purchase in the drug vending machine; the order generation module inquires first medicine ID information, a medicine name, a medicine dosage form, a medicine specification, a medicine unit price, a medicine batch number, a medicine validity period, a medicine production enterprise, a medicine quantity, a medicine payable amount, a medicine selling machine number and a medicine address corresponding to the first medicine to be shipped in the medicine information table; the order generation module integrates the first medicine ID information, the medicine name, the medicine dosage form, the medicine specification, the medicine unit price, the medicine lot number, the medicine expiration date, the medicine manufacturer, the medicine quantity, the medicine amount due, the medicine vending machine number, and the medicine address as first order information; the order generation module generates an order number and a serial number corresponding to the first order information; the order generation module integrates the first order information, the order number, and the serial number as the drug order.
The ID recognition processing module is used for judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table;
in one embodiment, the determining the order medicine ID change condition of the medicine order according to the medicine information table, the medicine order, and the medicine snapshot table includes: the ID recognition processing module reads the medicine information table, and searches a first modification time matched with the first medicine ID information in the medicine order in the medicine information table; the ID recognition processing module reads the medicine snapshot table, and queries second modification time of a first medicine snapshot ID matched with the first medicine ID information in the medicine order in the medicine snapshot table; the ID recognition processing module sets the condition of changing the order medicine ID to be consistent with the medicine ID or the medicine ID is changed according to the time consistency between the first modification time and the second modification time.
As one embodiment, the setting the order medicine ID change condition to be medicine ID coincidence or medicine ID presence change according to the time coincidence between the first modification time and the second modification time includes: the ID recognition processing module compares the first modification time with the second modification time; if the first modification time is the same as the second modification time, the ID recognition processing module sets the change condition of the order medicine ID as the medicine ID is consistent; and if the first modification time is different from the second modification time, the ID recognition processing module sets the condition of changing the ID of the ordered medicine as that the medicine ID is changed.
The transaction recording module is used for setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition; the transaction recording module records transaction information according to the transaction medicine table, the medicine order and the traceable snapshot ID;
as one embodiment, the setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition includes: the transaction record module responds to the change condition of the order medicine ID to create a second medicine snapshot ID for the medicine ID change, and takes the second medicine snapshot ID as the traceable snapshot ID; updating the traceable snapshot ID and the first drug ID information to the first drug snapshot ID in the drug snapshot table; and the transaction record module responds to the condition that the order medicine ID is changed to be consistent with the medicine ID, and takes the first medicine snapshot ID as the traceable snapshot ID.
As one embodiment, the transaction information recording according to the transaction medicine table, the medicine order, and the traceable snapshot ID includes: the transaction recording module records the traceable snapshot ID, the first medicine ID information and the serial number in the medicine order into the transaction medicine table.
Example 3
The present embodiment provides a computer-readable storage medium including:
the storage medium is used for storing computer software instructions for implementing the history information tracing method of the medicine vending machine described in the above embodiment 1, and the computer software instructions include a program for executing the program set for the history information tracing method of the medicine vending machine described above; specifically, the executable program may be built in the history information tracing system of the medicine vending machine described in embodiment 2, so that the history information tracing system of the medicine vending machine may implement the history information tracing method of the medicine vending machine described in embodiment 1 by executing the built-in executable program.
Further, the computer readable storage medium provided in the present embodiment may be any combination of one or more readable storage media, where the readable storage media includes an electric, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof.
Example 4
The present embodiment provides an electronic device, as shown in fig. 7, which may include: the device comprises a processor 1501, a communication interface 1502, a memory 1503 and a communication bus 1504, wherein the processor 1501, the communication interface 1502 and the memory 1503 are in communication with each other through the communication bus 1504.
A memory 1503 for storing a computer program;
the processor 1501 is configured to execute the computer program stored in the memory 1503 to implement the steps of the history information tracing method of the medicine vending machine described in the above embodiment 1.
As an embodiment of the present application, the communication bus mentioned by the above-mentioned terminal may be a peripheral component interconnect standard (Peripheral Component Interconnect, abbreviated as PCI) bus or an extended industry standard architecture (Extended Industry Standard Architecture, abbreviated as EISA) bus, or the like. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, only one thick line is shown in fig. 7, but not only one bus or one type of bus.
As an embodiment of the present application, a communication interface is used for communication between the terminal and other devices.
As an embodiment of the present application, the memory may include a random access memory (Random Access Memory, abbreviated as RAM) or may include a non-volatile memory (non-volatile memory), such as at least one disk memory. Optionally, the memory may also be at least one memory device located remotely from the aforementioned processor.
As an embodiment of the present application, the above-mentioned processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, abbreviated as CPU), a network processor (Network Processor, abbreviated as NP), and the like; but also digital signal processors (Digital Signal Processing, DSP for short), application specific integrated circuits (Application Specific Integrated Circuit, ASIC for short), field-programmable gate arrays (Field-Programmable Gate Array, FPGA for short) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
Compared with the prior art, the historical information tracing method, system, equipment and medium of the medicine vending machine can help a user or manager trace back the historical medicine purchasing information of the corresponding medicine under the condition that the medicine information is changed, so that the traceability and the information effectiveness of the medicine of the self-service medicine vending machine are ensured, the maintainability of the self-service medicine vending machine is improved, and the satisfaction of the user is easy to improve.
It should be understood that, in the various embodiments herein, the sequence number of each process described above does not mean the sequence of execution, and the execution sequence of each process should be determined by its functions and internal logic, and should not constitute any limitation on the implementation process of the embodiments herein.
It should also be understood that in embodiments herein, the term "and/or" is merely one relationship that describes an associated object, meaning that three relationships may exist. For example, a and/or B may represent: a exists alone, A and B exist together, and B exists alone. In addition, the character "/" herein generally indicates that the front and rear associated objects are an "or" relationship.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present disclosure.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, and are not repeated herein.
In the several embodiments provided herein, it should be understood that the disclosed systems, devices, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. In addition, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices, or elements, or may be an electrical, mechanical, or other form of connection.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the elements may be selected according to actual needs to achieve the objectives of the embodiments herein.
In addition, each functional unit in the embodiments herein may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solutions herein are essentially or portions contributing to the prior art, or all or portions of the technical solutions may be embodied in the form of a software product stored in a storage medium, including several instructions to cause 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 described in the embodiments herein. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing description is only illustrative of the present application and is not intended to limit the scope of the application, and all equivalent structures or equivalent processes or direct or indirect application in other related technical fields are included in the scope of the present application.
Claims (5)
1. The historical information tracing method of the medicine vending machine is characterized in that a database table structure is configured in the medicine vending machine, and a medicine information table and a transaction medicine table are stored in the database table structure, and the method comprises the following steps:
creating a medicine snapshot table corresponding to the medicine information table in the database table structure;
generating a drug order in response to a user purchasing a drug in the drug vending machine;
judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table;
setting a traceable snapshot ID according to the medicine snapshot table and the change condition of the order medicine ID; recording transaction information according to the transaction medicine table, the medicine order and the traceable snapshot ID;
the medicine information table stores medicine ID information corresponding to the medicine to be delivered and modification time corresponding to the medicine ID information; the medicine snapshot table stores medicine snapshot IDs corresponding to the medicine ID information and modification time corresponding to the medicine snapshot IDs;
the generating a drug order in response to a user purchasing a drug in the drug vending machine, comprising; confirming a first drug to be shipped for purchase in the drug vending machine; inquiring first medicine ID information, medicine names, medicine dosage forms, medicine specifications, medicine unit price, medicine batch numbers, medicine validity periods, medicine manufacturers, medicine quantity, medicine payable amount, medicine selling machine numbers and medicine addresses corresponding to the first to-be-shipped medicines in the medicine information table; integrating the first medicine ID information, the medicine name, the medicine dosage form, the medicine specification, the medicine unit price, the medicine lot number, the medicine expiration date, the medicine manufacturer, the medicine quantity, the medicine payable amount, the medicine vending machine number, and the medicine address as first order information; generating an order number and a serial number corresponding to the first order information; integrating the first order information, the order number and the serial number as the medicine order;
the step of judging the order medicine ID change condition of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table comprises the following steps: reading the medicine information table, and inquiring a first modification time matched with the first medicine ID information in the medicine order in the medicine information table; reading the medicine snapshot table, and inquiring second modification time of a first medicine snapshot ID matched with the first medicine ID information in the medicine order in the medicine snapshot table; setting the change condition of the order medicine ID to be consistent with the medicine ID or the medicine ID to be changed according to the time consistency between the first modification time and the second modification time;
the setting the change condition of the order medicine ID to be the medicine ID consistency or the medicine ID change according to the time consistency between the first modification time and the second modification time includes: comparing the first modification time with the second modification time; if the first modification time is the same as the second modification time, setting the change condition of the ID of the ordered medicine as the same as the ID of the medicine; if the first modification time is different from the second modification time, setting the change condition of the order medicine ID as that the medicine ID is changed;
the setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition includes: responding to the change condition of the order medicine ID to change the medicine ID, creating a second medicine snapshot ID, and taking the second medicine snapshot ID as the traceable snapshot ID; updating the traceable snapshot ID and the first drug ID information to the first drug snapshot ID in the drug snapshot table; and responding to the condition that the order medicine ID changes to be consistent with the medicine ID, and taking the first medicine snapshot ID as the traceable snapshot ID.
2. The method for tracing historical information of a medicine vending machine of claim 1, wherein:
the transaction information recording according to the transaction medicine table, the medicine order and the traceable snapshot ID includes:
and recording the traceable snapshot ID, the first medicine ID information and the serial number in the medicine order into the transaction medicine table.
3. A history information tracing system of a medicine vending machine based on a history information tracing method of a medicine vending machine according to claim 1, wherein a database table structure is configured in the medicine vending machine, and a medicine information table and a transaction medicine table are stored in the database table structure, characterized in that the system comprises: the system comprises a snapshot table creation module, an order generation module, an ID identification processing module and a transaction recording module;
the snapshot table creating module is used for creating a medicine snapshot table corresponding to the medicine information table in the database table structure;
the order generation module is used for responding to the purchase of medicines in the medicine vending machine by a user to generate a medicine order;
the ID recognition processing module is used for judging the change condition of the order medicine ID of the medicine order according to the medicine information table, the medicine order and the medicine snapshot table;
the transaction recording module is used for setting a traceable snapshot ID according to the medicine snapshot table and the order medicine ID change condition; and the transaction recording module records transaction information according to the transaction medicine table, the medicine order and the traceable snapshot ID.
4. A computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, and the computer program when executed by a processor implements the steps of the history information tracing method of the medicine vending machine according to any one of claims 1 or 2.
5. A computer device comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface, the memory complete communication with each other through the communication bus; wherein:
the memory is used for storing a computer program;
the processor is configured to execute the steps of the history information tracing method of the medicine vending machine according to any one of claims 1 or 2 by executing the program stored in the memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310725635.7A CN116469517B (en) | 2023-06-19 | 2023-06-19 | Historical information tracing method, system, equipment and medium of medicine vending machine |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310725635.7A CN116469517B (en) | 2023-06-19 | 2023-06-19 | Historical information tracing method, system, equipment and medium of medicine vending machine |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116469517A CN116469517A (en) | 2023-07-21 |
| CN116469517B true CN116469517B (en) | 2023-10-03 |
Family
ID=87182899
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310725635.7A Active CN116469517B (en) | 2023-06-19 | 2023-06-19 | Historical information tracing method, system, equipment and medium of medicine vending machine |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116469517B (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004318240A (en) * | 2003-04-11 | 2004-11-11 | Hitachi Ltd | Drug medicine information management system |
| CN203149640U (en) * | 2012-11-14 | 2013-08-21 | 西安联易信息技术有限公司 | Food and drug safety electronic regulatory system |
| CN205091834U (en) * | 2015-11-09 | 2016-03-16 | 陕西海隆智能科技有限公司 | Automatic medicine machine system sells |
| CN105447972A (en) * | 2015-11-09 | 2016-03-30 | 陕西海隆智能科技有限公司 | Automatic drug selling machine system |
| CN206711266U (en) * | 2017-04-01 | 2017-12-05 | 深圳怡化电脑股份有限公司 | Strip printer and financial self-service equipment |
| CN111597191A (en) * | 2020-03-16 | 2020-08-28 | 浙江明度智控科技有限公司 | Method and system for managing drug informatization tracing data |
| KR20210028868A (en) * | 2019-09-05 | 2021-03-15 | 주식회사 피피아이 | Method for providing return management service connecting pharmaceutical company to drugstore and providing medicine traceability in supply chain |
| CN112836150A (en) * | 2021-02-03 | 2021-05-25 | 捷玛计算机信息技术（上海）股份有限公司 | Identification method, system, equipment and medium for tracing code of medicine |
| CN114153788A (en) * | 2021-12-08 | 2022-03-08 | 浙江中控技术股份有限公司 | Traceable control method of actuator, actuator and control system |
| CN114297318A (en) * | 2021-12-14 | 2022-04-08 | 中金支付有限公司 | Data processing method and device |
| CN115099728A (en) * | 2022-08-25 | 2022-09-23 | 山东明河药业有限公司 | Medicine sales data management system and method |
| WO2022249802A1 (en) * | 2021-05-28 | 2022-12-01 | 一般社団法人企業防衛協会 | Traceability management server, traceability management system, traceability management program, recording medium and traceability management method |
| CN115438384A (en) * | 2022-07-26 | 2022-12-06 | 万达信息股份有限公司 | Internet drug delivery tracing method based on trusted data chain |
-
2023
- 2023-06-19 CN CN202310725635.7A patent/CN116469517B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004318240A (en) * | 2003-04-11 | 2004-11-11 | Hitachi Ltd | Drug medicine information management system |
| CN203149640U (en) * | 2012-11-14 | 2013-08-21 | 西安联易信息技术有限公司 | Food and drug safety electronic regulatory system |
| CN205091834U (en) * | 2015-11-09 | 2016-03-16 | 陕西海隆智能科技有限公司 | Automatic medicine machine system sells |
| CN105447972A (en) * | 2015-11-09 | 2016-03-30 | 陕西海隆智能科技有限公司 | Automatic drug selling machine system |
| CN206711266U (en) * | 2017-04-01 | 2017-12-05 | 深圳怡化电脑股份有限公司 | Strip printer and financial self-service equipment |
| KR20210028868A (en) * | 2019-09-05 | 2021-03-15 | 주식회사 피피아이 | Method for providing return management service connecting pharmaceutical company to drugstore and providing medicine traceability in supply chain |
| CN111597191A (en) * | 2020-03-16 | 2020-08-28 | 浙江明度智控科技有限公司 | Method and system for managing drug informatization tracing data |
| CN112836150A (en) * | 2021-02-03 | 2021-05-25 | 捷玛计算机信息技术（上海）股份有限公司 | Identification method, system, equipment and medium for tracing code of medicine |
| WO2022249802A1 (en) * | 2021-05-28 | 2022-12-01 | 一般社団法人企業防衛協会 | Traceability management server, traceability management system, traceability management program, recording medium and traceability management method |
| CN114153788A (en) * | 2021-12-08 | 2022-03-08 | 浙江中控技术股份有限公司 | Traceable control method of actuator, actuator and control system |
| CN114297318A (en) * | 2021-12-14 | 2022-04-08 | 中金支付有限公司 | Data processing method and device |
| CN115438384A (en) * | 2022-07-26 | 2022-12-06 | 万达信息股份有限公司 | Internet drug delivery tracing method based on trusted data chain |
| CN115099728A (en) * | 2022-08-25 | 2022-09-23 | 山东明河药业有限公司 | Medicine sales data management system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116469517A (en) | 2023-07-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9349122B2 (en) | System and method for programming point of sale devices | |
| US7324960B2 (en) | POS system | |
| CN110704486B (en) | Data processing method, device, system, storage medium and server | |
| CN103745333A (en) | Furniture safe circulation source tracing system and method based on cloud computing | |
| CN106156130B (en) | A kind of data processing method and device | |
| CN112380187A (en) | Inventory data monitoring method and device, computer equipment and storage medium | |
| CN116469517B (en) | Historical information tracing method, system, equipment and medium of medicine vending machine | |
| CN115456739B (en) | Data management method and related device | |
| NZ542567A (en) | Consignment inventory management and reconciliation system | |
| CN112907322B (en) | Order information processing method, device, platform, medium and program product | |
| US7464056B1 (en) | Method for managing customer financial accounts | |
| CN114819790A (en) | Intelligent store replenishment method and system based on big data | |
| CN112215543A (en) | Method and device for counting commodity inventory, terminal equipment and storage medium | |
| KR102713484B1 (en) | Information processing method for item in distribution system and electronic device | |
| CN117033450B (en) | Multi-dimensional data processing method and device, electronic equipment and storage medium | |
| CN114662520B (en) | Mobile phone accessory matching method and device, electronic equipment and storage medium | |
| KR100487276B1 (en) | Method and system for intermediating electronic commerce | |
| JP7471889B2 (en) | Information processing device, information processing program, and sales aggregation method | |
| TW201333851A (en) | App transaction money flow method and app store management method | |
| US20210406946A1 (en) | Information processing system, method, and medium | |
| US8285572B2 (en) | System and method for solution ordering by federation of order management systems and use of solution records | |
| EP4386648A1 (en) | Blockchain-based source-tracing method and system | |
| CN117290409A (en) | Method and device for generating rebate document, terminal equipment and storage medium | |
| CN117670254A (en) | Commodity sales management method, system and medium based on blockchain technology | |
| CN117875956A (en) | Unified payment processing method, system, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |