Mechanism material distribution real-time collaboration and traceability system based on unified data platform

Abstract

The invention, which relates to the technical field of mechanism material distribution, discloses a mechanism material distribution real-time collaboration and traceability system based on a unified data platform, comprising a data specification module, a dynamic routing module, a traceability code generation module, a storage verification module, a nutrition calculation module, a report generation module and an abnormal response module. The data specification module adopts a unified JSON Schema to define data specifications of a supplier end production batch number and a quality inspection report, a distribution end warehouse temperature and humidity and a vehicle GPS, and a school end acceptance image and student feedback; the dynamic routing module is used for realizing state change and pushing to the three-party system in real time through a dynamic routing engine based on the output of the data specification module; the traceability code generation module is used for generating a four-segment traceability code according to the structured data of the data specification module and storing a key data hash value of each link; and the evidence storage verification module is based on the output of the traceability code generation module.

Description

Technical Field

[0001] This invention relates to the field of institutional material distribution technology, and in particular to a real-time collaborative and traceable system for institutional material distribution based on a unified data platform. Background Technology

[0002] Institutional material distribution technology mainly refers to the technological system for the procurement, storage, transportation, and distribution of materials for a specific organization or institution. It involves multiple stages, including supplier management, warehouse management, logistics and distribution, quality control, food safety monitoring, and end-user acceptance feedback. Therefore, how to utilize advanced technologies to improve the intelligence and security of institutional material distribution has become one of the most pressing issues to be addressed.

[0003] In the field of institutional supplies distribution, in traditional supplies distribution systems, different participants use their own independent data formats and management systems, which makes it difficult to communicate information and creates information silos. In addition, institutions such as schools and hospitals need to develop menus based on the nutritional needs of students or patients, but existing systems lack automated tools to accurately calculate the required amount of raw materials and match alternative ingredients. Summary of the Invention

[0004] In view of the aforementioned existing problems, the present invention is proposed.

[0005] Therefore, this invention provides a real-time collaborative and traceable system for institutional material distribution based on a unified data platform. This solves the problem that in traditional material distribution systems, different participants use their own independent data formats and management systems, which makes it difficult to communicate information and creates information silos. Furthermore, schools, hospitals, and other institutions need to develop menus based on the nutritional needs of students or patients, but existing systems lack automated tools to accurately calculate the required quantities of raw materials and match alternative ingredients.

[0006] To solve the above-mentioned technical problems, the present invention provides the following technical solution:

[0007] In a first aspect, the present invention provides a real-time collaborative and traceable system for institutional material distribution based on a unified data platform, comprising:

[0008] The module includes a data standardization module, a dynamic routing module, a traceability code generation module, an evidence verification module, a nutrition calculation module, a report generation module, and an anomaly response module.

[0009] The data specification module uses a unified JSON Schema to define data specifications for supplier-side production batch numbers and quality inspection reports, delivery-side warehouse temperature and humidity and vehicle GPS, and school-side acceptance images and student feedback.

[0010] The dynamic routing module, based on the output of the data specification module, uses a dynamic routing engine to push state changes to the third-party system in real time.

[0011] The traceability code generation module generates a four-segment traceability code based on the structured data from the data specification module, and stores the hash values ​​of key data from each stage.

[0012] The evidence storage and verification module, based on the output of the traceability code generation module, uses a centralized database and timestamp service to centrally store the hash values ​​of data from each stage, and provides a third-party verifiable interface.

[0013] The nutrition calculation module automatically calculates the amount of raw materials to be purchased based on the school's weekly menu requirements and calls the nutrition standard rule library. If the inventory is insufficient, it matches substitute ingredients according to the protein content ratio.

[0014] The report generation module automatically generates a traceability report containing digital signatures and filing codes based on the data from the evidence verification module and in accordance with regional regulatory standards.

[0015] The anomaly response module monitors the delivery temperature and humidity and vehicle GPS data in real time. When an anomaly is triggered, it sends an alarm to the third-party system through the dynamic routing module and generates an emergency plan.

[0016] As a preferred embodiment of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in this invention, the specific steps for defining data specifications using a unified JSON Schema for supplier-side production batch numbers and quality inspection reports, distribution-side warehouse temperature and humidity and vehicle GPS, and school-side acceptance images and student feedback are as follows:

[0017] A unified JSON Schema is used to define the data fields for supplier-side production batch numbers and quality inspection reports, including:

[0018] Define a production batch number field to record the unique identifier of the product batch;

[0019] Define a production date field to record the product's production time;

[0020] Define a quality inspection report number field to record the unique identifier of the quality inspection report;

[0021] Define a quality inspection result field to record the specific results of the quality inspection;

[0022] A unified JSON Schema is used to define the data fields for temperature and humidity in the delivery warehouse and vehicle GPS data, including:

[0023] Define a warehouse temperature field to record the temperature values ​​inside the warehouse;

[0024] Define a warehouse humidity field to record the humidity value inside the warehouse;

[0025] Define a vehicle GPS coordinate field to record the geographical location information of the transport vehicle;

[0026] A unified JSON Schema is used to define the data fields for school-side acceptance images and student feedback, including:

[0027] Define an acceptance image field to record photos or videos taken during the acceptance process;

