A hospital hazardous chemicals safety management system and method

Abstract

The present invention provides a hospital hazardous chemicals safety management system and method, and discloses a hospital hazardous chemicals safety management system and method. The present invention is based on Php+Nodejs as a technical architecture, uses the Internet of Things and cloud servers as operating platforms, and can be accessed through mobile phone APP and PC terminals, realizing the full process management of hazardous chemicals purchase approval, safe storage, collection and return, waste disposal, supervision and management, and statistical analysis, timely data interaction through the network, sharing the database in the hospital hazardous chemicals safety management system, and managing hazardous chemicals in a traceable manner. All operation behaviors and operation data are visualized and traceable; all operation behaviors are standardized in accordance with the specifications, hierarchical management, and responsibility at all levels, which solves the current problem of hospitals' lack of intelligent management of hazardous chemicals, thereby meeting the requirements of high-quality hospital hazardous chemicals safety management in a complex real environment.

Description

Technical Field

[0001] The present invention relates to the technical field of hospital hazardous chemicals management, and in particular to a hospital hazardous chemicals safety management system and method. Background Art

[0002] With the development of economy and the growth of national strength, the hospital industry is also developing rapidly in technology. In the growth of my country's medical industry, a large number of clinical and scientific research experiments are indispensable, and hazardous chemicals are used in hospital work. In the safety management of hazardous chemicals in hospitals, it is easy to rely on manual management, uneven quality, chaotic processes, difficult to trace the source, insufficient hospital investment, irregular storage, and regulatory gaps. Summary of the invention

[0003] The present invention overcomes the shortcomings of the existing management of hazardous chemicals. The present invention provides a hospital hazardous chemicals safety management system and method. The system is based on Php+Nodejs as a technical architecture, uses the Internet of Things and a cloud server as an operating platform, and can be accessed through a mobile phone APP and a PC. The system realizes the full-process management of the purchase and approval, safe storage, collection and return, waste disposal, supervision and management, and statistical analysis of hazardous chemicals. The system can exchange data through the network in a timely manner, share data in the hospital hazardous chemicals safety management system, and manage hazardous chemicals in a traceable manner. All operation behaviors and operation data are visualized and traceable. The process is standardized, and all operation behaviors are carried out in accordance with the specifications, managed in layers, and responsible at all levels, which solves the problem of the current blank of intelligent management of hazardous chemicals in hospitals.

[0004] The present invention can be achieved through the following technical solutions:

[0005] A hospital hazardous chemicals safety management system of the present invention is configured with warehousing management, approval management, storage management, application for use, return management, waste management, inspection management, data statistics and operation log function modules which are respectively connected to a central database.

[0006] Furthermore, the central database adopts MySQL5.7 database, including administrator database, hazardous chemicals inventory database, collection and return record database, hazardous chemicals waste history record database, inspection database and hazardous chemicals dictionary database.

[0007] The administrator database adopts the basic framework of Thinkphp and the Eggjs framework to divide the personnel into first-level students, second-level regional management teachers, third-level superior management teachers - building managers and fourth-level supervisory teachers - general administrators.

[0008] The central database exchanges information with the APP, the PC side of the computer and the student side through the high-speed cache and message queue agent Redis, Nginx high-performance http and reverse proxy, and adopts the B / S architecture, i.e. the browser and server architecture, for human-computer interaction.

[0009] The warehousing management transmits signals to the hazardous chemicals dictionary database and the hazardous chemicals inventory database in the central database, increases or decreases the hazardous chemicals category data in the hazardous chemicals dictionary database, and increases the hazardous chemicals quantity data in the hazardous chemicals inventory database; the approval management, storage management, receipt application, and return management transmit the hazardous chemicals approval, receipt and return information to the receipt record database and the hazardous chemicals inventory database.

[0010] The central database transmits a signal to the PC end to consult the database, and the PC end can set personnel management permissions to form an administrator database and transmit it to the central database.

[0011] The first-level students use the student terminal to scan the WeChat code, and the student terminal is connected to the central database. The collection and return record database and hazardous chemicals inventory database in the central database interact with the student terminal respectively; the operation log uses egg-logger to generate log monitoring.

[0012] A hospital hazardous chemicals safety management method is configured with a mobile APP, a computer PC and a student terminal with greater mobility.

[0013] In the above scheme, the system builds a laboratory information management system from the aspects of information docking, label printing, hazardous chemicals coding storage, application and approval, collection and return, and reagent scrapping, achieving "inventory can be checked", "source can be traced", "destination can be traced", and "status can be controlled". The system realizes the source control of hazardous chemicals. For those who use hazardous chemicals, they need to go through the approval process on the system; they can be stored and collected only after approval.

[0014] The system follows the principle of "full-process closed-loop control, integration of online and offline, and intelligent hardware assistance" to manage hazardous chemicals in a refined manner by attaching identification cards to them. It establishes a dictionary database for hazardous chemicals and creates identification cards for each hazardous chemical, thus realizing the full-process management of hazardous chemicals, including application, procurement, acceptance, warehousing, issuance, delivery, use, disposal, and monitoring.

[0015] Students, teachers and administrators can all use mobile devices to operate. Students and teachers can put forward their own application requirements, and administrators can clearly understand the inventory management approval status, which greatly saves time costs such as communication, inquiry, and statistics, and achieves information process records to realize a closed loop in business.

[0016] The system function interface style and operation process are consistent, each business system shares basic data information and follows the same data standards; the system has good growth potential and can expand other functions.

[0017] The system adopts Php+Nodejs technology architecture, which is stable, lightweight, scalable and real-time interactive.

[0018] The system can be accessed from PC, mobile phone, etc.

[0019] This system uses the basic framework: Thinkphp, the task and plug-in framework: Eggjs Alibaba enterprise-level framework, the cache framework: Redis, egg-logger log, MySQL5.7 database, Nginx operating environment. It has a high degree of security and stability.

[0020] The B / S application architecture model is adopted. The B / S model supports the new version of IE browser and is compatible with the normal browsing operation of non-IE core browsers such as Firefox, Google Chrome, and Safari. It meets the requirements of centralized and high-performance processing of big data for students and teachers in various regions. Users at all levels can perform various use and management operations through the browser. It also supports mobile APP operations and can be completed without a computer. It has good openness and scalability, a friendly interface, and is easy to master and operate.

[0021] The system is based on a unified data platform and developed using a large database. The system is designed based on dynamic data and has strong versatility, strong network sharing capabilities, fast information exchange, and convenient data import and export functions.

[0022] It is in line with the use of hazardous chemicals in hospitals, safe to operate, and in line with national standards for hazardous chemicals management, and can easily and flexibly establish interfaces with other systems. The system design combines the current status of hospital hazardous chemicals informatization, makes full use of existing resources, and meets the design requirements of advancement, openness, scalability, and security.

[0023] System data can support file import and export for easy viewing.

[0024] It adopts multi-role, authority and hierarchical structure management, sets authority according to the college's management role, and can manage the use of various users individually or in batches, comprehensively covering all areas of laboratory management, and providing an intelligent and efficient information management platform for college-level laboratory management.

[0025] The system performance can ensure timely response. The response and data exchange between users at all levels and the central database should be completed within 2 seconds, and the generation of general statistics, report queries, etc. should not exceed 3 seconds. The central database server can meet the requirements of daily data processing during peak periods. The system design takes into account the maximum load state during centralized data and business processing; at the same time, the system guarantees sufficient scalability for future data growth and demand expansion.

[0026] Furthermore, the first-level students use the student terminal of WeChat to scan the QR code in the storage area to apply for collection. The student terminal is connected to the central database, and the information of the hazardous chemicals and quantities applied for by the students is transmitted to the collection and return record database and the hazardous chemicals inventory database. The collection and return record database simultaneously sends an application reminder to the regional management teacher of the corresponding area, and freezes the quantity of hazardous chemicals applied for in the hazardous chemicals inventory database.

[0027] The second-level regional management teacher, the third-level superior management teacher - the building manager and the fourth-level inspection teacher - the general administrator use mobile phone APP to perform warehousing management, approval management, storage management, application for use, return management, waste management and inspection management. At the same time, data statistics and operation logs can be viewed through the APP. The mobile phone APP is connected to the central database and transmits data to the central database; the warehousing management transmits the name, storage area and location information of hazardous chemicals to the hazardous chemicals dictionary database, and transmits the hazardous chemicals warehousing quantity to the hazardous chemicals inventory database; waste management is managed by the second-level regional management teacher An application for hazardous chemicals disposal is submitted, and the hazardous chemicals are disposed of by the third-level superior management teacher - the building manager, and the waste information is transmitted to the hazardous chemicals waste history record database. The supervision management is carried out by the fourth-level supervision teacher - the general administrator to conduct single, regular or periodic inspections on the purchase, storage, use and disposal of hazardous chemicals. The second-level regional management teachers in the corresponding areas will make rectifications and transmit the inspection and rectification results to the supervision database; the central database's collection record database, hazardous chemicals inventory database, hazardous chemicals dictionary database, hazardous chemicals waste history record database and supervision database exchange information in real time.

