An interactive full-link material management system and method based on transaction driving

Abstract

The application provides a transaction-driven interactive full-link material management system and method, aiming at solving the problems of untraceable material state change and high coupling degree of approval and inventory change in the prior art. The system includes five modules of material management, transaction management, user interaction, approval control and state calculation. The core is to create all user operations as independent and immutable transaction records, and the approval process only updates the transaction state. All real-time inventory, user holdings and state of materials are dynamically calculated by the state calculation module based on the effective transaction. This method realizes complete decoupling of operation and data, ensures strong consistency and complete traceability of data, supports new business scenarios through flexible extension of transaction types, and significantly improves the transparency, accuracy and maintainability of material management.

Description

Technical Field

[0001] This invention relates to the field of materials management technology, and more specifically, to a transaction-driven interactive end-to-end materials management system and method. Background Technology

[0002] In existing technologies, material or inventory management systems generally adopt a tightly coupled management model of "operation-direct update". When users perform operations such as receiving, issuing, and requisitioning, the system directly modifies core fields in the database such as the inventory quantity, status, and holder of the materials. This model has several inherent drawbacks: First, the change of material status is strongly bound to the specific operation process, lacking independent and tamper-proof operation logs. This makes it difficult to trace the root cause of any data anomalies, and it is impossible to effectively restore "when, who, and why" the material status was changed, making auditing and investigation extremely difficult. Second, to achieve process control, some systems have introduced an approval process, but the approval logic is highly coupled with changes to core inventory data. Data modification is triggered the moment approval is granted. This makes it impossible to effectively lock or identify the inventory resources to be operated on in the "suspended state" where approval is not completed, which can easily lead to data conflicts such as "sufficient inventory but actually occupied", undermining system consistency. Furthermore, the existing system suffers from poor scalability. When new business scenarios such as "material transfer" or "temporary allocation" are needed, it often requires in-depth modification and reconstruction of the core inventory calculation and update logic, resulting in high development and maintenance costs and significant risks. Finally, the system is typically administrator-centric, leading to a poor user experience for ordinary users who cannot perceive the progress of their applications and the overall picture of material flow in real time, resulting in insufficient management transparency. Therefore, there is an urgent need for a new material management solution that can decouple the operation process from status changes, ensure data traceability and consistency, and possess good scalability and interactive transparency. Summary of the Invention

[0003] This invention provides a transaction-driven interactive end-to-end material management system, comprising: a material management module for storing static basic information of materials; a transaction management module, communicatively connected to the material management module, for creating and storing transaction records corresponding to material operations; a user interaction module for receiving user operation instructions and triggering the transaction management module to create corresponding transaction records; an approval and access control module for performing access control and transaction approval to update the status of transaction records; and a status calculation module, communicatively connected to the transaction management module, for dynamically calculating and outputting the real-time inventory quantity of materials, the quantity held by users, and the material status based on the transaction status of approved or completed transaction records.

[0004] Compared to existing technologies, this technical solution achieves the following technical benefits: All business operations are abstracted into transaction records containing complete contextual information. This ensures that the trigger, object, quantity, time, and relationships of each material status change are independently and persistently stored, providing an immutable data foundation for end-to-end traceability. Simultaneously, the approval process only affects the transaction status, separated from the core inventory calculation logic, ensuring the stability of the data view during process suspension and eliminating the risk of data inconsistency due to concurrent operations. The status calculation module dynamically aggregates data based on effective transactions, ensuring that all dynamic data presented by the system (such as inventory and holdings) are real-time and accurate calculation results, rather than potentially erroneous static stored values. This achieves a unified approach of high reliability, high auditability, and business process flexibility.

[0005] In one embodiment of the present invention, the status calculation module is configured to perform the following calculations: Total material inventory = Initial inventory + Sum of all inbound adjustment transactions – Sum of all outbound adjustment transactions – Sum of all scrap transactions; Material inventory = Total inventory – Sum of all completed requisition or outbound transactions + Sum of all completed return transactions – Sum of all transactions under maintenance; User-held quantity = Sum of all completed requisition, outbound, or transfer-in transactions with the user as the target user – Sum of all completed return or transfer-out transactions with the user as the initiating user.

[0006] Compared to existing technologies, the technical effects achieved by this solution are significant: by precisely defining the three core calculation formulas executed by the state calculation module, the "transaction-driven" concept is applied to the specific data generation logic level, resulting in substantial technical benefits. These formulas clearly define how to aggregate discrete, atomic transaction records into real-time data indicators with direct management significance, such as total material inventory, quantity in stock, and quantity held by users. This method of generating data views by performing real-time calculations on transaction record sets based on deterministic rules completely replaces the traditional mode of directly reading and writing critical data, thereby eliminating systemic errors caused by human error or program logic defects that directly tamper with core data. More importantly, because the calculation source is limited to transactions with a determined state (approved / completed), the system naturally filters out interference from all intermediate states and ineffective operations. This ensures that even in complex business scenarios with high concurrency and multiple intertwined processes, the system can always provide logically consistent and accurate data states, greatly enhancing the system's robustness and the credibility of decision support.

