JP2006293772A - Commodity information display system, server, shopping cart, and commodity information display method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a commodity information display system and method, a server, and a shopping cart wherein commodity management information which is unique to a store and stored in the server can be presented at a terminal device of the shopping cart in accordance with the personal needs of a customer while being updated in real time. <P>SOLUTION: A commodity 201 is put in the shopping cart 200. When IC information read from an IC tag 202 of the commodity 201 is transmitted to a database server 10, the database server 10 decrements by one a remaining quantity being a management item of the commodity 201. When receiving the commodities 201, the store adds the quantity of the received commodities to the remaining quantity in the database server 10 by use of a keyboard 14 or a mouse 15. Consequently, the remaining quantity indicating a total quantity (sum of a display quantity and a stock quantity) to be sold with respect to the commodity 201 at the store can be displayed on the terminal device 100 with real-time accuracy. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a product information display system that displays character information received from a server in a shopping cart, a server, a shopping cart, and a product information display method.

  Traditionally, in sales floors such as supermarkets and mass merchandisers, products that customers want to purchase are put in the shopping carts provided and carried around the store, and it is a physical burden to carry many products Was big.

Therefore, in the technology described in Patent Document 1, in a store, a customer brings a handy terminal close to a non-contact IC tag of a product, receives product information from the non-contact IC tag, and displays the product information on the handy terminal. To decide whether or not to purchase the product.
Japanese Patent Laid-Open No. 2002-8134

  Then, the cash settlement process at the cash register can be performed efficiently in a short time because it is only necessary to hand over the handy terminal to the person in charge.

  Furthermore, in the non-contact type IC tag, stock data for each product item is stored, and when the product is sold, the number of sales is subtracted from the stock data for each product item, or purchase cancellation of the product is performed. When confirmed, the inventory data is added by the amount canceled, so that the latest inventory data can always be managed.

  However, since the content displayed on the handy terminal is stored in the non-contact IC tag of the product, it is difficult to provide information on the product in response to the customer's request while widely developing the information. Since the inventory data displayed on the handy terminal is also stored in the non-contact type IC tag of the product, there is a limit in reflecting the arrival data on the inventory data in real time.

  Therefore, the present invention has been made in view of the above-described points, and presents it to the terminal device of the shopping cart according to the customer's individual needs while updating the store-specific product management information stored in the server in real time. An object of the present invention is to provide a product information display system, a server, a shopping cart, and a product information display method.

  In the invention according to claim 1 made to solve this problem, a terminal device (for example, terminal device 100) provided in a shopping cart (for example, shopping cart 200) is a server (for example, database server 10). Product information display system (for example, product information display system 1) that performs wireless communication with the terminal device (for example, the terminal device 100), the cart side input by the terminal device (for example, the terminal device 100) By transmitting the input data to the server (for example, the database server 10), one or a plurality of character information about the product related to the contents of the cart side input data is received from the server (for example, the database server 10). Are displayed as a hierarchical menu, and are displayed on the terminal device (for example, the terminal device 100). The product data read from the product is transmitted to the server (for example, the database server 10), while the server (for example, the database server 10) receives the product data received from the terminal device (for example, the terminal device 100) or Based on server-side input data input by the server (for example, database server 10), product management information in one or more character information related to the product data or a product related to the contents of the server-side input data is updated. It is characterized by that.

  The invention according to claim 2 performs wireless communication with a terminal device (for example, the terminal device 100) provided in a shopping cart (for example, the shopping cart 200), and at the terminal device (for example, the terminal device 100). Product information display system (for example, product information display) for receiving from the terminal device (for example, the terminal device 100) the input data on the cart side or the product data read from the product by the terminal device (for example, the terminal device 100) System 1) server (for example, database server 10), wherein one or a plurality of character information about products displayed as a hierarchical menu on the terminal device (for example, terminal device 100) is the content of the cart side input data Stored directly or indirectly in association with a database (eg, an advertisement file 1, product file 41, dish list file 51, dish file 61, material file 71) and one or more characters relating to the goods related to the contents of the cart side input data received from the terminal device (for example, terminal device 100). Characters to be transmitted from the database (for example, advertisement product file 31, product file 41, dish list file 51, dish file 61, material file 71) to the terminal device (for example, terminal device 100) as the hierarchical menu. Information communication means (for example, communication circuit 25), server-side input means for inputting server-side input data (for example, keyboard 14, mouse 15), and product data received from the terminal device (for example, terminal device 100) or Input by the server side input means (for example, keyboard 14 and mouse 15) Updating means (for example, CPU 21, S263, S292) for updating product management information in one or more character information relating to the product data or the product related to the content of the server-side input data based on the server-side input data; It is characterized by having.

  In the invention according to claim 3, one or a plurality of character information relating to the product is stored in association with the contents of the cart side input data, and the product management information in the character information is stored in the product data. Shopping cart (for example, product information display system 1) provided with a terminal device (for example, terminal device 100) that performs wireless communication with a server (for example, database server 10) that is updated based on the shopping cart (for example, product information display system 1) , A shopping cart 200), wherein the terminal device (for example, the terminal device 100) includes a reading unit (for example, a reader 167) that reads the product data from a product, and a cart side input unit that inputs the cart side input data. (For example, buttons 105-110, touch panel 111, button 112) and the reader The product data read by (for example, the reader 167) or the cart side input data input by the cart side input means (for example, the buttons 105 to 110, the touch panel 111, the button 112) is used as the server (for example, the database server 10). ) Data communication means (for example, wireless communication circuit 164) to be transmitted to the device, and one or a plurality of character information relating to the product related to the contents of the cart side input data transmitted by the data communication means (for example, wireless communication circuit 164). It is characterized by comprising display means (for example, a liquid crystal display 102) that receives from the server (for example, the database server 10) and displays it as a hierarchical menu.

  Further, the invention according to claim 4 displays character information about the product stored in the server (for example, the database server 10) on the terminal device (for example, the terminal device 100) of the shopping cart (for example, the shopping cart 200). A product information display method for reading product data from products with the terminal device (for example, the terminal device 100), and cart side input data with the terminal device (for example, the terminal device 100). Cart side input process (for example, S104, S124, S128, S132, S174, S178, S182), the product data read in the reading process (for example, S61) or the cart side input process (for example, S104) , S124, S128, S132, S174, S178, S182) The data communication process (for example, S105, S125, S129, S133, S161, S175, S179, and the like) that transmits the cart side input data from the terminal device (for example, the terminal device 100) to the server (for example, the database server 10). S183) and one or more character information relating to the product related to the contents of the cart side input data received in the data communication step (for example, S105, S125, S129, S133, S161, S175, S179, S183) A character information communication process (for example, S206, S226, S229, S232, S264, S276, S279, S282) transmitted from the (for example, the database server 10) to the terminal device (for example, the terminal device 100), and the character information Communication process (for example, S206, S 26, S229, S232, S264, S276, S279, S282) display step (for example, S107, S127) for displaying one or a plurality of character information relating to the product on the terminal device (for example, terminal device 100) as a hierarchical menu. , S131, S135, S177, S181, S185), a server-side input process (for example, S291) for inputting server-side input data at the server (for example, the database server 10), and the data communication process (for example, S161). ) Or one or more characters related to the product related to the product data or the contents of the server-side input data based on the product data received in step S) or the server-side input data input in the server-side input step (eg, S291). Product management information in the information is stored in the server (for example, database Update server (for example, S263, S292) that is updated by the network server 10).

  That is, in the product information display system, the server, the shopping cart, and the product information display method of the present invention, the product management information unique to the store stored in the server is updated in real time to meet the needs of the customer. Can be presented to the terminal device.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing a product information display system 1 according to the present embodiment. The product information display system 1 according to the present embodiment is constructed in a store, and as shown in FIG. 1, a database server 10, a terminal device 100, and a shopping cart fixed to the terminal device 100 200, an IC tag 202 attached to the product 201 and storing a product code, a gate 203 installed near the entrance in the store, an access point 204, a local area network N, and the like.

  In this respect, the database server 10 includes a main body 11, an external storage device 12, a display 13, a keyboard 14, a mouse 15, and the like.

  In addition, the database server 10 and a plurality of access points 204 are connected to the local area network N, whereby the database server 10 and the terminal device 100 are connected via the plurality of access points 204. Wireless communication is performed between them. A plurality of shopping carts 200 are prepared in the store, and one terminal device 100 is fixed in each shopping cart 200. Accordingly, the database server 10 performs wireless communication individually with the plurality of terminal devices 100.

  FIG. 9 is a front view showing terminal device 100 of product information display system 1 according to the present embodiment. As illustrated in FIG. 9, the terminal device 100 includes an antenna 101, liquid crystal displays 102, 103, 104, an advertisement button 105, a cooking button 106, a purchase button 107, a cursor button 108, a ten button 109, a decision button 110, a liquid crystal A touch panel 111 and a home button 112 provided on the display 102 are provided.

  FIG. 2 is a block diagram showing terminal device 100 of product information display system 1 according to the present embodiment. As illustrated in FIG. 2, in the terminal device 100, a ROM 162, a RAM 163, an I / O 170, and the like are connected to the CPU 161.