[0028] The central database can be accessed through the PC, and the inspection database can export inspection reports through the PC. The return record database, hazardous chemicals inventory database and hazardous chemicals waste history record database can export hazardous chemicals registration forms through the PC.

[0029] Furthermore, the APP includes three major interfaces: home page, message and my interface.

[0030] The home page interface includes two parts: collection management and operation management.

[0031] The collection management includes two modules: checking the number of items to be approved in the responsible area and scanning the collection and approval code. The module for checking the number of items to be approved in the responsible area can view the approved number and the number to be approved in real time. When a teacher applies to collect items, he / she scans the QR code on the storage cabinet through the collection and approval scanning code. When the first area management teacher is approving the student's application for collection, he / she also needs to scan the QR code on the storage cabinet; the collection management exchanges information with the hazardous chemicals storage database and the collection and return record database.

[0032] The operation management includes approval management, warehousing storage, return management, waste liquid management, inspection management, inspection rectification, category list, approval management and operation log.

[0033] The approval management includes the approval of the use and storage of hazardous chemicals in the responsible area, as well as the supervision and rectification; the approval of the use and storage exchanges information with the collection and return record database to view the application for the use of hazardous chemicals in the responsible area, and make a judgment and approval. The first area management teacher approves the student's application for use and signs after scanning the QR code on the storage cabinet, and the second area management teacher can also remotely approve and sign on the spot; the storage approval exchanges information with the hazardous chemicals storage database to view the application for storage of hazardous chemicals in the responsible area, and make a judgment and approval to determine whether the storage application is passed.

[0034] The warehousing storage interacts with the hazardous chemicals storage database. When the warehousing application is passed and stored in the corresponding storage cabinet, the hazardous chemicals storage database changes. The warehousing storage module can also be used to view the number of hazardous chemicals stored in the storage cabinets in the corresponding area.

[0035] The return management exchanges information with the return record database and the hazardous chemicals storage database. When the user returns the goods, the first area management teacher scans the QR code on the storage cabinet, puts the hazardous chemicals back and signs. The second area management teacher can also remotely review and sign on the spot, and the return record can be checked through the return management.

[0036] The waste liquid management exchanges information with the hazardous chemicals waste historical record database. The second-level regional management teacher submits an application for the disposal of hazardous chemicals, and the third-level superior management teacher - the building manager discards the hazardous chemicals and transmits the waste information to the hazardous chemicals waste historical record database.

[0037] The inspection management and inspection rectification inspection database conducts information exchange, and the fourth-level general administrator conducts inspection management. The corresponding second-level regional management teacher makes rectifications based on the rectification opinions and then submits an application for review again until the inspection is passed.

[0038] The category list exchanges information with the hazardous chemicals dictionary database.

[0039] The approval management exchanges information with the central database, and users can directly view the hazardous chemicals inventory by adding bar charts and inventory details and can view them by category and region.

[0040] The operation log exchanges information with the central database, and the user can check the approval, quantity, and time of warehousing, collection, and return from the operation log.

[0041] The message interface includes four modules: warehouse message, inspection message, collection message and task message, and all of them interact with the central database.

[0042] The warehouse message is analyzed according to the central database to warn of excess inventory in the responsible area warehouse and insufficient drug inventory in the responsible area warehouse; the inspection message checks the inspection feedback; the collection message module reminds the application, return and signature records in the responsible area; the task message includes regular, one-time or periodic inspection tasks and waste liquid treatment tasks for publication reminders.

[0043] The "my" interface includes a display module for name and authority, and the "my" interface interacts with the central database, wherein the user's records of collection records, return records and inspection tasks can be viewed.

[0044] The PC terminal includes six interfaces: home page, authority management, dictionary management, area management, task center and data center.

[0045] The home page interface directly displays a hazardous chemicals inventory statistics bar chart module based on information transmitted from the hazardous chemicals inventory database, and the module can be viewed by category and region.

[0046] The authority management interface transmits administrator information to the administrator database, classifies the authority of different users through the role management module, selectively displays the real-time data collected by the database through the rule management module, and allocates authority through the administrator management module.

[0047] The dictionary management interface exchanges information with the hazardous chemicals dictionary database, adds, subtracts and modifies types through the hazardous chemicals type module, and adds or subtracts types of hazardous chemicals through the hazardous chemicals registration module.

[0048] The regional management interface exchanges information with the hazardous chemicals inventory database, and the hazardous chemicals waste history record database transmits information to the regional management. The regional management includes a regional classification module for setting the storage location of hazardous chemicals and a regional inventory module for viewing details.

[0049] The task center interface includes inspection tasks and waste liquid tasks that are issued regularly, once or periodically after processing the information transmitted by the hazardous waste history database and the inspection database.

[0050] The data center interface exchanges information with the central database, including being able to directly view the inspection report module, the data collection module and the operation log module, and being able to export inspection reports and hazardous chemicals registration forms, etc.

[0051] The student end fills in the student information through the WeChat applet, scans the QR code on the hazardous chemicals cabinet to submit an application, and when returning the hazardous chemicals, the teacher in charge of the first area scans the QR code on the cabinet to return the hazardous chemicals.

[0052] In the above scheme,

[0053] The tree-like organizational structure is displayed on the PC side, and supports adding, modifying, querying, viewing, and deleting information of each department, and supports maintaining information such as the person in charge and members of the department.

[0054] On the PC side, it supports account creation, modification, query, activation, deactivation, deletion, password modification and other functions; it supports account password, department, name and other information maintenance; it supports batch import and export of account information. Role is a collection of operating permissions within the system, similar to real-life positions; the system has built-in common roles, including system administrator, teacher, student, laboratory technician, etc.; it supports user-defined roles, and supports role creation, modification, permission configuration, and deletion.

[0055] On the PC side, you can centrally manage information such as buildings, floors, and rooms. You can add room information by importing and manually adding it. You can add, edit, modify, and import information on laboratories, warehouses, and other places. You can also edit information such as the laboratory's location, person in charge of safety, and the person in charge's contact information.

[0056] On the PC side, you can take inventory of the actual number of goods in the warehouse and storage locations, and support inventory by scanning codes through the APP side; after the inventory, you can automatically adjust the inventory quantity through profit and loss processing to achieve a balance between inventory quantity profit and loss.

[0057] System administrators can maintain basic information such as the name, brand, and specifications of reagents and consumables, and support manual addition and batch import of new information; administrators can classify reagents and consumables, and set labels; they can batch set the inventory limit, expiration warning days, validity period, default location, and whether to return reagents and consumables.

[0058] It displays the statistical overview of the incoming, inventory, withdrawal, and outgoing data for this week, the past week, this month, and this year; including the statistics and lists of the top five commodities in terms of incoming, current inventory, withdrawal, and outgoing quantities; it can perform incoming, inventory, withdrawal, and statistical analysis of reagents and consumables according to products, operators, and departments, display monthly statistical data, and can export them into Excel tables.

[0059] Furthermore, the category list and dictionary management both interact with the hazardous chemicals dictionary database to add hazardous chemicals categories; the steps of adding hazardous chemicals categories are as follows:

[0060] A1. Start entering the types of hazardous chemicals;

[0061] A2. Fill in the name of hazardous chemicals;

[0062] A3. Select the hazard level and medium of hazardous chemicals;

[0063] Hazard level: Level 1 is highly toxic / radioactive source, Level 2 is easy to make drugs, Level 3 is easy to make explosives, Level 4 is flammable and explosive, Level 5 is corrosive, Level 6 is toxic and Level 7 is other general categories;

[0064] Medium: liquid, solid

[0065] A4 determines whether to fill in the name, select the hazard level and the medium. If yes, it jumps to step A5; if not, it jumps to step A2;

[0066] A5 is stored in the dictionary;

[0067] A6 The entry of hazardous chemicals categories is completed.

[0068] Further, the warehousing management includes the following steps:

[0069] B1. Start storage;

[0070] B2. Select the area, floor, department and cabinet to be stored; jump to B4;

[0071] B3, scan the QR code of the storage cabinet; jump to B4;

[0072] B4. Call data from the hazardous chemicals dictionary database to display the hazardous chemicals in the cabinet, and then select the hazardous chemicals;

[0073] B5. Fill in the storage quantity and submit the storage application;

[0074] B6. Determine whether the hazardous chemicals in the cabinet exceed the cabinet capacity after storage; if so, proceed to step B7; if not, jump to step B13;

