Intelligent serial number generation and management system and method thereof

Abstract

The invention discloses an intelligent serial number generation and management system and a method thereof, and aims to provide an intelligent serial number generation and management system which is efficient, extensible and easy to maintain, ensures the stability, the safety and the usability of the system by integrating various modern Web development technologies and tools, and improves the reliability of the system. Meanwhile, the intelligent serial number generation and management system and the intelligent serial number generation and management method provide abundant functions to meet the requirement of a user for SN management. The system comprises an access layer, an access layer, a service layer, a basic service layer and a database layer, the basic service layer comprises a system file storage library and a main database, the service layer comprises a new SN module, an SN configuration module, an SN application query module, a rule management module and an authority control module, SN generation is carried out in the new SN module, and the access layer is used for accessing the access layer. SN query is carried out through the SN application query module, and SN management is carried out through the rule management module and the authority control module. The method is applied to the technical field of serial number generation and management.

Description

Technical Field

[0001] The present invention is applied to the technical field of serial number generation and management, and in particular relates to an intelligent serial number generation and management system and method thereof. Background Art

[0002] In modern manufacturing and supply chain management, product serial number (SN) management is an important link to ensure product tracking, quality management and after-sales service. Traditional SN management methods mainly rely on manual records or simple spreadsheets. This method has problems such as easy data errors, difficult tracking and untimely information, especially in large-scale production and complex supply chain environments. These problems are particularly prominent. The development background of the SN management system stems from the urgent need of enterprises to improve management efficiency, reduce management costs, improve product quality and meet regulatory requirements. With the development of information technology, the mature application of technologies such as cloud computing, the Internet of Things and big data analysis has provided a broad development space for the innovation of the SN management system. In the existing technical solutions, the improvements to the data service management system are mainly concentrated on automatic serial number generation technology, real-time data synchronization technology, the application of QR code / barcode technology, data analysis and reporting technology and permission management. The existing SN management technology mainly has the disadvantages of low data management and tracking efficiency, insufficient data synchronization and real-time performance, data security and privacy protection issues, and limited system compatibility and scalability. If we can design an intelligent serial number generation and management system and its method that is efficient, scalable and easy to maintain, ensures the stability, security and ease of use of the system by integrating a variety of modern Web development technologies and tools, and provides rich functions to meet users' needs for SN management, then the above problems can be solved. Summary of the invention

[0003] The technical problem to be solved by the present invention is to overcome the shortcomings of the prior art and provide an intelligent serial number generation and management system and method thereof that is efficient, scalable and easy to maintain, ensures the stability, security and ease of use of the system by integrating a variety of modern Web development technologies and tools, and provides rich functions to meet users' needs for SN management.

[0004] The technical solution adopted by the present invention is: the present invention includes an access layer, an access layer, a business layer, a basic service layer and a database layer, the basic service layer includes a system file storage library and a main database, the business layer includes a new SN module, an SN configuration module, an SN application query module, a rule management module and an authority control module, and the intelligent serial number generation and management method includes the following steps: Step A, generating SN in the new SN module; Step B, querying the SN through the SN application query module; Step C: managing SN through the rule management module and the authority control module; The SN generation in step A includes the following subdivision steps: Step A1: The user sets the parameters such as SN generation rule, format and length in the SN configuration requirement module; Step A2: Generate a SN according to the parameters set by the user through the new SN module, and store it in the master database; The SN query in step B includes the following subdivision steps: Step B1: The user enters query conditions on the front-end interface and submits a query request; Step B2, the SN application query module queries the master database for matching SN records according to the query conditions; Step B3: Return the query results to the front-end interface and display the query results on the interface; The SN management in step C includes the following sub-steps: Step C1: The user performs operations such as adding, deleting, modifying, and checking SN on the front-end interface; Step C2: The backend service performs corresponding addition, deletion, modification and query operations on the SN records in the master database according to the user's operation request; Step C3: Return the operation result to the front-end interface and display the operation result on the interface.

[0005] Furthermore, the business layer front end uses the Vue framework and the Element UI component library to build a user interface, and calls the API interface provided by the back end through HTTP libraries such as Axios to realize data display and interactive operations. The front end interface sends requests to the back end according to user operations, receives response data returned by the back end, and then updates the interface display. The business layer uses the Spring Boot framework to build back-end services, performs database operations through JPA, and communicates with the front end through the RESTful API interface.