The CPU 161 is a central processing unit that controls the terminal device 100.
The ROM 162 is a nonvolatile read-only memory that stores an arithmetic program for operating a flowchart described later.
The RAM 163 is a memory that temporarily stores various data calculated by the CPU 161.

  The I / O 170 is a connection unit to which a wireless communication circuit 164, a touch panel drive circuit 165, a display control circuit 166, a reader 167, a button switch circuit 168, a gate sensor 169, and the like are connected. Further, the antenna 101 is connected to the wireless communication circuit 164, the touch panel 111 is connected to the touch panel drive circuit 165, and the liquid crystal displays 102, 103, and 104 are connected to the display control circuit 166.

  The wireless communication circuit 164 performs data communication with the database server 10 or the like via the local area network N by performing wireless communication between the antenna 101 and the access point 204 (see FIG. 1). Circuit.

  The touch panel drive circuit 165 creates and outputs coordinate position information of a portion touched by the touch panel 111, and is a circuit for performing selection input for an item displayed on the liquid crystal display 102 by touch on the touch panel 111. .

The display control circuit 166 is a circuit for controlling the liquid crystal displays 102, 103, and 104. The liquid crystal display 102 is a main display on which various information is displayed. The liquid crystal display 103 is a sub display on which comment information is displayed. The liquid crystal display 104 is a sub-display that displays the number of pages of content being displayed on the liquid crystal display 102.
The reader 167 is a device that reads the stored contents of the IC tag 202 (see FIG. 1) attached to the product 201 (see FIG. 1) in a non-contact manner.

  Although the button switch circuit 168 is omitted in FIG. 2, the advertisement button 105 (see FIG. 9), the cooking button 106 (see FIG. 9), the purchase button 107 (see FIG. 9), and the cursor button 108 (see FIG. 9). Reference button), the ten button 109 (see FIG. 9), the enter button 110 (see FIG. 9), and the home button 112 (see FIG. 9), and is pressed when any of those buttons is pressed. It creates and outputs a switch signal that identifies the selected button.

  The gate sensor 169 generates and outputs a detection signal when the gate 203 (see FIG. 1) installed near the entrance in the store is detected, so that the shopping cart 200 (see FIG. 1) has the gate 203 (see FIG. 1). (See below).

  FIG. 3 is a block diagram showing the database server 10 of the product information display system 1 according to the present embodiment. As shown in FIG. 3, the database server 10 includes a main body 11, an external storage device 12, a display 13, a keyboard 14, a mouse 15, and the like. Further, in the main body 11, a ROM 22, a RAM 23, an I / O 24, and the like are connected to the CPU 21.

The CPU 21 is a central processing unit that controls the database server 10.
The ROM 22 is a non-volatile read-only memory in which an arithmetic program for operating a flowchart described later is stored.
The RAM 23 is a memory that temporarily stores various data calculated by the CPU 21.

The I / O 24 is a connection unit to which the communication circuit 25, the display control circuit 26, the keyboard 14, the mouse 15, the external storage device 12, and the like are connected.
The communication circuit 25 is a circuit for performing data communication with each information acquisition apparatus 100 and the like via the local area network N.