[0075] B7, the first regional management teacher determines whether the goods are correctly put into storage; if so, proceed to step B8; if not, jump to step B14;

[0076] B8. The first regional management teacher uses the APP to scan the QR code on the cabinet and signs at the warehousing approval area;

[0077] B9, the second regional management teacher determines whether the goods are correctly put into storage; if so, continue to step B10; if not, jump to step B14;

[0078] B10. The second regional management teacher signs at the APP entry approval section;

[0079] B11. Through storage, data is transmitted to the hazardous chemicals inventory database;

[0080] B12, this storage is completed;

[0081] B13, alert the superior management teacher and jump to step B5;

[0082] B14. Storage fails and feedback is given to the applicant.

[0083] In the above scheme, students and teachers register the name, brand, specification, product number, purity, storage location and other information of reagents and consumables on the warehousing interface, and generate a warehousing order after submission, or generate a warehousing order through Excel import to complete the registration of goods to be entered into the warehouse; then take the items to the reagent and consumables warehouse, confirm the warehousing order through mobile phones or smart terminals, and complete the actual entry of the items into the warehouse.

[0084] You can query the name, brand, specification, storage location, date, quantity and other attributes of inventory goods in real time; view the operation log of the goods, including detailed information on warehousing, outbound and return operations; you can print the QR code of the inventory, stick it on the surface of the item, and scan the code to view the detailed inventory information of the current reagents and consumables; you can quickly query the inventory information of reagents and consumables by type, warehouse location, name, CAS number, etc.; when the inventory is insufficient, over limit, or the reagents and consumables are about to expire or have expired, the system will automatically warn or alarm, and users can receive reminder messages through the system or SMS or email; controlled chemicals such as explosives, drugs, and highly toxic chemicals support single code management, and each bottle of chemical can be assigned a unique number. Operations such as outbound, return, and inventory are all accurately managed to specific numbers of hazardous chemicals.

[0085] Further, the approval management includes the following steps:

[0086] D1. Start approval management;

[0087] D2. The first regional management teacher opens the corresponding cabinet for applying for hazardous chemicals and scans the QR code inside the cabinet;

[0088] D3. The first regional management teacher determines whether the application has passed the review. If yes, the process goes to step D4. If no, the process goes to steps D5 and D6 at the same time.

[0089] D4. The first regional management teacher signs on site;

[0090] D5. Release the frozen usage and send a signal to the hazardous chemicals inventory database;

[0091] D6. Feedback: The application failed to pass the review;

[0092] D7, the second regional management teacher conducts on-site or remote review to see if the application has passed the review; if so, jump to step D8; if not, jump to steps D5 and D6 at the same time;

[0093] D8. The second regional management teacher signs and sends a signal to the hazardous chemicals inventory database and the return record database;

[0094] D9. The warehousing, collection and return were approved successfully.

[0095] Furthermore, the student end and the application for use include the following steps:

[0096] C1. Students use WeChat and teachers use APP to apply for the service;

[0097] C2. Scan the QR code on the corresponding cabinet;

[0098] C3. Select the hazardous chemicals used in the experiment from the hazardous chemicals names provided by the hazardous chemicals dictionary database; and jump to steps C4 and C5 at the same time;

[0099] C4. It can be seen that the existing surplus of the hazardous chemicals;

[0100] C5. Fill in the dosage;

[0101] C6. Determine whether the applied amount is met based on the hazardous chemicals inventory database and the filled amount; if so, jump to step C8; if not, jump to step C7;

[0102] C7. Give reminders to the regional management teacher;

[0103] C8. Freeze the selected amount and transmit the signal to the hazardous chemicals inventory database;

[0104] C9, determine whether the person borrowing the card is a person of level 3 or below; the person levels include level 1 students, level 2 regional management teachers, level 3 superior management teachers - building managers, and level 4 supervisors - general administrators; if yes, jump to step C10; if no, jump to step C11;

[0105] C10. Fill in the return date;

[0106] C11. Optional return time;

[0107] C12. Confirm the application and submit it.

[0108] In the above scheme, students and teachers can collect reagents and consumables online or on the go. The collection interface displays all available items. After selecting an item, enter the collection quantity, arrival time, use time, use location and other information before submitting for approval. A separate approval process can be set for controlled chemicals.

[0109] After approval, you can go to the warehouse to pick it up according to regulations;

[0110] It supports printing of collection orders and generating collection QR codes. You can scan the QR codes to quickly view collection details.

[0111] After the application is approved, you can go to the warehouse with a paper or electronic receipt to collect the goods. There are two ways: the regional management teacher will issue the goods uniformly, and the students and teachers will issue the goods independently.

[0112] After students and teachers take out reagents and consumables, they check the items and the receipt on their mobile phones or smart terminals to complete the outbound registration;

[0113] Hazardous chemicals managed with a single code or other items that require refined management can be checked by scanning the code, reducing the effort of manual checking.

[0114] Further, the return management includes the following steps:

[0115] E1, start the return application; jump to steps E2 and E3 at the same time;

[0116] E2. Return hazardous chemicals when they are about to expire and notify the regional management teacher;

[0117] E3. Scan the QR code to return the cabinet;

[0118] E4, input the amount returned;

[0119] E5. The first regional management teacher determines whether the return is qualified; if so, jump to step E6; if not, jump to step E7;

[0120] E6. The first regional management teacher signs on site;

[0121] E7, Feedback to the student side: return unqualified;

[0122] E8. The second regional management teacher will conduct on-site or remote review to determine whether the returned product is qualified; if so, jump to step E9; if not, jump to step E7;

[0123] E9. The second regional management teacher signs and sends a signal to the return record database and hazardous chemicals inventory database at the same time;

[0124] E10. This return is successful.

[0125] Students and teachers can check the reagents and consumables in their hands. For items that do not need to be returned, they can register their usage and consumption. Items that need to be returned will automatically receive a return reminder notification and return the items to the reagent warehouse within the specified time and register the return. If items that need to be returned have actually been consumed or are used for other purposes and cannot be returned, the reasons can be registered and the warehouse keeper can be notified;

[0126] Regional management teachers can check the distribution location of out-of-warehouse reagents and consumables, students and teachers who apply for them, places of use, expected return time and other information at any time in the off-warehouse goods. They can also send return reminder messages to achieve unified management and control of goods inside and outside the warehouse.

[0127] Further, the waste management comprises the following steps:

[0128] F1. Start waste liquid management;

[0129] F2, the regional management teacher selects the management area;

[0130] F3. Fill in the amount of waste liquid and sign;

[0131] F4. The superior manager / building manager clears the waste liquid and sends a signal to the hazardous waste history database

[0132] F5. Remove waste liquid from the cabinet;

[0133] F6. Waste liquid treatment is completed.

[0134] Further, the inspection management includes the following steps:

[0135] G1. Receive inspection tasks;

[0136] G2. Open the supervision management;

[0137] G3. Scan the QR code of the cabinet;

[0138] G4, determine whether the user is a fourth-level personnel; if so, jump to step G6; if not, jump to step G5;

[0139] G5, display no permission; jump to step G2;

[0140] G6. Pop-up inspection report;

[0141] G7. Fill in the inspection time and area;

[0142] G8, the supervisor-general administrator determines whether the inspection is passed; if so, jump to step G9; if not, jump to step G10;

[0143] G9. After all the information is passed, the supervisor will sign.

[0144] G10, inspect the teacher to fill in the problem;

[0145] G11. After rectification, fill in the rectification status and submit the re-inspection application; jump to step G2;

[0146] G12. Send a signal to the inspection database, and the inspection is completed.

[0147] In the above scheme, the system automatically assigns inspection tasks according to the inspected laboratories and inspectors in the inspection plan. The inspectors carry out inspections and patrols according to the plan and register the inspection results. The content and basis of the safety inspection can be exported as an Excel spreadsheet. It supports online filling of inspection conditions and inspection evaluations, and can quickly complete safety inspections and upload on-site pictures on site through mobile terminals. After the inspection is completed, if all inspection items are qualified, the system automatically generates an inspection report. If unqualified items or safety hazards are found during the safety inspection, safety rectification will be initiated. The inspector will initiate a safety rectification notice, specify the person in charge, rectification items and rectification period, and the system will automatically notify the person in charge to make rectifications.

[0148] After receiving the rectification notice, the person in charge of rectification will check the rectification items, rectification deadline, on-site photos and other information on the rectification page; after carrying out the actual rectification, he / she will fill in the rectification description and implementation status, and can quickly complete the rectification and implementation status and upload on-site photos on-site through the mobile terminal, and then submit them for review.

