A dispensing liquid preparation management system and method based on flexible production

Abstract

The application belongs to the technical field of pharmaceutical production, and discloses a dispensing liquid preparation management system and method based on flexible production, which comprises a formula storage module, a formula editing module, a production management module and a production supervision module.The formula storage module stores formula information of multiple formulas.The formula editing module edits formula information of a production formula to be produced in a formula editing template through a visual operation interface, stores the production formula into the formula storage module after editing is completed, and transmits the production formula to the production management module.The production management module receives the production formula transmitted by the formula editing module, and issues the production formula to a production controller.The production controller sends a production instruction according to the production formula to a formula production line corresponding to the production formula.The production supervision module monitors a production process of the formula production line, and sends a running state of the formula production line and an abnormal condition in the production process to a visual operation interface.The application solves the problems of poor operability of a pharmaceutical liquid preparation system and low production efficiency of a production line.

Description

Technical Field

[0001] This invention belongs to the field of pharmaceutical manufacturing technology, specifically relating to a drug preparation management system and method based on flexible production. Background Technology

[0002] Pharmaceutical companies' liquid preparation production lines are characterized by multiple products and multiple batches, completing the production of different drugs at different stages according to market demand. In many cases, the program design is completed during the initial construction. After actual production, adjustments can be made to local process parameters, that is, the formula program is pre-set according to the company's known process requirements.

[0003] However, once a new product is launched, the process usually undergoes significant changes. For example, certain steps may become repetitive, or certain steps may be skipped, allowing direct jumps to the next step. Companies often need to engage the original integrator to upgrade the system, add relevant process control procedures, and establish new formulas. This presents bottlenecks to the company's development in terms of timeliness, flexibility, and investment. Therefore, providing a pharmaceutical preparation management system and method based on flexible production to greatly increase the operability and flexibility of pharmaceutical preparation systems, and to promptly identify the cause and restore production when anomalies occur on the production line, is an urgent problem to be solved.

[0004] In addition, existing drug preparation and liquid production lines usually need to transmit production formulas via network. If the production formula is transmitted directly over the network, there is a risk of leakage. If the production formula is transmitted in encrypted form, it needs to be decrypted before it can be used, which takes a lot of time for both encryption and decryption. There is currently a lack of a method to solve the above-mentioned technical problems simultaneously on drug preparation and liquid production lines. Summary of the Invention

[0005] To address the aforementioned technical problems, this invention provides a drug preparation and dispensing management system and method based on flexible production. This system and method enable manufacturing enterprises to edit and modify drug formulas, supervise and manage the production process, promptly identify and resolve problems, and improve the production efficiency of the pharmaceutical preparation system.

[0006] In a first aspect, the present invention provides a drug preparation and liquid preparation management system based on flexible production. The system includes: a visual operation interface, a formula storage module, a formula editing module, a production management module, and a production monitoring module. The visual operation interface is connected to the formula storage module, the formula editing module, the production management module, and the production monitoring module, respectively.

[0007] The formula storage module stores formula information for multiple formulas. The formula information includes material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step. The above formulas are input through the formula editing module.

[0008] The formula editing module receives editing instructions from users through a visual operation interface. Users can edit the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step in the formula editing template. After editing, the production formula is stored in the formula storage module and then transmitted to the production management module. The formula editing template is a template that is pre-stored in the formula editing module to facilitate users in editing formulas.

[0009] The production management module is used to manage and control the production of production formulas. It receives production formulas transmitted by the formula editing module and sends the production formulas to the production controller. The production controller sends production instructions to the formula production line corresponding to the production formula according to the production formula.

[0010] The production monitoring module is used to monitor the production process of the formula production line, send the operating status of the formula production line and abnormal conditions in the production process to the visual operation interface, and store the above operating status and abnormal conditions in the production management module.

[0011] Specifically, the formula editing module retrieves the first formula from the formula storage module and modifies the material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step according to user requirements to obtain the production formula to be produced.

[0012] Specifically, the production monitoring module includes a production information acquisition unit, a sensor information storage unit, an anomaly information unit, an anomaly prediction unit, a repair information unit, and a display control unit;

[0013] The production information acquisition unit acquires the monitoring information of the sensors installed on each piece of equipment in the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information.

[0014] The sensor information storage unit is also used to store the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the parameters of the equipment includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself.

[0015] The abnormal information unit obtains the abnormal information of the sensor by comparing the above-mentioned regulatory information with the above-mentioned normal range information. Based on the sensor number, it obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit, and obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit based on the sensor number.

[0016] The display control unit is used to send regulatory information to the visual operation interface, and when an abnormal situation occurs, it sends the device location, the corresponding abnormal information, the abnormal result information, the abnormal cause information, and the repair method information to the visual operation interface on a device-by-device basis.

[0017] Specifically, abnormal information includes abnormal vibration, pressure reduction, pressure increase, temperature rise, and abnormal process parameters.

[0018] Specifically, the display control unit is also used to obtain the start time, end time, and changes in the monitoring information during the time period between the start and end times of the abnormal information from the abnormal information unit, generate an abnormal curve based on the start time, end time, and changes, and send the abnormal curve to the visualization operation interface.

[0019] Specifically, it also includes a permissions management module for managing the operating permissions of operators;

[0020] The operator responsible for editing the formula has the authority to view the formulas in the formula storage module, view the information in the production management module, and view the operating status and abnormal conditions of the production monitoring module.

[0021] The operators responsible for production management have the authority to view the recipes in the recipe storage module and to view the operating status and abnormal conditions of the production monitoring module.