[0007] In one embodiment of the present invention, the status calculation module further includes: the current status of the material, which is determined based on a comprehensive assessment of the quantity in stock, the quantity under maintenance, and the quantity scrapped.

[0008] Compared to existing technologies, the technical effects of this solution are as follows: the "status" of materials is no longer a simple, isolated label field in the system, but a multi-dimensional, precisely describable view derived in real time from underlying data. The system can automatically identify and simultaneously reflect the possible composite states of materials; for example, a material may be in both "in stock" and "awaiting maintenance" states at the same time. This dynamic determination mechanism avoids the lag, omissions, or contradictions caused by manual status marking, ensuring strict synchronization between status information and the actual physical situation. It provides extremely accurate and rich status information input for inventory visualization, resource scheduling, and early warning, enabling management decisions to be based on more granular and real-time situational awareness, significantly improving the level of management precision and response speed.

[0009] This invention also provides a transaction-driven interactive end-to-end material management method. This method is applied to any of the interactive end-to-end material management systems described above. The interactive end-to-end material management method includes: receiving a material operation instruction initiated by a user through a user interaction module; creating a transaction record corresponding to the operation instruction by a transaction management module, and setting its initial state to pending approval; the transaction record includes at least a transaction ID, transaction type, transaction association ID, target material ID, transaction quantity, initiating user ID, target user ID, transaction status, operation time, and remarks; approving the transaction record by an approval and access control module, and updating its transaction status based on the approval result; in response to the transaction status being updated to approved or completed, recalculating and updating the relevant material inventory quantity, user-held quantity, and material status based on the transaction record by a status calculation module.

[0010] Compared to existing technologies, this technical solution achieves the following technical effects: It provides a standardized and automated "transaction-driven" operation paradigm. This method strictly follows a linear causal chain: "instruction triggers transaction creation, approval updates transaction status, and status change drives recalculation," abstracting complex material management operations into a clear, stable, and controllable information processing pipeline. By stipulating that status recalculation is triggered only when the transaction status changes to "approved" or "completed," this method successfully achieves asynchronous and decoupled business process advancement and core data updates. This not only allows approval and other process control links to be independently configured and expanded without affecting the underlying data, but also significantly improves the system's processing performance and responsiveness in high-concurrency scenarios because the calculation is delayed and triggered in batches. This method ensures that regardless of how business operations are initiated, the final data status change is completed through a unified and reliable mechanism, guaranteeing global data consistency.

[0011] In one embodiment of the present invention, the transaction record created by the transaction management module has fields such as transaction type, target material ID, transaction quantity, initiating user ID, and target user ID that cannot be modified after creation; only the transaction status field can be updated according to the progress of the process.

[0012] Compared to existing technologies, this technical solution achieves the following significant technical effects: By strictly limiting the modifiability of transaction record fields, it establishes the legal and technical authority of transactions as "factual evidence," resulting in profound technical benefits. It stipulates that core factual fields such as transaction type, target material, quantity, and related parties cannot be modified after creation, allowing only status fields to be updated according to the process. This fundamentally guarantees the authenticity and integrity of the operational history. Once any business operation is recorded, its key facts are solidified and cannot be tampered with afterward, making audit clues based on transaction records absolutely credible and effectively meeting compliance and accountability requirements. Simultaneously, allowing status fields to change according to predefined business rules ensures the smooth progress of business processes. This design principle of "fact solidification and status variability" maintains business flexibility while constructing an unbreakable and trustworthy data foundation, and is one of the core mechanisms for achieving high traceability and high security in the system.

[0013] In one embodiment of the present invention, the full-chain management of the entire material lifecycle specifically includes: material creation, application and distribution, transfer, return and maintenance, scrapping and archiving, and full-chain traceability.

[0014] Compared to existing technologies, the technical benefits of this solution are as follows: By incorporating all business operations throughout the entire lifecycle into a unified abstraction of "transactions," the system can break down data barriers between different business stages, achieving seamless end-to-end management and traceability. This enables the system to provide managers with a complete asset view from procurement to final disposal, achieving comprehensive control over the total cost of ownership, utilization efficiency, and lifecycle status of materials.

[0015] In one embodiment of the present invention, material creation further includes: the manager creates the material through the user interaction module, the system automatically generates the initial warehousing transaction, the status calculation module calculates the initial inventory based on the transaction, and the material status is in stock.

[0016] Compared to existing technologies, this technical solution achieves the following advantages: even the initial data creation follows a transaction recording paradigm consistent with other operations, ensuring the integrity of data history from the source. Materials are not statically created out of thin air, but rather "generated" through a transaction with a clearly defined type (ADJUST_IN) and traceable operator (management personnel). This ensures that the initial inventory data of materials also possesses complete traceability information, solving the problem of lacking audit trails in initial data entry in traditional systems. Simultaneously, this process seamlessly integrates with the status calculation module, ensuring that once a material is created, its status (e.g., in stock) is the result of unified calculation logic, maintaining the consistency of the entire system's data generation logic and completing a crucial first link in end-to-end traceability.