[0149] After the inspection is completed, the system automatically generates a safety inspection report, which includes the inspection status, inspection evaluation, rectification date, rectification and implementation status, uploaded pictures, etc. of all inspection items; the system supports re-editing of the safety inspection report, which will enter the approval process after submission and support printing after approval;

[0150] Supports editing of safety inspection report templates.

[0151] Compared with the prior art, the technical solution of the present invention has at least the following beneficial effects:

[0152] 1. The hospital hazardous chemicals safety management system and method of the present invention can manage hazardous chemicals in a traceable manner throughout the entire process from purchase approval, safe storage, collection and return, waste disposal, supervision management, and statistical analysis. All operating behaviors and operating data can be visualized and traced. The process is standardized and all operating behaviors are carried out in accordance with the specifications, managed in layers, and each layer is responsible. Considering that the users include students, teachers, and managers, the process management method is simpler, more comprehensive, and meets actual needs.

[0153] 2. The hospital hazardous chemicals safety management system and method of the present invention allows students to apply for collection and return by scanning a QR code via WeChat, and teachers can access the system via a mobile phone APP and a computer PC, and share the system over the Internet, so the data exchange capability is strong and the system is very convenient to use.

[0154] 3. The hospital hazardous chemicals safety management system and method of the present invention has the ability to process big data with high performance. The database generated from the operation behaviors and data on the mobile phone and computer can be directly exported from the PC as needed, which is convenient for user review.

[0155] 4. The hospital hazardous chemicals safety management system and method of the present invention adopts a modular design and provides rich interface functions, making it open and extensible. It adopts Alibaba Cloud's Eggjs framework, which is efficient and stable, and reserves sufficient space for future data growth, as well as sufficient interfaces to cope with site changes, management method changes, etc.

[0156] 5. The hospital hazardous chemicals safety management system and method of the present invention provide an intelligent and efficient information platform for hospital hazardous chemicals management. BRIEF DESCRIPTION OF THE DRAWINGS

[0157] The drawings herein are incorporated into the specification and constitute the system and method of the specification, illustrate embodiments consistent with the present invention, and together with the specification are used to explain the principles of the present invention. The features, purposes and advantages of the present invention will become more obvious. The drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. The drawings of this embodiment are briefly described as follows.

[0158] Figure 1 is a system structure diagram of the present invention;

[0159] Figure 2 This is a diagram of the APP end system structure and method of the present invention;

[0160] Figure 3 The PC terminal system structure and method diagram of the present invention;

[0161] Figure 4A diagram showing a method of using the student terminal of the present invention;

[0162] Figure 5 This is a flowchart of the hazardous chemicals dictionary entry system of the present invention;

[0163] Figure 6 It is a flow chart of the warehousing system of the present invention;

[0164] Figure 7 A flow chart of the application and application system of the present invention;

[0165] Figure 8 This is a flow chart of the approval system for use of the present invention;

[0166] Fig. 9 is a flow chart of the return system of the present invention;

[0167] Fig.10 is a flow chart of the waste liquid management system of the present invention;

[0168] Fig.11 It is a flow chart of the inspection and management system of the present invention. DETAILED DESCRIPTION

[0169] The following will describe the exemplary implementation of the present invention in detail by taking the preferred embodiments as examples. However, the exemplary implementation can be implemented in various forms and should not be understood as being limited to the examples described herein; on the contrary, these implementations are provided to make the present invention more comprehensive and complete, and to fully convey the concept of the exemplary implementation to those skilled in the art, but those skilled in the art should understand that the following is merely an example to illustrate and describe some preferred implementations, and does not impose any limitation on the claims of the present invention.

[0170] Hereinafter, embodiments of the present invention will be described:

[0171] A hospital hazardous chemicals safety management system of the present invention is configured with warehousing management, approval management, storage management, application for use, return management, waste management, inspection management, data statistics and operation log function modules respectively connected to a central database 4 .

[0172] In one embodiment, the central database 4 uses the MySQL5.7 database, including an administrator database, a hazardous chemical inventory database, a collection and return record database, a hazardous chemical waste history record database, an inspection database and a hazardous chemical dictionary database.

[0173] The administrator database uses the Thinkphp basic framework and Eggjs framework to divide personnel into first-level students, second-level regional management teachers, third-level superior management teachers - building managers and fourth-level supervisory teachers - general administrators.

[0174] The central database 4 interacts with APP1, PC terminal 2 and student terminal 3 respectively through high-speed cache and message queue agent Redis, Nginx high-performance http and reverse proxy, and adopts B / S architecture, i.e. browser and server architecture for human-computer interaction.

[0175] Among them, the warehousing management transmits signals to the hazardous chemicals dictionary database and the hazardous chemicals inventory database in the central database 4, increases or decreases the hazardous chemicals category data in the hazardous chemicals dictionary database, and increases the hazardous chemicals quantity data in the hazardous chemicals inventory database; among them, the approval management, storage management, receipt application, and return management transmit the hazardous chemicals approval, receipt and return information to the receipt record database and the hazardous chemicals inventory database.

[0176] The central database 4 transmits a signal to the PC end to consult the database, wherein the PC end 2 can set personnel management permissions to form an administrator database and transmit it to the central database 4.

[0177] Among them, the first-level students use the student terminal 3 to scan the WeChat code, and the student terminal 3 is connected to the central database 4. The collection and return record database and the hazardous chemicals inventory database in the central database 4 interact with the student terminal 3 respectively; the operation log uses egg-logger to generate log monitoring.

[0178] A method for safe management of hazardous chemicals in a hospital is provided, which is configured with a mobile APP 1, a computer PC 2 and a student terminal 3 with greater mobility.

[0179] In the above embodiment, the system builds a laboratory information management system from the aspects of information docking, label printing, hazardous chemicals coding storage, application and approval, collection and return, and reagent scrapping, achieving "inventory can be checked", "source can be traced", "destination can be traced", and "status can be controlled". The system realizes the source control of hazardous chemicals. For the use of hazardous chemicals, it is necessary to go through the approval process on the system; only after approval can they be stored and collected.

[0180] The system follows the principle of "full-process closed-loop control, integration of online and offline, and intelligent hardware assistance" to manage hazardous chemicals in a refined manner by attaching identification cards to them. It establishes a dictionary database for hazardous chemicals and creates identification cards for each hazardous chemical, thus realizing the full-process management of hazardous chemicals, including application, procurement, acceptance, warehousing, issuance, delivery, use, disposal, and monitoring.

[0181] Students, teachers and administrators can all use mobile devices to operate. Students and teachers can put forward their own application requirements, and administrators can clearly understand the inventory management approval status, which greatly saves time costs such as communication, inquiry, and statistics, and achieves information process records to realize a closed loop in business.

[0182] The system function interface style and operation process are consistent, each business system shares basic data information and follows the same data standards; the system has good growth potential and can expand other functions.

[0183] The system adopts Php+Nodejs technology architecture, which is stable, lightweight, scalable and real-time interactive.

[0184] The system can be accessed from PC, mobile phone, etc.

[0185] This system uses the basic framework: Thinkphp, the task and plug-in framework: Eggjs Alibaba enterprise-level framework, the cache framework: Redis, egg-logger log, MySQL5.7 database, Nginx operating environment. It has a high degree of security and stability.

[0186] The application architecture model adopts the B / S browser / server mode. The B / S mode supports the new version of IE browser and is compatible with the normal browsing operations of non-IE core browsers such as Firefox, Google Chrome, and Safari. It meets the requirements of centralized and high-performance processing of big data for students and teachers in various regions. Users at all levels can perform various use and management operations through the browser. It also supports mobile APP operations and can be completed without a computer. It has good openness and scalability, a friendly interface, and is easy to master and operate.

[0187] The system is based on a unified data platform and developed using a large database. The system is designed based on dynamic data and has strong versatility, strong network sharing capabilities, fast information exchange, and convenient data import and export functions.

[0188] It is in line with the use of hazardous chemicals in hospitals, safe to operate, and in line with national standards for hazardous chemicals management, and can easily and flexibly establish interfaces with other systems. The system design combines the current status of hospital hazardous chemicals informatization, makes full use of existing resources, and meets the design requirements of advancement, openness, scalability, and security.

[0189] System data can support file import and export for easy viewing.

[0190] It adopts multi-role, authority and hierarchical structure management, sets authority according to the college's management role, and can manage the use of various users individually or in batches, comprehensively covering all areas of laboratory management, and providing an intelligent and efficient information management platform for college-level laboratory management.

[0191] The system performance can ensure timely response. The response and data exchange between users at all levels and the central database should be completed within 2 seconds, and the generation of general statistics, report queries, etc. should not exceed 3 seconds. The central database server can meet the requirements of daily data processing during peak periods. The system design takes into account the maximum load state during centralized data and business processing; at the same time, the system guarantees sufficient scalability for future data growth and demand expansion.

