Test fixture management system

Abstract

The invention relates to the technical field of industrial manufacturing informatization, in particular to a test fixture management system. The intelligent test fixture management system realizes full-life-cycle management of a fixture through the dynamic role-based access control authority mechanism, the intelligent conflict detection algorithm and the chain log mechanism, wherein a log data packet generated by the log management module comprises log entries, cryptographic hash values and preorder hash values. Through a dynamic role-based access control authority mechanism, functional level operation isolation of three layers of role super administrators / department administrators / production line personnel is realized. And the authority verification unit intercepts unauthorized operation in real time, and updates the cache in combination with message queue broadcast when the authority is changed, so that the occurrence rate of system unauthorized operation is reduced to 0.3 per year from 23 per year in the industry on average, and the requirement of a security standard on authority control is met.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of industrial manufacturing informatization, and particularly relates to a test fixture management system. BACKGROUND

[0002] As the core process equipment in the field of electronic manufacturing, the test fixture refers to the bearing and connecting tool designed for the test requirements of specific products. The core function of the test fixture is to physically fix the measured object (such as a printed circuit board or a chip module) and establish an electrical path, so as to realize the precise docking between the test instrument and the measured object through a probe array or a signal conversion module. The typical test fixture includes a mechanical positioning structure (such as a carrier plate or a clamping mechanism) and an electrical interface module (such as a high-frequency probe or a relay matrix), and needs to meet the strict precision requirements of a positioning error ≤0.05 mm and an impedance fluctuation ≤5%, so as to ensure the reliability of the functional test results.

[0003] In the industries of consumer electronics, automotive electronics and semiconductor manufacturing, the test fixture bears the key quality control function. For example, in the case of smart phone mainboard testing, the flying probe test frame needs to circulate on the production line 8-10 times a day; the vehicle-grade ECU controller communication verification fixture is exposed to a high-temperature vibration environment for a long time, and the failure rate is significantly higher than that of ordinary equipment; the probe card module for semiconductor wafer testing is worth more than 20,000 US dollars, and the maintenance cycle is more than 72 hours. These scenarios have high requirements for the real-time performance, state tracking accuracy and operation permission control of the fixture management.

[0004] At present, manufacturing enterprises generally use Excel tables or paper registration books to manage the fixture account, and rely on manual recording to update the records 4-6 hours after the position change, which causes serious distortion of the inventory data. For high-flow fixtures (cross-station allocation more than 4 times a day), this lag causes the annual loss of 1.8 million yuan due to production line downtime. In addition, the existing electronic management system only provides basic information input function, and the permission control is roughly divided into two levels of "administrator" and "ordinary user", and the function-level operation control is not realized. Due to the precision requirements of the test fixture (such as the need for anti-static operation of the probe array), the lack of permission causes the production line personnel to modify the fixture state beyond authority, which causes 23 static damage events a year, with a direct economic loss of more than 900,000 yuan.

[0005] The more serious problem is that the tool whole life cycle data is fragmented: inventory status, maintenance records, location information are stored in spreadsheets, paper documents and even warehouse whiteboards, which cannot form a closed-loop management. When the enterprise conducts monthly tool utilization analysis, it takes 16 person-hours to complete data collection and statistics, which is inefficient and cannot dynamically respond to production line demand. This management mode cannot meet the mandatory requirements of ISO 17025:2017 standard for test equipment whole life cycle traceability, and also violates the provisions of IATF 16949:2016 standard that the state of process equipment needs to be synchronized to the central system in real time. SUMMARY

[0006] In order to overcome the deficiencies of the prior art, the present application proposes a test tool management system based on a dynamic RBAC control mechanism, intelligent conflict detection and blockchain log to realize the whole life cycle management of test tools.

[0007] The present application discloses a test tool management system, comprising: a front-end interaction layer for responsive display of tool state and approval interface; a business logic layer, comprising: a permission control module configured to execute a dynamic role-based access control mechanism; a scheduling algorithm module configured to execute an intelligent conflict detection algorithm; a warning engine configured to execute intelligent warning rules for monitoring tool abnormal state and triggering alarms; a log management module configured to execute a chain log mechanism for generating tamper-proof operation records; a data layer including a relational database storing basic data, a memory database caching real-time state, and a blockchain node storing tamper-proof logs; Wherein, the test tool intelligent management system realizes the whole life cycle management of tools through the dynamic role-based access control mechanism, the intelligent conflict detection algorithm and the chain log mechanism, and the log data packet generated by the log management module contains log entries, cryptographic hash values and prehash values.

