JP3128583B1 - Reservation reception system - Google Patents

Abstract

[Summary] [Problem] To provide a reservation reception system and a server computer suitable for a customer to make a reservation directly. A reservation status table for storing a reservation status for each date, a server computer (4) capable of reading and writing the reservation status table, and a terminal (1) connectable to the server computer via a communication line. Prepare the reservation date by accessing the server computer from this terminal. When the server computer is accessed from the terminal, the server computer refers to the reservation status table to determine a reservation available date and a reservation full date, and it is possible to determine the reservation available date and the reservation full date, and to determine a calendar full date. When the reservation possible date is selected on the terminal, the selection information is transmitted to the server computer, and the reservation data reserved based on the selection information is written in the reservation status table.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention is, Ru <br/> relates to a reservation system that can be reserved the date and time at the customer terminal.

[0002]

2. Description of the Related Art In a conventional reservation receiving system, there is an operator, and a customer makes a reservation by contacting the operator by telephone or the like.

[0003]

By the way, the Internet has been developed in recent years, and it has been studied that customers make direct reservations with a terminal such as a personal computer. However, unlike the operator, the customer is not proficient in the operation, and the operability is not good in the conventional reservation receiving system. In addition, since there are various types of terminals connected to the Internet, it is necessary to minimize the load on the terminals so that the terminals can be used.

[0004] The present invention is intended to solve the above problems, and its object is to provide a reservation system the customer is suitable for direct reservation.

[0005]

According to a first aspect of the present invention, there is provided a reservation receiving system comprising: a reservation status table for storing a reservation status for each date; a server computer capable of reading and writing the reservation status table; A terminal (1) connectable to the server computer via a communication line, wherein the terminal accesses the server computer from the terminal and reserves a reservation date and time;
The reservation status table stores a date to be reserved.
Attached storage unit and a reservation for each date associated with this date
A reservation availability storage unit for storing availability of the
And store the reservation time and customer ID in pairs for each date
That time has and a separate reservation status storage unit, said server
-When the computer is accessed from the terminal,
Referring to reservation availability storage unit of the reservation-like status table, pre
Judgment possible dates and reservation full days are determined.
Reservation date full discrimination color, which is color data different from the approximate possible date
Allocate data and reserve dates and reservations
The reserved full date to which the full color discrimination color data is assigned is counted.
Means for transmitting to the terminal in data in the form of a render;
When receiving the date selection information from the terminal, the reservation status
Reservable time based on table's hourly reservation status storage
Judgment of reservation full time and different from reservation available time
The color data and the color data for determining whether the reservation day is full
The same or similar reservation color
Data is allocated to the reservation full time, and this reservation time full determination
Reservation full time to which color data is assigned and reservation possible
Means for transmitting the active time to the terminal;
Means for receiving an ID, and time selection information from the terminal.
The customer ID, date selection information and time selection information.
The reservation time by pairing the reservation time with the customer ID based on the report
Write to the hourly reservation status storage section of the status table
Means for transmitting a signal to the terminal to the effect that the reservation has been completed,
Of the written reservation time and customer ID by the reservation time
Means to re-arrange in the order of reservation time and this sort
Check the time-based reservation status storage area, and the reservation is full
Judgment whether or not it becomes, reservation is possible when it is full
Means for setting the contents of the refusal storage unit to non-reservable.
And the terminal transmits the server computer
Date in the form of a calendar with availability dates and full availability dates
When the data is received, a calendar is displayed and the reservation is full.
The cup day is indicated with the color of the reservation day full color data.
When the means for indicating and the displayed reservation available date are selected,
Send this date selection information to the server computer
Means and the reservation full from the server computer
When you receive the time and available time,
And the time when the reservation is full.
Is displayed with the color of the reserved time full color data.
When the displayed reservation available time is selected,
Send this time selection information to the server computer
And a customer ID on the server computer.
Transmission means and reservation from the server computer
When a signal indicating completion is received, a message indicating completion of reservation is displayed.
Means .

