Automated acquisition and tracing system for material information

Abstract

The present application relates to the technical field of industrial production management, and in particular to an automatic material information acquisition and tracing system, which realizes double code analysis, tamper-proofing verification and scene intelligent determination in the code scanning and acquisition stage, realizes material information association binding, shelf life warning and flow node trace in the data processing stage, realizes hierarchical storage, offline caching and version tracing in the data storage stage, realizes forward and reverse full-link tracing and report automatic generation in the query and tracing stage, and realizes post permission allocation and abnormal active push in the interactive control stage, finally solving the technical problems of existing technology, such as wrong material unable to be pre-intercepted, poor code scanning adaptability, easy data storage loss and difficult tracing, full-link tracing absence and passive abnormal processing, and achieving the technical effects of automatic material information acquisition, full life cycle traceability and efficient and safe production control.

Description

Technical Field

[0001] This invention relates to the field of industrial production management technology, specifically to an automated material information collection and traceability system. Background Technology

[0002] Currently, production management systems mostly revolve around material barcode binding and basic production data recording. By binding one-dimensional / two-dimensional codes to material and finished product information, and using barcode scanning to collect data during the production process, they achieve data retention and material traceability, ensuring basic material control and information traceability in the production process. However, this approach only achieves basic material-finished product association to a certain extent and cannot adapt to the actual needs of modern production lines with multiple scenarios, high concurrency, and cross-process collaboration. In long-term use, those skilled in the art have discovered numerous technical shortcomings: (1) Existing technology only completes the basic binding of material information with finished products and scanning time, without verifying the material information. It cannot intercept incorrect materials in advance during the material requisition and online process, and can only rely on manual verification or post-event traceability. Once incorrect materials occur, it will directly lead to the scrapping of finished products, production line shutdown, and even quality compliance accidents. There are fatal loopholes in the core control links of production. (2) The scanning and collection mechanism is rigid. Some solutions only support single QR code parsing and cannot be adapted to the material identification system of one-dimensional / two-dimensional codes in the production line. Large-scale transformation of existing material identification hardware is required. At the same time, the existing technology usually only simply implements the "reject repeated scanning" rule and cannot distinguish between actual production scenarios such as misscanning, rescanning, and batch use. This can easily lead to data omissions and redundancy, interfere with normal production processes, and reduce production execution efficiency. (3) The data storage architecture is rudimentary. Some solutions rely solely on a single cloud storage or real-time database for real-time, indiscriminate data storage. In the event of a network outage, scanned data will be directly lost, and severe lag is likely to occur when querying massive amounts of data. At the same time, existing technologies only perform simple data storage for material information. Once the data is tampered with or modified, core production data will face the risk of irreversible loss. (4) Existing technologies only support simple barcode information or detailed queries, and cannot achieve full-chain data positioning from finished products to materials or from work orders to each production stage. At the same time, existing technologies rely on external warehouse systems to complete data statistics, and production management decisions lack direct data support, resulting in a significant reduction in efficiency.

[0003] For example, the patent application CN114897540A, titled "A Supply Chain Management System," uses cloud storage and enterprise terminal servers as its core. It generates unique supply chain QR codes to bind products and, combined with production monitoring videos, achieves full-process recording and traceability of procurement, warehousing, processing, and outbound processes. However, it only completes the basic binding of product and material information with QR codes and videos, lacking the ability to verify information during material requisition and online processes, and to prevent material errors before they occur. Furthermore, the system only supports single QR code parsing, is incompatible with one-dimensional barcodes, and relies on a single cloud storage system. Data is easily lost in offline scenarios, and it is prone to lag when querying massive amounts of data. It can only query basic information and production videos, and cannot achieve full-chain bidirectional traceability from finished products to materials and from work orders to production processes.

[0004] For example, the publication number CN116029476A, titled "A Production Management System," is divided into two main modules: production and warehousing. It assigns one-dimensional / two-dimensional codes to materials and finished products and uses PDAs for scanning. However, it only records basic data and provides simple traceability for the production and warehousing processes. It merely records the barcode binding of materials and finished products, lacking a material information verification mechanism and failing to proactively intercept incorrect materials. Furthermore, the system only executes basic entry rules for scanning, unable to distinguish between accidental scanning, rescanning, and batch requisition scenarios, easily leading to data anomalies. The system also lacks offline caching and data tamper-proof storage solutions, making it prone to data loss and query lag during network outages. Finally, the system only supports basic barcode information queries, failing to achieve end-to-end data location, and data statistics cannot directly support production decisions.

