A method for associating materials and finished product bar codes with production flow in a composite current collector wire control system

Abstract

The application discloses a material and finished product barcode association tracking method for production process in a composite current collector wire control system, and belongs to the technical field of manufacturing production management. The method comprises the following steps: creating a production order and generating a work order, the work order number is generated according to a preset fixed-length coding rule, and raw material barcodes are automatically bound with the work order; process starting and completion tracking is performed through production reporting, the process mode comprises a unique code mode and a replacement code mode, concurrent control is realized by relying on state precondition; when the process is a slitting process, the slitting process is automatically triggered, finished product barcodes are generated according to the work order or product dimension, and the slitting of one raw material corresponding to multiple finished product barcodes is realized. The application realizes automatic association of raw material codes to finished product codes and full-process tracking, supports the slitting of multiple barcodes in the slitting process, the tracking accuracy reaches the single-piece level, and is suitable for full-process barcode tracking management in the field of composite current collector manufacturing.

Description

Technical Field

[0001] This application relates to the field of manufacturing production management technology, and in particular to a method for material and finished product barcode association traceability in a composite current collector line control system. Background Technology

[0002] In manufacturing production management, material traceability is a crucial aspect of ensuring product quality. Currently, raw material barcodes and finished product barcodes are typically independent, lacking an effective correlation mechanism during production, making it difficult to trace the source of raw materials. Some companies use batch-based correlation to establish a coarse-grained correspondence between raw materials and finished products based on production batches; however, this method only traces back to the batch level and cannot pinpoint the correspondence between specific individual raw materials and finished products. Manual data entry or barcode scanning for correlation is cumbersome and prone to errors in complex production scenarios such as multiple batches of raw materials being used in the same finished product or multiple barcodes being distributed during the cutting process. Systems that manage barcodes independently for each process lack cross-process data linkage capabilities, resulting in delayed updates to barcode flow information and hindering real-time tracking of the production process. Therefore, a traceability management solution is needed that can establish precise correlations between raw materials and finished products during the manufacturing process and support special process distribution scenarios. Summary of the Invention

[0003] Embodiments of this application provide a method for material and finished product barcode association traceability in a composite current collector line control system.

[0004] To achieve the above objectives, embodiments of this application provide a method for material and finished product barcode-based traceability in a composite current collector line control system, comprising: Step A, Production Order Creation and Raw Material Barcode Collection and Registration: Create a production order, which includes product information, process type, process template, and production line information; execute the order placement operation on the production order to generate a work order, the work order number is generated according to the preset fixed-length coding rule, and the work order number contains the production order number information; bind the raw material barcode to the work order and collect the raw material barcode; Step B, Production Process Tracking: Based on the production line number and work order status, locate the current work order and current process. The process mode includes unique code mode and change code mode; execute the start operation to update the production record status from not started to in progress; execute the completion operation to update the production record status from in progress to completed. Step C, Slitting Record Generation and Multi-Barcode Diversion: After the process is completed, check whether the process is a slitting process; if it is a slitting process, trigger the slitting reporting process and enter the slitting specifications; generate the corresponding finished product barcode based on the barcode generation strategy, and establish the association record between the finished product barcode and the raw material barcode; Step D, Product Coding Association and Packaging: Create a product coding record, which includes a work order identifier, a cutting record identifier, a raw material barcode, and a finished product barcode; create a packaging record, which includes a packaging batch barcode, and associate the finished product barcode with the packaging batch. Step E, Two-way traceability query: Based on the finished product barcode or packaging batch code, trace back to the raw material barcode and the entire production chain information, or based on the raw material barcode, trace forward to all derived finished product barcodes and packaging destination information.

[0005] Using the above solution, the overall process is organically linked through a series of steps, including creating production orders, generating work orders, binding raw material barcodes, tracking production processes, cutting and distribution, barcode association, packaging and collection, and two-way traceability queries. This achieves automatic data connection across all stages of the production process. Production personnel no longer need to repeatedly switch between different business modules or manually enter associated information. Barcode data during the production process flows naturally and is automatically accumulated between each process, ultimately forming a complete traceable data link, improving operational efficiency on the production floor and the integrity of traceability data.

[0006] Preferably, in step A, the fixed-length coding rule is as follows: the first part of the work order number is the production order number, the middle part is the date of issuance, and the last part is the incremental serial number of the work order issued on that day; when the work order is generated, the production record, production materials and work order process parameters are created simultaneously, and the production record is generated one by one according to the number of processes in the process template.

[0007] The work order number uses a fixed-length coding rule that includes the production order number, the issuance date, and an incremental serial number. This ensures that the work order number itself carries business information about the order and production time, allowing for quick identification of the work order's origin and issuance sequence without needing to consult additional data. When a work order is generated, production records, production materials, and work order process parameters are created simultaneously, ensuring that all related data is complete and ready before the work order is initiated. This prevents operational interruptions or traceability breakdowns due to missing data during subsequent production.