[0008] Further, the dynamic role-based access control mechanism comprises: a permission matrix database, which is a role permission table stored in the relational database, containing the following fields: a role identifier field for distinguishing three roles of super administrator, department administrator and line personnel; A permission tag field stores function level operation tags associated with a role; wherein each role identification corresponds to a permission tag to form a permission set of the role; A permission verification unit is configured to query the permission matrix database in real time when a user operation request is made; and A permission exception interrupt mechanism is configured to generate a security event log and prevent operation execution when permission verification fails.

[0009] Further, the permission verification unit performs the following steps: S1. Obtain the current user identity, query the permission matrix database to verify the operation instruction corresponding to the permission tag; S2. When the permission tag verification fails, record a security event log containing the user identification and target operation; S3. When the verification is successful, execute the target operation, and the permission set of the role to which the current user belongs is cached to the memory database at login, and is updated through a message queue broadcast when the permission is changed.

[0010] Further, the intelligent conflict detection algorithm includes: A multi-level sorting strategy unit is configured to arrange tool borrowing requests in descending order of priority value and ascending order of application time; An inventory atomic operation unit is configured to query and update real-time inventory through atomic increase / decrease commands of the memory database; and A waiting queue management unit is configured to transfer requests to a priority queue and push a notification when the inventory is insufficient.

[0011] Further, the intelligent conflict detection algorithm performs the following steps: A1. Receive a borrowing request containing a work order number, a priority value, and an application quantity; A2. Perform double sorting on the request queue: descending order of priority value → ascending order of application time; A3. Atomically deduct the inventory through the inventory atomic operation unit, and generate a distribution success record.

[0012] Further, the chain log mechanism includes: A log construction unit is configured to generate a log entry containing structured data of timestamp, user identification, operation type, and operation parameters; A tamper-proof verification chain unit performs the following steps: B1. Read the cryptographic hash value in the previously stored log data packet; B2. concatenating the cryptographic hash value of the previous log data packet with the current log entry to generate a current hash value; an immutable storage unit that writes the log data packet to a blockchain.

[0013] Further, the early warning engine is used for monitoring a tool taking event that is not returned after a timeout, and triggering an enterprise communication platform alarm when a preset threshold is exceeded; and detecting frequent taking behaviors of a same user within a unit time, and automatically freezing a permission and pushing an administrator to review.

[0014] Further, the triggering rule of the early warning module comprises that when a tool state continuously exceeds 8 hours, a state is polled every minute and an alarm is pushed; and when a user takes a tool more than 5 times within 1 hour, a red pop-up window warning is generated and an account is frozen.

[0015] Further, the wireless radio frequency identification / two-dimensional code integration unit is further used for deploying a fixed type reader / writer at a warehouse entrance and exit, and adding a passive ultra-high frequency tag to the tool; when the tool that is not associated with a warehouse-out order leaves a sensing area, a sound and light alarm is triggered and a log is uploaded; and a mobile terminal obtains tool details through a tool scanning interface by scanning a warehouse through a two-dimensional code.

[0016] Further, the multi-dimensional data board is further used for supporting cross analysis of the following dimensions: a tool type, a physical position, a state distribution, department ownership, time granularity and a classification label; the multi-dimensional data board integrates a real-time monitoring picture, accesses a security camera through an open network video interface protocol, and embeds an encrypted streaming media video with a delay of less than 2 seconds in an approval interface.

[0017] Compared with the prior art, the application has at least the following technical effects: The application realizes the function level operation isolation of three layers of super administrators / department managers / line personnel through a dynamic role-based access control permission mechanism. The permission verification unit intercepts unauthorized operations in real time, and the cache is updated through a message queue broadcast when the permission is changed, so that the unauthorized operation occurrence rate of the system is reduced from 23 times / year to 0.3 times / year, which meets the requirements of the safety standard on permission control.