[0006] Furthermore, the access layer accesses the system through a Web browser and cooperates with the business layer.

[0007] Furthermore, the access layer uses Nginx as a reverse proxy server to receive requests and forward the requests to corresponding backend services according to the configuration. The Nginx includes caching and distribution of static resources and routing forwarding functions.

[0008] Furthermore, the permission control module includes a role management module and a permission management module. The role management module adopts a role-based access control strategy to assign corresponding permissions according to the user's role. The permission control module uses the Spring Security security framework in the back-end service to implement the permission control function, performs access control on the API interface according to the user's role and permission, and encrypts and logs sensitive data and operations.

[0009] Furthermore, the business layer also includes a maintenance management module, which records relevant information of maintenance tasks. The back-end service stores the maintenance records in the master database and queries the maintenance records through the front-end interface.

[0010] Furthermore, the business layer also includes a resource upload management module, the resource upload end of the resource upload management module selects files and submits upload requests through the front-end interface, the back-end server stores the file information in the file repository and transmits the upload results through the front-end interface, the resource download end of the resource upload management module selects files and submits download requests through the front-end interface, and the back-end service selects files in the file repository and sends them to the front-end interface.

[0011] Furthermore, the newly created SN module includes all templates and common templates.

[0012] Furthermore, the authority control module includes administrator authority and common user authority.

[0013] Furthermore, the business layer also includes a homepage module, and the homepage module provides a system entry page.

[0014] The beneficial effects of the present invention are as follows: in terms of serial number generation, its template design is extremely prominent. By presetting a template containing elements such as fixed characters, dates, serial numbers, function versions and check codes, the serial number can be generated quickly and automatically, which greatly improves the efficiency and accuracy of serial number generation and reduces the errors and cumbersome operations that may be caused by manual intervention. In terms of query function, the present invention provides a variety of query mechanisms such as home page display, search box query, and paging search, which facilitates users to quickly locate specific serial numbers in large-scale data. Compared with some traditional technologies that can only perform simple queries or complex query paths, the query of the present invention is more efficient and convenient. At the same time, the rule query and preview function allows users to ensure in advance that the generated serial number meets the requirements, and the authority control ensures the security and standardization of the system operation, so that users of different roles have a reasonable range of functional authority in the system. Whether it is the administrator's management of templates and rules, or the restricted operation of ordinary users, the entire serial number management process can be made more orderly and controllable, suitable for the automated management needs in a large-scale production environment, and effectively improve management efficiency and data accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 It is a schematic diagram of the system architecture of the present invention; Figure 2 It is a flowchart of the implementation of SN management functions; Figure 3 is a flowchart of the permission control module; Figure 4 is a flowchart of the resource upload management module; Figure 5 It is a flowchart of the maintenance management module. DETAILED DESCRIPTION

[0016] like Figure 1 and Figure 2 As shown, in this embodiment, the present invention includes an access layer, an access layer, a business layer, a basic service layer and a database layer, the basic service layer includes a system file repository and a master database, the business layer includes a new SN module, an SN configuration module, an SN application query module, a rule management module and an authority control module, and the intelligent serial number generation and management method includes the following steps: Step A, generating SN in the new SN module; Step B, querying the SN through the SN application query module; Step C: managing SN through the rule management module and the authority control module; The SN generation in step A includes the following subdivision steps: Step A1: The user sets the parameters such as SN generation rule, format and length in the SN configuration requirement module; Step A2: Generate a SN according to the parameters set by the user through the new SN module, and store it in the master database; The SN query in step B includes the following subdivision steps: Step B1: The user enters query conditions on the front-end interface and submits a query request; Step B2, the SN application query module queries the master database for matching SN records according to the query conditions; Step B3: Return the query results to the front-end interface and display the query results on the interface; The SN management in step C includes the following sub-steps: Step C1: The user performs operations such as adding, deleting, modifying, and checking SN on the front-end interface; Step C2: The backend service performs corresponding addition, deletion, modification and query operations on the SN records in the master database according to the user's operation request; Step C3, return the operation result to the front-end interface, and display the operation result on the interface. It can be seen that the file repository is used to store documents, reports and other files generated by the system; MySQL storage is the main database of the system, and MySQL stores all SN-related data, including SN information, product information, user information, etc. MySQL has the characteristics of high performance, high reliability and easy maintenance, and can meet the system's needs for data storage. File storage can use a distributed file system or cloud storage solution to improve the scalability and data security of the system. The new SN module is responsible for generating new SNs and storing them in the database. This module uses an efficient algorithm to ensure that the generated SN is globally unique and difficult to guess. The SN application query module provides SN query functions. Users can query relevant information based on SN, such as product details, production date, etc. The SN configuration module allows users to configure SN generation rules and strategies, such as SN length, character set, etc.