[0017] In one embodiment of the present invention, the application and distribution process further includes: a regular user initiating an application, which in turn generates an application transaction; a warehouse manager approving the application transaction, which changes the transaction status to completed; a status calculation module deducting the quantity in stock and increasing the user's holdings; and a warehouse manager actively distributing materials, generating an outbound transaction, which changes the transaction status directly to completed, and simultaneously updating the inventory and holdings.

[0018] Compared to existing technologies, this technical solution achieves the following technical effects: it flexibly and rigorously supports diverse business processes through different transaction types and state transitions. Whether it's an application process requiring approval or a distribution operation directly executed by warehouse staff, it ultimately transforms into a transaction with a defined state, and a unified state calculation module triggers updates to inventory and holdings. This design not only meets the needs for operational convenience and strict control in different scenarios, but more importantly, it ensures that regardless of the path leading to material outbound, the underlying data change mechanism remains unified and reliable. All operations are recorded and tracked equally, avoiding data logic exceptions or vulnerabilities caused by different operation paths, thus enhancing the system's standardization and robustness.

[0019] In one embodiment of the present invention, the transfer also includes: the user holding the material initiates the transfer, the system generates a transfer transaction and associates it with the original requisition transaction ID; the warehouse manager approves the transfer transaction, and then the transaction status changes to completed; the status calculation module deducts the holding quantity of the initiating user and increases the holding quantity of the target user.

[0020] Compared to existing technologies, this technical solution achieves the following technical effects: it can explicitly establish the logical connection before and after the transfer of material usage rights at the transaction level, thus completely depicting the "chain of ownership transfer" at the data level. When user B holds a certain material, the system can not only know from the current transaction that he obtained it from user A, but also trace back to earlier requisition records through the associated ID, forming a clear path of ownership change. This greatly enhances the system's ability to depict and trace complex flow relationships, enabling precise management of scenarios such as "multiple people relaying the use of equipment within a department." Simultaneously, the transfer also follows a unified "transaction creation - approval - calculation update" model, ensuring that such extended business can be seamlessly integrated into the core management framework without requiring special processing logic, demonstrating the system architecture's excellent scalability.

[0021] In one embodiment of the present invention, the return and repair, and scrapping and archiving processes further include: a user initiating a return transaction, which is then generated by the system; after the warehouse manager accepts and approves the return, the transaction status changes to "completed," and the quantity in stock is increased while the user's holdings are decreased; if the material is damaged, the warehouse manager generates a repair transfer transaction; the status calculation module marks the quantity under repair, and after the repair is completed, a repair return transaction is generated, and the quantity in stock is restored; if the material cannot be repaired, a scrapping transaction is generated, and the system deducts the total inventory; when the inventory is 0, the manager generates an archiving transaction, the material is hidden in the regular list, and historical transactions are retained.

[0022] Compared to existing technologies, this technical solution achieves the following technical effects: It precisely manages the material exit process (e.g., return to inventory), anomaly handling process (e.g., repair), and final disposal process (e.g., scrapping and archiving) through a series of ordered transaction chains. In particular, the closed-loop management of the repair cycle through "repair transfer" and "repair return" transactions makes "under repair" a precisely quantifiable and traceable temporary state, rather than a simple note. The "scrap" transaction directly participates in total inventory calculations, ensuring accurate reduction of asset value. The "archiving" operation, while preserving complete historical transactions, performs logical asset cleanup on the front-end interface, satisfying both data retention and a clean interface. These processes collectively demonstrate the system's strong support capability for the complex and compliance-critical business needs at the end of the material lifecycle.

[0023] By adopting the technical solution of the present invention, the following technical effects can be achieved: (1) All business operations are abstracted into transaction records containing complete context information, so that the trigger, object, quantity, time and relationship of each material status change are independently and persistently saved, providing an immutable data foundation for full-chain traceability. At the same time, the approval process only acts on the transaction status and is separated from the core inventory calculation logic, ensuring the stability of the data view during the process suspension period and eliminating the risk of data inconsistency caused by concurrent operations. The status calculation module performs dynamic aggregation based on effective transactions, ensuring that all dynamic data presented by the system (such as inventory and holding quantity) are real-time and accurate calculation result views, rather than static storage values ​​that may be erroneous, thereby achieving a unity of high reliability, high auditability and business process flexibility as a whole; (2) A standardized and automated "transaction-driven" operation paradigm is provided. This method strictly follows a linear causal chain of "instruction triggers transaction creation, approval updates transaction status, and status change drives recalculation," abstracting complex material management business into a clear, stable, and controllable information processing pipeline. By stipulating that status recalculation is only triggered when the transaction status changes to "approved or completed," this method successfully achieves asynchronous and decoupled business process advancement and core data updates. This not only allows process control links such as approval to be configured and expanded independently without affecting the underlying data, but also significantly improves the system's processing performance and responsiveness in high-concurrency scenarios, because the calculation is delayed and triggered in batches. This method ensures that regardless of how the business operation is initiated, the final data status change is completed through a unified and reliable mechanism, guaranteeing the consistency of global data. Attached Figure Description

[0024] To more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings to be used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. Figure 1 A schematic diagram of a transaction-driven interactive end-to-end material management system provided for an embodiment of the present invention; Figure 2 A flowchart illustrating a transaction-driven interactive end-to-end material management method provided in an embodiment of the present invention; Figure 3 A flowchart of the entire material transfer process; Figure 4 A flowchart of the entire process for material return.