[0005] In summary, existing technologies only focus on basic barcode binding of materials and finished products, recording of barcode data, and shallow traceability. They fail to address core issues such as pre-emptive interception of incorrect materials, flexible adaptation of barcode scanning mechanisms, secure data storage, bidirectional traceability across the entire supply chain, and data support for production decisions. They cannot meet the actual needs of modern production lines with multiple scenarios, high concurrency, and cross-process collaboration, and thus have significant technical deficiencies. Summary of the Invention

[0006] The purpose of this invention is to address the shortcomings of existing technologies by providing an automated material information collection and traceability system. This system comprises multiple functional modules: in the barcode scanning stage, it achieves dual-code parsing, anti-tampering verification, and intelligent scenario determination; in the data processing stage, it achieves material information association and binding, shelf-life warning, and flow node tracking; in the data storage stage, it achieves hierarchical storage, offline caching, and version traceability; in the query and traceability stage, it achieves full-chain traceability (both forward and reverse) and automatic report generation; and in the interactive control stage, it achieves job permission allocation and proactive anomaly push notifications. Ultimately, this system solves the technical problems of existing technologies, such as the inability to proactively intercept incorrect materials, poor barcode compatibility, easy data loss and difficulty in traceability, lack of full-chain traceability, and passive anomaly handling. It achieves the technical effects of automated material information collection, full lifecycle traceability, and efficient and secure production control.

[0007] The objective of this invention is achieved through the following approach: An automated material information collection and traceability system includes multiple functional modules capable of data interaction. These modules include a barcode scanning module, a database module, a data processing module, a query module, and a user interaction module. The scanning module is used to parse the one-dimensional or two-dimensional barcode on the material into standard material information, and to perform anti-tampering verification, material compatibility verification, and scanning scenario determination. The database module is used to perform high-frequency / low-frequency hierarchical storage of material data, and to perform local offline storage of material information when the network is interrupted. It is also configured with a material information backup and version traceability mechanism. The data processing module is used to automatically associate material information with production work orders, operation teams, production equipment, and finished product models, and synchronously record the information of the entire flow of materials, including material requisition, online production, assembly, and finished product warehousing, and to provide intelligent early warning based on thresholds for material shelf life. The query and traceability module is used to provide users with material information and finished product information query functions, and supports keyword fuzzy query and multi-condition combination query. The query results can be generated into a visual statistical report for export. The user interaction module is used to set different access and operation permissions for users in different positions, and to actively push material abnormality information through industrial terminal pop-ups and workshop visualization dashboards to realize real-time alarms for abnormalities. The data input terminal of the scanning module is connected to the first data output terminal of the user interaction module. The first data output terminal of the scanning module is connected to the first data input terminal of the data processing module. The second data output terminal of the scanning module is connected to the first data input terminal of the user interaction module. The second data input terminal of the data processing module is connected to the second data output terminal of the user interaction module. The first data output terminal of the data processing module is connected to the first data input terminal of the database module. The second data output terminal of the data processing module is connected to the second data input terminal of the user interaction module. The second data input terminal of the database module is connected to the third data output terminal of the user interaction module. The third data input terminal of the data processing module is connected to the first data output terminal of the query module. The second data input terminal of the query module is connected to the fourth data output terminal of the user interaction module.

[0008] Preferably, the scanning module includes a scanning terminal, a parsing unit, an anti-tampering unit, a verification unit, and a scene determination unit, wherein, The barcode scanning terminal is used to collect the one-dimensional barcode / two-dimensional barcode image signal on the material identification sheet and output the original code data; The parsing unit is used to receive raw code data and extract standardized material information, including material code, batch, production date, supplier, etc., according to the built-in one-dimensional barcode / two-dimensional barcode dual-code parsing protocol. The anti-tampering unit is used to verify whether the built-in dynamic verification code and the tear-resistant laser mark on the one-dimensional barcode / two-dimensional barcode on the material identification sheet are intact, and output the verification result of whether the material identification is legal or illegal; The verification unit is used to receive the anti-tampering verification result. Only when the material identifier is valid, the parsed material information is matched in real time with the current production line number, finished product model, and compatible material list. If the match fails, it is determined to be an abnormal scan, the information entry is rejected and an early warning pop-up is triggered. If the match passes, the material information is pushed to the scene judgment unit and synchronously transmitted to the database module for temporary storage. The scenario determination unit is used to determine the scanning behavior into four scenarios: misscanning, rescanning, batch requisition, and normal scanning, based on preset scenario determination rules and material information, and to execute corresponding input, labeling, and quantity merging processing rules according to the scenario. The first data output terminal of the scanning terminal is connected to the data input terminal of the parsing unit, the second data output terminal of the scanning terminal is connected to the first data input terminal of the anti-tampering unit, the data output terminal of the parsing unit is connected to the second data input terminal of the anti-tampering unit, the data output terminal of the anti-tampering unit is connected to the data input terminal of the verification unit, and the data output terminal of the verification unit is connected to the data input terminal of the scene determination unit.

