Electronic system storage method for cold chain data according to order and delivery starting and ending time

Abstract

The invention relates to the technical field of cold-chain logistics distribution, in particular to an electronic system storage method for cold-chain data according to orders and distribution starting and ending time, which at least comprises the following steps: associating the orders with the data, acquiring the cold-chain data in real time, and automatically recording and checking the distribution time by the system; meanwhile, setting an abnormal condition processing mechanism and a differential storage mechanism; storing the data in an electronized manner; and finally, automatically generating a compliance report. In the whole cold chain transportation process, refined and real-time management of high-professional products can be achieved, it is ensured that key factors such as temperature and humidity and time are effectively monitored, and the requirements of laws and regulations are met. According to the whole scheme, the traceability and automatic management of the whole process are realized from order generation, data acquisition, exception handling to compliance report generation.

Description

Technical Field

[0001] The present invention relates to the technical field of cold chain logistics distribution, and more specifically to a method for electronically storing cold chain data according to order and distribution start and end time. Background Art

[0002] Drug quality management is an important part of medical quality management and is the basic guarantee for the safe and effective clinical application of drugs. Temperature has a great impact on the stability of refrigerated and frozen drugs. In recent years, the automation and informatization of hospital drug management has been raised to a certain level, but the supervision level of refrigerated drug storage and transportation is obviously lagging behind. In many medical institutions, including large "three-class" hospitals, the storage and transportation of refrigerated drugs and the temperature and humidity data records are still at the level of manual records, and it is impossible to realize the warning and remote alarm when the refrigerated drug circulation time exceeds the time limit. The timeliness of the circulation process will directly affect the appearance, clarity change, crystallization, color difference and mildew of the contents during the storage of drugs.

[0003] At the same time, the country also has strict requirements for the control of temperature and humidity in the entire circulation of drugs. Article 47 of the new version of "Good Distribution Practice for Pharmaceuticals" (GSP) implemented on June 25, 2015 clearly stipulates that warehouses for storing drugs must have "automatic monitoring and recording equipment for warehouse temperature and humidity"; at the same time, Article 57 also stipulates that "a computer system that can meet the requirements of full-process management and quality control must be established to ensure that drug quality can be traced."

[0004] However, the inadequacy of existing management equipment will seriously affect the safety of refrigerated medicines in hospitals, so it is urgent to improve management levels and means.

[0005] For example, the traditional refrigeration process is implemented by manual recording, which cannot truly reflect the complete operating status of the equipment. The recorded data exists human factors. The existing cold chain monitoring platform functions are very complete, and there are many systems with order delivery functions, but the cold chain data can only be stored or exported electronically, and cannot be associated with the order and delivery time and saved in the system. Summary of the invention

[0006] In order to solve the above problems, the present invention solves the correlation between cold chain data and orders and distribution, truly realizes the effectiveness and correspondence of cold chain data, and can meet the unified electronic storage requirements of cold chain data, sales documents and certificates (batch issuance) required by policies and regulations such as the Drug Administration Law and the Vaccine Administration Law.

[0007] To achieve the above object, the present invention provides the following technical solutions, which mainly include:

[0008] A method for electronically storing cold chain data according to order and delivery start and end time, comprising at least the following steps: associating orders with data, collecting cold chain data in real time, and automatically recording and verifying delivery time; setting up an abnormal situation handling mechanism and a differentiated storage mechanism; storing data electronically; and finally automatically generating a compliance report.

[0009] Preferably, the method comprises the following steps:

[0010] S1. When the system receives an order, it automatically generates a unique order ID. After the order is generated by the order system, the system also creates an associated entry for the order ID in the cold chain monitoring module;

[0011] S2, configure temperature, humidity and environmental data sensors, and upload sensor data in real time;

[0012] S3. When the logistics departs and arrives, the system automatically generates a timestamp through the logistics management module. The system tracks the location of the transport vehicle in real time through GPS positioning technology to ensure that the transportation route meets expectations. When the vehicle arrives at the designated location, the system automatically records it as "delivered" and checks whether the actual arrival time matches the expected time;

[0013] S4. Set up abnormal situation handling mechanism and differentiated storage mechanism;

[0014] S5. The system automatically archives all cold chain data, orders and delivery times, and electronically stores them according to regulatory requirements. All cold chain data is encrypted using blockchain technology or digital signatures, and the exported data reports are all digitally signed;

[0015] S6. After each transport is completed, the system automatically generates a complete compliance report including order ID, cold chain data, delivery time and exception handling.

[0016] Preferably, in S1, each order ID is used as an associated subject and associated with the subsequent cold chain and delivery time. The cold chain data will be saved in real time according to the order ID to ensure that all data can be traced back to the specific order in the system.

[0017] Preferably, in S2, the system uploads the data collected by the sensors to the cold chain monitoring platform in real time through the Internet of Things technology, and associates it with the order ID; the data is collected every minute or less to ensure that all environmental changes during transportation can be recorded.