[0025] Explanation of reference numerals in the attached figures: 100. Interactive end-to-end material management system; 110. Material management module; 120. Transaction management module; 130. User interaction module; 140. Approval and access control module; 150. Status calculation module. Detailed Implementation

[0026] To make the above-mentioned objectives, features, and advantages of the present invention more apparent and understandable, the technical solutions in the embodiments of the present invention are clearly and completely described. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0027] [First Embodiment] See Figure 1 An interactive end-to-end material management system 100 based on transaction-driven principles includes: a material management module 110 for storing static basic information about materials; a transaction management module 120, which is communicatively connected to the material management module 110 and is used to create and store transaction records corresponding to material operations; a user interaction module 130 for receiving user operation instructions and triggering the transaction management module 120 to create corresponding transaction records; an approval and access control module 140 for performing access control and transaction approval to update the status of transaction records; and a status calculation module 150, which is communicatively connected to the transaction management module 120 and is used to dynamically calculate and output the real-time inventory quantity of materials, the quantity held by users, and the material status based on the transaction status of the transaction records as approved or completed.

[0028] Specifically, the material management module 110 stores basic material information (equipment number, name, category, brand, model, serial number, purchase date, price, storage location, etc.), initial inventory information, and basic status indicators (such as "in stock", "under repair", "scrapped", "archived"), providing basic data support for transaction association; Transaction Management Module 120: As the core module, it records all operation transactions related to materials. Each transaction is an independent and unmodifiable record, containing at least the following fields: Transaction ID: A unique identifier used for transaction tracing and association; Transaction types: These correspond one-to-one with actual operations, including REQUEST, TRANSFER, RETURN, OUTBOUND, TO MAINTENANCE, MAINTENANCE RETURN, TO SCRAP, ADJUST IN / ADJUST OUT, ARCHIVE, etc. Transaction association ID: Used to link related transactions (e.g., a loan transaction is associated with the original borrowing transaction, and a repair transaction is associated with the damage record transaction). Target Material ID: A unique material identifier associated with Material Management module 110; Transaction quantity: The number of materials involved in the operation (positive integer); Initiating User ID: A unique identifier for the user performing the operation; Target User ID: Transaction recipient (e.g., the recipient of a loan, the recipient of a distribution); Transaction status includes PENDING, APPROVED, REJECTED, COMPLETED, and CANCELED. Operation time: Transaction creation time, approval time (if any), completion time (if any); Notes: Operating instructions (e.g., reasons for material damage, basis for inventory adjustments, loan period, etc.); User interaction module 130: Provides a visual operation entry point, supporting ordinary users to initiate operations such as material application, return, transfer, and query of personal materials, supporting warehouse managers to perform operations such as approval, distribution, and inventory adjustment, and supporting managers to perform operations such as material creation / editing, classification management, notification issuance, and archiving. All operations are converted into transaction requests through this module. Approval and Access Control Module 140: Performs access control based on user roles (ordinary users, warehouse staff, and managers), allowing only authorized roles to perform corresponding operations; it is also responsible for the transaction approval process, supporting the configuration of approval nodes according to transaction type (e.g., ordinary applications are approved by warehouse staff, and inventory adjustments are approved by managers), and the approval result directly updates the transaction status; Status Calculation Module 150: Instead of directly storing real-time inventory, quantity in use, and user holdings of materials, it dynamically calculates data based on approved / completed transaction records from the Transaction Management Module 120 using a preset algorithm. The core calculation formula is as follows: Total material inventory = Initial inventory + Σ(ADJUST_IN transaction count) - Σ(ADJUST_OUT transaction count) - Σ(TO_SCRAP transaction count); Material in stock = Total inventory - Σ(REQUEST / OUTBOUND completed transactions) + Σ(RETURN / MAINTENANCE_RETURN completed transactions) - Σ(TO_MAINTENANCE completed transactions); Number of transactions held by a user = Σ (Number of completed REQUEST / OUTBOUND / TRANSFER transactions for the target user) - Σ (Number of completed RETURN / TRANSFER transactions for the initiating user). The current status of materials is determined by a combination of the quantity in stock, the quantity under maintenance (TO_MAINTENANCE unreturned quantity), and the quantity scrapped (if the quantity in stock > 0, it includes the "in stock" status; if the quantity under maintenance > 0, it includes the "under maintenance" status).

[0029] The following is a specific example to illustrate this. Suppose that there is a material called "Laptop A" in the material management module 110, with an initial inventory of 10 units.

[0030] First, when 5 "Laptop A" units enter the system through an inbound adjustment transaction and complete the approval process, the status calculation module 150 will update the total inventory of "Laptop A" to 10 + 5 = 15 units according to the formula "Total Material Inventory = Initial Inventory + Sum of Quantities from All Inbound Adjustment Transactions". Simultaneously, the inventory quantity will also be updated to 15 units accordingly.

