JP5762792B2 - Lunch box ordering system - Google Patents

Description

  The present invention relates to a lunch ordering system using a communication network, and more particularly, to a lunch ordering system in which each lunch orderer belonging to a plurality of organizations can order a lunch to a plurality of lunch suppliers.

  The lunch box ordering system, which is a background technology, orders lunches from an ordering terminal via the network, and is used to receive orders and lunches from the ordering terminal. A lunchbox application service provider that provides information services, and a lunchbox production management system that receives order data from the lunchbox application service provider and manages the production of lunchboxes. A lunch box application service provider that accepts orders from order terminals and provides lunch information services is set up on the network, listing the menus of multiple lunch suppliers, and the orderer selects the lunch menu from the order terminal and places an order ( Patent Document 1).

JP 2004-005556 A

  However, in the conventional ordering and ordering system, it is possible to easily and quickly confirm the total amount and the breakdown of the lunch boxes purchased by an individual or a certain company or the total number and breakdown of the lunch boxes sold by a certain seller. There was a problem that it was not always easy. In addition, there is a problem that it is not always easy to see the evaluation of a purchaser who has already purchased a lunch.

The present invention has been made in view of the above problems, and an object of the present invention is to provide an ordering / ordering system capable of easily and quickly confirming orders within a predetermined period, the total amount of orders received, and a breakdown.
It is another object of the present invention to provide an ordering / ordering system that allows a user to easily see the other person's evaluation of a bento for which purchase is to be considered at the time of purchase consideration.

In order to achieve the above object, the lunch ordering system according to the present invention receives, via a network, a lunch information management means capable of providing necessary information when ordering a lunch, and receives lunch order information from the orderer. , Including ordering history management means for sending order information for lunch to the seller, receiving order information from the seller, and managing the history of those orders.
The order history management means manages the date of ordering, the ID of the orderer, and the ID of the ordered lunch box,
When the order history browsing request is received, the order history stored in association with the orderer ID included in the order history browsing request is extracted, and the first screen configuration information that allows browsing of the extracted order history is obtained. Generate and transmit the first screen configuration information to the transmission source of the order history browsing request.

The banquet closing support system of the present invention further has a word of mouth management means,
When the word-of-mouth management means receives a word-of-mouth review request, the word-of-mouth information stored in association with the lunch box ID included in the word-of-mouth review request is extracted and the extracted word-of-mouth information can be viewed on a second screen It is preferable that configuration information is generated and the second screen configuration information is transmitted to a transmission source of the word-of-mouth browsing request.

According to the present invention, it is possible to easily and quickly confirm orders and total orders and breakdowns within a predetermined period.
Further, according to the present invention, at the time of purchasing consideration, it is possible to easily decide whether or not to purchase by looking at the other person's evaluation for the lunch box to be examined.

It is a figure showing the whole lunch ordering system of the present invention. It is a figure for demonstrating the database of the lunch box ordering system of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention. It is an example of the screen which concerns on embodiment of this invention.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. The technical scope of the present invention is not limited by the following embodiments.

  In each embodiment, the system will be mainly described. However, the present invention can also be implemented as a program and method that can be used by a computer. The program can be recorded on any computer-readable medium such as a hard disk, CD-ROM, DVD-ROM, optical storage device, or magnetic storage device. Furthermore, the program can be recorded on another computer via a network.

[System Configuration]
FIG. 1 is a diagram showing a lunch box ordering system (hereinafter also referred to as “the present system”) according to an embodiment of the present invention, an orderer terminal and an orderer terminal using the system. As shown in the figure, an orderer terminal 110 used by an orderer (lunch purchaser) and an orderer terminal 120 used by a contractor (lunch seller) include a mobile communication network (not shown), the Internet, and the like. It is possible to connect to the system 130 via the communication network 90. This system includes a Web server 140 and a database (DB) server 150.
The orderer terminal 110 and the order receiver terminal 120 are a mobile phone, a mobile communication terminal, a personal computer or the like having a web browsing function, and are connected to a communication network such as a mobile communication network (not shown) or the Internet 90 by wire or wireless. Connectable.

FIG. 2 shows the internal functions of the DB server 150.
As shown in FIG. 2, the DB server 150 includes a purchaser management unit and a purchaser DB, a seller management unit and a seller DB, a lunch box information management unit and a lunch box information DB, an order history management unit and an order history database, And word-of-mouth management means and word-of-mouth DB.

