Disclosure of Invention
In view of the above, in order to solve the technical problems that in the prior art, a consumer does not have a good consumption channel and a supervision department has a high difficulty in spot inspection, the invention provides a food safety-based query system for nearby sellers.
The invention solves the problems through the following technical means:
a query system of nearby sellers based on food safety comprises a production link traceability data reporting terminal, a circulation link traceability data reporting terminal, a server and a query platform of nearby sellers;
the server is respectively connected with a production link traceability data reporting terminal, a circulation link traceability data reporting terminal and a nearby seller query platform;
the production link traceability data reporting terminal is used for reporting production link traceability data and position coordinates to the server by a production enterprise and storing the production link traceability data and the position coordinates in the server;
the circulation link traceability data reporting terminal is used for a circulation enterprise to report circulation link traceability data and position coordinates to a server and store the circulation link traceability data and the position coordinates in the server;
the server is used for storing the position coordinates of the operator and an electronic traceability circulation data pool formed by production link traceability data and circulation link traceability data;
the electronic traceability circulation data pool is used for analyzing and summarizing, calculating the operation data of the operator, and pushing the operation data and the position coordinates of the operator to a nearby seller query platform;
the nearby seller inquiry platform is used for inquiring a nearby seller by a consumer through a commodity bar code, a commodity bar code and a production date or a tracing code and displaying the nearby seller to the consumer in a map coordinate point marking mode;
and the supervisor for the region inquires about the distribution of the nearby sellers and commodities and supervises the information of the nearby sellers and commodities.
Furthermore, the server comprises a data storage module, an analysis and summary module and a data pushing module, wherein the analysis and summary module is respectively connected with the data storage module and the data pushing module;
the data storage module is used for storing the position coordinates of an operator and the electronic source tracing circulation data pool;
the analysis and summary module is used for analyzing and summarizing by utilizing the electronic traceability circulation data pool and calculating the operation data of the operator;
the data pushing module is used for pushing the operation data and the position coordinates of the operator to a nearby seller query platform.
Further, the process of calculating the operation data of the operator by the analysis and summary module is as follows:
analyzing all sales data and stock data from a manufacturer, a wholesaler and a retailer by using an electronic traceability circulation data pool;
calculating summarized data through analyzed sales data and shipment data:
and calculating the operation data of the operator through the summarized data.
Furthermore, the analysis and summary module is used for sequencing according to the shipping date of the operation data and the shipping date to calculate the latest shipping date; the nearby seller query platform also presents the latest date of purchase of the nearby seller of the goods to the consumer.
Furthermore, the food safety-based query system for the nearby sellers further comprises a third-party shared data extraction platform, a supervision platform and an enterprise platform, wherein the third-party shared data extraction platform, the supervision platform and the enterprise platform are all connected with the server;
the third party shared data extraction platform is used for extracting the enterprise data to be reported from the third party shared data platform and storing the enterprise data in the server;
the server is also used for calculating whether each enterprise reports data within a given time threshold value by utilizing the enterprise data to be reported and the electronic traceability circulation data pool, and generating early warning information and pushing the early warning information to a supervision platform or an enterprise platform by the enterprise which does not report;
the supervision platform is used for the supervision personnel to inquire out the early warning information of each day, and timely analyze, process and punish according to the early warning information;
the enterprise platform is used for reporting personnel of an enterprise to check early warning information, timely subsidizing data and avoiding supervision punishment.
And further, the system also comprises a manual additional recording terminal connected with the server, wherein the manual additional recording terminal is used for supplementing enterprise data to be reported, which is leaked by the third-party shared data extraction platform, in a manual additional recording mode.
Furthermore, a production link traceability data reporting terminal and a circulation link traceability data reporting terminal report data by adopting a WebService interface, Excel batch reporting or webpage direct reporting mode; and the third-party shared data extraction platform incrementally extracts the enterprise data to be reported from the third-party shared data platform in a dblink mode.
Furthermore, the data storage module is also used for storing enterprise data to be reported;
the analysis and summary module is further used for calculating whether each enterprise reports data within a given time threshold value or not according to the enterprise data to be reported and the electronic traceability circulation data pool, and generating early warning information for the enterprises which do not report;
the data pushing module is also used for pushing the early warning information to a supervision platform or an enterprise platform.
Further, the process of generating the early warning information by the analysis and summary module is as follows:
acquiring enterprise data to be reported, and circularly processing each enterprise according to the following process;
obtaining the latest production link traceability data reporting time of the enterprise by using the production link traceability data;
utilizing the circulation link traceability data to obtain the latest circulation link traceability data reporting time of the enterprise;
comparing the latest production link traceability data reporting time with the latest circulation link traceability data reporting time, and taking the maximum value as the latest traceability data reporting time of the enterprise;
comparing the latest source tracing data reporting time with the current time, wherein the difference value is the non-reporting time;
if the unreported time is more than or equal to the first threshold and less than the second threshold, generating early warning information pushed to the enterprise platform;
and if the unreported time is greater than or equal to the second threshold value, generating early warning information pushed to the supervision platform.
Further, the first threshold and the second threshold are set by the supervisory platform.
Compared with the prior art, the invention has the following beneficial effects:
1) the function of inquiring nearby sellers through the commodity bar code, the commodity bar code + the production date and the tracing code is realized;
2) the supervision efficiency is improved, and the supervision labor cost is reduced;
3) the authenticity of the inquired commodities is ensured, and counterfeit commodities are effectively prevented;
4) the consumers can buy the safe and traceable commodity;
5) the problem of information isolated island of commodity operation data is solved;
6) and the early warning information is pushed in time, so that the supervision personnel can check the early warning information and supervise and urge the enterprise to report data in time.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in detail below. It should be noted that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments, and all other embodiments obtained by those skilled in the art without any inventive work based on the embodiments of the present invention belong to the protection scope of the present invention.
Example 1
As shown in fig. 1, the present invention provides a query system for nearby sellers based on food safety, which includes a production link traceability data reporting terminal, a circulation link traceability data reporting terminal, a server, and a query platform for nearby sellers;
the server is respectively connected with a production link traceability data reporting terminal, a circulation link traceability data reporting terminal and a nearby seller query platform;
the production link traceability data reporting terminal is used for reporting production link traceability data and position coordinates to the server by a production enterprise and storing the production link traceability data and the position coordinates in the server;
the circulation link traceability data reporting terminal is used for a circulation enterprise to report circulation link traceability data and position coordinates to a server and store the circulation link traceability data and the position coordinates in the server;
the server is used for storing the position coordinates of the operator and an electronic traceability circulation data pool formed by production link traceability data and circulation link traceability data;
the electronic traceability circulation data pool is used for analyzing and summarizing, calculating the operation data of the operator, and pushing the operation data and the position coordinates of the operator to a nearby seller query platform;
the nearby seller inquiry platform is used for inquiring a nearby seller by a consumer through a commodity bar code, a commodity bar code and a production date or a tracing code and displaying the nearby seller to the consumer in a map coordinate point marking mode;
and the supervisor for the region inquires about the distribution of the nearby sellers and commodities and supervises the information of the nearby sellers and commodities.
The server comprises a data storage module, an analysis and summary module and a data pushing module, wherein the analysis and summary module is respectively connected with the data storage module and the data pushing module;
the data storage module is used for storing the position coordinates of an operator and the electronic source tracing circulation data pool;
the analysis and summary module is used for analyzing and summarizing by utilizing the electronic traceability circulation data pool and calculating the operation data of the operator;
the data pushing module is used for pushing the operation data and the position coordinates of the operator to a nearby seller query platform.
The process of calculating the operation data of the operator by the analysis and summary module is as follows:
analyzing all sales data and stock data from a manufacturer, a wholesaler and a retailer by using an electronic traceability circulation data pool;
calculating summarized data through analyzed sales data and shipment data:
and calculating the operation data of the operator through the summarized data.
The analysis and summary module is used for sorting according to the shipping date of the operation data and the shipping date and calculating the latest shipping date; the nearby seller query platform also presents the latest date of purchase of the nearby seller of the goods to the consumer.
And the production link traceability data reporting terminal and the circulation link traceability data reporting terminal report data by adopting a WebService interface, an Excel batch reporting mode or a webpage direct reporting mode.
The production link traceability data reporting terminal, the circulation link traceability data reporting terminal and the nearby seller query platform are mobile phones, tablets or PCs.
As shown in fig. 2, the query system for nearby sellers based on food safety of the present invention forms an electronic traceability circulation data pool by reporting traceability data of a food circulation link by enterprises such as manufacturers, wholesalers, retailers, etc., and analyzes and summarizes the data in the electronic traceability circulation data pool and pushes the data to a query platform for nearby sellers. The consumer can inquire the commodity bar code, the commodity bar code + the production date and the nearby seller of the tracing code through the nearby seller inquiry platform, the system is displayed to the consumer in a map coordinate point marking mode, and regional supervision personnel can inquire the nearby seller and the commodity distribution through the nearby seller inquiry platform and can effectively supervise the nearby seller and the commodity information. The processing flow of the food safety-based nearby seller query system is as follows:
1) reporting traceability data of food circulation links by manufacturers, wholesalers, retailers and the like to form an electronic traceability circulation data pool;
2) analyzing and summarizing the data of the electronic traceability circulation data pool, calculating the operation data of the operator, and pushing the operation data and the position coordinates of the operator to a query platform of a nearby seller;
3) the consumer can inquire the commodity bar code, the commodity bar code + the production date and the nearby seller of the tracing code through the nearby seller inquiry platform, and the system displays the commodity bar code, the commodity bar code + the production date and the nearby seller of the tracing code to the consumer in a map coordinate point marking mode;
4) and the regional supervision personnel can inquire the distribution of the nearby sellers and commodities through the nearby seller inquiry platform, and can effectively supervise the information of the nearby sellers and commodities.
The food safety-based query system for nearby sellers comprises three main processes: data reporting flow, data analysis and summary flow and data query flow.
Data reporting process
As shown in fig. 3, according to different degrees of enterprise informatization levels, the invention designs different data reporting modes, which is convenient for enterprises to report data, thereby promoting the integrity of the traceable data.
1) Design data acquisition mode
The data acquisition mode which is convenient and easy to use is designed, at present, three modes of WebService interface reporting, Excel batch reporting and webpage direct reporting are adopted, and an enterprise selects a proper mode to use the system according to the self informatization level.
2) Collecting tracing information and providing data support for tracing platform
The method comprises the steps of collecting electronic traceability circulation data pools of manufacturers, wholesalers and retailers, providing data support for a nearby seller inquiry system, realizing whole-process traceability from all links of the manufacturers, the wholesalers and the retailers, and providing data basis for consumer traceability inquiry.
3) Design circulation data storage structure
As shown in fig. 4, for enterprise reporting in the circulation link, upstream and downstream enterprises can agree on which to report, thereby reducing the workload of the enterprises. Taking the sales data as an example, From is an upstream sales enterprise, To is a downstream shipment enterprise, and From type is Sale. When the selling enterprise inputs data, the state is in a state of waiting for confirmation, the downstream goods-feeding enterprise receives the form to be confirmed, and the enterprise can select to confirm the goods feeding and refuse the goods feeding according to the actual situation. Therefore, the reporting workload of the whole circulation link enterprise is reduced by half, and meanwhile, only the state table of the form is generated in the data confirmation process, so that the data storage is also reduced by half.
Data analysis summary flow
As shown in FIG. 5, the invention utilizes enterprise data and circulation link traceability data to analyze and summarize and push to a query platform of a nearby seller.
The protocol for analysis and summary is as follows:
1) analyzing the data pool by using an electronic traceability circulation data pool reported by an enterprise, and analyzing all sales data and stock data from a manufacturer, a wholesaler and a retailer;
2) and analyzing the sales data and the shipment data, and summarizing the data: the From field in the form is all state data of the enterprise and the To field is 'confirmed' state data of the enterprise;
3) calculating the operation data of the operator through the summarized data;
4) sorting according to the goods-feeding date of the operation data and the goods-feeding date, and calculating the latest goods-feeding date;
5) and pushing the coordinates and the operation data of the operator to a nearby seller query platform.
Data query process
As shown in FIG. 6, the invention pushes the analyzed and summarized data to a nearby seller query platform.
The query scheme of the query platform of the nearby seller is as follows:
1) query platform for querying nearby sellers by consumers
The consumer can inquire the commodity bar code, the commodity bar code + the production date and the nearby seller of the tracing code through the nearby seller inquiry platform, and the system displays the commodity bar code, the commodity bar code + the production date and the nearby seller of the tracing code to the consumer in a map coordinate point marking mode.
2) Supervisor inquiry platform for inquiring nearby sellers
The regional supervision personnel can inquire the distribution of the nearby sellers and commodities through the nearby seller inquiry platform, and can effectively supervise the information of the nearby sellers and commodities.
The invention relates to a food safety-based query system for nearby sellers, which is characterized in that an electronic traceability circulation data pool is formed by inputting sales or goods feeding data by a manufacturer, a wholesaler and a retailer, the data of the electronic traceability circulation data pool is utilized for analyzing and summarizing, the operation data of an operator is calculated, the operation data and position coordinates of the operator are pushed to a query platform of the nearby sellers, a consumer can query the nearby sellers of a commodity bar code, a production date and a traceability code through the query platform of the nearby sellers, and the system is displayed to the consumer in a map coordinate point marking mode. The regional supervision personnel can inquire the distribution of the nearby sellers and commodities through the nearby seller inquiry platform, and can effectively supervise the information of the nearby sellers and commodities. The invention breaks the problem of information isolated island of commodity operation data, realizes the function of inquiring nearby sellers through the commodity bar code, the production date and the tracing code, ensures that consumers buy reassuring and traceable commodities, improves the supervision efficiency, reduces the supervision labor cost, ensures the authenticity of inquired commodities and effectively stops counterfeit and shoddy commodities.
Example 2
As shown in fig. 7, the present invention further provides a query system for nearby sellers based on food safety, which further includes, on the basis of embodiment 1, a third party shared data extraction platform, a supervision platform, an enterprise platform, and a manual entry-supplementing terminal, where the third party shared data extraction platform, the supervision platform, the enterprise platform, and the manual entry-supplementing terminal are all connected to the server;
the third party shared data extraction platform is used for extracting the enterprise data to be reported from the third party shared data platform and storing the enterprise data in the server; the third party shared data extraction platform incrementally extracts the enterprise data to be reported from the third party shared data platform in a dblink mode;
the server is also used for calculating whether each enterprise reports data within a given time threshold value by utilizing the enterprise data to be reported and the electronic traceability circulation data pool, and generating early warning information and pushing the early warning information to a supervision platform or an enterprise platform by the enterprise which does not report;
the supervision platform is used for the supervision personnel to inquire out the early warning information of each day, and timely analyze, process and punish according to the early warning information;
the enterprise platform is used for reporting personnel to check the early warning information by the enterprise, and timely subsidizing data to avoid supervision punishment;
and the manual additional recording terminal is used for supplementing enterprise data to be reported, which is leaked by the third-party shared data extraction platform, in a manual additional recording mode.
The data storage module is also used for storing enterprise data to be reported;
the analysis and summary module is further used for calculating whether each enterprise reports data within a given time threshold value or not according to the enterprise data to be reported and the electronic traceability circulation data pool, and generating early warning information for the enterprises which do not report;
the data pushing module is also used for pushing the early warning information to a supervision platform or an enterprise platform.
The process of generating the early warning information by the analysis and summary module is as follows:
acquiring enterprise data to be reported, and circularly processing each enterprise according to the following process;
obtaining the latest production link traceability data reporting time of the enterprise by using the production link traceability data;
utilizing the circulation link traceability data to obtain the latest circulation link traceability data reporting time of the enterprise;
comparing the latest production link traceability data reporting time with the latest circulation link traceability data reporting time, and taking the maximum value as the latest traceability data reporting time of the enterprise;
comparing the latest source tracing data reporting time with the current time, wherein the difference value is the non-reporting time;
if the unreported time is more than or equal to the first threshold and less than the second threshold, generating early warning information pushed to the enterprise platform;
and if the non-reporting time is greater than or equal to a second threshold value, generating early warning information pushed to the supervision platform, wherein the first threshold value and the second threshold value are set by the supervision platform.
According to the food safety-based query system for nearby sellers, enterprise data to be reported are extracted from a third-party shared data platform through a third-party shared data extraction platform, production link traceability data are input through a production enterprise, circulation link traceability data are input through a circulation enterprise to form an electronic traceability circulation data pool, enterprise reporting behaviors are analyzed through the electronic traceability circulation data pool, a time threshold value is set, enterprises which do not report data after time is exceeded, early warning information can be automatically pushed to a supervision platform and the enterprise platform by the system, and the early warning information can be visually presented to relevant personnel through the system. By introducing a data confirmation mechanism in the circulation link, the upstream enterprise inputs data, and the downstream enterprise confirms the data without inputting again, and vice versa. In the confirmation process, the data is not copied, and the system judges the reporting behavior of the enterprise related to the document according to the document type and the state, so that the physical storage capacity of the data and the reporting workload of the enterprise are effectively reduced; the system supervisor can inquire the detailed contents of the early warning every day through the supervision platform, and timely analyze, process and punish according to the early warning information; the enterprise reporting personnel can check the early warning information every day and report the data in time.
Compared with the prior scheme, the invention has the advantages and characteristics that:
1) the function of inquiring nearby sellers through the commodity bar code, the commodity bar code + the production date and the tracing code is realized;
2) the supervision efficiency is improved, and the supervision labor cost is reduced;
3) the authenticity of the inquired commodities is ensured, and counterfeit commodities are effectively prevented;
4) the consumers can buy the safe and traceable commodity;
5) the problem of information isolated island of commodity operation data is solved;
6) and the early warning information is pushed in time, so that the supervision personnel can check the early warning information and supervise and urge the enterprise to report data in time.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.