[0028] Define an acceptance time field to record the specific time of acceptance;

[0029] Define a student feedback rating field to record students' satisfaction ratings for the supplies;

[0030] Format the production batch number, production date, quality inspection report number, quality inspection results, and other data according to the predefined template;

[0031] Format data such as warehouse temperature, warehouse humidity, and vehicle GPS coordinates according to a predefined template;

[0032] The data, such as acceptance images, acceptance time, and student feedback scores, are formatted according to a predefined template.

[0033] The converted data is validated using a unified JSON Schema to ensure that all data fields conform to the predefined standard format.

[0034] As a preferred embodiment of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in this invention, the following steps are taken: Based on the output of the data standardization module, the dynamic routing engine is used to push status changes to the third-party system in real time.

[0035] Extract the business stage identifier of the current material from the standardized fields output by the data specification module, and combine it with the timestamp field to determine whether the current status is the latest changed status. If a status change is detected, mark the change information as an event to be pushed.

[0036] Read the predefined state-system mapping table, where each state corresponds to one or more target recipients. Match the corresponding push strategy according to the type of organization to which the current material belongs. If the strategy contains a conditional expression, evaluate whether it meets the push conditions.

[0037] The status change information is combined with relevant business data into a structured message body, a digital signature field is added to ensure the authenticity of the message source, and a version control identifier is added.

[0038] Based on the output list of target addresses, select the transmission protocol, initiate an asynchronous communication request, send a status change message, and record the response status code and return time for each push.

[0039] If a push fails, the message is added to the retry queue and a maximum number of attempts is set. If the recipient returns an explicit error code indicating verification failure or refusal to receive, an alarm notification is generated and automatic retry is paused. All push records are written to the log database for auditing by the monitoring system.

[0040] As a preferred embodiment of the real-time collaborative and traceability system for institutional material distribution based on a unified data platform as described in this invention, the specific steps for generating a four-segment traceability code based on the structured data from the data standardization module and storing the hash values ​​of key data at each stage are as follows:

[0041] The traceability code generation module receives structured data output from the data specification module, including supplier ID, production date, and batch number information.

[0042] The traceability code generation module uses the supplier ID field output by the data specification module as the first part of the traceability code;

[0043] The traceability code generation module uses the production date field output by the data specification module as the second part of the traceability code.

[0044] The traceability code generation module uses the batch number field output by the data specification module as the third part of the traceability code;

[0045] Calculate the check digit to ensure the integrity and accuracy of the traceability code;

[0046] The supplier ID, production date, and batch number are concatenated to form a basic string;

[0047] The base string is processed using a predefined verification algorithm to generate a verification code;

[0048] The verification code serves as the fourth part of the traceability code, ensuring the overall integrity of the traceability code.

[0049] Generate a complete four-segment traceability code and associate it with relevant business data for storage;

[0050] The traceability code generation module combines the supplier ID, production date, batch number, and check code into a complete four-segment traceability code according to a predefined format.

[0051] The traceability code generation module associates and stores the traceability code with the corresponding business data;

[0052] Store the hash values ​​of key data from each stage to ensure that the data cannot be tampered with;

[0053] While generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools.

[0054] The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values.

[0055] As a preferred embodiment of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in this invention, the evidence verification module includes:

[0056] Based on the output of the traceability code generation module, a centralized database and timestamp service are used to centrally store the hash values ​​of data from each stage, and a third-party verifiable interface is provided.

[0057] While generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools.

[0058] The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values;

[0059] The hash value, traceability code, and timestamp are stored together in the relational database of the unified data platform, and an open API is provided to verify data integrity.

[0060] The system submits key hash values ​​to a trusted timestamp service provider daily to obtain timestamp credentials, ensuring that the data is tamper-proof and has legal validity.

[0061] As a preferred embodiment of the institutional material distribution real-time collaboration and traceability system based on a unified data platform described in this invention, the following steps are taken: Based on the school's weekly menu requirements, the system automatically calculates the raw material procurement quantity by calling the nutritional standard rule library; if the inventory is insufficient, it matches substitute ingredients according to the protein content ratio.

[0062] Read the weekly menu file uploaded by the school, identify the names of the dishes included in the three meals a day, search for the corresponding ingredients and their single serving amount in the preset recipe database according to the dish name, summarize the ingredients of all dishes, form a total demand table by ingredient type, and record the average daily usage and weekly total of each ingredient.

[0063] Obtain the current total number of students in the school, the number of meal days, and the target average daily nutritional intake standard per student;

[0064] For each raw material, retrieve its nutrient content per unit mass from the nutrient database;

[0065] Based on the target total intake T and the nutritional contribution per unit of raw material N i Calculate the minimum theoretical purchase quantity Q of the raw material. i The expression is:

[0066]

[0067] The system retrieves inventory data from the warehouse management system, compares the actual inventory with the calculated purchase quantity, and determines whether the demand is met.

[0068] For each raw material, determine whether S is satisfied. i ≥Q i

[0069] If the condition is met, no procurement is required; otherwise, proceed to the next step of the alternative processing procedure.

[0070] Identify the type A of raw material that needs to be supplemented and obtain its protein content per unit mass;