[0009] Preferably, the data processing module includes a data association unit, a shelf-life early warning unit, and a flow tracking unit, wherein, The data association unit is used to automatically bind the legitimate material information transmitted by the barcode scanning module with the production work order, operation team, production equipment and finished product model data retrieved in real time from the enterprise's basic production information database to generate full-dimensional basic material data. The shelf life early warning unit is used to receive the full-dimensional basic material data output by the data association unit, parse the material production date and shelf life parameters, compare them with the current system time, determine the material status according to a custom threshold, and generate material verification data with status identifiers. The flow tracking unit is used to receive material verification data output by the shelf life warning unit, and, in conjunction with the current operation node, record the node operation time, operator, and equipment number to generate final material data with complete traceability information. The data output terminal of the data association unit is connected to the data input terminal of the shelf life warning unit, and the data output terminal of the shelf life warning unit is connected to the data input terminal of the circulation tracking unit.

[0010] Preferably, the database module includes a hierarchical storage unit, an offline caching unit, and a backup and traceability unit, wherein, The offline caching unit is used to receive material information, forward it directly to the hierarchical storage unit when the network is normal, and cache the material information locally with timestamps when the network fails. After the network is restored, it is incrementally synchronized to the hierarchical storage unit to ensure that the material information is not lost. The hierarchical storage unit is used to receive material information transmitted by the offline cache unit, and divide the material information into high-frequency query data and low-frequency query data according to the material query frequency. The high-frequency query data is stored in the high-speed cache area, and the low-frequency query data is stored in the regular database, so as to realize the hierarchical storage management of data. The backup traceability unit is used to receive the final data after hierarchical storage, generate a unique version number for each piece of data, perform incremental backups only for newly added / modified data, and retain historical versions to achieve traceability of tampering. The data output terminal of the offline cache unit is connected to the data input terminal of the hierarchical storage unit, and the data output terminal of the hierarchical storage unit is connected to the data input terminal of the backup traceability unit.

[0011] Preferably, the query and traceability module includes a query and traceability unit and a report generation unit, wherein, The query and traceability unit is used to receive user query instructions, query finished product information using material number, or query material information using finished product number, and supports keyword fuzzy query and multi-condition combination query, and outputs a structured material / finished product traceability dataset. The report generation unit is used to receive the traceability dataset output by the query and traceability unit, automatically generate visual charts such as material consumption, batch distribution, and production line consumption, and supports export in Excel / PDF format; The data output terminal of the query and traceability unit is connected to the data input terminal of the report generation unit, and the data output terminal of the report generation unit is connected to the data input terminal of the user interaction module.

[0012] Preferably, the user interaction module includes a permission management unit and an exception push unit, wherein, The permission management unit is used to verify the identity of users when they log in, and divides the operation permissions into five levels according to operators, quality inspectors, material managers, production supervisors and after-sales personnel, and outputs permission activation signals; The anomaly push unit is used to receive anomaly signals from various modules of the system and push them to the corresponding responsible persons through terminal pop-ups and workshop dashboards.

[0013] Preferably, in the scenario-based determination unit, the scenario of misscanning is when the same material has not been used and is scanned repeatedly. The system pops up a message indicating "suspected misscanning" and refuses to enter the data. In the supplementary cleaning scenario, the operator manually selects the supplementary cleaning, the system marks the reason for the supplementary cleaning, and records the supplementary cleaning time and operator information; In the scenario of batch requisition, the same material is scanned multiple times in the same batch, and the system automatically accumulates the quantity to generate a batch record. Normal scanning scenarios are for legitimate materials that are being scanned for the first time and have no historical records, and that have not yet been used. After the system completes the verification, the material information is pushed to the data processing module.

[0014] The beneficial effects of this invention include the following: ① Addressing the shortcomings of existing technologies that lack material information verification and cannot prevent incorrect materials from being detected in advance, the barcode scanning module of this invention verifies the legality of the identifier through an anti-tampering unit and matches the material information with the production line and finished product model in real time through a verification unit. If the information fails to match, the data is rejected and an alert is issued. This can prevent finished product scrap, production line shutdowns, and quality compliance incidents caused by incorrect materials from the source, thus filling a core production control loophole. Furthermore, the entire verification logic requires no manual intervention and can automatically complete data comparison, replacing the manual verification mode, significantly reducing the human error rate, and ensuring the compliance of the production process and the stability of finished product quality.