The display control unit 26 is a circuit for controlling the display 13.
The keyboard 14 and the mouse 15 are devices for inputting input data.

  The external storage device 12 is a device that stores a plurality of files that are accumulated and organized in large quantities. These files include, for example, the advertisement product file 31 shown in FIG. 4, the product file 41 shown in FIG. 5, the dish list file 51 shown in FIG. 6, the dish file 61 shown in FIG. 7, and the material file 71 shown in FIG. and so on.

  FIG. 4 is a diagram showing a part of the structure of the advertisement product file 31 stored in the external storage device 12 of the database server 10 in the product information display system 1 according to the present embodiment. As shown in FIG. 4, the advertisement product file 31 is provided with a record 32 in which product codes are stored.

  The product code stored in the record 32 of the advertisement product file 31 is data for specifying a product handled in the main store, and is data indicating a special sale item posted in the advertisement of the main store.

  FIG. 5 is a diagram showing a part of the structure of the product file 41 stored in the external storage device 12 of the database server 10 in the product information display system 1 according to the present embodiment. As shown in FIG. 5, the product file 41 stores a record 42 storing a product code, a record 43 storing a product name, a record 44 storing a unit price, and a display position designation code. Record 45, a record 46 storing the remaining number, a record 47 storing the cooking code, and the like.

  The product code stored in the record 42 of the product file 41 is data for specifying a product handled at the main store. The product name stored in the record 43 of the product file 41 is the name of the product specified by the product code. The unit price stored in the record 44 of the product file 41 is a price per unit of the product specified by the product code. The display position designation code stored in the record 45 of the product file 41 is data for specifying the position in the store where the product specified by the product code is displayed. The remaining number stored in the record 46 of the product file 41 is the total number of products that can be sold at the main store, and is the sum of the number of displays and the number of stocks. Further, the dish code stored in the record 47 of the product file 41 is data for identifying a dish that uses the product specified by the product code as a material.

  The product file 41 is created for each type of product handled at the main store and stored in the external storage device 12 of the database server 10.

  FIG. 6 is a diagram showing a part of the structure of the dish list file 51 stored in the external storage device 12 of the database server 10 in the product information display system 1 according to the present embodiment. As shown in FIG. 6, the dish list file 51 is provided with a field 53 storing a dish code and a field 54 storing a dish name in association with each record 52.

  The dish code stored in the field 53 of each record 52 of the dish list file 51 is data for identifying a dish. Further, the dish name stored in the field 54 of each record 52 of the dish list file 51 is the name of the dish specified by the dish code in the field 53 of the same record 52.

  FIG. 7 is a diagram showing a part of the structure of the dish file 61 stored in the external storage device 12 of the database server 10 in the product information display system 1 according to the present embodiment. As shown in FIG. 7, the dish file 61 is provided with a record 62 in which a dish code is stored and a record 63 in which a dish name is stored. Further, in each record 64, a material code is stored. Field 65, a field 66 storing material names, and a field 67 storing quantities are provided in association with each other.

  The dish code stored in the record 62 of the dish file 61 is data for identifying a dish. The dish name stored in the record 63 of the dish file 61 is the name of the dish specified by the dish code. In addition, the material code stored in the field 65 of the record 64 of the dish file 61 is data that identifies the material used in the dish specified by the dish code. Further, the material name stored in the field 66 of the record 64 of the dish file 61 is the name of the material specified by the material code stored in the field 65 of the same record 64 in the dish specified by the dish code. It is. Further, the amount stored in the field 67 of the record 64 of the dish file 61 is the amount of the material specified by the material code stored in the field 65 of the same record 64 in the dish specified by the dish code ( 1 person).

  The dish file 61 is created for each dish stored in the dish list file 51 (see FIG. 6) and stored in the external storage device 12 of the database server 10.

  FIG. 8 is a diagram showing a part of the structure of the material file 71 stored in the external storage device 12 of the database server 10 in the product information display system 1 according to the present embodiment. As shown in FIG. 8, the material file 71 is provided with a record 72 storing a material code, a record 73 storing a product code, and the like.

  The material code stored in the record 72 of the material file 71 is data for specifying the material. The product code stored in the record 73 of the material file 71 is data for specifying a product handled at the main store, and is a code for specifying a product that can be used as a material specified by the material data.

  The material file 71 is created for each material code stored in each dish file 61 (see FIG. 7) and stored in the external storage device 12 of the database server 10.

  Next, functions of the product information display system 1 according to the present embodiment will be described. 9 to 18 are front views showing the terminal device 100 of the product information display system 1 according to the present embodiment, and show examples of display contents of the liquid crystal displays 102, 103, and 104.

  In the store where the product information display system 1 according to the present embodiment is constructed, when a customer pulls the shopping cart 200 and enters from the entrance and passes through the gate 203, the terminal device fixed to the shopping cart 200 In the liquid crystal display 102 of 100, the state is changed from the state in which the cover screen shown in FIG. 9 is displayed to the state in which the advertisement item list screen shown in FIG. 10 is displayed.

  Even if the customer presses the advertisement item button 105 of the terminal device 100 fixed to the shopping cart 200, the advertisement item list screen shown in FIG. 10 is displayed on the liquid crystal display 102 of the terminal device 100. The state is changed.

  Here, the advertisement item list screen shown in FIG. 10 refers to a list screen displaying the special sale items and unit prices posted in the advertisement of the head office. At this time, the character data “displaying advertisement item” is displayed. Is displayed on the liquid crystal display 103 to inform the customer of that fact. Therefore, “banana”, “clam”, “spinach”, “△△ curry”, “shoe under”, and “umbrella” in the advertisement list screen shown in FIG. It is a product for sale.

  Further, the number of pages of the advertisement item list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 10, the character data “1/3 page” is displayed on the liquid crystal display 104, so that the number of pages of the advertisement item list screen displayed on the liquid crystal display 102 is the first page out of all three pages. Informing customers that there is. If the cursor button 108 is pressed, the number of pages of the advertisement item list screen displayed on the liquid crystal display 102 can be changed.

  Then, when one of the sale items (products) in the advertisement item list screen shown in FIG. 10 is selected via the touch panel 111, the advertisement item shown in FIG. 10 is displayed on the liquid crystal display 102 of the terminal device 100. The state shifts from the state where the list screen is displayed to the state where the display position screen shown in FIG. 11 is displayed.

  Here, the display position screen shown in FIG. 11 refers to a screen of a layout diagram that displays the position in the store where the special sale item (product) selected on the touch panel 111 is displayed, and the display position is hatched. This is indicated by part 121. Furthermore, at this time, the remaining number is displayed on the liquid crystal display 102, and the total number (the sum of the number of displays and the number of stocks) that can be sold at the main store is displayed. . Therefore, on the display position screen shown in FIG. 11, the special sale item (product) selected on the touch panel 111 is displayed at one end of the display shelf B and can be sold at the main store (the display number and the display number). The customer can be informed that the sum of the stock quantity is “213 boxes”.

  Since there is no continuation on the display position screen, the character data of “1/1 page” is displayed on the liquid crystal display 104, so that the number of pages of the display position screen displayed on the liquid crystal display 102 is one page in total. The customer is informed that it is the first page.

  On the other hand, when the customer puts the product 201 in the shopping cart 200, the related dish list screen shown in FIG. 12 is displayed on the liquid crystal display 102 of the terminal device 100 fixed to the shopping cart 200. Transition to the state.

  Here, the related dishes list screen shown in FIG. 12 refers to a list screen that displays dishes made from the products 201 put in the shopping cart 200. FIG. 12 shows an example in which the product 201 is “pork”. Therefore, “Curry”, “Vinegar pork”, “Potofu”, “Roll” in the related dishes list screen shown in FIG. “Cabbage”, “White Stew”, and “Vinegared Pork” are dishes made from “pork”.

  Further, the number of pages of the related dish list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 12, the character data of “1/2 page” is displayed on the liquid crystal display 104, so that the number of pages of the related dish list screen displayed on the liquid crystal display 102 is the first page out of the total of two pages. Informing customers that there is. If the cursor button 108 is pressed, the number of pages of the related dish list screen displayed on the liquid crystal display 102 can be changed.

  When one of the dishes in the related dish list screen shown in FIG. 12 is selected via the touch panel 111, the related dish list screen shown in FIG. 12 is displayed on the liquid crystal display 102 of the terminal device 100. From this state, the material list screen shown in FIG. 13 is displayed.

  Here, the material list screen shown in FIG. 13 refers to a list screen displaying the ingredients of the dish selected on the touch panel 111. FIG. 13 shows an example in which the dish selected on the touch panel 111 is “pork soup”. Therefore, “pork (sliced)”, “miso” in the material list screen shown in FIG. “Fried deep-fried”, “green onion”, “radish” and “carrot” are ingredients of “pork soup” which is a dish.

  Further, the number of pages of the material list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 13, the character data “1/2 page” is displayed on the liquid crystal display 104, so that the number of pages of the dish list screen displayed on the liquid crystal display 102 is the first page of the two pages. To inform customers. If the cursor button 108 is pressed, the number of pages of the material list screen displayed on the liquid crystal display 102 can be changed.

  When one of the materials in the material list screen shown in FIG. 13 is selected via the touch panel 111, the material list screen shown in FIG. 13 is displayed on the liquid crystal display 102 of the terminal device 100. From the state, the product list screen shown in FIG. 14 is displayed.

  Here, the product list screen shown in FIG. 14 refers to a list screen displaying products and unit prices corresponding to the material selected on the touch panel 111. FIG. 14 shows an example of the case where the material selected on the touch panel 111 is “carrot”. Therefore, “carrot (produced by XX)” and “carrot (○) in the product list screen shown in FIG. X production) is a product that falls under the material of “carrot”.

  Further, the number of pages of the product list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 14, since the product list screen does not continue, the number of pages of the product list screen displayed on the liquid crystal display 102 by displaying the character data “1/1 page” on the liquid crystal display 104. Is the first page of all pages.

  At this time, the cursor 122 blinks and the character “person” is displayed on the liquid crystal display 103 of the terminal device 100, and a numeric value is input with the ten button 109 at the position where the cursor 122 blinks. When the input is confirmed by the enter button 110, the liquid crystal display 103 of the terminal device 100 shifts from the state shown in FIG. 14 to the state shown in FIG.

  In the state shown in FIG. 15, in the dish selected on the dish-related list screen (see FIG. 12), the necessary number of ingredients selected on the material list screen (see FIG. 13) is the number of persons entered. Is displayed. In the state shown in FIG. 15, an example is shown in which the number “4” is input with the ten button 109 and the input is confirmed with the decision button 110 in the state shown in FIG. 14. That is, “1/2 bottle 60 g” displayed on the liquid crystal display 103 in FIG. 15 indicates the necessary amount of “carrot” necessary for “pork soup” serving as a dish for four persons.

  When one of the products in the product list screen shown in FIG. 14 or FIG. 15 is selected via the touch panel 111, the product shown in FIG. 14 or 15 is displayed on the liquid crystal display 102 of the terminal device 100. The state shifts from the state where the list screen is displayed to the state where the display position screen shown in FIG. 16 is displayed.

  Here, the display position screen shown in FIG. 16 refers to a screen of a layout diagram that displays the position in the store where the product selected on the touch panel 111 is displayed, and the display position is indicated by the hatched portion 121. It is. Furthermore, at this time, the remaining number is displayed on the liquid crystal display 102, and the total number of items that can be sold at the main store (the sum of the number of displays and the number of stocks) is displayed. Therefore, the products selected on the touch panel 111 are displayed on a part of the display shelf A by the display position screen shown in FIG. 16, and can be sold at the main store (the number of displays and the number of stocks). The customer can be informed that the sum is 72.

  Since there is no continuation on the display position screen, the character data of “1/1 page” is displayed on the liquid crystal display 104, so that the number of pages of the display position screen displayed on the liquid crystal display 102 is one page in total. The customer is informed that it is the first page.

  On the other hand, when the customer presses the purchase button 107 of the terminal device 100 fixed to the shopping cart 200, the purchase list screen shown in FIG. 17 is displayed on the liquid crystal display 102 of the terminal device 100. Transition to the state.

  Here, the purchase list screen shown in FIG. 17 refers to a screen of a list that displays details such as the product 201 put in the shopping cart 200, its number (or quantity), and its price. Or, when there are a plurality of quantities), the unit price is also displayed. In FIG. 17, the details of the product 201 put in the shopping cart 200 are “△ □ bread” with “1” and “148” yen, unit price “194” yen with “× ○ milk” is “2”. It shows that “ground beef” of “388” yen and unit price “98” yen / “100 g” is “120 g” and “117” yen.

  Further, the liquid crystal display 103 displays the total price of the products 201 put in the shopping cart 200. In FIG. 17, when the details of the product 201 put in the shopping cart 200 are “△ □ bread” is “1”, “× ○ milk” is “2”, and “ground beef” is “120 g”. The total amount is indicated as “Total 653 yen”.

  Further, the number of pages of the purchase list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 17, since the purchase list screen does not continue, the character data “1/1 page” is displayed on the liquid crystal display 104, whereby the purchase list screen displayed on the liquid crystal display 102 is displayed. The customer is informed that the number of pages is the first of all one page.

  On the other hand, when the customer presses the dish button 106 of the terminal device 100 fixed to the shopping cart 200, the dish list list screen shown in FIG. 18 is displayed on the liquid crystal display 102 of the terminal device 100. Migrate to

  Here, the dish list list screen shown in FIG. 18 is a display of a material list screen (see FIG. 13), a product list screen (see FIG. 14), or a display position screen (see FIG. 16) on the terminal device 100. This is a list screen that shows the dishes you will get. In FIG. 18, the character data of “hamburger”, “pork soup”, “vinegared pork”, “mapo tofu”, “fried oysters”, and “meat potato” are displayed on the liquid crystal display 102. It is known that the terminal device 100 can display a list screen (see FIG. 13), a product list screen (see FIG. 14), and a display position screen (see FIG. 16).

  Further, the number of pages of the dish list screen displayed on the liquid crystal display 102 is displayed on the liquid crystal display 104. In FIG. 18, the character data “page 1/12” is displayed on the liquid crystal display 104, so that the number of pages of the dish list screen displayed on the liquid crystal display 102 is the first page out of all 12 pages. Informing customers that there is. If the cursor button 108 is pressed, the number of pages of the dish list screen displayed on the liquid crystal display 102 can be changed.

  When one of the dishes in the dish list screen shown in FIG. 18 is selected via the touch panel 111, the dish list list screen shown in FIG. 18 is displayed on the liquid crystal display 102 of the terminal device 100. From this state, the material list screen shown in FIG. 13 is displayed. Since the subsequent steps are the same as those described above, description thereof is omitted.

  On the other hand, when the customer presses the home button 112 of the terminal device 100 fixed to the shopping cart 200, the cover screen shown in FIG. 9 is displayed on the liquid crystal display 102 of the terminal device 100. Transition.