[0071] Select a set of candidate ingredients C from the alternative ingredient library that are similar to food A and whose protein content difference does not exceed a set threshold;

[0072] In the candidate set C, the ingredients are further sorted according to price, supply stability and historical purchasing preferences, and the ingredient B with the highest priority is selected as the alternative.

[0073] Based on the protein content ratio of raw material A to substitute ingredient B, calculate the required quantity of substitute ingredients to purchase, as shown in the expression:

[0074]

[0075] Among them, Q A P represents the theoretical purchase quantity of raw material A. A P represents the protein content per unit mass of raw material A. B The protein content per unit mass of food ingredient B.

[0076] As a preferred embodiment of the real-time collaborative and traceability system for institutional material distribution based on a unified data platform as described in this invention, the following steps are taken: Based on the data from the evidence verification module, a traceability report containing digital signatures and registration codes is automatically generated according to regional regulatory standards.

[0077] Match the corresponding source tracing report template according to the administrative region to which the school belongs, and read the field definition rules in the template, including title format, body paragraphs, key data display methods and the location for filling in the supervision number;

[0078] Load template style resources, including fonts, colors, and headers and footers, for subsequent report rendering;

[0079] The traceability code allows for the identification of the complete lifecycle record of this batch of materials within the unified data platform;

[0080] Extract key data from each stage, including:

[0081] Supplier side: Production batch number, quality inspection report number, and quality inspection results;

[0082] Delivery end: Warehouse temperature and humidity records, vehicle GPS tracks, and transportation time;

[0083] School side: Acceptance video, student feedback scores, and signature information;

[0084] The extracted key data is filled into the report structure according to the template field definitions to form a complete traceability content framework;

[0085] Call the digital certificate management system to obtain the current system's valid signature private key;

[0086] A secure encryption algorithm is used to calculate the digest of the populated report content. The expression is as follows:

[0087] D = SHA256 (report content);

[0088] Where D is the summary value of the report content;

[0089] The digest value D is encrypted using the private key to generate the digital signature value S, expressed as:

[0090] S = Sign(D, private key);

[0091] Embed the digital signature value S at the end of the report and attach the public key certificate information for third-party verification;

[0092] Retrieve the current administrative division code, school ID, and report generation timestamp;

[0093] The above information is combined to generate a filing code, including:

[0094] Encoding = Region Code + School ID + Timestamp;

[0095] Embed the filing code in the report header and upload it simultaneously to the regional regulatory platform interface to complete the filing registration;

[0096] The generated traceability report is formatted and packaged before being sent to relevant parties.

[0097] As a preferred embodiment of the real-time collaborative and traceable organizational material distribution system based on a unified data platform described in this invention, the following steps are taken: Real-time monitoring of distribution temperature and humidity and vehicle GPS data, triggering anomalies, synchronously sending alarms to third-party systems via a dynamic routing module, and generating emergency plans.

[0098] IoT sensors are used to collect environmental temperature and humidity and GPS location information of transport vehicles in real time during the delivery process, and the raw data is transmitted to a unified data platform.

[0099] Based on preset temperature and humidity threshold ranges and transportation route planning, the collected data is compared and analyzed in real time to identify any abnormal conditions and determine whether the following conditions are met:

[0100] T min ≤T i ≤T max ;

[0101] H min ≤H i ≤H max ;

[0102] Among them, T i For the collected temperature value, H i The collected humidity value;

[0103] If the conditions are not met, it will be marked as an abnormal temperature and humidity.

[0104] By combining historical transportation routes and estimated arrival times, it is determined whether the current GPS location deviates from the planned route or poses a risk of delay. If the route is determined to be abnormal, the next alarm process is initiated.

[0105] Generate a corresponding alarm level identifier based on the anomaly type, and invoke the state-system mapping rules configured in the dynamic routing module;

[0106] Construct a structured alarm message containing the anomaly type, occurrence time, device number, and current value;

[0107] Alarm messages are sent asynchronously to each target system via an HTTPS protocol interface.

[0108] In a second aspect, the present invention provides a computer device, including a memory and a processor, wherein the memory stores a computer program, wherein: when the computer program is executed by the processor, it implements any step of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in the first aspect of the present invention.

[0109] Thirdly, the present invention provides a computer-readable storage medium having a computer program stored thereon, wherein: when the computer program is executed by a processor, it implements any step of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in the first aspect of the present invention.

[0110] The beneficial effects of this invention are as follows: By defining data fields for each stage using a unified JSON Schema, data interoperability between different participants is achieved; by extracting status identifiers and timestamps from standardized data, accurate identification of status changes is achieved; by using preset status-system mapping rules and condition judgment mechanisms, intelligent routing selection is achieved, improving the targeting of push notifications; by using digital signatures and version control, the security and compatibility of message transmission are enhanced; by using a four-segment coding design, the uniqueness and readability of material identification are achieved, facilitating rapid identification by humans or systems; by concatenating basic strings and generating verification codes, the integrity and tamper-proof capability of traceability codes are improved, providing authoritative and reliable data sources for regulatory agencies and the public. Attached Figure Description

[0111] To more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the following description of the embodiments will be briefly introduced. 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.

[0112] Figure 1 This is a schematic diagram of the real-time collaboration and traceability system for institutional material distribution based on a unified data platform in Example 1. Detailed Implementation