A reservation receiving system according to a second aspect of the present invention includes a reservation status table storing a reservation status for each date;
A lock table that stores the reservation status of each customer, a server computer that can read and write the reservation status table and the lock table, and a terminal that can be connected to the server computer via a communication line. Access and reserve the reservation date and time. The reservation status table includes a date storage unit that stores a date to be reserved, a reservation availability storage unit that stores availability of a reservation on each date in association with the date,
A time-based reservation status storage unit for storing a reservation time and a customer ID in pairs for each date in association with the date, wherein the server computer allows one person to make a reservation.
The maximum number of reservations that can be set
Access from the reservation status table
To determine the reservation available date and the reservation full date, and
The reservation date full size, which is different color data from the reservation possible date
In addition to assigning separate color data,
And the reservation full to which the reservation date full color data is assigned.
Send the cup date to the terminal in the form of calendar data
Means for receiving the date selection information from the terminal,
Reservable time and reservation full based on about status table
Judging the time, the color data is different from the bookable time
And the same as the color of the reservation date full color data
Or similar full reservation color data for reserved time
Time, and this reserved time full color data is
The assigned reservation full time and reservation available time are
And a customer ID from the terminal.
Means for receiving the time selection information from the terminal;
Check the maximum number of reservations
If the warning message is sent to the terminal,
If the number is not exceeded, the customer ID and date
Reservation time and customer based on selection information and time selection information
Hourly reservation letter in the reservation status table in combination with ID
And write a signal to the effect that the reservation has been completed.
Means for transmitting to the terminal, and after transmitting a signal indicating the completion of the reservation,
Based on the customer ID, date selection information and time selection information
And write the reservation status of each customer in the lock table
Means, and the reservation time and
Sort customer IDs by reservation time and arrange in order of reservation time.
Male means and this sorted hourly reservation status storage unit
Check to determine if the reservation is full,
When it becomes full, the contents of the reservation availability storage section are made unreservable
Setting means, the terminal comprising:
Reservation possible date and reservation full date from computer
When receiving data in the form of a calendar, the calendar is displayed.
In addition to the above, on the reservation full day,
Means for adding and displaying the color of the color data, and the displayed reservation
When an available date is selected, this date selection information is
Means for transmitting to the computer;
Receive the full reservation time and available reservation time from the
Displays the reservation available time and the reservation full time.
In addition, the reserved full time includes a color data for determining whether the reserved time is full.
Means to display the data in color and the displayed reservation is possible
When the time is selected, the time selection information is sent to the server
Means for transmitting to the computer;
Means for transmitting the customer ID to the client,
When the warning data is received from the computer, the warning
Means for indicating that the server computer
Received a signal indicating that the reservation has been completed
Means for performing the following.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of a reservation receiving system according to the present invention will be described with reference to FIGS. FIG. 1 is a schematic diagram of a network for explaining a reservation receiving system according to the present invention. 2A and 2B are explanatory diagrams of a table of the server computer. FIG. 2A is a diagram of a member data table, and FIG. 2B is a diagram of a reservation status table. FIGS. 3A and 3B are explanatory diagrams of a table of the server computer. FIG. 3A is a diagram of a reservable number table, FIG. 3B is a diagram of a lock table, and FIG. FIG. 4 is a diagram of the display screen of the customer terminal, and (a)
Is a diagram of a reservation status by month, and (b) is a diagram of a reservation time table. 5A and 5B are diagrams of a display screen of the terminal, in which FIG. 5A is a diagram of a reservation execution screen of the customer terminal, and FIG. 5B is a diagram of an initial screen of maintenance of the service provider side terminal. 6A and 6B are diagrams of a display screen of the terminal, in which FIG. 6A is a diagram of a setting change execution screen of the service provider terminal, and FIG. 6B is a diagram of a service selection screen of the customer terminal. FIG. 7 is a flowchart at the time of executing the reservation. FIG. 8 is a continuation of the flowchart of FIG. FIG. 9 is a continuation of the flowchart of FIG. FIG. 10 is a flowchart at the time of reservation cancellation, which is a continuation of the flowchart of FIG.

In FIG. 1, a customer's house or the like who reserves services such as massage, hotel, doctor and beauty salon, etc.
A customer terminal 1 composed of a personal computer or the like is installed. The customer terminal 1 can be connected to a communication network 2 such as the Internet via a communication line such as a telephone line. A reservation server computer 4 and a plurality of service provider terminals 6 that provide services can be connected to the communication network 2 via a communication line. Further, an administrator terminal 7 for managing the operation state of the reservation server computer 4 is connected to the reservation server computer 4. The administrator terminal 7 includes an input device such as a keyboard, a personal computer, and the like.
Further, the administrator terminal 7 may be connected to the communication network 2 in some cases.

