Agricultural product full life cycle information traceability method

A digital traceability system using unique codes and a cloud-based MySQL database addresses the lack of transparency in vegetable production, enabling consumers to verify vegetable authenticity and safety, and enhances operational efficiency.

CN120317883APending Publication Date: 2025-07-15INST OF AGRI INFORMATION & ECONOMICS HEBEI ACAD OF AGRI & FORESTRY SCI
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202510368969.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-03-27
Publication Date
2025-07-15

AI Technical Summary

Technical Problem

In the prior art, there are unknown sources of vegetable product quality and safety issues, unclear responsibilities, lack of management and inefficient information processing methods, and consumers cannot obtain reliable safety information.

Method used

A method of traceability of agricultural products throughout the life cycle information is adopted, and digital management is achieved through QR code scanning, transparency and traceability of all links from planting to sales, and primary product traceability codes and market entry traceability certificates are generated and printed using the management system, and information storage and query is carried out in combination with MySQL database.

Benefits of technology

The transparency and traceability of the agricultural product production process have been achieved. Consumers can scan the code on their mobile phone to obtain detailed information. Regulatory departments can accurately investigate quality issues, reduce farmers' losses, and improve corporate efficiency and consumer rights protection.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120317883A_ABST
    Figure CN120317883A_ABST
Patent Text Reader

Abstract

The invention provides an agricultural product full-life-cycle information tracing method. Firstly, an agricultural product production main body logs in a management system acquisition module, gives a primary product traceability code to a harvested agricultural product, and records the identity of the production main body and planting management information; and the agricultural product production and operation subject records own identity and transaction information in the system and generates a market entry traceability voucher during purchasing. And agricultural products with double codes enter the market for circulation. A consumer logs in the system after purchasing, and related information of a production subject and an operation subject can be inquired through code scanning. According to the method, object code correspondence is adopted, and various types of information are tagged. A supervision department can accurately investigate problems, and the loss of farmers is reduced. Consumers can conveniently obtain data of tracing, farming, environment and the like, so that cost reduction and benefit increase of enterprises are facilitated, rights and interests of the consumers are guaranteed, and vegetable production transparency and safety are improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention belongs to the field of agricultural product information traceability, and particularly relates to a method for tracing the whole life cycle information of agricultural products. Background Art

[0002] With the rapid development of the national economy and the gradual improvement of the quality of life, consumers pay more and more attention to food safety issues. People's choice of foods such as vegetables and fruits gradually tends to be green, healthy, and pollution-free.

[0003] Food quality and safety issues have always been key issues of the country. In recent years, the country has introduced a series of policies to regulate food safety issues. The increasing demand of consumers for high-quality life, the rapid development of technology, and the full coverage of smart phones have laid a good foundation for the agricultural market of new technology products. A "traceability system" that can easily identify authenticity and origin based on QR code scanning has emerged. However, there are still many problems in the quality and safety of vegetable products in China at present, such as the unclear source and destination of vegetables, the unclear demarcation of responsibility for problems, the lack of management and efficient information processing methods for vegetable production by vegetable production enterprises, and the lack of reliable channels for consumers to obtain vegetable safety information. Summary of the Invention

[0004] In order to solve the problems existing in the above-mentioned prior art, the present invention provides a method for tracing the whole life cycle information of agricultural products, which can realize digital management of various links of vegetables from planting, purchasing, processing, selling, and circulation, realize the transparency of the life cycle, the authenticity of the production process, the informatization of production and operation, and realize the traceability of each link.

[0005] The specific technical solution adopted by the present invention is as follows:

[0006] A method for tracing the whole life cycle information of agricultural products, the method comprises the following steps:

[0007] S1. The agricultural product production entity logs in to the management system and uses the acquisition system module to pack the harvested agricultural products and assign a primary product traceability code. The primary product traceability code correspondingly records the entity identity code of the agricultural product production entity and the planting management record of the agricultural product.

[0008] S2. The agricultural product production and operation entity purchases agricultural products from the agricultural product production entity. The agricultural product production and operation entity uses the management system to correspondingly record the entity identity code of the agricultural product production and operation entity and the superior transaction information, and generates a market entry traceability certificate after the recording is completed.

[0009] S3. When both the primary product traceability code of the agricultural product and the market entry traceability certificate are available, it enters the market for circulation for consumers to purchase.

[0010] S4. After purchasing agricultural products, consumers log in to the management system. By entering the primary product traceability code of the agricultural products through the query system module, they can query the entity identity code of the agricultural product production entity and the planting management records of the agricultural products. By entering the market access traceability certificate of the agricultural products, they can query the entity identity code of the agricultural product production and operation entity and the upstream transaction information.