[0113] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, the specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

[0114] Many specific details are set forth in the following description in order to provide a full understanding of the invention. However, the invention may also be practiced in other ways different from those described herein, and those skilled in the art can make similar extensions without departing from the spirit of the invention. Therefore, the invention is not limited to the specific embodiments disclosed below.

[0115] Secondly, the term "one embodiment" or "embodiment" as used herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The phrase "in one embodiment" appearing in different places in this specification does not necessarily refer to the same embodiment, nor is it a single or selective embodiment that is mutually exclusive with other embodiments.

[0116] Example 1, referring to Figure 1 This is the first embodiment of the present invention, which provides a real-time collaborative and traceable system for organizational material distribution based on a unified data platform, including:

[0117] The module includes a data standardization module, a dynamic routing module, a traceability code generation module, an evidence verification module, a nutrition calculation module, a report generation module, and an anomaly response module.

[0118] The data specification module uses a unified JSON Schema to define data specifications for supplier-side production batch numbers and quality inspection reports, delivery-side warehouse temperature and humidity and vehicle GPS, and school-side acceptance images and student feedback.

[0119] Furthermore, a unified JSON Schema is used to define the data fields for supplier-side production batch numbers and quality inspection reports, including:

[0120] Define a production batch number field to record the unique identifier of the product batch;

[0121] Define a production date field to record the product's production time;

[0122] Define a quality inspection report number field to record the unique identifier of the quality inspection report;

[0123] Define a quality inspection result field to record the specific results of the quality inspection;

[0124] A unified JSON Schema is used to define the data fields for temperature and humidity in the delivery warehouse and vehicle GPS data, including:

[0125] Define a warehouse temperature field to record the temperature values ​​inside the warehouse;

[0126] Define a warehouse humidity field to record the humidity value inside the warehouse;

[0127] Define a vehicle GPS coordinate field to record the geographical location information of the transport vehicle;

[0128] A unified JSON Schema is used to define the data fields for school-side acceptance images and student feedback, including:

[0129] Define an acceptance image field to record photos or videos taken during the acceptance process;

[0130] Define an acceptance time field to record the specific time of acceptance;

[0131] Define a student feedback rating field to record students' satisfaction ratings for the supplies;

[0132] Format the production batch number, production date, quality inspection report number, quality inspection results, and other data according to the predefined template;

[0133] Format data such as warehouse temperature, warehouse humidity, and vehicle GPS coordinates according to a predefined template;

[0134] The data, such as acceptance images, acceptance time, and student feedback scores, are formatted according to a predefined template.

[0135] The converted data is validated using a unified JSON Schema to ensure that all data fields conform to the predefined standard format;

[0136] It should be noted that the unified JSON Schema used in this embodiment is not limited to the listed fields, and other fields can be extended according to actual business needs; at the same time, it supports a multi-version schema coexistence mechanism to be compatible with the data format differences of different participants, ensuring that the system still has good compatibility and scalability in heterogeneous data environments.

[0137] The dynamic routing module, based on the output of the data specification module, uses a dynamic routing engine to push state changes to third-party systems in real time.

[0138] Furthermore, the business stage identifier of the current material is extracted from the standardized fields output by the data specification module, and the timestamp field is used to determine whether the current status is the latest changed status. If a status change is detected, the change information is marked as an event to be pushed.

[0139] Read the predefined state-system mapping table, where each state corresponds to one or more target recipients. Match the corresponding push strategy according to the type of organization to which the current material belongs. If the strategy contains a conditional expression, evaluate whether it meets the push conditions.

[0140] The status change information is combined with relevant business data into a structured message body, a digital signature field is added to ensure the authenticity of the message source, and a version control identifier is added.

[0141] Based on the output list of target addresses, select the transmission protocol, initiate an asynchronous communication request, send a status change message, and record the response status code and return time for each push.

[0142] If the push fails, the message is added to the retry queue and the maximum number of attempts is set. If the receiver returns an explicit error code indicating verification failure or refusal to receive, an alarm notification is generated and automatic retry is paused. All push records are written to the log database for auditing by the monitoring system.

[0143] It should be noted that the dynamic routing engine supports automatic adaptation to multiple communication protocols and can dynamically adjust the message sending frequency and concurrency based on the processing capacity of the receiving system. In addition, the alarm retry policy and log recording mechanism jointly ensure the high availability and auditability of information push.

[0144] The traceability code generation module generates a four-segment traceability code based on the structured data from the data specification module and stores the hash values ​​of key data from each stage.

[0145] Furthermore, the traceability code generation module receives structured data output by the data specification module, including supplier ID, production date, and batch number information.

[0146] The traceability code generation module uses the supplier ID field output by the data specification module as the first part of the traceability code;

[0147] The traceability code generation module uses the production date field output by the data specification module as the second part of the traceability code.

[0148] The traceability code generation module uses the batch number field output by the data specification module as the third part of the traceability code;

[0149] Calculate the check digit to ensure the integrity and accuracy of the traceability code;

[0150] The supplier ID, production date, and batch number are concatenated to form a basic string;

[0151] The base string is processed using a predefined verification algorithm to generate a verification code;