Next, a flowchart of a program for realizing the function of the product information display system 1 according to the present embodiment will be described.
FIG. 19 is a flowchart of a writing process program executed by the database server 10 of the product information display system 1 according to the present embodiment. The writing process program shown in the flowchart in FIG. 19 is read from the ROM 22 and executed by the CPU 21.

  In the write processing program, as shown in FIG. 19, first, in S291, it is determined whether or not there is a write request for accumulated data. Here, the accumulated data write request is a new creation or content change of the advertisement product file 31, the product file 41, the dish list file 51, the dish file 61, and the material file 71 stored in the external storage device 12. This is to request updating, and is performed by inputting data with the keyboard 14 or the mouse 15.

  If it is determined that there is no request for writing stored data (S291: NO), the write processing program is terminated without doing anything. On the other hand, if it is determined that there is a request to write stored data (S291: YES), the process proceeds to S292.

  In S292, the stored data is written, and then the write processing program is terminated. Here, the writing of the accumulated data means that the advertisement file 31, the product file 41, the dish list file 51, the dish file 61, and the material file 71 stored in the external storage device 12 are newly created or the contents are changed / updated. At this time, it is performed by inputting data with the keyboard 14 or the mouse 15 according to the contents displayed on the display 13.

  Thus, when the database server 10 of the product information display system 1 according to the present embodiment performs the writing process of FIG. 19, the store side displays the contents of the advertisement every time an advertisement is issued / distributed. The contents of the advertisement file 31 can be changed according to the product price, the contents of the product file 41 can be changed according to the change of the unit price of the product, the display position change, etc. The product file 41 of the product can be newly created, and the dish list file 51, the dish file 61, and the material file 71 can be expanded / reduced / modified. In particular, when a new product is received, the total number of items that can be sold at the main store (the number of displays and stock) is added to the remaining number stored in the record 46 in the product file 41. The real-time property of the sum of numbers) can be maintained.

  FIG. 20 is a flowchart of a display control processing program executed by the terminal device 100 of the product information display system 1 according to this embodiment. 20 is read from the ROM 162 and executed by the CPU 161.

  In the display control processing program, as shown in FIG. 20, first, in S11, it is determined whether or not the gate has passed. This determination is made based on whether or not the gate 203 is detected by the gate sensor 169. Here, when it is determined that the gate has passed (S11: YES), the process proceeds to S12, and after performing the advertisement display process of FIG. 21 described later, the display control process program is terminated. On the other hand, when it determines with not having passed through the gate (S11: NO), it progresses to S21.

  In S21, it is determined whether or not the advertisement item button 105 has been pressed. This determination is made based on a switch signal from the button switch circuit 168. If it is determined that the advertisement button 105 has been pressed (S21: YES), the process proceeds to S12, and after performing the advertisement display process of FIG. 21 described later, the display control processing program is terminated. On the other hand, when it determines with the advertisement button 105 not being pressed down (S21: NO), it progresses to S31.

  In S31, it is determined whether or not the cooking button 106 has been pressed. This determination is made based on a switch signal from the button switch circuit 168. If it is determined that the dish button 106 has been pressed (S31: YES), the process proceeds to S32, and after performing the dish list display process of FIGS. 22 and 23 described later, the display control processing program is terminated. . On the other hand, if it is determined that the cooking button 106 has not been pressed (S31: NO), the process proceeds to S41.

  In S41, it is determined whether or not the purchase button 107 is pressed. This determination is made based on a switch signal from the button switch circuit 168. If it is determined that the purchase button 107 has been pressed (S41: YES), the process proceeds to S42, and after performing a purchase display process of FIG. 24 described later, the display control processing program is terminated. On the other hand, if it is determined that the purchase button 107 is not pressed (S41: NO), the process proceeds to S51.

  In S51, it is determined whether or not the home button 112 has been pressed. This determination is made based on a switch signal from the button switch circuit 168. If it is determined that the home button 112 has been pressed (S51: YES), the process proceeds to S52, and after performing a cover screen display process of FIG. 25 described later, the display control processing program is terminated. On the other hand, when it is determined that the home button 112 is not pressed (S51: NO), the process proceeds to S61.

  In S61, it is determined whether or not the IC tag 202 is detected. This determination is made based on whether or not the content stored in the IC tag 202 has been read by the reader 167. If it is determined that the IC tag 202 is not detected (S61: NO), the display control processing program is terminated without doing anything. On the other hand, if it is determined that the IC tag 202 has been detected (S61: YES), in S62, the purchase sheet creation process of FIG.

  In S63, it is determined whether or not the cover screen (see FIG. 9) is displayed on the liquid crystal display 102. This determination is made from a control signal immediately before instructing the display control circuit 166 or the like. If it is determined that the cover screen (see FIG. 9) is not displayed on the liquid crystal display 102 (S63: NO), the display control processing program is terminated without doing anything. On the other hand, when it is determined that the cover screen (see FIG. 9) is displayed on the liquid crystal display 102 (S61: YES), after performing the related dish display process of FIGS. 27 and 28 described later in S64. Then, the display control processing program is terminated.

  FIG. 21 is a flowchart of an advertisement display processing program executed by the terminal device 100 and the database server 10 of the product information display system 1 according to this embodiment. 21 is read from the ROM 162 and executed by the CPU 161 in the terminal device 100, and is read from the ROM 22 and executed by the CPU 21 in the database server 10.

  In the advertisement display processing program, as shown in FIG. 20, first, in S <b> 101, the terminal device 100 transmits data requesting advertisement item list data to the database server 10.

  On the other hand, in S201, the database server 10 determines whether or not the data requesting the advertisement item list data has been received from the terminal device 100. Here, if it is determined that the data for requesting the advertisement item list data has not been received from the terminal device 100 (S201: NO), the process proceeds to S204 described later without doing anything. On the other hand, when it is determined that the data requesting the advertisement item list data is received from the terminal device 100 (S201: YES), the process proceeds to S202.

  In S202, the database server 10 searches the external storage device 12 for data necessary for creating the advertisement item list data. Specifically, the advertisement product file 31 stored in the external storage device 12 is searched, the product code stored in the record 32 of the advertisement product file 31 is read, and the product code stored in the record 42 is read. The file 41 is searched, and the product name stored in the record 43 of the product file 41 and the unit price stored in the record 43 of the product file 41 are read. At this time, when a plurality of product codes are read from the advertisement product file 31, the product name and unit price are read based on each product code as described above.

  Thereafter, in S <b> 203, the database server 10 creates advertisement product list data from the read product code, product name, unit price, and the like, and transmits the created advertisement product list data to the terminal device 100.

  On the other hand, in the terminal device 100, in S102, it is determined whether or not the advertisement list data has been received from the database server 10. If it is determined that the advertisement item list data has not been received from the database server 10 (S102: NO), the process returns to S102 itself and the above-described determination is repeated. On the other hand, if it is determined that the advertisement item list data has been received from the database server 10 (S102: YES), the process proceeds to S103, and the advertisement item list screen is displayed on the liquid crystal display 102 based on the advertisement item list data.

  In this regard, FIG. 10 shows an example of the advertisement item list screen displayed on the liquid crystal display 102. When the advertisement item list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104. The display content is controlled by the terminal device 100 based on the advertisement item list data.

  Thereafter, in S104, it is determined whether or not the touch panel 111 is touched in the terminal device 100. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S104: NO), the process returns to S104 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S104: YES), it progresses to S105.

  In S <b> 105, the terminal device 100 transmits to the database server 10 data requesting display position data for the sale item (product) designated on the touch panel 111. The data indicating that the display position data for the special sale item (product) is requested includes the touch panel drive circuit 165 among one or a plurality of special sale items (product) in the advertisement item list screen displayed on the liquid crystal display 102. The product code of the special sale item (product) specified by the coordinate position information from is included.

  On the other hand, in S <b> 204, the database server 10 determines whether or not the data requesting display position data for the special sale item (product) is received from the terminal device 100. Here, if it is determined that data indicating that display position data for a special sale item (product) is not received from the terminal device 100 (S204: NO), the advertisement display processing program is performed without doing anything. Exit. On the other hand, if it is determined that data indicating that display position data for a special sale item (product) is requested from the terminal device 100 (S204: YES), the process proceeds to S205.

  In S205, the database server 10 searches the external storage device 12 for data necessary for creating display position data for a special sale item (product). Specifically, the product file 41 in which the product code included in the data requesting display position data for the special sale product (product) is stored in the record 42 is searched, and the record 45 of the product file 41 is stored in the record 45. The stored display position designation code and the remaining number stored in the record 46 of the product file 41 are read out.

  Thereafter, in S206, the database server 10 creates display position data of the sale item (product) from the read display position designation code, the remaining number, etc., and transmits the created display position data to the terminal device 100. Thereafter, the advertisement display processing program is terminated.

  On the other hand, in S <b> 106, the terminal device 100 determines whether or not display position data of a special sale item (product) is received from the database server 10. Here, when it is determined that the display position data of the special sale item (product) is not received from the database server 10 (S106: NO), the process returns to S106 itself and the above-described determination is repeated. On the other hand, if it is determined that the display position data of the sale item (product) is received from the database server 10 (S106: YES), the process proceeds to S107, and the liquid crystal display is based on the display position data of the sale item (product). The display position screen is displayed at 102, and then the advertisement display processing program is terminated.

  In this regard, FIG. 11 shows an example of the display position screen displayed on the liquid crystal display 102. When the display position screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104. The display content is controlled by the terminal device 100 based on the display position data of the sale item (product). To do.

  22 and 23 are flowcharts of the dish list display processing program executed by the terminal device 100 and the database server 10 of the product information display system 1 according to the present embodiment. Note that the dish list display processing program shown in the flowchart in FIGS. 22 and 23 is read from the ROM 162 in the terminal device 100 and executed by the CPU 161, and is read from the ROM 22 in the database server 10 and executed by the CPU 21. The

  In the dish list display processing program, as shown in FIG. 22, first, in S121, the terminal device 100 transmits data requesting dish list list data to the database server 10.

  On the other hand, in S221, the database server 10 determines whether or not the data requesting the dish list data has been received from the terminal device 100. Here, when it is determined that the data requesting the dish list data has not been received from the terminal device 100 (S221: NO), the process proceeds to S224 described below without doing anything. On the other hand, if it is determined that the data requesting the dish list data has been received from the terminal device 100 (S221: YES), the process proceeds to S222.

  In S222, the database server 10 searches the external storage device 12 for data necessary to create the dish list data. Specifically, the dish list file 51 stored in the external storage device 12 is searched, the dish code stored in the field 53 of the record 52 of the dish list file 51 is read, and the record 52 of the dish list file 51 is read. The dish name stored in the field 54 is read out. At this time, if a plurality of records 52 are provided in the dish list file 51, the dish code and the dish name are read from the fields 53 and 54 of each record 52 as described above.

  Thereafter, in S223, the database server 10 creates dish list data from the read dish code, dish name, and the like, and transmits the created dish list data to the terminal device 100.

  On the other hand, the terminal device 100 determines whether or not the dish list data has been received from the database server 10 in S122. Here, when it is determined that the dish list data has not been received from the database server 10 (S122: NO), the process returns to S122 itself and the above-described determination is repeated. On the other hand, if it is determined that the dish list data has been received from the database server 10 (S122: YES), the process proceeds to S123, and the dish list screen is displayed on the liquid crystal display 102 based on the dish list data.

  In this regard, FIG. 18 shows an example of the dish list screen displayed on the liquid crystal display 102. When the dish list list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal display 104. The display content is controlled by the terminal device 100 based on the dish list list data.

  Thereafter, in S124, the terminal device 100 determines whether or not the touch panel 111 has been touched. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S124: NO), the process returns to S124 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S124: YES), it progresses to S125.

  In S <b> 125, the terminal device 100 transmits data requesting the material list data for the dish specified on the touch panel 111 to the database server 10. The data requesting the material list data for the dish is specified by the coordinate position information from the touch panel drive circuit 165 among one or a plurality of dishes on the dish list screen displayed on the liquid crystal display 102. This includes the cooking code of the food.

  On the other hand, in S224, the database server 10 determines whether or not the data requesting the ingredient list data for the dish has been received from the terminal device 100. Here, when it is determined that the data requesting the ingredient list data for the dish is not received from the terminal device 100 (S224: NO), the process proceeds to S227 in FIG. 23 described later without doing anything. . On the other hand, if it is determined that the data requesting the ingredient list data for the dish is received from the terminal device 100 (S224: YES), the process proceeds to S225.

  In S225, the database server 10 searches the external storage device 12 for data necessary to create the ingredient list data for the dish. Specifically, the dish file 61 in which the dish code included in the data requesting the ingredient list data for the dish is stored in the record 62 is searched for and stored in the field 65 of the record 64 of the dish file 61. The material code stored is read, the material name stored in the field 66 of the record 64 of the dish file 61 is read, and the amount stored in the field 67 of the record 64 of the dish file 61 is read. At this time, if a plurality of records 64 are provided in the dish file 61, the material code, material name, and quantity are read from the fields 65, 66, and 67 of each record 64 as described above.

  Thereafter, in S226, the database server 10 creates material list data for the dish from the read material code, material name, quantity, etc., and transmits the created material list data for the dish to the terminal device 100. Thereafter, the process proceeds to S227 in FIG.

  On the other hand, in S <b> 126, the terminal device 100 determines whether or not the ingredient list data on the dish has been received from the database server 10. Here, when it is determined that the ingredient list data for the dish has not been received from the database server 10 (S126: NO), the process returns to S126 itself and the above-described determination is repeated. On the other hand, if it is determined that the ingredient list data for the dish has been received from the database server 10 (S126: YES), the process proceeds to S127, and the ingredient list screen is displayed on the liquid crystal display 102 based on the ingredient list data for the dish. After that, the process proceeds to S128 of FIG.

  In this regard, FIG. 13 shows an example of the material list screen displayed on the liquid crystal display 102. In addition, when the material list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal display 104. The display content is controlled by the terminal device 100 based on the material list data on the dish.

  Thereafter, in S128 of FIG. 23, it is determined whether or not the touch panel 111 is touched in the terminal device 100. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S128: NO), the process returns to S128 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S128: YES), it progresses to S129.

  In S <b> 129, the terminal device 100 transmits data requesting the product list data for the material specified on the touch panel 111 to the database server 10. The data for requesting the product list data for the material is specified by the coordinate position information from the touch panel drive circuit 165 among one or a plurality of materials in the material list screen displayed on the liquid crystal display 102. Includes cooking codes for ingredients.

  On the other hand, the database server 10 determines whether or not the data requesting the product list data for the material is received from the terminal device 100 in S227 of FIG. Here, when it is determined that the data requesting the merchandise list data for the material has not been received from the terminal device 100 (S227: NO), the process proceeds to S230 to be described later without doing anything. On the other hand, if it is determined that the data requesting the merchandise list data for the material is received from the terminal device 100 (S227: YES), the process proceeds to S228.

  In S228, the database server 10 searches the external storage device 12 for data necessary to create the product list data for the material. Specifically, the material code included in the data requesting the product list data for the material is searched for the material file 71 stored in the record 72, and stored in the record 73 of the dish file 71. The product code is read out, the product file 41 stored in the record 42 is searched for the product code, and the product name stored in the record 43 of the product file 41 or the record 43 of the product file 41 is stored. Read the unit price. At this time, when a plurality of product codes are read from the material file 71, the product name and unit price are read based on each product code as described above.

  Thereafter, in S229, the database server 10 creates product list data for the material from the read product code, product name, unit price, etc., and transmits the product list data for the created material to the terminal device 100. Then, the process proceeds to S230 described later.

  On the other hand, in S <b> 130, the terminal device 100 determines whether or not the product list data for the material has been received from the database server 10. Here, when it determines with the merchandise list data about a material not having been received from the database server 10 (S130: NO), it returns to S130 itself and repeats the determination mentioned above. On the other hand, if it is determined that the product list data for the material has been received from the database server 10 (S130: YES), the process proceeds to S131, and the product list screen is displayed on the liquid crystal display 102 based on the product list data for the material. After that, the process proceeds to S132 described later.

  In this regard, FIGS. 14 and 15 show an example of a product list screen displayed on the liquid crystal display 102. When the product list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104, but the display content is controlled by the terminal device 100 based on the material list data about the dish. In particular, in the liquid crystal display 103, when the number of people is input with the numeric buttons 109 or the like, the amount of the inputted number of people is calculated and output based on the amount included in the above-described ingredient list data for the dish (see FIG. 15).

  Thereafter, in S132 of FIG. 23, it is determined whether or not the touch panel 111 is touched in the terminal device 100. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S132: NO), the process returns to S132 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S132: YES), it progresses to S13.

  In S <b> 133, the terminal device 100 transmits to the database server 10 data requesting display position data for the product designated on the touch panel 111. The data for requesting display position data for the product is specified by coordinate position information from the touch panel drive circuit 165 among one or a plurality of products in the product list screen displayed on the liquid crystal display 102. Contains the product code of the product.

  On the other hand, in S230, the database server 10 determines whether or not the data requesting display position data for the product has been received from the terminal device 100. Here, if it is determined that the data requesting display position data for the product has not been received from the terminal device 100 (S230: NO), the cooking list display processing program is terminated without doing anything. . On the other hand, if it is determined that the data requesting the display position data for the product has been received from the terminal device 100 (S230: YES), the process proceeds to S231.

  In S231, the database server 10 searches the external storage device 12 for data necessary to create display position data for the product. Specifically, the product code 41 stored in the record 42 is searched for the product code included in the data requesting display position data for the product, and stored in the record 45 of the product file 41. The display position designation code and the remaining number stored in the record 46 of the product file 41 are read.

  Thereafter, in S232, the database server 10 creates display position data of the product from the read display position designation code, the remaining number, etc., and transmits the created display position data to the terminal device 100. Then, the dish list display processing program is terminated.

  On the other hand, in the terminal device 100, in S134, it is determined whether or not the display position data of the product is received from the database server 10. Here, when it is determined that the display position data of the product has not been received from the database server 10 (S134: NO), the process returns to S134 itself and the above-described determination is repeated. On the other hand, if it is determined that the display position data of the product has been received from the database server 10 (S134: YES), the process proceeds to S135, and the display position screen is displayed on the liquid crystal display 102 based on the display position data of the product. Thereafter, the dish list display processing program is terminated.

  In this regard, FIG. 16 shows an example of the display position screen displayed on the liquid crystal display 102. When the display position screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104. The display content is controlled by the terminal device 100 based on the display position data of the product.

  FIG. 24 is a flowchart of the purchase display processing program executed by the terminal device 100 of the product information display system 1 according to the present embodiment. Note that the purchase display processing program whose flowchart is shown in FIG. 24 is read from the ROM 162 and executed by the CPU 161.

  In the purchase display processing program, as shown in FIG. 24, in S141, the terminal device 100 displays a purchase list screen on the liquid crystal display 102, and then ends the purchase display processing program. At this time, the purchase list screen is displayed on the liquid crystal display 102 based on the purchase sheet created by the purchase sheet creation process of FIG.

  In this regard, FIG. 17 shows an example of a purchase list screen displayed on the liquid crystal display 102. When the purchase list screen is displayed on the liquid crystal display 102, it is also displayed on the liquid crystal displays 103 and 104. The display content is the purchase created by the purchase sheet creation process of FIG. The terminal device 100 controls based on the sheet.

  FIG. 25 is a flowchart of a cover screen display processing program executed by the terminal device 100 of the product information display system 1 according to the present embodiment. The cover screen display processing program shown in the flowchart in FIG. 25 is read from the ROM 162 and executed by the CPU 161.

  In the cover screen display processing program, as shown in FIG. 25, in S151, the terminal device 100 displays the cover screen on the liquid crystal display 102, and then ends the cover screen display processing program. The cover screen is stored in a nonvolatile memory mounted on the ROM 162 or the display control circuit 166. The cover screen is also displayed on the liquid crystal display 102 even in the initial state of the terminal device 100.

  FIG. 26 is a flowchart of a purchase sheet creation processing program executed by the terminal device 100 and the database server 10 of the product information display system 1 according to the present embodiment. 26 is read from the ROM 162 and executed by the CPU 161 in the terminal device 100, and is read from the ROM 22 in the database server 10 and executed by the CPU 21.

  In the purchase sheet creation processing program, as shown in FIG. 26, first, in S <b> 161, the terminal device 100 transmits the IC information read from the IC tag 202 to the database server 10. The IC information read from the IC tag 202 includes a product code of the product 201 to which the IC tag 202 is attached.

  On the other hand, the database server 10 determines whether or not the IC information is received from the terminal device 100 in S261. If it is determined that the IC information has not been received from the terminal device 100 (S261: NO), the purchased sheet creation processing program is terminated without doing anything. On the other hand, if it is determined that the IC information is received from the terminal device 100 (S261: YES), the process proceeds to S262.

  In S262, the database server 10 performs a data search related to the product code included in the IC information. Specifically, the product file 41 in which the product code included in the IC information is stored in the record 42 is searched for.

  Thereafter, in S263, the database server 10 reads the remaining number stored in the record 46 of the found product file 41 and overwrites the record 46 with a value obtained by subtracting “1” from the remaining number. Then, the process proceeds to S264.

  In S264, the database server 10 reads the product name stored in the record 43 of the found product file 41, reads the unit price stored in the record 44 of the product file 41, and reads it out. The price data including the product name and unit price is transmitted to the terminal device 100, and then the purchase sheet creation processing program is terminated.

  On the other hand, the terminal device 100 determines whether or not price data has been received from the database server 10 in S162. If it is determined that the price data has not been received from the database server 10 (S162: NO), the process returns to S162 itself and the above-described determination is repeated. On the other hand, when it is determined that the price data is received from the database server 10 (S162: YES), the process proceeds to S163, and a purchase sheet is created based on the price data received from the database server 10, and thereafter Finally, the purchase sheet creation processing program is terminated. At this time, the created purchase sheet is developed on a spreadsheet sheet similar to the purchase list screen shown in FIG. 17, and stores the product name and unit price included in the price data, and the liquid crystal display 103. The total amount displayed on the screen is calculated on the spreadsheet.

  Information included in the price data may be stored in the IC tag 202 and read directly from the IC tag 202.

  27 and 28 are flowcharts of a related dish display processing program executed by the terminal device 100 and the database server 10 of the product information display system 1 according to the present embodiment. The related dish display processing program shown in the flowcharts of FIGS. 27 and 29 is read from the ROM 162 in the terminal device 100 and executed by the CPU 161, and is read from the ROM 22 in the database server 10 and executed by the CPU 21. The

  In the related dish display processing program, as shown in FIG. 27, first, in S171, the terminal device 100 transmits to the database server 10 data requesting related dish list data. At this time, the data indicating that the related dish list data is requested includes the product code read from the IC tag 202 (see S61 in FIG. 20).

  On the other hand, in S271, the database server 10 determines whether or not the data requesting the related dish list data is received from the terminal device 100. Here, if it is determined that the data requesting the related dish list data is not received from the terminal device 100 (S271: NO), the process proceeds to S274 described later without doing anything. On the other hand, if it is determined that the data requesting the related dish list data is received from the terminal device 100 (S271: YES), the process proceeds to S272.

  In S272, the database server 10 searches the external storage device 12 for data necessary for creating the related dish list data. Specifically, among the plurality of product files 41 stored in the external storage device 12, a product file having a field 42 in which a product code included in data requesting related dish list data is stored. 41 is retrieved, the dish code stored in the field 47 of the found product file 41 is read, and in the dish list file 51, the record 52 having the field 53 in which the retrieved dish code is stored is read. The dish name stored in the field 54 is read out. At this time, if a plurality of records 47 are provided in the product file 41, as described above, the dish code from each record 47 and the dish name from the field 54 of each record 52 of the dish list file 51 are stored. Read each.

  Thereafter, in S273, the database server 10 creates related dish list data from the read dish code, dish name, and the like, and transmits the created related dish list data to the terminal device 100.

  On the other hand, the terminal device 100 determines whether or not the related dish list data is received from the database server 10 in S172. If it is determined that the related dish list data has not been received from the database server 10 (S172: NO), the process returns to S172 itself and repeats the above-described determination. On the other hand, if it is determined that the related dish list data has been received from the database server 10 (S172: YES), the process proceeds to S173, and the related dish list screen is displayed on the liquid crystal display 102 based on the related dish list data.

  In this regard, FIG. 12 shows an example of the related dish list screen displayed on the liquid crystal display 102. When the related dish list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal display 104. The display content is controlled by the terminal device 100 based on the related dish list data.

  Thereafter, in S174, the terminal device 100 determines whether or not the touch panel 111 has been touched. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S174: NO), the process returns to S174 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S174: YES), it progresses to S175.

  In S <b> 175, the terminal device 100 transmits data requesting the material list data for the dish specified on the touch panel 111 to the database server 10. The data requesting the material list data for the dish is specified by the coordinate position information from the touch panel drive circuit 165 among one or a plurality of dishes on the dish list screen displayed on the liquid crystal display 102. This includes the cooking code of the food.

  On the other hand, in S274, the database server 10 determines whether or not the data requesting the ingredient list data for the dish has been received from the terminal device 100. Here, when it is determined that the data requesting the ingredient list data for the dish has not been received from the terminal device 100 (S274: NO), the process proceeds to S277 in FIG. 27 described later without doing anything. . On the other hand, if it is determined that the data requesting the ingredient list data for the dish is received from the terminal device 100 (S274: YES), the process proceeds to S275.

  In S275, the database server 10 searches the external storage device 12 for data necessary to create the ingredient list data for the dish. Specifically, the dish file 61 in which the dish code included in the data requesting the ingredient list data for the dish is stored in the record 62 is searched for and stored in the field 65 of the record 64 of the dish file 61. The material code stored is read, the material name stored in the field 66 of the record 64 of the dish file 61 is read, and the amount stored in the field 67 of the record 64 of the dish file 61 is read. At this time, if a plurality of records 64 are provided in the dish file 61, the material code, material name, and quantity are read from the fields 65, 66, and 67 of each record 64 as described above.

  Thereafter, in S276, the database server 10 creates material list data for the dish from the read material code, material name, quantity, etc., and transmits the created ingredient list data for the dish to the terminal device 100. Thereafter, the process proceeds to S277 in FIG.

  On the other hand, in the terminal device 100, in S176, it is determined whether or not the ingredient list data for the dish has been received from the database server 10. Here, when it is determined that the ingredient list data for the dish has not been received from the database server 10 (S176: NO), the process returns to S176 itself and the above-described determination is repeated. On the other hand, if it is determined that the ingredient list data for the dish has been received from the database server 10 (S176: YES), the process proceeds to S177, and the ingredient list screen is displayed on the liquid crystal display 102 based on the ingredient list data for the dish. After that, the process proceeds to S178 in FIG.

  In this regard, FIG. 13 shows an example of the material list screen displayed on the liquid crystal display 102. In addition, when the material list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal display 104. The display content is controlled by the terminal device 100 based on the material list data on the dish.

  Thereafter, in S178 of FIG. 28, the terminal device 100 determines whether or not the touch panel 111 has been touched. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S178: NO), the process returns to S178 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S178: YES), it progresses to S179.

  In S <b> 179, the terminal device 100 transmits data requesting the product list data for the material designated on the touch panel 111 to the database server 10. The data for requesting the product list data for the material is specified by the coordinate position information from the touch panel drive circuit 165 among one or a plurality of materials in the material list screen displayed on the liquid crystal display 102. Includes cooking codes for ingredients.

  On the other hand, the database server 10 determines whether or not the data requesting the product list data for the material is received from the terminal device 100 in S277 of FIG. Here, if it is determined that the data requesting the merchandise list data for the material has not been received from the terminal device 100 (S277: NO), the process proceeds to S280 described later without doing anything. On the other hand, if it is determined that the data requesting the merchandise list data for the material has been received from the terminal device 100 (S277: YES), the process proceeds to S278.

  In S278, the database server 10 searches the external storage device 12 for data necessary for creating the product list data for the material. Specifically, the material code included in the data requesting the product list data for the material is searched for the material file 71 stored in the record 72, and stored in the record 73 of the dish file 71. The product code is read out, the product file 41 stored in the record 42 is searched for the product code, and the product name stored in the record 43 of the product file 41 or the record 43 of the product file 41 is stored. Read the unit price. At this time, when a plurality of product codes are read from the material file 71, the product name and unit price are read based on each product code as described above.

  Thereafter, in S279, the database server 10 creates product list data for the material from the read product code, product name, unit price, etc., and transmits the product list data for the created material to the terminal device 100. Thereafter, the process proceeds to S280 described later.

  On the other hand, in S <b> 180, the terminal device 100 determines whether or not the product list data for the material has been received from the database server 10. If it is determined that the product list data for the material has not been received from the database server 10 (S180: NO), the process returns to S180 itself and the above-described determination is repeated. On the other hand, if it is determined that the product list data for the material has been received from the database server 10 (S180: YES), the process proceeds to S181, and the product list screen is displayed on the liquid crystal display 102 based on the product list data for the material. After that, the process proceeds to S182 described later.

  In this regard, FIGS. 14 and 15 show an example of a product list screen displayed on the liquid crystal display 102. When the product list screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104, but the display content is controlled by the terminal device 100 based on the material list data about the dish. In particular, in the liquid crystal display 103, when the number of people is input with the numeric buttons 109 or the like, the amount of the inputted number of people is calculated and output based on the amount included in the above-described ingredient list data for the dish (see FIG. 15).

  Thereafter, in S182, the terminal device 100 determines whether or not the touch panel 111 has been touched. This determination is made based on whether coordinate position information is output from the touch panel drive circuit 165. At this time, when it is determined that the touch panel 111 is not touched (S182: NO), the process returns to S182 itself and the above-described determination is repeated. On the other hand, when it determines with having touched the touch panel 111 (S182: YES), it progresses to S183.

  In S <b> 183, the terminal device 100 transmits to the database server 10 data requesting display position data for the product designated on the touch panel 111. The data for requesting display position data for the product is specified by coordinate position information from the touch panel drive circuit 165 among one or a plurality of products in the product list screen displayed on the liquid crystal display 102. Contains the product code of the product.

  On the other hand, in S280, the database server 10 determines whether or not data indicating that the display position data for the product is requested is received from the terminal device 100. Here, if it is determined that the data requesting the display position data for the product has not been received from the terminal device 100 (S280: NO), the related dish display processing program is terminated without doing anything. . On the other hand, if it is determined that the data requesting the display position data for the product has been received from the terminal device 100 (S280: YES), the process proceeds to S281.

  In S281, the database server 10 searches the external storage device 12 for data necessary for creating display position data for the product. Specifically, the product code 41 stored in the record 42 is searched for the product code included in the data requesting display position data for the product, and stored in the record 45 of the product file 41. The display position designation code and the remaining number stored in the record 46 of the product file 41 are read.

  Thereafter, in S282, the database server 10 creates display position data of the product from the read display position designation code, the remaining number, etc., and transmits the created display position data to the terminal device 100. The related dish display processing program is terminated.

  On the other hand, in the terminal device 100, in S184, it is determined whether or not the display position data of the product is received from the database server 10. Here, when it is determined that the display position data of the product has not been received from the database server 10 (S184: NO), the process returns to S184 itself and the above-described determination is repeated. On the other hand, if it is determined that the display position data of the product has been received from the database server 10 (S184: YES), the process proceeds to S185, and the display position screen is displayed on the liquid crystal display 102 based on the display position data of the product. Then, the related dish display processing program is terminated.

  In this regard, FIG. 16 shows an example of the display position screen displayed on the liquid crystal display 102. When the display position screen is displayed on the liquid crystal display 102, the display is also performed on the liquid crystal displays 103 and 104. The display content is controlled by the terminal device 100 based on the display position data of the product.

  As described above, the CPU 21 of the database server 10 functions as “update means” when executing S263 of FIG. 26 or S292 of FIG.

  As described above in detail, in the product information display system 1 according to the present embodiment, the terminal device 100 provided in the shopping cart 200 and the database server 10 perform wireless communication. At this time, the terminal device 100 uses the database server based on the detection signal output from the gate sensor 169 when the shopping cart 200 passes through the gate 203 or the IC information read by the reader 167 from the IC tag 202 of the product 201. 10, when data for requesting advertisement item list data or related dish list data is transmitted, the database server 10 stores the data in the external storage device 12 based on the contents included in the data. The advertisement item list data or the related dish list data created from the data such as the product file 41 being sent is transmitted to the terminal device 100, so that the terminal device 100 has the advertisement item list screen / display position screen or the related dish. List screen, material list screen, product list screen, display position screen Etc., and it can be sequentially displayed on the liquid crystal display 102 as a hierarchical menu selection operation by touch panel 111. Therefore, since the store-specific product information stored in the database server 10 can be presented to the terminal device 100 of the shopping cart 200 according to the customer's individual shopping progress, it contributes to the prevention of economical shopping and forgetting to shop. Can do.

  Further, for the product file 41 stored in the external storage device 12, the product information managed by the product file 41 is placed in the shopping cart 200, and the IC information read by the reader 167 from the IC tag 202 of the product 201. Is sent to the database server 10, the database server 10 subtracts “1” from the remaining number stored in the record 46 of the product file 41. On the other hand, when the product 201 managed by the product file 41 is received, the store side uses the keyboard 14 or the mouse 15 or the like to calculate the number of arrivals with respect to the remaining number stored in the record 46 of the product file 41. to add. Accordingly, when the display position screen is displayed on the terminal device 100, the remaining number which is the total number (the sum of the display number and the stock number) that can be sold at the main store for the product 201 managed by the product file 41 is displayed. Can be displayed with real-time accuracy. Therefore, the customer can know the display position of the product 201 and the current number of items that can be sold by viewing the display on the display position screen.