[0011] The method for the transfer of transaction information between an agricultural product production and operation entity and an agricultural product production entity or other agricultural product production and operation entities is as follows: The upstream purchasing party enters the downstream entity identity code and purchasing information in the management system. The purchasing information includes the purchasing time, types and quantities of purchased agricultural products. This purchasing information is sent to the downstream supply party through the management system. The supply party enters the supply information, which includes the collected primary product traceability code or the transported product traceability code and the input logistics information. After confirming the transaction, the management system automatically generates the transported product traceability code, and the transported product traceability code records the above-mentioned purchasing information and supply information.

[0012] The planting management records of the agricultural products recorded by the primary product traceability code include the name, type, harvested weight, harvesting date, harvesting location, harvesting quantity of the harvested crops, as well as the records of pesticide and fertilizer use.

[0013] There can be multiple groups of the transported product traceability codes in the management system. The market access traceability certificate corresponds to multiple groups of transported product traceability codes generated by the entity identity code of the last-level agricultural product production and operation entity before the agricultural products are listed and the upstream transaction information. The transported product traceability code is used to query the transaction information at the corresponding level.

[0014] A database is set up in the management system. The primary product traceability code and the transported product traceability code are used as indexes in the database for querying the data corresponding to the indexes.

[0015] The primary product traceability code is generated by the management system and printed as a label in the form of a two-dimensional code. The agricultural product production entity generates the primary product traceability code and prints the two-dimensional code label by entering the planting management records in the management system. This label is pasted on the packaging materials of the corresponding agricultural products.

[0016] The transported product traceability code is generated by the management system and stored in the database of the management system. When the query system module conducts a query, the management system sends the transported product traceability code to the query terminal and displays it in the form of a two-dimensional code through a program preset in the query terminal.

[0017] The market access traceability certificate includes a label printed with a digital verification code. By covering the digital verification code with a coating, the consumer scratches off the coating and logs in to the management system, and enters the above digital verification code for querying.

[0018] The beneficial effects of the present invention are:

[0019] The present invention adopts the method of corresponding physical objects with codes, one code for one object. The stored environmental data, production process, safety and quality inspection information, and vegetable category standard information are assigned to the primary product traceability code. If there are quality and safety problems in the same industry, the regulatory authorities can conduct precise investigations, narrow down the scope of the problems, hold individuals accountable, and reduce the losses of farmers. Consumers can obtain data such as the traceability process, farming operations, and base environment by simply scanning the code with their mobile phones. This empowers enterprises, reduces costs, and increases efficiency. At the same time, increasing the transparency and safety of the vegetable production process is also a guarantee of consumers' rights and interests. Brief Description of the Drawings

[0020] Figure 1 It is a schematic diagram of the operation process of the present invention; Detailed Embodiments

[0021] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments:

[0022] Specific embodiments are as follows Figure 1 As shown, the present invention is a method for tracing the whole life cycle information of agricultural products, and the method includes the following steps

[0023] S1. The agricultural product production entity logs in to the management system and uses the acquisition system module to assign a primary product traceability code to the harvested agricultural products after packaging. The primary product traceability code correspondingly records the entity identity code of the agricultural product production entity and the planting management record of the agricultural products.

[0024] S2. The agricultural product production and operation entity purchases agricultural products from the agricultural product production entity. The agricultural product production and operation entity uses the management system to correspondingly record the entity identity code of the agricultural product production and operation entity and the superior transaction information, and generates a market entry traceability certificate after the recording is completed.

[0025] S3. When both the primary product traceability code and the market entry traceability certificate of the agricultural product are available, that is, when both codes are complete, it enters the market for circulation for consumers to purchase.

[0026] S4. After consumers purchase agricultural products, they log in to the management system and enter the primary product traceability code of the agricultural products through the query system module to query the entity identity code of the agricultural product production entity and the planting management record of the agricultural products, and enter the market entry traceability certificate of the agricultural products to query the entity identity code of the agricultural product production and operation entity and the superior transaction information.

[0027] The management system relied on by the present invention has a database set in the cloud, and the database is a MySQL database. MySQL has the following advantages:

[0028] (1) Support multiple operating systems such as Windows, Linux, MacOS, etc.; support multi-threading, can make full use of CPU resources, provide APIs for multiple programming languages, including C, Java, PHP, Python, etc. MySQL optimizes SQL algorithms and effectively improves query speed. As a separate application in a client-server network environment, it can also be embedded into other software as a library and provides multi-language support. It supports large databases and can handle large databases with tens of millions of records.

