JP2015031973A - Commodity sales data registration processing system and commodity sales data registration processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a commodity sales data registration processing system and a commodity sales data registration processing program capable of automatically calculating calorie to be taken in a day and capable of recommending an appropriate menu for a customer.SOLUTION: The commodity sales data registration processing system includes a customer terminal having a control section that calculates a calorie difference which is a calorie allowance based on a required energy per day which is calculated from a required energy per day for a customer; a total taken calorie which is calculated based on menus that the customer has taken; a consumed calorie which is calculated based on the kind of sports which the customer has practiced and the practice time, and extracts menus of a calorie smaller than the calorie difference from commodity master to display recommendation menus on an input/output section.

Description

  Embodiments described herein relate generally to a merchandise sales data registration processing system and a merchandise sales data registration processing program.

  In stores that provide food and drink, such as restaurants and karaoke shops, introduction of a system in which customers order food and drink using a tablet-type terminal is progressing. In this system, a customer can select a menu displayed on the terminal and place an order by himself / herself.

  In addition, due to the recent increase in health consciousness, an increasing number of customers are concerned about the calories in their meals.

  In this regard, a technique has been proposed in which a customer inputs an upper limit calorie of a meal to be ingested to a terminal and the terminal presents a menu of the upper limit calorie or less.

  However, the customer rarely knows how many calories he should have on that day, and this technique does not provide an appropriate menu because an appropriate upper limit calorie is not entered.

JP 2007-249919 A

  Accordingly, there is a need for a merchandise sales data registration processing system and a merchandise sales data registration processing program that can automatically calculate how many calories the customer should consume after the day and recommend an appropriate menu.

  In order to solve the above-described problem, according to an embodiment of the present invention, a product master that stores a unit price and a calorie for each product code that is uniquely assigned to a product in a storage device, and a customer may ingest it. A server that stores a menu management database that stores calories for each ingested menu, an exercise amount table that stores exercise intensity for each exercise name, and an energy table that stores necessary energy per day for each occupation, and information Input / output unit that inputs and outputs, the required energy calculated from the required energy per day for each customer, the total calorie intake calculated from the consumed menu that the customer has already consumed, the type of exercise performed by the customer, and Calculate calorie difference that is calories that can be ingested based on calorie consumption calculated from exercise time, calorie difference Providing merchandise sales data registration processing system comprising a customer terminal, a and a control unit to be displayed on the output unit as a recommended menu extracts menu calories from the product master below.