[0018] 2. The chain log mechanism of the application realizes 100% tamper resistance of operation records through a log data packet structure: a log entry+current hash value+previous hash value and SHA-256 chain verification. The log data packet written to a private chain node of a blockchain can trace the whole life cycle operation records of any tool, and meets the mandatory requirements of ISO 17025:2017 on test equipment audit tracing.

[0019] 3. The present invention combines the dynamic RBAC permission mechanism with the chained log mechanism to achieve full-link auditability of operation behavior: the permission verification unit intercepts unauthorized operations, such as production line personnel deleting fixtures, and generates security event logs in real time; the log data packets are bound to the operator's identity through a hash chain, and blockchain storage ensures that the records are non-repudiable.

[0020] 4. The intelligent conflict detection algorithm of this invention adopts a dual sorting strategy of priority descending order → application time ascending order and atomic operations in memory database, which improves the efficiency of jig requisition request processing by 4 times. Actual production line testing shows that the jig in / out approval time has been reduced from 2 hours in the traditional mode to 15 minutes, and the inventory data update delay has been reduced from 4-6 hours to within 30 seconds, completely eliminating downtime and jig waiting losses caused by data distortion.

[0021] 5. The early warning engine of this invention is based on real-time status polling and actively monitors fixture anomalies. When the fixture status remains "in use" for more than 8 hours or a user uses it more than 5 times within 1 hour, multi-level alarms are automatically triggered: WeChat / SMS / audio-visual alarms and account permissions are frozen, reducing the unplanned downtime of the fixture from 4 hours / time to 1.2 hours / time.

[0022] 6. The intelligent conflict detection algorithm and early warning engine of this invention can realize resource preemption risk pre-handling: when the inventory atomic operation unit detects that the inventory is lower than the safety threshold, the early warning rule is automatically triggered, the system notifies the administrator in advance to purchase spare parts, and freezes low-priority requisition requests. The production line shutdown caused by jig shortage is reduced from an average of 18 times per year to 1.5 times.

[0023] 7. The wireless radio frequency identification / QR code integration unit of this invention deploys fixed readers in the warehouse, and combines them with UHF tags on jigs to achieve automatic security checks upon departure. When a jig without an associated outbound slip leaves the sensing area, an audible and visual alarm is triggered in real time, reducing the average annual jig loss rate from 5.2% to 0.5%, a reduction of 90%.

[0024] 8. The multi-dimensional data dashboard of this invention integrates encrypted streaming video and six-dimensional cross-analysis, and dynamically displays the distribution hot zones and health status of fixtures through a visual interface, reducing the time required for monthly utilization analysis from 16 person-hours to within 5 minutes.

[0025] 9. The present invention combines a multi-dimensional data dashboard with an RFID / QR code integration unit to achieve real-time mapping between physical location and logical state: the jig departure signal captured by the RFID reader is synchronized to the physical location heat map of the dashboard in real time. When a jig that is not associated with an outbound order moves, the dashboard automatically pops up a window to display the monitoring video stream, which shortens the jig search time. Attached Figure Description

[0026] Figure 1 : System architecture diagram of the intelligent management system for test fixtures of this invention; Figure 2 : The use flowchart of the test fixture intelligent management system of the application; Figure 3 : The interface diagram of the test fixture intelligent management system of the application; DETAILED DESCRIPTION

[0027] The application will be described in detail below in combination with the accompanying drawings of the specification: As Figure 1 shown, a test fixture management system comprises: A front-end interaction layer for responsive display of fixture status and approval interface; A business logic layer comprising: A permission control module configured to execute a dynamic role-based access control permission mechanism; A scheduling algorithm module configured to execute an intelligent conflict detection algorithm; An early warning engine configured to execute an intelligent early warning rule for monitoring fixture abnormal state and triggering an alarm; A log management module configured to execute a chain log mechanism for generating tamper-proof operation records; A data layer comprising a relational database storing basic data, a memory database caching real-time status, and a blockchain node storing tamper-proof logs; Wherein, the test fixture intelligent management system realizes fixture full life cycle management through the dynamic role-based access control permission mechanism, the intelligent conflict detection algorithm and the chain log mechanism, and the log data packet generated by the log management module contains log entries, cryptographic hash values and prehash values.