[0008] Preferably, step A, the step of collecting raw material barcodes, includes: receiving work order information, which includes work order number, material barcode, operation type, and quantity; verifying that the work order status is in production; when the operation type is "started", performing a concurrent occupancy check to query the database whether there is already a work order with the same material barcode, operation type "started", and no corresponding completion record; if it already exists, rejecting the operation; after the check passes, inserting the work order record and updating the production record status within the same database transaction to obtain an update statement, which includes status preconditions.

[0009] By receiving information such as work order number, material barcode, operation type, and quantity during the work reporting process, and performing concurrent occupancy verification under the start-up operation type—checking the database to see if a work order with the same material barcode, start-up type, and corresponding completion record already exists, and rejecting the operation if it already exists—this ensures that the same material barcode is not used multiple times within the same work order, avoiding traceability chaos caused by duplicate material input from a data perspective. After successful verification, the work reporting record is inserted and the production record status is updated within the same database transaction, with the update statement including a status precondition, ensuring the atomicity of work reporting data writing and status change, and data consistency.

[0010] Preferably, in step B, locating the current work order and the current process includes: filtering all work orders currently in production on the production line according to the production line number and production status, and sorting them in ascending order by work order start time; looking up the process template and corresponding process of the equipment according to the scanned equipment tag number; taking the work order with the earliest start time, comparing its process template with the template matched by the equipment corresponding to the equipment tag number one by one, and locating the corresponding process of the work order if a match is found.

[0011] By employing a positioning logic that filters work orders based on production line number and production status, sorts them forward by start time, looks up process templates and corresponding procedures based on equipment tag number, and compares the earliest work order with the template one by one, the system can automatically match the correct work order and procedure after the operator scans the equipment's QR code before starting work. When multiple work orders are in production on the same production line, this positioning method can accurately identify the procedure currently being performed by the equipment, avoiding the mistake of assigning materials to the wrong work order or procedure due to human error.

[0012] Preferably, in step B, the start-up operation includes: verifying that the scanned equipment tag number has been registered in the equipment ledger and bound to the corresponding workstation of the current production line; if the current process is the first process, verifying that the scanned raw material barcode belongs to the material details list corresponding to the current work order; implementing optimistic locking concurrency control through status preconditions, allowing start-up only when the production record status is not started; after verification, inserting a start-up type work report record in the same database transaction, and updating the production record status from not started to in progress.

[0013] During startup, the system verifies that the equipment tag number is registered in the equipment ledger and bound to the corresponding workstation on the current production line. This ensures consistency between production equipment and the process route, preventing equipment from being put into use without proper configuration. The first step additionally verifies that the raw material barcode belongs to the material list corresponding to the current work order, preventing the mixing or misuse of raw materials between different work orders. Through optimistic locking control with status preconditions, startup is only allowed when the production record status is "not started," avoiding status confusion caused by the same process being repeatedly started.

[0014] Preferably, in step B, the completion operation includes: if the process mode is a unique code mode, comparing the scanned barcode with the barcode entered when the process started; if they do not match, the completion is rejected; if the process mode is a code change mode, skipping the barcode comparison and recording the scanned barcode as a new barcode; verifying whether the set values ​​of the process parameters associated with the process have been completely filled in; if there are any missing parameters, the completion is rejected; verifying that the current status of the production record is in progress; after the verification is successful, inserting a completion-type work report record in the same database transaction, and updating the production record status from in progress to completed.

[0015] During the completion process, barcode comparison logic is handled separately for unique code mode and replacement code mode: In unique code mode, the completed scanned barcode is compared with the start-up entered barcode; if they do not match, completion is rejected, ensuring consistency of the same material roll in the feeding and discharging stages and preventing misuse of material rolls; in replacement code mode, the comparison is skipped and the scanned barcode is recorded as a new barcode, adapting to production scenarios involving different roll switching. Simultaneously, the completeness of the process parameter settings associated with this process is verified, avoiding the problem of untraceable output quality in the event of missing process parameters.

[0016] Preferably, in step C, the slitting and reporting process includes: automatically checking the slitting identifier of the process after the process is completed; if the identifier is correct, automatically triggering the slitting and reporting; receiving the slitting specification list, verifying that the slitting specification list is not empty and that the width and length of each specification are valid values; verifying that the number of slitting specifications does not exceed a preset upper limit; after the verification is passed, adding an exclusive lock to the total number of existing slitting records within the same database transaction, traversing each slitting specification to generate the finished product barcode number according to the barcode generation strategy, and inserting the slitting record and the product coding association record.

[0017] After the process is completed, the system automatically checks the slitting marker and triggers slitting data entry, eliminating the need for manual judgment and switching of the operation interface, thus reducing the risk of omissions in the slitting process. Upon receiving the slitting specification list, the system verifies that the width and length of each specification are valid values ​​and do not exceed the preset upper limit, ensuring the standardization of the slitting data. Exclusive locks control the query and insertion operations of the total number of slitting records, preventing sequence number errors or record overwriting when multiple operators simultaneously slit the same work order.