The customer terminal 1 and the service provider side terminal 6
As described above, a network interface, a central processing unit (CPU) as a control means, a memory such as a RAM, a hard disk (HDD), a display device, an input device including a numeric keypad, a mouse, a keyboard, etc. And so on. The reservation server computer 4 includes a network interface, a central processing unit (CPU) as control means, and a RAM.
And a hard disk (HDD). The customer terminal 1, the service provider terminal 6, and the reservation server computer 4 are connected to a network communication network 2 via a network interface. The server computer 4 for reservation has set up a homepage by a program, and the customer terminal 1 and the service provider terminal 6 have browser software such as a netscape navigator capable of viewing the homepage.

Various tables are stored in a storage area (for example, a hard disk or a RAM) of the reservation server computer 4. Next, this table will be described. The member data table shown in FIG.
Customer information such as D, name, date of birth, address, e-mail address and telephone number is stored. The reservation status table shown in FIG. 2B has a date column serving as a date storage unit for storing a date to be reserved, and a reservation availability column serving as a reservation availability storage unit for storing availability of a reservation on each date in association with this date. And an hourly reservation status storage section, which is an hourly reservation status storage unit that stores the hourly reservation status on each date in association with the date. In the reservation availability column, "0" indicating reservation availability, "1" indicating full reservation, and "2" indicating a holiday are input. In the hourly reservation status storage column,
The reservation status for each date is shown, and the reservation time and customer ID
Are entered in pairs. When a reservation time and a customer ID are newly input, they are sorted by reservation time and rearranged in the order of reservation time. By setting the order of the reservation time, the reservation status for each reservation time can be quickly determined.

FIG. 3A is a table showing the number of people who can be reserved for each reservation time. The table includes a column for reserved time and a column for the number of people who can be reserved. This bookable number of people,
This can be set at the service provider terminal 6. Note that this cannot be performed at the customer terminal 1. FIG. 3 (b)
Is a lock table, which includes a customer ID column and a reservation date / time column indicating the reservation status for each customer ID, and is provided to prevent one person from making a large number of reservations. The maximum number of reservations (for example, about 1 to 2 or 3) that can be reserved by one person is set in the reservation server computer 4, and if the number of reservation dates and times in the lock table is about to exceed the maximum reservation number, the reservation is made. Refuse. FIG.
(C) is a service-specific required time table, which includes a service type column and a required time column. For example, perm is 2 hours, cut is 1 hour,
In order to reserve a permanent, the reservation is refused unless it is free for two consecutive hours. The setting of the required time table for each service can be set by the service provider terminal 6. Note that this cannot be performed at the customer terminal 1. By the way, there are other tables, but they are not very relevant to the present invention, so that the description is omitted.

The date and time are reserved in the reservation receiving system configured as described above. The main flowchart of this reservation will be described. The detailed description is omitted. In this embodiment, a dental clinic is assumed. FIG.
In step 0, for example, a home page address (URL) is input from the customer terminal 1 and this home page address is transmitted via a communication line, and the reservation server computer 4 starts the reservation shown in FIG. Try to access the screen. Then, in step 1, the reservation server computer 4 sends the customer terminal 1
When there is this reservation start access from, the reservation status table shown in FIG. 2B is read, and the reservation availability column is referred to, and the procedure goes to step 2. In step 2, if "1", the day is determined to be a reservation full day, and if "2", the day is determined to be a holiday. If there is a reservation full day, go to step 3; if not, go to step 4. Then, in step 3, red, which is color data for discriminating the reserved day full, is assigned on the reserved full day, and the process goes to step 4. In addition, blue is assigned to the reservable date. These color data are preset in the reservation server computer 4 or the like. In addition, reservations are closed on days prior to the day. Further, when the "status of next month" button is clicked, a calendar indicating the reservation status of the next month is displayed.

In step 4, based on the date and color data, the reservation server computer 4 sends the reservation status data for each date in the form of a calendar shown in FIG. And send it. Then, in step 5, when the customer terminal 1 receives this data, a calendar as shown in FIG. 4A is displayed on the display unit of the customer terminal 1. In FIG. 4A, ○ indicates blue, and て い る indicates that the middle side is painted red. In this way, blue is displayed on a reservation available day and red is displayed on a full reservation day.