In addition, this invention is not limited to the said embodiment, A various change is possible in the range which does not deviate from the meaning.
For example, in the product information display system 1 according to the present embodiment, the IC information from the IC tag 202 attached to the product 201 is read by the reader 167. In this regard, a barcode having the same information as the IC information is read. May be attached to the product 201 and the barcode information may be read out by a reader.

  In the product information display system 1 according to the present embodiment, the contents of the purchase sheet created by the terminal device 100 are transmitted to a cash register in the store by wireless communication or the like, so that payment can be made efficiently. May be. In addition, after wirelessly communicating with the cash register in the store, the contents of the purchase sheet are reset.

  The present invention can be applied to a technique for displaying character information received from a server in a shopping cart.

It is the block diagram which showed the merchandise information display system which concerns on this Embodiment. It is the block diagram which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the block diagram which showed the database server of the merchandise information display system which concerns on this Embodiment. It is the figure which showed a part of structure of the advertisement product file memorize | stored in the external storage device of the database server in the merchandise information display system which concerns on this Embodiment. It is the figure which showed a part of structure of the goods file memorize | stored in the external storage device of the database server in the goods information display system which concerns on this Embodiment. It is the figure which showed a part of structure of the dish list file memorize | stored in the external storage device of the database server in the merchandise information display system which concerns on this Embodiment. It is the figure which showed a part of structure of the dish file memorize | stored in the external storage device of the database server in the merchandise information display system which concerns on this Embodiment. It is the figure which showed a part of structure of the material file memorize | stored in the external storage device of the database server in the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is the front view which showed the terminal device of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the writing process program performed with the database server of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the display control processing program performed with the terminal device of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the advertisement display processing program executed by the terminal device and the database server of the product information display system according to the present embodiment. It is a flowchart of the dish list display processing program performed with the terminal device and database server of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the dish list display processing program performed with the terminal device and database server of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the purchase display process program performed with the terminal device of the merchandise information display system which concerns on this Embodiment. It is a flowchart of a cover screen display processing program executed by the terminal device of the product information display system according to the present embodiment. It is a flowchart of the purchase sheet | seat preparation processing program run with the terminal device and database server of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the related dish display processing program performed with the terminal device and database server of the merchandise information display system which concerns on this Embodiment. It is a flowchart of the related dish display processing program performed with the terminal device and database server of the merchandise information display system which concerns on this Embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Product information display system 10 Database server 12 External storage device 14 Keyboard 15 Mouse 21 Database server CPU
31 Advertising file 41 Product file 51 Cooking list file 61 Cooking file 71 Material file 100 Terminal device 102 Liquid crystal display 105 Advertising button 106 Cooking button 107 Purchase button 108 Cursor button 109 Numeric button 110 Decision button 111 Touch panel 112 Home button 161 Terminal Device CPU
164 Wireless communication circuit 167 Reader 169 Gate sensor 200 Shopping cart 201 Product 202 IC tag 203 Gate 204 Access point N Local area network