[0028] The dynamic role-based access control permission mechanism comprises: A permission matrix database, which is a role permission table stored in the relational database, containing the following fields: A role identifier field for distinguishing three levels of roles: super administrator, department administrator and line personnel; A permission tag field for storing function level operation tags associated with the role; wherein the corresponding permission tags of each role identifier constitute the permission set of the role; A permission verification unit for querying the permission matrix database in real time when a user operation request is made; and A permission exception interruption mechanism for generating a security event log and preventing operation execution when permission verification fails.

[0029] The permission verification unit execution steps comprise: S1. Obtain the current user identity, query the permission matrix database to verify the operation instruction corresponding to the permission tag; S2. When the permission tag verification fails, record the security event log containing the user identity and the target operation; S3. When the verification is successful, execute the target operation, and the permission set of the role to which the current user belongs is cached to the memory database at login, and is updated through message queue broadcast when the permission is changed.

[0030] The intelligent conflict detection algorithm comprises: A multi-level sorting strategy unit, which is used to arrange the tool taking requests in descending order of priority value and ascending order of application time; An inventory atomic operation unit, which queries and updates real-time inventory through atomic increase / decrease commands of the memory database; and A waiting queue management unit, which transfers the request to a priority queue and pushes a notification when the inventory is insufficient.

[0031] The intelligent conflict detection algorithm execution steps comprise: A1. Receive a taking request containing a work order number, a priority value, and an application quantity; A2. Perform double sorting on the request queue: descending order of priority value→ascending order of application time; A3. Atomically deduct the inventory through the inventory atomic operation unit, and generate a distribution success record.

[0032] The chain log mechanism comprises: A log construction unit, which generates a log entry containing structured data of timestamp, user identity, operation type, and operation parameter; A tamper-proof verification chain unit, which performs the following steps: B1. Read the cryptographic hash value in the stored previous log data packet; B2. Concatenate the cryptographic hash value of the previous log data packet with the current log entry to generate a current hash value; An immutable storage unit, which writes the log data packet into a blockchain.

[0033] The early warning engine is used to monitor the timeout unreturned event after the tool is taken, and trigger an alarm on the enterprise communication platform when the preset threshold is exceeded; detect the frequent taking behavior of the same user within a unit time, automatically freeze the permission, and push the administrator for review.

[0034] The trigger rule of the early warning module includes: when the tool state continues to be "in use" for more than 8 hours, poll the state every minute and push the alarm; when the user takes the tool more than 5 times within 1 hour, generate a red pop-up window warning and freeze the account.

[0035] The wireless radio frequency identification / bar code integration unit is deployed with a fixed type reader at the warehouse entrance and exit, and the tool is additionally provided with a passive ultra-high frequency tag; when the tool without the associated out-of-warehouse order leaves the sensing area, an audible and light alarm is triggered and the log is uploaded; the mobile terminal calls the tool scanning interface through the warehouse scanning of the two-dimensional code to obtain the tool details.

[0036] As shown in Figure 3 , it also includes a multi-dimensional data board, which supports cross analysis of the following dimensions: tool model, physical location, state distribution, department affiliation, time granularity, and classification label; the multi-dimensional data board integrates real-time monitoring pictures, accesses security cameras through an open network video interface protocol, and embeds encrypted streaming media video with a delay of less than 2 seconds in the approval interface. Embodiment

[0037] Conflict resolution of high-priority tool taking requests As shown in Figure 2 , an emergency work order WO-20250909 of a certain production line needs to take 10 test tools of model QC-2010, and this work order is marked as the highest priority (value 5). After the system receives the request, the intelligent conflict detection algorithm starts the processing flow. The multi-level sorting strategy unit first scans the to-be-processed queue: all current taking requests are sorted by priority value from high to low (priority 5>3>1), and when multiple requests belong to priority 5, they are arranged in ascending order of application timestamp (early applicants have priority). After double sorting, the work order WO-20250909 is placed at the head of the queue because it has both the highest priority and the earliest application time.

[0038] The inventory atomic operation unit then queries the memory database to obtain the real-time available inventory of QC-2010 tools, which is currently 15. Since the inventory quantity is greater than the application quantity, the unit immediately performs an atomic deduction operation: reducing the inventory value from 15 to 5. This process is realized through the atomic decrement command of the memory database, ensuring data consistency under concurrent requests. After the inventory is updated successfully, the system generates a distribution record associated with the work order number WO-20250909, tool model QC-2010, and distribution quantity 10, and synchronously pushes it to the applicant's operation terminal.