The purchaser management means stores and manages information related to the purchaser in the purchaser DB. Table 4 shows an example of information related to the purchaser. Details will be described later.
Except for the point that the “delivery destination” is unnecessary, the information about the seller is the same as the information about the purchaser.
Table 1 shows an example of the lunch box information stored in the lunch box information DB. Details will be described later.
Table 3 shows an example of the ordering history stored in the ordering history DB. Details will be described later.
Table 5 shows an example of word-of-mouth information stored in the word-of-mouth DB. Details will be described later.

[Register Ordering Party]
First, the orderer accesses the ordering system page, completes user registration, and obtains a user ID and password. By including the ID of the organization (company) to which the user (orderer) belongs in the user ID, the organization (company) to which the user belongs can be easily identified from the user ID. Alternatively, the organization (company) to which each user belongs may be specified from the user ID by referring to a table in which the user ID and the company ID are associated with each other.

[Each management method]
An orderer or the like issues a search command by inputting a form or clicking a button from a Web browser activated on the orderer terminal. The Web server 140 calls a search program through the CGI and passes the search condition to each management means such as an order history management means. Each management means that has received the search condition inquires each DB using a search program. Each management unit generates an HTML page based on the search result, and passes it to the Web server 140. The Web server 140 transmits an HTML page to the Web browser.

[Bento order]
The orderer terminal 110 transmits the orderer ID, the lunch box ID, the number, and the date / time to be delivered to the system.
The system receives the order information and stores it in the database 150.

  An example of a flow when the orderer orders a lunch using the orderer terminal 110 will be described. As shown in FIG. 3, the orderer selects “less than 1000 yen”, “1,000 yen to 1,500 yen”, “1,500 yen to 5,000 yen”, “5,000” in “select from price”. Select either “Yen-10,000 Yen” or “10,000 Yen or more” (for example, click with the mouse), or “Search by Situation”, “Meeting”, “Training” Select.

  When “Less than 1000 yen” is selected in “Choose from price”, for example, as shown in FIG. 4, information related to lunch boxes of less than 1,000 yen (names of shops selling, names of lunch boxes, names of prices, prices) ) Is displayed. Further, by selecting “Display” in the “Details” column, it is possible to display detailed information regarding the lunch box in the row.

When “Display” in the “Details” column of FIG. 4 is selected, for example, an order confirmation screen as shown in FIG. 5 is displayed. On the order confirmation screen, “delivery date” is displayed. The “delivery date and time” is about 11:30 on the next day by default, but it is preferable to be able to select or input the date and time after the next day. In addition, on the order confirmation screen, the box lunch photo, detailed description of the box lunch (raw materials, special points, etc.), and the reviews and ratings (rating by the number of ☆) regarding the box lunch currently displayed are also displayed. The
In this order confirmation screen, by selecting “confirm” in the “order” column, the order is confirmed and the order information is transmitted to the system.

[Bento data]
As shown in Table 1, the data related to the lunch box includes the unique lunch box ID assigned to each lunch box, the unique company ID assigned to each sales company, the name of the lunch box, the description of the lunch box, the price, the situation, and the image file. Contains the link destination address.

[Limitation of selectable lunch boxes]
In this system, multiple employees of multiple companies can be registered as orderers. In addition, a plurality of lunch box sellers can be registered. However, not all company employees can buy lunch boxes sold by all lunch box sellers.
For example, the employees of Company A can select all the lunch boxes sold by Sellers A, B and C. The employees of Company B can select the lunch boxes sold by sellers A and B, but cannot select the lunch boxes sold by seller C. The employee of the company may select only the lunch box sold by the seller C.
When providing such a restriction on selection, a table as shown in Table 2 is stored in the database 150 in advance, and the system can select “1” based on the table, and cannot select if “0”. It may be judged.
It is preferable that the lunch box sold by the seller determined to be unselectable is not displayed on the lunch box selection screen. In other words, the lunch selection screen displayed on the orderer terminal 110 of the company A employee displays all the lunch boxes sold by the sellers A, B, and C, but displays them on the orderer terminal 110 of the company B employee. The lunch boxes selected by the sellers A and B are displayed on the lunch box selection screen, and only the lunch boxes sold by the seller C are displayed on the lunch box selection screen displayed on the orderer terminal 110 of the company employees. It is preferable that

