JP3344933B2 - Service reservation management system and recording medium storing a program for causing a computer to perform processing in the system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a service (service).
Regarding the service reservation management system that manages reservations related to
More specifically, the present invention relates to a service reservation management system capable of making a reservation without fail in consideration of the availability of equipment and equipment for services performed in predetermined equipment while using the equipment.

[0002]

2. Description of the Related Art For example, in the so-called estics industry, services (beautification, hair removal, slimming, etc.) are carried out in prescribed equipment (bed) using prescribed equipment. Conventionally, such time management of services is performed by a clerk writing a reservation in a notebook or the like.

[0003] When the service is performed on a facility (bed or the like), the reservation is substantially a reservation for use of the facility. Therefore, the note for performing the reservation management describes how services are temporally allocated (whether reserved) for all of the owned facilities.

[0004]

In the case where the facilities that can be implemented differ depending on the service, if a reservation for a certain service is entered on a notebook in which all the facilities held as described above are written, it is erroneous that Services may be assigned to equipment that cannot be implemented. In such a case,
Unless the equipment that should have been reserved on the day of the reservation is not vacant, the service cannot be actually provided.

[0005] Therefore, a first object of the present invention is to provide a service reservation management system which can prevent a service from being erroneously assigned to equipment that cannot be originally implemented. A second object of the present invention is to provide a recording medium storing a program for causing a computer to perform the processing in the service reservation management system.

[0006]

According to a first aspect of the present invention, there is provided a service reservation management system according to the first aspect of the present invention, which is capable of performing services and services. First table means describing the relationship with
Second table means describing the reservation status regarding the use time for the service of each facility, reserved service acquisition means for acquiring the service related to the reservation, and the contents described in the first and second table means. A reservation screen display control means for selectively displaying, on a display unit, a reservation status relating to a use time of a facility which can be performed by the service acquired by the reservation service acquiring means, and a facility for performing the service. It is configured to have reservation input means for inputting reservation information relating to use time, and reservation update means for updating the contents described in the second table means based on the reservation information input by the reservation input means. You.

In the service reservation management system as described above,
The reservation status relating to the use time of the facility that can be performed by the acquired service among all the facilities is selectively displayed on the display unit. Then, when the user inputs the reservation information while viewing the reservation status, the contents of the second table means are updated based on the reservation information. The service obtaining means may obtain the information on the service inputted from the input means such as a keyboard, or may read the information on the service electronically, magnetically or optically from a card or the like to a predetermined device (reader). ) May be obtained.

The reservation information input by the reservation input means includes a reservation date and a reservation time zone. In view of the fact that, when there is a device required for the execution of each service, the reservation management can be performed at the same time. And a third table means for describing the time vacant state of each device, and the reservation screen display control means further includes the first and the above. With reference to the contents of the third table means, the reservation status is displayed on the display unit so as to represent a state in which the equipment necessary for the service is not idle and the reserved state is already expressed, and the reservation input means And a reservation device updating means for updating the contents of the third table means relating to the equipment obtained from the contents of the first table means based on the inputted reservation information. .

[0009] In such a system, the reservation status is displayed so as to represent the reserved status when the equipment required for the service related to the reservation is not idle, so that the reservation status is checked. This prevents the user from making a reservation for the service at a time when the necessary equipment is not idle. In view of the fact that it is possible to properly cope with the case where the facilities are different in the execution stage of each service, the present invention provides, in each of the service reservation management systems, the first table means as described in claim 3. Describes the equipment that can be performed in accordance with the stage of execution of each service,
The reservation service acquiring means acquires the service execution stage together with the service related to the reservation, and the reservation screen display control means displays the facility reservation status according to the acquired service execution stage on the display unit. It can be configured to be.

The execution stage of the service can be quantified by the number of executions, the execution time, and the like. Further, in the case where a period in which a service can be executed is determined, from the viewpoint that the reservation can be performed accurately, the present invention provides the above-mentioned service reservation management system further comprising: The fourth table means describing the relationship between the service and the service available period, and the reservation information obtained by the reservation obtaining means and the contents of the fourth table means can be compared to make a reservation for the service. And a determination unit for determining whether or not the determination is made.