[0152] The check digit, as the fourth part of the traceability code, ensures the overall integrity of the traceability code.

[0153] Generate a complete four-segment traceability code and associate it with relevant business data for storage;

[0154] The traceability code generation module combines the supplier ID, production date, batch number, and check code into a complete four-segment traceability code according to a predefined format;

[0155] The traceability code generation module associates and stores the traceability code with the corresponding business data;

[0156] Store the hash values ​​of key data from each stage to ensure that the data cannot be tampered with;

[0157] While generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools.

[0158] The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values;

[0159] It should be noted that by using a structured traceability code composed of four parts—supplier ID, production date, batch number, and check code—and combining it with a predefined verification algorithm to process the basic string to generate the check code, the integrity and accuracy of the traceability code during data transmission and system interaction can be effectively ensured. This design not only improves the uniqueness and identifiability of the traceability code but also automatically detects errors during reading or input, avoiding data deviations caused by manual input or communication interference. This provides a guarantee for data consistency in subsequent stages and improves the traceability efficiency and reliability of the entire material distribution system.

[0160] The evidence storage and verification module, based on the output of the traceability code generation module, uses a centralized database and timestamp service to centrally store the hash values ​​of data from each stage, and provides a third-party verifiable interface;

[0161] Furthermore, while generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools.

[0162] The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values;

[0163] The hash value, traceability code, and timestamp are stored together in the relational database of the unified data platform, and an open API is provided to verify data integrity.

[0164] The system submits key hash values ​​to a trusted timestamp service provider daily to obtain timestamp credentials, ensuring that the data is tamper-proof and has legal validity.

[0165] It should be noted that by generating hash values ​​for key business data at each stage using the SHA-256 algorithm and storing them together with traceability codes and trusted timestamps in the relational database of a unified data platform, the ability to ensure data immutability and operational traceability is achieved. Furthermore, by submitting key hash values ​​to a trusted timestamp service provider daily to obtain timestamp credentials, the credibility of the data's temporal dimension is further enhanced, giving the evidence storage results legal validity. This combination of centralized and timestamp-based approaches effectively guarantees data integrity and regulatory compliance while meeting the limitations of the current deployment environment, demonstrating good practicality and scalability.

[0166] The nutrition calculation module automatically calculates the amount of raw materials to be purchased based on the school's weekly menu requirements and calls the nutrition standard rule library. If the inventory is insufficient, it matches substitute ingredients according to the protein content ratio.

[0167] Furthermore, it reads the weekly menu files uploaded by the school, identifies the names of the dishes included in the three meals a day, searches for the corresponding ingredients and their single serving quantities in the preset recipe database based on the dish names, summarizes the ingredients of all dishes, forms a total demand table by ingredient type, and records the average daily usage and weekly total of each ingredient.

[0168] Obtain the current total number of students in the school, the number of meal days, and the target average daily nutritional intake standard per student;

[0169] For each raw material, retrieve its nutrient content per unit mass from the nutrient database;

[0170] Based on the target total intake T and the nutritional contribution per unit of raw material N i Calculate the minimum theoretical purchase quantity Q of the raw material. i The expression is:

[0171]

[0172] The system retrieves inventory data from the warehouse management system, compares the actual inventory with the calculated purchase quantity, and determines whether the demand is met.

[0173] For each raw material, determine whether S is satisfied. i ≥Q i

[0174] If the condition is met, no procurement is required; otherwise, proceed to the next step of the alternative processing procedure.

[0175] Identify the type A of raw material that needs to be supplemented and obtain its protein content per unit mass;

[0176] Select a set of candidate ingredients C from the alternative ingredient library that are similar to food A and whose protein content difference does not exceed a set threshold;

[0177] In the candidate set C, the ingredients are further sorted according to price, supply stability and historical purchasing preferences, and the ingredient B with the highest priority is selected as the alternative.

[0178] Based on the protein content ratio of raw material A to substitute ingredient B, calculate the required quantity of substitute ingredients to purchase, as shown in the expression:

[0179]

[0180] Among them, Q A P represents the theoretical purchase quantity of raw material A. A P represents the protein content per unit mass of raw material A. B The protein content per unit mass of food ingredient B;

[0181] It should be noted that the nutrition standard rule base supports flexible configuration of national / local nutrition intake standards and can perform differentiated calculations based on individual parameters such as students' age, gender, and physical condition; in addition to matching the protein content ratio, the alternative food recommendation strategy can also combine the multidimensional assessment of nutrients such as fat and carbohydrates to ensure dietary balance.

[0182] The report generation module automatically generates a traceability report containing digital signatures and filing codes based on the data from the evidence verification module and in accordance with regional regulatory standards.

[0183] Furthermore, based on the administrative region to which the school belongs, the corresponding source tracing report template is matched, and the field definition rules in the template are read, including the title format, body paragraphs, key data display methods, and the location for filling in the supervision number;

[0184] Load template style resources, including fonts, colors, and headers and footers, for subsequent report rendering;

[0185] The traceability code allows for the identification of the complete lifecycle record of this batch of materials within the unified data platform;

[0186] Extract key data from each stage, including:

[0187] Supplier side: Production batch number, quality inspection report number, and quality inspection results;