Then, in step 6, when the customer clicks and selects a date on the customer terminal 1, the date selection information is transmitted from the customer terminal 1 to the reservation server computer 4 in step 7. In step 8, upon receiving the date selection information, the reservation server computer 4 refers to the reservation status column of the reservation status table of FIG. 2B and the reservable number table of FIG. 3A. Then, when the number of persons reserved for each reservation time has reached the number of persons who can be reserved in the number of persons for reservation table, it is determined that the reservation is full. In this way, it is determined whether or not there is a reservation full time. On the other hand, if there is, go to step 9. In step 9, red, which is color data for discriminating the reserved time full, is assigned to the reserved full time, and the process goes to step 10. In addition,
Blue is assigned to the reservation available time. These color data are set in advance in the reservation server computer 4 or the like.

Next, in step 10, the reservation server computer 4 creates a reservation status time table with reference to the reservation time (ie, the reception time) in the reservable number of people table, and displays red data for the reservation full time. And blue data is allocated to the reservable time, and transmitted to the customer terminal 1 in, for example, an HTML format. Then, in step 11, when the customer terminal 1 receives the transmission of the reservation status time table data from the reservation server computer 4, the customer terminal 1 displays the time table shown in FIG. In FIG. 4B, ○ is blue, and て い る, whose inner side is painted out, is red. In this way, the bookable time is colored in blue, and the reserved time is colored in red.

Next, at step 12, when the customer clicks and selects a reservation time at the customer terminal 1, the time selection information is transmitted from the customer terminal 1 to the reservation server computer 4 at step 13. Then, in step 14, upon receiving the time selection information, the reservation server computer 4
The reservation screen shown in (a) is transmitted. In step 15, the customer terminal 1 displays a reservation screen. Note that a reservation status time table is displayed below the reservation screen for convenience. Then, in step 16, the customer
Enter the consultation ID, date of birth and name of D. This operation is an identification operation, and the identification can be performed by other means. Also, "Sign up."
Select one of "Cancel." After completing these inputs, click the execute button. Then, the consultation ID,
The date of birth, name and data of application / cancel selection (ie, customer confirmation data) are transmitted from the customer terminal 1 to the reservation server computer 4. In step 17, based on the data of the medical examination ID, the date of birth, and the name, the identity is confirmed with reference to the member data table of FIG. 2A. If it is determined that the user is not the principal, the process proceeds to step 18, and data for warning is transmitted to the customer terminal 1. On the other hand, if it is determined that the user is the person, the process proceeds to step 19. At step 19, it is determined whether the application is a cancellation or application. On the other hand, in the case of cancellation, the procedure goes to step 40 in FIG.

In step 20, the reservation server computer 4 determines whether or not the reservation is possible with reference to the reservation status table of FIG. 2B.
The process proceeds to step 21, where warning data is transmitted to the customer terminal 1, and the fact is displayed on the screen of the customer terminal 1.
On the other hand, if the reservation is possible, the process goes to step 22 and
Reference is made to the lock table in (b). Then, in step 23, it is determined whether or not the set number of reservations has been exceeded, and if so, the process proceeds to step 24, where data for warning is transmitted to the customer terminal 1, and Is displayed on the screen. On the other hand, if it is within the reservable range, the process goes to step 25, and the content of the reservation (time and customer ID) is added to the reservation status column of the reservation status table of FIG. Then, the process proceeds to step 26, where the reservation server computer 4 transmits a message indicating that the reservation has been completed to the customer terminal 1 and displays that effect on the screen of the customer terminal 1. Then, in step 27, FIG.
The reserved customer ID is stored in the lock table shown in FIG.
Is written in the column of the reservation date and time corresponding to. In step 28, the reservation status column of the reservation status table is sorted by time and arranged in chronological order to speed up the determination of the next full reservation. Further, in step 29, it is determined with reference to the reservation status column of the reservation status table whether or not the reservation date is full. If it is not full, go to step 31 and end the reservation work. On the other hand, when the reservation is full, the process goes to step 30 and the corresponding reservation availability column is set to 1 so that it can be immediately recognized that the reservation is full. In this way, the calendar shown in FIG. 4A can be quickly displayed at the next access.

On the other hand, in the case of cancellation in step 19, as described above, the process goes to step 40 in FIG. 10, deletes the corresponding reservation from the reservation status column of the reservation status table, and goes to step 41. In step 41, the fact that the reservation cancellation has been completed is transmitted from the reservation server computer 4 to the customer terminal 1. Next, in step 42, the corresponding reservation availability column of the reservation status table is set to 0. Then, in step 43, the process ends.