[0018] Preferably, in step C, the barcode generation strategy includes a work order generation strategy and a product generation strategy. The work order generation strategy involves: obtaining the current work order number, querying the number of finished product barcodes already generated under the work order, calculating the next serial number, and generating a finished product barcode containing the work order number and the serial number, with the serial number length being a preset positive integer. The product generation strategy involves: obtaining the product number and the current date, querying the number of barcodes already generated for the product on the current day, calculating the next serial number, and generating a finished product barcode containing the product number, date, and serial number, with the serial number length being a preset positive integer. The concurrency of serial number generation is controlled by database row locks to ensure that the serial number is unique and increments.

[0019] Finished product barcodes are generated using two strategies: one based on the work order and the other on the product. Barcodes generated by the work order facilitate quick location of all finished products under that work order using the work order number, while barcodes generated by the product facilitate tracing the production distribution of that product across different work orders using the product number and date. Both strategies can be flexibly selected according to production management needs. Sequence number generation uses database row-level locking to control concurrency, ensuring that finished product barcodes generated on the same work order or for the same product within the same day have strictly incremental and non-repeating sequence numbers. This avoids duplicate numbers caused by concurrent operations, preventing barcodes from being uniquely identified during subsequent traceability.

[0020] Preferably, in step D, the product coding record includes a work order identifier, a cutting record identifier, a raw material barcode, a finished product barcode, finished product size parameters, and a coding status. Database indexes are established for the raw material barcode and the finished product barcode respectively. The coding rule for the packaging batch barcode is a combination of supplier number, date and time, and sequence number, with the sequence number being a preset positive integer. When scanning the semi-finished product barcode during packaging, it is verified that the semi-finished product barcode exists in the product coding association record and its status is "printed," and it is also verified that the semi-finished product barcode has not been associated with or used by other packaging records.

[0021] Product coding records simultaneously carry both raw material barcode and finished product barcode information. After establishing separate database indexes for raw material and finished product barcodes, queries from the raw material side to find the finished product, and vice versa, can be quickly located using the indexes, improving the query response speed for two-way traceability. During the packaging process, verification is performed to ensure that the semi-finished product barcode exists in the product coding association record and is in a "printed" status, and is not associated with other packaging records, preventing the same finished product from being packaged repeatedly or omitted from packaging.

[0022] Preferably, in step E, reverse traceability includes: if the input is a packaging batch code, sequentially querying packaging records to obtain basic packaging information, querying packaging details to obtain a list of semi-finished product barcodes, querying product coding association records to obtain the raw material barcodes corresponding to each semi-finished product barcode, querying work order material information to obtain basic raw material information, querying work orders and production orders to obtain order and product information, querying production records to obtain information on each process, and querying work order process parameters to obtain the actual values ​​of equipment parameters, assembling layer by layer into a complete traceability chain; if the input is a single finished product barcode, then directly starting the query from the product coding association records; Forward traceability includes: receiving raw material barcodes, querying product coding association records to obtain a list of all finished product barcodes derived from the raw material, querying the packaging batch information to which each finished product barcode belongs, and summarizing to obtain all finished product information, cutting specifications, and packaging destinations produced from the raw material.

[0023] Reverse traceability starts with packaging batch codes or individual finished product barcodes, unfolding layer by layer along the chain of packaging records, packaging details, product coding association records, work order material information, work orders and production orders, production records, and work order process parameters. This provides a complete data overview of the entire process from finished product to raw materials, from packaging to processes, and from equipment parameters to order information. Forward traceability retrieves all derived finished products by querying product coding association records using raw material barcodes, and then associates this with packaging batch information, enabling rapid location of the final destination of all finished products produced from a single batch of raw materials.

[0024] Preferably, the method further includes: for finished product barcodes generated according to the work order generation strategy, extracting the work order number portion from the finished product barcode and querying work order information based on the work order number portion; for finished product barcodes generated according to the product generation strategy, extracting the product number portion and the date portion from the finished product barcode, querying product information based on the product number portion, and determining the production date range based on the date portion.

[0025] The finished product barcodes contain built-in business information from the encoding rules: barcodes generated according to the work order strategy include the complete work order number, which can be extracted to directly locate the corresponding work order; barcodes generated according to the product strategy include the product number and date, which can be extracted to quickly determine product information and the production date range. This decoding process can parse key information from the barcode itself without querying the database. In batch traceability or offline query scenarios, the target data range can be filtered in advance, reducing the amount of data queried from the database and improving traceability efficiency.

[0026] This application has the following advantages over the prior art: This invention embeds raw material barcode collection into the production reporting process, using the reporting record as the collection carrier. Production personnel simultaneously enter the raw material barcode when reporting work, eliminating the need for a separate barcode scanning and association step, thus reducing operational steps and manual intervention. Work orders are automatically generated by the system and bound to the raw material code when the order is placed. The association operation is completed automatically in the background, avoiding omissions and errors from manual matching, and the association accuracy is refined from the batch level to the single-piece level.

[0027] The slitting process is natively linked to the process template. After the slitting process is marked during the process configuration stage, the system automatically recognizes and triggers the slitting process upon completion. Users do not need to actively switch business modules. The barcodes of the slitting finished products are automatically generated by the system according to a preset strategy, avoiding the problem of duplicate or skipped numbers that may occur with manual numbering. The system offers two entry points: slitting immediately upon completion of the process and slitting afterward. These options adapt to different work rhythms on the production floor, and users can flexibly choose according to their actual situation.