[0015] ② This invention uses scenario-based intelligent judgment to replace the single rejection logic. It can intelligently distinguish between scenarios such as mis-scanning, re-scanning, batch requisition, and normal scanning, and perform prompt confirmation, allow annotation entry, quantity merging and recording, and normal data entry operations respectively. It adapts to the actual operating habits of the production line, avoids data omission and redundancy, and ensures production efficiency and data accuracy.

[0016] ③ This invention implements hierarchical storage of material data, dividing material information into high-frequency query data and low-frequency data according to the frequency of data query, and storing them in a high-speed cache and a regular database respectively, which can significantly improve the query response speed under massive data and solve the problem of lag when querying large amounts of data.

[0017] Furthermore, this invention also includes an offline caching unit that temporarily stores scanned data locally during network failures and automatically performs incremental synchronization upon network reconnection, effectively preventing data loss caused by network fluctuations in industrial settings. In addition, the backup and traceability unit of this invention assigns a version number to each piece of material information data and retains historical modification records, enabling full lifecycle traceability of data and preventing malicious data tampering.

[0018] ④ The query module of this invention has the ability to trace back and forth in multiple dimensions, supporting keyword fuzzy search and multi-condition combination search. It can query the entire chain information from material to finished product in the forward direction, and the entire chain information from finished product to material in the reverse direction, which fully meets the traceability needs of the whole scenario of quality management.

[0019] Meanwhile, the report generation unit of this invention outputs visual statistical reports and supports export, without relying on external warehouse systems, providing direct data support for production management decisions and adapting to the multi-scenario and cross-link collaborative needs of modern production lines. Attached Figure Description

[0020] Figure 1 This is a block diagram of the modules of the present invention; Figure 2 This is a structural block diagram of the barcode scanning module of the present invention; Figure 3 This is a structural block diagram of the data processing module of the present invention; Figure 4 This is a structural block diagram of the database module of the present invention; Figure 5 This is a structural block diagram of the query module of the present invention; Figure 6 This is a structural block diagram of the user interaction module of the present invention; Figure 7 This is example code for storing material information in the database module of this invention. Figure 8 This is a schematic diagram illustrating the data processing module's data processing of material information in an embodiment of the present invention; Figure 9 This is example code for querying material information by the query module in an embodiment of the present invention. Detailed Implementation

[0021] like Figures 1 to 9 As shown, an automated material information collection and traceability system includes multiple functional modules capable of data interaction. These modules include a barcode scanning module, a database module, a data processing module, a query module, and a user interaction module. The scanning module is used to parse the one-dimensional or two-dimensional barcode on the material into standard material information, and to perform anti-tampering verification, material compatibility verification, and scanning scenario determination. The database module is used to perform high-frequency / low-frequency hierarchical storage of material data, and to perform local offline storage of material information when the network is interrupted. It is also configured with a material information backup and version traceability mechanism. The data processing module is used to automatically associate material information with production work orders, operation teams, production equipment, and finished product models, and synchronously record the information of the entire flow of materials, including material requisition, online production, assembly, and finished product warehousing, and to provide intelligent early warning based on thresholds for material shelf life. The query and traceability module is used to provide users with material information and finished product information query functions, and supports keyword fuzzy query and multi-condition combination query. The query results can be generated into a visual statistical report for export. The user interaction module is used to set different access and operation permissions for users in different positions, and to actively push material abnormality information through industrial terminal pop-ups and workshop visualization dashboards to realize real-time alarms for abnormalities. like Figure 1 As shown, the data input terminal of the scanning module is connected to the first data output terminal of the user interaction module; the first data output terminal of the scanning module is connected to the first data input terminal of the data processing module; the second data output terminal of the scanning module is connected to the first data input terminal of the user interaction module; the second data input terminal of the data processing module is connected to the second data output terminal of the user interaction module; the first data output terminal of the data processing module is connected to the first data input terminal of the database module; the second data output terminal of the data processing module is connected to the second data input terminal of the user interaction module; the second data input terminal of the database module is connected to the third data output terminal of the user interaction module; the third data input terminal of the data processing module is connected to the first data output terminal of the query module; the second data input terminal of the query module is connected to the fourth data output terminal of the user interaction module; and the second data output terminal of the query module is connected to the fourth data input terminal of the user interaction module.