[0011] The service available period includes a valid period during which the service provided by the contract or the like can be provided. Further, if the service cannot be performed continuously for a certain period of time due to the nature of the service, the previous period may be used. The period after the elapse of a certain period from the execution time is the feasible period. In order to solve the second problem, the present invention describes a relationship between each service and a facility capable of performing the service when the service related to the reservation is acquired, as described in claim 5. Using the first table means described above and the second table means describing the reservation status relating to the use time for the service of each facility, and causing the computer to perform processing in a system for performing reservation management of the service. A storage medium storing a program, which refers to the contents described in the first and second table means, and relates to a use time of a facility which can perform a service acquired by the reserved service acquiring means. A reservation screen display control step for selectively displaying the reservation status on the display unit; and a reservation input step for acquiring reservation information on the use time of the facility to perform the service inputted from the input means. When configured as a recording medium storing a program having a reservation update step of updating the content described in the second table means based on the reservation information input by reservation inputting step.

[0012]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows an example of a hardware configuration of a computer system for realizing a service reservation management system according to an embodiment of the present invention. This service reservation management system is used, for example, to manage reservations for services (esthetic services such as facial beauty, hair removal, and slimming) provided to its members at a so-called aesthetic salon.

In FIG. 1, this system includes a CPU (Central Processing Unit) 10 for controlling the entire system,
It has a memory unit 11, a display unit 12, an input unit 13, a card read / write unit 14, a disk unit 15, and a CD-ROM drive unit 16. The above units are interconnected via a bus. The memory unit 11 includes a ROM (read only memory) and a RAM (random access memory), and stores programs executed by the CPU 10, necessary data obtained in the course of processing by the CPU 10, and the like. The display unit 12 has a display screen composed of a CRT, an LCD, or the like, and information on reservation status, input reservation data (date and time) created in a service reservation management process (details will be described later) executed by the CPU 10. And so on.
The input unit 13 has a keyboard and a mouse, and is used by a user to input information necessary for the service reservation management processing such as instruction information and reservation data (date and time) to the system.

The card read / write unit 14 comprises:
For example, the information is read from a member card that magnetically stores the information, and the information is written to the member card. The member card includes, for example, a member code for identifying a member, a service code for identifying a service course contracted by the member, the remaining amount (number of times, time) of contracted services, the next reservation date and time, and the like. Information is recorded.

The disk unit 15 is composed of a hard disk device, and is a program executable in the system.
Files and various tables are stored. The program related to the service reservation management process is, for example, CD-RO
Provided to the system by M100. That is, a CD-ROM in which a program related to the service reservation management process is stored.
When the ROM 100 is set in the CD-ROM drive unit 16, the program is stored in the CD-ROM 10
0 to the disk unit 15 via the CD-ROM drive unit 16. Then, after the program relating to the service reservation management processing is read from the disk unit 15 and stored in the memory unit 11, the CPU 10 executes the processing relating to the reservation management according to the program in the memory unit 11.

The disk unit 15 stores a service master file, a facility master file, a device master file, a reservation condition table, a service application file, and a service daily report file, and a reservation database and a device reservation database are constructed. . In the service master file, for example, as shown in FIG. 2, information on each service course (service code, course name, processing unit (number of times, time), total processing amount of each service course (number of times, time), symbols,
Validity period, implementation interval) are described. In the information on the service course, the “execution interval” refers to a minimum time interval at which the member can receive the service (beauty, hair loss, slimming, etc.). Therefore, the member cannot receive the service at intervals shorter than the “execution interval”.

In an aesthetic salon, services (beautiful face,
Hair loss, slimming, etc.) are basically performed on a bed. And the bed suitable for the service is decided. In the facility master file, for example, as shown in FIG. 3, information (facility code, facility name, facility type) on facilities (beds) provided by the salon for each service is described. In the "facility type", the type of the facility (bed) (shared bed, (A) and (B) beds for beauty treatment, hair removal bed, slimming bed, etc.) is described. Here, that the “facility type” is “shared” indicates that the facility (bed) can be used for any service in the salon.