[0192] In one embodiment, a first-level student uses a student terminal 3 for scanning the QR code in the storage area through WeChat to apply for the use of the hazardous chemicals. The student terminal 3 is connected to a central database 4, and the information on the hazardous chemicals and quantities applied for by the students is transmitted to the collection and return record database and the hazardous chemicals inventory database. The collection and return record database simultaneously sends an application reminder to the regional management teacher of the corresponding area, and freezes the quantity of hazardous chemicals applied for in the hazardous chemicals inventory database.

[0193] Among them, the second-level regional management teacher, the third-level superior management teacher - the building manager and the fourth-level inspection teacher - the general administrator use the mobile phone APP1 to perform warehousing management, approval management, storage management, application for use, return management, waste management and inspection management. At the same time, data statistics and operation logs can be viewed through APP1. The mobile phone APP1 is connected to the central database 4 to transmit data to the central database 4; the warehousing management transmits the name, storage area and location information of hazardous chemicals to the hazardous chemicals dictionary database, and transmits the warehousing quantity of hazardous chemicals to the hazardous chemicals inventory database; waste management is managed by the second-level regional management The teacher submits an application for the disposal of hazardous chemicals, and the third-level superior management teacher - the building manager will discard the hazardous chemicals and pass the waste information to the hazardous chemical waste history record database. The fourth-level supervision teacher - the general administrator will conduct single, regular or periodic inspections on the purchase, storage, use and disposal of hazardous chemicals. The second-level regional management teachers in the corresponding areas will make rectifications and pass the inspection and rectification results to the supervision database; the central database 4's collection record database, hazardous chemicals inventory database, hazardous chemicals dictionary database, hazardous chemicals waste history record database and supervision database will exchange information in real time.

[0194] The central database 4 can be consulted through the PC terminal 2, and the inspection database can export the inspection report through the PC terminal 2. The return record database, the hazardous chemicals inventory database and the hazardous chemicals waste history record database can export the hazardous chemicals registration form through the PC terminal 2.

[0195] In one embodiment, APP1 includes three major interfaces: home page 11, message 12 and my 13.

[0196] The home page 11 interface includes two parts: collection management 111 and operation management 112.

[0197] The collection management 111 includes two modules: checking the number of items to be approved in the responsible area 1111 and collection and approval scanning 1112. The module of checking the number of items to be approved in the responsible area 1111 can view the approved quantity and the quantity to be approved in real time. When a teacher applies for collection of items, he / she scans the QR code on the storage cabinet through the collection and approval scanning 1112. When the first area management teacher is approving the student's application for collection, he / she also needs to scan the QR code on the storage cabinet. The collection management 111 exchanges information with the hazardous chemicals storage database and the collection and return record database.

[0198] The operation management 112 includes approval management 1121, warehousing storage 1122, return management 1123, waste liquid management 1124, inspection management 1125, inspection and rectification 1126, category list 1127, approval management 1128 and operation log 1129.

[0199] The approval management 1121 includes the approval of the use of the responsible area 11211, the approval of the warehousing 11212 and the supervision and rectification 11213; the approval of the use 11211 exchanges information with the collection record database, checks the application for the use of hazardous chemicals in the responsible area, and makes judgments and approvals. The first area management teacher approves the student's application for use and scans the QR code on the storage cabinet and signs. The second area management teacher can also remotely approve and sign on the spot; the warehousing approval 11212 exchanges information with the hazardous chemicals storage database, checks the application for the warehousing of hazardous chemicals in the responsible area, and makes judgments and approvals to determine whether the warehousing application is passed.

[0200] Among them, the warehousing storage 1122 interacts with the hazardous chemicals storage database. When the warehousing application is approved and stored in the corresponding storage cabinet, the hazardous chemicals storage database changes. The warehousing storage 1122 module can also be used to view the number of hazardous chemicals stored in the storage cabinet in the corresponding area.

[0201] The return management 1123 exchanges information with the return record database and the hazardous chemicals storage database. When the user returns the goods, the management teacher in the first area scans the QR code on the storage cabinet, puts the hazardous chemicals back and signs. The management teacher in the second area can also remotely review and sign on the spot, and the return record can be checked through the return management 1123.

[0202] Among them, waste liquid management 1124 exchanges information with the hazardous chemicals waste historical record database. The second-level regional management teacher submits an application for the disposal of hazardous chemicals, and the third-level superior management teacher - the building manager discards the hazardous chemicals and transmits the waste information to the hazardous chemicals waste historical record database.

[0203] Among them, the inspection management 1125 and the inspection rectification 1126 inspection databases exchange information. The fourth-level general administrator conducts inspection management 1125, and the corresponding second-level regional management teacher makes rectifications according to the rectification opinions and then submits an application for review again until the inspection is passed.

[0204] Among them, category list 1127 exchanges information with the hazardous chemicals dictionary database.

[0205] The approval management 1128 exchanges information with the central database, and the user can directly view the hazardous chemicals inventory addition bar chart 11281, inventory details 11282 and can view them by category and region 11283.

[0206] The operation log 1129 exchanges information with the central database, and the user can check the approval, quantity, and time of warehousing, collection, and return from the operation log 1129.

[0207] The message 12 interface includes four modules: warehouse message 121, inspection message 122, collection message 123 and task message 124, and all of them interact with the central database.

[0208] Among them, warehouse message 121 is analyzed according to the central database, and warns the responsible area warehouse for excess inventory and the responsible area warehouse for insufficient drug inventory; among them, inspection message 122 checks the inspection feedback; among them, the collection message 123 module reminds the application for collection, return and signature records in the responsible area; among them, task message 124 includes regular, single or periodic inspection tasks and waste liquid treatment tasks for issuance reminders.

[0209] The interface of my 13 includes display modules of name 131 and authority 132, wherein my 13 interacts with the central database for information, wherein the user's records of receipt 133, return record 134 and inspection task 135 can be viewed.

[0210] The PC terminal includes six interfaces: home page 21, authority management 22, dictionary management 23, area management 24, task center 25 and data center 26.

[0211] The home page 21 interface directly displays a hazardous chemicals inventory statistics bar chart 211 module based on information transmitted from the hazardous chemicals inventory database, and can view the 212 module by category and region.

[0212] The authority management 22 interface transmits the administrator information to the administrator database, classifies the authority of different users through the role management 221 module, selectively displays the real-time data collected from the database through the rule management 222 module, and allocates authority through the administrator management 223 module.

[0213] The dictionary management 23 interface exchanges information with the hazardous chemicals dictionary database, adds, reduces and modifies types through the hazardous chemicals type 231 module, and adds or reduces hazardous chemicals types through the hazardous chemicals registration 232 module.

[0214] The regional management 24 interface interacts with the hazardous chemicals inventory database, and the hazardous chemicals waste history record database transmits information to the regional management 24, wherein the regional management 24 includes a regional classification 241 module for setting the hazardous chemicals storage location and a regional inventory 242 module for viewing details.

[0215] The task center 25 interface includes inspection tasks and waste liquid tasks that are issued regularly, once or periodically after processing the information transmitted by the hazardous waste history database and the inspection database.

[0216] The data center 26 interface exchanges information with the central database 4, including a module for directly viewing the inspection report 261, a module for obtaining data 262, and a module for operating logs 263, and can export inspection reports and hazardous chemicals registration forms.

[0217] On the student side, fill in student information through the WeChat applet, scan the QR code on the hazardous chemicals cabinet to submit an application, and when returning the hazardous chemicals, the teacher in charge of the first area scans the QR code on the cabinet to return the chemicals.

[0218] In the above embodiment,

[0219] The tree-like organizational structure is displayed on the PC side, and supports adding, modifying, querying, viewing, and deleting information of each department, and supports maintaining information such as the person in charge and members of the department.

[0220] On the PC side, it supports account creation, modification, query, activation, deactivation, deletion, password modification and other functions; it supports account password, department, name and other information maintenance; it supports batch import and export of account information. Role is a collection of operating permissions within the system, similar to real-life positions; the system has built-in common roles, including system administrator, teacher, student, laboratory technician, etc.; it supports user-defined roles, and supports role creation, modification, permission configuration, and deletion.

[0221] On the PC side, you can centrally manage information such as buildings, floors, and rooms. You can add room information by importing and manually adding it. You can add, edit, modify, and import information on laboratories, warehouses, and other places. You can also edit information such as the laboratory's location, person in charge of safety, and the person in charge's contact information.

[0222] On the PC side, you can take inventory of the actual number of goods in the warehouse and storage locations, and support inventory by scanning codes through the APP side; after the inventory, you can automatically adjust the inventory quantity through profit and loss processing to achieve a balance between inventory quantity profit and loss.

