JP2013058141A - Expiration date information notification system and expiration date information notification method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an expiration date information notification system and an expiration date notification method which enable a consumer to obtain notification of an expiration date for use of a commodity, expiration date for consumption of food or the like by a simple procedure.SOLUTION: An expiration date information notification system 1 comprises: communication means 11 for performing transmission and reception of mails for portable phones; storage means 14 for storing information of received mails as a database; and information processing means 13 which controls the communication means and the storage means, and also processes information of mails in predetermined order. When the communication means receives a mail from a portable phone which has read a matrix type two-dimensional bar code attached to a commodity, the information processing means stores each received date and reception effective date in association with its mail address in the database, every day determines whether an effective date has passed on the basis of a reception date of each data in the database, and notifies a portable phone of a mail address of corresponding data that it is an expiration date of a commodity.

Description

  The present invention relates to a collective management by a commodity supplier such as the expiration date or the expiration date of a product or the like whose consumption period is determined or a food whose consumption period is determined.

Increased in summer, to prevent the entry of unpleasant pests such as butterflies and slurps (rock mosquitoes) that fly around dark and damp places such as the verandas of the house and the triangular corners of the kitchen, or prevent entry into the room Various types of insect repellents have been developed for this purpose.
Among these insect repellents, products that are effective for a long period (100 days, 130 days) are commercially available for liquid types used indoors and plate types used on verandas. (Non-Patent Document 1). Currently, the use period of the long-term use type insect repellent is left to the management of the consumer, and the use period is not properly controlled and is used afterwards, or the use period has elapsed. It was often replaced before.

Continuing use after the period of use gives consumers an impression that the product is ineffective and causes a disadvantage to the seller. Will buy the product again.
In recent years, the liquid type long-term use type has been widespread in removing electric mosquitoes. In such liquid-type electric mosquito traps, the chemical solution is filled in a transparent container, and it is possible to determine the elapsed time of use by visually checking the presence or absence of the chemical solution. Continuing to use it without concern is likely to cause distrust in the mosquito-repelling effect of the product.

  As a method for managing the expiration date or the expiration date of a product, for example, a technique for managing the expiration date of food at home using a refrigerator that can communicate with a communication network such as the Internet is proposed. (Patent Document 1).

JP 2003-122914 A

Internet, “Insect Connors (insect repellent) product information KINCHO Dainippon Insect Chrysanthemum Co., Ltd.”, http://www.kincho.co.jp/seihin/01/line_musiyoke.html

  The technique proposed in Patent Document 1 is not limited to a specific food, and is an excellent method that can be applied to all foods that are preferably managed for expiration dates, etc., while a display, a barcode reader, an input button, and these Refrigerator equipped with a control device with an interface circuit that performs input and output of the microcomputer, a microcomputer (CPU), etc. is necessary, and when storing food purchased in a store in the refrigerator, a complicated product registration work is required And In addition, there is a problem that food consumers must purchase a dedicated management device and refrigerator, which imposes a large economic burden on the consumer.

  The present invention has been made in view of the above-mentioned problems, and is a expiration date information notification system and expiration date information that allow consumers to obtain notification of the progress of the use period of a specific article or the consumption period of a food by a simple procedure. The purpose is to provide a notification method.

  The expiration date notification system according to the present invention includes a communication unit that transmits / receives mail to / from a mobile phone, a storage unit that stores mail information received by the communication unit as a database, the communication unit, and the storage unit. And information processing means for processing the information of the mail in a predetermined procedure, the information processing means from the mobile phone that has read the matrix type two-dimensional barcode attached to the product When the communication means receives the mail, the received date and the valid days of the product included as information in the matrix type two-dimensional barcode are stored in the database in association with the email address of the mobile phone. The date when the effective days have elapsed from the reception date in each data of the database and / or the effective days have elapsed. It is determined whether the date is a predetermined number of days before the date, and if this date is any of these dates, it is the expiration date or use of the product for the mobile phone with the email address in the data It is configured to notify by e-mail that the date is a predetermined number of days before the expiration date.