[0022] like Figure 2 As shown, the scanning module includes a scanning terminal, a parsing unit, an anti-tampering unit, a verification unit, and a scene determination unit, wherein... The barcode scanning terminal is used to collect the one-dimensional barcode / two-dimensional barcode image signal on the material identification sheet and output the original code data; The parsing unit is used to receive raw code data and extract standardized material information, including material code, batch, production date, supplier, etc., according to the built-in one-dimensional barcode / two-dimensional barcode dual-code parsing protocol. The anti-tampering unit is used to verify whether the built-in dynamic verification code and the tear-resistant laser mark on the one-dimensional barcode / two-dimensional barcode on the material identification sheet are intact, and output the verification result of whether the material identification is legal or illegal; The verification unit is used to receive the anti-tampering verification result. Only when the material identifier is valid, the parsed material information is matched in real time with the current production line number, finished product model, and compatible material list. If the match fails, it is determined to be an abnormal scan, the information entry is rejected and an early warning pop-up is triggered. If the match passes, the material information is pushed to the scene judgment unit and synchronously transmitted to the database module for temporary storage. The scenario determination unit is used to determine the scanning behavior into four scenarios: mis-scanning, re-scanning, batch requisition, and normal scanning, based on preset scenario determination rules and material information, and to execute corresponding processing rules such as data entry, labeling, and quantity merging according to the scenario. In this embodiment, in the scenario-based determination unit, the scenario of misscanning is when the same material has not been used and is scanned repeatedly. The system pops up a message indicating "suspected misscanning" and refuses to enter the data. In the supplementary cleaning scenario, the operator manually selects the supplementary cleaning, the system marks the reason for the supplementary cleaning, and records the supplementary cleaning time and operator information; In the scenario of batch requisition, the same material is scanned multiple times in the same batch, and the system automatically accumulates the quantity to generate a batch record. Normal scanning scenarios are for legitimate materials that are being scanned for the first time and have no historical records, and that have not yet been used. After the system completes the verification, the material information is pushed to the data processing module.

[0023] The first data output terminal of the scanning terminal is connected to the data input terminal of the parsing unit, the second data output terminal of the scanning terminal is connected to the first data input terminal of the anti-tampering unit, the data output terminal of the parsing unit is connected to the second data input terminal of the anti-tampering unit, the data output terminal of the anti-tampering unit is connected to the data input terminal of the verification unit, and the data output terminal of the verification unit is connected to the data input terminal of the scene determination unit.

[0024] like Figure 3 As shown, the data processing module includes a data association unit, a shelf-life early warning unit, and a flow tracking unit, wherein... The data association unit is used to automatically bind the legitimate material information transmitted by the barcode scanning module with the production work order, operation team, production equipment and finished product model data retrieved in real time from the enterprise's basic production information database to generate full-dimensional basic material data. The shelf life early warning unit is used to receive the full-dimensional basic material data output by the data association unit, parse the material production date and shelf life parameters, compare them with the current system time, determine the material status (normal / near shelf life / expired) according to a custom threshold, and generate material verification data with status identifiers. The material flow tracking unit is used to receive material verification data output by the shelf life warning unit, and, in conjunction with the current operation node (requisition / online / assembly / finished product warehousing), record the node operation time, operator, and equipment number to generate final material data with complete traceability information; The data output terminal of the data association unit is connected to the data input terminal of the shelf life warning unit, and the data output terminal of the shelf life warning unit is connected to the data input terminal of the circulation tracking unit.

[0025] like Figure 4 As shown, the database module includes a hierarchical storage unit, an offline caching unit, and a backup and traceability unit, wherein... The offline caching unit is used to receive material information, forward it directly to the hierarchical storage unit when the network is normal, and cache the material information locally with timestamps when the network fails. After the network is restored, it is incrementally synchronized to the hierarchical storage unit to ensure that the material information is not lost. The hierarchical storage unit is used to receive material information transmitted by the offline cache unit, and divide the material information into high-frequency query data and low-frequency query data according to the material query frequency. The high-frequency query data is stored in the high-speed cache area, and the low-frequency query data is stored in the regular database, so as to realize the hierarchical storage management of data. The backup traceability unit is used to receive the final data after hierarchical storage, generate a unique version number for each piece of data, perform incremental backups only for newly added / modified data, and retain historical versions to achieve traceability of tampering. The data output terminal of the offline caching unit is connected to the data input terminal of the hierarchical storage unit, the data output terminal of the hierarchical storage unit is connected to the data input terminal of the backup and traceability unit, and the data output terminal of the backup and traceability unit is connected to the data input terminals of the data processing module and the user interaction module, respectively.