[0028] Product barcode records serve as a crucial link, with a single table simultaneously representing the correspondence between raw material barcodes and finished product barcodes. Reverse tracing starts from the finished product barcode, sequentially linking packaging batches, cutting records, raw material sources, work order information, production orders, start and end times of each process, input and output data, and equipment parameter settings, presenting a complete chain from finished product to raw material. Forward tracing starts from the raw material barcode, quickly locating all finished products produced from that raw material, as well as the packaging batch and destination of each finished product. The barcode itself contains business coding information; without querying the database, the work order number or product number and production date can be parsed from the barcode format, improving offline identification efficiency and query response speed.

[0029] Concurrency control measures are implemented at each stage. A joint unique constraint at startup prevents the duplicate input of the same raw material; optimistic locking during status updates prevents the same process from being repeatedly started or completed; row locking during cutting ensures strictly incremental sequence numbers; unique constraints during packaging prevent the same half-finished product from being repeatedly associated; and optimistic locking upon packaging completion prevents duplicate submissions. In case of barcode scanner malfunction or barcode corruption, the system records a failure log and provides a manual degradation solution. If data is missing at a stage in the traceability chain, all valid data retrieved is returned, and the missing location is marked, balancing the fault tolerance requirements of the production site with data integrity requirements.

[0030] The combined effect of these measures ensures that barcode data is automatically collected and linked from the moment it is input into the production process. After passing through various processes and being cut and distributed, complete traceability information is maintained, enabling full-process data tracking from raw material input to finished product output without human intervention. Attached Figure Description

[0031] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0032] Figure 1 This is a flowchart illustrating the method for linking and tracing materials and finished products with barcodes in the production process of the composite current collector line control system according to an embodiment of this application. Detailed Implementation

[0033] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0034] In the description of this application, it should be understood that the terms "center", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application.

[0035] In the description of this application, it should be noted that, unless otherwise expressly specified and limited, the terms "installation", "connection" and "joining" should be interpreted broadly, for example, they can refer to fixed connection, detachable connection, or integral connection; for those skilled in the art, the specific meaning of the above terms in this application can be understood according to the specific circumstances.

[0036] The terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Therefore, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this application, unless otherwise stated, "a plurality of" means two or more.

[0037] Reference Figure 1 The present application provides the following embodiments.

[0038] Before implementing the material and finished product barcode association traceability method in the composite current collector line control system provided in this application, preliminary data configuration should be performed first.

[0039] In this application, the basic data modeling and configuration of the entire system are completed first. Specifically: In the material / product basic information, maintain the daily attributes of raw materials and finished products, including name, number, code, type (product / material), length, width, area, weight unit, and remarks.

[0040] The parameter definition maintains four main categories of system parameters: process parameters (key equipment parameters such as speed and pressure), data acquisition parameters (equipment parameters collected on the production line such as material level and temperature), inspection parameters (semi-finished product inspection parameters such as particle size and viscosity), and energy consumption parameters (energy parameters such as electrical energy and flow rate). Each parameter includes a parameter name, unit, English name, data type (floating-point / integer / text), parameter standard, upper limit, and lower limit.

[0041] In the three-level equipment system, equipment types are maintained according to parent-child relationships, including parent type, type name, and type description; equipment models are associated with corresponding equipment types, including model, brand, manufacturer, legend, specifications, and whether it is critical equipment; the equipment ledger maintains real equipment instances in the plant area, divided into parent-child levels, including key basic attributes such as equipment ownership, model, production line, tag number, asset information, usage status, and responsible department.

[0042] In production line modeling, the workshop-production line parent-child hierarchy is maintained, including the parent level, name, output, capacity, and weight unit. Each production line is divided into workstations, which include the associated equipment group, name, and workstation number, and the workstation sorting can be adjusted. After a workstation is associated with an equipment group, key process parameters of the equipment under that group can be bound.

[0043] In the process type and process template, the process type defines the purpose of the process; the process template defines the complete process steps for the production of a product, including product, process type, production line, process name, version, and remarks. The template process includes process number, process name, workstation, planned preparation time, planned time, process mode (unique code mode indicates that the input and output have the same code, and change code mode indicates that the input and output have different codes), processing content, whether to cut, whether to inspect the process, and whether to inspect and control.

[0044] The method for material and finished product barcode association traceability in the production process of the composite current collector line control system provided in this application includes: Step A, Production Order Creation and Raw Material Code Collection and Registration, specifically includes: Production order creation and work order generation are as follows: In this implementation, the system receives creation requests through the production order service. A production order includes an order number (default 8 characters), product (records of type "product" selected from the material / product basic information), process type, process template (filtered based on the selected product and process type), production line (automatically populated after selecting a process template), planned output, planned start time, planned end time, and finished product specifications. After a production order is created, raw material information is maintained in the sub-table, Material Details. Material details data is queried in real-time through the warehouse system, including name, code, specifications, batch number, barcode, length, width, and weight.