[0018] Preferably, in S4, the abnormal situation handling mechanism includes temperature and humidity abnormality warning, delay detection, and sealing detection and leakage monitoring; the differentiated handling mechanism is to perform special monitoring according to different transported products.

[0019] Preferably, the temperature and humidity abnormality warning includes system-set product-specific temperature and humidity thresholds. Once the sensor detects that the environmental data exceeds the normal range, the system automatically triggers an alarm and notifies relevant personnel to intervene. In the transportation of medicines, blood products, etc., temperature fluctuations exceeding the set range will trigger the abnormality handling procedure.

[0020] Preferably, delay detection includes when the delivery time exceeds expectations, the system automatically triggers an abnormal warning, records the cause of the delay, and confirms the actual situation through GPS location; the transportation personnel report the delay through mobile devices, the system records the delay time and cause, and initiates the emergency response process.

[0021] Preferably, the sealing detection and leakage monitoring system includes monitoring the container status through a sealing sensor. Once any leakage or sealing abnormality is detected, an alarm is automatically triggered, the transport vehicle is isolated, and emergency response personnel are notified.

[0022] Through the above technical solutions, we can see that compared with the existing technology, through the above step-by-step technical solutions, the entire cold chain transportation process can achieve refined and real-time management of highly professional products, ensure that key factors such as temperature, humidity, time, etc. are effectively monitored, and meet regulatory requirements. The entire solution, from order generation, data collection, exception handling to compliance report generation, has achieved full process traceability and automated management. DETAILED DESCRIPTION

[0023] The technical solutions in the embodiments of the present invention are described clearly and completely below. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0024] Embodiment 1

[0025] This example uses a large pharmaceutical company (referred to as "Pharmaceutical Company A") as an example. The company focuses on the production and distribution of vaccines and biological products. The challenge faced by Pharmaceutical Company A is to ensure that the temperature and humidity during cold chain transportation always meet the regulations to ensure the effectiveness and safety of vaccines.

[0026] Implementation steps

[0027] Step 1: Generate an order

[0028] Customer orders:

[0029] Pharmaceutical company A's customers place orders through the online system, requesting that a specific number of vaccines be delivered to a designated hospital. The order information is recorded by the system and a unique order ID (such as ORD1001) is generated.

[0030] System generated order:

[0031] The system automatically creates a database record containing customer information, product name, quantity and generation time.

[0032] To create an order via the API:

[0033]

[0034]

[0035] This API allows to create a new order, insert the order information into the database and return the generated order ID. The database connection uses psycopg2 for PostgreSQL operations.

[0036] Step 2: Cold chain data monitoring

[0037] Sensor Configuration:

[0038] Pharmaceutical company A installs high-precision temperature and humidity sensors on its delivery vehicles. The sensors collect environmental data in real time and upload the data to the monitoring platform through the Internet of Things technology.

[0039] Data Records:

[0040] At the beginning of transportation, the sensor monitors the temperature (set range 2°C to 8°C) and humidity (set range 60% to 70%) in real time and associates the data with the order ID. The API saves the cold chain monitoring data (such as temperature and humidity) to the database in real time. The sensor data can be obtained through the IoT interface. Here is the simulated data, which can be collected from the sensor interface in actual application.

[0041] The cold chain data collection module is as follows:

[0042]

[0043]

[0044] Step 3: Delivery time tracking

[0045] GPS Positioning:

[0046] Delivery vehicles are equipped with GPS devices to record the vehicle's location and route in real time.

[0047] Timestamp Records:

[0048] When a shipment is dispatched, the system automatically records the start time and the end time when it arrives at the destination, ensuring that every shipment has a clear time stamp.

[0049] The delivery time record and GPS positioning module are as follows:

[0050]

[0051] Step 4: Anomaly detection and emergency response

[0052] Real-time monitoring:

[0053] During transportation, the system monitors temperature and humidity data in real time.

[0054] Once the sensor detects that the temperature exceeds the set range (such as reaching 9°C), the system immediately issues an alarm to notify the transport personnel.

[0055] The system records the abnormal situation and notes it in the report.

[0056] Different sensors are set for detection according to the different items to be transported.

[0057] For example: medicines and vaccines:

[0058] Focus on monitoring temperature data to ensure it remains within the range of 2°C to 8°C;

[0059] The system evaluates the timing and magnitude of temperature fluctuations to determine if the product is still effective.

[0060] Blood products:

[0061] In addition to temperature monitoring, vibration monitoring is added to ensure that there is no severe physical impact during transportation;

[0062] Provide real-time feedback on delays. The transportation time must not exceed the set time limit. If it exceeds the time limit, the system will automatically mark it as abnormal.

[0063] Organ tissue:

[0064] Use an extremely low temperature sensor to maintain the organ below -80℃.

[0065] Cooperate with GPS and traffic management systems to ensure the priority of organ transportation and take emergency plans in case of delays.