[0017] like Figure 1 As shown, in this embodiment, the front end of the business layer uses the Vue framework and the Element UI component library to build a user interface, and calls the API interface provided by the back end through HTTP libraries such as Axios to realize data display and interactive operations. The front-end interface sends a request to the back end according to the user operation, and receives the response data returned by the back end, and then updates the interface display. The business layer uses the Spring Boot framework to build the back-end service, performs database operations through JPA, and communicates with the front end through the RESTful API interface. It can be seen that the front-end framework is built with the Vue framework and the Element UI component library, providing a rich user interface and interactive experience. The front end realizes data display and interactive operations by calling the API interface provided by the back end. The back-end framework uses the Spring Boot framework to build the back-end service, provides a RESTful API interface, and supports the development mode of front-end and back-end separation. Spring Boot is highly configurable and extensible, which is convenient for rapid development and deployment.

[0018] like Figure 1 As shown, in this embodiment, the access layer accesses the system through a Web browser and cooperates with the business layer. It can be seen that the user accesses the system through a Web browser, and the browser provides a friendly user interface, allowing the user to easily query, configure, and manage SN.

[0019] like Figure 1As shown, in this embodiment, the access layer uses Nginx as a reverse proxy server to receive requests and forward the requests to the corresponding backend services according to the configuration. The Nginx includes the caching and distribution of static resources and the routing forwarding functions. It can be seen that Nginx: As a reverse proxy server, Nginx is responsible for receiving user requests and forwarding the requests to the corresponding backend services according to the configuration. At the same time, Nginx is also responsible for the caching and distribution of static resources, as well as the routing forwarding function, to improve the response speed and availability of the system; JDK: Java Development Kit, which provides an operating environment for backend services.

[0020] like Figure 3 As shown, in this embodiment, the permission control module includes a role management module and a permission management module. The role management module adopts a role-based access control strategy, and assigns corresponding permissions according to the user's role. The permission control module uses the Spring Security security framework in the back-end service to implement the permission control function, and performs access control on the API interface according to the user's role and permission, and encrypts and logs sensitive data and operations. It can be seen that the administrator defines roles and permissions in the role management module, and assigns roles to different user groups or individual users. When the user logs in to the system, the user's access to and operation of the system functions is dynamically controlled according to the user's role and permission. In the back-end service, the Spring Security and other security frameworks are used to implement the permission control function, and the API interface is accessed and controlled according to the user's role and permission, and sensitive data and operations are encrypted and logged to ensure the security and traceability of the system.

[0021] like Figure 5 As shown, in this embodiment, the business layer also includes a maintenance management module, which records the relevant information of the maintenance task, and the back-end service stores the maintenance record in the main database, and queries the maintenance record through the front-end interface. It can be seen that the maintenance personnel record the relevant information of the maintenance task (such as maintenance time, maintenance personnel, maintenance results, etc.) in the maintenance management module, and the back-end service stores the maintenance record in the MySQL database, and the user can query and view the maintenance record on the front-end interface.

[0022] like Figure 4As shown, in this embodiment, the business layer also includes a resource upload management module, the resource upload end of the resource upload management module selects files and submits upload requirements through the front-end interface, the back-end server stores the file information in the file storage library and in the main database, and transmits the upload result through the front-end interface, the resource download end of the resource upload management module selects files and submits download requests through the front-end interface, and the back-end service selects files in the file storage library and sends them to the front-end interface. It can be seen that the user selects the file to be uploaded (such as a zip package, a csv file, etc.) on the front-end interface and submits an upload request. After receiving the upload request, the back-end service stores the file in the file storage service and stores the file information in the MySQL database. After the upload is completed, the upload result is returned to the front-end interface, and the uploaded file information is displayed on the interface; the user selects the file to be downloaded on the front-end interface and submits a download request. The back-end service obtains the file from the file storage service according to the download request and sends the file to the front-end interface for downloading. After the download is completed, the download result is returned to the front-end interface, and the downloaded file information is displayed on the interface.