[0045] When a production order is placed, the system iterates through all material details records under the current production order and creates a corresponding work order for each material detail. The work order number is generated according to a preset fixed-length coding rule (length is configurable by business requirements, preferably 19 digits): the first part is the production order number (preferably 8 digits), the middle part is the issuance date (8 digits), and the last part is the incrementing serial number of the work order issued under that production order on that day (preferably 3 digits), starting from a preset starting value (preferably 001) and incrementing sequentially, adding leading zeros if the number of digits is insufficient. When a work order is generated, production records (generated one by one according to the number of processes in the process template), production materials, and work order process parameters are created simultaneously. After manual confirmation, the work order status changes to "Confirmed," and after initiation, the status changes to "In Production."

[0046] Raw material code collection and registration, specifically: In this embodiment, production personnel submit raw material barcode information via a barcode scanning device. The work report information received by the system includes the work order number, material barcode, operation type, input or output quantity, and operator identification.

[0047] The system performs multi-level checks: checks the work order number format and data existence; checks the work order status as in production; checks the validity of the material barcode format; and when the operation type is "start," performs concurrent occupancy checks (checking whether there is already a work order with the same material barcode, operation type "start," and no corresponding completion record).

[0048] After successful verification, a work report record is inserted and the production record status is updated (from never started to in progress) within the same database transaction, resulting in an update statement with preconditions for the status. For scenarios where multiple workers simultaneously scan the same raw material barcode, a database joint unique constraint is set (work order identifier, material barcode, operation type). For scenarios where a single operator continuously scans multiple different raw material barcodes, an independent work report record is created for each barcode, and all records are committed uniformly within the same database transaction.

[0049] Step B, production process tracking, specifically includes: In this implementation, the operator scans the QR code on the equipment before starting work. The system filters work orders based on the production line number and production status, sorts them forward by start time; it then looks up the process template and corresponding process based on the scanned equipment tag number; it takes the work order with the earliest start time, compares its process template with the template matched to the equipment one by one, and locates the corresponding process for that work order after a successful match.

[0050] During the start-up operation, the system verifies that the equipment tag number has been registered and bound to the corresponding workstation of the current production line; verifies that the work order status is in production; if it is the first process, verifies that the raw material barcode belongs to the material details list corresponding to the current work order; and implements optimistic locking concurrent control through status preconditions. After the verification is successful, a work report record of the start-up type is inserted, and the production record status is updated from never started to in progress.

[0051] During the completion operation, the system processes barcode comparison according to the process mode: if the process mode is a unique code mode, the start barcode and completion barcode need to be compared; if the process mode is a change code mode, the comparison is skipped and the scanned barcode is recorded as a new barcode; the system verifies that the process parameter settings are completely filled in; and verifies that the production record status is in progress. After the verification is successful, a completion-type work report is inserted, the production record status is updated from in progress to completed, and the process time is automatically calculated.

[0052] Step C, record splitting and multi-barcode splitting, specifically includes: In this implementation, after each process is completed and passes verification, the system automatically checks the process's slitting identifier. If the identifier is correct, the slitting and reporting process is automatically triggered.

[0053] After the operator enters the slitting specifications, they submit the data. Each slitting specification includes width and length. The system verifies that the work order exists and is valid; verifies that the slitting specification list is not empty and that the width and length of each specification are valid values; and verifies that the number of slitting specifications does not exceed the preset limit (preferably no more than 100).

[0054] After successful verification, an exclusive lock is acquired on the total number of existing segmentation records for the work order within the same database transaction. Each segmentation specification is then iterated through to generate a finished product barcode number according to the barcode generation strategy. The system provides two strategies: generation by work order (work order number - serial number) and generation by product (product number + date + serial number). The serial number length is a preset positive integer, configurable by the system administrator within a preset range, preferably 2-6 digits, and more preferably 3 digits. Concurrency is controlled through database row locks to ensure the serial number is unique and increments sequentially.

[0055] Step D, product coding and packaging association, specifically: In this embodiment, when saving the slitting record, the system simultaneously creates a product coding record for each finished product barcode, including the work order identifier, slitting record identifier, raw material barcode, finished product barcode, finished product size parameters, and coding status. Database indexes are established for the raw material barcode and the finished product barcode respectively.

[0056] The packaging process consists of three stages. When creating a packaging record, the operator submits the product identifier, production line identifier, packaging date, packaging quantity, and operator identifier. The system automatically generates a packaging batch barcode (a combination of supplier number, date / time, and sequence number; the supplier number is preferably 5 digits, and the sequence number is a preset positive integer, preferably 1-4 digits, more preferably 2 digits). The initial status is "In Progress." In the barcode scanning and association stage, the operator scans the semi-finished product barcode one by one. The system verifies that the semi-finished product barcode exists in the product coding association record, its status is "printed," and it is not associated with any other packaging record. After all barcodes are scanned, the operator submits a packaging completion command. The system verifies that at least one semi-finished product has been scanned and updates the packaging record status from "In Progress" to "Completed."