In the device master file, for example, as shown in FIG. 4, information (device code, device name, number of devices) used for various treatments in services provided by the salon is described. . The reservation condition table is
For example, as shown in FIG. 5, each service (service code) and equipment (bed) type required for performing the service,
Describes the relationship with devices. Depending on the service (course), the facilities and equipment required in the course of implementation may change. In order for the information to be reflected in the reservation condition table, the reservation condition table describes the equipment type and equipment corresponding to the execution stage (number of times, time) of each service. The availability of equipment and equipment required for each service determines the success or failure of the corresponding service reservation.

In the service application file, for example, as shown in FIG. 6, information (member code, applied service code, application date) relating to the status of application of the service by the member is described. Further, in the service daily report file, for example, as shown in FIG. 7, the service (service code) actually provided to each member (member code) and its date (execution date) are described.

Further, in the reservation database, for example, as shown in FIG. 8, services (service codes) reserved in each time zone (start time, end time) of each day (reservation date), and are used for the same. Equipment (equipment code) and reservation member (member code) are described. With this reservation database, the reservation status of each service can be grasped. Also,
In the device reservation database, for example, as shown in FIG. 9, each time zone (start time, end time) of each day (reservation date)
The device (device code) reserved at the time of the start is described, and the reservable remaining number of the device is described in the time zone. From the device reservation database, the reservation status of each device and the number of devices that can be reserved (reservable remaining number) can be grasped.

The CPU 10 executes a service reservation management process according to, for example, a procedure shown in FIG. In FIG. 10, when a member or a staff member receiving a request from the member sets a member card in the card read / write unit 14 in order to make a next reservation, the card read / write unit 14 changes the member card from the member card. The read information is acquired by the CPU 10 (S1). For example, as shown in FIG. 11A, the member card includes a member code for specifying a member, a service code for specifying a service (course) contracted by the member, and a service code for receiving the service (course). The number of remaining times (remaining time) and the reservation date (not recorded before reservation) are recorded. Such information is read into the system.

When the reading of the membership card is completed, a date input screen is displayed on the display unit 12.
When the member or a staff member receiving a request from the member inputs a date on the date input screen using the input unit 13, the input date is acquired by the CPU 10 (S
2). Then, it is determined whether or not the service contracted by the member can be executed on the input date (S3). Specifically, the “application date (contract date)” of the service described by the member described in the service application file (see FIG. 6) and the “effective period” of the service described in the service master file (see FIG. 2) It is determined whether or not the input date is within the expiration date of the contract (application date + expiration period). In addition, the previous “execution date” of the service for the member described in the service daily report file (see FIG. 7) and the “execution interval” described in the service master file (FIG. 2)
It is determined whether or not the input date has passed a date equal to or longer than the execution interval from the previous execution date (input date ≧ previous execution date + execution interval).

If the result of the above determination indicates that the contract service cannot be performed for the member, the date input screen is displayed again on the display unit 12, and the above-described determination processing is performed on the newly input date. Done. On the other hand, as a result of the above determination, if the contracted service can be performed for the member, it is determined from the remaining number of obtained services that the stage of execution of the relevant service (day or hour) is determined. Is calculated (S
4). Specifically, based on the total number of times of the relevant service described in the service master file (see FIG. 2) and the obtained remaining number, the calculation is performed according to the total number−the remaining number + 1. In the example shown in FIG. 11, the total number of times of the “beauty course” (service code E001) is 30 (see the service master file (FIG. 2)), and the remaining number is 1
Since it is 0 times, the next time is the 21st time (30-10 + 1)
Is recognized.

When the execution stage (how many times) of the service is determined in this way, referring to the reservation condition table (see FIG. 5), the equipment that can be used in the service in the determined execution stage is referred to. The type is searched. 21 of "Beautiful face" course
At the second time, a bed (facilities) for beauty treatment (B) and a shared bed can be used. Then, an equipment code representing the equipment corresponding to the obtained equipment type is retrieved from the equipment master file (see FIG. 3) (S5). In the case of the 21st of the “Beauty” course, as the usable equipment, the first bed (B001), the second bed (B002) and the fourth bed (B004) are obtained.