By the way, the above is the case of a dental clinic, but in the case of a beauty salon, there are cases where a cut takes only one hour and a permanent which takes two hours. Therefore, the reservation screen shown in step 15 is not the one shown in FIG.
(B), and a service selection button is provided. Then, in step 16, the customer has also selected a service (eg, permanent or cut) with this service selection button. Further, between step 23 and step 25, the reservation server computer 4
Refers to the required time table for each service and obtains the time required for the selected service. Then, it is determined whether or not this time can be continuously secured by referring to the reservation status column of the reservation status table. If it cannot be secured, a warning is sent to the customer terminal 1, and if it can be secured, the procedure goes to step 25.

The case where the service provider changes the setting of the reservation time (that is, the reception time) and the number of people who can make a reservation (that is, the setting of the number of people who can make a reservation in FIG. 3A) will be described. The service provider terminal 6 accesses the maintenance page of the reservation server computer 4. In that case, the homepage address is naturally different from the initial screen of the reservation. Then, when there is an access from the service provider side terminal 6, the reservation server computer 4 transmits the screen of FIG. 5B to the service provider side terminal 6. Then, FIG. 5B is displayed on the screen of the service provider terminal 6, and the service provider inputs a password and presses an enter key. Then
The password is transmitted to the reservation server computer 4, and the reservation server computer 4 stores a service provider table (not shown) provided in the reservation server computer 4 (pairs of service provider IDs and passwords). To see if it is a service provider. In this way, it is possible to prevent a customer or the like from entering the maintenance work screen. If the user is a service provider, the reservation server computer 4 transmits a setting change page shown in FIG. Upon receiving the transmission, the service provider terminal 6 displays a setting change page. The service provider inputs what time and what minutes as the reception time, inputs the number of people who can make a reservation, and inputs a check. Then, click the update button. Then, this input data is transmitted from the service provider side terminal 6 to the reservation server computer 4, and the reservation server computer 4 rewrites the reservable number table.

On the other hand, when deleting the reservation reception time, a check is made to delete from the reception time. Then, the input data is transmitted from the service provider side terminal 6 to the reservation server computer 4, and the reservation server computer 4 deletes the corresponding reception time from the reservation possible number table. The update result and the deletion result are transmitted from the reservation server computer 4 to the service provider terminal 6, and displayed at the lower part of the screen of the service provider terminal 6, as shown in FIG.

The service provider can set holidays, search for customers, search for reservation status, and the like, in addition to changing the settings of the reception time and the number of people who can make reservations. The description is omitted. In addition, since the customer is not informed of the reservation setting change password given to the service provider, it is prohibited to change the setting of the reception time and the number of people who can make a reservation on the customer terminal 1. The reservation can be executed by the user side terminal 6. Further, in order to manage the operation state of the reservation server computer 4, an administrator password is required.
Since it has not been taught to customers and service providers,
The operation state of the reservation server computer 4 cannot be changed at the customer terminal 1 and the service provider terminal 6.

In this way, the reservation server computer 4 1) creates a reservation status data for each date by referring to the reservation status table when the reservation start access is made from the customer terminal 1, Means for transmitting to the terminal 1;
2) means for creating reservation status data for each reservation time by referring to the reservation status table when the date selection information is input from the customer terminal 1 and transmitting it to the customer terminal 1; When the selection information is input, it is determined whether or not a time corresponding to the selected service can be secured in the reservation status table. If the time can be secured, the reservation work is continued. Means for rejecting the request (sending a warning to the customer terminal 1); 4) When the time selection information is input from the customer terminal 1, the reservation data is transmitted based on the information such as the date selection information, the time selection information and the individual ID. It has means for writing to the reservation status table. When the customer terminal 1 receives 1) reservation status data for each date from the reservation server computer 4,
Means for displaying the reservation calendar on the screen; 2) means for displaying the reservation status time table on the screen when the reservation status data for each reservation time is input from the reservation server computer 4; and 3) service. Then, a means for transmitting the service selection information to the reservation server computer 4 is provided. Further, the service provider side terminal 6 is configured to be able to transmit the rewriting data of the reservation time and the maximum number of reservable persons for each reservation time to the reservation server computer 4 by the operation of the service provider. When the server computer 4 receives the rewriting data of the reservation time and the maximum reservable number of persons for each reservation time from the service provider terminal 6, the server computer 4 sets the maximum reservation time for each reservation time and reservation time such as a reservation status table and a maximum number of reservation persons table. A means for rewriting the number of people who can make a reservation is provided. As described above, in the reservation receiving system, in addition to the above-described means, means for executing the action are provided in each of the members that perform the action, in correspondence with the respective actions to be executed.