[0022] Secondly, the present invention also provides a method for managing drug preparation and solution preparation based on flexible production, the method comprising the following steps:

[0023] Step 1: Open the formula editing module through the visual operation interface. In the formula editing template, edit the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step of the production formula to be produced. After completing the editing, store the production formula in the formula storage module and transfer the production formula to the production management module. The formula editing template is a template that is pre-stored in the formula editing module to facilitate users to edit the formula.

[0024] Step 2: The production management module receives the production formula transmitted by the formula editing module and sends the production formula to the production controller. The production controller then sends a production instruction to the production line corresponding to the production formula based on the production formula.

[0025] Step 3: The production monitoring module monitors the production process of the formula production line, sends the operating status of the formula production line and any abnormal conditions during the production process to the visual operation interface, and stores the operating status and abnormal conditions in the production management module.

[0026] Specifically, in step 3, the production monitoring module monitors the production process of the formula production line, including the following steps:

[0027] Step 3.1: The sensor information storage unit stores the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the equipment parameters includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself.

[0028] Step 3.2: The production information acquisition unit acquires the monitoring information of the sensors installed on each device in the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information.

[0029] Step 3.3: The abnormal information unit obtains the abnormal information of the sensor by comparing the above-mentioned regulatory information with the above-mentioned normal range information. Based on the sensor number, it obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit. Based on the sensor number, it obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit.

[0030] Step 3.4: The display control unit sends the above-mentioned monitoring information to the visual operation interface, and when an abnormal situation occurs, it sends the location of the device and the corresponding abnormal information, abnormal result information, abnormal cause information, and repair method information to the visual operation interface on a device-by-device basis.

[0031] Specifically, the display control unit obtains the start time, end time, and changes in the monitoring information within the time period between the start and end times of the abnormal information from the abnormal information unit. Based on the start time, end time, and changes, an abnormal curve is generated and sent to the visualization operation interface.

[0032] Specifically, the recipe editing module transmits the production recipe to the production management module in encrypted form, including the following steps:

[0033] Step 1: Set up encrypted transmission information for the correspondence between different formula editing modules and production management modules. The correspondence includes the communication addresses of the formula editing module and the production management module, and the encrypted transmission information includes the location data for encrypting the production formula and the encryption key.

[0034] Step 2: The formula editing module searches for matching encrypted transmission information based on the communication address of the production management module that will send the production formula. The formula editing module then divides the production formula into different production formula blocks and sequentially numbers each production formula block.

[0035] Step 3: The recipe editing module extracts the corresponding production recipe block as the first data based on the location data in the encrypted transmission information, i.e. the production recipe block number, and uses all other production recipe blocks as the second data. The production recipe blocks in the first data and the second data are randomly arranged according to their numbers. At the same time, the order of the numbers corresponding to the production recipe blocks in the first data and the second data, as well as the decryption key corresponding to the encryption key, are added to the first data.

[0036] Step 4: The recipe editing module uses the public key of the production management module to encrypt the first data to obtain the first encryption result, and uses the encryption key to encrypt the second data to obtain the second encryption result. The first encryption result and the second encryption result are combined to form the sending data, and the sending data is also sent to the corresponding production management module.

[0037] Compared with the prior art, the beneficial effects of the present invention are at least as follows:

[0038] 1. This invention discloses a drug preparation management system and method based on flexible production. Pharmaceutical manufacturers can edit and modify drug formulas through a visual operation interface according to production needs, monitor the drug production process in real time, and promptly detect problems, identify causes, and restore production when abnormalities occur on the production line. This increases the operability and flexibility of pharmaceutical preparation and improves production efficiency.

[0039] 2. This invention limits the time for operators to use their management permissions, preventing the malicious use of permissions corresponding to an account when it is stolen. This solves the problem in the prior art where, when an operator's account is stolen, the person who stole the account uses the management permissions corresponding to the account to tamper with data information.

[0040] 3. This invention addresses the common practice in pharmaceutical preparation production lines of transmitting production formulas via network. To ensure the confidentiality of these formulas and prevent their illegal theft during transmission, a method for encrypting and transmitting production formulas between the formula editing module and the production management module is implemented. This method also reduces the time required for encrypting and decrypting the production formulas. In other words, while ensuring the data security of the production formulas, the time required for encryption and decryption is shortened, thereby achieving the goal of ensuring that encrypted transmission of production formulas does not delay the production management module's control over the production line. Attached Figure Description

[0041] Figure 1 This is a schematic diagram of a drug preparation and liquid preparation management system based on flexible production according to the present invention;

[0042] Figure 2 This is a schematic diagram of the production monitoring module of the drug preparation and liquid preparation management system of the present invention;

[0043] Figure 3 This is a flowchart of a drug preparation and solution management method based on flexible production according to the present invention;

[0044] Figure 4 This is a flowchart illustrating the encrypted transmission of production recipes from the recipe editing module to the production management module in this invention.

[0045] Figure 5 This is an example diagram illustrating the encrypted transmission of production recipes from the recipe editing module to the production management module in this invention. Detailed Implementation

[0046] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. Obviously, the specific embodiments described herein are merely illustrative of the invention and represent only a portion, not all, of the embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without inventive effort are within the scope of protection of this invention.

[0047] Example 1

[0048] Figure 1 The diagram shown is a structural schematic of an embodiment of a drug preparation and liquid formulation management system based on flexible production provided by the present invention. Figure 1 As shown, the system includes: a visual operation interface, a formula storage module, a formula editing module, a production management module, and a production monitoring module. The visual operation interface is connected to the formula storage module, the formula editing module, the production management module, and the production monitoring module, respectively.