[0223] System administrators can maintain basic information such as the name, brand, and specifications of reagents and consumables, and support manual addition and batch import of new information; administrators can classify reagents and consumables, and set labels; they can batch set the inventory limit, expiration warning days, validity period, default location, and whether to return reagents and consumables.

[0224] It displays the statistical overview of the incoming, inventory, withdrawal, and outgoing data for this week, the past week, this month, and this year; including the statistics and lists of the top five commodities in terms of incoming, current inventory, withdrawal, and outgoing quantities; it can perform incoming, inventory, withdrawal, and statistical analysis of reagents and consumables according to products, operators, and departments, display monthly statistical data, and can export them into Excel tables.

[0225] In one embodiment, the category list 1127 and the dictionary management 23 both interact with the hazardous chemicals dictionary database to add hazardous chemicals categories; adding hazardous chemicals categories includes the following steps:

[0226] A1. Start entering the types of hazardous chemicals;

[0227] A2. Fill in the name of hazardous chemicals;

[0228] A3. Select the hazard level and medium of hazardous chemicals;

[0229] Hazard level: Level 1 is highly toxic / reflective, Level 2 is hazardous, Level 3 is explosive, Level 4 is flammable and explosive, Level 5 is corrosive, Level 6 is toxic, and Level 7 is others.

[0230] Medium: liquid, solid

[0231] A4 determines whether to fill in the name, select the hazard level and the medium. If yes, it jumps to step A5; if not, it jumps to step A2;

[0232] A5 is stored in the dictionary;

[0233] A6 The entry of hazardous chemicals categories is completed.

[0234] In one embodiment, the warehousing management includes the following steps:

[0235] B1. Start storage;

[0236] B2. Select the area, floor, department and cabinet to be stored; jump to B4;

[0237] B3, scan the QR code of the storage cabinet; jump to B4;

[0238] B4. Call data from the hazardous chemicals dictionary database to display the hazardous chemicals in the cabinet, and then select the hazardous chemicals;

[0239] B5. Fill in the storage quantity and submit the storage application;

[0240] B6. Determine whether the hazardous chemicals in the cabinet exceed the cabinet capacity after storage; if so, proceed to step B7; if not, jump to step B13;

[0241] B7, the first regional management teacher determines whether the goods are correctly put into storage; if so, proceed to step B8; if not, jump to step B14;

[0242] B8. The first regional management teacher uses the APP to scan the QR code on the cabinet and signs at the warehousing approval area;

[0243] B9, the second regional management teacher determines whether the goods are correctly put into storage; if so, continue to step B10; if not, jump to step B14;

[0244] B10. The second regional management teacher signs at the APP entry approval section;

[0245] B11. Through storage, data is transmitted to the hazardous chemicals inventory database;

[0246] B12, this storage is completed;

[0247] B13, alert the superior management teacher and jump to step B5;

[0248] B14. Storage fails and feedback is given to the applicant.

[0249] In the above embodiment, students and teachers register the name, brand, specification, item number, purity, storage location and other information of reagents and consumables on the warehousing interface, and generate a warehousing order after submission, or generate a warehousing order through Excel import to complete the registration of goods to be entered into the warehouse; then take the items to the reagent and consumables warehouse, confirm the warehousing order through a mobile phone or smart terminal, and complete the actual entry of the items into the warehouse.

[0250] You can query the name, brand, specification, storage location, date, quantity and other attributes of inventory goods in real time; view the operation log of the goods, including detailed information on warehousing, outbound and return operations; you can print the QR code of the inventory, stick it on the surface of the item, and scan the code to view the detailed inventory information of the current reagents and consumables; you can quickly query the inventory information of reagents and consumables by type, warehouse location, name, CAS number, etc.; when the inventory is insufficient, over limit, or the reagents and consumables are about to expire or have expired, the system will automatically warn or alarm, and users can receive reminder messages through the system or SMS or email; controlled chemicals such as explosives, drugs, and highly toxic chemicals support single code management, and each bottle of chemical can be assigned a unique number. Operations such as outbound, return, and inventory are all accurately managed to specific numbers of hazardous chemicals.

[0251] In one embodiment, the approval management includes the following steps:

[0252] D1. Start approval management;

[0253] D2. The first regional management teacher opens the corresponding cabinet for applying for hazardous chemicals and scans the QR code inside the cabinet;

[0254] D3. The first regional management teacher determines whether the application has passed the review. If yes, the process goes to step D4. If no, the process goes to steps D5 and D6 at the same time.

[0255] D4. The first regional management teacher signs on site;

[0256] D5. Release the frozen usage and send a signal to the hazardous chemicals inventory database;

[0257] D6. Feedback: The application failed to pass the review;

[0258] D7, the second regional management teacher conducts on-site or remote review to see if the application has passed the review; if so, jump to step D8; if not, jump to steps D5 and D6 at the same time;

[0259] D8. The second regional management teacher signs and sends a signal to the hazardous chemicals inventory database and the return record database;

[0260] D9. The warehousing, collection and return were approved successfully.

[0261] In one embodiment, the student end and the application for use include the following steps:

[0262] C1. Students use WeChat and teachers use APP to apply for the service;

[0263] C2. Scan the QR code on the corresponding cabinet;

[0264] C3. Select the hazardous chemicals used in the experiment from the hazardous chemicals names provided by the hazardous chemicals dictionary database; and jump to steps C4 and C5 at the same time;

[0265] C4. It can be seen that the existing surplus of the hazardous chemicals;

[0266] C5. Fill in the dosage;

[0267] C6. Determine whether the applied amount is met based on the hazardous chemicals inventory database and the filled amount; if so, jump to step C8; if not, jump to step C7;

[0268] C7. Give reminders to the regional management teacher;

[0269] C8. Freeze the selected amount and transmit the signal to the hazardous chemicals inventory database;

[0270] C9, determine whether the person borrowing the card is a person of level 3 or below; the person levels include level 1 students, level 2 regional management teachers, level 3 superior management teachers - building managers, and level 4 supervisors - general administrators; if yes, jump to step C10; if no, jump to step C11;

[0271] C10. Fill in the return date;

[0272] C11. Optional return time;

[0273] C12. Confirm the application and submit it.

[0274] In the above embodiment, students and teachers can collect reagents and consumables online or on the go. The collection interface displays all available items. After selecting an item, enter the collection quantity, arrival time, use time, use location and other information and submit for approval. A separate approval process can be set for controlled chemicals.

[0275] After approval, you can go to the warehouse to pick it up according to regulations;

[0276] It supports printing of collection orders and generating collection QR codes. You can scan the QR codes to quickly view collection details.

[0277] After the application is approved, you can go to the warehouse with a paper or electronic receipt to collect the goods. There are two ways: the regional management teacher will issue the goods uniformly, and the students and teachers will issue the goods independently.

[0278] After students and teachers take out reagents and consumables, they check the items and the receipt on their mobile phones or smart terminals to complete the outbound registration;

[0279] Hazardous chemicals managed with a single code or other items that require refined management can be checked by scanning the code, reducing the effort of manual checking.

[0280] In one embodiment, the return management includes the following steps:

[0281] E1, start the return application; jump to steps E2 and E3 at the same time;

[0282] E2. Return hazardous chemicals when they are about to expire and notify the regional management teacher;

[0283] E3. Scan the QR code to return the cabinet;

[0284] E4, input the amount returned;

[0285] E5. The first regional management teacher determines whether the return is qualified; if so, jump to step E6; if not, jump to step E7;

[0286] E6. The first regional management teacher signs on site;

[0287] E7, Feedback to the student side: return unqualified;

[0288] E8. The second regional management teacher will conduct on-site or remote review to determine whether the returned product is qualified; if so, jump to step E9; if not, jump to step E7;

[0289] E9. The second regional management teacher signs and sends a signal to the return record database and hazardous chemicals inventory database at the same time;

[0290] E10. This return is successful.

[0291] In the above embodiment,

[0292] Students and teachers can check the reagents and consumables in their hands. For items that do not need to be returned, they can register their usage and consumption. Items that need to be returned will automatically receive a return reminder notification and return the items to the reagent warehouse within the specified time and register the return. If items that need to be returned have actually been consumed or are used for other purposes and cannot be returned, the reasons can be registered and the warehouse keeper can be notified;

[0293] Regional management teachers can check the distribution location of out-of-warehouse reagents and consumables, students and teachers who apply for them, places of use, expected return time and other information at any time in the off-warehouse goods. They can also send return reminder messages to achieve unified management and control of goods inside and outside the warehouse.

[0294] In one embodiment, waste management comprises the following steps:

[0295] F1. Start waste liquid management;

[0296] F2, the regional management teacher selects the management area;

[0297] F3. Fill in the amount of waste liquid and sign;