[0023] like Figure 1 As shown, in this embodiment, the new SN module includes all templates and common templates. It can be seen that the common templates are used to display the templates used recently, and all templates are used to display all available templates.

[0024] like Figure 1 As shown, in this embodiment, the authority control module includes administrator authority and common user authority. It can be seen that the administrator authority is used for template management, rule status control, etc., and the common user authority is limited to specific functions.

[0025] like Figure 1 As shown, in this embodiment, the business layer also includes a homepage module, and the homepage module provides a system entry page. It can be seen that the system entry page is provided to display the main functions and operation entrances of the system.

[0026] Although the embodiments of the present invention are described with practical solutions, they do not constitute limitations on the meaning of the present invention. For those skilled in the art, it is obvious to modify the implementation scheme and combine it with other solutions based on this description.

Claims

1. An intelligent serial number generation and management system and method thereof, the intelligent serial number generation and management system comprising an access layer, an access layer, a business layer, a basic service layer and a database layer, characterized in that: The basic service layer includes a system file repository and a master database, the business layer includes a new SN module, an SN configuration module, an SN application query module, a rule management module and an authority control module, and the intelligent serial number generation and management method includes the following steps: Step A, generating SN in the new SN module; Step B, querying the SN through the SN application query module; Step C: managing SN through the rule management module and the authority control module; The SN generation in step A includes the following subdivision steps: Step A1: The user sets the generation rule, format, length and other parameters of the SN in the SN configuration requirement module; Step A2: Generate a SN according to the parameters set by the user through the new SN module, and store it in the master database; The SN query in step B includes the following subdivision steps: Step B1: The user enters query conditions on the front-end interface and submits a query request; Step B2, the SN application query module queries the master database for matching SN records according to the query conditions; Step B3: Return the query results to the front-end interface and display the query results on the interface; The SN management in step C includes the following sub-steps: Step C1: The user performs operations such as adding, deleting, modifying, and checking SN on the front-end interface; Step C2: The backend service performs corresponding addition, deletion, modification and query operations on the SN records in the master database according to the user's operation request; Step C3: Return the operation result to the front-end interface and display the operation result on the interface.

2. The intelligent serial number generation and management system and method thereof according to claim 1, characterized in that: The business layer front end uses the Vue framework and the Element UI component library to build the user interface, and calls the API interface provided by the back end through HTTP libraries such as Axios to realize data display and interactive operations. The front end interface sends requests to the back end according to user operations, receives response data returned by the back end, and then updates the interface display. The business layer uses the Spring Boot framework to build the back end service, performs database operations through JPA, and communicates with the front end through the RESTful API interface.

3. The intelligent serial number generation and management system and method thereof according to claim 1 is characterized in that: The access layer accesses the system through a Web browser and cooperates with the business layer.

4. The intelligent serial number generation and management system and method thereof according to claim 2, characterized in that: The access layer uses Nginx as a reverse proxy server to receive requests and forward the requests to corresponding backend services according to the configuration. Nginx includes caching and distribution of static resources and routing forwarding functions.

5. The intelligent serial number generation and management system and method according to claim 2, characterized in that: The permission control module includes a role management module and a permission management module. The role management module adopts a role-based access control strategy to assign corresponding permissions according to the user's role. The permission control module uses the Spring Security security framework in the back-end service to implement the permission control function. According to the user's role and permission, the API interface is access controlled, and sensitive data and operations are encrypted and logged.

6. The intelligent serial number generation and management system and method according to claim 2, characterized in that: The business layer also includes a maintenance management module, which records relevant information of maintenance tasks. The back-end service stores the maintenance records in the main database and queries the maintenance records through the front-end interface.

7. The intelligent serial number generation and management system and method according to claim 2, characterized in that: The business layer also includes a resource upload management module. The resource upload end of the resource upload management module selects files and submits upload requirements through the front-end interface. The back-end server stores the file information in the file repository and transmits the upload results through the front-end interface. The resource download end of the resource upload management module selects files and submits download requests through the front-end interface. The back-end service selects files in the file repository and sends them to the front-end interface.

8. The intelligent serial number generation and management system and method thereof according to claim 1, characterized in that: The newly created SN module includes all templates and common templates.

9. The intelligent serial number generation and management system and method thereof according to claim 1, characterized in that: The authority control module includes administrator authority and common user authority.

10. The intelligent serial number generation and management system and method thereof according to claim 1, characterized in that: The business layer also includes a homepage module, which provides a system entry page.

Images