[0049] The formula storage module stores formula information for multiple formulas. The formula information includes material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step. The above formulas are input through the formula editing module.

[0050] Specifically, formulation information refers to information such as materials, equipment, processes, production steps, and production technology used in the production of a drug. For example, material type information includes the names of the drug's raw materials, excipients, and packaging materials; process parameter information includes parameters such as solution temperature, solution pH, mixing time, particle size, number of feedings, drying time, sterilization temperature, sterilization time, and dimensions during drug production.

[0051] The formula editing module receives editing instructions from users through a visual operation interface. Users can edit the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step in the formula editing template. After editing, the production formula is stored in the formula storage module and then transmitted to the production management module. The formula editing template is a template that is pre-stored in the formula editing module to facilitate users in editing formulas.

[0052] Specifically, the formula editing module can also retrieve a first formula from the formula storage module. Based on user needs, it can modify the material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step of the first formula to obtain the production formula to be produced. The first formula is similar to or closely related to the production formula to be edited by the formula editing module. For example, when the drug formula to be produced is an upgraded version of a previously produced formula, the previously produced formula can be retrieved from the formula storage module. Modifications can be made based on the formula information of that formula to obtain the production formula to be produced. Adjusting based on existing formula information is more convenient, time-saving, and labor-saving.

[0053] The production management module is used to manage and control the production of production formulas. It receives production formulas transmitted by the formula editing module and sends the production formulas to the production controller. The production controller then sends production instructions to the production line corresponding to the production formula based on the production formula.

[0054] Specifically, in actual production applications, pharmaceutical companies typically have multiple formulation production lines, each used to produce similar or related types of drugs. The production management module manages each formulation production line through a production controller. Similar or related types of drugs use the same or similar equipment, production steps, and operating procedures in their production processes. When the controller receives a production formulation, it sends the formulation to the corresponding formulation production line based on the formulation information and sends a production instruction. For example, when the production controller receives a production formulation, it displays information about the formulation production lines that can be used for production through a visual interface, and sends the production formulation and production instruction to the production line based on the operator's selection.

[0055] The production monitoring module is used to monitor the production process of the formula production line, send the operating status of the formula production line and abnormal conditions in the production process to the visual operation interface, and store the above operating status and abnormal conditions in the production management module.

[0056] For example, a schematic diagram of the production monitoring module of the drug preparation and liquid preparation management system of the present invention is shown below. Figure 2 As shown, it should be noted that Figure 2 The production monitoring module shown is an example illustration, intended only to illustrate the technical solution of the embodiments of this application, and does not constitute a limitation on the technical solution of the embodiments of this application. In practical applications, those skilled in the art can configure it according to actual needs.

[0057] like Figure 2 As shown, the production monitoring module includes: a production information acquisition unit, a sensor information storage unit, an anomaly information unit, an anomaly prediction unit, a repair information unit, and a display control unit.

[0058] The production information acquisition unit acquires the monitoring information of the sensors installed on each piece of equipment in the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information.

[0059] Specifically, each sensor on the formula production line corresponds to a different device, and the regulatory information of the corresponding device can be obtained by checking the sensor number.

[0060] The sensor information storage unit is also used to store the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the parameters of the equipment includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself.

[0061] For example, the performance parameters of the equipment include the equipment's temperature, vibration frequency, pressure, etc.

[0062] The abnormal information unit obtains abnormal information of the sensor by comparing the above-mentioned regulatory information with the above-mentioned normal range information. Based on the sensor number, it obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit, and based on the sensor number, it obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit.

[0063] Specifically, abnormal information includes abnormal vibration, pressure reduction, pressure increase, temperature rise, and abnormal process parameters.

[0064] Specifically, the anomaly prediction unit sets the possible abnormal result information for each type of predictable anomaly information based on the sensor's serial number, and stores the sensor's serial number, the anomaly information, and the abnormal result information in a related manner within the anomaly prediction unit. For example, the abnormal result information corresponding to the anomaly information can be set by those skilled in the art based on experience; if the abnormal result information corresponding to the anomaly information is missing, the anomaly prediction unit can automatically download the corresponding abnormal result information from the Internet based on the anomaly information, and associate the selection result with the anomaly information based on the operator's operation.

[0065] Specifically, the repair information unit sets the cause and repair method for each predictable anomaly based on the sensor's identification number, and stores the sensor's identification number, anomaly information, anomaly cause, and repair method in a linked manner within the repair information unit. For example, the anomaly cause and repair method corresponding to the anomaly information can be set by those skilled in the art based on experience; if the anomaly cause and repair method corresponding to the anomaly information are missing, the repair information unit can automatically download the corresponding anomaly cause and repair method from the internet based on the anomaly information, and associate the selection result with the anomaly information based on the operator's actions.

[0066] Specifically, each sensor corresponds to a different device, which in turn corresponds to a different process. Each process has different requirements for the operating procedures or process parameters of the materials or medicines to be processed. Therefore, it is necessary to set different abnormal results, abnormal causes, and repair methods for different sensors.

[0067] The display control unit is used to send regulatory information to the visual operation interface, and when an abnormal situation occurs, it sends the device location, the corresponding abnormal information, the abnormal result information, the abnormal cause information, and the repair method information to the visual operation interface on a device-by-device basis.