Claims (4)

A product information display system in which a terminal device provided in a shopping cart performs wireless communication with a server,
The terminal device receives, from the server, one or more character information relating to a product related to the content of the cart-side input data by transmitting the cart-side input data input at the terminal device to the server. While displaying as a hierarchical menu and sending product data read from the product by the terminal device to the server,
The server is based on the product data received from the terminal device or the server-side input data input by the server, in one or a plurality of character information related to the product related to the product data or the content of the server-side input data. Updating product management information,
Product information display system characterized by A product information display system for performing wireless communication with a terminal device provided in a shopping cart and receiving from the terminal device cart-side input data input by the terminal device or product data read from a product by the terminal device A server,
A database in which one or a plurality of character information related to products displayed as a hierarchical menu in the terminal device is stored in association with the contents of the cart side input data directly or indirectly;
Character information communication means for transmitting, as the hierarchical menu, one or a plurality of character information related to merchandise related to the contents of the cart side input data received from the terminal device, from the database to the terminal device;
Server-side input means for inputting server-side input data;
Product in one or a plurality of character information related to the product related to the product data or the contents of the server side input data based on the product data received from the terminal device or the server side input data input by the server side input means And a server for updating the management information. Wireless communication is performed with respect to a server that stores one or a plurality of character information related to the product directly or indirectly related to the content of the cart side input data and updates the product management information in the character information based on the product data. A shopping cart of a product information display system provided with a terminal device to perform,
The terminal device
Reading means for reading the product data from the product;
Cart side input means for inputting the cart side input data;
Data communication means for transmitting the product data read by the reading means or the cart side input data input by the cart side input means to the server;
Display means for receiving one or a plurality of character information relating to the product related to the contents of the cart side input data transmitted by the data communication means from the server and displaying it as a hierarchical menu;
A shopping cart featuring. A product information display method for displaying character information related to a product stored in a server on a terminal device of a shopping cart,
A reading step of reading product data from the product at the terminal device;
A cart side input step of inputting cart side input data in the terminal device;
A data communication step of transmitting the product data read in the reading step or the cart side input data input in the cart side input step from the terminal device to the server;
A character information communication step of transmitting from the server to the terminal device one or a plurality of character information related to the product related to the contents of the cart side input data received in the data communication step;
A display step of displaying on the terminal device one or more pieces of character information relating to the product received in the character information communication step;
A server-side input process for inputting server-side input data in the server;
Based on the product data received in the data communication step or the server side input data input in the server side input step, in one or a plurality of character information related to the product related to the product data or the contents of the server side input data A product information display method comprising: an update process in which the server updates product management information.

Images