[0057] Step E, bidirectional traceability query, specifically: In this implementation, reverse traceability supports queries initiated via packaging batch codes or individual finished product barcodes. If the input is a packaging batch code, the system sequentially queries packaging records, packaging details, product coding association records, work order material information, work orders and production orders, production records, and work order process parameters, assembling a complete traceability chain layer by layer. If the input is a single finished product barcode, the query starts directly from the product coding association records.

[0058] Forward traceability initiates a query through the raw material barcode, retrieves the barcode association records of the product to obtain a list of all finished product barcodes derived from the raw material, queries the packaging batch information to which each finished product barcode belongs, and summarizes all finished product information, cutting specifications and packaging destinations produced from the raw material.

[0059] Meanwhile, the system supports automatic decoding of finished product barcodes: for barcodes generated according to the work order generation strategy (including hyphens), the part before the hyphen is extracted to obtain the work order number, and the work order information is queried based on the work order number; for barcodes generated according to the product generation strategy (pure encoding format), the prefix is ​​extracted to obtain the product number, and the product information is queried based on the product number, and the middle date part is extracted to determine the production date range.

[0060] The method for material and finished product barcode association traceability in the composite current collector line control system provided in this application embodiment further includes: concurrent control and exception handling, specifically: In this implementation, the system employs multiple mechanisms to ensure data consistency in concurrent scenarios. The start-up operation uses database-wide unique constraints (work order identifier, material barcode, operation type) to prevent the same raw material from being used repeatedly in the same work order. Production record status updates utilize optimistic locking with update statements that include status preconditions, ensuring that only the first request to arrive successfully updates the status. In the slicing scenario, database row locks ensure that the query for the number of slicing records and the insertion of records for the same work order are not interrupted by other transactions. In the packaging scenario, the unique constraint of the semi-finished product barcode in the packaging details table prevents the same semi-finished product from being scanned and entered repeatedly.

[0061] For abnormal scenarios, when scanning fails, the system logs the failure and returns a clear prompt, while the page provides a fallback option for manual input. During split submission, if the work order status is changed, a prompt is returned requesting a refresh and retry. If a network interruption causes submission failure, the front end automatically saves the entered data, supporting resubmission after network recovery. During traceability queries, if the barcode format is invalid or the data is missing, a corresponding error message is returned; if data is missing at a certain stage in the process, all valid data retrieved is returned, and the missing stage is marked.

[0062] The method for material and finished product barcode association traceability in the composite current collector line control system provided in this application embodiment further includes: system deployment and operation, specifically: In this implementation, the entire system is structured in three layers from top to bottom. The operation and interaction layer is geared towards production operators, providing business entry points such as production reporting, slitting data entry, packaging barcode scanning, and traceability queries, supporting both barcode scanning devices and manual input. The business service layer includes production order services, work order management services, reporting record services, slitting processing services, packaging management services, and traceability query services, carrying the key business logic and verification rules for each stage. The data persistence layer stores basic data, production process data, barcode-related data, and log data, ensuring data consistency and query efficiency through mechanisms such as transactions, unique constraints, row locks, and indexes.

[0063] Raw material barcodes enter the system from the reporting stage, undergo process flow, cutting and distribution, coding and binding, packaging and collection, and are ultimately accumulated into a complete two-way traceability data chain, with data that is traceable, verifiable, and retrospective throughout the entire process. This invention is applicable to the entire process of barcode traceability in the composite current collector manufacturing industry, from raw material warehousing and production processing to finished product delivery.

[0064] Working principle: The key to this invention lies in using work reports as the data collection carrier for raw material barcodes and product coding records as the hub for traceability association, forming a complete traceability chain through the automatic interconnection of data from each stage. The specific working process is as follows: Before the system can run, basic data configuration must be completed. Users maintain basic information about materials and products, upper and lower limits of system parameters, the three-level system architecture of equipment, the layout of production lines and workstations, as well as process types and process templates. The process templates define the process mode, cutting identifier, and other attributes for each process. This configuration data provides the basis for the verification logic and triggering conditions in the subsequent production process.

[0065] When production starts, the user creates a production order, selecting the product, process type, and process template. The raw material information required for the order is maintained in the material details, where the raw material barcodes are generated by the warehousing system upon receipt. After the order is placed, the system automatically iterates through the material details to generate work orders. The work order number is generated according to a preset fixed-length coding rule and includes three parts: order number, issuance date, and serial number. This number will be used throughout the entire production process to locate all relevant business data. Simultaneously with work order generation, the system creates production records for each process step according to the number of steps in the process template, instantiates the material details, binds them to the work orders, and inherits the configuration values ​​of the process parameters.

[0066] During actual production, production personnel submit work reports via barcode scanning or manual input. This information includes the work order number, material barcode, operation type, and quantity. The system first verifies whether the work order status is "in production" and whether the material barcode format is valid. For "start" operations, it additionally verifies whether the raw material is already in use to prevent duplicate input of the same material. After successful verification, the system writes the work report record to the same database transaction and updates the production record status. A "start" operation updates the production record from "not started" to "in progress," and a "complete" operation updates it from "in progress" to "completed." Status update statements include preconditions; changes are only executed if the current status meets expectations. If the status has already been changed by other operations in a concurrent scenario, the system automatically rolls back and prompts the user to refresh and retry.