[0298] F4. The superior manager / building manager empties the waste liquid and sends a signal to the hazardous waste history database;

[0299] F5. Remove waste liquid from the cabinet;

[0300] F6. Waste liquid treatment is completed.

[0301] In one embodiment, the supervision management includes the following steps:

[0302] G1. Receive inspection tasks;

[0303] G2. Open the supervision management;

[0304] G3. Scan the QR code of the cabinet;

[0305] G4, determine whether the user is a fourth-level personnel; if so, jump to step G6; if not, jump to step G5;

[0306] G5, display no permission; jump to step G2;

[0307] G6. Pop-up inspection report;

[0308] G7. Fill in the inspection time and area;

[0309] G8, the supervisor-general administrator determines whether the inspection is passed; if so, jump to step G9; if not, jump to step G10;

[0310] G9. After all the information is passed, the supervisor will sign.

[0311] G10, inspect the teacher to fill in the problem;

[0312] G11. After rectification, fill in the rectification status and submit the re-inspection application; jump to step G2;

[0313] G12. Send a signal to the inspection database, and the inspection is completed.

[0314] In the above embodiment, the system automatically allocates inspection tasks according to the inspected laboratories and inspectors in the inspection plan. The inspectors carry out inspections and patrol activities according to the plan and register the inspection results. The content and basis of the safety inspection can be exported as an Excel table. It supports online filling of inspection conditions and inspection evaluations, and can quickly complete safety inspections and upload on-site pictures on site through mobile terminals. After the inspection is completed, if all inspection items are qualified, the system automatically generates an inspection report. If unqualified items or safety hazards are found during the safety inspection, safety rectification will be initiated. The inspector initiates a safety rectification notice, specifies the person in charge of the rectification, rectification items and rectification period, and the system automatically notifies the person in charge to make rectifications.

[0315] After receiving the rectification notice, the person in charge of rectification will check the rectification items, rectification deadline, on-site photos and other information on the rectification page; after carrying out the actual rectification, he / she will fill in the rectification description and implementation status, and can quickly complete the rectification and implementation status and upload on-site photos on-site through the mobile terminal, and then submit them for review.

[0316] After the inspection is completed, the system automatically generates a safety inspection report, which includes the inspection status of all inspection items, inspection evaluation, rectification date, rectification and implementation status, uploaded pictures, etc.

[0317] Supports re-editing of the safety inspection report, which will enter the approval process after submission and can be printed after approval;

[0318] Supports editing of safety inspection report templates.

[0319] The present invention is described in detail above with reference to the accompanying drawings by using a specific embodiment of a hospital hazardous chemicals safety management system and method. However, those skilled in the art should understand that the above description is only an example to illustrate and describe some specific implementation methods, and does not have any limitation on the scope of the present invention, especially the scope of the claims.

Claims

1. A hospital hazardous chemicals safety management system, characterized in that: It is equipped with modules for warehouse entry management, approval management, storage management, application for use, return management, waste management, inspection management, data statistics and operation log, which are respectively connected to the central database (4); The central database (4) adopts MySQL5.7 database, including an administrator database, a hazardous chemical inventory database, a collection and return record database, a hazardous chemical waste history database, an inspection database and a hazardous chemical dictionary database; The administrator database uses the Thinkphp basic framework and the Eggjs framework to divide personnel into first-level students, second-level regional management teachers, third-level superior management teachers - building managers and fourth-level supervisors - general administrators; The central database (4) respectively exchanges information with the APP (1), the PC end (2) and the student end (3) through the high-speed cache and message queue proxy Redis, Nginx high-performance http and reverse proxy, and adopts the B / S architecture, i.e. the browser and server architecture, for human-computer interaction; The warehousing management transmits a signal to the hazardous chemicals dictionary database and the hazardous chemicals inventory database in the central database (4), increases or decreases the hazardous chemicals category data in the hazardous chemicals dictionary database, and increases the hazardous chemicals quantity data in the hazardous chemicals inventory database; the approval management, storage management, receipt application, and return management transmit the hazardous chemicals approval, receipt and return information to the receipt record database and the hazardous chemicals inventory database; The central database (4) transmits a signal to the PC terminal to consult the database. The PC terminal (2) can set personnel management permissions to form an administrator database and transmit it to the central database (4); The first-level students use a student terminal (3) for scanning a QR code using WeChat, and the student terminal (3) is connected to a central database (4). The collection and return record database and the hazardous chemicals inventory database in the central database (4) respectively interact with the student terminal (3); the operation log is generated using egg-logger for log monitoring.

2. A management method for implementing the hospital hazardous chemicals safety management system according to claim 1, characterized in that: It is equipped with a mobile APP (1), a PC (2), and a student terminal (3) with greater mobility; The first-level students use the student terminal (3) for scanning the QR code in the storage area to apply for the use of the hazardous chemicals. The student terminal (3) is connected to the central database (4), and the information on the hazardous chemicals and the quantity applied for by the students is transmitted to the collection and return record database and the hazardous chemicals inventory database. The collection and return record database simultaneously sends an application reminder to the regional management teacher of the corresponding area, and freezes the quantity of the hazardous chemicals applied for in the hazardous chemicals inventory database. The second-level regional management teacher, the third-level superior management teacher - the building manager and the fourth-level supervisor - the general administrator use a mobile phone APP (1) to perform storage management, approval management, storage management, application for use, return management, waste management and supervision management. At the same time, data statistics and operation logs can be viewed through the APP (1). The mobile phone APP (1) is connected to the central database (4) to transmit data to the central database (4); the storage management transmits the name, storage area and location information of the hazardous chemicals to the hazardous chemicals dictionary database, and transmits the storage quantity of hazardous chemicals to the hazardous chemicals inventory database; Waste management is carried out by the second-level regional management teacher who submits an application for hazardous chemical waste disposal, and the third-level superior management teacher - the building manager discards the hazardous chemicals and transmits the waste information to the hazardous chemical waste history database. Supervision management is carried out by the fourth-level supervisor - the general administrator to conduct a single, regular or periodic inspection of the purchase, storage, use and waste disposal of hazardous chemicals. The second-level regional management teacher of the corresponding area will make rectifications and transmit the inspection and rectification results to the supervision database; the collection and return record database, hazardous chemical inventory database, hazardous chemical dictionary database, hazardous chemical waste history database and supervision database of the central database (4) exchange information in real time; The central database (4) can be consulted through the PC terminal (2), the inspection database can export inspection reports through the PC terminal (2), and the return record database, the hazardous chemical inventory database and the hazardous chemical waste history record database can export the hazardous chemical registration form through the PC terminal (2).