The term “use” in the above includes “consumption”, and “effective days” is the number of days that can be used or the number of days until consumption.
Another expiration date information notification system according to the present invention includes a communication unit that transmits / receives mail to / from a mobile phone, a storage unit that stores information on mail received by the communication unit as a database, the communication unit, and the communication unit. Information processing means for controlling the storage means and processing the information of the mail according to a predetermined procedure, and the information processing means reads the matrix type two-dimensional barcode attached to the product When the communication means receives the mail from the database, it searches the data already stored in the database for the mail address that matches the mail address of the received mail, and if no match is extracted, use The date of receipt of the email as the start date and the number of valid days of the product included as information in the matrix type 2D barcode A code indicating product use is stored in the database in association with the e-mail address of the mobile phone that sent the mail, and if a match is extracted, the code of the data indicates product use If it is rewritten with a code not used for the product and the effective date is rewritten with the number of effective days obtained by subtracting the number of days elapsed from the start date of use to the date of receipt of the email, or the code of the data indicates that the product is not used If so, rewrite the product use code and rewrite the use start date on the date of receipt of the e-mail. Determine whether the number of days has passed and / or is a day that is a predetermined number of days before the day that has passed the effective number of days. If today is any of these, notify the mobile phone with the email address in the data that it is the expiration date of the product or that it is a predetermined number of days before the expiration date Configured as follows.

  Preferably, the storage means is configured to store an identification code associated with the mail address in a database, and the information processing means has already received the database when the communication means receives mail from the mobile phone. The ID code and the mail address are both included in the matrix type two-dimensional bar code as information and searched for data that matches the ID code and mail address transmitted by the mail. If nothing is extracted, the mail information is processed according to the predetermined procedure. If a match is extracted, it has already been registered for the mobile phone with the mail address of the received mail. It is configured to notify that there is.

  The expiration date information notification method according to the present invention is a notification method for expiration date information to be performed by a computer, and is a mobile phone that reads a matrix type two-dimensional bar code that records an e-mail address attached to a product and the number of days of use of the product. When the mail addressed to the mail address is received, the received date of the mail and the valid days of the product included as information in the matrix type two-dimensional barcode are associated with the mail address of the mobile phone that transmitted the mail. Whether it is stored in the database, and today is the day before the day when the effective date has elapsed from the reception date in the data of the database and / or the day before the day when the effective date has passed If today is one of these, the email address in the data Be notified by mail that this is the day before the number of days that a predetermined than that or expiration date is the expiration date of the product to the telephone.

The term “use” in the above includes “consumption”, and “effective days” is the number of days that can be used or the number of days until consumption.
Another expiration date information notification method according to the present invention is an expiration date notification method to be performed by a computer, which reads a matrix type two-dimensional barcode that records an email address attached to a product and the number of days used for the product. When a mail addressed to the e-mail address is received from a mobile phone, a search is made for data that already matches the e-mail address of the received e-mail address from the data stored in the database. Is associated with the email address of the mobile phone that sent the email, the date of receipt of the email as the start date of use, the number of valid days of the product included as information in the matrix type two-dimensional barcode, and the code indicating the usage of the product Stored in the database and if a match is extracted, If the code of the data indicates product use, rewrite the product with a product non-use code and rewrite the valid days with the valid days obtained by subtracting the number of days elapsed from the start date of use to the date of receipt of the email, or the data If the code indicates that the product is not used, it is rewritten to a product use code and the use start date is rewritten to the date of receipt of the email. It is determined whether today is the day before the effective date from the start date of use and / or the day before the date that has passed the effective day, and whether the date is a day before the current date. If there is, it is the expiration date of the product for the mobile phone with the email address in the data, or a date that is a predetermined number of days before the expiration date The Rukoto be notified by e-mail.

The “predetermined procedure” includes the above-mentioned expiration date information notification system according to the present invention, another expiration date information notification system according to the present invention, the expiration date information notification method according to the present invention according to the present invention, and In another expiration date information notification method according to the present invention, it means a procedure of processing performed by the information processing means after the communication means receives mail from the mobile phone.
“Today” refers to the processing date by the information processing means.

  ADVANTAGE OF THE INVENTION According to this invention, the expiration date information notification system and expiration date information notification method which a consumer can obtain notification of use period progress of a specific article or consumption period progress of foodstuffs by a simple procedure can be provided.