As described above, in this embodiment,
In the reservation status column of the reservation status table, a plurality of pairs of the reservation time and the customer ID are stored, so that the reservation server computer 4 does not have to be arranged in a tree structure with respect to the dates. Loading can be reduced. Also, after adding a new reservation,
Since the images are sorted in order of date, it is possible to quickly determine whether or not the reservation is full at the time of the next reservation. Moreover,
Since this rearrangement is performed after the reservation is completed, it is possible to minimize waiting for customers.

The embodiment of the present invention has been described above in detail.
The present invention is not limited to the above embodiment,
Within the gist of the present invention described in the claims,
Various changes can be made. Modification examples of the present invention are exemplified below. (1) In the embodiment, provided services are:
Any service that can be reserved by date or date and time is possible. (2) In the embodiment, the customer confirmation is made by the customer I
D, the date of birth and the name are used, but it is also possible to confirm by other means. (3) In the embodiment, the terminal is a personal computer, but may be another terminal, such as a mobile phone or a dedicated terminal. (4) In the embodiment, the various tables are provided on the reservation server computer, but may be provided outside the reservation server computer (that is, on another server computer or the like). Various settings such as the maximum number of reservations that can be reserved by one person can also be provided outside the reservation server computer (that is, another server computer or the like). (5) In the embodiment, red, which is the color data for determining whether the reserved time is full, is attached to the date or the reserved time by coloring a circle provided with the date or the reserved time. The way of coloring can be changed as appropriate, and the date or the reserved time can be added to the date or the reserved time by directly coloring the date or the number of the reserved time. (6) The communication line can be wired or wireless. (7) The service types in the service-specific required time table are permanent and cut, but the service type can be selected as appropriate. For example, if your teeth are broken at the first visit (1 hour), if your teeth are painful at the first visit (30 minutes),
It is also possible to provide three types of re-examination (30 minutes). In addition, when selecting a service, the time required together with the service is displayed, and the service can be substantially selected by selecting the required time.

[0026]

According to the present invention, the server computer refers to the reservation status table to determine a reservation available date and a reservation full date, and it is possible to determine the reservation available date and the reservation full date, and When the reservation available date displayed on the terminal is selected in the form of a calendar and selected on the terminal, the selected information is transmitted to the server computer.
Therefore, the customer can easily determine the reservation available date and the reservation full date, and can easily make a reservation by selecting this date. As a result, customers can easily and directly make reservations without an operator.

Further, the reservation possible date and the reservation full date can be distinguished and displayed on the terminal in the form of a calendar. When the reservation possible date displayed on the customer terminal is selected, this date selection information is stored in the server. Sent to the computer, when the server computer receives the date selection information, it determines the reservation available time and the reservation full time based on the reservation status table and displays it on the customer terminal so that the reservation available time and the reservation full time can be distinguished Then, when the reservable time displayed on the customer terminal is selected, the time selection information is transmitted to the server computer. Therefore, the date and time can be easily reserved by selecting a date on a calendar from which a reservation possible date and a reservation full date can be distinguished and by selecting a time on a reservation time table from which a reservation possible time and a reservation full time can be distinguished. be able to.

Further, the server computer assigns the reserved day full color data, which is color data different from the reserved date, to the reserved full day, and also assigns the reserved date and the reserved day full color data. Sends the full reservation day to the terminal in the form of a calendar,
In addition to displaying the calendar, the full reservation day is displayed with the color of the color data for discriminating the full reservation date, and when the available reservation date displayed on this terminal is selected, this date selection information is sent to the server computer. Sent, the server computer receives the date selection information, determines the reservation available time and the reservation full time based on the reservation status table,
Reserved time full discrimination color data that is different from the reservable time and is the same as or similar to the color of the reserved date full discrimination color data is assigned to the reserved full time, and the reserved time full discrimination color data is assigned. The reservation full time and the reservation available time are transmitted to the terminal. Therefore, the color data allocation process is performed on the server computer side, the load on the terminal side can be reduced, and it is possible to support various terminals used in the Internet and the like. Moreover, since the color of the reservation full time and the color of the reservation full day are substantially the same, it is possible to easily make a reservation even if the user is not familiar with the operation.