[Order for lunch box]
When the system receives the order information, it stores it in the database 150. When a predetermined time (for example, 18:00) has passed, the order information is collected for each seller, and the order information is transmitted to the seller associated with the lunch box ID included in the order information.
For example, an order to the seller A of the employee of Company A, the employee of Company B, and the employee of Company A is transmitted to the seller A. As a transmission method, E-mail may be used, or a facsimile may be used.

[Confirm purchase price]
The screen for confirming the purchase amount is generated based on the ordering history.
As shown in Table 3, for example, the ordering / ordering history is a history of ordering / ordering information including ordering date / time, orderer's personal ID, lunch box ID, ordering date / time, orderer's company ID, delivery date / time , and the like. The ordering information includes ordering information and order information. Order information and order information partially overlap. For example, the ordering information includes “ordering date / time, orderer's personal ID, lunch box ID, contractor's company ID, delivery date / time”. The order information includes “orderer's personal ID, lunch box ID, order date / time, orderer's company ID, delivery date / time”.

[Confirmation of purchase price, by buyer, breakdown: employees]
The purchaser management means stores the ID of the orderer and the ID of the ordering manager (hereinafter also simply referred to as “manager”) in association with each other. Upon receiving an order history browsing request including the manager's ID as a transmission source, the order history management means stores the order history stored in association with the orderer's ID stored in association with the manager's ID. The second screen configuration information that can be extracted and browsed the extracted order history is generated, and the second screen configuration information is transmitted to the transmission source (manager terminal) of the order history browsing request. In this way, the administrator can view the order history (ordered party / type of lunch / quantity / money) stored in association with the orderer ID stored in association with his / her ID.
FIG. 6 shows an example of a purchase price confirmation screen for each purchaser. As shown in the figure, the period to be confirmed is input and “Display” is selected. The period may be input by directly entering a numerical value, selecting a numerical value from a pull-down menu, or displaying a calendar and selecting a specific day from the calendar.
FIG. 6 shows a screen that can be viewed by the manager of the company to which the employee who is the purchaser belongs. The viewable range is the purchase history stored in association with the orderer ID stored in association with the manager ID (generally, information on purchases of employees belonging to the same company as the administrator). Limited to
When the period is specified and “display” is selected, the total purchase amount purchased by all employees of the company is displayed within the period.
Further, it is preferable that the administrator is notified of the total purchase amount purchased by all employees of the company ordered within the predetermined period for every predetermined period without specifying the period and selecting the display. Furthermore, it is preferable that the total purchase amount is automatically settled.
For example, at the beginning of each month, from the beginning of last month to the end of last month, the total purchase amount purchased by all employees of the company ordered is notified to the administrator and settled by automatic deduction from the bank account of the company. It is preferable.
In order to be able to execute such processing, for example, (1) the purchaser management means stores in advance the ID and contact address of the ordering manager in association with each other, and (2) the order history management means has a predetermined order. For each period, the total amount of the order amount of all the purchasers stored in association with the ID of each company is transmitted to the contact address, and this total amount is stored in association with the company ID. Settlement by automatic deduction from.
In addition to the total amount for the entire company, the total purchase amount for each employee is also displayed.
When “display” in the “history” column is selected, details of the purchase history of the employee in the row are displayed. FIG. 7 shows an example of a history displayed when “display” in the “history” column is selected. As shown in the figure, the date of ordering, the name of the shop of the ordering party, the name of the ordered lunch box, and the amount of money are displayed.
In addition, when the operator of this system browses, it is preferable to be able to select the company to which the employee who is the purchaser belongs. That is, it is preferable to be able to view not only the purchase history of employees of Company A but also the purchase history of employees of Company B.