FIG. 1 is a diagram showing an operating environment of the expiration date information notification system. FIG. 2 is a diagram showing the configuration of the expiration date information notification system. FIG. 3 is a flowchart showing the operation of the expiration date information notification system. FIG. 4 shows the data structure of the database. FIG. 5 is a mobile phone screen for confirming rewriting of the database. FIG. 6 is a diagram showing a database in which use of some products is registered for interruption. FIG. 7 is a diagram showing a database in which use resumption is registered for some products. FIG. 8 is a diagram of a mobile phone screen for e-mail regarding the expiration date. FIG. 9 is a flowchart showing the operation of another expiration date information notification system. FIG. 10 is a diagram showing a data structure of a database in another expiration date information notification system. FIG. 11 is a flowchart of batch processing.

FIG. 1 is a diagram illustrating an operating environment of the expiration date information notification system 1, and FIG. 2 is a diagram illustrating a configuration of the expiration date information notification system 1.
The expiration date information notification system 1 is realized by a web server (computer) connected to the Internet (wide area communication network) 2. The expiration date information notification system 1 includes a communication unit 11, an internal storage unit 12, an information processing unit 13, and an external storage unit 14.

The communication means 11 is an interface for connecting the expiration date information notification system 1 to the Internet.
The internal storage unit 12 is a semiconductor memory (RAM) capable of writing and reading. The internal storage unit 12 stores a program for operating the expiration date information notification system 1, various data generated during data processing for storage in the external storage unit 14, and the like. The main programs for operating the expiration date notification system 1 include an initial registration unit 21, a duplicate registration avoidance unit 22, a suspension / resumption registration unit 23, and a period warning unit 24.

  The information processing unit 13 executes a program stored in the internal storage unit 12 to connect to the Internet via the communication unit 11, process data received through the Internet, and use data stored in the external storage unit 14. Performs deadline management processing and mail transmission processing to data registrants. The information processing means 13 is constituted by an arithmetic processing unit (CPU).

  The external storage means 14 stores data received via the Internet as a database. As the external storage means 14, a magnetic recording medium (hard disk) or a nonvolatile semiconductor memory is used. “External” in the external storage means 14 means a storage area that is distinguished from the work area on the memory used when the arithmetic processing unit operates, separately from the internal storage means 12 as a magnetic recording medium or semiconductor memory. It does not mean that it exists.

The expiration date notification system 1 uses information recorded in a matrix type two-dimensional barcode (hereinafter referred to as “QR code” (registered trademark)) attached to a package (packaging box or container, etc.) PC of a commercial product. The expiration date of each product is managed based on the received information.
Next, the operation of the expiration date information notification system 1 will be described.

FIG. 3 is a flowchart showing the operation of the expiration date information notification system 1, and FIG. 4 is a diagram showing the data structure of the database DB.
First, a procedure until the expiration date information notification system 1 receives product information transmitted by a customer will be described.
The following information is recorded in the QR code attached to the product package PC.
(1) Email address of product data transmission destination (2) Product item GA
(3) Lot number LN
(4) Identification code (duplicate registration avoidance code) DC
(5) Days of use PT
Products with a QR code on which information of (1) to (5) is recorded may be a specific period, such as insect repellents such as butterflies and squirrels (rock mosquitoes), and electric mosquito traps. For example, foods that have sustained performance when left untreated, foods with a shelf life or expiry date after opening, and foods, medicines, etc. with expiry dates after production. In addition, when the expiration date after manufacture is managed by the expiration date information notification system 1, the date of manufacture is also recorded in the QR code.

  For the information (2) to (5) above, for example, using an automatic mail transmission data insertion function published by a mobile phone HP operator, an e-mail is sent to the e-mail address recorded in (1) without a message. Then, it is recorded on the QR code so that the information from the used item GA to the used days PT is transmitted. Here, “the number of days of use PT” is the number of days that can be used continuously from the date of use of a product such as an insect repellent, for example, and the expiration date or expiration date after opening is determined. It is the number of days until the expiration date or the expiry date for a given food, and the number of days from the date of manufacture to the expiry date for a food, medicine, etc. for which the expiry date after production is determined.