Further, a reservation condition table (see FIG. 5)
, A device required for the service at the determined execution stage is searched. In the 21st “Beauty” course, no equipment
1 (K001) and device 02 (K002). Then, referring to the device reservation database (see FIG. 9), the availability of these obtained devices (device codes) in each time zone of the input date is checked (S6). If the number of remaining reservations in the time zone checked in the device reservation database is “0”, the device cannot be used in that time zone. That is, the service using the device cannot be reserved in the time zone.

When the above-mentioned processing is completed, the usage status (vacancy status) of each of the acquired facilities (beds) in each time zone in the input date is checked with reference to the reservation database (see FIG. 8). The check result is displayed on the display unit 12 as a reservation registration screen, for example, as shown in FIG. 12 (S7). In the example shown in FIG.
Reserved time zone (shaded area) and available time area (blank area) for the 1st bed, 2nd bed, 4th bed that can be used in the first "Beauty" course on the input date (August 10) Is displayed in the time schedule format. Also,
The time zone (from 15:00 to 15:30 in the example of FIG. 12) in which there is no vacancy of the equipment used in the service (reservable remaining amount “0”, see the equipment reservation database shown in FIG. 9) is also reserved. It is displayed as a time zone (shaded area).

As described above, when the user sees the reservation registration screen displayed on the display unit 12 and there is no convenient time zone for the member, for example, the operation of canceling the reservation by the input unit 13 is performed (S8, NO). When the processing is completed, the membership card set in the card read / write unit 14 is left as it is,
Is discharged from

On the other hand, if the member has a convenient time zone,
The start time (for example, 1
5:30), end time (for example, 16:30), and equipment code (B004: No. 4 bed) are input and designated (S
8, YES), the designated time zone (15:15) of the input date (for example, August 10) in the reservation database (see FIG. 8).
From 30 to 16:30), the facility code, the service course, and the member code are registered (S9). Then, the reservation remaining amount in the designated time zone of the input date of each device used in the service in the reservation device database (see FIG. 9) is reduced by "1" (S10).

Thereafter, a process for updating the reservation date and the reservation time recorded on the membership card is performed based on the input date and the start time of the designated time zone (S11).
That is, the card read / write unit 14 writes the input date and the start time on the member card as the reservation date and the reservation time. As a result, for example, the membership card written as shown in FIG. 11B is ejected from the card read / write unit 14.

According to the system as described above, the reservation registration screen displays only the reservation status of facilities (beds) that can be used for the service (course) contracted by the member who intends to make a reservation, Since the user can make a reservation while looking at the information, it is possible to reliably prevent the user from mistakenly making a reservation for a facility (bed) used only for another service. In addition, the reservation status of the equipment necessary for the execution of the service is also displayed on the reservation registration screen at the same time, so that the reservation of the time period when the equipment required for the service is not open can be surely prevented.

In the above example, the reservation condition table (FIG. 5)
) Corresponds to the first table means, the reservation database (see FIG. 8) corresponds to the second table means, the processing in step S1 (see FIG. 10) corresponds to the reservation service acquisition means, and step S4 The processing from S7 to S7 (see FIG. 10) corresponds to the reservation screen display control means. The processing in the input unit 13 and step S2 corresponds to the reservation input means, and the processing in step S9 (see FIG. 10) corresponds to the reservation update means.

Further, a device reservation database (see FIG. 9)
Corresponds to the third table means, and the processing in step S10 corresponds to the reserved device updating means. Further, a service master file (see FIG. 2), a service application file (effective date: application date, contract date) (see FIG. 6), and a reservation database (execution interval start date: previous execution date) (see FIG. 6) 8) corresponds to the fourth table means, and the processing in step S3 (see FIG. 10) corresponds to the determination means.

[0033]

As described above, according to the present invention as set forth in claims 1 to 4, the reservation status regarding the use time of the facility which can be performed by the acquired service among all the facilities is selectively set. Is displayed on the display unit, the reservation operation is performed while observing the reservation status, so that it is possible to prevent erroneous assignment of services to equipment that cannot be originally performed.

According to the fifth aspect of the present invention, it is possible to provide a recording medium storing a program for causing a computer to perform the processing in the service reservation management system as described above.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a hardware configuration example of a computer system to which a service reservation management system according to an embodiment of the present invention is applied.