[0039] Through double sorting of priority and time, critical production tasks are guaranteed to obtain resources first; The atomic operation unit avoids inventory negative value anomalies caused by simultaneous deduction by multiple users; The distribution record is updated to the visual board within 30 seconds after generation, and the production scheduler can monitor the tool distribution hot area in real time.

[0040] The work order WO-20250909 takes 4 minutes and 15 seconds from submission request to completion of allocation, which is 8 times faster than the traditional manual approval mode; the inventory data error rate is reduced from ±12% recorded manually to 0.01% (atomic operation guarantee); the average response time of high-priority work orders is shortened to within 7 minutes. Embodiment

[0041] Permission interception and security audit of tool deletion operation A certain line operator Wang tried to delete the test tool numbered XT-203 through the system. The permission verification unit in the permission control module immediately starts the verification process: first capture the user identity U7845 of Wang, and then query the role permission table in the relational database. The table shows that the "line personnel" role to which Wang belongs only has the permission of tool viewing and taking, and does not include the deletion permission tag. The permission verification unit determines that the operation is beyond the authorized scope, triggers the permission exception interruption mechanism: generates a security event log containing the user identity, the target operation type and the tool number, and forcibly terminates the execution of the delete instruction.

[0042] At the same time, the log management module synchronously starts the tamper-proof log generation process. The log construction unit creates a structured log entry, which records the event occurrence timestamp, the operation user identity, the operation type classification as a security violation, and the details of the intercepted delete operation (target tool number XT-203). The tamper-proof verification chain unit calls the cryptographic hash value (generated by the SHA-256 algorithm) stored in the latest log data packet in the system, concatenates the hash value with the text of the newly created log entry, and inputs them into the same hash function to generate a unique hash value for the current operation. The immutable storage unit integrates the log entry text, the newly generated hash value and the referenced previous hash value into a new log data packet, which is written into the blockchain private chain node permanent storage.

[0043] The permission verification unit blocks the unauthorized operation within 0.2 seconds, and the log management module synchronously generates an unalterable record, forming a "operation-interception-audit" full-process closed loop; The operator's identity is bound through the cryptographic hash chain, ensuring that Wang cannot deny his unauthorized behavior. The auditor can verify the integrity of the continuous hash chain in the blockchain and locate the unique record of this violation operation; The whole process from operation initiation, permission verification to log chaining takes less than 1.5 seconds, greatly improving the security response efficiency of the system. The security event traceability time is compressed from the traditional manual verification of 3 hours to seconds. Embodiment

[0044] Real-time positioning based tool quick call and state linkage The difference is that the multi-dimensional data board integrates real-time positioning function, and realizes tool space position tracking through the following steps: C1. Deploy multiple Bluetooth beacons in the physical environment to collect the signal strength of the tool's built-in tag; C2. The positioning engine analyzes the signal strength based on the trilateration algorithm to calculate the three-dimensional coordinates of the tool; C3. Map the three-dimensional coordinates to a 3D map and update and render the tool position icon in real time.

[0045] It also includes a state linkage control unit that responds to tool positioning coordinate updates and performs the following operations: D1. When the tool state changes to "to be picked up", automatically generate the optimal pickup path from the user's workstation to the tool location and superimpose it on the 3D map; D2. The linkage permission control module unlocks the electronic lock of the target tool storage cabinet; D3. Trigger the warning engine to start the return countdown monitoring.

[0046] Technician Zhang of the SMT workshop needs to urgently call the TP-880 probe module tool. After submitting the use request through the system mobile terminal, the multi-dimensional data board immediately starts the real-time positioning function. Three groups of Bluetooth beacons (TiCC2640R2F) deployed in Area A, Line B, and Shelf C of the workshop synchronously capture the signal of the tool's built-in tag, collect the signal strength value (RSSI), and upload it to the positioning engine. The engine uses the trilateration algorithm to calculate the spatial coordinates: taking the three beacons as the centers and the distance value obtained by the signal attenuation model as the radius, a virtual sphere is drawn, and the intersection point of the spheres is the three-dimensional coordinates of the tool (with a precision of ±0.3 meters).