Hereinafter, an insect repellent will be described as an example.
A consumer who wishes to have the expiration date information notification system 1 manage the expiration date of a product such as an insect repellent that has a specified expiration date from the start of use is attached to the package PC at the start of use of the product. The QR code is photographed with a camera using the QR code reading function of the mobile phone HP, and transmitted to an e-mail address displayed on the screen. In the transmitted mail, the product item GA, the lot number LN, the identification code DC, and the usable date PT of the photographed product are attached as product data and transmitted to the expiration date information notification system 1.

As described above, a technique is known in which a mail address and transmission data of a transmission destination are recorded in a QR code, and information recorded in the QR code is transmitted to a mail address recorded by photographing the QR code with a mobile phone. (Ran's Night (registered trademark), http://rans-night.jp/rans_pc/ransnight_about.html).
Referring to FIG. 3, in the expiration date information notification system 1 that has received the product data from the consumer's mobile phone HP, the information processing means 13 is a database DB stored in the external storage means 14 (see FIG. 4). The registered records including the product data matching the product item GA, the lot number LN, and the identification code DC are searched (S11).

  Here, the database DB will be described. In the example of FIG. 4, the commodity item GA has 3 characters, the lot number LN has 8 characters, and the identification code DC has 4 characters, both of which are character string data. For example, if the number of data items such as product item GA, lot number LN, and identification code DC is I, the database stores each information in an array (I, J) where the number of columns is I and the number of data (number of records) is J. (Data) is stored.

  For example, when the consumer purchases and uses a plurality of products having the same lot number LN, the identification code DC is used to identify each product. The identification code DC is attached as a different character string to all products manufactured with the same lot number LN so that the same consumer does not have the possibility of purchasing the same lot number LN and the same identification code DC. preferable. In the database DB shown in FIG. 4, the identification code DC is 4 characters. When the number of commodities manufactured in the same lot is large and the number of identification codes DC is insufficient with only numbers, English letters are used in addition to numbers.

  In order to shorten the search time for product data (record) in which the product item GA, the lot number LN and the identification code DC match, the character string of the product item GA, the lot number LN and the identification code DC is concatenated as one data. You may memorize | store in database DB. In this case, the information processing means 13 concatenates the character string of the commodity item GA, the lot number LN, and the identification code DC of the received commodity data, and then collates with the registered commodity data in the database DB.

“Product data” refers to product items GA to usage days PT ((2) to (5)) at the stage of transmission from the mobile phone HP that has read the QR code, and after being registered in the database DB The contents of each data item constituting the record shall be said.
When the expiration date information notification system 1 does not find the registered product data in which the product item GA, the lot number LN, and the identification code DC of the received product data match in the database DB (NO in S12), the mail address of the sender The MA, the received commodity item GA, the lot number LN, the identification code DC, and the usage date PT are stored in the corresponding column of the newly created record (row data) in the database DB, and the reception date and the usage flag UF are registered on the registration date RD. “1” indicating “used” is stored in “1”, and the number of days that the product can be used is stored in the remaining number of used days UD (S13). At the same time, the registration date RD is copied to the use resumption date RU of the data item.

Further, the expiration date information notification system 1 uses the remaining usage days UD to determine the usage expiration date when the received date (registration date) is used as the usage start date, three days before, and the date ten days before the usage expiration date. The calculation results are stored in columns of the due date LD, the BT 3 days before the due date, and the BD 10 days before the due date in the database DB (S14).
When the product expiration date is managed by the expiration date notification system 1 starting from the date of manufacture and not from the registration date, it is read from the QR code and transmitted by the mobile phone HP instead of the registration date of the database DB. The manufacturing date is recorded (in this case, the data item name is not “registration date” but “manufacturing date”, but the processing contents before and after this are the same).

These series of processes are executed by a program written in the semiconductor memory as the internal storage unit 12 as the initial registration unit 21.
When a new record based on the received product data is created in the database DB, the expiration date information notification system 1 transmits a contact mail notifying that the registration is completed to the registered mail address MA (S15). .

When registered product data that matches the product item GA, the lot number LN, and the identification code DC of the received product data is found in the database DB (YES in S12), the expiration date information notification system 1 receives the received email address. Is compared with the mail address MA of the registered product data that coincides (S16).
When the received e-mail address does not match the e-mail address MA of the registered product data (NO in S16), the expiration date notification system 1 accesses from a person other than the registrant (consumer) for the already registered product. Accordingly, a notification mail indicating that data registration and data change cannot be performed is sent to the mail sender (S17). This operation limits product data registration, data change, etc. for one product to a specific person (specific mobile phone HP), thereby allowing duplicate registration from family members (other mobile phones HP) or data This is to avoid duplication processing (error processing) such as changes.

  The process for avoiding the duplicate registration by the expiration date information notification system 1 is executed by a program stored in the internal storage unit 12 as the duplicate registration avoidance unit 22. The expiration date information notification system 1 may not include the duplicate registration avoidance unit 22. Such an expiration date information notification system 1 does not transmit an email indicating that it has been registered to the registrant's mobile phone HP. As for the mail transmission to the registrant on the expiration date and several days before, the same message (see FIG. 8) with the same number as the number of duplicate registrations is transmitted.

  When the email address of the received email matches the email address MA of the registered product data (YES in S16), the expiration date information notification system 1 sends a confirmation email asking whether or not to request processing for changing the registered product data. A reply is made to the cellular phone HP of the (mail sender) (S18). When the use flag UF of the matching registered product data is “1”, the confirmation email indicates, for example, “Do you want to suspend the use of insect repellent A (product name corresponding to product item GA)?” A mail message “Please reply with an empty mail when interrupting” is transmitted (FIG. 5A). In addition, when the use flag of the registered product data that matches is “0”, the confirmation email indicates, for example, “Do you want to resume using insect repellent A (product name corresponding to product item GA)?” And “Please reply with a blank e-mail when resuming” is sent (FIG. 5B).

Here, “data change” refers to changing the record that the product is in use to the non-use state, or changing the record that the product is in use to the use state.
This data change can be made when, for example, the use of an electric mosquito collector that can be used for a long time (120 days) is stopped halfway due to a trip, etc. This is done when used only for

When this expiration date information notification system 1 is used for managing the expiration date of food, medicine, etc., such data change is not normally made.
When the expiration date information notification system 1 does not receive mail from the consumer (mail sender) within a predetermined time (NO in S19), the registrant does not wish to change the product data and does not perform subsequent processing. . When the registrant does not wish to change the product data and forgets that it has been registered and tries to register it in the expiration date notification system 1, the data change for starting use is sent even though the product is in use. Cases.

  When the expiration date information notification system 1 confirms the arrival of an empty mail (YES in S19), if the usage flag UF of the registered product data hit by the search is “1” (YES in S20), the usage flag UF is set to “ It is rewritten to “0” (S21). Due to this rewriting, use of this product is interrupted, and the product is not subject to expiration management by the expiration date information notification system 1. The expiration date information notification system 1 calculates the elapsed days from the use resumption date RU of the corresponding record, and stores the result obtained by subtracting the calculated elapsed days from the remaining used days UD in the remaining used days UD (S21). The expiration date information notification system 1 notifies the empty mail sender (registrant, consumer) by email that registration of the expiration date management suspension has ended (S15).

  If the e-mail addresses match without sending the confirmation e-mail (S18) (YES in S16), the use flag UF may be rewritten unconditionally. In such an expiration date information notification system 1, after rewriting the usage flag UF, the mobile phone HP that has sent the mail is notified that use interruption or use resumption has been registered. The registrant who received the notification, if the use interruption or resumption of use is an erroneous transmission, captures the QR code of the product again and sends it by e-mail, and then re-registers the use resumption or resumption of use. Avoid changes.

FIG. 6 is a diagram showing a database DB in which product data of record numbers 5684 and 5681 are registered for interruption of use. FIG. 6 shows that the product with record number 5684 has been registered for use suspension on the 25th day from the registration date, and the product with record number 5681 has been registered for use suspension on the 34th day from the registration date.
When the use flag UF of the registered product data hit in the search is not “1” (“0”) (NO in S20), the expiration date information notification system 1 rewrites the use flag UF to “1”, and The record resumption date RU is rewritten to the incoming date of the empty mail (S22).

  Subsequently, the expiration date information notification system 1 calculates the expiration date, three days before the expiration date, and 10 days before the expiration date from the usage resumption date RU and the remaining usage date UD, and the expiration date LD in the database DB is calculated based on the calculation result. The data of BT 3 days before the deadline and BD 10 days before the deadline are rewritten (S14). The expiration date information notification system 1 notifies the empty mail sender (registrant, consumer) by email that registration of the expiration date management suspension has ended (S15).

FIG. 7 is a diagram showing a database DB in which use resumption is registered for the product data of record numbers 5684 and 5681. FIG. 7 shows that the product with the record number 5684 is registered for resuming use on August 5, 2011, and the product with the record number 5681 is registered for resuming use on September 1, 2011.
The processing of the expiration date information notification system 1 relating to the suspension and resumption of use of the product is executed by a program stored in the internal storage means 12 as the suspension / resumption registration means 23.

  The expiration date check of the product data in the database DB by the expiration date information notification system 1 is performed every day as a batch process at night, for example, between 2 am and 4 am. The expiration date information notification system 1 reads the data of the expiration date LD, the BT 3 days before the expiration date, and the BD 10 days before the expiration date of each record, and whether these dates match the current date (the date on which the check process is performed, today) For records that have the same expiration date LD, BT 3 days before expiration, or BD 10 days before the expiration date, a separate storage is provided in the external storage unit 14 for the data of the expiration date, 3 days before the expiration date, and 10 days before the expiration date. In the area, the mail address of the corresponding record, the product name corresponding to the product item, and the registration date are stored.

The registrant (consumer) is notified that the expiration date is imminent or that the expiration date has expired. The product data corresponding to each day is determined during the daytime, for example, from 10 am to 11 am This is done by means of mail transmission to the registrant's mobile phone HP.
The notification regarding the expiration date by mail transmission to the registrant's mobile phone HP performed by the expiration date notification system 1 is executed by a program stored in the internal storage means 12 as the expiration warning means 24.

FIG. 8 is a diagram of a screen of the mobile phone HP for mail related to the expiration date. 8A is a mail transmitted 10 days before the expiration date, FIG. 8B is a mail transmitted 3 days before the expiration date, and FIG. 8C is a mail transmitted on the day of the expiration date.
The consumer who has received the e-mail regarding the expiration date of the product plans to purchase a new product based on the information in the e-mail, or monitors whether the product is used or not to determine whether to stop using the product.

  For products that can be used for a long period of time, consumers generally do not strictly manage the use period, and often end use based on the number of days elapsed since the use start date that has been memorized. Therefore, it may be used continuously without knowing that the expiration date has passed, or the use may be terminated even if there is still a period before the expiration date. The expiration date management by the expiration date information notification system 1 can be expected to increase the number of repeaters by encouraging the consumer to use the item appropriately, informing the consumer of the effect of the item.

The identification code DC has a role of identifying individual products when the same consumer purchases and uses a plurality of products in addition to the role of preventing duplicate registration of already registered product data.
When a corresponding data record is extracted every day as a batch process, the identification code DC is also stored in the external storage means 14 together with the mail address MA, etc., thereby identifying the corresponding product on the screen of the mobile phone HP in FIG. The code DC can be displayed.

  For example, it is possible for a plurality of products of the same product item to be registered on the same day from one mobile phone HP. And use may be interrupted only about some registered goods. Even in such a case, each product can be clearly distinguished on the database DB by using the identification code DC. Then, in batch processing for searching for products whose expiration date has expired every day, when the corresponding data record is extracted, if the identification code DC is also stored in the external storage means 14 together with the mail address MA etc., then the mail is transmitted. The identification code DC of the corresponding product can be displayed on the screen of the mobile phone HP shown in FIG.

  When the expiration date information notification system 1 has such a function of identifying individual products by the identification code DC and sending information on the expiration date by e-mail, a person separate from the QR code is provided on the product package PC. It is preferable to write an identification code as a character so that it can be visually recognized. Instead of writing the identification code DC as characters in the product package, the identification code as characters may be displayed on the screen if the mobile phone HP reads the QR code attached to the package PC.

In any case, the registrant who has received the mail can select a product for which information regarding the expiration date has been mailed from a plurality of products to be used.
The expiration date notification system 1 stores the e-mail address of the registrant in the database DB together with the expiration date of the product. Information on the registrant (consumer, customer) can be used to transmit information on a new product to a registrant whose use deadline is approaching, or to send an e-mail that prompts the user to purchase a new product.

The expiration date information notification system 1 is preferably managed by a supplier of goods, for example, a manufacturer and seller of insect repellents. In addition, even if a management company entrusted by a plurality of manufacturers and distributors performs, it is advantageous in terms of utilization of consumer data.
FIG. 9 is a flowchart showing the operation of another expiration date information notification system 1B, FIG. 10 is a diagram showing the data structure of the database DB in another expiration date information notification system 1B, and FIG. 11 is a flowchart of batch processing.

The expiration date information notification system 1B includes a communication unit 11, an internal storage unit 12, an information processing unit 13, and an external storage unit 14. These configurations are the same as those in the expiration date information notification system 1.
The expiration date information notification system 1B, when registering the product data transmitted from the consumer by the mobile phone HP in the database DB, information on the expiration date (expiration date LD, 3 days before the expiration date and 10 days before the expiration date). ) Is not calculated (see FIG. 9 in comparison with FIG. 3), and is different from the expiration date information notification system 1 in that these are not registered in the database (see FIG. 10 in comparison with FIG. 4).

  In the expiration date information notification system 1B, the expiration date check in the daily batch processing is performed every time the individual record data is read from the database DB (S31, S32), and the expiration date from the remaining usage number UD and the usage resumption date RU. The calculation is performed 3 days before the due date and 10 days before the due date (S33, S35, S37). In batch processing, record data that matches the search condition is stored in the storage area secured for each condition in the external storage means 14 with the mail address MA, the product item GA, or the product name corresponding to the product item GA and the registration date RD. (S34, S36, S38).