[0029] (2) MySQL is easy to use; compared with the setup and management of other large databases, its complexity is lower and it is easy to learn. MySQL management is simple and easy to maintain. For example, the replication of most mainstream databases is relatively complex and the operations are very troublesome, but the replication and dual-machine hot standby of databases in MySQL are very simple.

[0030] (3) Strong security and connectivity; flexible, secure permission and password system, very flexible and allows host verification. When connecting to the server, all passwords are in encrypted form, which maximally ensures the security of passwords. At the same time, since MySQL is networked, it can be accessed anywhere on the Internet, greatly improving the efficiency of data sharing.

[0031] After the agricultural product production entity logs in to the management system, it can pre-store planting management records in the system. The planting management records of the agricultural products recorded by the primary product traceability code include the harvested crop name, type, harvested weight, harvested date, harvested location, harvested quantity, and pesticide and fertilizer usage records.

[0032] When generating the primary product traceability code, the management system generates a unique primary key using the UUID algorithm, associates this primary key with the planting management records of this category of crops, and at the same time generates a QR code through a preset algorithm and prints it to form a label for implementing "one code for one thing" for the crops. Later, consumers can query the specific information of this agricultural product by entering the key value of this primary key through the image recognition method of scanning in the management system.

[0033] The market entry traceability certificate is also a set of unique primary keys stored in the database, which is used to store the process of agricultural product transactions, that is, downstream suppliers and upstream purchasers. Since there may be multiple levels of distributors for agricultural products, this market entry traceability certificate can correspond to storing multiple sets of upstream and downstream supply relationships. This supply relationship can record information such as the respective entity identity codes of the upstream and downstream, the types, quantities, and values of the traded agricultural products. The market entry traceability certificate includes two parts. One is the website address used to guide consumers to log in to the query page of the management system, which is presented in the form of a QR code. The other is that the market entry traceability certificate is a label printed with a digital verification code. The digital verification code is covered by a coating. Consumers scrape off the coating and log in to the management system, and enter the above digital verification code for query.

[0034] The method for the transfer of transaction information between agricultural product production and operation entities and agricultural product production entities or other agricultural product production and operation entities is that the upstream purchasing party enters the downstream entity identity code and purchasing information in the management system. The purchasing information includes the purchasing time, types and quantities of purchased agricultural products. This purchasing information is sent to the downstream supply party through the management system. The supply party enters the supply information, and the supply information includes the traceability code of the primary product or the traceability code of the transported product collected, and enters the logistics information. After the transaction is confirmed, the management system automatically generates the traceability code of the transported product, and the traceability code of the transported product records the above purchasing information and supply information.

[0035] Specifically, a table is constructed in the database to store information. When the upstream purchasing party logs in to the management system and enters the purchasing information, the management system adds a new piece of data in the table, generates a primary key using the UUID algorithm, and associates the entity identity code of the purchasing party and the purchasing information filled in by the purchasing party. The terminal of the management system logged in with the purchasing party's account scans the entity identity code page of the management system logged in with the supplier's account, jumps to the above purchasing information entry page, and brings in the entity identity codes of the purchasing party and the supply party with the help of the database. After the purchasing party fills in the information, the management system pushes the information to the supply party for confirmation operations.

[0036] There may be multiple sets of the traceability codes of the transported products in the management system. The market entry traceability certificate corresponds to the entity identity code of the last-level agricultural product production and operation entity before the agricultural product is listed and multiple sets of traceability codes of the transported products generated by the upstream transaction information. The traceability codes of the transported products are used to query the transaction information of the corresponding level.

[0037] A database is set up in the management system. The database uses the traceability code of the primary product and the traceability code of the transported product as indexes to query the data corresponding to the indexes.

[0038] The primary product traceability code is generated by the management system and printed as a label in the form of a QR code. The agricultural product production entity generates the primary product traceability code and prints the QR code label by inputting the planting management record into the management system. The label is affixed to the packaging material of the corresponding agricultural product.

[0039] The operating product traceability code is generated by the management system and retained in the database of the management system. When the query system module performs a query, the management system sends the operating product traceability code to the query terminal and displays it in the form of a QR code through a program preset in the query terminal.