[0031] Next, if user Zhang San applies to requisition one "Laptop A", and the requisition transaction is approved and completed, the status calculation module 150 will perform the following updates: According to the formula "Material in Stock = Total Inventory – Sum of Quantities of All Completed Requisition or Issuance Transactions", the in-stock quantity of "Laptop A" will be updated to 15 – 1 = 14 units; at the same time, according to the formula "User Holding Quantity = Sum of Quantities of All Completed Requisition, Issuance, or Transfer Transactions Targeting This User", the holding quantity of user Zhang San will be updated to 1 unit.

[0032] Subsequently, if one "Laptop A" is scrapped due to damage, the scrapping transaction is approved. The status calculation module 150 will update the total inventory to 15 - 1 = 14 units according to the formula "Total Material Inventory = Total Material Inventory - Sum of Quantities of All Scrapped Transaction". At the same time, the number of units in stock will decrease by 1, becoming 13 units.

[0033] Finally, when user Zhang San returns the one "Laptop A" he holds, the return transaction is approved. The status calculation module 150 updates the inventory quantity of "Laptop A" to 13 + 1 = 14 units according to the formula "Material in Stock = Material in Stock + Sum of Quantities of All Completed Return Transactions"; at the same time, according to the formula "User Holding Quantity = User Holding Quantity – Sum of Quantities of All Completed Return or Transfer Transactions Initiated by This User", it updates the holding quantity of user Zhang San to 1 – 1 = 0 units.

[0034] Preferably, all business operations are abstracted into transaction records containing complete contextual information. This ensures that the trigger, object, quantity, time, and relationships of each material status change are independently and persistently stored, providing an immutable data foundation for end-to-end traceability. Simultaneously, the approval process only affects the transaction status, separated from the core inventory calculation logic, ensuring the stability of the data view during process suspension and eliminating the risk of data inconsistency due to concurrent operations. The status calculation module 150 dynamically aggregates data based on effective transactions, ensuring that all dynamic data presented by the system (such as inventory and holdings) are real-time and accurate calculation results, rather than potentially erroneous static stored values. This achieves a unified approach of high reliability, high auditability, and business process flexibility.

[0035] Specifically, the status calculation module 150 is configured to perform the following calculations: Total material inventory = Initial inventory + Sum of all inbound adjustment transactions – Sum of all outbound adjustment transactions – Sum of all scrap transactions; Material on-stock quantity = Total inventory – Sum of all completed requisition or outbound transactions + Sum of all completed return transactions – Sum of all transactions under maintenance; Quantity held by user = Sum of all completed requisition, outbound, or transfer-in transactions with that user as the target user – Sum of all completed return or transfer-out transactions with that user as the initiating user.

[0036] Preferably, by precisely defining the three core calculation formulas executed by the state calculation module 150, the "transaction-driven" concept is applied to the specific data generation logic level, resulting in significant technical effects. These formulas clearly define how to aggregate discrete, atomic transaction records into real-time data indicators with direct management significance, such as total material inventory, quantity in stock, and quantity held by users. This method of generating data views by performing real-time calculations on transaction record sets based on deterministic rules completely replaces the traditional mode of directly reading and writing key data, thereby eliminating systemic errors caused by human error or program logic defects that directly tamper with core data. More importantly, since the calculation source is limited to transactions with a determined state (approved / completed), the system naturally filters out interference from all intermediate states and ineffective operations. This ensures that in complex business scenarios with high concurrency and multiple intertwined processes, the system can always provide logically consistent and accurate data states, greatly enhancing the system's robustness and the credibility of decision support.

[0037] Specifically, the status calculation module 150 also includes: the current status of the material, which is determined based on the quantity in stock, the quantity under maintenance, and the quantity scrapped.

[0038] The preferred approach transforms the "status" of materials from a simple, isolated label field into a multi-dimensional, precisely describable view derived in real-time from underlying data. The system can automatically identify and simultaneously reflect the possible composite states of materials; for example, a material may be simultaneously in "in stock" and "awaiting maintenance." This dynamic determination mechanism avoids the lag, omissions, or contradictions caused by manual status marking, ensuring strict synchronization between status information and the actual physical condition. It provides extremely accurate and rich status information input for inventory visualization, resource scheduling, and early warning, enabling management decisions to be based on more granular and real-time situational awareness, significantly improving the precision and responsiveness of management.

[0039] See Figure 2-4 The present invention also provides a transaction-driven interactive end-to-end material management method, which is applied to the interactive end-to-end material management system as described above. The interactive end-to-end material management method includes: S1: Receive material operation instructions initiated by the user through the user interaction module; S2: The transaction management module creates a transaction record corresponding to the operation instruction and sets its initial status to pending approval. The transaction record includes at least the transaction ID, transaction type, transaction association ID, target material ID, transaction quantity, initiating user ID, target user ID, transaction status, operation time, and remarks. S3: The approval and access control module approves transaction records and updates their transaction status based on the approval results; S4: In response to the transaction status being updated to approved or completed, the status calculation module recalculates and updates the relevant material inventory quantity, user holding quantity, and material status based on the transaction record.