[0026] like Figure 5 As shown, the query and traceability module includes a query and traceability unit and a report generation unit, wherein, The query and traceability unit is used to receive user query instructions, query finished product information using material number, or query material information using finished product number, and supports keyword fuzzy query and multi-condition combination query, and outputs a structured material / finished product traceability dataset. The report generation unit is used to receive the traceability dataset output by the query and traceability unit, automatically generate visual charts such as material consumption, batch distribution, and production line consumption, and supports export in Excel / PDF format; The data output terminal of the query and traceability unit is connected to the data input terminal of the report generation unit, and the data output terminal of the report generation unit is connected to the data input terminal of the user interaction module.

[0027] like Figure 6 As shown, the user interaction module includes a permission management unit and an exception push unit, wherein, The permission management unit is used to verify the identity of users when they log in, and divides the operation permissions into five levels: operators, quality inspectors, material managers, production supervisors and after-sales personnel. It outputs permission activation signals and all operations must pass the permission verification first. The anomaly push unit is used to receive anomaly signals (wrong material / expired / synchronization failure) from various modules of the system and push them to the corresponding responsible persons through terminal pop-ups and workshop dashboards.

[0028] The specific process of automating material information collection and traceability using the above system is as follows: user permissions are the entry point, barcode scanning is the starting point, data processing is the core, storage and backup are the support, query and traceability are the exit point, and anomaly push notifications are the guarantee. The entire process is free of redundant manual operations, realizing automatic material information collection, intelligent verification, closed-loop storage, full-link traceability, and proactive alarms. The complete operation is divided into 6 core stages: (1) Phase 1: User interaction module implements permission verification and system initialization 1. Operators log in to the system via industrial terminals, and the access control unit completes identity verification; 2. Five levels of operation permissions are assigned according to job position (operator / quality inspector / administrator / supervisor / after-sales), and only operations within the authorized permissions are allowed; 3. The system automatically loads the current production line number, finished product model, and compatible material list to complete pre-production initialization; 4. The permission activation signal is synchronously sent to the scanning module, data processing module, database module, and query and traceability module. All operations can only be executed after the permission verification is passed.

[0029] (2) Phase 2: The barcode scanning module implements four-fold verification of material codes: collection, anti-tampering, adaptability, and scenario-based verification. This phase is the core entry point for automated collection of material information, completing the triple checks of "genuine code, correct material, and legal scenario". 1. The barcode scanning terminal collects the one-dimensional / two-dimensional barcode image of the material identification sheet and outputs the original code data; 2. The parsing unit extracts standardized material information (code, batch, production date, supplier) according to the dual-code protocol; 3. The tamper-proof unit verifies the QR code dynamic verification code + tear-resistant laser label, and outputs the result of whether the label is legal or illegal; 4. The verification unit only receives valid identification data and matches material information with the production line / finished product / material list in real time: Mismatch / illegal flag → Directly reject the entry and trigger an alert pop-up; Match successful → Pushed to scene determination unit; 5. The scene determination unit classifies four types of scenes according to rules and processes them automatically: Accidental scanning: Scanning a device that has not been claimed → pop-up notification, default rejection of data entry; Rescan: Manually select rescan → Mark the reason, record the time / operator; Batch requisition: Scan consecutively within the same batch → automatically accumulate quantities and generate batch records; Normal scanning: First valid scan → Directly pushed to the data processing module; Once the verified and legitimate material data has been completed, it will be temporarily stored in the database module for archiving.

[0030] (3) In stage 3, the data processing module realizes intelligent processing of material data in all dimensions. This stage upgrades single material information into full-chain traceability data, which is the core of traceability capability: 1. The data association unit receives legitimate material information, automatically binds it to production work orders, operation teams, production equipment, and finished product models, and generates comprehensive basic material data. 2. The shelf life warning unit parses the production date / shelf life, determines the status (normal / near expiration / expired) according to the threshold, and generates verification data with status indicators; 3. The flow tracking unit, combined with the current node (requisition / online / assembly / finished product warehousing), records the operation time, personnel, and equipment, and generates final material data with complete traceability information; Once the traceability data has been processed, it is pushed to the database module for storage and archiving.

[0031] (4) Phase 4: The database module implements hierarchical data storage + offline fallback + incremental backup. This phase ensures that data is not lost, queries are fast, and data is traceable. 1. Offline cache units prioritize receiving data: Network is normal → forward directly to tiered storage; Network failure → Encrypted and timestamped local storage is temporarily stored, and incremental synchronization is performed after the network is restored; 2. Hierarchical storage units are stored in layers according to query frequency: High-frequency data (last 3 months / core production line) → high-speed cache (fast query); Low-frequency data (over 3 months / spare materials) → Regular database (saves resources); 3. The backup and traceability unit generates a unique version number for each piece of data, and only incrementally backs up newly added / modified data, while retaining historical versions to achieve traceability of data tampering.