[0066] Bacteria:

[0067] Monitor temperature and humidity changes, especially humidity, which needs to be kept accurate.

[0068] If environmental conditions deviate from the normal range, the system predicts their impact on bacterial activity and recommends further testing by the laboratory.

[0069] Toxins:

[0070] Focus on monitoring tightness and temperature to ensure there is no risk of leakage.

[0071] Multi-factor authentication is implemented to ensure that only authorized personnel can operate, and all operation records during transportation are encrypted and saved.

[0072] The API checks whether there are abnormal conditions where the temperature and humidity exceed the set range based on the cold chain data collected in real time. Once an abnormality is detected, the system returns an early warning message, which can trigger further emergency response.

[0073] The processing code is as follows:

[0074]

[0075] Step 5: Data Retention and Compliance

[0076] Electronic data storage:

[0077] All cold chain data, delivery time and exception handling records are automatically stored in the database and associated with the corresponding order ID.

[0078] Each data record is time-stamped to ensure traceability.

[0079] Generate compliance reports:

[0080] After delivery is completed, the system automatically generates a compliance report, including:

[0081] Order ID

[0082] Customer Name

[0083] Product Name

[0084] Temperature and humidity logging

[0085] Delivery time

[0086] Exception handling

[0087] The report is archived in PDF format and can be exported at any time for regulatory review.

[0088] Step 6: Generate a compliance report

[0089] Medical regulatory agencies regularly review the cold chain data of Pharmaceutical Company A to ensure that all transportation complies with the requirements of the Drug Administration Law and the Vaccine Administration Law.

[0090] The processing code is as follows:

[0091]

[0092] In this specification, each embodiment is described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the embodiments can be referred to each other. For the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part.

[0093] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for storing cold chain data in an electronic system according to order and delivery start and end time, characterized in that: At least the following steps are included: associating orders and data, and collecting cold chain data in real time, and the system automatically records and verifies delivery time; at the same time, setting up an abnormal situation handling mechanism and a differentiated storage mechanism; saving data electronically; and finally automatically generating a compliance report.

2. The electronic system storage method according to claim 1, characterized in that: The following steps are included: S1. When the system receives an order, it automatically generates a unique order ID. After the order is generated by the order system, the system also creates an associated entry for the order ID in the cold chain monitoring module; S2, configure temperature, humidity and environmental data sensors, and upload sensor data in real time; S3. When the logistics departs and arrives, the system automatically generates a timestamp through the logistics management module. The system uses GPS positioning technology to track the location of the transport vehicle in real time to ensure that the transport route meets expectations. When the vehicle arrives at the designated location, the system automatically records it as "delivered" and checks whether the actual arrival time matches the expected time; S4. Set up abnormal situation handling mechanism and differentiated storage mechanism; S5. The system automatically archives all cold chain data, orders and delivery times, and electronically stores them according to regulatory requirements. All cold chain data is encrypted using blockchain technology or digital signatures, and the exported data reports are all digitally signed; S6. After each transport is completed, the system automatically generates a complete compliance report including order ID, cold chain data, delivery time and exception handling.

3. The electronic system storage method according to claim 2, characterized in that: In S1, each order ID is used as an associated entity and associated with the subsequent cold chain and delivery time. The cold chain data will be saved in real time according to the order ID to ensure that all data can be traced back to the specific order in the system.

4. The electronic system storage method according to claim 2, characterized in that: In S2, the system uses IoT technology to upload the data collected by sensors to the cold chain monitoring platform in real time and associate it with the order ID; data is collected every minute or less to ensure that all environmental changes during transportation can be recorded.

5. The electronic system storage method according to claim 2, characterized in that: In S4, the abnormal situation handling mechanism includes temperature and humidity abnormality warning, delay detection, and sealing detection and leakage monitoring; the differentiated handling mechanism is to perform special monitoring according to the different products being transported.

6. The electronic system storage method according to claim 5, characterized in that: The temperature and humidity abnormality warning includes system-set product-specific temperature and humidity thresholds. Once the sensor detects that the environmental data exceeds the normal range, the system automatically triggers an alarm and notifies relevant personnel to intervene. In the transportation of medicines, blood products, etc., temperature fluctuations exceeding the set range will trigger the abnormal handling procedure.

7. The electronic system storage method according to claim 5, characterized in that: Delay detection includes when the delivery time exceeds expectations, the system automatically triggers an abnormal warning, records the cause of the delay, and confirms the actual situation through GPS location; the transportation personnel report the delay through mobile devices, the system records the delay time and cause, and initiates the emergency response process.

8. The electronic system storage method according to claim 5, characterized in that: The sealing detection and leakage monitoring system monitors the container status through the sealing sensor. Once any leakage or sealing abnormality is detected, the alarm is automatically triggered, the transport vehicle is isolated, and the emergency response personnel are notified.

Images