[0040] Specifically, all operations in the system do not directly modify the core material data, but rather indirectly drive state updates through transaction records. The specific logic is as follows: Operation-triggered transaction creation: When a user performs any operation through the interaction module (such as applying for materials), the system does not modify the material inventory or status. Instead, the transaction management module creates the corresponding transaction record and marks the transaction status as "pending approval". Approval only updates the transaction status: When the approval module performs an approval operation, it only modifies the transaction status (approved → approved, rejected → rejected) and does not involve any direct modification of material data; Dynamic calculation takes effect: The status calculation module only includes transactions in the calculation scope when the transaction status is "approved" or "completed", and updates dynamic data such as the quantity of materials in stock, the quantity in use, and the quantity held by users in real time; transactions that are pending approval, rejected, or revoked are not included in the calculation to avoid interfering with inventory. Transactions are immutable: Created transaction records only support status updates and do not allow modification of core fields such as transaction type, quantity, and associated materials, ensuring the accuracy of traceability.

[0041] Specifically, through the above architecture and methods, the system achieves end-to-end management of the entire material lifecycle: Material creation: Managers create materials through the interactive module. The system automatically generates an "Initial Inbound" transaction (transaction type: ADJUST_IN). The status calculation module calculates the initial inventory based on this transaction, and the material status is "In Stock". Application and Distribution: Ordinary users initiate applications → generate "Application Transaction" (PENDING) → warehouse keeper approves (APPROVED) → transaction status changes to COMPLETED → status calculation module deducts the quantity in stock and increases the user's holdings; warehouse keeper actively distributes materials → generates "Outbound Transaction" (OUTBOUND, directly COMPLETED) → synchronizes and updates inventory and holdings; Transfer: The user holding the material initiates the transfer → a "transfer transaction" (PENDING, associated with the original requisition transaction ID) is generated → the warehouse manager approves → the transaction COMPLETED → the status calculation module deducts the holding quantity of the initiating user and increases the holding quantity of the target user; Return and Repair: User initiates return → generates "Return Transaction" (PENDING) → Warehouse clerk accepts and approves → COMPLETED → increases inventory quantity and deducts user holding quantity; If material is damaged → Warehouse clerk generates "Repair Transfer Transaction" (TO_MAINTENANCE) → Status calculation module marks the quantity under repair → After repair is completed, generates "Repair Return Transaction" (MAINTENANCE_RETURN) → restores inventory quantity; Scrap and Archiving: If a material cannot be repaired, a "Scrap Transaction" (TO_SCRAP) is generated, which reduces the total inventory. When the inventory is 0, the administrator generates an "Archive Transaction" (ARCHIVE), which hides the material in the regular list, while the historical transaction is retained. End-to-end traceability: By using the transaction ID or material ID, you can query all transaction records of the material from creation to archiving, and fully restore the operator, time, reason, quantity and other information of each status change.

[0042] Specifically, all the codes are automatically generated instruction codes used to refer to operations or names, and have no special meaning.

[0043] Specifically, taking "Material Transfer" in the MiMs system as an example, the complete process is as follows: Ordinary user A logs into the system, finds that they hold material X (2 units) through "My Materials", initiates a transfer application, selects to transfer to user B, transfers 1 unit, and fills in the remarks "Temporary loan for project for 1 month". The transaction is transferred to the transaction management module, and a transaction record is created: Transaction ID=T001, Transaction Type=TRANSFER, Target Material ID=MAT001 (Material X), Transaction Quantity=1, Initiating User ID=USER001 (User A), Target User ID=USER002 (User B), Transaction Status=PENDING, Operation Time=2026-01-06 10:30:00, Remarks=“Temporary borrowing for 1 month”; The approval and access control module identifies the transaction as a "transfer" type and automatically assigns it to user B's approval queue; User B logs into the system, views the details of transaction T001 in "Pending Approval Transactions", verifies the actual holding quantity of User A (the status calculation module calculates in real time: holding quantity = 2, operable quantity = 2, no other pending approval transactions occupying the quantity), and clicks "Approve" after confirming that the conditions are met. The transaction status is then updated to APPROVED. The transaction management module synchronizes the APPROVED status to the status calculation module. The status calculation module performs the calculation: User A's holding quantity = 2 - 1 = 1, User B's holding quantity = 0 + 1 = 1, and the quantity of material X in stock remains unchanged. The system automatically sends notifications to User A and User B, informing them that the transfer approval has been granted. Users can view the updated holding quantity through "My Materials". If User B subsequently returns material X, the above process repeats: create a RETURN type transaction → warehouse manager approval → status calculation module deducts User B's holding quantity and increases the quantity in stock, forming a complete closed loop.

[0044] Preferably, a standardized and automated "transaction-driven" operation paradigm is provided. This method strictly follows a linear causal chain of "instruction triggers transaction creation, approval updates transaction status, and status change drives recalculation," abstracting complex material management operations into a clear, stable, and controllable information processing pipeline. By stipulating that status recalculation is triggered only when the transaction status changes to "approved or completed," this method successfully achieves asynchronous and decoupled operation between business process advancement and core data updates. This not only allows process control links such as approval to be independently configured and expanded without affecting the underlying data, but also significantly improves the system's processing performance and responsiveness in high-concurrency scenarios, because the calculation is delayed and triggered in batches. This method ensures that regardless of how business operations are initiated, the final data status change is completed through a unified and reliable mechanism, guaranteeing the consistency of global data.