FIG. 2 is a diagram showing an example of the contents of a service master file.

FIG. 3 is a diagram showing an example of the contents of an equipment master file.

FIG. 4 is a diagram showing an example of the contents of a device master file.

FIG. 5 is a diagram showing an example of the contents of a reservation condition table.

FIG. 6 is a diagram showing an example of the contents of a service application file.

FIG. 7 is a diagram showing an example of the contents of a service daily report file.

FIG. 8 is a diagram showing an example of the contents of a reservation database.

FIG. 9 is a diagram showing an example of the contents of a device reservation database.

FIG. 10 is a flowchart illustrating a procedure of a service reservation management process.

FIG. 11 is a diagram showing a display example of a membership card.

FIG. 12 is a diagram showing an example of a reservation registration screen displayed on a display unit.

[Explanation of symbols]

 Reference Signs List 10 CPU 11 Memory unit 12 Display unit 13 Input unit 14 Card read / write unit 15 Disk unit 16 CD-ROM driver

──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Seichiro Kotani 1-12-11, Shimodori, Kumamoto-shi, Kumamoto Pref.Minnobu Co., Ltd. No. 27 Fujitsu Minami Kyushu System Engineering Co., Ltd. (72) Inventor Hiroyuki Ogata 2081-27 Tahara, Mashiki-cho, Kamimashiki-gun, Kumamoto Prefecture Fujitsu Minami Kyushu System Engineering Co., Ltd. (JP, A) JP-A-9-223179 (JP, A) JP-A-9-128446 (JP, A) JP-A-8-242435 (JP, A) JP-A-7-49908 (JP, A) ( 58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 17/60 124 JICST file (JOIS)

Claims (5)

(57) [Claims] 1. A first table means for describing a relationship between each service and a facility capable of performing the service, and a second table means for describing a reservation status relating to a use time for a service of each facility. A reservation service acquisition means for acquiring a service relating to a reservation; and equipment capable of performing the service acquired by the reservation service acquisition means with reference to the contents described in the first and second table means. Reservation screen display control means for selectively displaying the reservation status relating to the use time of the service on the display unit, reservation input means for inputting reservation information relating to the use time of the equipment to perform the service, and the reservation input means A service reservation management system comprising: a reservation updating unit that updates contents described in the second table unit based on the reservation information. 2. The service reservation management system according to claim 1, wherein the first table means further describes a relationship between each service and a device required for performing the service, and further stores a time of each device. The reservation screen display control means further refers to the contents of the first and third table means so that the equipment necessary for the service is in an empty state. For a time that is not the same, the reservation status is displayed on the display unit so as to represent the state of being already reserved, and the device obtained from the contents of the first table means based on the reservation information input by the reservation input means. A service reservation management system, comprising: a reservation device updating unit that updates contents of the third table unit. 3. The service reservation management system according to claim 1 or 2, wherein the first table means describes equipment which can be executed in correspondence with the execution stage of each service, and The acquisition unit acquires the service execution stage together with the service related to the reservation, and the reservation screen display control unit causes the display unit to display the reservation status of the facility according to the acquired service execution stage. Service reservation management system. 4. The service reservation management system according to claim 1, further comprising: a fourth table means for describing a relationship between each service and an executable period of the service; A service reservation management system, comprising: a determination unit configured to compare the reservation information with the contents of the fourth table unit to determine whether execution of the service can be reserved. 5. A first table means for describing a relationship between each service and a facility capable of performing the service when the service related to the reservation is acquired, and a reservation relating to a use time for the service of each facility. A recording medium storing a program for causing a computer to perform processing in a system for performing reservation management of the service using the second table means describing a situation, wherein the first and second table means are provided. A reservation screen display control step of selectively displaying, on the display unit, a reservation status relating to the use time of the facility that can be performed by the service acquired by the reserved service acquisition means, with reference to the contents described in A reservation input step for acquiring reservation information relating to the use time of the facility to perform the service inputted from the means; and a reservation information input in the reservation input step. A recording medium storing a program having a reservation update step of updating contents described in the second table means.