[0040] Based on "one item, one code", digital management is established; closed-loop traceability information of the entire industry chain of vegetable planting, from origin, planting, processing, packaging, circulation to sales, is opened up. Since the above coding operations are all issued by the cloud server operation management system, counterfeiters cannot imitate the product's full life cycle information. Through the association relationship, the integration of product information, production entity, farm information, production process and other information is achieved, and anti-counterfeiting early warning is finally completed.

[0041] The combination of internal traceability (operating product traceability code) and external traceability (primary product traceability code) links the physical flow and information flow of the product together, ensuring the visibility and consistency of information throughout the traceability process. Internal traceability is the primary product traceability code of agricultural products, or the primary product traceability code of raw materials after agricultural product processing is associated with the batch number of the finished product, thereby binding all the information of the vegetables. If agricultural products from different families are mixed and redistributed or packaged after processing, the new products will be issued a new primary product traceability code from the management system logged in by the agricultural product production and operation entity that specifically executes the subcontract. The new primary product traceability code is associated with the original primary product traceability code to achieve traceability. Consumers can scan the code on their mobile phones to check the relevant information of each operating link of the product. The first query by consumers should show the number of queries as 0.

Claims

1. A method for tracing the information of the whole life cycle of agricultural products, characterized in that: The method described above has the following steps: S1. The agricultural product producer logs in to the management system and uses the collection system module to assign a primary product traceability code to the harvested agricultural products after packaging. The primary product traceability code corresponds to the producer identity code of the agricultural product producer and the planting management record of the agricultural product. S2. The agricultural product producer and operator purchases agricultural products from the agricultural product producer. The agricultural product producer and operator uses the management system to record the producer identity code of the agricultural product producer and operator and the upstream transaction information, and generates a market entry traceability certificate after the recording is completed. S3. When both the primary product traceability code of the agricultural product and the market entry traceability certificate are available, it enters the market for consumers to purchase. S4. After purchasing agricultural products, the consumer logs in to the management system and enters the primary product traceability code of the agricultural product through the query system module to query the producer identity code of the agricultural product producer and the planting management record of the agricultural product, and enters the market entry traceability certificate of the agricultural product to query the producer identity code of the agricultural product producer and operator and the upstream transaction information.

2. The method for tracing the whole life cycle information of agricultural products according to claim 1, wherein: The method for the transfer of transaction information between the agricultural product producer and operator and the agricultural product producer or other agricultural product producers and operators is that the upstream purchasing party enters the downstream entity identity code and the purchase information in the management system. The purchase information includes the purchase time, the types and quantities of agricultural products purchased. This purchase information is sent to the downstream supply party through the management system. The supply party enters the supply information, which includes the collected primary product traceability code or the transfer product traceability code, and enters the logistics information. After confirming the transaction, the management system automatically generates a transfer product traceability code, and the transfer product traceability code records the above purchase information and supply information.

3. A method for tracing the whole life cycle information of agricultural products according to claim 1, characterized in that: The planting management record of the agricultural product recorded by the primary product traceability code includes the name, type, harvested weight, harvest date, harvest location, harvest quantity of the harvested crop, as well as the pesticide and fertilizer usage records.

4. A method for tracing the whole life cycle information of agricultural products according to claim 2, characterized in that: There can be multiple groups of transfer product traceability codes in the management system. The market entry traceability certificate corresponds to multiple groups of transfer product traceability codes generated by the producer identity code of the last-level agricultural product producer and operator before the agricultural product is listed and the upstream transaction information. The transfer product traceability code is used to query the transaction information at the corresponding level.

5. The method for tracing the whole life cycle information of agricultural products according to claim 2, characterized in that: A database is set up in the management system. The database uses the primary product traceability code and the transfer product traceability code as indexes to query the data corresponding to the indexes.

6. The method for tracing the whole life cycle information of agricultural products according to claim 1, wherein: The primary product traceability code is generated by the management system and printed as a label in the form of a two-dimensional code. The agricultural product producer generates the primary product traceability code and prints the two-dimensional code label by entering the planting management record in the management system. This label is pasted on the packaging material of the corresponding agricultural product.

7. A method for tracing the whole life cycle information of agricultural products according to claim 1, characterized in that: The transfer product traceability code is generated by the management system and stored in the database of the management system. When the query system module conducts a query, the management system sends the transfer product traceability code to the query terminal and displays it in the form of a two-dimensional code through a program preset in the query terminal.

8. A method for tracing the whole life cycle information of agricultural products according to claim 1, characterized in that: The market entry traceability certificate includes a label printed with a digital verification code. By covering the digital verification code with a coating, the consumer scratches off the coating and logs in to the management system to enter the digital verification code for query.