[0045] Specifically, the transaction type, target material ID, transaction quantity, initiating user ID, and target user ID fields of the transaction records created by the transaction management module cannot be modified after creation; only the transaction status field can be updated according to the progress of the process.

[0046] Preferably, by strictly limiting the modifiability of transaction record fields, the legal and technical authority of transactions as "proof of facts" is established, resulting in profound technical effects. Stipulating that core fact fields such as transaction type, target material, quantity, and related parties cannot be modified after creation, and only status fields are allowed to be updated according to the process, fundamentally guarantees the authenticity and integrity of the operational history. Once any business operation is recorded, its key facts are solidified and cannot be tampered with afterward, making audit clues based on transaction records absolutely credible and effectively meeting compliance and accountability requirements. At the same time, allowing status fields to change according to predefined business rules ensures the smooth progress of business processes. This design principle of "solidified facts, variable status" maintains business flexibility while constructing an unbreakable and trustworthy data foundation, and is one of the core mechanisms for the system to achieve high traceability and high security.

[0047] Specifically, the full-chain management of the entire material lifecycle includes: material creation, application and distribution, lending, return and maintenance, scrapping and archiving, and full-chain traceability.

[0048] Preferably, by incorporating all business operations throughout the entire lifecycle into a unified abstraction of "transactions," the system can break down data barriers between different business stages, achieving seamless end-to-end management and traceability. This enables the system to provide managers with a complete asset view from the source of procurement to final disposal, achieving comprehensive control over the total cost of ownership, utilization efficiency, and lifecycle status of materials.

[0049] Specifically, material creation also includes: managers creating materials through the user interaction module, the system automatically generating an initial inbound transaction, the status calculation module calculating the initial inventory based on the transaction, and the material status being in stock.

[0050] Preferably, even the creation of initial system data follows a transaction recording paradigm completely consistent with other operations, ensuring the integrity of data history from the source. Materials are not statically created out of thin air, but rather "generated" through a transaction with a clearly defined type (ADJUST_IN) and traceable operator (management personnel). This ensures that the initial inventory data of materials also possesses complete traceability information, solving the problem of lacking audit trails in initial data entry in traditional systems. Simultaneously, this process seamlessly integrates with the status calculation module, ensuring that once a material is created, its status (e.g., in stock) is the result of a unified calculation logic, maintaining the consistency of the entire system's data generation logic and completing a crucial first link in end-to-end traceability.

[0051] Specifically, the application and distribution process includes: ordinary users initiating applications, which in turn generate application transactions; warehouse managers approving application transactions, and the transaction status changing to completed; the status calculation module deducting the quantity in stock and increasing the user's holdings; and warehouse managers actively distributing materials, generating outbound transactions, and the transaction status directly changing to completed, while simultaneously updating inventory and holdings.

[0052] Preferably, diverse business processes are flexibly and rigorously supported through different transaction types and state transitions. Whether it's an application process requiring approval or a distribution operation directly executed by warehouse staff, it ultimately transforms into a transaction with a defined state, and an integrated state calculation module triggers updates to inventory and holdings. This design not only meets the needs for operational convenience and strict control in different scenarios, but more importantly, it ensures that regardless of the path leading to material outbound, the underlying data change mechanism remains consistent and reliable. All operations are recorded and tracked equally, avoiding data logic exceptions or vulnerabilities caused by different operation paths, thus enhancing the system's standardization and robustness.

[0053] Specifically, the transfer process also includes: the user holding the material initiates the transfer, the system generates a transfer transaction and associates it with the original requisition transaction ID; the warehouse manager approves the transfer transaction, and then the transaction status changes to completed; the status calculation module deducts the holding quantity of the initiating user and increases the holding quantity of the target user.

[0054] Preferably, the system can explicitly establish the logical connection between the transfer of material usage rights at the transaction level, thus fully depicting the "chain of ownership transfer" at the data level. When user B holds a certain material, the system can not only know from the current transaction that he obtained it from user A, but also trace back to earlier usage records through the associated ID, forming a clear path of ownership change. This greatly enhances the system's ability to depict and trace complex flow relationships, enabling precise management of scenarios such as "multiple people relaying the use of equipment within a department." At the same time, the transfer also follows the unified model of "creating a transaction - approval - calculation and update," ensuring that such extended business can be seamlessly integrated into the core management framework without special processing logic, demonstrating the excellent scalability of the system architecture.

[0055] Specifically, the return and repair, and scrapping and archiving processes include: when a user initiates a return transaction, the system generates a return transaction; after the warehouse manager accepts and approves the return, the transaction status changes to "completed," and the quantity in stock is increased while the user's holdings are decreased; if the material is damaged, the warehouse manager generates a repair transfer transaction; the status calculation module marks the quantity under repair, and after the repair is completed, a repair return transaction is generated, and the quantity in stock is restored; if the material cannot be repaired, a scrapping transaction is generated, and the system deducts the total inventory; when the inventory is 0, the administrator generates an archiving transaction, the material is hidden in the regular list, and historical transactions are retained.