3. The management method according to claim 2, characterized in that: The APP (1) includes three interfaces: home page (11), message (12) and my (13); The home page (11) interface includes two parts: use management (111) and operation management (112); The collection management (111) includes two modules: checking the number of items to be approved in the responsible area (1111) and collection and approval scanning (1112). The module for checking the number of items to be approved in the responsible area (1111) can view the approved number and the number to be approved in real time. When a teacher applies for collection of items, he / she scans the QR code on the storage cabinet through the collection and approval scanning (1112). When the first area management teacher is approving the student's application for collection, he / she also needs to scan the QR code on the storage cabinet. The collection management (111) exchanges information with the hazardous chemicals storage database and the collection and return record database. The operation management (112) includes approval management (1121), warehousing (1122), return management (1123), waste liquid management (1124), supervision management (1125), supervision and rectification (1126), category list (1127), approval management (1128) and operation log (1129); The approval management (1121) includes the approval of the use of the responsible area (11211), the approval of the storage (11212) and the supervision and rectification (11213); the approval of the use (11211) exchanges information with the collection and return record database, checks the application for the use of hazardous chemicals in the responsible area, and makes a judgment and approval. The first area management teacher scans the QR code on the storage cabinet and signs the student's application for use. The second area management teacher can also remotely approve and sign on the spot; the storage approval (11212) exchanges information with the hazardous chemical storage database, checks the storage application for hazardous chemicals in the responsible area, and makes a judgment and approval to determine whether the storage application is passed; The storage (1122) exchanges information with the hazardous chemicals storage database. When the storage application is passed and stored in the corresponding storage cabinet, the hazardous chemicals storage database changes. The storage (1122) module can also be used to view the number of hazardous chemicals stored in the storage cabinet in the corresponding area. The return management (1123) exchanges information with the return record database and the hazardous chemicals storage database. When the user returns the goods, the first area management teacher scans the QR code on the storage cabinet, puts the hazardous chemicals back and signs. The second area management teacher can also remotely review and sign on site. The return record can be checked through the return management (1123). The waste liquid management (1124) exchanges information with the hazardous chemical waste historical record database. The second-level regional management teacher submits an application for hazardous chemical waste disposal, and the third-level superior management teacher - the building manager discards the hazardous chemical and transmits the waste information to the hazardous chemical waste historical record database. The said supervision management (1125) and supervision rectification (1126) supervision databases exchange information, and the fourth-level general administrator conducts supervision management (1125), and the corresponding second-level regional management teacher makes rectifications according to the rectification opinions, and then submits the review application again until the supervision is passed; The category list (1127) exchanges information with the hazardous chemicals dictionary database; The approval management (1128) exchanges information with the central database, and the user can directly view the hazardous chemicals inventory addition bar chart (11281), inventory details (11282) and can view by category and region (11283); The operation log (1129) exchanges information with the central database, and the user can check the approval, quantity, and time of storage, collection, and return from the operation log (1129); The message (12) interface includes four modules: warehouse message (121), inspection message (122), requisition message (123) and task message (124), and all of them interact with the central database; The warehouse message (121) is analyzed according to the central database to warn the warehouse in the responsible area of ​​overstocking and the warehouse in the responsible area of ​​insufficient drug inventory; the inspection message (122) checks the inspection feedback; the collection message (123) module reminds the application, return and signature records in the responsible area; the task message (124) includes regular, single or periodic inspection tasks and waste liquid treatment tasks for release reminders; The My (13) interface includes display modules for name (131) and authority (132). The My (13) interacts with the central database, wherein the user's records can be viewed in the collection records (133), return records (134) and inspection tasks (135); The PC terminal includes six interfaces: home page (21), authority management (22), dictionary management (23), area management (24), task center (25) and data center (26); The home page (21) interface directly displays a hazardous chemicals inventory statistics bar chart (211) module based on information transmitted from the hazardous chemicals inventory database, and can view modules by category and region (212); The authority management (22) interface transmits administrator information to the administrator database, classifies the authority of different users through the role management (221) module, selectively displays the real-time collected data of the database through the rule management (222) module, and allocates authority through the administrator management (223) module; The dictionary management (23) interface exchanges information with the hazardous chemicals dictionary database, adds, removes and modifies the types through the hazardous chemicals type (231) module, and adds or removes the types of hazardous chemicals through the hazardous chemicals registration (232) module; The regional management (24) interface exchanges information with the hazardous chemicals inventory database, and the hazardous chemicals waste history database transmits information to the regional management (24), and the regional management (24) includes a regional classification (241) module for setting the hazardous chemicals storage location and a regional inventory (242) module for viewing details; The task center (25) interface includes inspection tasks and waste liquid tasks that are issued regularly, once or periodically after processing the information transmitted by the hazardous chemical waste history database and the inspection database; The data center (26) interface exchanges information with the central database (4), including a module for directly viewing the inspection report (261), a module for obtaining data (262) and an operation log (263), and can export the inspection report and the hazardous chemicals registration form, etc.; The student end fills in the student information through the WeChat applet, scans the QR code on the hazardous chemicals cabinet to submit an application, and when returning the hazardous chemicals, the teacher in charge of the first area scans the QR code on the cabinet to return the hazardous chemicals.

4. The management method according to claim 3, characterized in that: The category list (1127) and dictionary management (23) both interact with the hazardous chemicals dictionary database to add hazardous chemicals categories. Adding hazardous chemicals categories includes the following steps: A1. Start entering the types of hazardous chemicals; A2. Fill in the name of hazardous chemicals; A3. Select the hazard level and medium of hazardous chemicals; Hazard level: Level 1 is highly toxic / radioactive source, Level 2 is easy to make drugs, Level 3 is easy to make explosives, Level 4 is flammable and explosive, Level 5 is corrosive, Level 6 is toxic and Level 7 is other general categories; Medium: liquid, solid; A4 determines whether to fill in the name, select the hazard level and the medium. If yes, it jumps to step A5; if not, it jumps to step A2; A5 is stored in the dictionary; A6 The entry of hazardous chemicals categories is completed.

5. The management method according to claim 2, characterized in that: The warehousing management includes the following steps: B1. Start storage; B2. Select the area, floor, department and cabinet to be stored; jump to B4; B3, scan the QR code of the storage cabinet; jump to B4; B4. Call data from the hazardous chemicals dictionary database to display the hazardous chemicals in the cabinet, and then select the hazardous chemicals; B5. Fill in the storage quantity and submit the storage application; B6. Determine whether the hazardous chemicals in the cabinet exceed the cabinet capacity after storage; if so, proceed to step B7; if not, jump to step B13; B7, the first regional management teacher determines whether the goods are correctly put into storage; if so, proceed to step B8; if not, jump to step B14; B8. The first regional management teacher uses the APP to scan the QR code on the cabinet and signs at the warehousing approval area; B9, the second regional management teacher determines whether the goods are correctly put into storage; if so, continue to step B10; if not, jump to step B14; B10. The second regional management teacher signs at the APP entry approval section; B11. Through storage, data is transmitted to the hazardous chemicals inventory database; B12, this storage is completed; B13, alert the superior management teacher and jump to step B5; B14. Storage fails and feedback is given to the applicant.

6. The management method according to claim 2, characterized in that: The approval management includes the following steps: D1. Start approval management; D2. The first regional management teacher opens the corresponding cabinet for applying for hazardous chemicals and scans the QR code inside the cabinet; D3. The first regional management teacher determines whether the application has passed the review. If yes, the process goes to step D4. If no, the process goes to steps D5 and D6 at the same time. D4. The first regional management teacher signs on site; D5. Release the frozen usage and send a signal to the hazardous chemicals inventory database; D6. Feedback: The application failed to pass the review; D7, the second regional management teacher conducts on-site or remote review to see if the application has passed the review; if so, jump to step D8; if not, jump to steps D5 and D6 at the same time; D8. The second regional management teacher signs and sends a signal to the hazardous chemicals inventory database and the return record database; D9. The warehousing, collection and return were approved successfully.

7. The management method according to claim 2, characterized in that: The student end and the application for use include the following steps: C1. Students use WeChat and teachers use APP to apply for the service; C2. Scan the QR code on the corresponding cabinet; C3. Select the hazardous chemicals used in the experiment from the hazardous chemicals names provided by the hazardous chemicals dictionary database; and jump to steps C4 and C5 at the same time; C4. It can be seen that the existing surplus of the hazardous chemicals; C5. Fill in the dosage; C6. Determine whether the applied amount is met based on the hazardous chemicals inventory database and the filled amount; if so, jump to step C8; if not, jump to step C7; C7. Give reminders to the regional management teacher; C8. Freeze the selected amount and transmit the signal to the hazardous chemicals inventory database; C9, determine whether the person borrowing the card is a person of level 3 or below; the person levels include level 1 students, level 2 regional management teachers, level 3 superior management teachers - building managers, and level 4 supervisors - general administrators; if yes, jump to step C10; if no, jump to step C11; C10. Fill in the return date; C11. Optional return time; C12. Confirm the application and submit it.

8. The management method according to claim 2, characterized in that: The return management includes the following steps: E1, start the return application; jump to steps E2 and E3 at the same time; E2. Return hazardous chemicals when they are about to expire and notify the regional management teacher; E3. Scan the QR code to return the cabinet; E4, input the amount returned; E5. The first regional management teacher determines whether the return is qualified; if so, jump to step E6; if not, jump to step E7; E6. The first regional management teacher signs on site; E7, Feedback to the student side: return unqualified; E8. The second regional management teacher will conduct on-site or remote review to determine whether the returned product is qualified; if so, jump to step E9; if not, jump to step E7; E9. The second regional management teacher signs and sends a signal to the return record database and hazardous chemicals inventory database at the same time; E10. This return is successful.

9. The management method according to claim 2, characterized in that: The waste management comprises the following steps: F1. Start waste liquid management; F2, the regional management teacher selects the management area; F3. Fill in the amount of waste liquid and sign; F4. The superior manager / building manager clears the waste liquid and sends a signal to the hazardous waste history database F5. Remove waste liquid from the cabinet; F6. Waste liquid treatment is completed.

10. The management method according to claim 2, characterized in that: The supervision management includes the following steps: G1. Receive inspection tasks; G2. Open the supervision management; G3. Scan the QR code of the cabinet; G4, determine whether the user is a fourth-level personnel; if so, jump to step G6; if not, jump to step G5; G5, display no permission; jump to step G2; G6. Pop-up inspection report; G7. Fill in the inspection time and area; G8, the supervisor-general administrator determines whether the inspection is passed; if so, jump to step G9; if not, jump to step G10; G9. After all the information is passed, the supervisor will sign. G10, inspect the teacher to fill in the problem; G11. After rectification, fill in the rectification status and submit the re-inspection application; jump to step G2; G12. Send a signal to the inspection database, and the inspection is completed.

Images