It is a figure which shows the structure of a merchandise sales data registration processing system. It is a block diagram which shows the structure of the terminal for customers. It is a figure which shows the data structure of a goods master. It is a figure which shows the data structure of a menu management database. It is a figure which shows the data structure of an exercise amount table. It is a figure which shows the data structure of an intake table. It is a figure which shows the data structure of an energy table. It is a figure which shows the data structure of a member master. It is a figure which shows the example of the customer information input screen displayed on the input-output part of a customer terminal. It is a figure which shows the example of the recommended menu display screen displayed on the input / output part of a customer terminal. It is a flowchart which shows operation | movement of the terminal for customers.

  Hereinafter, an embodiment of a product sales data registration processing system and a product sales data registration processing program will be described in detail with reference to the drawings.

  The merchandise sales data registration processing system of the present embodiment includes a merchandise master that stores a unit price and calories for each merchandise code that is uniquely assigned to a merchandise, and an ingested menu that a customer may possibly consume. A server that stores a menu management database for storing calories, an exercise amount table for storing exercise intensity for each exercise name, and an energy table for storing required energy for each occupation, and an input / output device for inputting and outputting information. Calculated from the required energy per day calculated from the required energy per day for each output unit, the total calorie intake calculated from the ingested menu already ingested by the customer, the type of exercise performed and the exercise time performed by the customer Calculate the calorie difference, which is the calories that can be consumed based on the calorie consumption, and calculate the calorie difference It provided around a control unit to be displayed in the input-output unit a menu of calories as recommended menu is extracted from the product master, and the customer terminal with a, a.

  FIG. 1 is a diagram showing a configuration of a merchandise sales data registration processing system (hereinafter referred to as a registration processing system). As shown in FIG. 1, a registration processing system includes a server 2 connected to each other via a communication line, a printer 3 installed in a kitchen, and a POS (Point of sales) terminal that is a product sales data registration terminal installed in an accounting office. 4 and an access point 5. The registration processing system also includes a customer terminal 1 connected by a wireless communication line via an access point 5.

  The server 2 includes a control unit including a CPU (Central processing unit) that is an arithmetic device, a communication unit that performs information communication, and a storage unit that includes a storage device such as a memory and a hard disk drive.

  The server 2 stores, in the storage device, a product master 2A that stores the unit price, calories, and the number of servings obtained by quantifying the position in the meal for each product code assigned to the product, and a menu that the customer may take Menu management database (hereinafter referred to as DB) 2B for storing calories and serving number for each, exercise amount table 2C for storing exercise intensity for each exercise name, appropriate calories per day for each gender and age, and appropriate An intake table 2D for storing the number of servings, an energy table 2E for storing required energy per day for each occupation, and a member master 2F for storing information about customers are stored.

  The printer 3 forms an image of a customer order on a recording medium.

  The POS terminal 4 includes a control unit including a CPU that is an arithmetic device, an input / output unit that inputs and outputs information, a printer, a communication unit that performs information communication, and a storage unit that includes a storage device such as a memory and a hard disk drive. And a deposit / withdrawal device.

  The POS terminal 4 stores in the storage unit an accounting product master that stores a unit price for each product code, and a transaction file that stores the contents of one transaction.

  The customer terminal 1 can use a so-called tablet computer. The customer terminal 1 is arranged for each customer table.

  FIG. 2 is a block diagram showing the configuration of the customer terminal 1. As shown in FIG. 2, the customer terminal 1 includes a control unit 11 including a CPU that is an arithmetic device, a storage unit 12 including a storage device such as a memory, and an input / output unit 13 that inputs and outputs information such as a touch panel. And a communication unit 14 that performs information communication.

  The storage unit 12 stores a product sales data registration processing program, and the control unit 11 reads the product sales data registration processing program from the storage unit 12 and executes it.

  The storage unit of the server 2 stores a product sales data registration processing program, the control unit of the server 2 executes the product sales data registration processing program, and the customer terminal 1 stores a browser in the storage unit 12, The control unit 11 can be configured to execute a browser.

  FIG. 3 is a diagram illustrating a data configuration of the product master 2A. As shown in FIG. 3, the product master 2 </ b> A includes a “product code” that is an identifier uniquely assigned to the product, a “name” that is the name of the product, a “unit price” that is the price of the product, and the calorie of the product. The “calorie” indicating “the number of servings” and the “serving number” obtained by quantifying the position in the meal are stored.

  Here, the number of servings can be based on, for example, a “meal balance guide” (http://www.mhlw.go.jp/bunya/kenkou/eiyou-syokuji.html) provided by the Ministry of Health, Labor and Welfare.

  Examples of each data are as follows: product code “0051”, name “Torang set meal”, unit price “980”, calorie “1200” (kcal), serving number “1”, side dish “1”, Main dish “3”, milk “0”, fruit “0”.

  FIG. 4 is a diagram illustrating a data configuration of the menu management DB 2B. As shown in FIG. 4, the menu management DB 2 </ b> B includes an “ingested menu name” that indicates a menu that the customer may ingest before the store visits, an “ingested calorie” that indicates the calories in the menu, and the menu The “number of consumed servings” indicating the number of servings is stored.

  Examples of each data are: “ham egg” for the ingested menu name, “250” (kcal) for the ingested calorie, “0” for the consumed serving, “0” for the side dish, “1” for the main dish, “milk” 0 ”and fruit“ 0 ”.

  FIG. 5 is a diagram illustrating a data configuration of the exercise amount table 2C. As illustrated in FIG. 5, the exercise amount table 2 </ b> C stores “exercise name” indicating the type of exercise performed on that day and “exercise intensity” obtained by quantifying the intensity of exercise.

  In the example of each data, the exercise name is “fast walk” and the exercise intensity is “4.0”.

  FIG. 6 is a diagram illustrating a data configuration of the intake amount table 2D. As shown in FIG. 6, the intake table 2D includes “sex”, “age”, “activity amount” indicating the daily activity amount of the customer, and “appropriate calorie” which is the appropriate intake calorie number per day. And “appropriate serving number”, which is the number of servings per day that is appropriate intake.

  Here, the appropriate calorie and the appropriate serving number can be based on, for example, the “meal balance guide” provided by the aforementioned Ministry of Health, Labor and Welfare.

  Examples of each data are gender “male”, age “18-69”, activity amount “ordinary or better”, appropriate calorie “2600”, appropriate serving number “8”, side dish “7”, Main dish “6”, milk “3”, fruit “3”.

  FIG. 7 is a diagram illustrating a data configuration of the energy table 2E. As shown in FIG. 7, the energy table 2E stores “work” indicating the occupation of the customer and “necessary energy per day” indicating the required energy (kcal) per day per kg of body weight.

  In the example of each data, the work is “desk work center” and the required energy per day is “30”.

  FIG. 8 is a diagram showing a data structure of the member master 2F. As shown in FIG. 8, the member master 2F includes a “member ID” which is an identifier uniquely assigned to a customer, a customer's “sex”, “age”, “height”, “weight”, “activity”, And “work” are stored.

  Examples of each data include a member ID “1023”, a gender “male”, an age “35”, a height “175”, an activity amount “ordinary or higher”, and a work “desk work center”.

  FIG. 9 is a diagram illustrating an example of a customer information input screen 901 displayed on the input / output unit 13 of the customer terminal 1. As shown in FIG. 9, the customer information input screen 901 includes a basic information input field 901A for inputting customer basic information, an exercise input field 901B for inputting information related to exercise performed by the customer on the day, and the customer already taking in the day. An ingested menu input field 901C for inputting the selected menu and a recommended menu search button 901D.

  The basic information input column 901A includes columns for inputting a member ID, gender, height, weight, activity amount, and work.

  The exercise input column 901B includes columns for inputting an exercise name and exercise time.

  The ingested menu input field 901C includes a field for selectively inputting an ingested menu name.

  When the customer ID is input, the customer terminal 1 reads customer information from the member master 2F and displays it.

  The customer terminal 1 stores the customer information read from the member master 2F and the input information in the storage unit 12.

  When the recommended menu search button 901D is pressed, the customer terminal 1 searches the recommended menu and displays the recommended menu display screen 1001.

  FIG. 10 is a diagram illustrating an example of a recommended menu display screen 1001 displayed on the input / output unit 13 of the customer terminal 1. As shown in FIG. 10, the recommended menu display screen 1001 includes a recommended menu display field 1001A for displaying a recommended menu, a normal menu display field 1001B for displaying other menus, and a selected menu display for displaying a selected menu. A column 1001C, a message column 1001D for displaying a message, and an “order” button 1001E for instructing order confirmation are provided.

  The customer selects a menu from the recommended menu display field 1001A or the normal menu display field 1001B. The selected menu is displayed in the selected menu display field 1001C.

  When it is determined that the calorie is over, a message to that effect is displayed.

  When the “order” button 1001E is pressed, the selected menu is transmitted to the server 2 and the POS terminal 4 as order information.

  FIG. 11 is a flowchart showing the operation of the customer terminal 1. As shown in FIG. 11, in step 1101, the customer terminal 1 displays a customer information input screen 901 on the input / output unit 13 to display basic information, information on exercises performed by the customer on the day, and menus that the customer has already ingested on the day. Input. Basic information includes member ID, gender, height, weight, activity, and work.

  In step 1102, the customer terminal 1 calculates the required calories per day.

  First, the customer terminal 1 calculates the standard weight according to the following equation (1).

(Standard weight) = (height (m)) × (height (m)) × 22 (1)
Next, the customer terminal 1 searches the exercise amount table 2C based on the input “work”, and reads “necessary energy per day” (kcal / kg).

  Next, by substituting the standard weight and “necessary energy per day” into the following equation (2), “necessary calories per day” is calculated.

(Required calories per day) = (Standard body weight) x (Required energy per day) (2)
In step 1103, the customer terminal 1 calculates the calories that have already been consumed by summing the calories that have been consumed.

  Specifically, the customer terminal 1 sequentially searches the menu management DB 2B based on the input ingested menu name, reads ingested calories, and sequentially adds them.

  In step 1104, the customer terminal 1 calculates the number of consumed servings.

  Specifically, the customer terminal 1 sequentially searches the menu management DB 2B based on the input ingested menu name, reads out the ingested serving number, and sequentially for each item such as “main dish” and “side dish”. Add up.

  In step 1105, the customer terminal 1 calculates the difference between the appropriate value and the ingested value for the calorie and the serving number.

  Specifically, the calorie difference is calculated by the following equation (3).

(Calorie difference) = (required energy per day) − (total calorie intake) − (calorie consumption) (3)
Here, calorie consumption is calculated as follows.

  The customer terminal 1 searches the energy table 2E based on the input exercise name, reads out the exercise intensity, and calculates it based on the following equation (4).

(Calorie consumption) = ((exercise intensity) -1) × (weight) × (exercise time) × 1.05 (4)
Next, the customer terminal 1 searches the intake table 2D based on gender, height, weight, and activity, and reads the appropriate serving number for each item.

  Then, the customer terminal 1 calculates the serving number difference for each item based on the following equation (5).

(Serving number difference) = (Appropriate serving number) − (Total number of served servings) (5)
In step 1106, the customer terminal 1 retrieves a recommended menu from the product master 2A based on the calorie difference and the serving number difference.

  Specifically, the customer terminal 1 first extracts a menu having a calorie difference or less from the product master 2A.

  Next, the customer terminal 1 extracts a menu whose serving number is less than the serving number difference for each item from the extracted menu, and sets the extracted menu as a recommended menu.

  In step 1107, the customer terminal 1 displays the recommended menu in the recommended menu display field 1001A of the recommended menu display screen 1001, and displays the other menus in the normal menu display field 1001B.

  In step 1108, the customer terminal 1 inputs an order candidate.

  In step 1109, the customer terminal 1 determines whether the menu of order candidates is over calories.

  Specifically, the customer terminal 1 searches the merchandise master 2A based on the merchandise code of the selected menu, sequentially reads and adds the calories.

  When the total value of the calories exceeds the calorie difference, it is determined that the calorie is over. The value obtained by subtracting the calorie difference from the total calorie value is stored in the storage unit 12 as the calorie over value.

  If the customer terminal 1 determines that the menu of the order candidate is over calories, the process proceeds to step 1110, and if determined that the menu is not over calories, the process proceeds to step 1111.

  In step 1110, the customer terminal 1 displays that the calorie is over and the calorie over value in the message field 1001D.

  In step 1111, when the “order” button 1001E is pressed, the customer terminal 1 receives an order for the selected menu as an order.

  The server 2 can also be configured to distribute the customer information input screen 901 and the recommended menu display screen 1001 to a smartphone or a tablet terminal.

  The contents of the recommended menu display screen 1001 can be output from the printer 3 or the printer of the POS terminal 4 so that the customer can take it home.

  As described above, the product sales data registration processing system of the present embodiment stores, in the storage device, the number of servings obtained by quantifying the unit price, the calorie, and the position in the meal for each product code assigned to the product. Product master 2A, menu management DB 2B that stores calories and the number of servings for each ingested menu that a customer may take, exercise amount table 2C that stores exercise intensity for each exercise name, and 1 for each gender and age A server 2 that stores an intake table 2D that stores the number of appropriate servings per day, an energy table 2E that stores necessary energy per day for each occupation, and a member master 2F that stores information about customers. Input / output unit 13 for input / output and the required energy per day for each customer's height, weight, and occupation Calculate the calorie difference that is the calorie that can be consumed based on the required daily energy calculated from the menu, the total calorie intake calculated from the menu already consumed by the customer, and the calorie consumption calculated from the exercise and exercise time performed by the customer. A customer terminal including a control unit 11 that extracts a menu of calories below the calorie difference from the product master and displays the menu on the input / output unit 13.

  Therefore, there is an effect that the customer can automatically calculate how many calories should be consumed after the day and recommend an appropriate menu.

  Although several embodiments have been described, these embodiments have been presented by way of example and are not intended to limit the scope of the invention. These embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and their modifications are included in the scope and gist of the invention, and are also included in the invention described in the claims and the equivalents thereof.

1: Customer terminal 2: Server 2A: Product master 2B: Product management database 2C: Exercise amount table 2D: Intake amount table 2E: Energy table 2F: Member master

Claims (6)

In the storage device,
For each product code uniquely assigned to the product, a product master that stores the unit price and calories,
A menu management database that stores calories for each ingested menu that a customer may consume,
A momentum table that stores exercise intensity for each exercise name;
An energy table that stores the required energy per day for each occupation,
A server for storing
An input / output unit for inputting / outputting information;
Daily energy requirement calculated from daily energy requirement for each customer, total calorie intake calculated from the ingested menu already consumed by the customer, calorie consumption calculated from the type and exercise time of exercise performed by the customer Calculating a calorie difference that is calories that can be ingested based on, extracting a menu of calories below the calorie difference from the product master and displaying the recommended menu on the input / output unit;
A customer terminal comprising:
Merchandise sales data registration processing system. The server
An additional intake table that stores the appropriate number of servings per day for each gender and age,
The product master is
Further storing the number of servings quantifying the position in the meal for each product code,
The menu management database is
Further storing the serving number for each ingested menu;
The controller is
2. The serving number difference is calculated by subtracting the consumed serving number from the appropriate serving number, and a menu lower than the serving number difference is further extracted from the recommended menu and displayed on the input / output unit. Product sales data registration processing system. The controller is
The product sales data registration processing system according to claim 2, wherein when it is determined that the total calorie value of the selected menu exceeds the calorie difference, the fact is displayed on the input / output unit. A product sales data registration terminal that includes a printer and performs accounting processing;
The printer is
4. The merchandise sales data registration processing system according to claim 3, wherein the calorie difference and the calorie total value of the selected menu are image-formed on a recording medium. In the storage device,
For each product code uniquely assigned to the product, a product master that stores the unit price and calories,
A menu management database that stores calories for each ingested menu that a customer may consume,
A momentum table that stores exercise intensity for each exercise name;
An energy table that stores the required energy per day for each occupation,
A server for storing
An input / output unit for inputting / outputting information;
A control unit;
A customer terminal comprising:
In a product sales data registration processing system comprising:
The customer terminal,
Daily energy requirement calculated from daily energy requirement for each customer, total calorie intake calculated from the ingested menu already consumed by the customer, calorie consumption calculated from the type and exercise time of exercise performed by the customer A calorie difference calculating means for calculating a calorie difference that is calories that can be consumed based on;
A recommended menu extraction display means for extracting a menu of calories below the calorie difference from a product master and displaying it on the input / output unit as a recommended menu;
Product sales data registration processing program to function as The server
An additional intake table that stores the appropriate number of servings per day for each gender and age,
The product master is
Further storing the number of servings quantifying the position in the meal for each product code,
The menu management database is
Further storing the serving number for each ingested menu;
The customer terminal,
A balanced nutrition food presenting means for calculating a serving number difference by subtracting a consumed serving number from the appropriate serving number, and further extracting a menu lower than the serving number difference from the recommended menus and displaying it on the input / output unit The product sales data registration processing program according to claim 5 for further functioning as:

Images