[0032] (5) Stage 5: The query and traceability module realizes full-link query and traceability and automatic report generation. This stage realizes two-way traceability of materials and finished products, meeting the quality traceability requirements. 1. The user initiates a query command through the interactive terminal, and the query and traceability unit receives and executes it: Forward traceability: Material number → check finished product, work order, production line, operator; Reverse tracing: Finished product number / work order → Check all materials used, batches, and suppliers; It supports fuzzy search and multi-condition combined search, and outputs a structured traceability dataset; 2. The report generation unit automatically generates visual charts of material consumption, batch distribution, and production line consumption based on traceability data, and supports one-click export to Excel / PDF.

[0033] (6) Stage 6: The user interaction module implements proactive anomaly push and closed-loop alarm. This stage realizes proactive system management, replacing passive query: 1. The barcode scanning module (incorrect / tampered), data processing module (expired), and database module (synchronization failure) output abnormal signals in real time; 2. The anomaly push unit receives anomaly signals and accurately pushes them to the corresponding responsible persons through industrial terminal pop-ups and workshop visualization dashboards; All anomalies, operations, and data changes are fully recorded, forming a closed loop of collection, processing, storage, traceability, and alarm.

[0034] In summary, this invention, through the dual-code compatible parsing, anti-tampering verification, material compatibility verification, and scenario-based intelligent judgment of the barcode scanning module; the full-dimensional automatic data association, intelligent shelf-life warning, and flow node tracking of the data processing module; the hierarchical storage, offline caching, incremental backup, and version traceability of the database module; the forward and reverse full-link traceability and visual report generation of the query and traceability module; and the refined permission control and proactive anomaly push of the user interaction module, fundamentally solves the core technical defects of existing technologies, such as the inability to intercept incorrect materials in advance, rigid barcode scanning mechanisms with poor adaptability, easy loss and lag in data storage and lack of traceability, lack of full-link bidirectional traceability, and lack of data support for production decisions. Ultimately, it achieves automated collection of production line material information, intelligent verification throughout the entire process, secure and stable storage, full life-cycle bidirectional traceability, and proactive anomaly control. It can effectively adapt to the actual production needs of modern production lines with multiple scenarios, high concurrency, and cross-link collaboration, and significantly improve the efficiency of production material management and quality and safety assurance capabilities.

[0035] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications made to the present invention by those skilled in the art without departing from the spirit of the present invention shall fall within the protection scope of the present invention.

Claims

1. An automated material information collection and traceability system, characterized in that, It includes multiple functional modules capable of data interaction, including a QR code scanning module, a database module, a data processing module, a query module, and a user interaction module. The scanning module is used to parse the one-dimensional or two-dimensional barcode on the material into standard material information, and to perform anti-tampering verification, material compatibility verification, and scanning scenario determination. The database module is used to perform high-frequency / low-frequency hierarchical storage of material data, and to perform local offline storage of material information when the network is interrupted. It is also configured with a material information backup and version traceability mechanism. The data processing module is used to automatically associate material information with production work orders, operation teams, production equipment, and finished product models, and synchronously record the information of the entire flow of materials, including material requisition, online production, assembly, and finished product warehousing, and to provide intelligent early warning based on thresholds for material shelf life. The query and traceability module is used to provide users with material information and finished product information query functions, and supports keyword fuzzy query and multi-condition combination query. The query results can be generated into a visual statistical report for export. The user interaction module is used to set different access and operation permissions for users in different positions, and to actively push material abnormality information through industrial terminal pop-ups and workshop visualization dashboards to realize real-time alarms for abnormalities.

2. The system according to claim 1, characterized in that, The scanning module includes a scanning terminal, a parsing unit, an anti-tampering unit, a verification unit, and a scene determination unit, wherein... The barcode scanning terminal is used to collect the one-dimensional barcode / two-dimensional barcode image signal on the material identification sheet and output the original code data; The parsing unit is used to receive raw code data and extract standardized material information, including material code, batch, production date, supplier, etc., according to the built-in one-dimensional barcode / two-dimensional barcode dual-code parsing protocol. The anti-tampering unit is used to verify whether the built-in dynamic verification code and the tear-resistant laser mark on the one-dimensional barcode / two-dimensional barcode on the material identification sheet are intact, and output the verification result of whether the material identification is legal or illegal; The verification unit is used to receive the anti-tampering verification result. Only when the material identifier is valid, the parsed material information is matched in real time with the current production line number, finished product model, and compatible material list. If the match fails, it is determined to be an abnormal scan, the information entry is rejected and an early warning pop-up is triggered. If the match passes, the material information is pushed to the scene judgment unit and synchronously transmitted to the database module for temporary storage. The scenario determination unit is used to determine the scanning behavior into four scenarios: misscanning, rescanning, batch requisition, and normal scanning, based on preset scenario determination rules and material information, and to execute corresponding input, labeling, and quantity merging processing rules according to the scenario. The first data output terminal of the scanning terminal is connected to the data input terminal of the parsing unit, the second data output terminal of the scanning terminal is connected to the first data input terminal of the anti-tampering unit, the data output terminal of the parsing unit is connected to the second data input terminal of the anti-tampering unit, the data output terminal of the anti-tampering unit is connected to the data input terminal of the verification unit, and the data output terminal of the verification unit is connected to the data input terminal of the scene determination unit.