[0068] Specifically, during the production process of the formula production line, the production monitoring module sends monitoring information to the visual operation interface. The visual operation interface displays the real-time operating status of the formula production line in a specific area. When an abnormal situation occurs during production, a notification is issued for that abnormal situation on a per-equipment basis. The aforementioned specific area is set by those skilled in the art based on experience, and can be customized according to actual needs.

[0069] For example, the upper half of the display screen of the visual operation interface displays a dynamic flowchart of all processes of the formula production line in the form of an assembly line. Each piece of equipment is marked with an icon in the corresponding position according to the production steps. For example, the formula production line includes four steps in sequence: 1, 2, 3, and 4. The equipment corresponding to the four steps are equipment A, equipment B, equipment C, and equipment D, respectively. Then, the icons of equipment A, equipment B, equipment C, and equipment D are marked on the dynamic flowchart in the order of 1-2-3-4. When an abnormal situation occurs at equipment C, the icon of equipment C is turned red. At the same time, the abnormal situation of equipment C is displayed in the lower half of the display screen. For example, "Sensor 3 Equipment C 10:00 Pressure value is low. Loosening of the tablets is caused by mechanical factors. The pressure is too low. Adjust the pressure." That is to say, at equipment C, the pressure value is low starting at 10 o'clock, which will cause loose tablets. This is caused by the pressure of the mechanical pressure machine being too low. The mechanical pressure at equipment C needs to be adjusted. For example, hyperlinks are added to the equipment icons in the dynamic flow diagram of the formulation production line. When the equipment malfunctions, clicking on the equipment displays the malfunction information, malfunction result information, malfunction cause information, and repair methods in a specific area of ​​the visual operation interface. This specific area is set by those skilled in the art based on experience. For example, hyperlinks are added to the equipment icons in the dynamic flow diagram of the formulation production line. When the equipment malfunctions, the standard processing time for the malfunction is displayed on the equipment icon, with different standard processing times set for different malfunctions.

[0070] For example, there can be multiple abnormal results corresponding to abnormal information, and there can also be multiple abnormal causes corresponding to each abnormal result. Each abnormal result, the abnormal cause corresponding to each abnormal result, and the repair method corresponding to each abnormal cause can be displayed together in the visual operation interface.

[0071] Specifically, the display control unit is also used to obtain the start time, end time, and changes in the monitoring information during the time period between the start and end times of the abnormal information from the abnormal information unit, generate an abnormal curve based on the start time, end time, and changes, and send the abnormal curve to the visualization operation interface.

[0072] The visual operation interface displays anomaly curves when equipment malfunctions, allowing operators to monitor ongoing anomalies in real time and take appropriate actions based on changes in the anomaly. It also facilitates operator analysis of anomalies, enabling proactive preventative measures to avoid recurrence.

[0073] Specifically, the drug preparation and liquid preparation management system of the present invention also includes an access control module for managing the operating permissions of operators.

[0074] The operator responsible for editing the formula has the authority to view the formulas in the formula storage module, view the information in the production management module, and view the operating status and abnormal conditions of the production monitoring module.

[0075] The operators responsible for production management have the authority to view the recipes in the recipe storage module and to view the operating status and abnormal conditions of the production monitoring module.

[0076] Operators who edit formulas have the authority to edit formulas, view formulas, view production information, and view regulatory information. Operators responsible for production management have the authority to view formulas, view production information, and view regulatory information.

[0077] Figure 3 The diagram shown is a flowchart of an embodiment of a drug preparation and solution management method based on flexible production provided by the present invention. The flowchart specifically includes:

[0078] Step 1: Open the formula editing module through the visual operation interface. In the formula editing template, edit the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step of the production formula to be produced. After completing the editing, store the production formula in the formula storage module and transfer the production formula to the production management module. The formula editing template is a template that is pre-stored in the formula editing module to facilitate users to edit the formula.

[0079] Specifically, formulation information refers to information such as materials, equipment, processes, production steps, and production technology used in the production of a drug. For example, material type information includes the names of the drug's raw materials, excipients, and packaging materials; process parameter information includes parameters such as solution temperature, solution pH, mixing time, particle size, number of feedings, drying time, sterilization temperature, sterilization time, and dimensions during drug production.

[0080] Specifically, the formula editing module can also retrieve a first formula from the formula storage module. Based on user needs, it can modify the material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step of the first formula to obtain the production formula to be produced. The first formula is similar to or closely related to the production formula to be edited by the formula editing module. For example, when the drug formula to be produced is an upgraded version of a previously produced formula, the previously produced formula can be retrieved from the formula storage module. Modifications can be made based on the formula information of that formula to obtain the production formula to be produced. Adjusting based on existing formula information is more convenient, time-saving, and labor-saving.

[0081] Step 2: The production management module receives the production formula transmitted by the formula editing module and sends the production formula to the production controller. The production controller then sends a production instruction to the production line corresponding to the production formula based on the production formula.

[0082] Specifically, in actual production applications, pharmaceutical companies typically have multiple formulation production lines, each used to produce similar or related types of drugs. The production management module manages each formulation production line through a production controller. Similar or related types of drugs use the same or similar equipment, production steps, and operating procedures in their production processes. When the controller receives a production formulation, it sends the formulation to the corresponding formulation production line based on the formulation information and sends a production instruction. For example, when the production controller receives a production formulation, it displays information about the formulation production lines that can be used for production through a visual interface, and sends the production formulation and production instruction to the production line based on the operator's selection.

[0083] Step 3: The production monitoring module monitors the production process of the formula production line, sends the operating status of the formula production line and any abnormal conditions during the production process to the visual operation interface, and stores the operating status and abnormal conditions in the production management module.