[0047] The positioning engine pushes the coordinates (X=35.2m, Y=18.7m, Z=2.1m) and the tool state "idle" to the business logic layer. After the scheduling algorithm module verifies that the tool meets the use conditions, it automatically goes through the approval process. At the same time: 1. Board dynamic update: the TP-880 tool icon in the 3D map (rendered by the Unity engine) flashes from Shelf C to the "to be picked up" state; 2. Path optimization guidance: combined with Zhang's workstation coordinates (X=12.4m, Y=5.3m), the optimal pickup path is generated and superimposed on the map; 3. Permission linkage: Zhang's mobile terminal instantly unlocks the tool cabinet electronic lock (the permission control module verifies that its use permission is effective).

[0048] When Zhang reaches the target shelf, the RFID reader verifies the fixture tag information again. After confirming the match, the system changes the fixture status to "in use" and triggers the following linkage: log recording: the chain log mechanism generates operation entries, including location trajectory and status change records; warning timing: the warning engine starts the 8-hour timeout return countdown simultaneously.

[0049] This embodiment uses Bluetooth beacon positioning → coordinate mapping to 3D map → permission module triggering electronic lock unlocking; calculates the optimal path in real time based on fixture position (X, Y, Z) and user position, reducing the time-consuming of searching; the state changes from "idle" to "ready to pick up" to "in use" in ≤10 seconds, and the location information is refreshed every 30 seconds.

[0050] The fixture search time is shortened from the industry average of 42 minutes to 3 minutes; The positioning system energy consumption is reduced by 62% (Bluetooth beacon standby power consumption <1.2mA); The warehouse space utilization rate is improved by 33% (precise positioning releases redundant buffer area). Embodiment

[0051] Fixture accounting and maintenance response coordination based on cloud storage The difference is that the cloud storage unit of the data layer performs a fixture accounting operation, including the steps of: E1. In response to the fixture nameplate QR code scanned by the mobile terminal, call the preset information template and start the multi-angle shooting process; E2. Upload the photographed fixture photos to the cloud object storage service, and name them according to the rule {fixture number}_{timestamp}_{angle}.jpg; E3. Generate an electronic account field, associate the access link of the photo, supplier information and expected life cycle.

[0052] The difference is that the warning engine embeds the access link of the historical photo set in the maintenance work order, and performs: F1. Push the maintenance work order containing the fixture historical photos to the designated terminal; F2. Analyze the technical document link stored in the cloud to obtain spare part specification parameters; F3. Generate a purchase application form in the ERP system according to the parameters.

[0053] After purchasing a new type of test vehicle (model: ZT-900), warehouse manager Li used a mobile device to scan the QR code on the fixture's nameplate. The system automatically retrieves the preset fixture information template and initiates a multi-angle shooting process: 1. Cloud storage linkage: Li takes three photos of the fixture's front, side, and interface close-ups in sequence; the photos are uploaded to the Alibaba Cloud OSS storage bucket in JPG format and named ZT-900_20250909_front.jpg according to the rule; encrypted storage: the photos are stored in fragments after being encrypted with AES-256, generating a unique access URL; 2. Automatic generation of electronic ledger: the system extracts the barcode information (supplier code, purchase date) and integrates it with the cloud photo URL; generating electronic ledger fields; 3. Real-time access during maintenance: when the ZT-900 fixture experiences a probe breakage failure on the SMT production line, the early warning engine pushes a maintenance work order to WeChat, embedding the fixture's historical photo set URL in the message body; maintenance engineer Wang clicks the URL to view the historical images of the fault location (comparing with the current status); the system simultaneously triggers the spare parts procurement process, generating a purchase requisition form in SAP based on the probe specifications in the cloud technical document.

[0054] Cloud-based photos are stored during the billing phase (an extended feature of the instruction manual), and during the repair phase, technical document URLs are automatically pushed to drive the procurement process; encrypted photo storage meets GDPR requirements; photo retrieval time during repair response is <3 seconds (traditional systems take >15 minutes).

[0055] The above embodiments describe the system and workflow in detail, but the scope of protection of the present invention is not limited thereto. Those skilled in the art can make several modifications and improvements without departing from the concept, and these should all fall within the scope of protection of the present invention.

Claims