The reservation status table includes a date storage unit that stores the date of the reservation, a reservation availability storage unit that stores the availability of the reservation on each date in association with this date,
A time-based reservation status storage unit for storing a reservation status for each time on each date in association with a date, and when determining a reservation possible date and a reservation full date, a reservation availability storage unit of a reservation status table. After writing the reservation data in the hourly reservation status storage section of the reservation status table, check the hourly reservation status storage section to determine whether the reservation is full. However, when it becomes full, the contents of the reservation availability storage unit may be set to non-reservable. In such a case, the reservation possible date and the reservation full date can be easily determined in the reservation availability storage unit, and it is possible to immediately respond to the access from the customer. Moreover, the work of setting the contents of the reservation availability storage unit to non-reservation is performed after the reservation data is written in the reservation status storage unit by time of the reservation status table, so that the reservation operation is not hindered and Can be shortened as much as possible. And the reservation letter in the reservation status table
In the status column, a plurality of pairs of reservation time and customer ID are stored.
Each reservation time is arranged in a tree with respect to the date.
More load on the server computer than if it were deployed
Can be reduced. Also, a new schedule
After adding about, it is sorted by date, so next time
Quickly determine whether a reservation is full when making a reservation
Can be. Moreover, this sort is done after the reservation is completed.
To keep customers waiting as little as possible
Can be.

The server computer can read and write a lock table that stores the reservation status of each customer separately from the reservation status table, and sets the maximum reservable number that can be reserved by one person. When a reservation is made, the lock table is referred to, and if the number exceeds the maximum reservable number, the reservation may be rejected. In such a case, the mistake of making many reservations by one person can be prevented as much as possible.

[Brief description of the drawings]

FIG. 1 is a schematic diagram of a network for explaining a reservation receiving system according to the present invention.

FIGS. 2A and 2B are explanatory diagrams of a table of a server computer. FIG. 2A is a diagram of a member data table, and FIG. 2B is a diagram of a reservation status table.

FIGS. 3A and 3B are explanatory diagrams of a table of a server computer. FIG. 3A is a diagram of a reservable number of people table, FIG. 3B is a diagram of a lock table, and FIG.

FIGS. 4A and 4B are diagrams of a display screen of the customer terminal, in which FIG. 4A is a diagram of a monthly reservation status, and FIG. 4B is a diagram of a reservation timetable.

5A and 5B are diagrams of a display screen of the terminal, in which FIG. 5A is a diagram of a reservation execution screen of a customer terminal, and FIG. 5B is a diagram of an initial screen of maintenance of a service provider terminal.

6A and 6B are diagrams of a display screen of the terminal, FIG. 6A is a diagram of a setting change execution screen of the service provider terminal, and FIG. 6B is a diagram of a service selection screen of the customer terminal.

FIG. 7 is a flowchart at the time of executing a reservation.

FIG. 8 is a continuation of the flowchart of FIG. 7;

FIG. 9 is a continuation of the flowchart in FIG. 8;

FIG. 10 is a flowchart at the time of reservation cancellation, which is a continuation of the flowchart in FIG. 8;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Customer terminal 4 Server computer for reservation 6 Terminal of service provider 7 Administrator terminal

Continuation of the front page (56) References JP-A-10-149391 (JP, A) JP-A-9-69127 (JP, A) JP-A-1-116880 (JP, A) FUJITSU HOPE / EGMA IN for Windows Explanation (Hospital Management System / General Order System), Fujitsu Limited, April 1996, first edition, p. 73-78 (58) Field surveyed (Int. Cl. ⁷ , DB name) G06F 17/60 126 JICST file (JOIS)

Claims (2)