[0188] Delivery end: Warehouse temperature and humidity records, vehicle GPS tracks, and transportation time;

[0189] School side: Acceptance video, student feedback scores, and signature information;

[0190] The extracted key data is filled into the report structure according to the template field definitions to form a complete traceability content framework;

[0191] Call the digital certificate management system to obtain the current system's valid signature private key;

[0192] A secure encryption algorithm is used to calculate the digest of the populated report content. The expression is as follows:

[0193] D = SHA256 (report content);

[0194] Where D is the summary value of the report content;

[0195] The digest value D is encrypted using the private key to generate the digital signature value S, expressed as:

[0196] S = Sign(D, private key);

[0197] Embed the digital signature value S at the end of the report and attach the public key certificate information for third-party verification;

[0198] Retrieve the current administrative division code, school ID, and report generation timestamp;

[0199] The above information is combined to generate a filing code, including:

[0200] Encoding = Region Code + School ID + Timestamp;

[0201] Embed the filing code in the report header and upload it simultaneously to the regional regulatory platform interface to complete the filing registration;

[0202] The generated traceability report will be formatted and pushed to relevant parties;

[0203] It should be noted that the traceability report template supports dynamic updates and expansion according to regional regulatory policies, and the digital signature mechanism adopts the X.509 certificate system to ensure that the report source is verifiable and the content is tamper-proof; the filing code generation rules can be flexibly adjusted according to the interface requirements of the regulatory platform, and support the connection with multiple regional regulatory systems to facilitate unified management and data collection.

[0204] The anomaly response module monitors delivery temperature and humidity and vehicle GPS data in real time. When an anomaly is triggered, it sends an alarm to the third-party system through the dynamic routing module and generates an emergency plan.

[0205] Furthermore, IoT sensors are used to collect real-time data on environmental temperature and humidity and the GPS location of transport vehicles during the delivery process, and the raw data is transmitted to a unified data platform.

[0206] Based on preset temperature and humidity threshold ranges and transportation route planning, the collected data is compared and analyzed in real time to identify any abnormal conditions and determine whether the following conditions are met:

[0207] T min ≤T i ≤T max ;

[0208] H min ≤H i ≤H max ;

[0209] Among them, T i For the collected temperature value, H i The collected humidity value;

[0210] If the conditions are not met, it will be marked as an abnormal temperature and humidity.

[0211] By combining historical transportation routes and estimated arrival times, it is determined whether the current GPS location deviates from the planned route or poses a risk of delay. If the route is determined to be abnormal, the next alarm process is initiated.

[0212] Generate a corresponding alarm level identifier based on the anomaly type, and invoke the state-system mapping rules configured in the dynamic routing module;

[0213] Construct a structured alarm message containing the anomaly type, occurrence time, device number, and current value;

[0214] Alarm messages are sent asynchronously to each target system via an HTTPS protocol interface;

[0215] It should be noted that the frequency of temperature and humidity monitoring and GPS positioning data collection can be dynamically adjusted according to the type of transported goods and delivery distance to balance energy consumption and monitoring accuracy; the emergency response strategy can be optimized by machine learning in combination with historical handling records to gradually improve the level of intelligence in abnormal response and improve the efficiency and accuracy of event handling.

[0216] This embodiment also provides a computer device suitable for a real-time collaborative and traceable system for institutional material distribution based on a unified data platform, including: a memory and a processor; the memory is used to store computer-executable instructions, and the processor is used to execute the computer-executable instructions to realize the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as proposed in the above embodiment.

[0217] The computer device can be a terminal, comprising a processor, memory, communication interface, display screen, and input devices connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, carrier networks, NFC (Near Field Communication), or other technologies. The display screen can be an LCD screen or an e-ink screen. The input devices can be a touch layer covering the display screen, buttons, a trackball, or a touchpad on the computer device's casing, or an external keyboard, touchpad, or mouse.

[0218] This embodiment also provides a storage medium on which a computer program is stored. When executed by a processor, the program implements the real-time collaborative and traceable system for organizational material distribution based on a unified data platform, as proposed in the above embodiments. The storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read Only Memory (EPROM), Programmable Red-Only Memory (PROM), Read-Only Memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk.

[0219] In summary, this invention achieves data interoperability among different participants by defining data fields for each stage using a unified JSON Schema; it enables accurate identification of status changes by extracting status identifiers and timestamps from standardized data; it achieves intelligent routing selection and improves the targeting of push notifications by pre-setting status-system mapping rules and condition judgment mechanisms; it enhances the security and compatibility of message transmission through digital signatures and version control; it achieves the uniqueness and readability of material identification through a four-segment coding design, facilitating rapid identification by humans or systems; and it improves the integrity and tamper-proof capability of traceability codes by concatenating basic strings and generating verification codes, providing authoritative and reliable data sources for regulatory agencies and the public.

[0220] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the claims of the present invention.

Claims