[0084] Specifically, in step 3, the production monitoring module monitors the production process of the formula production line, including the following steps:

[0085] Step 3.1: The sensor information storage unit stores the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the equipment parameters includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself.

[0086] For example, the performance parameters of the equipment include the equipment's temperature, vibration frequency, pressure, etc.

[0087] Step 3.2: The production information acquisition unit acquires the monitoring information of the sensors installed on each piece of equipment in the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information.

[0088] Specifically, each sensor on the formulation production line corresponds to a different piece of equipment, and the regulatory information for that equipment can be obtained by checking the sensor's serial number.

[0089] Step 3.3: The abnormal information unit obtains the abnormal information of the sensor by comparing the above-mentioned regulatory information with the above-mentioned normal range information. Based on the sensor number, it obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit. Based on the sensor number, it obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit.

[0090] Specifically, abnormal information includes abnormal vibration, pressure reduction, pressure increase, temperature rise, and abnormal process parameters.

[0091] Specifically, the anomaly prediction unit sets the possible abnormal result information for each type of predictable anomaly information based on the sensor's serial number, and stores the sensor's serial number, the anomaly information, and the abnormal result information in a related manner within the anomaly prediction unit. For example, the abnormal result information corresponding to the anomaly information can be set by those skilled in the art based on experience; if the abnormal result information corresponding to the anomaly information is missing, the anomaly prediction unit can automatically download the corresponding abnormal result information from the Internet based on the anomaly information, and associate the selection result with the anomaly information based on the operator's operation.

[0092] Specifically, the repair information unit sets the cause and repair method for each predictable anomaly based on the sensor's identification number, and stores the sensor's identification number, anomaly information, anomaly cause, and repair method in a linked manner within the repair information unit. For example, the anomaly cause and repair method corresponding to the anomaly information can be set by those skilled in the art based on experience; if the anomaly cause and repair method corresponding to the anomaly information are missing, the repair information unit can automatically download the corresponding anomaly cause and repair method from the internet based on the anomaly information, and associate the selection result with the anomaly information based on the operator's actions.

[0093] Specifically, each sensor corresponds to a different device, which in turn corresponds to a different process. Each process has different requirements for the operating procedures or process parameters of the materials or medicines to be processed. Therefore, it is necessary to set different abnormal results, abnormal causes, and repair methods for different sensors.

[0094] Step 3.4: The display control unit sends the above-mentioned monitoring information to the visual operation interface, and when an abnormal situation occurs, it sends the location of the device and the corresponding abnormal information, abnormal result information, abnormal cause information, and repair method information to the visual operation interface on a device-by-device basis.

[0095] Specifically, during the production process of the formula production line, the production monitoring module sends monitoring information to the visual operation interface. The visual operation interface displays the real-time operating status of the formula production line in a specific area. When an abnormal situation occurs during production, a notification is issued for that abnormal situation on a per-equipment basis. The aforementioned specific area is set by those skilled in the art based on experience, and can be customized according to actual needs.

[0096] For example, the upper half of the display screen of the visual operation interface displays a dynamic flowchart of all processes of the formula production line in the form of an assembly line. Each piece of equipment is marked with an icon in the corresponding position according to the production steps. For example, the formula production line includes four steps in sequence: 1, 2, 3, and 4. The equipment corresponding to the four steps are equipment A, equipment B, equipment C, and equipment D, respectively. Then, the icons of equipment A, equipment B, equipment C, and equipment D are marked on the dynamic flowchart in the order of 1-2-3-4. When an abnormal situation occurs at equipment C, the icon of equipment C is turned red. At the same time, the abnormal situation of equipment C is displayed in the lower half of the display screen. For example, "Sensor 3 Equipment C 10:00 Pressure value is low. Loosening of the tablets is caused by mechanical factors. The pressure is too low. Adjust the pressure." That is to say, at equipment C, the pressure value is low starting at 10 o'clock, which will cause loose tablets. This is caused by the pressure of the mechanical pressure machine being too low. The mechanical pressure at equipment C needs to be adjusted. For example, hyperlinks are added to the equipment icons in the dynamic flow diagram of the formulation production line. When the equipment malfunctions, clicking on the equipment displays the malfunction information, malfunction result information, malfunction cause information, and repair methods in a specific area of ​​the visual operation interface. This specific area is set by those skilled in the art based on experience. For example, hyperlinks are added to the equipment icons in the dynamic flow diagram of the formulation production line. When the equipment malfunctions, the standard processing time for the malfunction is displayed on the equipment icon, with different standard processing times set for different malfunctions.

[0097] For example, there can be multiple abnormal results corresponding to abnormal information, and there can also be multiple abnormal causes corresponding to each abnormal result. Each abnormal result, the abnormal cause corresponding to each abnormal result, and the repair method corresponding to each abnormal cause can be displayed together in the visual operation interface.

[0098] Specifically, the display control unit is also used to obtain the start time, end time, and changes in the monitoring information during the time period between the start and end times of the abnormal information from the abnormal information unit, generate an abnormal curve based on the start time, end time, and changes, and send the abnormal curve to the visualization operation interface.

[0099] The visual operation interface displays anomaly curves when equipment malfunctions, allowing operators to monitor ongoing anomalies in real time and take appropriate actions based on changes in the anomaly. It also facilitates operator analysis of anomalies, enabling proactive preventative measures to avoid recurrence.