1. A test fixture management system, comprising: Comprise: A front-end interaction layer for responsive display of tool state and approval interface; A business logic layer comprising: A permission control module configured to implement a dynamic role-based access control permission mechanism; A scheduling algorithm module configured to implement an intelligent conflict detection algorithm; A warning engine configured to implement an intelligent warning rule for monitoring tool abnormal state and triggering an alarm; A log management module configured to implement a chain log mechanism for generating tamper-proof operation records; A data layer comprising a relational database storing basic data, a memory database caching real-time state, and a blockchain node storing tamper-proof logs; Wherein, the test tool intelligent management system realizes tool life cycle management through the dynamic role-based access control permission mechanism, the intelligent conflict detection algorithm and the chain log mechanism, and the log data packet generated by the log management module contains log entries, cryptographic hash values and prehash values.

2. The test fixture management system of claim 1, wherein, The dynamic role-based access control permission mechanism comprises: A permission matrix database, which is a role permission table stored in the relational database, containing the following fields: A role identifier field for distinguishing three levels of roles: super administrator, department administrator and line personnel; A permission tag field for storing function-level operation tags associated with the role; wherein the permission tags corresponding to each role identifier constitute the permission set of the role; A permission verification unit for querying the permission matrix database in real time when a user operation request is received; and A permission exception interruption mechanism for generating a security event log and preventing operation execution when permission verification fails.

3. The test fixture management system of claim 2, wherein, The permission verification unit execution steps include: S1. Obtain the current user identity, query the permission matrix database to verify the operation instruction corresponding to the permission tag; S2. When the permission tag verification fails, record a security event log containing the user identifier and the target operation; S3. When the verification is successful, execute the target operation, and the permission set of the role to which the current user belongs is cached to the memory database at login, and is updated through message queue broadcast when the permission is changed.

4. The test fixture management system of claim 1, wherein The intelligent conflict detection algorithm comprises: A multi-level sorting strategy unit for sorting tool taking requests in descending order of priority value and ascending order of application time; An inventory atomic operation unit for querying and updating real-time inventory through atomic increase / decrease commands of the memory database; and A waiting queue management unit for transferring requests to a priority queue and pushing notifications when inventory is insufficient.

5. The test fixture management system of claim 4, wherein, The intelligent conflict detection algorithm execution steps include: A1. Receive a taking request containing a work order number, a priority value, and an application quantity; A2. Perform double sorting on the request queue: priority value descending order → application time ascending order; A3. Atomically deduct inventory through the inventory atomic operation unit, and generate a successful allocation record.

6. The test fixture management system of claim 1, wherein, The chain log mechanism comprises: A log building unit that generates a log entry containing a timestamp, a user identification, an operation type, and an operation parameter structured data; A tamper-proof verification chain unit that performs the following steps: B1. reading a stored cryptographic hash value in a previous log data packet; B2. concatenating the cryptographic hash value of the previous log data packet with the current log entry to generate a current hash value; An immutable storage unit that writes the log data packet into a blockchain.

7. The test fixture management system of claim 1, wherein The early warning engine is used to monitor the event of tool taking out and not returning after timeout, and trigger the alarm of enterprise communication platform when exceeding the preset threshold; detect the frequent taking behavior of the same user within a unit time, automatically freeze the permission and push the administrator for review.

8. The test fixture management system of claim 7, wherein, The trigger rules of the early warning module include: when the tool state continues to be "in use" for more than 8 hours, poll the state every minute and push the alarm; when the user takes out more than 5 times within 1 hour, generate a red pop-up window warning and freeze the account.

9. The test fixture management system of claim 1, wherein, Further comprising: A wireless radio frequency identification / two-dimensional code integration unit, a fixed type reader / writer is deployed at the warehouse entrance and exit, and a passive ultra-high frequency tag is added to the tool; When the tool without associated outbound order leaves the induction area, trigger sound and light alarm and upload log; mobile terminal calls tool scanning interface to obtain tool details through two-dimensional code scanning warehouse.

10. The test fixture management system of claim 1, wherein, Further comprising a multi-dimensional data board, which supports cross analysis of the following dimensions: tool type, physical location, state distribution, department ownership, time granularity, classification label; the multi-dimensional data board integrates real-time monitoring pictures, accesses security cameras through open network video interface protocol, and embeds encrypted streaming media video with delay < 2 seconds in the approval interface.

Images