[Confirmation of purchase price, by buyer, breakdown: seller]
FIG. 8 shows another example of a purchase price confirmation screen for each purchaser. As shown in the figure, the period to be confirmed is input and “Display” is selected.
FIG. 8 shows a screen that can be browsed by the manager of the company to which the employee who is the purchaser belongs. For this reason, the viewable range is limited to information related to the purchase of employees of the company.
When the period is specified and “display” is selected, the total purchase amount purchased by the employee of the company is displayed within the period.
In addition to the total amount of the entire company, the total amount of purchase for each seller that is the supplier is also displayed.
When “Display” in the “History” column is selected, details of the order history to the seller in the row are displayed. FIG. 9 shows an example of a history displayed when “display” in the “history” column is selected. As shown in the figure, the date of ordering, the total order amount of the day, etc. are displayed.
FIG. 10 shows an example of a screen displayed when “Display” in the “Details” column of FIG. 9 is selected. As shown in the figure, for the seller of the selected “display” row (in the example of FIGS. 9 and 10, “00 bower”), the date the lunch was delivered, the name of the lunch, The unit price, delivered number, price (unit price x number), and delivery destination are displayed.

  The delivery destination (delivery destination) is stored in the database 150 as purchaser information, for example. Table 4 shows an example of purchaser information. As shown in Table 4, the purchaser information includes the company to which the purchaser belongs, the manager of the company, the purchaser's own personal ID, the purchaser's first and last name, its reading gana, delivery address, and telephone number as contact information. Or email address.

[Review]
When “Write a word of mouth” shown in FIG. 5 is selected, a word of mouth entry screen (FIG. 11) is displayed. In this review entry screen, enter a review and select “☆☆☆”, “☆☆” or “☆” from the pull-down menu, and select “Send”. (Text data) and rating (number of stars) are sent to the system and stored in the database 150.

  The evaluation and word-of-mouth stored in the database 150 are stored together with the lunch box ID, the posting date / time (word-writing transmission date / time), and the personal ID of the poster as shown in Table 5, for example. Before storing the reviews in the database 150, the purchase history of the poster is checked from the poster's personal ID, and the reviews are stored in the database only when it has been confirmed that the lunch to be posted has actually been purchased in the past. 150 may be stored.

90 Internet 110 Orderer terminal 120 Orderee terminal 130 Lunch box ordering system 140 Web server 150 DB server

Claims (5)

Lunch information management means that can provide necessary information when ordering bento boxes via the network, receiving bento order information from the orderer, sending bento order information to the seller, and receiving order information from the seller A lunch order receiving and ordering system comprising: an order history management means for managing the history of orders received; and an order history browsing request receiving means for receiving an order history browsing request;
The order history management means includes:
Manage the date of ordering, the orderer's ID, the ID of the ordered lunch,
When the order history browsing request receiving means receives the order history browsing request, it extracts the order history stored in association with the orderer ID included in the order history browsing request, and extracts the extracted order history. Generating first screen configuration information that can be browsed, and transmitting the first screen configuration information to a transmission source of the order history browsing request ;
The lunch box information management means includes:
Store at least one viewable merchant ID in association with each orderer ID,
Upon receiving the lunch box browsing request, the lunch box ID associated with the seller ID stored in association with the orderer ID included in the lunch box browsing request is extracted, and the lunch box information regarding the extracted lunch box ID is viewed. A lunch box ordering system, characterized in that the fourth screen configuration information is generated and the fourth screen configuration information is transmitted to a transmission source of the lunch box browsing request . Furthermore, it has a buyer management means,
The purchaser management means associates and stores the orderer ID and the ordering manager ID,
Upon receiving an order history browsing request including the order manager's ID as a transmission source, the order history manager manages the order manager's ID in association with the orderer's ID stored in association with the order manager's ID. Extracting the stored order history, generating second screen configuration information capable of browsing the extracted order history, and transmitting the second screen configuration information to a transmission source of the order history browsing request. The lunch box ordering system according to claim 1, wherein Furthermore, it has word-of-mouth management means,
When the word-of-mouth communication management means receives the word-of-mouth browsing request, it extracts word-of-mouth information stored in association with the lunch box ID included in the word-of-mouth review request, and a third screen on which the word-of-mouth information extracted can be viewed lunch ordering system according to claim 1 which generates configuration information, and transmits the third screen configuration information to the sender of the reviews browsing request. A plurality of orderer IDs are stored in association with the ID of one company to which the orderer belongs, and a plurality of seller IDs are stored in association with the ID of the one company. The lunch box ordering system according to claim 1 . The purchaser management means associates and stores in advance the ordering manager's ID and contact address,
The order history management means transmits, for each predetermined period, the total amount of the order amounts of all the orderers stored in association with the ID of each company to the contact address, and further the settlement of the total amount The lunch box ordering system according to claim 2, wherein: