Laboratory original record registration system based on HTML5 technology
Through the laboratory original record registration system based on HTML5 technology, the problems of data entry errors and losses in traditional laboratory testing are solved, efficient and secure data management is achieved, and cross-platform compatibility and good user experience is provided.
Patent Information
- Application Number
- CN202411456697.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-18
- Publication Date
- 2024-11-15
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
During traditional laboratory testing, there are problems such as data entry errors, risk of data loss and inefficiency, especially because manual copying and paper recordings are easy to be damaged and inconvenient for long-term storage.
The laboratory original record registration system based on HTML5 technology, including front-end modules and back-end modules, supports file upload, Canvas editing, data entry and display, interact with the back-end through the API interface, realizes data verification, conversion and storage, and HTTPS encrypted transmission and Service Worker technology are used for offline data caching and synchronization.
Improve the accuracy and efficiency of data entry, reduce the risk of paper records loss, provide good user experience and data security, ensure the security of data during transmission and storage, and can still be achieved when the network is unstable. Normal input and editing.
Smart Images

Figure CN118967072A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of laboratory test data management, and in particular to a laboratory original record registration system based on HTML5 technology. Background Art
[0002] Traditional laboratories usually use pre-designed Word or Excel templates to register original records during the testing process. During the testing process, the experimenter prints it out and fills in the experimental data manually. After the experiment is completed, the paper records are copied or entered into the corresponding electronic documents or software systems. This method has the following problems: (1) Data entry errors: Data recording errors are prone to occur during manual transcription.
[0003] (2) Data loss risk: Paper records are easily lost or damaged, making them inconvenient for long-term preservation and future auditing.
[0004] (3) Inefficiency: The manual filling and copying process is cumbersome and time-consuming, affecting work efficiency.
[0005] To this end, we propose a laboratory original record registration system based on HTML5 technology. Summary of the invention
[0006] The purpose of the present invention is to provide a laboratory original record registration system based on HTML5 technology to solve the problem of data entry errors and data loss in the background technology.
[0007] To achieve the above object, the present invention provides the following technical solutions: a laboratory original record registration system based on HTML5 technology, the laboratory original record registration system based on HTML5 technology includes a front-end module and a back-end module; The front-end module is used to collect uploaded templates, determine whether a new template needs to be created based on the laboratory record content, and edit and input the collected laboratory record data into the template record; The backend module is used to manage the collected laboratory record data, convert and store the laboratory data, and generate laboratory reports; The front-end module includes a file upload module, a Canvas editing module, a data entry module and a data display module; The file upload module is used to upload data from an existing Word file or Excel template file and create an experimental raw data record template; The Canvas editing module is used to display and edit template content on the Canvas canvas in the browser; and supports copying selected content from an existing Word file or Excel template file and pasting it into the Canvas editing module, reformatting it based on the original format, and generating a new experimental raw data record template; or using an existing Word or Excel template to upload it to the system as an experimental raw data record template.
[0008] The data entry module is used for the operator to directly fill in the test data in the Canvas editing module. After the template is created, the laboratory test items are determined, the template is referenced to register the test data, and the experimental item formula is selected from the system database, and the experimental data recorded in the template is introduced into the formula for calculation to obtain the corresponding experimental results; The data display module is used to display the input data and generated charts in real time, compare and analyze the displayed experimental results, automatically determine the experimental results according to the set conditions, and calculate the test pass rate according to the obtained test results. When the pass rate continues to decrease, a prompt is issued, and the experimental formula and the data recorded in the template are used to reversely calculate the experimental data error points. The backend module includes a file parsing module, a data processing module, a data storage module and a rights management module; The file parsing module is used to parse the uploaded template file and render the template file content into editable elements and formats in the Canvas canvas; The data processing module is used to verify, clean and convert the input data; The data storage module is used to store test data and generate experimental reports; The authority management module is used to implement role-based access control.
[0009] In the process of testing, traditional laboratories usually use pre-designed Word or Excel templates to register original records. This traditional registration method is prone to data entry errors due to manual transcription when in use, and traditional paper documents are easily lost or damaged, which is not conducive to long-term preservation of experimental data. In addition, such traditional recording methods are cumbersome and troublesome, resulting in low work efficiency. The present invention supports importing Word and Excel templates or copying selected content from Word and Excel files and pasting them into the system. The process retains the original format in the document, and on this basis, the data is edited, modified and typeset in real time, and the security and privacy of the data are protected. In addition, the user interaction design and cross-platform compatibility are optimized, and the technical problems of data entry errors and data loss in the process of traditional laboratory test data management are effectively solved. The system not only improves the accuracy and efficiency of experimental data entry and reduces the risk of loss of paper records, but also provides a good user experience and data security protection. It has broad application prospects and market value. The system uses HTTPS encrypted transmission and storage layer encryption to ensure the security of data during transmission and storage, and the role-based access control (RBAC) mechanism ensures that only authorized users can access and operate data, meeting the laboratory's high requirements for data security and privacy protection. Sensitive data in the system can be encrypted and stored to prevent unauthorized access and leakage. The system uses Service Worker technology to achieve offline data caching and synchronization, ensuring that when the network connection is unstable or interrupted, users can still enter and edit data normally, and automatically synchronize data after the network is restored to improve the reliability of the system. The system is developed based on Web technology, and the system can run seamlessly on various operating systems and devices. Users only need a browser to access the system without the need for additional software installation and configuration.
[0010] As a further description of the above technical solution: The front-end module interacts with the back-end module through an API interface. The Canvas editing module is used for users to add, adjust and delete text boxes, tables and graphics on the Canvas.
[0011] As a further description of the above technical solution: The data entry module supports receiving data collected by experimental equipment or sensors through the API interface. The data entry module adopts two methods: manual input and API automatic collection; the data display module uses HTML5 technology to draw charts and forms. When the original record template is configured for the data automatically collected by the API, data processing rules and data conversion rules are set. During the experiment, the system extracts experimental data according to the set data processing rules and data conversion rules.
[0012] As a further description of the above technical solution: The registration system adopts HTTPS encrypted transmission and storage layer encryption to ensure the security of data during transmission and storage, and a role-based access control mechanism to enable authorized users to access and operate data.
[0013] As a further description of the above technical solution: The registration system uses Service Worker technology to achieve offline data caching and synchronization, ensuring that users can still enter and edit data normally when the network connection is unstable or interrupted.
[0014] As a further description of the above technical solution: The registration system is developed based on Web technology, and users access the system through desktop operating systems and mobile devices.
[0015] As a further description of the above technical solution: The registration system is provided with a plug-in mechanism, and the plug-in mechanism is written and integrated with custom plug-ins by third-party developers.
[0016] As a further description of the above technical solution: The data processing module includes data cleaning, conversion and normalization. The preliminary data processing is completed in the front-end module, and the detailed processing is carried out in the back-end module. Data is transmitted between each processing link through the API interface.
[0017] As a further description of the above technical solution: The data processing module also includes equipment data acquisition, detection data entry and upload, data verification and cleaning, data storage and synchronization; Equipment data collection: Users manually input data or API synchronizes test data, and the registration system automatically verifies the format and integrity of the input data; Detection data entry and upload: Users detect data through the interface or automatic collection equipment, and the data is uploaded to the front-end module through the API. The front-end module performs preliminary verification and conversion; Data verification and cleaning: The uploaded data is further verified and cleaned in the front-end module, and abnormal data is marked and processed to ensure data accuracy and consistency; Data storage and synchronization: The cleaned data is stored in the database and classified and managed by device number and inspection date. ServiceWorker technology is used to achieve offline data caching and synchronization.
[0018] Compared with the prior art, the present invention has the following beneficial effects: 1. The present invention supports importing Word and Excel templates or copying selected content from Word and Excel files and pasting it into the system. The process retains the original format in the document, and on this basis, the data is edited, modified and typeset in real time, and the security and privacy of the data are protected. It also optimizes the user interaction design and cross-platform compatibility, and effectively solves the technical problems of data entry errors and data loss in the traditional laboratory test data management process. The system not only improves the accuracy and efficiency of experimental data entry, reduces the risk of paper record loss, but also provides a good user experience and data security, and has broad application prospects and market value; 2. Improve data entry accuracy: By directly entering data into the system, errors in manual transcription can be avoided. Combined with the system's automatic verification function, data entry errors can be effectively reduced and data accuracy can be improved. 3. Reduce the risk of paper record loss: All data are stored in the electronic system, no longer relying on paper records, which reduces the risk of data loss or damage. At the same time, data can be backed up regularly to ensure data security; 4. Improve work efficiency: This system supports importing existing Word or Excel templates into the system and editing and typesetting them on Canvas. You can also copy and paste the text, tables, formulas, statistical charts and other elements that have been typeset in existing Word or Excel into the Canvas editor for secondary editing and typesetting. Users do not need to redesign the template, saving a lot of time. In addition, the intelligent input auxiliary function and automatic save function further improve the input efficiency; 5. Enhanced data security and privacy protection: HTTPS encrypted transmission and storage layer encryption are used to ensure the security of data during transmission and storage, and the role-based access control (RBAC) mechanism ensures that only authorized users can access and operate data, meeting the laboratory's high requirements for data security and privacy protection. In addition, sensitive data in the system can be encrypted and stored to prevent unauthorized access and leakage; 6. Improve user experience: Through intuitive and concise interface design and smooth interactive experience, users can complete data entry and management tasks more easily. Responsive layout design ensures good display on various devices and screen sizes, making it convenient for users to operate anytime and anywhere; 7. Support offline operation: Use Service Worker technology to achieve offline data caching and synchronization, ensuring that users can still enter and edit data normally when the network connection is unstable or interrupted, and automatically synchronize data after the network is restored to improve system reliability.
[0019] 8. Cross-platform compatibility: Developed based on Web technology, the system can run seamlessly on various operating systems and devices. Users only need a browser to access the system without the need for additional software installation and configuration.
[0020] 9. Data error correction: The pass rate of experimental data can be displayed during the data display process, and the user can observe the accuracy of the experimental process based on the displayed pass rate. When the pass rate continues to decline, the user can reverse the cause of the failure, thereby realizing the data reverse of the experimental equipment during the registration process, and calculating the error location based on the selected formula, which is convenient for improving the processing technology. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] Figure 1 This is a structural block diagram of Embodiment 1 of the present invention; Figure 2 It is a schematic diagram of the system flow of the present invention. DETAILED DESCRIPTION
[0022] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0023] Example 1: Please refer to Figure 1-Figure 2 , the present invention provides a technical solution: a laboratory original record registration system based on HTML5 technology, the laboratory original record registration system based on HTML5 technology includes a front-end module and a back-end module; The front-end module is used to collect uploaded templates, determine whether a new template needs to be created based on the laboratory record content, and edit and input the collected laboratory record data into the template record; The backend module is used to manage the collected laboratory record data, convert and store the laboratory data, and generate laboratory reports; The front-end module includes a file upload module, a Canvas editing module, a data entry module and a data display module. The front-end module uses modern Web technology with React.js or Vue.js framework to implement the Canvas editing function; The file upload module is used to upload data from an existing Word file or Excel template file and create a test template; The Canvas editing module is used to display and edit template content on the Canvas canvas in the browser; and supports copying selected content from an existing Word file or Excel template file and pasting it into the Canvas editing module, reformatting it based on the original format, and generating a new experimental raw data record template; or using an existing Word or Excel template to upload it to the system as an experimental raw data record template.
[0024] In the process of determining the template, whether a new template needs to be created is determined based on the following contents: Applicability of existing templates: If the existing Word or Excel templates already contain all the necessary data items and format requirements, you can use these templates directly. If the existing templates do not fully meet your needs, you may need to modify them or create new templates. Changes in data structure: If the laboratory's testing items or equipment change, new data fields or table structures may be required. At this time, new templates need to be created to accommodate these changes.
[0025] If new test items are added or the test standards of old items are changed, the corresponding templates also need to be updated; Changes to the standard: If your lab needs to comply with new industry standards or regulatory requirements, you may need to update the templates to ensure that records comply with the latest regulations.
[0026] For example, if the experimental data criteria change, it is necessary to require the addition of certain data record items, then the existing template may no longer be applicable and a new template needs to be created; Data entry efficiency: If the existing template has efficiency issues during data entry, such as duplicate or redundant data entry, consider creating a new template to optimize the data entry process. If the laboratory often needs to manually enter a lot of the same information, a new template can be created to pre-fill this information to improve efficiency. Data analysis needs: If your lab needs to perform specific types of data analysis, you may want to create new templates to collect specific data to better support your data analysis needs.
[0027] For example, if the lab needs to perform trend analysis on a certain type of data, then it needs to ensure that the template contains the relevant data fields; Template flexibility: If a lab frequently needs to make minor adjustments to the same type of test, it may be beneficial to create flexible templates so that users can easily add or remove data items as needed.
[0028] The data entry module is used for the operator to directly fill in the test data in the Canvas editing module. After the template is created, the laboratory test items are determined, the template is referenced to register the test data, and the experimental item formula is selected from the system database, and the experimental data recorded in the template is introduced into the formula for calculation to obtain the corresponding experimental results; The data display module is used to display the input data and generated charts in real time, compare and analyze the displayed experimental results, automatically determine the experimental results according to the set conditions, and calculate the test pass rate according to the obtained test results. When the pass rate continues to decrease, a prompt is issued, and the experimental formula and the data recorded in the template are used to reversely calculate the experimental data error points. The backend module includes a file parsing module, a data processing module, a data storage module and a rights management module; The file parsing module is used to parse the uploaded template file and convert the template file into a Canvas editable format; The data processing module is used to verify, clean and convert the input data; The data storage module is used to store test data and generate experimental reports; The authority management module is used to implement role-based access control.
[0029] Among them, the front-end module and the back-end module can interact with each other through the API interface, and by importing Word and Excel templates or copying selected content from Word and Excel files and pasting them into the system, the process retains the original format in the document, and on this basis, the data is edited, modified and typeset in real time, and the security and privacy of the data are protected, and the user's interactive design and cross-platform compatibility are optimized, effectively solving the technical problems of data entry errors and data loss in the traditional laboratory test data management process. The system not only improves the accuracy and efficiency of experimental data entry, reduces the risk of paper record loss, but also provides a good user experience and data security guarantee, with broad application prospects and market value, and the imported Word or Excel templates can be edited and typeset on Canvas, and the text, tables, formulas, statistical charts and other elements that have been typeset in the existing Word or Excel can be copied and pasted into the Canvas editor for secondary editing and typesetting. Users do not need to redesign the template, saving a lot of time. In addition, the intelligent input auxiliary function and automatic save function further improve the input efficiency.
[0030] Embodiment 2: The front-end module interacts with the back-end module through an API interface. The Canvas editing module: users can add, adjust and delete text boxes, tables and graphics on the Canvas, and supports mathematical formula insertion and calculation.
[0031] Among them, the set Canvas editing module can edit and layout the imported Word or Excel templates, and can also copy and paste the text, tables, formulas, statistical charts and other elements that have been layout in existing Word or Excel into the Canvas editor for secondary editing and layout. It has a high degree of automation, and can insert pre-designed mathematical formulas, etc., and can directly calculate the corresponding experimental data results after data entry.
[0032] The data entry module supports receiving data collected by experimental equipment or sensors through the API interface, and supports both manual input and automatic sensor collection; the data display module uses HTML5Canvas to draw charts and forms, and updates and displays the detection data and generated charts in real time, supporting visual operations. When the original record template is configured for the data automatically collected by the API, data processing rules and data conversion rules are set. During the experiment, the system extracts experimental data according to the set data processing rules and data conversion rules.
[0033] Among them, the set data entry module can use the API interface to receive data, and the use of manual input and automatic collection can prevent data entry errors and omissions during the data entry process. Moreover, the charts and forms drawn by HTML5 technology can be generated and displayed in real time through the data display module, which is convenient for users to observe and organize the updated data in time.
[0034] The registration system uses HTTPS encrypted transmission and storage layer encryption to ensure the security of data during transmission and storage. The role-based access control mechanism enables authorized users to access and operate data, meeting the laboratory's high requirements for data security and privacy protection.
[0035] Among them, HTTPS encrypted transmission and storage layer encryption can ensure the security of data transmission and storage process, ensure the security of data during access, and encrypt sensitive words in the accessed data, ensuring that the laboratory performs high-standard encryption protection on the data to prevent data leakage.
[0036] The registration system uses Service Worker technology to achieve offline data caching and synchronization, ensuring that users can still enter and edit data normally when the network connection is unstable or interrupted.
[0037] Among them, the set Service Worker technology can complete the data entry and editing process even when the network is disconnected, can provide temporary storage services, and automatically synchronize data after the network is restored, thereby improving the reliability of the system.
[0038] The registration system is developed based on Web technology and supports cross-platform use. Users can access and use the system on desktop operating systems such as Windows, MacOS, Linux, and mobile devices such as IOS and Android.
[0039] Among them, this application can be used across platforms. Through responsive design, the system interface can adapt to different screen sizes and provide a consistent user experience.
[0040] The registration system supports a plug-in mechanism, allowing third-party developers to write and integrate custom plug-ins.
[0041] Among them, users can install data analysis plug-ins to conduct in-depth analysis and visual display of detection data; install import and export plug-ins to import data into other software for processing, or import data from other software.
[0042] Embodiment 3: The data processing module includes data cleaning, conversion and normalization. The preliminary data processing is completed in the front-end module, and the detailed processing is performed in the back-end module. Data is transmitted between each processing link through the API interface.
[0043] The data processing module also includes equipment data acquisition, detection data entry and upload, data verification and cleaning, data storage and synchronization; Equipment data collection: Users manually input data or API synchronizes test data, and the registration system automatically verifies the format and integrity of the input data; Test data entry and upload: Users enter test data through the interface or automatically collect test data, and the data is uploaded to the front-end module through the API, and the front-end module performs preliminary verification and conversion; Data verification and cleaning: The uploaded data is further verified and cleaned in the front-end module, and abnormal data is marked and processed to ensure data accuracy and consistency; Data storage and synchronization: The cleaned data is stored in the database and classified and managed by device number and inspection date. ServiceWorker technology is used to achieve offline data caching and synchronization.
[0044] Use HTML5 technology to draw test forms and charts in the browser. Users can enter and modify data on Canvas. All operations are synchronized to the front-end module in real time to ensure data consistency and security. Based on the collected data and predefined templates, the system can automatically generate test reports in PDF format. Users can view them online or download and print them. All test data and reports in the laboratory can be stored. Users can search for historical data through the retrieval function provided by the system, and perform data analysis and statistics.
[0045] The HTML5 technology achieves an editing experience similar to Word and Excel. Combined with JavaScript libraries (such as Fabric.js or Konva.js), users can freely draw text boxes, tables, graphics and other elements on the Canvas, and support adjusting the position, size and style. Through the MathJax or KaTeX library, users can insert mathematical formulas on the Canvas and automatically calculate the results. For example, users can enter formulas in a table, and the system will automatically update the calculation results and display them in the corresponding cells.
[0046] The registration system and user interaction design focus on improving user experience and operational convenience, including the following aspects: Visual data display: Use HTML5 technology to draw charts and forms to display test data in real time. Data updates are synchronized with charts, and users can interact with charts by dragging, clicking, double-clicking, etc. Intelligent input assistance: This system can automatically complete the input fields to reduce the amount of manual input. It can automatically calculate the results according to the input mathematical formula and fill them into the corresponding cells; Multi-platform compatibility: Responsive layout design ensures a good experience on different devices and screen sizes, supports cross-platform access, and can seamlessly use system functions whether on PC or mobile devices.
[0047] The backend terminal technology stack is: Java Spring Boot, Spring Cloud, Spring Data JPA, MySQL or PostgreSQL database, Redis cache, RabbitMQ message queue, Docker and Kubernetes container orchestration tools.
[0048] Embodiment 4: The back-end module further includes: File parsing service: responsible for receiving template files uploaded by the front-end module, parsing their contents and converting them into editable formats and returning them to the front-end module; Data processing service: responsible for verifying, cleaning and converting the test data uploaded by the front-end module to ensure the accuracy and consistency of the data; Data storage service: responsible for persistent storage of test data and generated reports, using relational databases such as MySQL or PostgreSQL; Report generation service: Generate and store the test report in PDF format based on the test data entered by the user and the predefined template; Permission management service: implement user registration, login, identity authentication and role-based access control to ensure data security; API Gateway Service: Unified management of externally exposed API interfaces, processing request forwarding, load balancing and authority authentication; Configuration management service: Centrally manage the configuration information of each microservice, supporting dynamic refresh and unified management.
[0049] The core functional modules of the back-end module include equipment data collection, detection data collection, data processing, data recording and display, report generation, data storage and retrieval, and user authority management.
[0050] Equipment data collection module: provides an input interface where users can manually enter basic information such as equipment name, model, parameters, etc., and supports barcode or QR code scanning to automatically identify equipment information; Detection data acquisition module: manually input detection data such as voltage, current, power, etc. through instruments and meters, support automatic data collection by sensors, and upload to the registration system through API; Data processing module: The front-end module uses JavaScript to perform preliminary verification and conversion of data, while the back-end module further cleans, normalizes and stores the uploaded data; Data recording and display module: Use HTML5 technology and JavaScript to realize dynamic drawing of detection forms and charts. Users can freely add text boxes, tables and graphics on Canvas and adjust their positions and styles. Enter mathematical formulas in the table, and the system will automatically calculate and display the results.
[0051] Report generation module: Automatically generates a test report in PDF format based on user input and test data. The report template can be customized, including company logo, test date, signature and other information.
[0052] Data storage and retrieval module: Data is stored in the server database, supporting classification management and tag management. It provides keyword and time range retrieval functions to facilitate users to find historical data.
[0053] User rights management module: implements user registration, login and authentication. Different roles (such as administrator, operator, viewer) have different access rights.
[0054] In this system, each module communicates through HTTP RESTful API or message queues (such as RabbitMQ) to ensure the independence and decoupling of each service. Asynchronous communication is used between services to improve the response speed and reliability of the system.
[0055] Among them, HTTP communication is used for synchronous requests, such as file upload, data query and other operations that require immediate response; Message queue: used for asynchronous task processing, such as data processing, report generation and other operations that do not require immediate response, to improve system throughput and performance.
[0056] And the registration system also includes high availability and fault tolerance design; This registration system adopts the following measures to ensure high availability and fault tolerance: Service fuse: Use Hystrix and other fuse mechanisms to prevent chain failures from propagating when a module is unavailable, thus protecting the overall stability of the system. Load balancing: Use Nginx or Spring Cloud LoadBalancer to achieve even distribution of requests and avoid single point bottlenecks; Automatic expansion: Through container orchestration tools such as Kubernetes, automatic expansion and reduction between modules can be achieved, and resource allocation can be dynamically adjusted according to traffic; Log monitoring: Use the ELK (Elasticsearch, Logstash, Kibana) stack or Prometheus+Grafana to monitor system logs and metrics to detect and handle problems in a timely manner.
[0057] Example 5: Input and management of laboratory test data; A laboratory needs to record and manage data from a variety of testing equipment. The traditional method is to manually fill in the test results in a pre-designed Word or Excel template, and then enter it into the computer. This process is time-consuming and prone to errors. After using the system provided by the present invention, the experimenter only needs to import the Word or Excel template into the system, or copy the selected content from the existing Word file or Excel template file and paste it into the Canvas canvas for editing and typesetting, and fill in the test data directly on the Canvas during the subsequent experiment. The system verifies the input data format in real time and saves it automatically. After the experiment, a PDF report is generated and archived, and the user is allowed to retrieve historical data by keywords and time range; The specific steps of this embodiment are as follows: Step 1: The experimenter uploads the designed Word or Excel template file through the system.
[0058] Step 2: The system parses the template content and generates an editable form on the Canvas; or copy the selected content from an existing Word file or Excel template file and paste it into the Canvas canvas for editing and typesetting.
[0059] Step 3: During the experiment, the experimenter fills in the test data directly on Canvas.
[0060] Step 4: The system verifies the data format and range in real time, prompts abnormal data, and automatically saves the data.
[0061] Step 5: After the experiment is completed, the system generates a PDF report based on the predefined template, including company logo, test date, signature and other information.
[0062] Step 6: All data is stored, and users can retrieve and view historical data through the system.
[0063] Example 6: Offline data entry and synchronization; A laboratory is located in an area with poor network coverage, and network interruptions often occur, which prevents data entry from proceeding smoothly. After using the system provided by the present invention, the experimenter can continue to enter and edit data when the network is interrupted, and the system will automatically synchronize the data to the server after the network is restored, ensuring the integrity and continuity of the data.
[0064] The specific steps of this embodiment are as follows: Step 1: When the network is normal, the experimenter logs in to the system and completes the original record template design in the system or enters and edits the experimental data in the Canvas editor; Step 2: When the network is interrupted, the experimenter can still enter and edit data in the Canvas editor, and all input data is saved in the local cache; Step 3: When the network is restored, the system automatically synchronizes the locally cached data to the system to ensure data consistency; Step 4: After the experiment is completed, the system generates a PDF report based on the predefined template and archives it, and all data is stored in the system database.
[0065] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.
Claims
1. A laboratory original record registration system based on HTML5 technology, characterized by: The laboratory original record registration system based on HTML5 technology includes a front-end module and a back-end module; The front-end module is used to collect uploaded templates, determine whether a new template needs to be created based on the laboratory record content, and edit and input the collected laboratory record data into the template record; The backend module is used to manage the collected laboratory record data, convert and store the laboratory data, and generate laboratory reports; The front-end module includes a file upload module, a Canvas editing module, a data entry module and a data display module; The file upload module is used to upload data from an existing Word file or Excel template file and create an experimental raw data record template; The Canvas editing module is used to display and edit the template content on the Canvas canvas in the browser; and copy the selected content from the existing Word file or Excel template file and paste it into the Canvas editing module, and determine whether a new template needs to be created according to the uploaded template file; The data entry module is used for the operator to directly fill in the test data in the Canvas editing module. After the template is created, the laboratory test items are determined, the template is referenced to register the test data, and the experimental item formula is selected from the system database, and the experimental data recorded in the template is introduced into the formula for calculation to obtain the corresponding experimental results; The data display module is used to display the input data and generated charts in real time, compare and analyze the displayed experimental results, automatically determine the experimental results according to the set conditions, and calculate the test pass rate based on the obtained test results. When the pass rate continues to decrease, a prompt is issued, and the experimental results are used to reversely calculate the experimental data error points based on the experimental formula and the data recorded in the template.
2. According to claim 1, a laboratory original record registration system based on HTML5 technology is characterized in that: The backend module includes a file parsing module, a data processing module, a data storage module and a rights management module; The file parsing module is used to parse the uploaded template file and render the template file content into editable elements and formats in the Canvas canvas; The data processing module is used to verify, clean and convert the input data; The data storage module is used to store test data and generate experimental reports; The authority management module is used to implement role-based access control; The front-end module interacts with the back-end module through an API interface. The Canvas editing module is used for users to add, adjust and delete text boxes, tables and graphics on the Canvas.
3. According to claim 2, a laboratory original record registration system based on HTML5 technology is characterized in that: The data entry module supports receiving data collected by experimental equipment or sensors through the API interface. The data entry module adopts two methods: manual input and API automatic collection; the data display module uses HTML5 technology to draw charts and forms. When the original record template is configured for the data automatically collected by the API, data processing rules and data conversion rules are set. During the experiment, the system extracts experimental data according to the set data processing rules and data conversion rules.
4. The laboratory original record registration system based on HTML5 technology according to claim 3 is characterized by: The registration system adopts HTTPS encrypted transmission and storage layer encryption to ensure the security of data during transmission and storage, and a role-based access control mechanism to enable authorized users to access and operate data.
5. According to claim 4, a laboratory original record registration system based on HTML5 technology is characterized in that: The registration system uses Service Worker technology to achieve offline data caching and synchronization, ensuring that users can still enter and edit data normally when the network connection is unstable or interrupted.
6. The laboratory original record registration system based on HTML5 technology according to claim 5 is characterized by: The registration system is developed based on Web technology, and users access the system through desktop operating systems and mobile devices.
7. The laboratory original record registration system based on HTML5 technology according to claim 6 is characterized by: The registration system is provided with a plug-in mechanism, and the plug-in mechanism is written and integrated with custom plug-ins by third-party developers.
8. The laboratory original record registration system based on HTML5 technology according to claim 7 is characterized by: The data processing module includes data cleaning, conversion and normalization. The preliminary data processing is completed in the front-end module, and the detailed processing is carried out in the back-end module. Data is transmitted between each processing link through the API interface.
9. The laboratory original record registration system based on HTML5 technology according to claim 8 is characterized by: The data processing module also includes equipment data acquisition, detection data entry and upload, data verification and cleaning, data storage and synchronization; Equipment data collection: Users manually input data or API synchronizes test data, and the registration system automatically verifies the format and integrity of the input data; Detection data entry and upload: Users detect data through the interface or automatic collection equipment, and the data is uploaded to the front-end module through the API. The front-end module performs preliminary verification and conversion; Data verification and cleaning: The uploaded data is further verified and cleaned in the front-end module, and abnormal data is marked and processed to ensure data accuracy and consistency; Data storage and synchronization: The cleaned data is stored in the database and classified and managed by device number and inspection date. ServiceWorker technology is used to achieve offline data caching and synchronization.
Citation Information
Patent Citations
Virtual-reality combined virtual experiment construction method based on VISA
CN110570735A
Laboratory sample full-period management system
CN112907050A
Laboratory record table online filling method
CN116629224A