Transmission of the information regarding the expiration date to the mail address of the extracted data is the same as that in the expiration date information notification system 1 described above.
In the above-described embodiment, the email transmission related to the expiration date of the product may be any one or two times 10 days before, 3 days before, and the current date. For example, it may be two days before and one day before the expiration date. Do not set the date of determination in the batch processing regarding the expiration date as the current day (today in the computer's internal clock), for example, add the day to the current day as the date of determination, and send the corresponding product data to the mobile phone HP by email You may go to

A part of the data processing method of the expiration date information notification system 1 can be applied to the data processing method of the expiration date information notification system 1B, and a part of the data processing method of the expiration date information notification system 1B can be applied. It can be applied to the data processing method of the expiration date information notification system 1.
When the expiration date information notification system 1, 1B is used for managing the expiration date of food, medicine, etc., the suspension / resumption registration means 23 can be omitted from the expiration date information notification system 1, 1B. The database DB used for managing the expiration date of food, medicine, etc. does not have the data items of the use flag UF, the remaining use days UD, and the use resumption dates RU. In managing the expiration date of a product whose use can be interrupted, the expiration date information notification systems 1 and 1B that do not have the suspension / resumption registration means 23 may be provided by leaving the management regarding the suspension and resumption of use to the registrant.

Each component of the expiration date information notification system 1 can be replaced with another one as long as the above-described processing can be performed. The database DB can include other information such as a use interruption period.
The information attached to the product package or the like is not limited to the QR code, but other matrix type two-dimensional bar code or other graphic code that can be read by the camera attached to the mobile phone HP. It may be.

  In addition, the configuration of the expiration date information notification system 1 and the expiration date information notification system 1 or the overall structure, number, and the like can be changed as appropriate in accordance with the spirit of the present invention.

  INDUSTRIAL APPLICABILITY The present invention can be used for collective management by a product supplier such as the expiration date or the expiration date of a product or the like whose consumption period is determined or a food or the like whose consumption period is determined.

1 Expiration Date Information Notification System 11 Communication Unit 13 Information Processing Unit 14 Storage Unit (External Storage Unit)
DB Database DC Identification code HP Mobile phone LD Expiration date (expiration date)
E-mail address related to MA-managed products PT Valid days (use days)
RD reception date (registration date)
RU use start date (use resumption date)
UF Code indicating use of goods (usage flag)

Claims (5)

A communication means for sending and receiving emails to and from a mobile phone;
Storage means for storing the information of the mail received by the communication means as a database;
An information processing means for controlling the communication means and the storage means and processing the information of the mail in a predetermined procedure;
The information processing means includes
When the communication means receives a mail from a mobile phone that has read a matrix type two-dimensional barcode attached to a product, the mobile phone determines the reception date and the effective days of the product included as information in the matrix type two-dimensional barcode. Stored in the database in association with the email address of
For each day, it is determined whether or not today is the day before the effective date from the reception date in each data of the database and / or the date that is a predetermined number of days before the day after the effective date. If today's date is one of these, notify the mobile phone with the email address in the data that it is the expiration date of the product or that it is a predetermined number of days before the expiration date An expiration date information notification system characterized by being configured to do so. A communication means for sending and receiving emails to and from a mobile phone;
Storage means for storing the information of the mail received by the communication means as a database;
An information processing means for controlling the communication means and the storage means and processing the information of the mail in a predetermined procedure;
The information processing means includes
When the communication means receives an email from a mobile phone that reads a matrix type two-dimensional barcode attached to a product,
Search the data already stored in the database for the one whose email address matches the email address of the received email,
If no match is extracted, the e-mail is sent with the date of receipt of the e-mail as the start date of use, the number of valid days of merchandise included as information in the matrix type two-dimensional barcode, and a code indicating the use of the merchandise. Storing it in the database in association with the email address of the mobile phone;
If a match is extracted, if the code of the data indicates product use, it is rewritten with a product non-use code and the number of days elapsed from the start date of use to the date of receipt of the email is reduced. Rewrite the effective days with the effective days, or rewrite the product use code if the code of the data indicates that the product is not used, and rewrite the use start date on the date of receipt of the email,
For each day, the date of the database for which the code indicates the use of the product is the day before the day when the effective day has passed since the start date of use and / or the day before the day when the effective day has passed. If today is any of these, it is the expiration date of the product for the mobile phone with the email address in the data or a predetermined number of days before the expiration date The expiration date information notification system is configured to notify by e-mail that it is the day of the expiration date. The storage means
An identification code associated with the email address is configured to be stored in a database;
The information processing means includes
When the communication means receives an email from the mobile phone,
Search the data already stored in the database for an identification code and an e-mail address that match the identification code and e-mail address sent by the e-mail, both of which are included in the matrix type two-dimensional barcode as information. ,
If a match is not extracted, the email information is processed in the predetermined procedure,
3. Expiration date information according to claim 1 or 2, wherein when a match is extracted, notification is made that the mobile phone of the received mail has already been registered. Notification system. An expiration date notification method for a computer,
When an e-mail addressed to the e-mail address is received from a mobile phone that has read a matrix type two-dimensional barcode that records the e-mail address attached to the product and the number of days the product has been used,
Storing in the database the date of receipt of the email and the valid days of the product included as information in the matrix type two-dimensional barcode in association with the email address of the mobile phone that sent the email;
For each day, it is determined whether or not today is the day before the effective date from the reception date in each data of the database and / or the date that is a predetermined number of days before the day after the effective date. If today's date is one of these, notify the mobile phone with the email address in the data that it is the expiration date of the product or that it is a predetermined number of days before the expiration date An expiration date notification method characterized by: An expiration date notification method for a computer,
When an e-mail addressed to the e-mail address is received from a mobile phone that has read a matrix type two-dimensional barcode that records the e-mail address attached to the product and the number of days the product has been used,
Search the data already stored in the database for the one whose email address matches the email address of the received email,
If no match is extracted, the e-mail is sent with the date of receipt of the e-mail as the start date of use, the number of valid days of merchandise included as information in the matrix type two-dimensional barcode, and a code indicating the use of the merchandise. Storing it in the database in association with the email address of the mobile phone;
If a match is extracted, if the code of the data indicates product use, it is rewritten with a product non-use code and the number of days elapsed from the start date of use to the date of receipt of the email is reduced. Rewrite the effective days with the effective days, or rewrite the product use code if the code of the data indicates that the product is not used, and rewrite the use start date on the date of receipt of the email,
For each day, the date of the database for which the code indicates the use of the product is the day before the day when the effective day has passed since the start date of use and / or the day before the day when the effective day has passed. If today is any of these, it is the expiration date of the product for the mobile phone with the email address in the data or a predetermined number of days before the expiration date Notification method of expiration date information, which is notified by e-mail that the date is