3. The system according to claim 1, characterized in that, The data processing module includes a data association unit, a shelf-life early warning unit, and a flow tracking unit, wherein... The data association unit is used to automatically bind the legitimate material information transmitted by the barcode scanning module with the production work order, operation team, production equipment and finished product model data retrieved in real time from the enterprise's basic production information database to generate full-dimensional basic material data. The shelf life early warning unit is used to receive the full-dimensional basic material data output by the data association unit, parse the material production date and shelf life parameters, compare them with the current system time, determine the material status according to a custom threshold, and generate material verification data with status identifiers. The flow tracking unit is used to receive material verification data output by the shelf life warning unit, and, in conjunction with the current operation node, record the node operation time, operator, and equipment number to generate final material data with complete traceability information. The data output terminal of the data association unit is connected to the data input terminal of the shelf life warning unit, and the data output terminal of the shelf life warning unit is connected to the data input terminal of the circulation tracking unit.

4. The system according to claim 1, characterized in that, The database module includes a hierarchical storage unit, an offline cache unit, and a backup and traceability unit, wherein... The offline caching unit is used to receive material information, forward it directly to the hierarchical storage unit when the network is normal, and cache the material information locally with timestamps when the network fails. After the network is restored, it is incrementally synchronized to the hierarchical storage unit to ensure that the material information is not lost. The hierarchical storage unit is used to receive material information transmitted by the offline cache unit, and divide the material information into high-frequency query data and low-frequency query data according to the material query frequency. The high-frequency query data is stored in the high-speed cache area, and the low-frequency query data is stored in the regular database, so as to realize the hierarchical storage management of data. The backup traceability unit is used to receive the final data after hierarchical storage, generate a unique version number for each piece of data, perform incremental backups only for newly added / modified data, and retain historical versions to achieve traceability of tampering. The data output terminal of the offline cache unit is connected to the data input terminal of the hierarchical storage unit, and the data output terminal of the hierarchical storage unit is connected to the data input terminal of the backup traceability unit.

5. The system according to claim 1, characterized in that, The query and traceability module includes a query and traceability unit and a report generation unit, wherein... The query and traceability unit is used to receive user query instructions, query finished product information using material number, or query material information using finished product number, and supports keyword fuzzy query and multi-condition combination query, and outputs a structured material / finished product traceability dataset. The report generation unit is used to receive the traceability dataset output by the query and traceability unit, automatically generate visual charts such as material consumption, batch distribution, and production line consumption, and supports export in Excel / PDF format; The data output terminal of the query and traceability unit is connected to the data input terminal of the report generation unit, and the data output terminal of the report generation unit is connected to the data input terminal of the user interaction module.

6. The system according to claim 1, characterized in that, The user interaction module includes a permission management unit and an exception push unit, wherein, The permission management unit is used to verify the identity of users when they log in, and divides the operation permissions into five levels according to operators, quality inspectors, material managers, production supervisors and after-sales personnel, and outputs permission activation signals; The anomaly push unit is used to receive anomaly signals from various modules of the system and push them to the corresponding responsible persons through terminal pop-ups and workshop dashboards.

7. The system according to claim 2, characterized in that, In the scenario-based judgment unit, the scenario of misscanning is when the same material has not been used and is scanned repeatedly. The system pops up a message saying "suspected misscanning" and refuses to enter the data. In the supplementary cleaning scenario, the operator manually selects the supplementary cleaning, the system marks the reason for the supplementary cleaning, and records the supplementary cleaning time and operator information; In the scenario of batch requisition, the same material is scanned multiple times in the same batch, and the system automatically accumulates the quantity to generate a batch record. Normal scanning scenarios are for legitimate materials that are being scanned for the first time and have no historical records, and that have not yet been used. After the system completes the verification, the material information is pushed to the data processing module.

Images