1. A real-time collaborative and traceable system for institutional material distribution based on a unified data platform, characterized by: include: The module includes a data standardization module, a dynamic routing module, a traceability code generation module, an evidence verification module, a nutrition calculation module, a report generation module, and an anomaly response module. The data specification module uses a unified JSON Schema to define data specifications for supplier-side production batch numbers and quality inspection reports, delivery-side warehouse temperature and humidity and vehicle GPS, and school-side acceptance images and student feedback. The dynamic routing module, based on the output of the data specification module, uses a dynamic routing engine to push state changes to the third-party system in real time. The traceability code generation module generates a four-segment traceability code based on the structured data from the data specification module, and stores the hash values ​​of key data from each stage. The evidence storage and verification module, based on the output of the traceability code generation module, uses a centralized database and timestamp service to centrally store the hash values ​​of data from each stage, and provides a third-party verifiable interface. The nutrition calculation module automatically calculates the amount of raw materials to be purchased based on the school's weekly menu requirements and calls the nutrition standard rule library. If the inventory is insufficient, it matches substitute ingredients according to the protein content ratio. The report generation module automatically generates a traceability report containing digital signatures and filing codes based on the data from the evidence verification module and in accordance with regional regulatory standards. The anomaly response module monitors the delivery temperature and humidity and vehicle GPS data in real time. When an anomaly is triggered, it sends an alarm to the third-party system through the dynamic routing module and generates an emergency plan.

2. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 1, characterized in that: The specific steps for defining data specifications using a unified JSON Schema for supplier-side production batch numbers and quality inspection reports, delivery-side warehouse temperature and humidity and vehicle GPS, and school-side acceptance images and student feedback are as follows: A unified JSON Schema is used to define the data fields for supplier-side production batch numbers and quality inspection reports, including: Define a production batch number field to record the unique identifier of the product batch; Define a production date field to record the product's production time; Define a quality inspection report number field to record the unique identifier of the quality inspection report; Define a quality inspection result field to record the specific results of the quality inspection; A unified JSON Schema is used to define the data fields for temperature and humidity in the delivery warehouse and vehicle GPS data, including: Define a warehouse temperature field to record the temperature values ​​inside the warehouse; Define a warehouse humidity field to record the humidity value inside the warehouse; Define a vehicle GPS coordinate field to record the geographical location information of the transport vehicle; A unified JSON Schema is used to define the data fields for school-side acceptance images and student feedback, including: Define an acceptance image field to record photos or videos taken during the acceptance process; Define an acceptance time field to record the specific time of acceptance; Define a student feedback rating field to record students' satisfaction ratings for the supplies; Format the production batch number, production date, quality inspection report number, quality inspection results, and other data according to the predefined template; Format data such as warehouse temperature, warehouse humidity, and vehicle GPS coordinates according to a predefined template; The data, such as acceptance images, acceptance time, and student feedback scores, are formatted according to a predefined template. The converted data is validated using a unified JSON Schema to ensure that all data fields conform to the predefined standard format.

3. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 2, characterized in that: The output based on the data specification module is used to push state changes to the third-party system in real time through a dynamic routing engine. The specific steps are as follows: Extract the business stage identifier of the current material from the standardized fields output by the data specification module, and combine it with the timestamp field to determine whether the current status is the latest changed status. If a status change is detected, mark the change information as an event to be pushed. Read the predefined state-system mapping table, where each state corresponds to one or more target recipients. Match the corresponding push strategy according to the type of organization to which the current material belongs. If the strategy contains a conditional expression, evaluate whether it meets the push conditions. The status change information is combined with relevant business data into a structured message body, a digital signature field is added to ensure the authenticity of the message source, and a version control identifier is added. Based on the output list of target addresses, select the transmission protocol, initiate an asynchronous communication request, send a status change message, and record the response status code and return time for each push. If a push fails, the message is added to the retry queue and a maximum number of attempts is set. If the recipient returns an explicit error code indicating verification failure or refusal to receive, an alarm notification is generated and automatic retry is paused. All push records are written to the log database for auditing by the monitoring system.

4. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 3, characterized in that: The steps for generating a four-segment traceability code based on the structured data from the data specification module and storing the hash values ​​of key data from each stage are as follows: The traceability code generation module receives structured data output from the data specification module, including supplier ID, production date, and batch number information. The traceability code generation module uses the supplier ID field output by the data specification module as the first part of the traceability code; The traceability code generation module uses the production date field output by the data specification module as the second part of the traceability code. The traceability code generation module uses the batch number field output by the data specification module as the third part of the traceability code; Calculate the check digit to ensure the integrity and accuracy of the traceability code; The supplier ID, production date, and batch number are concatenated to form a basic string; The base string is processed using a predefined verification algorithm to generate a verification code; The verification code serves as the fourth part of the traceability code, ensuring the overall integrity of the traceability code. Generate a complete four-segment traceability code and associate it with relevant business data for storage; The traceability code generation module combines the supplier ID, production date, batch number, and check code into a complete four-segment traceability code according to a predefined format. The traceability code generation module associates and stores the traceability code with the corresponding business data; Store the hash values ​​of key data from each stage to ensure that the data cannot be tampered with; While generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools. The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values.

5. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 4, characterized in that: The evidence verification module includes: Based on the output of the traceability code generation module, a centralized database and timestamp service are used to centrally store the hash values ​​of data from each stage, and a third-party verifiable interface is provided. While generating traceability codes, key data from each stage are extracted, including quality inspection reports from suppliers, temperature and humidity records from delivery, and acceptance images from schools. The SHA-256 algorithm is used to perform hash operations on key data to generate corresponding hash values; The hash value, traceability code, and timestamp are stored together in the relational database of the unified data platform, and an open API is provided to verify data integrity. The system submits key hash values ​​to a trusted timestamp service provider daily to obtain timestamp credentials, ensuring that the data is tamper-proof and has legal validity.

6. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 5, characterized in that: Based on the school's weekly menu requirements, the system automatically calculates the raw material procurement quantity using a nutritional standard rule library. If the inventory is insufficient, substitute ingredients are matched according to the protein content ratio. The specific steps are as follows: Read the weekly menu file uploaded by the school, identify the names of the dishes included in the three meals a day, search for the corresponding ingredients and their single serving amount in the preset recipe database according to the dish name, summarize the ingredients of all dishes, form a total demand table by ingredient type, and record the average daily usage and weekly total of each ingredient. Obtain the current total number of students in the school, the number of meal days, and the target average daily nutritional intake standard per student; For each raw material, retrieve its nutrient content per unit mass from the nutrient database; Based on the target total intake T and the nutritional contribution per unit of raw material N i Calculate the minimum theoretical purchase quantity Q of the raw material. i The expression is: The system retrieves inventory data from the warehouse management system, compares the actual inventory with the calculated purchase quantity, and determines whether the demand is met. For each raw material, determine whether S is satisfied. i ≥Q i If the condition is met, no procurement is required; otherwise, proceed to the next step of the alternative processing procedure. Identify the type A of raw material that needs to be supplemented and obtain its protein content per unit mass; Select a set of candidate ingredients C from the alternative ingredient library that are similar to food A and whose protein content difference does not exceed a set threshold; In the candidate set C, the ingredients are further sorted according to price, supply stability and historical purchasing preferences, and the ingredient B with the highest priority is selected as the alternative. Based on the protein content ratio of raw material A to substitute ingredient B, calculate the required quantity of substitute ingredients to purchase, as shown in the expression: Among them, Q A P represents the theoretical purchase quantity of raw material A. A P represents the protein content per unit mass of raw material A. B The protein content per unit mass of food ingredient B.

7. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 6, characterized in that: The data from the evidence verification module is used to automatically generate a traceability report containing digital signatures and filing codes according to regional regulatory standards. The specific steps are as follows: Match the corresponding source tracing report template according to the administrative region to which the school belongs, and read the field definition rules in the template, including title format, body paragraphs, key data display methods and the location for filling in the supervision number; Load template style resources, including fonts, colors, and headers and footers, for subsequent report rendering; The traceability code allows for the identification of the complete lifecycle record of this batch of materials within the unified data platform; Extract key data from each stage, including: Supplier side: Production batch number, quality inspection report number, and quality inspection results; Delivery end: Warehouse temperature and humidity records, vehicle GPS tracks, and transportation time; School side: Acceptance video, student feedback scores, and signature information; The extracted key data is filled into the report structure according to the template field definitions to form a complete traceability content framework; Call the digital certificate management system to obtain the current system's valid signature private key; A secure encryption algorithm is used to calculate the digest of the populated report content. The expression is as follows: D = SHA256 (report content); Where D is the summary value of the report content; The digest value D is encrypted using the private key to generate the digital signature value S, expressed as: S = Sign(D, private key); Embed the digital signature value S at the end of the report and attach the public key certificate information for third-party verification; Retrieve the current administrative division code, school ID, and report generation timestamp; The above information is combined to generate a filing code, including: Encoding = Region Code + School ID + Timestamp; Embed the filing code in the report header and upload it simultaneously to the regional regulatory platform interface to complete the filing registration; The generated traceability report is formatted and packaged before being sent to relevant parties.

8. The real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in claim 7, characterized in that: The real-time monitoring of delivery temperature and humidity and vehicle GPS data, when an anomaly is triggered, synchronously sends an alarm to the third-party system via the dynamic routing module and generates an emergency plan. The specific steps are as follows: IoT sensors are used to collect environmental temperature and humidity and GPS location information of transport vehicles in real time during the delivery process, and the raw data is transmitted to a unified data platform. Based on preset temperature and humidity threshold ranges and transportation route planning, the collected data is compared and analyzed in real time to identify any abnormal conditions and determine whether the following conditions are met: T min ≤T i ≤T max ; H min ≤H i ≤H max ; Among them, T i For the collected temperature value, H i The collected humidity value; If the conditions are not met, it will be marked as an abnormal temperature and humidity. By combining historical transportation routes and estimated arrival times, it is determined whether the current GPS location deviates from the planned route or poses a risk of delay. If the route is determined to be abnormal, the next alarm process is initiated. Generate a corresponding alarm level identifier based on the anomaly type, and invoke the state-system mapping rules configured in the dynamic routing module; Construct a structured alarm message containing the anomaly type, occurrence time, device number, and current value; Alarm messages are sent asynchronously to each target system via an HTTPS protocol interface.

9. A computer device, comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, it implements the steps of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in any one of claims 1 to 8.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by the processor, it implements the steps of the real-time collaborative and traceable system for institutional material distribution based on a unified data platform as described in any one of claims 1 to 8.

Images