[0067] Before starting work, operators scan the QR code on the equipment in the process. The system filters all work orders currently in production on that production line based on the production line number, sorts them forward by start time, and compares the process template of the earliest work order with the template found by the equipment tag number. If a match is found, the system locates the corresponding work order and process for manual confirmation. At start-up, the system verifies that the equipment tag number is registered and bound to the current production line station. If it is the first process, it also verifies that the raw material barcode belongs to the material details range of the current work order. At completion, the system processes barcode comparison according to the process mode. In unique code mode, it compares the consistency between the start-up barcode and the completion barcode. In code change mode, it skips the comparison and uses the new barcode as the subsequent record, while simultaneously verifying that the process parameter settings associated with that process are completely filled in.

[0068] After each process is completed, the system automatically checks the cutting identifier of the process. If it is marked as a cutting process, the cutting data entry process is triggered. The user enters a list of cutting specifications, each specification including width and length values. The system verifies that the specifications are not empty, all values ​​are valid, and the number of specifications does not exceed the preset limit. Then, it adds an exclusive lock to the existing cutting records and iterates through each specification to generate finished product barcodes according to the barcode generation strategy. The system provides two strategies: a work order generation strategy that uses the work order number plus a serial number to form the finished product barcode, and a product generation strategy that uses the product number plus a date plus a serial number to form the finished product barcode. The two strategies can be selected according to management needs, and the serial number length can be configured by the administrator. The row locking mechanism ensures that the finished product barcode serial numbers of the same work order are strictly incremental and do not repeat. When the cutting record is saved, the system simultaneously creates a product coding record. This record simultaneously carries the work order identifier, cutting record identifier, raw material barcode, finished product barcode, finished product size parameters, and coding status. The raw material barcode and the finished product barcode are respectively indexed in the database.

[0069] The packaging process operates independently of the production process. Users first create a packaging record, submitting product identification, production line identification, packaging date, and packaging quantity. The system automatically generates a packaging batch barcode, with the encoding rule being a combination of supplier number, date and time, and sequence number. The initial status is "in progress." Users then scan the barcodes of the semi-finished products one by one. The system verifies that the barcode exists in the product coding record and its status is "printed," while also verifying that it is not used by other packaging records. Once verification is successful, the barcode is written to the packaging details. After all barcodes are scanned, the user submits a packaging completion command. The system verifies that at least one semi-finished product has been scanned and updates the packaging record status to "completed." The update statement includes a status precondition to prevent duplicate submissions.

[0070] During traceability queries, users can initiate reverse traceability by entering a packaging batch code or a single finished product barcode. The system then queries layer by layer along the chain of packaging records, packaging details, product coding records, work order material information, work orders and production orders, production records, and work order process parameters, assembling the data into a complete traceability chain that includes raw material source, processing steps, equipment parameters, cutting information, and packaging information. Users can also initiate forward traceability by entering a raw material barcode. The system retrieves all derived finished product barcodes for that raw material from the product coding records, then associates them with packaging batch information to summarize the destination of all finished products. The barcodes themselves have built-in encoding rules; barcodes generated according to a work order strategy can directly extract the work order number, while barcodes generated according to a product strategy can directly extract the product number and date portion for quickly locating the query range.

[0071] Throughout the process, data flows in from the order stage, goes through work order binding, work reporting collection, process status flow, splitting and distribution, coding records, packaging and collection, and finally settles into a two-way traceability data chain. All status changes are recorded, and in concurrent scenarios, data consistency is ensured through mechanisms such as unique constraints, optimistic locking, and row locking.

[0072] The above are merely specific embodiments of this application, but the scope of protection of this application is not limited thereto. Any variations or substitutions within the technical scope disclosed in this application should be included within the scope of protection of this application. Therefore, the scope of protection of this application should be determined by the scope of the claims.

Claims

1. A method for material and finished product barcode association traceability in a composite current collector line control system, characterized in that, include: Step A, Production Order Creation and Raw Material Code Collection and Registration: Create a production order, which includes product information, process type, process template, and production line information; The production order is issued to generate a work order. The work order number is generated according to a preset fixed-length coding rule and contains the production order number information. The raw material barcode is bound to the work order and the raw material barcode is collected. Step B, Production Process Tracking: Based on the production line number and work order status, locate the current work order and the current process. The process mode includes unique code mode and change code mode. Execute the start operation to update the production record status from not started to in progress; execute the completion operation to update the production record status from in progress to completed. Step C, Slitting Record Generation and Multi-Barcode Diversion: After the process is completed, check whether the process is a slitting process; if it is a slitting process, trigger the slitting reporting process and enter the slitting specifications; generate the corresponding finished product barcode based on the barcode generation strategy, and establish the association record between the finished product barcode and the raw material barcode; Step D, Product Coding Association and Packaging: Create a product coding record, which includes a work order identifier, a cutting record identifier, a raw material barcode, and a finished product barcode; Create a packaging record that includes a packaging batch barcode and associate the finished product barcode with the packaging batch; Step E, Two-way traceability query: Based on the finished product barcode or packaging batch code, trace back to the raw material barcode and the entire production chain information, or based on the raw material barcode, trace forward to all derived finished product barcodes and packaging destination information.

2. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step A, the fixed-length coding rule is as follows: the first part of the work order number is the production order number, the middle part is the date of issuance, and the last part is the incremental serial number of the work order issued on that day; when the work order is generated, production records, production materials, and work order process parameters are created simultaneously, and the production records are generated one by one according to the number of processes in the process template.

3. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step A, the step of collecting the raw material barcode includes: receiving work report information, which includes work order number, material barcode, operation type, and quantity; verifying that the work order status is in production; when the operation type is started, performing a concurrent occupancy check to query the database whether there is already a work report with the same work order, the same material barcode, the operation type started, and no corresponding completion record; if it already exists, rejecting the operation; after the check passes, inserting the work report record and updating the production record status within the same database transaction to obtain an update statement, which includes a status precondition.

4. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step B, locating the current work order and the current process includes: filtering all work orders currently in production on the production line according to the production line number and production status, and sorting them in ascending order by work order start time; looking up the process template and corresponding process of the equipment according to the scanned equipment tag number; taking the work order with the earliest start time, comparing its process template with the template matched by the equipment corresponding to the equipment tag number one by one, and locating the corresponding process of the work order if a match is found.

5. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step B, the start-up operation includes: verifying that the scanned equipment tag number has been registered in the equipment ledger and bound to the corresponding workstation of the current production line; if the current process is the first process, verifying that the scanned raw material barcode belongs to the material details list corresponding to the current work order; implementing optimistic locking concurrency control through status preconditions, allowing start-up only when the production record status is not started; after verification, inserting a start-up type work report record in the same database transaction, and updating the production record status from not started to in progress.

6. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step B, the completion operation includes: if the process mode is a unique code mode, the scanned barcode is compared with the barcode entered when the process started; if they do not match, completion is rejected. If the process mode is a code change mode, the barcode comparison is skipped and the scanned barcode is recorded as a new barcode. The process parameters associated with the process are checked to see if the set values ​​are completely filled in; if there are any missing parameters, completion is rejected. The current status of the production record is checked to be in progress. After the check passes, a completion-type work report is inserted in the same database transaction, and the production record status is updated from in progress to completed.

7. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step C, the slitting and reporting process includes: automatically checking the slitting identifier of the process after the process is completed; if the identifier is correct, automatically triggering the slitting and reporting; receiving the slitting specification list and verifying that the slitting specification list is not empty and that the width and length of each specification are valid values; verifying that the number of slitting specifications does not exceed a preset upper limit; after the verification is passed, adding an exclusive lock to the total number of existing slitting records within the same database transaction, traversing each slitting specification to generate the finished product barcode number according to the barcode generation strategy, and inserting the slitting record and the product coding association record.

8. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1 or 7, characterized in that, In step C, the barcode generation strategy includes a work order generation strategy and a product generation strategy. The work order generation strategy involves: obtaining the current work order number, querying the number of finished product barcodes already generated under that work order, calculating the next serial number, and generating a finished product barcode containing the work order number and the serial number, wherein the serial number length is a preset positive integer. The product generation strategy involves: obtaining the product number and the current date, querying the number of barcodes already generated for that product on the current day, calculating the next serial number, and generating a finished product barcode containing the product number, date, and serial number, wherein the serial number length is a preset positive integer. The concurrency of serial number generation is controlled by database row locks to ensure that the serial number is unique and increments.

9. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step D, the product coding record includes a work order identifier, a cutting record identifier, a raw material barcode, a finished product barcode, finished product size parameters, and a coding status. Database indexes are established for the raw material barcode and the finished product barcode. The encoding rule for the packaging batch barcode is a combination of supplier number, date and time, and sequence number, where the sequence number is a preset positive integer. During the packaging process, when scanning the semi-finished product barcode, it is verified that the semi-finished product barcode exists in the product coding association record and its status is "printed," and it is also verified that the semi-finished product barcode has not been associated with or used by other packaging records.

10. The method for material and finished product barcode association traceability in the production process of the composite current collector line control system according to claim 1, characterized in that, In step E, the reverse traceability includes: if the input is a packaging batch code, sequentially querying packaging records to obtain basic packaging information, querying packaging details to obtain a list of semi-finished product barcodes, querying product coding association records to obtain the raw material barcodes corresponding to each semi-finished product barcode, querying work order material information to obtain basic raw material information, querying work orders and production orders to obtain order and product information, querying production records to obtain information on each process, and querying work order process parameters to obtain the actual values ​​of equipment parameters, assembling layer by layer into a complete traceability chain; if the input is a single finished product barcode, the query starts directly from the product coding association records. The forward traceability includes: receiving raw material barcodes, querying product coding association records to obtain a list of all finished product barcodes derived from the raw material, querying the packaging batch information to which each finished product barcode belongs, and summarizing to obtain all finished product information, cutting specifications and packaging destinations produced by the raw material.

Images