[0100] Specifically, the operators responsible for editing formulas have the authority to view formulas in the formula storage module, information in the production management module, and the operating status and abnormal conditions of the production monitoring module.

[0101] The operators responsible for production management have the authority to view the recipes in the recipe storage module and to view the operating status and abnormal conditions of the production monitoring module.

[0102] Operators who edit formulas have the authority to edit formulas, view formulas, view production information, and view regulatory information. Operators responsible for production management have the authority to view formulas, view production information, and view regulatory information.

[0103] Example 2

[0104] The inventors discovered in practical production applications that when operators are granted certain management permissions, and their accounts are stolen, the thieves can use those permissions to tamper with data. To solve this problem, the inventors limited the time operators could use their management permissions, preventing malicious use of those permissions when an account is stolen.

[0105] The method for limiting the usage time of management permissions according to the present invention includes the following steps:

[0106] Step 1: Obtain the number of management accounts that have set specific permissions and the number of times that specific permission has been used. Calculate the usage frequency of the specific permission based on the number of management accounts and the number of times it has been used. The number of times the specific permission has been used is the total number of times the management accounts that have set the specific permission have used the specific permission within a certain period up to the current time.

[0107] Specifically, if the number of managed accounts is A and the number of uses is B, then the usage frequency is... The more frequently a permission is used, the more important it is.

[0108] For example, if the number of managed accounts is 5, and the number of times that specific permission has been used in the past 20 days is 60, then the frequency of use of that specific permission is 60 / 5 = 12.

[0109] Step 2: Obtain the average interval between each management account using the aforementioned specific permission, and calculate the effective time of the specific permission based on the average interval and the usage frequency. The average interval is the average time between the last time a management account used the specific permission and the last time it used the specific permission.

[0110] Specifically, if the average interval is C, then the effective time of this specific permission is... Where x is any natural number, and lgK = I represents the importance of this specific permission.

[0111] To prevent the effective time T1 from becoming negative, the value of the importance level I of the specific permission is adjusted. For example, the upper limit of the importance level I of the specific permission is set to 3. If lgK is a value greater than 3, then 3 is set as the importance level of the specific permission, and the effective time of the specific permission is calculated using 3 as the importance level. It should be noted that the upper limit of the importance level I of the specific permission is set by those skilled in the art based on the actual application scenario.

[0112] Furthermore, the duration of the validity period can be changed by adjusting the value of x. For example, frequently used permissions are more important, and the value of x can be adjusted to have a shorter validity period. For example, system administrators can adjust the value of x to be less for frequently used permissions than for less frequently used permissions.

[0113] Step 3: Obtain the most recent usage interval for any management account corresponding to the aforementioned specific permission, and determine whether this most recent interval is greater than the aforementioned valid time. The most recent usage interval is the time interval between the last time the management account used this specific permission and the time of its last use of this specific permission.

[0114] Step 4: If the recent usage interval is longer than the effective time, delete the specific permissions of any of the above management accounts.

[0115] Example 3

[0116] In practical application of the drug preparation management system and method based on flexible production as described in Embodiments 1 and 2 above, the inventors discovered that the formula editing module frequently sends production formulas to the production management module, and the formula editing module does not encrypt the production formulas. That is, plaintext data is always used in the communication process between the formula editing module and the production management module, which may lead to the leakage of production formulas. However, production formulas have obvious confidentiality and their data security should be strictly guaranteed. At the same time, if the formula editing module first encrypts the production formula and then sends the encrypted production formula to the production management module, the production management module also needs to decrypt the encrypted result before it can send the production formula to the production controller. Only then can the production controller send production instructions to the corresponding formula production line according to the production formula. If the amount of production formula data transmitted is large, the encryption and decryption of the production formula will take a lot of time, which will result in the inability to control the formula production line to start production in a timely manner. If the frequency of transmitting production formulas is high, the encryption and decryption time should also be short in order to control the formula production line to start production in a timely manner.

[0117] To further address the aforementioned technical problems, Embodiment 3 proposes the following... Figure 4 The following steps are shown:

[0118] Step 1: Set up encrypted transmission information for the correspondence between different formula editing modules and production management modules. The correspondence includes the communication addresses of the formula editing module and the production management module, and the encrypted transmission information includes the location data for encrypting the production formula and the encryption key.

[0119] Step 2: The formula editing module searches for matching encrypted transmission information based on the communication address of the production management module that will send the production formula. The formula editing module then divides the production formula into different production formula blocks and sequentially numbers each production formula block.

[0120] Step 3: The recipe editing module extracts the corresponding production recipe block as the first data based on the location data in the encrypted transmission information, i.e. the production recipe block number, and uses all other production recipe blocks as the second data. The production recipe blocks in the first data and the second data are randomly arranged according to their numbers. At the same time, the order of the numbers corresponding to the production recipe blocks in the first data and the second data, as well as the decryption key corresponding to the encryption key, are added to the first data.

[0121] Step 4: The recipe editing module uses the public key of the production management module to encrypt the first data to obtain the first encryption result, and uses the encryption key to encrypt the second data to obtain the second encryption result. The first encryption result and the second encryption result are combined to form the sending data, and the sending data is also sent to the corresponding production management module.

[0122] Specifically, to facilitate understanding of the processes from steps 1 to 4 above, the following is given: Figure 5 The example diagram shows that the production formula is divided into production formula blocks 1 to N. The first data includes production formula blocks 3 and 1, and a decryption key corresponding to the encryption key in the encrypted transmission information. The second data includes production formula blocks N, ..., production formula blocks 2 and 4. In particular, the first data also includes the numbering sequence corresponding to each production formula block in the first and second data, i.e., 3, 1, N, ..., 2, 4. The first data is encrypted with the public key of the production management module to obtain the first encryption result. The second data is encrypted with the encryption key in the encrypted transmission information to obtain the second encryption result. Finally, the first encryption result and the second encryption result are combined to obtain the transmitted data.