(57) [Claims] 1. A reservation status table for storing a reservation status for each date, a server computer capable of reading and writing the reservation status table, and a terminal connectable to the server computer via a communication line. A reservation reception system for accessing a server computer to reserve a reservation date and time, wherein the reservation status table stores a date to be reserved.
Attached storage unit and a reservation for each date associated with this date
A reservation availability storage unit for storing availability of the
And store the reservation time and customer ID in pairs for each date
A time-based reservation status storage unit, wherein the server computer accesses from the terminal.
If there is, refer to the reservation availability storage section of the reservation status table.
To determine the reservation available date and the reservation full date.
Reservation date full, which is a color data different from the reservable date
In addition to assigning the color data for cup identification,
And a reservation to which reservation date full color data is assigned
Send full days to the terminal in the form of calendar data
Means for receiving date selection information from the terminal,
Based on the hourly reservation status storage unit in the reservation status table,
Judgment about available time and reservation full time, and possible reservation time
It is different from the color data and the reservation day full judgment
Reservation time full or similar to the color of the color data
The color data for determination is assigned to the reserved full time,
The reserved full time to which the full / full color data is assigned
Means for transmitting to the terminal information and a reservation available time,
Means for receiving the customer ID from the end, and time selection from the terminal.
Selection information, the customer ID, date selection information and
The reservation time and the customer ID are paired based on the time selection information.
In the hourly reservation status storage section of the reservation status table.
And sends a signal to the terminal indicating that the reservation has been completed.
Reservation of means, this written reservation time and customer ID
Means to sort by time and rearrange in order of reserved time
Check the hourly reservation status storage section of
Determines whether the reservation is full and when it is full
Means to set the contents of the reservation availability storage unit to non-reservable
Provided with a door, the terminal, the reservation from the server computer
Data in the form of a calendar of available dates and full days of reservations
When you receive it, a calendar will be displayed and the reservation full day
Is displayed with the color of the color data for discriminating whether the reservation day is full.
When the available reservation date and the displayed reservation available date are selected,
Means of sending date selection information to server computer
And the reservation full time from the server computer
When you receive the reservation time and the reservation time,
In addition to displaying the full time, the reserved full time
A method for adding and displaying the color of the color data for determining whether the reservation time is full.
At this time, when the column and the displayed available time are selected,
Sending the selection information to the server computer
And transmitting the customer ID to the server computer.
Means for making a reservation completion from the server computer.
Means for indicating that the reservation has been completed upon receipt of a signal to the effect
A reservation receiving system comprising: 2. A reservation status table for storing a reservation status for each date, a lock table for storing a reservation status for each customer, a server computer capable of reading and writing the reservation status table and the lock table, and communicating with the server computer. A terminal that can be connected via a line, a reservation receiving system that accesses a server computer from this terminal to reserve a reservation date and time, wherein the reservation status table includes a date storage unit that stores a date to be reserved. A reservation availability storage unit that stores the availability of a reservation on each date in association with this date; and an hourly reservation status storage unit that stores a pair of a reservation time and a customer ID for each date in association with the date. The server computer has the maximum
The number of available reservations is set, and
If there is access, refer to the reservation status table and reserve
Judgment possible dates and reservation full days are determined.
Reservation date full discrimination color, which is color data different from the approximate possible date
Allocate data and reserve dates and reservations
The reserved full date to which the full color discrimination color data is assigned is counted.
Means for transmitting to the terminal in data in the form of a render;
When receiving the date selection information from the terminal, the reservation status
Table to determine available reservation time and full reservation time.
And the color data is different from the bookable time
The same or kind to the tint of the reservation date full discrimination Irode over data
The similar reserved time full judgment color data is divided into the reserved full time.
And the reserved time full color data is assigned.
Send the full reservation time and the available reservation time to the terminal
Means for receiving, a means for receiving a customer ID from the terminal,
Upon receiving the time selection information from the terminal, the lock table
If the number exceeds the maximum reservable number
Sends warning data to the terminal,
If not, the customer ID and date selection information
And the reservation time and the customer ID based on the time selection information.
Hourly reservation status storage unit of the reservation status table as a pair
To the terminal and send a signal to the terminal
Means for communicating, and after transmitting a signal indicating that the reservation has been completed, the customer
Customer based on ID, date selection information and time selection information
Means for writing each reservation status in the lock table;
The reservation time and customer I written in the reservation status table
D and sort by reservation time and rearrange in order of reservation time
Means and the sorted hourly reservation status storage section.
To determine if the reservation is full,
When the reservation becomes unavailable, the contents of the reservation availability storage
Means for executing the reservation from the server computer.
Data in the form of a calendar of available dates and full days of reservations
When you receive it, a calendar will be displayed and the reservation full day
Is displayed with the color of the color data for discriminating whether the reservation day is full.
When the available reservation date and the displayed reservation available date are selected,
Means of sending date selection information to server computer
And the reservation full time from the server computer
When you receive the reservation time and the reservation time,
In addition to displaying the full time, the reserved full time
A method for adding and displaying the color of the color data for determining whether the reservation time is full.
At this time, when the column and the displayed available time are selected,
Sending the selection information to the server computer
And transmitting the customer ID to the server computer.
Means for transmitting the warning data from the server computer.
Means for displaying a warning when receiving the data,
Receives a signal from the server computer that the reservation has been completed
Means for indicating that the reservation has been completed.
A reservation reception system characterized by the following.