[0056] Preferably, a series of ordered transaction chains are used to precisely manage the material exit process (such as return to inventory), exception handling process (such as repair), and final disposal process (such as scrapping and archiving). In particular, the "repair transfer" and "repair return" transactions enable closed-loop management of the repair cycle, making "under repair" a precisely quantifiable and traceable temporary state, rather than a simple note. The "scrap" transaction directly participates in the total inventory calculation, ensuring accurate reduction of asset value. The "archiving" operation, while preserving complete historical transactions, performs logical asset cleanup on the front-end interface, meeting the dual requirements of data retention and interface simplicity. These processes collectively demonstrate the system's strong support capability for the complex and compliance-critical business needs at the end of the material lifecycle.

[0057] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A transaction-driven, interactive, end-to-end material management system, characterized in that, include: The material management module is used to store static basic information about materials. A transaction management module, which is communicatively connected to the material management module, is used to create and store transaction records corresponding to material operations; The user interaction module is used to receive user operation instructions and trigger the transaction management module to create corresponding transaction records. An approval and access control module is used to perform access verification and transaction approval in order to update the status of transaction records. The status calculation module is communicatively connected to the transaction management module and is used to dynamically calculate and output the real-time inventory quantity, user holding quantity, and material status of materials based on transaction records whose transaction status is approved or completed.

2. The transaction-driven interactive end-to-end material management system according to claim 1, characterized in that, The state calculation module is configured to perform the following calculations: Total material inventory = Initial inventory + Sum of quantities from all inbound adjustment transactions – Sum of quantities from all outbound adjustment transactions – Sum of quantities from all scrap transactions; Material inventory quantity = Total inventory – Sum of all completed requisition or issuance transactions + Sum of all completed return transactions – Sum of all ongoing maintenance transactions; User holdings = Sum of all completed transactions involving the user as the target user (requisition, outbound, or transfer-in) – Sum of all completed transactions involving the user as the initiating user (return or transfer-out).

3. The transaction-driven interactive end-to-end material management system according to claim 2, characterized in that, The state calculation module also includes: The current status of the materials is determined based on a comprehensive assessment of the quantity in stock, the quantity under maintenance, and the quantity scrapped.

4. A transaction-driven interactive end-to-end material management method, wherein the interactive end-to-end material management method is applied to the interactive end-to-end material management system as described in any one of claims 1-3, characterized in that, The interactive end-to-end material management method includes: Receive material handling instructions initiated by the user through the user interaction module; The transaction management module creates a transaction record corresponding to the operation instruction and sets its initial status to pending approval. The transaction record includes at least the transaction ID, transaction type, transaction association ID, target material ID, transaction quantity, initiating user ID, target user ID, transaction status, operation time, and remarks. The approval and access control module approves the transaction records and updates their transaction status based on the approval results. In response to a transaction status being updated to approved or completed, the status calculation module recalculates and updates the relevant material inventory quantity, user holding quantity, and material status based on the transaction record.

5. The transaction-driven interactive end-to-end material management method according to claim 4, characterized in that, The transaction records created by the transaction management module cannot be modified after creation, including the transaction type, target material ID, transaction quantity, initiating user ID, and target user ID fields. Only the transaction status field can be updated according to the progress of the process.

6. The transaction-driven interactive end-to-end material management method according to claim 4, characterized in that, Also includes: The full-chain management of the entire material lifecycle includes: material creation, application and distribution, lending, return and maintenance, scrapping and archiving, and full-chain traceability.

7. The transaction-driven interactive end-to-end material management method according to claim 6, characterized in that, The material creation also includes: Managers create materials through the user interaction module, and the system automatically generates an initial inbound transaction. The status calculation module calculates the initial inventory based on this transaction, and the material status is in stock.

8. The transaction-driven interactive end-to-end material management method according to claim 6, characterized in that, The application and distribution also include: A regular user initiates an application, which in turn generates an application transaction in the system; The warehouse clerk approves the application, and the transaction status changes to "completed". The status calculation module deducts the quantity in the inventory and increases the user's holdings. The warehouse keeper proactively distributes materials, generating outbound transactions, and the transaction status immediately changes to completed, while simultaneously updating inventory and holdings.

9. The transaction-driven interactive end-to-end material management method according to claim 6, characterized in that, The lending also includes: When a user holding materials initiates a loan, the system generates a loan transaction and associates it with the original requisition transaction ID. The warehouse clerk approves the aforementioned transfer transaction, and the transaction status changes to "completed". The status calculation module deducts the holdings of the initiating user and increases the holdings of the target user.

10. The transaction-driven interactive end-to-end material management method according to claim 6, characterized in that, The return and repair and the scrapping and archiving also include: The user initiates a return transaction, and the system generates a return transaction. After the warehouse clerk accepts and approves the transaction, the transaction status changes to "completed," and the quantity in stock is increased while the user's holdings are decreased. If materials are damaged, the warehouse keeper generates a repair transfer transaction. The status calculation module marks the quantity under maintenance, generates a maintenance return transaction after maintenance is completed, and restores the quantity in the inventory; If a material cannot be repaired, a scrap transaction is generated, and the system deducts the total inventory. When the inventory is 0, the administrator generates an archived transaction, the material is hidden in the regular list, and the historical transaction is retained.

Images