[0123] Furthermore, the recipe editing module sends the aforementioned data to the production management module through the following steps:

[0124] Step 1: The recipe editing module divides the data to be sent into a pre-defined number of data blocks.

[0125] Step 2: For the first data block to be sent, generate random data as seed data, divide the seed data into a predetermined number of seed data blocks, and calculate the XOR result of each pair of different seed data blocks. Then, concatenate the results of each XOR calculation to form the initial sending key. Repeat the method of generating the initial sending key until the data length of the initial sending key meets the predetermined requirements. Select data with a predetermined length starting from a predetermined position from the initial sending key as the sending key. Encrypt the first data block to be sent using the sending key and send the encryption result to the production management module.

[0126] Step 3: For the second data block, use the sending key of the first data block as seed data, and generate a sending key using the same method as the first data block. Encrypt the second data block using the sending key, and send the encryption result to the production management module.

[0127] Step 4: For other data blocks to be sent, the sending key of the previous data block is used as the seed data of the next data block to generate the sending key of the next data block. The next data block is then encrypted using the sending key, and the encryption result is sent to the production management module.

[0128] Specifically, a symmetric encryption algorithm is used between the recipe editing module and the production management module. When the production management module receives the encryption results of the first, second, and third data blocks from the recipe editing module in sequence, up to the Nth data block, as long as the production management module and the recipe editing module share the initial seed data and the method for generating the transmission key for each data block, the production management module can calculate the transmission key corresponding to the encryption result of each data block using the same seed data and the same method. This key is then used to decrypt the encryption result of each data block, ultimately obtaining the complete transmission data. This method enhances the communication security between the production management module and the recipe editing module.

[0129] Furthermore, after receiving the data sent from the recipe editing module, the production management module obtains the production recipe through the following steps:

[0130] Step 1: The production management module uses its own private key to decrypt the first encryption result to obtain several randomly arranged production recipe blocks, the decryption number order, and the decryption key.

[0131] Step 2: Based on the decryption key, the production management module decrypts the second encryption result to obtain several randomly arranged production formula blocks. The production management module then combines the production formula blocks obtained from the two decryption processes according to their decryption number order to obtain the correct production formula.

[0132] In summary, Embodiment 3 achieves the method of encrypting and transmitting production formulas between the formula editing module and the production management module through the above method. At the same time, it reduces the time for encrypting and decrypting production formulas. In other words, while ensuring the data security of production formulas, it also shortens the time for encrypting and decrypting production formulas, so that the encrypted transmission of production formulas will not cause delays in the production management module's control of the formula production line.

[0133] The above-described embodiments merely illustrate preferred embodiments of the present invention, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of the present invention. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of the present invention, and these all fall within the scope of protection of the present invention. Therefore, the scope of protection of this patent should be determined by the appended claims.

Claims

1. A drug preparation and solution management system based on flexible production, characterized in that, include: The system includes a visual operation interface, a formula storage module, a formula editing module, a production management module, and a production monitoring module. The visual operation interface is connected to the formula storage module, the formula editing module, the production management module, and the production monitoring module, respectively. The formula storage module stores formula information for multiple formulas. The formula information includes material type information, material quantity information, production step information, operating procedure information, and process parameter information corresponding to each production step. The formula is input through the formula editing module. The formula editing module receives editing instructions from the user through a visual operation interface. It edits the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step in the formula editing template. It also retrieves a first formula from the formula storage module, modifies the above information of the first formula according to user requirements, and obtains the production formula to be produced. After editing, the production formula is stored in the formula storage module and transmitted to the production management module. The formula editing template is a template pre-stored in the formula editing module to facilitate user editing of the formula. The production management module is used to manage and control the production of the production formula, receive the production formula transmitted by the formula editing module, and send the production formula to the production controller. The production controller sends a production instruction to the formula production line corresponding to the production formula according to the production formula. The production monitoring module is used to monitor the production process of the formula production line, send the operating status of the formula production line and the abnormal conditions in the production process to the visual operation interface, and store the operating status and the abnormal conditions in the production management module. The recipe editing module transmits the production recipe to the production management module in encrypted form, including the following steps: Step (1): Set encrypted transmission information for the correspondence between different formula editing modules and production management modules. The correspondence includes the communication addresses of the formula editing module and the production management module, and the encrypted transmission information includes the location data for encrypting the production formula and the encryption key. Step (2): The formula editing module searches for matching encrypted transmission information based on the communication address of the production management module that will send the production formula. The formula editing module divides the production formula into different production formula blocks and sequentially numbers the different production formula blocks. Step (3): Based on the location data in the encrypted transmission information, i.e. the production formula block number, the formula editing module takes out the corresponding production formula block as the first data and takes all other production formula blocks as the second data. The production formula blocks in the first data and the second data are randomly arranged according to the number. At the same time, the number order corresponding to each production formula block in the first data and the second data, as well as the decryption key corresponding to the encryption key, are added to the first data. Step (4): The recipe editing module uses the public key of the production management module to encrypt the first data to obtain the first encryption result, and uses the encryption key to encrypt the second data to obtain the second encryption result. The first encryption result and the second encryption result are combined to form the sending data, and the sending data is also sent to the corresponding production management module.

2. The drug preparation and solution management system based on flexible production according to claim 1, characterized in that, The production monitoring module includes a production information acquisition unit, a sensor information storage unit, an anomaly information unit, an anomaly prediction unit, a repair information unit, and a display control unit; The production information acquisition unit acquires monitoring information of sensors installed on each device of the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information. The sensor information storage unit is also used to store the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the equipment parameters includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself. The abnormal information unit obtains the abnormal information of the sensor by comparing the regulatory information with the normal range information, obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit based on the sensor number, and obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit based on the sensor number. The display control unit is used to send the monitoring information to the visual operation interface, and when the abnormal situation occurs, send the location of the device and the abnormal information, the abnormal result information, the abnormal cause information, and the repair method information of the device to the visual operation interface on a per-device basis.

3. The drug preparation and liquid preparation management system based on flexible production according to claim 2, characterized in that, The abnormal information includes abnormal vibration, pressure reduction, pressure increase, temperature rise, and abnormal process parameters.

4. The drug preparation and solution management system based on flexible production according to claim 3, characterized in that, The display control unit is further configured to obtain the start time, end time, and changes in the monitoring information within the time period between the start time and the end time from the abnormal information unit, generate an abnormal curve based on the start time, the end time, and the changes, and send the abnormal curve to the visualization operation interface.

5. The drug preparation and solution management system based on flexible production according to claim 1, characterized in that, It also includes a permissions management module for managing the operating permissions of operators; The operator responsible for editing the formula has the authority to view the formulas in the formula storage module, view the information in the production management module, and view the operating status and abnormal conditions of the production monitoring module. The operators responsible for production management have the authority to view the recipes in the recipe storage module, the operating status of the production monitoring module, and any abnormal conditions.

6. A method for managing drug preparation and solution formulation based on flexible production, characterized in that, Includes the following steps: Step 1: Open the formula editing module through the visual operation interface. In the formula editing template, edit the material type information, material quantity information, production step information, operation procedure information, and process parameter information corresponding to each production step of the production formula to be produced. Obtain the first formula from the formula storage module, modify the above information of the first formula according to the user's needs, and obtain the production formula to be produced. After completing the editing, store the production formula in the formula storage module and transmit the production formula to the production management module. The formula editing template is a template pre-stored in the formula editing module to facilitate the user's editing of the formula. Step 2: The production management module receives the production formula transmitted by the formula editing module and sends the production formula to the production controller. The production controller sends a production instruction to the formula production line corresponding to the production formula according to the production formula. Step 3: The production monitoring module monitors the production process of the formula production line, sends the operating status of the formula production line and any abnormal conditions in the production process to the visual operation interface, and stores the operating status and the abnormal conditions in the production management module. In step 1, the recipe editing module transmits the production recipe to the production management module in encrypted form, including the following steps: Step (1): Set encrypted transmission information for the correspondence between different formula editing modules and production management modules. The correspondence includes the communication addresses of the formula editing module and the production management module, and the encrypted transmission information includes the location data for encrypting the production formula and the encryption key. Step (2): The formula editing module searches for matching encrypted transmission information based on the communication address of the production management module that will send the production formula. The formula editing module divides the production formula into different production formula blocks and sequentially numbers the different production formula blocks. Step (3): Based on the location data in the encrypted transmission information, i.e. the production formula block number, the formula editing module takes out the corresponding production formula block as the first data and takes all other production formula blocks as the second data. The production formula blocks in the first data and the second data are randomly arranged according to the number. At the same time, the number order corresponding to each production formula block in the first data and the second data, as well as the decryption key corresponding to the encryption key, are added to the first data. Step (4): The recipe editing module uses the public key of the production management module to encrypt the first data to obtain the first encryption result, and uses the encryption key to encrypt the second data to obtain the second encryption result. The first encryption result and the second encryption result are combined to form the sending data, and the sending data is also sent to the corresponding production management module.

7. The method for managing drug preparation and solution preparation based on flexible production according to claim 6, characterized in that, Step 3 involves the production monitoring module monitoring the production process of the formula production line, specifically including the following steps: Step 3.1: The sensor information storage unit stores the normal range information of the parameters of the equipment corresponding to each sensor installed on the formula production line. The normal range information of the equipment parameters includes the normal range information of the process parameters of the production step corresponding to the equipment and the normal range information of the performance parameters of the equipment itself. Step 3.2: The production information acquisition unit acquires the monitoring information of the sensors installed on each device of the formula production line, and stores the monitoring information in the sensor information storage unit based on the sensor number. The monitoring information also includes the time information of acquiring the monitoring information. Step 3.3: The abnormal information unit obtains the abnormal information of the sensor by comparing the regulatory information with the normal range information, obtains the abnormal result information corresponding to the abnormal information from the abnormal prediction unit based on the sensor number, and obtains the abnormal cause information and repair method information corresponding to the abnormal information from the repair information unit based on the sensor number. Step 3.4: The display control unit sends the monitoring information to the visual operation interface, and when the abnormal situation occurs, sends the device location and the abnormal information, the abnormal result information, the abnormal cause information, and the repair method information to the visual operation interface on a device-by-device basis.

8. The method for managing drug preparation and solution preparation based on flexible production according to claim 7, characterized in that, The display control unit obtains the start time, end time, and changes in the monitoring information within the time period between the start time and end time from the abnormal information unit, generates an abnormal curve based on the start time, end time, and changes, and sends the abnormal curve to the visualization operation interface.

Images